public function getBranchs() { if ($this->_branchs === null) { $this->_branchs = UserToBranch::find()->select('id_branch')->where(['id_user' => $this->owner->getId()])->column(); } return $this->_branchs; }
public function search($params) { $query = UserToBranchModel::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id_branch' => $this->id_branch, 'id_user' => $this->id_user]); return $dataProvider; }
protected function getUserProperties() { $properties = []; $userId = $this->owner->getId(); if ($userId !== null) { $properties = ['branchs' => UserToBranch::find()->select('id_branch')->where(['id_user' => $userId])->column()]; $properties['branch'] = \Yii::$app->getSession()->get('_branch_active'); $properties['branch'] = 1; } return $properties; }
public function actionChangeBranch() { $model = new DynamicModel(['selected' => Yii::$app->user->branch]); $model->addRule('selected', 'safe'); $ids = UserToBranch::find()->select('id_branch')->where(['id_user' => Yii::$app->user->id])->column(); $branchs = Branch::findAll(['id_branch' => $ids]); if ($model->load(Yii::$app->request->post())) { Yii::$app->user->branch = $model->selected; } return $this->render('change-branch', ['model' => $model, 'branchs' => $branchs]); }
public static function getBranchList($id_user = null) { if ($id_user === null) { return ArrayHelper::map(Branch::find()->all(), 'id_branch', 'nm_branch'); } else { $query = UserToBranch::find()->with('idBranch')->where(['user_id' => $id_user]); return ArrayHelper::map($query->all(), 'id_branch', 'idBranch.nm_branch'); } }