public function index()
{
$totalTrips = Trip::all()->count();
$totalTravelCompanies = TravelCompany::all()->count();
$totalUsers = User::all()->count();
$totalPaidBookings = Booking::where('status', 'paid')->count();
$totalBus = Rental::all()->count();
return view('admin.dashboard', ['tT' => $totalTrips, 'tU' => $totalUsers, 'tP' => $totalPaidBookings, 'tC' => $totalTravelCompanies, 'tB' => $totalBus]);
}
/**
* Store a newly created resource in storage.
*
* @param CreateTravelCompaniesRequest $request
*
* @return Response
*/
public function store(CreateTravelCompaniesRequest $request)
{
$email = $request->email;
$password = $request->password;
$name = $request->name;
$phone = $request->phone;
$slug = str_slug($request->name);
TravelCompany::create(['email' => $email, 'name' => $name, 'phone' => $phone, 'slug' => $slug]);
$travel_company = TravelCompany::all()->last();
TravelCompanyStaff::create(['email' => $email, 'name' => $name, 'phone' => $phone, 'password' => $password, 'travel_company_id' => $travel_company->id, 'type' => 1]);
return redirect()->route('admin.travel-companies.index');
}
/**
* @return \Illuminate\View\View
*/
public function all()
{
$companies = TravelCompany::all();
return view('companies.all', ['companies' => $companies]);
}
/**
* @param Request $request
*
* @return $this
*/
public function search(Request $request)
{
$this->validate($request, ['departure_station' => 'required|different:destination_station', 'destination_station' => 'required', 'start' => 'required']);
$travel_companies = TravelCompany::all();
$to = $request->destination_station;
$from = $request->departure_station;
$departure_date = Carbon::parse($request->start);
$dd_start = Carbon::parse($request->start)->startOfDay();
$dd_end = Carbon::parse($request->start)->endOfDay();
// $trips = Trip::all();
// dd($request->all(), $trips);
if ($departure_date->lt(Carbon::today())) {
return redirect()->back()->withErrors('Invalid Date');
} else {
if ($departure_date->eq(Carbon::today())) {
$trips = $this->getTodayOneWayTrips($from, $to);
// dd($trips);
} else {
// $trips = Trip::whereraw('departure_date = ? AND departure_station = ? AND destination_station = ?',
// [$departure_date, $from, $to])->get();
$trips = Trip::whereraw('departure_station = ? AND destination_station = ?', [$from, $to])->whereBetween('departure_date', [$dd_start, $dd_end])->get();
}
}
return view('pages.all_trips', ['travel_companies' => $travel_companies, 'from' => $from, 'to' => $to, 'start' => $departure_date])->with('trips', $trips);
}
public function booking_reports_index()
{
$travel_companies = TravelCompany::all();
return view('admin.reports.booking.index', ['companies' => $travel_companies]);
}
