From e985967af2a339aa066fe457fca65909b5931f66 Mon Sep 17 00:00:00 2001 From: Alexander Smirnov Date: Tue, 2 Apr 2024 13:34:10 +0300 Subject: [PATCH] fix double quotes around value in pgsql --- erp24/controllers/PlanStoreController.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/erp24/controllers/PlanStoreController.php b/erp24/controllers/PlanStoreController.php index ce4a6b6..5347b7e 100644 --- a/erp24/controllers/PlanStoreController.php +++ b/erp24/controllers/PlanStoreController.php @@ -250,7 +250,7 @@ class PlanStoreController extends Controller public function getStoreList() { $stores = CityStore::find()->innerJoin('store_dynamic', 'store_dynamic.store_id = city_store.id') - ->select(['cluster' => 'CONCAT_WS(" ", "Куст", store_dynamic.value_int)', 'store_name' => 'city_store.name', 'store_id' => 'city_store.id']) + ->select(['cluster' => 'CONCAT_WS(\' \', \'Куст\', store_dynamic.value_int)', 'store_name' => 'city_store.name', 'store_id' => 'city_store.id']) ->asArray() ->all(); -- 2.39.5