From a6029a85ec961230c4da9484408a256f92f3820f Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Fri, 17 May 2024 10:53:16 +0300 Subject: [PATCH] fix sales sql query for pgsql --- erp24/records/Sales.php | 2 +- erp24/scripts/tasks/task_18_newsletters_for_non_tg_users.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/erp24/records/Sales.php b/erp24/records/Sales.php index e6776d52..09956648 100755 --- a/erp24/records/Sales.php +++ b/erp24/records/Sales.php @@ -136,6 +136,6 @@ class Sales extends \yii\db\ActiveRecord } public function getUsers() { - return $this->hasOne(Users::class, ['phone' => new Expression('phone::varchar(20)')]); + return $this->hasOne(Users::class, ['phone' => 'phone']); } } \ No newline at end of file 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 853e1edf..2667abac 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::varchar(20)', '']) + $sales = Sales::find()->leftJoin('users', 'users.phone = sales.phone::varchar(20)')->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