public function store()
{
$data = Input::all();
$data['TRAVEL_SCHEDULE_DEPARTTIME'] = date('Y-m-d H:i', strtotime($data['date'] . " " . $data['depart_hour'] . ":" . $data['depart_minute']));
$plus = $data['hour_estimate'] * 60 + $data['minute_estimate'];
$hour_arrive = date('H:i', strtotime('+' . $plus . ' minutes', strtotime($data['TRAVEL_SCHEDULE_DEPARTTIME'])));
$data['TRAVEL_SCHEDULE_ARRIVETIME'] = date('Y-m-d H:i', strtotime($hour_arrive));
unset($data['_token']);
unset($data['date']);
unset($data['depart_hour'], $data['depart_minute'], $data['hour_estimate'], $data['minute_estimate']);
$data['TRAVEL_SCHEDULE_CREATEBY'] = Session::get('id');
$flag = 0;
$flag = Travelschedule::where(function ($query) use($data) {
$query->where('TRAVEL_SCHEDULE_DEPARTTIME', '<=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_ARRIVETIME'])))->where('TRAVEL_SCHEDULE_ARRIVETIME', '>=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_ARRIVETIME'])));
})->orWhere(function ($query) use($data) {
$query->where('TRAVEL_SCHEDULE_DEPARTTIME', '<=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_DEPARTTIME'])))->where('TRAVEL_SCHEDULE_ARRIVETIME', '>=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_DEPARTTIME'])));
})->orWhere(function ($query) use($data) {
$query->where('TRAVEL_SCHEDULE_DEPARTTIME', '>=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_DEPARTTIME'])))->where('TRAVEL_SCHEDULE_ARRIVETIME', '<=', date('Y-m-d H:i', strtotime($data['TRAVEL_SCHEDULE_ARRIVETIME'])));
})->where('VEHICLE_ID', '=', $data['VEHICLE_ID'])->count();
if ($flag == 0) {
Travelschedule::insert($data);
} else {
Session::flash("error", "Ada jadwal yang bentrok, mohon periksa kembali");
}
return redirect::back();
}
function scheduleSearchRentang()
{
$data = Input::all();
$city = City::all();
$data = Input::all();
$tanggal = $data['TRAVEL_SCHEDULE_DATE'];
$start = date('Y-m-d', strtotime(' -7 day', strtotime($tanggal)));
$finish = date('Y-m-d', strtotime(' +7 day', strtotime($tanggal)));
$schedule = Travelschedule::travelScheduleRentang($data['depart'], $data['dest'], $start, $finish)->get();
return view('travelpage::hasil-search', compact('schedule', 'city'));
}
function umum_bulanan_detail($id)
{
$data = Travelschedule::partnerSchedule($this->partner_id)->where('TRAVEL_SCHEDULE_GROUP', '=', $id)->get();
return view("travelpartner::jadwal.bulanan_detail", compact('data'));
}
