报表配置，cavos预览报错html预览正常的配置文件
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-02-22 15:40:40','医师执业注册健康体检表',1,0,'656004587716898816','118',null,null,null,'2022-03-01 19:34:41','admin',null,'printinfo',null,'admin',null,'20220222154040','{"loopBlockList":[],"area":{"sri":35,"sci":6,"eri":35,"eci":6,"width":111,"height":27},"excel_config_id":"656004587716898816","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":20,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"2":{"cells":{"1":{"merge":[1,4],"height":50,"text":"医 师 执 业 注 册 健 康 体 检 表","style":37},"2":{"style":38},"3":{"style":38},"4":{"style":38},"5":{"style":38}}},"3":{"cells":{"1":{"style":38},"2":{"style":38},"3":{"style":38},"4":{"style":38},"5":{"style":38}}},"5":{"cells":{"1":{"text":"体检医院名称：","style":38},"2":{"text":"银川致康医院","style":38},"3":{"style":38},"4":{"text":"体检日期：${induct_doctor.ordertime}","merge":[0,2],"height":25,"style":38},"5":{"style":38},"6":{"style":38}}},"7":{"cells":{"0":{"text":"姓名","style":56},"1":{"style":56,"text":"${induct_doctor.name}"},"2":{"text":"性别 ${induct_doctor.sex}","style":56},"3":{"text":"出生日期","style":56},"4":{"style":56,"text":"${induct_doctor.birthdate}","merge":[0,1],"height":39},"5":{"style":58},"6":{"style":18,"text":"${induct_doctor.picture}","merge":[3,0],"height":167,"rendered":"","config":"","display":"img"},"7":{"text":""}},"height":39},"8":{"cells":{"0":{"text":"身份证号","style":56},"1":{"merge":[0,4],"height":25,"style":56,"text":"${induct_doctor.idno}"},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"10":{"text":"","rendered":"","config":""}},"height":33},"9":{"cells":{"0":{"text":"工作单位","style":56},"1":{"merge":[0,4],"height":25,"style":56,"text":"${induct_doctor.departname}"},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58}},"height":36},"10":{"cells":{"0":{"text":"出生地","style":56},"1":{"style":56,"text":"${induct_doctor.address}"},"2":{"text":"民族","style":59},"3":{"style":56,"text":"${induct_doctor.nation}"},"4":{"text":"婚姻","style":59},"5":{"style":56,"text":"${induct_doctor.marriage}"}},"height":39},"11":{"cells":{"0":{"text":"既往病史","style":56},"1":{"style":57,"text":"${induct_doctor.history}","merge":[0,5],"height":46},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58},"9":{"text":"","rendered":"","config":""}},"height":35},"12":{"cells":{"0":{"text":"家族史","style":56},"1":{"style":57,"text":"${induct_doctor.other}","merge":[0,5],"height":41},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}},"height":31},"13":{"cells":{"0":{"text":"身高","style":56},"1":{"style":56,"text":"${induct_doctor_common.height}"},"2":{"text":"厘米","style":56},"3":{"text":"体重","style":56},"4":{"style":56,"text":"${induct_doctor_common.weight}"},"5":{"text":"千克","style":56,"merge":[0,1],"height":40},"6":{"style":58}},"height":40},"14":{"cells":{"0":{"merge":[3,0],"height":100,"text":"眼","style":59},"1":{"text":"裸眼视力","style":56},"2":{"text":"左","style":59,"merge":[2,0],"height":75},"3":{"style":56,"text":"${induct_doctor_eyes.lyslz}"},"4":{"text":"右","style":59,"merge":[2,0],"height":75},"5":{"style":56,"text":"${induct_doctor_eyes.lysly}"},"6":{"style":60,"text":"意见:"}}},"15":{"cells":{"0":{"style":58},"1":{"text":"矫正视力","style":56},"2":{"style":58},"3":{"style":56,"text":"${induct_doctor_eyes.jzslz}"},"4":{"style":58},"5":{"style":56,"text":"${induct_doctor_eyes.jzsly}"},"6":{"style":61,"text":"${induct_doctor_eyes.content}"}}},"16":{"cells":{"0":{"style":58},"1":{"text":"眼疾","style":56},"2":{"style":58},"3":{"text":"${induct_doctor_eyes.yjz}","style":58},"4":{"style":58},"5":{"text":"${induct_doctor_eyes.yjy}","style":58},"6":{"style":60,"text":" "},"8":{"text":""}}},"17":{"cells":{"0":{"style":58},"1":{"text":"色觉","style":56},"2":{"style":56,"text":"${induct_doctor_eyes.bsl}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":62,"text":"医师:"},"8":{"text":""}}},"18":{"cells":{"0":{"merge":[5,0],"height":150,"text":"耳鼻咽喉","style":59},"1":{"text":"听力","style":56},"2":{"text":"左","style":59,"merge":[2,0],"height":75},"3":{"style":56,"text":"${induct_doctor_ebyh.tlz}"},"4":{"style":59,"text":"右","merge":[2,0],"height":75},"5":{"style":56,"text":"${induct_doctor_ebyh.tly}"},"6":{"style":63,"text":"意见:"}}},"19":{"cells":{"0":{"style":58},"1":{"text":"耳疾","style":56},"2":{"style":58},"3":{"style":56,"text":"${induct_doctor_ebyh.ejz}"},"4":{"style":58},"5":{"style":56,"text":"${induct_doctor_ebyh.ejy}"},"6":{"style":61,"text":"${induct_doctor_ebyh.content}"}}},"20":{"cells":{"0":{"style":58},"1":{"text":"鼻及鼻窦","style":56},"2":{"style":58},"3":{"style":56,"text":"${induct_doctor_ebyh.bjbdz}"},"4":{"style":58},"5":{"style":56,"text":"${induct_doctor_ebyh.bjbdy}"},"6":{"style":60,"text":" "}}},"21":{"cells":{"0":{"style":58},"1":{"text":"嗅觉","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_ebyh.xj}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}}},"22":{"cells":{"0":{"style":58},"1":{"text":"咽","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_ebyh.yan}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "},"8":{"text":""}}},"23":{"cells":{"0":{"style":58},"1":{"text":"喉","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_ebyh.hou}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":62,"text":"医师:"}}},"24":{"cells":{"0":{"merge":[2,0],"height":75,"text":"口腔","style":59},"1":{"text":"粘膜","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_mouth.nm}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":"意见:"}}},"25":{"cells":{"0":{"style":58},"1":{"text":"牙及牙龈","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_mouth.yjyg}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":61,"text":"${induct_doctor_mouth.content}"},"8":{"text":""}}},"26":{"cells":{"0":{"style":58},"1":{"text":"舌","style":56},"2":{"merge":[0,3],"height":25,"text":"${induct_doctor_mouth.she}","style":56},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":62,"text":" "}}},"27":{"cells":{"0":{"merge":[8,0],"height":225,"text":"内科","style":59},"1":{"text":"呼吸(次/分)","style":56},"2":{"text":"${induct_doctor_inner.hx}","style":56},"3":{"text":"脉搏(次/分)","style":56},"4":{"text":"${induct_doctor_inner.mb}","style":56,"merge":[0,1],"height":25},"5":{"style":58},"6":{"style":64,"text":"意见:${induct_doctor_inner.content}"}},"height":33},"28":{"cells":{"0":{"style":58},"1":{"text":"血压(mmhg)","style":56},"2":{"style":56,"text":"${induct_doctor_inner.xy}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "},"8":{"text":""}},"height":33},"29":{"cells":{"0":{"style":58},"1":{"text":"发育及营养","style":56},"2":{"style":56,"text":"${induct_doctor_inner.fyjyy}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}},"height":28},"30":{"cells":{"0":{"style":58},"1":{"text":"神经及精神","style":56},"2":{"style":56,"text":"${induct_doctor_inner.sjjjs}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}},"height":32},"31":{"cells":{"0":{"style":58},"1":{"text":"肺及呼吸道","style":56},"2":{"style":56,"text":"${induct_doctor_inner.fjhxd}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "},"8":{"text":""}},"height":39},"32":{"cells":{"0":{"style":58},"1":{"text":"心脏及血管","style":56},"2":{"style":56,"text":"${induct_doctor_inner.xzjxg}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}},"height":34},"33":{"cells":{"0":{"style":58},"1":{"text":"肝、脾、双肾","style":56},"2":{"style":56,"text":"${induct_doctor_inner.gpss}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}},"height":36},"34":{"cells":{"0":{"style":58},"1":{"text":"腹部包块","style":56},"2":{"style":56,"text":"${induct_doctor_inner.fbbk}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":60,"text":" "}},"height":35},"35":{"cells":{"0":{"style":58},"1":{"text":"其他","style":56},"2":{"style":56,"text":"${induct_doctor_inner.other}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":62,"text":"医师:"}},"height":27},"36":{"cells":{"0":{"merge":[4,0],"height":125,"text":"外科","style":59},"1":{"text":"皮肤","style":56},"2":{"style":56,"text":"${induct_doctor_out.pf}"},"3":{"text":"淋巴结","style":56},"4":{"merge":[0,1],"height":25,"style":56,"text":"${induct_doctor_out.lbj}"},"5":{"style":58},"6":{"style":64,"text":"意见:${induct_doctor_out.content}"}},"height":33},"37":{"cells":{"0":{"style":58},"1":{"text":"头、颈","style":56},"2":{"style":56,"text":"${induct_doctor_out.tj}"},"3":{"text":"甲状腺","style":56},"4":{"merge":[0,1],"height":25,"style":56,"text":"${induct_doctor_out.jzx}"},"5":{"style":58},"6":{"style":60,"text":" "}},"height":31},"38":{"cells":{"0":{"style":58},"1":{"text":"脊柱","style":56},"2":{"style":56,"text":"${induct_doctor_out.jz}"},"3":{"text":"四肢","style":56},"4":{"merge":[0,1],"height":25,"style":56,"text":"${induct_doctor_out.sz}"},"5":{"style":58},"6":{"style":60,"text":" "},"9":{"text":""}},"height":28},"39":{"cells":{"0":{"style":58},"1":{"text":"肛门","style":56},"2":{"style":56,"text":"${induct_doctor_out.gm}"},"3":{"text":"生殖器","style":56},"4":{"merge":[0,1],"height":25,"style":56,"text":"${induct_doctor_out.szq}"},"5":{"style":58},"6":{"style":60,"text":" "}},"height":37},"40":{"cells":{"0":{"style":58},"1":{"text":"其他","style":56},"2":{"style":56,"text":"${induct_doctor_out.other}","merge":[0,3],"height":25},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":62,"text":"医师:"}},"height":31},"41":{"cells":{"0":{"text":"辅助检查附录报告单","style":65,"merge":[1,0],"height":50},"1":{"text":"胸透或胸X片","style":56},"2":{"merge":[0,3],"height":25,"style":56,"text":"${induct_doctor_xiontong.xthxxp}"},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":56,"text":"医师:"},"8":{"text":""}},"height":46},"42":{"cells":{"0":{"style":58},"1":{"text":"心电图","style":56},"2":{"merge":[0,3],"height":25,"style":56,"text":"${induct_doctor_packs.xdt}"},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":56,"text":"医师:"}},"height":40},"43":{"cells":{"0":{"style":59,"text":"#{induct_doctor_lis.group(checkname)}","aggregate":"group","rendered":"","config":""},"1":{"text":"#{induct_doctor_lis.group(combname)}","style":57,"aggregate":"group","rendered":"","config":""},"2":{"merge":[0,3],"height":25,"style":66,"text":"#{induct_doctor_lis.content}"},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"text":"医师:","style":56}},"height":49},"44":{"cells":{"0":{"text":"体检结果","style":65,"rendered":"","config":"","display":"normal","merge":[4,0],"height":75},"1":{"rendered":"","config":"","text":" ","merge":[0,5],"height":25,"style":64},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"45":{"cells":{"0":{"style":58},"1":{"style":84,"text":"#{induct_doctor_final.summary}","merge":[0,2],"height":25},"2":{},"3":{},"4":{"text":" "},"5":{"text":" "},"6":{"style":13,"text":" "}}},"46":{"cells":{"0":{"style":58},"1":{"style":85,"text":" "},"2":{"style":58,"text":" "},"3":{"style":58,"text":" "},"4":{"style":58,"text":" "},"5":{"style":58,"text":" "},"6":{"style":71,"text":" "}}},"47":{"cells":{"0":{"style":58},"1":{"style":85,"text":" "},"2":{"text":"主检医师签名:","style":78,"merge":[0,1],"height":25},"3":{},"4":{"merge":[0,1],"height":25,"text":"体检医院盖章","style":68},"5":{"style":58},"6":{"style":71,"text":" "},"8":{"text":"","rendered":"","config":""},"10":{"text":"","rendered":"","config":""}}},"48":{"cells":{"0":{"style":58},"1":{"style":86,"text":" "},"2":{"style":72,"text":" "},"3":{"style":72,"text":" "},"4":{"merge":[0,1],"height":25,"text":"年 月 日 ","style":81},"5":{"style":58},"6":{"style":73,"text":" "}}},"49":{"cells":{"0":{"merge":[8,0],"height":225,"text":"用人单位意见","style":69},"1":{"text":"（对申请人的身体健康状况是否适宜或胜任拟聘任的工作岗位提出意见）","style":70,"merge":[0,5],"height":25},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"50":{"cells":{"0":{"style":58},"1":{"text":"","rendered":"","config":"","style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":71,"text":" "}}},"51":{"cells":{"0":{"style":58},"1":{"style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":71,"text":" "}}},"52":{"cells":{"0":{"style":58},"1":{"style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":71,"text":" "},"9":{"text":"","rendered":"","config":""}}},"53":{"cells":{"0":{"style":58},"1":{"style":58},"2":{"style":58},"3":{"style":58},"4":{"merge":[0,1],"height":25,"text":"盖章","style":68},"5":{"style":58},"6":{"style":71,"text":" "}}},"54":{"cells":{"0":{"style":58},"1":{"style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":71,"text":" "}}},"55":{"cells":{"0":{"style":58},"1":{"text":"负责人签名：","style":58},"2":{"style":58,"text":" "},"3":{"style":58},"4":{"merge":[0,1],"height":25,"text":" 年 月 日","style":68},"5":{"style":58},"6":{"style":71,"text":" "}}},"56":{"cells":{"0":{"style":58},"1":{"style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":71,"text":" "}}},"57":{"cells":{"0":{"style":58},"1":{"style":72,"text":" "},"2":{"style":72,"text":" "},"3":{"style":72,"text":" "},"4":{"style":72,"text":" "},"5":{"style":72,"text":" "},"6":{"style":73,"text":" "}}},"58":{"cells":{"0":{"text":"注:","style":77},"1":{"text":"1、体检医院为二级以上医院。","style":67,"merge":[0,5],"height":25},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"59":{"cells":{"0":{"style":58},"1":{"merge":[0,5],"height":25,"text":"2、表中内容要如实工整填写，不得涂改，不得弄虚作假。","style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"60":{"cells":{"0":{"style":58},"1":{"merge":[0,5],"height":25,"text":"3、X线、心电图、肝功、血常规、尿常规报告单等请粘贴在A4纸上。","style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"61":{"cells":{"0":{"style":58},"1":{"merge":[0,5],"height":25,"text":"4、用人单位签署意见后，此表随注册申请材料交注册机关。","style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"62":{"cells":{"0":{"style":58},"1":{"merge":[0,5],"height":25,"text":"5、此表用A4纸双面印制。","style":58},"2":{"style":58},"3":{"style":58},"4":{"style":58},"5":{"style":58},"6":{"style":58}}},"len":94},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,9,7]},"groupField":"induct_doctor_lis.checkname","freeze":"A1","dataRectWidth":638,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"bold":true}},{"font":{"bold":true}},{"align":"center","font":{"bold":true,"size":22}},{"font":{"bold":true,"size":22}},{"align":"center","textwrap":true},{"border":{"bottom":["thin","#000"]}},{"textwrap":true},{"textwrap":true,"align":"right"},{"border":{"top":["thin","#000"],"left":["thin","#000"]}},{"border":{"top":["thin","#000"]}},{"border":{"top":["thin","#000"],"right":["thin","#000"]}},{"border":{"left":["thin","#000"]}},{"border":{"right":["thin","#000"]}},{"align":"center","border":{"left":["thin","#000"]}},{"align":"center","textwrap":true,"border":{"left":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"bottom":["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":"center","textwrap":true,"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"right":["thin","#000"]}},{"align":"center","textwrap":true,"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]}},{"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true},{"border":{"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true},{"border":{"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":"left"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","valign":"top"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","valign":"top","textwrap":true},{"border":{"top":["thin","#000"],"bottom":["thin","#000"]}},{"align":"left","textwrap":true,"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"top":["thin","#000"],"left":["thin","#000"]},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":false},{"align":"center","font":{"bold":true,"size":22,"name":"宋体"}},{"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"align":"center","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"]},"textwrap":true,"font":{"name":"宋体"}},{"border":{"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体"}},{"align":"center","textwrap":true,"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"]},"textwrap":false,"font":{"name":"宋体"}},{"textwrap":true,"font":{"name":"宋体"}},{"align":"center","font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"top":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体","size":12}},{"font":{"name":"宋体","size":12}},{"align":"center","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"font":{"name":"宋体","size":12}},{"align":"center","textwrap":true,"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":false,"font":{"name":"宋体","size":12}},{"textwrap":true,"font":{"name":"宋体","size":12}},{"align":"center","font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"top":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}},{"textwrap":true,"align":"right","font":{"size":12}},{"textwrap":true,"font":{"size":12}},{"font":{"size":12}},{"textwrap":true,"align":"right","font":{"size":12,"name":"宋体"}},{"font":{"name":"宋体","size":12},"align":"left"},{"align":"center","textwrap":true,"border":{"top":["thin","#000"],"bottom":["thin","#000"],"left":["thin","#000"]},"font":{"name":"宋体","size":12}},{"textwrap":true,"font":{"name":"宋体","size":12},"border":{"top":["thin","#000"],"right":["thin","#000"]}},{"align":"center","font":{"name":"宋体","size":12},"border":{"bottom":["thin","#000"]}},{"textwrap":false,"font":{"name":"宋体","size":12},"border":{"top":["thin","#000"],"right":["thin","#000"]}},{"textwrap":false,"font":{"name":"宋体","size":12}},{"textwrap":true,"font":{"name":"宋体","size":12},"border":{"left":["thin","#000"]}},{"font":{"name":"宋体","size":12},"border":{"left":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"left":["thin","#000"]},"font":{"name":"宋体","size":12}},{"align":"right","font":{"name":"宋体","size":12}}],"validations":[],"isGroup":true,"cols":{"3":{"width":70},"4":{"width":96},"5":{"width":61},"6":{"width":111},"len":50},"merges":["B3:F4","E6:G6","E8:F8","G8:G11","B9:F9","B10:F10","B12:G12","B13:G13","F14:G14","A15:A18","C15:C17","E15:E17","C18:F18","A19:A24","C19:C21","E19:E21","C22:F22","C23:F23","C24:F24","A25:A27","C25:F25","C26:F26","C27:F27","A28:A36","E28:F28","C29:F29","C30:F30","C31:F31","C32:F32","C33:F33","C34:F34","C35:F35","C36:F36","A37:A41","E37:F37","E38:F38","E39:F39","E40:F40","C41:F41","A42:A43","C42:F42","C43:F43","C44:F44","A50:A58","B50:G50","E54:F54","E56:F56","B59:G59","B60:G60","B61:G61","B62:G62","B63:G63","A45:A49","B45:G45","E48:F48","E49:F49","B46:D46","C48:D48"]}',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_doctor','基本信息','0','2022-02-22 17:30:15','0',null,'','656025393759023104','656004587716898816','SELECT
t2.name,
(
CASE
t2.sex
WHEN ''1395668945472708610''
THEN ''通用''
WHEN ''1395668968889507841''
THEN ''男性''
WHEN ''1395669001382780929''
THEN ''女性''
END
) AS sex,
t2.id_no AS idNo,
t2.phone,
SUBSTRING(t2.id_no, 7, 8) AS birthDate,
CONCAT(
CONCAT(
''${ipport}'',
''/sys/common/static/''
),
t1.picture
) AS picture,
t2.address,
t2.address,
depart_name AS departName,
t2.age,
(
CASE
t2.marriage
WHEN ''1397393941601521665''
THEN ''已婚''
WHEN ''1397393968440872962''
THEN ''未婚''
WHEN ''1397394014523691009''
THEN ''离异''
WHEN ''1397394246925881345''
THEN ''丧偶''
ELSE ''未知''
END
) AS marriage,
t2.nation,
t3.pre_desease_history AS history,
t3.other,
DATE_FORMAT(t1.order_time,''%Y-%m-%d'') AS orderTime
FROM
pe_regist t1
INNER JOIN pe_user_info t2
ON t1.pe_user_id = t2.id
LEFT JOIN pe_indus_cons_detail_common t3
ON t1.id=t3.reg_id
WHERE t1.del_flag = 0
AND t2.del_flag = 0
AND t1.id = ''${regid}''','0','2022-02-23 09:58:26',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-02-22 17:30:15','String',0,null,'other',null,'656025394061012992',null,null,'admin','656025393759023104',null,null,null,'other',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-02-22 17:30:15','String',1,null,'address',null,'656025394081984512',null,null,'admin','656025393759023104',null,null,null,'address',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-02-22 17:30:15','String',2,null,'nation',null,'656025394094567424',null,null,'admin','656025393759023104',null,null,null,'nation',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-02-22 17:30:15','String',3,null,'sex',null,'656025394107150336',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',4,null,'history',null,'656025394115538944',null,null,'admin','656025393759023104',null,null,null,'history',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-02-22 17:30:15','String',5,null,'idno',null,'656025394153287680',null,null,'admin','656025393759023104',null,null,null,'idno',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-02-22 17:30:15','String',6,null,'birthdate',null,'656025394165870592',null,null,'admin','656025393759023104',null,null,null,'birthdate',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-02-22 17:30:15','String',7,null,'picture',null,'656025394174259200',null,null,'admin','656025393759023104',null,null,null,'picture',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-02-22 17:30:15','String',8,null,'phone',null,'656025394186842112',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',9,null,'marriage',null,'656025394195230720',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',10,null,'name',null,'656025394203619328',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',11,null,'age',null,'656025394216202240',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',12,null,'departname',null,'656025394228785152',null,null,'admin','656025393759023104',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-02-22 17:30:15','String',13,null,'ordertime',null,'656025663347912704',null,null,'admin','656025393759023104',null,null,null,'ordertime',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-02-22 17:30:15','656025393759023104','ipport',1,null,null,'1',null,'656025394245562368',0,null,'admin','ipport',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-02-22 17:30:15','656025393759023104','regid',2,null,null,'1',null,'656025394266533888',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_doctor_common','一般检查','0','2022-02-23 11:05:36','0',null,'','656026590205210624','656004587716898816','SELECT
CONCAT(phy_result, ''/'', result_unit) AS height,
( SELECT
CONCAT(phy_result, ''/'', result_unit) AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''体重'') AS weight,
(SELECT
CONCAT(phy_result, ''/'', result_unit) AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''血压'')AS bloodPress,
(SELECT
CONCAT(phy_result, ''/'', result_unit) AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''脉搏'') AS pulse
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''身高'' ','0','2022-02-23 11:05:36',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-02-23 11:05:36','String',0,null,'pulse',null,'656026590238765056',null,null,'admin','656026590205210624',null,null,null,'pulse',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-02-23 11:05:36','String',1,null,'weight',null,'656026590268125184',null,null,'admin','656026590205210624',null,null,null,'weight',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-02-23 11:05:36','String',2,null,'bloodpress',null,'656026590280708096',null,null,'admin','656026590205210624',null,null,null,'bloodpress',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-02-23 11:05:36','String',3,null,'height',null,'656026590293291008',null,null,'admin','656026590205210624',null,null,null,'height',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-02-23 11:05:36','656026590205210624','regid',1,null,null,'',null,'656026590310068224',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_doctor_eyes','眼','0','2022-02-24 10:03:41','0',null,'','656027291799023616','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS yjz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''裸眼视力左'') AS yjy,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''眼疾右'') AS lyslz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''裸眼视力右'') AS lysly,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''矫正视力左'') AS jzslz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''矫正视力右'') AS jzsly,
(SELECT
phy_result AS pz
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''色觉'') AS bsl,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id=t2.reg_id AND t1.comb_id=t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id=t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''眼疾左''','0','2022-02-24 10:03:41',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-02-24 10:03:41','String',0,null,'doctor',null,'656027291832578048',null,null,'admin','656027291799023616',null,null,null,'doctor',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-02-24 10:03:41','String',1,null,'lyslz',null,'656027291866132480',null,null,'admin','656027291799023616',null,null,null,'lyslz',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-02-24 10:03:41','String',2,null,'lysly',null,'656027291874521088',null,null,'admin','656027291799023616',null,null,null,'lysly',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-02-24 10:03:41','String',3,null,'jzslz',null,'656027291891298304',null,null,'admin','656027291799023616',null,null,null,'jzslz',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-02-24 10:03:41','String',4,null,'jzsly',null,'656027291903881216',null,null,'admin','656027291799023616',null,null,null,'jzsly',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-02-24 10:03:41','String',5,null,'bsl',null,'656027291912269824',null,null,'admin','656027291799023616',null,null,null,'bsl',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-02-24 10:03:41','String',6,null,'content',null,'656029173904863232',null,null,'admin','656027291799023616',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-02-24 10:03:41','String',7,null,'yjz',null,'656646020052316160',null,null,'admin','656027291799023616',null,null,null,'yjz',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-02-24 10:03:41','String',8,null,'yjy',null,'656646020064899072',null,null,'admin','656027291799023616',null,null,null,'yjy',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-02-24 10:03:41','656027291799023616','regid',1,null,null,'',null,'656027291929047040',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_doctor_ebyh','耳鼻咽喉','0','2022-02-23 11:08:43','0',null,'','656031703946784768','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS hou,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''听力左'') AS tlz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''听力右'') AS tly,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''耳疾左'') AS ejz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''耳疾右'') AS ejy,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''耳疾左'') AS ejz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''耳疾右'') AS ejy,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''鼻及鼻窦左'') AS bjbdz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''鼻及鼻窦右'') AS bjbdy,
(SELECT
phy_result AS pz
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''嗅觉'') AS xj,
(SELECT
phy_result AS pz
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''咽'') AS yan,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id=t2.reg_id AND t1.comb_id=t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id=t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''喉''','0','2022-02-23 11:08:43',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-02-23 11:08:43','String',0,null,'doctor',null,'656031703980339200',null,null,'admin','656031703946784768',null,null,null,'doctor',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-02-23 11:08:43','String',1,null,'xj',null,'656031704001310720',null,null,'admin','656031703946784768',null,null,null,'xj',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-02-23 11:08:43','String',2,null,'ejz',null,'656031704013893632',null,null,'admin','656031703946784768',null,null,null,'ejz',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-02-23 11:08:43','String',3,null,'ejy',null,'656031704026476544',null,null,'admin','656031703946784768',null,null,null,'ejy',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-02-23 11:08:43','String',4,null,'bjbdz',null,'656031704034865152',null,null,'admin','656031703946784768',null,null,null,'bjbdz',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-02-23 11:08:43','String',5,null,'yan',null,'656031704047448064',null,null,'admin','656031703946784768',null,null,null,'yan',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-02-23 11:08:43','String',6,null,'bjbdy',null,'656031704081002496',null,null,'admin','656031703946784768',null,null,null,'bjbdy',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-02-23 11:08:43','String',7,null,'content',null,'656031704093585408',null,null,'admin','656031703946784768',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-02-23 11:08:43','String',8,null,'hou',null,'656031704101974016',null,null,'admin','656031703946784768',null,null,null,'hou',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-02-23 11:08:44','String',9,null,'tly',null,'656032416630337536',null,null,'admin','656031703946784768',null,null,null,'tly',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-02-23 11:08:44','String',10,null,'tlz',null,'656032416638726144',null,null,'admin','656031703946784768',null,null,null,'tlz',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-02-23 11:08:44','656031703946784768','regid',1,null,null,'',null,'656031704122945536',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_doctor_mouth','口腔','0','2022-02-23 11:09:20','0',null,'','656272917841342464','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS she,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''粘膜'') AS nm,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''牙及牙龈'') AS yjyg,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id = t2.reg_id
AND t1.comb_id = t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id = t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''舌''','0','2022-02-23 11:09: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-02-23 11:09:20','String',0,null,'doctor',null,'656272917925228544',null,null,'admin','656272917841342464',null,null,null,'doctor',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-02-23 11:09:20','String',1,null,'yjyg',null,'656272917950394368',null,null,'admin','656272917841342464',null,null,null,'yjyg',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-02-23 11:09:20','String',2,null,'content',null,'656272917962977280',null,null,'admin','656272917841342464',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-02-23 11:09:20','String',3,null,'nm',null,'656272917988143104',null,null,'admin','656272917841342464',null,null,null,'nm',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-02-23 11:09:20','String',4,null,'she',null,'656273062142177280',null,null,'admin','656272917841342464',null,null,null,'she',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-02-23 11:09:20','656272917841342464','regid',1,null,null,'',null,'656272918067834880',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_doctor_inner','内科','0','2022-02-24 10:32:19','0',null,'','656274368944697344','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS other,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''呼吸'') AS hx,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''脉搏'') AS mb,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''血压'') AS xy,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''发育及营养'') AS fyjyy,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''神经及精神'') AS sjjjs,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''肺及呼吸道'') AS fjhxd,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''心脏及血管'') AS xzjxg,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''肝、脾、双肾'') AS gpss,
(SELECT
phy_result AS pz
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''腹部包块'') AS fbbk,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id=t2.reg_id AND t1.comb_id=t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id=t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''内科其他''','0','2022-02-24 10:32:19',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-02-24 10:32:19','String',0,null,'doctor',null,'656274369024389120',null,null,'admin','656274368944697344',null,null,null,'doctor',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-02-24 10:32:19','String',1,null,'hx',null,'656274369045360640',null,null,'admin','656274368944697344',null,null,null,'hx',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-02-24 10:32:19','String',2,null,'xy',null,'656274369057943552',null,null,'admin','656274368944697344',null,null,null,'xy',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-02-24 10:32:19','String',3,null,'other',null,'656274369066332160',null,null,'admin','656274368944697344',null,null,null,'other',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-02-24 10:32:19','String',4,null,'fyjyy',null,'656274369078915072',null,null,'admin','656274368944697344',null,null,null,'fyjyy',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-02-24 10:32:19','String',5,null,'xzjxg',null,'656274369091497984',null,null,'admin','656274368944697344',null,null,null,'xzjxg',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-02-24 10:32:19','String',6,null,'mb',null,'656274369217327104',null,null,'admin','656274368944697344',null,null,null,'mb',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-02-24 10:32:19','String',7,null,'gpss',null,'656274369229910016',null,null,'admin','656274368944697344',null,null,null,'gpss',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-02-24 10:32:19','String',8,null,'sjjjs',null,'656274369242492928',null,null,'admin','656274368944697344',null,null,null,'sjjjs',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-02-24 10:32:19','String',9,null,'fbbk',null,'656274369255075840',null,null,'admin','656274368944697344',null,null,null,'fbbk',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-02-24 10:32:19','String',10,null,'content',null,'656274369263464448',null,null,'admin','656274368944697344',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-02-24 10:32:19','String',11,null,'fjhxd',null,'656274369276047360',null,null,'admin','656274368944697344',null,null,null,'fjhxd',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-02-24 10:32:19','656274368944697344','regid',1,null,null,'',null,'656274369292824576',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_doctor_out','外科','0','2022-02-24 11:17:58','0',null,'','656275576979746816','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS szq,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''皮肤'') AS pf,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''头、颈'') AS tj,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''脊柱'') AS jz,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''肛门'') AS gm,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''外科其他'') AS other,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''淋巴结'') AS lbj,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''甲状腺'') AS jzx,
(SELECT
phy_result AS phyResult
FROM
pe_result
WHERE del_flag = 0
AND diseases_flag = 2
AND reg_id = ''${regid}''
AND item_name = ''四肢'') AS sz,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id=t2.reg_id AND t1.comb_id=t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id=t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''生殖器''','0','2022-02-24 11:17:58',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-02-24 11:17:58','String',0,null,'doctor',null,'656275577009106944',null,null,'admin','656275576979746816',null,null,null,'doctor',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-02-24 11:17:58','String',1,null,'jz',null,'656275577030078464',null,null,'admin','656275576979746816',null,null,null,'jz',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-02-24 11:17:58','String',2,null,'other',null,'656275577042661376',null,null,'admin','656275576979746816',null,null,null,'other',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-02-24 11:17:58','String',3,null,'lbj',null,'656275577055244288',null,null,'admin','656275576979746816',null,null,null,'lbj',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-02-24 11:17:58','String',4,null,'pf',null,'656275577067827200',null,null,'admin','656275576979746816',null,null,null,'pf',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-02-24 11:17:58','String',5,null,'tj',null,'656275577084604416',null,null,'admin','656275576979746816',null,null,null,'tj',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-02-24 11:17:58','String',6,null,'gm',null,'656275577088798720',null,null,'admin','656275576979746816',null,null,null,'gm',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-02-24 11:17:58','String',7,null,'sz',null,'656275577101381632',null,null,'admin','656275576979746816',null,null,null,'sz',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-02-24 11:17:58','String',8,null,'jzx',null,'656275577109770240',null,null,'admin','656275576979746816',null,null,null,'jzx',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-02-24 11:17:58','String',9,null,'szq',null,'656275577122353152',null,null,'admin','656275576979746816',null,null,null,'szq',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-02-24 11:17:58','String',10,null,'content',null,'656275577130741760',null,null,'admin','656275576979746816',null,null,null,'content',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-02-24 11:17:58','656275576979746816','regid',1,null,null,'',null,'656275577147518976',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_doctor_packs','心电图','0','2022-02-23 10:02:31','0',null,'','656282309479395328','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS xdt
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id = t2.reg_id
AND t1.comb_id = t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id = t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''心电图''','0','2022-02-23 10:02:31',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-02-23 10:02:31','String',0,null,'doctor',null,'656282309504561152',null,null,'admin','656282309479395328',null,null,null,'doctor',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-02-23 10:02:31','String',1,null,'xdt',null,'656282309525532672',null,null,'admin','656282309479395328',null,null,null,'xdt',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-02-23 10:02:31','656282309479395328','regid',1,null,null,'',null,'656282309550698496',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_doctor_xiontong','胸透','0','2022-02-23 10:03:44','0',null,'','656283644740268032','656004587716898816','SELECT
t1.doctor,
t1.phy_result AS xthxxp
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id = t2.reg_id
AND t1.comb_id = t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id = t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.item_name = ''胸透或胸X片''','0','2022-02-23 10:03:44',null,'admin',null,'',null,null,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-02-23 10:03:44','String',0,null,'doctor',null,'656283644773822464',null,null,'admin','656283644740268032',null,null,null,'doctor',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-02-23 10:03:44','String',1,null,'xthxxp',null,'656283644798988288',null,null,'admin','656283644740268032',null,null,null,'xthxxp',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-02-23 10:03:44','656283644740268032','regid',1,null,null,'',null,'656283644819959808',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_doctor_lis','检验科','1','2022-02-28 11:33:08','0',null,'','656284169967792128','656004587716898816','SELECT
t1.doctor,
''检验项目'' AS checkName,
t1.comb_name AS combName,
t3.content
FROM
pe_result t1
LEFT JOIN pe_summary t2
ON t1.reg_id = t2.reg_id
AND t1.comb_id=t2.comb_id
LEFT JOIN pe_summary_details t3
ON t2.id = t3.pe_sum_id
WHERE t1.del_flag = 0
AND t1.diseases_flag = 2
AND t1.reg_id = ''${regid}''
AND t1.dept_id = ''${depid}''
GROUP BY t1.reg_id,
t1.comb_id','0','2022-02-28 11:33:08',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-02-28 11:33:08','String',0,null,'doctor',null,'656284170009735168',null,null,'admin','656284169967792128',null,null,null,'doctor',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-02-28 11:33:08','String',1,null,'checkname',null,'656284170030706688',null,null,'admin','656284169967792128',null,null,null,'checkname',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-02-28 11:33:08','String',2,null,'combname',null,'656284170043289600',null,null,'admin','656284169967792128',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-02-28 11:33:08','String',3,null,'content',null,'656645109703798784',null,null,'admin','656284169967792128',null,null,null,'content',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-02-28 11:33:08','656284169967792128','regid',1,null,null,'',null,'656284170068455424',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-02-28 11:33:08','656284169967792128','depid',3,null,null,'',null,'656657971176304640',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 ('induct_doctor_final','结论','1','2022-02-23 11:11:35','0',null,'','656285074607861760','656004587716898816',' 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=2','0','2022-02-23 11:11:35',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-02-23 11:11:35','String',0,null,'summary',null,'656285074695942144',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',1,null,'regid',null,'656285074716913664',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',2,null,'advise',null,'656285074729496576',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',3,null,'penumber',null,'656285074742079488',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',4,null,'notiflag',null,'656285074754662400',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',5,null,'notifyuser',null,'656285074763051008',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',6,null,'recheckdays',null,'656285074775633920',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',7,null,'rechecktime',null,'656285074784022528',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',8,null,'rechecksummary',null,'656285074796605440',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',9,null,'checkdoctor',null,'656285074804994048',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',10,null,'totaldoctor',null,'656285074817576960',null,null,'admin','656285074607861760',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-02-23 11:11:35','String',11,null,'createby',null,'656285074825965568',null,null,'admin','656285074607861760',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-02-23 11:11:35','656285074607861760','regid',1,null,null,'',null,'656285074842742784',0,null,'admin','regid',null,null,'');
607
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
