From cab4355fec9928639e688d096d9ad5e77cb28493 Mon Sep 17 00:00:00 2001
From: Christian Klinger
Date: Fri, 10 Jun 2016 17:19:50 +0200
Subject: first rough version of exams-module.

---
 modules-available/exams/inc/exams.inc.php | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 modules-available/exams/inc/exams.inc.php

(limited to 'modules-available/exams/inc/exams.inc.php')

diff --git a/modules-available/exams/inc/exams.inc.php b/modules-available/exams/inc/exams.inc.php
new file mode 100644
index 00000000..9e5833ba
--- /dev/null
+++ b/modules-available/exams/inc/exams.inc.php
@@ -0,0 +1,17 @@
+<?php
+
+class Exams {
+
+
+    /**
+     * @param: array of location ids
+     * @return: true iff for any of the given location ids an exam is scheduled
+     **/
+    public static function isInExamMode($locationIds) {
+        // TODO: Better use prepared statement
+        $l = '(' . implode(', ', $locationIds) . ')';
+        $res = Database::queryFirst("SELECT (COUNT(examid) > 0) as examMode FROM exams WHERE starttime < NOW() AND endtime > NOW() AND locationid IN $l", []);
+
+        return $res['examMode'];
+    }
+}
-- 
cgit v1.2.3-55-g7522