@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

@php $total_MP = $hourlyProductionDashboardTimeEntry->operator + $hourlyProductionDashboardTimeEntry->helpar; @endphp {{ $total_MP }}

@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

Time	Achievements
{{ $item->productions_end_hours }}	{{ $item->output_hour }}

@else No Data Found

@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 {{ $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

@if ($time_entry->count() > 0) @foreach ($time_entry as $item) @endforeach

Time	M/C	Remarks
{{ $item->productions_end_hours }}	{{ $item->Bottlenecks_machine }}	{{ $item->Bottlenecks_remarks }}

@endif

No Data Found

Back Print Export Print & Send to Email