# Generated by Django 5.2.6 on 2026-06-29 10:52 import django.db.models.deletion import expense.models from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0013_user_is_new_employee'), ('base', '0002_initial'), ('budget', '0001_initial'), ('employee', '0001_initial'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='ExpenseApprovalWorkflow', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Created At')), ('is_active', models.BooleanField(default=True, verbose_name='Is Active')), ('name', models.CharField(max_length=200, unique=True, verbose_name='Workflow Name')), ('description', models.TextField(blank=True, verbose_name='Description')), ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('modified_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_modified_by', to=settings.AUTH_USER_MODEL, verbose_name='Modified By')), ], options={ 'verbose_name': 'Approval Workflow', 'verbose_name_plural': 'Approval Workflows', 'ordering': ['name'], }, ), migrations.CreateModel( name='ExpenseApprovalStage', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Created At')), ('is_active', models.BooleanField(default=True, verbose_name='Is Active')), ('name', models.CharField(max_length=200, verbose_name='Stage Name')), ('order', models.PositiveSmallIntegerField(help_text='Execution order (1 = first). Must be unique within workflow.', verbose_name='Order')), ('is_disbursement_stage', models.BooleanField(default=False, help_text='When this stage approves, the request is marked DISBURSED instead of APPROVED.', verbose_name='Is Disbursement Stage')), ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('group', models.ForeignKey(help_text='Members of this Django Group can approve at this stage.', on_delete=django.db.models.deletion.PROTECT, to='auth.group', verbose_name='Approver Group')), ('modified_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_modified_by', to=settings.AUTH_USER_MODEL, verbose_name='Modified By')), ('workflow', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='stages', to='expense.expenseapprovalworkflow', verbose_name='Workflow')), ], options={ 'verbose_name': 'Approval Stage', 'verbose_name_plural': 'Approval Stages', 'ordering': ['workflow', 'order'], 'unique_together': {('workflow', 'order')}, }, ), migrations.CreateModel( name='ExpenseRequest', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Created At')), ('is_active', models.BooleanField(default=True, verbose_name='Is Active')), ('reference_number', models.CharField(editable=False, max_length=30, unique=True, verbose_name='Reference No.')), ('title', models.CharField(max_length=300, verbose_name='Request Title')), ('amount', models.DecimalField(decimal_places=2, max_digits=15, verbose_name='Amount (₦)')), ('justification', models.TextField(verbose_name='Purpose / Justification')), ('status', models.CharField(choices=[('pending', 'Pending Approval'), ('approved', 'Approved'), ('rejected', 'Rejected'), ('kiv', 'Kept In View (KIV)'), ('resubmitted', 'Resubmitted'), ('disbursed', 'Disbursed'), ('closed', 'Closed')], default='pending', max_length=20, verbose_name='Status')), ('submitted_at', models.DateTimeField(auto_now_add=True, verbose_name='Submitted At')), ('resubmit_count', models.PositiveSmallIntegerField(default=0, verbose_name='Resubmit Count')), ('budget_item', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='expense_requests', to='budget.budgetitem', verbose_name='Budget Item')), ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('current_stage', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='pending_requests', to='expense.expenseapprovalstage', verbose_name='Current Stage')), ('department', models.ForeignKey(blank=True, help_text='Auto-filled from employee profile.', null=True, on_delete=django.db.models.deletion.SET_NULL, to='base.department', verbose_name='Department')), ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='expense_requests', to='employee.employee', verbose_name='Employee')), ('modified_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_modified_by', to=settings.AUTH_USER_MODEL, verbose_name='Modified By')), ('workflow', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='expense.expenseapprovalworkflow', verbose_name='Approval Workflow')), ], options={ 'verbose_name': 'Expense Request', 'verbose_name_plural': 'Expense Requests', 'ordering': ['-submitted_at'], }, ), migrations.CreateModel( name='ExpenseDocument', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True, null=True, verbose_name='Created At')), ('is_active', models.BooleanField(default=True, verbose_name='Is Active')), ('file', models.FileField(upload_to=expense.models._expense_doc_upload_path, validators=[expense.models._validate_document], verbose_name='File')), ('file_name', models.CharField(editable=False, max_length=255)), ('created_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('modified_by', models.ForeignKey(blank=True, editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_modified_by', to=settings.AUTH_USER_MODEL, verbose_name='Modified By')), ('uploaded_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='expense_documents_uploaded', to=settings.AUTH_USER_MODEL, verbose_name='Uploaded By')), ('expense', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='documents', to='expense.expenserequest', verbose_name='Expense Request')), ], options={ 'verbose_name': 'Expense Document', 'verbose_name_plural': 'Expense Documents', }, ), migrations.CreateModel( name='ExpenseApprovalLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('action', models.CharField(choices=[('submitted', 'Submitted'), ('approved', 'Approved'), ('rejected', 'Rejected'), ('kiv', 'Kept In View'), ('recalled', 'Recalled from KIV'), ('resubmitted', 'Resubmitted'), ('disbursed', 'Disbursed'), ('closed', 'Closed')], max_length=20, verbose_name='Action')), ('comment', models.TextField(blank=True, verbose_name='Comment / Reason')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='Timestamp')), ('actor', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, verbose_name='Actor')), ('stage', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='expense.expenseapprovalstage', verbose_name='Workflow Stage')), ('expense', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='approval_logs', to='expense.expenserequest', verbose_name='Expense Request')), ], options={ 'verbose_name': 'Approval Log Entry', 'verbose_name_plural': 'Approval Log Entries', 'ordering': ['expense', 'created_at'], }, ), migrations.CreateModel( name='KIVRecord', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('reason', models.TextField(verbose_name='KIV Reason')), ('revisit_date', models.DateField(verbose_name='Revisit Date')), ('status_before_kiv', models.CharField(choices=[('pending', 'Pending Approval'), ('approved', 'Approved'), ('rejected', 'Rejected'), ('kiv', 'Kept In View (KIV)'), ('resubmitted', 'Resubmitted'), ('disbursed', 'Disbursed'), ('closed', 'Closed')], default='pending', max_length=20, verbose_name='Status Before KIV')), ('recalled_at', models.DateTimeField(blank=True, null=True, verbose_name='Recalled At')), ('expense', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='kiv_records', to='expense.expenserequest', verbose_name='Expense Request')), ('recalled_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='kiv_recalled_by', to=settings.AUTH_USER_MODEL, verbose_name='Recalled By')), ('set_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='kiv_set_by', to=settings.AUTH_USER_MODEL, verbose_name='Set By')), ('stage', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='expense.expenseapprovalstage', verbose_name='Stage at KIV')), ], options={ 'verbose_name': 'KIV Record', 'verbose_name_plural': 'KIV Records', 'ordering': ['-revisit_date'], }, ), ]