@if (is_null($trimsChallanDataInputs) || empty($trimsChallanDataInputs))

Currently No Information Available!

@else @if (session('message'))

× {{ session('message') }}.

@endif @if (session('error_message'))

× {{ session('error_message') }}.

@endif

@csrf

Buyer

Order/ Style

Item

Season

Reset

{{--

@csrf

Buyer

Order/ Style

Season

--}}

@php $sl=0 @endphp @foreach ($trimsChallanDataInputs as $spl) @php $data = DB::table('trims_receives') ->where('order_style', $spl->order_style) ->get(); $issue = DB::table('trims_issues') ->where('order_style', $spl->order_style) ->get(); $receive = 0; $issueQty = 0; if ($data->isNotEmpty()) { foreach ($data as $d) { $receive += $d->receive_qty; } } if ($issue->isNotEmpty()) { foreach ($issue as $i) { $issueQty += $i->issue_qty; } } @endphp {{-- --}} {{-- --}} {{-- --}} @endforeach

Sl#

BUYER NAME

ORDER / STYLE

Receive Balance Qty

Issue Balance Qty

New Issue

Actions

@if ($receive != null)

@php $itemList = \App\Models\TrimsReceive::select('item_name', 'itemList_id', DB::raw('SUM(receive_qty) as total_receive_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('item_name', 'itemList_id') ->get(); $issue_qty = DB::table('trims_issues') ->select('item_name', 'itemList_id', DB::raw('SUM(issue_qty) as total_issue_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('item_name', 'itemList_id') ->get(); foreach ($itemList as $item) { foreach ($issue_qty as $issue) { if ($item->itemList_id == $issue->itemList_id) { $balance_qty = $item->total_receive_qty - $issue->total_issue_qty; } else { $balance_qty = $item->total_receive_qty; } } } @endphp @php $sl=0 @endphp @foreach ($itemList as $item) @endforeach

Sl#	Item Name	Total Receive Qty	Total Issue Qty	Balance Qty	Action
{{ ++$sl }}	{{ $item->item_name }}	{{ $item->total_receive_qty }}	@foreach ($issue_qty as $issue) @if ($item->itemList_id == $issue->itemList_id) {{ $issue->total_issue_qty }} @endif @endforeach	@foreach ($issue_qty as $issue) @if ($item->itemList_id == $issue->itemList_id) {{ $item->total_receive_qty - $issue->total_issue_qty }} @endif @endforeach	@csrf

@else 0 @endif

@if ($issue == null) 0 @else

@php $itemList = \App\Models\TrimsIssue::select('item_name', 'itemList_id', DB::raw('SUM(issue_qty) as total_issue_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('item_name', 'itemList_id') ->get(); $receive_qty = DB::table('trims_receives') ->select('item_name', 'itemList_id', DB::raw('SUM(receive_qty) as total_receive_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('item_name', 'itemList_id') ->get(); foreach ($itemList as $item) { foreach ($receive_qty as $receive) { if ($item->itemList_id == $receive->itemList_id) { $balance_qty = $receive->total_receive_qty - $item->total_issue_qty; } else { $balance_qty = $item->total_issue_qty; } } } @endphp @php $sl=0 @endphp @foreach ($itemList as $item) @endforeach

Sl#	Item Name	Total Receive Qty	Total Issue Qty	Balance Qty
{{ ++$sl }}	{{ $item->item_name }}	@foreach ($receive_qty as $receive) @if ($item->itemList_id == $receive->itemList_id) {{ $receive->total_receive_qty }} @endif @endforeach	{{ $item->total_issue_qty }}	@foreach ($receive_qty as $receive) @if ($item->itemList_id == $receive->itemList_id) {{ $receive->total_receive_qty - $item->total_issue_qty }} @endif @endforeach

@endif

@if(auth::user()->role_id==6 || auth::user()->role_id==1) @endif