summaryrefslogblamecommitdiffstats
path: root/modules-available/exams/page.inc.php
blob: a6bd7e16f30364b9d6d4829bdd4551b0b41c3e63 (plain) (tree)
1
2
3
4
5
6
7
8
9



                             
                            


                            
                             

                          


                                                              
                                                                   
         
                                                 
                                    

                                                         
                        
                                                                                                                                                             



                                                                      
                 
                                                                   



                                      
                                                                                                                                                                                               



                                                                                                        

                                                 







                                                               
                                                                                                                                                       
                                             
                                                                                   
                                                                     
                                                                                                

                                                                  
                                                                                        
                                                                  
                                                     





                                            


                                                                                            








                                                                       
                 
                  

                                         




















                                                                                                         
                                 


                                      
                                                                                                             
                       



















                                                                                                                                        










                                                         

                                                                                          







                                                 
                              



                                                                         
                                                                          

                                                                   
                                                                         



                                                                                             
                         



                            



                                                

                                               












                                                                                          


                                                             

















                                                                                      
                                          
         
                                                                              

















                                                                                                                

                                                                          
                                                                      
                                                     


                                                                                                                                        
                                                   









                                                                                                                                  

                                                                                                                                                                                             





















                                                                                                                                                                              

                                                                                                                                                                                                       

















                                                                                                                                                                    







                                                                










                                                                                       



                                                    








                                                                                                                                            
                                              





























                                                                                                                         












                                                                                

                                                                                                 
                                   












                                                                                                  
                                                    
 
                                                                                  



                                                                                  
                                                                        


                                                                                                   
                                                                                  


                                                      
                                                
                         
                                                            



                                                                         
                                                     
 
                                                                                   
                                                                             





                                                                                                                                                     
 

                 

 
<?php

class Page_Exams extends Page
{
	var $action = false;
	var $exams = [];
	var $locations = [];
	var $lectures = [];
	private $currentExam;
	private $rangeMin;
	private $rangeMax;


	/** if examid is set, also add a column 'selected' **/
	protected function readLocations($examidOrLocations = null)
	{
		if ($examidOrLocations == null) {
			$active = 0;
		} elseif (is_array($examidOrLocations)) {
			$active = $examidOrLocations;
		} else {
			$tmp = Database::simpleQuery("SELECT locationid FROM exams_x_location WHERE examid= :examid", array('examid' => $examidOrLocations));
			$active = array();
			while ($row = $tmp->fetch(PDO::FETCH_ASSOC)) {
				$active[] = (int)$row['locationid'];
			}
		}
		$this->locations = Location::getLocations($active);
	}

	protected function readExams()
	{
		$tmp = Database::simpleQuery("SELECT e.examid, e.autologin, l.displayname AS lecturename, e.starttime, e.endtime, e.description, GROUP_CONCAT(exl.locationid) AS locationids, "
			. "GROUP_CONCAT(loc.locationname SEPARATOR ', ') AS locationnames FROM exams e "
			. "NATURAL LEFT JOIN exams_x_location exl "
			. "NATURAL LEFT JOIN location loc "
			. "LEFT JOIN sat.lecture l USING (lectureid) "
			. "GROUP BY examid "
			. "ORDER BY examid ASC");
		while ($exam = $tmp->fetch(PDO::FETCH_ASSOC)) {
			$this->exams[] = $exam;
		}
	}

	protected function readLectures()
	{
		$tmp = Database::simpleQuery(
			"SELECT lectureid, Group_Concat(locationid) as lids, displayname, starttime, endtime, isenabled, firstname, lastname, email " .
			"FROM sat.lecture " .
			"INNER JOIN sat.user ON (user.userid = lecture.ownerid) " .
			"NATURAL LEFT JOIN sat.lecture_x_location " .
			"WHERE isexam <> 0 AND starttime < :rangeMax AND endtime > :rangeMin " .
			"GROUP BY lectureid " .
			"ORDER BY starttime ASC, displayname ASC",
			['rangeMax' => $this->rangeMax, 'rangeMin' => $this->rangeMin]);
		while ($lecture = $tmp->fetch(PDO::FETCH_ASSOC)) {
			$this->lectures[] = $lecture;
		}
	}

	protected function makeItemsForVis()
	{
		$out = [];
		// foreach group also add an invisible item on top
		// disabled for now - more of an annoyance if you have more than a few rooms
		/*
		foreach ($this->locations as $l) {
			$out[] = ['id' => 'spacer_' . $l['locationid'],
				'group' => $l['locationid'],
				'className' => 'spacer',
				'start' => 0,
				'content' => 'spacer',
				'end' => 99999999999999,
				'subgroup' => 0
			];
		}
		*/
		$unique_ids = 1;
		/* add the red shadows */
		if (is_array($this->exams)) {
			foreach ($this->exams as $e) {
				if ($e['starttime'] > $this->rangeMax || $e['endtime'] < $this->rangeMin)
					continue;
				$locationids = explode(',', $e['locationids']);
				if ($locationids[0] == 0) {
					$locationids = [];
					foreach ($this->locations as $location) {
						$locationids[] = $location['locationid'];
					}
				}
				foreach ($locationids as $locationid) {
					$out[] = [
						'id' => 'shadow_' . $unique_ids++,
						'content' => $e['description'],
						'title' => $e['description'],
						'start' => intval($e['starttime']) * 1000,
						'end' => intval($e['endtime']) * 1000,
						'type' => 'background',
						'group' => $locationid,
					];
				}
			}
		}
		/* add the lectures */
		$allLocationIds = array_map(function($loc) { return $loc['locationid']; }, $this->locations);
		$i = 2;
		foreach ($this->lectures as $lecture) {
			$mark = '<span class="' . ($lecture['isenabled'] ? '' : 'glyphicon glyphicon-exclamation-sign') . '"></span>';
			if (empty($lecture['lids'])) {
				$locations = $allLocationIds;
			} else {
				$locations = explode(',', $lecture['lids']);
			}
			foreach ($locations as $location) {
				$out[] = [
					'id' => $lecture['lectureid'] . '/' . $location,
					'content' => htmlspecialchars($lecture['displayname']) . $mark,
					'title' => $lecture['isenabled'] ? '' : Dictionary::translate('warning_lecture_is_not_enabled'),
					'start' => intval($lecture['starttime']) * 1000,
					'end' => intval($lecture['endtime']) * 1000,
					'group' => $location,
					'className' => $lecture['isenabled'] ? '' : 'disabled',
					'editable' => false,
					'subgroup' => $i++,
				];
			}
		}

		return json_encode($out);
	}

	protected function makeGroupsForVis()
	{
		$out = [];
		foreach ($this->locations as $l) {
			$out[] = [
				'id' => $l['locationid'],
				'content' => $l['locationpad'] . ' ' . $l['locationname'],
				'sortIndex' => $l['sortIndex'],
			];
		}
		return json_encode($out);
	}

	protected function makeExamsForTemplate()
	{
		$out = [];
		$now = time();
		if (is_array($this->exams)) {
			foreach ($this->exams as $exam) {
				if ($exam['endtime'] < $now) {
					$exam['rowClass'] = 'text-muted';
					$exam['btnClass'] = 'btn-default';
					$exam['liesInPast'] = true;
				} else {
					$exam['btnClass'] = 'btn-danger';
				}
				$exam['starttime_s'] = date('Y-m-d H:i', $exam['starttime']);
				$exam['endtime_s'] = date('Y-m-d H:i', $exam['endtime']);
				$out[] = $exam;
			}
		}
		return $out;
	}

	protected function makeLectureExamList()
	{
		$out = [];
		$now = time();
		$cutoff = strtotime('+30 day');
		$theCount = 0;
		foreach ($this->lectures as $lecture) {
			if ($lecture['endtime'] < $now || $lecture['starttime'] > $cutoff)
				continue;
			$entry = $lecture;
			if (!$lecture['isenabled']) {
				$entry['class'] = 'text-muted';
			}
			$entry['starttime_s'] = date('Y-m-d H:i', $lecture['starttime']);
			$entry['endtime_s'] = date('Y-m-d H:i', $lecture['endtime']);
			$duration = $lecture['endtime'] - $lecture['starttime'];
			if ($duration < 86400) {
				$entry['duration_s'] = gmdate('H:i', $duration);
			}
			if (++$theCount > 5) {
				$entry['class'] = 'collapse';
			}
			$out[] = $entry;
		}
		return $out;
	}
	
	protected function makeEditFromArray($source)
	{
		if (!isset($source['description']) && isset($source['displayname'])) {
			$source['description'] = $source['displayname'];
		}
		return [
			'starttime_date' => date('Y-m-d', $source['starttime']),
			'starttime_time' => date('H:i', $source['starttime']),
			'endtime_date' => date('Y-m-d', $source['endtime']),
			'endtime_time' => date('H:i', $source['endtime'])
		] + $source;
	}

	private function isDateSane($time)
	{
		return ($time >= $this->rangeMin && $time <= $this->rangeMax);
	}

	private function saveExam()
	{
		if (!Request::isPost()) {
			Util::traceError('Is not post');
		}
		/* process form-data */
		$locationids = Request::post('locations', [], "ARRAY");

		/* global room has id 0 */
		if (empty($locationids)) {
			$locationids[] = 0;
		}

		$examid = Request::post('examid', 0, 'int');
		$starttime = strtotime(Request::post('starttime_date') . " " . Request::post('starttime_time'));
		$endtime = strtotime(Request::post('endtime_date') . " " . Request::post('endtime_time'));
		$description = Request::post('description', '', 'string');
		$lectureid = Request::post('lectureid', '', 'string');
		$autologin = Request::post('autologin', '', 'string');
		if (!$this->isDateSane($starttime)) {
			Message::addError('starttime-invalid', Request::post('starttime_date') . " " . Request::post('starttime_time'));
			Util::redirect('?do=exams');
		}
		if (!$this->isDateSane($endtime)) {
			Message::addError('endtime-invalid', Request::post('endtime_date') . " " . Request::post('endtime_time'));
			Util::redirect('?do=exams');
		}
		if ($endtime <= $starttime) {
			Message::addError('end-before-start');
			Util::redirect('?do=exams');
		}

		if ($examid === 0) {
			// No examid given, is add
			$res = Database::exec("INSERT INTO exams(lectureid, starttime, endtime, autologin, description) VALUES(:lectureid, :starttime, :endtime, :autologin, :description);",
					compact('lectureid', 'starttime', 'endtime', 'autologin', 'description')) !== false;

			$exam_id = Database::lastInsertId();
			foreach ($locationids as $lid) {
				$res = $res && Database::exec("INSERT INTO exams_x_location(examid, locationid) VALUES(:exam_id, :lid)", compact('exam_id', 'lid')) !== false;
			}
			if ($res === false) {
				Message::addError('exam-not-added');
			} else {
				Message::addInfo('exam-added-success');
			}
			Util::redirect('?do=exams');
		}

		// Edit

		$this->currentExam = Database::queryFirst("SELECT * FROM exams WHERE examid = :examid", array('examid' => $examid));
		if ($this->currentExam === false) {
			Message::addError('invalid-exam-id', $examid);
			Util::redirect('?do=exams');
		}

		/* update fields */
		$res = Database::exec("UPDATE exams SET lectureid = :lectureid, starttime = :starttime, endtime = :endtime, autologin = :autologin, description = :description WHERE examid = :examid",
				compact('lectureid', 'starttime', 'endtime', 'description', 'examid', 'autologin')) !== false;
		/* drop all connections and reconnect to rooms */
		$res = $res && Database::exec("DELETE FROM exams_x_location WHERE examid = :examid", compact('examid')) !== false;
		/* reconnect */
		foreach ($locationids as $lid) {
			$res = $res && Database::exec("INSERT INTO exams_x_location(examid, locationid) VALUES(:examid, :lid)", compact('examid', 'lid')) !== false;
		}
		if ($res !== false) {
			Message::addInfo("changes-successfully-saved");
		} else {
			Message::addError("error-while-saving-changes");
		}
		Util::redirect('?do=exams');
	}

	protected function doPreprocess()
	{
		User::load();

		if (!User::hasPermission('superadmin')) {
			Message::addError('main.no-permission');
			Util::redirect('?do=Main');
		}

		$this->rangeMin = strtotime('-1 day');
		$this->rangeMax = strtotime('+3 month');

		$req_action = Request::any('action', 'show');
		if (in_array($req_action, ['show', 'add', 'delete', 'edit', 'save'])) {
			$this->action = $req_action;
		}

		if ($this->action === 'show') {

			$this->readExams();
			$this->readLocations();
			$this->readLectures();

		} elseif ($this->action === 'add') {

			$this->readLectures();

		} elseif ($this->action === 'edit') {

			$examid = Request::get('examid', 0, 'int');
			$this->currentExam = Database::queryFirst("SELECT * FROM exams WHERE examid = :examid", array('examid' => $examid));
			if ($this->currentExam === false) {
				Message::addError('invalid-exam-id', $examid);
				Util::redirect('?do=exams');
			}
			$this->readLocations($examid);
			$this->readLectures();

		} elseif ($this->action === 'save') {

			$this->saveExam();

		} elseif ($this->action === 'delete') {

			if (!Request::isPost()) {
				die('delete only works with a post request');
			}
			$examid = Request::post('examid');
			$res = Database::exec("DELETE FROM exams WHERE examid = :examid;", compact('examid'));
			$res = Database::exec("DELETE FROM exams_x_location WHERE examid = :examid;", compact('examid'));
			if ($res === false) {
				Message::addError('exam-not-deleted-error');
			} else {
				Message::addInfo('exam-deleted-success');
			}
			Util::redirect('?do=exams');

		} elseif ($this->action === false) {

			Util::traceError("action not implemented");

		}
	}

	protected function doRender()
	{
		if ($this->action === "show") {

			// General title and description
			Render::addTemplate('page-main-heading');
			// List of defined exam periods
			Render::addTemplate('page-exams', [
					'exams' => $this->makeExamsForTemplate()
			]);
			// List of upcoming lectures marked as exam
			$upcoming = $this->makeLectureExamList();
			if (empty($upcoming)) {
				Message::addInfo('no-upcoming-lecture-exams');
			} else {
				Render::addTemplate('page-upcoming-lectures', [
					'pending_lectures' => $upcoming,
					'decollapse' => array_key_exists('class', end($upcoming))
				]);
			}
			// Vis.js timeline
			Render::addTemplate('page-exams-vis', [
				'exams_json' => $this->makeItemsForVis(),
				'rooms_json' => $this->makeGroupsForVis(),
				'vis_begin' => strtotime('-5 minute') * 1000,
				'vis_end' => strtotime('+2 day') * 1000,
				'vis_min_date' => $this->rangeMin * 1000,
				'vis_max_date' => $this->rangeMax * 1000,
				'axis_label' => (count($this->locations) > 5 ? 'both' : 'bottom'),
				'utc_offset' => date('P')
			]);

		} elseif ($this->action === "add") {

			Render::setTitle(Dictionary::translate('title_add-exam'));
			$data = [];
			$baseLecture = Request::any('lectureid', false, 'string');
			$locations = null;
			if ($baseLecture !== false) {
				foreach ($this->lectures as &$lecture) {
					if ($lecture['lectureid'] === $baseLecture) {
						$data['exam'] = $this->makeEditFromArray($lecture);
						$locations = explode(',', $lecture['lids']);
						$lecture['selected'] = 'selected';
						break;
					}
				}
				unset($lecture);
			}
			$data['lectures'] = $this->lectures;
			$this->readLocations($locations);
			$data['locations'] = $this->locations;
			Render::addTemplate('page-add-edit-exam', $data);

		} elseif ($this->action === 'edit') {

			Render::setTitle(Dictionary::translate('title_edit-exam'));
			$exam = $this->makeEditFromArray($this->currentExam);
			foreach ($this->lectures as &$lecture) {
				if ($lecture['lectureid'] === $this->currentExam['lectureid']) {
					$lecture['selected'] = 'selected';
				}
			}
			Render::addTemplate('page-add-edit-exam', ['exam' => $exam, 'locations' => $this->locations, 'lectures' => $this->lectures]);

		}
	}

}