All files / src/domains/crm/services crm-dashboard.service.ts

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { Injectable, Logger } from '@nestjs/common';
import { InjectModel } from '@nestjs/mongoose';
import { Model, Types } from 'mongoose';
import { Lead } from '../schemas/lead.schema';
import { Opportunity } from '../schemas/opportunity.schema';
import { Quotation } from '../schemas/quotation-proposal.schema';
 
@Injectable()
export class CrmDashboardService {
  private readonly logger = new Logger(CrmDashboardService.name);
 
  constructor(
    @InjectModel(Lead.name) private readonly leadModel: Model<Lead>,
    @InjectModel(Opportunity.name)
    private readonly opportunityModel: Model<Opportunity>,
    @InjectModel(Quotation.name)
    private readonly quotationModel: Model<Quotation>,
  ) {}
 
  async getDashboardSummary(tenantId: Types.ObjectId): Promise<any> {
    const [leadCounts, oppsAgg, quotesAgg] = await Promise.all([
      this.leadModel
        .aggregate([
          { $match: { tenantId, deletedAt: null } },
          { $group: { _id: '$leadStatus', count: { $sum: 1 } } },
        ])
        .exec(),
      this.opportunityModel
        .aggregate([
          { $match: { tenantId, deletedAt: null } },
          {
            $group: {
              _id: '$status',
              totalAmountMinor: { $sum: '$amountMinor' },
              weightedAmountMinor: { $sum: '$weightedAmountMinor' },
              count: { $sum: 1 },
            },
          },
        ])
        .exec(),
      this.quotationModel
        .aggregate([
          { $match: { tenantId, deletedAt: null } },
          { $group: { _id: '$status', count: { $sum: 1 } } },
        ])
        .exec(),
    ]);
 
    return {
      leads: leadCounts,
      opportunities: oppsAgg,
      quotations: quotesAgg,
    };
  }
}