/** * @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; }