ProjectController.php 16 KB

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