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 = "\r\n SELECT *\r\n FROM " . $event_tools_db_prefix . "eventtools_ops_group_session_assignments\r\n LEFT JOIN " . $event_tools_db_prefix . "eventtools_opsession_req\r\n USING ( opsreq_person_email )\r\n WHERE opsreq_group_cycle_name = '" . $cycle . "'\r\n AND show_name != \"\" AND start_date != \"\" " . $where . "\r\n ORDER BY start_date, show_name, customers_lastname, customers_firstname\r\n ;\r\n";
//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, $i, "show_name") . '<br>' . mysql_result($result, $i, "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;
}
public function format_heading($result, $i, $url = NONE)
{
global $event_tools_replace_on_data_error;
echo "<tr class=\"et-tour-tr1\">\n";
echo "<td class=\"et-tour-td1\"><span class=\"et-tour-number\">" . errorOnEmpty(htmlspecialchars(mysql_result($result, $i, "number")), "number") . "</span></td>\n";
echo "<td colspan=\"6\" class=\"et-tour-td2-\"><span class=\"et-tour-name\"><a name=\"" . mysql_result($result, $i, "number") . "\"></a>" . errorOnEmpty(htmlspecialchars(mysql_result($result, $i, "name")), "name") . "</span></td>\n";
echo "<td class=\"et-tour-td8-\"><span class=\"et-tour-status\">" . $this->show_status_or_link($result, $i) . "</span></td>\n";
echo "</tr>\n";
echo "<tr class=\"et-tour-tr2\">\n";
echo "<td class=\"et-tour-td1\"></td>\n";
echo "<td class=\"et-tour-td2\"><span class=\"et-tour-day\">" . day_from_long_format(mysql_result($result, $i, "start_date")) . "</span></td>\n";
echo "<td class=\"et-tour-td3\"><span class=\"et-tour-period\">" . tourPeriod(mysql_result($result, $i, "start_date"), mysql_result($result, $i, "end_date")) . "</span></td>\n";
echo "<td class=\"et-tour-td4\"><span class=\"et-tour-date\">" . date_from_long_format(mysql_result($result, $i, "start_date")) . "</span></td>\n";
echo "<td class=\"et-tour-td5\"><span class=\"et-tour-spare\">" . "" . "</span></td>\n";
if (mysql_result($result, $i, "tour_price") >= 0) {
$price = "\$" . mysql_result($result, $i, "tour_price");
} else {
if ($event_tools_replace_on_data_error) {
$price = "<span class=\"et-error-missing\">(no price)</span>";
} else {
$price = "<span class=\"et-error-missing\">TBA</span>";
}
}
echo "<td class=\"et-tour-td6\"><span class=\"et-tour-price\">" . $price . "</span></td>\n";
echo "<td class=\"et-tour-td7\"><span class=\"et-tour-depart\">" . "Dep " . time_from_long_format(mysql_result($result, $i, "start_date")) . "</span></td>\n";
if (substr(mysql_result($result, $i, "start_date"), -8) != '00:00:00' && substr(mysql_result($result, $i, "end_date"), -8) == '00:00:00') {
$r = "";
} else {
$r = "Ret " . time_from_long_format(mysql_result($result, $i, "end_date"));
}
echo "<td class=\"et-tour-td8\"><span class=\"et-tour-depart\">" . $r . "</span></td>\n";
echo "</tr>\n";
echo "<tr class=\"et-tour-tr3\">\n";
echo "<td colspan=\"8\" class=\"et-tour-td1\"><div class=\"et-tour-desc\">" . errorOnEmpty(mysql_result($result, $i, "description"), "description") . "</div></td>\n";
echo "</tr>\n";
}
