{{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} @php $i=0; $customer_new = 0; $comment_new = 0; $order_new = 0; $order_old = 0; $schedules_percent = 0; $revenue_new = 0; $payment_new = 0; $all_detail_new = 0; $schedules_new = 0; $all_schedules_den = 0; $revenue_old = 0; $detail_old = 0; @endphp @if(count($users)) @foreach($users as $item) @php $i++ ; $customer_new += $item->customer_new; $comment_new += $item->comment_new; $order_new += $item->order_new; $order_old += $item->order_old; $schedules_percent += $item->schedules_den >0 && $item->customer_new>0 ?round(($item->schedules_new/$item->customer_new)*100,1):0; $revenue_new += $item->revenue_new; $payment_new += $item->payment_new; $schedules_new += $item->schedules_new; $all_schedules_den += $item->schedules_den; $all_detail_new += $item->detail_new; $revenue_old += $item->revenue_old; $detail_old += $item->detail_old; @endphp {{-- --}} @endforeach @endif {{-- --}}

CHỈ SỐ BÁO CÁO											TỶ LỆ CHUYỂN ĐỔI						KẾT QUẢ DOANH THU
	Nhân viên	Cuộc gọi	Tổng SĐT	SĐT mới	SĐT trùng	Lịch hẹn	Khách đến	Khách đến mua	Khách đến k.mua	Đơn chốt	% Chốt lịch	Tỷ lệ đến/SĐT	% Đến/lịch hẹn	% Mua/lịch hẹn	% K.mua/lịch hẹn	% Chốt /khách đến	% Chốt /SĐT	TB đơn	Doanh số	Doanh thu	Thu nợ	Thực thu
(1)	(2)	(2.1)	(3)	(4)	(5)	(6)	(7)	(8)	(8.1)	(5)/(3)	(5)/(4)	(6)/(4)	(7)/(4)	(8)/(5)	(8)/(3)	(12)/(8)	(9)	(10)	(11)	(12)
{{$i}}	{{$item->full_name}}	{{$item->call_center}}	{{$item->customer_new}}	{{$item->customer_new - $item->duplicate}}	{{$item->duplicate}}	{{$item->schedules_new}}	{{$item->schedules_den}}	{{$item->become_buy}}	{{$item->not_buy}}	{{$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->customer_new) ? round($item->schedules_den/$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->schedules_new> 0 && $item->become_buy >0 ?round(($item->become_buy/$item->schedules_new)*100,1):0}}%	{{$item->schedules_new> 0 && $item->not_buy >0 ?round(($item->not_buy/$item->schedules_new)*100,1):0}}%	{{$item->order_new>0&&$item->schedules_den >0 ?round(($item->order_new/$item->schedules_den)*100,1):0}}%	{{$item->order_new>0 && $item->customer_new >0 ?round(($item->order_new/$item->customer_new)*100,1):0}}%	{{$item->order_new>0 && $item->detail_new >0 ?number_format($item->detail_new/$item->order_new):0}}	{{number_format($item->revenue_new)}}	{{number_format($item->payment_new)}}	{{number_format($item->is_debt)}}	{{number_format($item->detail_new)}}
	Tổng cộng	{{@number_format($users->sum('call_center'))}}	{{@number_format($customer_new)}}	{{@number_format($customer_new - $users->sum('duplicate'))}}	{{@number_format($users->sum('duplicate'))}}	{{@number_format($schedules_new)}}	{{@number_format($all_schedules_den)}}	{{@number_format($users->sum('become_buy'))}}	{{@number_format($users->sum('not_buy'))}}	{{@number_format($order_new)}}	{{!empty($schedules_new)&& !empty($customer_new)?round($schedules_new/$customer_new*100,1):0}}%	{{!empty($all_schedules_den)&& !empty($customer_new)?round($all_schedules_den/$customer_new*100,1):0}}%	{{!empty($all_schedules_den)&& !empty($schedules_new)?round($all_schedules_den/$schedules_new*100,1):0}}%	{{!empty($schedules_new)&& !empty($users->sum('become_buy'))?round($users->sum('become_buy')/$schedules_new*100,1):0}}%	{{!empty($schedules_new)&& !empty($users->sum('not_buy'))?round($users->sum('not_buy')/$schedules_new*100,1):0}}%	{{!empty($all_schedules_den)&& !empty($order_new)?round($order_new/$all_schedules_den*100,1):0}}%	{{!empty($customer_new)&& !empty($order_new)?round($order_new/$customer_new*100,1):0}}%	{{!empty($all_detail_new)&& !empty($order_new)?number_format($all_detail_new/$order_new):0}}	{{@number_format($revenue_new)}}	{{@number_format($payment_new)}}	{{@number_format($users->sum('is_debt'))}}	{{@number_format($all_detail_new)}}