代码拉取完成，页面将自动刷新
版本号:1.5.0-beta
问题描述:设计页面第一页和第二页是挨着的，html预览空白出来一页
截图:
设计页面
html预览页面
脚本sql:
insert into jimu_report(api_code,create_time,name,template,del_flag,id,view_count,note,status,thumb,update_time,create_by,api_url,type,css_str,update_by,js_str,code,json_str,api_method) values (null,'2022-04-19 11:16:06','入职_0副本9248',0,0,'676233188907184128','2',null,null,null,'2022-04-19 11:17:13','admin',null,'printinfo',null,'admin',null,'2022041113530674169248','{"loopBlockList":[],"area":false,"excel_config_id":"676233188907184128","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"6":{"text":"${Induct_info.penumber}","rendered":"0v7ADifHquDeYyjm","config":2,"display":"barcode","merge":[1,1],"height":50,"style":37}}},"1":{"cells":{}},"3":{"cells":{"1":{"text":" ","style":3,"rendered":"","config":""},"2":{"merge":[1,4],"height":50,"text":"宁东朝阳医院健康体检中心","style":64},"9":{"text":"","rendered":"","config":""},"12":{"text":"","rendered":"","config":""}}},"4":{"cells":{"7":{"text":"","rendered":"","config":""}}},"5":{"cells":{"7":{"text":"","rendered":"","config":""}}},"6":{"cells":{"2":{"merge":[1,4],"height":50,"text":"健康体检报告 ","style":64}}},"7":{"cells":{}},"8":{"cells":{"1":{"text":" ","style":3}}},"9":{"cells":{"2":{"merge":[1,4],"height":50,"text":"Health Examination Report ","style":69}}},"10":{"cells":{"11":{"text":"","rendered":"","config":""}}},"12":{"cells":{}},"13":{"cells":{"3":{"text":""}}},"21":{"cells":{"1":{"merge":[0,1],"height":25,"text":"体检编号","style":79},"3":{"merge":[0,3],"height":41,"text":"${Induct_info.penumber}","style":83}},"height":35},"22":{"cells":{"1":{"merge":[0,1],"height":25,"text":"姓 名","style":79},"3":{"merge":[0,3],"height":37,"text":"${Induct_info.name}","style":83}},"height":37},"23":{"cells":{"1":{"merge":[0,1],"height":25,"text":"性 别","style":79},"3":{"merge":[0,3],"height":25,"text":"${Induct_info.sex}","style":83}},"height":34},"24":{"cells":{"1":{"merge":[0,1],"height":36,"text":"年 龄","style":79},"3":{"merge":[0,3],"height":36,"style":83,"text":"${Induct_info.age}"}},"height":36},"25":{"cells":{"1":{"merge":[0,1],"height":25,"text":"身份证号","style":79},"3":{"merge":[0,3],"height":34,"style":83,"text":"${Induct_info.idno}"}},"height":34},"26":{"cells":{"1":{"merge":[0,1],"height":35,"text":"单 位","style":79},"3":{"merge":[0,3],"height":35,"style":83,"text":"${Induct_info.companyname}"}},"height":35},"27":{"cells":{"1":{"merge":[0,1],"height":37,"text":"联系电话","style":79},"3":{"merge":[0,3],"height":37,"style":83,"text":"${Induct_info.phone}"}},"height":37},"28":{"cells":{"1":{"style":79,"merge":[0,1],"height":25,"text":"体检日期"},"3":{"merge":[0,3],"height":25,"style":83,"text":"${Induct_info.ordertime}"}},"height":36},"29":{"cells":{"2":{"text":" ","style":11},"3":{"merge":[0,1],"height":25,"style":9,"text":" "}}},"30":{"cells":{"2":{"text":" ","style":11},"3":{"merge":[0,1],"height":25,"style":9,"text":" "}}},"31":{"cells":{"2":{"text":" ","style":11},"3":{"merge":[0,1],"height":25,"style":9,"text":" "}}},"36":{"cells":{"1":{"style":7,"text":" "},"2":{"style":7,"text":" "},"3":{"style":7,"text":" "},"4":{"style":7,"text":" "},"5":{"text":" ","rendered":"","config":"","style":94},"6":{"merge":[0,1],"height":25,"text":"以诚行医，信昭天下","style":22}}},"37":{"cells":{"1":{"merge":[0,6],"height":25,"text":"地址：宁东镇中凯广场 咨询电话：0951-4721111 邮编：751400","style":93}}},"40":{"cells":{"1":{"merge":[0,1],"height":25,"text":" 尊敬的客户：","style":22},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"41":{"cells":{"1":{"merge":[0,6],"height":25,"text":" 感谢您对我院体检工作的信任及支持，并配合我们顺利完成此次医学体检。由于医疗科学","style":22}},"height":36},"42":{"cells":{"1":{"merge":[0,6],"height":25,"text":"技术对疾病认知的有限性、医疗设备的局限性以及您选择的体检项目并未涵盖所有脏器，因此","style":22}},"height":35},"43":{"cells":{"1":{"merge":[0,6],"height":25,"text":"医生所作出的健康诊断及医学建议仅仅是依据您的本次检查的结果而做出的。现将您的体检结","style":22}},"height":37},"44":{"cells":{"1":{"merge":[0,6],"height":25,"text":"果汇总分析如下，请您认知阅读。我们建议您对异常结果进行随访、复查及其他相关检查，便","style":22}},"height":38},"45":{"cells":{"1":{"merge":[0,6],"height":25,"text":"于医生更多更详实的医学依据来建立医学判断。如对体检报告及我们的建议有疑问，请您来我","style":22}},"height":43},"46":{"cells":{"1":{"merge":[0,6],"height":25,"text":"院体检中心详细咨询,咨询电话（0951-4721111）","style":22}},"height":40},"47":{"cells":{"1":{"merge":[0,6],"height":25,"text":" ","style":22}}},"48":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"49":{"cells":{"1":{"merge":[0,6],"height":25,"text":" 欢迎您对我们的工作提出意见和建议。祝您身体健康！","style":22}}},"50":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"51":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"55":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"56":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"57":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"merge":[0,3],"height":25,"text":"朝阳医院健康体检中心","style":22}}},"58":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"style":22,"text":" "},"6":{"style":22,"text":" "},"7":{"style":22,"text":" "}}},"62":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"text":"总检医师:","style":22},"6":{"merge":[0,1],"height":25,"style":22,"text":"${induct_final.totaldoctor}"}}},"66":{"cells":{"1":{"style":22,"text":" "},"2":{"style":22,"text":" "},"3":{"style":22,"text":" "},"4":{"style":22,"text":" "},"5":{"merge":[0,2],"height":25,"text":"签 章：宁东朝阳医院体检中心","style":22}}},"79":{"cells":{"1":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n rowcolor(''${depart_lis.departname}'',''#0a0a0a'',''#a5a5a5'')\n})","style":59,"merge":[0,3],"height":25},"5":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n rowcolor(''检查日期:'',''#0a0a0a'',''#a5a5a5'')\n})","style":60},"6":{"merge":[0,1],"height":25,"text":"${summary_lis.checktime}","style":60}}},"80":{"cells":{"1":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n rowcolor(''项目'',''red'',''yellow'')\n})","style":56},"2":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''检查者''\n})","style":56},"3":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''明细''\n})","style":56},"4":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''结果''\n})","style":56},"5":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''标识''\n})","style":0},"6":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''参考值''\n})","style":0},"7":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n ''单位''\n})","style":56}}},"81":{"cells":{"1":{"style":21,"text":"#{result_lis.group(combname)}","aggregate":"group"},"2":{"style":44,"text":"#{result_lis.group(checker)}","aggregate":"group"},"3":{"style":44,"text":"#{result_lis.itemname}"},"4":{"style":21,"text":"#{result_lis.phyresult}"},"5":{"style":53,"text":"#{result_lis.resulttips}"},"6":{"style":53,"text":"#{result_lis.resultdownvalue}-#{result_lis.resultupvalue}"},"7":{"style":21,"text":"#{result_lis.resultunit}","aggregate":"select"}}},"82":{"cells":{"1":{"text":"=(let result= ''${depart_lis.departname}'';\nif(result==''''){\n ''''\n}else{\n rowcolor(''小结'',''#0a0a0a'',''#e3efd9'')\n})","style":52},"2":{"merge":[0,5],"height":25,"text":"${summary_lis.content}","style":44},"3":{},"4":{},"5":{},"6":{},"7":{}}},"83":{"cells":{"2":{"text":""},"4":{"text":""}}},"86":{"cells":{"1":{"merge":[0,6],"height":25,"text":"【体检综述报告】","style":31}}},"87":{"cells":{"1":{"text":"单位名称","style":13},"2":{"style":13,"text":"${Induct_info.companyname}","merge":[0,2],"height":25},"5":{"text":"打印时间","style":13},"6":{"merge":[0,1],"height":25,"text":"=now()","style":35}}},"88":{"cells":{"1":{"style":42,"text":"体检编号"},"2":{"style":42,"text":"${Induct_info.penumber}"},"3":{"style":42,"text":"姓名${Induct_info.name}"},"4":{"style":42,"text":"性别:${Induct_info.sex}"},"5":{"style":42,"text":"年龄:${Induct_info.age}"},"6":{"style":42,"text":"总检医生:${induct_final.totaldoctor}","merge":[0,1],"height":25}}},"89":{"cells":{"1":{"merge":[0,6],"height":25,"text":"${induct_final.summary}","style":44},"2":{},"3":{},"4":{},"5":{},"6":{},"7":{}}},"90":{"cells":{"5":{"text":""}}},"91":{"cells":{"6":{"text":""}}},"92":{"cells":{"4":{"text":""}}},"len":116},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[]},"groupField":"result_lis.combname","freeze":"A1","dataRectWidth":693,"displayConfig":{"1":{"barcodeContent":"${Induct_info.penumber}","format":"CODE128","width":"4","height":50,"displayValue":true,"text":"${Induct_info.penumber}","fontOptions":"","font":"monospace","textAlign":"left","textPosition":"top","textMargin":2,"fontSize":"18","background":"#fff","lineColor":"#000","margin":10,"containerWidth":200,"containerHeight":50},"2":{"barcodeContent":"${Induct_info.penumber}","format":"CODE128","width":"4","height":50,"displayValue":true,"text":"${Induct_info.penumber}","fontOptions":"","font":"monospace","textAlign":"left","textPosition":"top","textMargin":2,"fontSize":"18","background":"#fff","lineColor":"#000","margin":10,"containerWidth":169,"containerHeight":50}},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"name":"宋体"}},{"font":{"name":"宋体"}},{"align":"center","font":{"name":"宋体","size":24}},{"font":{"name":"宋体","size":24}},{"font":{"name":"宋体","size":22}},{"font":{"name":"宋体","size":22},"align":"center"},{"border":{"bottom":["thin","#000"]}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体"}},{"font":{"name":"宋体","size":14}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体","size":14}},{"font":{"name":"宋体","size":14},"align":"center"},{"font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10,"bold":true}},{"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"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"name":"宋体","size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":10}},{},{"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"name":"宋体","size":10},"format":"normal"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":10},"format":"normal"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"name":"宋体","size":12},"format":"normal"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12},"format":"normal"},{"bgcolor":"#a5a5a5"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#a5a5a5"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#e3efd9"},{"bgcolor":"#e3efd9"},{"font":{"name":"宋体","size":14,"bold":true}},{"font":{"name":"宋体","bold":true}},{"font":{"name":"宋体","size":10,"bold":false}},{"font":{"name":"宋体","size":10,"bold":false},"format":"datetime"},{"font":{"name":"宋体","size":10,"bold":true},"format":"datetime"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"normal"},{"format":"normal"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"normal","font":{"name":"宋体"}},{"format":"normal","font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"normal","font":{"name":"宋体","bold":true}},{"format":"normal","font":{"name":"宋体","bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"normal","font":{"name":"宋体","bold":true,"size":10}},{"format":"normal","font":{"name":"宋体","bold":true,"size":10}},{"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#e3efd9","textwrap":true},{"bgcolor":"#afabac"},{"bgcolor":"#afabac","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"]},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#e3efd9","textwrap":false},{"bgcolor":"#ffffff","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"bgcolor":"#ffffff"},{"align":"center","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#ffffff","textwrap":false},{"bgcolor":"#ffffff","textwrap":false},{"align":"left"},{"bgcolor":"#ffffff","font":{"name":"宋体"}},{"bgcolor":"#ffffff","font":{"name":"宋体","size":12}},{"bgcolor":"#ffffff","font":{"name":"宋体","size":12,"bold":true}},{"font":{"name":"宋体","size":12,"bold":true}},{"font":{"size":26}},{"font":{"size":26},"align":"center"},{"font":{"size":26,"name":"宋体"},"align":"center"},{"font":{"size":26,"name":"宋体","bold":true},"align":"center"},{"font":{"size":26,"bold":true}},{"font":{"size":24}},{"align":"center","font":{"name":"宋体","size":24,"bold":true}},{"font":{"name":"宋体","size":24,"bold":true}},{"align":"center","font":{"name":"宋体","size":24,"bold":false}},{"font":{"name":"宋体","size":24,"bold":false}},{"align":"right"},{"align":"right","font":{"size":22}},{"font":{"size":22}},{"align":"right","font":{"size":24}},{"align":"right","font":{"size":24,"name":"宋体"}},{"align":"right","font":{"size":22,"name":"宋体"}},{"align":"right","font":{"size":18,"name":"宋体"}},{"font":{"name":"宋体","size":18}},{"align":"right","font":{"size":16,"name":"宋体"}},{"font":{"name":"宋体","size":16}},{"font":{"name":"宋体","size":18},"border":{"bottom":["thin","#000"]}},{"font":{"name":"宋体","size":18},"border":{"bottom":["thin","#000"]},"align":"center"},{"font":{"name":"宋体","size":16},"border":{"bottom":["thin","#000"]},"align":"center"},{"font":{"size":16}},{"align":"right","font":{"size":16}},{"font":{"name":"宋体","size":16},"align":"center"},{"align":"right","font":{"name":"宋体"}},{"font":{"size":16},"border":{"bottom":["thin","#000"]}},{"font":{"size":16,"name":"宋体"},"border":{"bottom":["thin","#000"]}},{"font":{"size":16,"name":"宋体"},"border":{"bottom":["thin","#000"]},"align":"right"},{"font":{"size":14}},{"font":{"name":"宋体","size":14,"bold":true},"align":"center"},{"font":{"name":"宋体","size":14,"bold":true},"align":"center","border":{"top":["thin","#000"]}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体"},"align":"center"},{"font":{"size":12}}],"validations":[],"isGroup":true,"cols":{"0":{"width":21},"5":{"width":103},"6":{"width":92},"7":{"width":77},"len":50},"merges":["G1:H2","C4:G5","C7:G8","C10:G11","B22:C22","D22:G22","B23:C23","D23:G23","B24:C24","D24:G24","B25:C25","D25:G25","B26:C26","D26:G26","B27:C27","D27:G27","B28:C28","D28:G28","B29:C29","D29:G29","D30:E30","D31:E31","D32:E32","G37:H37","B38:H38","B41:C41","B42:H42","B43:H43","B44:H44","B45:H45","B46:H46","B47:H47","B48:H48","B50:H50","E58:H58","G63:H63","F67:H67","B80:E80","G80:H80","C83:H83","B87:H87","C88:E88","G88:H88","G89:H89","B90:H90"]}',null);
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('Induct_info','基本信息','0','2022-04-19 11:16:06','0',null,'','676233189083344896','676233188907184128','SELECT
t1.age,
t1.name,
t1.phone,
(
CASE
t1.marriage
WHEN ''1397393941601521665''
THEN ''已婚''
WHEN ''1397393968440872962''
THEN ''未婚''
WHEN ''1397394014523691009''
THEN ''离异''
WHEN ''1397394246925881345''
THEN ''丧偶''
ELSE ''未知''
END
) AS marriage,
(
CASE
t1.sex
WHEN ''1395668945472708610''
THEN ''通用''
WHEN ''1395668968889507841''
THEN ''男性''
WHEN ''1395669001382780929''
THEN ''女性''
ELSE ''未知''
END
) AS sex,
t2.pe_number AS peNumber,
(
CASE
WHEN t2.pe_depart_id IS NULL
THEN ''无''
ELSE t2.pe_depart_id
END
) AS peDepartId,
DATE_FORMAT(t2.order_time, ''%Y-%m-%d'') AS orderTime,
t2.id AS regId,
(
CASE
WHEN t1.depart_name IS NULL
THEN ''无''
ELSE t1.depart_name
END
) AS companyname,
t1.id_no AS idNo
FROM
pe_user_info t1
INNER JOIN pe_regist t2
ON t1.id = t2.pe_user_id
WHERE t1.del_flag = 0
AND t2.del_flag = 0
AND t2.id = ''${regid}''','0','2022-04-11 15:17:07',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',0,null,'年龄',null,'676233189154648064',null,null,'admin','676233189083344896',null,null,null,'age',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',1,null,'姓名',null,'676233189221756928',null,null,'admin','676233189083344896',null,null,null,'name',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',2,null,'手机号',null,'676233189259505664',null,null,'admin','676233189083344896',null,null,null,'phone',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',3,null,'婚姻',null,'676233189280477184',null,null,'admin','676233189083344896',null,null,null,'marriage',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',4,null,'性别',null,'676233189301448704',null,null,'admin','676233189083344896',null,null,null,'sex',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',5,null,'体检号',null,'676233189335003136',null,null,'admin','676233189083344896',null,null,null,'penumber',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',6,null,'单位编号',null,'676233189355974656',null,null,'admin','676233189083344896',null,null,null,'pedepartid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',7,null,'预约时间',null,'676233189385334784',null,null,'admin','676233189083344896',null,null,null,'ordertime',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',8,null,'登记编号',null,'676233189418889216',null,null,'admin','676233189083344896',null,null,null,'regid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',9,null,'单位名称',null,'676233189431472128',null,null,'admin','676233189083344896',null,null,null,'companyname',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',10,null,'身份证号',null,'676233189448249344',null,null,'admin','676233189083344896',null,null,null,'idno',null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:06','676233189083344896','regid',1,null,null,'1509081937567895553',null,'676233189540524032',0,null,'admin','regid',null,null,'');
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('induct_final','总检','0','2022-04-19 11:16:06','0',null,'','676233189653770240','676233188907184128','SELECT
summary,
reg_id AS regId,
pe_number AS peNumber,
noti_flag AS notiFlag,
notify_user AS notifyUser,
recheck_days AS recheckDays,
recheck_time AS recheckTime,
recheck_summary AS recheckSummary,
check_doctor AS checkDoctor,
total_doctor AS totalDoctor,
create_by AS createBy
FROM
pe_final_check
WHERE reg_id = ''${regid}''
AND diseases_flag = 2','0','2022-04-11 15:17:07',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',0,null,'summary',null,'676233189775405056',null,null,'admin','676233189653770240',null,null,null,'summary',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',1,null,'regid',null,'676233189792182272',null,null,'admin','676233189653770240',null,null,null,'regid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',2,null,'penumber',null,'676233189808959488',null,null,'admin','676233189653770240',null,null,null,'penumber',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',3,null,'notiflag',null,'676233189821542400',null,null,'admin','676233189653770240',null,null,null,'notiflag',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',4,null,'notifyuser',null,'676233189834125312',null,null,'admin','676233189653770240',null,null,null,'notifyuser',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',5,null,'recheckdays',null,'676233189859291136',null,null,'admin','676233189653770240',null,null,null,'recheckdays',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:06','String',6,null,'rechecktime',null,'676233189876068352',null,null,'admin','676233189653770240',null,null,null,'rechecktime',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',7,null,'rechecksummary',null,'676233189888651264',null,null,'admin','676233189653770240',null,null,null,'rechecksummary',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',8,null,'checkdoctor',null,'676233189901234176',null,null,'admin','676233189653770240',null,null,null,'checkdoctor',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',9,null,'totaldoctor',null,'676233189913817088',null,null,'admin','676233189653770240',null,null,null,'totaldoctor',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',10,null,'createby',null,'676233189934788608',null,null,'admin','676233189653770240',null,null,null,'createby',null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233189653770240','regid',1,null,null,'',null,'676233189947371520',0,null,'admin','regid',null,null,'');
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('depart_lis','检验科','0','2022-04-19 11:16:07','0',null,'','676233189972537344','676233188907184128','SELECT
t1.id,
t1.depart_name AS departName
FROM
sys_depart t1
INNER JOIN pe_result t2
ON t1.id = t2.dept_id
WHERE t2.reg_id = ''${regid}''
AND diseases_flag = 2
AND lis_flag = 1
GROUP BY t2.dept_id','0','2022-04-11 18:15:02',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',0,null,'id',null,'676233190110949376',null,null,'admin','676233189972537344',null,null,null,'id',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',1,null,'departname',null,'676233190123532288',null,null,'admin','676233189972537344',null,null,null,'departname',null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233189972537344','regid',1,null,null,'',null,'676233190136115200',0,null,'admin','regid',null,null,'');
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('result_lis','检验科结果','1','2022-04-19 11:16:07','0',null,'','676233190169669632','676233188907184128','SELECT
t1.reg_id AS regId,
t1.result_type AS resultType,
t1.comb_id AS combId,
t1.item_id AS itemId,
t1.item_name AS itemName,
t1.phy_result AS phyResult,
t1.result_unit AS resultUnit,
t1.result_up_value AS resultUpValue,
t1.result_down_value AS resultDownValue,
t1.result_tips AS resultTips,
t1.neg_flag AS negFlag,
t1.dept_id AS deptId,
t1.doctor AS checker,
t1.create_by AS createBy,
t2.depart_name AS depName,
t3.name AS combName
FROM
pe_result t1
LEFT JOIN sys_depart t2
ON t1.dept_id = t2.id
LEFT JOIN pe_combinate t3
ON t1.comb_id = t3.id
WHERE t1.reg_id = ''${regid}''
AND t2.id = ''${depid}''
AND t1.diseases_flag = 2
AND t2.del_flag = 0
ORDER BY t2.depart_order ASC','0','2022-04-11 18:00:20',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',0,null,'regid',null,'676233190186446848',null,null,'admin','676233190169669632',null,null,null,'regid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',1,null,'resulttype',null,'676233190199029760',null,null,'admin','676233190169669632',null,null,null,'resulttype',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',2,null,'combid',null,'676233190207418368',null,null,'admin','676233190169669632',null,null,null,'combid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',3,null,'itemid',null,'676233190220001280',null,null,'admin','676233190169669632',null,null,null,'itemid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',4,null,'itemname',null,'676233190232584192',null,null,'admin','676233190169669632',null,null,null,'itemname',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',5,null,'phyresult',null,'676233190240972800',null,null,'admin','676233190169669632',null,null,null,'phyresult',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',6,null,'resultunit',null,'676233190287110144',null,null,'admin','676233190169669632',null,null,null,'resultunit',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',7,null,'resultupvalue',null,'676233190299693056',null,null,'admin','676233190169669632',null,null,null,'resultupvalue',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',8,null,'resultdownvalue',null,'676233190308081664',null,null,'admin','676233190169669632',null,null,null,'resultdownvalue',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',9,null,'resulttips',null,'676233190320664576',null,null,'admin','676233190169669632',null,null,null,'resulttips',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',10,null,'negflag',null,'676233190329053184',null,null,'admin','676233190169669632',null,null,null,'negflag',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',11,null,'deptid',null,'676233190341636096',null,null,'admin','676233190169669632',null,null,null,'deptid',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',12,null,'checker',null,'676233190354219008',null,null,'admin','676233190169669632',null,null,null,'checker',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',13,null,'createby',null,'676233190362607616',null,null,'admin','676233190169669632',null,null,null,'createby',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',14,null,'depname',null,'676233190375190528',null,null,'admin','676233190169669632',null,null,null,'depname',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',15,null,'combname',null,'676233190383579136',null,null,'admin','676233190169669632',null,null,null,'combname',null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233190169669632','regid',1,null,null,'',null,'676233190396162048',0,null,'admin','regid',null,null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233190169669632','depid',2,null,null,'',null,'676233190412939264',0,null,'admin','depid',null,null,'');
insert into jimu_report_db(db_code,db_ch_name,is_list,create_time,db_type,db_key,db_source,id,jimu_report_id,db_dyn_sql,is_page,update_time,tb_db_table_name,create_by,api_url,json_data,db_table_name,update_by,tb_db_key,java_type,java_value,api_method,api_convert,db_source_type) values ('summary_lis','检验科结论','0','2022-04-19 11:16:07','0',null,'','676233190438105088','676233188907184128',' SELECT
GROUP_CONCAT(t1.comb_name, ":", t2.content) AS content,
SUBSTRING_INDEX(
GROUP_CONCAT(
DATE_FORMAT(t1.create_time, ''%Y-%m-%d'')
),
'','',
1
) AS checkTime
FROM
pe_summary t1
INNER JOIN pe_summary_details t2
ON t1.id = t2.pe_sum_id
AND t1.reg_id = ''${regid}''
AND dept_id = ''${deptid}''
AND t1.del_flag = 0
AND t2.del_flag = 0
AND t1.diseases_flag=2','0','2022-04-12 11:42:44',null,'admin',null,'',null,'admin',null,null,null,null,'','mysql');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',0,null,'content',null,'676233190450688000',null,null,'admin','676233190438105088',null,null,null,'content',null,'');
insert into jimu_report_db_field(create_time,widget_type,order_num,search_mode,field_text,dict_code,id,search_flag,update_time,create_by,jimu_report_db_id,widget_width,search_value,update_by,field_name,search_format,ext_json) values ('2022-04-19 11:16:07','String',1,null,'checktime',null,'676233190463270912',null,null,'admin','676233190438105088',null,null,null,'checktime',null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233190438105088','regid',1,null,null,'',null,'676233190475853824',0,null,'admin','regid',null,null,'');
insert into jimu_report_db_param(create_time,jimu_report_head_id,param_name,order_num,widget_type,search_mode,param_value,dict_code,id,search_flag,update_time,create_by,param_txt,update_by,search_format,ext_json) values ('2022-04-19 11:16:07','676233190438105088','deptid',2,null,null,'',null,'676233190484242432',0,null,'admin','deptid',null,null,'');
