Corp/backend/finance/migrations/0017_payrollcarryover.py
2026-09-07 19:43:48 +03:00

168 lines
6.3 KiB
Python

# Generated by Django 5.2.4 on 2026-08-04 11:09
from decimal import Decimal
import django.core.validators
import django.db.models.deletion
from django.conf import settings
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
("finance", "0016_payrollcellcommentthread"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name="PayrollCarryover",
fields=[
(
"id",
models.BigAutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
(
"direction",
models.CharField(
choices=[
("company_owes", "Доплата сотруднику"),
("employee_owes", "Долг сотрудника"),
],
max_length=20,
verbose_name="Вид остатка",
),
),
(
"amount",
models.DecimalField(
decimal_places=2,
max_digits=19,
validators=[
django.core.validators.MinValueValidator(Decimal("0.01"))
],
verbose_name="Сумма",
),
),
("reason", models.TextField(verbose_name="Основание")),
(
"status",
models.CharField(
choices=[
("pending", "Ожидает следующего периода"),
("transferred", "Перенесено"),
("cancelled", "Отменено"),
],
default="pending",
max_length=16,
verbose_name="Статус",
),
),
(
"created_at",
models.DateTimeField(auto_now_add=True, verbose_name="Создан"),
),
(
"updated_at",
models.DateTimeField(auto_now=True, verbose_name="Обновлён"),
),
(
"transferred_at",
models.DateTimeField(
blank=True, null=True, verbose_name="Перенесён"
),
),
(
"cancelled_at",
models.DateTimeField(blank=True, null=True, verbose_name="Отменён"),
),
(
"cancelled_by",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="cancelled_payroll_carryovers",
to=settings.AUTH_USER_MODEL,
verbose_name="Отменил",
),
),
(
"created_by",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="created_payroll_carryovers",
to=settings.AUTH_USER_MODEL,
verbose_name="Создал",
),
),
(
"employee",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="payroll_carryovers",
to=settings.AUTH_USER_MODEL,
verbose_name="Сотрудник",
),
),
(
"generated_input_line",
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="generated_from_carryover",
to="finance.payrollinputline",
verbose_name="Созданная операция",
),
),
(
"source_period",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="outgoing_carryovers",
to="finance.payrollperiod",
verbose_name="Исходный период",
),
),
(
"target_period",
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="incoming_carryovers",
to="finance.payrollperiod",
verbose_name="Период переноса",
),
),
],
options={
"verbose_name": "Долг или доплата",
"verbose_name_plural": "Долги и доплаты",
"ordering": ["-created_at", "-id"],
"indexes": [
models.Index(
fields=["status", "source_period"],
name="pay_carry_status_source_idx",
),
models.Index(
fields=["target_period", "employee"],
name="pay_carry_target_employee_idx",
),
],
"constraints": [
models.CheckConstraint(
condition=models.Q(("amount__gt", 0)),
name="pay_carry_amount_positive",
)
],
},
),
]