{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["本地数据","获取松下人事数据","获取灵锡数据"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"本地数据","index":0,"n_rows":165,"n_cols":6,"rows_kept":165,"cut":false,"hidden":false,"merged":[[2,0,17,0],[18,0,30,0],[31,0,41,0],[42,0,52,0],[53,0,61,0],[62,0,67,0],[68,0,79,0],[80,0,108,0],[109,0,132,0],[133,0,151,0],[152,0,158,0],[159,0,164,0],[2,1,17,1],[18,1,30,1],[31,1,41,1],[42,1,52,1],[53,1,61,1],[62,1,67,1],[68,1,79,1],[80,1,108,1],[109,1,132,1],[133,1,151,1],[152,1,158,1],[159,1,164,1]]}
["本地数据"]
["表名称","表描述","列名","列描述","示例1","示例2"]
["frame_user","用户表","id","id","1","1021425397054570496"]
[null,null,"staff_code","员工编号","测试工号1","测试工号2"]
[null,null,"department","部门ID","b60290d0-38c5-11ed-95ef-002b676e86f6","b60290d0-38c5-11ed-95ef-002b676e86f6"]
[null,null,"username","用户账号","admin1","admin2"]
[null,null,"password","用户密码","a0a****************************be2","a0a****************************be2"]
[null,null,"truename","用户姓名","管理","测试用账号"]
[null,null,"gender","性别，1-男，2-女","1","1"]
[null,null,"phone","联系电话","15995298888","15995298888"]
[null,null,"posts","岗位，逗号分隔","1022113195545853952","1022113195545853952"]
[null,null,"data_role","权限关键字，暂用于数据权限","1022079976255520768","1031882682306396160"]
[null,null,"reset_at","密码最新重置时间","","2022-11-24T13:32:15"]
[null,null,"login_at","最后登录时间","2022-12-08T10:40:39","2022-11-03T14:50:18"]
[null,null,"is_init","0-未初始化，1-已初始化","1","1"]
[null,null,"is_lock","0-未锁定，1-已锁定","0","1"]
[null,null,"status","状态：0-禁用， 1-启用","1","1"]
[null,null,"del_flag","删除标志（0代表存在 2代表删除）","0","2"]
["pecw_address_record","地址变更记录","recordid","主键","2LnoIAMBO3zRtj1vvnB","2mW97AhpCnCdchWfgTX"]
[null,null,"userid","申请人id","1022916181364834304","1022824132565270528"]
[null,null,"extendid","用户扩展表id","CT172160","HYX207003"]
[null,null,"submitdate","提交日期","2022-11-11T15:15:57","2022-10-20T13:15:14"]
[null,null,"oldaddress","原地址","新吴区净慧东道","新吴区江溪街道万裕苑一区31号501室"]
[null,null,"newaddress","新地址","滨湖区新吴区净慧东道","新吴区新洲人家"]
[null,null,"state","审批状态（0待提交1已提交2已审核3已退回）","1","2"]
[null,null,"operatetime","审核时间","","2022-10-20T13:16:34"]
[null,null,"audituser","审批人id","","1022915525082087424"]
[null,null,"createuser","创建人","1022916181364834304","1022824132565270528"]
[null,null,"createtime","创建时间","2022-11-11T15:15:57","2022-10-20T13:15:14"]
[null,null,"updateuser","更新人","1022916181364834304","1022824132565270528"]
[null,null,"updatetime","更新时间","2022-11-11T15:15:57","2022-10-20T13:16:34"]
["pecw_announcement","通知公告表","announceid","主键","Ea1mQ8ujisW5Ma36RRX","eidSbspRW6JcI7fO8af"]
[null,null,"title","标题","测试通知公告2","zttest2"]
[null,null,"picurl","主题图地址","1022154313188769792","1032586404216963072"]
[null,null,"content","内容","测试通知内容2","1212"]
[null,null,"state","状态（0待发布、1已发布、2已撤回）","2","0"]
[null,null,"publishuser","发布人","1",""]
[null,null,"publishtime","发布时间","2022-10-19T15:39:10",""]
[null,null,"createuser","创建人","1","1"]
[null,null,"createtime","创建时间","2022-09-21T14:36:41","2022-10-20T09:29:48"]
[null,null,"updateuser","修改人","1",""]
[null,null,"updatetime","修改时间","2022-10-19T15:56:53","2022-10-20T09:29:48"]
["pecw_announcement_detail","通知公告表-查收人明细表","detailid","主键","00FpgnbavFj1LYqrsXA","00SHEuUHsu7eDh7rq3c"]
[null,null,"announceid","通知公告表id","UZcgEpUZUXOcBKEIBAc","SqogaU3xgaRzDn9hd92"]
[null,null,"userid","用户id","1024618410195025920","1022916710799245312"]
[null,null,"extendid","用户扩展id（预留）","k57MnTE3ntgoeP5FVCf","8SvxPUSD1Xp3mz2MVcX"]
[null,null,"state","确认状态（0未确认1已确认）","0","0"]
[null,null,"ucode","工号","WMP032110","ZZ221004"]
[null,null,"uname","姓名","郑爱伟","张禹"]
[null,null,"udept","部门","镍氢电池工场/镍氢制造总括部/镍氢制造部/组立科/工程改善系","锂离子电池工场/CELL总括部/CELL制造三部/仕上科/圆筒自动系"]
[null,null,"uphone","联系电话","13771136599","15567255799"]
[null,null,"createuser","创建人","1","1"]
[null,null,"createtime","创建时间","2022-10-10T13:25:29","2022-10-19T11:47:23"]
["pecw_audit_record","审批记录表","id","主键","0wE4Vr6Qeo8UvDuR2WI","0WKQ9VpQkKYA20CTQdW"]
[null,null,"formid","表单id","gBnMTXtRXl1kAiu0yhw","Ev2sVnoe9mWRelilX6i"]
[null,null,"audituser","审批人id","1022915670079176704","1022824124608675840"]
[null,null,"audittime","审批时间","2022-10-25T10:30:30","2022-11-18T16:55:54"]
[null,null,"auditresult","审批结果","yes",""]
[null,null,"audittype","审批类型","end","start"]
[null,null,"processtype","流程类型","apply_leave","apply_free"]
[null,null,"createuser","创建人","","1022824124608675840"]
[null,null,"createtime","创建时间","2022-10-25T10:30:30","2022-11-18T16:55:54"]
["pecw_code_rule","编码规则","ruleid","主键","3917e608-3324-11ed-868f-002b676e86f6","825492d9-33cc-11ed-868f-002b676e86f6"]
[null,null,"prefix","前缀","GL","LX"]
[null,null,"nowdate","当前日期yyyyMMdd","20221124","20221202"]
[null,null,"tablename","表名","pecw_isolation_record","pecw_in_out_record"]
[null,null,"countsize","流水号位数","4","4"]
[null,null,"countnum","流水号","3","1"]
["pecw_epidemic_info","人员涉疫信息表","infoid","主键","000FAdG07HoQ1vL0zkV","000JkfTU0TQyMFgN6IE"]
[null,null,"extendcode","工号","WM212003","WM128027"]
[null,null,"ilevel","苏康码信息状态（1绿码、2黄码、3红码）","1","1"]
[null,null,"controlled","是否在管控区域(true、false)","false","false"]
[null,null,"vaccine","是否接种疫苗（0已接种、1未接种）","0","0"]
[null,null,"nuclein","核酸信息状态（0已采样未检测、1阴性、-1无核算记录、2阳性）","1","1"]
[null,null,"iname","扫码/刷卡人姓名","罗丽梅","卞政"]
[null,null,"irange","核酸核验周期(24/48/72)","24","72"]
[null,null,"createtime","创建时间","2022-10-17T19:11:16","2022-10-14T19:10:43"]
[null,null,"updatetime","更新时间","2022-10-17T19:11:16","2022-10-14T19:10:43"]
[null,null,"getdatatime","统一开始获取数据时间(新增)","2022-10-17T19:00","2022-10-14T19:00"]
[null,null,"message","异常情况备注(如未获取数据的msg)","苏康码：已过期，请更新","苏康码：已过期，请更新"]
["pecw_in_out_record","离锡返锡记录","recordid","主键","28dqiPNF2V19Ga5Eg4Z","3IA4J3RsGLixAlez7gq"]
[null,null,"recordcode","申请单号","LX202210210006","LX202211110001"]
[null,null,"recorddate","申请日期(有问题暂时不用,改用createtime字段)","2022-10-21T00:00","2022-11-11T00:00"]
[null,null,"recordusertype","申请人类型（本人、他人）","他人","本人"]
[null,null,"recorduser","申请人id","1022916182677651456","1022916181364834304"]
[null,null,"state","申请状态（0待提交1待审核2已审核3已退回4结束流程）","2","2"]
[null,null,"backstate","返锡申报提交状态（0未提交1已提交）","0","0"]
[null,null,"outreason","出省原因","探亲","探亲"]
[null,null,"outdate","出发时间","2022-10-21T00:00","2022-11-23T00:00"]
[null,null,"outway","交通方式","自驾","火车/高铁"]
[null,null,"outprovince","目的地-省","西藏自治区","天津市"]
[null,null,"outcity","目的地-市","拉萨市","市辖区"]
[null,null,"outarea","目的地-区","市辖区","河西区"]
[null,null,"outaddress","目的地详细地址","","河西"]
[null,null,"outrisk","是否属于风险区（0是1否）","1","0"]
[null,null,"intime","返锡时间","2022-10-21T00:00","2022-11-25T00:00"]
[null,null,"inway","交通方式","自驾","飞机"]
[null,null,"inprovince","回归地-省","江苏省","内蒙古自治区"]
[null,null,"incity","回归地-市","无锡市","呼和浩特市"]
[null,null,"inarea","回归地-区","市辖区","回民区"]
[null,null,"inaddress","回归地详细地址","",""]
[null,null,"recordnotes","备注","",""]
[null,null,"inrequirement","返锡当天与社区确认防疫要求","",""]
[null,null,"travelcode","行程码(图片url)","1033018336939606016","1040563625489596416"]
[null,null,"createuser","创建人","1024619485111255040","1022916181364834304"]
[null,null,"createtime","创建时间","2022-10-21T14:08:54","2022-11-11T09:48:26"]
[null,null,"updateuser","更新人","",""]
[null,null,"updatetime","更新时间","2022-10-21T14:31:27","2022-11-11T09:52:22"]
[null,null,"processid","流程相关","40139","187508"]
["pecw_isolation_record","隔离记录","recordid","主键","0YxywiKohbYHM9REB7w","1cuL3MMr9mktfDzLe4y"]
[null,null,"recordcode","申请单号","GL202211110001","GL202211170001"]
[null,null,"recorddate","申请日期","2022-11-11T00:00","2022-11-17T00:00"]
[null,null,"recordusertype","申请人类型（本人、他人）","本人","本人"]
[null,null,"recorduser","申请人id","1022916181364834304","1022915525082087424"]
[null,null,"recordaddress","居住地址","新吴区净慧东道","新吴区天鹅座"]
[null,null,"recordreason","原因","入境人员","入境人员"]
[null,null,"recordstarttime","隔离开始时间","2026-01-01T00:00","2022-11-15T00:00"]
[null,null,"recordrequirement","防控要求","3天3检","3天3检"]
[null,null,"recordtype","隔离类型","居家隔离","居家隔离"]
[null,null,"isolationtype","集中隔离类型","",""]
[null,null,"isolationname","集中隔离名称","",""]
[null,null,"isolationaddress","集中隔离地址","",""]
[null,null,"submitstate","隔离申请提交状态（0待提交1已提交）","1","1"]
[null,null,"state","解封审核状态（0待解封、1待审核、2已审核、3已退回）","1","1"]
[null,null,"expectendtime","预计隔离结束时间","2026-01-03T00:00","2022-11-21T00:00"]
[null,null,"recordendtime","隔离结束时间","2026-01-01T00:00","2022-11-17T00:00"]
[null,null,"recordnotes","备注","",""]
[null,null,"recordsupport","解除隔离证明","1040578699386159104","1042842493126705152"]
[null,null,"createuser","创建人","1022916181364834304","1022915525082087424"]
[null,null,"createtime","创建时间","2022-11-11T10:19:48","2022-11-17T00:00"]
[null,null,"updateuser","更新人","","1022915525082087424"]
[null,null,"updatetime","更新时间","2022-11-11T10:48:31","2022-11-23T17:09:18"]
[null,null,"processid","流程相关","195008","300008"]
["pecw_user_extend","人员信息扩展表","extendid","主键","00v9FpImCU0d9XHjH1a","01S7vJjoe0mot0kcgFe"]
[null,null,"userid","用户id","1022916156584886272","1022915047942258688"]
[null,null,"extenddept","部门","锂离子电池工场/CELL总括部/CELL制造一部/角形科/组立二系","锂离子电池工场/CELL总括部/CELL制造一部/角形科/组立二系"]
[null,null,"extendcode","工号","WMZ122308","WMY071055"]
[null,null,"extendname","姓名","穆娟娟","邓尚举"]
[null,null,"extendphone","联系电话","13806191346","18351576602"]
[null,null,"extendaddress","现居住地址","梁溪区黄巷街道沈巷小区231号802","惠山区堰桥街道西漳横街34号"]
[null,null,"numbervaccineshots","疫苗接种次数",1,2]
[null,null,"firsttimevaccineshots","第一针接种时间","2022-11-11T10:48:31","2022-11-11T10:48:31"]
[null,null,"firstnamevaccineshots","第一针疫苗品牌名称","疫苗品牌1","疫苗品牌1"]
[null,null,"secondtimevaccineshots","第二针接种时间","","2022-11-12T10:48:31"]
[null,null,"secondnamevaccineshots","第二针疫苗品牌名称","","疫苗品牌2"]
[null,null,"thirdtimevaccineshots","第三针接种时间","",""]
[null,null,"thirdnamevaccineshots","第三针疫苗品牌名称","",""]
[null,null,"createuser","创建人","-1","-1"]
[null,null,"createtime","创建时间","2022-09-23T17:03:37","2022-09-23T16:59:12"]
[null,null,"updateuser","更新人","-1","-1"]
[null,null,"updatetime","更新时间","2022-12-05T13:19:30","2022-12-05T13:16:28"]
[null,null,"isdel","删除标志（0未删除1已删除）","0","0"]
["pecw_wgy_dept","网格员管辖部门信息","wgyid","主键","123","8OaoPyQM3xsO60wAaYR"]
[null,null,"userid","用户id","1022824101678415872","1024618545310334976"]
[null,null,"ids","管辖部门ids","b60290d0-38c5-11ed-95ef-002b676e86f6","1021819803368685568,3d923d37-38c4-11ed-95ef-002b676e86f6,69afbfee-38c4-11ed-95ef-002b676e86f6,82650f67-38c4-11ed-95ef-002b676e86f6,826704d7-38c4-11ed-95ef-002b676e86f6,69b1a6ba-38c4-11ed-95ef-002b676e86f6,ae0086f8-38c4-11ed-95ef-002b676e86f6,69b43fa0-38c4-11ed-95ef-002b676e86f6,ae02e453-38c4-11ed-95ef-002b676e86f6,69b6e94a-38c4-11ed-95ef-002b676e86f6,ae047af1-38c4-11ed-95ef-002b676e86f6,3d94741a-38c4-11ed-95ef-002b676e86f6,d0a2f1d8-38c4-11ed-95ef-002b676e86f6,f5073ab6-38c4-11ed-95ef-002b676e86f6,f5098757-38c4-11ed-95ef-002b676e86f6,d0a48e9c-38c4-11ed-95ef-002b676e86f6,f50b9282-38c4-11ed-95ef-002b676e86f6,f50d690c-38c4-11ed-95ef-002b676e86f6"]
[null,null,"createuser","创建者","1",-1]
[null,null,"createtime","创建时间","2022-09-23T15:53:32","2022-10-21T16:08:47"]
[null,null,"updateuser","修改者","1",""]
[null,null,"updatetime","修改时间","2022-09-23T15:53:36",""]
["sys_dept","部门信息表","id","id","07b9070d-38cc-11ed-95ef-002b676e86f6","010382aa-38c2-11ed-95ef-002b676e86f6"]
[null,null,"parent_id","父id","9a5cbc0e-38cb-11ed-95ef-002b676e86f6","e3b3f041-38c1-11ed-95ef-002b676e86f6"]
[null,null,"dept_name","部门名称","组立科","计量计测系"]
[null,null,"dept_code","部门编码","zulike","jiliangjicexi"]
[null,null,"dept_order","顺序号","0","0"]
[null,null,"dept_level","部门层级","0","6"]

{"sheet":"获取松下人事数据","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,15,0],[2,1,15,1]]}
["获取松下人事数据"]
["表名称","表描述","列名","示例1","示例2"]
["MRYG","人员信息视图","一级部门","锂离子电池工场","镍氢电池工场"]
[null,null,"二级部门","CELL总括部","镍氢制造总括部"]
[null,null,"三级部门","CELL制造三部","镍氢制造部"]
[null,null,"四级部门","仕上科","镍氢仕上科"]
[null,null,"五级部门","圆筒系","充放电系"]
[null,null,"工号","IH207022","HY9010"]
[null,null,"姓名","杨芳","王晓红"]
[null,null,"联系电话","138*****048","189*****980"]
[null,null,"身份证号/灵锡码","5107**********058X","3202**********1929"]
[null,null,"现居住地址","梁溪区扬名街道新联苑134-102","新吴区旺庄街道新光嘉园31—103"]
[null,null,"班别编号","E01","B01"]
[null,null,"班别名称","夜班12","早班12"]
[null,null,"上班时间点","21:00","09:00"]
[null,null,"下班时间点","33:00","21:00"]

{"sheet":"获取灵锡数据","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,4,1,6],[2,0,12,0]]}
["获取灵锡数据"]
["接口名称","一级列名","二级列名","列描述","示例"]
["灵锡接口:获取健康信息","code",null,"code状态码","{","code: 200,"]
[null,"data",null,"数据",null,"data: {"]
[null,null,"certCode",null,null,null,"certCode: \"320283********6514\","]
[null,null,"controlled",null,null,null,"controlled: false,"]
[null,null,"level",null,null,null,"level: \"1\","]
[null,null,"name",null,null,null,"name: \"张洮\","]
[null,null,"nuclein_state",null,null,null,"nuclein_state: 1,"]
[null,null,"timeRange",null,null,null,"timeRange: 72,"]
[null,null,"vaccine",null,null,null,"vaccine: 0"]
[{"$nulls":5},"}"]
[{"$nulls":4},"}"]