<?php
class Page_LocationInfo extends Page
{
private $action;
/**
* Called before any page rendering happens - early hook to check parameters etc.
*/
protected function doPreprocess()
{
User::load();
if (!User::isLoggedIn()) {
Message::addError('main.no-permission');
Util::redirect('?do=Main'); // does not return
}
$this->action = Request::post('action');
if ($this->action === 'updateOpeningTimeExpert') {
$this->updateOpeningTimeExpert();
} elseif($this->action === 'updateOpeningTimeEasy') {
$this->updateOpeningTimeEasy();
} elseif ($this->action === 'updateConfig') {
$this->updateConfig();
} elseif ($this->action === 'updateServer') {
$this->updateServer();
} elseif ($this->action === 'deleteServer') {
$this->deleteServer();
}
}
/**
* Menu etc. has already been generated, now it's time to generate page content.
*/
protected function doRender()
{
$getAction = Request::get('action');
if (empty($getAction)) {
Util::redirect('?do=locationinfo&action=infoscreen');
}
if ($getAction === 'infoscreen') {
$this->getInfoScreenTable();
}
if($getAction == 'updateroomdb') {
$this->updateInfoscreenDb();
Util::redirect('?do=locationinfo&action=infoscreen');
}
if ($getAction === 'hide') {
$roomId = Request::get('id', 0, 'int');
$hiddenValue = Request::get('value', 0, 'int');
$this->toggleHidden($roomId, $hiddenValue);
Util::redirect('?do=locationinfo&action=infoscreen#row' . $roomId);
}
}
private function updateServer() {
$id = Request::post('id', 0, 'int');
if ($id == 0) {
Database::exec("INSERT INTO `setting_location_info` (servername, serverurl, servertype, login, passwd) VALUES (:name, :url, :type, :login, :passwd)",
array('name' => Request::post('name', '', 'string'), 'url' => Request::post('url', '', 'string'), 'type' => Request::post('type', '', 'string'),
'login' => Request::post('user', '', 'string'), 'passwd' => Request::post('password', '', 'string')));
} else {
Database::exec("INSERT INTO `setting_location_info` (serverid, servername, servertype, serverurl, login, passwd) VALUES (:id, :name, :type, :url, :login, :passwd)
ON DUPLICATE KEY UPDATE servername=:name, serverurl=:url, servertype=:type, login=:login, passwd=:passwd",
array('id' => $id, 'name' => Request::post('name', '', 'string'), 'url' => Request::post('url', '', 'string'), 'type' => Request::post('type', '', 'string'),
'login' => Request::post('user', '', 'string'), 'passwd' => Request::post('password', '', 'string')));
}
Util::redirect('?do=locationinfo&action=infoscreen');
}
private function deleteServer() {
$id = Request::post('id', 0, 'int');
Database::exec("DELETE FROM `setting_location_info` WHERE serverid=:id", array('id' => $id));
Util::redirect('?do=locationinfo&action=infoscreen');
}
private function updateConfig()
{
$result = array();
$locationid = Request::post('id', 0, 'int');
$result['language'] = Request::post('language');
$result['mode'] = Request::post('mode', 1, 'int');
$result['vertical'] = Request::post('vertical', false, 'bool');
$result['eco'] = Request::post('eco', false, 'bool');
$result['scaledaysauto'] = Request::post('autoscale', false, 'bool');
$result['daystoshow'] = Request::post('daystoshow', 7, 'int');
$result['rotation'] = Request::post('rotation', 0, 'int');
$result['scale'] = Request::post('scale', 50, 'int');
$result['switchtime'] = Request::post('switchtime', 20, 'int');
$result['calupdate'] = Request::post('calupdate', 30, 'int');
$result['roomupdate'] = Request::post('roomupdate', 30, 'int');
$result['configupdate'] = Request::post('configupdate', 180, 'int');
$serverid = Request::post('serverid', 0, 'int');
$serverroomid = Request::post('serverroomid', 0, 'int');
Database::exec("INSERT INTO `location_info` (locationid, serverid, serverroomid, hidden, config) VALUES (:id, :serverid, :serverroomid, :hidden, :config)
ON DUPLICATE KEY UPDATE config=:config, serverid=:serverid, serverroomid=:serverroomid",
array('id' => $locationid, 'hidden' => false, 'config' => json_encode($result, true), 'serverid' => $serverid, 'serverroomid' => $serverroomid));
Message::addSuccess('config-saved');
Util::redirect('?do=locationinfo');
}
private function updateOpeningTimeExpert()
{
$days = Request::post('days');
$locationid = Request::post('id', 0, 'int');
$openingtime = Request::post('openingtime');
$closingtime = Request::post('closingtime');
$easyMode = Request::post('easyMode');
$delete = Request::post('delete');
$dontadd = Request::post('dontadd');
$count = 0;
$result = array();
$resulttmp = array();
$deleteCounter = 0;
if (!$easyMode) {
$dbquery = Database::simpleQuery("SELECT openingtime FROM `location_info` WHERE locationid = :id", array('id' => $locationid));
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$resulttmp = json_decode($dbdata['openingtime'], true);
}
$index = 0;
foreach ($resulttmp as $day) {
$skip = false;
foreach ($delete as $del) {
if ($del == $index) {
$skip = true;
break;
}
}
if ($skip == true) {
$index++;
$deleteCounter++;
continue;
}
$result[] = $day;
$index++;
}
}
if (!empty($days) && !is_array($days)) {
Message::addError('no-days-selected');
Util::redirect('?do=locationinfo');
} else{
$dayz = array();
$da = array();
foreach ($days as $d) {
if ($d != '-') {
$da[] = $d;
} else {
$dayz[$count] = $da;
$da = array();
$count++;
}
}
$optime = array();
for ($x = 0; $x < $count; $x++) {
if ($dontadd[$x] == 'dontadd') {
continue;
}
$optime['days'] = $dayz[$x];
$optime['openingtime'] = $openingtime[$x];
$optime['closingtime'] = $closingtime[$x];
$result[] = $optime;
}
}
Database::exec("INSERT INTO `location_info` (locationid, hidden, openingtime) VALUES (:id, :hidden, :openingtime) ON DUPLICATE KEY UPDATE openingtime=:openingtime",
array('id' => $locationid, 'hidden' => false, 'openingtime' => json_encode($result, true)));
if ($deleteCounter > 0) {
Message::addSuccess('deleted-x-entries', $deleteCounter);
}
if ($count > 0) {
Message::addSuccess('added-x-entries', $count);
}
Util::redirect('?do=locationinfo');
}
private function updateOpeningTimeEasy() {
$locationid = Request::post('id', 0, 'int');
$openingtime = Request::post('openingtime');
$closingtime = Request::post('closingtime');
$result = array();
$opt0['days'] = array ("Monday", "Tuesday", "Wednesday", "Thursday", "Friday");
$opt0['openingtime'] = $openingtime[0];
$opt0['closingtime'] = $closingtime[0];
$result[] = $opt0;
$opt1['days'] = array ("Saturday");
$opt1['openingtime'] = $openingtime[1];
$opt1['closingtime'] = $closingtime[1];
$result[] = $opt1;
$opt2['days'] = array ("Sunday");
$opt2['openingtime'] = $openingtime[2];
$opt2['closingtime'] = $closingtime[2];
$result[] = $opt2;
Database::exec("INSERT INTO `location_info` (locationid, hidden, openingtime) VALUES (:id, :hidden, :openingtime) ON DUPLICATE KEY UPDATE openingtime=:openingtime",
array('id' => $locationid, 'hidden' => false, 'openingtime' => json_encode($result, true)));
Message::addSuccess('openingtime-updated');
Util::redirect('?do=locationinfo');
}
protected function toggleHidden($id, $val) {
Database::exec("INSERT INTO `location_info` (locationid, hidden) VALUES (:id, :hidden) ON DUPLICATE KEY UPDATE hidden=:hidden", array('id' => $id, 'hidden' => $val));
$this->checkChildRecursive($id, $val);
$this->checkParentRecursive($id);
}
protected function checkChildRecursive($id, $val) {
$dbquery = Database::simpleQuery("SELECT locationid FROM `location` WHERE parentlocationid = :locationid", array('locationid' => $id));
$childs = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$childs[] = $dbdata['locationid'];
}
foreach ($childs as $key) {
Database::exec("INSERT INTO `location_info` (locationid, hidden) VALUES (:id, :hidden) ON DUPLICATE KEY UPDATE hidden=:hidden", array('id' => $key, 'hidden' => $val));
$this->checkChildRecursive($key, $val);
}
}
protected function checkParentRecursive($id) {
$dbquery = Database::simpleQuery("SELECT parentlocationid FROM `location` WHERE locationid = :locationid", array('locationid' => $id));
$parent = 0;
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$parent = (int)$dbdata['parentlocationid'];
}
if ($parent === 0) {
return;
} else {
$dbq = Database::simpleQuery("SELECT COUNT(case li.hidden when '0' then 1 else null end) AS '0',
COUNT(case li.hidden when '1' then 1 else null end) AS '1',
COUNT(*) - COUNT(case li.hidden when '0' then 1 else null end) - COUNT(case li.hidden when '1' then 1 else null end) AS 'NULL'
FROM `location` AS l LEFT JOIN `location_info` AS li ON l.locationid=li.locationid
WHERE parentlocationid = :parentId;", array('parentId' => $parent));
$amountofzero = 0;
$amountofnull = 0;
while($dbd=$dbq->fetch(PDO::FETCH_ASSOC)) {
$amountofzero = (int)$dbd['0'];
$amountofnull = (int)$dbd['NULL'];
}
if ($amountofzero == 0 AND $amountofnull == 0) {
Database::exec("INSERT INTO `location_info` (locationid, hidden) VALUES (:id, :hidden) ON DUPLICATE KEY UPDATE hidden=:hidden", array('id' => $parent, 'hidden' => 1));
} else {
Database::exec("INSERT INTO `location_info` (locationid, hidden) VALUES (:id, :hidden) ON DUPLICATE KEY UPDATE hidden=:hidden", array('id' => $parent, 'hidden' => 0));
}
$this->checkParentRecursive($parent);
}
}
protected function getInfoScreenTable() {
$dbquery = Database::simpleQuery("SELECT l.locationname, l.locationid, li.hidden, m.pcState, m.total FROM `location_info` AS li
RIGHT JOIN `location` AS l ON li.locationid=l.locationid LEFT JOIN
(SELECT locationid, Count(case m.logintime WHEN NOT 1 THEN null else 1 end) AS pcState, Count(*) AS total FROM `machine` AS m
WHERE locationid IS NOT NULL GROUP BY locationid) AS m ON l.locationid=m.locationid");
$pcs = array();
if (Module::isAvailable('locations')) {
foreach (Location::getLocations() as $loc) {
$data = array();
$data['locationid'] = (int)$loc['locationid'];
$data['locationname'] = $loc['locationname'];
$data['depth'] = $loc['depth'];
$data['hidden'] = NULL;
$locid = (int)$loc['locationid'];
$pcs[$locid] = $data;
}
}
while($roominfo=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$locid = (int)$roominfo['locationid'];
if ($roominfo['hidden'] == NULL) {
$pcs[$locid]['hidden'] = 0;
} else {
$pcs[$locid]['hidden'] = $roominfo['hidden'];
}
if ($roominfo['pcState'] != NULL) {
$pcs[$locid]['pcState'] = $roominfo['pcState'];
}
if ($roominfo['total'] != NULL) {
$pcs[$locid]['total'] = $roominfo['total'];
$pcs[$locid]['hasPcs'] = true;
} else {
$pcs[$locid]['hasPcs'] = false;
}
}
$serverlist = array();
$dbquery2 = Database::simpleQuery("SELECT * FROM `setting_location_info`");
while($db=$dbquery2->fetch(PDO::FETCH_ASSOC)) {
$server['id'] = $db['serverid'];
$server['name'] = $db['servername'];
if ($db['servertype'] == 'HISinOne') {
$server['HISinOne'] = true;
$server['DAVINCI'] = false;
} elseif ($db['servertype'] == 'DAVINCI') {
$server['HISinOne'] = false;
$server['DAVINCI'] = true;
}
$server['url'] = $db['serverurl'];
$server['user'] = $db['login'];
$server['password'] = $db['passwd'];
$serverlist[] = $server;
}
Render::addTemplate('location-info', array(
'list' => array_values($pcs), 'serverlist' => array_values($serverlist),
));
}
/**
* AJAX
*/
protected function doAjax()
{
User::load();
if (!User::isLoggedIn()) {
die('Unauthorized');
}
$action = Request::any('action');
if ($action === 'pcsubtable') {
$id = Request::any('id', 0, 'int');
$this->ajaxShowLocation($id);
} elseif ($action === 'timetable') {
$id = Request::any('id', 0, 'int');
$this->ajaxTimeTable($id);
} elseif ($action === 'config') {
$id = Request::any('id', 0, 'int');
$this->ajaxConfig($id);
}
}
//TODO REMOVE FUNCTION. NOT NECCESSARY BUT AFTER TESTING pcSTATE
private function ajaxShowLocation($id)
{
$dbquery = Database::simpleQuery("SELECT machineuuid, clientip, position, logintime, lastseen FROM `machine` WHERE locationid = :id", array('id' => $id));
$data = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$pc = array();
$pc['id'] = $dbdata['machineuuid'];
$pc['ip'] = $dbdata['clientip'];
$pc['pcState'] = LocationInfo::getPcState($dbdata['logintime'], $dbdata['lastseen']);
$position = json_decode($dbdata['position'], true);
$pc['x'] = $position['gridRow'];
$pc['y'] = $position['gridCol'];
$data[] = $pc;
}
echo Render::parse('pcsubtable', array(
'list' => array_values($data)
));
}
private function ajaxTimeTable($id) {
$array = array();
$dbquery = Database::simpleQuery("SELECT openingtime FROM `location_info` WHERE locationid = :id", array('id' => $id));
$dbresult = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$dbresult[] = json_decode($dbdata['openingtime'], true);
}
if($this->isEasyMode($dbresult)) {
echo Render::parse('timetable', array('id' => $id, 'openingtime0' => $dbresult[0][0]['openingtime'],
'closingtime0' => $dbresult[0][0]['closingtime'], 'openingtime1' => $dbresult[0][1]['openingtime'],
'closingtime1' => $dbresult[0][1]['closingtime'], 'openingtime2' => $dbresult[0][2]['openingtime'],
'closingtime2' => $dbresult[0][2]['closingtime'], 'easyMode' => true, 'expertMode' => false));
} else{
foreach($dbresult as $db) {
$index = 0;
foreach ($db as $key) {
$str = "| ";
foreach ($key['days'] as $val) {
$str .= $val;
$str .= " | ";
}
$ar = array();
$ar['days'] = $str;
$ar['openingtime'] = $key['openingtime'];
$ar['closingtime'] = $key['closingtime'];
$ar['index'] = $index;
$array[] = $ar;
$index++;
}
}
echo Render::parse('timetable', array('id' => $id, 'openingtimes' => array_values($array), 'easyMode' => false, 'expertMode' => true));
}
}
private function isEasyMode($array) {
if(count($array[0]) == 3) {
if ($array[0][0]['days'] == array ("Monday","Tuesday","Wednesday","Thursday","Friday")
&& $array[0][1]['days'] == array ("Saturday") && $array[0][2]['days'] == array ("Sunday")) {
return true;
} else {
return false;
}
} elseif ($array[0] == 0) {
return true;
} else {
return false;
}
}
private function ajaxConfig($id) {
$array = array();
// Get Config data from db
$dbquery = Database::simpleQuery("SELECT config, serverid, serverroomid FROM `location_info` WHERE locationid = :id", array('id' => $id));
$serverid;
$serverroomid;
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$array = json_decode($dbdata['config'], true);
$serverid = $dbdata['serverid'];
$serverroomid = $dbdata['serverroomid'];
}
// get Server / ID list
$dbq = Database::simpleQuery("SELECT serverid, servername FROM `setting_location_info`");
$serverList = array();
while($dbd=$dbq->fetch(PDO::FETCH_ASSOC)) {
$d['sid'] = $dbd['serverid'];
$d['sname'] = $dbd['servername'];
$serverList[] = $d;
}
echo Render::parse('config', array('id' => $id, 'language' => $array['language'], 'mode' => 'mode'.$array['mode'], 'vertical' => $array['vertical'],
'eco' => $array['eco'], 'daystoshow' => 'day'.$array['daystoshow'], 'scaledaysauto' => $array['scaledaysauto'], 'rotation' => 'rotation'.$array['rotation'],
'scale' => $array['scale'], 'switchtime' => $array['switchtime'], 'calupdate' => $array['calupdate'],
'roomupdate' => $array['roomupdate'], 'configupdate' => $array['configupdate'],
'serverlist' => array_values($serverList), 'serverid' => $serverid, 'serverroomid' => $serverroomid));
}
}
