| | |
| | | for(String areaValue:area){ |
| | | ComActAcidChartsVO acid=new ComActAcidChartsVO(); |
| | | acid.setName(areaValue); |
| | | ComActAcidChartsVO acidCount =this.baseMapper.selectAcidCount(date,localCity); |
| | | ComActAcidChartsVO acidCount =this.baseMapper.selectAcidCount(date,areaValue); |
| | | if(acidCount!=null){ |
| | | acid.setNumOne(acidCount.getNumOne()); |
| | | } |
| | | acidList.add(acid); |
| | | ComActAcidChartsVO danger=new ComActAcidChartsVO(); |
| | | danger.setName(areaValue); |
| | | ComActAcidChartsVO dangerCount =this.baseMapper.selectDangerCount(date,localCity); |
| | | ComActAcidChartsVO dangerCount =this.baseMapper.selectDangerCount(date,areaValue); |
| | | if(dangerCount!=null){ |
| | | danger.setNumOne(dangerCount.getNumOne()); |
| | | danger.setNumTwo(dangerCount.getNumTwo()); |
| | |
| | | and create_time between concat(#{date},' 00:00:00') and concat(#{date},' 23:23:59') |
| | | </if> |
| | | <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and relation_name like |
| | | concat('%',#{localCity},'%')</if>) numberOne, |
| | | concat('%',#{localCity},'%')</if>) numOne, |
| | | (select count(*) as numTwo from com_act_acid_danger_member where type = 2 |
| | | <if test="date!=null and date!=''">and |
| | | create_time between concat(#{date},' 00:00:00') and concat(#{date},' 23:23:59') |
| | | </if> |
| | | <if test="localCity!=null and localCity!='' and localCity !='panzhihua'">and relation_name like |
| | | concat('%',#{localCity},'%')</if>) numberTwo |
| | | concat('%',#{localCity},'%')</if>) numTwo |
| | | </select> |
| | | |
| | | <select id="selectCheck" resultType="com.panzhihua.common.model.vos.community.acid.ComActAcidChartsVO"> |