public function addTeacherToСourse($course_id, $teachers)
{
$smnt = MyDatabase::db()->prepare('
DELETE FROM course_user
WHERE course_user.is_admin = 1 AND course_user.course_id = :course_id;
DELETE FROM course_user
WHERE course_user.course_id = :course_id AND course_user.user_id IN (:teacher);
');
try {
$smnt->execute(array('teacher' => implode(',', $teachers), 'course_id' => $course_id));
$smnt->closeCursor();
} catch (PDOException $ex) {
return false;
}
$smnt2 = MyDatabase::db()->prepare('
INSERT INTO course_user(user_id,course_id,is_admin)
VALUES(:user_id,:course_id,1)');
foreach ($teachers as $teacher) {
try {
$smnt2->execute(array('user_id' => $teacher, 'course_id' => $course_id));
} catch (PDOException $ex) {
return false;
}
}
return true;
}
public function reportBestUniversityForScale($scale)
{
try {
$smnt = MyDatabase::db()->prepare("call procedure_report_{$scale}_best_university()");
$smnt->execute();
return $smnt->fetchAll();
} catch (Exception $e) {
return null;
}
}
public function reportNewUserForScale($scale)
{
try {
$smnt = MyDatabase::db()->prepare(" call procedure_report_new_user_{$scale}()");
$smnt->execute();
return $smnt->fetchAll();
} catch (Exception $e) {
return null;
}
}
public function findAllAsArrayForFrontendPersonal($user_id)
{
try {
$smnt = MyDatabase::db()->prepare(" SELECT table2.*\nFrom course_user\nINNER JOIN\n(\nSelect `course`.`id` AS `id` , `course`.title as `title` ,\n`course_original_type`.`title` as `type`, `university`.`title` as `university`,\nCOUNT(`User`.`id`) as `counts`\nFROM `course`\nINNER JOIN `course_original_course` ON `course_original_course`.`id` = `course`.`original_course_id`\nINNER JOIN university ON university.id = course_original_course.university_id\nINNER JOIN course_original_type ON course_original_type.id = course_original_course.type_id\nLEFT JOIN course_user ON course.id = course_user.course_id\nLEFT JOIN `User` ON course_user.user_id = User.id\nGROUP BY course.id, course.title, course_original_type.title, university.title\n ) as table2\nON course_user.course_id = table2.id\nWHERE course_user.user_id = :user_id");
$smnt->execute(array('user_id' => $user_id));
return $smnt->fetchAll();
} catch (Exception $e) {
return null;
}
}