PHP Flight::GetFlightInfo方法代码示例

 public function GetCoordinates($flightId)
 {
     if (!is_int(intval($flightId))) {
         throw new Exception("Incorrect flightId passed into GetCoordinates FlightsController." . $flightId, 1);
     }
     $Fl = new Flight();
     $flight = $Fl->GetFlightInfo($flightId);
     unset($Fl);
     $bruType = $flight['bruType'];
     $apTableName = $flight['apTableName'];
     $bpTableName = $flight['bpTableName'];
     $Bru = new Bru();
     $bruInfo = $Bru->GetBruInfo($bruType);
     unset($Bru);
     $kmlScript = $bruInfo['kml_export_script'];
     $kmlScript = str_replace("[ap]", $apTableName, $kmlScript);
     $kmlScript = str_replace("[bp]", $bpTableName, $kmlScript);
     $c = new DataBaseConnector();
     $link = $c->Connect();
     $info = [];
     $averageLat = 0;
     $averageLong = 0;
     if (!$link->multi_query($kmlScript)) {
         //err log
         error_log("Impossible to execute multiquery: (" . $kmlScript . ") " . $link->error);
     }
     do {
         if ($res = $link->store_result()) {
             while ($row = $res->fetch_array()) {
                 $lat = $row['LAT'];
                 $long = $row['LONG'];
                 $h = $row['H'];
                 $averageLat += $lat;
                 $averageLong += $long;
                 $averageLat /= 2;
                 $averageLong /= 2;
                 if ($h < 0) {
                     $h = 10.0;
                 }
                 $h = round($h, 2);
                 $info[] = [$long, $lat, $h];
             }
             $res->free();
         }
     } while ($link->more_results() && $link->next_result());
     $c->Disconnect();
     unset($c);
     return $info;
 }

 public function copyTemplate($flightId, $oldName)
 {
     $Fl = new Flight();
     $flightInfo = $Fl->GetFlightInfo($flightId);
     unset($Fl);
     $bruType = $flightInfo['bruType'];
     $Bru = new Bru();
     $bruInfo = $Bru->GetBruInfo($bruType);
     $tableName = $bruInfo['paramSetTemplateListTableName'];
     unset($Bru);
     $newName = date('Y-m-d') . '_' . $this->_user->username . '_' . $this->generateRandomString(3);
     $username = $this->_user->username;
     $PSTempl = new PSTempl();
     $tpl = $PSTempl->getTemplate($tableName, $oldName, $username);
     $PSTempl->createTemplate($newName, $tpl, $tableName, $username);
     unset($PSTempl);
     return 'ok';
 }

 public function SearchByAlgorithm($algId, $flightsArr)
 {
     $foundFlights = [];
     $SF = new SearchFlights();
     $searchAlg = $SF->GetSearchAlgorithById($algId);
     unset($SF);
     $F = new Flight();
     if ($searchAlg) {
         foreach ($flightsArr as $flightid) {
             $query = $searchAlg['alg'];
             $flightInfo = $F->GetFlightInfo($flightid);
             $apTableName = $flightInfo['apTableName'];
             $bpTableName = $flightInfo['bpTableName'];
             $query = str_replace("[ap]", $apTableName, $query);
             $query = str_replace("[bp]", $bpTableName, $query);
             foreach ($flightInfo as $flightInfoKey => $flightInfoVal) {
                 $query = str_replace("[" . $flightInfoKey . "]", $flightInfoVal, $query);
             }
             $c = new DataBaseConnector();
             $link = $c->Connect();
             if (!$link->multi_query($query)) {
                 //err log
                 error_log("Impossible to execute multiquery: (" . $query . ") " . $link->error);
             }
             do {
                 if ($res = $link->store_result()) {
                     $resultArr = array();
                     if ($row = $res->fetch_array()) {
                         $foundFlights[] = $flightInfo;
                     }
                     $res->free();
                 }
             } while ($link->more_results() && $link->next_result());
             $c->Disconnect();
             unset($c);
         }
     }
     unset($F);
     return $foundFlights;
 }

 public function GetTableStep($flightId)
 {
     $F = new Flight();
     $flightInfo = $F->GetFlightInfo($flightId);
     unset($F);
     $FDR = new Bru();
     $FDRinfo = $FDR->GetBruInfo($flightInfo['bruType']);
     unset($FDR);
     $userId = $this->_user->GetUserIdByName($this->_user->username);
     $O = new UserOptions();
     $step = $O->GetOptionValue($userId, 'printTableStep');
     unset($O);
     if ($step === null) {
         $step = 0;
     } else {
         $step = $step * $FDRinfo['stepDivider'];
     }
     return $step;
 }

 public function ImportFlight($importedFileName)
 {
     $copiedFilesDir = UPLOADED_FILES_PATH;
     $copiedFilePath = $copiedFilesDir . $importedFileName;
     $zip = new ZipArchive();
     $res = $zip->open($copiedFilePath);
     $importFolderName = sprintf("Imported_%s", date('Y-m-d'));
     $needToCreateImportedFolder = true;
     $Fl = new Flight();
     $Bru = new Bru();
     $Fr = new Frame();
     $FlE = new FlightException();
     $Fd = new Folder();
     $folderInfo = [];
     $userId = $this->_user->GetUserIdByName($this->_user->username);
     if ($res === TRUE) {
         $i = 0;
         $headerFiles = [];
         do {
             $fileName = $zip->getNameIndex($i);
             if (strpos($fileName, "header") !== false) {
                 $headerFiles[] = $fileName;
             }
             $i++;
         } while ($i < $zip->numFiles);
         foreach ($headerFiles as $name) {
             $zip->extractTo($copiedFilesDir, $name);
             $json = file_get_contents($copiedFilesDir . "/" . $name);
             unlink($copiedFilesDir . "/" . $name);
             $flightInfoImported = json_decode($json, true);
             $bruType = $flightInfoImported['bruType'];
             $flightId = $Fl->InsertNewFlight($flightInfoImported['bort'], $flightInfoImported['voyage'], $flightInfoImported['startCopyTime'], $flightInfoImported['bruType'], $flightInfoImported['performer'], $flightInfoImported['departureAirport'], $flightInfoImported['arrivalAirport'], $importedFileName, $flightInfoImported['flightAditionalInfo']);
             $flightInfo = $Fl->GetFlightInfo($flightId);
             $tableNameAp = $flightInfo['apTableName'];
             $tableNameBp = $flightInfo['bpTableName'];
             $bruInfo = $Bru->GetBruInfo($bruType);
             $apPrefixes = $Bru->GetBruApCycloPrefixes($bruType);
             $bpPrefixes = $Bru->GetBruBpCycloPrefixes($bruType);
             $apCyclo = $Bru->GetBruApCycloPrefixOrganized($bruType);
             $tables = $Fl->CreateFlightParamTables($flightId, $apCyclo, $bpPrefixes);
             $apTables = $flightInfoImported["apTables"];
             for ($j = 0; $j < count($apTables); $j++) {
                 $zip->extractTo($copiedFilesDir, $apTables[$j]["file"]);
                 if (file_exists($copiedFilesDir . $apTables[$j]["file"])) {
                     $Fr->LoadFileToTable($tableNameAp . "_" . $apTables[$j]["pref"], $copiedFilesDir . $apTables[$j]["file"]);
                     unlink($copiedFilesDir . $apTables[$j]["file"]);
                 }
             }
             $bpTables = $flightInfoImported["bpTables"];
             for ($j = 0; $j < count($bpTables); $j++) {
                 $zip->extractTo($copiedFilesDir, $bpTables[$j]["file"]);
                 if (file_exists($copiedFilesDir . $bpTables[$j]["file"])) {
                     $Fr->LoadFileToTable($tableNameBp . "_" . $bpTables[$j]["pref"], $copiedFilesDir . $bpTables[$j]["file"]);
                     unlink($copiedFilesDir . $bpTables[$j]["file"]);
                 }
             }
             if (isset($flightInfoImported["exTableName"]) && $flightInfoImported["exTableName"] != "") {
                 $tableGuid = substr($tableNameAp, 0, 14);
                 $FlE->CreateFlightExceptionTable($flightId, $tableGuid);
                 $flightInfo = $Fl->GetFlightInfo($flightId);
                 $exTables = $flightInfoImported["exTables"];
                 $zip->extractTo($copiedFilesDir, $exTables);
                 $Fr->LoadFileToTable($flightInfo["exTableName"], $copiedFilesDir . $exTables);
                 if (file_exists($copiedFilesDir . $exTables)) {
                     unlink($copiedFilesDir . $exTables);
                 }
             }
             $this->_user->SetFlightAvaliable($this->_user->username, $flightId);
             if (count($headerFiles) > 1) {
                 if ($needToCreateImportedFolder) {
                     $folderInfo = $Fd->CreateFolder($importFolderName, 0, $userId);
                     $needToCreateImportedFolder = false;
                 }
                 if (isset($folderInfo['folderId'])) {
                     $Fd->PutFlightInFolder($flightId, $folderInfo['folderId'], $userId);
                 } else {
                     $Fd->PutFlightInFolder($flightId, 0, $userId);
                     //we put currently uploaded file in root
                 }
             } else {
                 //into root if only one
                 $Fd->PutFlightInFolder($flightId, 0, $userId);
                 //we put currently uploaded file in root
             }
         }
         $zip->close();
         unlink($copiedFilePath);
         unset($zip);
         unset($Fl);
         unset($FlE);
         unset($Fr);
         unset($Fd);
         unset($Bru);
         if (count($headerFiles) <= 0) {
             return false;
         }
         return true;
     } else {
         return false;
     }
//.........这里部分代码省略.........

 public function ConstructFlightEventsList($extFlightId, $sections = [], $colored = false)
 {
     $flightId = $extFlightId;
     $user = $this->_user->username;
     $Fl = new Flight();
     $flightInfo = $Fl->GetFlightInfo($flightId);
     $bruType = $flightInfo['bruType'];
     unset($Fl);
     $Bru = new Bru();
     $bruInfo = $Bru->GetBruInfo($bruType);
     $flightApHeaders = $Bru->GetBruApHeaders($bruType);
     $flightBpHeaders = $Bru->GetBruBpHeaders($bruType);
     $prefixArr = $Bru->GetBruApCycloPrefixes($bruType);
     unset($Bru);
     $Frame = new Frame();
     $framesCount = $Frame->GetFramesCount($flightInfo['apTableName'], $prefixArr[0]);
     //giving just some prefix
     unset($Frame);
     // create new PDF document
     $pdf = new TCPDF('L', 'mm', 'A4', true, 'UTF-8', false);
     // set document information
     $pdf->SetCreator($user);
     $pdf->SetAuthor($user);
     $pdf->SetTitle('Flight events list');
     $pdf->SetSubject('Flight events list');
     // $pdf->SetKeywords('TCPDF, PDF, example, test, guide');
     $bort = $flightInfo['bort'];
     $voyage = $flightInfo['voyage'];
     $copyDate = date('H:i:s d-m-Y', $flightInfo['startCopyTime']);
     $Fr = new Frame();
     $flightDuration = $Fr->FrameCountToDuration($framesCount, $bruInfo['stepLength']);
     unset($Fr);
     $usrInfo = $this->_user->userInfo;
     $headerStr = $usrInfo['company'];
     $imageFile = '';
     if ($colored && $usrInfo['logo'] != '') {
         $imageFile = SITE_ROOT_DIR . '/fileUploader/files/' . uniqid() . '.png';
         file_put_contents($imageFile, $usrInfo['logo']);
         $img = file_get_contents($imageFile);
         $pdf->SetHeaderData('$' . $img, "20", $headerStr, "", [0, 10, 50], [0, 10, 50]);
     } else {
         // set default header data
         $pdf->SetHeaderData("", "", $headerStr, "", [0, 10, 50], [0, 10, 50]);
     }
     $pdf->setFooterData([0, 10, 50], [0, 10, 50]);
     // set header and footer fonts
     $pdf->setHeaderFont(array('dejavusans', '', 11));
     $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
     // set default monospaced font
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     // set margins
     $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
     $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
     $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
     // set auto page breaks
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     // set image scale factor
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     // ---------------------------------------------------------
     // set default font subsetting mode
     $pdf->setFontSubsetting(true);
     // Set font
     // dejavusans is a UTF-8 Unicode font, if you only need to
     // print standard ASCII chars, you can use core fonts like
     // helvetica or times to reduce file size.
     $pdf->SetFont('dejavusans', '', 12, '', true);
     // Add a page
     // This method has several options, check the source code documentation for more information.
     $pdf->AddPage();
     if ($imageFile !== '') {
         unlink($imageFile);
     }
     // set text shadow effect
     $pdf->setTextShadow(array('enabled' => true, 'depth_w' => 0.2, 'depth_h' => 0.2, 'color' => [196, 196, 196], 'opacity' => 1, 'blend_mode' => 'Normal'));
     // Pasport
     $strStyle = "text-align:center; font-size: xx-large; font-weight: bold; color: rgb(0, 10, 64);";
     $str = '<p style="' . $strStyle . '">' . $this->lang->pasport . '</p>';
     $pdf->writeHTML($str, true, false, false, false, '');
     // Pasport info
     $strStyle = "text-align:center;";
     $str = '<p style="' . $strStyle . '">' . $this->lang->bruType . ' - ' . $bruInfo['bruType'] . '. <br>' . $this->lang->bort . ' - ' . $flightInfo['bort'] . '; ' . $this->lang->voyage . ' - ' . $flightInfo['voyage'] . '; ' . $this->lang->route . ' : ' . ($new_string = preg_replace('/[^a-zA-z0-9]/', '', $flightInfo['departureAirport']) . ' - ' . preg_replace('/[^a-zA-z1-9]/', '', $flightInfo['arrivalAirport']) . '. <br>' . $this->lang->flightDate . ' - ' . date('H:i:s d-m-Y', $flightInfo['startCopyTime']) . '; ' . $this->lang->duration . ' - ' . $flightDuration . '. <br>');
     $fileName = date('Y-m-d_H.i.s', $flightInfo['startCopyTime']) . '_' . $flightInfo['bort'] . '_' . $flightInfo['voyage'] . '_' . $bruInfo['bruType'];
     if (strpos($bruInfo['aditionalInfo'], ";") >= 0) {
         $counterNeedBrake = false;
         $aditionalInfoArr = explode(";", $flightInfo['flightAditionalInfo']);
         foreach ($aditionalInfoArr as $aditionalInfo) {
             if ($aditionalInfo != "") {
                 $nameVal = explode(":", $aditionalInfo);
                 if (count($nameVal) > 1) {
                     $name = $nameVal[0];
                     $val = $nameVal[1];
                     if ($counterNeedBrake) {
                         $str .= (isset($this->lang->{$name}) ? $this->lang->{$name} : $name) . " - " . $val . "; </br>";
                         $counterNeedBrake = !$counterNeedBrake;
                     } else {
                         $str .= (isset($this->lang->{$name}) ? $this->lang->{$name} : $name) . " - " . $val . "; ";
                         $counterNeedBrake = !$counterNeedBrake;
                     }
                 }
             }
//.........这里部分代码省略.........

 public function SetExcReliability($extFlightId, $extExcId, $extState)
 {
     $flightId = $extFlightId;
     $excId = $extExcId;
     $state = $extState;
     $Fl = new Flight();
     $flightInfo = $Fl->GetFlightInfo($flightId);
     unset($Fl);
     $excTableName = $flightInfo['exTableName'];
     if ($state == false || $state == 'false') {
         $state = 1;
     } else {
         if ($state == true || $state == 'true') {
             $state = 0;
         } else {
             $state = 0;
         }
     }
     $FE = new FlightException();
     $res = $FE->UpdateFalseAlarmState($excTableName, $excId, $state);
     unset($FE);
     return $res;
 }