Sin descripción

zuoXiTable.html 7.6KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  6. <title>坐席工作报表</title>
  7. <script src="Script/Common/huayi.load.js"></script>
  8. <script src="Script/Common/huayi.config.js"></script>
  9. <link rel="stylesheet" href="js/select2/css/select2.min.css" />
  10. <link rel="stylesheet" href="./css/init.css" />
  11. <style>
  12. .clearfix:after {
  13. content: "";
  14. display: block;
  15. clear: both;
  16. }
  17. .zxt-top{
  18. background: #f3f3f4;
  19. height: 60px;
  20. padding: 10px 20px;
  21. }
  22. .topCon{
  23. float: right;
  24. margin-right: 45px;
  25. }
  26. .topCon select{
  27. padding: 2px;
  28. height: 28px;
  29. border: 1px solid #ebebeb;
  30. color: #1ab394;
  31. outline: none;
  32. vertical-align: middle;
  33. }
  34. .topCon input{
  35. width: 128px;
  36. padding: 2px 2PX 2PX 10PX;
  37. height: 28px;
  38. border: 1px solid #ebebeb;
  39. color: #1ab394;
  40. outline: none;
  41. vertical-align: middle;
  42. }
  43. .zxt-content{
  44. width: 95%;
  45. margin: 0 auto;
  46. }
  47. .zxt-table table{
  48. font-size: 12px;
  49. margin-top: 20px;
  50. }
  51. .zxt-table table thead tr td {
  52. background: #1ab394;
  53. color: #fff;
  54. }
  55. </style>
  56. </head>
  57. <body class="gray-bg" style="background: #fefefe;">
  58. <div class="zxtable">
  59. <div class="daoHang clearfix">
  60. <div class="dhLeft">
  61. <sapn><i class="syIcon"></i>位置:<a id="ReIndex" href="javaScript:;">首页</a>&gt;<a href="javaScript:;">报表分析</a>&gt;<a href="javaScript:;">员工考核分析</a>&gt;<a href="" style="color: #000;">坐席工作报表</a></sapn>
  62. </div>
  63. </div>
  64. <div class="zxt-top clearfix">
  65. <div class="topCon">
  66. 部门:<select name="" id="bumen">
  67. </select>
  68. 开始时间:
  69. <input type="text" class="laydate-icon" id="startTime"/>
  70. 结束时间:
  71. <input type="text" class="laydate-icon" id="endTime" />
  72. 月工作天数:
  73. <input type="text" id="dayss" style="width:50px;" />
  74. <button class="btns sear">搜索</button>
  75. <a class="btns export">导出</a>
  76. </div>
  77. </div>
  78. <div class="zxt-content">
  79. <div class="zxt-table">
  80. <table class="table table-bordered text-center thTable table-hover" style="width: 100%;">
  81. <thead>
  82. <tr>
  83. </tr>
  84. </thead>
  85. <tbody class="tbody">
  86. </tbody>
  87. </table>
  88. </div>
  89. </div>
  90. </div>
  91. <script src="./js/jquery.min.js?v=2.1.4"></script>
  92. <script src="./js/bootstrap.min.js?v=3.3.6"></script>
  93. <script src="./js/jquery.cookie.js"></script>
  94. <script src="./js/laydate/laydate.js"></script>
  95. <script src="./js/select2/js/select2.min.js"></script>
  96. <script>
  97. var token = $.cookie("token");
  98. var stime = helper.DateFormat.getNowDate(), //初始化当前年份
  99. endtime = stime //结束年份
  100. laydate.render({
  101. elem: '#startTime',
  102. calendar: true,
  103. theme: '#1ab394',
  104. value: stime,
  105. });
  106. laydate.render({
  107. elem: '#endTime',
  108. calendar: true,
  109. theme: '#1ab394',
  110. value: endtime,
  111. });
  112. var stime,//开始时间
  113. endtime,//结束时间
  114. dpt;//部门
  115. //部门下拉数据
  116. $("#bumen").select2({
  117. width: 'resolve' ,
  118. minimumResultsForSearch: -1,
  119. ajax:{
  120. type:"get",
  121. url:huayi.config.callcenter_url+"Department/GetDeptList",
  122. async:true,
  123. dataType: "json",
  124. data:function(params){
  125. return{
  126. token:token,
  127. pid:params.id
  128. }
  129. },
  130. processResults:function(data){
  131. return{
  132. results:data.data
  133. }
  134. },
  135. cache: true
  136. },
  137. placeholder: "请选择",
  138. });
  139. Ajax(stime, endtime);
  140. //搜索事件
  141. $(".sear").click(function(){
  142. $('.thTable tbody').html('');
  143. stime=$('#startTime').val();//开始时间
  144. endtime=$('#endTime').val();//结束时间
  145. dpt=$('#bumen').val(); //部门
  146. if(stime != '' && endtime != '') {
  147. Ajax(stime,endtime,dpt);
  148. }else{
  149. Ajax();
  150. if(stime==''){
  151. layer.confirm('请选择开始时间!', {
  152. btn: ['确定']
  153. });
  154. return;
  155. }else if(endtime ==''){
  156. layer.confirm('请选择结束时间!', {
  157. btn: ['确定']
  158. });
  159. return;
  160. }
  161. }
  162. });
  163. //导出
  164. $('.export').click(function() {
  165. stime=$('#startTime').val();//开始时间
  166. endtime=$('#endTime').val();//结束时间
  167. if(stime != '' && endtime != '') {
  168. dcexcel(this);
  169. }else{
  170. if(stime==''){
  171. layer.confirm('请选择开始时间!', {
  172. btn: ['确定']
  173. });
  174. return;
  175. }else if(endtime ==''){
  176. layer.confirm('请选择结束时间!', {
  177. btn: ['确定']
  178. });
  179. return;
  180. }
  181. }
  182. })
  183. function dcexcel(obj) {
  184. var url = huayi.config.callcenter_url + "ZuoXiWorkTotal/ExptList?token=" + $.cookie("token");
  185. url += "&stime=" + $("#startTime").val() + "&endtime=" + $("#endTime").val() + "&dpt=" + $("#bumen").val() + "&dayss=" + $("#dayss").val();
  186. obj.href = url;
  187. }
  188. //表头
  189. $.ajax({
  190. type:'get',
  191. url:huayi.config.callcenter_url+"ZuoXiWorkTotal/GetColumnList",
  192. async:true,
  193. dataType:'json',
  194. data:{
  195. token:token
  196. },
  197. success:function(res){
  198. var con=res.data;
  199. // console.log(con);
  200. for(var i=0;i<con.length;i++){
  201. $('<td>' + con[i]+ '</td>').appendTo('.thTable thead tr')
  202. }
  203. }
  204. })
  205. //表内数据
  206. function Ajax(stime, endtime, dpt, dayss) {
  207. $.ajax({
  208. type:"get",
  209. url:huayi.config.callcenter_url+"ZuoXiWorkTotal/GetDataList",
  210. async:true,
  211. dataType:'json',
  212. data:{
  213. stime:stime,
  214. endtime: endtime,
  215. dpt: dpt,
  216. dayss: dayss,
  217. token:token
  218. },
  219. success:function(res){
  220. var result=res.data;
  221. $('.thTable tbody').html('');
  222. for(var i = 0; i < result.length; i++) {
  223. $('<tr><td>' + result[i].部门 + '</td><td>' + result[i].坐席 + '</td><td>' + result[i].坐席工号 + '</td><td>' + result[i].呼入电话数 + '</td><td>' + result[i].坐席接通量 + '</td><td>' + result[i].呼损量 + '</td><td>' + result[i].接通率 + '</td><td>' + result[i].呼损率 + '</td><td>' + result[i].平均排队时间 + '</td><td>' + result[i].接听通话次数 + '</td><td>' + result[i].通话分钟数 + '</td><td>' + result[i].通话秒数 + '</td><td>' + result[i].平均接听通话秒数 + '</td><td>' + result[i].平均振铃秒数 + '</td><td>' + result[i].呼入占有率 + '</td><td>' + result[i].用户评价 + '</td><td>' + result[i].坐席登录次数 + '</td><td>' + result[i].登录时长分钟数 + '</td><td>' + result[i].工作时长分钟数 + '</td><td>' + result[i].平均每天工作时长 + '</td><td>' + result[i].平均操作分钟数 + '</td><td>' + result[i].置忙次数 + '</td><td>' + result[i].休息时长分钟数 + '</td><td>' + result[i].平均每天休息时长 + '</td><td>' + result[i].置忙平均休息分钟数 + '</td></tr>').appendTo('.thTable tbody')
  224. }
  225. }
  226. });
  227. }
  228. </script>
  229. </body>
  230. </html>