ProjectController.php 15 KB

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