$request->addParameter('endDate', $_POST['REGION_ENDDATE']);
/* Create layout for table */
$table = '<table class="table table-hover">' . '<thead>' . '<tr>' . '<th>Region</th>' . '<th>Number of On-Time Flights</th>' . '</tr>' . '</thead>' . '<tbody>';
}
}
/* Transform the request into a command */
$request->transformCommand();
/* database manager executes query */
$results = $dbMan->executeQuery($request);
if ($results == null) {
//request failed
} else {
$rows = $results->num_rows;
for ($i = 0; $i < $rows; ++$i) {
$results->data_seek($i);
$row = $results->fetch_array(MYSQLI_NUM);
$table = $table . '<tr>';
for ($j = 0; $j < count($row); ++$j) {
$table = $table . '<td>' . $row[$j] . '</td>';
}
$table = $table . '</tr>';
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table>';
$table = $table . '<button type="button" class="btn btn-primary generateModel" onClick="' . $request->type . '(this)">Generate Model</button>';
showExportButton('#regions .export');
}
}
echo $table;
$results->data_seek($i);
$row = $results->fetch_array(MYSQLI_NUM);
$table = $table . '<tr>';
for ($j = 0; $j < count($row); ++$j) {
$table = $table . '<td>' . $row[$j] . '</td>';
}
if ($request->type == 'getProbabilityOfDelay') {
$total++;
if ($row[5] < $row[6]) {
$table = $table . '<td><span class="label label-danger">Delayed</span></td></tr>';
$delays++;
} else {
$table = $table . '<td><span class="label label-success">On-Time</span></td></tr>';
}
}
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table>';
if ($rows > 0 && $request->type != 'getProbabilityOfDelay') {
$table = $table . '<button type="button" class="btn btn-primary generateModel" onClick="' . $request->type . '(this)">Generate Model</button>';
}
if ($request->type == 'getProbabilityOfDelay' && $rows > 0) {
$delayPercentage = round($delays / $total * 100, 2);
$table = $table . '<h4>' . $_POST['AIRLINE_NAME'] . ' probability of delays departing from the ' . $_POST['AIRLINE_REGION'] . ': <span class="label label-default">' . $delayPercentage . '%</span></h4>';
}
showExportButton('#airlines .export');
}
}
echo $table;
$table = '<table class="table table-hover">' . '<thead>' . '<tr>' . '<th>Airspace Id</th>' . '<th>Airspace Point 1</th>' . '<th>Airspace Point 2</th>' . '<th>Number of Cancellation Messages</th>' . '<th></th>' . '</tr>' . '</thead>' . '<tbody>';
}
}
}
}
/* Transform the request into a command */
$request->transformCommand();
/* database manager executes query */
$results = $dbMan->executeQuery($request);
if ($results == null) {
//request failed
} else {
$rows = $results->num_rows;
for ($i = 0; $i < $rows; ++$i) {
$results->data_seek($i);
$row = $results->fetch_array(MYSQLI_NUM);
$table = $table . '<tr>';
for ($j = 0; $j < count($row); ++$j) {
$table = $table . '<td>' . $row[$j] . '</td>';
}
$table = $table . '<td><button type="button" class="btn btn-primary plotButton">Plot</button></td>';
$table = $table . '</tr>';
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table><script type="text/javascript">$(document).ready(function(){ initMap(); });</script>';
showExportButton('#airspace .export');
}
}
echo $table;
}
$table = $table . '</tr>';
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table>';
if ($request->type == 'getDelayedFlights' && $rows > 0) {
$table = $table . '<h5 style="float: right">Number of delayed flights from ' . $request->fields['depart_airport'] . ' to ' . $request->fields['arrival_airport'] . ' between ' . $request->fields['startDate'] . ' and ' . $request->fields['endDate'] . ': <span class="label label-default">' . $rows . '</span></h5>';
$table = $table . '<h4>Average Delay Time: <span class="label label-default">' . round($delaySum / $rows, 2) . ' minutes</span></h4>';
} else {
if ($request->type == 'getOnTimeFlights' && $rows > 0) {
$table = $table . '<h4>Number of on-time flights from ' . $request->fields['depart_airport'] . ' to ' . $request->fields['arrival_airport'] . ' between ' . $request->fields['startDate'] . ' and ' . $request->fields['endDate'] . ': <span class="label label-default">' . $rows . '</span></h4>';
}
}
showExportButton('#flights .export');
}
}
echo $table;
/* Subtracts two time quantities HH:MM:SS
* Returns the number of minutes between two times */
function subtractTime($t1, $t2)
{
/* Split time strings by ':' */
$t1 = explode(":", $t1);
$t2 = explode(":", $t2);
/* Create Decimal representations of time */
$t1 = $t1[0] . '.' . $t1[1];
$t2 = $t2[0] . '.' . $t2[1];
/* Calculate the difference between the times
* Round to 2 decimal places */
$table = $table . '<td><span class="label label-danger">Delayed</span></td></tr>';
$delays++;
} else {
$table = $table . '<td><span class="label label-success">On-Time</span></td></tr>';
}
}
$table = $table . '</tr>';
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table>';
if ($rows > 0 && $request->type == 'getAirportsByDelays') {
$table = $table . '<button type="button" class="btn btn-primary generateModel" onClick="' . $request->type . '(this)">Generate Model</button>';
}
if ($request->type == 'getDelayedDeparturesByAirport') {
$table = $table . '<h4>Number of delayed flights departing from ' . $request->fields['airport'] . ' between ' . $request->fields['startDate'] . ' and ' . $request->fields['endDate'] . ': <span class="label label-default">' . $rows . '</span></h4>';
} else {
if ($request->type == 'getDelayedArrivalsByAirport') {
$table = $table . '<h4>Number of delayed flights arriving to ' . $request->fields['airport'] . ' between ' . $request->fields['startDate'] . ' and ' . $request->fields['endDate'] . ': <span class="label label-default">' . $rows . '</span></h4>';
} else {
if ($request->type == 'getPercentageDelayedDeparturesByAirport' && $rows > 0) {
$delayPercentage = round($delays / $total * 100, 2);
$table = $table . '<h4>Percentage of delayed departures for ' . $request->fields['airport'] . ' between ' . $request->fields['startDate'] . ' and ' . $request->fields['endDate'] . ' : <span class="label label-primary">' . $delayPercentage . '%' . '</span></h4>';
}
}
}
showExportButton('#airports .export');
}
}
echo $table;
} else {
if ($orderBy == 'sort_by_flightNumber') {
$request->addParameter('orderBy', 'flight_number');
}
}
/* Transform command */
$request->transformCommand();
/* Execute Query */
$results = $dbMan->executeQuery($request);
if ($results == null) {
//request failed
} else {
$rows = $results->num_rows;
$total = 0;
$delays = 0;
for ($i = 0; $i < $rows; ++$i) {
$results->data_seek($i);
$row = $results->fetch_array(MYSQLI_NUM);
$table = $table . '<tr>';
for ($j = 0; $j < count($row); ++$j) {
$table = $table . '<td>' . $row[$j] . '</td>';
}
}
if ($rows == 0) {
$table = $table . '<tr><td>No items</td></tr>';
}
$table = $table . '</tbody></table>';
showExportButton('#messages .export');
}
}
echo $table;
