Out of Stock Summary Report {{$this->selectedBranch}}
Report Date: {{ date('M j, Y g:i:s a',strtotime(now()))}}	Generated By: {{ auth()->user()->name}}
Coverage: {{date('M j, Y',strtotime($start_date)).' - '.date('M j, Y',strtotime($end_date))}}
*Note: Coverage date is based on Actual Date.

@foreach($products as $p) @if(empty(!$data)) @foreach($date_range as $dr) @php $b_data= $data->where('inventory_date',$dr)->where('item_code',$p->item_code); $min_hour = $b_data->min('hour'); $first = $b_data->where('hour',$min_hour)->first(); $beginning = isset($first->beginning) ? $first->beginning : 0; $running = $beginning; $arr=[]; if($b_data->sum('beginning') > 0 || $b_data->sum('s_ins') > 0 || $b_data->sum('s_outs') > 0){ for ($i = 0; $i < 24; $i++){ $r_data = $b_data->where('hour',$i)->first(); if(!is_null($r_data)){ $running += ($r_data->s_ins - $r_data->s_outs); if($running <= 0){ array_push($arr,$r_data->hour); } } } } @endphp @if(!empty($arr)) @endif @endforeach @else @endif

{{ $p->item_code}} {{ $p->item_description}}
Date	BEG	PAR	RD	SOLD	OOST
{{ date('F j, Y (l)', strtotime($dr))}}	{{ $beginning }}	{{ $b_data->max('par_stock')}}	{{ $b_data->sum('deliveries')}}	{{ $b_data->sum('sales')}}	@foreach($arr as $a) {{$a.':00'.($loop->last ? '':', ')}} @endforeach
NO DATA

@endforeach