LaborReportController.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Events\ClockoutEvent;
  4. use App\Events\GuardAuditEvent;
  5. use App\Events\TeamAuditEvent;
  6. use App\Exports\Export;
  7. use App\LaborCompany;
  8. use App\LaborReport;
  9. use App\LaborReportStatus;
  10. use App\Services\LaborReportService;
  11. use App\UserDutyCheck;
  12. use App\UserWorkgroup;
  13. use Carbon\Carbon;
  14. use Exception;
  15. use Illuminate\Http\Request;
  16. use Illuminate\Support\Facades\Auth;
  17. use Illuminate\Support\Facades\Gate;
  18. use Illuminate\Support\Facades\Http;
  19. use Maatwebsite\Excel\Facades\Excel;
  20. class LaborReportController extends Controller
  21. {
  22. public function __construct()
  23. {
  24. app()->singleton('laborReportService',LaborReportService::class);
  25. }
  26. /**
  27. * Display a listing of the resource.
  28. * @param Request $request
  29. * @return void
  30. * 临时工报表
  31. */
  32. public function index(Request $request)
  33. {
  34. if(!Gate::allows('人事管理-临时工报表')){ view('personnel/index'); }
  35. $paginateParams=$request->input();
  36. $user=Auth::user();
  37. if (!$user)return redirect('/');
  38. $laravelEchoPrefix = config('database.redis.options.prefix');
  39. $tokenOfBroadcastEnterAndLeave='';
  40. if(Gate::allows('人事管理-临时工报表-可见全部组')||Gate::allows('人事管理-门卫审核')){
  41. $tokenOfBroadcastEnterAndLeave=LaborReport::tokenOfBroadcastEnterAndLeave();
  42. }
  43. $userWorkgroupIds=$user->getPermittingWorkgroupIds(Gate::allows('人事管理-临时工报表-可见全部组'));
  44. $permittingWorkgroups=UserWorkgroup::whereIn('id',$userWorkgroupIds)->get();
  45. if($permittingWorkgroups->isEmpty())$permittingWorkgroups="[]";
  46. $laborReports=app('laborReportService')->paginate($request->input());
  47. foreach ($laborReports as $laborReport){
  48. if (!$laborReport->group_user_id){
  49. //2小时之内组长未审核实行软删除
  50. $tenMinutesLater=Carbon::parse($laborReport->created_at)->subHours(-2)->format('Y-m-d H:i:s');
  51. if (Carbon::now()->format('Y-m-d H:i:s')>$tenMinutesLater){
  52. $laborReport->delete();
  53. $this->log(__METHOD__,"组长未审核该条记录将在10分钟后实行软删除__".__FUNCTION__,$laborReport->toJson(),Auth::user()['id']);
  54. }
  55. }
  56. $addOneHourCheckedAt=Carbon::parse($laborReport->userDutyCheck['checked_at'])->subHours(-1)->format('Y-m-d H:i:s');
  57. if (!$laborReport->userDutyCheck['verify_user_id']&&Carbon::now()->format('Y-m-d H:i:s')>$addOneHourCheckedAt){
  58. $laborReport->delete();
  59. $this->log(__METHOD__,"进场门卫未审核该条记录将在一小时后实行软删除__".__FUNCTION__,$laborReport->toJson(),Auth::user()['id']);
  60. }
  61. }
  62. $laborCompanies=LaborCompany::query()->get();
  63. $userWorkGroups=UserWorkgroup::query()->select('id','name')->get();
  64. return view('personnel/laborReport/index',compact('laborReports','userWorkGroups','laborCompanies','laravelEchoPrefix','permittingWorkgroups','paginateParams','tokenOfBroadcastEnterAndLeave'));
  65. }
  66. public function export(Request $request){
  67. if (!Gate::allows('人事管理-临时工报表')){return redirect(url('/')); }
  68. if ($request->checkAllSign){
  69. $params = $request->input();
  70. unset($params["checkAllSign"]);
  71. $laborReports=app('laborReportService')->get($params);
  72. }else{
  73. $laborReports=app('laborReportService')->get(["id"=>$request->data]);
  74. }
  75. $data = [];
  76. foreach ($laborReports as $laborReport){
  77. $row = [
  78. "enter_number" => $laborReport->enter_number,
  79. "user_workgroup_name" => $laborReport->userWorkgroup ? $laborReport->userWorkgroup->name : null,
  80. "name" => $laborReport->name,
  81. "mobile_phone" => $laborReport->mobile_phone,
  82. "identity_number" => $laborReport->identity_number,
  83. "labor_company" => $laborReport->laborCompany ? $laborReport->laborCompany->name : null,
  84. "enter_at" => $laborReport->enter_at,
  85. "check_in_at" => $laborReport->check_in_at,
  86. "check_out_at" => $laborReport->check_out_at,
  87. "round_check_in_at" => $laborReport->round_check_in_at,
  88. "round_check_out_at" => $laborReport->round_check_out_at,
  89. "exit_at" => $laborReport->exit_at,
  90. "verify_at" => $laborReport->verify_at,
  91. "group_user_id" => $laborReport->user ? $laborReport->user->name : null,
  92. "relax_time" => (string)$laborReport->relax_time,
  93. "online_duration" => $laborReport->online_duration,
  94. "working_duration" => $laborReport->working_duration,
  95. "remark" => $laborReport->remark,
  96. ];
  97. $data[] = $row;
  98. }
  99. $post = Http::post(config('go.export.url'),['type'=>'laborReport','data'=>json_encode($data,JSON_UNESCAPED_UNICODE)]);
  100. if ($post->status() == 500){
  101. throw new Exception($post->header("Msg"));
  102. }
  103. return response($post,200, [
  104. "Content-type"=>"application/octet-stream",
  105. "Content-Disposition"=>"attachment; filename=临时工报表记录-".date('ymdHis').'.xlsx',
  106. ]);
  107. }
  108. //门卫打卡审核
  109. public function guardClockAudit(Request $request){
  110. if(!Gate::allows('人事管理-门卫审核')){ return ["success"=>false,"data"=>"您无此权限操作!!!"]; }
  111. $id=$request->input('id');
  112. $userDutyCheckId=$request->input('user_duty_check_id');
  113. $laborReportStatus=new LaborReportStatus([
  114. 'labor_report_id'=>$id,
  115. 'status'=>'已入场',
  116. ]);
  117. $laborReportStatus->save();
  118. $this->log(__METHOD__,"门卫打卡审核创建当前临时工报表状态".__FUNCTION__,json_encode($laborReportStatus),Auth::user()['id']);
  119. $userDutyCheck=UserDutyCheck::find($userDutyCheckId);
  120. $userDutyCheck->verify_user_id=Auth::user()['id'];
  121. $userDutyCheck->update();
  122. event(new GuardAuditEvent($userDutyCheck));
  123. $this->log(__METHOD__,"门卫打卡审核".__FUNCTION__,json_encode($userDutyCheck),Auth::user()['id']);
  124. return ["success"=>true,"data"=>$userDutyCheck->verify_user_id];
  125. }
  126. //打卡组长审核
  127. public function groupClockAudit(Request $request){
  128. if(!Gate::allows('人事管理-组长审核')){ return ["success"=>false,"data"=>"您无此权限操作!"]; }
  129. $id=$request->input('id');
  130. $laborReport=LaborReport::find($id);
  131. $laborReport->group_user_id=Auth::user()['id'];
  132. $laborReport->verify_at=date('Y-m-d H:i:s');
  133. $laborReport->update();
  134. $laborReport->verifyPerson=Auth::user()['name'];
  135. $this->log(__METHOD__,"打卡组长审核".__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
  136. event(new TeamAuditEvent($laborReport));
  137. return ["success"=>true,"data"=>$laborReport];
  138. }
  139. //打卡组长审核(特定组添加备注)
  140. public function addRemarkAndGroupClock(Request $request){
  141. if(!Gate::allows('人事管理-组长审核')){ return ["success"=>false,"data"=>"您无此权限操作!"]; }
  142. $id=$request->input('id');
  143. $remark=$request->input('remark');
  144. if(!$remark){ return ["success"=>false,"data"=>"您还未添加任何备注,请返回添加备注!"]; }
  145. $laborReport=LaborReport::find($id);
  146. $laborReport->group_user_id=Auth::user()['id'];
  147. $laborReport->verify_at=date('Y-m-d H:i:s');
  148. $laborReport->update();
  149. $laborReport->setRemarkAttribute($remark,$id);
  150. $laborReport->verifyPerson=Auth::user()['name'];
  151. $this->log(__METHOD__,"打卡组长审核并添加相应备注".__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
  152. event(new TeamAuditEvent($laborReport));
  153. return ["success"=>true,"data"=>$laborReport];
  154. }
  155. //组长点击退组
  156. public function groupExport(Request $request){
  157. if(!Gate::allows('人事管理-组长审核')){ return ["success"=>false,"data"=>"您无此权限操作!"]; }
  158. $id=$request->input('id');
  159. $laborReport=LaborReport::find($id);
  160. $laborReportStatus=new LaborReportStatus([
  161. 'labor_report_id'=>$id,
  162. 'status'=>'已退组',
  163. ]);
  164. $laborReportStatus->save();
  165. $this->log(__METHOD__,"报表记录退组对应状态".__FUNCTION__,json_encode($laborReportStatus),Auth::user()['id']);
  166. $check_out_at=Carbon::now()->format('Y-m-d H:i:s');
  167. $check_in_at=$laborReport->check_in_at;
  168. $laborReport->check_out_at=$check_out_at;
  169. $online_duration=round(Carbon::parse($check_out_at)->diffInSeconds(Carbon::parse($check_in_at))/3600,2);
  170. $round_time=round(Carbon::parse($laborReport->round_check_out_at)->diffInSeconds(Carbon::parse($laborReport->round_check_in_at))/3600,2);
  171. $laborReport->working_duration=$this->minusLunchTime($laborReport,$round_time);
  172. if ($laborReport['enter_at']){
  173. $enter_at=$laborReport['enter_at'];
  174. $laborReport->online_duration=round(Carbon::parse($check_out_at)->diffInSeconds(Carbon::parse($enter_at))/3600,2);
  175. }else{
  176. $laborReport->online_duration=$online_duration;
  177. }
  178. $laborReport->update();
  179. $laborReport->is_exportGroup=$laborReport->getIsExportGroupAttribute();
  180. $this->log(__METHOD__,"退组".__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
  181. event(new ClockoutEvent($laborReport));
  182. return ["success"=>true,"data"=>$laborReport];
  183. }
  184. //晚19点后组长点击退场,判断是否有晚餐情况
  185. public function groupExportEnsure(Request $request){
  186. if(!Gate::allows('人事管理-组长审核')){ return ["success"=>false,"data"=>"您无此权限操作!"]; }
  187. $id=$request->input('id');
  188. $relax_time=$request->input('relax_time');
  189. if(!$relax_time){ return ["success"=>false,"data"=>"未选择确切晚饭时间,请重新选择!"]; }
  190. $laborReport=LaborReport::find($id);
  191. $laborReportStatus=new LaborReportStatus([
  192. 'labor_report_id'=>$id,
  193. 'status'=>'已退组',
  194. ]);
  195. $laborReportStatus->save();
  196. $this->log(__METHOD__,"报表记录退组对应状态".__FUNCTION__,json_encode($laborReportStatus),Auth::user()['id']);
  197. $check_out_at=Carbon::now()->format('Y-m-d H:i:s');
  198. $check_in_at=$laborReport->check_in_at;
  199. $laborReport->check_out_at=$check_out_at;
  200. $online_duration=round(Carbon::parse($check_out_at)->diffInSeconds(Carbon::parse($check_in_at))/3600,2);
  201. $round_time=round(Carbon::parse($laborReport->round_check_out_at)->diffInSeconds(Carbon::parse($laborReport->round_check_in_at))/3600,2);
  202. if ($relax_time){
  203. $laborReport->relax_time=$relax_time;
  204. $laborReport->working_duration=$this->minusLunchTime($laborReport,$round_time)-$relax_time/60;//减去晚饭时间
  205. }else{
  206. $laborReport->working_duration=$this->minusLunchTime($laborReport,$round_time);
  207. }
  208. if ($laborReport->enter_at){
  209. $enter_at=$laborReport['enter_at'];
  210. $laborReport->online_duration=round(Carbon::parse($check_out_at)->diffInSeconds(Carbon::parse($enter_at))/3600,2);
  211. }else{
  212. $laborReport->online_duration=$online_duration;
  213. }
  214. $laborReport->update();
  215. $laborReport->is_exportGroup=$laborReport->getIsExportGroupAttribute();
  216. $this->log(__METHOD__,"退组".__FUNCTION__,json_encode($laborReport),Auth::user()['id']);
  217. event(new ClockoutEvent($laborReport));
  218. return ["success"=>true,"data"=>$laborReport];
  219. }
  220. //工作时长减午饭休息时间
  221. public function minusLunchTime($laborReport,$hour){
  222. $checkInTime=$laborReport->check_in_at;
  223. $checkOutTime=$laborReport->check_out_at;
  224. $checkOutTime=Carbon::parse($checkOutTime)->format('H');
  225. $checkInTime=Carbon::parse($checkInTime);
  226. if ($checkInTime->lessThanOrEqualTo($checkInTime->clone()->setHours(11)->setMinutes(30))&&(int)$checkOutTime>=13){
  227. $hour=$hour-1;
  228. }
  229. return $hour;
  230. }
  231. public function updateLaborCompany(Request $request){
  232. if(!Gate::allows('人事管理-临时工报表-修改劳务所')){ return ["success"=>false,"data"=>"您无此权限操作!"]; }
  233. $param=$request->input();
  234. $enter_number=$request->enter_number;
  235. app('laborReportService')->修改劳务所($param);
  236. $laborReport=LaborReport::query()->where('enter_number',$enter_number)->first();
  237. if ($laborReport->labor_company_id==$request->input('laborCompanyId')){
  238. $labor_company=LaborCompany::query()->find($request->input('laborCompanyId'))->value('name');
  239. return ['success'=>true,'data'=>$laborReport,'labor_company'=>$labor_company];
  240. }else{
  241. return ['success'=>true,'data'=>'修改劳务所失败'];
  242. }
  243. }
  244. public function 删除($id){
  245. if(!Gate::allows('人事管理-临时工报表-删除')){return['success'=>false,'data'=>'没有权限'];}
  246. if(is_null($id)){return ['success'=>false,'data'=>'传入id为空'];}
  247. $laborReport=app('laborReportService')->删除($id);
  248. if ($laborReport>0)return ['success'=>true,'data'=>$laborReport];
  249. return ['success'=>true,'data'=>'删除报表失败'];
  250. }
  251. //回收站
  252. function recycle(Request $request){
  253. if(!Gate::allows('人事管理-临时工报表-删除')){ return redirect('/'); }
  254. $laborReports=LaborReport::query()->with(['user','userDutyCheck','userWorkgroup','laborCompany'])->onlyTrashed()->paginate($request->paginate??50);
  255. return view('personnel.laborReport.recycle',compact('laborReports'));
  256. }
  257. //回收站恢复
  258. function recover(Request $request){
  259. if(!Gate::allows('人事管理-临时工报表-删除')){ return redirect('/'); }
  260. $checkData=$request->checkData;
  261. $this->log(__METHOD__,"回收站恢复临时工报表记录_".__FUNCTION__,json_encode($request->input()),Auth::user()['id']);
  262. return ['success'=>LaborReport::withTrashed()->whereIn('id',$checkData)->restore()];
  263. }
  264. public function changeLaborReportRemark(Request $request){
  265. if(!Gate::allows('人事管理-临时工报表-编辑备注')){return ['success'=>'false','fail_info'=>'没有权限'];}
  266. $laborReportId = $request->input('id');
  267. $laborReportRemark = $request->input('remark');
  268. if(is_null($laborReportId) ){
  269. return ['success'=>false,'fail_info'=>'参数异常'];
  270. }
  271. $laborReport=LaborReport::find($laborReportId);
  272. $laborReport->setRemarkAttribute($laborReportRemark,$laborReportId);
  273. $this->log(__METHOD__,'添加或者修改临时工报表备注'.__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  274. return ['success'=>true,'status'=>$laborReport];
  275. }
  276. }