78 lines
2.8 KiB
Python
78 lines
2.8 KiB
Python
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",
|
|
),
|
|
),
|
|
]
|