diff options
Diffstat (limited to 'lib/classes/admission/AdmissionPriority.class.php')
| -rw-r--r-- | lib/classes/admission/AdmissionPriority.class.php | 253 |
1 files changed, 0 insertions, 253 deletions
diff --git a/lib/classes/admission/AdmissionPriority.class.php b/lib/classes/admission/AdmissionPriority.class.php deleted file mode 100644 index 47e1564..0000000 --- a/lib/classes/admission/AdmissionPriority.class.php +++ /dev/null @@ -1,253 +0,0 @@ -<?php -/** - * AdmissionPriority.class.php - * - * This class represents priorities a user has given to a set of courses. - * No instance is needed, all methods are designed to be called statically. - * - * This program is free software; you can redistribute it and/or - * modify it under the terms of the GNU General Public License as - * published by the Free Software Foundation; either version 2 of - * the License, or (at your option) any later version. - * - * @author Thomas Hackl <thomas.hackl@uni-passau.de> - * @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2 - * @category Stud.IP - */ -class AdmissionPriority -{ - /** - * Get all priorities for the given course set. - * The priorities are stored in a 2-dimensional array in the form - * priority[user_id][course_id] = x. - * - * @param String $courseSetId - * @return A 2-dimensional array containing all priorities. - */ - public static function getPriorities($courseSetId) - { - $query = "SELECT p.`user_id`, p.`seminar_id`, p.`priority` - FROM `priorities` AS p - JOIN `seminare` AS s ON (p.`seminar_id` = s.`Seminar_id`) - WHERE p.`set_id` = ?"; - $stmt = DBManager::get()->prepare($query); - $stmt->execute([$courseSetId]); - - $priorities = []; - while ($current = $stmt->fetch(PDO::FETCH_ASSOC)) { - $priorities[$current['user_id']][$current['seminar_id']] = $current['priority']; - } - return $priorities; - } - - /** - * Get all priorities for the given course in the given course set. - * The priorities are stored in an array in the form - * priority[user_id] = x. - * - * @param String $courseSetId - * @param String $courseId - * @return An array containing all priorities. - */ - public static function getPrioritiesByCourse($courseSetId, $courseId) - { - $query = "SELECT p.`user_id`, p.`priority` - FROM `priorities` AS p - JOIN `seminare` AS s ON (p.`seminar_id` = s.`Seminar_id`) - WHERE p.`set_id` = ? AND p.`seminar_id` = ?"; - $stmt = DBManager::get()->prepare($query); - $stmt->execute([$courseSetId, $courseId]); - - $priorities = []; - while ($current = $stmt->fetch(PDO::FETCH_ASSOC)) { - $priorities[$current['user_id']] = $current['priority']; - } - return $priorities; - } - - /** - * Get all priorities the given user has set in the given course set. - * The priorities are stored in an array in the form - * priority[course_id] = x. - * - * @param String $courseSetId - * @param String $userId - * @return An array containing all priorities. - */ - public static function getPrioritiesByUser($courseSetId, $userId) - { - $query = "SELECT p.`seminar_id`, p.`priority` - FROM `priorities` AS p - JOIN `seminare` AS s ON (p.`seminar_id` = s.`Seminar_id`) - WHERE p.`set_id` = ? AND p.`user_id` = ? - ORDER BY p.`priority`"; - $stmt = DBManager::get()->prepare($query); - $stmt->execute([$courseSetId, $userId]); - - $priorities = []; - while ($current = $stmt->fetch(PDO::FETCH_ASSOC)) { - $priorities[$current['seminar_id']] = $current['priority']; - } - return $priorities; - } - - /** - * The given user sets a course in the given course set to priority x. - * - * @param String $courseSetId - * @param String $userId - * @param String $courseId - * @param int $priority - * @return int Number of affected rows, if any. - */ - public static function setPriority($courseSetId, $userId, $courseId, $priority) - { - $query = "INSERT INTO `priorities` ( - `user_id`, `set_id`, `seminar_id`, `priority`, `mkdate`, `chdate` - ) - SELECT ?, ?, `seminare`.`seminar_id`, ?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP() - FROM `seminare` INNER JOIN `seminar_courseset` USING(`seminar_id`) - WHERE `seminare`.`seminar_id` = ? AND `set_id` = ? - ON DUPLICATE KEY - UPDATE `priority` = VALUES(`priority`), - `chdate` = VALUES(`chdate`)"; - $stmt = DBManager::get()->prepare($query); - $stmt->execute([(string)$userId, (string)$courseSetId, (int)$priority, (string)$courseId, (string)$courseSetId]); - - $ok = $stmt->rowCount(); - if ($ok) { - StudipLog::log( - 'SEM_USER_ADD', $courseId, $userId, - 'Anmeldung zur Platzvergabe', - sprintf('Prio: %s Anmeldeset: %s', $priority, $courseSetId) - ); - NotificationCenter::postNotification( - 'UserAdmissionPriorityDidCreate', $courseId, $userId - ); - } - return $ok; - } - - /** - * unset priority for given user,set and course - * reorder remaining priorities - * - * @param String $courseSetId - * @param String $userId - * @param String $courseId - * @return int Number of affected rows, if any. - */ - public static function unsetPriority($courseSetId, $userId, $courseId) - { - $query = "DELETE FROM `priorities` - WHERE `user_id` = ? AND `seminar_id` = ? AND `set_id` = ? - LIMIT 1"; - $deleted = DBManager::get()->execute($query, [$userId, $courseId, $courseSetId]); - if (!$deleted) { - return 0; - } - - $priovar = md5($courseSetId . $userId); - DBManager::get()->exec("SET @{$priovar} := 0"); - - $query = "UPDATE `priorities` - SET `priority` = (@{$priovar} := @{$priovar} + 1) - WHERE `user_id` = ? AND `set_id` = ? - ORDER BY `priority`"; - DBManager::get()->execute($query, [$userId, $courseSetId]); - - StudipLog::log( - 'SEM_USER_DEL', $courseId, $userId, - 'Anmeldung zur Platzvergabe zurückgezogen', - sprintf('Anmeldeset: %s', $courseSetId) - ); - NotificationCenter::postNotification( - 'UserAdmissionPriorityDidDelete', $courseId, $userId - ); - - return $deleted; - } - - /** - * delete all priorities for one set - * - * @param String $courseSetId - * @return int Number of affected rows, if any. - */ - public static function unsetAllPriorities($courseSetId) - { - $query = "DELETE FROM `priorities` WHERE `set_id` = ?"; - return DBManager::get()->execute($query, [$courseSetId]); - } - - /** - * delete all priorities for one set and one user - * - * @param String $courseSetId - * @param String $userId - * @return int Number of affected rows, if any. - */ - public static function unsetAllPrioritiesForUser($courseSetId, $userId) - { - $query = "DELETE FROM `priorities` - WHERE `user_id` = ? AND `set_id` = ?"; - return DBManager::get()->execute($query, [$userId, $courseSetId]); - } - - /** - * returns statistics of priority selection for a set - * - * @param String $courseSetId - * @return array stats grouped by course id - */ - public static function getPrioritiesStats($courseSetId) - { - $query = "SELECT p.`seminar_id`, - COUNT(*) AS c, - AVG(p.`priority`) AS a, - COUNT(IF(p.`priority` = 1, 1, NULL)) AS h - FROM `priorities` AS p - JOIN `seminare` AS s ON (p.`seminar_id` = s.`Seminar_id`) - WHERE p.`set_id` = ? - GROUP BY p.`seminar_id`"; - return DBManager::get()->fetchGrouped($query, [$courseSetId]); - } - - /** - * returns number of users with priorities for a set - * - * @param String $courseSetId - * @return integer - */ - public static function getPrioritiesCount($courseSetId) - { - $query = "SELECT COUNT(DISTINCT `user_id`) - FROM `priorities` - WHERE `set_id` = ?"; - return (int) DBManager::get()->fetchColumn($query, [$courseSetId]); - } - - /** - * return max chosen priority in set - * - * @param String $courseSetId - * @return integer - */ - public static function getPrioritiesMax($courseSetId) - { - $query = "SELECT MAX(`priority`) FROM `priorities` WHERE `set_id` = ?"; - return (int) DBManager::get()->fetchColumn($query, [$courseSetId]); - } - - /** - * delete all priorities for one course - * - * @param String $course_id - * @return int Number of affected rows, if any. - */ - public static function unsetAllPrioritiesForCourse($course_id) - { - $query = "DELETE FROM `priorities` WHERE `seminar_id` = ?"; - return DBManager::get()->execute($query, [$course_id]); - } -} |