/** * @param string|integer $user the user ID. * @param Item $item the role or permission that this rule is associated with * @param array $params parameters passed to ManagerInterface::checkAccess(). * @return boolean a value indicating whether the rule permits the role or permission it is associated with. */ public function execute($user, $item, $params) { $areaPersonal = AreaPersonal::findOne($params['id_area'], $user); if ($areaPersonal != NULL) { return true; } return false; }
/** * 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; }
/** * Finds the AreaPersonal model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $area_id * @param string $user_id * @return AreaPersonal the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($area_id, $user_id) { if (($model = AreaPersonal::findOne(['area_id' => $area_id, 'user_id' => $user_id])) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
?> </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>
/** * @return \yii\db\ActiveQuery */ public function getAreaPersonals() { return $this->hasMany(AreaPersonal::className(), ['area_id' => 'id']); }
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); }