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