Blame view

models/BlogArticle.php 6.93 KB
37f80fd4   Yarik   first commit
1
2
3
4
  <?php
      
      namespace artweb\artbox\blog\models;
      
0194ad48   Yarik   Namespaces
5
      use artweb\artbox\behaviors\SaveImgBehavior;
65b3647f   Anastasia   event, blog, social
6
      use artweb\artbox\ecommerce\models\ProductVariant;
37f80fd4   Yarik   first commit
7
8
      use yii\behaviors\TimestampBehavior;
      use yii\db\ActiveRecord;
0194ad48   Yarik   Namespaces
9
10
11
      use artweb\artbox\language\behaviors\LanguageBehavior;
      use artweb\artbox\language\models\Language;
      use artweb\artbox\ecommerce\models\Product;
37f80fd4   Yarik   first commit
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
      use yii\db\ActiveQuery;
      use yii\web\Request;
      
      /**
       * This is the model class for table "blog_article".
       *
       * @property integer           $id
       * @property string            $image
       * @property integer           $created_at
       * @property integer           $updated_at
       * @property integer           $deleted_at
       * @property integer           $sort
       * @property boolean           $status
       * @property integer           $author_id
       * @property BlogArticleLang[] $blogArticleLangs
       * @property Language[]        $languages
       * @property BlogArticle[]     $relatedBlogArticles
       * @property BlogArticle[]     $blogArticles
       * @property BlogCategory[]    $blogCategories
5410d5a0   Yarik   Video and blog
31
       * @property BlogCategory      $blogCategory
37f80fd4   Yarik   first commit
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
       * @property Product[]         $products
       * @property BlogTag[]         $blogTags
       * * * From language behavior *
       * @property BlogArticleLang   $lang
       * @property BlogArticleLang[] $langs
       * @property BlogArticleLang   $objectLang
       * @property string            $ownerKey
       * @property string            $langKey
       * @property BlogArticleLang[] $modelLangs
       * @property bool              $transactionStatus
       * @method string           getOwnerKey()
       * @method void             setOwnerKey( string $value )
       * @method string           getLangKey()
       * @method void             setLangKey( string $value )
       * @method ActiveQuery      getLangs()
       * @method ActiveQuery      getLang( integer $language_id )
       * @method BlogArticleLang[]    generateLangs()
       * @method void             loadLangs( Request $request )
       * @method bool             linkLangs()
       * @method bool             saveLangs()
       * @method bool             getTransactionStatus()
       * * End language behavior *
       * * From SaveImgBehavior
       * @property string|null       $imageFile
       * @property string|null       $imageUrl
       * @method string|null getImageFile( int $field )
       * @method string|null getImageUrl( int $field )
       * * End SaveImgBehavior
       */
      class BlogArticle extends ActiveRecord
      {
65b3647f   Anastasia   event, blog, social
63
          public $products_file;
37f80fd4   Yarik   first commit
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'blog_article';
          }
          
          public function behaviors()
          {
              return [
                  [
                      'class' => TimestampBehavior::className(),
                  ],
                  [
                      'class'  => SaveImgBehavior::className(),
                      'fields' => [
                          [
                              'name'      => 'image',
                              'directory' => 'blog/article',
                          ],
                      ],
                  ],
                  'language' => [
                      'class' => LanguageBehavior::className(),
                  ],
              ];
          }
          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [
                      [
                          'created_at',
                          'updated_at',
                          'deleted_at',
                          'sort',
                          'author_id',
                      ],
                      'integer',
                  ],
                  [
                      [ 'status' ],
                      'boolean',
                  ],
                  [
                      [ 'image' ],
                      'string',
                      'max' => 255,
                  ],
65b3647f   Anastasia   event, blog, social
117
                  ['products_file', 'file']
37f80fd4   Yarik   first commit
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
              ];
          }
          
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [
                  'id'         => 'ID',
                  'image'      => 'Image',
                  'created_at' => 'Created At',
                  'updated_at' => 'Updated At',
                  'deleted_at' => 'Deleted At',
                  'sort'       => 'Sort',
                  'status'     => 'Status',
                  'author_id'  => 'Author ID',
              ];
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
37f80fd4   Yarik   first commit
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
          public function getRelatedBlogArticles()
          {
              return $this->hasMany(BlogArticle::className(), [ 'id' => 'related_blog_article_id' ])
                          ->viaTable('blog_article_to_article', [ 'blog_article_id' => 'id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getBlogArticles()
          {
              return $this->hasMany(BlogArticle::className(), [ 'id' => 'blog_article_id' ])
                          ->viaTable('blog_article_to_article', [ 'related_blog_article_id' => 'id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getBlogCategories()
          {
              return $this->hasMany(BlogCategory::className(), [ 'id' => 'blog_category_id' ])
                          ->viaTable('blog_article_to_category', [ 'blog_article_id' => 'id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
5410d5a0   Yarik   Video and blog
168
169
170
171
172
173
174
175
176
          public function getBlogCategory()
          {
              return $this->hasOne(BlogCategory::className(), [ 'id' => 'blog_category_id' ])
                          ->viaTable('blog_article_to_category', [ 'blog_article_id' => 'id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
37f80fd4   Yarik   first commit
177
178
179
180
181
182
183
184
185
186
187
188
189
190
          public function getProducts()
          {
              return $this->hasMany(Product::className(), [ 'id' => 'product_id' ])
                          ->viaTable('blog_article_to_product', [ 'blog_article_id' => 'id' ]);
          }
          
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getBlogTags()
          {
              return $this->hasMany(BlogTag::className(), [ 'id' => 'blog_tag_id' ])
                          ->viaTable('blog_article_to_tag', [ 'blog_article_id' => 'id' ]);
          }
65b3647f   Anastasia   event, blog, social
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
          
          public function saveProducts($file){
              set_time_limit(0);
      
      
              $handle =  fopen($file, 'r');
      
      
              while (($data = fgetcsv($handle, 1000, ";")) !== FALSE) {
                  if(isset($data[0])){
                      $product = ProductVariant::find()->where(['sku' => $data[0]])->joinWith('product')->one();
                      if($product instanceof  ProductVariant){
                          $this->link('products', $product);
                      }
                  }
          
              }
              fclose($handle);
              unlink($file);
      
          }
37f80fd4   Yarik   first commit
212
      }