2
0

TaskController.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
  1. <?php
  2. namespace App\Http\Controllers;
  3. use App\Http\Api\StudioApi;
  4. use App\Http\Api\TaskApi;
  5. use App\Http\Resources\TaskResource;
  6. use App\Models\Project;
  7. use App\Models\Task;
  8. use App\Models\TaskAssignee;
  9. use App\Services\AuthService;
  10. use Illuminate\Http\Request;
  11. use Illuminate\Http\Response;
  12. use Illuminate\Support\Str;
  13. class TaskController extends Controller
  14. {
  15. /**
  16. * Display a listing of the resource.
  17. *
  18. * @return Response
  19. */
  20. public function index(Request $request)
  21. {
  22. //
  23. $user = AuthService::current($request);
  24. if (! $user) {
  25. return $this->error(__('auth.failed'), 401, 401);
  26. }
  27. switch ($request->input('view')) {
  28. case 'all':
  29. $table = Task::whereNotNull('owner_id');
  30. break;
  31. case 'instance':
  32. $table = Task::where('type', 'instance');
  33. break;
  34. case 'studio':
  35. $table = Task::where('owner_id', $user['user_uid']);
  36. break;
  37. case 'project':
  38. $projects = Project::where('uid', $request->input('project_id'))
  39. ->orWhereJsonContains('path', $request->input('project_id'))
  40. ->select('uid')
  41. ->get();
  42. $table = Task::whereIn('project_id', $projects);
  43. break;
  44. default:
  45. // code...
  46. break;
  47. }
  48. if ($request->has('executor_id_includes')) {
  49. $table = $table->whereIn(
  50. 'executor_id',
  51. explode(',', $request->input('executor_id_includes'))
  52. );
  53. }
  54. if ($request->has('executor_id_not-includes')) {
  55. $table = $table->whereNotIn(
  56. 'executor_id',
  57. explode(',', $request->input('executor_id_not-includes'))
  58. );
  59. }
  60. if ($request->has('assignees_id_includes')) {
  61. $assigneesId = explode(',', $request->input('assignees_id_includes'));
  62. $assigneesTasks = TaskAssignee::whereIn('assignee_id', $assigneesId)
  63. ->select('task_id')->get();
  64. $table = $table->whereIn('id', $assigneesTasks);
  65. }
  66. if ($request->has('assignees_id_not-includes')) {
  67. $assigneesId = explode(',', $request->input('assignees_id_includes'));
  68. $assigneesTasks = TaskAssignee::whereIn('assignee_id', $assigneesId)
  69. ->select('task_id')->get();
  70. $table = $table->whereNotIn('id', $assigneesTasks);
  71. }
  72. // 指派给
  73. if ($request->has('assignees_id_null')) {
  74. $table = $table->doesntHave('task_assignees');
  75. }
  76. if ($request->has('assignees_id_not-null')) {
  77. $table = $table->has('task_assignees');
  78. }
  79. if ($request->input('sign_up_equals') === 'true') {
  80. $table = $table->whereNull('assignees_id')
  81. ->whereNull('executor_id');
  82. }
  83. /**某人参与的 */
  84. if ($request->has('participants_id_includes')) {
  85. $id = explode(',', $request->input('participants_id_includes'));
  86. $tasks_id = TaskAssignee::whereIn('assignee_id', $id)->select('task_id')->get();
  87. $table = $table->where(function ($query) use ($id, $tasks_id) {
  88. $query->whereIn('executor_id', $id)
  89. ->orWhereIn('id', $tasks_id);
  90. });
  91. }
  92. if ($request->has('participants_id_not-includes')) {
  93. $id = explode(',', $request->input('participants_id_includes'));
  94. $tasks_id = TaskAssignee::whereIn('assignee_id', $id)->select('task_id')->get();
  95. $table = $table->where(function ($query) use ($id, $tasks_id) {
  96. $query->whereNotIn('executor_id', $id)
  97. ->orWhereNotIn('id', $tasks_id);
  98. });
  99. }
  100. if ($request->has('keyword')) {
  101. $table = $table->where('title', 'like', '%'.$request->input('keyword').'%');
  102. }
  103. if ($request->has('status') && $request->input('status') !== 'all') {
  104. $table = $table->whereIn('status', explode(',', $request->input('status')));
  105. }
  106. $count = $table->count();
  107. $table = $table->orderBy(
  108. $request->input('order', 'created_at'),
  109. $request->input('dir', 'asc')
  110. );
  111. $table = $table->skip($request->input('offset', 0))
  112. ->take($request->input('limit', 1000));
  113. $result = $table->get();
  114. return $this->ok(
  115. [
  116. 'rows' => TaskResource::collection(resource: $result),
  117. 'count' => $count,
  118. ]
  119. );
  120. }
  121. /**
  122. * Store a newly created resource in storage.
  123. *
  124. * @return Response
  125. */
  126. public function store(Request $request)
  127. {
  128. //
  129. $user = AuthService::current($request);
  130. if (! $user) {
  131. return $this->error(__('auth.failed'), 401, 401);
  132. }
  133. $studioId = StudioApi::getIdByName($request->input('studio_name'));
  134. if (! self::canEdit($user['user_uid'], $studioId)) {
  135. return $this->error(__('auth.failed'), 403, 403);
  136. }
  137. $new = Task::firstOrNew(
  138. [
  139. 'id' => $request->input('id'),
  140. ],
  141. [
  142. 'owner_id' => $studioId,
  143. 'creator_id' => $user['user_uid'],
  144. 'project_id' => $request->input('project_id'),
  145. ],
  146. );
  147. if (Str::isUuid($request->input('id'))) {
  148. $new->id = $request->input('id');
  149. } else {
  150. $new->id = Str::uuid();
  151. }
  152. $new->title = $request->input('title');
  153. $new->editor_id = $user['user_uid'];
  154. $new->parent_id = $request->input('parent_id');
  155. $new->type = $request->input('type');
  156. // 处理任务顺序
  157. if ($request->input('parent_id')) {
  158. $maxOrder = Task::where('parent_id', $request->input('parent_id'))
  159. ->max('order');
  160. } else {
  161. $maxOrder = Task::where('project_id', $request->input('project_id'))
  162. ->max('order');
  163. }
  164. if ($maxOrder === null) {
  165. $new->order = 1;
  166. } else {
  167. $new->order = $maxOrder + 1;
  168. }
  169. $new->save();
  170. return $this->ok(new TaskResource($new));
  171. }
  172. /**
  173. * Display the specified resource.
  174. *
  175. * @return Response
  176. */
  177. public function show(Task $task)
  178. {
  179. //
  180. return $this->ok(new TaskResource($task));
  181. }
  182. /**
  183. * Update the specified resource in storage.
  184. *
  185. * @return Response
  186. */
  187. public function update(Request $request, Task $task)
  188. {
  189. //
  190. $user = AuthService::current($request);
  191. if (! $user) {
  192. return $this->error(__('auth.failed'), 401, 401);
  193. }
  194. if (! self::canUpdate($user['user_uid'], $task)) {
  195. return $this->error(__('auth.failed'), 403, 403);
  196. }
  197. if ($request->has('title')) {
  198. $task->title = $request->input('title');
  199. }
  200. if ($request->has('description')) {
  201. $task->description = $request->input('description');
  202. }
  203. if ($request->has('category')) {
  204. $task->category = $request->input('category');
  205. }
  206. if ($request->has('progress')) {
  207. $task->progress = $request->input('progress');
  208. }
  209. if ($request->has('assignees_id')) {
  210. $delete = TaskAssignee::where('task_id', $task->id)->delete();
  211. $assigneesData = [];
  212. foreach ($request->input('assignees_id') as $key => $id) {
  213. $assigneesData[] = [
  214. 'id' => Str::uuid(),
  215. 'task_id' => $task->id,
  216. 'assignee_id' => $id,
  217. 'editor_id' => $user['user_uid'],
  218. ];
  219. }
  220. TaskAssignee::insert($assigneesData);
  221. }
  222. if ($request->has('roles')) {
  223. $task->roles = json_encode($request->input('roles'), JSON_UNESCAPED_UNICODE);
  224. }
  225. if ($request->has('executor_id')) {
  226. $task->executor_id = $request->input('executor_id');
  227. }
  228. if ($request->has('executor_relation_task_id')) {
  229. $task->executor_relation_task_id = $request->input('executor_relation_task_id');
  230. }
  231. if ($request->has('project_id')) {
  232. $task->project_id = $request->input('project_id');
  233. }
  234. if ($request->has('pre_task_id')) {
  235. TaskApi::setRelationTasks(
  236. $task->id,
  237. explode(',', $request->input('pre_task_id')),
  238. $user['user_uid'],
  239. 'pre'
  240. );
  241. }
  242. if ($request->has('next_task_id')) {
  243. TaskApi::setRelationTasks(
  244. $task->id,
  245. explode(',', $request->input('next_task_id')),
  246. $user['user_uid'],
  247. 'next'
  248. );
  249. }
  250. if ($request->has('is_milestone')) {
  251. $task->is_milestone = $request->input('is_milestone');
  252. }
  253. if ($request->has('order')) {
  254. $task->order = $request->input('order');
  255. }
  256. $task->editor_id = $user['user_uid'];
  257. $task->save();
  258. return $this->ok(new TaskResource($task));
  259. }
  260. /**
  261. * Remove the specified resource from storage.
  262. *
  263. * @return Response
  264. */
  265. public function destroy(Request $request, Task $task)
  266. {
  267. //
  268. $user = AuthService::current($request);
  269. if (! $user) {
  270. return $this->error(__('auth.failed'), 401, 401);
  271. }
  272. if (! self::canEdit($user['user_uid'], $task->owner)) {
  273. return $this->error(__('auth.failed'), 403, 403);
  274. }
  275. $task->delete();
  276. if ($task->trashed()) {
  277. return $this->ok('ok');
  278. } else {
  279. return $this->error('fail', 500, 500);
  280. }
  281. }
  282. public static function canEdit($user_uid, $owner_uid)
  283. {
  284. return $user_uid === $owner_uid;
  285. }
  286. /**
  287. * Update the specified resource in storage.
  288. *
  289. * @param string $user_uid
  290. * @param Task $task
  291. * @return bool
  292. */
  293. public static function canUpdate($user_uid, $task)
  294. {
  295. if ($user_uid === $task->owner_id) {
  296. return true;
  297. }
  298. if ($user_uid === $task->executor_id) {
  299. return true;
  300. }
  301. if (TaskAssignee::where('task_id', $task->id)
  302. ->where('assignee_id', $user_uid)
  303. ->exists()
  304. ) {
  305. return true;
  306. }
  307. return false;
  308. }
  309. }