###########
function getCalendar($idList) {
//// Build SQL query for multiple ids.
$query = "SELECT locationid, l.serverid AS serverid, serverurl, servertype, credentials FROM `location_info` as l LEFT JOIN setting_location_info as s ON s.serverid = l.serverid WHERE locationid IN (";
$query .= implode(",", $idList);
$query .= ") AND l.serverid = s.serverid ORDER BY servertype ASC, locationid ASC";
$dbquery = Database::simpleQuery($query);
$serverList = array();
$first = true;
$lastservertype = "";
while($dbresult=$dbquery->fetch(PDO::FETCH_ASSOC)) {
if (!isset($serverList[$dbresult['serverid']])) {
$serverList[$dbresult['serverid']] = array('credentials' => json_decode($dbresult['credentials'], true), 'url' => $dbresult['serverurl'], 'type' => $dbresult['servertype'], 'idlist' => array());
}
$serverList[$dbresult['serverid']]['idlist'][] = $dbresult['locationid'];
}
$resultarray = array();
foreach ($serverList as $serverid => $server) {
$serverInstance = CourseBackend::getInstance($server['type']);
$serverInstance->setCredentials($server['credentials'], $server['url'], $serverid);
echo $serverInstance->getError();
$calendarFromBackend = $serverInstance->fetchSchedule($server['idlist']);
$formattedArray = array();
if ($calendarFromBackend === false) {
// TODO: write error in db.
}
foreach ($calendarFromBackend as $key => $value) {
$y['id'] = $key;
$y['calendar'] = $value;
$formattedArray[] = $y;
}
$resultarray = array_merge($resultarray, $formattedArray);
}
return json_encode($resultarray, true);
}
// ########## ##########
// ################# OLD CALENDAR STUFF ########################################
/*
function randomCalendarGenerator() {
$randNum = rand(3, 7);
$result = array();
for ($i = 0; $i < $randNum; $i++) {
$c = array();
$c['title'] = getRandomWord();
$randH = rand(8, 16);
$rand2 = $randH + 2;
$date = getdate();
$mday = $date['mday'] + $i;
$todays = $date['year'] . "-" . $date['month'] . "-" . $mday . " " . $randH . ":00:00";
$c['start'] = $todays;
$todaye = $date['year'] . "-" . $date['month'] . "-" . $mday . " " . $rand2 . ":00:00";
$c['end'] = $todaye;
$result[] = $c;
}
return json_encode($result);
}
function getRandomWord($len = 10) {
$word = array_merge(range('a', 'z'), range('A', 'Z'));
shuffle($word);
return substr(implode($word), 0, $len);
}
// TODO FILTER 2 weeks or some days only
function getCalendars($ids) {
$idList = getMultipleInformations($ids);
$calendars = array();
foreach ($idList as $id) {
$a['id'] = $id;
$a['calendar'] = json_decode(getCalendar($id), true);
$calendars[] = $a;
}
echo json_encode($calendars);
}
function getCalendar($getRoomID) {
// TODO GET AND RETURN THE ACTUAL calendar
//echo randomCalendarGenerator();
$dbquery = Database::simpleQuery("SELECT calendar, lastcalendarupdate, serverid, serverroomid FROM `location_info` WHERE locationid=:locationID", array('locationID' => $getRoomID));
$calendar;
$lastupdate;
$serverid;
$serverroomid;
while($dbresult=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$lastupdate = (int) $dbresult['lastcalendarupdate'];
$calendar = $dbresult['calendar'];
$serverid = $dbresult['serverid'];
$serverroomid = $dbresult['serverroomid'];
}
$NOW = time();
if ($lastupdate == 0 || $NOW - $lastupdate > 900) {
return updateCalendar($getRoomID, $serverid, $serverroomid);
} else {
return $calendar;
}
}
function updateCalendar($locationid, $serverid, $serverroomid) {
// TODO CALL UpdateCalendar($serverid, $serverroomid);
$result = randomCalendarGenerator();
// ^ replace with the actual call
// Save in db and update timestamp
$NOW = time();
Database::exec("UPDATE `location_info` Set calendar=:calendar, lastcalendarupdate=:now WHERE locationid=:id", array('id' => $locationid, 'calendar' => $result, 'now' => $NOW));
return $result;
}
*/
// ########################################################################
function getPcStates($idList) {
$pcStates = array();
$roominfoList = json_decode(getRoomInfo($idList), true);
foreach ($roominfoList as $roomInfo) {
$result['id'] = $roomInfo['id'];
$idle = 0;
$occupied = 0;
$off = 0;
$broken = 0;
foreach ($roomInfo['computer'] as $computer) {
if ($computer['pcState'] == 0) {
$idle++;
} elseif($computer['pcState'] == 1) {
$occupied++;
} elseif($computer['pcState'] == 2) {
$off++;
} elseif($computer['pcState'] == 3) {
$broken++;
}
}
$result['idle'] = $idle;
$result['occupied'] = $occupied;
$result['off'] = $off;
$result['broken'] = $broken;
$pcStates[] = $result;
}
return json_encode($pcStates);
}
function getRoomTree($ids) {
$idList = getMultipleInformations($ids);
$idList = array_unique($idList);
$roomTree = array();
$filteredIdList = array();
foreach ($idList as $id) {
$dbresult = Database::queryFirst("SELECT locationname FROM `location` WHERE locationid=:locationID", array('locationID' => $id));
if (!in_array($id, $filteredIdList)) {
$a['id'] = $id;
$a['name'] = $dbresult['locationname'];
$filteredIdList[] = $id;
$a['childs'] = getChildsRecursive($id, $filteredIdList);
$roomTree[] = $a;
}
}
return json_encode($roomTree);
}
function getChildsRecursive($id, &$filteredIdList) {
$dbquery = Database::simpleQuery("SELECT locationid, locationname FROM `location` WHERE parentlocationid=:locationID", array('locationID' => $id));
$array = array();
$dbarray = array();
while($dbresult=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$dbarray[] = $dbresult;
}
foreach ($dbarray as $db) {
$i = $db['locationid'];
if (!in_array($i, $filteredIdList)) {
$a['id'] = $i;
$a['name'] = $db['locationname'];
$filteredIdList[] = $i;
$a['childs'] = getChildsRecursive($i, $filteredIdList);
$array[] = $a;
}
}
return $array;
}
function getConfig($locationID) {
$dbresult = Database::queryFirst("SELECT l.locationname, li.config, li.serverroomid, s.servertype, s.serverurl FROM `location_info` AS li
RIGHT JOIN `location` AS l ON l.locationid=li.locationid
LEFT JOIN `setting_location_info` AS s ON s.serverid=li.serverid
WHERE l.locationid=:locationID", array('locationID' => $locationID));
$config = array();
$config = json_decode($dbresult['config'], true);
$config['room'] = $dbresult['locationname'];
$date = getdate();
$config['time'] = $date['year'] . "-" . $date['mon'] . "-" . $date['mday'] . " " . $date['hours'] . ":" . $date['minutes'] . ":" . $date['seconds'];
if($dbresult['servertype'] === "Frontend") {
$config['calendarqueryurl'] = $dbresult['serverurl'] . "/" . $dbresult['serverroomid'] . ".json";
}
if (empty($config)) {
echo json_encode(array());
} else {
echo json_encode($config, JSON_UNESCAPED_SLASHES);
}
}
/*
function checkIfHidden($locationID) {
$dbquery = Database::simpleQuery("SELECT hidden FROM `location_info` WHERE locationid = :locationID", array('locationID' => $locationID));
while($roominfo=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$hidden = $roominfo['hidden'];
if ($hidden === '0') {
return false;
} else {
return true;
}
}
return false;
}*/
// ########## ##########
function getRoomInfo($idList, $coords) {
$coordinates = (string)$coords;
// Build SQL Query for multiple ids.
$query = "SELECT m.locationid, machineuuid, position, logintime, lastseen, lastboot FROM `machine` as m LEFT JOIN location_info AS l ON l.locationid = m.locationid WHERE l.hidden = 0 AND m.locationid IN (";
//$query = "SELECT locationid, machineuuid, position, logintime, lastseen, lastboot FROM `machine` WHERE locationid IN (";
$query .= implode(",", $idList);
$query .= ")";
$query .= " ORDER BY m.locationid ASC";
// Execute query.
$dbquery = Database::simpleQuery($query);
$dbresult = array();
$currentlocationid = 0;
$pclist = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
// Add the data in the array if locationid changed
if ($dbdata['locationid'] != $currentlocationid && $currentlocationid != 0) {
$data['id'] = $currentlocationid;
$data['computer'] = $pclist;
$dbresult[] = $data;
$pclist = array();
}
$pc['id'] = $dbdata['machineuuid'];
// Add coordinates if bool = true.
if ($coordinates == '1' || $coordinates == 'true') {
$position = json_decode($dbdata['position'], true);
$pc['x'] = $position['gridCol'];
$pc['y'] = $position['gridRow'];
}
$pc['pcState'] = LocationInfo::getPcState($dbdata);
$pclist[] = $pc;
// Save the last entry to add this at the end.
$lastentry['id'] = $dbdata['locationid'];
$lastentry['computer'] = $pclist;
$currentlocationid = $dbdata['locationid'];
}
$dbresult[] = $lastentry;
return json_encode($dbresult, true);
}
// ########## ###########
// ########## ##########
function getOpeningTime($idList) {
// Build SQL Query for multiple ids.
$query = "SELECT locationid, openingtime FROM `location_info` WHERE locationid IN (";
$query .= implode(",", $idList);
$query .= ")";
// Execute query.
$dbquery = Database::simpleQuery($query);
$dbresult = array();
$handledIds = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$data['id'] = $dbdata['locationid'];
$data['openingtime'] = json_decode($dbdata['openingtime'], true);
$handledIds[] = $data['id'];
$dbresult[] = $data;
}
$finalArray = array();
$idList = array_diff($idList, $handledIds);
foreach ($idList as $id) {
$data['id'] = $id;
$data['openingtime'] = array();
$dbresult[] = $data;
}
// Go through the db entrys [id] = id; [openingtime] = e.g. [{"days":["Saturday","Sunday"],"openingtime":"12:32","closingtime":"14:35"}]
foreach($dbresult as $entry) {
$tmp = array();
// Get the parents time if there is no openingtime defined.
if (count($entry['openingtime']) == 0) {
//$tmp = getOpeningTimesFromParent($entry['id']);
$tmp['id'] = $entry['id'];
$tmp['openingtime'] = getOpeningTimesFromParent($entry['id']);
} else {
$tmp['id'] = $entry['id'];
$tmp['openingtime'] = formatOpeningtime($entry['openingtime']);
}
$finalArray[] = $tmp;
}
return json_encode($finalArray, true);
}
// Format the openingtime in the frontend needed format.
function formatOpeningtime($openingtime) {
$weekarray = array ("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
foreach ($weekarray as $d) {
$array = array();
foreach ($openingtime as $opt) {
foreach($opt['days'] as $val) {
if ($val == $d) {
$arr = array();
$openTime = explode(':', $opt['openingtime']);
$arr['HourOpen'] = $openTime[0];
$arr['MinutesOpen'] = $openTime[1];
$closeTime = explode(':', $opt['closingtime']);
$arr['HourClose'] = $closeTime[0];
$arr['MinutesClose'] = $closeTime[1];
$array[] = $arr;
}
}
if(!empty($array)) {
$result[$d] = $array;
}
}
}
return $result;
}
function getOpeningTimesFromParent($locationID) {
// Get parent location id.
$dbquery = Database::queryFirst("SELECT parentlocationid FROM `location` WHERE locationid = :locationID", array('locationID' => $locationID));
$parentlocationid = 0;
$parentlocationid = (int)$dbquery['parentlocationid'];
if ($parentlocationid == 0) {
return createBasicClosingTime();
} else {
$dbquery = Database::queryFirst("SELECT openingtime FROM `location_info` WHERE locationid = :locationID", array('locationID' => $parentlocationid));
$dbresult = json_decode($dbquery['openingtime'], true);
if (count($dbresult) == 0) {
return getOpeningTimesFromParent($parentlocationid);
} else {
return formatOpeningtime($dbresult);
}
}
}
function createBasicClosingTime() {
$weekarray = array ("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
$array = array();
foreach ($weekarray as $d) {
$a = array();
$arr['HourOpen'] = '00';
$arr['MinutesOpen'] = '00';
$arr['HourClose'] = '23';
$arr['MinutesClose'] = '59';
$a[] = $arr;
$array[$d] = $a;
}
return $array;
}
// ########## ##########