package com.ruoyi.web.controller.api; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.ruoyi.common.annotation.Log; import com.ruoyi.common.basic.PageInfo; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.common.utils.uuid.IdUtils; import com.ruoyi.framework.web.service.TokenService; import com.ruoyi.system.dto.ExperimentDispatchSignDTO; import com.ruoyi.system.dto.TExperimentDispatchDTO; import com.ruoyi.system.mapper.SysUserMapper; import com.ruoyi.system.model.*; import com.ruoyi.system.query.TExperimentDispatchQuery; import com.ruoyi.system.service.*; import com.ruoyi.system.vo.TExperimentDispatchVO; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import java.time.LocalDateTime; import java.util.List; import java.util.Objects; import java.util.stream.Collectors; /** *

* 实验调度管理 前端控制器 *

* * @author xiaochen * @since 2025-04-08 */ @Api(tags = "实验调度管理") @RestController @RequestMapping("") public class TExperimentDispatchController { private final TExperimentDispatchService experimentDispatchService; private final TokenService tokenService; private final ISysUserService sysUserService; private final SysUserMapper sysUserMapper; private final TExperimentDispatchGroupService experimentDispatchGroupService; private final TExperimentDispatchParticipantsService experimentDispatchParticipantsService; private final TExperimentDispatchTaskService experimentDispatchTaskService; private final TProjectTeamService projectTeamService; private final TProjectTeamStaffService projectTeamStaffService; private final TProjectProposalService projectProposalService; @Autowired public TExperimentDispatchController(TExperimentDispatchService experimentDispatchService, TokenService tokenService, ISysUserService sysUserService, SysUserMapper sysUserMapper, TExperimentDispatchGroupService experimentDispatchGroupService, TExperimentDispatchParticipantsService experimentDispatchParticipantsService, TExperimentDispatchTaskService experimentDispatchTaskService, TProjectTeamService projectTeamService, TProjectTeamStaffService projectTeamStaffService, TProjectProposalService projectProposalService) { this.experimentDispatchService = experimentDispatchService; this.tokenService = tokenService; this.sysUserService = sysUserService; this.sysUserMapper = sysUserMapper; this.experimentDispatchGroupService = experimentDispatchGroupService; this.experimentDispatchParticipantsService = experimentDispatchParticipantsService; this.experimentDispatchTaskService = experimentDispatchTaskService; this.projectTeamService = projectTeamService; this.projectTeamStaffService = projectTeamStaffService; this.projectProposalService = projectProposalService; } /** * 获取实验调度管理列表 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:list')") @ApiOperation(value = "获取实验调度分页列表",response = TExperimentDispatchQuery.class) @PostMapping(value = "/api/t-experiment-dispatch/pageList") public R> pageList(@RequestBody String param) { TExperimentDispatchQuery query = JSON.parseObject(param, TExperimentDispatchQuery.class); return R.ok(experimentDispatchService.pageList(query)); } /** * 添加实验调度管理 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:add')") @Log(title = "实验调度信息-新增实验调度", businessType = BusinessType.INSERT) @ApiOperation(value = "添加实验调度",response = TExperimentDispatchDTO.class) @PostMapping(value = "/api/t-experiment-dispatch/add") public R add(@RequestBody String param) { TExperimentDispatchDTO dto = JSON.parseObject(param,TExperimentDispatchDTO.class); // 通过当前用户查询项目组 Long userId = tokenService.getLoginUser().getUserId(); TProjectTeamStaff projectTeamStaff = projectTeamStaffService.getOne(Wrappers.lambdaQuery(TProjectTeamStaff.class) .eq(TProjectTeamStaff::getUserId, userId) .last("LIMIT 1")); if(Objects.isNull(projectTeamStaff)){ return R.fail("当前用户未分配项目组,无法创建项目课题方案"); } // 查询项目组 TProjectTeam projectTeam = projectTeamService.getById(projectTeamStaff.getTeamId()); if(Objects.isNull(projectTeam)){ return R.fail("项目组不存在"); } if(projectTeam.getStatus() == 2){ return R.fail("项目组已封存,无法创建项目课题方案"); } // 生成实验调度编号 String experimentCode = projectTeam.getTeamName() + "-EX"; // 查询上个项目课题方案的序号 long count = experimentDispatchService.count(Wrappers.lambdaQuery(TExperimentDispatch.class) .like(TExperimentDispatch::getExperimentCode, experimentCode)); experimentCode = experimentCode + String.format("%03d", count+1);; dto.setExperimentCode(experimentCode); experimentDispatchService.save(dto); // 添加实验分组 List experimentDispatchGroups = dto.getExperimentDispatchGroups(); for (TExperimentDispatchGroup experimentDispatchGroup : experimentDispatchGroups) { experimentDispatchGroup.setDispatchId(dto.getId()); } experimentDispatchGroupService.saveBatch(experimentDispatchGroups); // 添加参与人员 List experimentDispatchParticipants = dto.getExperimentDispatchParticipants(); experimentDispatchParticipants.forEach(experimentDispatchParticipant -> { experimentDispatchParticipant.setDispatchId(dto.getId()); }); experimentDispatchParticipantsService.saveBatch(experimentDispatchParticipants); // 添加实验任务 List experimentDispatchTasks = dto.getExperimentDispatchTasks(); experimentDispatchTasks.forEach(experimentDispatchTask -> { experimentDispatchTask.setDispatchId(dto.getId()); }); experimentDispatchTaskService.saveBatch(experimentDispatchTasks); return R.ok(); } /** * 修改实验调度 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:edit')") @Log(title = "实验调度信息-修改实验调度", businessType = BusinessType.UPDATE) @ApiOperation(value = "修改实验调度") @PostMapping(value = "/api/t-experiment-dispatch/update") public R update(@RequestBody String param) { TExperimentDispatchDTO dto = JSON.parseObject(param,TExperimentDispatchDTO.class); experimentDispatchService.updateById(dto); // 添加实验分组 experimentDispatchGroupService.remove(Wrappers.lambdaQuery(TExperimentDispatchGroup.class).eq(TExperimentDispatchGroup::getDispatchId, dto.getId())); List experimentDispatchGroups = dto.getExperimentDispatchGroups(); for (TExperimentDispatchGroup experimentDispatchGroup : experimentDispatchGroups) { experimentDispatchGroup.setDispatchId(dto.getId()); } experimentDispatchGroupService.saveBatch(experimentDispatchGroups); // 添加参与人员 experimentDispatchParticipantsService.remove(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class).eq(TExperimentDispatchParticipants::getDispatchId, dto.getId())); List experimentDispatchParticipants = dto.getExperimentDispatchParticipants(); experimentDispatchParticipants.forEach(experimentDispatchParticipant -> { experimentDispatchParticipant.setDispatchId(dto.getId()); }); experimentDispatchParticipantsService.saveBatch(experimentDispatchParticipants); // 添加实验任务 experimentDispatchTaskService.remove(Wrappers.lambdaQuery(TExperimentDispatchTask.class).eq(TExperimentDispatchTask::getDispatchId, dto.getId())); List experimentDispatchTasks = dto.getExperimentDispatchTasks(); experimentDispatchTasks.forEach(experimentDispatchTask -> { experimentDispatchTask.setDispatchId(dto.getId()); }); experimentDispatchTaskService.saveBatch(experimentDispatchTasks); return R.ok(); } /** * 查看实验调度详情 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:detail')") @ApiOperation(value = "查看实验调度详情") @GetMapping(value = "/open/t-experiment-dispatch/getDetailById") public R getDetailById(@RequestParam String id) { TExperimentDispatch experimentDispatch = experimentDispatchService.getById(id); TExperimentDispatchVO experimentDispatchVO = new TExperimentDispatchVO(); BeanUtils.copyProperties(experimentDispatch, experimentDispatchVO); // 查询项目课题 TProjectProposal proposal = projectProposalService.getById(experimentDispatch.getProposalId()); if(Objects.nonNull(proposal)){ experimentDispatchVO.setProjectName(proposal.getProjectName()); experimentDispatchVO.setProjectCode(proposal.getProjectCode()); experimentDispatchVO.setProjectStage(proposal.getProjectStage()); } // 查询组别 experimentDispatchVO.setExperimentDispatchGroups(experimentDispatchGroupService.list(Wrappers.lambdaQuery(TExperimentDispatchGroup.class).eq(TExperimentDispatchGroup::getDispatchId, id))); // 查询参与人员 List list = experimentDispatchParticipantsService.list(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class).eq(TExperimentDispatchParticipants::getDispatchId, id)); List userIds = list.stream().map(TExperimentDispatchParticipants::getUserId).collect(Collectors.toList()); if(!CollectionUtils.isEmpty(userIds)){ List sysUsers = sysUserMapper.selectUserByIds(userIds); list.forEach(tExperimentDispatchParticipant -> { SysUser sysUser = sysUsers.stream().filter(user -> user.getUserId().equals(tExperimentDispatchParticipant.getUserId())).findFirst().orElse(null); if(sysUser != null){ tExperimentDispatchParticipant.setNickName(sysUser.getNickName()); tExperimentDispatchParticipant.setAvatar(sysUser.getAvatar()); } }); } experimentDispatchVO.setExperimentDispatchParticipants(list); // 查询实验任务 experimentDispatchVO.setExperimentDispatchTasks(experimentDispatchTaskService.list(Wrappers.lambdaQuery(TExperimentDispatchTask.class).eq(TExperimentDispatchTask::getDispatchId, id))); return R.ok(experimentDispatchVO); } /** * 查询化验师的通过签字的实验调度 */ @ApiOperation(value = "查询化验师的通过签字的实验调度") @GetMapping(value = "/open/t-experiment-dispatch/chemistSignList") public R> chemistSignList() { Long userId = tokenService.getLoginUser().getUserId(); Integer roleType = tokenService.getLoginUser().getUser().getRoleType(); if(roleType != 4){ return R.fail("您不是化验师,无法查看"); } List experimentDispatchParticipants = experimentDispatchParticipantsService.list(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class) .eq(TExperimentDispatchParticipants::getRoleType, roleType) .eq(TExperimentDispatchParticipants::getUserId, userId) .eq(TExperimentDispatchParticipants::getStatus, 2)); if(CollectionUtils.isEmpty(experimentDispatchParticipants)){ return R.fail("您没有通过签字的实验调度"); } List dispatchIds = experimentDispatchParticipants.stream().map(TExperimentDispatchParticipants::getDispatchId).distinct().collect(Collectors.toList()); List experimentDispatches = experimentDispatchService.list(Wrappers.lambdaQuery(TExperimentDispatch.class) .in(TExperimentDispatch::getId, dispatchIds) .in(TExperimentDispatch::getStatus, 1, 2)); List proposalIds = experimentDispatches.stream().map(TExperimentDispatch::getProposalId).collect(Collectors.toList()); List list = projectProposalService.list(Wrappers.lambdaQuery(TProjectProposal.class).in(TProjectProposal::getId, proposalIds)); // 查询参与人员 List ids = experimentDispatches.stream().map(TExperimentDispatch::getId).collect(Collectors.toList()); if(!CollectionUtils.isEmpty(ids)){ List tExperimentDispatchParticipants = experimentDispatchParticipantsService.list(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class) .in(TExperimentDispatchParticipants::getDispatchId, ids)); List userIds = tExperimentDispatchParticipants.stream().map(TExperimentDispatchParticipants::getUserId).collect(Collectors.toList()); List sysUsers = sysUserMapper.selectUserByIds(userIds); tExperimentDispatchParticipants.forEach(tExperimentDispatchParticipant -> { SysUser sysUser = sysUsers.stream().filter(user -> user.getUserId().equals(tExperimentDispatchParticipant.getUserId())).findFirst().orElse(null); if(sysUser != null){ tExperimentDispatchParticipant.setNickName(sysUser.getNickName()); } }); experimentDispatches.forEach(experimentDispatch -> { list.stream().filter(projectProposal -> projectProposal.getId().equals(experimentDispatch.getProposalId())).findFirst().ifPresent(projectProposal -> { experimentDispatch.setProjectName(projectProposal.getProjectName()); }); List experimentDispatchParticipantsList = tExperimentDispatchParticipants.stream().filter(tExperimentDispatchParticipant -> tExperimentDispatchParticipant.getDispatchId().equals(experimentDispatch.getId())).collect(Collectors.toList()); String participantsName = experimentDispatchParticipantsList.stream().map(TExperimentDispatchParticipants::getNickName).collect(Collectors.joining(";")); experimentDispatch.setParticipantsName(participantsName); }); } return R.ok(experimentDispatches); } /** * 删除实验调度 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:delete')") @Log(title = "实验调度信息-删除实验调度", businessType = BusinessType.DELETE) @ApiOperation(value = "删除实验调度") @DeleteMapping(value = "/open/t-experiment-dispatch/deleteById") public R deleteById(@RequestParam String id) { // 删除组别 experimentDispatchGroupService.remove(Wrappers.lambdaQuery(TExperimentDispatchGroup.class).eq(TExperimentDispatchGroup::getDispatchId, id)); // 删除参与人员 experimentDispatchParticipantsService.remove(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class).eq(TExperimentDispatchParticipants::getDispatchId, id)); // 删除任务 experimentDispatchTaskService.remove(Wrappers.lambdaQuery(TExperimentDispatchTask.class).eq(TExperimentDispatchTask::getDispatchId, id)); return R.ok(experimentDispatchService.removeById(id)); } /** * 批量删除实验调度 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:delete')") @Log(title = "实验调度信息-删除实验调度", businessType = BusinessType.DELETE) @ApiOperation(value = "批量删除实验调度") @DeleteMapping(value = "/open/t-experiment-dispatch/deleteByIds") public R deleteByIds(@RequestBody List ids) { // 删除组别 experimentDispatchGroupService.remove(Wrappers.lambdaQuery(TExperimentDispatchGroup.class).in(TExperimentDispatchGroup::getDispatchId, ids)); // 删除参与人员 experimentDispatchParticipantsService.remove(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class).in(TExperimentDispatchParticipants::getDispatchId, ids)); // 删除任务 experimentDispatchTaskService.remove(Wrappers.lambdaQuery(TExperimentDispatchTask.class).in(TExperimentDispatchTask::getDispatchId, ids)); return R.ok(experimentDispatchService.removeByIds(ids)); } /** * 批量删除实验调度 */ //@PreAuthorize("@ss.hasPermi('system:experimentDispatch:sign')") @Log(title = "实验调度信息-实验调度签字", businessType = BusinessType.UPDATE) @ApiOperation(value = "实验调度签字",response = ExperimentDispatchSignDTO.class) @PostMapping(value = "/api/t-experiment-dispatch/sign") public R sign(@RequestBody String param) { ExperimentDispatchSignDTO experimentDispatchSign = JSON.parseObject(param, ExperimentDispatchSignDTO.class); Long userId = tokenService.getLoginUser().getUserId(); Integer roleType = tokenService.getLoginUser().getUser().getRoleType(); TExperimentDispatchParticipants experimentDispatchParticipants = experimentDispatchParticipantsService.getOne(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class) .eq(TExperimentDispatchParticipants::getDispatchId, experimentDispatchSign.getDispatchId()) .eq(TExperimentDispatchParticipants::getRoleType, roleType) .eq(TExperimentDispatchParticipants::getUserId, userId) .last("LIMIT 1")); if(experimentDispatchParticipants != null){ experimentDispatchParticipants.setStatus(2); experimentDispatchParticipants.setSignTime(LocalDateTime.now()); experimentDispatchParticipants.setConfirmSign(experimentDispatchSign.getConfirmSign()); experimentDispatchParticipantsService.updateById(experimentDispatchParticipants); } long count = experimentDispatchParticipantsService.count(Wrappers.lambdaQuery(TExperimentDispatchParticipants.class) .eq(TExperimentDispatchParticipants::getDispatchId, experimentDispatchSign.getDispatchId()) .in(TExperimentDispatchParticipants::getRoleType, 4, 5) .eq(TExperimentDispatchParticipants::getStatus, 1)); if(count == 0){ TExperimentDispatch tExperimentDispatch = experimentDispatchService.getById(experimentDispatchSign.getDispatchId()); tExperimentDispatch.setStatus(2); experimentDispatchService.updateById(tExperimentDispatch); } return R.ok(); } }