/**
* 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;
}
}
