-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathops_print_by_layout.php
138 lines (116 loc) · 4.44 KB
/
ops_print_by_layout.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
<?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">
@media print
{
table { page-break-after:auto }
tr { page-break-inside:avoid; page-break-after:auto }
td { page-break-inside:avoid; page-break-after:auto }
thead { display:table-header-group }
tfoot { display:table-footer-group }
}
</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 (! ($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_by_layout.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;
// assume single month for now
$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
LEFT JOIN ".$event_tools_db_prefix."eventtools_opsession_req
USING ( opsreq_person_email )
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 '<table border="1"><tr>';
echo '<th>'.mysql_result($result,0,"show_name").'<br>'.mysql_result($result,0,"start_date").' </th>';
$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
echo '</tr>';
// finally, start layout
echo '<tr><th>'.mysql_result($result,$i,"show_name").'<br>'.mysql_result($result,$i,"start_date").' </th>';
$colnum = 1;
}
// show if allocated
if (1 == mysql_result($result,$i,"status")) {
echo '<td class="attendee">';
echo mysql_result($result,$i,"customers_firstname").' ';
echo mysql_result($result,$i,"customers_lastname").' ';
// if you want to print options selected by user, put it here
echo '</td>';
$count--;
}
}
echo '</tr></table>';
return;
?>
</body>
</html>