调整语法不兼容

whycxzp

2024-11-13 dcf387e233a47ffb81d36bd02c4bb7ee966af5a1

调整语法不兼容

 src/main/resources/mapper/BattInfMapper.xml

@@ -751,7 +751,7 @@
        where BattGroupId=#{battGroupId}
    </select>
    <select id="selectAlarmNumIn3D"  resultType="java.lang.String">
        select IFNULL(GROUP_CONCAT(DISTINCT MonNum),"") from db_alarm.tb_battalarm_data where BattGroupId=#{battGroupId} and MonNum>0
        select IFNULL(wm_CONCAT(DISTINCT MonNum),'') from db_alarm.tb_battalarm_data where BattGroupId=#{battGroupId} and MonNum>0
    </select>
    <select id="hasBattBinf" resultType="java.lang.Integer">
        select count(*) from  db_battinf.tb_battinf where StationId=#{stationId}

 src/main/resources/mapper/WorkflowPropertyMapper.xml

@@ -6,10 +6,10 @@
    <select id="getPropertyList" resultType="com.whyc.dto.WorkflowPropertyDTO2">
        SELECT
<!--            GROUP_CONCAT(id) id,-->
            GROUP_CONCAT(link_type) link_type,
            GROUP_CONCAT(link_name) link_name,
            GROUP_CONCAT(role_type) role_type,
            GROUP_CONCAT(role_name) role_name,
            WM_concat(link_type) link_type,
            WM_concat(link_name) link_name,
            WM_concat(role_type) role_type,
            WM_concat(role_name) role_name,
            type
        FROM
            web_site.tb_workflow_property