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

Currently No Information Available!

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

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

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

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

@endif

@csrf

Buyer

Order/ Style

Book. No

Lot. No

Season

Reset

@php $sl=0 @endphp @foreach ($fabricsChallanDataInputs as $spl) @php $data = DB::table('fabrics_receives') ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->where('book_no', $spl->book_no) ->get(); $issue = DB::table('fabrics_issues') ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->where('book_no', $spl->book_no) ->get(); $receive = 0; $dlv_cutting = 0; if ($data->isNotEmpty()) { foreach ($data as $d) { $receive += $d->receive_qty; } } if ($issue->isNotEmpty()) { foreach ($issue as $i) { $dlv_cutting += $i->dlv_cutting; } } // dd($dlv_cutting); @endphp {{-- --}} {{-- --}} @endforeach

Sl#

BUYER NAME

ORDER / STYLE

BOOK. NO

lot

Receive Balance Qty

Issue Balance Qty

New Issue

Actions

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

@endif {{ $spl->id }}-{{ ++$sl }}

@php $lot = DB::table('fabrics_receives') ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->where('book_no', $spl->book_no) ->select('lot') ->distinct() ->get(); @endphp @if ($lot->isNotEmpty()) @foreach ($lot as $item) {{ $item->lot }}, @endforeach @else 0 @endif

@if ($receive != null)

@php $itemList = \App\Models\FabricsReceive::select('parts', 'rack_no', 'self_bin_no', 'fabric_type', 'color_name', DB::raw('SUM(receive_qty) as total_receive_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('parts', 'rack_no', 'self_bin_no', 'fabric_type', 'color_name') ->get(); $booking = DB::table('fabrics_receives') ->select('parts', 'fabric_type', 'color_name', 'rack_no', 'self_bin_no', DB::raw('MAX(booking_qty) as max_booking_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('parts', 'rack_no', 'self_bin_no', 'fabric_type', 'color_name') ->get(); // dd($booking); $dlv_cutting = DB::table('fabrics_issues') ->select('parts', 'rack_no', 'self_bin_no', 'fabric_type', 'color_name', DB::raw('SUM(dlv_cutting) as total_issue_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('parts', 'rack_no', 'self_bin_no', 'fabric_type', 'color_name') ->get(); $totalReceive = DB::table('fabrics_receives') ->select('parts', 'fabric_type', 'color_name', DB::raw('SUM(receive_qty) as total_receive_qty'), DB::raw('MAX(booking_qty) as max_booking_qty'), DB::raw('MAX(booking_qty) - SUM(receive_qty) as Recv_balance_qty')) ->where('buyer_id', $spl->buyer_id) ->where('order_style', $spl->order_style) ->groupBy('parts', 'fabric_type', 'color_name') ->get() ->toArray(); // dd($totalReceive); @endphp @php $sl = 0; $lastTotalReceiveQty = 0; $last_balance = 0; @endphp @foreach ($itemList as $item) {{-- Checking if $totalReceive is an array --}} @if (is_array($totalReceive)) @foreach ($totalReceive as $totalReceiveItem) {{-- Checking if $totalReceiveItem is an object and has the required properties --}} @if (is_object($totalReceiveItem) && property_exists($totalReceiveItem, 'parts') && property_exists($totalReceiveItem, 'fabric_type') && property_exists($totalReceiveItem, 'color_name')) @if ( $item->parts == $totalReceiveItem->parts && $item->fabric_type == $totalReceiveItem->fabric_type && $item->color_name == $totalReceiveItem->color_name) @endif @endif @endforeach @endif @endforeach

Sl#	Parts	Fabric Type	Color Name	Rack No	Self Bin No	Total Booking Qty	Total Receive Qty	Recv Balance Qty	Total Issue Qty	Balance Qty	Action
{{ ++$sl }}	{{ $item->parts }}	{{ $item->fabric_type }}	{{ $item->color_name }}	{{ $item->rack_no }}	{{ $item->self_bin_no }}	@foreach ($booking as $book) @if ( $item->parts == $book->parts && $item->rack_no == $book->rack_no && $item->self_bin_no == $book->self_bin_no && $item->fabric_type == $book->fabric_type && $item->color_name == $book->color_name) {{ $book->max_booking_qty }} @endif @endforeach	{{ $item->total_receive_qty }}	{{ $totalReceiveItem->max_booking_qty - $totalReceiveItem->total_receive_qty }}	@foreach ($dlv_cutting as $issue) @if ( $item->parts == $issue->parts && $item->rack_no == $issue->rack_no && $item->self_bin_no == $issue->self_bin_no && $item->fabric_type == $issue->fabric_type && $item->color_name == $issue->color_name) {{ $issue->total_issue_qty }} @endif @endforeach	@foreach ($dlv_cutting as $issue) @if ( $item->parts == $issue->parts && $item->rack_no == $issue->rack_no && $item->self_bin_no == $issue->self_bin_no && $item->fabric_type == $issue->fabric_type && $item->color_name == $issue->color_name) {{ $item->total_receive_qty - $issue->total_issue_qty }} @endif @endforeach	@csrf

@else 0 @endif

@if ($dlv_cutting == null) 0 @else @endif

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