From 1fe54cbb927dd89f7568d971fe427e980302f1d1 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期三, 23 七月 2025 14:03:54 +0800 Subject: [PATCH] 总检页面查询数据接口弃检结果去重 --- ltkj-admin/src/main/resources/sql/陕健医.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" index dc12af1..1ae5f96 100644 --- "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" +++ "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" @@ -77,6 +77,7 @@ SELECT config_value,'pbkwyy' as hosp FROM ltkjpeis10_pbkwyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all SELECT config_value,'ssyjyy' as hosp FROM ltkjpeis10_ssyjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all SELECT config_value,'wbzxyy' as hosp FROM ltkjpeis10_wbzxyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all - SELECT config_value,'xamjyy' as hosp FROM ltkjpeis10_xamjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' + SELECT config_value,'xamjyy' as hosp FROM ltkjpeis10_xamjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all + SELECT config_value,'xatlgcyy' as hosp FROM ltkjpeis10_xatlgcyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' ) a ORDER BY a.config_value DESC; -- Gitblit v1.8.0