TaskController.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508
  1. <?php
  2. namespace App\Http\Controllers\API;
  3. use App\Exports\DownloadHelper;
  4. use App\Exports\TaskExport;
  5. use App\Http\Controllers\Controller;
  6. use App\Http\Requests\API\Task\AssignRequest;
  7. use App\Http\Requests\API\Task\BatchCreateItemRules;
  8. use App\Http\Requests\API\Task\BatchCreateRequest;
  9. use App\Http\Requests\API\Task\CreateOrUpdateRequest;
  10. use App\Http\Requests\API\Task\LinkContainerRequest;
  11. use App\Http\Resources\API\TaskDetailResource;
  12. use App\Http\Resources\API\TaskResource;
  13. use App\Imports\TaskImport;
  14. use App\Models\Approval;
  15. use App\Models\Container;
  16. use App\Models\Enums\ActionObjectType;
  17. use App\Models\Enums\FileObjectType;
  18. use App\Models\Enums\ObjectAction;
  19. use App\Models\Enums\TaskStatus;
  20. use App\Models\Library;
  21. use App\Models\Project;
  22. use App\Models\Requirement;
  23. use App\Models\Task;
  24. use App\Models\TaskContainer;
  25. use App\Repositories\ActionRepository;
  26. use App\Repositories\CustomFieldRepository;
  27. use App\Services\File\FileAssociationService;
  28. use App\Services\History\ModelChangeDetector;
  29. use Carbon\Carbon;
  30. use Illuminate\Http\Request;
  31. use Illuminate\Support\Facades\Auth;
  32. use Illuminate\Support\Facades\Validator;
  33. use Maatwebsite\Excel\Facades\Excel;
  34. class TaskController extends Controller
  35. {
  36. use DownloadHelper;
  37. /**
  38. * Display a listing of the resource.
  39. */
  40. public function index(Request $request)
  41. {
  42. $tasks= $this->getTasks($request);
  43. return TaskResource::collection($tasks);
  44. }
  45. public function publicSearch(Request $request){
  46. $tasks=$this->getTasks($request);
  47. return TaskResource::collection($tasks);
  48. }
  49. protected function getTasks(Request $request){
  50. $pageSize=$request->get('page_size') ?? 10;
  51. $sort=$request->input('sort','desc');
  52. $tasks = Task::query()
  53. ->where("parent_id", 0)
  54. ->when($request->approval_status, fn($query) => $query->where("approval_status", $request->approval_status))
  55. ->with(['children', 'assignTo', 'createdBy'])
  56. ->filter($request->all())
  57. ->allowed()
  58. ->orderBy('created_at',$sort)
  59. ->paginate($pageSize);
  60. return $tasks;
  61. }
  62. public function export(Request $request)
  63. {
  64. return $this->downloadExcelHelper(
  65. new TaskExport(),
  66. "task",
  67. $request->get("extension"),
  68. );
  69. }
  70. /**
  71. * Store a newly created resource in storage.
  72. */
  73. public function store(FileAssociationService $service, CreateOrUpdateRequest $request, CustomFieldRepository $customFieldRepo)
  74. {
  75. $isAction=true;
  76. $projectId=$request->get("project_id");
  77. $project = Project::allowed($projectId,$isAction)->find($projectId);
  78. if($project===null||is_null($project)){
  79. return $this->badRequest('Permission denied or project not found. Please contact the administrator.');
  80. };
  81. $requirement = $request->has('requirement_id')
  82. ? Requirement::query()->findOrFail($request->get("requirement_id"))
  83. : null;
  84. $service->check(
  85. $request->get("file_ids", []),
  86. FileObjectType::TASK,
  87. $request->get("file_uuid"),
  88. );
  89. $formData = [
  90. ...$request->all(),
  91. 'company_id' => Auth::user()->company_id,
  92. 'created_by' => Auth::id(),
  93. 'whitelist' => $request->whitelist ? sprintf(",%s,", implode(',', $request->whitelist)) : null,
  94. 'asset_id' => $requirement?->asset_id,
  95. 'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null,
  96. 'requirement_group_id'=> $requirement?->requirement_group_id,
  97. ];
  98. if ($request->has("naming_rule_id") && $request->get("naming_rule_id") > 0) {
  99. $keys = $customFieldRepo->keysByGroup($request->get("naming_rule_id"));
  100. $formData['naming_rules'] = $request->only($keys);
  101. }
  102. $task = Task::create($formData);
  103. ActionRepository::createByTask($task, ObjectAction::CREATED);
  104. $service->association($task->id);
  105. return $this->created();
  106. }
  107. public function import(Request $request)
  108. {
  109. Excel::import(new TaskImport(), $request->file("file"));
  110. return $this->created();
  111. }
  112. /**
  113. * Display the specified resource.
  114. */
  115. public function show(string $id)
  116. {
  117. $task = Task::query()->allowed($id)->with([
  118. 'containers'
  119. ])->findOrFail($id);
  120. return new TaskDetailResource($task);
  121. }
  122. public function start(Request $request, string $id)
  123. {
  124. $isAction=true;
  125. $task = Task::query()->allowed($id,$isAction)->find($id);
  126. if($task===null||is_null($task)){
  127. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  128. };
  129. $task->status = TaskStatus::DOING->value;
  130. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  131. $task->save();
  132. ActionRepository::createByTask(
  133. $task,
  134. ObjectAction::STARTED,
  135. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  136. objectChanges: $changes
  137. );
  138. return $this->noContent();
  139. }
  140. public function pause(Request $request, string $id)
  141. {
  142. $isAction=true;
  143. $task = Task::query()->allowed($id,$isAction)->find($id);
  144. if($task===null||is_null($task)){
  145. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  146. };
  147. $task->status = TaskStatus::PAUSE->value;
  148. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  149. $task->save();
  150. ActionRepository::createByTask(
  151. $task, ObjectAction::PAUSED,
  152. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  153. objectChanges: $changes
  154. );
  155. return $this->noContent();
  156. }
  157. public function closed(Request $request, string $id)
  158. {
  159. $isAction=true;
  160. $task = Task::query()->allowed($id,$isAction)->find($id);
  161. if($task===null||is_null($task)){
  162. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  163. };
  164. $task->status = TaskStatus::CLOSED->value;
  165. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  166. $task->save();
  167. ActionRepository::createByTask(
  168. $task, ObjectAction::CLOSED,
  169. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  170. objectChanges: $changes
  171. );
  172. return $this->noContent();
  173. }
  174. public function done(Request $request, string $id)
  175. {
  176. $isAction=true;
  177. $task = Task::query()->allowed($id,$isAction)->find($id);
  178. if($task===null||is_null($task)){
  179. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  180. };
  181. $task->fill([
  182. 'status' => TaskStatus::DONE->value,
  183. 'finished_by' => Auth::user()->id,
  184. 'finished_at' => Carbon::now(),
  185. ]);
  186. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  187. $task->save();
  188. ActionRepository::createByTask(
  189. $task, ObjectAction::DONE,
  190. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  191. objectChanges: $changes
  192. );
  193. return $this->noContent();
  194. }
  195. public function cancel(Request $request, string $id)
  196. {
  197. $isAction=true;
  198. $task = Task::query()->allowed($id,$isAction)->find($id);
  199. if($task===null||is_null($task)){
  200. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  201. };
  202. $task->fill([
  203. 'status' => TaskStatus::CANCEL->value,
  204. 'canceled_by' => Auth::user()->id,
  205. 'canceled_at' => Carbon::now(),
  206. ]);
  207. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  208. $task->save();
  209. ActionRepository::createByTask(
  210. $task, ObjectAction::CANCELED,
  211. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  212. objectChanges: $changes
  213. );
  214. return $this->noContent();
  215. }
  216. public function wait(Request $request,string $id){
  217. $isAction=true;
  218. $task = Task::query()->allowed($id,$isAction)->find($id);
  219. if($task===null||is_null($task)){
  220. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  221. };
  222. $task->status=TaskStatus::WAIT->value;
  223. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  224. $task->save();
  225. ActionRepository::createByTask(
  226. $task, ObjectAction::WAITED,
  227. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  228. objectChanges: $changes
  229. );
  230. return $this->noContent();
  231. }
  232. public function assign(AssignRequest $request,string $id){
  233. $isAction=true;
  234. $task = Task::query()->allowed($id,$isAction)->find($id);
  235. if($task===null||is_null($task)){
  236. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  237. };
  238. $task->fill([
  239. 'assign'=>$request->get('assign'),
  240. ...$request->all(),
  241. ]);
  242. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  243. $task->save();
  244. ActionRepository::createByTask(
  245. $task, ObjectAction::ASSIGNED,
  246. $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null,
  247. objectChanges: $changes
  248. );
  249. return $this->noContent();
  250. }
  251. /**
  252. * Update the specified resource in storage.
  253. */
  254. public function update(CreateOrUpdateRequest $request, string $id, CustomFieldRepository $customFieldRepo)
  255. {
  256. $isAction=true;
  257. $task = Task::query()->allowed($id,$isAction)->find($id);
  258. if($task===null||is_null($task)){
  259. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  260. };
  261. $requirement = $request->has('requirement_id') && $task->requirement_id != $request->get('requirement_id')
  262. ? Requirement::query()->findOrFail($request->get("requirement_id"))
  263. : null;
  264. $formData = [
  265. ...$request->except('created_by'),
  266. 'whitelist' => $request->whitelist ? sprintf(",%s,", implode(',', $request->whitelist)) : null,
  267. 'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null,
  268. 'asset_id' => $requirement?->asset_id,
  269. ];
  270. if ($request->has("naming_rule_id") && $request->get("naming_rule_id") > 0) {
  271. $keys = $customFieldRepo->keysByGroup($request->get("naming_rule_id"));
  272. $formData['naming_rules'] = $request->only($keys);
  273. }
  274. $task->fill($formData);
  275. $changes = ModelChangeDetector::detector(ActionObjectType::TASK, $task);
  276. $task->save();
  277. ActionRepository::createByTask($task, ObjectAction::EDITED, objectChanges: $changes);
  278. return $this->noContent();
  279. }
  280. /**
  281. * Remove the specified resource from storage.
  282. */
  283. public function destroy(string $id)
  284. {
  285. $isAction=true;
  286. $task = Task::query()->allowed($id,$isAction)->find($id);
  287. if($task===null||is_null($task)){
  288. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  289. };
  290. $task->delete();
  291. Approval::query()->where('object_type','task')->where('object_id',$id)->delete();
  292. ActionRepository::createByTask($task, ObjectAction::DELETED);
  293. return $this->noContent();
  294. }
  295. public function batchStore(BatchCreateRequest $request, CustomFieldRepository $customFieldRepo)
  296. {
  297. $isAction=true;
  298. $projectId=$request->get("project_id");
  299. $project = Project::allowed($projectId,$isAction)->find($projectId);
  300. if($project===null||is_null($project)){
  301. return $this->badRequest('Permission denied or project not found. Please contact the administrator.');
  302. };
  303. $parsedItems = [];
  304. $previousItem = [];
  305. foreach ($request->items as $index => $item) {
  306. if ($index == 0) {
  307. $newItem = $item;
  308. } else {
  309. $newItem = [];
  310. foreach ($item as $k => $v) {
  311. $newItem[$k] = $v == "ditto" ? data_get($previousItem, $k) : $v;
  312. }
  313. }
  314. $previousItem = $newItem;
  315. $parsedItems[] = $newItem;
  316. }
  317. $itemRules = new BatchCreateItemRules();
  318. foreach ($parsedItems as $index => $item) {
  319. $rules = $itemRules->rules($item);
  320. try {
  321. $validator = Validator::make($item, $rules);
  322. if ($validator->fails()) {
  323. return $this->badRequest(sprintf("line: %d, %s", $index + 1, $validator->errors()->first()));
  324. }
  325. } catch (\Exception $e) {
  326. return $this->badRequest(sprintf("line: %d, %s", $index + 1, $e->getMessage()));
  327. }
  328. }
  329. foreach ($parsedItems as $item) {
  330. $requirement=$item['requirement_id']>0 ? Requirement::query()->findOrFail($item['requirement_id']) : null;
  331. $item["whitelist"]=!empty($item['whitelist']) ? sprintf(",%s,", implode(',',$item['whitelist'])) : null;
  332. $namingRuleId = data_get($item, "naming_rule_id", 0);
  333. if ($namingRuleId > 0) {
  334. $keys = $customFieldRepo->keysByGroup($namingRuleId);
  335. $item['naming_rules'] = collect($item)->only($keys)->toArray();
  336. }
  337. $task = Task::query()->create([
  338. ...$item,
  339. 'project_id' => $project->id,
  340. 'parent_id' => $request->parent_id,
  341. 'company_id' => Auth::user()->company_id,
  342. 'created_by' => Auth::id(),
  343. 'asset_id' => $requirement?->asset_id,
  344. 'requirement_group_id'=> $requirement?->requirement_group_id,
  345. ]);
  346. ActionRepository::createByTask($task, ObjectAction::CREATED);
  347. }
  348. return $this->noContent();
  349. }
  350. /**
  351. * 容器链接
  352. *
  353. * @param LinkContainerRequest $request
  354. * @param string $id
  355. * @return \Illuminate\Http\JsonResponse|\Illuminate\Http\Response
  356. */
  357. public function linkContainer(LinkContainerRequest $request, string $id)
  358. {
  359. $isAction=true;
  360. $task = Task::query()->allowed($id,$isAction)->find($id);
  361. if($task===null||is_null($task)){
  362. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  363. };
  364. $libraryIds = Library::query()->allowed()->where("project_id", $task->project_id)->pluck("id");
  365. if ($libraryIds->isEmpty()) {
  366. return $this->badRequest("No container exists for the current task item");
  367. }
  368. $containers = Container::query()
  369. ->allowed()
  370. ->whereIn("library_id", $libraryIds->toArray())
  371. ->whereIn("id", $request->get("container_ids", []))
  372. ->get(['id']);
  373. if (! $containers) {
  374. return $this->badRequest("Please select a valid container");
  375. }
  376. foreach ($containers as $container) {
  377. TaskContainer::query()->firstOrCreate([
  378. 'container_id' => $container->id,
  379. 'task_id' => $task->id
  380. ]);
  381. }
  382. return $this->noContent();
  383. }
  384. public function unlinkContainer(string $id)
  385. {
  386. $taskContainer = TaskContainer::query()->findOrFail($id);
  387. $taskId=$taskContainer->task_id;
  388. $isAction=true;
  389. $task = Task::query()->allowed($taskId,$isAction)->find($taskId);
  390. if($task===null||is_null($task)){
  391. return $this->badRequest('Permission denied or task not found. Please contact the administrator.');
  392. };
  393. $taskContainer->delete();
  394. return $this->noContent();
  395. }
  396. /**
  397. * 待关联的容器
  398. *
  399. * @param Request $request
  400. * @param string $id
  401. * @return \Illuminate\Http\JsonResponse
  402. */
  403. public function containerToBeLinked(Request $request, string $id)
  404. {
  405. $task = Task::query()->allowed($id)->findOrFail($id);
  406. $libraryIds = Library::query()->allowed()->where("project_id", $task->project_id)->pluck("id");
  407. if ($libraryIds->isEmpty()) {
  408. return $this->badRequest("No container exists for the current task item");
  409. }
  410. $containers = Container::query()
  411. ->allowed()
  412. ->leftJoin("task_container", "containers.id", "=", "task_container.container_id")
  413. ->where($request->only(['library_id']))
  414. ->whereIn("library_id", $libraryIds->toArray())
  415. ->whereNull("task_container.id")
  416. ->selectRaw("containers.id, containers.name")
  417. ->get();
  418. return $this->success([
  419. 'data' => $containers
  420. ]);
  421. }
  422. }