UserDutyCheckController.php 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\LaborCompany;
  4. use App\LaborReport;
  5. use App\User;
  6. use App\UserDetail;
  7. use App\UserDutyCheck;
  8. use App\UserLabor;
  9. use App\UserToken;
  10. use App\UserWorkgroup;
  11. use App\Warehouse;
  12. use Carbon\Carbon;
  13. use Endroid\QrCode\QrCode;
  14. use Illuminate\Http\Request;
  15. use Illuminate\Http\Response;
  16. use Illuminate\Support\Facades\Auth;
  17. use Illuminate\Support\Facades\Cache;
  18. use Illuminate\Support\Facades\Date;
  19. use Illuminate\Support\Facades\Validator;
  20. use Ramsey\Uuid\Uuid;
  21. class UserDutyCheckController extends Controller
  22. {
  23. //校验二维码进入打卡页面
  24. public function clock(Request $request){
  25. $userWorkgroupID=$request->input('userWorkgroupID');
  26. $qrCode_refresh_everyday=config('hr.qrCode_refresh_everyday');
  27. $qrCode_refresh=config('hr.qrCode_refresh');
  28. if ($qrCode_refresh_everyday){
  29. $key=$request->input('key');
  30. if (!$key) return view('exception.404',['error'=>'二维码失效!']);
  31. $date=md5(date('Y-m-d'));
  32. if ($key!=$date) return view('exception.404',['error'=>'二维码失效!']);
  33. }
  34. if ($qrCode_refresh){
  35. $time=strtotime(Cache::get('last_refresh_date'));
  36. $key=$request->input('key');
  37. if (!$key) return view('exception.404',['error'=>'二维码失效!']);
  38. $date=md5(date('Y-m-d H:i:s', strtotime('+30second',$time)));
  39. if ($key!=$date) return view('exception.404',['error'=>'二维码失效!']);
  40. }
  41. $userLaborToken=$request->cookie('userLaborToken');
  42. if ($userLaborToken && Cache::has('tokenStr_'.$userLaborToken)) {
  43. $user_id=Cache::get('tokenStr_'.$userLaborToken);
  44. $userDetail=UserDetail::find($user_id);
  45. if (!$userDetail) return redirect('personnel/checking-in/userDutyCheck/createUserDetail/'.$userDetail->mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
  46. $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
  47. //正常情况
  48. $laborReport=LaborReport::where('user_workgroup_id',$userWorkgroupID)->where('created_at','like',Carbon::now()->format('Y-m-d')."%")->where('user_id',$userDetail->user_id)->first();
  49. if(!isset($laborReport)&&$userDutyCheck->type=='登入'){
  50. $laborReport=LaborReport::createLaborReportData($userDetail->user_id,$userWorkgroupID,$userDutyCheck);
  51. $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  52. }else if ($laborReport&&$userDutyCheck->type=='登出'){
  53. $laborReport= LaborReport::updateLaborReportData($laborReport,$userDutyCheck);
  54. $this->log(__METHOD__,"更新临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  55. }
  56. if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
  57. if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常,请联系相关人员!</h1>";
  58. $userWorkgroups=$userDetail->user->userWorkgroups();
  59. if($userWorkgroups->count()>0)
  60. $group_name=$userDetail->user->userWorkgroups->first()['name'];
  61. $laravelEchoPrefix = config('database.redis.options.prefix');
  62. 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]);
  63. }
  64. return view("personnel/checking-in/clock",compact('userWorkgroupID'));
  65. }
  66. //提交打卡
  67. public function storeClock(Request $request){
  68. $mobile_phone=$request->input('mobile_phone');
  69. $userWorkgroupID=$request->input('userWorkgroupID');
  70. $this->validator($request)->validate();
  71. $userDetail=UserDetail::where('mobile_phone',$mobile_phone)->first();
  72. if (!$userDetail) return redirect('personnel/checking-in/userDutyCheck/createUserDetail/'.$mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
  73. $user=User::find($userDetail->user_id);
  74. if (Cache::has('tokenUser_'.$user->id))return "<h1 style='color: red;text-align:center'>请使用原有设备进行打卡,如无法使用原有设备请联系管理人员解绑设备!</h1>";
  75. //if ($userWorkgroupID)$user->userWorkgroups()->sync([$userWorkgroupID]);
  76. $userDutyCheckOld=UserDutyCheck::where('user_id',$userDetail->user_id)->orderBy('checked_at','DESC')->limit(10)->first();
  77. $date=date('Y-m-d H:i:s');
  78. $lastDate=Carbon::parse($userDutyCheckOld['checked_at']);
  79. $thisDate=Carbon::parse($date);
  80. $diffDate=$thisDate->diffInMinutes($lastDate);
  81. $dateNow=Carbon::now()->format('Y-m-d');
  82. //七天未登录从新选择劳务所
  83. if ($diffDate>7*1440){
  84. return redirect('personnel/checking-in/userDutyCheck/updateUserDetail/'.$mobile_phone)->with("userWorkgroupID",$userWorkgroupID);
  85. }
  86. $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
  87. //正常情况
  88. $laborReport=LaborReport::where('user_workgroup_id',$userWorkgroupID)->where('created_at','like',$dateNow."%")->where('user_id',$userDetail->user_id)->first();
  89. if(!$laborReport&&$userDutyCheck->type=='登入'){
  90. $laborReport=LaborReport::createLaborReportData($userDetail->user_id,$userWorkgroupID,$userDutyCheck);
  91. $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  92. }else if ($laborReport&&$userDutyCheck->type=='登出'){
  93. $laborReport=LaborReport::updateLaborReportData($laborReport,$userDutyCheck);
  94. $this->log(__METHOD__,"更新临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  95. }
  96. if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
  97. if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常,请联系相关人员!</h1>";
  98. $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
  99. $group_name=$userDetail->user->userWorkgroups->first()['name'];
  100. $laravelEchoPrefix = config('database.redis.options.prefix');
  101. 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])
  102. ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
  103. }
  104. //去往登记资料页面
  105. public function createUserDetail($mobile_phone){
  106. $userWorkgroupID=session("userWorkgroupID");
  107. $laborCompanies=LaborCompany::select('id','name')->get();
  108. return view('personnel/checking-in/createUserDetail',['mobile_phone'=>$mobile_phone,'userWorkgroupID'=>$userWorkgroupID,'laborCompanies'=>$laborCompanies]);
  109. }
  110. //七天未打卡去往选择劳务所页面
  111. public function updateUserDetail($mobile_phone){
  112. $userWorkgroupID=session("userWorkgroupID");
  113. $laborCompanies=LaborCompany::select('id','name')->get();
  114. return view('personnel/checking-in/updateUserDetail',['mobile_phone'=>$mobile_phone,'userWorkgroupID'=>$userWorkgroupID,'laborCompanies'=>$laborCompanies]);
  115. }
  116. //提交修改资料
  117. public function storeUpdateUserDetail(Request $request){
  118. $this->validator($request)->validate();
  119. $mobile_phone=$request->input('mobile_phone');
  120. $userWorkgroupID=$request->input('userWorkgroupID');
  121. $userDetail=UserDetail::where('mobile_phone',$mobile_phone)->first();
  122. if (!$userDetail)return view('exception.404',['error'=>'临时工信息不存在!']);
  123. $labor_company_id=$request->input('labor_company_id');
  124. $userLabor=UserLabor::where('user_id',$userDetail->user_id)->first();
  125. $userLabor->update([
  126. 'labor_company_id'=>$labor_company_id,
  127. ]);
  128. $this->log(__METHOD__,"更改临时工劳务所信息".__FUNCTION__,json_encode($userLabor),Auth::user()['id']);
  129. $userDutyCheck=$this->dutyCheck($userDetail->user_id,$userWorkgroupID);
  130. //添加临时工报表数据
  131. $laborReport=LaborReport::createLaborReportData($userDetail->user_id,$userWorkgroupID,$userDutyCheck);
  132. $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  133. if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
  134. if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常,请联系相关人员!</h1>";
  135. $user=User::find($userDetail->user_id);
  136. $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
  137. $this->log(__METHOD__,"录入临时工,用户,对应工作组,打卡记录".__FUNCTION__,json_encode($request->all()));
  138. $group_name=$userDetail->user->userWorkgroups->first()['name'];
  139. $laravelEchoPrefix = config('database.redis.options.prefix');
  140. 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])
  141. ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
  142. }
  143. //提交登记资料
  144. public function storeUserDetail(Request $request){
  145. $this->validator($request)->validate();
  146. $mobile_phone=$request->input('mobile_phone');
  147. $full_name=$request->input('full_name');
  148. $identity_number=$request->input('identity_number');
  149. $userWorkgroupID=$request->input('userWorkgroupID');
  150. $user=new User([
  151. 'name'=>$mobile_phone,
  152. 'password'=>Uuid::uuid1(),
  153. ]);
  154. $user->save();
  155. $this->log(__METHOD__,"创建临时工用户__".__FUNCTION__,json_encode($user));
  156. //if ($userWorkgroupID)$user->userWorkgroups()->sync([$userWorkgroupID]);
  157. $userDetail=new UserDetail([
  158. 'user_id'=>$user->id,
  159. 'full_name'=>$full_name,
  160. 'identity_number'=>$identity_number,
  161. 'gender'=>$request->input('gender'),
  162. 'mobile_phone'=>$mobile_phone,
  163. 'type'=>'临时工',
  164. ]);
  165. $userDetail->save();
  166. $this->log(__METHOD__,"提交临时工信息__".__FUNCTION__,json_encode($userDetail));
  167. $labor_company_id=$request->input('labor_company_id');
  168. $userLabor=new UserLabor([
  169. 'user_id'=>$user->id,
  170. 'labor_company_id'=>$labor_company_id,
  171. ]);
  172. $userLabor->save();
  173. $this->log(__METHOD__,"提交临时工对应劳务所信息__".__FUNCTION__,json_encode($userLabor));
  174. $userDutyCheck=$this->dutyCheck($user->id,$userWorkgroupID);
  175. $laborReport=LaborReport::createLaborReportData($user->id,$userWorkgroupID,$userDutyCheck);
  176. $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  177. if ($userDutyCheck&&$userDutyCheck->error)return "<h1 style='color: darkred;text-align:center'>重复打卡!</h1>";
  178. if (!$userDutyCheck)return "<h1 style='color: red;text-align:center'>打卡异常,请联系相关人员!</h1>";
  179. $userLaborToken=$user->token(config('users.token_check_in_expire_minutes'));
  180. $this->log(__METHOD__,"录入临时工,用户,对应工作组,打卡记录".__FUNCTION__,json_encode($request->all()));
  181. $group_name=$userDetail->user->userWorkgroups->first()['name'];
  182. $laravelEchoPrefix = config('database.redis.options.prefix');
  183. 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])
  184. ->cookie('userLaborToken',$userLaborToken,config('users.token_check_in_expire_minutes'),'/');
  185. }
  186. //根据用户提交打卡记录
  187. public function dutyCheck($user_id,$userWorkgroupID){
  188. $userDutyCheckOld=UserDutyCheck::where('user_id',$user_id)->orderBy('checked_at','DESC')->limit(10)->first();
  189. if ($userWorkgroupID!=$userDutyCheckOld['workgroup_id']){
  190. $user=User::find($user_id);
  191. $user->userWorkgroups()->sync([$userWorkgroupID]);
  192. }
  193. $date=date('Y-m-d H:i:s');
  194. $userDutyCheck=new UserDutyCheck([
  195. 'user_id'=>$user_id,
  196. 'checked_at'=>$date,
  197. 'source'=>'正常',
  198. 'verify_user_id'=>'',
  199. 'workgroup_id'=>$userWorkgroupID,
  200. ]);
  201. if (!$userDutyCheckOld){
  202. $userDutyCheck->type="登入";
  203. $userDutyCheck->save();
  204. $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
  205. return $userDutyCheck;
  206. }
  207. $lastDate=Carbon::parse($userDutyCheckOld->checked_at);
  208. $thisDate=Carbon::parse($date);
  209. $diffDate=$thisDate->diffInMinutes($lastDate);
  210. if ($userDutyCheckOld->type=="登出"&&$diffDate<7*1440){
  211. $userDutyCheck->type="登入";
  212. $userDutyCheck->verify_user_id=0;
  213. $userDutyCheck->save();
  214. $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
  215. return $userDutyCheck;
  216. }
  217. if($diffDate<=5){
  218. $userDutyCheck->error=true;
  219. return $userDutyCheck;
  220. }
  221. if ($userDutyCheckOld->type=="登入"){
  222. switch ($diffDate){
  223. case $diffDate<=20:
  224. $userDutyCheck->type="登入";
  225. break;
  226. case $diffDate>=1380:
  227. $userDutyCheck->type="登入";
  228. break;
  229. default:
  230. $userDutyCheck->type="登出";
  231. }
  232. }
  233. if ($userDutyCheckOld->type=="登出"){
  234. switch ($diffDate){
  235. case $diffDate<=20:
  236. $userDutyCheck->type="登出";
  237. break;
  238. default:
  239. $userDutyCheck->type="登入";
  240. }
  241. }
  242. $userDutyCheck->save();
  243. $this->log(__METHOD__,"提交打卡记录__".__FUNCTION__,json_encode($userDutyCheck));
  244. return $userDutyCheck;
  245. }
  246. // //添加临时工报表数据
  247. // public function createLaborReportData($userDetail,$userWorkgroupID,$userDutyCheck){
  248. // $user_id=$userDetail['user_id'];
  249. // $name=$userDetail['full_name'];
  250. // $mobile_phone=$userDetail['mobile_phone'];
  251. // $identity_number=$userDetail['identity_number'];
  252. // $labor_company_id=UserLabor::where('user_id',$user_id)->value('labor_company_id');
  253. // $labor_company=LaborCompany::where('id',$labor_company_id)->value('name');
  254. // if ($userDutyCheck->type=='登入'){
  255. // $check_in_at=$userDutyCheck['checked_at'];
  256. // }
  257. // $laborReport=new LaborReport([
  258. // 'enter_number'=>Uuid::uuid1(),
  259. // 'user_workgroup_id'=>$userWorkgroupID,
  260. // 'user_id'=>$user_id,
  261. // 'name'=>$name,
  262. // 'mobile_phone'=>$mobile_phone,
  263. // 'identity_number'=>$identity_number,
  264. // 'labor_company'=>$labor_company,
  265. // 'check_in_at'=>$check_in_at,
  266. // ]);
  267. // $laborReport->save();
  268. // $number_id=$laborReport->id;
  269. // $enter_number=$userWorkgroupID.date ("ymd").str_pad($number_id>99999?$number_id%99999:$number_id,4,"0",STR_PAD_LEFT);
  270. // $laborReport->enter_number=$enter_number;
  271. // $laborReport->update();
  272. // $this->log(__METHOD__,"提交临时工报表记录__".__FUNCTION__,json_encode($laborReport));
  273. // return;
  274. // }
  275. // //修改临时工报表数据
  276. // public function updateLaborReportData($laborReport,$userDutyCheck){
  277. // $laborReport->check_out_at=$userDutyCheck->checked_at;
  278. // $checkInDate=Carbon::parse($laborReport['check_in_at']);
  279. // $checkOutDate=Carbon::parse($userDutyCheck->checked_at);
  280. // $hour=($checkOutDate->diffInSeconds($checkInDate))/3600; //在线时长
  281. // $laborReport['online_duration']=$hour;
  282. // $laborReport['working_duration']=$hour;
  283. // $laborReport->update();
  284. // $date=Carbon::parse($laborReport['check_in_at'])->format('Y-m-d');
  285. // if ($laborReport->check_out_at>$date." 14:00:00"){
  286. // $userDutyCheckStart=UserDutyCheck::where('user_id',$laborReport->user_id)->where('workgroup_id',$laborReport->user_workgroup_id)->where('checked_at','>=',$date." 11:00".":00")
  287. // ->where('checked_at','<=',$date." 14:00:00")->where('type','登出')->first();
  288. // $userDutyCheckEnd=UserDutyCheck::where('user_id',$laborReport->user_id)->where('workgroup_id',$laborReport->user_workgroup_id)->where('checked_at','>=',$date." 11:00".":00")
  289. // ->where('checked_at','<=',$date." 14:00:00")->where('type','登入')->first();
  290. // $beginTime=Carbon::parse($userDutyCheckStart['checked_at']);
  291. // $endTime=Carbon::parse($userDutyCheckEnd['checked_at']);
  292. // $lunchHour=($endTime->diffInSeconds($beginTime))/3600;
  293. // $laborReport['working_duration']=$hour-$lunchHour;
  294. // $laborReport->update();
  295. // }
  296. // $this->log(__METHOD__,__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
  297. // return;
  298. // }
  299. public function validator(Request $request){
  300. $validator=Validator::make($request->input(),[
  301. 'full_name'=>['filled'],
  302. 'gender'=>['filled'],
  303. 'mobile_phone'=>['required','integer','digits:11'],
  304. 'identity_number' => ['filled','identity_cards','unique:user_details,identity_number'],
  305. ],[
  306. 'unique'=>':attribute 已经存在,不能重复!',
  307. 'filled' => ':attribute 不能为空',
  308. 'required'=>':attribute 为必填项',
  309. 'integer'=>':attribute 数字类型',
  310. 'digits'=>':attribute 必须是11位',
  311. ],[
  312. 'full_name'=>'姓名',
  313. 'gender'=>'性别',
  314. 'mobile_phone'=>'手机号',
  315. 'identity_number' => '身份证号',
  316. ]);
  317. return $validator;
  318. }
  319. }