Job List

Close Create Holydays Add Capacity Plan Add Sewing Plan

@can('TNA-CURD') Add Job Job Excel Upload @endcan

@if (session('message'))

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

@endif

@forelse ($jobs as $job) @empty @endforelse

Job No	Buyer	Style	PO Number	Item	Order Qty	Sewing Balance	Shipped Qty	Receive Date	Delivery Date	Action
	{{ $job->buyer }}	{{ $job->style }}	{{ $job->po }}	{{ $job->item }}	{{ $job->order_quantity }}	@php $sewing_qty = DB::table('sewing_balances') ->where('job_no', $job->job_no) ->get() ->sum('sewing_balance'); $total_sewing_qty = $job->order_quantity - $sewing_qty ?? 0; @endphp	@php $total_shipped_qty = DB::table('shipments') ->where('job_no', $job->job_no) ->get() ->sum('shipped_qty'); @endphp	{{ $job->order_received_date }}	{{ $job->delivery_date }}	@if (auth()->user()->role_id == 1) @csrf @method('POST') @csrf @method('POST') @endif
No Job Found

@php $sewing_balance = App\Models\SewingBalance::select( 'job_no', 'color', 'size', DB::raw('SUM(sewing_balance) as total_sewing_balance'), DB::raw('SUM(production_min_balance) as total_production_min_balance'), ) ->where('job_no', $job->job_no) ->groupBy('job_no', 'color', 'size') ->get(); @endphp

@forelse ($sewing_balance as $balance) @php $order_qty = App\Models\Job::where('job_no', $balance->job_no) ->where('color', $balance->color) ->where('size', $balance->size) ->first()->color_quantity; @endphp @empty @endforelse

Job No	Color	Size	Order Qty	Total Sewing QTY	Total Sewing Balance	Total Production Min Balance	Action
{{ $balance->job_no }}	{{ $balance->color }}	{{ $balance->size }}	{{ $order_qty }}	{{ $balance->total_sewing_balance }}	{{ $order_qty - $balance->total_sewing_balance }}	{{ $balance->total_production_min_balance }}	show
No Sewing Balance Found

@php // Fetch shipped quantities and values $shipped_qty = App\Models\Shipment::select( 'job_no', 'color', 'size', DB::raw('SUM(shipped_qty) as total_shipped_qty'), DB::raw('SUM(shipped_value) as total_shipped_value'), DB::raw('SUM(excess_short_shipment_qty) as total_excess_short_shipment_qty'), DB::raw('SUM(excess_short_shipment_value) as total_excess_short_shipment_value'), ) ->where('job_no', $job->job_no) ->groupBy('job_no', 'color', 'size') ->get(); @endphp

@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
Total