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

import EmployeeRelations.models
import django.core.files.storage
import django.db.models.deletion
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

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

    operations = [
        migrations.CreateModel(
            name='DisciplinaryAction',
            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)),
                ('action_type', models.CharField(max_length=20)),
                ('charge', models.TextField()),
                ('status', models.CharField(db_index=True, default='Notice Issued', max_length=20)),
                ('notice_served_on', models.DateField(blank=True, null=True)),
                ('hearing_date', models.DateField(blank=True, null=True)),
                ('hearing_time', models.TimeField(blank=True, null=True)),
                ('hearing_location', models.CharField(blank=True, max_length=200, null=True)),
                ('employee_response', models.TextField(blank=True, null=True)),
                ('response_at', models.DateTimeField(blank=True, null=True)),
                ('minutes', models.TextField(blank=True, null=True)),
                ('outcome', models.CharField(default='Pending', max_length=20)),
                ('penalty', models.CharField(blank=True, max_length=300, null=True)),
                ('decision_date', models.DateField(blank=True, null=True)),
                ('decided_by', models.CharField(blank=True, max_length=150, null=True)),
                ('committee', models.ManyToManyField(blank=True, related_name='+', to='Employee.employeedt')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_disciplinary', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='er_disciplinary', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='CaseDocument',
            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)),
                ('title', models.CharField(max_length=250)),
                ('doc_type', models.CharField(default='Evidence', max_length=15)),
                ('description', models.TextField(blank=True, null=True)),
                ('confidentiality', models.CharField(default='Confidential', max_length=14)),
                ('file', models.FileField(max_length=300, storage=django.core.files.storage.FileSystemStorage(location='/home/ib48ogp0dgnx/public_html/hrms.edunexusone.com/private_media'), upload_to=EmployeeRelations.models.vault_path)),
                ('file_name', models.CharField(max_length=255)),
                ('file_size', models.PositiveIntegerField(default=0)),
                ('content_type', models.CharField(blank=True, max_length=100, null=True)),
                ('sha256', models.CharField(db_index=True, max_length=64)),
                ('uploaded_by', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_documents', to='Company.company_details')),
                ('disciplinary', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='documents', to='EmployeeRelations.disciplinaryaction')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='DocumentAccessLog',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('created_by', models.CharField(blank=True, help_text='Who created this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('updated_by', models.CharField(blank=True, help_text='Who last updated this record (e.g. admin:<id> / employee:<id>)', max_length=150, null=True)),
                ('id_version', models.PositiveIntegerField(default=1, help_text='Record version counter')),
                ('is_active', models.BooleanField(default=True)),
                ('action', models.CharField(max_length=12)),
                ('actor', models.CharField(blank=True, max_length=150, null=True)),
                ('actor_name', models.CharField(blank=True, max_length=150, null=True)),
                ('ip_address', models.GenericIPAddressField(blank=True, null=True)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_document_logs', to='Company.company_details')),
                ('document', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='access_logs', to='EmployeeRelations.casedocument')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='ERCase',
            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)),
                ('case_no', models.CharField(max_length=30)),
                ('category', models.CharField(db_index=True, max_length=20)),
                ('sub_category', models.CharField(blank=True, max_length=80, null=True)),
                ('subject', models.CharField(max_length=300)),
                ('description', models.TextField(blank=True, null=True)),
                ('severity', models.CharField(db_index=True, default='Medium', max_length=10)),
                ('status', models.CharField(db_index=True, default='Open', max_length=20)),
                ('source', models.CharField(choices=[('HR', 'HR'), ('Employee', 'Employee'), ('Manager', 'Manager'), ('Anonymous', 'Anonymous')], default='HR', max_length=10)),
                ('is_confidential', models.BooleanField(default=True)),
                ('tracking_hash', models.CharField(blank=True, db_index=True, max_length=64, null=True)),
                ('incident_date', models.DateField(blank=True, null=True)),
                ('target_date', models.DateField(blank=True, null=True)),
                ('opened_at', models.DateTimeField(auto_now_add=True)),
                ('resolved_at', models.DateTimeField(blank=True, null=True)),
                ('resolution_type', models.CharField(blank=True, max_length=40, null=True)),
                ('resolution_summary', models.TextField(blank=True, null=True)),
                ('resolved_by', models.CharField(blank=True, max_length=150, null=True)),
                ('closed_at', models.DateTimeField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_cases', to='Company.company_details')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='er_cases', to='Employee.employeedt')),
                ('investigator', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='er_cases_assigned', to='Employee.employeedt')),
                ('raised_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='er_cases_raised', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.AddField(
            model_name='disciplinaryaction',
            name='case',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='disciplinary_actions', to='EmployeeRelations.ercase'),
        ),
        migrations.CreateModel(
            name='CaseNote',
            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)),
                ('note_type', models.CharField(default='Note', max_length=10)),
                ('text', models.TextField()),
                ('is_internal', models.BooleanField(default=True)),
                ('author', models.CharField(blank=True, max_length=150, null=True)),
                ('author_name', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_case_notes', to='Company.company_details')),
                ('case', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='notes', to='EmployeeRelations.ercase')),
            ],
            options={
                'ordering': ['id'],
            },
        ),
        migrations.AddField(
            model_name='casedocument',
            name='case',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='documents', to='EmployeeRelations.ercase'),
        ),
        migrations.CreateModel(
            name='LegalCase',
            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)),
                ('legal_no', models.CharField(max_length=30)),
                ('case_type', models.CharField(max_length=20)),
                ('title', models.CharField(max_length=300)),
                ('claimant', models.CharField(blank=True, max_length=200, null=True)),
                ('forum', models.CharField(blank=True, max_length=200, null=True)),
                ('court_case_number', models.CharField(blank=True, max_length=80, null=True)),
                ('filed_on', models.DateField(blank=True, null=True)),
                ('next_hearing_date', models.DateField(blank=True, null=True)),
                ('counsel_name', models.CharField(blank=True, max_length=150, null=True)),
                ('claim_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=14, null=True)),
                ('status', models.CharField(db_index=True, default='Open', max_length=20)),
                ('outcome', models.TextField(blank=True, null=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('closed_on', models.DateField(blank=True, null=True)),
                ('case', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='legal_cases', to='EmployeeRelations.ercase')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_legal_cases', to='Company.company_details')),
                ('employee', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='er_legal_cases', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.AddField(
            model_name='casedocument',
            name='legal_case',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='documents', to='EmployeeRelations.legalcase'),
        ),
        migrations.CreateModel(
            name='RelationsSetting',
            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)),
                ('icc_meeting_frequency', models.CharField(choices=[('Monthly', 'Monthly'), ('Quarterly', 'Quarterly'), ('Half-Yearly', 'Half-Yearly'), ('Yearly', 'Yearly')], default='Quarterly', max_length=12)),
                ('hearing_notice_days', models.PositiveSmallIntegerField(default=2)),
                ('warning_valid_months', models.PositiveSmallIntegerField(default=12)),
                ('company', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='relations_setting', to='Company.company_details')),
                ('hr_head', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('icc_presiding_officer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('legal_counsel', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.employeedt')),
                ('vault_members', models.ManyToManyField(blank=True, related_name='+', to='Employee.employeedt')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='WarningLetter',
            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)),
                ('warning_no', models.CharField(max_length=30)),
                ('level', models.CharField(max_length=25)),
                ('reason', models.TextField()),
                ('incident_date', models.DateField(blank=True, null=True)),
                ('issued_on', models.DateField(blank=True, null=True)),
                ('valid_until', models.DateField(blank=True, null=True)),
                ('status', models.CharField(db_index=True, default='Draft', max_length=14)),
                ('issued_by', models.CharField(blank=True, max_length=150, null=True)),
                ('acknowledged_at', models.DateTimeField(blank=True, null=True)),
                ('acknowledgement_remarks', models.TextField(blank=True, null=True)),
                ('withdrawn_reason', models.TextField(blank=True, null=True)),
                ('case', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='warnings', to='EmployeeRelations.ercase')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='er_warnings', to='Company.company_details')),
                ('disciplinary', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='warnings', to='EmployeeRelations.disciplinaryaction')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='er_warnings', to='Employee.employeedt')),
                ('letter', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='People.employeeletter')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.AddIndex(
            model_name='ercase',
            index=models.Index(fields=['company', 'status'], name='EmployeeRel_company_9dbc2c_idx'),
        ),
        migrations.AddIndex(
            model_name='ercase',
            index=models.Index(fields=['company', 'category'], name='EmployeeRel_company_543a88_idx'),
        ),
        migrations.AddIndex(
            model_name='ercase',
            index=models.Index(fields=['company', 'employee'], name='EmployeeRel_company_466bcf_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='ercase',
            unique_together={('company', 'case_no')},
        ),
        migrations.AddIndex(
            model_name='disciplinaryaction',
            index=models.Index(fields=['company', 'status'], name='EmployeeRel_company_a2d64f_idx'),
        ),
        migrations.AddIndex(
            model_name='disciplinaryaction',
            index=models.Index(fields=['company', 'employee'], name='EmployeeRel_company_9846f7_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='legalcase',
            unique_together={('company', 'legal_no')},
        ),
        migrations.AddIndex(
            model_name='warningletter',
            index=models.Index(fields=['company', 'employee'], name='EmployeeRel_company_132a51_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='warningletter',
            unique_together={('company', 'warning_no')},
        ),
    ]
