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');
});
}
