Stock Report ({{ $month }}) |
S.NO | Items |
Est. Stock
|
@if($orderNumberOpen > 0 )
Order 1
{{(!empty($category->orderDates)) ? \Carbon\Carbon::parse($category->orderDates[0])->format('d-M-Y') : ""}} |
@endif
@if(($orderNumberOpen > 1 && $orderNumberOpen <= 3))
Order 2
{{(!empty($category->orderDates) && (count($category->orderDates) > 1)) ? \Carbon\Carbon::parse($category->orderDates[1])->format('d-M-Y') : ""}} |
@endif
@if($orderNumberOpen > 2 && $orderNumberOpen <= 3)
Order 3
{{(!empty($category->orderDates) && (count($category->orderDates) > 2)) ? \Carbon\Carbon::parse($category->orderDates[2])->format('d-M-Y') : ""}} |
@endif
Prev Rem stock | Total Stock | Used Stock | Remaining Stock |
---|---|---|---|---|---|---|---|---|---|
{{$count ++}} | {{$stockItem->itemName}} | {{$stockItem->itemDetails->est_stock ?? 0}}{{$stockItem->itemUnite}} | @if(($orderNumberOpen > 0 )){{$stockItem->itemDetails->order1 ?? 0}}{{$stockItem->itemUnite}} | @endif @if(($orderNumberOpen > 1 && $orderNumberOpen <= 3)){{$stockItem->itemDetails->order2 ?? 0}}{{$stockItem->itemUnite}} | @endif @if(($orderNumberOpen > 2 && $orderNumberOpen <= 3)){{$stockItem->itemDetails->order3 ?? 0}}{{$stockItem->itemUnite}} | @endif{{$stockItem ? ($stockItem->previousMonthData ? $stockItem->previousMonthData->remaningStock : 0 ) : 0 }}{{$stockItem->itemUnite}} | @php $previousMonthReaming = $stockItem->previousMonthData ? $stockItem->previousMonthData->remaningStock : 0; $currentTotalStock = $stockItem->itemDetails ? ($stockItem->itemDetails->total_stock ) : 0; $totalStock = $previousMonthReaming + $currentTotalStock; @endphp {{$totalStock }}{{$stockItem->itemUnite}} | {{ $stockItem->itemDetails->used_stock ?? 0 }}{{$stockItem->itemUnite}} | {{ (($stockItem->itemDetails->remaningStock ?? 0)) + $previousMonthReaming }}{{$stockItem->itemUnite}} |