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"; }