{"text_format":"2","workbook":"xlsx","n_sheets":2,"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":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,16,10,18],[0,0,1,0],[0,22,1,22],[0,3,0,8],[0,10,0,18],[0,20,0,21],[2,16,2,18],[3,16,3,18],[0,26,1,26],[0,23,1,23],[0,24,1,24],[0,1,0,2],[7,16,7,18],[0,25,1,25]]}
["地市名称","系统版本",null,"应用服务器",{"$nulls":6},"数据库",{"$nulls":9},"管理员",null,"外网访问URL","防火墙","部署时间","微信端","备注"]
[null,"版本号","最新发布日期","IP","用户名","密码","处理器","内存","可用硬盘","已用","IP","用户名","密码","sid","连接用户名","连接密码","处理器","内存","硬盘","已用","用户名","密码"]
["江苏省","4.1.2","20160604","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","yjptqwerty1234",null,"有"]
["镇江","4.1.2","20160604","192.168.10.25","administrator",null,"E5-2620 0 @2.00GHz 2.00GHz(2处理器)","5G","32G","20G","192.168.10.1",null,null,"zjeport","yjptnewcity","windows","公用",null,null,null,"admin","yjptqwerty1234","http://zj-eport.gov.cn:7050/yjpt/","有","2014-07-30",null,"虚拟机，性能未满足要求"]
["南通","4.1.2","20160604","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","yjptqwerty1234","http://58.221.239.213:7050/yjpt/",null,"2014-08-15","是","teamviewer的id:597621213；密码：123456"]
["常州","4.1.2","20160604","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","yjptqwerty1234","http://222.185.255.10:5678/yjpt/",null,"2014-10-08"]
["淮安","4.1.2","20160604","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","yjptqwerty1234","http://112.4.174.66:7080/yjpt/",null,"2014-09-21",null,"数据库和应用使用同一台服务器"]
["南京","4.1.2","20160604","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,"硬件差，数据库和应用使用同一台服务器"]
["南京-省局新","4.1.2","20160604","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","yjptqwerty1234","http://218.2.208.145:8090/yjpt/",null,null,"是"]
["徐州","4.1.2","20160604","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","yjptqwerty1234","http://222.187.126.162:81/yjpt/","有","2014-10-09"]
["镇江内河","4.1.2","20160604","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,"数据库和应用使用同一台服务器"]
["无锡","4.1.2","20160604","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","yjptqwerty1234","http://61.160.77.229:8080/yjpt/",null,"2014-10-18","是"]
["盐城","4.1.2","20160604","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","yjptqwerty1234","http://218.92.205.156:18080/yjpt/","有","2014-10-18"]
["泰州","4.1.2","20160604","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","yjptqwerty1234","http://www.tzjtj.gov.cn:7000/yjpt/",null,"2014-11-22"]
["盐城内河","4.1.2","20160604","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",null,null,"http://221.231.126.3:18080/yjpt/","有","2014-12-30"]
["苏州","4.1.2","20160604","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","yjptqwerty1234","http://221.224.9.194:10046/yjpt/",null,null,"是","teamviewer的id:480 071 235；密码：681cdu（数据库连接使用另外一个ip：10.8.64.153）"]
["扬州","4.1.2","20160604","10.5.255.128","administrator","Webserv1503","E7-4820 0 @2.00GHz 2.00GHz","16.5G","500G",null,"10.5.255.128","administrator","Dataserv1503","yjpt","yjpt","windows","E7-4820 0 @2.00GHz 2.00GHz(4处理器)","64G","2TB","40G ","admin","yjptqwerty1234","http://61.177.182.197:8080/yjpt/","有","2015-03-26",null,"数据建了个yjpt_zc/yjpt_zc用户,用于扬州数据对接；扬州系统部署的密码是admin@123\nteamviewer的id:677180850；密码：123456"]
["连云港","4.1.2","20160604","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","yjptqwerty1234","http://211.103.49.236:8080/yjpt/",null,"2015-05-06",null,"连云港不跟专网通，不跟省局同步,teamviewer的ID是145583200，密码123456"]
["连云港内河"]
["南通内河","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","yjptqwerty1234","http://58.221.88.199:8081/yjpt/",null,"2015-05-12"]
["宿迁","4.1.2","20160604","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","yjptqwerty1234","http://61.147.254.211:6081/yjpt/",null,"2015-05-12"]
["泰兴","4.1.2","20160604","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",null,null,"http://58.222.156.35:10001/yjpt/",null,"2015-07-30",null,"泰兴增加远程端口：58.222.156.35:13389 "]
["文档系统",null,null,"10.1.30.50","Administrator ",123456]
[]
[]
[]
[]
["数据库密码","Yjpt2015"]

{"sheet":"版本说明","index":1,"n_rows":24,"n_cols":3,"rows_kept":24,"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"]