From 40075d8326f4e67db2c702762482e900147c41a6 Mon Sep 17 00:00:00 2001
From: marina <m.zozirova@gmail.com>
Date: Tue, 17 Jun 2025 12:03:44 +0300
Subject: [PATCH] =?utf8?q?ERP-360=20=D0=A1=D0=B1=D0=BE=D1=80=D0=BA=D0=B0?=
 =?utf8?q?=20=D1=81=D1=82=D1=80=D0=B0=D0=BD=D0=B8=D1=86=D1=8B=20=D0=B0?=
 =?utf8?q?=D0=B2=D1=82=D0=BE=D0=BF=D0=BC?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/controllers/AutoPlannogrammaController.php | 13 +++++++++----
 erp24/views/auto-plannogramma/index.php          |  2 +-
 2 files changed, 10 insertions(+), 5 deletions(-)

diff --git a/erp24/controllers/AutoPlannogrammaController.php b/erp24/controllers/AutoPlannogrammaController.php
index bc1057d2..505369a6 100644
--- a/erp24/controllers/AutoPlannogrammaController.php
+++ b/erp24/controllers/AutoPlannogrammaController.php
@@ -156,11 +156,15 @@ class AutoPlannogrammaController extends BaseController
             foreach ($productData['values'] as &$value) {
                 $storeId = $value['store_id'];
                 $value['title'] = [];
+
                 if (isset($forecast[$storeId][$productId])) {
                     $forecastData = $forecast[$storeId][$productId];
+                    $quantity = $value['quantity'];
+
                     foreach ($forecastData as $type => $groups) {
-                        foreach ($groups as $group => $amount) {
-                            $value['title'][$type][$group] = $amount;
+                        if (isset($groups['share'])) {
+                            $calculated = round($quantity * $groups['share'], 2);
+                            $value['title'][$type] = $calculated;
                         }
                     }
                 }
@@ -230,7 +234,7 @@ class AutoPlannogrammaController extends BaseController
                 ->select('store_id')
                 ->where(['category' => 3, 'active' => 1, 'value_int' => $filters['territorial_manager']])
                 ->column();
-            $query->andWhere(['in', 'a.store_id', $territorialManagerStoreIds ?: [-1]]);
+            $query->andWhere(['in', 'p.store_id', $territorialManagerStoreIds ?: [-1]]);
         }
 
         if (!empty($filters['bush_chef_florist'])) {
@@ -238,9 +242,10 @@ class AutoPlannogrammaController extends BaseController
                 ->select('store_id')
                 ->where(['category' => 2, 'active' => 1, 'value_int' => $filters['bush_chef_florist']])
                 ->column();
-            $query->andWhere(['in', 'a.store_id', $bushChefFloristStoreIds ?: [-1]]);
+            $query->andWhere(['in', 'p.store_id', $bushChefFloristStoreIds ?: [-1]]);
         }
 
+
         return array_values($query->column());
     }
 
diff --git a/erp24/views/auto-plannogramma/index.php b/erp24/views/auto-plannogramma/index.php
index 0fc108ff..c652830d 100644
--- a/erp24/views/auto-plannogramma/index.php
+++ b/erp24/views/auto-plannogramma/index.php
@@ -186,7 +186,7 @@ $this->registerJsFile('/js/autoplannogramma/autoplannogramma.js', ['position' =>
                     <?= Html::label("КШФ:", null, ['class' => 'label-kshf']) ?><br>
 
                     <div class="buttons d-flex justify-content-end">
-                        <?= Html::a('Auto', '#', ['class' => 'btn btn-success ms-1 btn-auto']) ?>
+                        <?= Html::a('Auto', Url::to(['auto-plannogramma/week-sales-species-excel']), ['class' => 'btn btn-success ms-1 btn-auto']) ?>
                         <?= Html::a('Corrected', '#', ['class' => 'btn btn-success ms-1 btn-corrected']) ?>
                     </div>
                 </th>
-- 
2.39.5