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

import django.db.models.deletion
import django.utils.timezone
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='TrainingProgram',
            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)),
                ('title', models.CharField(max_length=250)),
                ('description', models.TextField(blank=True, null=True)),
                ('category', models.CharField(blank=True, max_length=80, null=True)),
                ('trainer_name', models.CharField(blank=True, max_length=150, null=True)),
                ('mode', models.CharField(choices=[('Classroom', 'Classroom'), ('Online', 'Online'), ('Hybrid', 'Hybrid'), ('Self-paced', 'Self-paced')], default='Classroom', max_length=12)),
                ('duration_hours', models.DecimalField(decimal_places=1, default=Decimal('0'), max_digits=6)),
                ('capacity', models.PositiveIntegerField(blank=True, null=True)),
                ('audience_label', models.CharField(default='Employees', max_length=40)),
                ('start_date', models.DateField(blank=True, null=True)),
                ('end_date', models.DateField(blank=True, null=True)),
                ('status', models.CharField(choices=[('Draft', 'Draft'), ('Upcoming', 'Upcoming'), ('Ongoing', 'Ongoing'), ('Completed', 'Completed'), ('Cancelled', 'Cancelled')], db_index=True, default='Upcoming', max_length=10)),
                ('is_mandatory', models.BooleanField(default=False)),
                ('awards_certificate', models.BooleanField(default=True)),
                ('certificate_title', models.CharField(blank=True, max_length=250, null=True)),
                ('certificate_validity_months', models.PositiveIntegerField(blank=True, null=True)),
                ('pass_attendance_percent', models.PositiveSmallIntegerField(default=75)),
                ('skill_level_awarded', models.PositiveSmallIntegerField(default=0)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_programs', to='Company.company_details')),
                ('trainer', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='trainings_conducted', to='Employee.employeedt')),
            ],
            options={
                'ordering': ['code'],
            },
        ),
        migrations.CreateModel(
            name='TrainingEnrollment',
            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)),
                ('status', models.CharField(choices=[('Pending', 'Pending Approval'), ('Enrolled', 'Enrolled'), ('Completed', 'Completed'), ('Rejected', 'Rejected'), ('Dropped', 'Dropped'), ('Cancelled', 'Cancelled')], db_index=True, default='Pending', max_length=10)),
                ('source', models.CharField(choices=[('Self', 'Self nomination'), ('Manager', 'Manager nomination'), ('HR', 'HR enrolment')], default='HR', max_length=8)),
                ('nominated_by', models.CharField(blank=True, max_length=150, null=True)),
                ('reason', models.TextField(blank=True, null=True)),
                ('approver_code', models.CharField(blank=True, db_index=True, max_length=100, null=True)),
                ('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)),
                ('completed_on', models.DateField(blank=True, null=True)),
                ('score', models.DecimalField(blank=True, decimal_places=2, max_digits=5, null=True)),
                ('feedback_rating', models.DecimalField(blank=True, decimal_places=1, max_digits=2, null=True)),
                ('feedback_comment', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_enrollments', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_enrollments', to='Employee.employeedt')),
                ('program', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='enrollments', to='Training.trainingprogram')),
            ],
            options={
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='TrainingCertificate',
            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)),
                ('certificate_no', models.CharField(max_length=40)),
                ('verification_code', models.CharField(db_index=True, max_length=24)),
                ('title', models.CharField(max_length=250)),
                ('issued_on', models.DateField(default=django.utils.timezone.localdate)),
                ('expiry_date', models.DateField(blank=True, null=True)),
                ('issued_by', models.CharField(blank=True, max_length=150, null=True)),
                ('status', models.CharField(choices=[('Issued', 'Issued'), ('Revoked', 'Revoked')], db_index=True, default='Issued', max_length=8)),
                ('is_external', models.BooleanField(default=False)),
                ('issuer_name', models.CharField(blank=True, max_length=200, null=True)),
                ('file', models.FileField(blank=True, null=True, upload_to='training_certificates/')),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_certificates', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_certificates', to='Employee.employeedt')),
                ('enrollment', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='certificates', to='Training.trainingenrollment')),
                ('program', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='certificates', to='Training.trainingprogram')),
            ],
            options={
                'ordering': ['-issued_on', '-id'],
            },
        ),
        migrations.CreateModel(
            name='TrainingSession',
            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)),
                ('session_date', models.DateField(db_index=True)),
                ('start_time', models.TimeField(blank=True, null=True)),
                ('end_time', models.TimeField(blank=True, null=True)),
                ('location', models.CharField(blank=True, max_length=200, null=True)),
                ('meeting_link', models.URLField(blank=True, null=True)),
                ('trainer_name', models.CharField(blank=True, max_length=150, null=True)),
                ('status', models.CharField(choices=[('Scheduled', 'Scheduled'), ('Completed', 'Completed'), ('Cancelled', 'Cancelled')], db_index=True, default='Scheduled', max_length=10)),
                ('notes', models.TextField(blank=True, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_sessions', to='Company.company_details')),
                ('program', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sessions', to='Training.trainingprogram')),
            ],
            options={
                'ordering': ['session_date', 'start_time', 'id'],
            },
        ),
        migrations.CreateModel(
            name='TrainingAttendance',
            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)),
                ('status', models.CharField(choices=[('Present', 'Present'), ('Late', 'Late'), ('Absent', 'Absent'), ('Excused', 'Excused')], db_index=True, default='Present', max_length=8)),
                ('hours_attended', models.DecimalField(decimal_places=2, default=Decimal('0'), max_digits=5)),
                ('remarks', models.CharField(blank=True, max_length=250, null=True)),
                ('marked_by', models.CharField(blank=True, max_length=150, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_attendance', to='Company.company_details')),
                ('enrollment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='attendance', to='Training.trainingenrollment')),
                ('session', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='attendance', to='Training.trainingsession')),
            ],
            options={
                'ordering': ['session__session_date', 'id'],
            },
        ),
        migrations.CreateModel(
            name='TrainingSkill',
            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)),
                ('domain', models.CharField(max_length=200)),
                ('category', models.CharField(blank=True, max_length=80, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('target_level', models.PositiveSmallIntegerField(default=3)),
                ('gap_level_override', models.CharField(blank=True, choices=[('Optimal', 'Optimal'), ('Active Track', 'Active Track'), ('Upskilling', 'Upskilling'), ('Critical', 'Critical')], max_length=14, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='training_skills', to='Company.company_details')),
                ('department', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='Employee.department')),
            ],
            options={
                'ordering': ['domain'],
            },
        ),
        migrations.AddField(
            model_name='trainingprogram',
            name='skills',
            field=models.ManyToManyField(blank=True, related_name='programs', to='Training.trainingskill'),
        ),
        migrations.CreateModel(
            name='EmployeeSkill',
            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)),
                ('current_level', models.PositiveSmallIntegerField(default=0)),
                ('assessed_on', models.DateField(default=django.utils.timezone.localdate)),
                ('assessed_by', models.CharField(blank=True, max_length=150, null=True)),
                ('source', models.CharField(choices=[('Manual', 'HR / Manager assessment'), ('Self', 'Self assessment'), ('Training', 'Training completion')], default='Manual', max_length=8)),
                ('remarks', models.CharField(blank=True, max_length=250, null=True)),
                ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='employee_skills', to='Company.company_details')),
                ('employee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='skill_levels', to='Employee.employeedt')),
                ('skill', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ratings', to='Training.trainingskill')),
            ],
            options={
                'ordering': ['skill__domain', 'employee__name'],
            },
        ),
        migrations.AddIndex(
            model_name='trainingenrollment',
            index=models.Index(fields=['company', 'status'], name='Training_tr_company_94e871_idx'),
        ),
        migrations.AddIndex(
            model_name='trainingenrollment',
            index=models.Index(fields=['company', 'approver_code', 'status'], name='Training_tr_company_d9aace_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='trainingcertificate',
            unique_together={('company', 'certificate_no')},
        ),
        migrations.AlterUniqueTogether(
            name='trainingattendance',
            unique_together={('session', 'enrollment')},
        ),
        migrations.AlterUniqueTogether(
            name='trainingskill',
            unique_together={('company', 'domain')},
        ),
        migrations.AlterUniqueTogether(
            name='trainingprogram',
            unique_together={('company', 'code')},
        ),
        migrations.AlterUniqueTogether(
            name='employeeskill',
            unique_together={('employee', 'skill')},
        ),
    ]
