@forelse ($shipped_qty as $balance) @php // Fetch the order quantity and unit price $job = App\Models\Job::where('job_no', $balance->job_no) ->where('color', $balance->color) ->where('size', $balance->size) ->first(); $order_qty = $job->color_quantity ?? 0; $unit_price = $job->unit_price ?? 0; // Calculate total_short_qty and total_short_value $total_short_qty = $order_qty - $balance->total_shipped_qty; $total_short_value = $total_short_qty * $unit_price; @endphp @empty @endforelse

Job No	Color	Size	Order Qty	Total Shipped Qty	Total Shipped Value	Total Short Shipment Qty	Total Short Shipment Value	Total Excess Qty	Total Excess Value	Action
{{ $balance->job_no }}	{{ $balance->color }}	{{ $balance->size }}	{{ $order_qty }}	{{ $balance->total_shipped_qty }}	{{ $balance->total_shipped_value }}	{{ $total_short_qty }}	{{ $total_short_value }}	{{ $balance->total_excess_short_shipment_qty }}	{{ $balance->total_excess_short_shipment_value }}	Show
No Sewing Balance Found