From 8d36d7d74135edc711e0b90879b67c0e1d217dd8 Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Tue, 10 Dec 2024 16:40:24 +0300
Subject: [PATCH] =?utf8?q?[ERP-261]=20=D1=82=D0=B0=D0=B1=D0=BB=D0=B8=D1=86?=
 =?utf8?q?=D0=B0=20waybill=5Fincoming?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 ...0_133251_create_table_waybill_incoming.php | 51 +++++++++++++++++++
 1 file changed, 51 insertions(+)
 create mode 100755 erp24/migrations/m241210_133251_create_table_waybill_incoming.php

diff --git a/erp24/migrations/m241210_133251_create_table_waybill_incoming.php b/erp24/migrations/m241210_133251_create_table_waybill_incoming.php
new file mode 100755
index 00000000..2280f0a5
--- /dev/null
+++ b/erp24/migrations/m241210_133251_create_table_waybill_incoming.php
@@ -0,0 +1,51 @@
+<?php
+
+use yii\db\Migration;
+
+/**
+ * Class m241210_133251_create_table_waybill_incoming
+ */
+class m241210_133251_create_table_waybill_incoming extends Migration
+{
+    const TABLE_NAME = 'erp24.waybill_incoming';
+
+    /**
+     * {@inheritdoc}
+     */
+    public function safeUp()
+    {
+        $this->createTable(self::TABLE_NAME, [
+            'id' => $this->primaryKey(),
+            'guid' => $this->string(100)->notNull()->unique()->comment('GUID документа для 1c'),
+            'shift_transfer_id' => $this->integer()->comment('ID записи передачи смены'),
+            'status' => $this->integer()->notNull()->defaultValue(1)->comment('Статус документа'),
+            'created_admin_id' => $this->integer()->notNull()->comment('Создан пользователем'),
+            'updated_admin_id' => $this->integer()->null()->comment('Изменён пользователем'),
+
+            'store_id' => $this->integer()->notNull()->comment('id магазина в ERP'),
+            'store_guid' => $this->string(100)->notNull()->comment('GUID магазина из 1с'),
+            'number' => $this->string(100)->notNull()->comment('Название документа'),
+            'number_1c' => $this->string(100)->null()->comment('Название документа в 1с'),
+            'date' => $this->dateTime()->notNull()->comment('Дата документа'),
+            'comment' => $this->text()->null()->comment('Комментарий'),
+            'quantity' => $this->float()->notNull()->comment('Количество'),
+            'summ' => $this->float()->notNull()->comment('Сумма розничная'),
+            'summ_self_cost' => $this->float()->null()->comment('Сумма себестоимости'),
+            'created_at' => $this->dateTime()->notNull()->comment('Дата создания'),
+            'updated_at' => $this->dateTime()->null()->comment('Дата обновления'),
+            'deleted_at' => $this->dateTime()->null()->comment('Дата удаление'),
+
+            'send_at' => $this->dateTime()->null()->comment('Дата отправления в 1с'),
+            'active' => $this->tinyInteger()->notNull()->defaultValue(1)->comment('Активность'),
+            'deleted_admin_id' => $this->integer()->null()->comment('Удален пользователем'),
+        ]);
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function safeDown()
+    {
+        $this->dropTable(self::TABLE_NAME);
+    }
+}
-- 
2.39.5