jyy
2021-03-12 baa79615425b71521e67ec8a9344b88ce53fc5de
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
131
132
133
134
135
136
137
138
139
140
 
 
 
 
<!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">
            <!-- 用于套餐的查询 -->
            <input autocomplete="off"   type="hidden" name="vipId" value="" id="vipId">
            
            <div class="form-group mr-20">
                <label>充值卡名称</label>
                <input autocomplete="off"   name="cardName" type="text" class="form-control">
            </div>
            
            <div class="form-group mr-20">
                <label for="status">状态</label>
                <select name="status" class="form-control">
                    <option value="">--请选择状态--</option>
                    <option value="有效">有效</option>
                    <option value="无效">无效</option>
                    <option value="转让">转让</option>
                    <option value="冻结">冻结</option>
                    <option value="退款">退款</option>
                </select>
            </div>
            
            <div class="form-group mr-20">
                <label >来源</label>
                <select name="source" class="form-control">
                    <option value="">--请选择来源--</option>
                    <option value="购买">购买</option>
                    <option value="赠送">赠送</option>
                    <option value="转让">转让</option>
                    <option value="数据迁移">数据迁移</option>
                </select>
            </div>
            
            
            
            <button  onclick="myGrid.serchData()" type="button" class="btn btn-default btn-sm"><i class="fa fa-search " ></i> 搜索</button>
            <button  type="reset" class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button>
        </form>
    <!-- 搜索框部分en -->
        <table id="mgrid">
            <thead>
                <tr>
                    <th data-formatter="MGrid.indexfn" data-align="center"
                        data-width="30px">序号</th>
                    <th data-field="vipInfo.vipNo">客户编号</th>
                    <th data-field="vipInfo.vipName">所属客户</th>
                    <th data-field="cardName" data-sortable="true">充值卡名称</th>
                    <th data-field="useTotal">总次数</th>
                    <th data-field="lastCount">剩余次数</th>
                    <th data-field="realMoney">本金</th>
                    <th data-field="giftMoney">赠送金额</th>
                    <th data-field="source">来源</th>
                    <th data-field="status">状态</th>
                    <th data-field="isVipCar" data-formatter="getYesOrNo">是否是会籍卡</th>
                    <th data-field="isOver" data-formatter="getYesOrNo">是否使用完成</th>
                    <th data-field="failTime" data-formatter="MGrid.getTimeDD">到期时间</th>
                </tr>
            </thead>
       </table>
 
    </div>
    
    <script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script><script type="text/javascript">
    //初始化表格
    $("#vipId").val($.query.get("vipId"));
    var myGrid;
     myGrid=MGrid.initGrid({
                 url:basePath+"/admin/moneyCardUse/showVipMoneyCardList",
                 detailView : true,
                onExpandRow : function(index, row, $detail) {
                    InitSubTable(index, row, $detail);
                },
             });
    // 父子表,拼接字表
        function InitSubTable(index, row, $detail) {
            var id = row.id;
             $.AjaxProxy({p:{carUseId:id}}).invoke(
                        basePath+"/admin/projService/showVipMoneyCardFlowList" , function(loj){
                            console.log(loj);
                            if (loj.length == 0) {
                                var cur = $detail.html('<h4></h4>');
                                var html = "没有找到匹配的数据";
                                cur.append(html);
                            } else {
                                var thead = '<thead><tr><th>序号</th><th>操作人</th> <th>操作时间</th><th>操作内容</th></tr></thead>';
                                var cur_table = $detail.html(
                                        '<table  class="table table-hover" >' + thead + '</table>')
                                        .find('table');
                                var html = "";
                                for (var i = 0; i < loj.length; i++) {
                                    html += '<tr>' 
                                        + '<td>' + (i + 1) + '</td>' 
                                        + '<td>'+ loj.getString(i,"staffName") + '</td>' 
                                         + '<td>'+ loj.getDate(i,"createTime") + '</td>' 
                                        + '<td>'+  loj.getString(i,"content")+ '</td>' + '</tr>';
                                }
                                cur_table.append(html);
                            }     
                });
            
        }
    
     function getYesOrNo(value, row, index){
         switch(value){
         case 'Y':
             return "是";
         case 'N':
             return "否";
         default: 
             return value;
         }
     }
    </script>
</body>
</html>