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();
}
}