From 7734d037c9e9331e3ab7ead5d8d3b85fae8db188 Mon Sep 17 00:00:00 2001
From: fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Wed, 25 Dec 2024 14:15:12 +0300
Subject: [PATCH] =?utf8?q?=D0=9E=D1=82=D0=BA=D0=BB=D1=8E=D1=87=D0=B5=D0=BD?=
 =?utf8?q?=D0=B8=D0=B5=20=D0=B7=D0=B0=D0=BF=D0=B8=D1=81=D0=B8=20=D0=B2=20?=
 =?utf8?q?=D1=84=D0=B0=D0=B9=D0=BB=20=D0=B2=20=D0=BC=D0=B5=D1=82=D0=BE?=
 =?utf8?q?=D0=B4=D0=B5=20=D0=BA=D1=80=D0=BE=D0=BD=20=D0=B8=20=D0=B8=D0=B7?=
 =?utf8?q?=D0=BC=D0=B5=D0=BD=D0=B5=D0=BD=D0=B8=D0=B5=20=D0=BC=D0=B8=D0=B3?=
 =?utf8?q?=D1=80=D0=B0=D1=86=D0=B8=D0=B8?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/commands/CronController.php                    | 12 ++++++------
 ...241224_145213_create_users_telegram_log_table.php |  5 +++--
 2 files changed, 9 insertions(+), 8 deletions(-)

diff --git a/erp24/commands/CronController.php b/erp24/commands/CronController.php
index db6e1f0e..f905f466 100644
--- a/erp24/commands/CronController.php
+++ b/erp24/commands/CronController.php
@@ -360,9 +360,9 @@ class CronController extends Controller
         $batchSize = 500;
         $offset = 0;
 
-        $csvFilePath = Yii::getAlias('@runtime/missing_users.csv');
-        $fileHandle = fopen($csvFilePath, 'w');
-        fputcsv($fileHandle, ['phone', 'username', 'chat_id', 'is-blocked', 'is_registered', 'reason'], ';');
+       // $csvFilePath = Yii::getAlias('@runtime/missing_users.csv');
+      //  $fileHandle = fopen($csvFilePath, 'w');
+      //  fputcsv($fileHandle, ['phone', 'username', 'chat_id', 'is-blocked', 'is_registered', 'reason'], ';');
 
         while (true) {
             $chatbotUsers = $remoteDb
@@ -382,7 +382,7 @@ class CronController extends Controller
                 $isBlocked = (int)$remoteUser['is_blocked'];
                 $isRegistered = (int)$remoteUser['is_registered'];
                 if (empty($phone)) {
-                    fputcsv($fileHandle, [$phone, $username, $chatId, $isBlocked, $isRegistered, 'Отсутствует телефон'], ';');
+                   // fputcsv($fileHandle, [$phone, $username, $chatId, $isBlocked, $isRegistered, 'Отсутствует телефон'], ';');
                     continue;
                 }
 
@@ -407,7 +407,7 @@ class CronController extends Controller
                 $user = Users::findOne(['phone' => $phone]);
 
                 if (!$user) {
-                    fputcsv($fileHandle, [$phone, $username, $chatId, $isBlocked, $isRegistered, 'Пользователь не найден'], ';');
+                   // fputcsv($fileHandle, [$phone, $username, $chatId, $isBlocked, $isRegistered, 'Пользователь не найден'], ';');
                     continue;
                     /* $user = new Users([
                          'phone' => $phone,
@@ -438,7 +438,7 @@ class CronController extends Controller
             $this->stdout("Обработано записей: {$offset}\n", BaseConsole::FG_GREEN);
         }
 
-        fclose($fileHandle);
+       // fclose($fileHandle);
         $this->stdout(
             "Синхронизация завершена успешно. Записи без пользователей сохранены в {$csvFilePath}\n",
             BaseConsole::FG_GREEN
diff --git a/erp24/migrations/m241224_145213_create_users_telegram_log_table.php b/erp24/migrations/m241224_145213_create_users_telegram_log_table.php
index bdfda56e..3d6a3359 100644
--- a/erp24/migrations/m241224_145213_create_users_telegram_log_table.php
+++ b/erp24/migrations/m241224_145213_create_users_telegram_log_table.php
@@ -17,7 +17,8 @@ class m241224_145213_create_users_telegram_log_table extends Migration
 
         if (!isset($tableSchema)) {
             $this->createTable(self::TABLE_NAME, [
-                'phone' => $this->string()->notNull()->unique()->comment('Телефон'),
+                'id' => $this->primaryKey()->comment('Первичный ключ'),
+                'phone' => $this->string()->notNull()->comment('Телефон'),
                 'is_blocked' => $this->integer(1)->notNull()->defaultValue(0)->comment(
                     'Заблокирован: 0 - нет, 1 - да'
                 ),
@@ -30,7 +31,7 @@ class m241224_145213_create_users_telegram_log_table extends Migration
                 'date_end' => $this->date()->null()->comment('Дата окончания активности'),
 
             ]);
-            $this->addPrimaryKey('pk_users_telegram_log', self::TABLE_NAME, 'phone');
+
         }
     }
 
-- 
2.39.5