20230226@xingjs@提交官网一张图相关内容接口(新增服务大类统计、数据服务类型统计、登录用户次数统计)
| | |
| | | |
| | | |
| | | <!-- 统计项目类型 1 --> |
| | | <!-- select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a |
| | | where name in ('测量(ESV)', '勘察(EGE)', '地灾(EGD)', '洞库(EGD)') group by name order by name;--> |
| | | <select id="selectProjectType1" resultMap="OneMapResult"> |
| | | select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a |
| | | where name in ('测量(ESV)', '勘察(EGE)', '地灾(EGD)', '洞库(EGD)') group by name order by name; |
| | | SELECT |
| | | (SELECT string_agg(code, |
| | | ',') |
| | | FROM lf.sys_dir |
| | | WHERE name = a.name) "key", name "value" |
| | | FROM lf.sys_dir a |
| | | WHERE name IN ('基础地灾', '基础勘察', '合规数据', '管理数据', '勘察(EGE)', '地灾(EGD)', '洞库(EGD)') |
| | | GROUP BY name |
| | | ORDER BY key; |
| | | </select> |
| | | |
| | | <!-- 统计项目类型 2 --> |