All files / src/domains/hr/payroll/runs/schemas payroll-calculation-result.schema.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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { Prop, Schema, SchemaFactory } from '@nestjs/mongoose';
import { Document, Schema as MongooseSchema } from 'mongoose';
 
@Schema({ collection: 'payroll_calculation_results', timestamps: true })
export class PayrollCalculationResult extends Document {
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true, index: true })
  tenantId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  runId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  employeeId!: MongooseSchema.Types.ObjectId;
  @Prop({ default: 0 }) grossEarnings!: number;
  @Prop({ default: 0 }) totalDeductions!: number;
  @Prop({ default: 0 }) employerContributions!: number;
  @Prop({ default: 0 }) netPay!: number;
  @Prop({ default: 0 }) totalCostToCompany!: number;
  @Prop({ default: 0 }) workingDays!: number;
  @Prop({ default: 0 }) paidDays!: number;
  @Prop({ default: 0 }) lopDays!: number;
  @Prop({ default: 0 }) overtimeHours!: number;
  @Prop({ default: 1 }) version!: number;
  @Prop({ default: false }) isLocked!: boolean;
}
export const PayrollCalculationResultSchema = SchemaFactory.createForClass(
  PayrollCalculationResult,
);
PayrollCalculationResultSchema.index(
  { tenantId: 1, runId: 1, employeeId: 1 },
  { unique: true },
);