<x-app-layout>
@include('set_tenant_db')

@php
$employees = Illuminate\Support\Facades\DB::table('employee')->select('empl_cd', 'pan', 'b_date', 'name', 'locn_cd', 'email')->get();

foreach ($employees as $emp) {
    if (empty($emp->pan) || empty($emp->b_date)) {
        continue;
    }

    [$yyyy, $mm, $dd] = explode('-', $emp->b_date);
    $formattedDate = $dd . $mm . $yyyy;
    $tempPassword = strtolower($emp->pan . $formattedDate);
    $hashedPassword = Illuminate\Support\Facades\Hash::make($tempPassword);

    $existingUser = Illuminate\Support\Facades\DB::table('sysusr')->where('userid', $emp->empl_cd)->first();

    if ($existingUser) {
        Illuminate\Support\Facades\DB::table('sysusr')->where('userid', $emp->empl_cd)->update([
            'ori_password' =>$tempPassword,
            'password' => $hashedPassword,
        ]);
    } else {
        Illuminate\Support\Facades\DB::table('sysusr')->insert([
            'userid'   => $emp->empl_cd,
            'ori_password' =>$tempPassword,
            'password' => $hashedPassword,
            'profile'  => '1',
            'username' => $emp->name,
            'proloc'   => $emp->locn_cd,
            'email'    => $emp->email,
        ]);
    }
}
@endphp
</x-app-layout>