城管随手拍功能更新

101captain

2021-08-19 0c2960d08c43667338d4ce405c3c41202357eda8

城管随手拍功能更新

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java

@@ -338,6 +338,11 @@
    R putEasypHotoStatus(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO);

    /**
     * 城管随手拍统计
     */
    @PostMapping("/esayPhotoCount")
    R  esayphotoCount(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO);
    /**
     * 新增社区
     *
     * @param comActVO 社区信息

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityActivityApi.java

@@ -267,6 +267,12 @@
        return communityService.pageEasyPhoto(comActEasyPhotoVO);
    }

    @ApiOperation(value = "城管随手拍统计")
    @PostMapping("pageeasyphoto/urbanCount")
    public R pageEasyPhotoUrbanCount(@RequestBody ComActEasyPhotoVO comActEasyPhotoVO) {
        return communityService.esayphotoCount(comActEasyPhotoVO);
    }

    @ApiOperation(value = "随手拍详情", response = ComActEasyPhotoVO.class)
    @GetMapping("easyphoto")
    public R detailEasyPhoto(@RequestParam("id") Long id) {

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml

@@ -127,8 +127,18 @@
            AND del_tag = 0
    </select>

    <select id="easyPhotoCount" resultType="com.panzhihua.common.model.vos.community.ComActEasyPhotoCountVO">
            select
    <select id="easyPhotoCount" resultType="com.panzhihua.common.model.vos.community.easyPhoto.ComActEasyPhotoCountVO">
        select count(*) total,(select count(*) today from com_act_easy_photo where transfer_time BETWEEN DATE_FORMAT(CURDATE(),'%Y-%m-%d %H:%i:%s')  and DATE_ADD(CURRENT_DATE, INTERVAL 1 DAY)
       <if test="urbanStatus !=null">
        and urban_status=#{urbanStatus}
        </if>)
            today from com_act_easy_photo
        <where>
            1=1
            <if test="urbanStatus !=null">
                    and urban_status=#{urbanStatus}
            </if>
        </where>
    </select>

</mapper>