0 AND locationid IN (:idlist)";
$dbquery = Database::simpleQuery($query, array('idlist' => $idArray));
while ($dbresult = $dbquery->fetch(PDO::FETCH_ASSOC)) {
unset($idArray[$dbresult['locationid']]);
}
}
return array_flip($idArray);
}
// ########## ##########
/**
* Gets the location info of the given locations.
*
* @param $idList Array list of ids.
* @param bool $coords Defines if coords should be included or not.
* @return string location info, formatted as JSON
*/
function getLocationInfo($idList, $coords = false)
{
if (empty($idList))
return '[]';
$positionCol = $coords ? 'm.position,' : '';
$query = "SELECT m.locationid, m.machineuuid, $positionCol m.logintime, m.lastseen, m.lastboot FROM machine m
WHERE m.locationid IN (:idlist)";
$dbquery = Database::simpleQuery($query, array('idlist' => $idList));
// Iterate over matching machines
$dbresult = array();
while ($dbdata = $dbquery->fetch(PDO::FETCH_ASSOC)) {
// Set the id if the locationid changed.
if (!isset($dbresult[$dbdata['locationid']])) {
$dbresult[$dbdata['locationid']] = array('id' => $dbdata['locationid'], 'computer' => array());
}
// Compact the pc data in one array.
$pc = array('id' => $dbdata['machineuuid']);
if ($coords && !empty($dbdata['position'])) {
$position = json_decode($dbdata['position'], true);
if (isset($position['gridCol']) && isset($position['gridRow'])) {
$pc['x'] = $position['gridCol'];
$pc['y'] = $position['gridRow'];
if (isset($position['overlays']) && is_array($position['overlays'])) {
$pc['overlays'] = $position['overlays'];
} else {
$pc['overlays'] = array();
}
}
}
$pc['pcState'] = LocationInfo::getPcState($dbdata);
// Add the array to the computer list.
$dbresult[$dbdata['locationid']]['computer'][] = $pc;
}
// The array keys are only used for the isset -> Return only the values.
return json_encode(array_values($dbresult));
}
// ########## ###########
// ########## ##########
/**
* Gets the Opening time of the given locations.
*
* @param $idList Array list of locations
* @return string Opening times JSON
*/
function getOpeningTime($idList)
{
$locations = Location::getLocationsAssoc();
$allIds = $idList;
foreach ($idList as $id) {
if (isset($locations[$id]) && isset($locations[$id]['parents'])) {
$allIds = array_merge($allIds, $locations[$id]['parents']);
}
}
if (empty($allIds))
return '[]';
$openingTimes = array();
$qs = '?' . str_repeat(',?', count($allIds) - 1);
$res = Database::simpleQuery("SELECT locationid, openingtime FROM locationinfo_locationconfig WHERE locationid IN ($qs)",
array_values($allIds));
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
$openingTimes[(int)$row['locationid']] = $row['openingtime'];
}
$returnValue = array();
foreach ($idList as $locationid) {
$id = $locationid;
while ($id !== 0) {
if (!empty($openingTimes[$id])) {
$cal = json_decode($openingTimes[$id], true);
if (is_array($cal)) {
$cal = formatOpeningtime($cal);
}
if (!empty($cal)) {
$returnValue[] = array(
'id' => $locationid,
'openingtime' => $cal,
);
break;
}
}
$id = $locations[$id]['parentlocationid'];
}
}
return json_encode($returnValue);
}
/**
* Format the openingtime in the frontend needed format.
* One key per week day, wich contains an array of {
* 'HourOpen' => hh, 'MinutesOpen' => mm,
* 'HourClose' => hh, 'MinutesClose' => mm }
*
* @param array $openingtime The opening time in the db saved format.
* @return mixed The opening time 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;
}
// ########## ##########
/**
* Gets the config of the location.
*
* @param $locationID ID of the location
*/
function getConfig($locationID)
{
$dbresult = Database::queryFirst("SELECT l.locationname, li.config FROM `location` AS l
LEFT JOIN `locationinfo_locationconfig` AS li ON (l.locationid = li.locationid)
WHERE l.locationid = :locationID", array('locationID' => $locationID));
$config = defaultConfig();
if ($dbresult !== false) {
if (!empty($dbresult['config'])) {
$json = json_decode($dbresult['config'], true);
if (is_array($json)) {
$config = $json + $config;
}
}
$config['room'] = $dbresult['locationname'];
}
$date = getdate();
$config['time'] = date('Y-m-d H:i:s');
return json_encode($config);
}
/**
* Creates and returns a default config for room that didn't saved a config yet.
*
* @return Return a default config.
*/
function defaultConfig()
{
return array(
'language' => 'en',
'mode' => 1,
'vertical' => false,
'eco' => false,
'scaledaysauto' => true,
'daystoshow' => 7,
'rotation' => 0,
'scale' => 50,
'switchtime' => 20,
'calupdate' => 30,
'roomupdate' => 5,
'configupdate' => 180,
);
}
/**
* Gets the pc states of the given locations.
*
* @param $idList Array list of the location ids.
* @return string PC state JSON
*/
function getPcStates($idList)
{
$pcStates = array();
$locationInfoList = json_decode(getLocationInfo($idList), true);
foreach ($locationInfoList as $locationInfo) {
$result['id'] = $locationInfo['id'];
$idle = 0;
$occupied = 0;
$off = 0;
$broken = 0;
foreach ($locationInfo['computer'] as $computer) {
if ($computer['pcState'] == "IDLE") {
$idle++;
} elseif ($computer['pcState'] == "OCCUPIED") {
$occupied++;
} elseif ($computer['pcState'] == "OFF") {
$off++;
} elseif ($computer['pcState'] == "BROKEN") {
$broken++;
}
}
$result['idle'] = $idle;
$result['occupied'] = $occupied;
$result['off'] = $off;
$result['broken'] = $broken;
$pcStates[] = $result;
}
return json_encode($pcStates);
}
/**
* Gets the location tree of the given locations.
*
* @param int[] $idList Array list of the locations.
* @return string location tree data as JSON.
*/
function getLocationTree($idList)
{
$locations = Location::getTree();
$ret = findLocations($locations, $idList);
return json_encode($ret);
}
function findLocations($locations, $idList)
{
$ret = array();
foreach ($locations as $location) {
if (in_array($location['locationid'], $idList)) {
$ret[] = $location;
} elseif (!empty($location['children'])) {
$ret = array_merge($ret, findLocations($location['children'], $idList));
}
}
return $ret;
}
// ########## ###########
/**
* Gets the calendar of the given ids.
*
* @param $idList Array list with the location ids.
* @return string Calendar JSON.
*/
function getCalendar($idList)
{
$serverList = array();
if (!empty($idList)) {
// Build SQL query for multiple ids.
$qs = '?' . str_repeat(',?', count($idList) - 1);
$query = "SELECT l.locationid, l.serverid, l.serverlocationid, s.servertype, s.credentials
FROM `locationinfo_locationconfig` AS l
INNER JOIN locationinfo_coursebackend AS s ON (s.serverid = l.serverid)
WHERE l.hidden = 0 AND l.locationid IN ($qs)
ORDER BY s.servertype ASC";
$dbquery = Database::simpleQuery($query, array_values($idList));
while ($dbresult = $dbquery->fetch(PDO::FETCH_ASSOC)) {
if (!isset($serverList[$dbresult['serverid']])) {
$serverList[$dbresult['serverid']] = array(
'credentials' => json_decode($dbresult['credentials'], true),
'type' => $dbresult['servertype'],
'idlist' => array()
);
}
$serverList[$dbresult['serverid']]['idlist'][] = $dbresult['locationid'];
}
}
$resultArray = array();
foreach ($serverList as $serverid => $server) {
$serverInstance = CourseBackend::getInstance($server['type']);
if ($serverInstance === false) {
EventLog::warning('Cannot fetch schedule for locationid ' . $server['locationid']
. ': Backend type ' . $server['type'] . ' unknown. Disabling location.');
Database::exec("UPDATE locationinfo_locationconfig SET serverid = 0 WHERE locationid = :lid",
array('lid' => $server['locationid']));
continue;
}
$credentialsOk = $serverInstance->setCredentials($serverid, $server['credentials']);
if ($credentialsOk) {
$calendarFromBackend = $serverInstance->fetchSchedule($server['idlist']);
} else {
$calendarFromBackend = array();
}
LocationInfo::setServerError($serverid, $serverInstance->getError());
if (is_array($calendarFromBackend)) {
foreach ($calendarFromBackend as $key => $value) {
$resultArray[] = array(
'id' => $key,
'calendar' => $value,
);
}
}
}
return json_encode($resultArray);
}
// ########## ##########