Flight::route('GET /v1/main/driver', function () {
$company = Flight::request()->query->company;
try {
if ($company) {
$array = Driver::selectByCompany($company);
} else {
$array = Driver::selectAll();
}
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('GET /v1/main/driver/@id', function ($id) {
try {
$object = Driver::select($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('POST /v1/main/driver', function () {
try {
$object = Driver::insert();
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/driver/@id', function ($id) {
try {
public static function selectByCompany($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM vehicle WHERE company_id = :company;";
$query = $connection->prepare($sql);
$query->bindParam(':company', $id, PDO::PARAM_INT);
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
$result = array();
foreach ($rows as $row) {
$vehicle = new Vehicle();
$vehicle->Id = (int) $row['id'];
$vehicle->DtCreated = $row['vehicle_dt_created'];
$vehicle->DtSubscribed = $row['vehicle_dt_subscribed'];
$vehicle->Plate = $row['vehicle_plate'];
$vehicle->Name = $row['vehicle_name'];
$vehicle->Model = $row['vehicle_model'];
$vehicle->MaInitial = (int) $row['vehicle_ma_initial'];
$vehicle->MaLimit = (int) $row['vehicle_ma_limit'];
$vehicle->MaMaintenance = (int) $row['vehicle_ma_maintenance'];
$vehicle->SpeedMax = (int) $row['vehicle_speed_max'];
$vehicle->FuelMax = (int) $row['vehicle_fuel_max'];
// $vehicle->Status = (int)$row['e_status_id'];
// $vehicle->Driver = $row['driver_id'] == null ? null : (int)$row['driver_id'];
// $vehicle->Unit = $row['unit_id'] == null ? null : (int)$row['unit_id'];
// $vehicle->Company = (int) $row['company_id'];
// $vehicle->TrackeeType = (int) $row['e_trackee_type_id'];
$vehicle->Status = (int) $row['e_status_id'];
$vehicle->Driver = Driver::select($row['driver_id']);
$vehicle->Unit = Unit::select($row['unit_id']);
$vehicle->Company = Company::select($row['company_id']);
$vehicle->TrackeeType = TrackeeType::select($row['e_trackee_type_id']);
$vehicle->Status = Status::select($row['e_status_id']);
array_push($result, $vehicle);
}
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}