{"text_format":"2","workbook":"xlsx","n_sheets":1,"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":65,"n_cols":7,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,2,0],[1,1,2,1],[3,1,32,1],[33,1,59,1],[1,2,2,2],[3,2,4,2],[5,2,8,2],[9,2,10,2],[11,2,29,2],[31,2,32,2],[33,2,41,2],[42,2,49,2],[51,2,56,2],[57,2,58,2],[1,3,2,3],[3,3,4,3],[5,3,8,3],[9,3,10,3],[11,3,15,3],[16,3,29,3],[31,3,32,3],[33,3,41,3],[44,3,45,3],[48,3,49,3],[51,3,56,3],[57,3,58,3],[1,4,2,4],[24,4,25,4],[28,4,29,4],[35,4,36,4],[38,4,39,4],[40,4,41,4],[54,4,55,4],[57,4,58,4],[1,5,2,5],[1,6,2,6]]}
["需求列表"]
["编号","终端","模块","子模块","功能","功能描述","备注"]
[]
[{"$f":"ROW()-3","v":1},"访客系统-管理端","访客管理","访客管理","访客详情","访客信息增加<身份证号>字段"]
[2,null,null,null,"访客列表","访客列表字段优化，“操作”栏中的“查看”内容过于单一，需丰富，至少加入“邀请人”字段"]
[3,null,"邀访管理","邀访流程","访客表单","新增“联系人”角色(主访客)"]
[4,null,null,null,"邀访审核","邀请人进行审核功能"]
[5,null,null,null,"邀访列表","增加筛选项“邀请人”，“部门”"]
[6,null,null,null,"消息推送","公众号通知功能"]
[7,null,"通行管理","通行管理","实时刷新","近1分钟内的通行数据加颜色背景，并定时5秒自动刷新"]
[8,null,null,null,"通行列表","外显字段重新定义"]
[9,null,"考勤管理","考勤计算","考勤定时任务","定时任务变更为凌晨4:10，统计周期为前一天凌晨四点至当日凌晨四点"]
[10,null,null,null,"考勤列表","跨日考勤显示(+1)"]
[11,null,null,null,"考勤计算规则","考勤逻辑优化\n1.进入和外出数据都存在，取第一条进入的数据和最后一条数据，如果最后一条是进入，则下班时间为第二天的03:59，如果最后一条是外出，则下班时间为外出时间\n2.如果有出入时间，进入时间小于上班时间且外出时间大于下班时间，算为正常数据；如果有进入时间，最后一条是进入数据，且进入时间小于上班时间，则算为正常数据\n3.如果出入时间为转天数据，则时间后加(+1)\n4.如果全是外出数据（或只有一条外出），只有下班时间，没有上班时间，算为异常数据\n5.如果全是进入数据（或只有一条进入），只有上班时间，下班时间无，算为异常数据\n6.班次设置：增加班次管理，满足制造中心考勤多班次考勤要求，按照自定义班次和排班信息对考勤进行统计\n7.排班设置：支持导入、导出、编辑的方式对制造中心人员周、月班次进行设置\n8.定时任务：系统根据每日各班次时间对相应班次人员定时进行考勤统计数据操作       "]
[12,null,null,null,"通行数据","中控【万傲瑞达】对接"]
[13,null,null,null,"考勤计算","【万傲瑞达】考勤计算，导出"]
[14,null,null,"致远OA对接","组织结构信息","同步组织结构信息"]
[15,null,null,null,"人员信息","同步人员信息"]
[16,null,null,null,"请假单据","同步请假单据，判断假期类型【病假，年假，事假】"]
[17,null,null,null,"公出单据","同步公出单据信息"]
[18,null,null,null,"出差单据","同步出差单据信息"]
[{"$nulls":4},"销假"]
[{"$nulls":4},"加班单据","同步制造中心加班申请单，记录至人员调休假中"]
[21,null,null,null,"年假信息","同步人员年假信息"]
[22,null,null,null,"考勤单据整合","根据请假，公出，出差单据，反填考勤信息，将“异常”根据实际情况转为“迟到/早退/请假/公出”等"]
[23,{"$nulls":4},"根据通行数据，单据信息，自动识别销假"]
[24,null,null,null,"节假日管理","节假日手动维护（按年维护，一年维护一次）"]
[25,null,null,null,"假期损耗统计","自动扣除年假并显示剩余假期数"]
[26,null,null,null,"考勤自动统计","定时推送、维护推送指定人邮箱，可在每月1日或2日，将上月考勤报表自动推送至考勤专员处（邮箱或其他方式）"]
[27,{"$nulls":4},"支持导出出勤信息统计表，将一个月内，迟到/早退/请假/公出时间，出勤时间分别加总，由另一张表导出"]
[28,null,"系统管理","员工管理","员工列表","目前显示顺序由“权重”字段决定，操作仍相对不友好，可新增“拖拽”调节部门内的“显示顺序”。或者使用“+”和“-”按钮调节部门顺序及部门内员工顺序"]
[29,null,"客餐管理","客餐管理","客餐列表","客餐列表展示"]
[30,null,null,null,"客餐统计","客餐图表统计"]
[31,"访客系统-小程序端","邀访管理","邀访管理","访客表单","新增“联系人”角色(主访客)"]
[32,null,null,null,"邀访记录/受邀记录  查询","详情页增加状态位进度条"]
[33,null,null,null,"受邀记录/访客邀请","新增访客二维码回显"]
[34,{"$nulls":4},"新增<机构/单位>字段，必填\n新增<车牌号>字段回显"]
[35,null,null,null,"小程序回显","访客端，可在小程序home通过点击“访问安排”和“受邀记录”可直接转至访问事项详情页，展示二维码"]
[36,null,null,null,"历史记录模糊查询","记录每个员工邀请过的访客，输入访客姓名支持模糊查询"]
[37,{"$nulls":4},"填写完访客姓名支持手机号自动回填"]
[38,null,null,null,"安保模块","创建安保角色，并支持小程序判断角色并登录专属页面"]
[39,{"$nulls":4},"二维码识别、显示访客信息"]
[40,null,"考勤管理","考勤查询","考勤查询","全部考勤信息的查询、逻辑判定、异常情况申诉"]
[41,null,null,"考勤统计","考勤统计","对全部真实的考勤信息进行分项、分月统计"]
[42,null,null,"请假单据","请假单创建","需根据角色判断请对应请假指定的表单内容，字段固定"]
[{"$nulls":4},"假期余量判定","在员工填写请假时长时，根据相应假期余量，提示剩余数量，填写超过余量，无法提交表单（小程序限定，oa无法做到）"]
[44,null,null,"公出单据","公出单创建","需根据角色判断请对应公出指定的表单内容，字段固定"]
[45,null,null,"出差单据","出差单创建","需根据角色判断请对应出差指定的表单内容，字段固定"]
[46,null,null,"流程监控","审批流程监控","定时同步致远，当前审批节点状态"]
[47,null,null,null,"审批结果监控","定时同步致远，审批结果，并根据考勤逻辑与审批结果核算考勤"]
[48,null,"访客申请","访客申请","访客申请","访客流程定义，表单定义，状态定义"]
[49,null,"客餐管理","客餐管理","客餐统一入口","客餐统一入口"]
[50,null,null,null,"客餐表单创建","表单创建，表单完成后生成与纸质票据对应取餐号"]
[51,null,null,null,"打印机对接","打印机打印小票"]
[52,null,null,null,"食堂模块","创建食堂角色，并支持小程序判断角色并登录特有功能页面"]
[53,{"$nulls":4},"客餐查询，校验"]
[54,null,null,null,"访客记录关联","关联访客信息"]
[55,null,"个人信息","车牌管理","员工车牌管理","支持员工车牌号维护(多张)，添加第二张及以上车牌时需备注原由\n"]
[56,{"$nulls":4},"后勤保障部(定义角色)审批"]
[57,null,"消息推送","消息推送","服务号、短信消息跳转","1.邀请人：通过服务号消息推送或短信跳转小程序对应详情页\n2.访客：通过服务号消息推送或短信跳转小程序对应详情页"]
[{"$nulls":6},"分项合计工时（单位：人日）"]
[]
[]
[]
[{"$nulls":4}," "]