Grameen Milk

Route Sale Consolidated Report

Date Range : {{ $start_date }} - {{ $end_date }}

Report Generated On : {{ $generate_time }}

@foreach($sales_report as $key=>$data) @endforeach
# Route Sales Collected Outstanding Prev Outstanding Total Outstanding Petty Cash Advance Amount Grand Total Outstanding
{{ $key+1 }} {{ $data->route_name }} {{ $data->total_sales }} {{ $data->total_sales - $data->outstanding_amount }} {{ $data->outstanding_amount }} {{ $data->prev_outstanding_amount }} {{ $data->outstanding_amount + $data->prev_outstanding_amount }} {{ $data->petty_cash }} {{ $data->total_advance_amount }} {{ ($data->outstanding_amount + $data->prev_outstanding_amount + $data->petty_cash) - $data->total_advance_amount }}
Total {{ $sales_report->sum('total_sales') }} {{ $sales_report->sum('total_sales') - $sales_report->sum('outstanding_amount') }} {{ $sales_report->sum('outstanding_amount') }} {{ $sales_report->sum('prev_outstanding_amount') }} {{ $sales_report->sum('outstanding_amount') + $sales_report->sum('prev_outstanding_amount') }} {{ $sales_report->sum('petty_cash') }} {{ $sales_report->sum('total_advance_amount') }} {{ ($sales_report->sum('outstanding_amount') + $sales_report->sum('prev_outstanding_amount') + $sales_report->sum('petty_cash')) - $sales_report->sum('total_advance_amount') }}