@if (is_null($hourlyProductionDashboards) || empty($hourlyProductionDashboards))

Currently No Information Available!

@else {{-- --}}

{{-- Create --}} Old Data

{{-- hourlyProductionDashboard Table goes here --}} @php $sl=0 @endphp {{-- @dd($hourlyProductionDashboards); --}} @foreach ($hourlyProductionDashboards as $key => $hourlyProductionDashboard) {{-- --}} {{-- --}} @endforeach

Sl#

Date

Floor

Line

Buyer

Style

Item

Actions

{{ \Carbon\Carbon::parse($hourlyProductionDashboard->date)->format('d-M-Y') }}

Date	Floor	Buyer	Style	Item
{{ \Carbon\Carbon::parse($hourlyProductionDashboard->date)->format('d-M-Y') }}	{{ $hourlyProductionDashboard->floor }}{{ $hourlyProductionDashboard->floor == 1 ? 'st' : ($hourlyProductionDashboard->floor == 2 ? 'nd' : ($hourlyProductionDashboard->floor == 3 ? 'rd' : 'th')) }} Floor	{{ $hourlyProductionDashboard->buyer }}	{{ $hourlyProductionDashboard->style }}	{{ $hourlyProductionDashboard->item }}

@php $hourlyProductionDashboardLines = App\Models\HourlyProductionDashboard::where('date', $hourlyProductionDashboard->date) ->where('floor', $hourlyProductionDashboard->floor) ->where('buyer', $hourlyProductionDashboard->buyer) ->where('style', $hourlyProductionDashboard->style) ->where('item', $hourlyProductionDashboard->item) ->get(); // dd($hourlyProductionDashboardLines) @endphp @foreach ($hourlyProductionDashboardLines as $hourlyProductionDashboardLine) @endforeach

Line	Hour	Qty
{{ $hourlyProductionDashboardLine->line }}	{{ $hourlyProductionDashboardLine->hour }}	{{ $hourlyProductionDashboardLine->qty }}

Date	Floor	Buyer	Style	Item
{{ \Carbon\Carbon::parse($hourlyProductionDashboard->date)->format('d-M-Y') }}	{{ $hourlyProductionDashboard->floor }}{{ $hourlyProductionDashboard->floor == 1 ? 'st' : ($hourlyProductionDashboard->floor == 2 ? 'nd' : ($hourlyProductionDashboard->floor == 3 ? 'rd' : 'th')) }} Floor	{{ $hourlyProductionDashboard->buyer }}	{{ $hourlyProductionDashboard->style }}	{{ $hourlyProductionDashboard->item }}

{{-- @php $hourlyProductionDashboardLines = App\Models\HourlyProductionDashboard::where('date', $hourlyProductionDashboard->date) ->where('floor', $hourlyProductionDashboard->floor) ->where('buyer', $hourlyProductionDashboard->buyer) ->where('style', $hourlyProductionDashboard->style) ->where('item', $hourlyProductionDashboard->item) ->get(); @endphp @foreach ($hourlyProductionDashboardLines as $hourlyProductionDashboardLine) @endforeach

Line	Hour	Qty
{{ $hourlyProductionDashboardLine->line }}	{{ $hourlyProductionDashboardLine->hour }}	{{ $hourlyProductionDashboardLine->qty }}

--}}

{{-- --}} @php $hpd_timeEntry = DB::table('hourly_production_dashboards') ->where('date', $hourlyProductionDashboard->date) ->where('floor', $hourlyProductionDashboard->floor) ->where('buyer', $hourlyProductionDashboard->buyer) ->where('style', $hourlyProductionDashboard->style) ->where('item', $hourlyProductionDashboard->item) ->get(); // dd($hpd_timeEntry->count()); @endphp @foreach ($hpd_timeEntry as $key => $hourlyProductionDashboardTimeEntry) @php $time_entry = DB::table('production_time_entries') ->where('hourly_production_dashboard_id', $hourlyProductionDashboardTimeEntry->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

@if ($hourlyProductionDashboard->buyer == null) @else @endif Show Report History {{-- --}}