{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["功能模块","迭代内容","开发进度"]
["访客系统","访客信息增加<身份证号>字段","已完成"]
["访客系统","员工邀请访客流程优化，新增“联系人”角色(主访客)","已完成"]
["访客系统","员工邀请访客流程优化，新增邀请人审核功能","已完成"]
["访客系统","消息推送除站内消息外，新增公众号通知功能","开发中"]
["访客系统","访客<身份证号>字段设置为非必填项","已完成"]
["访客系统","“联系人”补全访问信息点击提交时弹窗提示“若您有其他同行人员，可点击右上角三个点，向其分享填写”","已完成"]
["访客系统","“联系人”点击提交审核时弹窗提示“请确认所有访问人员已填写完成”","已完成"]
["访客系统","员工提交邀请信息时弹窗提示“请关注现代党建公众号以获取访问事项的最新动态”","已完成"]
["考勤系统","考勤逻辑优化，定时任务变更为凌晨4:10，统计周期为前一天凌晨四点至当日凌晨四点","已完成"]
["考勤系统","考勤逻辑优化，跨日考勤显示(+1)","已完成"]
["考勤系统","考勤逻辑优化\n1.进入和外出数据都存在，取第一条进入的数据和最后一条数据，如果最后一条是进入，则下班时间为第二天的03:59，如果最后一条是外出，则下班时间为外出时间\n2.如果有出入时间，进入时间小于上班时间且外出时间大于下班时间，算为正常数据；如果有进入时间，最后一条是进入数据，且进入时间小于上班时间，则算为正常数据\n3.如果出入时间为转天数据，则时间后加(+1)\n4.如果全是外出数据（或只有一条外出），只有下班时间，没有上班时间，算为异常数据\n5.如果全是进入数据（或只有一条进入），只有上班时间，下班时间无，算为异常数据","已完成"]
["考勤系统","部门管理数据展示方式由列表样式优化为树形结构样式","开发中"]
["考勤系统","考勤月统计数据导出时将单个员工当月所有数据集合显示，且按照日期正序排列","已完成"]
["考勤系统","增加员工权重值维护，考勤数据查询及导出按照员工权重值排序","已完成"]
["考勤系统","增加<在岗时长>字段，用下班时间减上班时间，如当日出现缺卡的情况，在岗时长记为0","开发中"]
["考勤系统","对接ZKT门禁设备，同步人员数据与权限","待开发"]
["考勤系统","对接ZKT门禁设备，同步通行数据，生成考勤数据","待开发"]
["考勤系统","对接海康威视门禁设备，同步人员数据与权限","待开发"]
["考勤系统","在考勤查询和导出的时候，<考勤日期>后加一个字段显示<星期>","开发中"]