public function actionGetnumberofrowsbrowse()
{
$model = new PersonalInformation();
if ($model->load(\Yii::$app->getRequest()->getBodyParams(), '')) {
$result = \Yii::$app->getRequest()->getBodyParams();
$a = array();
$b = array();
foreach ($result as $key => $value) {
$a[] = $value['course_id'];
$b[] = $value['ei_graduation_year'];
}
$s = sizeof($a);
$k = "";
//course_id
$x = 0;
foreach ($a as $aa) {
if ($s - 1 == $x) {
$k .= '(' . $a[$x] . ',' . $b[$x] . ')';
} else {
$k .= '(' . $a[$x] . ',' . $b[$x] . ')' . ',';
}
$x++;
}
$students = new PersonalInformation();
//$query="SELECT pi_id,pi_name,pi_hp FROM personal_information LIMIT $from,1";
$query = "SELECT personal_information.pi_id, personal_information.pi_name, personal_information.pi_hp FROM user INNER JOIN personal_information ON user.pi_id = personal_information.pi_id" . " INNER JOIN user_education ON user.id=user_education.id " . "INNER JOIN education_information ON user_education.ei_id=education_information.ei_id" . " WHERE (education_information.course_id,education_information.ei_graduation_year) IN ({$k})";
$students = PersonalInformation::findBySql($query)->all();
return $students;
}
}
