| | |
| | | |
| | | List<DamStationStatistics> tableResCountPage(@Param("dam")DamStationStatistics damStationStatistics, IPage<DamStationStatistics> page); |
| | | |
| | | List<DamStationStatistics> alarmResCount(@Param("dam") DamStationStatistics damStationStatistics,@Param("basCode") String basCode); |
| | | List<DamStationStatistics> alarmResCount(@Param("dam") DamStationStatistics damStationStatistics,@Param("basCodes") String basCodes); |
| | | |
| | | List<DamStatisticsRes> damResInfoCount(@Param("adCode") String adCode); |
| | | |
| | |
| | | <if test="dam.adCode != null and dam.adCode !='' "> |
| | | AND (province."ad_code" =#{dam.adCode} or city."ad_code" = #{dam.adCode} or county."ad_code" = #{dam.adCode}) |
| | | </if> |
| | | <if test="dam.basCode != null and dam.basCode !='' "> |
| | | <if test="basCodes != null and basCodes !='' "> |
| | | AND(abb."code" in |
| | | <foreach collection="basCode.split(',')" item="item" index="index" open="(" separator="," close=")"> |
| | | <foreach collection="basCodes.split(',')" item="item" index="index" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | or pabb."code" in |
| | | <foreach collection="basCode.split(',')" item="item" index="index" open="(" separator="," close=")"> |
| | | <foreach collection="basCodes.split(',')" item="item" index="index" open="(" separator="," close=")"> |
| | | #{item}) |
| | | </foreach> |
| | | </if> |