Sales Trend Report
Period : {{ $period }}
Group by : {{ $groupname }}

@if ($show_onhand) @endif @if ($show_onhand) @endif @if ($show_onhand) @endif @if ($show_onhand) @endif @php $total_qty1 = 0; $total_gross1 = 0; $total_disc1 = 0; $total_nett1 = 0; $total_qty2 = 0; $total_gross2 = 0; $total_disc2 = 0; $total_nett2 = 0; @endphp @if ($show_onhand) @php $total_onhand1 = 0; $total_onhand2 = 0; @endphp @endif @foreach($data as $item) @if ($show_onhand) @endif @if ($show_onhand) @endif @php $total_qty1 += $item['qty1']; $total_gross1 += $item['gross1']; $total_disc1 += $item['disc1']; $total_nett1 += $item['nett1']; $total_qty2 += $item['qty2']; $total_gross2 += $item['gross2']; $total_disc2 += $item['disc2']; $total_nett2 += $item['nett2']; @endphp @if ($show_onhand) @php $total_onhand1 += $item['onhand1']; $total_onhand2 += $item['onhand2']; @endphp @endif @endforeach @php if ($total_nett1 == 0 && $total_nett2 == 0) { $growth = 0; } elseif ($total_nett1 == 0 && $total_nett2 > 0) { $growth = 100; } elseif ($total_nett1 == 0 && $total_nett2 < 0) { $growth=-100; } else { $growth=($total_nett2 - $total_nett1) / $total_nett1 * 100; } @endphp @if ($show_onhand) @endif @if ($show_onhand) @endif

{{ __('Warehouse') }}	{{ $groupname }}	{{ $period1 }}					{{ $period2 }}					{{ __('Growth') }}
		{{ __('Sales') }}				{{ __('Stock') }}	{{ __('Sales') }}				{{ __('Stock') }}
		{{ __('Qty') }}	{{ __('Gross') }}	{{ __('Disc') }}	{{ __('Nett') }}	{{ __('Qty') }}	{{ __('Qty') }}	{{ __('Gross') }}	{{ __('Disc') }}	{{ __('Nett') }}	{{ __('Qty') }}
{{ $item['whs'] }}	{{ $item['group'] }}	{{ $item['qty1'] }}	{{ $item['gross1'] }}	{{ $item['disc1'] }}	{{ $item['nett1'] }}	{{ $item['onhand1'] }}	{{ $item['qty2'] }}	{{ $item['gross2'] }}	{{ $item['disc2'] }}	{{ $item['nett2'] }}	{{ $item['onhand2'] }}	{{ $item['var'] }}
Total		{{ $total_qty1 }}	{{ $total_gross1 }}	{{ $total_disc1 }}	{{ $total_nett1 }}	{{ $total_onhand1 }}	{{ $total_qty2 }}	{{ $total_gross2 }}	{{ $total_disc2 }}	{{ $total_nett2 }}	{{ $total_onhand2 }}	{{ $growth }}