{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["后端开发计划","前端开发计划","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"后端开发计划","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"merged":[[1,0,35,0],[1,1,35,1],[1,2,4,2],[1,3,4,3],[1,4,4,4],[1,5,4,5],[1,6,4,6],[1,7,4,7],[1,8,4,8],[5,8,10,8],[6,2,11,2],[6,3,11,3],[6,4,11,4],[6,5,11,5],[6,6,11,6],[6,7,11,7],[11,8,16,8],[12,2,17,2],[12,3,17,3],[12,4,17,4],[12,5,17,5],[12,6,17,6],[12,7,17,7],[17,8,21,8],[18,2,22,2],[18,3,22,3],[18,4,22,4],[18,5,22,5],[18,6,22,6],[18,7,22,7],[22,8,27,8],[23,2,28,2],[23,3,28,3],[23,4,28,4],[23,5,28,5],[23,6,28,6],[23,7,28,7]],"flags":["formulas_cached_only"]}
["工程","模块","功能","功能描述","方案","计划开始时间","计划结束时间","计划完成天数","备注"]
["TQC远程升级web平台","TQC远程升级web平台","系统搭建","架构搭建","使用maven搭建项目、采用SpringBoot+mybatis框架，数据库采用mysql、环境搭建\n","2020-04-16","2020-04-17","2天"]
[]
[]
[]
[null,null,"日志文件","平台运行日志","采用log4j获取平台日志","2020-04-20","2020-04-20","1天"]
[null,null," 用户管理","实现的对用户的管理","新建一个用户类，从而实现对用户的增删改查","2020-04-21","2020-04-23","3天"]
[]
[]
[]
[]
[]
[null,null,"用户权限管理","不同用户具有的权限是不一样的，如：若是admin用户、test用户具有的用户权限是不一样的","采用springBoot-security来控制权限","2020-04-24","2020-04-28","3天"]
[]
[]
[]
[]
[]
[null,null,"升级包管理","增删改查","定义升级包类，从而实现对升级包的增删改查","2020-04-29","2020-04-30","2天"]
[]
[]
[]
[]
[null,null,"升级包权限管理","不同用户对升级包的访问权限是不一样的，可以实现根据用户的角色来控制其对升级包的访问权限","在用户中定义一个角色的属性，根据用户的角色来控制其是否具有对不同升级包的访问权限","2020-05-06","2020-05-08","3天"]
[]
[]
[]
[]
[]
[null,null,"升级包统计","升级包下载次数统计、版本统计","每完成一次下载便对对应升级包进行统计","2020-05-11","2020-05-13","3天"]
[null,null,"升级包加密管理","实现对升级包的加密管理","使用Spring框架的Bcrypt加密","2020-05-14","2020-05-18","2天"]
[null,null,"web平台发布部署","将web平台发布部署到云服务器、环境搭建与测试","采用jar的部署方式实现","2020-05-19","2020-05-21","4天"]
[null,null,"手机app增加一个登陆web平台页面","app通过该页面登录平台从而实现对该用户的权限控制","新建一个登陆页面","2020-05-22","2020-05-22","1天"]
[null,null,"手机app对接web系统","手机app不在从sdcard中获取升级包，而是从web平台系统获取升级包","用http请求从web平台中下载升级包","2020-05-25","2020-05-26","2天"]
[null,null,"手机app对下载的升级包进行解密","平台下载下来的升级是有加密处理的，故app需要解密后方能使用，保证升级包的使用权限管理","android采用Base64解密","2020-05-27","2020-05-28","2天"]
[null,null,"app打包发布测试","app打包测试发布","采用gradle打包发布","2020-05-29","2020-05-29","1天"]

{"sheet":"前端开发计划","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[1,0,6,0],[1,1,3,1],[4,1,6,1],[16,0,17,0]],"flags":["formulas_cached_only"]}
["工程","模块","功能","功能描述","方案","计划开始时间","计划结束时间","计划完成天数","备注"]
["TQC远程升级web平台","用户管理模块","登录页面","提供一个用户登录页面","采用vue登录页面，用户登录需要提供用户名、密码、验证码","2020-06-01","2020-06-02","2天"]
[null,null,"首页页面","提供一个用户登录显示首页","采用vue框架的布局容器container的方式设计","2020-06-03","2020-06-03","1天"]
[null,null,"用户管理页面","管理员可以对用户进行管理，如增删改查，授权角色管理等操作","页面是用户信息，信息后面有对用户进行管理，如修改，更新，授权等操作，左侧头部分是一个查询框，根据用户名进行模糊查询，右侧是一个添加用户按钮","2020-06-04","2020-06-09","4天"]
[null,"升级包管理模块","用户信息管理中心","登录的用户可以选择头像、密码或其他信息修改","提供一个嵌套card来展示用户信息","2020-06-10","2020-06-11","2天"]
[null,null,"升级包管理页面","具有权限的用户可对升级包进行操作，如下载，上传，增删改查等操作","页面是升级包信息，信息后面有对升级包进行管理，如修改，更新，下载等操作，左侧头部分是一个查询框，根据升级包名进行模糊查询，右侧是一个上传升级包按钮","2020-06-12","2020-06-16","3天"]
[null,null,"项目打包部署","Linux环境安装搭建","采用公有云Linux虚拟机，将项目中所需的环境安装部署","2020-06-17","2020-06-19","3天"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}