/** * Retrieves a list of models based on the current search/filter conditions. * * Typical usecase: * - Initialize the model fields with values from filter form. * - Execute this method to get CActiveDataProvider instance which will filter * models according to data in model fields. * - Pass data provider to CGridView, CListView or any similar widget. * * @return CActiveDataProvider the data provider that can return the models * based on the search/filter conditions. */ public function search($params) { $query = DatabasesPerm::find(); $dataProvider = new \yii\data\ActiveDataProvider(['query' => $query, "sort" => ['defaultOrder' => []]]); //exit; $this->load($params); if (!$this->validate()) { var_dump($this->getErrors()); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'database_id' => $this->database_id, 'level_id' => $this->level_id]); //$sort->defaultOrder = 'issue_date DESC'; return $dataProvider; }
public function actionPermissions($id) { //$model= DatabasesPerm::findOne($id); $model = new DatabasesPerm(); $model->scenario = 'search'; //$model->unsetAttributes(); // clear any default values $model->database_id = $id; $user = new DatabasesPerm(); $user->database_id = $id; if ($user->load(Yii::$app->request->post())) { $user->save(); //if($model->save()) // $this->redirect(array('index')); } return $this->render('permissions', array('model' => $model, 'user' => $user)); }
/** * @return string the associated database table name */ public function getLevel() { $level = DatabasesPerm::findOne(array($this->id, Yii::$app->user->id)); return $level; }