{!! getLogo() !!}

SALES SUMMARY REPORT CUSTOMER WISE

Filtered by:

From Date : {{ $from_date ?? '' }} | To Date : {{ $end_date ?? '' }}

Customer : {{ $customer_name ?? '' }} {{ $customer_code ?? ''}} | Area : {{ $city ?? '' }} | Rep : {{ $rep ?? '' }}

Order #	Date	Total	Credit Note	Paid	Sale

@php $full_total = 0; $full_returned = 0; // $full_paid = 0; $full_balance = 0; @endphp @foreach ($customers as $customer) @if ($customer->invoices->isNotEmpty()) Customer : {{ $customer->company_name ?? '' }} {{$customer->business_name ?? '' }} | Rep: {{ $customer->rep->fname ?? '' }} {{ $customer->rep->lname ?? '' }}

@php $total_invoice_amount = 0; $total_returned_amount = 0; // $total_paid_amount = 0; $total_balance = 0; @endphp @foreach ($customer->invoices as $invoice) @php $invoice_total = \App\Utils\CommonUtil::calculateInvoiceTotal($invoice->id); $returned_amount = \App\Utils\CommonUtil::calculateTotalReturnAmountInvoice($invoice->id); $full_total += $invoice_total; $full_returned += $returned_amount; // $full_paid += $invoice->paid_amount; $full_balance += $invoice_total - $returned_amount; $total_invoice_amount += $invoice_total; $total_returned_amount += $returned_amount; // $total_paid_amount += $invoice->paid_amount; $total_balance += $invoice_total - $returned_amount; @endphp {{-- --}} @endforeach {{-- --}}

Total		{{ \App\Http\Helper::formatPrice($total_invoice_amount) }}	{{ \App\Http\Helper::formatPrice($total_returned_amount) }}	{{ \App\Http\Helper::formatPrice($total_paid_amount) }}	{{ \App\Http\Helper::formatPrice($total_balance) }}
{{ $invoice->invoice_code }}	@php $count_days = \Carbon\Carbon::parse($invoice->invoice_date)->diffInDays(\Carbon\Carbon::now(), false); @endphp {{ $invoice->invoice_date }}	{{ \App\Http\Helper::formatPrice($invoice_total) }}	{{ \App\Http\Helper::formatPrice($returned_amount) }}	{{ \App\Http\Helper::formatPrice($invoice->paid_amount) }}	{{ \App\Http\Helper::formatPrice($invoice_total - $returned_amount) }}

@endif @endforeach {{-- --}}

Full Total		{{ \App\Http\Helper::formatPrice($full_total) }}	{{ \App\Http\Helper::formatPrice($full_returned) }}	{{ \App\Http\Helper::formatPrice($full_paid) }}	{{ \App\Http\Helper::formatPrice($full_balance) }}