@php $k=0; @endphp @if(count($users)) @foreach($users as $item) @php $k++; @endphp @endforeach @endif

STT	CHI NHÁNH	KHÁCH HÀNG MỚI											KHÁCH HÀNG CŨ					TỔNG CHUNG
		SĐT	Lịch hẹn	Khách đến	Đơn chốt	Tỷ lệ chốt lịch	Tỷ lệ đến	Tỷ lệ chốt đơn	Doanh số sau CK	Doanh thu	Thu nợ	Thực thu	Đơn chốt	Doanh số sau CK	Doanh thu	Thu nợ	Thực thu	Doanh thu TB/đơn	Doanh số	Doanh thu	Thu nợ	Thực thu	Thực thu
(1)	(2)	(3)	(4)	(5)	(6)	(4)/(3)	(5)/(4)	(6)/(5)	(7)	(8)	(9)	(10)	(11)	(12)	(13)	(14)	(13)+(14)	(6)+(11)	(7)+(12)	(15)	(16)	(Từ đơn hàng)	(Trừ tiêu ví)
	Tổng cộng	{{@number_format($users->sum('customer_new'))}}	{{@number_format($users->sum('schedules_new'))}}	{{@number_format($users->sum('schedules_den'))}}	{{@number_format($users->sum('order_new'))}}	{{!empty($users->sum('schedules_new'))&& !empty($users->sum('customer_new'))?round($users->sum('schedules_new')/$users->sum('customer_new')*100,1):0}}%	{{!empty($users->sum('schedules_den'))&& !empty($users->sum('schedules_new'))?round($users->sum('schedules_den')/$users->sum('schedules_new')*100,1):0}}%	{{!empty($users->sum('schedules_den'))&& !empty($users->sum('order_new'))?round($users->sum('order_new')/$users->sum('schedules_den')*100,1):0}}%	{{@number_format($users->sum('revenue_new'))}}	{{@number_format($users->sum('payment_new'))}}	{{@number_format($users->sum('detail_new') - $users->sum('payment_new'))}}	{{@number_format($users->sum('detail_new'))}}	{{@number_format($users->sum('order_old'))}}	{{@number_format($users->sum('revenue_old'))}}	{{@number_format($users->sum('payment_old'))}}	{{@number_format($users->sum('all_payment') - $users->sum('detail_new') - $users->sum('payment_old'))}}	{{@number_format($users->sum('all_payment') + $users->sum('payment_wallet') - $users->sum('payment_used') - $users->sum('detail_new'))}}	{{!empty($users->sum('payment_old'))&& !empty($users->sum('order_old'))?number_format($users->sum('payment_old')/$users->sum('order_old')):0}}	{{number_format($users->sum('revenue_total'))}}	{{number_format($users->sum('payment_new') + $users->sum('payment_old'))}}	{{number_format(($users->sum('all_payment') - $users->sum('payment_new') - $users->sum('payment_old'))>0?$users->sum('all_payment') - $users->sum('payment_new') - $users->sum('payment_old'):0)}}	{{number_format($users->sum('all_payment'))}}	{{number_format($users->sum('all_payment') + $users->sum('payment_wallet') - $users->sum('payment_used'))}}
{{$k}}	{{$item->name}}	{{$item->customer_new}}	{{$item->schedules_new}}	{{$item->schedules_den}}	{{$item->order_new}}	{{!empty($item->schedules_new) && !empty($item->customer_new) ?round(($item->schedules_new/$item->customer_new)*100,1):0}} %	{{!empty($item->schedules_den) && !empty($item->schedules_new) ? round($item->schedules_den/$item->schedules_new*100,1):0}}%	{{$item->order_new>0&&$item->schedules_den >0 ?round(($item->order_new/$item->schedules_den)*100,1):0}} %	{{number_format($item->revenue_new)}}	{{number_format($item->payment_new)}}	{{number_format($item->detail_new - $item->payment_new)}}	{{number_format($item->detail_new)}}	{{$item->order_old}}	{{number_format($item->revenue_old)}}	{{number_format($item->payment_old)}}	{{number_format($item->all_payment - $item->detail_new -$item->payment_old)}}	{{number_format($item->all_payment + $item->payment_wallet - $item->payment_used - $item->detail_new)}}	{{!empty($item->payment_old) && !empty($item->order_old) ? number_format($item->payment_old/$item->order_old):0}}	{{number_format($item->revenue_total)}}	{{number_format($item->payment_new + $item->payment_old)}}	{{number_format(($item->all_payment - $item->payment_new - $item->payment_old)>0?$item->all_payment - $item->payment_new - $item->payment_old:0)}}	{{number_format($item->all_payment)}}	{{number_format($item->all_payment + $item->payment_wallet - $item->payment_used)}}