ProjectUserController.php 9.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Models\Project;
  4. use App\Models\ProjectRole;
  5. use App\Models\ProjectUser;
  6. use App\Models\User;
  7. use function Couchbase\defaultDecoder;
  8. use Illuminate\Http\Request;
  9. class ProjectUserController extends BaseController
  10. {
  11. protected $model;
  12. protected $department;
  13. protected $model_name = '项目角色';
  14. protected $pre_uri = '/admin/ProjectUser/';
  15. protected $view_path = 'admin.project-users.';
  16. protected $redirect_index = '/admin/ProjectUser/index';
  17. public function __construct()
  18. {
  19. parent::__construct();
  20. $this->model = new ProjectUser();
  21. }
  22. public function index(Request $request)
  23. {
  24. $project = Project::find($request->input('project_id'));
  25. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  26. return view($this->view_path . 'index', compact('model', 'model_name','pre_uri', 'project'));
  27. }
  28. public function get(Request $request)
  29. {
  30. $items = $this->model->with('user', 'projectRole');
  31. if($request->input('name')) {
  32. $user_ids = User::where('name', 'like', '%' . $request->input('name') . '')->pluck('id')->unique();
  33. if(count($user_ids) > 0) {
  34. $items = $items->whereIn('user_id', $user_ids);
  35. }
  36. }
  37. $select_items = collect(['project_id', 'user_id']);
  38. foreach($select_items as $select_item) {
  39. if($request->has($select_item) && !empty($request->input($select_item))) {
  40. $items = $items->where($select_item, '=', $request->input($select_item));
  41. }
  42. }
  43. $items = $items->paginate();
  44. foreach($items as $item) {
  45. $item->user_name = $item->user ? $item->user->name : '';
  46. $item->role_name = $item->projectRole ? $item->projectRole->name : '';
  47. $item->project_name = $item->project ? $item->project->name : '';
  48. }
  49. return response()->json(['code' => 0, 'message' => '', 'count' => $items->total(), 'data' => $items->items()]);
  50. }
  51. public function create()
  52. {
  53. $user_options = (new User())->getOptions();
  54. $role_options = (new ProjectRole())->getNotLeaderOptions();
  55. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  56. return view($this->view_path . 'create', compact('model', 'model_name','pre_uri', 'user_options', 'role_options'));
  57. }
  58. public function store(Request $request)
  59. {
  60. if(empty($request->input('data')) || !is_array($request->input('data'))) return back()->withErrors(['sg_error_info' => '数据错误']);
  61. $validator = $this->model->getValidator($request, 'store');
  62. if($validator->fails()) {
  63. return back()->withErrors($validator)->withInput();
  64. }
  65. $data = $request->input('data');
  66. $project_id = $data['project_id'];
  67. $user_id = $data['user_id'];
  68. $project_role_id = $data['project_role_id'];
  69. //查找该用户
  70. $project_users = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->get()->toArray();
  71. //用户在项目中
  72. if (count($project_users)!=0)
  73. {
  74. if ($project_role_id == 4)
  75. {
  76. //原本的项目经理变成项目副经理
  77. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  78. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  79. }else if ($project_role_id == 2)
  80. {
  81. $m_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',2)->value('user_id');
  82. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  83. }
  84. //自己的角色变成项目经理
  85. $res = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->update(['project_role_id'=>$project_role_id]);
  86. Project::where('id',$project_id)->update(['user_id'=>$user_id]);
  87. if(empty($res)) return back()->withErrors(['sg_error_info' => '更新失败']);
  88. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '更新成功']);
  89. }else{
  90. // 用户不在项目中
  91. if ($project_role_id == 4)
  92. {
  93. //原本的项目经理变成项目副经理
  94. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  95. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  96. }else if ($project_role_id == 2)
  97. {
  98. $m_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',2)->value('user_id');
  99. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  100. }
  101. $res = $this->model->create($data);
  102. Project::where('id',$project_id)->update(['user_id'=>$user_id]);
  103. if(empty($res)) return back()->withErrors(['sg_error_info' => '保存失败']);
  104. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '创建成功']);
  105. }
  106. }
  107. public function edit(Request $request)
  108. {
  109. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  110. $user_options = (new User())->getOptions();
  111. $role_options = (new ProjectRole())->getNotLeaderOptions();
  112. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  113. return view($this->view_path . 'edit', compact('model', 'model_name', 'pre_uri', 'item', 'user_options', 'role_options'));
  114. }
  115. public function update(Request $request)
  116. {
  117. $user_id = intval(request('user_id'));
  118. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  119. if(empty($request->input('data')) || !is_array($request->input('data'))) return back()->withErrors(['sg_error_info' => '数据错误']);
  120. $validator = $this->model->getValidator($request, 'update');
  121. if($validator->fails()) {
  122. return back()->withErrors($validator)->withInput();
  123. }
  124. $data = $request->input('data');
  125. $project_id = $request->input('project_id');
  126. $project_users = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->get()->toArray();
  127. if (count($project_users)!=0)
  128. {
  129. if ($data['project_role_id'] == 4)
  130. {
  131. //原本的项目经理变成项目副经理
  132. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  133. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  134. }else if ($data['project_role_id'] == 2)
  135. {
  136. $m_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',2)->value('user_id');
  137. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  138. }
  139. //自己的角色变成项目经理
  140. $res = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->update(['project_role_id'=>$data['project_role_id']]);
  141. if(empty($res)) return back()->withErrors(['sg_error_info' => '更新失败']);
  142. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '更新成功']);
  143. }
  144. else
  145. {
  146. if ($data['project_role_id'] == 4)
  147. {
  148. //原本的项目经理变成项目副经理
  149. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  150. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  151. }else if ($data['project_role_id'] == 2)
  152. {
  153. $m_user_id = ProjectUser::where('project_id',$data['project_id'])->where('project_role_id',2)->value('user_id');
  154. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  155. }
  156. $res = $this->model->create($data);
  157. if(empty($res)) return back()->withErrors(['sg_error_info' => '保存失败']);
  158. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '创建成功']);
  159. }
  160. }
  161. public function delete(Request $request)
  162. {
  163. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return response()->json(['status' => 'fail', 'info' => '找不到要删除的数据']);
  164. $res = $item->delete();
  165. if (!$res) return response()->json(['status' => 'fail', 'info' => '删除失败']);
  166. return response()->json(['status' => 'success', 'info' => '操作成功']);
  167. }
  168. }