@if(count($isi)!=0) @foreach($isi as $i) where('id_sales',g('sales')); if(g('month')!=0){ $count_sales_order->whereMonth('sales_order.created_at',g('month')); }if(g('year')!=0){ $count_sales_order->whereYear('sales_order.created_at',g('year')); } $count_sales_order = $count_sales_order->count(); $count_canvasing = DB::table('canvasing') ->where('id_sales',g('sales')); if(g('month')!=0){ $count_canvasing->whereMonth('canvasing.created_at',g('month')); }if(g('year')!=0){ $count_canvasing->whereYear('canvasing.created_at',g('year')); } $count_canvasing = $count_canvasing->count(); $count_checkin_checkout = DB::table('checkin_checkout') ->where('id_sales',g('sales')); if(g('month')!='0' && g('month')!=''){ $count_checkin_checkout->whereMonth('datetime_checkin',g('month')); }if(g('year')!='0' && g('year')!=''){ $count_checkin_checkout->whereYear('datetime_checkin',g('year')); } $count_checkin_checkout = $count_checkin_checkout->count(); ?> @endforeach @else @endif

Customer	Checkin - Checkout	Date
		{{ date('d/m/Y', strtotime($i->datetime_checkin)) }}
Data not found