/**
* @return \yii\db\ActiveQuery
*/
public function getGroup()
{
return $this->hasOne(Group::className(), ['id' => 'group_id']);
}
public function attributeLabels()
{
return array_merge(parent::attributeLabels(), ['ownerUsername' => Yii::t('app', 'Owner')]);
}
/**
* Finds the Group model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Group the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Group::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = $this->find();
$query->joinWith(['owner', 'group']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$userClass = Yii::$app->getModule('versioning')->userClass;
/* uncomment to sort by relations table on respective column */
$dataProvider->sort->attributes['ownerUsername'] = ['asc' => [$userClass::tableName() . '.username' => SORT_ASC], 'desc' => [$userClass::tableName() . '.username' => SORT_DESC]];
$dataProvider->sort->attributes['groupTitle'] = ['asc' => ['' . Group::tableName() . '.title' => SORT_ASC], 'desc' => ['' . Group::tableName() . '.title' => SORT_DESC]];
$dataProvider->sort->attributes['recordModel'] = ['asc' => ['concat(' . Record::tableName() . '.model,' . Record::tableName() . '.id)' => SORT_ASC], 'desc' => ['concat(' . Record::tableName() . '.model,' . Record::tableName() . '.id)' => SORT_DESC]];
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['filter_viewers' => $this->filter_viewers]);
$params = self::queryNumber([['id', $this->tableName()], ['record_id'], ['owner_id', $this->tableName()], ['group_id'], ['isdel']]);
foreach ($params as $p) {
$query->andFilterWhere($p);
}
$params = self::queryString([['model'], ['viewers']]);
foreach ($params as $p) {
$query->andFilterWhere($p);
}
$query->andFilterWhere(['like', 'lower(' . $userClass::tableName() . '.username)', strtolower($this->ownerUsername)]);
$query->andFilterWhere(['like', 'lower(' . Group::tableName() . '.title)', strtolower($this->groupTitle)]);
$query->andFilterWhere(["like", "lower(concat(" . Record::tableName() . ".model,' '," . Record::tableName() . ".record_id))", strtolower($this->recordModel)]);
/* example to use search all in field1,field2,field3 or field4
if ($this->term)
{
$query->andFilterWhere(["OR","lower(field1) like '%".strtolower($this->term)."%'",
["OR","lower(field2) like '%".strtolower($this->term)."%'",
["OR","lower(field3) like '%".strtolower($this->term)."%'",
"lower(field4) like '%".strtolower($this->term)."%'"
]
]
]);
}
*/
return $dataProvider;
}
