/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = AreaPersonal::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $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; } $query->andFilterWhere(['area_id' => $this->area_id, 'user_id' => $this->user_id, 'permission' => $this->permission]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = AreaPersonal::find(); $query->joinWith('area'); $query->joinWith('user'); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['area_Name'] = ['asc' => ['areas.name' => SORT_ASC], 'desc' => ['areas.name' => SORT_DESC]]; $dataProvider->sort->attributes['user_Name'] = ['asc' => ['users.first_name' => SORT_ASC], 'desc' => ['users.first_name' => SORT_DESC]]; $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; } $query->andFilterWhere(['name' => $this->area_id, 'first_name' => $this->user_id, 'permission' => $this->permission])->andFilterWhere(['like', 'areas.name', $this->area_Name])->andFilterWhere(['like', 'user.first_name', $this->user_Name]); return $dataProvider; }
?> </td> <td class="skip-export kv-align-center kv-align-middle"> <?php $user = User::findOne($pers["user_id"]); echo $user->first_name; ?> </td> <td class="skip-export kv-align-center kv-align-middle"> <?php echo $user->lastname; ?> </td> <td class="skip-export kv-align-center kv-align-middle"> <?php $relationship = AreaPersonal::find()->where(['user_id' => $pers['user_id'], 'area_id' => $area->id])->one(); echo $relationship->permission; ?> </td> <td class="skip-export kv-align-center kv-align-middle"> <a data-toggle="modal" data-target="#permissionsModal" data-user-id="<?php echo $user->id; ?> " data-area-id="<?php echo $area->id; ?> "> <span data-toggle="tooltip" title="Modify permission" class="glyphicon glyphicon-pencil"></span> </a>
public function actionRemove($a_id, $u_id) { $model = AreaPersonal::find()->where(['user_id' => $u_id, 'area_id' => $a_id])->one(); $model->delete(); return $this->redirect('modify?id=' . $a_id); }