<?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();
// 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";
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 "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
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
$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
$insertSQL = "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`) \n VALUES ('{$aircraftid}', '{$from}', '{$to}', '{$nmDist}', '{$paxOpt}', '{$picOpt}', '{$sicOpt}', '{$headOpt}'\n , '{$bOff}', '{$bOn}', '{$tOff}', '{$lndng}', '{$fTime}', '{$dFuel}', '{$aFuel}', '{$uFuel}', '{$natOpt}', '{$cliOpt}', '{$fTime}','{$today}','{$today}')";
// Update Aircraft Stat
$updateSQL = "UPDATE aircraft SET airframe_hrs=airframe_hrs+{$fTime}, \n\t\tengine1_hours=engine1_hours+{$fTime}, \n\t\tengine2_hours=engine2_hours+{$fTime},\n\t\tengine1_cycles=engine1_cycles+{$fTime}, \n\t\tengine2_cycles=engine2_cycles+{$fTime},\n\t\tupdated_at = '{$today}' WHERE aircraftid = {$aircraftid}";
// Run insert query
$rs = $airops->exec($insertSQL);
$status = $airops->conn->insert_id;
// Insert into air
$rs = $airops->exec("INSERT INTO air(`sector_id`,`aircraftid`) VALUES('{$status}','{$aircraftid}')");
// Update Aircraft stats
$rs = $airops->exec($updateSQL);
echo "Added Sector {$status} Successfully!";
