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 actionListsocialmedia() { $model = new User(); $inputs = array(); if ($model->load(\Yii::$app->getRequest()->getBodyParams(), '')) { $inputs = \Yii::$app->getRequest()->getBodyParams(); } $query = new Query(); $jointype = "LEFT OUTER JOIN"; $query->select('user.username,user_socialmedia.*,socialmedia.*,socialmedia_platform.*')->from('user')->join($jointype, 'user_socialmedia', 'user.id=user_socialmedia.id')->join($jointype, 'socialmedia', 'user_socialmedia.sm_id=socialmedia.sm_id')->join($jointype, 'socialmedia_platform', 'socialmedia.sp_id=socialmedia_platform.sp_id'); $query->where(['user.id' => $inputs['user_id']]); $command = $query->createCommand(); $data = $command->queryAll(); return $data; }