Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 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 | 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x | import { Prop, Schema, SchemaFactory } from '@nestjs/mongoose';
import { Document, Schema as MongooseSchema } from 'mongoose';
@Schema({ timestamps: true, collection: 'analytics_reports' })
export class SavedReport extends Document {
@Prop({ type: MongooseSchema.Types.ObjectId, required: true })
tenantId: MongooseSchema.Types.ObjectId;
@Prop({ required: true })
reportName: string;
@Prop({ required: true })
moduleCode: string; // 'Sales' | 'HR' | 'Quality'
@Prop({ type: [String], default: [] })
selectedFields: string[];
@Prop({ type: String })
groupByField?: string;
@Prop({ type: String })
sortByField?: string;
}
export const SavedReportSchema = SchemaFactory.createForClass(SavedReport);
SavedReportSchema.index({ tenantId: 1, reportName: 1 }, { unique: true });
@Schema({ timestamps: true, collection: 'analytics_subscriptions' })
export class ReportSubscription extends Document {
@Prop({ type: MongooseSchema.Types.ObjectId, required: true })
tenantId: MongooseSchema.Types.ObjectId;
@Prop({ type: MongooseSchema.Types.ObjectId, ref: 'SavedReport', required: true })
reportId: MongooseSchema.Types.ObjectId;
@Prop({ required: true })
scheduleCron: string; // e.g. '0 9 * * 1'
@Prop({ type: [String], required: true })
recipientEmails: string[];
}
export const ReportSubscriptionSchema = SchemaFactory.createForClass(ReportSubscription);
ReportSubscriptionSchema.index({ tenantId: 1, reportId: 1 });
|