From e16052b528cd27fd7d4fd335201b6548460d3f8c Mon Sep 17 00:00:00 2001 From: Vladimir Fomichev Date: Wed, 30 Jul 2025 17:21:51 +0300 Subject: [PATCH] =?utf8?q?=D0=97=D0=B0=D0=BF=D0=BE=D0=BB=D0=BD=D0=B5=D0=BD?= =?utf8?q?=D0=B8=D0=B5=20=D0=B4=D0=B0=D0=BD=D0=BD=D1=8B=D1=85=20=D0=B0?= =?utf8?q?=D0=BA=D1=82=D0=B8=D0=B2=D0=BD=D0=BE=D1=81=D1=82=D0=B8?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../controllers/Products1cNomenclatureActualityController.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/erp24/controllers/Products1cNomenclatureActualityController.php b/erp24/controllers/Products1cNomenclatureActualityController.php index d2a6cfd9..e4601de3 100644 --- a/erp24/controllers/Products1cNomenclatureActualityController.php +++ b/erp24/controllers/Products1cNomenclatureActualityController.php @@ -234,10 +234,10 @@ class Products1cNomenclatureActualityController extends Controller ->select('sp.product_id') ->from(['s' => 'sales']) ->innerJoin(['sp' => 'sales_products'], 's.id = sp.check_id') - ->andWhere(['s.store_id' => $storeIds]) + //->andWhere(['s.store_id' => $storeIds]) ->andWhere(['between', 's.date', "{$startDate} 00:00:00", "{$endDate} 23:59:59"]) ->groupBy('sp.product_id') - ->having(['=', new \yii\db\Expression('COUNT(DISTINCT s.store_id)'), $countStores]) + //->having(['=', new \yii\db\Expression('COUNT(DISTINCT s.store_id)'), $countStores]) ->column(); if (empty($productIds)) { -- 2.39.5