public static function selectByCollection($id)
{
$connection = Flight::dbMain();
try {
$sql = "SELECT * FROM vehicle_collection WHERE collection_id = :collection_id;";
$query = $connection->prepare($sql);
$query->bindParam(':collection_id', $id, PDO::PARAM_INT);
$query->execute();
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
$result = array();
foreach ($rows as $row) {
$vehicleCollection = new VehicleCollection();
$vehicleCollection->Id = (int) $row['id'];
$vehicleCollection->Vehicle = Vehicle::select($row['vehicle_id']);
$vehicleCollection->Collection = Collection::select($row['collection_id']);
array_push($result, $vehicleCollection);
}
return $result;
} catch (PDOException $pdoException) {
throw $pdoException;
} catch (Exception $exception) {
throw $exception;
} finally {
$connection = null;
}
}
/**
*
* Predefined Transport List
*
*/
public function transportList()
{
$vehicle_id = array();
$vehicles = Vehicle::where('val', 1)->get();
// filtering
$vehicle = Vehicle::lists('vehicle_type', 'id');
$city = array('76' => 'Any') + City::lists('city', 'id');
//$city['%'] = 'Any';
if (Session::has('st_date')) {
$st_date = Session::get('st_date');
} else {
$st_date = date("Y/m/d");
}
if (Session::has('ed_date')) {
$ed_date = Session::get('ed_date');
} else {
$ed_date = date("Y/m/d", strtotime($st_date . ' + 2 days'));
}
if (Input::has('vehicle')) {
$get_vehicle = Input::get('vehicle');
$vehicle_id[] = $get_vehicle;
} else {
$get_vehicle_ids = Vehicle::select('id')->get();
foreach ($get_vehicle_ids as $get_vehicle_id) {
$vehicle_id[] = $get_vehicle_id->id;
}
}
if (Input::has('price_range_transport')) {
$price_range_array = Input::get('price_range_transport');
$price_range = explode(';', $price_range_array);
$min_rate = $price_range[0];
$max_rate = $price_range[1];
$min_trans_rate = $min_rate;
$max_trans_rate = $max_rate;
} else {
$min_rate = 0;
$max_rate = 10000000;
$min_trans_rate = TransportPackage::min('rate');
$max_trans_rate = TransportPackage::max('rate');
}
if (Input::has('from')) {
$from = Input::get('from');
} else {
$from = '%';
}
if (Input::has('from')) {
$to = Input::get('to');
} else {
$to = '%';
}
// dd($from.'/'.$to);
if (Input::has('transport_days')) {
$days = Input::get('transport_days');
} else {
$days = '%';
}
//dd($min_rate.'/'.$max_rate);
$transport_packages = TransportPackage::WhereHas('Vehicle', function ($r) use($vehicle_id) {
$r->whereIn('id', $vehicle_id);
})->where('val', 1)->where('rate', '>=', $min_rate)->where('rate', '<=', $max_rate)->where('origin', 'LIKE', $from)->where('destination', 'LIKE', $to)->where('days', 'LIKE', $days)->paginate(9);
return View::make('transport.transport_list')->with(array('transport_packages' => $transport_packages, 'min_trans_rate' => $min_trans_rate, 'max_trans_rate' => $max_trans_rate, 'vehicle' => $vehicle, 'city' => $city, 'vehicles' => $vehicles, 'st_date' => $st_date, 'ed_date' => $ed_date));
}
Flight::route('GET /v1/main/vehicle', function () {
$company = Flight::request()->query->company;
try {
if ($company) {
$array = Vehicle::selectByCompany($company);
} else {
$array = Vehicle::selectAll();
}
Flight::ok($array);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('GET /v1/main/vehicle/@id', function ($id) {
try {
$object = Vehicle::select($id);
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('POST /v1/main/vehicle', function () {
try {
$object = Vehicle::insert();
Flight::ok($object);
} catch (Exception $exception) {
Flight::error($exception);
}
});
Flight::route('PUT /v1/main/vehicle/@id', function ($id) {
try {
