function ticketslist_to_sorted_grouped($sortBy, $sortOrder, $ticket_list, $startFrom, $eventName, $eventDate, $venueName, $productionID, $city, $eventID)
{
include '../include/host_info.inc.php';
global $query_string;
global $eventTypeID;
# Section Row Price Seat Quanity Button
$SECTION_WIDTH = "29%";
$ROW_WIDTH = "15%";
$PRICE_WIDTH = "15%";
$SEAT_WIDTH = "13%";
$QUANTITY_WIDTH = "12%";
$BUYNOW_WIDTH = "16%";
$MAX_TIX_PP = 500;
$NUM_TIX_PP = $MAX_TIX_PP;
echo '<div class="tickets">';
$num_pages = ceil((double) count($ticket_list) / (double) $MAX_TIX_PP);
#echo count($ticket_list) . " tickets sets available for this Event<br/>";
if ($num_pages > 1) {
print_page_nav($startFrom, $num_pages, $sortBy, $sortOrder, $productionID);
}
$image_path = "{$root_url}/Images/";
$image_up = "arrow-up.gif";
$image_down = "arrow-down.gif";
$image_none = "arrow-none.gif";
$ticket_limit_reached = 0;
if ($sortBy == 'sec' || $sortBy == 'row') {
foreach ($ticket_list as $key => $row) {
$SeatSection[$key] = $row['SeatSection'];
$TicketPrice[$key] = $row['TicketPrice'];
$SeatRow[$key] = $row['SeatRow'];
}
if ($sortOrder == 'desc') {
$sortOrderCode = SORT_DESC;
} else {
$sortOrderCode = SORT_ASC;
}
if ($sortBy == 'sec') {
array_multisort($SeatSection, $sortOrderCode, $TicketPrice, SORT_ASC, $ticket_list);
} else {
array_multisort($SeatRow, $sortOrderCode, $TicketPrice, SORT_ASC, $ticket_list);
}
$sorted_array = $ticket_list;
} elseif ($sortBy == 'pr') {
if ($sortOrder == 'desc') {
$sorted_array = array_reverse($ticket_list);
} else {
$sorted_array = $ticket_list;
}
} else {
$sorted_array = $ticket_list;
}
echo "\n";
echo '<table width="100%" cellspacing="0">';
$url = make_production_url($eventName, $productionID, $city, $eventTypeID);
$url_array = explode('?', $url);
$url = $url_array[0];
$query_string = "&event_id={$productionID}";
echo "\n<tr class=\"tableHeading\">";
$sortable_columns = array("sec" => "Section", "row" => "Row", "pr" => "Price");
foreach ($sortable_columns as $columnID => $columnHeading) {
if (strlen($sortBy) == 0 && $columnID == 'pr') {
$nextSortOrder = 'desc';
$arrow = $image_path . $image_up;
} elseif ($sortBy == $columnID) {
if ($sortOrder == 'desc') {
$nextSortOrder = 'asc';
$arrow = $image_path . $image_down;
} else {
$nextSortOrder = 'desc';
$arrow = $image_path . $image_up;
}
} else {
$nextSortOrder = 'asc';
$arrow = $image_path . $image_none;
}
echo "\n";
if ($columnID == 'sec') {
echo '<th width="' . $SECTION_WIDTH . '">';
} elseif ($columnID == 'pr') {
echo '<th width="' . $PRICE_WIDTH . '">';
} else {
echo '<th width="' . $ROW_WIDTH . '">';
}
$url_sort_params = $url . "?sortBy={$columnID}&sortOrder={$nextSortOrder}" . $query_string;
echo '<a href="' . $url_sort_params . "\">{$columnHeading}</a><img src=\"{$arrow}\" alt=\"↓\"/></th>";
}
echo "\n";
echo '<th width="' . $SEAT_WIDTH . '">Seat No.</th><th width="' . $QUANTITY_WIDTH . '">Quantity</th><th width="' . $BUYNOW_WIDTH . '"> </th>';
echo "\n</tr>";
echo "\n</table>";
$ticket_index = 1;
for ($j = ($startFrom - 1) * $MAX_TIX_PP; $j < $startFrom * $MAX_TIX_PP - 1 && $j < count($sorted_array); $j++) {
# foreach($sorted_array as $index=>$ticket_info) {
# echo '<form action="/ticket_order.html" method="post">';
echo '<table width="100%" cellspacing="0">';
if ($ticket_index % 2 == 0) {
$class = "class=\"even\"";
} else {
$class = "class=\"odd\"";
}
echo "\n<tr {$class}>";
echo '<td width="' . $SECTION_WIDTH . '"><strong>Section: </strong>' . $sorted_array[$j]['SeatSection'] . "\n" . '</td><td width="' . $ROW_WIDTH . '"><strong>Row: </strong>' . $sorted_array[$j]['SeatRow'] . '</td><td width="' . $PRICE_WIDTH . '">' . $sorted_array[$j]['TicketPrice'] . '</td><td width="' . $SEAT_WIDTH . '">' . $sorted_array[$j]['SeatFrom'] . "-" . $sorted_array[$j]['SeatThru'] . '</td>';
echo '<td width="' . $QUANTITY_WIDTH . '">';
echo '<select id="Ticks' . $ticket_index . '">';
$split_ary = explode(' ', $sorted_array[$j]['ValidSplits']);
echo $sorted_array[$j]['ValidSplits'] . "<br/>";
for ($i = 0; $i < count($split_ary); $i++) {
echo '<option>' . $split_ary[$i] . '</option>';
}
echo '</select>';
echo '</td>';
$section_lower = strtolower($sorted_array[$j]['SeatSection']);
$seat_lower = strtolower($sorted_array[$j]['SeatRow']);
$ticketid = $sorted_array[$j]['TicketID'];
# echo "\n<span class=\"tiny\">Up to " . $sorted_array[$j]['Available'] . " Available</span>";
# echo "</td>";
#########
# OLD, non-framed
# https://tickettransaction2.com/Checkout.aspx?brokerid=982&sitenumber=6&tgid=455676449&treq=8&evtID=545276&price=187.00&SessionId=JFv2u
$tprice = substr($sorted_array[$j]['TicketPrice'], 1);
$session_id = GenerateSessionId();
$req_quantity = 1;
echo '<td width="' . $BUYNOW_WIDTH . '">';
echo '<a target="_self" href="javascript:SubmitPurchaseLink(' . "'Ticks{$ticket_index}', '" . $sorted_array[$j]['TicketID'] . "', '{$tprice}', '{$productionID}')" . '">';
echo '<img src="' . $root_url . '/Images/tickets_br.gif" alt="Buy ' . $eventName . " " . $venueName . " Section " . $sorted_array[$j]['SeatSection'] . " Row " . $sorted_array[$j]['SeatRow'] . ' tickets"/></a>';
echo "\n";
echo "\n</tr>";
echo "\n<tr {$class}>\n<td style=\"text-align=left;\" colspan=\"6\"><span class=\"tiny\">" . utf8_decode($sorted_array[$j]['Descr']) . "</span></td></tr>";
echo "\n</table>";
$ticket_index++;
}
if ($num_pages > 1) {
print_page_nav($startFrom, $num_pages, $sortBy, $sortOrder, $productionID);
}
echo "</div>";
}
function ticketslist_to_sorted_grouped($sortBy, $sortOrder, $ticket_list, $startFrom, $eventName, $eventDate, $venueName, $productionID, $city)
{
include '../include/host_info.inc.php';
global $query_string;
global $eventTypeID;
# Section Row Price Seat Quanity Button
$SECTION_WIDTH = "29%";
$ROW_WIDTH = "15%";
$PRICE_WIDTH = "15%";
$SEAT_WIDTH = "13%";
$QUANTITY_WIDTH = "12%";
$BUYNOW_WIDTH = "16%";
$MAX_TIX_PP = 500;
$NUM_TIX_PP = $MAX_TIX_PP;
echo '<div class="tickets">';
$num_pages = ceil((double) count($ticket_list) / (double) $MAX_TIX_PP);
#echo count($ticket_list) . " tickets sets available for this Event<br/>";
if ($num_pages > 1) {
print_page_nav($startFrom, $num_pages, $sortBy, $sortOrder, $productionID);
}
$image_path = "{$root_url}/Images/";
$image_up = "arrow-up.gif";
$image_down = "arrow-down.gif";
$image_none = "arrow-none.gif";
$ticket_limit_reached = 0;
if ($sortBy == 'sec' || $sortBy == 'row') {
foreach ($ticket_list as $key => $row) {
$SeatSection[$key] = $row['SeatSection'];
$TicketPrice[$key] = $row['TicketPrice'];
$SeatRow[$key] = $row['SeatRow'];
}
if ($sortOrder == 'desc') {
$sortOrderCode = SORT_DESC;
} else {
$sortOrderCode = SORT_ASC;
}
if ($sortBy == 'sec') {
array_multisort($SeatSection, $sortOrderCode, $TicketPrice, SORT_ASC, $ticket_list);
} else {
array_multisort($SeatRow, $sortOrderCode, $TicketPrice, SORT_ASC, $ticket_list);
}
$sorted_array = $ticket_list;
} elseif ($sortBy == 'pr') {
if ($sortOrder == 'desc') {
$sorted_array = $ticket_list;
} else {
$sorted_array = array_reverse($ticket_list);
}
} else {
$sorted_array = array_reverse($ticket_list);
}
echo '<table width="100%" cellspacing="0">';
$url = make_production_url($eventName, $productionID, $city, $eventTypeID);
$url_array = explode('?', $url);
$url = $url_array[0];
$query_string = "&event_id={$productionID}";
echo "<tr class=\"tableHeading\">";
$sortable_columns = array("sec" => "Section", "row" => "Row", "pr" => "Price");
foreach ($sortable_columns as $columnID => $columnHeading) {
if (strlen($sortBy) == 0 && $columnID == 'pr') {
$nextSortOrder = 'desc';
$arrow = $image_path . $image_up;
} elseif ($sortBy == $columnID) {
if ($sortOrder == 'desc') {
$nextSortOrder = 'asc';
$arrow = $image_path . $image_down;
} else {
$nextSortOrder = 'desc';
$arrow = $image_path . $image_up;
}
} else {
$nextSortOrder = 'asc';
$arrow = $image_path . $image_none;
}
if ($columnID == 'sec') {
echo '<th width="' . $SECTION_WIDTH . '">';
} elseif ($columnID == 'pr') {
echo '<th width="' . $PRICE_WIDTH . '">';
} else {
echo '<th width="' . $ROW_WIDTH . '">';
}
$url_sort_params = $url . "?sortBy={$columnID}&sortOrder={$nextSortOrder}" . $query_string;
echo '<a href="' . $url_sort_params . "\">{$columnHeading}</a><img src=\"{$arrow}\" alt=\"↓\"/></th>";
}
echo '<th width="' . $SEAT_WIDTH . '">Seat No.</th><th width="' . $QUANTITY_WIDTH . '">Quantity</th><th width="' . $BUYNOW_WIDTH . '"> </th>';
echo "</tr>";
echo "</table>";
$ticket_index = 1;
for ($j = ($startFrom - 1) * $MAX_TIX_PP; $j < $startFrom * $MAX_TIX_PP - 1 && $j < count($sorted_array); $j++) {
# foreach($sorted_array as $index=>$ticket_info) {
# echo '<form action="/ticket_order.html" method="post">';
echo '<table width="100%" cellspacing="0">';
if ($ticket_index % 2 == 0) {
$class = "class=\"even\"";
} else {
$class = "class=\"odd\"";
}
echo "\n<tr {$class}>";
echo '<td width="' . $SECTION_WIDTH . '"><strong>Section: </strong>' . $sorted_array[$j]['SeatSection'] . "\n" . '</td><td width="' . $ROW_WIDTH . '"><strong>Row: </strong>' . $sorted_array[$j]['SeatRow'] . '</td><td width="' . $PRICE_WIDTH . '">' . $sorted_array[$j]['TicketPrice'] . '</td><td width="' . $SEAT_WIDTH . '">' . $sorted_array[$j]['SeatFrom'] . "-" . $sorted_array[$j]['SeatThru'] . '</td><td width="' . $QUANTITY_WIDTH . '"> ';
$section_lower = strtolower($sorted_array[$j]['SeatSection']);
$seat_lower = strtolower($sorted_array[$j]['SeatRow']);
if (preg_match("/^lawn\$/", $section_lower) || preg_match("/^ga\$/", $section_lower) || preg_match("/^g\\.a\$/", $section_lower) || preg_match("/^ga\$/", $seat_lower) || preg_match("/^g\\.a\\.\$/", $section_lower) || preg_match("/^ga\\.\$/", $seat_lower)) {
$min_num_tickets = 1;
} else {
if ($sorted_array[$j]['Available'] % 2 == 0) {
$min_num_tickets = 2;
} else {
$min_num_tickets = 1;
$max_num_tickets = $sorted_array[$j]['Available'];
$num_tickets_array = array();
for ($num_tickets = $min_num_tickets; $num_tickets <= $max_num_tickets; $num_tickets++) {
if ($max_num_tickets - $num_tickets != 1) {
$num_tickets_array[] = $num_tickets;
}
}
$num_tickets_descending_array = array_reverse($num_tickets_array);
}
}
$ticketid = $sorted_array[$j]['TicketID'];
echo "\n<span class=\"tiny\">Up to " . $sorted_array[$j]['Available'] . " Available</span>";
echo "</td>";
#########
# OLD, non-framed
echo '<td width="' . $BUYNOW_WIDTH . '"><a href="https://www.ticketsnow.com/buytickets.aspx?id=' . $ticketid . '&reqqty=0&client=4089" rel="nofollow"><img src="/Images/buy_tix.png" onmouseover="this.src=\'/Images/buy_tix_mouse_over.png\';" onmouseout="this.src=\'/Images/buy_tix.png\';" alt="' . "Buy {$eventName} {$venueName} Section " . $sorted_array[$j]['SeatSection'] . " Row " . $sorted_array[$j]['SeatRow'] . ' tickets"/></a>';
# echo ' <input type="image" src="/Images/buy_tix.png" onmouseover="this.src=\'/Images/buy_tix_mouse_over.png\';" onmouseout="this.src=\'/Images/buy_tix.png\';" value="Submit" alt="' . "Buy $eventName $venueName Section " . $sorted_array[$j]['SeatSection'] . " Row " . $sorted_array[$j]['SeatRow'] . ' tickets" /></td>';
#########
echo '<td width="18%">';
# echo '<input type="hidden" name="ticket_id" value="' . $ticketid . '"/>';
# echo '<input type="hidden" name="event_name" value="' . $eventName . '"/>';
# echo '<input type="hidden" name="event_date" value="' . $eventDate . '"/>';
# echo '<input type="hidden" name="venue_name" value="' . $venueName . '"/>';
# echo '<input type="hidden" name="quantity" value="0"/>';
# echo ' <input type="image" src="/Images/buy_tix.png" onmouseover="this.src=\'/Images/buy_tix_mouse_over.png\';" onmouseout="this.src=\'/Images/buy_tix.png\';" value="Submit" alt="' . "Buy $eventName $venueName Section " . $sorted_array[$j]['SeatSection'] . " Row " . $sorted_array[$j]['SeatRow'] . ' tickets" /></td>';
# echo '<input type="hidden" name="quantity" value="0"/> <input type="image" src="/Images/buy_tix.png" value="Submit" alt="' . "Buy $eventName $venueName Section " . $sorted_array[$j]['SeatSection'] . " Row " . $sorted_array[$j]['SeatRow'] . ' tickets" /></td>';
# old echo '<input type="hidden" name="quantity" value="0"/> <button title="Buy these Tickets." type="submit" name="submit" value="1">Order</button></td>';
#echo "<td><span class=tiny>" . utf8_decode($sorted_array[$j]['Descr']) . "</span> </td>";
# # echo "</form>";
echo "</tr>";
echo "<tr {$class}><td style=\"text-align=left;\" colspan=\"6\"><span class=\"tiny\">" . utf8_decode($sorted_array[$j]['Descr']) . "</span></td></tr>";
echo "</table>";
#echo "</form>";
$ticket_index++;
}
if ($num_pages > 1) {
print_page_nav($startFrom, $num_pages, $sortBy, $sortOrder, $productionID);
}
echo "</div>";
}
echo "{$action}</td>";
echo '<td align="left" width="4%"> ' . $dates . '</td>';
echo '<td align="left" width="30"> ' . $ID . '<input type="hidden" name="ID_' . $i . '" id="ID_' . $i . '" value="' . $ID . '"/></td>';
$ev_url = make_event_url($name);
$ev_url = "www.mongotickets.com" . $ev_url;
echo '<td align="left" width="33%"><input type="text" value="' . $ev_url . '" size="60"/></td>';
echo '</tr>';
$i++;
}
echo '<tr>
<td colspan="9" align="center"> <input type="submit" value="Update" /> </td>
</tr>';
echo '</form>';
echo '</table>';
if ($num_pages > 1) {
print_page_nav($start, $num_pages, $url_params);
}
} else {
}
mysql_close($dbh);
} else {
print 'I cannot connect to the database because: ' . mysql_error();
}
ob_end_flush();
function Breadcrumbs($categoryID, $eventID)
{
$Bsql = "SELECT C.CategoryID, C.CategoryName" . " FROM ModifiedPreorderTreeTraversalCategories AS B, ModifiedPreorderTreeTraversalCategories AS C" . " WHERE (B.lft BETWEEN C.lft AND C.rgt)" . " AND (B.CategoryID = {$categoryID})" . " ORDER BY C.lft";
#Might want to change to (B.lft BETWEEN (C.lft+1) AND C.rgt)
$result = mysql_query($Bsql);
$top_level_category_array = array(2, 3, 4);
$breadcrumb_string = "";
