From 8a3d867c8632ba0de5459fc9de602e2379fc1313 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 15 三月 2024 14:52:55 +0800
Subject: [PATCH] 修改 统计管线长度
---
src/main/resources/mapper/sys/ReportMapper.xml | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/sys/ReportMapper.xml b/src/main/resources/mapper/sys/ReportMapper.xml
index b206f35..94e34ea 100644
--- a/src/main/resources/mapper/sys/ReportMapper.xml
+++ b/src/main/resources/mapper/sys/ReportMapper.xml
@@ -284,7 +284,12 @@
<!-- 缁熻绠＄嚎闀垮害 -->
<select id="countLineLength" resultType="com.lf.server.entity.ctrl.CountEntity">
- select name "m1", area * 1000000 "area" from lf.sys_line_buffer;
+ select name "m1", code,
+ (select cast( coalesce(sum( ST_Length( ST_GeographyFromText( ST_AsText(geom) ) ) ) / 1000, 0) as decimal(20, 2) )
+ from bs.m_pipeline b where b.dirid like a.code || '%') as "sizes"
+ from lf.sys_dir a
+ where pid = 0
+ order by a.code;
</select>
<!-- 鎸夐」鐩粺璁″嫎鎺㈢偣涓暟 -->
--
Gitblit v1.9.3