{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["部署信息","版本说明","数据库","安全系统各地市设定","公司内网服务器信息","各所在地部署情况及联系人"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":32,"n_cols":28,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,27,1,27],[0,24,1,24],[0,25,1,25],[0,2,0,3],[3,17,3,19],[0,26,1,26],[0,4,0,10],[18,17,18,19],[0,1,1,1],[0,23,1,23],[0,11,0,19],[0,21,0,22],[2,17,2,19],[17,17,17,19]]}
[null,"地市名称","系统版本",null,"应用服务器",{"$nulls":6},"数据库",{"$nulls":9},"各市yjpt系统管理员",null,"外网访问URL","防火墙","部署时间","微信端","备注"]
[null,null,"版本号","最新发布日期","IP","用户名","密码","处理器","内存","可用硬盘","已用","IP","用户名","密码","sid","连接用户名","连接密码","处理器","内存","硬盘","已用","用户名","密码"]
[null,"江苏省","4.2.1","20161208","10.1.30.114","administrator","gkaq@zw!","E5-4640 v2 @2.60GHz 2.60GHz（2处理器）","16G","300G","132G","10.1.30.104","oracle","oracle","JTTJJC","yjptpro","windows","公用",null,null,null,"admin","yjptqwerty@1234",null,"有"]
["A","南京（弃用）","4.1.2","20161206","10.22.192.249","administrator","Hgc@85263268","E5-5430 0 @2.66GHz 2.66GHz","2G","20G",null,null,"administrator","Hgc@85263268","orcl","yjptnewcity","windows","公用",null,null,null,"admin","yjptqwerty1234","http://221.226.102.115:8080/yjpt/","有",null,null,"硬件差，数据库和应用使用同一台服务器"]
["A","南京-省局新","4.2.1","20161206","193.168.1.151","administrator","lu_wei2000!","E5-2640 v2 @2.00GHz 2.00GHz(2处理器)","8G","200G","25G","10.1.30.104","oracle","oracle","JTTJJC","yjptnj","windows",{"$nulls":4},"admin","yjptqwerty@1234","http://218.2.208.145:8090/yjpt/",null,null,"是"]
["B","无锡","4.2.1","20161206","10.3.0.20","administrator","123ABCabc","E5-2407 V2 @2.40GHz 2.40GHz","32G","1TB","70G","10.3.0.21","administrator","123ABCabc","orcl","yjpt","windows","E5-2407 V2 @2.20GHz 2.20GHz","8G","600G",null,"admin","yjptqwerty@1234","http://61.160.77.229:7000/yjpt/",null,"2014-10-18","是"]
["C","徐州","4.2.1","20161206","10.13.18.50","administrator","Passw0rd","E5-2609 V2 @2.50GHz 2.50GHz(2处理器)","32G","2TB","20G","10.13.18.51","administrator","Passw0rd","yjpt","yjpt","windows","E5-2609 V2 @2.50GHz 2.50GHz(2处理器)","64G","4TB",null,"admin","yjptqwerty@1234","http://222.187.126.162:81/yjpt/","有","2014-10-09"]
["D","常州","4.2.1","20161206","10.9.30.224","administrator","8832438Fengs","E5-2665 0 @2.40GHz 2.40GHz(2处理器)","8G","250G","50G","10.9.30.225","administrator","8832438Fengs","yjpt","yjpt","windows","E5-2665 0 @2.40GHz 2.40GHz(2处理器)","16G","1TB","40G","admin","yjptqwerty@1234","http://222.185.255.10:5678/yjpt/",null,"2014-10-08"]
["E","苏州","4.2.1","20161206","10.8.96.161","systemszjt","2wsx!QAZ","E5-5507 0 @2.27GHz 2.27GHz","32G","700G","40G","10.8.96.162","systemszjt","2wsx!QAZ","orcl","yjpt","windows","E5-5507 0 @2.27GHz 2.27GHz","32G","2TB","50G","admin","yjptqwerty@1234","http://221.224.9.194:10046/yjpt/",null,null,"是","teamviewer的id:480 071 235；密码：681cdu（数据库连接使用另外一个ip：10.8.64.153）"]
["F","南通","4.2.1","20161206","10.32.0.120","administrator","123.123abc","E5-5620 0 @2.40GHz 2.40GHz(2处理器)","8G","150G","30G","10.32.0.119","administrator",83559381,"yjpt","yjpt","windows","E5-5620 0 @2.40GHz 2.40GHz(2处理器)","8G","150G","70G","admin","yjptqwerty@1234","http://58.221.239.213:7050/yjpt/",null,"2014-08-15","是","teamviewer的id:597621213；密码：123456"]
["F","南通内河","4.2.1","20161206","10.21.97.102","Administrator","2010ntygc!@#",{"$nulls":4},"10.21.97.158","administrator","2010ntygc!@#","orcl","yjpt","windows",{"$nulls":4},"admin","yjptqwerty@1234","http://58.221.88.199:8080/yjpt/"]
["F","南通内河（旧，弃用）","3.9.1","20151213","10.21.96.142","administrator","ygc@123","E5-4607 V2 @2.20GHz 2.20GHz(2处理器)","8G","1T","20G","10.21.96.141","administrator","ygc@123","yjpt","yjpt","windows","E5-4607 V2 @2.20GHz 2.20GHz(2处理器)","8G","1TB","30G","admin","yjptqwerty@1234","http://58.221.88.199:8081/yjpt/",null,"2015-05-12"]
["G","连云港","4.2.1","20161206","10.33.0.147","administrator","ndr+2cs7","E5-4607 V2 @2.60GHz 2.60GHz(4处理器)","32G","400G","40G","10.33.0.148","administrator","ndr+2cs7","orcl    ","yjpt","windows","E5-4607 V2 @2.60GHz 2.60GHz(4处理器)","32G","1.7TB","50G","admin","yjptqwerty@1234","http://211.103.49.236:8080/yjpt/",null,"2015-05-06",null,"teamviewer的ID是145583200，密码123456"]
["H","淮安","4.2.1","20161206","10.7.32.3:3390","administrator","qwer1234!","E5-4603 0 @2.00GHz 2.00GHz(4处理器)","32G","1.8T","50G","10.7.32.3","administrator","qwer1234!","orcl","yjpt","windows","E5-4603 0 @2.00GHz 2.00GHz(4处理器)","32G","1.8TB","30G","admin","yjptqwerty@1234","http://112.4.174.66:7080/yjpt/",null,"2014-09-21",null,"数据库和应用使用同一台服务器"]
["J","盐城","4.2.1","20161206","10.12.254.241:13389","administrator","W.007","E5-4603 V2 @2.20GHz 2.20GHz(4处理器)","32G","100G","40G","192.168.100.250","administrator","W.007","yjpt","yjpt","windows","E5-4603 V2 @2.20GHz 2.20GHz(4处理器)","32G","1TB","60G","admin","yjptqwerty@1234","http://218.92.205.156:18080/yjpt/","有","2014-10-18"]
["J","盐城内河","4.2.1","20161206","10.22.112.15:13389","administrator","Lenovo123","E7-4807 0 @1.87GHz 1.86GHz(4处理器)","32G","1.6TB","50G","192.168.200.251","administrator","lianxiang123!","yjpt","yjpt","windows","E5-4807 0 @1.87GHz 1.86GHz(4处理器)","32G","4TB","50G","admin","yjptqwerty@1234","http://221.231.126.3:18080/yjpt/","有","2014-12-30"]
["K","扬州","4.2.1","20161206","10.5.206.1","administrator","admin@123","E7-4820 0 @2.00GHz 2.00GHz","16.5G","500G",null,"10.5.255.129","administrator","Dataserv1503","yjpt","yjpt","windows","E7-4820 0 @2.00GHz 2.00GHz(4处理器)","64G","2TB","40G ","admin","yjptqwerty@1234","http://61.177.182.197:8080/yjpt/","有","2015-03-26",null,"数据建了个yjpt_zc/yjpt_zc用户,用于扬州数据对接；扬州系统部署的密码是admin@123\nteamviewer的id:677180850；密码：123456"]
["L","镇江","4.2.1","20161206","192.168.10.25","administrator","ZJKA@vmware51","E5-2620 0 @2.00GHz 2.00GHz(2处理器)","5G","32G","20G","192.168.10.1","jsgk","jsgk","zjeport","yjptnewcity","windows","公用",null,null,null,"admin","yjptqwerty@1234","http://zj-eport.gov.cn:7050/yjpt/","有","2014-07-30",null,"虚拟机，性能未满足要求。远程方式：10.1.30.114远程到10.31.240.99:13389(192.168.10.72:3389\n)，再远程到192.168.10.25"]
["L","镇江内河（与镇江合并，弃用）","4.1.2","20161206","10.6.100.101","administrator","zjsjtysj","E5-2620 V2 @2.60GHz 2.60GHz","32G","2TB","50G","10.6.100.101","administrator","zjsjtysj","orcl","yjpt","windows","公用",null,null,null,"admin","yjptqwerty1234","http://61.132.29.219:8088/yjpt/",null,"2014-10-09",null,"数据库和应用使用同一台服务器"]
["M","泰州","4.2.1","20161206","10.10.1.28","Administrator ","Tz86881761","E7-4809 V2 @1.90GHz 1.90GHz(4处理器)","24G","500G","25G","10.10.1.29","Administrator ","Tz86881761","orcl","yjpt","windows","E7-4809 V2 @1.90GHz 1.90GHz(4处理器)","24G","2TB",null,"admin","yjptqwerty@1234","http://218.90.243.178:7000/yjpt/",null,"2014-11-22"]
["M","泰兴","4.2.1","20161206","10.10.207.207","administrator","yjpt.123","E5-4603 V2 @2.20GHz 2.20GHz(4处理器)","32G","300G","50G","10.10.207.208","administrator","yjpt.123","orcl","yjpt","windows","E5-4603 V2 @2.20GHz 2.20GHz(4处理器)","32G","1TB","50G","admin","yjptqwerty@1234","http://58.222.156.35:10001/yjpt/",null,"2015-07-30",null,"泰兴增加远程端口：58.222.156.35:13389 "]
["M","泰兴内河","4.2.1","20161206","10.10.205.137(172.16.10.95)","administrator","TXYGC@123",{"$nulls":4},"172.16.10.96","1qaz@WSX","sys system sactt",{"$nulls":7},"admin","yjptqwerty@1234","http://58.222.241.44:9091/yjpt/"]
["N","宿迁","4.2.1","20161206","10.11.96.23","administrator","Gkj84381105","E5-5620 0 @2.4GHz 2.4GHz","16G","550G","30G","10.11.30.29","administrator","Gkj84381105","orcl","yjpt","windows","E5-5620 0 @2.4GHz 2.4GHz","16G","550G",null,"admin","yjptqwerty@1234","http://61.147.254.211:6081/yjpt/",null,"2015-05-12"]
[]
[]
[null,"文档系统",null,null,"10.1.30.50","Administrator ",123456]
[]
[]
[]
[]
[null,"数据库sysdba密码:Yjpt2015",{"$nulls":16},"58.222.156.35:3889"]
[null,"（南通内河新装的是f）"]

{"sheet":"版本说明","index":1,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["版本号","说明","时间"]
["2.9.1",null,"2015-03-14"]
["3.1.3","督查导入没有","2015-04-08"]
["3.2","海事对接不成功，督查导入,审批权限控制（对应模块）","2015-04-30"]
["3.3","海事数据对接，报表更新，","2015-05-08"]
["3.4","控制海事对接的数据，只有发版本的地市才同步数据,南通内河所在地更新","2015-05-12"]
["3.5","海事比对变更，督查办理修正，经营人信息审核功能增加","2015-05-30"]
["3.5.1","海事比对更新，报表打印更新，行政人员审批权限修正","2015-06-11"]
["3.6","危货统计增加进出港；申报页面增加船队；去除birt；危货审核中数据可修改；\n南京本部、苏州常熟内河、昆山、无锡新区、扬州江都加章","2015-06-27"]
["3.7","督查查询条件增加整改状态；大菜单统计过滤删除的港区；宿迁所在地变更\n增加泰兴所在地（市级）；附证编号统一；督查流程增加控制","2015-07-29"]
["3.7.1","管理制度、应急物资、安全设施设备和管理制度模板导入；待办任务分页；时间控件（选时分时也确认选择）；港区根据使用频率自动排序；应急预案审核中可编辑","2015-08-19"]
["3.7.2","危货页面增加集装箱箱量TEU，各集装箱数量并统计；验证码加宽；危货复制权限放开；导入模块优化；危货打印报表更新","2015-08-25"]
["3.7.3","专项检查页面的督查查看；集装箱TEU的优化；危货","2015-08-28"]
["3.8","附证信息增加微信扫描；时间控件修正；经营人一览页面查询修正；附证变更增加附件，附证变更企业基本数据可编辑；数据删除同步bug修正;经营人查询条件是否危货企业变更；作业申报集装箱数量可输入小数；","2015-09-25"]
["3.8.1","经营人一览页面查询条件增加所在区域；公告附件为多附件形式；海事比对优化；\n人员信息导入","2015-10-15"]
["3.8.2","泊位统计万吨修正；经营人页面附证查看优化；督查任务状态变更；危货申报查看页面审批信息查看和标色（红粗）；非“同意作业”的已完成的危货作业一览也面变色（黄）；船代角色增加；督查市级下发修正；经营人统计精确到三位小数；督查导出任务状态显示；危货申请72小时开关控制；危货打印增加上港和下港；","2015-10-29"]
["3.8.3","时间控件优化；危货有关的待办增加双击事件；自动审批设置过滤掉普货企业；\n自动审批图标；","2015-11-15"]
["3.9","危险品增加UN号和名称说明（危货申请，附证，附证变更，统计）；增加企业情况和存储设施信息统计；经营人统计页面省局变成存储量变成储罐个数和储罐总容量；储罐一览页面字段变更；经营人一览查询条件增加码头类型和储罐类型；经营人类型变化；储罐增加当前状态；张家港增加章；淮安增加视频监控；","2015-11-26"]
["3.9.1","危险品毒性等级增加剧毒；危货申报标注报告时间和危险品；泊位靠泊能力与装载量之间判断；附证报表修正；附证打印开放；","2015-12-13"]
["3.9.2","统计图增加查询按钮;所在地的附证过期和超期提醒;增加用户操作手册;淮安视频切入;太仓沿江，苏州吴中加章；督查流程修改","2015-01-13"]
["4.0.0","附证增加查看，首页代办提醒，作业申报一览增加状态查询条件，底部增加作废数，吞吐量统计货种一直可见，作业量统计增加导出；镇江，镇江内河合并","2016-04-16"]
["4.0.1","1、作废状态改成“不通过”，并增加“退回”状态，一览查询结果下方显示“不通过XX条，退回XX条”。\n2、危货作业取消和变更的审批不在待办事项中，需要纳入进来。\n3、危货作业查询中增加“审核人”条件。\n6、企业收到消息后是否已读（袁：增加消息管理画面，可以查看发送了哪些消息，哪些已读，哪些未读，发送人、接收人联系方式）\n7、手机app修改：危货申报中，已经批准的默认不显示，但是可以采用查询到已批准的申报。\n8、数据公示功能需要按规定的格式进行修改，包括字体大小等。\n9、督查、自查、应急管理模块的照片附件大小可配置。\n10、不通过的原因可配置，取自公共代码。\n11、督查的隐患大类、中类、分类和区域非必填。\n12、数据导入模板修改，去掉镇江内河。\n13、开工完工报时可更改上港和下港。\n14、经营人页面增加法人身份证号。\n15、太仓视频监视修复。","2016-04-30"]
["4.1.0","1、申报画面加一个字段“技术品名”，默认带入所选择的危险品名称，文本框、必填、可修改。\n2、理化性质和安全防范措施添加记忆功能，按危险品名记忆上次所填的内容\n3、公告添加收件人，可以指定发给哪些企业\n4、申报画面添加一个字段“包装”，文本框，集装箱申报必填\n5、自动审批添加有效时间范围，如果当前时间在所设置的范围内可以自动审批，如果不在不审批。比如2016-04-07 08:00:00~2016-04-10 08:00:00\n6.南京法人行政许可优化","2016-05-31"]
["4.1.2","1：申报单页面增加集装箱箱号\n2：公告页面优化\n3：消息修正\n4：申报单页面按钮配置化\n5：附证，安全审批一览页面经营人查询条件变成文本框","2016-06-04"]
["4.1.3","1：危货申报一览页面查询条件省局文本，市级下拉框\n2：危货作业申报许可统计\n3：督查延期整改修正\n4：剧毒化学品备案，待办任务处理","2016-07-01"]

{"sheet":"数据库","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,1,1],[0,2,1,2]]}
[null,"地市名称","备注数据库备份方法"]
[]
[null,"江苏省","在10.1.30.114上由命令导出数据库备份"]
["A","南京-省局新","在10.1.30.114上由命令导出数据库备份"]
["B","无锡","由10.1.30.114远程连接到服务器上用命令导出"]
["C","徐州","在10.1.30.114上由命令导出数据库备份"]
["D","常州","由10.1.30.114远程连接到服务器上用命令导出"]
["E","苏州","由10.1.30.114远程连接到服务器上用命令导出"]
["F","南通","由10.1.30.114远程连接到服务器上用命令导出"]
["F","南通内河"]
["G","连云港","由10.1.30.114远程连接到服务器上用命令导出"]
["H","淮安","由10.1.30.114远程连接到服务器上用命令导出（数据库和应用使用同一台服务器）"]
["J","盐城","先由10.1.30.114连上应用服务器，再由应用服务器远程到数据库服务器"]
["J","盐城内河","先由10.1.30.114连上应用服务器，再由应用服务器远程到数据库服务器"]
["K","扬州","由10.1.30.114远程连接到服务器上用命令导出"]
["L","镇江","由应用服务器192.168.10.25上用命令导出数据库备份"]
["M","泰州","由10.1.30.114远程连接到服务器上用命令导出"]
["M","泰兴","由10.1.30.114远程连接到服务器上用命令导出，也可以拨了vpn后远程到58.222.156.35:13389再远程到数据库服务器"]
["N","宿迁","由10.1.30.114远程连接到服务器上用命令导出（原本上面有个任务计划，每天都会备份数据库，之前有段时间数据库用户名密码不对，有些备份文件夹是空的，后来改过了，时间长了，空间可能有问题）"]

{"sheet":"安全系统各地市设定","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"地市名称","sequence start","szd"]
[null,"江苏省",17000000001,900]
["A","南京",3000000001,90014]
["B","无锡",5000000001,90016]
["C","徐州",9000000001,90020]
["D","常州",10000000001,90021]
["E","苏州",1000000001,90012]
["F","南通",7000000001,90015]
["F","南通内河",14000000001,90025]
["G","连云港",2000000001,90013]
["G","连云港内河",15000000001,90026]
["H","淮安",12000000001,90023]
["J","盐城",8000000001,90019]
["J","盐城内河",16000000001,90027]
["K","扬州",6000000001,90017]
["L","镇江",1,90011]
["L","镇江内河",13000000001,90024]
["M","泰州",4000000001,90018]
["M","泰兴",18000000001,90028]
["M","泰兴内河",19000000001,90029]
["N","宿迁",11000000001,90022]

{"sheet":"公司内网服务器信息","index":4,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,5],[0,6,0,8]]}
["SVN",null,null,"应用",null,null,"数据库"]
["IP","用户","密码","IP","用户","密码","IP","用户","密码"]
["192.168.57.71","administrator","xt.123","192.168.57.81（旧）\n192.168.57.37","administrator","Aaa12345","192.168.57.83（旧）\n192.168.57.36","administrator","xt.123"]
[null,null,null,"192.168.57.74","administrator","74xt.123"]

{"sheet":"各所在地部署情况及联系人","index":5,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["序号","所在地","状态","联系人1","联系电话","联系人2","联系电话","备注"]
[1,"省局","已部署","杨正",null,null,null,"省厅信息中心"]
[2,"镇江","已部署，已培训","陈俊",15051143886,"陈海浪",15262904156,"镇江市口岸门户"]
[3,"南京","已部署，已培训，试运行完善中","殷科",null,null,null,"http://221.226.102.115:8080/yjpt/Main.html "]
[4,"南通港","已部署 和刘局沟通，周三培训","陈处","QQ：250285346",null,null,"已向政务网申请发布外网链接"]
[5,"常州","已部署","常州市交通局邓处",348872230]
[6,"淮安","已部署，已培训","漆伟","qq:568358608 手机：15152362307"]
[7,"南通内河港","交通局在搬到新大楼，但是尚未通电，因此耽搁了部署进度，10月中旬完成  采购计划已报财政","程峰","QQ：651552848，手机：13813745446","纪林 1750407863",13606298999]
[8,"扬州","局里统筹安排软硬件，周六上午给IP地址进行系统部署","扬州港口管理局何局",13605272130,"钱科","15298461008，QQ：19783617","赵处 15995122002"]
[9,"泰州","设备正在采购中，大约10月中旬能够部署好","杨科","QQ:475934690，手机：18952611219","戚处","办公室：86881800手机：13337792999","唐科 052386881790    钱科（钱凯） 18952611219","陈总电话189-5261-2066"]
[10,"盐城港","9月29日招标结束，设备已进场，正在安装部署","胡主任","QQ：369116968，手机：13805103833"]
[11,"盐城内河港","分管领导开组织会时进行研究，部署工作","单科","QQ：550188531，手机：18961996506"]
[12,"镇江内河港","已部署","沈科","QQ：191119212，手机：18912803979","查主任",18912809211,"吕 18912803882","工程师 18912803911",null,"欧主任 80828399 912533016"]
[13,"连云港","如果一切顺利的情况，从省局发文到部署完成，大约需要1个月的时间","王处","邮箱：LYGKAW@126.com，手机：13775584597"]
[14,"无锡港","已部署","孙科","QQ：3241902，手机：13585072886","钱主任（信息中心）","QQ：472979272，手机：13915350058","  固话051081822848","刘工（信息中心）18914111114","刘处81822835 、13961690217"]
[15,"苏州港","正在做系统迁移，10月中旬能完成部署","张处","办公室：051268125860","杨处","手机：15950063113\n邮箱：yanghoude@szjt.gov.cn\n     yanghoude@163.com\nQQ: 1248970034"]
[16,"徐州港","已部署","许处","QQ：812365636，手机：13952169499"]
[17,"宿迁","设备已满足条件，但是搬到新楼里基建施工影响了部署进度","宿迁港口局朱科","QQ：250947419，13951194228","钱主任","0527-84381105","张杨科长：qq14244286"]
[18,"连云港内河港","情况比较复杂特殊，现由港口办管理港口事务，且两名管理人员都为借调人员，需要时会同业务和信息处室进行处理，业务方面没有危化品企业，没有吞吐量较大的码头，（曾经有过，已被连云港港接管）","港口办"]