From 30c7fd97847f18d5f682a87bdfe0fffc3b1d58eb Mon Sep 17 00:00:00 2001
From: Vladimir Fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Wed, 30 Jul 2025 17:27:52 +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  | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/erp24/controllers/Products1cNomenclatureActualityController.php b/erp24/controllers/Products1cNomenclatureActualityController.php
index 7555bafb..196d785d 100644
--- a/erp24/controllers/Products1cNomenclatureActualityController.php
+++ b/erp24/controllers/Products1cNomenclatureActualityController.php
@@ -235,11 +235,12 @@ class Products1cNomenclatureActualityController extends Controller
             ->from(['s' => 'sales'])
             ->innerJoin(['sp' => 'sales_products'], 's.id = sp.check_id')
             //->andWhere(['s.store_id' => $storeIds])
+            ->innerJoin(['p1c' => 'products_1c_nomenclature'], 'p1c.id = sp.product_id')
             ->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])
             ->column();
-        var_dump($productIds);
+        var_dump($productIds); die();
         if (empty($productIds)) {
             Yii::$app->session->setFlash('info', 'Нет товаров, удовлетворяющих условиям.');
             return $this->render('add-activity', [
-- 
2.39.5