模板介绍

模板说明

本模板把容联七陌坐席工作量报表拉取到本地MySQL数据库中

流程图

依赖组件

1.需要下载容联七陌分类的拉取坐席工作量报表组件。
2.需要创建相应的表结构或者用库表输出组件自动建表。

依赖表结构

CREATE TABLE `qimoor_agent_response_report`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `replyCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '回复消息数',
  `sessionAccessCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '接入会话数',
  `responseTotalCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '响应会话数',
  `sessionRolllnCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转入会话数',
  `sessionRollOutCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '转出会话数',
  `sessionAverageTimeLength` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '平均会话时长',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

使用评价