public function getDashdetails() { $guestlist_date = date('Y-m-d', strtotime(date('Y-m-d') . "-1 days")); $registered = User::count(); $subimitted = Hotelrecord::select(DB::raw('count(*) as subimitted_hotels'))->where('guestlist_date', $guestlist_date)->get(); $totals = Hotelrecord::select(DB::raw('sum(total_check_in) as total_check_in, sum(total_check_out) as total_check_out, sum(foreign_guest) as foreign_guest'))->where('guestlist_date', $guestlist_date)->get(); $totals[0]['guestlist_date'] = date("d-M-Y", strtotime($guestlist_date)); $totals[0]['subimitted_hotels'] = $subimitted[0]['subimitted_hotels']; $totals[0]['registered'] = $registered - 5; return Response::json($totals); }
public function getSubmittedhotels() { $guestlist_date = date('Y-m-d', strtotime(date('Y-m-d') . "-1 days")); $registered = User::count(); $subimitted = Hotelrecord::select(DB::raw('count(*) as subimitted_hotels'))->where('guestlist_date', $guestlist_date)->get(); $totals = Hotelrecord::select(DB::raw('sum(total_check_in) as total_check_in, sum(total_check_out) as total_check_out, sum(foreign_guest) as foreign_guest'))->where('guestlist_date', $guestlist_date)->get(); $totals[0]['guestlist_date'] = $guestlist_date; $totals[0]['subimitted_hotels'] = $subimitted[0]['subimitted_hotels']; $totals[0]['registered'] = $registered - 5; $data = array('guestlist_date' => $totals[0]['guestlist_date'], 'registered' => $totals[0]['registered'], 'subimitted_hotels' => $totals[0]['subimitted_hotels'], 'total_check_in' => $totals[0]['total_check_in'], 'total_check_out' => $totals[0]['total_check_out'], 'foreign_guest' => $totals[0]['foreign_guest']); Mail::send('emails.reports', $data, function ($message) { $message->from('*****@*****.**', 'Crimatrix'); $message->to('*****@*****.**')->cc('*****@*****.**')->subject('Crimatrix daily report'); }); }