ProjectController.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463
  1. <?php
  2. namespace App\Http\Controllers\API;
  3. use App\Http\Controllers\Controller;
  4. use App\Http\Requests\API\Project\CreateOrUpdateRequest;
  5. use App\Http\Requests\API\Project\LinkRequirementByPlanRequest;
  6. use App\Http\Requests\API\Project\LinkRequirementRequest;
  7. use App\Http\Requests\API\Project\PostponeRequest;
  8. use App\Http\Requests\API\Project\UnlinkRequirementRequest;
  9. use App\Http\Requests\API\Project\UpdateLinkAssetsRequest;
  10. use App\Http\Resources\API\AssetRequirementGroupTreeResource;
  11. use App\Http\Resources\API\AssetRequirementResource;
  12. use App\Http\Resources\API\AssetParentResource;
  13. use App\Http\Resources\API\ProjectAssetResource;
  14. use App\Http\Resources\API\ProjectDetailResource;
  15. use App\Http\Resources\API\ProjectGroupViewTaskResource;
  16. use App\Http\Resources\API\ProjectKanbanRequirementResource;
  17. use App\Http\Resources\API\ProjectKanbanTaskResource;
  18. use App\Http\Resources\API\SimplePlanResource;
  19. use App\Http\Resources\API\ProjectRequirementResource;
  20. use App\Http\Resources\API\ProjectResource;
  21. use App\Models\Enums\ActionObjectType;
  22. use App\Models\Enums\ObjectAction;
  23. use App\Models\Enums\ProjectStatus;
  24. use App\Models\Enums\TaskStatus;
  25. use App\Models\Plan;
  26. use App\Models\Project;
  27. use App\Models\ProjectAsset;
  28. use App\Models\ProjectPlan;
  29. use App\Models\ProjectRequirement;
  30. use App\Models\Requirement;
  31. use App\Models\Task;
  32. use App\Models\User;
  33. use App\Models\RequirementGroup;
  34. use App\Repositories\ActionRepository;
  35. use App\Services\History\ModelChangeDetector;
  36. use App\Services\Project\ProjectKanbanService;
  37. use App\Services\Project\ProjectGanttService;
  38. use App\Services\Project\ProjectTaskGroupViewService;
  39. use Illuminate\Http\Request;
  40. use Illuminate\Support\Facades\Auth;
  41. use Illuminate\Support\Facades\DB;
  42. use function Nette\Utils\setAttribute;
  43. class ProjectController extends Controller
  44. {
  45. /**
  46. * Display a listing of the resource.
  47. */
  48. public function index(Request $request)
  49. {
  50. $projectAsset = Project::filter($request->all())->with('assets')->simplePaginate();
  51. return ProjectResource::collection($projectAsset);
  52. }
  53. public function treeIndex(string $id){
  54. $project = Project::findOrFail($id);
  55. //获取项目所关联的需求所在需求分组的id
  56. $requirementsGroupIds=$project->requirementsGroup ->pluck('id')->unique()->toArray();
  57. // 加载项目中的所有Asset及其关联的RequirementGroup
  58. $assetsWithRequirementGroups = $project->assets()->with('requirementGroups')->get();
  59. $filteredAssets = $assetsWithRequirementGroups->map(function ($asset) use ($requirementsGroupIds) {
  60. if (empty($requirementsGroupIds)) {
  61. // 如果$requirementsGroupIds为空,则清空requirementGroups集合
  62. $asset->setRelation('requirementGroups', collect());
  63. } else {
  64. // 否则,过滤requirementGroups集合
  65. $asset->setRelation('requirementGroups', $asset->requirementGroups->filter(function ($group) use ($requirementsGroupIds) {
  66. return in_array($group->id, $requirementsGroupIds);
  67. }));
  68. }
  69. return $asset;
  70. });
  71. return AssetRequirementGroupTreeResource::collection($filteredAssets);
  72. }
  73. /**
  74. * Store a newly created resource in storage.
  75. */
  76. public function store(CreateOrUpdateRequest $request)
  77. {
  78. $project = new Project();
  79. $project->mergeFillable([
  80. 'company_id', 'created_by'
  81. ]);
  82. $project->fill([
  83. ...$request->all(),
  84. 'company_id' => Auth::user()->company_id,
  85. 'created_by' => Auth::id(),
  86. 'whitelist' => $request->whitelist ? sprintf(",%s", implode(',', $request->whitelist)) : null,
  87. ]);
  88. $project->save();
  89. ActionRepository::createByProject($project, ObjectAction::CREATED);
  90. if ($request->has("assets")) {
  91. foreach ($request->get("assets", []) as $assetId) {
  92. ProjectAsset::create([
  93. 'project_id' => $project->id,
  94. 'asset_id' => $assetId,
  95. ]);
  96. }
  97. }
  98. if ($request->has("plans")) {
  99. foreach ($request->get("plans", []) as $planId) {
  100. ProjectPlan::create([
  101. 'project_id' => $project->id,
  102. 'plan_id' => $planId,
  103. ]);
  104. }
  105. }
  106. return $this->created();
  107. }
  108. /**
  109. * Display the specified resource.
  110. */
  111. public function show(string $id)
  112. {
  113. $project = Project::findOrFail($id);
  114. return new ProjectDetailResource($project);
  115. }
  116. /**
  117. * Update the specified resource in storage.
  118. */
  119. public function update(CreateOrUpdateRequest $request, string $id)
  120. {
  121. $project = Project::findOrFail($id);
  122. $project->fill([
  123. ...$request->all(),
  124. 'whitelist' => $request->whitelist ? sprintf(",%s", implode(',', $request->whitelist)) : null,
  125. ]);
  126. $project->save();
  127. ActionRepository::createByProject($project, ObjectAction::EDITED);
  128. if ($request->has("assets")) {
  129. ProjectAsset::where('project_id', $project->id)->delete();
  130. foreach ($request->get("assets", []) as $assetId) {
  131. ProjectAsset::create([
  132. 'project_id' => $project->id,
  133. 'asset_id' => $assetId,
  134. ]);
  135. }
  136. }
  137. if ($request->has("plans")) {
  138. ProjectPlan::where('project_id', $project->id)->delete();
  139. foreach ($request->get("plans", []) as $planId) {
  140. ProjectPlan::create([
  141. 'project_id' => $project->id,
  142. 'plan_id' => $planId,
  143. ]);
  144. }
  145. }
  146. return $this->noContent();
  147. }
  148. /**
  149. * Remove the specified resource from storage.
  150. */
  151. public function destroy(string $id)
  152. {
  153. $project = Project::findOrFail($id);
  154. $project->delete();
  155. ActionRepository::createByProject($project, ObjectAction::DELETED);
  156. return $this->noContent();
  157. }
  158. public function closed(Request $request, string $id)
  159. {
  160. $project = Project::findOrFail($id);
  161. $project->status = ProjectStatus::CLOSED->value;
  162. $project->save();
  163. ActionRepository::createByProject($project, ObjectAction::CLOSED, $request->get("comment"));
  164. return $this->noContent();
  165. }
  166. public function start(Request $request, string $id)
  167. {
  168. $project = Project::findOrFail($id);
  169. $project->status = ProjectStatus::DOING->value;
  170. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  171. $project->save();
  172. ActionRepository::createByProject(
  173. $project,
  174. ObjectAction::STARTED,
  175. $request->get("comment"),
  176. objectChanges: $changes
  177. );
  178. return $this->noContent();
  179. }
  180. public function pause(Request $request, string $id)
  181. {
  182. $project = Project::findOrFail($id);
  183. $project->status = ProjectStatus::PAUSE->value;
  184. $project->save();
  185. ActionRepository::createByProject($project, ObjectAction::PAUSED, $request->get("comment"));
  186. return $this->noContent();
  187. }
  188. /**
  189. * 延期
  190. *
  191. * @param PostponeRequest $request
  192. * @param string $id
  193. * @return \Illuminate\Http\Response
  194. */
  195. public function postpone(PostponeRequest $request, string $id)
  196. {
  197. $project = Project::findOrFail($id);
  198. $project->fill($request->only([
  199. 'begin', 'end'
  200. ]));
  201. $project->save();
  202. ActionRepository::createByProject($project, ObjectAction::DELAY, $request->get("comment"));
  203. return $this->noContent();
  204. }
  205. public function linkRequirement(LinkRequirementRequest $request, string $id)
  206. {
  207. $requirementIds = $request->get("requirement_id",[]);
  208. $project = Project::findOrFail($id);
  209. if(! $requirementIds){
  210. return $this->forbidden("Please select the correct requirement");
  211. }
  212. // $requirement = Requirement::findOrFail($request->requirement_id);
  213. // $exists = ProjectAsset::query()
  214. // ->where('project_id', $project->id)
  215. // ->where('asset_id', $requirement->asset_id)
  216. // ->count();
  217. // if (! $exists) {
  218. // return $this->forbidden("Please select the correct requirement");
  219. // }
  220. DB::transaction(function () use ($requirementIds,$project) {
  221. foreach ($requirementIds as $requirementId) {
  222. $requirement=Requirement::query()->where('id',$requirementId)->first();
  223. ProjectRequirement::query()->firstOrCreate([
  224. 'project_id' => $project->id,
  225. 'requirement_id' => $requirement->id,
  226. 'asset_id' => $requirement->asset_id,
  227. 'requirement_group_id'=> $requirement->requirement_group_id,
  228. ]);
  229. }
  230. });
  231. return $this->noContent();
  232. }
  233. public function unlinkRequirement(UnlinkRequirementRequest $request, string $id)
  234. {
  235. $requirementIds = $request->get("requirement_id",[]);
  236. $project = Project::findOrFail($id);
  237. if (! $requirementIds) {
  238. return $this->forbidden("Please select the correct requirement");
  239. }
  240. if($project->requirements->isEmpty()){
  241. return $this->forbidden("Project has no associated requirements");
  242. }
  243. DB::transaction(function () use ($requirementIds,$project) {
  244. foreach ($requirementIds as $requirement) {
  245. ProjectRequirement::query()->where([
  246. 'project_id' => $project->id,
  247. 'requirement_id' => $requirement,
  248. ])->delete();
  249. }
  250. });
  251. return $this->noContent();
  252. }
  253. public function linkRequirementByPlan(LinkRequirementByPlanRequest $request, string $id)
  254. {
  255. $project = Project::findOrFail($id);
  256. $plan = Plan::findOrFail($request->plan_id);
  257. foreach ($plan->requirements as $requirement) {
  258. ProjectRequirement::query()->firstOrCreate([
  259. 'project_id' => $project->id, 'requirement_id' => $requirement->id,
  260. ]);
  261. }
  262. return $this->noContent();
  263. }
  264. public function plan(string $id)
  265. {
  266. $project = Project::findOrFail($id);
  267. return SimplePlanResource::collection($project->plans);
  268. }
  269. public function requirement(Request $request,string $id)
  270. {
  271. $project = Project::findOrFail($id);
  272. // 初始化 requirements 的查询构建器
  273. $requirementsQuery = $project->requirements();
  274. if ($request->has('asset')) {
  275. $asset_id = $request->input('asset');
  276. $requirementsQuery->where('requirements.asset_id', $asset_id);
  277. }
  278. if ($request->has('requirementGroup')) {
  279. $requirementGroup = $request->input('requirementGroup');
  280. $requirementsQuery->where('requirements.requirement_group_id', $requirementGroup);
  281. }
  282. $requirements = $requirementsQuery
  283. ->with(['createdBy']) // 预加载 createdBy 关联
  284. ->simplePaginate();
  285. return ProjectRequirementResource::collection($requirements);
  286. }
  287. public function notLinkAssetRequirement(string $id)
  288. {
  289. $project = Project::findOrFail($id);
  290. $requirements = $project->assets
  291. ? Requirement::query()->whereIn('asset_id', $project->assets?->pluck('id')->toArray())->whereNotIn('id', $project->requirements?->pluck('id')->toArray())->simplePaginate()
  292. : [];
  293. return AssetRequirementResource::collection($requirements);
  294. }
  295. public function updateLinkAssets(UpdateLinkAssetsRequest $request,string $project_id)
  296. {
  297. $project = Project::find($project_id);
  298. if (is_null($project)){
  299. return $this->badRequest('project does not exist');
  300. }
  301. $assetsIds = $request->assets;
  302. DB::transaction(function () use ($project_id,$assetsIds) {
  303. ProjectAsset::where('project_id', $project_id)->delete();
  304. foreach ($assetsIds as $assetId) {
  305. ProjectAsset::create([
  306. 'project_id' => $project_id,
  307. 'asset_id' => $assetId,
  308. ]);
  309. }
  310. });
  311. return $this->noContent();
  312. }
  313. public function dynamic(Request $request, string $id)
  314. {
  315. $project = Project::findOrFail($id);
  316. return $this->success([
  317. 'data' => ActionRepository::dynamic($project, $request->all())
  318. ]);
  319. }
  320. public function kanban(Request $request, ProjectKanbanService $service, string $id)
  321. {
  322. $project = Project::findOrFail($id);
  323. return $this->success([
  324. 'data' => $service->kanban($project, $request->get("group", "requirement_asc"))
  325. ]);
  326. }
  327. public function groupView(Request $request, string $id)
  328. {
  329. $project = Project::findOrFail($id);
  330. $group = in_array(
  331. $request->get("group"),
  332. ['requirement_id','status','assign','finished_by','closed_by','task_type']
  333. ) ? $request->get("group") : "requirement_id";
  334. return $this->success([
  335. 'data' => (new ProjectTaskGroupViewService())->groupView($project, $group, $request->all())
  336. ]);
  337. }
  338. public function gantt(Request $request, string $id)
  339. {
  340. $project = Project::findOrFail($id);
  341. $group = in_array(
  342. $request->get("group"),
  343. ['requirement_id','assign','task_type']
  344. ) ? $request->get("group") : "task_type";
  345. return $this->success([
  346. 'data' => (new ProjectGanttService())->gantt($project, $group)
  347. ]);
  348. }
  349. public function printKanban(string $id)
  350. {
  351. $project = Project::findOrFail($id);
  352. return $this->success([
  353. 'data' => [
  354. 'requirements' => ProjectKanbanRequirementResource::collection($project->requirements),
  355. 'tasks' => ProjectKanbanTaskResource::collection($project->tasks),
  356. 'task_status' => TaskStatus::cases(),
  357. ]
  358. ]);
  359. }
  360. public function latestDynamic(string $id)
  361. {
  362. $project = Project::findOrFail($id);
  363. return $this->success([
  364. 'data' => ActionRepository::latestDynamic($project)
  365. ]);
  366. }
  367. }