count_list.html 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6. <title>统计查询</title>
  7. <!-- Tell the browser to be responsive to screen width -->
  8. <meta name="viewport" content="width=device-width, initial-scale=1">
  9. <!-- Font Awesome -->
  10. <link rel="stylesheet" href="${contextPath}/dist/js/layui/css/layui.css">
  11. <link rel="stylesheet" href="${contextPath}/dist/css/admin.css" media="all">
  12. </head>
  13. <body class="layui-layout-body">
  14. <div class="layui-layout layui-layout-admin">
  15. <!-- Navbar -->
  16. <#include "../body/top.html">
  17. <!-- /.navbar -->
  18. <!-- Main Sidebar Container -->
  19. <#include "../body/left.html">
  20. <!-- Content Wrapper. Contains page content -->
  21. <div class="layui-body">
  22. <!-- 内容主体区域 -->
  23. <div class="layui-card">
  24. <form id="searchForm" action="${contextPath}/count/bill">
  25. <div class="layui-form layui-card-header layuiadmin-card-header-auto">
  26. <div class="layui-form-item">
  27. <div class="layui-inline">
  28. <label class="layui-form-label">开始时间</label>
  29. <div class="layui-input-inline">
  30. <input type="text" name="start_time" value="${start_time}" id="start_time" lay-verify="date" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input">
  31. </div>
  32. </div>
  33. <div class="layui-inline">
  34. <label class="layui-form-label">结束时间</label>
  35. <div class="layui-input-inline">
  36. <input type="text" name="end_time" value="${end_time}" id="end_time" lay-verify="date" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input">
  37. </div>
  38. </div>
  39. <div class="layui-inline">
  40. <button id="search_btn" class="layui-btn layuiadmin-btn-list" lay-submit lay-filter="LAY-app-contlist-search">
  41. <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
  42. </button>
  43. </div>
  44. </div>
  45. </div>
  46. </form>
  47. </div>
  48. <table class="layui-hide" id="test" lay-filter="test"></table>
  49. <script type="text/html" id="toolbarDemo">
  50. <div class="layui-btn-container">
  51. </div>
  52. </script>
  53. <script type="text/html" id="countAllTpl">
  54. <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}" title="详细">{{d.count_all}}元</a>
  55. </script>
  56. <script type="text/html" id="countTfTpl">
  57. <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=2" title="详细">{{d.count_tf}}元</a>
  58. </script>
  59. <script type="text/html" id="countSjTpl">
  60. <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1" title="详细">{{d.count_sj}}元</a>
  61. </script>
  62. <script type="text/html" id="countWxTpl">
  63. <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1&pay_type=0" title="详细">{{d.count_wx}}元</a>
  64. </script>
  65. <script type="text/html" id="countAliTpl">
  66. <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1&pay_type=1" title="详细">{{d.count_ali}}元</a>
  67. </script>
  68. </div>
  69. <!-- /.content-wrapper -->
  70. <#include "../body/footer.html">
  71. </div>
  72. <!-- ./wrapper -->
  73. <script type="text/javascript" src="${contextPath}/dist/js/jquery-1.11.1.min.js"></script>
  74. <script src="${contextPath}/dist/js/layui/layui.js"></script>
  75. <script>
  76. //JavaScript代码区域
  77. layui.use(['element', 'laypage', 'layer', 'form', 'laydate','table'], function(){
  78. var element = layui.element;
  79. var form = layui.form;
  80. var laydate = layui.laydate;
  81. var table = layui.table;
  82. //日期
  83. laydate.render({
  84. elem: '#start_time'
  85. });
  86. laydate.render({
  87. elem: '#end_time'
  88. });
  89. table.render({
  90. elem: '#test'
  91. ,url:'${contextPath}/count/bill_json?start_time=${start_time}&end_time=${end_time}'
  92. ,toolbar: '#toolbarDemo' //开启头部工具栏,并为其绑定左侧模板
  93. ,defaultToolbar: ['filter', 'exports', 'print',{ //自定义头部工具栏右侧图标。如无需自定义,去除该参数即可
  94. title: '提示'
  95. ,layEvent: 'LAYTABLE_TIPS'
  96. ,icon: 'layui-icon-tips'
  97. }]
  98. ,title: '用户数据表'
  99. ,totalRow: true
  100. ,height: 'full-240' //高度最大化减去差值
  101. ,cols: [[
  102. {field:'user_name', title:'操作人', width:150,fixed: 'left',style:'background-color: #009688; color: #fff;',totalRowText: '合计:'}
  103. ,{field:'count_all', title:'总金额', templet: '#countAllTpl', totalRow: true}
  104. ,{field:'count_tf', title:'退款', templet: '#countTfTpl', totalRow: true}
  105. ,{field:'count_sj', title:'实际总金额', templet: '#countSjTpl', totalRow: true}
  106. ,{field:'count_wx', title:'微信', templet: '#countWxTpl', totalRow: true}
  107. ,{field:'count_wxtf', title:'微信退费', totalRow: true}
  108. ,{field:'count_ali', title:'支付宝',templet: '#countAliTpl', totalRow: true}
  109. ,{field:'count_alitf', title:'支付宝退费', totalRow: true}
  110. ]]
  111. ,page: false
  112. ,done: function (res, curr, count) {
  113. $(".layui-table-total td").css("background-color", "#FF5722");
  114. }
  115. });
  116. });
  117. </script>
  118. </body>
  119. </html>