From 3a10cbbd8a77ae887590765e2d77ba988e40d075 Mon Sep 17 00:00:00 2001
From: marina <m.zozirova@gmail.com>
Date: Wed, 5 Mar 2025 14:12:40 +0300
Subject: [PATCH] =?utf8?q?ERP-329=20=D0=9D=D0=BE=D0=B2=D1=8B=D0=B9=20?=
 =?utf8?q?=D0=B8=D0=BD=D1=82=D0=B5=D1=80=D1=84=D0=B5=D0=B9=D1=81=20=D0=B4?=
 =?utf8?q?=D0=BB=D1=8F=20=D1=80=D0=B0=D0=B1=D0=BE=D1=82=D1=8B=20=D1=81=20?=
 =?utf8?q?=D0=B7=D0=B0=D0=BA=D0=B0=D0=B7=D0=B0=D0=BC=D0=B8=20=D0=BC=D0=BF?=
 =?utf8?q?=20=D0=B8=20=D0=B0=D0=BC=D0=BE?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/records/OrdersUnion.php | 22 +++++++++++-----------
 1 file changed, 11 insertions(+), 11 deletions(-)

diff --git a/erp24/records/OrdersUnion.php b/erp24/records/OrdersUnion.php
index c812d704..a6df5d98 100644
--- a/erp24/records/OrdersUnion.php
+++ b/erp24/records/OrdersUnion.php
@@ -23,7 +23,7 @@ class OrdersUnion extends ActiveRecord
         'flowwow' => 'Flowwow',
     ];
 
-    public static function getOrders($params = null)
+    public static function getOrders($params = [])
     {
         $queryAmo = (new Query())
             ->select([
@@ -66,12 +66,12 @@ class OrdersUnion extends ActiveRecord
                     WHEN ms.warehouse_id = 1 THEN 'flowwow'
                     ELSE 'Marketplace' 
                 END AS source"),
-                    'mo.id',
-                    'mod.delivery_end AS delivery_date',
-                    'mo.status_id',
-                    'mo.store_id',
-                    'payment_method',
-                    'mo.total',
+                'mo.id',
+                'mod.delivery_end AS delivery_date',
+                'mo.status_id',
+                'mo.store_id',
+                'payment_method',
+                'mo.total',
                 new \yii\db\Expression("NULLIF(concat(country, ' ', city, ' ', street, ' ', house, ' ', apartment), '')::TEXT AS delivery_address"),
                 new \yii\db\Expression("(
                 SELECT jsonb_agg(jsonb_build_object(
@@ -109,10 +109,10 @@ class OrdersUnion extends ActiveRecord
 
 
         $query = (new Query())
-            ->andFilterWhere(['source' => $params['source']])
-            ->andFilterWhere(['store_id' => $params['store_id']])
-            ->andFilterWhere(['>=', 'delivery_date', $params['delivery_date'] . ' 00:00:00'])
-            ->andFilterWhere(['<=', 'delivery_date', $params['delivery_date'] . ' 23:59:59'])
+            ->andFilterWhere(['source' => array_key_exists('source', $params) ? $params['source'] : null])
+            ->andFilterWhere(['store_id' => array_key_exists('store_id', $params) ? $params['store_id'] : null])
+            ->andFilterWhere(['>=', 'delivery_date', array_key_exists('delivery_date', $params) ? $params['delivery_date'] . ' 00:00:00' : null])
+            ->andFilterWhere(['<=', 'delivery_date', array_key_exists('delivery_date', $params) ? $params['delivery_date'] . ' 23:59:59' : null])
             ->from(['orders' => $queryAmo->union($queryMarketplace, true)])
             ->orderBy('id desc');
 
-- 
2.39.5