{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["视频稽查","英飞拓"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":1,"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":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
["序号","提出人","问题类型","问题描述","解决方案或进度","提出时间","状态","预期解决时间","实际解决时间","备注","负责人","优先级"]
[1,"稽查办","班次管理","生成的晚班值班时间没有跨天，实际上是跨天的",null,"2017-06-12","已验证"]
[2,"稽查办","稽查","弹出框遮挡程序界面",null,"2017-06-12","已验证"]
[3,"稽查办","任务详情","已稽查任务详情，去掉修改和删除按钮",null,"2017-06-12","已验证"]
[4,"稽查办","稽查","稽查人员头像点击客户端会有模态窗口",null,"2017-06-12","已验证"]
[5,"稽查办","稽查"," 稽查界面截图点击查看弹窗",null,"2017-06-12","已验证"]
[6,"稽查办","稽查"," 稽查界面头像点击查看 有弹窗",null,"2017-06-12","已验证"]
[7,"稽查办","稽查","工号显示后3位",null,"2017-06-12","已验证"]
[8,"稽查办","视频","丁堰收费站入口1 车道 广场  均显示的视屏是入口广场的  \n如皋收费站值机室 显示通道15的广场视\n兴桥收费站值机室 显示出口广场视屏",null,"2017-06-12","已验证"]
[9,"稽查办","视频","进度条的tip去除",null,"2017-06-12","已验证"]
[10,"稽查办","视频","视屏无法切换",null,"2017-06-12","已验证"]
[11,"稽查办","无效任务","已提交无效任务详情查看弹窗 未清空",null,"2017-06-12","已验证"]
[12,"稽查办","无效任务","无效任务按时间搜索不正确",null,"2017-06-12","已验证"]
[13,"自查","无效任务","无效任务确认后，需从user_count表删除",null,"2017-06-12","已验证",null,"2017-06-20",null,null,"高"]
[14,"自查","视频","标清录像截得图像分辨率太小","标清设备是大华的，分辨率本身就小","2017-06-12","挂起",{"$nulls":4},"中"]
[15,"稽查办","申诉","申诉页面布局调整",null,"2017-06-12","已验证"]
[16,"稽查办","申诉","申诉稽查取消扣分要说明",null,"2017-06-12","已验证",{"$nulls":4},"高"]
[17,"稽查办","登录/退出","客户端退出要加提示是否退出",null,"2017-06-12","已验证"]
[18,"自查","申诉","申诉弹出框可伸缩",null,"2017-06-12","已验证",{"$nulls":4},"低"]
[19,"稽查办","任务下发","任务下发4天确认，超出默认确认",null,"2017-06-12","已验证",null,"2017-06-15"]
[20,"稽查办","任务下发","申诉任务下发2天确认，超出默认确认",null,"2017-06-12","已验证",null,"2017-06-15"]
[21,"稽查办","所有","添加返回按钮，面包屑导航",null,"2017-06-12","已验证",null,"2017-06-15",null,null,"高"]
[22,"稽查办","我的任务","待提交任务从稽查管理员界面去掉",null,"2017-06-12","已验证"]
[23,"稽查办","我的任务","待发送任务名称改为待下发收费站任务",null,"2017-06-12","已验证"]
[24,"稽查办","无效任务","无效任务审核需稽查管理员查看该录像",null,"2017-06-12","已验证",null,"2017-06-14",null,null,"高"]
[25,"稽查办","任务列表","管理员界面可查看稽查人列",null,"2017-06-12","已验证",null,"2017-06-16"]
[26,"稽查办","稽查","评分可添加没备注，分数能修改",null,"2017-06-12","已验证",null,"2017-06-19",null,null,"高"]
[27,"稽查办","任务生成","根据排班人员来分配任务",null,"2017-06-12","已验证"]
[28,"自查","无效任务","无效任务原因可选择或手动输入",null,"2017-06-12","已验证",{"$nulls":4},"中"]
[29,"自查","任务生成","任务周期为26号到下个月25号",null,"2017-06-12","已验证",{"$nulls":4},"高"]
[30,"自查","任务生成","check_user_count表添加task_id，方便无效任务删除该记录",null,"2017-06-12","已验证",null,"2017-06-19",null,null,"高"]
[31,"稽查办","稽查","任务点击预览提交，才更新为待提交任务",null,"2017-06-12","已验证",null,"2017-06-14"]
[32,"稽查办","稽查","考核项修改时图片不显示",null,"2017-06-12","已验证",null,"2017-06-13",null,null,"高"]
[33,"稽查办","稽查","一个任务可能会有多个考核人，扣分可选择人（人后面显示本周期已考核次数）","显示考核次数还没加","2017-06-12","已验证",null,"2017-06-20",null,null,"高"]
[34,"自查","班次管理","team_class表中user_ids现在为空",null,"2017-06-12","已验证",null,"2017-06-14",null,null,"高"]
[35,"稽查办","统计分析","收费站人员查看自己本站和全站排名\n收费站管理员查看本站所有人排名\n稽查管理员查看所有人排名",null,"2017-06-13","已验证",null,null,"统计分析页面查看",null,"高"]
[36,"稽查办","稽查","快进和慢放的倍数显示",null,"2017-06-13","已验证",null,"2017-06-15",null,null,"高"]
[37,"稽查办","已稽查任务列表","已稽查任务需要显示该人稽查过的所有任务",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[38,"稽查办","稽查复核","管理员可复核稽查稽查员的结果，详情页面加复核按钮，不通过可再次稽查",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[39,"稽查办","任务下发","下发界面搜索添加有扣分和无扣分的下拉框选项",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[40,"稽查办","任务下发","下发添加复选框，一键下发只下发勾选的任务",null,"2017-06-13","已验证",null,"2017-06-15",null,null,"高"]
[41,"稽查办","无效任务","无效任务可批量同意，参照一键下发",null,"2017-06-13","已验证",null,"2017-06-15",null,null,"高"]
[42,"稽查办","统计分析","添加出勤率统计界面",null,"2017-06-13","已验证",null,null,"统计分析页面查看",null,"中"]
[43,"稽查办","稽查视频","值机室视频无法显示",null,"2017-06-13","已验证",null,"2017-06-13"]
[44,"稽查办","稽查视频","东台出口2车道视频和厅内视频弄反",null,"2017-06-13","已验证",null,"2017-06-13"]
[45,"稽查办","稽查视频","丁堰出口2亭内实际为出口4",null,"2017-06-13","已验证",null,"2017-06-13"]
[46,"稽查办","人员管理","开发区李友东照片损坏",null,"2017-06-13","已验证",{"$nulls":4},"中"]
[47,"稽查办","稽查视频","灌南东出口1厅内车道接反",null,"2017-06-13","已验证",null,"2017-06-13"]
[48,"稽查办","任务查询","待下发任务查询添加职位查询条件",null,"2017-06-13","已验证",{"$nulls":4},"高"]
[49,"稽查办","申诉","申诉任务分配后，只能被分配的稽查员可以看到",null,"2017-06-13","已验证",null,"2017-06-13"]
[50,"稽查办","稽查视频","进度条拖动卡顿",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[51,"稽查办","稽查视频","车道广场亭内和车道、广场播放进度保持一致",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[52,"稽查办","稽查视频","视频放大，按钮（播放、快进等）也同步显示在放大界面上",null,"2017-06-13","已验证",null,"2017-06-15",null,null,"高"]
[53,"稽查办","更换考查人员","选择收费站人员时，可查看头像大图",null,"2017-06-13","已验证",null,"2017-06-14",null,null,"高"]
[54,"稽查办","收费站","收费站确认以后稽查管理员可退回，由于收费站会误操作，本来应该申诉最后误点击了确认",null,"2017-06-14","已验证",null,"2017-06-15",null,null,"高"]
[55,"稽查办","任务查询","待下发任务时要可选择到考核人",null,"2017-06-14","已验证",{"$nulls":4},"高"]
[56,"自查","任务查询","添加待提交状态，与开始状态区分。因为现在无法区分考核开始和待提交状态",null,"2017-06-14","已验证",null,"2017-06-15"]
[57,"稽查办","收费站排班","做可查看所有收费站排班的页面，方便查看所有的排班",null,"2017-06-20","已验证",null,null,"统计分析页面查看"]
[58,"自查","任务生成","更换稽查人员的时候需要同步更新user_count表",null,"2017-06-20","已验证",null,"2017-06-20"]
[59,"稽查办","收费站排班","班组人员变化，会导致之前的排班的人员显示为空",null,"2017-06-20","已验证",null,"2017-06-20"]
[60,"稽查办","申诉列表","申诉列表添加筛选条件：申诉结果和申诉类别",null,"2017-06-20","已解决",null,null,null,"潘虎"]
[61,"稽查办","扣分项","扣分项修改选人选择整个收费站的人",null,"2017-06-20","已验证"]
[62,"稽查办","稽查页面","稽查页面人员信息旁边显示本周期已考核次数（稽查员提交之后的次数）",null,"2017-06-20","已验证"]
[63,"稽查办","稽查页面","更改人员的时候需要判断更换的人是否已被稽查过，如稽查过，则不能更换此人",null,"2017-06-20","已验证"]
[64,"稽查办","顶班管理","顶班的人选择收费站所有的人",null,"2017-06-20","已验证"]
[65,"自查","视频稽查","cs版稽查界面不显示稽查排班数据",null,"2017-06-20","挂起"]
[66,"自查","所有页面","后台隐藏稽查员信息，前台只有稽查管理员可以看",null,"2017-06-20","挂起"]
[67,"稽查办","我的任务和申诉管理下的页面","列表右下角显示总条数",null,"2017-06-21","已验证"]
[68,"稽查办","我的任务和申诉管理下的页面","导航条，点击上级后，要记住上级的查询条件，并直接显示上次的查询结果，不需要再次查询",null,"2017-06-21","已验证"]
[69,"稽查办","视频稽查","修改评分的考核人，选择考核人会错位（可能cs版有问题）",null,"2017-06-21","已验证"]
[70,"稽查办","视频稽查","点击修改评分图片，图片出不来",null,"2017-06-21","已验证"]
[71,"稽查办","视频稽查","扣分项的备注可勾选或手动输入（为了解决杨手礼有多种问题，但只扣一次分）",null,"2017-06-21","已验证"]
[72,"稽查办","统计分析","考核情况统计报表收费值机人数、 受检人数、受检次数添加合计功能，搜索条件加职位查询",null,"2017-06-23","已解决"]
[73,"稽查办","任务查询","在已稽查任务和收费站已确认任务2个里面都要添加扣分选项",null,"2017-06-23","已验证"]
[74,"稽查办","统计分析","考核问题统计报表扣分合计不对",null,"2017-06-23","已验证"]
[75,"稽查办","任务查询","所有查询任务的列表都要添加职位查询条件",null,"2017-06-23","已验证"]
[76,"自查","视频稽查","更换考核人要存日志表",null,"2017-06-27","已验证"]
[77,"稽查办","统计分析","报表统计可通过任务时间和任务生成时间进行统计，因为稽查员需要统计他们每周的工作量",null,"2017-06-28","已验证",null,null,"统计分析页面查看"]
[78,"稽查办","任务生成","任务一个人24小时内只能被稽查1次，并加上权重，已被稽查次数越少的人，下次被稽查的概率越高",null,"2017-06-28","已验证"]
[79,"稽查办","人员管理","增加收费站人员转站的功能",null,"2017-06-28","已验证"]
[80,"稽查办","任务列表","收费站待确认和已确认列表也要添加有无扣分项查询条件",null,"2017-06-28","已验证"]
[81,"稽查办","手动生成任务","手动补班功能，提供补班按钮，弹出班次列表界面，选择班次后生成任务",null,"2017-06-28","已解决"]
[82,"稽查办","收费站排班","收费站排班页面可显示全部机动排班",null,"2017-06-30","已验证"]
[83,"稽查办","视频稽查","点击考核次数显示考核明细",null,"2017-06-30","已验证"]
[84,"稽查办","任务生成","任务生成排除已置为无效任务的班次",null,"2017-06-30","已解决"]
[85,"稽查办","申诉","申诉添加成功与失败确认",null,"2017-07-05","已解决"]
[86,"稽查办","无效任务","无效任务拒绝后可重新稽查",null,"2017-07-13","已解决"]
[87,"自查","统计分析","统计分析统计时间修改为每日23：00到23:00",null,"2017-07-13","已解决",null,null,"3个表格已修改"]
[88,"稽查办","申诉稽查","申诉稽查保存备注之后，任务会跳到待稽查任务界面",null,"2017-07-13","已解决"]
[89,"稽查办","统计分析","统计分析中柱状图，按照同分同名次来修改，现在是同分不同名次",null,"2017-07-13","已解决"]
[90,"稽查办","申诉稽查","稽查管理员也可以退回误提交的申诉任务",null,"2017-07-13","已解决"]
[91,"稽查办","申诉稽查","直接提交加上成功或失败，弹出框被视频挡住",null,"2017-07-13","已解决"]
[92,"稽查办","统计分析","员工排名统计报表加上道管中心查询选项",null,"2017-07-13","已解决"]
[93,"稽查办","统计分析","公司全体收费站加排名",null,"2017-07-13","已解决"]
[94,"稽查办","统计分析","饼图除了百分比之外，还要加上具体数值",null,"2017-07-13","已解决"]
[95,"稽查办","统计分析","员工排名统计报表中的稽查人数和考核问题统计报表中不一致",null,"2017-07-13","已解决"]
[96,"稽查办","统计分析","公司统计、道管中心统计、收费站统计的各个问题类别的人均扣分情况都只有一个类别显示",null,"2017-07-13","已解决"]
[97,"稽查办","统计分析","cs端正常出勤明细统计表显示有问题，不能显示上班情况",null,"2017-07-13","挂起"]
[98,"稽查办","稽查","稽查页面中已稽查次数加上扣分选项",null,"2017-07-13","已解决"]
[99,"稽查办","稽查","无效任务原因标签控件第一次可以，第二次会失败",null,"2017-07-13","已解决"]
[100,"稽查办","排班","今天不能修改昨天的排班，不然有可能造成任务生成出问题，导致找不到之前排班",null,"2017-07-13","已解决"]
[101,"稽查办","稽查","更改考核人需把之前考核人的扣分加到更换的考核人身上",null,"2017-07-17","已解决"]
[102,"稽查办","统计分析","稽查员工作量统计按照稽查结束时间为准",null,"2017-07-17","已解决"]
[103,"稽查办","统计分析","班长计分统计算法要修改成：\n（班长扣分+班组成员扣分）/（班长稽查次数+班组成员稽查次数）",null,"2017-07-17","已解决"]
[104,"稽查办","手工补任务","补任务的时间限制15分钟要修改成xx分钟",null,"2017-07-17","已解决"]
[105,"稽查办","排班","临时开道的排班录入，正常当班选择“临时开道”，然后就可以录入顶班信息",null,"2017-07-17","已解决"]
[106,null,"稽查","进度条上加时间",null,"2017-07-21","已解决"]
[107,null,"统计分析","统计分析的表头固定",null,"2017-07-21","已解决",null,null,null,"潘虎"]
[108,null,"图片预览","图片预览插件的按钮位置和图片位置差距太大",null,"2017-07-21","未解决"]
[109,null,"统计分析","员工排名排序，先扣分，后次数（倒序）",null,"2017-07-21","已解决"]
[110,null,"统计分析","收费员界面权限修改",null,"2017-07-21","已解决"]
[111,null,"排班管理","收费站排班界面修改",null,"2017-07-21","未解决",null,null,null,"温红权"]
[112,null,"人员管理","稽查管理员可查看所有人员",null,"2017-07-21","已解决"]
[113,null,"统计分析","扣分项根据收费站确认后的结果来计算，不确认不计算在内",null,"2017-07-21","挂起"]
[114,null,"统计分析","稽查人员工作量统计加部门和人员，结果表格加考核完成时间列",null,"2017-07-27","已解决"]
[115,null,"统计分析","个人工作量统计加任务详情页面",null,"2017-07-27","已解决"]
[116,null,"统计分析","员工排名统计不需要加权限限制",null,"2017-07-27","已解决"]
[117,null,"待收费站确认任务","收费站确认任务加一键确认",null,"2017-07-27","已解决"]
[118,null,"统计分析","个人统计 添加班长扣分",null,"2017-07-28","已解决"]
[119,null,"统计分析","稽查管理员控制收费站是否显示受检次数",null,"2017-07-28","已解决"]
[120,null,"统计分析"," 机动人员顶岗明细中，被稽查的班次与补任务中的被稽查班次不一致",null,"2017-07-28","已解决",null,null,null,"温红权"]
[121,null,"统计分析","员工排名统计表，按公司查、按道管查、按收费站查同一个人的排名都不一样",null,"2017-07-28","已解决",null,null,null,"温红权"]
[122,null,"统计分析","考核扣分统计与公司扣分情况占比不一致",null,"2017-07-28","已解决"]
[123,null,"统计分析","考核扣分情况占比图：鼠标放上去增加显示各个部门的人数\n公司统计，显示各个道管的人数\n道管统计，显示各个收费站的人数\n",null,"2017-07-28","已解决"]
[124,null,"统计分析","考核问题分布报表最后一行增加合计显示",null,"2017-07-28","已解决"]
[125,null,"统计分析","考核进步top5排行 查询调教选择不同月份，进步、退步排名不变；且进步、退步的名次不对",null,"2017-07-28","已解决",null,null,null,"温红权"]
[126,null,"统计分析","问题类别扣分图：柱子增加分节分颜色显示不同部门的扣分数，类似右图\n公司统计：部门即道管中心\n道管统计，部门即收费站",null,"2017-07-28","已解决",null,null,null,"温红权"]
[127,null,"统计分析","正常出勤明细出数据要13秒，机动出勤明细要25秒，太慢要优化",null,"2017-07-28","已解决",null,null,null,"潘虎"]
[128,null,"统计分析","申诉统计页面在数字上加上链接，可链接查看申诉任务详情",null,"2017-07-28","已解决"]
[129,null,"统计分析","申诉统计页面，点导出出错",null,"2017-07-28","已解决"]
[130,null,"统计分析","员工排名统计报表，没有根据查询结果导出，而是导出全部",null,"2017-07-28","已解决"]
[131,null,"排班","灌南东排班添加2个班长",null,"2017-08-03","已解决",null,null,null,"温红权"]
[132,null,"用户管理","用户管理 添加删除提示",null,"2017-08-03","已解决",null,null,null,"温红权"]
[133,null,"所有页面","我的任务列表添加返回记录当前页",null,"2017-08-03","已解决",null,null,null,"潘虎"]
[134,null,"统计分析","问题类别扣分图：柱子增加分节分颜色显示不同部门的扣分数，类似右图","建议不做修改","2017-08-03","已解决",null,null,null,"温红权"]
[135,null,null,"千分制统计，<=15分  换成平均分，不能用总分",null,null,"已解决"]
[136,null,"稽查任务列表","列表时间倒序",null,"2017-08-09","已解决"]
[137,null,"录像、图片","看录像、图片可以最大化（原图最大）",null,"2017-08-09","未解决"]
[138,null,"员工统计","受检次数（公司领导可以看跟稽查一样）",null,"2017-08-09","未解决"]
[139,null,"员工统计","员工排名对齐表头",null,"2017-08-09","未解决"]
[140,null,"统计分析","各个问题类别的扣分情况 去年与今年 表示体现不同",null,"2017-08-07","已解决"]
[141,null,"员工统计","员工统计饼图修改",null,"2017-08-07","未解决"]
[142,null,"用户管理 ","去除读写标记",null,"2017-08-07","未解决"]
[143,null,"用户管理","用户管理-修改用户窗口，职位显示数字啥意思？",null,"2017-08-10","未解决"]
[144,null,"任务详情","任务详情-流程图，效果调整优化，参考下面的图",null,"2017-08-10","未解决"]
[145,null,"用户管理","工号和手机号两列重叠了",null,"2017-08-10","未解决"]
[146,null,"稽查工作量统计","稽查任务数量数据不一致。\n6.26-7.25，稽查人员工作量统计，任务书是4280 已稽查任务，是3059\n员工排名统计，导出受检次数合计3106",null,"2017-08-10","未解决"]

{"sheet":"英飞拓","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["序号","提出人","问题类型","问题描述","解决方案","提出时间","状态","预期解决时间","实际解决时间","备注"]
[1,"稽查办","DVR视屏播放慢","DVR视屏类型播放加载慢 LMC速度快","反馈英飞拓","2017-06-12","已解决",null,null,null,"英飞拓"]
[2,"稽查办","注册ocx报错","注册ocx报错","反馈英飞拓","2017-06-12","正在解决",null,null,null,"英飞拓"]
[3,"稽查办","视屏按时下载","视屏按时下载级域NVR不能下载","英飞拓SDK修改","2017-06-12","已解决",null,null,null,"英飞拓"]
[4,"稽查办","搜索返回视屏段不正确","搜索返回视屏段不正确","录像上的时间跟存储的时间不一致，摄像机时间跟录像服务器时间未同步","2017-06-12","已解决",null,null,null,"英飞拓"]
[5,"稽查办","视屏无法播放","灌云北入口3 sdk无法访问 LMC能访问","又可以访问了、已提交英飞拓让其查原因","2017-06-13","已解决",null,null,null,"英飞拓"]
[6,"稽查办",null,"获取进度条失败",null,"2017-06-14","已解决"]
[7,"稽查办",null,"视屏快进INF_NET_PlayControlEx    本域DVR快进不了，NVR的没问题",null,"2017-06-22","已解决"]
[8,"稽查办",null,"DVR设置进度设置不了",null,"2017-06-22","已解决"]
[9,"稽查办",null,".值机室NVR视屏无法控制进度（控制的进度小于当前进度时）",null,"2017-06-22","已解决"]
[10,"稽查办",null,"DVR视屏按时下载无声音",null,"2017-06-22","已解决"]
[11,"稽查办",null,"NVR视屏按时下载文件下载进度一直为0，文件大小也为0",null,"2017-06-22","已解决"]
[12,"稽查办","视屏播放","DVR设备整点自动停止播放",null,"2017-06-23","已解决"]
[13,"自测","视屏按时下载","视屏格式转MP4",null,"2017-06-23","已解决"]