From 97cc8b6363589d1337dc8c0c01eb17170c1b87f2 Mon Sep 17 00:00:00 2001
From: Vladimir Fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Fri, 20 Jun 2025 17:36:03 +0300
Subject: [PATCH] =?utf8?q?=D0=A4=D0=B8=D0=BA=D1=81?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/controllers/CategoryPlanController.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/erp24/controllers/CategoryPlanController.php b/erp24/controllers/CategoryPlanController.php
index 7a5f7b5c..5195c97a 100644
--- a/erp24/controllers/CategoryPlanController.php
+++ b/erp24/controllers/CategoryPlanController.php
@@ -73,7 +73,7 @@ class CategoryPlanController extends Controller {
             ->leftJoin('products_1c_nomenclature p1cn', 'p1cn.id = sp.product_id')
             ->where(['between', 's.date', $date_start, $date_end])
             ->andWhere(['order_id' => ['', '0']])
-            ->andWhere(['not in', 'p1c.category', ['', 'букет', 'сборка', 'сервис']])
+            ->andWhere(['not in', 'p1cn.category', ['', 'букет', 'сборка', 'сервис']])
             ->andWhere(['s.store_id' => $model->store_id])
             ->groupBy(['s.store_id', "TO_CHAR(s.date, 'YYYY-MM')", "p1cn.category"])
             ->orderBy(['month' => SORT_ASC, 'p1cn.category' => SORT_ASC])
@@ -111,7 +111,7 @@ class CategoryPlanController extends Controller {
             ->where(['between', 's.date', $date_start, $date_end])
             ->andWhere(['not in', 'order_id', ['', '0']])
             ->andWhere(['s.store_id' => $model->store_id])
-            ->andWhere(['not in', 'p1c.category', ['', 'букет', 'сборка', 'сервис']])
+            ->andWhere(['not in', 'p1cn.category', ['', 'букет', 'сборка', 'сервис']])
             ->groupBy(['s.store_id', "TO_CHAR(s.date, 'YYYY-MM')", "p1cn.category"])
             ->orderBy(['month' => SORT_ASC, 'p1cn.category' => SORT_ASC])
             ->asArray()
@@ -136,7 +136,7 @@ class CategoryPlanController extends Controller {
             ->leftJoin('products_1c_nomenclature p1cn', 'p1cn.id = wop.product_id')
             ->where(['between', 'wo.date', $date_start, $date_end])
             ->andWhere(['wo.type' => WriteOffsErp::WRITE_OFFS_TYPE_BRAK])
-            ->andWhere(['not in', 'p1c.category', ['', 'букет', 'сборка', 'сервис']])
+            ->andWhere(['not in', 'p1cn.category', ['', 'букет', 'сборка', 'сервис']])
             ->andWhere(['wo.store_id' => $store_id])
             ->groupBy(["month", 'p1cn.category'])
             ->asArray()->all();
-- 
2.39.5