@php $total_service = 0; $total_code = 0; $total_test = 0; $total_reservation = 0; $total_cod_qty = 0; $total_credit_qty = 0; $total_credit_amount = 0; $total_cod_amount = 0; $total_online_qty = 0; $total_online_amount = 0; $total_amount = 0; $total_cost_price = 0; $total_pl = 0; $total_service_subtotal_cod_tax = 0; $total_service_subtotal_credit_tax = 0; $total_service_subtotal_online_tax = 0; $total_service_subtotal_total_tax = 0; @endphp @foreach($orders as $order) @php $net_total_test = 0; if (isset($order->TOTAL_AMOUNT_TEST)){ $net_total_test = $order->TOTAL_AMOUNT_TEST; } $cod_total_test = 0; if (isset($order->COD_AMOUNT_TEST)){ $cod_total_test = $order->COD_AMOUNT_TEST; } $credit_test = 0; if (isset($order->CREDIT_TEST)){ $credit_test = $order->CREDIT_TEST; } $online_test = 0; if (isset($order->Online_amount_test)){ $online_test = $order->Online_amount_test; } $service_subtotal_cod_tax_test = 0; $service_subtotal_credit_tax_test = 0; $service_subtotal_online_tax_test = 0; $service_subtotal_total_tax_test = 0; if (isset($order->service_subtotal_cod_tax_test)){ $service_subtotal_cod_tax_test = $order->service_subtotal_cod_tax_test; } if (isset($order->service_subtotal_credit_tax_test)){ $service_subtotal_credit_tax_test = $order->service_subtotal_credit_tax_test; } if (isset($order->service_subtotal_online_tax_test)){ $service_subtotal_online_tax_test = $order->service_subtotal_online_tax_test; } if (isset($order->service_subtotal_total_tax_test)){ $service_subtotal_total_tax_test = $order->service_subtotal_total_tax_test; } $total_service += 1; $total_code += 1; $total_test += $order->quantity ?? 0; $total_reservation += $order->total_reservations ?? 0; $total_cod_qty += $order->cod_qty ?? 0; $total_cod_amount += $order->COD_AMOUNT + $cod_total_test ?? 0; $total_credit_qty += $order->credit_qty ?? 0; $total_credit_amount += $order->CREDIT + $credit_test ?? 0; $total_online_qty += $order->Online_qty ?? 0; $total_online_amount += $order->Online_amount + $online_test ?? 0; $total_amount += $order->TOTAL_AMOUNT + $net_total_test ?? 0; $total_cost_price += $order->COST_PRICE ?? 0; $net_total = ($order->TOTAL_AMOUNT + $net_total_test) - ($order->service_subtotal_total_tax + $service_subtotal_total_tax_test); $cost_price = $order->COST_PRICE ?? 0; $pl = $net_total - $cost_price; $total_pl += $pl; $total_service_subtotal_cod_tax += ($order->service_subtotal_cod_tax + $service_subtotal_cod_tax_test) ?? 0; $total_service_subtotal_credit_tax += ($order->service_subtotal_credit_tax + $service_subtotal_credit_tax_test) ?? 0; $total_service_subtotal_online_tax += ($order->service_subtotal_online_tax + $service_subtotal_online_tax_test) ?? 0; $total_service_subtotal_total_tax += ($order->service_subtotal_total_tax + $service_subtotal_total_tax_test) ?? 0; @endphp @endforeach

{{$Profile->NAME_EN}}
Services Analysis Report
Service Name	Service Code	Test Qty	Reservation Qty	Patient Qty	Cost Price	P&L	OPD Qty	OPD Amount	Credits Qty	Credits Amount	Online Qty	Online Amount	Total Amount	Selected Users
{{$order->NAME_EN ?? null}}	{{$order->CODE ?? null}}	{{$order->quantity ?? 0}}	{{$order->total_reservations ?? 0}}	{{$order->quantity ?? 0}}	{{$cost_price}}	{{$pl}}	{{$order->cod_qty ?? 0}}	{{($order->COD_AMOUNT + $cod_total_test) - ($order->service_subtotal_cod_tax + $service_subtotal_cod_tax_test) ?? 0}}	{{$order->credit_qty ?? 0}}	{{($order->CREDIT + $credit_test) - ($order->service_subtotal_credit_tax + $service_subtotal_credit_tax_test) ?? 0}}	{{$order->Online_qty ?? 0}}	{{($order->Online_amount + $online_test) - ($order->service_subtotal_online_tax + $service_subtotal_online_tax_test) ?? 0}}	{{$net_total}}	{{$user_selected ?? '--'}}
Service Name : {{$total_service}}	Service Code : {{$total_code}}	Test Qty : {{$total_test}}	Reservation Qty : {{$total_reservation}}	Patient Qty : {{$total_reservation}}	Cost Price : {{$total_cost_price}}	P&L : {{$total_pl}}	OPD Qty : {{$total_cod_qty}}	OPD Amount : {{$total_cod_amount - $total_service_subtotal_cod_tax}}	Credits Qty : {{$total_credit_qty}}	Credits Amount : {{$total_credit_amount - $total_service_subtotal_credit_tax}}	Online Qty : {{$total_online_qty}}	Online Amount : {{$total_online_amount - $total_service_subtotal_online_tax}}	Total Amount : {{$total_amount - $total_service_subtotal_total_tax}}