123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124 |
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <title>统计查询</title>
- <!-- Tell the browser to be responsive to screen width -->
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <!-- Font Awesome -->
- <link rel="stylesheet" href="${contextPath}/dist/js/layui/css/layui.css">
- <link rel="stylesheet" href="${contextPath}/dist/css/admin.css" media="all">
- </head>
- <body class="layui-layout-body">
- <div class="layui-layout layui-layout-admin">
- <!-- Navbar -->
- <#include "../body/top.html">
- <!-- /.navbar -->
- <!-- Main Sidebar Container -->
- <#include "../body/left.html">
- <!-- Content Wrapper. Contains page content -->
- <div class="layui-body">
- <!-- 内容主体区域 -->
- <div class="layui-card">
- <form id="searchForm" action="${contextPath}/count/bill">
- <div class="layui-form layui-card-header layuiadmin-card-header-auto">
- <div class="layui-form-item">
- <div class="layui-inline">
- <label class="layui-form-label">开始时间</label>
- <div class="layui-input-inline">
- <input type="text" name="start_time" value="${start_time}" id="start_time" lay-verify="date" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input">
- </div>
- </div>
- <div class="layui-inline">
- <label class="layui-form-label">结束时间</label>
- <div class="layui-input-inline">
- <input type="text" name="end_time" value="${end_time}" id="end_time" lay-verify="date" placeholder="yyyy-MM-dd" autocomplete="off" class="layui-input">
- </div>
- </div>
- <div class="layui-inline">
- <button id="search_btn" class="layui-btn layuiadmin-btn-list" lay-submit lay-filter="LAY-app-contlist-search">
- <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
- </button>
- </div>
- </div>
- </div>
- </form>
- </div>
- <table class="layui-hide" id="test" lay-filter="test"></table>
- <script type="text/html" id="toolbarDemo">
- <div class="layui-btn-container">
- </div>
- </script>
- <script type="text/html" id="countAllTpl">
- <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}" title="详细">{{d.count_all}}元</a>
- </script>
- <script type="text/html" id="countTfTpl">
- <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=2" title="详细">{{d.count_tf}}元</a>
- </script>
- <script type="text/html" id="countSjTpl">
- <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1" title="详细">{{d.count_sj}}元</a>
- </script>
- <script type="text/html" id="countWxTpl">
- <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1&pay_type=0" title="详细">{{d.count_wx}}元</a>
- </script>
- <script type="text/html" id="countAliTpl">
- <a href="${contextPath}/count/bill_detail?start_time=${start_time}&end_time=${end_time}&status=1&pay_type=1" title="详细">{{d.count_ali}}元</a>
- </script>
- </div>
- <!-- /.content-wrapper -->
- <#include "../body/footer.html">
- </div>
- <!-- ./wrapper -->
- <script type="text/javascript" src="${contextPath}/dist/js/jquery-1.11.1.min.js"></script>
- <script src="${contextPath}/dist/js/layui/layui.js"></script>
- <script>
- //JavaScript代码区域
- layui.use(['element', 'laypage', 'layer', 'form', 'laydate','table'], function(){
- var element = layui.element;
- var form = layui.form;
- var laydate = layui.laydate;
- var table = layui.table;
-
- //日期
- laydate.render({
- elem: '#start_time'
- });
- laydate.render({
- elem: '#end_time'
- });
-
- table.render({
- elem: '#test'
- ,url:'${contextPath}/count/bill_json?start_time=${start_time}&end_time=${end_time}'
- ,toolbar: '#toolbarDemo' //开启头部工具栏,并为其绑定左侧模板
- ,defaultToolbar: ['filter', 'exports', 'print',{ //自定义头部工具栏右侧图标。如无需自定义,去除该参数即可
- title: '提示'
- ,layEvent: 'LAYTABLE_TIPS'
- ,icon: 'layui-icon-tips'
- }]
- ,title: '用户数据表'
- ,totalRow: true
- ,height: 'full-240' //高度最大化减去差值
- ,cols: [[
- {field:'user_name', title:'操作人', width:150,fixed: 'left',style:'background-color: #009688; color: #fff;',totalRowText: '合计:'}
- ,{field:'count_all', title:'总金额', templet: '#countAllTpl', totalRow: true}
- ,{field:'count_tf', title:'退款', templet: '#countTfTpl', totalRow: true}
- ,{field:'count_sj', title:'实际总金额', templet: '#countSjTpl', totalRow: true}
- ,{field:'count_wx', title:'微信', templet: '#countWxTpl', totalRow: true}
- ,{field:'count_wxtf', title:'微信退费', totalRow: true}
- ,{field:'count_ali', title:'支付宝',templet: '#countAliTpl', totalRow: true}
- ,{field:'count_alitf', title:'支付宝退费', totalRow: true}
- ]]
- ,page: false
- ,done: function (res, curr, count) {
- $(".layui-table-total td").css("background-color", "#FF5722");
- }
- });
- });
- </script>
- </body>
- </html>
|