Report Parameters

Transaction Year* @error('transaction_year') {{ $message }} @enderror

Store Filter* @error('selectedBranchFilter') {{ $message }} @enderror

@error('selectedBranches') {{ $message }} @enderror

General Category* @error('selectedCategory') {{ $message }} @enderror

Area* @error('selectedArea') {{ $message }} @enderror

Provincial vs. Non-Provincial* @error('selectedProvincialNonProvincial') {{ $message }} @enderror

City/Municipality* @error('selectedCity') {{ $message }} @enderror

Generating Report..

Generating CSV File..

Item Sales and Quantity Sold Report (Monthly)

Report Date: {{ date('F j, Y g:i:s a',strtotime(now()))}}

Generated By: {{ auth()->user()->name}}

Coverage: Year {{$transaction_year}}

*Note: Coverage date is based on Transaction Date.

@forelse($monthly_aggregate_data as $mad) @php $filtered_data = array_filter($data, function($row) use($mad) { return $row[0] == $mad[0]; }); @endphp @foreach($filtered_data as $fd) @endforeach @empty @endforelse

Month	Item Code	Item Name	Gross Sales	Quantity
{{ $mad[1] }}	{{ $fd[1] }}	{{ $fd[2] }}	{{ number_format((float)$fd[3],2,'.',',') }}	{{ $fd[4] }}
{{ $mad[1]}} TOTAL			{{ number_format((float)$mad[2],2,'.',',')}}	{{ number_format((float)$mad[3],2,'.',',')}}
			0	0

@push('custom-scripts') @endpush