From c00fb31dae0f03084d1f10a4a4ec9021d4810aad Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Thu, 16 May 2024 12:35:43 +0300 Subject: [PATCH] fix newsletters --- erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php b/erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php index 763418e..853e1ed 100644 --- a/erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php +++ b/erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php @@ -52,7 +52,7 @@ try { $infoText .= ' test '; ////////////////////////////////////////////// - $sales = Sales::find()->joinWith(['users'])->where(['source' => '0'])->andWhere(['!=', 'sales.phone', '']) + $sales = Sales::find()->joinWith(['users'])->where(['source' => '0'])->andWhere(['!=', 'sales.phone::varchar(20)', '']) ->andWhere(['>=', 'sales.date', date('Y-m-d H:i:s', strtotime('-15 minute', time()))]) ->all(); -- 2.39.5