springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/grid/GridEventStatisticsDTO.java
New file @@ -0,0 +1,19 @@ package com.panzhihua.common.model.dtos.grid; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @Data @ApiModel("统计模块-网格事件统计请求参数") public class GridEventStatisticsDTO { @ApiModelProperty("网格id") private Long gridId; @ApiModelProperty("查询开始时间") private String startTime; @ApiModelProperty("查询结束时间") private String endTime; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/grid/GridEventStatisticsDetailVO.java
New file @@ -0,0 +1,71 @@ package com.panzhihua.common.model.vos.grid; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; /** * 地图模块-网格事件统计数据 */ @Data @ApiModel("统计模块-网格事件统计数据") public class GridEventStatisticsDetailVO { @ApiModelProperty("总完成数量") private Integer sum = 0; @ApiModelProperty("总未完成数量") private Integer noSum = 0; @ApiModelProperty("突发事件完成数量") private Integer eventTFTotal = 0; @ApiModelProperty("突发事件未完成数量") private Integer noEventTFTotal = 0; @ApiModelProperty("矛盾纠纷完成数量") private Integer eventMDTotal = 0; @ApiModelProperty("矛盾纠纷未完成数量") private Integer noEventMDTotal = 0; @ApiModelProperty("治安隐患完成数量") private Integer eventZATotal = 0; @ApiModelProperty("治安隐患未完成数量") private Integer noEventZATotal = 0; @ApiModelProperty("不稳定因素完成数量") private Integer eventBWDTotal = 0; @ApiModelProperty("不稳定因素未完成数量") private Integer noEventBWDTotal = 0; @ApiModelProperty("特殊人员上报完成数量") private Integer eventTSTotal = 0; @ApiModelProperty("特殊人员上报未完成数量") private Integer noEventTSTotal = 0; @ApiModelProperty("公共服务完成数量") private Integer eventGGTotal = 0; @ApiModelProperty("公共服务未完成数量") private Integer noEventGGTotal = 0; @ApiModelProperty("走访任务完成数量") private Integer eventZFTotal = 0; @ApiModelProperty("走访任务未完成数量") private Integer noEventZFTotal = 0; @ApiModelProperty("随手拍完成数量") private Integer eventSSPTotal = 0; @ApiModelProperty("随手拍未完成数量") private Integer noEventSSPTotal = 0; @ApiModelProperty("宣传教育发布数量") private Integer eventXCTotal = 0; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/grid/GridEventStatisticsVO.java
New file @@ -0,0 +1,37 @@ package com.panzhihua.common.model.vos.grid; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; /** * 地图模块-网格详细信息 */ @Data @ApiModel("统计模块-网格统计数据") public class GridEventStatisticsVO { @ApiModelProperty("今日完成") private Integer todayNum = 0; @ApiModelProperty("本月完成") private Integer monthNum = 0; @ApiModelProperty("今日发布宣传教育") private Integer todayEducationNum = 0; @ApiModelProperty("总发布宣传教育") private Integer educationNum = 0; @ApiModelProperty("今日特殊人群上报") private Integer todaySpecialTotal = 0; @ApiModelProperty("总特殊人群上报") private Integer specialTotal = 0; @ApiModelProperty("实有房屋总数") private Integer houseTotal = 0; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/grid/GridService.java
@@ -821,4 +821,20 @@ */ @PostMapping("/statistics/admin/gridMemberStatistics") R gridMemberStatistics(@RequestBody MemberStatisticsAdminDTO statisticsAdminDTO); /** * 根据网格id查询网格统计数据 * @param gridId 网格id * @return 网格统计数据 */ @PostMapping("/statistics/getGridEventStatistics") R getGridEventStatisticsByApp(@RequestParam("gridId") Long gridId); /** * 查询网格事件统计数据 * @param statisticsDTO 请求参数 * @return 网格事件统计数据 */ @PostMapping("/statistics/event/getGridEventStatistics") R getGridEventDetailStatisticsByApp(@RequestBody GridEventStatisticsDTO statisticsDTO); } springcloud_k8s_panzhihuazhihuishequ/grid_app/src/main/java/com/panzhihua/grid_app/api/StatisticsApi.java
@@ -1,15 +1,15 @@ package com.panzhihua.grid_app.api; import com.panzhihua.common.controller.BaseController; import com.panzhihua.common.model.dtos.grid.GridEventStatisticsDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.grid.ComMapGridDetailVO; import com.panzhihua.common.model.vos.grid.GridEventStatisticsDetailVO; import com.panzhihua.common.model.vos.grid.GridEventStatisticsVO; import com.panzhihua.common.service.grid.GridService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @@ -21,13 +21,22 @@ @Resource private GridService gridService; @ApiOperation(value = "根据网格id查询统计详情-lyq",response = ComMapGridDetailVO.class) @ApiOperation(value = "根据网格id查询统计详情-lyq",response = GridEventStatisticsVO.class) @PostMapping("event") public R getGridDetail(@RequestParam("gridId") Long gridId){ if(gridId == null){ return R.fail("参数错误"); } return null; return gridService.getGridEventStatisticsByApp(gridId); } @ApiOperation(value = "网格id查询统计事件详情-lyq",response = GridEventStatisticsDetailVO.class) @PostMapping("event/detail") public R getGridEventDetailStatistics(@RequestBody GridEventStatisticsDTO statisticsDTO){ if(statisticsDTO == null || statisticsDTO.getGridId() == null){ return R.fail("参数错误"); } return gridService.getGridEventDetailStatisticsByApp(statisticsDTO); }
@@ -1,5 +1,6 @@ package com.panzhihua.service_grid.api; import com.panzhihua.common.model.dtos.grid.GridEventStatisticsDTO; import com.panzhihua.common.model.dtos.grid.MemberStatisticsAdminDTO; import com.panzhihua.common.model.vos.R; import com.panzhihua.service_grid.service.EventService; @@ -35,4 +36,24 @@ public R gridMemberStatistics(@RequestBody MemberStatisticsAdminDTO statisticsAdminDTO){ return eventService.gridMemberStatistics(statisticsAdminDTO); } /** * 根据网格id查询网格统计数据 * @param gridId 网格id * @return 网格统计数据 */ @PostMapping("/getGridEventStatistics") public R getGridEventStatisticsByApp(@RequestParam("gridId") Long gridId){ return eventService.getGridEventStatisticsByApp(gridId); } /** * 查询网格事件统计数据 * @param statisticsDTO 请求参数 * @return 网格事件统计数据 */ @PostMapping("/event/getGridEventStatistics") public R getGridEventDetailStatisticsByApp(@RequestBody GridEventStatisticsDTO statisticsDTO){ return eventService.getGridEventDetailStatisticsByApp(statisticsDTO); } } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/dao/EventMapper.java
@@ -5,11 +5,8 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.dtos.grid.*; import com.panzhihua.common.model.vos.grid.ComMapGridEventVO; import com.panzhihua.common.model.vos.grid.EventStatisticsAllAdminVO; import com.panzhihua.common.model.vos.grid.EventStatisticsMemberAdminVO; import com.panzhihua.common.model.vos.grid.*; import com.panzhihua.service_grid.model.dos.EventDO; import com.panzhihua.common.model.vos.grid.EventVO; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -79,4 +76,18 @@ EventStatisticsAllAdminVO eventStatistics(@Param("communityId") Long communityId); Integer getEventCountByGridIds(@Param("ids") List<Long> ids); /** * 根据网格id查询网格统计数据 * @param gridId 网格id * @return 网格统计数据 */ GridEventStatisticsVO getGridEventStatisticsByApp(@Param("gridId") Long gridId); /** * 查询网格事件统计数据 * @param statisticsDTO 请求参数 * @return 网格事件统计数据 */ GridEventStatisticsDetailVO getGridEventDetailStatisticsByApp(@Param("statisticsDTO") GridEventStatisticsDTO statisticsDTO); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/EventService.java
@@ -191,4 +191,18 @@ * @return 网格员统计信息 */ R gridMemberStatistics(MemberStatisticsAdminDTO statisticsAdminDTO); /** * 根据网格id查询网格统计数据 * @param gridId 网格id * @return 网格统计数据 */ R getGridEventStatisticsByApp(Long gridId); /** * 查询网格事件统计数据 * @param statisticsDTO 请求参数 * @return 网格事件统计数据 */ R getGridEventDetailStatisticsByApp(GridEventStatisticsDTO statisticsDTO); } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/java/com/panzhihua/service_grid/service/impl/EventServiceImpl.java
@@ -11,10 +11,7 @@ import com.panzhihua.common.model.dtos.grid.*; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.ComActVO; import com.panzhihua.common.model.vos.grid.EventDetailsVO; import com.panzhihua.common.model.vos.grid.EventResourceVO; import com.panzhihua.common.model.vos.grid.EventTransferRecordVO; import com.panzhihua.common.model.vos.grid.EventVO; import com.panzhihua.common.model.vos.grid.*; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.utlis.StringUtils; import com.panzhihua.service_grid.dao.*; @@ -1622,4 +1619,52 @@ public R gridMemberStatistics(MemberStatisticsAdminDTO statisticsAdminDTO){ return R.ok(eventGridMemberRelationMapper.gridMemberStatistics(new Page(statisticsAdminDTO.getPageNum(),statisticsAdminDTO.getPageSize()),statisticsAdminDTO)); } /** * 根据网格id查询网格统计数据 * @param gridId 网格id * @return 网格统计数据 */ @Override public R getGridEventStatisticsByApp(Long gridId){ return R.ok(this.baseMapper.getGridEventStatisticsByApp(gridId)); } /** * 查询网格事件统计数据 * @param statisticsDTO 请求参数 * @return 网格事件统计数据 */ @Override public R getGridEventDetailStatisticsByApp(GridEventStatisticsDTO statisticsDTO){ GridEventStatisticsDetailVO statisticsDetailVO = this.baseMapper.getGridEventDetailStatisticsByApp(statisticsDTO); if(statisticsDetailVO == null){ statisticsDetailVO = new GridEventStatisticsDetailVO(); } if(statisticsDetailVO.getEventSSPTotal() == null){ statisticsDetailVO.setEventSSPTotal(0); } if(statisticsDetailVO.getNoEventSSPTotal() == null){ statisticsDetailVO.setNoEventSSPTotal(0); } if(statisticsDetailVO.getEventZFTotal() == null){ statisticsDetailVO.setEventZFTotal(0); } if(statisticsDetailVO.getNoEventZFTotal() == null){ statisticsDetailVO.setNoEventZFTotal(0); } //统计数据 Integer sum = statisticsDetailVO.getEventTFTotal() + statisticsDetailVO.getEventMDTotal() + statisticsDetailVO.getEventZATotal() + statisticsDetailVO.getEventBWDTotal() + statisticsDetailVO.getEventTSTotal() + statisticsDetailVO.getEventGGTotal() + statisticsDetailVO.getEventXCTotal() + statisticsDetailVO.getEventSSPTotal() + statisticsDetailVO.getEventZFTotal(); statisticsDetailVO.setSum(sum); Integer noSum = statisticsDetailVO.getNoEventTFTotal() + statisticsDetailVO.getNoEventMDTotal() + statisticsDetailVO.getNoEventZATotal() + statisticsDetailVO.getNoEventBWDTotal() + statisticsDetailVO.getNoEventTSTotal() + statisticsDetailVO.getNoEventGGTotal() + statisticsDetailVO.getNoEventSSPTotal() + statisticsDetailVO.getNoEventZFTotal(); statisticsDetailVO.setNoSum(noSum); return R.ok(statisticsDetailVO); } } springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventMapper.xml
@@ -550,4 +550,317 @@ </foreach> </select> <select id="getGridEventStatisticsByApp" resultType="com.panzhihua.common.model.vos.grid.GridEventStatisticsVO"> SELECT count( id ) AS todayNum, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_process_status = 2 AND create_at BETWEEN DATE_FORMAT( DATE_ADD( curdate(), INTERVAL - DAY ( curdate())+ 1 DAY ), '%Y-%m-%d %H:%i:%s' ) AND NOW() <if test="gridId!=null"> AND grid_id = #{gridId} </if> ) AS monthNum, ( SELECT count( id ) FROM `event` WHERE event_category = 2 AND event_status = 2 AND create_at BETWEEN DATE_FORMAT( CURDATE(), '%Y-%m-%d %H:%i:%s' ) AND NOW() <if test="gridId!=null"> AND grid_id = #{gridId} </if> ) AS todayEducationNum, ( SELECT count( id ) FROM `event` WHERE event_category = 2 AND event_status = 2 ) AS educationNum, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND event_process_status = 2 AND create_at BETWEEN DATE_FORMAT( CURDATE(), '%Y-%m-%d %H:%i:%s' ) AND NOW() <if test="gridId!=null"> AND grid_id = #{gridId} </if> ) AS todaySpecialTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_status = 2 AND event_process_status = 2 ) AS specialTotal FROM `event` WHERE event_category = 1 AND event_process_status = 2 AND create_at BETWEEN DATE_FORMAT( CURDATE(), '%Y-%m-%d %H:%i:%s' ) AND NOW() <if test="gridId!=null"> AND grid_id = #{gridId} </if> </select> <select id="getGridEventDetailStatisticsByApp" parameterType="com.panzhihua.common.model.dtos.grid.GridEventStatisticsDTO" resultType="com.panzhihua.common.model.vos.grid.GridEventStatisticsDetailVO"> SELECT count( e.id ) AS eventTFTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 5 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventTFTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventMDTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 3 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventMDTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventZATotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 1 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventZATotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventBWDTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 4 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventBWDTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventTSTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 6 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventTSTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventGGTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 1 AND event_type = 2 AND event_process_status IN ( 1, 3 ) AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventGGTotal, ( SELECT count( id ) FROM `event` WHERE event_category = 2 AND event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventXCTotal, ( SELECT count( id ) FROM event_visiting_tasks WHERE event_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventZFTotal, ( SELECT count( id ) FROM event_visiting_tasks WHERE event_status IN ( 1, 3 ) <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventZFTotal, ( SELECT count( id ) FROM com_act_easy_photo WHERE handle_status = 2 AND community_id = egd.grid_community_id <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS eventSSPTotal, ( SELECT count( id ) FROM com_act_easy_photo WHERE handle_status = 1 AND community_id = egd.grid_community_id <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> ) AS noEventSSPTotal FROM `event` AS e LEFT JOIN event_grid_data AS egd ON egd.id = e.grid_id WHERE e.event_category = 1 AND e.event_type = 5 AND e.event_process_status = 2 <if test="statisticsDTO.gridId!=null"> AND grid_id = #{statisticsDTO.gridId} </if> <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> AND create_at <![CDATA[ >= ]]> #{statisticsDTO.ageStartTime} </if> <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} </if> </select> </mapper>
