UserController.php 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Components\AsyncResponse;
  4. use App\Owner;
  5. use App\OwnerGroup;
  6. use App\Role;
  7. use App\Supplier;
  8. use App\User;
  9. use App\UserDetail;
  10. use App\UserWorkgroup;
  11. use Doctrine\DBAL\Configuration;
  12. use Exception;
  13. use Illuminate\Database\Eloquent\Builder;
  14. use Illuminate\Http\Request;
  15. use Illuminate\Http\Response;
  16. use Illuminate\Support\Facades\Auth;
  17. use Illuminate\Support\Facades\Gate;
  18. use Illuminate\Support\Facades\Hash;
  19. use Illuminate\Support\Facades\Validator;
  20. class UserController extends Controller
  21. {
  22. use AsyncResponse;
  23. /**
  24. * Display a listing of the resource.
  25. *
  26. * @param Request $request
  27. * @return Response
  28. */
  29. public function index(Request $request)
  30. {
  31. if(!Gate::allows('用户-查询')){ return redirect(url('/')); }
  32. $owners=app("OwnerService")->getIntersectPermitting();
  33. $userDetailQuery = UserDetail::query()->select('user_id')->where('type','临时工');
  34. $query = User::with(['roles','logistics','userWorkgroups','suppliers','userDetail'])->whereNotIn('id',$userDetailQuery);
  35. if($request->has('name')){
  36. $user=$request->input('name');
  37. $query->where('name','like',$user.'%');
  38. }
  39. if($request->has('role')){
  40. $role = $request->input('role');
  41. $query->whereHas('roles',function($query) use ($role){
  42. if (strpos($role, ',') || strpos($role, ',') || strpos($role, ' ')) {
  43. $arr = array_filter(preg_split('/[,, ]+/is', $role));
  44. $query->whereIn('name', $arr);
  45. unset($role);
  46. } else {
  47. $query->where('name','like',$role.'%');
  48. }
  49. });
  50. }
  51. if($request->input('owners')){
  52. $owner_id= $request->input('owners');
  53. $owner_ids = array_filter(preg_split('/[,, ]+/is',$owner_id));
  54. $ownerIds=[];
  55. foreach ($owner_ids as $id)$ownerIds[]='_'.$id;
  56. $query->whereHas('roles',function($query) use ($ownerIds){
  57. $query->whereHas('authorities',function ($query)use($ownerIds){
  58. $query->whereIn('name',$ownerIds);
  59. });
  60. });
  61. }
  62. $users = $query->orderBy('id','desc')->paginate($request->paginate ?? 50);
  63. $users->each(function (User $user){
  64. $user['isSuperAdmin']=$user->isSuperAdmin();
  65. });
  66. return view('maintenance.user.index',compact('users','owners'));
  67. }
  68. /**
  69. * Show the form for creating a new resource.
  70. *
  71. * @return Response
  72. */
  73. public function create()
  74. {
  75. if(!Gate::allows('用户-录入')){ return redirect(url('/')); }
  76. $roles=Role::all();
  77. $logistics=app('LogisticService')->getSelection(["id","name"],"物流");
  78. $userWorkgroups=UserWorkgroup::query()->get();
  79. $suppliers=Supplier::query()->get();
  80. return view('maintenance.user.create',['rolesAll'=>$roles,'logistics'=>$logistics,'userWorkgroups'=>$userWorkgroups,'suppliers'=>$suppliers]);
  81. }
  82. protected function validatorCreate(array $data)
  83. {
  84. return Validator::make($data, [
  85. 'name' => ['required', 'string', 'max:50', 'unique:users'],
  86. ]);
  87. }
  88. protected function validatorUpdate(array $data)
  89. {
  90. return Validator::make($data, [
  91. 'name' => ['required', 'string', 'max:50'],
  92. ]);
  93. }
  94. /**
  95. * Show the form for editing the specified resource.
  96. *
  97. * @param User $user
  98. * @return Response
  99. */
  100. public function edit(User $user)
  101. {
  102. if(!Gate::allows('用户-编辑')){ return redirect(url('/')); }
  103. $user=$user->loadMissing('userDetail');
  104. $rolesAll=Role::all();
  105. $roles=$user->roles()->get();
  106. $logistics=app('LogisticService')->getSelection(["id","name"],"物流");
  107. $logisticUser=$user->logistics()->get();
  108. $userWorkgroups=UserWorkgroup::query()->get();
  109. $userWorkgroup=$user->userWorkgroups()->first();
  110. $supplierUser=$user->suppliers()->get();
  111. $suppliers=Supplier::query()->get();
  112. return view('maintenance.user.edit',compact('user','rolesAll','roles','logistics','logisticUser','userWorkgroups','userWorkgroup','suppliers','supplierUser'));
  113. }
  114. /**
  115. * Update the specified resource in storage.
  116. *
  117. * @param Request $request
  118. * @param User $user
  119. * @return Response
  120. */
  121. public function update(Request $request, User $user)
  122. {
  123. if(!Gate::allows('用户-编辑')){ return redirect(url('/')); }
  124. $this->validatorUpdate($request->all())->validate();
  125. $user->fill($request->all());
  126. $user->update();
  127. $rolesIds=$request->input('role')??'';
  128. if($rolesIds){
  129. $roleIdArr=explode(',',$rolesIds);
  130. $user->roles()->sync($roleIdArr);
  131. }else{
  132. $user->roles()->sync([]);
  133. }
  134. $supplierIds=$request->input('supplier')??'';
  135. if($supplierIds){
  136. $supplierIdArr=explode(',',$supplierIds);
  137. $user->suppliers()->sync($supplierIdArr);
  138. }else{
  139. $user->suppliers()->sync([]);
  140. }
  141. $carrierIds=$request->input('logistic')??'';
  142. if($carrierIds){
  143. $carrierIds=explode(',',$carrierIds);
  144. $user->logistics()->sync($carrierIds);
  145. }else{
  146. $user->logistics()->sync([]);
  147. }
  148. $userWorkgroupId=$request->input('userWorkgroupID');
  149. if($userWorkgroupId){
  150. $user->userWorkgroups()->sync([$userWorkgroupId]);
  151. }else{
  152. $user->userWorkgroups()->sync([]);
  153. }
  154. $phone=$request->input('phone');
  155. $user=$user->loadMissing('userDetail');
  156. if ($phone){
  157. if (!$user->userDetail) UserDetail::query()->create(['user_id'=>$user->id,'mobile_phone'=>$phone]);
  158. UserDetail::query()->where('user_id',$user->id) ->update(['mobile_phone'=>$phone]);
  159. }
  160. app('LogService')->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']);
  161. app("UserService")->clearUserCache($user);
  162. return redirect('maintenance/user/')->with('successTip',"成功修改用户“{$user['name']}”!");
  163. }
  164. /**
  165. * Remove the specified resource from storage.
  166. *
  167. * @param User $user
  168. * @return array|Response
  169. * @throws Exception
  170. */
  171. public function destroy(User $user)
  172. {
  173. if(!Gate::allows('用户-删除')){ return redirect(url('/')); }
  174. app('LogService')->log(__METHOD__,__FUNCTION__,$user->toJson(),Auth::user()['id']);
  175. $re=$user->delete();
  176. app("UserService")->clearUserCache($user);
  177. return ['success'=>$re];
  178. }
  179. /**
  180. * 重置密码
  181. */
  182. public function resetPassword()
  183. {
  184. $this->gate("用户-编辑");
  185. $user = User::query()->find(\request("id"));
  186. if (!$user)$this->error("用户不存在");
  187. if (array_search($user->name,config("users.superAdmin"))!==false)$this->error("无权操作超管账户");
  188. $user->update(["password" => Hash::make(request("pwd"))]);
  189. $this->success();
  190. }
  191. }