{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["集拼业务管理系统-功能清单","验证环境"],"not_rendered":{"charts":0,"images":2,"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":83,"n_cols":8,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,1,1,6],[4,1,7,1],[8,1,9,1],[10,1,26,1],[27,1,34,1],[35,1,43,1],[44,1,48,1],[49,1,56,1],[57,1,63,1],[64,1,82,1],[5,2,7,2],[8,2,9,2],[10,2,13,2],[14,2,17,2],[20,2,26,2],[27,2,28,2],[29,2,30,2],[35,2,37,2],[39,2,42,2],[50,2,52,2],[54,2,56,2],[57,2,58,2],[62,2,63,2],[64,2,75,2],[76,2,78,2],[79,2,82,2]]}
[]
[null,"集拼业务管理系统"]
[null,"一级模块","二级模块","功能点","功能具体描述","验证结果","备注"]
[null,"用户登录","登录认证","/","管理用户帐号密码登录","功能正常"]
[null,"后台首页","消息提醒","/","右上角显示当前登录账号未读的消息数，点击打开未读消息列表","功能正常"]
[null,null,"数据概览","作业中的集拼单","查看未完结的集拼单","功能正常"]
[null,null,null,"待处理的预警","查看未处理的预警","功能正常"]
[null,null,null,"最近15天集拼单","图表显示最近15天的集拼单","功能正常"]
[null,"理货管理","理货数据查询","条件查询","按订单号、航次号、出入库标识、货主名称等条件查询从辅助系统同步过来的理货数据","功能正常"]
[null,null,null,"理货信息详情","查看理货信息详情","功能正常"]
[null," 集拼管理","集拼订单分布","按状态分布显示订单","按“装箱计划、到货通知、运抵、准装、核放”显示各环节的未完结集拼单","功能正常"]
[null,null,null,"集拼单详情","查看集拼单详情及处理进程","功能正常"]
[null,null,null,"重新发起AI分析","在“到货通知”环节，可以在前端人为发起AI分析","功能正常"]
[null,null,null,"异常处理","在“到货通知”环节，可以在前端人为控制机械臂、人为反馈空箱和围网分析结果","功能正常"]
[null,null,"集拼订单查询","按条件查询订单","按“装箱计划、到货通知、运抵、准装、核放”显示各环节的未完结集拼单","功能正常"]
[null,null,null,"集拼单详情","查看集拼单详情及处理进程","功能正常"]
[null,null,null,"重新发起AI分析","在“到货通知”环节，可以在前端人为发起AI分析","功能正常"]
[null,null,null,"异常处理","在“到货通知”环节，可以在前端人为控制机械臂、人为反馈空箱和围网分析结果","功能正常"]
[null,null,"集拼核放单","按条件查询","按条件查询辅助系统推送的核放单数据","功能正常"]
[null,null,"集拼过卡记录","按条件查询","按条件查询辅助系统推送的过卡记录","功能正常"]
[null,null,"异常报警","设备异常报警","后台定期扫描设备服务接口的可用状态，如发现异常则生成报警信息并消息提醒","功能正常"]
[null,null,null,"应用接口异常报警","后台定期扫描应用接口的可用状态，如发现异常则生成报警信息并消息提醒","功能正常"]
[null,null,null,"AI分析异常报警","收到AI分析异常反馈时触发报警并消息提醒","功能正常"]
[null,null,null,"入库车辆异常报警","入库车辆的车牌与到货通知的车牌不相符时触发报警并消息提醒","功能正常"]
[null,null,null,"去卡口超时异常报警","收到华东辅助系统接口反馈的超时信息时触发报警并消息提醒","功能正常"]
[null,null,null,"报警记录查询","按“设备异常、接口异常、AI分析异常、入库车辆异常、去卡口超时异常”分类列出未处理的预警记录","功能正常"]
[null,null,null,"报警记录处理","更新报警的处理结果","功能正常"]
[null,"AI分析相关","车辆入库识别","车牌识别","对接号牌识别接口，识别进入车位车辆的车牌","功能正常"]
[null,null,null,"出入库事件","对接车辆出入库事件通知接口，根据业务流程处理车辆的进出事件","功能正常"]
[null,null,"A阶段AI分析","围网密闭分析","   收到到货通知且车辆已到达车位，发起A阶段AI分析，获取库位相机抓拍图片，调用AI系统接口进行 围网分析，分析结果反馈给华东辅助系统。","功能正常"]
[null,null,null,"空箱分析","   收到华东的到货通知且车辆已到达车位，发起A阶段AI分析，获取车位相机抓拍图片，调用AI系统接口进行 空箱分析，分析结果反馈给华东辅助系统。","功能正常"]
[null,null,"B阶段AI分析","空箱分析","   收到华东的准装通知时发起B阶段AI分析，获取车位相机抓拍图片，调用AI系统接口进行 空箱分析，分析结果反馈给华东辅助系统。","功能正常"]
[null,null,"抓拍分析记录","按条件查询","按条件查询抓拍分析记录、分析结果","功能正常"]
[null,null,"分析结果确认","批量确认分析结果","人为确认AI分析结果","功能正常"]
[null,null,"AI分析统计","围网分析统计\n空箱分析统计","基于AI分析记录和人工确认结果统计Ai分析次数、准确率等","功能正常"]
[null,"基础数据管理","监控设备管理","增、删、改、查、导出","监控设备基本信息维护、查询及导出","功能正常"]
[null,null,null,"安装区域绑定、解绑","设备安装区域的绑定与解绑","功能正常"]
[null,null,null,"设备启停","设备启用、停用","功能正常"]
[null,null,"监控区域管理","增、删、改、查、导出","监控区域基本信息维护、查询及导出","功能正常"]
[null,null,"接入应用管理","增、删、改、查、导出","应用基本信息维护、查询及导出","功能正常"]
[null,null,null,"生成RSA密钥对","生成RSA密钥对","功能正常"]
[null,null,null,"RSA公钥密钥下载","下载已生成的RSA公钥、秘钥","功能正常"]
[null,null,null,"接口可用状态检测","定时检测接口可用状态并更新","功能正常"]
[null,null,"接入企业管理","增、删、改、查、导出","企业基本信息维护、查询及导出","功能正常"]
[null,"仓库管理","仓库设置","增、删、改、查、导出","仓库基本信息维护、查询及导出","功能正常"]
[null,null,"库区管理","增、删、改、查、导出","库区基本信息维护、查询及导出","功能正常"]
[null,null,"库位管理","增、删、改、查、导出","库位基本信息维护、查询及导出","功能正常"]
[null,null,"货架管理","增、删、改、查、导出","货架基本信息维护、查询及导出","功能正常"]
[null,null,"托盘管理","增、删、改、查、导出","托盘基本信息维护、查询及导出","功能正常"]
[null,"权限管理","部门管理","部门增删改查","可对部门信息进行增删改查操作","功能正常"]
[null,null,"角色管理","角色增删改查","可对角色信息进行增删改查操作","功能正常"]
[null,null,null,"分配角色权限","可以绑定角色的菜单权限","功能正常"]
[null,null,null,"关联角色用户","可以分配角色用户","功能正常"]
[null,null,"菜单管理","菜单增删改查","菜单增删改查","功能正常"]
[null,null,"用户管理","用户增删改查","可对用户信息进行增删改查操作，绑定用户的单位、部门、角色等信息","功能正常"]
[null,null,null,"分配角色","给用户分配指定角色","功能正常"]
[null,null,null,"重置密码","重置密码","功能正常",null,{"$f":"2/23","v":0.0869565217391304}]
[null,"系统管理","消息提醒","未读消息","查看当前登录用户的未读信息","功能正常"]
[null,null,null,"已读消息","查看当前登录用户的已读信息","功能正常"]
[null,null,"消息提醒设置","提醒设置","针对5类提醒信息，可设置是否要提醒以及提醒范围","功能正常"]
[null,null,"参数设置","参数配置","系统的基础参数配置管理功能","功能正常"]
[null,null,"字典管理","字典配置","配置字典名称、字典数据","功能正常"]
[null,null,"系统运维","操作日志","查看用户的业务操作日志","功能正常"]
[null,null,null,"登录日志","查看用户的登录日志","功能正常"]
[null,"数据交互模块","华东辅助系统对接","接口鉴权认证接口","根据预先分配的用户名和密码，加签名串Key，获取动态授权口令token","功能正常"]
[null,null,null,"理货信息同步接口","企业理货完成后，辅助系统将货物出入库信息同步给集拼业务系统","功能正常"]
[null,null,null,"装货计划接口","企业装货计划信息申报后，辅助系统将装货计划信息同步给集拼业务系统","功能正常"]
[null,null,null,"到货通知接口","企业完成舱单确报申报后，辅助系统将车辆确报信息同步给集拼业务系统","功能正常"]
[null,null,null,"AI识别结果发送(A阶段)","收到到货通知且车辆到达指定车位，集拼系统将对应围网是否闭合、是否空箱的AI分析结果反馈给辅助系统。","功能正常"]
[null,null,null,"运抵结果通知接口","辅助系统将车牌号码、舱单号码、运抵结果、运抵时间、验放回执信息同步给集拼业务系统","功能正常"]
[null,null,null,"AI识别结果发送(B阶段)","收到准装通知，集拼系统发起空箱AI分析，并将分析结果反馈给辅助系统。","功能正常"]
[null,null,null,"准装信息通知接口","辅助系统将准装信息同步给集拼业务系统","功能正常"]
[null,null,null,"集拼核放单接口","辅助系统将集拼核放单信息同步给集拼业务系统","功能正常"]
[null,null,null,"过卡记录接口","辅助系统将过卡记录信息同步给集拼业务系统","功能正常"]
[null,null,null,"车辆离开仓库通知接口","车辆离开仓库时通知到辅助系统","功能正常"]
[null,null,null,"从仓库去卡口预警接口","辅助系统计算车辆从仓库去卡口的时间，如果超过时间阈值则向集拼系统同步预警信息","功能正常"]
[null,null,"AI分析系统对接","发起围网密闭分析","调用AI系统接口，发起围网是否密闭、是否有货的分析","功能正常"]
[null,null,null,"发起空箱分析","调用AI系统接口，发起是否空箱的分析","功能正常"]
[null,null,null,"AI分析结果反馈接口","AI系统将分析结果反馈集拼业务系统","功能正常"]
[null,null,"硬件服务接口对接","车牌识别通知接口","车辆驶入月台触发车牌识别，集拼系统接收号牌识别事件，记录车牌与车位关系","功能正常"]
[null,null,null,"车辆进出月台通知接口","车辆进出月台触发进出通知事件，集拼系统接收进出通知事件，更新车位状态","功能正常"]
[null,null,null,"机械臂升降控制接口","收到到货通知，若车位停有车辆且车位有机械臂，通知机械臂下降到位再发起拍照","功能正常"]
[null,null,null,"相机图片抓拍接口","集拼系统对指定的库位或车位相机发起拍照指令，获取抓拍图片","功能正常"]

{"sheet":"验证环境","index":1,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"序号","系统名称","系统地址","帐密信息","备注"]
[null,1,"集拼业务管理系统","http://179.188.5.20:8080/","admin/admin123"]