语法适配瀚高

whycxzp

2025-03-19 2b610635b0da111bb7349a2248b76b5786307c31

语法适配瀚高

 src/main/resources/mapper/BattLithiumTestDataInfMapper.xml

@@ -8,7 +8,7 @@
        <result property="devType" column="dev_type"></result>
    </resultMap>
    <select id="getDevTinf" resultMap="staticTinf">
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_batt_testdata.tb_batttestdata_inf
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_lithium_testdata.tb_batttestdata_inf
        <where>
            dev_id in (
            SELECT distinct dev_id from db_user.tb_battgroup_baojigroup,db_user.tb_battgroup_usr
@@ -22,9 +22,9 @@
        </where>
    </select>
    <select id="getDevTinfByYear" resultMap="staticTinf">
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_batt_testdata.tb_batttestdata_inf
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_lithium_testdata.tb_batttestdata_inf
        <where>
            YEAR(test_starttime)=YEAR(NOW())
            EXTRACT (YEAR from test_starttime)= EXTRACT (YEAR from NOW())
            and dev_id in (
            SELECT distinct dev_id from db_user.tb_battgroup_baojigroup,db_user.tb_battgroup_usr
            <where>
@@ -37,7 +37,7 @@
        </where>
    </select>
    <select id="getDevTinfByMonth" resultMap="staticTinf">
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_batt_testdata.tb_batttestdata_inf
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type from db_lithium_testdata.tb_batttestdata_inf
        <where>
            DATE_FORMAT(test_starttime,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m')
            and dev_id in (
@@ -60,7 +60,7 @@
    </resultMap>
    <select id="getDevTinfByWeek"  resultMap="staticTinfWeek">
        select num,dev_id,test_type,floor(dev_id/100000000) as dev_type,DATE_FORMAT(test_starttime, '%Y-%m-%d') AS week_day
        from db_batt_testdata.tb_batttestdata_inf
        from db_lithium_testdata.tb_batttestdata_inf
        <where>
            DATE_SUB(CURDATE(), INTERVAL 6 DAY) &lt;= DATE(test_starttime)
            and floor(dev_id/100000000)=#{type}
@@ -77,7 +77,7 @@
    </select>
    <select id="getTinfById" resultType="com.whyc.pojo.db_lithium_testdata.BattLithiumTestDataInf">
        select *
        from db_batt_testdata.tb_batttestdata_inf
        from db_lithium_testdata.tb_batttestdata_inf
        <where>
        and test_type=#{type}
        and dev_id=#{devId}