1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
<?php
HandleParameters();
function HandleParameters() {
$getAction = Request::get('action', 0, 'string');
if ($getAction == "roominfo") {
$getRoomID = Request::get('id', 0, 'int');
$getCoords = Request::get('coords', 0, 'string');
if (empty($getCoords)) {
$getCoords = '0';
}
getRoomInfoJson($getRoomID, $getCoords);
} elseif ($getAction == "openingtime") {
$getRoomID = Request::get('id', 0, 'int');
getOpeningTimes($getRoomID);
}
}
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;
}
}
}
function getOpeningTimes($locationID) {
$error = checkIfHidden($locationID);
if ($error == true) {
echo "ERROR";
return;
}
$dbquery = Database::simpleQuery("SELECT openingtime FROM `location_info` WHERE locationid = :locationID", array('locationID' => $locationID));
$result = array();
while($dbdata=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$dbresult = json_decode($dbdata['openingtime'], true);
}
$weekarray = array ("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
foreach ($weekarray as $d) {
$array = array();
foreach ($dbresult as $day) {
foreach($day['days'] as $val) {
if ($val == $d) {
$arr = array();
$arr['HourOpen'] = $day['openingtime'][0] . $day['openingtime'][1];
$arr['MinutesOpen'] = $day['openingtime'][3] . $day['openingtime'][4];
$arr['HourClose'] = $day['closingtime'][0] . $day['closingtime'][1];
$arr['MinutesClose'] = $day['closingtime'][3] . $day['closingtime'][4];
$array[] = $arr;
}
}
if(!empty($array)) {
$result[$d] = $array;
}
}
}
echo json_encode($result, true);
}
function getRoomInfoJson($locationID, $coords) {
$error = checkIfHidden($locationID);
$pcs = getPcInfos($locationID, $coords);
if (empty($pcs)) {
$error = true;
}
if ($error === false) {
echo $pcs;
} else {
echo "ERROR";
}
}
function getPcInfos($locationID, $coords) {
$dbquery;
if ($coords === '1') {
$dbquery = Database::simpleQuery("SELECT machineuuid, position, logintime FROM `machine` WHERE locationid = :locationID" , array('locationID' => $locationID));
} else {
$dbquery = Database::simpleQuery("SELECT machineuuid, logintime FROM `machine` WHERE locationid = :locationID" , array('locationID' => $locationID));
}
$pcs = array();
while($pc=$dbquery->fetch(PDO::FETCH_ASSOC)) {
$computer = array();
$computer['id'] = $pc['machineuuid'];
if ($coords === '1') {
$position = json_decode($pc['position'], true);
$computer['x'] = $position['gridRow'];
$computer['y'] = $position['gridCol'];
}
$computer['inUse'] = 0;
if ($pc['logintime'] > 0) {
$computer['inUse'] = 1;
}
$pcs[] = $computer;
}
$str = json_encode($pcs, true);
return $str;
}
|
