From 5d121f11c2a4d85570b4ca6326f3e33090e6655e Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Fri, 3 May 2024 13:13:47 +0300 Subject: [PATCH] fix --- erp24/api3/core/services/NotifiableService.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/api3/core/services/NotifiableService.php b/erp24/api3/core/services/NotifiableService.php index b865fdff..fea1ff74 100644 --- a/erp24/api3/core/services/NotifiableService.php +++ b/erp24/api3/core/services/NotifiableService.php @@ -33,7 +33,7 @@ class NotifiableService } } - $userBonuses = UsersBonus::find()->select(['phone', 'sum(if(tip=\'plus\', bonus, -bonus)) as sum']) + $userBonuses = UsersBonus::find()->select(['phone', 'sum(CASE WHEN tip=\'plus\' THEN bonus ELSE -bonus END) as sum']) ->where(['in', 'phone', array_keys($buffer)]) ->andWhere(['<', 'date_start', new Expression('NOW()')]) ->andWhere(['>', 'date_end', new Expression('NOW()')]) -- 2.39.5