public function init() { parent::init(); $view = $this->getView(); $module = Yii::$app->getModule("versioning"); $user_id = Yii::$app->user->id; $groups = \amilna\versioning\components\Libs::userGroups($user_id); $groups = [1]; $bundle = NotificationAsset::register($view); $this->bundle = $bundle; $searchModel = new VersionSearch(); $dataProvider = $searchModel->search([]); $query = $dataProvider->query; $query->andWhere([Version::tableName() . ".status" => true])->andWhere(Record::tableName() . ".record_id is not null"); if (count($this->models) > 0) { $query->andWhere([Record::tableName() . ".model" => $this->models])->andWhere(Record::tableName() . ".filter_viewers = false"); } if ($user_id > 0) { $query->andWhere("concat(','," . Record::tableName() . ".viewers,',') not like '%," . $user_id . ",%'")->andWhere(Record::tableName() . ".filter_viewers = false OR (" . Record::tableName() . ".filter_viewers = true AND (" . Record::tableName() . ".owner_id = :uid OR " . Record::tableName() . ".group_id in (" . implode(",", $groups) . ")) )", [":uid" => $user_id]); } else { $query->limit(10); } $query->orderBy(Route::tableName() . ".time DESC," . Version::tableName() . ".id DESC"); $script = "\t\t\n\t\t" . PHP_EOL; $view->registerJs($script); echo $this->render($this->viewPath, ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'module' => $module, 'widget' => $this]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = $this->find(); $query->joinWith(['record', 'route', 'route.user']); $dataProvider = new ActiveDataProvider(['query' => $query]); $userClass = Yii::$app->getModule('versioning')->userClass; /* uncomment to sort by relations table on respective column */ $dataProvider->sort->attributes['recordModel'] = ['asc' => ['concat(' . Record::tableName() . '.model,' . Record::tableName() . '.id)' => SORT_ASC], 'desc' => ['concat(' . Record::tableName() . '.model,' . Record::tableName() . '.id)' => SORT_DESC]]; $dataProvider->sort->attributes['time'] = ['asc' => ['' . Route::tableName() . '.time' => SORT_ASC], 'desc' => ['' . Route::tableName() . '.time' => SORT_DESC]]; $dataProvider->sort->attributes['routeUser'] = ['asc' => [$userClass::tableName() . '.username' => SORT_ASC], 'desc' => [$userClass::tableName() . '.username' => SORT_DESC]]; if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['status' => $this->status]); $params = self::queryNumber([['id', $this->tableName()], ['route_id'], ['record_id'], ['type'], ['isdel']]); foreach ($params as $p) { $query->andFilterWhere($p); } $params = self::queryString([['record_attributes']]); foreach ($params as $p) { $query->andFilterWhere($p); } $params = self::queryTime([['time', Route::tableName()]]); foreach ($params as $p) { $query->andFilterWhere($p); } $query->andFilterWhere(["like", "lower(concat(" . Record::tableName() . ".model,' '," . Record::tableName() . ".record_id))", strtolower($this->recordModel)]); $query->andFilterWhere(['like', 'lower(' . $userClass::tableName() . '.username)', strtolower($this->routeUser)]); /* example to use search all in field1,field2,field3 or field4 */ //print_r(self::mkArrQuery([["OR","lower(field1) like '%".strtolower($this->recordModel)."%'"],["OR","lower(field2) like '%".strtolower($this->recordModel)."%'"]])); //die(); /* 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; }