@csrf {{-- --}} @php $unique_booking = []; $unique_receive = []; $unique_rcv_bal = []; @endphp @foreach ($fabrics_receive as $fabricsChallanDataInput) {{-- @dd($fabricsChallanDataInput) --}} @php $booking_qty = App\Models\FabricsReceive::where('color_name', $fabricsChallanDataInput['color_name']) ->where('buyer_id', $fabricsChallanDataInput['buyer_id']) ->where('order_style', $fabricsChallanDataInput['order_style']) ->where('parts', $fabricsChallanDataInput['parts']) ->where('rack_no', $fabricsChallanDataInput['rack_no']) ->where('self_bin_no', $fabricsChallanDataInput['self_bin_no']) ->get('booking_qty'); //if booking qty is different for same color, buyer, order, parts, rack, self/bin no then it only sum the booking qty of unique booking qty $booking_qty = $booking_qty->unique('booking_qty')->sum('booking_qty'); // dd($booking_qty); $receive_qty = App\Models\FabricsReceive::where('color_name', $fabricsChallanDataInput['color_name']) ->where('buyer_id', $fabricsChallanDataInput['buyer_id']) ->where('order_style', $fabricsChallanDataInput['order_style']) ->where('parts', $fabricsChallanDataInput['parts']) ->where('rack_no', $fabricsChallanDataInput['rack_no']) ->where('self_bin_no', $fabricsChallanDataInput['self_bin_no']) ->sum('receive_qty'); $total_rcv_bal_qty = App\Models\FabricsReceive::where('color_name', $fabricsChallanDataInput['color_name']) ->where('buyer_id', $fabricsChallanDataInput['buyer_id']) ->where('order_style', $fabricsChallanDataInput['order_style']) ->where('parts', $fabricsChallanDataInput['parts']) ->where('rack_no', $fabricsChallanDataInput['rack_no']) ->where('self_bin_no', $fabricsChallanDataInput['self_bin_no']) ->sum('rcv_bal_qty'); // dd($total_rcv_bal_qty, $total_rcv_bal); $rcv_bal = App\Models\FabricsReceive::where('color_name', $fabricsChallanDataInput['color_name']) ->where('buyer_id', $fabricsChallanDataInput['buyer_id']) ->where('order_style', $fabricsChallanDataInput['order_style']) ->where('parts', $fabricsChallanDataInput['parts']) ->sum('receive_qty'); $unique_booking[] = $booking_qty; $unique_receive[] = $receive_qty; $unique_rcv_bal[] = $booking_qty - $receive_qty; // dd($unique_booking, $unique_receive, $unique_rcv_bal) @endphp @endforeach

Fabrication	Challan No	Color	lot	Dia	GSM	Parts	Cons	Rack No	Self/Bin No	Booking Qty	Receive Qty	Total Rec Qty	Balance Qty	Remarks	Actions
															Copy