<?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!";