ProjectUserController.php 9.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190
  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. if(empty($res)) return back()->withErrors(['sg_error_info' => '更新失败']);
  87. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '更新成功']);
  88. }else{
  89. // 用户不在项目中
  90. if ($project_role_id == 4)
  91. {
  92. //原本的项目经理变成项目副经理
  93. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  94. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  95. }else if ($project_role_id == 2)
  96. {
  97. $m_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',2)->value('user_id');
  98. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  99. }
  100. $res = $this->model->create($data);
  101. if(empty($res)) return back()->withErrors(['sg_error_info' => '保存失败']);
  102. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '创建成功']);
  103. }
  104. }
  105. public function edit(Request $request)
  106. {
  107. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  108. $user_options = (new User())->getOptions();
  109. $role_options = (new ProjectRole())->getNotLeaderOptions();
  110. list($model, $model_name, $pre_uri) = array($this->model, $this->model_name, $this->pre_uri);
  111. return view($this->view_path . 'edit', compact('model', 'model_name', 'pre_uri', 'item', 'user_options', 'role_options'));
  112. }
  113. public function update(Request $request)
  114. {
  115. $user_id = intval(request('user_id'));
  116. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return back()->withErrors(['sg_error_info' => '找不到要编辑的数据']);
  117. if(empty($request->input('data')) || !is_array($request->input('data'))) return back()->withErrors(['sg_error_info' => '数据错误']);
  118. $validator = $this->model->getValidator($request, 'update');
  119. if($validator->fails()) {
  120. return back()->withErrors($validator)->withInput();
  121. }
  122. $data = $request->input('data');
  123. $project_id = $request->input('project_id');
  124. $project_users = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->get()->toArray();
  125. if (count($project_users)!=0)
  126. {
  127. if ($data['project_role_id'] == 4)
  128. {
  129. //原本的项目经理变成项目副经理
  130. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  131. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  132. }else if ($data['project_role_id'] == 2)
  133. {
  134. $m_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',2)->value('user_id');
  135. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  136. }
  137. //自己的角色变成项目经理
  138. $res = ProjectUser::where('project_id',$project_id)->where('user_id',$user_id)->update(['project_role_id'=>$data['project_role_id']]);
  139. if(empty($res)) return back()->withErrors(['sg_error_info' => '更新失败']);
  140. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '更新成功']);
  141. }
  142. else
  143. {
  144. if ($data['project_role_id'] == 4)
  145. {
  146. //原本的项目经理变成项目副经理
  147. $s_user_id = ProjectUser::where('project_id',$project_id)->where('project_role_id',4)->value('user_id');
  148. ProjectUser::where('project_id',$project_id)->where('user_id',$s_user_id)->update(['project_role_id'=>3]);
  149. }else if ($data['project_role_id'] == 2)
  150. {
  151. $m_user_id = ProjectUser::where('project_id',$data['project_id'])->where('project_role_id',2)->value('user_id');
  152. ProjectUser::where('project_id',$project_id)->where('user_id',$m_user_id)->update(['project_role_id'=>1]);
  153. }
  154. $res = $this->model->create($data);
  155. if(empty($res)) return back()->withErrors(['sg_error_info' => '保存失败']);
  156. return redirect($this->pre_uri . 'create')->with(['sg_success_info' => '创建成功']);
  157. }
  158. }
  159. public function delete(Request $request)
  160. {
  161. if(empty($request->input('id')) || empty($item = $this->model->find($request->input('id')))) return response()->json(['status' => 'fail', 'info' => '找不到要删除的数据']);
  162. $res = $item->delete();
  163. if (!$res) return response()->json(['status' => 'fail', 'info' => '删除失败']);
  164. return response()->json(['status' => 'success', 'info' => '操作成功']);
  165. }
  166. }