TNA Dashboard

@php // Query TNAs based on the user's role and assigned buyers $query = DB::table('t_n_a_s')->where('order_close', '0'); // Assuming this is the base query $buyerList = DB::table('t_n_a_s')->where('order_close', '0')->select('buyer')->distinct()->get(); @endphp

{{-- Back --}} @foreach ($buyerList as $buyer) @endforeach

@php $sl = 1; @endphp @forelse ($tnas as $tna) {{-- @dd($tna) --}} @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', 'cutting', 'etd'] as $task) @foreach (['plan', 'actual'] as $type) @php $date = $tna->{$task . '_' . $type}; $cellClass = ''; $explanation = ''; // Default explanation to empty // Check if $date is a valid date and not 'N/A' if ($date && $date !== 'N/A' && strtotime($date) !== false) { try { $cellDate = \Carbon\Carbon::parse($date); $today = \Carbon\Carbon::now(); $diffDays = $today->diffInDays($cellDate, false); if ($type === 'plan' && empty($tna->{$task . '_actual'})) { if ($cellDate->isToday() || $cellDate->lt($today)) { $cellClass = 'bg-red'; } elseif ($diffDays <= 2) { $cellClass = 'bg-yellow'; } else { $cellClass = 'bg-light'; } } if ($type === 'actual' && $tna->{$task . '_plan'}) { $planDate = \Carbon\Carbon::parse($tna->{$task . '_plan'}); if ($cellDate->gt($planDate)) { $cellClass = 'text-danger font-weight-bold'; } } } catch (\Exception $e) { // Log the error or handle it appropriately $date = ''; // Reset the date if parsing fails } } elseif ($date === 'N/A') { $cellClass = 'text-muted'; // Optional: add a class for 'N/A' } @endphp @if ($type === 'actual' && empty($date)) @else @php $explanation = DB::table('tna_explanations') ->where('perticulars', $task . '_' . $type) ->where('tna_id', $tna->id) ->first()->explanation ?? ''; @endphp @endif @endforeach @endforeach @empty @endforelse

Action	Buyer	Style	PO Number	Item	Qty (pcs)	PO Receive Date	Shipment/ETD	Total Lead Time	Order Free Time	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		Cutting		ETD
Action	Buyer	Style	PO Number	Item						Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan	Actual
{{ $sl++ }}	{{ $tna->buyer }}	{{ str_replace(',', ' ', $tna->style) }}	{{ str_replace(',', ' ', $tna->po) }}	{{ $tna->item }}	{{ $tna->qty_pcs }}	{{ \Carbon\Carbon::parse($tna->po_receive_date)->format('d-M-y') ?? '' }}	{{ \Carbon\Carbon::parse($tna->shipment_etd)->format('d-M-y') ?? '' }}	{{ $tna->total_lead_time }}	@if ($tna->pp_meeting_actual == null) @php $today = \Carbon\Carbon::parse($tna->pp_meeting_plan); $shipment_etd = \Carbon\Carbon::parse($tna->shipment_etd); $diffDays = $today->diffInDays($shipment_etd, false); if ($diffDays > 0) { echo $diffDays; } else { echo '0'; } @endphp @else @php $today = \Carbon\Carbon::parse($tna->pp_meeting_plan); $shipment_etd = \Carbon\Carbon::parse($tna->pp_meeting_actual); $diffDays = $today->diffInDays($shipment_etd, false); if ($diffDays > 0) { echo $diffDays; } else { echo '0'; } @endphp @endif		{{ $date == 'N/A' ? 'N/A' : ($date ? \Carbon\Carbon::parse($date)->format('d-M-y') : '') }}
No TNA Found