@php $customer_new = 0; $comment_new = 0; $schedules_new = 0; $order_new = 0; $schedules_percent = 0; $order_percent = 0; $revenue_new = 0; $payment_new = 0; $schedules_old = 0; $comment_old = 0; $order_old = 0; $revenue_old = 0; $payment_old = 0; $all_payment = 0; @endphp @if(count($users)) @foreach($users as $item) @php $i++ ; $customer_new += $item->customer_new; $comment_new += $item->comment_new; $schedules_new += $item->schedules_new; $order_new += $item->order_new; $schedules_percent += $item->schedules_new >0 && $item->customer_new>0 ?round(($item->schedules_new/$item->customer_new)*100):0; $order_percent += $item->order_new>0&&$item->customer_new >0 ?round(($item->order_new/$item->customer_new)*100):0; $revenue_new += $item->revenue_new; $payment_new += $item->payment_new; $schedules_old += $item->schedules_old; $comment_old += $item->comment_old; $order_old += $item->order_old; $revenue_old += $item->revenue_old; $payment_old += $item->payment_old; $all_payment += $item->all_payment; @endphp @endforeach @endif

STT	SALE	KHÁCH HÀNG MỚI									KHÁCH HÀNG CŨ						TỔNG CHUNG
	Nhân viên	SĐT	Trao đổi	Lịch hẹn	Đơn chốt	Tỷ lệ chốt lịch	Tỷ lệ chốt đơn	Doanh số sau CK	Doanh thu	Doanh thu TB/đơn	Lịch hẹn	Trao đổi	Đơn chốt	Doanh số sau CK	Doanh thu	Doanh thu TB/đơn	Doanh số	Doanh thu	Thu nợ	Đã thu T.kỳ
(1)	(2)	(3)	(4)	(5)	(6)	(5)/(3)	(6)/(3)	(7)	(8)	(avg)	(9)	(10)	(11)	(12)	(13)	(avg)	(7)+(12)	(8)+(13)
{{$i}}	{{$item->full_name}}	{{$item->customer_new}}	{{$item->comment_new}}	{{$item->schedules_new}}	{{$item->order_new}}	{{!empty($item->schedules_new) && !empty($item->customer_new) ?round(($item->schedules_new/$item->customer_new)*100):0}} %	{{$item->order_new>0&&$item->customer_new >0 ?round(($item->order_new/$item->customer_new)*100):0}} %	{{number_format($item->revenue_new)}}	{{number_format($item->payment_new)}}	{{!empty($item->payment_new) && !empty($item->order_new) ? number_format($item->payment_new/$item->order_new):0}}	{{$item->schedules_old}}	{{$item->comment_old}}	{{$item->order_old}}	{{number_format($item->revenue_old)}}	{{number_format($item->payment_old)}}	{{!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)}}	{{number_format($item->all_payment)}}
	Tổng cộng	{{@number_format($customer_new)}}	{{@number_format($comment_new)}}	{{@number_format($schedules_new)}}	{{@number_format($order_new)}}	{{@number_format($schedules_percent/count($users))}}%	{{@number_format($order_percent/count($users))}}%	{{@number_format($revenue_new)}}	{{@number_format($payment_new)}}	{{!empty($payment_new)&& !empty($order_new)?number_format($payment_new/$order_new):0}}	{{@number_format($schedules_old)}}	{{@number_format($comment_old)}}	{{@number_format($order_old)}}	{{@number_format($revenue_old)}}	{{@number_format($payment_old)}}	{{!empty($payment_old)&& !empty($order_old)?number_format($payment_old/$order_old):0}}	{{number_format($allTotal)}}	{{number_format($grossRevenue)}}	{{number_format($all_payment - $grossRevenue)}}	{{number_format($all_payment)}}