调整语法不兼容

whycxzp

2024-11-08 cf7c95c6a7625a5821fcbdabd66d28c921bad969

调整语法不兼容

 src/main/resources/mapper/Fbs9100StateMapper.xml

@@ -7,7 +7,7 @@
    dev_errcommcount;0:通讯正常，1：通讯中断，100：全部
    -->
    <select id="searchByCondition" resultType="com.whyc.pojo.Fbs9100State">
        select
        <!--select
        tb_fbs9100_state.dev_ip,tb_fbs9100_state.dev_version,record_datetime,tb_fbs9100_state.dev_id,op_cmd,dev_datetime,dev_testtype,dev_testgroupnum,
        dev_workstate,dev_alarmstate,dev_res_test_state,dev_onlinevollow,dev_eachgroup_battsum,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,
        dev_captest_cap,dev_captest_timelong,dev_restest_moncount,dev_restest_monindex,dev_commcount,dev_errcommcount,db_ram_db.tb_fbs9100_state.dev_61850alarms,dev_last_captest_stop_type,elec_comb_acttive_energy,elec_posi_acttive_energy,elec_rever_acttive_energy,elec_active_power,elec_vol,elec_curr,
@@ -38,7 +38,41 @@
            and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid
            and db_user.tb_user_inf.uid=#{uId} )
        </if>
        GROUP BY tb_fbs9100_state.dev_id
        GROUP BY tb_fbs9100_state.dev_id-->

        select
        tb_fbs9100_state.dev_ip,tb_fbs9100_state.dev_version,record_datetime,tb_fbs9100_state.dev_id,op_cmd,dev_datetime,dev_testtype,dev_testgroupnum,
        dev_workstate,dev_alarmstate,dev_res_test_state,dev_onlinevollow,dev_eachgroup_battsum,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,
        dev_captest_cap,dev_captest_timelong,dev_restest_moncount,dev_restest_monindex,dev_commcount,dev_errcommcount,db_ram_db.tb_fbs9100_state.dev_61850alarms,dev_last_captest_stop_type,elec_comb_acttive_energy,elec_posi_acttive_energy,elec_rever_acttive_energy,elec_active_power,elec_vol,elec_curr,
        db_battinf.tb_battinf.StationName as stationName,db_battinf.tb_battinf.FbsDeviceName as deviceName,
        COUNT(DISTINCT db_battinf.tb_battinf.BattGroupId) as num
        from db_ram_db.tb_Fbs9100_state
        left outer join db_battinf.tb_battinf ON tb_fbs9100_state.dev_id=db_battinf.tb_battinf.FBSDeviceId
        LEFT OUTER JOIN db_ram_db.tb_batt_rtstate ON
        db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid
        <if test="devErrcommcount==0">
            where dev_errcommcount=0
        </if>
        <if test="devErrcommcount==1">
            where dev_errcommcount>0
        </if>
        <if test="devErrcommcount==100">
            where dev_errcommcount>-1
        </if>
        <if test="uId!=null and uId!=0">
            and db_battinf.tb_battinf.StationId in(select distinct db_battinf.tb_battinf.StationId
            from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf
            where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId
            and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id
            and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid
            and db_user.tb_user_inf.uid=#{uId} )
        </if>
        <!--        GROUP BY tb_fbs9100_state.dev_id-->
        GROUP BY tb_fbs9100_state.dev_ip,tb_fbs9100_state.dev_version,record_datetime,tb_fbs9100_state.dev_id,op_cmd,dev_datetime,dev_testtype,dev_testgroupnum,
        dev_workstate,dev_alarmstate,dev_res_test_state,dev_onlinevollow,dev_eachgroup_battsum,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,
        dev_captest_cap,dev_captest_timelong,dev_restest_moncount,dev_restest_monindex,dev_commcount,dev_errcommcount,db_ram_db.tb_fbs9100_state.dev_61850alarms,dev_last_captest_stop_type,elec_comb_acttive_energy,elec_posi_acttive_energy,elec_rever_acttive_energy,elec_active_power,elec_vol,elec_curr,
        db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName
        order by db_battinf.tb_battinf.StationName
    </select>
    <select id="getList" resultType="com.whyc.pojo.Fbs9100State">
        SELECT distinct

 src/main/resources/mapper/Fbs9600StateMapper.xml

@@ -28,6 +28,8 @@
                and db_user.tb_user_inf.uid=#{uId} )
            </if>
        </where>
        GROUP BY tb_fbs9600_state.dev_id
        GROUP BY tb_Fbs9600_state.dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount,
        db_battinf.tb_battinf.StationName
        order by db_battinf.tb_battinf.StationName
    </select>
</mapper>

 src/main/resources/mapper/Ld9StateMapper.xml

@@ -32,7 +32,7 @@
        )
    </select>
    <select id="getLd9State" resultType="com.whyc.pojo.Fbs9100State">
        select distinct db_ram_db.tb_ld9_state.num as id,db_ram_db.tb_ld9_state.dev_ip,db_ram_db.tb_ld9_state.dev_id,db_ram_db.tb_ld9_state.dev_version,
        <!--select distinct db_ram_db.tb_ld9_state.num as id,db_ram_db.tb_ld9_state.dev_ip,db_ram_db.tb_ld9_state.dev_id,db_ram_db.tb_ld9_state.dev_version,
        db_ram_db.tb_ld9_state.sys_state,db_ram_db.tb_ld9_state.sys_stop_reason as devAlarmstate,db_ram_db.tb_ld9_state.dev_commcount,db_ram_db.tb_ld9_state.dev_errcommcount,db_ram_db.tb_ld9_state.timelong as devCaptestTimelong,db_ram_db.tb_ld9_state.record_datetime ,
        db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName as deviceName,
        COUNT(DISTINCT db_battinf.tb_battinf.BattGroupId) as num,
@@ -59,7 +59,38 @@
                and db_user.tb_user_inf.uid=#{uId}   )
            </if>
        </where>
        GROUP BY db_ram_db.tb_ld9_state.dev_id
        GROUP BY db_ram_db.tb_ld9_state.dev_id-->


        select distinct db_ram_db.tb_ld9_state.num as id,db_ram_db.tb_ld9_state.dev_ip,db_ram_db.tb_ld9_state.dev_id,db_ram_db.tb_ld9_state.dev_version,
        db_ram_db.tb_ld9_state.sys_state,db_ram_db.tb_ld9_state.sys_stop_reason as devAlarmstate,db_ram_db.tb_ld9_state.dev_commcount,db_ram_db.tb_ld9_state.dev_errcommcount,db_ram_db.tb_ld9_state.timelong as devCaptestTimelong,db_ram_db.tb_ld9_state.record_datetime ,
        db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName as deviceName,
        COUNT(DISTINCT db_battinf.tb_battinf.BattGroupId) as num
        from db_ram_db.tb_ld9_state
        left outer join db_battinf.tb_battinf ON db_ram_db.tb_ld9_state.dev_id=db_battinf.tb_battinf.FBSDeviceId
        LEFT OUTER JOIN db_ram_db.tb_batt_rtstate ON db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid
        <where>
            <if test="devErrcommcount==0">
                dev_errcommcount=0
            </if>
            <if test="devErrcommcount==1">
                dev_errcommcount>0
            </if>
            <if test="devErrcommcount==100">
                dev_errcommcount>-1
            </if>
            <if test="uId!=null and uId!=0">
                and db_battinf.tb_battinf.StationId in(select distinct db_battinf.tb_battinf.StationId
                from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf
                where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId
                and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id
                and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid
                and db_user.tb_user_inf.uid=#{uId}   )
            </if>
        </where>
        GROUP BY db_ram_db.tb_ld9_state.num,db_ram_db.tb_ld9_state.dev_ip,db_ram_db.tb_ld9_state.dev_id,db_ram_db.tb_ld9_state.dev_version,
        db_ram_db.tb_ld9_state.sys_state,db_ram_db.tb_ld9_state.sys_stop_reason,db_ram_db.tb_ld9_state.dev_commcount,db_ram_db.tb_ld9_state.dev_errcommcount,db_ram_db.tb_ld9_state.timelong,db_ram_db.tb_ld9_state.record_datetime ,
        db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName
        order by db_battinf.tb_battinf.StationName
    </select>
</mapper>