From 44735c19d1a6fbb271c4e8ef66e58c19708666b5 Mon Sep 17 00:00:00 2001
From: Alexander Smirnov <fredeom@mail.ru>
Date: Fri, 5 Jul 2024 15:09:28 +0300
Subject: [PATCH] =?utf8?q?=D0=98=D1=81=D1=80=D0=BF=D0=B0=D0=B2=D0=BB=D0=B5?=
 =?utf8?q?=D0=BD=D0=B8=D0=B5=20=D0=B2=D1=8C=D1=8E=D1=88=D0=BA=D0=B8?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 erp24/controllers/TimetableFactController.php |  8 ++-
 erp24/views/timetable-fact/index.php          | 60 +++++++++++++------
 2 files changed, 49 insertions(+), 19 deletions(-)

diff --git a/erp24/controllers/TimetableFactController.php b/erp24/controllers/TimetableFactController.php
index d0b46cb2..4a73b709 100644
--- a/erp24/controllers/TimetableFactController.php
+++ b/erp24/controllers/TimetableFactController.php
@@ -2,6 +2,7 @@
 
 namespace app\controllers;
 
+use http\Exception;
 use Yii;
 use yii\base\DynamicModel;
 use yii\db\Expression;
@@ -54,15 +55,18 @@ class TimetableFactController extends Controller
            [['store_id', 'date_start', 'date_end', 'group_id', 'admin_id', 'autoclosed', 'sort'], 'safe']
         ]);
         $model->load(Yii::$app->request->get());
+        if ($model->date_start && $model->date_end && $model->date_end < $model->date_start) {
+            Yii::$app->session->setFlash('info', "Дата окончания не может быть раньше даты начала");
+        }
         $timetableFactModelQuery = TimetableFactModel::find();
         if ($model->store_id && $model->store_id > 0) {
             $timetableFactModelQuery->andWhere(['store_id' => $model->store_id]);
         }
         if ($model->date_start) {
-            $timetableFactModelQuery->andWhere(['>=', new Expression('CONCAT(date_end, \' \', time_end)'), $model->date_start]);
+            $timetableFactModelQuery->andWhere(['>=', 'date_shift', date('Y-m-d 00:00:00', strtotime($model->date_start))]);
         }
         if ($model->date_end) {
-            $timetableFactModelQuery->andWhere(['<=', new Expression('CONCAT(date_start, \' \', time_start)'), $model->date_end]);
+            $timetableFactModelQuery->andWhere(['<=', 'date_shift', date('Y-m-d 23:59:59', strtotime($model->date_end))]);
         }
         if ($model->group_id && $model->group_id > 0) {
             $timetableFactModelQuery->andWhere(['d_id' => $model->group_id]);
diff --git a/erp24/views/timetable-fact/index.php b/erp24/views/timetable-fact/index.php
index 75ba0fe6..d5bac023 100644
--- a/erp24/views/timetable-fact/index.php
+++ b/erp24/views/timetable-fact/index.php
@@ -21,11 +21,20 @@ $this->params['breadcrumbs'][] = $this->title;
 
     <h1><?= Html::encode($this->title) ?></h1>
 
+    <?php if (Yii::$app->session->hasFlash('info')): ?>
+        <div class="alert alert-warning alert-dismissable">
+            <button aria-hidden="true" data-dismiss="alert" class="close" type="button">×</button>
+            <?= Yii::$app->session->getFlash('info') ?>
+        </div>
+    <?php endif; ?>
+
     <?php $form = ActiveForm::begin(['method' => 'GET']) ?>
 
     <div class="row">
-        <div class="col-11 d-flex align-items-center justify-content-around">
-            <div class="mb-3">Магазин:</div> <div style="display:inline-block"><?= $form->field($model, 'store_id')->widget(Select2::class, [
+        <div class="col-11 d-flex align-items-center justify-content-around gap-2">
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3">Магазин:</div>
+                <div style="display:inline-block"><?= $form->field($model, 'store_id')->widget(Select2::class, [
                     'data' => $stores,
                     'language' => 'ru',
                     'options' => ['placeholder' => 'Магазин...'],
@@ -33,25 +42,34 @@ $this->params['breadcrumbs'][] = $this->title;
                         'allowClear' => true
                     ],
                 ])->label(false) ?></div>
-        <div class="mb-3">Дата до:</div> <div style="display:inline-block"><?= $form->field($model, 'date_start')->widget(DateTimePicker::class, [
+            </div>
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3">Дата смены от:</div>
+                <div style="display:inline-block; max-width: 120px;"><?= $form->field($model, 'date_start')->widget(DateTimePicker::class, [
                     'language' => 'ru',
                     'template' => '{input}',
                     'clientOptions' => [
                         'autoclose' => true,
-                        'format' => 'Y-m-d H:i:s',
+                        'format' => 'Y-m-d',
                         'todayBtn' => true
                     ],
                 ])->label(false) ?></div>
-        <div class="mb-3">после:</div> <div style="display:inline-block"><?= $form->field($model, 'date_end')->widget(DateTimePicker::class, [
+            </div>
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3">до:</div>
+                <div style="display:inline-block; max-width: 120px;"><?= $form->field($model, 'date_end')->widget(DateTimePicker::class, [
                     'language' => 'ru',
                     'template' => '{input}',
                     'clientOptions' => [
                         'autoclose' => true,
-                        'format' => 'Y-m-d H:i:s',
+                        'format' => 'Y-m-d',
                         'todayBtn' => true
                     ],
                 ])->label(false) ?></div>
-        <div class="mb-3">Группа:</div> <div style="display:inline-block"><?= $form->field($model, 'group_id')->widget(Select2::class, [
+            </div>
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3">Группа:</div>
+                <div style="display:inline-block"><?= $form->field($model, 'group_id')->widget(Select2::class, [
                     'data' => $adminGroups,
                     'language' => 'ru',
                     'options' => ['placeholder' => 'Должность...'],
@@ -59,16 +77,24 @@ $this->params['breadcrumbs'][] = $this->title;
                         'allowClear' => true
                     ],
                 ])->label(false) ?></div>
-        <div class="mb-3">Сотрудник:</div> <div style="display:inline-block"><?= $form->field($model, 'admin_id')->widget(Select2::class, [
-                'data' => $admins,
-                'language' => 'ru',
-                'options' => ['placeholder' => 'Сотрудник...'],
-                'pluginOptions' => [
-                    'allowClear' => true
-                ],
-            ])->label(false) ?></div>
-        <div class="mb-3" title="Автоматическое закрытие">Авт. закр.:</div> <div style="display:inline-block"><?= $form->field($model, 'autoclosed')->checkbox([0 => 'unchecked', 1 => 'checked'], [])->label(false) ?></div>
-        <div class="mb-4"><?= Html::submitButton('Применить', ['class' => 'btn btn-secondary btn-sm'])?></div>
+            </div>
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3">Сотрудник:</div>
+                <div style="display:inline-block"><?= $form->field($model, 'admin_id')->widget(Select2::class, [
+                    'data' => $admins,
+                    'language' => 'ru',
+                    'options' => ['placeholder' => 'Сотрудник...'],
+                    'pluginOptions' => [
+                        'allowClear' => true
+                    ],
+                ])->label(false) ?></div>
+            </div>
+            <div class="d-flex align-items-center justify-content-center gap-2">
+                <div class="mb-3" title="Автоматическое закрытие">Авт. закр.:</div>
+                <div style="display:inline-block"><?= $form->field($model, 'autoclosed')->checkbox([0 => 'unchecked', 1 => 'checked'], [])->label(false) ?></div>
+            </div>
+            <div class="mb-4"><?= Html::submitButton('Применить', ['class' => 'btn btn-secondary btn-sm'])?></div>
+            <div class="mb-4"><?= Html::a('Сбросить фильтр', '/timetable-fact/index', ['class' => 'btn btn-link btn-sm'])?></div>
         </div>
     </div>
 
-- 
2.39.5