From c1687fb7b4fadadb250418367362f720e3bda200 Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Tue, 30 Apr 2024 19:32:05 +0300 Subject: [PATCH] fix api3 report show --- erp24/api3/core/services/ReportService.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/erp24/api3/core/services/ReportService.php b/erp24/api3/core/services/ReportService.php index d833a397..3c9dc6ff 100644 --- a/erp24/api3/core/services/ReportService.php +++ b/erp24/api3/core/services/ReportService.php @@ -23,6 +23,8 @@ class ReportService * @throws Exception */ public function show($data) { + set_time_limit(600); + $currentDate = $data->date_start; $reports = []; @@ -144,7 +146,7 @@ class ReportService "sum(CASE WHEN (s.phone IS NOT NULL) AND u.sale_cnt > 1 THEN 1 ELSE 0 END) as repeatBonusUserCount", "s.store_id", "s.admin_id"]) - ->leftJoin('users u', 'u.phone = s.phone AND u.phone IN (\'' + ->leftJoin('users u', 'u.phone = s.phone::varchar(20) AND u.phone IN (\'' . implode('\',\'', ArrayHelper::getColumn($salesPhones, 'phone')) .'\')') ->where(['between', 's.date', $date_start, $date_end]) ->andWhere(['s.store_id' => $data->stores]) -- 2.39.5