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