Blame view

common/models/Gallery.php 2.16 KB
6af5dbe3   Alexey Boroda   -Admin gallery ready
1
2
3
4
5
6
7
8
9
10
11
  <?php
      /**
       * Created by PhpStorm.
       * User: beer
       * Date: 28.09.17
       * Time: 12:38
       */
      
      namespace common\models;
      
      use artbox\core\models\Image;
40282c41   Alexey Boroda   -Image language f...
12
13
      use artbox\core\models\Language;
      use yii\db\ActiveQuery;
6af5dbe3   Alexey Boroda   -Admin gallery ready
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
      
      /**
       * Stub class Gallery
       * for holding gallery
       *
       * @package common\models
       */
      class Gallery
      {
          /**
           * @return array
           */
          public function getImages(): array
          {
              return Image::find()
                          ->where(
                              [
                                  'gallery' => true,
                              ]
                          )
40282c41   Alexey Boroda   -Image language f...
34
35
36
37
38
39
40
41
42
43
44
                          ->with(
                              [
                                  'lang' => function (ActiveQuery $query) {
                                      $query->andWhere(
                                          [
                                              'language_id' => Language::getCurrent()->id,
                                          ]
                                      );
                                  },
                              ]
                          )
6af5dbe3   Alexey Boroda   -Admin gallery ready
45
46
47
48
49
50
                          ->all();
          }
          
          /**
           * @param array $images
           */
5de17c7c   Alexey Boroda   -Gallery save fixed
51
          public function saveImages($images)
6af5dbe3   Alexey Boroda   -Admin gallery ready
52
          {
5de17c7c   Alexey Boroda   -Gallery save fixed
53
54
55
56
57
58
59
60
61
62
              \Yii::$app->db->createCommand()
                            ->update(
                                'ImageManager',
                                [
                                    'gallery' => false,
                                ],
                                '1 = 1'
                            )
                            ->execute();
              if (!empty($images)) {
6af5dbe3   Alexey Boroda   -Admin gallery ready
63
64
65
66
67
68
69
70
71
72
73
74
75
                  $condition = 'id IN (' . implode(',', $images) . ')';
                  \Yii::$app->db->createCommand()
                                ->update(
                                    'ImageManager',
                                    [
                                        'gallery' => true,
                                    ],
                                    $condition
                                )
                                ->execute();
              }
          }
      }