/** * Finds user by [[username]] * * @return User|null */ public function getUser() { if ($this->_user === false) { $this->_user = User::findByUsername($this->username); } return $this->_user; }
public function actionView($id = 0) { if (!empty($id)) { header("Content-Type:application/json", true, 200); $user = User::find()->joinWith("woouserdata")->where(['user.id' => $id])->asArray()->one(); Yii::$app->response->format = "json"; $json = json_encode(['user' => $user]); return $json; } }
/** * @return \yii\db\ActiveQuery */ public function getUser() { return $this->hasOne(User::className(), ['id' => 'id']); }
/** * @return \yii\db\ActiveQuery */ public function getUsers() { return $this->hasMany(User::className(), ['pi_id' => 'pi_id']); }
/** * @return \yii\db\ActiveQuery */ public function getUserId1() { return $this->hasOne(User::className(), ['id' => 'user_id_1']); }
public function actionSearchallusers() { $model = new User(); $inputs = array(); if ($model->load(\Yii::$app->getRequest()->getBodyParams(), '')) { $inputs = \Yii::$app->getRequest()->getBodyParams(); $fields = array('pi_name', 'user.pi_id', 'course_name', 'course_code', 'inst_name', 'inst_code', 'ei_graduation_year', 'pi_email_1', 'pi_title', 'pi_company'); $order = array('inst_name' => 'asc', 'course_name' => 'asc', 'ei_graduation_year' => 'asc', 'pi_name' => 'asc'); $uni_id = empty($inputs['uni_id']) ? null : $inputs['uni_id']; $courses_id = empty($inputs['courses']) ? null : $inputs['courses']; $ei_graduation_year = empty($inputs['years']) ? null : $inputs['years']; $filter = array(); if ($uni_id != null) { $filter['uni_id'] = $uni_id; } if ($courses_id != null) { $filter['course.course_id'] = $courses_id; } if ($ei_graduation_year != null) { $filter['ei_graduation_year'] = $ei_graduation_year; } $user = User::findAllUsersInfo($fields, $filter, $order); return $user; } }
public function actionDeletesocialmedia() { // delete on socialmedia table $model = new SocialMedia(); $inputs = array(); if ($model->load(\Yii::$app->getRequest()->getBodyParams(), '')) { $inputs = \Yii::$app->getRequest()->getBodyParams(); $model = User::find($inputs); if ($model->delete()) { //delete on user_socialmedia table //$db->createCommand()->delete('user_socialmedia', ['sm_id'=>$inputs])->execute(); //$userSocialmedia = new UserSocialmedia::deleteAll(['sm_id'=>$inputs]); } return $userSocialmedia; } }