baoshi-was/app/LaborReport.php

<?php

namespace App;

use Carbon\Carbon;
use Illuminate\Database\Eloquent\Model;
use App\Traits\ModelTimeFormat;
use Illuminate\Support\Facades\Auth;
use Ramsey\Uuid\Uuid;

class LaborReport extends Model
{
    use ModelTimeFormat;

    protected $fillable=[
        'id','enter_number','user_workgroup_id','user_id','name','mobile_phone','identity_number','labor_company','check_in_at','verify_at','check_out_at','online_duration','working_duration'
    ];

    public function userWorkgroup(){
        return $this->belongsTo('App\UserWorkgroup','user_workgroup_id','id');
    }
    public function user(){
        return $this->belongsTo('App\User','group_user_id','id');
    }

    //添加临时工报表数据
    static function createLaborReportData($user_id,$userWorkgroupID,$userDutyCheck){
        $userDetail=UserDetail::find($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;
    }
    //修改临时工报表数据
    static function updateLaborReportData($laborReport,$userDutyCheck){
        $laborReport->check_out_at=$userDutyCheck->checked_at;
        $checkInDate=Carbon::parse($laborReport['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 ($laborReport->check_out_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;
    }
}