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; }
/** * Finds the UserToBranch model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id_branch * @param integer $id_user * @return UserToBranch the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id_branch, $id_user) { if (($model = UserToBranch::findOne(['id_branch' => $id_branch, 'id_user' => $id_user])) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
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'); } }