/**
* @return \Illuminate\View\View
*/
public function profile()
{
$user = Auth::user()->get();
$total_traveled = Booking::whereraw('user_id = ? AND status = ?', [$user->id, 'paid'])->count();
return view('customers.profile', ['user' => $user, 'total_traveled' => $total_traveled]);
}
public function filter_bookings(Request $request)
{
$travel_company = Auth::travel_company_staff()->get()->travel_company;
$company_id = $travel_company->id;
$this->validate($request, ['start' => 'required', 'end' => 'required']);
$end = Carbon::parse($request->end);
$start = Carbon::parse($request->start);
$reserved_bookings = Booking::whereraw('travel_company_id = ? AND status = ?', [$company_id, 'reserved'])->whereraw('updated_at <= ? AND created_at >= ?', [$end, $start])->orderBy('updated_at', 'desc')->get();
$paid_bookings = Booking::whereraw('travel_company_id = ? AND status = ?', [$company_id, 'paid'])->whereraw('updated_at <= ? AND created_at >= ?', [$end, $start])->orderBy('updated_at', 'desc')->get();
$canceled_bookings = Booking::whereraw('travel_company_id = ? AND status = ?', [$company_id, 'canceled'])->whereraw('updated_at <= ? AND created_at >= ?', [$end, $start])->orderBy('updated_at', 'desc')->get();
return view('companies.bookings.index', ['reserved_bookings' => $reserved_bookings, 'paid_bookings' => $paid_bookings, 'canceled_bookings' => $canceled_bookings]);
}
