From f106c3adf5b6cf393cdb5298eec3a7d5bf24613d Mon Sep 17 00:00:00 2001
From: Vladimir Fomichev <vladimir.fomichev@erp-flowers.ru>
Date: Tue, 7 Oct 2025 16:08:29 +0300
Subject: [PATCH] =?utf8?q?=D0=A4=D0=B8=D0=BB=D1=8C=D1=82=D1=80=20=D0=BF?=
 =?utf8?q?=D0=BE=20=D0=B0=D1=80=D1=82=D0=B8=D0=BA=D1=83=D0=BB=D1=83=20?=
 =?utf8?q?=D0=B8=20=D1=81=D0=BE=D1=80=D1=82=D0=B8=D1=80=D0=BE=D0=B2=D0=BA?=
 =?utf8?q?=D0=B0=20=D0=BF=D0=BE=20=D0=B8=D0=BC=D0=B5=D0=BD=D0=B8?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/controllers/MatrixErpController.php | 11 ++++++++++-
 erp24/views/matrix_erp/index.php          | 18 +++++++++++-------
 2 files changed, 21 insertions(+), 8 deletions(-)

diff --git a/erp24/controllers/MatrixErpController.php b/erp24/controllers/MatrixErpController.php
index b22bd971..00785677 100644
--- a/erp24/controllers/MatrixErpController.php
+++ b/erp24/controllers/MatrixErpController.php
@@ -106,12 +106,14 @@ class MatrixErpController extends Controller
             'activeFilter' => 1,
             'nameFilter',
             'groupNameFilter',
+            'articuleFilter',
 
         ], [
             [
                 [
                     'groupNameFilter',
                     'nameFilter',
+                    'articuleFilter',
                 ],
                 'safe',
 
@@ -136,6 +138,7 @@ class MatrixErpController extends Controller
             $nameFilter = $filterModel->nameFilter;
             $groupNameFilter = $filterModel->groupNameFilter;
             $activeFilter = $filterModel->activeFilter;
+            $articuleFilter = $filterModel->articuleFilter;
 
         } else {
             $query->andWhere(['group_name' => 'marketplace']);
@@ -159,11 +162,17 @@ class MatrixErpController extends Controller
                 $query->andFilterWhere(['like', 'matrix_erp.name', $nameFilter]);;
             }
         }
+
+        if (isset($articuleFilter) && $articuleFilter != "") {
+            if (!empty($articuleFilter)) {
+                $query->andFilterWhere(['like', 'matrix_erp.articule', $articuleFilter]);
+            }
+        }
         $test = 1;
 
 //        $action = $query->createCommand()->getRawSql();
 
-        $model = $query->all();
+        $model = $query->orderBy(['name' => SORT_ASC])->all();
         if (!empty($model)) {
             foreach ($model as $item) {
                 $item->setComponentsArray();
diff --git a/erp24/views/matrix_erp/index.php b/erp24/views/matrix_erp/index.php
index 5235e3f8..14493c17 100644
--- a/erp24/views/matrix_erp/index.php
+++ b/erp24/views/matrix_erp/index.php
@@ -85,7 +85,7 @@ $this->params['breadcrumbs'][] = $this->title;
                 <div class="card-body">
                     <?php $form = ActiveForm::begin(['id' => 'filter-form']); ?>
                     <div class="row">
-                        <div class="col-sm-4 col-md-4">
+                        <div class="col-sm-3 col-md-3">
                             <?php
 
                             echo $form->field($filterModel, 'groupNameFilter')->dropDownList(array_merge([
@@ -105,7 +105,7 @@ $this->params['breadcrumbs'][] = $this->title;
 
                             ?>
                         </div>
-                        <div class="col-sm-4 col-md-4">
+                        <div class="col-sm-3 col-md-3">
                             <?php
 
                             echo $form->field($filterModel, 'nameFilter')->textInput(
@@ -113,19 +113,23 @@ $this->params['breadcrumbs'][] = $this->title;
 
                             ?>
                         </div>
-                        <div class="col-sm-4 col-md-4">
+                        <div class="col-sm-3 col-md-3">
+                            <?php
+                            echo $form->field($filterModel, 'articuleFilter')->textInput(
+                                ['class' => 'form-control'])->label('Артикул');
+                            ?>
+                        </div>
+                        <div class="col-sm-3 col-md-3">
                             <?php
                             echo $form->field($filterModel, 'activeFilter')->dropDownList(
                                 ['' => 'Все', 1 => 'Активная', 0 => 'Не активная',],
                                 ['class' => 'form-control', 'onchange' => 'this.form.submit();'])->label('Активность');
                             ?>
                         </div>
-
-
                     </div>
                     <div class="row">
-                        <div class="col-sm-4 col-md-4">
-                            <?= Html::submitButton('Фильтр', ['class' => 'btn btn-primary  mt-4 mb-0']) ?>
+                        <div class="col-sm-12 col-md-12">
+                            <?= Html::submitButton('Фильтр', ['class' => 'btn btn-primary mt-4 mb-0']) ?>
                         </div>
                     </div>
                     <?php ActiveForm::end() ?>
-- 
2.39.5