查询A表以及与A表关联的中间关系表数据（和其他定制数据）

小灰灰 2024-03-17 12:00 16阅读 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);
    	}

/**
     * 任务节点关系表 服务类
     *
     * @author com.xhsoft
     * @since 2022-11-09
     */
    public interface ITaskJointService extends IService<TaskJoint> {
    
    	/**
    	 * 自定义分页
    	 *
    	 * @param page
    	 * @param taskJoint
    	 * @return
    	 */
    	IPage<TaskJointVO> selectTaskJointPage(IPage<TaskJointVO> page, TaskJointVO taskJoint);
    
    
    	/**
    	 * 查询任务节点
    	 * @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);
    	}
    
    
    }

import com.xhsoft.flange.entity.FlangeJoint;
    import com.xhsoft.task.entity.TaskInfo;
    import com.xhsoft.task.entity.TaskJoint;
    import com.xhsoft.task.vo.TaskJointVO;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import java.util.List;
    
    /**
     * 任务节点关系表 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);
    
    
    
    }

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.xhsoft.task.mapper.TaskJointMapper">
    
        
        <resultMap id="taskJointResultMap" type="com.xhsoft.task.entity.TaskJoint">
            <result column="id" property="id"/>
            <result column="project_id" property="projectId"/>
            <result column="task_id" property="taskId"/>
            <result column="joint_id" property="jointId"/>
            <result column="drawing_id" property="drawingId"/>
            <result column="start_status" property="startStatus"/>
            <result column="end_status" property="endStatus"/>
            <result column="is_submit" property="isSubmit"/>
            <result column="submit_time" property="submitTime"/>
            <result column="is_review" property="isReview"/>
            <result column="check_time" property="checkTime"/>
        </resultMap>
    
        
        <resultMap id="taskJointVOResultMap" type="com.xhsoft.task.vo.TaskJointVO">
            <result column="id" property="id"/>
            <result column="project_id" property="projectId"/>
            <result column="task_id" property="taskId"/>
            <result column="joint_id" property="jointId"/>
            <result column="joint_no" property="jointNo"/>
            <result column="pid" property="pid"/>
            <result column="package_no" property="packageNo"/>
            <result column="isometric_no" property="isometricNo"/>
            <result column="drawing_id" property="drawingId"/>
            <result column="start_status" property="startStatus"/>
            <result column="end_status" property="endStatus"/>
            <result column="is_submit" property="isSubmit"/>
            <result column="submit_time" property="submitTime"/>
            <result column="is_review" property="isReview"/>
            <result column="check_time" property="checkTime"/>
        </resultMap>
    
    
        <select id="selectTaskJointPage" resultMap="taskJointResultMap">
            select * from t_task_joint where is_deleted = 0
        </select>
    
        <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
            from
                t_task_joint tj
            left join
                t_flange_joint fj on tj.joint_id = fj.id
            left join
                t_drawing_joint dj on tj.joint_id = dj.joint_id
            where
                tj.task_id = #{id}
            order by
                package_no asc, joint_no asc
        </select>
    
    
    </mapper>

>     import com.xhsoft.task.entity.TaskJoint;
>     import io.swagger.annotations.ApiModelProperty;
>     import lombok.Data;
>     import lombok.EqualsAndHashCode;
>     import io.swagger.annotations.ApiModel;
>     
>     /**
>      * 任务节点关系表视图实体类
>      *
>      * @author com.xhsoft
>      * @since 2022-11-09
>      */
>     @Data
>     @EqualsAndHashCode(callSuper = true)
>     @ApiModel(value = "TaskJointVO对象", description = "任务节点关系表")
>     public class TaskJointVO extends TaskJoint {
>        private static final long serialVersionUID = 1L;
>     
>        /**
>         * 节点编号
>         */
>        private String jointNo;
>        /**
>         * PID
>         */
>        private String pid;
>        /**
>         * 包编号
>         */
>        private String packageNo;
>        /**
>         * 图纸编号
>         */
>        private String isometricNo;
>     
>     }