workreport.html 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217
  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. <link rel="shortcut icon" href="favicon.ico">
  8. <link href="__CSS__/bootstrap.min.css?v=3.3.6" rel="stylesheet">
  9. <link href="__CSS__/font-awesome.min.css?v=4.4.0" rel="stylesheet">
  10. <link href="__CSS__/plugins/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
  11. <link href="__CSS__/animate.min.css" rel="stylesheet">
  12. <link href="__CSS__/style.min.css?v=4.1.0" rel="stylesheet">
  13. <link href="__JS__/layui/css/myLayui.css" rel="stylesheet">
  14. </head>
  15. <body class="gray-bg">
  16. <div class="wrapper wrapper-content animated fadeInRight">
  17. <!-- Panel Other -->
  18. <div class="ibox float-e-margins">
  19. <div class="ibox-title">
  20. <h5>工作报表</h5>
  21. </div>
  22. <div class="ibox-content">
  23. <!--搜索框开始-->
  24. <form id='commentForm' role="form" method="post" class="form-inline pull-right">
  25. <div class="content clearfix m-b">
  26. <div class="form-group">
  27. <label>工作日期:</label>
  28. <input type="text" class="form-control" id="start" value="<?php echo date('Y-m-d',time()-86400);?>" style="width: 100px;"> --
  29. <input type="text" class="form-control" id="end" value="<?php echo date('Y-m-d',time()-86400);?>" style="width: 100px;">
  30. </div>
  31. <div class="form-group">
  32. <label>客服:</label>
  33. <input type="text" class="form-control" id="username" name="user_name">
  34. </div>
  35. <div class="form-group">
  36. <button class="btn btn-primary" type="button" style="margin-top:5px" id="search"><strong>搜 索</strong>
  37. </button>
  38. </div>
  39. <div class="form-group" style="margin-left:50px;margin-top:5px">
  40. <button class="btn btn-primary" type="button" id="toExcel" name="toExcel" value="0"><strong>导出Excel</strong>
  41. </button>
  42. </div>
  43. </div>
  44. </form>
  45. <!--搜索框结束-->
  46. <div class="example-wrap">
  47. <div class="example">
  48. <table id="cusTable">
  49. <thead>
  50. <th data-field="user_account">账号</th>
  51. <th data-field="user_name">名称</th>
  52. <th data-field="user_job_number">工号</th>
  53. <th data-field="service_num">接入会话量</th>
  54. <th data-field="send_words">总消息量</th>
  55. <th data-field="transfer_in">接入转接量</th>
  56. <th data-field="reply">回复率</th>
  57. <th data-field="answer_problem">答问比</th>
  58. <th data-field="conversation">平均会话时长</th>
  59. <th data-field="response">平均响应时长</th>
  60. <th data-field="appraise">参评率</th>
  61. <th data-field="pleased">相对满意度率</th>
  62. <th data-field="pleased_num">满意评价次数</th>
  63. <th data-field="commonly">一般评价次数</th>
  64. <th data-field="no_pleased">不满意评价次数</th>
  65. <th data-field="message">留言处理量</th>
  66. </thead>
  67. </table>
  68. </div>
  69. </div>
  70. <!-- End Example Pagination -->
  71. </div>
  72. </div>
  73. </div>
  74. <!-- End Panel Other -->
  75. <script src="__JS__/jquery.min.js?v=2.1.4"></script>
  76. <script src="__JS__/bootstrap.min.js?v=3.3.6"></script>
  77. <script src="__JS__/content.min.js?v=1.0.0"></script>
  78. <script src="__JS__/plugins/bootstrap-table/bootstrap-table.min.js"></script>
  79. <script src="__JS__/plugins/bootstrap-table/bootstrap-table-mobile.min.js"></script>
  80. <script src="__JS__/plugins/bootstrap-table/locale/bootstrap-table-zh-CN.min.js"></script>
  81. <script src="__JS__/plugins/layer/layer.min.js"></script>
  82. <script src="__JS__/layui/layui.js"></script>
  83. <script type="text/javascript">
  84. layui.use(['form', 'upload'], function(){
  85. var form = layui.form;
  86. form.on('select(message_status)', function(value){
  87. $("#message_status").val(value.value);
  88. onSearch()
  89. });
  90. });
  91. </script>
  92. <script type="text/javascript">
  93. function initTable() {
  94. //先销毁表格
  95. $('#cusTable').bootstrapTable('destroy');
  96. //初始化表格,动态从服务器加载数据
  97. $("#cusTable").bootstrapTable({
  98. method: "get", //使用get请求到服务器获取数据
  99. url: "{:url('report/workreport')}", //获取数据的地址
  100. striped: true, //表格显示条纹
  101. pagination: true, //启动分页
  102. pageSize: 50, //每页显示的记录数
  103. pageNumber:1, //当前第几页
  104. pageList: [20, 50], //记录数可选列表
  105. sidePagination: "server", //表示服务端请求
  106. paginationFirstText: "首页",
  107. paginationPreText: "上一页",
  108. paginationNextText: "下一页",
  109. paginationLastText: "尾页",
  110. queryParamsType : "undefined",
  111. queryParams: function queryParams(params) { //设置查询参数
  112. var param = {
  113. pageNumber: params.pageNumber,
  114. pageSize: params.pageSize,
  115. searchText:$('#username').val(),
  116. start:$('#start').val(),
  117. end:$('#end').val()
  118. };
  119. return param;
  120. },
  121. onLoadSuccess: function(res){ //加载成功时执行
  122. if(111 == res.code){
  123. window.location.reload();
  124. }
  125. layer.msg("加载成功", {time : 1000});
  126. },
  127. onLoadError: function(){ //加载失败时执行
  128. layer.msg("加载数据失败");
  129. }
  130. });
  131. }
  132. $(document).ready(function () {
  133. //调用函数,初始化表格
  134. initTable();
  135. //当点击查询按钮的时候执行
  136. $("#search").bind("click", function(){
  137. var start = $('#start').val();
  138. var end = $('#end').val();
  139. if(start > end){
  140. layer.msg('开始时间不能大于结束时间');
  141. return false;
  142. }
  143. //获取当前时间 年月日
  144. var date = new Date();
  145. var year = date.getFullYear();
  146. var month = date.getMonth() + 1;
  147. var day = date.getDate();
  148. if (month < 10) {
  149. month = "0" + month;
  150. }
  151. if (day < 10) {
  152. day = "0" + day;
  153. }
  154. var nowDate = year + "-" + month + "-" + day;
  155. console.log(nowDate);
  156. if(nowDate <= end){
  157. layer.msg('结束时间不能大于等于当前时间');
  158. return false;
  159. }
  160. initTable();
  161. });
  162. $("#toExcel").on("click", function () {
  163. $("#toExcel").val(1);
  164. $("#start").val();
  165. $("#end").val();
  166. $("#username").val();
  167. var url = "{:url('report/workreport')}" + "?pageNumber=1&pageSize=100&start="+$("#start").val()+"&end="+$("#end").val()+"&searchText="+$("#username").val()+"&toExcel=1";
  168. window.open(url);
  169. return false;
  170. });
  171. });
  172. function messageDel(id){
  173. layer.confirm('确认删除?', {icon: 3, title:'提示'}, function(index){
  174. //do something
  175. $.getJSON("{:url('Messages/delMessage')}", {'id' : id}, function(res){
  176. if(1 == res.code){
  177. layer.alert(res.msg, {title: '友情提示', icon: 1, closeBtn: 0}, function(){
  178. initTable();
  179. });
  180. }else if(111 == res.code){
  181. window.location.reload();
  182. }else{
  183. layer.alert(res.msg, {title: '友情提示', icon: 2});
  184. }
  185. });
  186. layer.close(index);
  187. })
  188. }
  189. layui.use('laydate', function(){
  190. var laydate = layui.laydate;
  191. laydate.render({
  192. elem: '#start'
  193. ,type: 'date'
  194. });
  195. laydate.render({
  196. elem: '#end'
  197. ,type: 'date'
  198. });
  199. });
  200. </script>
  201. </body>
  202. </html>