@php $sl=0 @endphp @foreach ($search_worker 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'); @endphp @endforeach
{{-- Logo --}}
Northern Tosrifa Group
Download Date: {{ Carbon\Carbon::now()->format('d-M-Y') }}
Serial Number Name ID Card No Date of Join Present Grade Proposed Grade Floor Line Machine Process Name Achieve Pcs Efficiency Remarks
{{ ++$sl }} {{ $spl->employee_name_english }} {{ $spl->id_card_no }} {{ Carbon\Carbon::parse($spl->joining_date)->format('d-M-Y') }} {{ $spl->present_grade }} {{ $spl->recomanded_grade }} {{ $spl->floor }} {{ $spl->line ?? '' }}
    @foreach ($machine_type as $type)
  1. {{ $type->machine_type }}
    2. @endforeach
    @foreach ($data as $item)
  1. {{ ucwords($item->sewing_process_name) }}
    2. @endforeach
    @foreach ($data as $item)
  • {{ number_format($item->achive_production, 2) }}
    • @endforeach
    @foreach ($data as $item)
  • {{ number_format($item->efficiency, 2) }}
    • @endforeach