baoshi-was/app/Http/Controllers/UserDutyCheckController.php

<?php

namespace App\Http\Controllers;

use App\LaborCompany;
use App\LaborReport;
use App\User;
use App\UserDetail;
use App\UserDutyCheck;
use App\UserLabor;
use App\UserToken;
use App\UserWorkgroup;
use App\Warehouse;
use Carbon\Carbon;
use Endroid\QrCode\QrCode;
use Illuminate\Http\Request;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\Date;
use Illuminate\Support\Facades\Validator;
use Ramsey\Uuid\Uuid;

class UserDutyCheckController extends Controller
{
    //校验二维码进入打卡页面
    public function clock(Request $request){
        $userWorkgroupID=$request->input('userWorkgroupID');
        $qrCode_refresh_everyday=config('hr.qrCode_refresh_everyday');
        $qrCode_refresh=config('hr.qrCode_refresh');
        if ($qrCode_refresh_everyday){
            $key=$request->input('key');
            if (!$key) return view('exception.404',['error'=>'二维码失效！']);
            $date=md5(date('Y-m-d'));
            if ($key!=$date) return view('exception.404',['error'=>'二维码失效！']);
        }
        if ($qrCode_refresh){
            $time=strtotime(Cache::get('last_refresh_date'));
            $key=$request->input('key');
            if (!$key) return view('exception.404',['error'=>'二维码失效！']);
            $date=md5(date('Y-m-d H:i:s', strtotime('+30second',$time)));
            if ($key!=$date) return view('exception.404',['error'=>'二维码失效！']);
        }
        $userLaborToken=$request->cookie('userLaborToken');
        if ($userLaborToken && Cache::has('tokenStr_'.$userLaborToken)) {
            $user_id=Cache::get('tokenStr_'.$userLaborToken);
            $userDetail=UserDetail::find($user_id);
            if (!$userDetail)   return redirect('personnel/checking-in/userDutyCheck/createUserDetail/'.$userDetail->mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
            if ($userWorkgroupID){
                $user=UserToken::getUser($userLaborToken);
                $user->userWorkgroups()->sync([$userWorkgroupID]);
            }
            $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
            //正常情况
            $laborReport=LaborReport::where('user_workgroup_id',$userWorkgroupID)->where('created_at','like',Carbon::now()->format('Y-m-d')."%")->where('user_id',$userDetail->user_id)->first();
            if(!isset($laborReport)&&$userDutyCheck->type=='登入'){
                $this->createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck);
            }else if ($laborReport&&$userDutyCheck->type=='登出'){
                $this->updateLaborReportData($laborReport,$userDutyCheck);
            }
            if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
            if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常，请联系相关人员!</h1>";
            $userWorkgroups=$userDetail->user->userWorkgroups();
            if($userWorkgroups->count()>0)
                $group_name=$userDetail->user->userWorkgroups->first()['name'];
            $laravelEchoPrefix = config('database.redis.options.prefix');
            return response()->view('personnel/checking-in/success',['group_name'=>$group_name??'','full_name'=>$userDetail->full_name,'checked_at'=>$userDutyCheck->checked_at,'type'=>$userDutyCheck->type,'laravelEchoPrefix'=>$laravelEchoPrefix]);
        }
        return view("personnel/checking-in/clock",compact('userWorkgroupID'));
    }

    //提交打卡
    public function storeClock(Request $request){
        $mobile_phone=$request->input('mobile_phone');
        $userWorkgroupID=$request->input('userWorkgroupID');
        $this->validator($request)->validate();
        $userDetail=UserDetail::where('mobile_phone',$mobile_phone)->first();
        if (!$userDetail)   return redirect('personnel/checking-in/userDutyCheck/createUserDetail/'.$mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
        $user=User::find($userDetail->user_id);
        if (Cache::has('tokenUser_'.$user->id))return "<h1 style='color: red;text-align:center'>请使用原有设备进行打卡,如无法使用原有设备请联系管理人员解绑设备!</h1>";
        if ($userWorkgroupID)$user->userWorkgroups()->sync([$userWorkgroupID]);

        $userDutyCheckOld=UserDutyCheck::where('user_id',$userDetail->user_id)->orderBy('checked_at','DESC')->limit(10)->first();
        $date=date('Y-m-d H:i:s');
        $lastDate=Carbon::parse($userDutyCheckOld['checked_at']);
        $thisDate=Carbon::parse($date);
        $diffDate=$thisDate->diffInMinutes($lastDate);
        $dateNow=Carbon::now()->format('Y-m-d');
        //七天未登录从新选择劳务所
        if ($diffDate>7*1440){
            return redirect('personnel/checking-in/userDutyCheck/updateUserDetail/'.$mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
        }
        $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
        //正常情况
        $laborReport=LaborReport::where('user_workgroup_id',$userWorkgroupID)->where('created_at','like',$dateNow."%")->where('user_id',$userDetail->user_id)->first();
        if(!$laborReport&&$userDutyCheck->type=='登入'){
             $this->createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck);
        }else if ($laborReport&&$userDutyCheck->type=='登出'){
             $this->updateLaborReportData($laborReport,$userDutyCheck);
        }
        if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
        if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常，请联系相关人员!</h1>";
        $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
        $group_name=$userDetail->user->userWorkgroups->first()['name'];
        $laravelEchoPrefix = config('database.redis.options.prefix');
        return response()->view('personnel/checking-in/success',['group_name'=>$group_name??'','full_name'=>$userDetail->full_name,'checked_at'=>$userDutyCheck->checked_at,'type'=>$userDutyCheck->type,'laravelEchoPrefix'=>$laravelEchoPrefix])
            ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
    }
    //去往登记资料页面
    public function createUserDetail($mobile_phone){
        $userWorkgroupID=session("userWorkgroupID");
        $laborCompanies=LaborCompany::select('id','name')->get();
        return view('personnel/checking-in/createUserDetail',['mobile_phone'=>$mobile_phone,'userWorkgroupID'=>$userWorkgroupID,'laborCompanies'=>$laborCompanies]);
    }
    //七天未打卡去往选择劳务所页面
    public function updateUserDetail($mobile_phone){
        $userWorkgroupID=session("userWorkgroupID");
        $laborCompanies=LaborCompany::select('id','name')->get();
        return view('personnel/checking-in/updateUserDetail',['mobile_phone'=>$mobile_phone,'userWorkgroupID'=>$userWorkgroupID,'laborCompanies'=>$laborCompanies]);
    }
    //提交修改资料
    public  function storeUpdateUserDetail(Request $request){
        $this->validator($request)->validate();
        $mobile_phone=$request->input('mobile_phone');
        $userWorkgroupID=$request->input('userWorkgroupID');
        $user=User::where('name',$mobile_phone)->first();
        $userDetail=UserDetail::where('mobile_phone',$mobile_phone)->first();
        $labor_company_id=$request->input('labor_company_id');
        $userLabor=UserLabor::where('user_id',$userDetail->user_id)->first();
        $userLabor->update([
            'labor_company_id'=>$labor_company_id,
        ]);
        $this->log(__METHOD__,"更改临时工劳务所信息".__FUNCTION__,json_encode($userLabor),Auth::user()['id']);
        $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
        //添加临时工报表数据
        $this->createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck);
        if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
        if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常，请联系相关人员!</h1>";
        $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
        $this->log(__METHOD__,"录入临时工,用户,对应工作组,打卡记录".__FUNCTION__,json_encode($request->all()));
        $group_name=$userDetail->user->userWorkgroups->first()['name'];
        $laravelEchoPrefix = config('database.redis.options.prefix');
        return response()->view('personnel/checking-in/success',['group_name'=>$group_name??'','full_name'=>$userDetail->full_name,'checked_at'=>$userDutyCheck->checked_at,'type'=>$userDutyCheck->type,'laravelEchoPrefix'=>$laravelEchoPrefix])
            ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
    }
    //提交登记资料
    public  function storeUserDetail(Request $request){
        $this->validator($request)->validate();
        $mobile_phone=$request->input('mobile_phone');
        $full_name=$request->input('full_name');
        $identity_number=$request->input('identity_number');
        $userWorkgroupID=$request->input('userWorkgroupID');
        $user=new User([
            'name'=>$mobile_phone,
            'password'=>Uuid::uuid1(),
        ]);
        $user->save();
        $this->log(__METHOD__,"创建临时工用户__".__FUNCTION__,json_encode($user));
        if ($userWorkgroupID)$user->userWorkgroups()->sync([$userWorkgroupID]);
        $userDetail=new UserDetail([
            'user_id'=>$user->id,
            'full_name'=>$full_name,
            'identity_number'=>$identity_number,
            'gender'=>$request->input('gender'),
            'mobile_phone'=>$mobile_phone,
            'type'=>'临时工',
        ]);
        $userDetail->save();
        $this->log(__METHOD__,"提交临时工信息__".__FUNCTION__,json_encode($userDetail));
        $labor_company_id=$request->input('labor_company_id');
        $userLabor=new UserLabor([
            'user_id'=>$user->id,
            'labor_company_id'=>$labor_company_id,
        ]);
        $userLabor->save();
        $this->log(__METHOD__,"提交临时工对应劳务所信息__".__FUNCTION__,json_encode($userLabor));
        $userDutyCheck=$this->dutyCheck($user->id,$userWorkgroupID);
        $this->createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck);
        if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
        if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常，请联系相关人员!</h1>";
        $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
        $this->log(__METHOD__,"录入临时工,用户,对应工作组,打卡记录".__FUNCTION__,json_encode($request->all()));
        $group_name=$userDetail->user->userWorkgroups->first()['name'];
        $laravelEchoPrefix = config('database.redis.options.prefix');
        return response()->view('personnel/checking-in/success',['group_name'=>$group_name??'','full_name'=>$userDetail->full_name,'checked_at'=>$userDutyCheck->checked_at,'type'=>$userDutyCheck->type,'laravelEchoPrefix'=>$laravelEchoPrefix])
            ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
    }

    //根据用户提交打卡记录
    public function dutyCheck($user_id,$workgroup_id){
        $userDutyCheckOld=UserDutyCheck::where('user_id',$user_id)->orderBy('checked_at','DESC')->limit(10)->first();
        $date=date('Y-m-d H:i:s');
        $userDutyCheck=new UserDutyCheck([
            'user_id'=>$user_id,
            'checked_at'=>$date,
            'source'=>'正常',
            'verify_user_id'=>'',
            'workgroup_id'=>$workgroup_id,
        ]);
        if (!$userDutyCheckOld){
            $userDutyCheck->type="登入";
            $userDutyCheck->save();
            $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
            return $userDutyCheck;
        }
        $lastDate=Carbon::parse($userDutyCheckOld->checked_at);
        $thisDate=Carbon::parse($date);
        $diffDate=$thisDate->diffInMinutes($lastDate);
        if ($userDutyCheckOld->type=="登出"&&$diffDate<7*1440){
            $userDutyCheck->type="登入";
            $userDutyCheck->verify_user_id=0;
            $userDutyCheck->save();
            $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
            return $userDutyCheck;
        }
        if($diffDate<=5){
            $userDutyCheck->error=true;
            return $userDutyCheck;
        }
        if ($userDutyCheckOld->type=="登入"){
            switch ($diffDate){
                case $diffDate<=20:
                    $userDutyCheck->type="登入";
                    break;
                case $diffDate>=1380:
                    $userDutyCheck->type="登入";
                    break;
                default:
                    $userDutyCheck->type="登出";
            }
        }
        if ($userDutyCheckOld->type=="登出"){
            switch ($diffDate){
                case $diffDate<=20:
                    $userDutyCheck->type="登出";
                    break;
                default:
                    $userDutyCheck->type="登入";
            }
        }
        $userDutyCheck->save();
        $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
        return $userDutyCheck;
    }
    //添加临时工报表数据
    public function createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck){
        $user_id=$userDetail['user_id'];
        $name=$userDetail['full_name'];
        $mobile_phone=$userDetail['mobile_phone'];
        $identity_number=$userDetail['identity_number'];
        $labor_company_id=UserLabor::where('user_id',$user_id)->value('labor_company_id');
        $labor_company=LaborCompany::where('id',$labor_company_id)->value('name');
        if ($userDutyCheck->type=='登入'){
            $check_in_at=$userDutyCheck['checked_at'];
        }
        $laborReport=new LaborReport([
            'enter_number'=>Uuid::uuid1(),
            'user_workgroup_id'=>$userWorkgroupID,
            'user_id'=>$user_id,
            'name'=>$name,
            'mobile_phone'=>$mobile_phone,
            'identity_number'=>$identity_number,
            'labor_company'=>$labor_company,
            'check_in_at'=>$check_in_at,
        ]);
        $laborReport->save();
        $number_id=$laborReport->id;
        $enter_number=$userWorkgroupID.date ("ymd").str_pad($number_id>99999?$number_id%99999:$number_id,4,"0",STR_PAD_LEFT);
        $laborReport->enter_number=$enter_number;
        $laborReport->update();
        $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
        return;
    }
    //修改临时工报表数据
    public function updateLaborReportData($laborReport,$userDutyCheck){
        $check_in_at=$laborReport['check_in_at'];
        $laborReport->check_out_at=$userDutyCheck->checked_at;
        $checkInDate=Carbon::parse($check_in_at);
        $checkOutDate=Carbon::parse($userDutyCheck->checked_at);
        $hour=($checkOutDate->diffInSeconds($checkInDate))/3600; //在线时长
        $laborReport['online_duration']=$hour;
        $laborReport['working_duration']=$hour;
        $laborReport->update();
        $date=Carbon::parse($laborReport->check_in_at)->format('Y-m-d');
        if ($userDutyCheck->checked_at>$date." 14:00:00"){
            $userDutyCheckStart=UserDutyCheck::where('user_id',$laborReport->user_id)->where('workgroup_id',$laborReport->user_workgroup_id)->where('checked_at','>=',$date." 11:00".":00")
                ->where('checked_at','<=',$date." 14:00:00")->where('type','登出')->first();
            $userDutyCheckEnd=UserDutyCheck::where('user_id',$laborReport->user_id)->where('workgroup_id',$laborReport->user_workgroup_id)->where('checked_at','>=',$date." 11:00".":00")
                ->where('checked_at','<=',$date." 14:00:00")->where('type','登入')->first();
            $beginTime=Carbon::parse($userDutyCheckStart['checked_at']);
            $endTime=Carbon::parse($userDutyCheckEnd['checked_at']);
            $lunchHour=($endTime->diffInSeconds($beginTime))/3600;
            $laborReport['working_duration']=$hour-$lunchHour;
            $laborReport->update();
        }
        $this->log(__METHOD__,__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
        return;
    }

    public function validator(Request $request){
        $validator=Validator::make($request->input(),[
            'full_name'=>['filled'],
            'gender'=>['filled'],
            'mobile_phone'=>['required','integer','digits:11'],
            'identity_number' => ['filled','identity_cards','unique:user_details,identity_number'],
        ],[
            'unique'=>':attribute 已经存在，不能重复！',
            'filled' => ':attribute 不能为空',
            'required'=>':attribute 为必填项',
            'integer'=>':attribute 数字类型',
            'digits'=>':attribute 必须是11位',
        ],[
            'full_name'=>'姓名',
            'gender'=>'性别',
            'mobile_phone'=>'手机号',
            'identity_number' => '身份证号',
        ]);
        return $validator;
    }
}