查询任务表下所有关联的节点表，节点表与任务表有中间关系表（定制列表内容）

╰+哭是因爲堅強的太久メ 2024-03-17 12:08 69阅读 0赞

/**
    	 * 详情
    	 */
    	@GetMapping("/detail")
    	@ApiOperationSupport(order = 1)
    	@ApiOperation(value = "详情", notes = "传入taskInfo")
    	public R<TaskInfo> detail(TaskInfo taskInfo) {
    		TaskInfo detail = taskInfoService.getOne(Condition.getQueryWrapper(taskInfo));
    
    		TaskInfoVO vo = JSON.parseObject(JSON.toJSONString(detail), TaskInfoVO.class);
    		List<TaskJointVO> joints = taskJointService.selectTaskJoint(detail);
    		vo.setJoints(joints);
    
    		return R.data(vo);
    	}

/**
    	 * 查询任务节点
    	 * @param taskInfo
    	 * @return
    	 */
    	List<TaskJointVO> selectTaskJoint(TaskInfo taskInfo);

/**
     * 任务节点关系表 服务实现类
     *
     * @author com.xhsoft
     * @since 2022-11-09
     */
    @Service
    public class TaskJointServiceImpl extends ServiceImpl<TaskJointMapper, TaskJoint> implements ITaskJointService {
    
    	@Override
    	public IPage<TaskJointVO> selectTaskJointPage(IPage<TaskJointVO> page, TaskJointVO taskJoint) {
    		return page.setRecords(baseMapper.selectTaskJointPage(page, taskJoint));
    	}
    
    	/**
    	 * 查询任务节点
    	 * @param taskInfo
    	 * @return
    	 */
    	public List<TaskJointVO> selectTaskJoint(TaskInfo taskInfo){
    		return baseMapper.selectTaskJoint(taskInfo);
    	}

/**
     * 任务节点关系表 Mapper 接口
     *
     * @author com.xhsoft
     * @since 2022-11-09
     */
    public interface TaskJointMapper extends BaseMapper<TaskJoint> {
    
    	/**
    	 * 自定义分页
    	 *
    	 * @param page
    	 * @param taskJoint
    	 * @return
    	 */
    	List<TaskJointVO> selectTaskJointPage(IPage page, TaskJointVO taskJoint);
    
    	/**
    	 * 查询任务节点
    	 * @param taskInfo
    	 * @return
    	 */
    	List<TaskJointVO> selectTaskJoint(TaskInfo taskInfo);
    
    
    
    }

<select id="selectTaskJoint" resultMap="taskJointVOResultMap">
            select
                tj.id,
                tj.project_id,
                tj.task_id,
                tj.joint_id,
                tj.start_status,
                tj.end_status,
                tj.is_submit,
                tj.submit_time,
                tj.is_review,
                tj.check_time,
                dj.drawing_id,
                fj.joint_no,
                fj.package_no,
                fj.pid,
                fj.isometric_no
            f