ProjectController.php 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474
  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. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  127. $project->save();
  128. ActionRepository::createByProject($project, ObjectAction::EDITED, objectChanges: $changes);
  129. if ($request->has("assets")) {
  130. ProjectAsset::where('project_id', $project->id)->delete();
  131. foreach ($request->get("assets", []) as $assetId) {
  132. ProjectAsset::create([
  133. 'project_id' => $project->id,
  134. 'asset_id' => $assetId,
  135. ]);
  136. }
  137. }
  138. if ($request->has("plans")) {
  139. ProjectPlan::where('project_id', $project->id)->delete();
  140. foreach ($request->get("plans", []) as $planId) {
  141. ProjectPlan::create([
  142. 'project_id' => $project->id,
  143. 'plan_id' => $planId,
  144. ]);
  145. }
  146. }
  147. return $this->noContent();
  148. }
  149. /**
  150. * Remove the specified resource from storage.
  151. */
  152. public function destroy(string $id)
  153. {
  154. $project = Project::findOrFail($id);
  155. $project->delete();
  156. ActionRepository::createByProject($project, ObjectAction::DELETED);
  157. return $this->noContent();
  158. }
  159. public function closed(Request $request, string $id)
  160. {
  161. $project = Project::findOrFail($id);
  162. $project->status = ProjectStatus::CLOSED->value;
  163. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  164. $project->save();
  165. ActionRepository::createByProject(
  166. $project, ObjectAction::CLOSED, $request->get("comment"), objectChanges: $changes
  167. );
  168. return $this->noContent();
  169. }
  170. public function start(Request $request, string $id)
  171. {
  172. $project = Project::findOrFail($id);
  173. $project->status = ProjectStatus::DOING->value;
  174. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  175. $project->save();
  176. ActionRepository::createByProject(
  177. $project,
  178. ObjectAction::STARTED,
  179. $request->get("comment"),
  180. objectChanges: $changes
  181. );
  182. return $this->noContent();
  183. }
  184. public function pause(Request $request, string $id)
  185. {
  186. $project = Project::findOrFail($id);
  187. $project->status = ProjectStatus::PAUSE->value;
  188. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  189. $project->save();
  190. ActionRepository::createByProject(
  191. $project, ObjectAction::PAUSED, $request->get("comment"), objectChanges: $changes
  192. );
  193. return $this->noContent();
  194. }
  195. /**
  196. * 延期
  197. *
  198. * @param PostponeRequest $request
  199. * @param string $id
  200. * @return \Illuminate\Http\Response
  201. */
  202. public function postpone(PostponeRequest $request, string $id)
  203. {
  204. $project = Project::findOrFail($id);
  205. $project->fill($request->only([
  206. 'begin', 'end'
  207. ]));
  208. $changes = ModelChangeDetector::detector(ActionObjectType::PROJECT, $project);
  209. $project->save();
  210. ActionRepository::createByProject(
  211. $project, ObjectAction::DELAY, $request->get("comment"), objectChanges: $changes
  212. );
  213. return $this->noContent();
  214. }
  215. public function linkRequirement(LinkRequirementRequest $request, string $id)
  216. {
  217. $requirementIds = $request->get("requirement_id",[]);
  218. $project = Project::findOrFail($id);
  219. if(! $requirementIds){
  220. return $this->forbidden("Please select the correct requirement");
  221. }
  222. // $requirement = Requirement::findOrFail($request->requirement_id);
  223. // $exists = ProjectAsset::query()
  224. // ->where('project_id', $project->id)
  225. // ->where('asset_id', $requirement->asset_id)
  226. // ->count();
  227. // if (! $exists) {
  228. // return $this->forbidden("Please select the correct requirement");
  229. // }
  230. DB::transaction(function () use ($requirementIds,$project) {
  231. foreach ($requirementIds as $requirementId) {
  232. $requirement=Requirement::query()->where('id',$requirementId)->first();
  233. ProjectRequirement::query()->firstOrCreate([
  234. 'project_id' => $project->id,
  235. 'requirement_id' => $requirement->id,
  236. 'asset_id' => $requirement->asset_id,
  237. 'requirement_group_id'=> $requirement->requirement_group_id,
  238. ]);
  239. }
  240. });
  241. return $this->noContent();
  242. }
  243. public function unlinkRequirement(UnlinkRequirementRequest $request, string $id)
  244. {
  245. $requirementIds = $request->get("requirement_id",[]);
  246. $project = Project::findOrFail($id);
  247. if (! $requirementIds) {
  248. return $this->forbidden("Please select the correct requirement");
  249. }
  250. if($project->requirements->isEmpty()){
  251. return $this->forbidden("Project has no associated requirements");
  252. }
  253. DB::transaction(function () use ($requirementIds,$project) {
  254. foreach ($requirementIds as $requirement) {
  255. ProjectRequirement::query()->where([
  256. 'project_id' => $project->id,
  257. 'requirement_id' => $requirement,
  258. ])->delete();
  259. }
  260. });
  261. return $this->noContent();
  262. }
  263. public function linkRequirementByPlan(LinkRequirementByPlanRequest $request, string $id)
  264. {
  265. $project = Project::findOrFail($id);
  266. $plan = Plan::findOrFail($request->plan_id);
  267. foreach ($plan->requirements as $requirement) {
  268. ProjectRequirement::query()->firstOrCreate([
  269. 'project_id' => $project->id, 'requirement_id' => $requirement->id,
  270. ]);
  271. }
  272. return $this->noContent();
  273. }
  274. public function plan(string $id)
  275. {
  276. $project = Project::findOrFail($id);
  277. return SimplePlanResource::collection($project->plans);
  278. }
  279. public function requirement(Request $request,string $id)
  280. {
  281. $project = Project::findOrFail($id);
  282. // 初始化 requirements 的查询构建器
  283. $requirementsQuery = $project->requirements();
  284. if ($request->has('asset')) {
  285. $asset_id = $request->input('asset');
  286. $requirementsQuery->where('requirements.asset_id', $asset_id);
  287. }
  288. if ($request->has('requirementGroup')) {
  289. $requirementGroup = $request->input('requirementGroup');
  290. $requirementsQuery->where('requirements.requirement_group_id', $requirementGroup);
  291. }
  292. $requirements = $requirementsQuery
  293. ->with(['createdBy']) // 预加载 createdBy 关联
  294. ->simplePaginate();
  295. return ProjectRequirementResource::collection($requirements);
  296. }
  297. public function notLinkAssetRequirement(string $id)
  298. {
  299. $project = Project::findOrFail($id);
  300. $requirements = $project->assets
  301. ? Requirement::query()->whereIn('asset_id', $project->assets?->pluck('id')->toArray())->whereNotIn('id', $project->requirements?->pluck('id')->toArray())->simplePaginate()
  302. : [];
  303. return AssetRequirementResource::collection($requirements);
  304. }
  305. public function updateLinkAssets(UpdateLinkAssetsRequest $request,string $project_id)
  306. {
  307. $project = Project::find($project_id);
  308. if (is_null($project)){
  309. return $this->badRequest('project does not exist');
  310. }
  311. $assetsIds = $request->assets;
  312. DB::transaction(function () use ($project_id,$assetsIds) {
  313. ProjectAsset::where('project_id', $project_id)->delete();
  314. foreach ($assetsIds as $assetId) {
  315. ProjectAsset::create([
  316. 'project_id' => $project_id,
  317. 'asset_id' => $assetId,
  318. ]);
  319. }
  320. });
  321. return $this->noContent();
  322. }
  323. public function dynamic(Request $request, string $id)
  324. {
  325. $project = Project::findOrFail($id);
  326. return $this->success([
  327. 'data' => ActionRepository::dynamic($project, $request->all())
  328. ]);
  329. }
  330. public function kanban(Request $request, ProjectKanbanService $service, string $id)
  331. {
  332. $project = Project::findOrFail($id);
  333. return $this->success([
  334. 'data' => $service->kanban($project, $request->get("group", "requirement_asc"))
  335. ]);
  336. }
  337. public function groupView(Request $request, string $id)
  338. {
  339. $project = Project::findOrFail($id);
  340. $group = in_array(
  341. $request->get("group"),
  342. ['requirement_id','status','assign','finished_by','closed_by','task_type']
  343. ) ? $request->get("group") : "requirement_id";
  344. return $this->success([
  345. 'data' => (new ProjectTaskGroupViewService())->groupView($project, $group, $request->all())
  346. ]);
  347. }
  348. public function gantt(Request $request, string $id)
  349. {
  350. $project = Project::findOrFail($id);
  351. $group = in_array(
  352. $request->get("group"),
  353. ['requirement_id','assign','task_type']
  354. ) ? $request->get("group") : "task_type";
  355. return $this->success([
  356. 'data' => (new ProjectGanttService())->gantt($project, $group)
  357. ]);
  358. }
  359. public function printKanban(string $id)
  360. {
  361. $project = Project::findOrFail($id);
  362. return $this->success([
  363. 'data' => [
  364. 'requirements' => ProjectKanbanRequirementResource::collection($project->requirements),
  365. 'tasks' => ProjectKanbanTaskResource::collection($project->tasks),
  366. 'task_status' => TaskStatus::cases(),
  367. ]
  368. ]);
  369. }
  370. public function latestDynamic(string $id)
  371. {
  372. $project = Project::findOrFail($id);
  373. return $this->success([
  374. 'data' => ActionRepository::latestDynamic($project)
  375. ]);
  376. }
  377. }