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

Currently No Information Available!

@else @if (session('message'))

× {{ session('message') }}.

@endif

@php // Combined database queries $workerData = DB::table('worker_entries') ->select('floor', 'id_card_no', 'present_grade', 'recomanded_grade') ->distinct() ->get(); $processData = DB::table('worker_sewing_process_entries') ->select('sewing_process_type', 'sewing_process_name') ->distinct() ->get(); @endphp

Floor:

ID Card No: {{-- --}} @foreach ($workerData->unique('id_card_no') as $item) @endforeach

Process Type:

Process Name:

Present Grade:

Recommended Grade:

Reset

@can('Admin') @endcan @if (auth()->user()->role_id == 1 || auth()->user()->role_id == 3) All Data Download @endif Unfinished list

@if (session('search_worker') || $search_worker)

@csrf

Export Format:

@endif

@php $sl=0 @endphp @foreach ($workerEntries as $spl) @php $data = DB::table('worker_sewing_process_entries') ->where('worker_entry_id', $spl->id) ->get(); $machine_type = DB::table('sewing_process_lists') ->whereIn('id', $data->pluck('sewing_process_list_id')) ->get('machine_type'); $grades = [ 'F' => 0, 'D' => 1, 'C' => 2, 'C+' => 3, 'C++' => 4, 'B' => 5, 'B+' => 6, 'A' => 7, 'A+' => 8, ]; if ($spl->present_grade != null && $spl->recomanded_grade != null) { $present_grade_value = $grades[$spl->present_grade]; $recommended_grade_value = $grades[$spl->recomanded_grade]; } else { $present_grade_value = 9; $recommended_grade_value = 0; } $row_class = $recommended_grade_value < $present_grade_value ? 'bg-danger' : ''; @endphp {{-- --}} {!! $spl->actions !!} @endforeach

Sl#	Floor	Line	ID Card No	Name	Process Type	Machine Type	Process Name	Present Grade	Recommended Grade	Recommended Salary	Actions
{{ $spl->id }}	{{ $spl->floor }}	@if ($spl->line == null) Line Entry @else {{ $spl->line }} @endif	{{ $spl->id_card_no }}	{{ $spl->employee_name_english }}	@foreach ($data as $item) {{ ucwords($item->sewing_process_type) }} @endforeach	@foreach ($machine_type as $type) {{ ucwords($type->machine_type) }} @endforeach	@foreach ($data as $item) {{ ucwords($item->sewing_process_name) }} @endforeach	{{ $spl->present_grade }}	{{ $spl->recomanded_grade }}	@if ($spl->recomanded_salary == null \|\| $spl->recomanded_salary == 'N/A') Failed @else {{ $spl->recomanded_salary }} TK @endif