{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["功能列表","技术列表","Sheet3"],"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":94,"n_cols":11,"rows_kept":94,"cut":false,"hidden":false,"merged":[[1,0,1,3],[68,0,68,3],[70,0,70,3],[5,0,5,3],[10,0,10,3],[35,0,35,3],[49,0,49,3],[62,0,62,3],[43,0,43,3],[46,0,46,3]]}
["菜单模块","功能划分","是否可用","完成人员","进度(%)","页面访问路径URL","用户角色","访问权限","备注","备注","备注"]
["系统登录"]
["系统登录","系统登录","Y","侯庆营",100,"/sba/",null,"SBA",null,"最近登录时间不正确（由手机端生成）"]
[null,"系统主页面","Y","侯庆营",100,"/sba/main",null,"MAIN",null,"最近登录时间不正确（由手机端生成）"]
[null,"系统退出","Y","侯庆营",100,"/sba/logout",null,"LOGOUT",null,"最近登录时间不正确（由手机端生成）"]
["用户管理"]
["用户管理","用户查询列表","Y","侯庆营",100,"/sba/user/querypage","ROLE_ADMIN_USER","USER_QUERYPAGE",null,"最近登录时间不正确（由手机端生成）"]
[null,"用户条件查询","Y","侯庆营",100,"/sba/user/querypageby",null,"USER_QUERYPAGEBY",null,"注册时间，查询9月14日-9月15日，则9月14日注册和9月15日注册都查不出来"]
[null,"用户分页跳转","Y","侯庆营",100,"/sba/user/querypageby",null,"USER_QUERYPAGEBY"]
[null,"用户批量导出EXCEL","Y","侯庆营",100,"/sba/excel/exportuser",null,"EXCEL_EXPORTUSER"]
["员工管理"]
["代理员工","代理员工查询列表","Y","侯庆营",100,"/sba/employee/queryagencypage","ROLE_ADMIN_EMPLOYEE","EMPLOYEE_QUERYAGENCYPAGE","购买城市未关联"]
[null,"代理员工条件查询","Y","侯庆营",100,"/sba/employee/queryagencypage",null,"EMPLOYEE_QUERYAGENCYPAGE","购买城市，户籍类型查询不到"]
[null,"代理员工分页跳转","Y","侯庆营",100,"/sba/employee/queryagencypage",null,"EMPLOYEE_QUERYAGENCYPAGE"]
[null,"代理员工状态修改","Y","侯庆营",100,"/sba/employee/updaterecon",null,"EMPLOYEE_UPDATERECON"]
[null,"代理员工批量状态修改","Y","侯庆营",100,"/sba/employee/batchrecon",null,"EMPLOYEE_BATCHRECON"]
[null,"代理员工按月查询列表","Y","侯庆营",100,"/sba/employee/queryagencydetailpage",null,"EMPLOYEE_QUERYAGENCYDETAILPAGE"]
[null,"代理员工批量导出EXCEL","Y","侯庆营",100,"/sba/excel/exportagencydetail",null,"EXCEL_EXPORTAGENCYDETAIL","购买城市不对应，服务费不准确"]
[null,"代理员工导入核对EXCEL","Y","侯庆营",100,"/sba/excel/importEmployeeExcel",null,"EXCEL_IMPORTEMPLOYEEEXCEL","导入字段计算不对应"]
["增减员","增减员查询列表","Y","侯庆营",100,"/sba/employee/querychangepage",null,"EMPLOYEE_QUERYCHANGEPAGE"]
[null,"增员条件查询","Y","侯庆营",100,"/sba/employee/querychangedetailpage",null,"EMPLOYEE_QUERYCHANGEDETAILPAGE","购买城市，户籍类型查询不到"]
[null,"增员分页跳转","Y","侯庆营",100,"/sba/employee/querychangedetailpage",null,"EMPLOYEE_QUERYCHANGEDETAILPAGE"]
[null,"增员批量导出EXCEL","Y","侯庆营",100,"/sba/employee/excel/exportchangecoming",null,"EMPLOYEE_EXCEL_EXPORTCHANGECOMING","购买城市不对应，服务费不准确"]
[null,"导入增员卡号EXCEL","Y","侯庆营",100,"/sba/excel/importEmployeeAddExcel",null,"EXCEL_IMPORTEMPLOYEEADDEXCEL","导入字段计算不对应"]
[null,"编辑增员状态","Y","侯庆营",100,"/sba/employee/updaterecon",null,"EMPLOYEE_UPDATERECON"]
[null,"批量修改增员状态","Y","侯庆营",100,"/sba/employee/batchrecon",null,"EMPLOYEE_BATCHRECON"]
[null,"编辑增员卡号","Y","侯庆营",100,"/sba/employee/updatesbcard",null,"EMPLOYEE_UPDATESBCARD","置空时有问题","校验表格输入内容长度"]
[null,"编辑增员失败原因","Y","侯庆营",100,"/sba/employee/updatereason",null,"EMPLOYEE_UPDATEREASON","置空时有问题"]
[null,"查看增员身份证","Y","侯庆营",100,"/sba/employee/checkidcard",null,"EMPLOYEE_CHECKIDCARD"]
[null,"增减员打包下载身份证ZIP","Y","侯庆营",100,"/sba/employee/downloadfile",null,"EMPLOYEE_DOWNLOADFILE","暂未测试"]
[null,"查询减员列表","Y","侯庆营",100,"/sba/employee/querychangedetailpage",null,"EMPLOYEE_QUERYCHANGEDETAILPAGE"]
[null,"减员条件查询","Y","侯庆营",100,"/sba/employee/querychangedetailpage",null,"EMPLOYEE_QUERYCHANGEDETAILPAGE"]
[null,"减员分页跳转","Y","侯庆营",100,"/sba/employee/querychangedetailpage",null,"EMPLOYEE_QUERYCHANGEDETAILPAGE"]
[null,"减员批量导出EXCEL","Y","侯庆营",100,"/sba/excel/exportchangegoing",null,"EXCEL_EXPORTCHANGEGOING","购买城市不对应"]
[null,"编辑减员失败原因","Y","侯庆营",100,"/sba/employee/updatereason",null,"EMPLOYEE_UPDATEREASON","置空时有问题"]
["订单管理"]
["订单管理","订单查询列表","Y","侯庆营",100,"/sba/order/querypageby","ROLE_ADMIN_ORDER","ORDER_QUERYPAGEBY","社保卡，备注不对应，","主页：购买城市空了；下单时间时分秒错；购买类型为社保时候错；社保卡是否需要错；订单状态？\n","详情页：选择购买社保，社保卡和社保卡费用时展示不正确；打包购买时服务费不正确；支付方式没有填写；下单时间时分秒错；修改时间没有更新"]
[null,"订单条件查询","Y","侯庆营",100,"/sba/order/querypageby",null,"ORDER_QUERYPAGEBY",null,"购买账号查询？下单时间请检查时间区间的开闭情况。 例如9月28-9月28日搜不出结果"]
[null,"订单分页跳转","Y","侯庆营",100,"/sba/order/querypageby",null,"ORDER_QUERYPAGEBY",null,"跳转到第3页后，1,2页不见了。"]
[null,"订单批量导出EXCEL","Y","侯庆营",100,"/sba/excel/exportorder",null,"EXCEL_EXPORTORDER","导出错误"]
[null,"订单详情修改显示","Y","侯庆营",100,"/sba/order/querydetail",null,"ORDER_QUERYDETAIL"]
[null,"订单详情修改","Y","侯庆营",100,"/sba/order/modify",null,"ORDER_MODIFY","服务费不准确"]
[null,"订单备注修改","Y","侯庆营",100,"/sba/order/modify",null,"ORDER_MODIFY","未做"]
["买单管理"]
["买单管理","买单查询列表","Y","侯庆营",100,"/sba/buy/querypageby","ROLE_ADMIN_BUY","BUY_QUERYPAGEBY"]
[null,"买单条件查询","Y","侯庆营",100,"/sba/buy/querypageby",null,"BUY_QUERYPAGEBY"]
["城市配置"]
["城市配置","城市配置列表","Y","赖应和",100,"/sba/city/list","ROLE_ADMIN_CITY","PERMIT_CITY_LIST"]
[null,"城市配置条件查询","Y","赖应和",100,"/sba/city/list",null,"PERMIT_CITY_LIST"]
["参数调整"]
["社保参数","社保参数查询列表","Y","赖应和",null,"/sba/sb/list","ROLE_ADMIN_SB","SB_LIST",null,"跟参数修改页不对应"]
[null,"社保参数条件查询"]
[null,"社保参数增加","Y","赖应和",null,"/sba/sb/2modify",null,"SB_2MODIFY"]
[null,"社保参数提交修改","Y","赖应和",null,"/sba/sb/mod/main",null,"SB_MOD_MAIN"]
[null,"社保参数分页跳转"]
["公积金参数","公积金参数查询列表","Y","赖应和",null,"/sba/fund/list","ROLE_ADMIN_FUND","FUND_LIST",null,"跟参数修改页不对应"]
[null,"公积金参数条件查询"]
[null,"公积金参数修改","Y","赖应和",null,"/sba/fund/2modify",null,"FUND_2MODIFY"]
[null,"公积金参数提交修改","Y","赖应和",null,"/sba/fund/modify",null,"FUND_MODIFY"]
[null,"公积金参数分页跳转"]
["服务费","服务费查询列表","Y","侯庆营",null,"/sba/charge/querylist","ROLE_ADMIN_CHARGE","CHARGE_QUERYLIST"]
[null,"服务费提交修改",{"$nulls":6},"未做"]
["群发消息"]
["群发消息","群发消息查询消息列表","Y","侯庆营",100,"/sba/news/list","ROLE_ADMIN_NEWS","NEWS_LIST"]
[null,"群发消息保存","Y","侯庆营",100,"/sba/news/add",null,"NEWS_ADD"]
[null,"群发消息分页跳转","Y","侯庆营",100,"/sba/news/querylist",null,"NEWS_QUERYLIST"]
[null,"群发消息删除","Y","侯庆营",100,"/sba/news/delete",null,"NEWS_DELETE"]
[null,"群发消息批量删除消息","Y","侯庆营",100,"/sba/news/batchdelete",null,"NEWS_BATCHDELETE"]
["代理机构",{"$nulls":7},"未包含在此版本，没有确定需求"]
["代理机构","代理机构查询列表"]
["系统账号管理",{"$nulls":7},"未包含在此版本，先初步实现"]
["系统账号管理","添加系统账号","Y","侯庆营",100,"/sba/system/user/add","ROLE_ADMIN_SYSTEM_USER","SYSTEM_USER_ADD"]
[null,"删除系统账号","Y","侯庆营",100,"/sba/system/user/delete",null,"SYSTEM_USER_DELETE"]
[null,"查询系统账号","Y","侯庆营",100,"/sba/system/user/querypageby",null,"SYSTEM_USER_QUERYPAGEBY"]
[null,"修改账号密码显示","Y","侯庆营",100,"/sba/system/user/showpass",null,"SYSTEM_USER_SHOWPASS"]
[null,"修改账号密码","Y","侯庆营",100,"/sba/system/user/updatepass",null,"SYSTEM_USER_UPDATEPASS"]
[null,"授权账号角色查询页面","Y","侯庆营",100,"/sba/system/user/queryrolelist",null,"SYSTEM_USER_QUERYROLELIST"]
[null,"授权账号角色提交","Y","侯庆营",100,"/sba/system/user/grantrole",null,"SYSTEM_USER_GRANTROLE"]
[null,"禁用账号",null,"侯庆营"]
[null,"系统账号分页跳转","Y","侯庆营",100,"/sba/system/user/querypageby",null,"SYSTEM_USER_QUERYPAGEBY"]
["系统角色管理","添加系统角色","Y","侯庆营",100,"/sba/system/role/add","ROLE_ADMIN_SYSTEM_ROLE","SYSTEM_ROLE_ADD"]
[null,"删除系统角色","Y","侯庆营",100,"/sba/system/role/delete",null,"SYSTEM_ROLE_DELETE"]
[null,"查询系统角色","Y","侯庆营",100,"/sba/system/role/querypageby",null,"SYSTEM_ROLE_QUERYPAGEBY"]
[null,"修改角色",null,"侯庆营"]
[null,"角色授权查询","Y","侯庆营",100,"/sba/system/role/queryprivilegelist",null,"SYSTEM_ROLE_QUERYPRIVILEGELIST"]
[null,"修改角色授权提交","Y","侯庆营",100,"/sba/system/role/grantprivilege",null,"SYSTEM_ROLE_GRANTPRIVILEGE"]
[null,"禁用角色",null,"侯庆营"]
[null,"系统角色分页跳转","Y","侯庆营",100,"/sba/system/role/querypageby",null,"SYSTEM_ROLE_QUERYPAGEBY"]
["系统权限管理","添加系统权限","Y","侯庆营",100,"/sba/system/privilege/add","ROLE_ADMIN_SYSTEM_PRIVILEGE","SYSTEM_PRIVILEGE_ADD"]
[null,"删除系统权限","Y","侯庆营",100,"/sba/system/privilege/delete",null,"SYSTEM_PRIVILEGE_DELETE"]
[null,"查询系统权限","Y","侯庆营",100,"/sba/system/privilege/querypageby",null,"SYSTEM_PRIVILEGE_QUERYPAGEBY"]
[null,"修改权限",null,"侯庆营"]
[null,"禁用权限",null,"侯庆营"]
[null,"系统权限分页跳转","Y","侯庆营",100,"/sba/system/privilege/querypageby",null,"SYSTEM_PRIVILEGE_QUERYPAGEBY"]

{"sheet":"技术列表","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["技术项目","完成人员","进度(%)","备注"]
["Maven改造","侯庆营",100]
["Spring security安全登录","侯庆营",100]
["系统管理员及角色","侯庆营",100]
["系统菜单权限","侯庆营",100]
["图片服务分离","侯庆营",100,"分离出图片上传和返回链接功能，封装成独立服务分开部署和存储图片"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}