176 lines
6.7 KiB
Python
176 lines
6.7 KiB
Python
# Generated by Django 5.2.4 on 2026-09-07 06:31
|
|
|
|
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 = [
|
|
("commerce", "0012_sale_customer_external_id_sale_customer_name"),
|
|
("finance", "0031_payrolltablereviewmark"),
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name="ReportingEntry",
|
|
fields=[
|
|
(
|
|
"id",
|
|
models.BigAutoField(
|
|
auto_created=True,
|
|
primary_key=True,
|
|
serialize=False,
|
|
verbose_name="ID",
|
|
),
|
|
),
|
|
(
|
|
"kind",
|
|
models.CharField(
|
|
choices=[
|
|
("production", "Выпуск продукции"),
|
|
("purchase", "Закупка для производства"),
|
|
("tax", "Уплаченные налоги сотрудника"),
|
|
("overhead", "Общие расходы"),
|
|
("cash_in", "Поступление денег"),
|
|
("cash_out", "Выплата денег"),
|
|
],
|
|
max_length=16,
|
|
),
|
|
),
|
|
("date", models.DateField(db_index=True, verbose_name="Дата факта")),
|
|
(
|
|
"reference",
|
|
models.CharField(
|
|
max_length=200, verbose_name="Документ / уникальный номер"
|
|
),
|
|
),
|
|
(
|
|
"description",
|
|
models.CharField(
|
|
blank=True, max_length=500, verbose_name="Описание"
|
|
),
|
|
),
|
|
(
|
|
"quantity",
|
|
models.DecimalField(
|
|
decimal_places=4,
|
|
default=0,
|
|
max_digits=18,
|
|
validators=[
|
|
django.core.validators.MinValueValidator(Decimal("0"))
|
|
],
|
|
),
|
|
),
|
|
(
|
|
"amount",
|
|
models.DecimalField(
|
|
decimal_places=2,
|
|
default=0,
|
|
max_digits=18,
|
|
validators=[
|
|
django.core.validators.MinValueValidator(Decimal("0"))
|
|
],
|
|
),
|
|
),
|
|
(
|
|
"currency",
|
|
models.CharField(
|
|
default="RUB",
|
|
max_length=3,
|
|
validators=[
|
|
django.core.validators.RegexValidator("^[A-Z]{3}$")
|
|
],
|
|
),
|
|
),
|
|
("created_at", models.DateTimeField(auto_now_add=True)),
|
|
("voided_at", models.DateTimeField(blank=True, null=True)),
|
|
(
|
|
"created_by",
|
|
models.ForeignKey(
|
|
on_delete=django.db.models.deletion.PROTECT,
|
|
related_name="reporting_entries_created",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
(
|
|
"employee",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.PROTECT,
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
(
|
|
"product",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.PROTECT,
|
|
to="commerce.product",
|
|
),
|
|
),
|
|
(
|
|
"voided_by",
|
|
models.ForeignKey(
|
|
blank=True,
|
|
null=True,
|
|
on_delete=django.db.models.deletion.PROTECT,
|
|
related_name="reporting_entries_voided",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
],
|
|
options={
|
|
"ordering": ["-date", "-pk"],
|
|
"constraints": [
|
|
models.UniqueConstraint(
|
|
fields=("kind", "reference"),
|
|
name="reporting_entry_reference_unique",
|
|
),
|
|
models.CheckConstraint(
|
|
condition=models.Q(("amount__gte", 0), ("quantity__gte", 0)),
|
|
name="reporting_entry_nonnegative",
|
|
),
|
|
models.CheckConstraint(
|
|
condition=models.Q(
|
|
models.Q(
|
|
("amount", 0),
|
|
("employee__isnull", True),
|
|
("kind", "production"),
|
|
("product__isnull", False),
|
|
("quantity__gt", 0),
|
|
),
|
|
models.Q(
|
|
("amount__gt", 0),
|
|
("employee__isnull", True),
|
|
("kind", "purchase"),
|
|
),
|
|
models.Q(
|
|
("amount__gt", 0),
|
|
("employee__isnull", False),
|
|
("kind", "tax"),
|
|
("product__isnull", True),
|
|
("quantity", 0),
|
|
),
|
|
models.Q(
|
|
("amount__gt", 0),
|
|
("employee__isnull", True),
|
|
("kind__in", ["overhead", "cash_in", "cash_out"]),
|
|
("product__isnull", True),
|
|
("quantity", 0),
|
|
),
|
|
_connector="OR",
|
|
),
|
|
name="reporting_entry_kind_fields",
|
|
),
|
|
],
|
|
},
|
|
),
|
|
]
|