mybatispus分页返回map数据

Love The Way You Lie 2022-12-19 00:45 112阅读 0赞

# 1:controller层 #

@PostMapping("/unionList")
    	public ResultBean unionList(HttpServletRequest request,Integer id,Integer pageNum,Integer pageSize){
    		Map<String,Object> map = new HashMap<>();
    		FdmUserCompany fdmUserCompany = generateToken.getAppLoginUser(request);
    		String userId = fdmUserCompany.getId();//用户ID
    		IPage<FdmUnion> page = new Page<>(pageNum,pageSize);
    		QueryWrapper<Map<String,Object>> queryWrapper = new QueryWrapper<>();
    		queryWrapper.eq(ToolUtil.isNotEmpty(id),"id",id);
    		IPage<Map<String,Object>> iPage = fdmUnionDetailMapper.selectFdmUnionDetailListPage(page,queryWrapper,userId);
    		map.put("iPage",iPage);
    		return setResultSuccess(map);
    	}

# 2:mapper层 #

IPage<Map<String, Object>> selectFdmUnionDetailListPage(IPage<FdmUnion> page, @Param(Constants.WRAPPER) QueryWrapper<Map<String, Object>> queryWrapper,@Param("userId")String userId);

# 3:xml #

<select id="selectFdmUnionDetailListPage" resultType="java.util.Map">
            SELECT
               a.id as workId,a.content,b.id as id,b.name,b.img,b.sheng,b.shi,b.qu,b.longitude,b.latitude,
               case when c.userId is null  THEN 5-- 可以申请
                    when c.userId is not null and c.state=1 and c.type=1 THEN 1-- 会长
                    when c.userId is not null and c.state=1 and c.type=2 THEN 2-- 待审核
                    when c.userId is not null and c.state=2 and c.type=2 THEN 3-- 审核通过
                    when c.userId is not null and c.state=3 and c.type=2 THEN 4-- 被拒绝
               end as type
            FROM fdm_work_template_type a
            inner join fdm_union b on a.id = b.workId
            left join fdm_union_detail c on b.id = c.unionId and c.userId = #{userId}
            ${ew.customSqlSegment}
        </select>