All files / src/platform/calendar/schemas holiday-calendar.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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
import { Prop, Schema, SchemaFactory } from '@nestjs/mongoose';
import { Document, Schema as MongooseSchema } from 'mongoose';
 
@Schema({ timestamps: true, collection: 'calendar_holiday_calendars' })
export class SharedHolidayCalendar extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true })
  calendarCode: string;
 
  @Prop({ required: true })
  calendarName: string;
 
  @Prop({ required: true })
  year: number;
 
  @Prop()
  description?: string;
 
  @Prop({ default: 'active' })
  status: string;
 
  @Prop({ default: null })
  effectiveFrom: Date;
 
  @Prop({ default: null })
  effectiveTo: Date;
}
 
export const SharedHolidayCalendarSchema = SchemaFactory.createForClass(SharedHolidayCalendar);
SharedHolidayCalendarSchema.index({ tenantId: 1, calendarCode: 1, year: 1 }, { unique: true });
 
@Schema({ timestamps: true, collection: 'calendar_holidays' })
export class SharedHoliday extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'SharedHolidayCalendar' })
  holidayCalendarId: string;
 
  @Prop({ required: true })
  holidayCode: string;
 
  @Prop({ required: true })
  holidayName: string;
 
  @Prop({ required: true })
  date: Date; // Specific occurrence date
 
  @Prop({ default: 'Public', enum: ['Public', 'Company', 'Regional', 'Optional', 'Restricted', 'Bank', 'Local', 'Emergency'] })
  type: string;
 
  @Prop()
  description?: string;
 
  @Prop({ default: false })
  recurring: boolean;
 
  @Prop({ default: false })
  optional: boolean;
 
  @Prop({ default: false })
  halfDay: boolean;
 
  @Prop({ default: true })
  paid: boolean;
 
  @Prop({ type: [String], default: [] })
  branchIds: string[];
 
  @Prop({ type: [String], default: [] })
  locationIds: string[];
 
  @Prop()
  religionOrRegionReference?: string;
}
 
export const SharedHolidaySchema = SchemaFactory.createForClass(SharedHoliday);
SharedHolidaySchema.index({ tenantId: 1, holidayCalendarId: 1, date: 1 });
 
@Schema({ timestamps: true, collection: 'calendar_holiday_assignments' })
export class HolidayAssignment extends Document {
  @Prop({ required: true, index: true })
  tenantId: string;
 
  @Prop({ required: true })
  assignmentType: string; // 'Employee' | 'Branch' | 'Factory' | 'SupportTeam' | 'Region' | 'FinanceDept'
 
  @Prop({ required: true, index: true })
  assignmentTargetId: string; // employeeId, branchId, teamId, etc.
 
  @Prop({ required: true, type: MongooseSchema.Types.ObjectId, ref: 'SharedHolidayCalendar' })
  holidayCalendarId: string;
 
  @Prop({ required: true })
  year: number;
}
 
export const HolidayAssignmentSchema = SchemaFactory.createForClass(HolidayAssignment);
HolidayAssignmentSchema.index({ tenantId: 1, assignmentType: 1, assignmentTargetId: 1, year: 1 }, { unique: true });