workreport.html 9.3 KB

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