Helius
2022-05-27 4351e71d782741143a98f86f6648acd16689165f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
 
<!DOCTYPE HTML>
<html xmlns:th="http://www.thymeleaf.org" xmlns:matrix="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport"
    content="width=device-width,initial-scale=1,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
<LINK rel="Bookmark" href="../images/favicon.ico">
<!-- 本框架基本脚本和样式 -->
<script type="text/javascript"
        th:src="@{/js/plugin/jquery-2.1.4.min.js}"></script>
<script type="text/javascript" th:src="@{/js/systools/MBase.js}"></script>
</head>
<body class="gray-bg">
    <div class="ibox-content">
    <!-- 搜索框部分start -->
        <form class="form-inline" id="serchform">
        <div class="row mb-10">
                <div class="col-sm-8">
                    <button  onclick="myGrid.serchData()" type="button" class="btn btn-info btn-sm"><i class="fa fa-search" ></i> 搜索</button>
                    <button  onclick="myGrid.resetForm()" type="button"   class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button>
                </div>
            </div>
 
            <div class="form-group mr-20">
                <label>储值卡名称</label>
                <input autocomplete="off"   name="projName" type="text" class="form-control" >
            </div>
 
            <div class="form-group mr-20">
                <label for="parentId">商品分类</label>
                <select class="form-control select2" size="1" name="cateId" id="parentId">
                    <option value="" selected="selected">--选择分类--</option>
                </select>
            </div>
 
            <div class="form-group mr-20">
                <label>会员</label>
                <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipQueryKey" type="text" class="form-control"  >
            </div>
 
 
            <div class="form-group mr-20">
                <label>到期时间</label><!--    入库时间的查询增加一个查询的其实时间两个字段 -->
                <input autocomplete="off"   id="select_begin" name="beginTime" type="text" class="form-control datetimepicker">-
                <input autocomplete="off"   name="endTime"  type="text" class="form-control datetimepicker" id="select_end">
            </div>
        </form>
        <div id="option-bar" >
            <button  matrix:btn="cardSale-exportExcel"  onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button>
        </div>
        <table id="mgrid" data-url="" >
            <thead>
                <tr>
                    <th data-formatter="MGrid.indexfn" data-align="center"  data-width="30px" >序号</th>
                    <th data-field="VIP_NAME" >客户名</th>
                    <th data-field="card_name" >充值卡名称</th>
                    <th data-field="FAIL_TIME"  data-formatter="MGrid.getTime"  data-sortable="true"   >到期日期</th>
                      <th data-field="real_money"  data-sortable="true"     >剩余本金</th>
                      <th data-field="gift_money"  data-sortable="true"     >剩余赠送金额</th>
                    <th data-field="isOver" data-formatter="getYesOrNo">是否使用完成</th>
                    <th data-field="is_vip_car" data-formatter="getYesOrNo">是否为会籍卡</th>
                      <th data-field="remark" >备注</th>
                      <th data-field="SOURCE" >来源</th>
                      <th data-field="ORDER_NO" >订单号</th>
                </tr>
            </thead>
        </table>
    </div>
 
    <script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script><script type="text/javascript">
 
        function getYesOrNo(value, row, index) {
            switch (value) {
                case 'Y':
                    return "是";
                case 'N':
                    return "否";
                default:
                    return value;
            }
        }
 
    var myGrid;
        $(function(){
            //时间
            MTools.ininDatetimepicker({});
            //限制结束时间不小于开始时间
            MTools.limitStartEndTime({});
            //初始化项目属性搜索列表
            MTools.autoFullSelect();
            $(".select2").select2();
 
            initFunctionList();
 
            //有删除权限
            var delUrl="";
            myGrid=MGrid.initGrid({
                 url:basePath+"/admin/moneyCardUseStatistics/showList"
             });
        });
 
        function exportExcel(){
            var param=MForm.toUrlParam("#serchform");
            window.location.href=basePath+"/admin/moneyCardUseStatistics/exportShowList?"+param;
        }
 
 
 
        function initFunctionList() {
        $.AjaxProxy({
            a: false,
            c: false,
            p: {salePlatform: '线下'}
        }).invoke(basePath + "/admin/shoppinggoodscategory/all", function (loj) {
            $("#parentId").createSelectTree(loj.attr("result").rows, {
                append: true,
                value: "name",
            });
        });
    }
 
 
    </script>
</body> 
</html>