public static function select($id) { $connection = Flight::dbMain(); try { $sql = "SELECT * FROM unit WHERE id = :id;"; $query = $connection->prepare($sql); $query->bindParam(':id', $id, PDO::PARAM_INT); $query->execute(); if ($query->rowCount() < 1) { return null; } $row = $query->fetch(PDO::FETCH_ASSOC); $unit = new Unit(); $unit->Id = (int) $row['id']; $unit->Imei = $row['unit_imei']; $unit->DtCreated = $row['unit_dt_created']; $unit->SerialNumber = $row['unit_serial_number']; $unit->Sim = Sim::select($row['sim_id']); $unit->UnitStatus = UnitStatus::select($row['e_status_unit_id']); $unit->UnitType = UnitType::select($row['unit_type_id']); $unit->Company = Company::select($row['company_id']); $unit->UnitData = UnitData::select($row['unit_imei']); return $unit; } catch (PDOException $pdoException) { throw $pdoException; } catch (Exception $exception) { throw $exception; } finally { $connection = null; } }
} }); Flight::route('POST /v1/session/logout', function () { try { $object = Session::logout(); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); //============================================================================= //UnitData //============================================================================= Flight::route('GET /v1/data/unitdata/@id', function ($id) { try { $object = UnitData::select($id); Flight::ok($object); } catch (Exception $exception) { Flight::error($exception); } }); //============================================================================= //Poi //============================================================================= Flight::route('GET /v1/main/poi', function () { $company = Flight::request()->query->company; try { if ($company) { $array = Poi::selectByCompany($company); } else { $array = Poi::selectAll();