新增网格员详情查询

zhongrj

2023-12-23 a00d28306e1892e516e451fe060f2c019cb2f637

新增网格员详情查询

 src/main/java/org/springblade/modules/grid/controller/GridmanController.java

@@ -62,6 +62,14 @@
        GridmanEntity detail = gridmanService.getOne(Condition.getQueryWrapper(gridman));
        return R.data(GridmanWrapper.build().entityVO(detail));
    }

    /**
     * 网格员表 自定义详情
     */
    @GetMapping("/getDetail")
    public R<GridmanVO> getDetail(GridmanEntity gridman) {
        return R.data(gridmanService.getDetail(gridman));
    }
    /**
     * 网格员表 分页
     */

 src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.java

@@ -51,4 +51,9 @@
    Integer getGridStatistics(String code, Long userId);

    Integer getCompanyStatistics(String code, Long userId);

    /**
     * 网格员表 自定义详情
     */
    GridmanVO getDetail(@Param("gridman") GridmanEntity gridman);
}

 src/main/java/org/springblade/modules/grid/mapper/GridmanMapper.xml

@@ -103,4 +103,13 @@
    </select>


    <!--网格员表 自定义详情-->
    <select id="getDetail" resultType="org.springblade.modules.grid.vo.GridmanVO">
        select
        jgm.*,jg.community_code communityCode
        from jczz_gridman jgm
        left join jczz_grid jg on jg.id = jgm.grid_id and jg.is_deleted = 0
        where jgm.is_deleted = 0
        and jgm.id = #{gridman.id}
    </select>
</mapper>

 src/main/java/org/springblade/modules/grid/service/IGridmanService.java

@@ -64,4 +64,9 @@
    List<GridmanVO> getGridmanList(GridmanVO gridman);

    Object getGridStatistics(String code, String roleType);

    /**
     * 网格员表 自定义详情
     */
    GridmanVO getDetail(GridmanEntity gridman);
}

 src/main/java/org/springblade/modules/grid/service/impl/GridmanServiceImpl.java

@@ -195,4 +195,12 @@
        }
        return objectObjectHashMap;
    }

    /**
     * 网格员表 自定义详情
     */
    @Override
    public GridmanVO getDetail(GridmanEntity gridman) {
        return baseMapper.getDetail(gridman);
    }
}