|
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-03-04 14:29:57','个人报告(主子)',1,0,'659612131995709440','229',null,null,null,'2022-03-16 15:27:17','admin',null,'printinfo',null,'admin',null,'202108131517597541','{"loopBlockList":[{"sci":1,"sri":44,"eci":3,"eri":44,"index":1,"db":"health_common_report_child","loopTime":2}],"area":{"sri":25,"sci":4,"eri":25,"eci":4,"width":87,"height":25},"excel_config_id":"659612131995709440","printConfig":{"paper":"A4","width":210,"height":297,"definition":2,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"1":{"merge":[2,6],"height":71.25,"text":"体检报告单","style":205},"11":{"styles":1,"text":" "},"12":{"styles":2,"text":" "},"13":{"styles":3,"text":" "},"14":{"styles":4,"text":" "},"15":{"styles":5,"text":" "},"16":{"styles":6,"text":" "},"17":{"styles":7,"text":" "}},"height":23.75},"1":{"cells":{"11":{"styles":8,"text":" "},"12":{"styles":9,"text":" "},"13":{"styles":10,"text":" "},"14":{"styles":11,"text":" "},"15":{"styles":12,"text":" "},"16":{"styles":13,"text":" "},"17":{"styles":14,"text":" "},"-1":{"text":"#{report_person_base.picture}"}},"height":23.75},"2":{"cells":{"11":{"styles":15,"text":" "},"12":{"styles":16,"text":" "},"13":{"styles":17,"text":" "},"14":{"styles":18,"text":" "},"15":{"styles":19,"text":" "},"16":{"styles":20,"text":" "},"17":{"styles":21,"text":" "}},"height":23.75},"3":{"cells":{"1":{"style":322,"merge":[0,8],"height":25,"text":" ","rendered":"","config":""}}},"4":{"cells":{"1":{"merge":[0,1],"height":23.75,"text":"姓名: #{report_person_base.name}","style":275},"3":{"text":"性别:#{report_person_base.sex}","style":278},"4":{"text":"婚姻:#{report_person_base.marriage}","style":301},"5":{"text":"体检号:#{report_person_base.penumber}","style":278,"merge":[0,2],"height":23.75,"rendered":"","config":""},"8":{"text":"#{report_person_base.picture}","rendered":"","config":"","display":"img","style":252,"merge":[2,1],"height":103.5},"10":{"styles":26,"text":" "}},"height":39.75},"5":{"cells":{"1":{"style":275,"text":" "},"2":{"style":275,"text":" "},"3":{"style":275,"text":" "},"4":{"style":275,"text":" "},"5":{"style":275,"text":" "},"6":{"style":275,"text":" "},"7":{"style":275,"text":" "},"10":{"text":"","rendered":"","config":""}}},"6":{"cells":{"1":{"merge":[0,1],"height":38.75,"text":"日期:#{report_person_base.ordertime}","style":275},"3":{"text":"年龄:#{report_person_base.age}","style":278},"4":{"text":"联系电话:#{zm_person_report.name}","style":278},"5":{"styles":30,"style":275,"text":"#{report_person_base.phone}","merge":[0,1],"height":38.75},"7":{"styles":31,"style":275,"text":" "},"10":{"styles":33,"text":" "},"12":{"text":"","rendered":"","config":""}},"height":38.75},"7":{"cells":{"1":{"style":322,"merge":[0,8],"height":24.5,"text":" "},"10":{"text":"","rendered":"","config":""},"11":{"text":"","rendered":"","config":""}},"height":24.5},"8":{"cells":{"1":{"text":"尊敬的客户:","rendered":"","config":"","merge":[0,7],"height":23.75,"style":275},"9":{"style":275,"text":" "},"10":{"styles":47,"text":" "},"11":{"text":"","rendered":"","config":""}},"height":23.75},"9":{"cells":{"1":{"merge":[0,7],"height":21.75,"text":" 欢迎您光临我院，感谢您对我们工作的信任和支持！? ","style":275},"9":{"style":275,"text":" "},"10":{"styles":54,"text":" "}},"height":21.75},"10":{"cells":{"1":{"merge":[5,8],"height":143.75,"text":"? 健康体检是针对自然人群有无影响健康的异常指标进行筛查的过程,健康体检不是疾病诊断，是对一些可疑指标或结果，建议进一步检查或追踪观察。祈望在健康没有出现大问题之前，把所有异常问题都提前发现并解决。由于科学技术发展的局限性，个体间可能存在的生物差异，任何一次医学检查的手段和方法都不具备绝对的特异性和灵敏性（即不存在100%的可靠和准确性），我们建议您对异常结果进行随访复查和其它相关的检查，便于医生有更多更详实的医学证据去进行初步医学判断。同时，为了您的健康，我们建议您每年进行一次健康体检。对有异常结果者，作不定期复查。我们愿为您的健康保驾护航。最后欢迎您再次莅临健康体检。","style":281},"10":{"styles":61,"text":" "},"11":{"text":"","rendered":"","config":""}},"height":23.75},"11":{"cells":{"10":{"styles":84,"text":" "},"12":{"text":"","rendered":"","config":""}},"height":23.75},"12":{"cells":{"10":{"styles":91,"text":" "}},"height":23},"13":{"cells":{"10":{"styles":93,"text":" "},"12":{"text":"","rendered":"","config":""}},"height":24.5},"16":{"cells":{"1":{"text":""},"2":{},"3":{},"4":{},"5":{},"6":{},"7":{},"8":{},"9":{}}},"17":{"cells":{"1":{"merge":[0,8],"height":25,"text":" ","style":283}}},"18":{"cells":{"5":{"merge":[0,1],"height":25,"text":" ","style":285},"7":{"merge":[0,1],"height":25,"text":" ","style":275}}},"20":{"cells":{"1":{"merge":[0,7],"height":25,"text":"☆温馨提示：","style":275},"9":{"text":""},"12":{"text":""}}},"21":{"cells":{"1":{"merge":[0,4],"height":25,"text":"??????? 一、本次体检化验报告只对本次送检标本负责。","style":275},"6":{"style":275,"text":" "},"7":{"style":275,"text":" "},"8":{"style":275,"text":" "},"9":{"text":""},"11":{"text":""}}},"22":{"cells":{"1":{"merge":[0,4],"height":25,"text":"??????? 二、本次健康体检报告仅做为健康保健之用，如对检查结果有异议请于一周内来银川中美宁大医院咨询。","style":275},"6":{"style":275,"text":" "},"7":{"style":275,"text":" "},"8":{"text":" ","style":275},"9":{"text":""}}},"23":{"cells":{"1":{"merge":[0,4],"height":25,"text":"??????? 三、本次健康体检后，您需要健康维护与管理。","style":275},"6":{"style":275,"text":" "},"7":{"style":275,"text":" "},"8":{"style":275,"text":" "}}},"36":{"cells":{"2":{"text":"????? ","merge":[0,3],"height":25,"style":106}}},"37":{"cells":{"1":{"text":"【基本信息】","style":325,"merge":[0,8],"height":25}}},"38":{"cells":{"1":{"merge":[0,1],"height":23.75,"text":"体检号:#{report_person_base.penumber}","style":288},"3":{"text":"姓名:#{report_person_base.name}","style":288},"4":{"text":"性别:#{report_person_base.sex}","style":288},"5":{"text":"婚姻:#{report_person_base.marriage}","style":288,"merge":[0,4],"height":23.75},"10":{"styles":101,"text":" "}},"height":23.75},"39":{"cells":{"1":{"merge":[0,1],"height":25,"text":"年龄:#{report_person_base.age}","style":288},"3":{"text":"体检时间:#{report_person_base.ordertime}","merge":[0,6],"height":25,"style":288}}},"40":{"cells":{"1":{"text":"体检团队:#{report_person_base.companyname}","style":289,"merge":[0,1],"height":25},"3":{"text":"批次:#{report_person_base.departname}","style":289,"rendered":"","config":""},"4":{"merge":[0,5],"height":25,"style":288,"text":"团体ID号:#{report_person_base.pedepartid}"}}},"43":{"cells":{"1":{"merge":[0,8],"height":25,"text":"【${health_common_report.depart_name}检查】 ","style":325}}},"44":{"cells":{"1":{"merge":[0,1],"height":25,"text":" ","style":275}}},"45":{"cells":{"1":{"style":288,"text":"#{health_common_report_child.itemname}","loopBlock":1},"2":{"style":288,"text":"#{health_common_report_child.result}","merge":[0,1],"height":25,"loopBlock":1},"3":{"text":"","loopBlock":1},"6":{"text":""}}},"47":{"cells":{"1":{"text":"","loopBlock":0},"2":{"text":"","loopBlock":0}}},"48":{"cells":{"1":{"text":""},"2":{"text":""},"3":{"text":""}}},"49":{"cells":{"1":{"merge":[0,8],"height":25,"text":"【内外科检查】 ","style":325}}},"51":{"cells":{"1":{"style":292,"text":"#{health_inner_vs_out.group(departname)}","loopBlock":0,"zonedEdition":0,"merge":[0,1],"height":25,"aggregate":"group"},"2":{"text":"","loopBlock":0,"zonedEdition":0},"3":{"style":288,"text":"#{health_inner_vs_out.itemname}","loopBlock":0,"zonedEdition":0},"4":{"style":288,"text":"#{health_inner_vs_out.result}","loopBlock":0,"merge":[0,5],"height":25,"zonedEdition":0},"5":{"text":"","loopBlock":0,"zonedEdition":0},"6":{"text":"","loopBlock":0,"zonedEdition":0},"7":{"text":"","loopBlock":0,"zonedEdition":0},"8":{"text":"","loopBlock":0,"zonedEdition":0},"9":{"text":"","loopBlock":0,"zonedEdition":0}}},"52":{"cells":{"4":{"text":""}}},"53":{"cells":{"1":{"merge":[0,8],"height":25,"text":"【检验科检查】 ","style":325}}},"54":{"cells":{"1":{"text":"项目","style":292},"2":{"text":"明细","style":292},"3":{"text":"结果","style":292,"merge":[0,1],"height":25},"5":{"text":"标识","style":292},"6":{"text":"参考值","merge":[0,1],"height":25,"style":292},"8":{"text":"单位","style":292},"9":{"text":"检查者","style":292}}},"55":{"cells":{"1":{"style":292,"text":"#{report_person_result.combname}","aggregate":"select"},"2":{"style":292,"text":"#{report_person_result.itemname}"},"3":{"style":292,"text":"#{report_person_result.phyresult}","merge":[0,1],"height":25},"5":{"style":292,"text":"#{report_person_result.resulttips}"},"6":{"merge":[0,1],"height":25,"style":292,"text":"#{report_person_result.resultdownvalue}-#{report_person_result.resultupvalue}"},"8":{"style":292,"text":"#{report_person_result.resultunit}"},"9":{"style":292,"text":"#{report_person_result.checker}"}}},"56":{"cells":{"3":{"text":""}}},"57":{"cells":{"15":{"text":"","rendered":"","config":""}}},"58":{"cells":{"1":{"merge":[0,8],"height":25,"text":"【其他科室检查】 ","style":328,"loopBlock":0,"zonedEdition":0}}},"59":{"cells":{"1":{"text":"科室","loopBlock":0,"zonedEdition":0,"style":292},"2":{"text":"项目","loopBlock":0,"zonedEdition":0,"style":292},"3":{"text":"明细","style":292,"loopBlock":0},"4":{"text":"结果","loopBlock":0,"zonedEdition":0,"style":292,"merge":[0,5],"height":25}}},"60":{"cells":{"1":{"text":"#{health_other_result.group(depname)}","loopBlock":0,"zonedEdition":0,"style":293,"aggregate":"group","sort":"asc"},"2":{"text":"#{health_other_result.group(combname)}","loopBlock":0,"zonedEdition":0,"style":293,"aggregate":"group"},"3":{"text":"#{health_other_result.itemname}","loopBlock":0,"zonedEdition":0,"style":293},"4":{"text":"#{health_other_result.phyresult}","loopBlock":0,"zonedEdition":0,"style":289,"merge":[0,5],"height":25}}},"61":{"cells":{"1":{"text":"","loopBlock":0},"2":{"text":"","loopBlock":0},"3":{"text":"","loopBlock":0},"4":{"text":"","loopBlock":0},"5":{"text":"","loopBlock":0},"6":{"text":"","loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"text":"","loopBlock":0},"9":{"text":"","loopBlock":0}}},"62":{"cells":{"1":{"text":"","loopBlock":0},"2":{"text":"","loopBlock":0},"3":{"text":"","loopBlock":0},"4":{"text":"","loopBlock":0},"5":{"text":"","loopBlock":0},"6":{"text":"","loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"text":"","loopBlock":0},"9":{"text":"","loopBlock":0}}},"63":{"cells":{"1":{"text":"","loopBlock":0},"2":{"text":"","loopBlock":0},"3":{"text":"","loopBlock":0},"4":{"text":"","loopBlock":0},"5":{"text":"","loopBlock":0},"6":{"text":"","loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"text":"","loopBlock":0},"9":{"text":"","loopBlock":0}}},"64":{"cells":{"1":{"loopBlock":0},"2":{"text":"","loopBlock":0},"3":{"text":"","loopBlock":0},"4":{"text":"","loopBlock":0},"5":{"text":"","loopBlock":0},"6":{"text":"","loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"text":"","loopBlock":0},"9":{"text":"","loopBlock":0}}},"65":{"cells":{"1":{"loopBlock":0},"2":{"loopBlock":0},"3":{"loopBlock":0},"4":{"loopBlock":0},"5":{"loopBlock":0},"6":{"loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"loopBlock":0},"9":{"loopBlock":0}}},"66":{"cells":{"1":{"loopBlock":0},"2":{"loopBlock":0,"rendered":"","config":""},"3":{"loopBlock":0},"4":{"loopBlock":0},"5":{"loopBlock":0},"6":{"loopBlock":0},"7":{"text":"","loopBlock":0},"8":{"loopBlock":0},"9":{"loopBlock":0}},"height":37},"67":{"cells":{"1":{"style":316,"text":"【总检提示】","merge":[0,8],"height":25,"rendered":"","config":"","display":"normal","zonedEdition":0}}},"68":{"cells":{"1":{"text":"${report_person_final.summary}","rendered":"","config":"","merge":[0,8],"height":25,"style":283}}},"69":{"cells":{"1":{"style":275,"text":" ","zonedEdition":0},"2":{"style":275,"text":" ","zonedEdition":0},"3":{"style":275,"text":" ","zonedEdition":0,"rendered":"","config":""},"4":{"style":275,"text":" ","zonedEdition":0},"5":{"merge":[0,1],"height":25,"text":"总检医生:","style":285,"rendered":"","config":"","display":"normal","zonedEdition":0},"7":{"merge":[0,1],"height":25,"text":"${report_person_final.totaldoctor}","style":275,"zonedEdition":0,"rendered":"","config":""},"9":{"style":275,"text":" ","zonedEdition":0}}},"70":{"cells":{"5":{"merge":[0,1],"height":25,"text":"咨询电话:","style":285},"7":{"merge":[0,1],"height":25,"text":"0951-5987288","style":275}}},"71":{"cells":{"5":{"merge":[0,1],"height":25,"text":"报告日期:","style":285,"rendered":"","config":""},"7":{"merge":[0,1],"height":25,"text":"=now()","style":340},"10":{"text":"","rendered":"","config":""}}},"72":{"cells":{"1":{"text":"说明：","style":297},"2":{"text":" ","style":297,"rendered":"","config":""},"3":{"style":275,"text":" ","rendered":"","config":""},"4":{"style":275,"text":" "},"5":{"style":275,"text":" ","merge":[0,1],"height":25,"rendered":"","config":""},"9":{"style":275,"text":" "}}},"73":{"cells":{"1":{"text":"1.以上是对本次体检部分阳性结果的解释和建议，请您详细阅读本报告的全部内容，如发现其他异常结果或有特殊疑问，","style":298,"merge":[0,8],"height":25},"11":{"text":"","rendered":"","config":""}}},"74":{"cells":{"1":{"merge":[0,8],"height":25,"text":"请及时预约中心专家咨询，必要时进行复查以免延误诊断。","style":297,"rendered":"","config":""}}},"75":{"cells":{"1":{"merge":[0,8],"height":25,"text":"2.本次体检报告反映的只是本次检查的结果及评估。","style":297}}},"76":{"cells":{"1":{"text":"3.本次体检设定为健康体检，其结果与评估仅供参考使用。如要进行特殊疾病的筛查与诊断，请咨询专家后选择特定","style":299,"merge":[0,8],"height":25}}},"77":{"cells":{"1":{"merge":[0,8],"height":25,"text":"检查项目，以免漏检","style":297},"12":{"text":"","rendered":"","config":""}}},"78":{"cells":{"1":{"merge":[0,8],"height":25,"text":"4.本体检报告为个人健康体检保密资料，我们已提供了独立保密包装，请注意保管。","style":297}}},"81":{"cells":{"2":{"text":""},"5":{"text":""}}},"94":{"cells":{"3":{"text":"","loopBlock":0},"4":{"text":"","loopBlock":0}}},"len":111,"-1":{"cells":{"1":{"text":"#{health_common_report_child.result}"}}}},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"50","btnList":[1,2,3,4,5,6,9,7]},"groupField":"health_inner_vs_out.departname","freeze":"A1","dataRectWidth":1517,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"left":["thin","#000000"]},"color":"#000000","align":"center","font":{"size":24,"bold":true}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":11,"bold":true}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11,"bold":true}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11,"bold":true}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thin","#000000"],"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{},"color":"#000000","font":{"size":11,"bold":true}},{"border":{"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11}},{"border":{"left":["thin","#000000"],"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11,"bold":true}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11,"bold":true}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thin","#000000"],"right":["thin","#000000"]},"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11},"textwrap":true},{"color":"#000000","font":{"size":11},"textwrap":false},{"color":"#000000","font":{"size":11,"bold":true}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"font":{"bold":true}},{"border":{"bottom":["thin","#000"]}},{"font":{"bold":true,"size":12}},{"border":{},"color":"#000000","font":{"size":12,"bold":true}},{"border":{"left":["thin","#000000"]},"color":"#000000","font":{"size":12,"bold":true}},{"border":{"top":["thin","#000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thick","#000"]},"color":"#000000","font":{"size":11}},{"border":{"top":["thick","#000"]}},{"border":{"top":["thick","#000"]},"color":"#000000","font":{"size":11,"bold":true}},{"border":{"bottom":["thick","#000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["thick","#000"]}},{"border":{"bottom":["thin","#000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["dashed","#000"]},"color":"#000000","font":{"size":12,"bold":true}},{"font":{"bold":true,"size":12},"border":{"bottom":["dashed","#000"]}},{"border":{"left":["dashed","#000"]},"color":"#000000","font":{"size":11}},{"border":{"bottom":["dashed","#000"],"top":["dashed","#000"],"left":["dashed","#000"],"right":["dashed","#000"]},"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":11},"textwrap":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"]},"color":"#000000","font":{"size":11}},{"color":"#000000","font":{"size":12,"bold":true}},{},{"bgcolor":"#93d051"},{"color":"#000000","font":{"size":12,"bold":true},"bgcolor":"#93d051"},{"font":{"bold":true,"size":12},"bgcolor":"#93d051"},{"color":"#000000","font":{"size":12,"bold":true},"bgcolor":"#93d051","border":{"bottom":["thin","#365624"],"top":["thin","#365624"],"left":["thin","#365624"],"right":["thin","#365624"]}},{"font":{"bold":true,"size":12},"bgcolor":"#93d051","border":{"bottom":["thin","#365624"],"top":["thin","#365624"],"left":["thin","#365624"],"right":["thin","#365624"]}},{"color":"#000000","font":{"size":12,"bold":true},"bgcolor":"#93d051","border":{"bottom":["thin","#365624"]}},{"font":{"bold":true,"size":12},"bgcolor":"#93d051","border":{"bottom":["thin","#365624"]}},{"bgcolor":"#93d051","border":{"bottom":["thin","#365624"]}},{"color":"#000000","font":{"size":11,"bold":true},"format":"normal"},{"format":"normal"},{"align":"left"},{"align":"left","valign":"top"},{"align":"left","valign":"top","textwrap":true},{"align":"left","valign":"top","textwrap":false},{"textwrap":true},{"textwrap":true,"valign":"top"},{"align":"right"},{"align":"right","valign":"top"},{"align":"right","valign":"middle"},{"align":"right","valign":"middle","textwrap":true},{"textwrap":true,"align":"left"},{"font":{"bold":true},"color":"#000100"},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"],"right":["thin","#365624"]}},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"],"right":["thin","#365624"]},"bgcolor":"#538136"},{"bgcolor":"#538136"},{"border":{"top":["thin","#365624"],"left":["thin","#365624"]}},{"border":{"top":["thin","#365624"]}},{"border":{"top":["thin","#365624"],"right":["thin","#365624"]}},{"border":{"left":["thin","#365624"]}},{"border":{"right":["thin","#365624"]}},{"border":{"bottom":["thin","#365624"],"left":["thin","#365624"]}},{"border":{"bottom":["thin","#365624"],"right":["thin","#365624"]}},{"border":{"bottom":["thin","#365624"],"right":["thin","#365624"]},"align":"left"},{"border":{"bottom":["thin","#365624"],"right":["thin","#365624"]},"align":"left","valign":"middle"},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"]}},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"]}},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"right":["thin","#365624"]}},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"]},"bgcolor":"#538136"},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"]},"bgcolor":"#538136"},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"right":["thin","#365624"]},"bgcolor":"#538136"},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"]},"bgcolor":"#538136","font":{"bold":true}},{"border":{"top":["thin","#365624"],"bottom":["thin","#365624"],"left":["thin","#365624"],"right":["thin","#365624"]},"bgcolor":"#538136","font":{"bold":true}},{"bgcolor":"#538136","font":{"bold":true}},{"font":{"bold":true},"color":"#000100","align":"left"},{"font":{"bold":true},"color":"#000100","align":"left","valign":"top"},{"font":{"bold":true},"color":"#000100","align":"left","valign":"top","textwrap":true},{"align":"center"},{"align":"center","valign":"middle"},{"align":"right","valign":"middle","font":{"bold":true}},{"align":"right","valign":"middle","font":{"bold":true},"color":"#000100"},{"align":"right","font":{"bold":true}},{"align":"right","font":{"bold":true},"color":"#000100"},{"align":"right","valign":"middle","font":{"bold":true},"color":"#000100","border":{"bottom":["thin","#000"]}},{"align":"right","font":{"bold":true},"color":"#000100","border":{"bottom":["thin","#000"]}},{"align":"left","valign":"middle","font":{"bold":true},"color":"#000100","border":{"bottom":["thin","#000"]}},{"align":"left","font":{"bold":true},"color":"#000100","border":{"bottom":["thin","#000"]}},{"border":{"top":["thin","#000"]}},{"font":{"bold":true},"align":"left"},{"font":{"bold":true},"align":"left","valign":"top"},{"font":{"bold":true},"align":"left","valign":"top","textwrap":true},{"font":{"bold":false}},{"font":{"bold":false},"align":"left"},{"font":{"bold":false},"align":"left","valign":"top"},{"font":{"bold":false},"align":"left","valign":"top","textwrap":true},{"bgcolor":"#a7d08c"},{"bgcolor":"#a7d08c","font":{"bold":true}},{"bgcolor":"#a7d08c","font":{"bold":true},"align":"left"},{"border":{"top":["thick","#000"],"left":["thick","#000"]}},{"border":{"top":["thick","#000"],"right":["thick","#000"]}},{"border":{"bottom":["thick","#000"],"left":["thick","#000"]}},{"border":{"bottom":["thick","#000"],"right":["thick","#000"]}},{"border":{"bottom":["thick","#000"],"top":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"right":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"font":{"bold":true,"size":10}},{"font":{"bold":true,"size":15}},{"font":{"bold":true,"size":18}},{"font":{"bold":true,"size":18},"align":"center"},{"bgcolor":"#365624"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","valign":"middle"},{"align":"right","border":{"bottom":["thick","#000"],"top":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]}},{"align":"left","font":{"bold":true},"color":"#000100","border":{"bottom":["thick","#000"],"top":["thick","#000"],"left":["thick","#000"],"right":["thick","#000"]}},{"align":"right","border":{"bottom":["thick","#000"]}},{"align":"left","font":{"bold":true},"color":"#000100","border":{"bottom":["thick","#000"]}},{"bgcolor":"#a7d08c","border":{"bottom":["thick","#000"]}},{"align":"left","valign":"middle","font":{"bold":true},"color":"#000100"},{"font":{"bold":true},"bgcolor":"#365624"},{"align":"left","valign":"top","textwrap":true,"font":{"size":12}},{"align":"left","valign":"top","textwrap":true,"font":{"size":12,"bold":true}},{"align":"left","valign":"top","textwrap":true,"font":{"size":12,"bold":false}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"align":"center"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"font":{"bold":true},"border":{"top":["thin","#000"]}},{"font":{"bold":true},"border":{"top":["thin","#000"]},"textwrap":true},{"font":{"bold":true},"border":{"top":["thin","#000"]},"textwrap":true,"align":"left"},{"font":{"bold":true},"border":{"top":["thin","#000"]},"textwrap":true,"align":"left","valign":"top"},{"font":{"bold":true},"border":{"top":["thin","#000"]},"textwrap":false,"align":"left","valign":"top"},{"font":{"bold":true},"valign":"top"},{"font":{"bold":true},"valign":"top","textwrap":true},{"font":{"bold":true},"valign":"middle","textwrap":true},{"font":{"bold":true},"align":"left","valign":"middle","textwrap":true},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","valign":"top"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","valign":"top"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"align":"center","valign":"top"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"]},"align":"left","valign":"top"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"right":["thin","#000"]},"align":"center","valign":"bottom"},{"align":"center","valign":"bottom"},{"align":"center","valign":"bottom","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","valign":"middle"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","valign":"middle","textwrap":true},{"font":{"bold":false,"size":12}},{"align":"left","valign":"top","textwrap":true,"font":{"size":12,"bold":false},"color":"#5b9cd6"},{"font":{"bold":false,"size":12},"color":"#5b9cd6"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false},{"color":"#000000","font":{"size":10}},{"font":{"size":10}},{"color":"#000000","font":{"size":10},"textwrap":true},{"align":"left","valign":"top","textwrap":true,"font":{"size":12,"bold":false},"color":"#000100"},{"color":"#000100"},{"align":"left","valign":"middle","textwrap":true},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"color":"#ffffff"},{"color":"#ffffff"},{"align":"center","textwrap":true},{"border":{"bottom":["dashed","#000"],"top":["dashed","#000"],"left":["dashed","#000"],"right":["dashed","#000"]},"color":"#ffffff"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#538136"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#538136","font":{"bold":true}},{"font":{"bold":true},"align":"center","valign":"middle","textwrap":true},{"font":{"bold":true},"align":"center","valign":"middle","textwrap":false},{"bgcolor":"#c5e0b3"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3","font":{"bold":true}},{"bgcolor":"#c5e0b3","border":{"bottom":["thin","#000"]}},{"bgcolor":"#c5e0b3","border":{"bottom":["medium","#000"]}},{"bgcolor":"#c5e0b3","border":{"bottom":["medium","#000100"]}},{"bgcolor":"#c5e0b3","border":{"bottom":["thick","#000100"]}},{"bgcolor":"#c5e0b3","border":{"bottom":["thick","#000100"]},"font":{"size":14}},{"bgcolor":"#c5e0b3","font":{"size":14}},{"bgcolor":"#c5e0b3","border":{"bottom":["thick","#000100"]},"font":{"size":14,"name":"宋体"}},{"bgcolor":"#c5e0b3","font":{"size":14,"name":"宋体"}},{"bgcolor":"#c5e0b3","font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3","font":{"bold":true,"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3","font":{"bold":true,"name":"宋体","size":14}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3","font":{"bold":false,"name":"宋体","size":14}},{"bgcolor":"#c5e0b3","font":{"size":14,"name":"宋体","bold":false}},{"font":{"name":"宋体"}},{"font":{"name":"宋体","size":12}},{"color":"#000000","font":{"size":10,"name":"宋体"}},{"color":"#000000","font":{"size":10,"name":"宋体"},"textwrap":true},{"color":"#000000","font":{"size":12,"name":"宋体"}},{"color":"#000000","font":{"size":12,"name":"宋体"},"textwrap":true},{"align":"left","valign":"top","textwrap":true,"font":{"name":"宋体"}},{"align":"left","valign":"top","textwrap":true,"font":{"name":"宋体","size":12}},{"textwrap":true,"font":{"name":"宋体"}},{"textwrap":true,"font":{"name":"宋体","size":12}},{"align":"right","font":{"name":"宋体"}},{"align":"right","font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"name":"宋体","size":12}},{"font":{"bold":true,"name":"宋体"}},{"font":{"bold":true,"name":"宋体"},"align":"center","valign":"middle","textwrap":false},{"font":{"bold":true,"name":"宋体"},"valign":"middle","textwrap":true},{"font":{"bold":true,"name":"宋体","size":12}},{"font":{"bold":true,"name":"宋体","size":12},"align":"center","valign":"middle","textwrap":false},{"font":{"bold":true,"name":"宋体","size":12},"valign":"middle","textwrap":true},{"color":"#000000","font":{"size":12,"name":"宋体"},"textwrap":true,"align":"center"},{"color":"#000000","font":{"size":12,"name":"宋体"},"textwrap":true,"align":"center","valign":"middle"},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"name":"宋体","size":10}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":10}},{"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center","font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10},"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]}},{"border":{"bottom":["thick","#000100"],"top":["thick","#000100"],"left":["thick","#000100"],"right":["thick","#000100"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":10}},{"border":{"bottom":["thick","#000100"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10},"border":{"bottom":["thick","#000100"]}},{"border":{"bottom":["thin","#000100"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10},"border":{"bottom":["thin","#000100"]}},{"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]},"align":"center","font":{"name":"宋体","size":10}},{"font":{"name":"宋体","size":10},"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]}},{"border":{"bottom":["thin","#000100"],"top":["thin","#000100"],"left":["thin","#000100"],"right":["thin","#000100"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":10}},{"bgcolor":"#c5e0b3","font":{"name":"宋体","size":12}},{"textwrap":true,"font":{"name":"宋体","size":12},"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"font":{"name":"宋体","size":12},"border":{"bottom":["thin","#000"],"left":["thin","#000"]}},{"font":{"name":"宋体","size":12},"border":{"bottom":["thin","#000"]}},{"align":"right","font":{"name":"宋体","size":12},"border":{"bottom":["thin","#000"]}},{"font":{"name":"宋体","size":12},"border":{"bottom":["thin","#000"],"right":["thin","#000"]}},{"bgcolor":"#a7d08c","border":{"bottom":["thin","#000"]}},{"font":{"name":"宋体","size":14}},{"font":{"name":"宋体","size":14,"bold":true}},{"bgcolor":"#c5e0b3","font":{"size":14,"name":"宋体","bold":true}},{"font":{"name":"宋体","size":14,"bold":true},"color":"#c5e0b3"},{"font":{"name":"宋体","size":14,"bold":true},"color":"#000100"},{"font":{"name":"宋体","size":14,"bold":true},"color":"#000100","bgcolor":"#c5e0b3"},{"border":{"top":["thin","#000"],"left":["thin","#000"]},"align":"center"},{"border":{"top":["thin","#000"]},"align":"center"},{"border":{"top":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"right":["thin","#000"]}},{"align":"center","font":{"name":"宋体","size":12}},{"font":{"size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false,"font":{"name":"宋体","size":12}},{"format":"date2"},{"format":"date2","font":{"name":"宋体"}},{"format":"date2","font":{"name":"宋体","size":12}}],"validations":[],"isGroup":true,"cols":{"0":{"width":19},"1":{"width":93},"2":{"width":68},"3":{"width":125},"4":{"width":87},"5":{"width":76},"6":{"width":52},"7":{"width":70},"8":{"width":65},"9":{"width":62},"len":50},"merges":["B1:H3","B4:J4","B5:C5","F5:H5","I5:J7","B7:C7","F7:G7","B8:J8","B9:I9","B10:I10","B11:J16","B18:J18","F19:G19","H19:I19","B21:I21","B22:F22","B23:F23","B24:F24","C37:F37","B38:J38","B39:C39","F39:J39","B40:C40","D40:J40","B41:C41","E41:J41","B44:J44","B45:C45","C46:D46","B50:J50","B52:C52","E52:J52","B54:J54","D55:E55","G55:H55","D56:E56","G56:H56","B59:J59","E60:J60","E61:J61","B68:J68","B69:J69","F70:G70","H70:I70","F71:G71","H71:I71","F72:G72","H72:I72","F73:G73","B74:J74","B75:J75","B76:J76","B77:J77","B78:J78","B79:J79"]}',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 ('report_person_base','个人基本信息','1','2022-03-04 14:29:58','0',null,'','659612132272533504','659612131995709440',' 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 t3.depart_name IS NULL
??????????? THEN ''无''
??????????? ELSE
??????????? t3.depart_name
??????????? END AS departName,
??????????? CASE
??????????? WHEN t3.company_name IS NULL
??????????? THEN ''无''
??????????? ELSE
??????????? t3.company_name
??????????? END AS companyName,
???????? CONCAT(CONCAT(''${ipport}'',''/sys/common/static/''),t2.picture) AS picture
??????? FROM
??????????? pe_user_info t1
??????????????? INNER JOIN pe_regist t2
?????????????????????????? ON t1.id = t2.pe_user_id
??????????????? LEFT JOIN pe_depart t3 ON t2.pe_depart_id=t3.id
??????? WHERE t1.del_flag = 0
????????? AND t2.del_flag = 0
????????? AND t2.id =''${regid}''','0','2022-03-07 11:41:39',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-03-04 14:29:58','String',0,null,'age',null,'659612132499025920',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',1,null,'name',null,'659612132528386048',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',2,null,'phone',null,'659612132540968960',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',3,null,'marriage',null,'659612132549357568',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',4,null,'sex',null,'659612132561940480',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',5,null,'penumber',null,'659612132574523392',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',6,null,'pedepartid',null,'659612132582912000',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',7,null,'ordertime',null,'659612132595494912',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',8,null,'regid',null,'659612132608077824',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',9,null,'departname',null,'659612132620660736',null,null,'admin','659612132272533504',null,null,null,'departname',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-03-04 14:29:58','String',10,null,'companyname',null,'659612132629049344',null,null,'admin','659612132272533504',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-03-04 14:29:58','String',11,null,'picture',null,'659612132641632256',null,null,'admin','659612132272533504',null,null,null,'picture',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-03-04 14:29:58','659612132272533504','regid',1,null,null,'',null,'659612132654215168',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-03-04 14:29:58','659612132272533504','ipport',2,null,null,'',null,'659612132683575296',0,null,'admin','ipport',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 ('report_person_result','检验科结果','1','2022-03-07 09:40:20','0',null,'','659612132721324032','659612131995709440','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 t1.diseases_flag = 0
? AND t2.del_flag=0
? AND t2.id IN (SELECT id FROM sys_depart WHERE lis_flag=1 )
ORDER BY t2.depart_order ASC','0','2022-03-07 11:41:39',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-03-07 09:40:21','String',0,null,'regid',null,'659612132830375936',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',1,null,'resulttype',null,'659612132842958848',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',2,null,'combid',null,'659612132855541760',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',3,null,'itemid',null,'659612132868124672',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',4,null,'itemname',null,'659612132876513280',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',5,null,'phyresult',null,'659612132893290496',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',6,null,'resultunit',null,'659612132901679104',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',7,null,'resultupvalue',null,'659612132914262016',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',8,null,'resultdownvalue',null,'659612132926844928',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',9,null,'resulttips',null,'659612132939427840',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',10,null,'negflag',null,'659612132952010752',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',11,null,'deptid',null,'659612132960399360',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',12,null,'checker',null,'659612132972982272',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',13,null,'createby',null,'659612132981370880',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',14,null,'depname',null,'659612132993953792',null,null,'admin','659612132721324032',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-03-07 09:40:21','String',15,null,'combname',null,'659612133002342400',null,null,'admin','659612132721324032',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-03-07 09:40:21','659612132721324032','regid',1,null,null,'',null,'659612133014925312',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 ('report_person_final','总检结论','0','2022-03-04 14:29:58','0',null,'','659612133044285440','659612131995709440',' SELECT
??????????? summary,
??????????? reg_id AS regId,
??????????? advise,
??????????? 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=0','0','2022-03-07 11:41:39',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-03-04 14:29:58','String',0,null,'summary',null,'659612133061062656',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',1,null,'rechecktime',null,'659612133069451264',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',2,null,'totaldoctor',null,'659612133082034176',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',3,null,'notiflag',null,'659612133094617088',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',4,null,'createby',null,'659612133107200000',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',5,null,'notifyuser',null,'659612133115588608',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',6,null,'advise',null,'659612133132365824',null,null,'admin','659612133044285440',null,null,null,'advise',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-03-04 14:29:58','String',7,null,'recheckdays',null,'659612133170114560',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',8,null,'penumber',null,'659612133182697472',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',9,null,'regid',null,'659612133203668992',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',10,null,'checkdoctor',null,'659612133220446208',null,null,'admin','659612133044285440',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-03-04 14:29:58','String',11,null,'rechecksummary',null,'659612133233029120',null,null,'admin','659612133044285440',null,null,null,'rechecksummary',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-03-04 14:29:58','659612133044285440','regid',1,null,null,'',null,'659612133258194944',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 ('health_common_report','一般科室检查','0','2022-03-07 11:38:35','0',null,'','659616474232811520','659612131995709440','SELECT id,depart_name FROM sys_depart WHERE parent_id !='''' AND del_flag=0 ORDER BY depart_order ASC LIMIT 0,1','0','2022-03-07 11:41:39',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-03-07 11:38:35','String',0,null,'id',null,'659616474266365952',null,null,'admin','659616474232811520',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-03-07 11:38:35','String',1,null,'depart_name',null,'659616474291531776',null,null,'admin','659616474232811520',null,null,null,'depart_name',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 ('health_common_report_child','一般科室详情','1','2022-03-07 10:21:23','0',null,'','659616770275176448','659612131995709440','SELECT
? t1.reg_id AS regId,
? t1.item_name AS itemName,
? (CASE
? WHEN? t1.result_unit IS NULL
? THEN t1.phy_result
? ELSE
? CONCAT(t1.phy_result, ''/'', t1.result_unit)
? END) AS result
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 t1.diseases_flag = 0
? AND t2.id=''${departid}''','0','2022-03-07 11:41:39',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-03-07 10:21:23','String',0,null,'regid',null,'659616927213449216',null,null,'admin','659616770275176448',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-03-07 10:21:23','String',1,null,'itemname',null,'659616927276363776',null,null,'admin','659616770275176448',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-03-07 10:21:23','String',2,null,'result',null,'659645195509592064',null,null,'admin','659616770275176448',null,null,null,'result',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-03-07 10:21:23','659616770275176448','regid',1,null,null,'',null,'659616927427358720',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-03-07 10:21:23','659616770275176448','departid',3,null,null,'',null,'659617301467000832',0,null,'admin','departid',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 ('health_inner_vs_out','内外科检查','1','2022-03-07 11:40:08','0',null,'','659648180084043776','659612131995709440','SELECT
? t1.reg_id AS regId,
? t1.item_name AS itemName,
? (CASE
? WHEN? t1.result_unit IS NULL
? THEN t1.phy_result
? ELSE
? CONCAT(t1.phy_result, ''/'', t1.result_unit)
? END) AS result,
? t2.depart_name AS departName
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 t1.diseases_flag = 0
? AND t2.id IN (SELECT id? FROM sys_depart WHERE parent_id !='''' AND del_flag=0 AND (depart_name LIKE ''%内科%'' OR depart_name LIKE ''%外科%'') )','0','2022-03-07 11:41:39',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-03-07 11:40:08','String',0,null,'regid',null,'659648180121792512',null,null,'admin','659648180084043776',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-03-07 11:40:08','String',1,null,'itemname',null,'659648180142764032',null,null,'admin','659648180084043776',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-03-07 11:40:08','String',2,null,'result',null,'659648180155346944',null,null,'admin','659648180084043776',null,null,null,'result',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-03-07 11:40:08','String',3,null,'departname',null,'659657670481178624',null,null,'admin','659648180084043776',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-03-07 11:40:08','659648180084043776','departid',1,null,null,'',null,'659648180172124160',0,null,'admin','departid',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-03-07 11:40:08','659648180084043776','regid',2,null,null,'',null,'660636689259327488',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 ('health_other_result','其他科室检查','1','2022-03-07 11:41:39','0',null,'','660626234012889088','659612131995709440','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
? INNER JOIN
??? (SELECT
????? id,
????? depart_name,
????? depart_order
??? FROM
????? sys_depart
??? WHERE del_flag = 0
????? AND ! (
??????? depart_name = ''外科''
??????? OR depart_name = ''内科''
??????? OR depart_name = ''检验科''
??????? OR depart_name = ''一般情况''
??????? OR depart_name = ''一般检查''
????? )
????? AND parent_id !=''''
????? AND del_flag = 0) t2
??? ON t1.dept_id = t2.id
? LEFT JOIN pe_combinate t3
??? ON t1.comb_id = t3.id
WHERE t1.reg_id = ''${regid}''
? AND t1.diseases_flag = 0
ORDER BY t2.depart_order ASC','1','2022-03-07 11:41:39',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-03-07 11:41:39','String',0,null,'combid',null,'660629193845141504',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',1,null,'resultupvalue',null,'660629193870307328',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',2,null,'deptid',null,'660629193878695936',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',3,null,'resultunit',null,'660629193891278848',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',4,null,'resultdownvalue',null,'660629193899667456',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',5,null,'checker',null,'660629193941610496',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',6,null,'depname',null,'660629193949999104',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',7,null,'negflag',null,'660629193958387712',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',8,null,'itemid',null,'660629193970970624',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',9,null,'phyresult',null,'660629193979359232',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',10,null,'itemname',null,'660629193991942144',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',11,null,'createby',null,'660629194004525056',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',12,null,'regid',null,'660629194017107968',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',13,null,'resulttype',null,'660629194025496576',null,null,'admin','660626234012889088',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-03-07 11:41:39','String',14,null,'combname',null,'660629194038079488',null,null,'admin','660626234012889088',null,null,null,'combname',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-03-07 11:41:39','String',15,null,'resulttips',null,'660629194046468096',null,null,'admin','660626234012889088',null,null,null,'resulttips',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-03-07 11:41:39','660626234012889088','regid',1,null,null,'',null,'660629194100994048',0,null,'admin','regid',null,null,'');
|