Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 2
 CRAP
0.00% covered (danger)
0.00%
0 / 15
ChangeBiometricId
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 2
 42
0.00% covered (danger)
0.00%
0 / 15
 __construct
0.00% covered (danger)
0.00%
0 / 1
 2
0.00% covered (danger)
0.00%
0 / 2
 handle
0.00% covered (danger)
0.00%
0 / 1
 30
0.00% covered (danger)
0.00%
0 / 13
<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use App\Models\Dashboard\AttendanceDetail;
use App\Models\Auth\User;
use App\Models\Admin\UserDetail;
use App\Models\AttendanceRequests\UserAttendanceRequests;
class ChangeBiometricId extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'change:biometricid';
    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Change biometric id to user id';
    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }
    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        
        $attendanceDetails = AttendanceDetail::all();
        foreach($attendanceDetails as $attendanceDetail){
            $userBiometricId = $attendanceDetail->user_id;
            $userDetail = UserDetail::where('biometric_id',$userBiometricId)->first();
            if(!empty($userDetail)){
               // $attendance = AttendanceDetail::where('id',$attendanceDetail->id)->first();
           
                $attendanceDetail->update(['user_id' => $userDetail->user_id]);
            }
            
            
        }
        $userAttendanceRequests = UserAttendanceRequests::all();
        foreach($userAttendanceRequests as $userAttendanceRequest){
            $userBiometricId = $userAttendanceRequest->user_id;
            $userDetail = UserDetail::where('biometric_id',$userBiometricId)->first();
            if(!empty($userDetail)){
               // $attendance = AttendanceDetail::where('id',$attendanceDetail->id)->first();
           
                $userAttendanceRequest->update(['user_id' => $userDetail->user_id]);
            }
            
            
        }
    }
}