# Generated by Django 5.2.14 on 2026-06-18 09:48 import django.db.models.deletion import django.utils.timezone from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="LeaveType", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("name", models.CharField(max_length=100, unique=True)), ("paid", models.BooleanField(default=True)), ( "max_days_per_year", models.PositiveSmallIntegerField(default=0, help_text="0 = unlimited"), ), ("requires_approval", models.BooleanField(default=True)), ("carry_over", models.BooleanField(default=False)), ], options={ "ordering": ["name"], }, ), migrations.CreateModel( name="Department", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("name", models.CharField(max_length=100, unique=True)), ( "head", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="headed_departments", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["name"], }, ), migrations.CreateModel( name="StaffProfile", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("employee_id", models.CharField(blank=True, max_length=32, unique=True)), ("job_title", models.CharField(blank=True, max_length=150)), ( "employment_type", models.CharField( choices=[ ("permanent", "Permanent"), ("contract", "Contract"), ("intern", "Intern"), ("consultant", "Consultant"), ], default="permanent", max_length=16, ), ), ( "status", models.CharField( choices=[ ("active", "Active"), ("on_leave", "On leave"), ("suspended", "Suspended"), ("terminated", "Terminated"), ], default="active", max_length=16, ), ), ("date_joined", models.DateField(blank=True, null=True)), ("contract_end_date", models.DateField(blank=True, null=True)), ("phone", models.CharField(blank=True, max_length=32)), ("national_id", models.CharField(blank=True, max_length=64)), ("emergency_contact_name", models.CharField(blank=True, max_length=100)), ("emergency_contact_phone", models.CharField(blank=True, max_length=32)), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "department", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="staff", to="rims_hr.department", ), ), ( "supervisor", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="direct_reports", to=settings.AUTH_USER_MODEL, ), ), ( "user", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="staff_profile", to=settings.AUTH_USER_MODEL, ), ), ], options={ "ordering": ["user__last_name", "user__first_name"], }, ), migrations.CreateModel( name="LeaveRequest", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("start_date", models.DateField()), ("end_date", models.DateField()), ("days", models.DecimalField(decimal_places=1, max_digits=5)), ("reason", models.TextField(blank=True)), ( "status", models.CharField( choices=[ ("pending", "Pending"), ("approved", "Approved"), ("rejected", "Rejected"), ("cancelled", "Cancelled"), ], default="pending", max_length=16, ), ), ("reviewed_at", models.DateTimeField(blank=True, null=True)), ("review_note", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ( "reviewed_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="leave_reviews", to=settings.AUTH_USER_MODEL, ), ), ( "leave_type", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="requests", to="rims_hr.leavetype", ), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="leave_requests", to="rims_hr.staffprofile", ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="BackToOfficeReport", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("return_date", models.DateField()), ( "summary", models.TextField( help_text="Brief summary of activities during leave / absence." ), ), ("submitted_at", models.DateTimeField(default=django.utils.timezone.now)), ( "leave_request", models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="back_to_office_report", to="rims_hr.leaverequest", ), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="back_to_office_reports", to="rims_hr.staffprofile", ), ), ], options={ "ordering": ["-return_date"], }, ), migrations.CreateModel( name="TravelRequest", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("purpose", models.CharField(max_length=255)), ("destination", models.CharField(max_length=255)), ( "travel_type", models.CharField( choices=[ ("local", "Local"), ("regional", "Regional"), ("international", "International"), ], default="local", max_length=16, ), ), ("departure_date", models.DateField()), ("return_date", models.DateField()), ( "estimated_cost", models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True), ), ("currency", models.CharField(default="USD", max_length=3)), ("per_diem_days", models.PositiveSmallIntegerField(default=0)), ( "status", models.CharField( choices=[ ("draft", "Draft"), ("pending", "Pending approval"), ("approved", "Approved"), ("rejected", "Rejected"), ("completed", "Completed"), ("cancelled", "Cancelled"), ], default="draft", max_length=16, ), ), ("approved_at", models.DateTimeField(blank=True, null=True)), ("notes", models.TextField(blank=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ( "approved_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="travel_approvals", to=settings.AUTH_USER_MODEL, ), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="travel_requests", to="rims_hr.staffprofile", ), ), ], options={ "ordering": ["-created_at"], }, ), migrations.CreateModel( name="TravelReport", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("summary", models.TextField()), ("outcomes", models.TextField(blank=True)), ( "actual_cost", models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True), ), ("submitted_at", models.DateTimeField(default=django.utils.timezone.now)), ( "travel_request", models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name="report", to="rims_hr.travelrequest", ), ), ], options={ "ordering": ["-submitted_at"], }, ), migrations.CreateModel( name="LeaveBalance", fields=[ ( "id", models.BigAutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID" ), ), ("year", models.PositiveSmallIntegerField()), ("entitled_days", models.DecimalField(decimal_places=1, default=0, max_digits=5)), ("used_days", models.DecimalField(decimal_places=1, default=0, max_digits=5)), ("carried_over", models.DecimalField(decimal_places=1, default=0, max_digits=5)), ( "leave_type", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="balances", to="rims_hr.leavetype", ), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="leave_balances", to="rims_hr.staffprofile", ), ), ], options={ "ordering": ["-year", "leave_type__name"], "unique_together": {("staff", "leave_type", "year")}, }, ), ]