", "", "", ""); // Functions //****************************************************************************** // Create the reservation table. If $old=True, then list reservations // that have already passed. //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ function createResTable ($old) { // Generate date condition $old? $curDateTime = "<='" : $curDateTime = ">'" ; // Format: 22 January 2006 4:30 PM $curDateTime .= date('d F Y g\:i A\''); $sql = "SELECT ReservationID, TotalPrice FROM Reservations NATURAL JOIN FlightReservations WHERE CustomerID=3"; $res = $DB->dbQuery($sql, __FILE__, __LINE__); $table = ""; // Go through each reservation, and build the table while($row = $res->fetchRow()) { $resID = $row['ReservationID']; $price = $row['TotalPrice']; $sql=" SELECT SeatID FROM Seats NATURAL JOIN FlightDates NATURAL JOIN FlightSegments WHERE ReservationID='" . $resID . "' AND (DepartureDate + DepartureTime) " . $curDateTime; echo $sql; $table .= ""; } return table; } // Page Generation //****************************************************************************** if(isset($_GET['method'])) { // Past Reservations //~~~~~~~~~~~~~~~~~~~~~ if($_GET['method'] == "pastflights") { /* Set Up Page */ $cssincludes[] = "myflights_container.css"; $PAGECLASS = & new Page($cssincludes); $TMP = & new Template("templates/content/tmp_comingflights.php"); $table = createResTable(True); /* Pass in Variables */ $TMP->set("method", "pastflights"); $TMP->set("resTable", $table); /* Render It */ $PAGECLASS->set("content", $TMP); $PAGECLASS->render("templates/layout/lo_main.php"); } // Details Page for selected reservation //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ if($_GET['method'] == "flightdetails") { /* Set Up Page */ $cssincludes[] = "myflights_container.css"; $PAGECLASS = & new Page($cssincludes); $TMP = & new Template("templates/content/tmp_comingflights.php"); /* Pass in Variables */ $TMP->set("method", "flightdetails"); /* Render It */ $PAGECLASS->set("content", $TMP); $PAGECLASS->render("templates/layout/lo_main.php"); } } // Upcoming Reservations //~~~~~~~~~~~~~~~~~~~~~~~~~~ else { /* Set Up Page */ $cssincludes[] = "myflights_container.css"; $PAGECLASS = & new Page($cssincludes); $TMP = & new Template("templates/content/tmp_comingflights.php"); $table = createResTable(False); /* Pass in Variables */ $TMP->set("method", false); $TMP->set("resTable", $table); /* Render It */ $PAGECLASS->set("content", $TMP); $PAGECLASS->render("templates/layout/lo_main.php"); } // Cleanup //****************************************************************************** $DB->dbClose(); ?>