import django.db.models.deletion
from django.conf import settings
from django.db import migrations, models


class Migration(migrations.Migration):
    dependencies = [
        ("finance", "0030_alter_payroll_component_kind_labels"),
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name="PayrollTableReviewMark",
            fields=[
                (
                    "id",
                    models.BigAutoField(
                        auto_created=True,
                        primary_key=True,
                        serialize=False,
                        verbose_name="ID",
                    ),
                ),
                (
                    "created_at",
                    models.DateTimeField(auto_now_add=True, verbose_name="Отмечено"),
                ),
                (
                    "employee",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="payroll_table_row_review_marks",
                        to=settings.AUTH_USER_MODEL,
                        verbose_name="Сотрудник",
                    ),
                ),
                (
                    "period",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="table_review_marks",
                        to="finance.payrollperiod",
                        verbose_name="Расчётный период",
                    ),
                ),
                (
                    "reviewer",
                    models.ForeignKey(
                        on_delete=django.db.models.deletion.CASCADE,
                        related_name="payroll_table_review_marks",
                        to=settings.AUTH_USER_MODEL,
                        verbose_name="Проверяющий",
                    ),
                ),
            ],
            options={
                "verbose_name": "Контрольная отметка расчётной таблицы",
                "verbose_name_plural": "Контрольные отметки расчётной таблицы",
                "ordering": ["employee_id"],
            },
        ),
        migrations.AddConstraint(
            model_name="payrolltablereviewmark",
            constraint=models.UniqueConstraint(
                fields=("period", "reviewer", "employee"),
                name="pay_table_review_mark_unique",
            ),
        ),
        migrations.AddIndex(
            model_name="payrolltablereviewmark",
            index=models.Index(
                fields=["reviewer", "period"],
                name="pay_review_user_period_idx",
            ),
        ),
    ]