/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Files::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 20], 'sort' => ['defaultOrder' => ['updated_at' => SORT_DESC, 'file_id' => SORT_ASC]]]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$filesType = \Yii::$app->controller->module->acceptedFilesType;
$mime_type = isset($filesType[$this->mime_type]) ? $filesType[$this->mime_type] : $this->mime_type;
$query->andFilterWhere(['mime_type' => $mime_type, 'folder_id' => $this->folder_id]);
if (!empty($this->tags)) {
$tagKeyword = $this->tags;
$this->tags = [];
$query->joinWith(['filesRelationships' => function ($query) use($tagKeyword) {
$query->joinWith(['tag' => function ($query) use($tagKeyword) {
foreach ($tagKeyword as $tkey) {
$query->orFilterWhere(['like', 'value', $tkey]);
}
}], true, 'INNER JOIN');
}], false, 'INNER JOIN');
foreach ($tagKeyword as $tkey) {
$this->tags[$tkey] = $tkey;
}
}
$query->andFilterWhere(['OR', ['like', 'src_file_name', $this->keywords], ['like', 'caption', $this->keywords], ['like', 'alt_text', $this->keywords], ['like', 'description', $this->keywords]]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFile()
{
return $this->hasOne(Files::className(), ['file_id' => 'file_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFiles()
{
return $this->hasMany(Files::className(), ['folder_id' => 'folder_id']);
}
