# Generated by Django 5.0.6 on 2026-11-02 07:03

import django.db.models.deletion
from decimal import Decimal
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('Company', '0001_initial'),
        ('Employee', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Loan',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('loan_no', models.CharField(max_length=30)),
                ('loan_type', models.CharField(choices=[('LOAN', 'Employee Loan'), ('SALARY_ADVANCE', 'Salary Advance')], default='LOAN', max_length=14)),
                ('principal', models.DecimalField(decimal_places=2, max_digits=12)),
                ('interest_rate', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=5)),
                ('tenure_months', models.PositiveSmallIntegerField()),
                ('emi_amount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('start_month', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('start_year', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('purpose', models.CharField(blank=True, max_length=300, null=True)),
                ('status', models.CharField(choices=[('PENDING', 'Pending Approval'), ('ACTIVE', 'Active'), ('CLOSED', 'Closed'), ('FORECLOSED', 'Foreclosed'), ('REJECTED', 'Rejected'), ('CANCELLED', 'Cancelled')], db_index=True, default='PENDING', max_length=10)),
                ('sanctioned_on', models.DateField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decision_remarks', models.CharField(blank=True, max_length=300, null=True)),
                ('requested_by_employee', models.BooleanField(default=False)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_loans', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_loans', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
                'unique_together': {('company', 'loan_no')},
            },
        ),
        migrations.CreateModel(
            name='PayrollCycle',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('month', models.PositiveSmallIntegerField()),
                ('year', models.PositiveSmallIntegerField()),
                ('status', models.CharField(choices=[('OPEN', 'Open'), ('INPUTS_FROZEN', 'Inputs Frozen'), ('VERIFIED', 'Verified'), ('BANK_FILE_READY', 'Bank File Ready'), ('RELEASED', 'Payslips Released')], db_index=True, default='OPEN', max_length=16)),
                ('inputs_frozen_at', models.DateTimeField(blank=True, null=True)),
                ('inputs_frozen_by', models.CharField(blank=True, max_length=150, null=True)),
                ('verified_at', models.DateTimeField(blank=True, null=True)),
                ('verified_by', models.CharField(blank=True, max_length=150, null=True)),
                ('verification_result', models.JSONField(blank=True, default=dict)),
                ('bank_file_at', models.DateTimeField(blank=True, null=True)),
                ('bank_file_by', models.CharField(blank=True, max_length=150, null=True)),
                ('bank_file', models.FileField(blank=True, null=True, upload_to='payroll_hub/bank_files/')),
                ('bank_file_total', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=14)),
                ('bank_file_count', models.PositiveIntegerField(default=0)),
                ('release_on', models.DateField(blank=True, null=True)),
                ('released_at', models.DateTimeField(blank=True, null=True)),
                ('released_by', models.CharField(blank=True, max_length=150, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_cycles', to='Company.company_details')),
            ],
            options={
                'ordering': ['-year', '-month'],
                'unique_together': {('company', 'month', 'year')},
            },
        ),
        migrations.CreateModel(
            name='PayrollDeduction',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('head', models.CharField(max_length=100)),
                ('amount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('reason', models.CharField(blank=True, max_length=300, null=True)),
                ('month', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('year', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('status', models.CharField(choices=[('PENDING_APPROVAL', 'Pending Approval'), ('APPROVED', 'Approved'), ('PENDING_FNF', 'Pending F&F'), ('RECOVERED', 'Recovered'), ('WAIVED', 'Waived')], db_index=True, default='PENDING_APPROVAL', max_length=16)),
                ('exit_fnf_id', models.PositiveIntegerField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_deductions', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_deductions', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='PayrollSetting',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('include_timesheet_overtime', models.BooleanField(default=True)),
                ('allow_employee_claims', models.BooleanField(default=True)),
                ('allow_employee_loan_requests', models.BooleanField(default=True)),
                ('loan_max_emi_percent', models.PositiveSmallIntegerField(default=50)),
                ('loan_max_tenure_months', models.PositiveSmallIntegerField(default=60)),
                ('loan_max_principal', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=12)),
                ('payslip_release_day', models.PositiveSmallIntegerField(default=0)),
                ('bank_portal_name', models.CharField(blank=True, max_length=60, null=True)),
                ('require_verification_before_bank_file', models.BooleanField(default=True)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_hub_setting', to='Company.company_details')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='LoanRepayment',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('installment_no', models.PositiveSmallIntegerField()),
                ('month', models.PositiveSmallIntegerField()),
                ('year', models.PositiveSmallIntegerField()),
                ('amount', models.DecimalField(decimal_places=2, max_digits=12)),
                ('principal_part', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('interest_part', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('status', models.CharField(choices=[('SCHEDULED', 'Scheduled'), ('DEDUCTED', 'Deducted'), ('SKIPPED', 'Skipped'), ('WAIVED', 'Waived')], db_index=True, default='SCHEDULED', max_length=10)),
                ('deducted_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_loan_repayments', to='Company.company_details')),
                ('loan', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='repayments', to='PayrollHub.loan')),
            ],
            options={
                'ordering': ['loan_id', 'installment_no'],
                'unique_together': {('loan', 'installment_no')},
            },
        ),
        migrations.CreateModel(
            name='PayrollInput',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('month', models.PositiveSmallIntegerField()),
                ('year', models.PositiveSmallIntegerField()),
                ('input_type', models.CharField(choices=[('BONUS', 'Bonus'), ('INCENTIVE', 'Incentive'), ('REIMBURSEMENT', 'Reimbursement'), ('ARREAR', 'Arrears'), ('OTHER_EARNING', 'Other earning'), ('OTHER_DEDUCTION', 'Other deduction'), ('LOP', 'Loss of Pay (LOP) verification')], db_index=True, max_length=16)),
                ('label', models.CharField(blank=True, max_length=100, null=True)),
                ('amount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('days', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=5)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('status', models.CharField(choices=[('PENDING_REVIEW', 'Pending Review'), ('APPROVED', 'Approved'), ('VERIFIED', 'Verified'), ('REJECTED', 'Rejected'), ('PROCESSED', 'Processed')], db_index=True, default='PENDING_REVIEW', max_length=14)),
                ('source', models.CharField(choices=[('MANUAL', 'Entered by HR'), ('EMPLOYEE', 'Claimed by employee')], default='MANUAL', max_length=8)),
                ('attachment', models.FileField(blank=True, null=True, upload_to='payroll_hub/inputs/')),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('decision_remarks', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_inputs', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payroll_inputs', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-year', '-month', '-id'],
                'indexes': [models.Index(fields=['company', 'year', 'month'], name='PayrollHub__company_c6d031_idx')],
            },
        ),
        migrations.CreateModel(
            name='Payslip',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('payslip_no', models.CharField(max_length=40)),
                ('month', models.PositiveSmallIntegerField()),
                ('year', models.PositiveSmallIntegerField()),
                ('gross_salary', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=14)),
                ('total_deductions', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=14)),
                ('net_payable', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=14)),
                ('breakup', models.JSONField(blank=True, default=dict)),
                ('status', models.CharField(choices=[('RELEASED', 'Released'), ('REVOKED', 'Revoked')], db_index=True, default='RELEASED', max_length=9)),
                ('released_at', models.DateTimeField(blank=True, null=True)),
                ('released_by', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hub_payslips', to='Company.company_details')),
                ('cycle', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='payslips', to='PayrollHub.payrollcycle')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hub_payslips', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-year', '-month', 'employee_id'],
                'unique_together': {('company', 'employee', 'month', 'year'), ('company', 'payslip_no')},
            },
        ),
        migrations.CreateModel(
            name='SalaryComponent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('code', models.CharField(max_length=20)),
                ('name', models.CharField(max_length=100)),
                ('component_type', models.CharField(choices=[('EARNING', 'Earning'), ('DEDUCTION', 'Deduction')], db_index=True, default='EARNING', max_length=9)),
                ('calc_method', models.CharField(choices=[('PERCENT_OF_GROSS', '% of monthly gross'), ('PERCENT_OF_BASIC', '% of basic'), ('PERCENT_OF_COMPONENT', '% of another component'), ('FIXED_AMOUNT', 'Fixed amount per month'), ('BALANCING', 'Balancing figure (gross minus other earnings)')], default='FIXED_AMOUNT', max_length=20)),
                ('calc_value', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('cap_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=12, null=True)),
                ('is_taxable', models.BooleanField(default=True)),
                ('tax_treatment', models.CharField(blank=True, max_length=200, null=True)),
                ('description', models.CharField(blank=True, max_length=250, null=True)),
                ('sort_order', models.PositiveIntegerField(default=1)),
                ('base_component', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='dependents', to='PayrollHub.salarycomponent')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='salary_components', to='Company.company_details')),
            ],
            options={
                'ordering': ['sort_order', 'id'],
                'unique_together': {('company', 'code')},
            },
        ),
        migrations.CreateModel(
            name='VariablePay',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1)),
                ('is_active', models.BooleanField(default=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('period_type', models.CharField(choices=[('MONTHLY', 'Monthly'), ('QUARTERLY', 'Quarterly'), ('HALF_YEARLY', 'Half-yearly'), ('ANNUAL', 'Annual')], default='QUARTERLY', max_length=12)),
                ('period_label', models.CharField(max_length=40)),
                ('target_amount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('achievement_percent', models.DecimalField(decimal_places=2, default=Decimal('100.00'), max_digits=6)),
                ('payable_amount', models.DecimalField(decimal_places=2, default=Decimal('0.00'), max_digits=12)),
                ('status', models.CharField(choices=[('DRAFT', 'Draft'), ('PENDING_APPROVAL', 'Pending Approval'), ('APPROVED', 'Approved'), ('PAID', 'Paid'), ('REJECTED', 'Rejected')], db_index=True, default='DRAFT', max_length=16)),
                ('payout_month', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('payout_year', models.PositiveSmallIntegerField(blank=True, null=True)),
                ('appraisal_id', models.PositiveIntegerField(blank=True, null=True)),
                ('remarks', models.TextField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('decided_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='variable_pay', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='variable_pay', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
                'unique_together': {('company', 'employee', 'period_label')},
            },
        ),
    ]
