湖北水库项目
parent: 6f4d018f | patch | commit | ignore whitespace
xieb
2023-07-04 6829b805861513b68df6a91c35b85312b48f90bb 
Merge remote-tracking branch 'origin/jtdev' into jtdev
1 files modified
3 ■■■■■ changed files
skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml 3 ●●●●● patch | view | raw | blame | history 
 skjcmanager/skjcmanager-service/skjcmanager-alerts/src/main/java/cn/gistack/alerts/alarmRule/mapper/AlarmRecordMapper.xml


@@ -13,9 +13,6 @@


        left join SJZT_MD."att_res_base" arb on arb."guid" = sar.reservoir_number


        left join SJZT_MD."att_ad_base" aab on aab."guid" = arb."interior_ad_guid"


        where sar.is_deleted = 0


        <if test="alarmRecord.alarmSurveyStationName!=null and alarmRecord.alarmSurveyStationName!=''">


            and alarm_survey_station_name like concat(concat('%',#{alarmRecord.alarmSurveyStationName}),'%')


        </if>


        <if test="alarmRecord.reservoirName!=null and alarmRecord.reservoirName!=''">


            and sar.reservoir_name like concat(concat('%',#{alarmRecord.reservoirName}),'%')


        </if>