Hourly Production Dashboard Data Inforomation Hourly Production Dashboard Data
@if (session('message'))
× {{ session('message') }}.
@endif
Date {{ \Carbon\Carbon::parse($hourlyProductionDashboard->date)->format('d-M-Y') }} Floor {{ $hourlyProductionDashboard->floor }}{{ $hourlyProductionDashboard->floor == 1 ? 'st' : ($hourlyProductionDashboard->floor == 2 ? 'nd' : ($hourlyProductionDashboard->floor == 3 ? 'rd' : 'th')) }} Floor Block {{ $hourlyProductionDashboard->block }}
{{-- --}} @foreach ($hpd_timeEntry as $key => $hourlyProductionDashboardTimeEntry) @php $time_entry = DB::table('production_time_entries') ->where( 'hourly_production_dashboard_id', $hourlyProductionDashboardTimeEntry->id, ) ->where('batch_id', $hourlyProductionDashboardTimeEntry->batch_id) ->where( 'company_id', $hourlyProductionDashboardTimeEntry->company_id, ) ->where( 'division_id', $hourlyProductionDashboardTimeEntry->division_id, ) ->where('date', $hourlyProductionDashboardTimeEntry->date) ->where('floor', $hourlyProductionDashboardTimeEntry->floor) ->where('block', $hourlyProductionDashboardTimeEntry->block) ->where('line', $hourlyProductionDashboardTimeEntry->line) ->get(); // dd($time_entry->count()); @endphp @if ($time_entry->count() > 0) {{-- --}} @else @endif @endforeach
Line Buyer Style No. Item SMV Running M/C Operator Helpar Total M/P Working Hrs. Spent Minutes Production Output/ Day Produce minutes Efficiency. %TGT %TGT/ Hour TGT/ Day Performance Quality Check (Pcs) Defect Qty (Pcs) DHU % Remarks Bottlenecks
{{ $hourlyProductionDashboardTimeEntry->line }} {{ $hourlyProductionDashboardTimeEntry->buyer }} {{ $hourlyProductionDashboardTimeEntry->style }} {{ $hourlyProductionDashboardTimeEntry->item }} {{ number_format($hourlyProductionDashboardTimeEntry->smv, 2) }} {{ $hourlyProductionDashboardTimeEntry->running_machine }} {{ $hourlyProductionDashboardTimeEntry->operator }} {{ $hourlyProductionDashboardTimeEntry->helpar }} @php $total_MP = $hourlyProductionDashboardTimeEntry->operator + $hourlyProductionDashboardTimeEntry->helpar; @endphp {{ $total_MP }} {{ $hourlyProductionDashboardTimeEntry->working_hrs }} @if ($time_entry->count() > 0) @php $spent_minutes = $time_entry->sum('spent_minutes'); if ($spent_minutes > 0) { $spent_minutes = $spent_minutes; } else { $spent_minutes = 0; } @endphp {{ $spent_minutes }} @else @endif @if ($time_entry->count() > 0) @foreach ($time_entry as $item) @endforeach @endif @if ($time_entry->count() > 0) @php $output_per_day = $time_entry->sum('output_hour'); if ($output_per_day > 0) { $output_per_day = $output_per_day; } else { $output_per_day = 0; } @endphp {{ $output_per_day ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $Produce_minutes = ceil( $output_per_day * number_format( $hourlyProductionDashboardTimeEntry->smv, 2, ), ); if ($Produce_minutes > 0) { $Produce_minutes = $Produce_minutes; } else { $Produce_minutes = 0; } @endphp {{ $Produce_minutes ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $efficiency = ($Produce_minutes / $spent_minutes) * 100; if ($efficiency > 0) { $efficiency = $efficiency; } else { $efficiency = 0; } @endphp {{ number_format($efficiency, 2) ?? 0 }} % @else 0 @endif @if ($time_entry->count() > 0) @php $tgt = $time_entry->avg('target'); if ($tgt > 0) { $tgt = $tgt; } else { $tgt = 0; } @endphp {{ ceil($tgt) ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $tgt_hour = ceil( $hourlyProductionDashboardTimeEntry->target_per_day / $hourlyProductionDashboardTimeEntry->working_hrs, ); if ($tgt_hour > 0) { $tgt_hour = $tgt_hour; } else { $tgt_hour = 0; } @endphp {{ $tgt_hour ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $tgt_day = $hourlyProductionDashboardTimeEntry->target_per_day; if ($tgt_day > 0) { $tgt_day = $tgt_day; } else { $tgt_day = 0; } @endphp {{ $tgt_day ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $performance = ($time_entry->sum('output_hour') / $hourlyProductionDashboardTimeEntry->target_per_day) * 100; if ($performance > 0) { $performance = $performance; } else { $performance = 0; } @endphp {{ number_format($performance, 2) ?? 0 }} % @else 0 @endif @if ($time_entry->count() > 0) @php $quality_check = $time_entry->sum('quality_check_pcs'); if ($quality_check > 0) { $quality_check = $quality_check; } else { $quality_check = 0; } @endphp {{ $quality_check ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $defect_qty = $time_entry->sum('defect_qty_pcs'); if ($defect_qty > 0) { $defect_qty = $defect_qty; } else { $defect_qty = 0; } @endphp {{ $defect_qty ?? 0 }} @else 0 @endif @if ($time_entry->count() > 0) @php $dhu = ($defect_qty / $quality_check) * 100; if ($dhu > 0) { $dhu = $dhu; } else { $dhu = 0; } @endphp {{ number_format($dhu, 2) ?? 0 }} @else 0 @endif {{ $hourlyProductionDashboardTimeEntry->remarks }} @if ($time_entry->count() > 0) @foreach ($time_entry as $item) @endforeach @endif No Data Found

Fatal error: Uncaught Error: Class "DB" not found in D:\NTG_App\www\Fashion_Asia_Limited\FAL_Hourly_Production\resources\temp\dataentryform3.blade.php:534 Stack trace: #0 {main} thrown in D:\NTG_App\www\Fashion_Asia_Limited\FAL_Hourly_Production\resources\temp\dataentryform3.blade.php on line 534