From ce6eb24bc82d5d93f4e6da2641dd0202e23766e4 Mon Sep 17 00:00:00 2001
From: fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Fri, 10 Jan 2025 11:42:04 +0300
Subject: [PATCH] =?utf8?q?=D0=94=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D0=B5=D0=BD?=
 =?utf8?q?=D0=B8=D0=B5=20=D0=BC=D0=B8=D0=B3=D1=80=D0=B0=D1=86=D0=B8=D0=B8?=
 =?utf8?q?=20=D0=B8=20=D1=82=D0=B0=D0=B1=D0=BB=D0=B8=D1=86=D1=8B?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 ...41_create_users_telegram_message_table.php | 44 +++++++++++++++++++
 erp24/records/SentKogort.php                  |  6 +--
 2 files changed, 47 insertions(+), 3 deletions(-)
 create mode 100644 erp24/migrations/m250110_074741_create_users_telegram_message_table.php

diff --git a/erp24/migrations/m250110_074741_create_users_telegram_message_table.php b/erp24/migrations/m250110_074741_create_users_telegram_message_table.php
new file mode 100644
index 00000000..c90ff9ad
--- /dev/null
+++ b/erp24/migrations/m250110_074741_create_users_telegram_message_table.php
@@ -0,0 +1,44 @@
+<?php
+
+use yii\db\Migration;
+
+/**
+ * Handles the creation of table `{{%users_telegram_message}}`.
+ */
+class m250110_074741_create_users_telegram_message_table extends Migration
+{
+    const TABLE_NAME = 'erp24.users_telegram_message';
+    /**
+     * {@inheritdoc}
+     */
+    public function safeUp()
+    {
+        $tableSchema = $this->db->getTableSchema(self::TABLE_NAME);
+
+        if (!isset($tableSchema)) {
+            $this->createTable(self::TABLE_NAME, [
+                'id' => $this->bigPrimaryKey()->comment('ID'),
+                'chat_id' => $this->string()->notNull()->comment('Chat ID'),
+                'phone' => $this->string()->notNull()->comment('Телефон'),
+                'message' => $this->string()->notNull()->comment('Текст сообщения в Телеграм'),
+                'kogort_date' => $this->date()->notNull()->comment('Дата когорты'),
+                'target_date' => $this->date()->notNull()->comment('Целевая дата'),
+                'type' => $this->integer()->notNull()->defaultValue(1)
+                    ->comment('Номер рассылки: 1- первая, 2 - вторая'),
+                'created_at' => $this->dateTime()->notNull()->defaultExpression('CURRENT_TIMESTAMP')
+                    ->comment('Дата создания записи'),
+            ]);
+        }
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function safeDown()
+    {
+        $tableSchema = $this->db->getTableSchema(self::TABLE_NAME);
+        if (isset($tableSchema)) {
+            $this->dropTable(self::TABLE_NAME);
+        }
+    }
+}
diff --git a/erp24/records/SentKogort.php b/erp24/records/SentKogort.php
index 6f2a9258..1c05074b 100644
--- a/erp24/records/SentKogort.php
+++ b/erp24/records/SentKogort.php
@@ -27,9 +27,9 @@ class SentKogort extends \yii\db\ActiveRecord
     ];
 
     public const STATUSES = [
-      'created' => 1,
-        'first' => 2,
-        'second' => 3,
+      'created' => 1, // создана запись в когорте
+        'first' => 2, // отправлено первое сообщение в чатбот на номер в когорте
+        'second' => 3, // отправлено второе сообщение на номер в когорте
     ];
     /**
      * {@inheritdoc}
-- 
2.39.5