/**
  * @param array|null $params
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = SourceMessage::find();
     $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
     // check and populate params
     if (!($this->load($params) && $this->validate())) {
         $query->joinWith(['messages']);
         return $dataProvider;
     }
     if ($this->status == static::STATUS_TRANSLATED) {
         $query->translated();
     }
     if ($this->status == static::STATUS_NOT_TRANSLATED) {
         $query->notTranslated();
     }
     if ($this->status == static::STATUS_DELETED) {
         $query->deleted();
     }
     // search with related table
     // @see http://www.yiiframework.com/wiki/621/filter-sort-by-calculated-related-fields-in-gridview-yii-2-0/
     if (!empty($this->translation)) {
         $query->joinWith(['messages' => function ($q) {
             $q->where(['like', Message::tableName() . '.translation', $this->translation]);
         }]);
     }
     $query->andFilterWhere(['like', 'category', $this->category])->andFilterWhere(['like', 'message', $this->message]);
     return $dataProvider;
 }
Example #2
0
 /**
  * @return array|SourceMessage[]
  */
 public static function getCategories()
 {
     return SourceMessage::find()->select('category')->distinct('category')->asArray()->all();
 }
Example #3
0
 public function actionFlush()
 {
     $tableNames = [Message::tableName(), SourceMessage::tableName()];
     $db = Yii::$app->getDb();
     foreach ($tableNames as $tableName) {
         $db->createCommand()->delete($tableName)->execute();
     }
     echo PHP_EOL . 'Done.' . PHP_EOL;
 }