20230228@xingjs@提交官网一张图相关内容接口(专题展示和工程展示相关模块内容)
| | |
| | | public List<String> countZhPipeMapLenByMed(); |
| | | |
| | | /** |
| | | * 全国站场座数 |
| | | * 全国站场座数、阀室、管道数等 |
| | | * |
| | | * @return {@link List}<{@link String}> |
| | | */ |
| | |
| | | } |
| | | |
| | | /** |
| | | * 全国站场座数 |
| | | * 全国站场座数、阀室、管道数等 |
| | | * |
| | | * @return {@link List}<{@link String}> |
| | | */ |
| | |
| | | SELECT medium AS type,count(*) AS count,sum(length)AS length FROM bs.m_pipesegment GROUP BY medium ; |
| | | </select> |
| | | |
| | | <!-- 统计全国站场座数 --> |
| | | <!-- 统计全国站场座数、阀室、管道数等 --> |
| | | <select id="countZhPipeStations" resultType="java.util.Map"> |
| | | select |
| | | case medium when 'CPY' then '成品油' when 'TRQ' then '天然气' when 'YY' then '原油' else '其它' end "输送介质", |