-
Notifications
You must be signed in to change notification settings - Fork 2
/
checklist.php
82 lines (60 loc) · 1.99 KB
/
checklist.php
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
<?php
require('settings.php');
require('functions.php');
require('data.php');
if (!isset($_GET['selection']) || $_GET['selection'] == '') {
// Set default selection (all floors in head office, no teams or departments)
$_GET['selection'] = "0-1-2-3-4-5//";
// Nah, set it to empty
$_GET['selection'] = "";
}
$selection_input = explode('/', $_GET['selection']);
// Code to build selection array as needed
$selection = Array('floors' => Array(), 'teams' => Array(), 'departments' => Array());
if (isset($selection_input[0]) && $selection_input[0] != '') {
foreach (explode('-', $selection_input[0]) as $value) {
$selection['floors'][] = $value;
}
}
if (isset($selection_input[1]) && $selection_input[1] != '') {
foreach (explode('-', $selection_input[1]) as $value) {
$selection['teams'][] = $value;
}
}
if (isset($selection_input[2]) && $selection_input[2] != '') {
foreach (explode('-', $selection_input[2]) as $value) {
$selection['departments'][] = $value;
}
}
// Generate WHERE clause, starting with always-untrue (1=2) so that OR sections can be appended
$where_clause = '1=2';
foreach ($selection['floors'] as $floor) {
$where_clause .= ' OR `floor` = ' . $floor;
}
foreach ($selection['teams'] as $team) {
$where_clause .= ' OR `team` = ' . $team;
}
foreach ($selection['departments'] as $department) {
$where_clause .= ' OR `department` = ' . $department;
}
//$order_by = '`floor`, `surname`, `firstname`';
$order_by = '`firstname`, `surname`';
$list = getEmployees($where_clause, $order_by);
?>
<html>
<head>
<title>Employee Checklist</title>
<link rel="stylesheet" href="style.php" />
</head>
<body>
<h1 class="checklist" contenteditable="true">Click to enter a title</h1>
<?php showSelector($selection); ?>
<?php
if (count($list)>0) {
displayChecklist($list, null, 1);
} else {
echo('<p style="text-align: center;">Select required group(s) from the list.</p>');
}
?>
</body>
</html>