<?php
include "airops_con.php";
include "BcryptHasher.php";
//Instantiate custom DB class
$airops = new AiropsDB();
//Instantiate BcryptHasher class
$bcrypt = new BcryptHasher();
$username = $_POST['userN'];
$password = $_POST['passW'];
$query = "SELECT * FROM users where username='******' LIMIT 1";
// Run select query
$rs = $airops->exec($query);
$user = $rs->fetch_assoc();
if ($user) {
$isValid = $bcrypt->checkhash($password, $user['password']);
if ($isValid) {
// return user as json object
echo json_encode($user);
} else {
echo json_encode(array("error" => 1));
}
} else {
echo json_encode(array("error" => 1));
}
<?php
include "conn/airops_con.php";
//include("BcryptHasher.php");
//Instantiate custom DB class
$airops = new AiropsDB();
//Instantiate BcryptHasher class$bcrypt = new BcryptHasher;
$airport = $_POST['bCom'];
$icao = $_POST['icao'];
$city = $_POST['aCom'];
$insertSQL = "INSERT into `airports` (`airport`,`ICAO`,`city`) VALUES ('{$airport}','{$icao}','{$city}')";
// Run insert query
$rs = $airops->exec($insertSQL);
//echo $ra;
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Startup Details
$airID = $_REQUEST['aircraftid'];
$regN = $_REQUEST['registration'];
$clSgn = $_REQUEST['callsign'];
$serial = $_REQUEST['serial'];
$type = $_REQUEST['type'];
// Insert Query
$insertSQL = "SELECT `aircraftid`,`registration`,`type`,`serial`,`callsign` FROM `aircraft` WHERE `aircraftid`=2";
echo $getSQL;
// Run insert query
$ra = $airops->exec($getSQL);
echo "Added Details {$status} Successfully";
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
$today = date('Y-m-d');
// Get aircraft id
$aircraftid = $_GET['aircraftid'];
// Select Aircraft Status
$selectSQL = "SELECT * from document where entityid={$aircraftid} ORDER BY `expires` ASC";
// Fetch result set and display details
$rs = $airops->exec($selectSQL);
while ($docs = $rs->fetch_assoc()) {
$diff = round($airops->date_diff($docs['expires'], $today) / 24);
?>
<tr>
<td>
<?php
if ($diff < 14) {
echo '<span class="badge badge-danger">' . $diff . '</span>';
} else {
if ($diff >= 14 && $diff < 28) {
echo '<span class="badge badge-warning">' . $diff . '</span>';
} else {
echo '<span class="badge badge-inverse">' . $diff . '</span>';
}
}
?>
</td>
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
$today = date('Y-m-d') . " ";
// Get aircraft id
$aircraftid = $_GET['aircraftid'];
// Select Aircraft Status
$selectSQL = "SELECT nextinspection, status, airframe_hrs, landings, engine1_cycles, \n engine1_hours, engine2_cycles, engine2_hours, apu_hours \n from aircraft where aircraftid={$aircraftid}";
// Fetch result set and display details
$rs = $airops->exec($selectSQL);
while ($stat = $rs->fetch_assoc()) {
?>
<div class="panel" id="maintenance">
<div class="panel-heading">
<div class="panel-title"> <i class="fa fa-bar-chart-o"></i> AIRCRAFT STATS</div>
</div>
<div id="aircraft_stat">
<div class="panel-body" id="maintenance" align="center">
<div class="stats" align="center">
<fieldset><legend>Engine</legend>
<table class="sTable" id="engine">
<tr>
<td></td>
<td># 1</td>
<td># 2</td>
<td>APU</td></tr>
<tr><td>HOURS</td>
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include "airops_con.php";
//include("BcryptHasher.php");
//Instantiate custom DB class
$airops = new AiropsDB();
$q = strtolower($_GET["term"]);
//Instantiate BcryptHasher class$bcrypt = new BcryptHasher;
//$name = $_POST['name'];
$return = array();
$getSQL = "SELECT *, CONCAT(icao,', ',airport,', ',city) AS fullAir FROM airports WHERE airport LIKE '%{$q}%' OR city LIKE '%{$q}%' or icao LIKE '%{$q}%'";
$query = $airops->exec($getSQL);
while ($row = mysql_fetch_array($query)) {
array_push($return, array('label' => $row['fullAir'], 'value' => $row['fullAir']));
}
echo json_encode($return);
<?php
include 'airops_con.php';
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
// Get aircraft id
$aircraftid = $_GET['aircraftid'];
//$aircraftid = 2;
$query = "select * from crew where aircraftid = {$aircraftid}";
$result = $airops->exec($query);
while ($data = $result->fetch_assoc()) {
echo "<td>{$data['position']}: <span>{$data['displayname']}</span> <span>{$data['codeno']}</span></td>";
}
$result->free();
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
$today = date('Y-m-d H:m:s');
$air = $_POST["air"];
// Store Air [ array of sectors ]
$fTime = 0;
// Total Flight time per air
$aircraftid = $air[0]['aircraftid'];
// Run insert query
$rs = $airops->exec("INSERT INTO air(`aircraftid`,`air`) values('{$aircraftid}', uuid())");
$airid = $airops->conn->insert_id;
// Insert sectors
// ('{$aircraftid}', '{$from}', '{$to}', '{$nmDist}', '{$paxOpt}', '{$picOpt}', '{$sicOpt}', '{$headOpt}'
// , '{$bOff}', '{$bOn}', '{$tOff}', '{$lndng}', '{$fTime}', '{$dFuel}', '{$aFuel}', '{$uFuel}', '{$natOpt}', '{$cliOpt}', '{$fTime}','{$today}','{$today}')
//$city = $mysqli->escape($city);
$insertArr = array();
foreach ($air as $i => $s) {
$insertArr[] = "('{$mysqli->escape($s['aircraftid'])}', '{$mysqli->escape($s['from'])}', '{$mysqli->escape($s['to'])}', '{$mysqli->escape($s['dist'])}', '{$mysqli->escape($s['pax'])}', \n\t\t\t'{$mysqli->escape($s['pic'])}', '{$mysqli->escape($s['sic'])}', '{$mysqli->escape($s['hca'])}', '{$mysqli->escape($s['block_off'])}', '{$mysqli->escape($s['block_on'])}', \n\t\t\t'{$mysqli->escape($s['flight_off'])}', '{$mysqli->escape($s['flight_on'])}', '{$mysqli->escape($s['airframe'])}', '{$mysqli->escape($s['departure_fuel'])}', '{$mysqli->escape($s['arrival_fuel'])}', \n\t\t\t" . ($mysqli->escape($s['departure_fuel']) - $mysqli->escape($s['arrival_fuel'])) . ", '{$mysqli->escape($s['nature'])}', '{$mysqli->escape($s['client'])}', '{$mysqli->escape($s['airframe'])}','{$today}','{$today}','{$airid}')";
$fTime += $s['airframe'];
// sum uasort(array, cmp_function)p flight times
}
// Prepare query
$query = "INSERT INTO `sector` (`aircraftid`, `from`, `to`, `dist`, `pax`, `pic`, `sic`, `hca`, `block_off`, `block_on`, \n `flight_off`, `flight_on`, `airframe`, `departure_fuel`, `arrival_fuel`, `fuel_used`, `nature`, `client`, `leg`, `created_at`, `updated_at`,`air_id`) \n VALUES " . implode(", ", $insertArr);
// Insert sectors
$rs = $airops->exec($query);
// Update Aircraft Stats
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
$today = date('Y-m-d H:m:s');
// Sector Details
$aircraftid = $_POST['aircraftid'];
//$aircraftid = $_POST['airReg'];
$from = $_POST['frOpt'];
$to = $_POST['toOpt'];
$picOpt = $_POST['picOpt'];
$sicOpt = $_POST['sicOpt'];
$headOpt = $_POST['headOpt'];
$paxOpt = $_POST['paxOpt'];
$natOpt = $_POST['natOpt'];
$cliOpt = $_POST['cliOpt'];
$bOff = $_POST['bOff'];
$tOff = $_POST['tOff'];
$lndng = $_POST['lndng'];
$bOn = $_POST['bOn'];
$dFuel = $_POST['dFuel'];
$aFuel = $_POST['aFuel'];
$uFuel = $dFuel - $aFuel;
$nmDist = $_POST['nmDist'];
$sLnd = $_POST['sLnd'];
$fTime = $_POST['flightTime'];
$bTime = $_POST['blockTime'];
// Insert Query
<?php
include "airops_con.php";
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
$today = date('Y-m-d');
// Get aircraft id
$aircraftid = $_GET['aircraftid'];
// Select Aircraft Status
$selectSQL = "SELECT aircraftid, registration, type, serial, callsign, nextinspection, status, airframe_hrs, landings \n from aircraft where aircraftid = {$aircraftid} LIMIT 1";
// Fetch result set and display details
$rs = $airops->exec($selectSQL);
while ($aircraft = $rs->fetch_assoc()) {
?>
<table id="sumTit">
<tr align="center">
<td class="fTitle" id="fTitle" colspan="2">
<b>FLIGHT FOLIO TECHNICAL LOG / DEFECT REPORT</b>
</td>
<td class="fTitle"></td>
<td class="fTitle sumDate">
Date: <span id="sumDate"><?php
echo date("d M Y");
?>
</span><br>
Log: <span id="logNum">41491</span>
</td>
</tr>
<tr>
<?php
include 'airops_con.php';
//Instantiate custom DB class
$airops = new AiropsDB();
// Set date to UTC
date_default_timezone_set('utc');
// Get aircraft id
$aircraftid = $_GET['aircraftid'];
$query = "select a.airframe_hrs, a.engine1_hours, a.engine2_hours, \n\ta.engine1_cycles, a.engine2_cycles, a.landings, s.* \n\tfrom aircraft a inner join sector s on a.aircraftid = s.aircraftid\n\twhere a.aircraftid = {$aircraftid}";
$result = $airops->exec($query);
echo "<tr>\n\t<tr>\n\t\t<td colspan='10'></td>\t\t\n\t\t<td colspan='2'>engine hours</td>\n\t\t<td colspan='2'>engine cycles</td>\t\t\t\t\n\t\t<td colspan='5'></td>\n\t</tr>\n\t<tr>\n\t\t<td>ID</td>\n\t\t<td>from</td>\n\t\t<td>to</td>\n\t\t<td>dist(nm)</td>\n\t\t<td>pic</td>\n\t\t<td>sic</td>\n\t\t<td>h c/a</td>\n\t\t<td>block time</td>\n\t\t<td>flight time</td>\n\t\t<td>airframe</td>\n\t\t<td>#1</td>\n\t\t<td>#2</td>\n\t\t<td>#1</td>\n\t\t<td>#2</td>\n\t\t<td>lnds</td>\n\t\t<td>fuel</td>\n\t\t<td>pax</td>\n\t\t<td>nature</td>\n\t\t<td>client</td>\n\t</tr>\t \n\t<!--<tr>\n\t\t<td colspan='9' align='right'><b><i>Totals carried forward </b></i></td>\n\t\t<td>3169.7</span></td>\n\t\t<td>3169.7</td>\n\t\t<td>3169.7</td>\n\t\t<td>3169.7</span></td>\n\t\t<td>9778</td>\n\t\t<td>2410</td>\n\t\t<td colspan='4' align='left'> (lbs)</td>\t\t\n\t</tr>-->\n</tr>";
$d2 = time();
$total_fTime = $total_bTime = $total_legs = $total_fuel = $total_pax = 0;
$total = array();
while ($data = $result->fetch_assoc()) {
$bTime = $airops->date_diff($data['block_on'], $data['block_off']);
$fTime = $airops->date_diff($data['flight_on'], $data['flight_off']);
echo "<tr>;\n <td align='center'>{$data['sectorid']}</td>\n <td align='center'>{$data['from']}</td>\n\t<td align='center'>{$data['to']}</td>\n\t<td align='center'>{$data['dist']}</td>\n\t<td align='center'>{$data['pic']}</td>\n\t<td align='center'>{$data['sic']}</td>\n\t<td align='center'>{$data['hca']}</td>\n\t<td align='center'>\n\t\t\tOFF " . date("H:m", strtotime($data['block_off'])) . "<span style='float:right; margin-right:5px'>" . $bTime . "</span><br/>\n\t\t\tON " . date("H:m", strtotime($data['block_on'])) . "\n\t\t</td>\n\t<td align='center'>\n\t\t\tOFF " . date("H:m", strtotime($data['flight_off'])) . "<span style='float:right; margin-right:5px'>" . $fTime . "</span><br/>\n\t\t\tON " . date("H:m", strtotime($data['flight_on'])) . "\n\t\t </td>\n\t<td align='center'>{$airops->date_diff($data['flight_on'], $data['flight_off'])}</td>\n\t<td align='center'>{$airops->date_diff($data['flight_on'], $data['flight_off'])}</td>\n\t<td align='center'>{$airops->date_diff($data['flight_on'], $data['flight_off'])}</td>\n\t<td align='center'>{$data['leg']}</td>\n\t<td align='center'>{$data['leg']}</td>\n\t<td align='center'>{$data['leg']}</td>\n\t<td align='center'>{$data['fuel_used']}</td>\n\t<td align='center'>{$data['pax']}</td>\n\t<td align='center'>{$data['nature']}</td>\n\t<td align='center'>{$data['client']}</td>\n\t</tr>";
$total_fTime += $fTime;
$total_bTime += $bTime;
$total_legs += $data['leg'];
$total_fuel += $data['fuel_used'];
$total_pax += $data['pax'];
$total = array($data['airframe_hrs'], $data['engine1_hours'], $data['engine2_hours'], $data['engine1_cycles'], $data['engine2_cycles'], $data['landings']);
}
//echo "overal = " .$result->num_rows;
echo "<tr>\n\t\t<td colspan='7' align='right'><b><i>Sub-Total: </b></i></td>\n\t\t<td style='margin-right:5px'>{$total_bTime}</td>\n\t\t<td style='margin-right:5px'>{$total_fTime}</td>\n\t\t<td>{$total_fTime}</td>\n\t\t<td>{$total_fTime}</td>\n\t\t<td>{$total_fTime}</td>\n\t\t<td>{$total_legs}</td>\n\t\t<td>{$total_legs}</td>\n\t\t<td>{$total_legs}</td>\n\t\t<td>{$total_fuel}</td>\n\t\t<td colspan='3' align='left'> {$total_pax}</td>\n\t</tr>\n\t<tr>\n\t\t<td align='right' colspan='8'><b><i>Grand-Total: </b></i></td>\t\t\n\t\t<td>{$total[0]}</td>\n\t\t<td>{$total[1]}</td>\n\t\t<td>{$total[2]}</td>\n\t\t<td>{$total[3]}</td>\n\t\t<td>{$total[4]}</td>\n\t\t<td>{$total[5]}</td>\n\t</tr>";
$result->free();
