From 2b610635b0da111bb7349a2248b76b5786307c31 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 19 三月 2025 09:50:18 +0800
Subject: [PATCH] 语法适配瀚高
---
src/main/resources/mapper/BattLithiumTestDataInfMapper.xml | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml b/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml
index 7452233..be3e2d0 100644
--- a/src/main/resources/mapper/BattLithiumTestDataInfMapper.xml
+++ b/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) <= 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}
--
Gitblit v1.9.1