springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/grid/EventVO.java
@@ -42,6 +42,9 @@ @ApiModelProperty(value = "网格员名字") private String gridMemberName; @ApiModelProperty(value = "网格员头像url") private String gridMemberImageUrl; @ApiModelProperty(value = "网格员联系方式") private String gridMemberTelephone; springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java
@@ -47,4 +47,10 @@ */ List<ComMapGridEventVO> getEventByGridId(@Param("gridId") Long gridId); /** * 根据网格员id查询网格员头像url * @param gridMemberId 网格员id * @return 头像url */ String getGridMemberImageUrl(@Param("gridMemberId") Long gridMemberId); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
@@ -127,6 +127,12 @@ eventVO.setAudios(audioList); eventVO.setPics(picList); eventVO.setVideos(videoList); //查询网格员头像 String imageUrl = eventMapper.getGridMemberImageUrl(eventVO.getGridMemberId()); if(StringUtils.isNotEmpty(imageUrl)){ eventVO.setGridMemberImageUrl(imageUrl); } }); return R.ok(ipage); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventMapper.xml
@@ -441,4 +441,8 @@ AND grid_id = #{gridId} </select> <select id="getGridMemberImageUrl" resultType="String"> select image_url from sys_user where user_id = #{gridMemberId} </select> </mapper>