From 0e14fdd5a66cca6f23cc92b864a405ccec582db5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 20 三月 2024 16:46:47 +0800
Subject: [PATCH] 解决编码错误
---
src/main/resources/mapper/sys/ReportMapper.xml | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/main/resources/mapper/sys/ReportMapper.xml b/src/main/resources/mapper/sys/ReportMapper.xml
index c45ef77..28c455d 100644
--- a/src/main/resources/mapper/sys/ReportMapper.xml
+++ b/src/main/resources/mapper/sys/ReportMapper.xml
@@ -149,7 +149,7 @@
select name "m1",
(select cast( coalesce(sum(b.area), 0) as decimal(20, 2) ) from lf.sys_meta b
inner join lf.sys_dir c on b.dircode = c.code
- where c.name = '鏁板瓧楂樼▼妯″瀷' and b.type in ('dem', 'tif', 'tiff') and b.depcode like a.code || '%') "area"
+ where c.name = '鏁板瓧楂樼▼妯″瀷' and b.type in ('dem', 'tif', 'tiff') and b.dircode like a.code || '%') "area"
from lf.sys_dir a
where pid = 0
order by code;
@@ -166,8 +166,8 @@
<!-- 鎸夐」鐩粺璁″�炬枩鎽勫奖妯″瀷闈㈢Н:osgb -->
<select id="countOsgbAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity">
select name "m1",
- (select coalesce(sum(b.area), 0) from lf.sys_meta b
- where b.type = 'osgb' and b.depcode like a.code || '%') "area"
+ (select cast( coalesce(sum(area), 0) as decimal(20, 2) ) from lf.sys_meta b
+ where b.type = 'osgb' and b.dircode like a.code || '%') "area"
from lf.sys_dir a
where pid = 0
order by code;
@@ -177,7 +177,7 @@
<select id="countLasAreaByPrj" resultType="com.lf.server.entity.ctrl.CountEntity">
select name "m1",
(select cast( coalesce(sum(area), 0) as decimal(20, 2) ) from lf.sys_meta b
- where b.type in ('las', 'laz') and b.depcode like a.code || '%') "area"
+ where b.type in ('las', 'laz') and b.dircode like a.code || '%') "area"
from lf.sys_dir a
where pid = 0
order by code;
@@ -279,7 +279,7 @@
select name "m1",
(select cast( coalesce(sum(b.area), 0) as decimal(20, 2) ) from lf.sys_meta b
inner join lf.sys_dir c on b.dircode = c.code
- where c.name = '鏁板瓧姝ｅ皠褰卞儚鍥�' and b.type in ('img', 'tif', 'tiff') and b.depcode like a.code || '%') "area"
+ where c.name = '鏁板瓧姝ｅ皠褰卞儚鍥�' and b.type in ('img', 'tif', 'tiff') and b.dircode like a.code || '%') "area"
from lf.sys_dir a
where pid = 0
order by code;
--
Gitblit v1.9.3