|
--- select config_key, config_value from sys_config where config_key='sys.authority.campus.all'
|
config_key | config_value
|
|
--- select d.dept_code, d.dept_name, d.campusid, count(*) dup from sys_dept d inner join sys_user_dept ud on d.dept_code = ud.dept_code where d.del_flag=0 and ud.del_flag=0 and d.orgid='20001001' and ud.orgid='20001001' and ud.user_id=2609 and d.dept_type='2' group by d.dept_code, d.dept_name, d.campusid
|
dept_code | dept_name | campusid | dup
|
40003047 | 2-6东病区（骨伤中心一） | 30001002 | 40
|
|
--- select d.dept_code, d.dept_name, d.campusid from sys_dept d inner join sys_user_dept ud on d.dept_code = ud.dept_code where d.del_flag=0 and ud.del_flag=0 and d.orgid='20001001' and ud.orgid='20001001' and d.campusid='30001002' and ud.user_id=2609 and d.dept_type='2' group by d.dept_code, d.dept_name, d.campusid
|
dept_code | dept_name | campusid
|
40003047 | 2-6东病区（骨伤中心一） | 30001002
|
|
--- select leavehospitaldistrictcode, leavehospitaldistrictname, count(*) cnt from service_subtask where del_flag='0' and service_type='2' and sendstate in (1,2,3,5,7) and endtime>='2026-10-01' and endtime<'2026-11-01' and endtime <= DATE_SUB(CURDATE(), INTERVAL 7 DAY) and leavehospitaldistrictcode in ('40003047','40003048') group by leavehospitaldistrictcode, leavehospitaldistrictname
|
leavehospitaldistrictcode | leavehospitaldistrictname | cnt
|
40003047 | 2-6东病区（骨伤中心一） | 90
|
40003048 | 2-6西病区（骨伤中心二） | 25
|
