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

Currently No Information Available!

@else {{-- --}}

Back @can('QC-CURD') @endcan Old Data

@csrf

@php $buyers = DB::table('working_hour_allocations') ->select('buyer_id', 'buyer') ->distinct() ->get(); $styles = DB::table('working_hour_allocations') ->select('style') ->distinct() ->get(); $lines = DB::table('working_hour_allocations') ->select('line') ->distinct() ->get(); $items = DB::table('working_hour_allocations') ->select('item') ->distinct() ->get(); @endphp

Buyer

Style

Item

Line

From Date

To Date

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

Sl#

Date

Floor

Line

Section

Buyer

Style

Item

Hours

Actions

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

@php $whasLines = DB::table( 'working_hour_allocations', ) ->where('date', now()->format('Y-m-d')) ->where('floor', $whas->floor) ->where('buyer', $whas->buyer) ->where('style', $whas->style) ->where('item', $whas->item) ->where('line', $whas->line) ->distinct('start_time', 'end_time') ->get(); // dd($whasLines); @endphp

Alter Data

@foreach ($whasLines as $whasLine) @endforeach

@can('QC-EDIT') Action @endcan	Hours	Sewing DHU%	Total Production	Total Alter	Total Check	Uneven Shape	Broken Stitch	Dirty Mark	Oil Stain	Down Stitch	Hiking	Improper Tuck	Label Alter	Needle Mark / Hole	Open Seam	Skip Stitch	Pleat	Sleeve / Shoulder Up Down	Puckering	Raw Edge	Shading	Others
@can('QC-EDIT') @csrf @endcan	{{ $whasLine->start_time }} - {{ $whasLine->end_time }}	@php $sewing_dhu = $whasLine->sewing_dhu; // show only 2 decimal points $sewing_dhu = number_format( $sewing_dhu, 2, ); echo $sewing_dhu; @endphp	{{ $whasLine->Total_Production }}	{{ $whasLine->Total_Alter }}	{{ $whasLine->total_check }}	{{ $whasLine->Uneven_Shape }}	{{ $whasLine->Broken_Stitch }}	{{ $whasLine->Dirty_Mark }}	{{ $whasLine->Oil_Stain }}	{{ $whasLine->Down_Stitch }}	{{ $whasLine->Hiking }}	{{ $whasLine->Improper_Tuck }}	{{ $whasLine->Label_Alter }}	{{ $whasLine->Needle_Mark_Hole }}	{{ $whasLine->Open_Seam }}	{{ $whasLine->Skip_Stitch }}	{{ $whasLine->Pleat }}	{{ $whasLine->Sleeve_Shoulder_Up_Down }}	{{ $whasLine->Puckering }}	{{ $whasLine->Raw_Edge }}	{{ $whasLine->Shading }}	{{ $whasLine->Others }}
Total		@php $sewing_dhu = $whasLines->avg( 'sewing_dhu', ); // show only 2 decimal points $sewing_dhu = number_format( $sewing_dhu, 2, ); echo $sewing_dhu; @endphp	@php $total_production = $whasLines->sum( 'Total_Production', ); echo $total_production; @endphp	@php $total_alter = $whasLines->sum( 'Total_Alter', ); echo $total_alter; @endphp	@php $total_check = $whasLines->sum( 'total_check', ); echo $total_check; @endphp	@php $uneven_shape = $whasLines->sum( 'Uneven_Shape', ); echo $uneven_shape; @endphp	@php $broken_stitch = $whasLines->sum( 'Broken_Stitch', ); echo $broken_stitch; @endphp	@php $dirty_mark = $whasLines->sum( 'Dirty_Mark', ); echo $dirty_mark; @endphp	@php $oil_stain = $whasLines->sum( 'Oil_Stain', ); echo $oil_stain; @endphp	@php $down_stitch = $whasLines->sum( 'Down_Stitch', ); echo $down_stitch; @endphp	@php $hiking = $whasLines->sum( 'Hiking', ); echo $hiking; @endphp	@php $improper_tuck = $whasLines->sum( 'Improper_Tuck', ); echo $improper_tuck; @endphp	@php $label_alter = $whasLines->sum( 'Label_Alter', ); echo $label_alter; @endphp	@php $needle_mark_hole = $whasLines->sum( 'Needle_Mark_Hole', ); echo $needle_mark_hole; @endphp	@php $open_seam = $whasLines->sum( 'Open_Seam', ); echo $open_seam; @endphp	@php $skip_stitch = $whasLines->sum( 'Skip_Stitch', ); echo $skip_stitch; @endphp	@php $pleat = $whasLines->sum( 'Pleat', ); echo $pleat; @endphp	@php $sleeve_shoulder_up_down = $whasLines->sum( 'Sleeve_Shoulder_Up_Down', ); echo $sleeve_shoulder_up_down; @endphp	@php $puckering = $whasLines->sum( 'Puckering', ); echo $puckering; @endphp	@php $raw_edge = $whasLines->sum( 'Raw_Edge', ); echo $raw_edge; @endphp	@php $shading = $whasLines->sum( 'Shading', ); echo $shading; @endphp	@php $others = $whasLines->sum( 'Others', ); echo $others; @endphp

Reject Data

@foreach ($whasLines as $whasLine) @endforeach

Hours	Reject %	Total Reject	Fabric_hole	Scissor/ Cuttar Cut	Needle Hole	Print/ EMB Damage	Shading	Others
{{ $whasLine->start_time }} - {{ $whasLine->end_time }}	@php $reject_dhu = $whasLine->reject_dhu; // show only 2 decimal points $reject_dhu = number_format( $reject_dhu, 2, ); echo $reject_dhu; @endphp	{{ $whasLine->Total_reject }}	{{ $whasLine->reject_Fabric_hole }}	{{ $whasLine->reject_scissor_cuttar_cut }}	{{ $whasLine->reject_Needle_hole }}	{{ $whasLine->reject_Print_emb_damage }}	{{ $whasLine->reject_Shading }}	{{ $whasLine->reject_Others }}
Total	@php $reject_dhu = $whasLines->avg( 'reject_dhu', ); // show only 2 decimal points $reject_dhu = number_format( $reject_dhu, 2, ); echo $reject_dhu; @endphp	@php $Total_reject = $whasLines->sum( 'Total_reject', ); echo $Total_reject; @endphp	@php $reject_Fabric_hole = $whasLines->sum( 'reject_Fabric_hole', ); echo $reject_Fabric_hole; @endphp	@php $reject_scissor_cuttar_cut = $whasLines->sum( 'reject_scissor_cuttar_cut', ); echo $reject_scissor_cuttar_cut; @endphp	@php $reject_Needle_hole = $whasLines->sum( 'reject_Needle_hole', ); echo $reject_Needle_hole; @endphp	@php $reject_Print_emb_damage = $whasLines->sum( 'reject_Print_emb_damage', ); echo $reject_Print_emb_damage; @endphp	@php $reject_Shading = $whasLines->sum( 'reject_Shading', ); echo $reject_Shading; @endphp	@php $reject_Others = $whasLines->sum( 'reject_Others', ); echo $reject_Others; @endphp

@php $hpd_timeEntry = DB::table('working_hour_allocations') ->where('date', now()->format('Y-m-d')) ->where('floor', $whas->floor) ->where('buyer', $whas->buyer) ->where('style', $whas->style) ->where('item', $whas->item) ->where('line', $whas->line) ->distinct('start_time', 'end_time') ->get(); // dd($hpd_timeEntry->count()); // dd($hpd_timeEntry); @endphp @if ($hpd_timeEntry->count() > 0) @foreach ($hpd_timeEntry as $timeEntry) {{-- @dd($timeEntry); --}} @if ($timeEntry->Total_Alter == null) @else {{ $timeEntry->start_time }}, @endif @endforeach @endif

@php // Query to get the latest entry for the given conditions $hpd_timeEntry = DB::table('working_hour_allocations') ->where('date', now()->format('Y-m-d')) ->where('floor', $whas->floor) ->where('buyer', $whas->buyer) ->where('style', $whas->style) ->where('item', $whas->item) ->where('line', $whas->line) ->latest('id') ->first(); // Use first() to get the single latest record @endphp @if ($hpd_timeEntry) @if ($hpd_timeEntry->Total_Alter === null) @else @endif @endif @can('QC-EDIT')

@csrf @method('DELETE')

@endcan