| id | Buyer | Style | PO Number | Item | Qty (pcs) | PO Receive Date | Shipment ETD | Total Lead Time | Order Free Time | Lab Dip Submission (Plan) | Lab Dip Submission (Actual) | Fabric Booking (Plan) | Fabric Booking (Actual) | Fit Sample Submission (Plan) | Fit Sample Submission (Actual) | Print Strike Off Submission (Plan) | Print Strike Off Submission (Actual) | Bulk Accessories Booking (Plan) | Bulk Accessories Booking (Actual) | Fit Comments (Plan) | Fit Comments (Actual) | Bulk Yarn Inhouse (Plan) | Bulk Yarn Inhouse (Actual) | Bulk Accessories Inhouse (Plan) | Bulk Accessories Inhouse (Actual) | PP Sample Submission (Plan) | PP Sample Submission (Actual) | Bulk Fabric Knitting (Plan) | Bulk Fabric Knitting (Actual) | PP Comments Receive (Plan) | PP Comments Receive (Actual) | Bulk Fabric Dyeing (Plan) | Bulk Fabric Dyeing (Actual) | Bulk Fabric Delivery (Plan) | Bulk Fabric Delivery (Actual) | PP Meeting (Plan) | PP Meeting (Actual) | Fabrics and Accessories Inspection (Plan) | Fabrics and Accessories Inspection (Actual) | Size Set Making (Plan) | Size Set Making (Actual) | Pattern Correction (Plan) | Pattern Correction (Actual) | Machines, Layout, and Folder Preparation (Plan) | Machines, Layout, and Folder Preparation (Actual) | Bulk Cutting Start (Plan) | Bulk Cutting Start (Actual) | Print/Emb. Start (Plan) | Print/Emb. Start (Actual) | Bulk Sewing Input (Plan) | Bulk Sewing Input (Actual) | Bulk Wash Start (Plan) | Bulk Wash Start (Actual) | Bulk Finishing Start (Plan) | Bulk Finishing Start (Actual) | Bulk Cutting Close (Plan) | Bulk Cutting Close (Actual) | Print/Emb. Close (Plan) | Print/Emb. Close (Actual) | Bulk Sewing Close (Plan) | Bulk Sewing Close (Actual) | Bulk Wash Close/Finishing Received (Plan) | Bulk Wash Close/Finishing Received (Actual) | Bulk Finishing Close (Plan) | Bulk Finishing Close (Actual) | Pre-final Inspection (Plan) | Pre-final Inspection (Actual) | Final Inspection (Plan) | Final Inspection (Actual) | Ex-factory (Plan) | Ex-factory (Actual) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ $tna->id }} | {{ $tna->buyer }} | {{ $tna->style }} | {{ $tna->po }} | {{ $tna->item }} | {{ $tna->qty_pcs }} | {{ $tna->po_receive_date ? \Carbon\Carbon::parse($tna->po_receive_date)->format('d-M-Y') : '' }} | {{ $tna->shipment_etd ? \Carbon\Carbon::parse($tna->shipment_etd)->format('d-M-Y') : '' }} | {{ $tna->total_lead_time }} | @php $orderFreeTime = $tna->pp_meeting_actual ? \Carbon\Carbon::parse($tna->pp_meeting_actual)->diffInDays( \Carbon\Carbon::parse($tna->shipment_etd), false, ) : \Carbon\Carbon::parse($tna->pp_meeting_plan)->diffInDays( \Carbon\Carbon::parse($tna->shipment_etd), false, ); echo max($orderFreeTime, 0); @endphp | @foreach (['lab_dip_submission', 'fabric_booking', 'fit_sample_submission', 'print_strike_off_submission', 'bulk_accessories_booking', 'fit_comments', 'bulk_yarn_inhouse', 'bulk_accessories_inhouse', 'pp_sample_submission', 'bulk_fabric_knitting', 'pp_comments_receive', 'bulk_fabric_dyeing', 'bulk_fabric_delivery', 'pp_meeting', 'fabrics_and_accessories_inspection', 'size_set_making', 'pattern_correction', 'machines_layout', 'cutting', 'print_start', 'bulk_sewing_input', 'bulk_wash_start', 'bulk_finishing_start', 'bulk_cutting_close', 'print_close', 'bulk_sewing_close', 'bulk_wash_close', 'bulk_finishing_close', 'pre_final_inspection', 'final_inspection', 'ex_factory'] as $task)@if (!empty($tna->{$task . '_plan'}) && strtotime($tna->{$task . '_plan'})) {{ \Carbon\Carbon::parse($tna->{$task . '_plan'})->format('d-M-Y') }} @else N/A @endif | @if (!empty($tna->{$task . '_actual'}) && strtotime($tna->{$task . '_actual'})) {{ \Carbon\Carbon::parse($tna->{$task . '_actual'})->format('d-M-Y') }} @else N/A @endif | @endforeach