All files / src/domains/hr/payroll/advances/schemas salary-advance.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
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
57
58
59
60
61
62
63
64
65
66
67
68
69
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { Prop, Schema, SchemaFactory } from '@nestjs/mongoose';
import { Document, Schema as MongooseSchema } from 'mongoose';
 
@Schema({ collection: 'salary_advance_policies', timestamps: true })
export class SalaryAdvancePolicy extends Document {
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true, index: true })
  tenantId!: MongooseSchema.Types.ObjectId;
  @Prop({ required: true }) policyName!: string;
  @Prop({ default: 0 }) maxAdvancePercentage!: number;
  @Prop({ default: 0 }) maxAdvanceAmount!: number;
  @Prop({ default: 6 }) minServiceMonths!: number;
  @Prop({ default: 1 }) maxRecoveryMonths!: number;
  @Prop({ default: true }) requiresApproval!: boolean;
  @Prop({ default: true }) isActive!: boolean;
}
export const SalaryAdvancePolicySchema =
  SchemaFactory.createForClass(SalaryAdvancePolicy);
 
@Schema({ collection: 'salary_advance_requests', timestamps: true })
export class SalaryAdvanceRequest extends Document {
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true, index: true })
  tenantId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  employeeId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId })
  policyId?: MongooseSchema.Types.ObjectId;
  @Prop({ required: true }) requestedAmount!: number;
  @Prop({ default: 0 }) approvedAmount!: number;
  @Prop({ default: 0 }) recoveredAmount!: number;
  @Prop({ default: 0 }) outstandingAmount!: number;
  @Prop({ default: 1 }) recoveryMonths!: number;
  @Prop() reason?: string;
  @Prop({
    default: 'pending',
    enum: [
      'pending',
      'approved',
      'rejected',
      'active',
      'recovered',
      'cancelled',
    ],
  })
  status!: string;
  @Prop({ type: MongooseSchema.Types.ObjectId })
  approvedBy?: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId })
  createdBy?: MongooseSchema.Types.ObjectId;
}
export const SalaryAdvanceRequestSchema =
  SchemaFactory.createForClass(SalaryAdvanceRequest);
SalaryAdvanceRequestSchema.index({ tenantId: 1, employeeId: 1, status: 1 });
 
@Schema({ collection: 'salary_advance_approvals', timestamps: true })
export class SalaryAdvanceApproval extends Document {
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  tenantId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  advanceId!: MongooseSchema.Types.ObjectId;
  @Prop({ type: MongooseSchema.Types.ObjectId, required: true })
  approverId!: MongooseSchema.Types.ObjectId;
  @Prop({ required: true, enum: ['pending', 'approved', 'rejected'] })
  status!: string;
  @Prop() comments?: string;
}
export const SalaryAdvanceApprovalSchema = SchemaFactory.createForClass(
  SalaryAdvanceApproval,
);