programs_info/无锡市生命线项目/数据库备份/删除前备份/代码修改前备份/前置数据库中的视图都移动到后管平台进行的修改/SecuritySupervise2Mapper.java

package com.slave2.midScreen2.mapper;

import com.slave.midScreen.model.in.SelectInfo;
import com.slave.midScreen.model.in.SelectInfoDetail;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.List;
import java.util.Map;

@Component
public interface SecuritySupervise2Mapper {
    //    //返回集合
//    @Select("select * from demo_clas WHERE name like '%#{name}%")
//    List<DemoClass> queryName(@Param("name") String name);

    @Select("<script> SELECT COALESCE (COUNT (1),0) AS COUNT,view_risk_collect.fxdj,view_risk_collect.TYPE FROM citylifeline.view_risk_collect view_risk_collect WHERE view_risk_collect.dispose_progress in \n" +
            "<foreach collection='gkztCodeList' index='index' item='item' open='(' separator=',' close=')'>#{item}</foreach> \n" +
            "GROUP BY view_risk_collect.TYPE,--专项场景_燃气/内涝等\n" +
            "view_risk_collect.fxdj--'隐患等级'\n" +
            "</script>")
    List<Map<String, Object>> findRiskCountList(@Param("gkztCodeList") List<String> gkztCodeList);

    @Select("<script> SELECT COUNT (1) COUNT,TYPE FROM citylifeline.view_risk_collect view_risk_collect WHERE (view_risk_collect.dispose_progress in \n" +
            "<foreach collection='gkztCodeList' index='index' item='item' open='(' separator=',' close=')'>#{item}</foreach> \n" +
            ") AND EXTRACT (EPOCH FROM (now()-pgsj))> (24*60*60)--超时24小时\n" +
            "GROUP BY TYPE--专项场景_燃气/内涝等\n" +
            "</script>")
    List<Map<String, Object>> findOverHourRiskCountList(@Param("gkztCodeList") List<String> gkztCodeList);

    @MapKey("area")
    List<Map<String, Object>> findCountRiskEveryPlace(@Param("entity") SelectInfo info, @Param("gkztCodeList") List<String> gkztCodeList);

    @MapKey("id")
    List<Map<String, Object>> findInfoRiskEveryPlace(@Param("entity") SelectInfo info, @Param("gkztCodeList") List<String> gkztCodeList);

    @MapKey("id")
    List<Map<String, Object>> findInfoRiskDetailEveryPlace(@Param("entity") SelectInfoDetail info, @Param("gkztCodeList") List<String> gkztCodeList);

    @Select("SELECT COUNT (1) all_count,EXTRACT (YEAR FROM T.pgsj) AS findYear,EXTRACT (MONTH FROM T.pgsj) AS findMonth,T.fxlx FROM citylifeline.view_risk_collect T WHERE T.pgsj>= #{ start_time,jdbcType=TIMESTAMP } AND T.pgsj< #{ end_time,jdbcType=TIMESTAMP } AND T.TYPE IN (#{ scene }) GROUP BY EXTRACT (YEAR FROM T.pgsj),EXTRACT (MONTH FROM T.pgsj),T.fxlx order by T.fxlx")
    List<Map<String, Object>> findFengXianFenXi(@Param("start_time") Date start_time, @Param("end_time") Date end_time, @Param("scene") String scene);

    @Select("SELECT COUNT (1) all_count,EXTRACT (YEAR FROM pgsj) AS findYear,EXTRACT (MONTH FROM pgsj) AS findMonth,fxdj FROM citylifeline.view_risk_collect WHERE pgsj>=#{ start_time,jdbcType=TIMESTAMP } AND pgsj< #{ end_time,jdbcType=TIMESTAMP } AND TYPE IN (#{ scene }) GROUP BY EXTRACT (YEAR FROM pgsj),EXTRACT (MONTH FROM pgsj),fxdj")
    List<Map<String, Object>> findFengXianFenXiTongJi(@Param("start_time") Date start_time, @Param("end_time") Date end_time, @Param("scene") String scene);

    @Select("SELECT COUNT (1) all_count,xzqhdm,fxdj FROM citylifeline.view_risk_collect WHERE EXTRACT (YEAR FROM pgsj)=#{ year,jdbcType=INTEGER } AND xzqhdm IN (#{ scene }) GROUP BY xzqhdm,fxdj ORDER BY xzqhdm")
    List<Map<String, Object>> findFengXianFenXiTongJi2(@Param("year") Integer year, @Param("scene") String scene);
    @MapKey("fxdj")
    List<Map<String, Object>> findFengXianFenXiTongJi3(@Param("year") Integer year, @Param("scene") String scene);
    @MapKey("all_month")
    List<Map<String, Object>> findFengXianFenXiTongJi4(@Param("year") Integer year, @Param("place") String place, @Param("scene") String scene,@Param("gkztCodeList") List<String> gkztCodeList);
    @Select("${sql}")
    List<Map<String, Object>> select2(@Param("sql") String sql);

    @MapKey("type")
    List<Map<String, Object>> pointStatistics(@Param("place")String area, @Param("sceneList") List<String> scene);
    @MapKey("bsm")
    List<Map<String, Object>> pointStatisticsDetail(@Param("place") String area, @Param("sceneList") List<String> scene);

    @MapKey("scene")
    List<Map<String, Object>> pointTopStatisticsDetail(@Param("sceneList")  List<String> scene);
}