<?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();