<?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>
