| | |
|---|
| | | left join tj_order b on b.card_id = a.card_id join tj_customer c on c.cus_id = b.user_id |
|---|
| | | left join sys_attachment d on d.old_file_name<>concat(c.cus_name,'_',a.id,'.jpg') |
|---|
| | | where a.his_xmdm in ('8522','gmd'); |
|---|
| | | |
|---|
| | | -- 病种统计报表 |
|---|
| | | INSERT INTO `jimu_report` (`id`, `code`, `name`, `note`, `status`, `type`, `json_str`, `api_url`, `thumb`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `api_method`, `api_code`, `template`, `view_count`, `css_str`, `js_str`, `tenant_id`, `print_type`, `is_start`, `create_id`, `update_id`) VALUES ('1042322631512850432', '20250123163821', '病种统计', NULL, NULL, 'datainfo', '{\"loopBlockList\":[],\"area\":{\"sri\":3,\"sci\":1,\"eri\":3,\"eci\":1,\"width\":250,\"height\":40},\"excel_config_id\":\"1042322631512850432\",\"printConfig\":{\"paper\":\"A4\",\"width\":210,\"height\":297,\"definition\":1,\"isBackend\":false,\"marginX\":10,\"marginY\":10,\"layout\":\"portrait\",\"printCallBackUrl\":\"\"},\"zonedEditionList\":[],\"rows\":{\"0\":{\"cells\":{\"0\":{\"merge\":[1,6],\"height\":50,\"text\":\"病种统计\",\"style\":1}}},\"1\":{\"cells\":{}},\"2\":{\"cells\":{\"0\":{\"style\":7,\"text\":\" 项目\"},\"1\":{\"style\":8,\"text\":\" 异常项目\",\"rendered\":\"\",\"config\":\"\"},\"2\":{\"style\":8,\"text\":\" 阳性人数\"},\"3\":{\"style\":8,\"text\":\"阴性人数 \"},\"4\":{\"style\":8,\"text\":\"总检查人数\"},\"5\":{\"style\":8,\"text\":\" 正常率\"}}},\"3\":{\"cells\":{\"0\":{\"style\":11,\"text\":\"#{data.group(pro_name)}\",\"aggregate\":\"group\",\"rendered\":\"\",\"config\":\"\"},\"1\":{\"style\":11,\"text\":\"#{data.temp_result}\",\"aggregate\":\"select\",\"rendered\":\"\",\"config\":\"\",\"display\":\"normal\"},\"2\":{\"style\":12,\"text\":\"#{data.yangxing}\",\"rendered\":\"\",\"config\":\"\"},\"3\":{\"style\":12,\"text\":\"#{data.yinxing}\"},\"4\":{\"style\":12,\"text\":\"#{data.person_count}\"},\"5\":{\"style\":13,\"text\":\"#{data.zcl}\",\"decimalPlaces\":\"2\"}},\"height\":40},\"5\":{\"cells\":{\"0\":{\"style\":10,\"text\":\" \"},\"1\":{\"style\":10,\"text\":\" \",\"rendered\":\"\",\"config\":\"\"},\"2\":{\"style\":10,\"text\":\" \"},\"3\":{\"style\":10,\"text\":\" \"},\"4\":{\"style\":10,\"text\":\" \"},\"5\":{\"style\":10,\"text\":\" \"}}},\"6\":{\"cells\":{\"0\":{\"style\":10,\"text\":\" \"},\"1\":{\"style\":10,\"text\":\" \"},\"2\":{\"style\":10,\"text\":\" \"},\"3\":{\"style\":10,\"text\":\" \"},\"4\":{\"style\":10,\"text\":\" \"},\"5\":{\"style\":10,\"text\":\" \"}}},\"len\":99},\"dbexps\":[],\"dicts\":[],\"rpbar\":{\"show\":true,\"pageSize\":\"\",\"btnList\":[]},\"groupField\":\"data.pro_name\",\"fixedPrintHeadRows\":[],\"fixedPrintTailRows\":[],\"freeze\":\"A1\",\"dataRectWidth\":640,\"displayConfig\":{},\"background\":false,\"name\":\"sheet1\",\"autofilter\":{},\"styles\":[{\"align\":\"center\"},{\"align\":\"center\",\"font\":{\"size\":22}},{\"font\":{\"size\":22}},{\"bgcolor\":\"#deeaf6\"},{\"bgcolor\":\"#deeaf6\",\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]}},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]}},{\"bgcolor\":\"#deeaf6\",\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"font\":{\"bold\":true}},{\"bgcolor\":\"#deeaf6\",\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"font\":{\"bold\":true},\"align\":\"center\"},{\"bgcolor\":\"#deeaf6\",\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"align\":\"center\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"format\":\"number\"},{},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"textwrap\":true},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"align\":\"center\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"format\":\"number\",\"align\":\"center\"}],\"validations\":[],\"isGroup\":true,\"cols\":{\"1\":{\"width\":250},\"2\":{\"width\":60},\"3\":{\"width\":60},\"4\":{\"width\":70},\"5\":{\"width\":100},\"len\":50},\"merges\":[\"A1:G2\"]}', NULL, NULL, '10001', '2025-01-23 16:38:22', '10001', '2025-05-26 14:45:56', 0, NULL, NULL, 0, 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL); |
|---|
| | | INSERT INTO `jimu_report_db` (`id`, `jimu_report_id`, `create_by`, `update_by`, `create_time`, `update_time`, `db_code`, `db_ch_name`, `db_type`, `db_table_name`, `db_dyn_sql`, `db_key`, `tb_db_key`, `tb_db_table_name`, `java_type`, `java_value`, `api_url`, `api_method`, `is_list`, `is_page`, `db_source`, `db_source_type`, `json_data`, `api_convert`, `create_id`, `update_id`) VALUES ('1047054311028981760', '1042322631512850432', '10001', '10001', '2025-05-26 14:45:54', '2025-05-26 14:45:54', 'data', '信息', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://192.168.1.2:5000/report/jmreport/getBingZhong?hospId=ltkjpeis10_jdczgzyy&start=${start}&end=${end}', '0', '1', '0', '', NULL, '', '', NULL, NULL); |
|---|
| | | INSERT INTO `jimu_report_db_param` (`id`, `jimu_report_head_id`, `param_name`, `param_txt`, `param_value`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `search_flag`, `widget_type`, `search_mode`, `dict_code`, `search_format`, `ext_json`, `create_id`, `update_id`) VALUES ('1086866920296972288', '1047054311028981760', 'start', '开始时间', '=dateStr(\'yyyy-MM-dd\', -1)', 1, '10001', '2025-05-26 14:45:54', NULL, NULL, 1, 'date', NULL, NULL, 'yyyy-MM-dd HH:mm:ss', '', NULL, NULL); |
|---|
| | | INSERT INTO `jimu_report_db_param` (`id`, `jimu_report_head_id`, `param_name`, `param_txt`, `param_value`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `search_flag`, `widget_type`, `search_mode`, `dict_code`, `search_format`, `ext_json`, `create_id`, `update_id`) VALUES ('1086868045213499392', '1047054311028981760', 'end', '结束时间', '=dateStr(\'yyyy-MM-dd 23:59:59\')', 2, '10001', '2025-05-26 14:45:54', NULL, NULL, 1, 'date', NULL, NULL, 'yyyy-MM-dd HH:mm:ss', '', NULL, NULL); |
|---|
| | | INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `create_id`, `update_id`) VALUES (2403, '病种统计', 2035, 60, 'bztj', 'jmreport/bztj/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', '超级管理员', '2025-05-26 09:43:57', '', NULL, '', 0, NULL, NULL); |
|---|
