积木报表
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-21 14:45:10，职业总检报告书，1，0，655629615823613952，null,null,null,'2022-03-07 14:39:54','admin',null,'printinfo',null,'admin',null,'20220221144509','{"loopBlockList":[],"area":{"sri":10,"sci":8,"eri":10,"eci":8,"width":100,"height":25},"excel_config_id":"655629615823613952","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":20,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"4":{"cells":{"1":{"merge":[0,4],"height":25,"text":"${diseases_team_info.companyname}","style":30}}},"7":{"cells":{"1":{"merge":[1,4],"height":50,"text":"职 业 健 康 检 查 总 结 报 告 书","style":32}}},"8":{"cells":{}},"11":{"cells":{"2":{"merge":[1,2],"height":50,"text":"宁大职检(2020)第004号","style":30}}},"12":{"cells":{}},"28":{"cells":{"1":{"merge":[1,4],"height":50,"text":"银 川 中 美 宁 大 医 院 职 业 健 康 检 查 机 构","style":32}}},"29":{"cells":{}},"33":{"cells":{"2":{"merge":[1,2],"height":50,"text":"=now()","style":36}}},"34":{"cells":{}},"48":{"cells":{"3":{"text":"说 明","style":30}}},"50":{"cells":{"0":{"merge":[0,6],"height":25,"text":"1、本机构是经宁夏回族自治区卫生计生委批准的职业健康检查机构。本着科学、公正、开放、实事求是的原则，对职业健康检查过程及其结果负责，对委托单位提供的技术资料保密。\n未经同意，不得用于广告和商品宣传。\n未经同意，不得用于广告和商品宣传。\n3.本报告未签发人签字、修改、未加盖本机构专用章或部分复制的，视为无效。","style":38}}},"51":{"cells":{"0":{"merge":[0,6],"height":25,"text":"银川中美宁大医院职业健康检查机构\n体检机构资质证书编号:(2020)宁卫健职检字 第12号\n地址：银川市兴庆区北京东路530号\n邮编：751001 \n电话：0951-- 5553336 \n投诉电话：0951—4077790","style":38}}},"52":{"cells":{"0":{"text":"委托单位：","style":39},"1":{"style":41,"text":"${diseases_team_info.companyname}","merge":[0,3],"height":25},"5":{"style":39,"text":" "},"6":{"style":39,"text":" "}}},"53":{"cells":{"0":{"merge":[0,6],"height":25,"text":"体检单位：银川中美宁大医院\n法定代表人：臧海涛\n主检医师:王瑜(资质证书号:宁卫计职(物)(2016)018号；宁卫计职(毒)2016年018号)\n职业健康检查医师：\n 王 瑜:(执业证书编号:1106400001931\n冒少媛:(执业证号:11064010001978)\n 马存林:(执业证书编号:1106401000350)\n 李 娜:(执业证号:1106400000343\n (执业证书编号:11064010002138)\n 苏培娇：(20181640032070023)","style":38}}},"54":{"cells":{"0":{"merge":[0,6],"height":25,"text":"报告作者： 报告日期： 年 月 日","style":39}}},"55":{"cells":{"0":{"merge":[0,6],"height":25,"text":"审 核 人： 审核日期： 年 月 日 ","style":39}}},"56":{"cells":{"0":{"merge":[0,6],"height":25,"text":"签 发 人： 签发日期： 年 月 日","style":39}}},"62":{"cells":{"2":{"merge":[1,2],"height":50,"text":"职业健康检查机构(公章)","style":42}}},"63":{"cells":{}},"76":{"cells":{"1":{"merge":[0,4],"height":25,"text":"职 业 健 康 检 查 总 结 报 告 书","style":42}}},"78":{"cells":{"0":{"text":"一、检查对象及人数：","style":44,"merge":[0,1],"height":25},"2":{"merge":[0,4],"height":25,"text":" ","style":21},"3":{},"4":{},"5":{},"6":{}}},"79":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 被检单位：宁夏美源达贸易有限公司，应检人数：12人；实检人数：12人。检查时间：2020年11月21日。检查时间:2020年11月21日。地点:银川中美宁大医院。","style":38}}},"80":{"cells":{"0":{"merge":[0,1],"height":25,"text":"二、职业病危害因素名称：","style":46}}},"81":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 工频电场是汽油、一氧化碳、二氧化硫、氮氧化物、噪声、苯和苯的衍生物。","style":39}}},"82":{"cells":{"0":{"merge":[0,1],"height":25,"text":"三、职业健康检查类别：","style":46}}},"83":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 上岗前、√在岗期间、离岗期间、应急医学观察。","style":39}}},"84":{"cells":{"0":{"merge":[0,1],"height":25,"text":"四、职业健康检查项目：","style":46}}},"85":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 询问个人一般情况、职业史、既往史、急慢性职业病史、吸烟饮酒史等。测量血压、身高和体重；检查心电图、血常规、尿常规、肝功能(谷丙转氨酶)、胸部正位片、电测听和一般项目。","style":38}}},"86":{"cells":{"0":{"merge":[0,1],"height":25,"text":"五、职业健康检查依据：","style":46}}},"87":{"cells":{"0":{"merge":[0,6],"height":25,"text":"1.《中华人民共和国职业病防治法》(2016年7月2日，中华人民共和国主席令第48号)\n2.《职业健康检查管理办法》(国家卫生计生委令第5号)\n3.卫生部卫生法监发20159号）\n4.《职业病分类和目录》（国卫疾控发【2013】48号）\n5.《职业健康监护技术规范》（GBZ188--2014）\n6.《使用有毒物品作业场所劳动保护条例》（中华人民共和国国务院令第352号2002年5月12日）\n7.《中华人民共和国尘肺病防治条例》（1987年12月3日）\n8.《工作场职业病危害作业分级 第一部分：生产性粉尘》（GBZ/T229.1-2010）\n9.相关职业病诊断标准\n（1)《尘肺病诊断标准》（GBZ70-2015）\n（2)《职业性噪声聋诊断标准》（GBZ49-2014）\n(3) GBZ27-2002《职业性溶剂汽油中毒诊断标准","style":39}}},"88":{"cells":{"0":{"merge":[0,1],"height":25,"text":"六、职业健康监护的目的","style":46}}},"89":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 本次职业健康检查为（在岗期间）检查，其主要目的是早期发现可疑职业病及劳动者的其他健康异常改变；及时发现有职业禁忌和疑似职业病的劳动者；评价健康变化与职业病危害的关系。\n七、本次职业健康检查中职业病危害因素对健康的影响；职业健康检查目标疾病、健康检查周期、各类作业体检结果及处理原则","style":39}}},"90":{"cells":{"0":{"text":"1、汽油","style":47}}},"91":{"cells":{"0":{"merge":[0,6],"height":25,"text":" 汽油，外观为透明液体，主要成分为C4～C12脂肪烃和环烃类，并含少量芳香烃和硫化物,汽油中毒是工业生产或使用中，接触汽油蒸气或液体所致全身性中毒性疾病。急性中毒以神经或精神症状为主，误将汽油吸入呼吸道可引起吸入性肺炎;慢性中毒主要表现为神经衰弱综合征、植物神经功能紊乱和中毒性周围神经病。接触汽油场所应加强防护措施 ：\n呼吸系统防护：空气中浓度较高时，佩带防毒面具。紧急事态抢救或逃生时，应该佩戴自给式呼吸器。 眼睛防护：戴化学安全防护眼镜。 防护服：穿紧袖工作服，长统胶鞋。 手防护：戴橡皮手套。 \n健康体检周期：劳动者接触汽油健康检查周期：1年。\n目标疾病：a;职业病：1）职业性慢性溶剂汽油中毒（GBZ27)\n 2)汽油致职业性皮肤病（GBZ18)\n b)职业禁忌证：1）严重慢性皮肤疾患\n2）多发性周围神经炎","style":39}}},"92":{"cells":{"0":{"text":"2.噪 声","style":47}}},"93":{"cells":{"0":{"merge":[0,6],"height":25,"text":"（1）对人体的危害 \n① 全身损害 \n对神经系统的影响：临床表现为头痛、头晕、心悸、睡眠障碍和全身乏力等神经衰弱综合症。有的还可出现记忆力减退和情绪不稳定、易激怒等症状。\n对心血管系统的影响：临床表现为心率加快或减慢，血压早期为不稳定，晚期可升高。心电图检查可见S－T段和/或T波的改变。脑血流图检查可见波幅降低、流入时间延长等，提示血管紧张度增加、血管弹性下降。\n对内分泌系统的影响：中等强度噪声作用下，肾上腺皮质功能增强；高强度噪声作用下，肾上腺皮质功能减弱。还可引起免疫功能下降，降低机体抵抗力。\n对消化系统的影响：临床表现为胃肠道功能紊乱、食欲不振、胃液分泌减少、胃蠕动减慢和消化不良等。还可引起脂质代谢障碍，血胆固醇升高。\n此外，在噪声环境下作业工人可感到烦躁，并有注意力不集中，反应迟钝等表现，不仅影响工作效率，降低工作质量，而且容易引发工伤等安全事故。\n②听觉系统损害 \n噪声主要损伤听力系统，其损伤变化一般是从暂时性听阈位移逐渐发展为永久性听阈位移，根据听力损伤的程度，永久性听阈位移分为听力损失和职业性噪声聋。\n目标疾病 \n (1) 职业病：职业性噪声聋（参见GBZ49）\n (2) 职业禁忌证：\n ① 除噪声外各种原因引起永久性感音神经性听力损失（500Hz、1000Hz和2000Hz中任一频率的纯音气导听阈＞25dBHL）\n ② 中度以上传导性耳聋\n ③噪声敏感者（上岗前职业健康体检纯音听力检查各频率听力损失均在正常范围之内即≤25dBHL，噪声作业1年后，高频段3000Hz、4000Hz、6000Hz中任一耳，任一频率听阈≥65dBHL）\n 工作场所中应加强防噪措施和注意个人防护，正确佩戴个人防护用品，如：防噪耳罩、耳塞等。","style":38}}},"94":{"cells":{"0":{"text":"七：防护措施与建议","merge":[0,1],"height":25,"style":46}}},"95":{"cells":{"0":{"merge":[0,6],"height":25,"text":"1.根据贵单位生产作业的环境特点，为确保企业工作场所符合职业卫生的要求，建议企业按照《中华人民共和国职业病防治法》等法律法规的规定，加强职业卫生管理，重点加强工作场所和劳动者的个人防护工作，对有可能引起职业性慢性溶剂汽油中毒和汽油致职业性皮肤病及职业性噪声聋的工作场所要进一步改善工作环境.第一，采取有效的防护措施。加油站内应保持良好的通风条件，必要时安装通风排毒装置，进一步降低工作场所空气中汽油的浓度。正确穿戴涂有聚乙烯脂的手套、工作服和工作鞋，避免皮肤接触。同时工作场所应有可用的安全淋浴和冲洗器具。 第二，要重视宣传教育和培训工作。特别是新员工，使其了解所在岗位存在的职业病危害及预防措施，严格遵守操作规程，维护职业病危害防护设施，减少加油、卸油等操作过程中油品的滴漏，严禁用口虹吸汽油。同时，培养良好的卫生习惯，如下班后用肥皂、清水洗净手和脸，不要接触油品后立即吃东西、抽烟等。 第三，针对可能发生的汽油泄漏、扩散、中毒事故，制定可操作性强的应急救援预案。包括组织机构、职责分工、实施程序及要求等方面内容。配备一定数量的应急救援装置，如防毒口罩、护目镜、防护服、空气呼吸器等。一旦出现空气中汽油蒸气浓度较高时，可使用密封护目镜保护眼睛，戴有褐色标志滤毒盒的防毒口罩以减少吸入。在进入汽油槽车、汽油储罐或汽油塔等高浓度环境时，可使用背负式空气呼吸器、防护服进行个体防护。 第四，定期对工作场所空气中汽油浓度进行检测，对检测不合格的工作场所及时治理，从根本上保护劳动者健康。同时，对接触汽油的作业工人进行上岗前、在岗期间及离岗时的职业健康检查，发现患有过敏性皮肤疾病、神经系统器质性疾病的职业禁忌症人员应及时调离汽油作业岗位，发现疑似职业病患者应及时安排观察、治疗。 第五，加油站应建立职业病危害防治管理制度。保证宣传教育培训、安全操作、防护设施维护检修、防护用品管理、职业健康监护等项工作都有章可循，不留管理死角，并根据实际情况逐步完善。加油站汽油作业工人的职业健康应引起全社会的高度重视，用人单位要为员工提供一个健康与安全的工作环境，实现源头控制，保护劳动者健康。\n2.职业卫生管理\n企业配置专人管理职业卫生相关事务，建立职业卫生管理制度，保证职业卫生档案、职业健康体检资料，以及作业场所职业病危害因素检测数据的有效性与持续性。贵企业应在日常生产中：\n（1）应进一步落实工作场所的监测制度，对作业场所存在的职业病危害因素定期进行检测与评价，并将结果存入职业卫生档案。发现职业病危害因素超标的工作岗位，应及时查找原因，确保各种职业病的危害因素浓（强）度符合国家职业卫生标准要求。\n（2）应进一步加强对作业人员的定期职业卫生防护知识培训工作，按时进行上岗前和定期职业健康检查，避免患有职业禁忌症的工人接触相应的职业病有害因素。\n（3）应进一步完善应急救援预案和应急事故通报及处理程序，制定安全卫生检查规范，加强日常检查和督导，对发现的问题应做好记录、通报和总结，及时提出改进意见，以防止安全事故和职业病的发生。\n3.操作人员的管理\n操作人员的不安全行为和作业环境中的潜在危险因素是造成意外事故的主要原因，因此，应加强工作现场以及操作人员的安全卫生管理，预防意外事故的发生。创立成熟的操作规程及相关卫生防护制度。同时，加强人员的岗位培训，并侧重对新员工和特殊岗位的针对性培训，并实施考核和复训，使之能有效预防和控制应急事故。\n4.个人防护用品及应急救援\n加强个体防护，尤其重要。同时制订相关管理制度，对个人防护用品应经常检查、更新，以保证使用的个人防护用品是安全和有效的。另外，应加强对操作人员正确使用个人防护用品的培训和监督，确保人员能严格按照规定使用防护用品，防止操作人员出现大意松懈导致的防护不到位而遭到职业病危害因素的影响。","style":38,"rendered":"","config":"","display":"normal"}}},"96":{"cells":{"0":{"merge":[0,6],"height":25,"text":" ","style":16},"1":{},"2":{},"3":{},"4":{},"5":{},"6":{}}},"97":{"cells":{"0":{"merge":[0,2],"height":25,"text":"八、检查结果统计与分析","style":46,"rendered":"","config":""}}},"98":{"cells":{"0":{"merge":[0,6],"height":25,"text":"本次对接触汽油、噪声、工频电场等职业病危害因素作业人员12人进行职业健康体检，受检率为100％。目前发现闫凤琴血压(143/94mmhg)升高。其他人员体检结果汇总名单详见附表。","style":38}}},"99":{"cells":{"0":{"merge":[0,1],"height":25,"text":"九、职业健康检查总报告书附件","style":46},"7":{"text":"","rendered":"","config":""}}},"100":{"cells":{"0":{"merge":[0,6],"height":25,"text":"1、本次职业健康检查结果异常人员一览表 ","style":39}}},"101":{"cells":{"0":{"merge":[0,6],"height":25,"text":"2、本次职业健康检查未见异常人员一览表","rendered":"","config":"","style":39}}},"102":{"cells":{"1":{"merge":[0,4],"height":25,"text":"职业健康检查结果异常人员一览表（附件1）","style":47}}},"103":{"cells":{"0":{"style":51,"text":"编号"},"1":{"style":51,"text":"姓名"},"2":{"style":51,"text":"性别"},"3":{"style":51,"text":"年龄"},"4":{"style":51,"text":"接触有害因素"},"5":{"style":51,"text":"检查结果"},"6":{"style":51,"text":"备注"}}},"104":{"cells":{"0":{"style":52,"text":"#{diseases_team_book.regid}"},"1":{"text":"#{diseases_team_book.name}","style":52},"2":{"style":52,"text":"#{diseases_team_book.sex}"},"3":{"style":52,"text":"#{diseases_team_book.age}"},"4":{"style":52,"text":"#{diseases_team_book.factorname}"},"5":{"style":52,"text":"#{diseases_team_book.summary}"},"6":{"style":53,"text":" "}}},"106":{"cells":{"1":{"merge":[0,4],"height":25,"text":"职业健康检查结果未见异常人员一览表（附件2）","style":47}}},"107":{"cells":{"0":{"style":51,"text":"编号"},"1":{"style":51,"text":"姓名"},"2":{"style":51,"text":"性别"},"3":{"style":51,"text":"年龄"},"4":{"style":51,"text":"接触有害因素"},"5":{"style":51,"text":"检查结果"},"6":{"style":51,"text":"备注"}}},"108":{"cells":{"0":{"style":52,"text":"#{diseases_team_book_health.regid}"},"1":{"style":52,"text":"#{diseases_team_book_health.name}"},"2":{"style":52,"text":"#{diseases_team_book_health.sex}"},"3":{"style":52,"text":"#{diseases_team_book_health.age}"},"4":{"style":52,"text":"#{diseases_team_book_health.factorname}"},"5":{"style":52,"text":"#{diseases_team_book_health.summary}"},"6":{"style":53,"text":" "}}},"len":112},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,7,9,8]},"freeze":"A1","dataRectWidth":644,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"align":"center"},{"align":"center","font":{"size":16}},{"font":{"size":16}},{"align":"center","font":{"size":16,"bold":true}},{"font":{"size":16,"bold":true}},{"align":"center","font":{"size":18,"bold":true}},{"font":{"size":18,"bold":true}},{"align":"center","font":{"size":22,"bold":true}},{"font":{"size":22,"bold":true}},{"align":"center","font":{"size":14}},{"font":{"size":14}},{"align":"center","font":{"size":14,"bold":true}},{"font":{"size":14,"bold":true}},{"font":{"bold":true}},{"align":"center","format":"date2"},{"format":"date2"},{"textwrap":true},{"border":{"bottom":["thin","#000"]}},{"textwrap":true,"font":{"bold":true}},{"textwrap":true,"font":{"bold":true,"size":12}},{"font":{"bold":true,"size":12}},{"textwrap":false},{"font":{"size":12}},{"font":{"bold":true},"align":"right"},{"font":{"bold":true},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"font":{"bold":true,"name":"宋体"},"align":"center"},{"font":{"name":"宋体"}},{"font":{"bold":true,"name":"宋体","size":14},"align":"center"},{"font":{"name":"宋体","size":14}},{"align":"center","font":{"size":22,"bold":true,"name":"宋体"}},{"font":{"name":"宋体","size":22}},{"align":"center","font":{"size":18,"bold":true,"name":"宋体"}},{"align":"center","format":"date2","font":{"name":"宋体"}},{"align":"center","format":"date2","font":{"name":"宋体","size":14}},{"textwrap":true,"font":{"name":"宋体"}},{"textwrap":true,"font":{"name":"宋体","size":12}},{"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"]},"font":{"name":"宋体","size":12}},{"align":"center","font":{"size":16,"bold":true,"name":"宋体"}},{"textwrap":true,"font":{"bold":true,"size":12,"name":"宋体"}},{"textwrap":true,"font":{"bold":true,"size":14,"name":"宋体"}},{"font":{"bold":true,"size":12,"name":"宋体"}},{"font":{"bold":true,"size":14,"name":"宋体"}},{"font":{"bold":true,"name":"宋体","size":12},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体"}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"name":"宋体","size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"name":"宋体","size":12}}],"validations":[],"cols":{"6":{"width":44},"len":50},"merges":["B5:F5","B8:F9","C12:E13","B29:F30","C34:E35","A51:G51","A52:G52","B53:E53","A54:G54","A55:G55","A56:G56","A57:G57","C63:E64","B77:F77","A79:B79","C79:G79","A80:G80","A81:B81","A82:G82","A83:B83","A84:G84","A85:B85","A86:G86","A87:B87","A88:G88","A89:B89","A90:G90","A92:G92","A94:G94","A95:B95","A96:G96","A97:G97","A98:C98","A99:G99","A100:B100","A101:G101","A102:G102","B103:F103","B107:F107"]}',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 ('diseases_team_book','团队职业异常报告书','1','2022-02-24 16:44:31','0',null,'','655653913925808128','655629615823613952',' 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, t5.factor_details AS factorName, GROUP_CONCAT(t5.factor_details,'''')AS factorName, t4.summary 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 LEFT JOIN pe_final_check t4 ON t2.id=t4.reg_id AND diseases_flag=''1'' LEFT JOIN pe_indus_cons_detail_factor t5 ON t2.id=t5.reg_id AND t2.pe_depart_id=t5.indus_depart_id WHERE t1.del_flag = 0 AND t2.del_flag = 0 AND t4.neg_flag=1 AND t2.pe_depart_id =''${departid}'' ','0','2022-02-24 16:44: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-24 16:44:31','String',0,null,'age',null,'655653914211020800',null,null,'admin','655653913925808128',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-24 16:44:31','String',1,null,'name',null,'655653914336849920',null,null,'admin','655653913925808128',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-24 16:44:31','String',2,null,'phone',null,'655653914353627136',null,null,'admin','655653913925808128',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-24 16:44:31','String',3,null,'marriage',null,'655653914362015744',null,null,'admin','655653913925808128',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-24 16:44:31','String',4,null,'sex',null,'655653914370404352',null,null,'admin','655653913925808128',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-24 16:44:31','String',5,null,'penumber',null,'655653914382987264',null,null,'admin','655653913925808128',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-24 16:44:31','String',6,null,'pedepartid',null,'655653914391375872',null,null,'admin','655653913925808128',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-02-24 16:44:31','String',7,null,'ordertime',null,'655653914399764480',null,null,'admin','655653913925808128',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-02-24 16:44:31','String',8,null,'regid',null,'655653914412347392',null,null,'admin','655653913925808128',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-24 16:44:31','String',9,null,'departname',null,'655653914424930304',null,null,'admin','655653913925808128',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-24 16:44:31','String',10,null,'companyname',null,'655653914437513216',null,null,'admin','655653913925808128',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-02-24 16:44:31','String',11,null,'factorname',null,'655653914445901824',null,null,'admin','655653913925808128',null,null,null,'factorname',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 16:44:31','String',12,null,'summary',null,'655653914454290432',null,null,'admin','655653913925808128',null,null,null,'summary',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 16:44:31','655653913925808128','departid',1,null,null,'',null,'655653914483650560',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 ('diseases_team_book_health','团队职业正常报告书','1','2022-02-24 16:44:50','0',null,'','655671718347829248','655629615823613952',' 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, t5.factor_details AS factorName, GROUP_CONCAT(t5.factor_details,'''')AS factorName, t4.summary 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 LEFT JOIN pe_final_check t4 ON t2.id=t4.reg_id AND diseases_flag=''1'' LEFT JOIN pe_indus_cons_detail_factor t5 ON t2.id=t5.reg_id AND t2.pe_depart_id=t5.indus_depart_id WHERE t1.del_flag = 0 AND t2.del_flag = 0 AND t4.neg_flag=0 AND t2.pe_depart_id =''${departid}'' ','0','2022-02-24 16:44:50',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 16:44:50','String',0,null,'age',null,'655671718385577984',null,null,'admin','655671718347829248',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-24 16:44:50','String',1,null,'name',null,'655671718406549504',null,null,'admin','655671718347829248',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-24 16:44:50','String',2,null,'phone',null,'655671718414938112',null,null,'admin','655671718347829248',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-24 16:44:50','String',3,null,'marriage',null,'655671718427521024',null,null,'admin','655671718347829248',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-24 16:44:50','String',4,null,'sex',null,'655671718440103936',null,null,'admin','655671718347829248',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-24 16:44:50','String',5,null,'penumber',null,'655671718452686848',null,null,'admin','655671718347829248',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-24 16:44:50','String',6,null,'pedepartid',null,'655671718465269760',null,null,'admin','655671718347829248',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-02-24 16:44:50','String',7,null,'ordertime',null,'655671718473658368',null,null,'admin','655671718347829248',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-02-24 16:44:50','String',8,null,'regid',null,'655671718482046976',null,null,'admin','655671718347829248',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-24 16:44:50','String',9,null,'departname',null,'655671718494629888',null,null,'admin','655671718347829248',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-24 16:44:50','String',10,null,'companyname',null,'655671718507212800',null,null,'admin','655671718347829248',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-02-24 16:44:50','String',11,null,'factorname',null,'655671718515601408',null,null,'admin','655671718347829248',null,null,null,'factorname',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 16:44:50','String',12,null,'summary',null,'655671718528184320',null,null,'admin','655671718347829248',null,null,null,'summary',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 16:44:50','655671718347829248','departid',1,null,null,'',null,'655671718540767232',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 ('diseases_team_info','团队基本信息','0','2022-02-21 17:39:47','0',null,'','655673635119591424','655629615823613952','SELECT company_name AS companyName,depart_name AS departName FROM pe_depart WHERE id=''${departid}''','0','2022-02-21 17:39:47',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-21 17:39:47','String',0,null,'companyname',null,'655673635341889536',null,null,'admin','655673635119591424',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-02-21 17:39:47','String',1,null,'departname',null,'655673635367055360',null,null,'admin','655673635119591424',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-02-21 17:39:47','655673635119591424','departid',1,null,null,'',null,'655673635383832576',0,null,'admin','departid',null,null,'');
业务表可以为空
create table `pe_depart` ( `id` bigint (20), `company_id` varchar (108), `company_name` varchar (300), `del_flag` int (10), `sort` int (19), `depart_name` varchar (300), `discount` Decimal (12), `pay_status` varchar (108), `order_time` datetime , `create_by` varchar (96), `create_time` datetime , `update_by` varchar (96), `update_time` datetime , `remarks` varchar (1500) ); create table `pe_user_info` ( `id` varchar (108), `app_user_id` varchar (108), `del_flag` int (10), `name` varchar (60), `depart_name` varchar (360), `operation_type` varchar (108), `depart_id` varchar (108), `his_id` varchar (96), `phone` varchar (96), `sex` varchar (108), `nationality` varchar (108), `marriage` varchar (108), `indus_type` varchar (108), `id_type` varchar (108), `id_no` varchar (96), `self_price` Decimal (12), `team_price` Decimal (12), `self_number` int (10), `team_number` int (10), `birth_date` datetime , `email` varchar (60), `address` varchar (360), `detail_addr` varchar (1500), `picture` varchar (3000), `nation` varchar (36), `mouth` varchar (36), `age` varchar (36), `remarks` varchar (384), `create_by` varchar (150), `create_time` datetime , `update_by` varchar (150), `update_time` datetime ); create table `pe_regist` ( `id` varchar (108), `order_no` varchar (96), `order_status` int (10), `del_flag` int (10), `his_id` varchar (96), `worke_type` varchar (108), `pe_type` varchar (108), `pe_number` varchar (96), `pe_user_id` varchar (60), `name` varchar (60), `order_time` datetime , `pe_depart_id` varchar (60), `report_flag` varchar (108), `group_id` varchar (36), `group_name` varchar (150), `pack_dis_flag` varchar (108), `cur_rate` Decimal (12), `source` varchar (108), `total_price` Decimal (12), `pay_status` varchar (108), `pe_status` varchar (108), `print_num` int (10), `picture` varchar (3000), `create_by` varchar (108), `create_time` datetime , `update_by` varchar (108), `update_time` datetime , `remarks` varchar (1500) ); create table `pe_final_check` ( `id` varchar (108), `del_flag` int (1), `summary` text , `reg_id` varchar (108), `advise` text , `pe_number` varchar (108), `diseases_flag` int (1), `his_id` varchar (96), `neg_flag` int (1), `noti_flag` int (1), `notify_user` varchar (108), `recheck_days` varchar (108), `recheck_time` datetime , `recheck_summary` varchar (300), `check_doctor` varchar (108), `total_doctor` varchar (108), `create_by` varchar (150), `create_time` datetime , `update_by` varchar (150), `update_time` datetime , `remarks` varchar (1500) );