-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathops_print_summary.php
144 lines (124 loc) · 5.35 KB
/
ops_print_summary.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
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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
<?php require_once('access_and_open.php'); require_once('secure.php'); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Op Session Roster</title>
<style type="text/css">
div.session { margin-top: 3em; font-weight:bold; font-size: 18pt; font-family: Ariel; }
span.date { font-weight:bold; font-size: 18pt; font-family: Ariel; }
th.carpool { font-weight:normal; font-size: 10pt; font-family: Ariel; }
td.num { font-weight:normal; font-size: 14pt; font-family: Ariel; }
td.attendee { font-weight:normal; font-size: 14pt; font-family: Ariel; }
td.slot { font-weight:normal; font-size: 14pt; font-family: Ariel; }
div.break { page-break-before:always; page-break-after:always;}
</style>
</head>
<body>
<?php
include_once('mysql2i.class.php'); // migration step
require_once('ops_assign_common.php');
require_once('utilities.php');
// parse out arguments
parse_str($_SERVER["QUERY_STRING"], $args);
// first, see if there's a "?cy=" or "?start=" in the arguments
if ( ! isset($args["cy"])) {
echo '<h1>'.$event_tools_event_name.' Op Session Roster</h1>';
echo '<a href="index.php">Back to main page</a><p/>';
echo '<form method="get" action="ops_print_summary.php">
Cycle Name: <input name="cy"></textarea>
Date (blank or day-of-month, e.g. 25): <input name="date"></textarea>
<button type="submit">Start</button>
</form>
';
// display existing cycles & number of assignments)
echo '<h3>Existing cycles</h3><table><tr><th>Cycle Name</th><th>N Assigned</th></tr>';
global $opts, $event_tools_db_prefix, $event_tools_href_add_on;
mysql_connect($opts['hn'],$opts['un'],$opts['pw']);
@mysql_select_db($opts['db']) or die( "Unable to select database");
$query="
SELECT opsreq_group_cycle_name, SUM(status)
FROM ".$event_tools_db_prefix."eventtools_ops_group_session_assignments
WHERE status = 1
GROUP BY opsreq_group_cycle_name
ORDER BY opsreq_group_cycle_name
;
";
$result=mysql_query($query);
$num = mysql_numrows($result);
for ($i = 0; $i < $num; $i++) {
echo '<tr><td><a href="?cy='.mysql_result($result,$i,"opsreq_group_cycle_name").'">'.mysql_result($result,$i,"opsreq_group_cycle_name").'</a></td><td>'.mysql_result($result,$i,1).'</td></tr>';
}
echo '</table>';
return;
}
$cycle = $args["cy"];
$date = NULL;
if (array_key_exists("date", $args)) {
$date = $args["date"];
}
$where = "";
if ($date != NULL && $date != "") {
if (strlen($date) == 1) $date = '0'.$date;
$where = ' AND start_date LIKE "2___-__-'.substr($date,-2).'%" ';
}
// open db
global $opts, $event_tools_db_prefix, $event_tools_href_add_on, $cycle;
mysql_connect($opts['hn'],$opts['un'],$opts['pw']);
@mysql_select_db($opts['db']) or die( "Unable to select database");
$query="
SELECT *
FROM ".$event_tools_db_prefix."eventtools_ops_group_session_assignments
WHERE opsreq_group_cycle_name = '".$cycle."'
AND show_name != \"\" ".$where."
ORDER BY start_date, show_name, customers_lastname, customers_firstname
;
";
//echo $query;
$result=mysql_query($query);
$num = mysql_numrows($result);
$title = mysql_result($result,0,"show_name").' '.mysql_result($result,0,"start_date");
$date = date_from_long_format(mysql_result($result,0,"start_date"));
$count = 0+mysql_result($result,0,"spaces");
$first = TRUE;
echo '<div class="session">'.mysql_result($result,0,"show_name").' <div>';
echo '<span class="date">'.mysql_result($result,0,"start_date").' <span>';
echo '<table><tr><th></th><th class="carpool">Seats for<br/>carpool?</th><th></th></tr>';
$colnum = 1;
for ($i=0; $i < $num; $i++) {
// if doesn't match, do a session break
if ($title != mysql_result($result,$i,"show_name").' '.mysql_result($result,$i,"start_date")) {
$title = mysql_result($result,$i,"show_name").' '.mysql_result($result,$i,"start_date");
// first end old session
if ($count > 0) {
for ($j = 0; $j < $count; $j++) echo '<tr><td class="num">'.($colnum++).'</td><td>____</td><td class="slot"><pre>__________________________________________________</pre></td></tr>';
}
$count = 0+mysql_result($result,$i,"spaces");
echo '</table>';
// page break
echo '<div class="break"></div>';
// finally, start new header
echo '<div class="session">'.mysql_result($result,$i,"show_name").' <div>';
echo '<span class="date">'.mysql_result($result,$i,"start_date").' <span>';
echo '<table><tr><th></th><th class="carpool">Seats for<br/>carpool?</th><th></th></tr>';
$colnum = 1;
}
// show if allocated
if (1 == mysql_result($result,$i,"status")) {
echo '<tr><td class="num">'.($colnum++).'</td><td>____</td><td class="attendee">';
echo mysql_result($result,$i,"customers_firstname").' ';
echo mysql_result($result,$i,"customers_lastname").' ';
echo '</td></tr>';
$count--;
}
}
// end last session
if ($count > 0) {
for ($j = 0; $j < $count; $j++) echo '<tr><td class="num">'.($colnum++).'</td><td>____</td><td class="slot"><pre>__________________________________________________</pre></td></tr>';
}
echo '</table>';
return;
?>
</body>
</html>