{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["项目工作量估算","项目计划","方案说明"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,3],[32,0,32,3],[3,1,14,1],[15,1,19,1],[20,1,21,1],[22,1,27,1],[28,1,31,1],[3,2,6,2],[7,2,14,2],[15,4,19,4],[20,4,21,4]]}
["项目工作量估算"]
["项目名称","用户统一管理系统",null,null,"备注"]
["序号","功能模块","子模块","功能"]
[{"$f":"ROW()-3","v":1},"用户统一管理系统","平台基础功能","用户管理","用户的增删改查功能。"]
[{"$f":"ROW()-3","v":2},null,null,"单点系统管理"]
[3,null,null,"系统级赋权管理","系统级的赋权管理，系统内模块的赋权在各个系统中实现"]
[4,null,null,"登录及首页"]
[5,null,"应用接口","用户新增"]
[6,null,null,"用户修改"]
[7,null,null,"用户删除"]
[8,null,null,"密码修改"]
[9,null,null,"用户存在验证"]
[10,null,null,"用户权限验证"]
[11,null,null,"用户权限修改"]
[12,null,null,"接口联调"]
[13,"省级各系统用户梳理","安全系统",null,"不在本次报价范围内"]
[14,null,"经营系统"]
[15,null,"资源系统"]
[16,null,"OA系统"]
[17,null,"锚调系统"]
[18,"各地市系统用户梳理","安全系统",null,"不在本次报价范围内"]
[19,null,"经营系统"]
[20,"业务系统改造","安全系统",null,"不在本次报价范围内"]
[21,null,"经营系统"]
[22,null,"资源系统",null,"不在本次报价范围内"]
[23,null,"OA系统"]
[24,null,"锚调系统",null,"不在本次报价范围内"]
[25,null,"智能监管平台"]
[26,"个别任务","初始化数据导入"]
[27,null,"数据库设计"]
[28,null,"系统部署"]
[29,null,"连云港门户的简单首页"]
["合计"]
["说明："]
["1、省、地市两级部署，省级部署一套单独的AP、DB，地市按照港口区划分别部署AP、DB"]
["2、省级用户统一管理，地市用户按照港口区划分别单独管理"]
["3、本系统只做系统级的赋权管理，各系统内模块的赋权在各个系统中实现"]

{"sheet":"项目计划","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,1,6,1],[7,1,8,1],[9,1,10,1],[11,1,13,1],[2,3,8,3],[9,3,10,3],[11,3,13,3],[2,4,8,4],[9,4,10,4],[11,4,13,4]]}
["项目工作计划"]
["序号","功能模块","子模块","开始时间","结束时间"]
[{"$f":"ROW()-2","v":1},"省级各系统用户梳理","安全系统","2016-11-14","2016-12-15"]
[2,null,"经营系统"]
[3,null,"资源系统"]
[4,null,"OA系统"]
[5,null,"锚调系统"]
[6,"各地市系统用户梳理","安全系统"]
[7,null,"经营系统"]
[8,"用户统一管理系统","平台基础功能","2016-11-14","2016-12-15"]
[9,null,"应用接口"]
[10,"业务系统改造","经营系统","2016-11-30","2016-12-25"]
[11,null,"OA系统"]
[12,null,"智能监管平台"]
[13,"连云港门户的简单首页",null,"2016-11-28","2016-12-02"]

{"sheet":"方案说明","index":2,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[[8,0,8,36]]}
["方案说明："]
["一、用户梳理工作"]
["1、省级用户梳理"]
["①、安全系统省级数据库、经营系统省级数据库、资源系统数据库、锚调系统数据库、OA系统数据库的用户表及关联表数据抽取"]
["②、对抽取的用户数据做汇总、去重、筛选、转换、比对、分析"]
["③、针对重名用户、多用户、无匹配用户等问题跟业主确认"]
["④、根据用户统一管理系统的数据库要求，做成初始化数据"]
["实施步骤"]
["1)收集各业务系统目前所有的用户信息(登录名、用户名、所属经营人企业或行政人员)\n2)将收集来的用户信息进行整理，合并，并记录每个用户可访问的系统(如从OA系统收集来的用户信息，默认都可以访问OA系统，其它类同)\n3)如出现登录名相同的情况时，做以下处理：\n①　首先判断收集来的系统用户是否为同一用户(登录名相同，可通过用户名初步判断，最终判断需要业主确认)\n②　如判断为同一用户，合并登录信息，标记此登录名可同时登录多个系统\n③　如判断为非同一用户，则需要对相同的登录名进行区别处理，重命名其中一个登录名，如在原登录名后加“１”，以区分\n④　如出现同一用户在不同系统中有不同的登录名情况出现时，保留原登录名，记录原登录名可登录的系统，当实际用户提出时，做针对性修改(合并用户，在多个可用登录名中选择一个，其它系统中新建相同的登录名的用户，原来多余的登录名用户帐号做逻辑删除操作)"]
["2、地市用户梳理"]
["①、目前只梳理连云港地市的用户数据"]
["②、安全系统地市级数据库、经营系统地市级数据库的用户表及关联表数据抽取"]
["②、对抽取的用户数据做汇总、去重、筛选、转换、比对、分析"]
["③、针对重名用户、多用户、无匹配用户等问题跟业主确认"]
["④、根据用户统一管理系统的数据库要求，做成初始化数据"]
["二、统一用户管理系统"]
["①、省级部署一套单独的用户统一管理系统，对省级用户做统一管理"]
["②、地市按照港口区划分别单独部署一套用户统一管理系统，对各个地市的用户分别做统一管理"]
["③、统一用户管理系统只做系统级的赋权管理，各系统内模块的赋权在各个系统中实现"]
["④、涉及到各系统的内部改造，改造对接人：安全系统-->马寅虎，资源系统-->马寅虎，锚调系统-->马寅虎；经营、OA、智能监管平台-->李前锟"]