| 
<!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="form-group mr-20"> 
 | 
                <label>日期范围</label> 
 | 
                <input name="beginTime" type="text" class="form-control datetimepicker" id="beginTime">- 
 | 
                <input name="endTime"  type="text" class="form-control datetimepicker" id="endTime"> 
 | 
            </div> 
 | 
  
 | 
            <div class="form-group mr-20"> 
 | 
                <label>会员</label> 
 | 
                <input autocomplete="off" placeholder="姓名/编号/电话"  name="vipName" type="text" class="form-control"  > 
 | 
            </div> 
 | 
  
 | 
            <div class="form-group mr-20"> 
 | 
                <label>美疗师</label> 
 | 
                <select class="form-control autoFull select2" 
 | 
                        th:data-url="@{/admin/getShopStaffByRoleName?roleName=美疗师}" 
 | 
                        data-value="suId" 
 | 
                        data-filed="suName" 
 | 
                        name="beaultId" 
 | 
                        id="beaultId"> 
 | 
                    <option value="">--请选择美容师--</option> 
 | 
                </select> 
 | 
            </div> 
 | 
  
 | 
            <div class="form-group mr-20"> 
 | 
                <label>门店</label> 
 | 
                <select class="form-control autoFull" data-filed="shopName" name="shopId" id="shopId" 
 | 
                        th:data-url="@{/admin/shopInfo/findAllWithPermi}"> 
 | 
                    <option value=''>--请选择部所属门店--</option> 
 | 
                </select> 
 | 
            </div> 
 | 
  
 | 
            <div class="form-group mr-20"> 
 | 
                <label> 
 | 
                <input type="checkbox" name="t1"> 指定客 
 | 
                </label> 
 | 
            </div> 
 | 
  
 | 
            <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  type="reset"   class="btn btn-default btn-sm"><i class="fa fa-refresh " ></i> 重置</button> 
 | 
<!--                    <button  matrix:btn="ygyjbb-exportExcel"  onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button>--> 
 | 
                </div> 
 | 
            </div> 
 | 
        </form> 
 | 
  
 | 
  
 | 
        <table id="mgrid"> 
 | 
            <thead> 
 | 
                <tr> 
 | 
                    <th data-formatter="MGrid.indexfn" data-align="center" 
 | 
                        data-width="30px">序号</th> 
 | 
                    <th data-field="vipName" data-formatter="buildVipNameJump">姓名</th> 
 | 
                    <th data-field="meiliao">美疗师</th> 
 | 
                    <th data-field="arriveCnt">到店次数</th> 
 | 
                    <th data-field="goodsCash" data-formatter="countColumn">消费金额</th> 
 | 
                    <th data-field="hisConsume" data-formatter="countColumn">消耗本金</th> 
 | 
                    <th data-field="freeConsume" data-formatter="countColumn">消耗赠送</th> 
 | 
                     
 | 
                </tr> 
 | 
            </thead> 
 | 
        </table> 
 | 
    </div> 
 | 
  
 | 
    <script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script> 
 | 
    <script type="text/javascript" th:src="@{/js/function/public.js}"></script> 
 | 
    <script type="text/javascript"> 
 | 
        var myGrid; 
 | 
        var initParam = { 
 | 
                format : "yyyy-mm-dd hh:ii", //默认显示年与日,如果想显示十分秒:"yyyy-mm-dd hh:ii:ss" 
 | 
                minView: "hour",     //"month",只显示年月日的选择,不会再跳转去选择时分秒;如果想要选择时分秒的:"hour" 
 | 
            } 
 | 
         MTools.ininDatetimepicker(initParam); 
 | 
        //限制结束时间不小于开始时间 
 | 
         MTools.limitStartEndTime({}); 
 | 
  
 | 
        $(function() { 
 | 
            MTools.autoFullSelect(); 
 | 
            $(".select2").select2(); 
 | 
            myGrid = MGrid.initGrid({ 
 | 
                url : basePath+"/admin/vipStatistics/vipConsumeStatistics", 
 | 
                showExport : true, 
 | 
                showFooter : false, 
 | 
                height:'auto', 
 | 
                width:'auto', 
 | 
                exportDataType : "basic", //basic', 'all', 'selected'. 
 | 
                exportTypes : [ 'excel', 'xlsx' ], //导出类型 
 | 
                exportOptions : { 
 | 
                    ignoreColumn : [ 0 ], 
 | 
                    fileName : "客户消费统计" + MTools.getTime(), //文件名称设置 
 | 
                    worksheetName : 'Sheet1', //表格工作区名称   
 | 
                    tableName : '客户消费统计', 
 | 
                    excelstyles : [ 'background-color', 'color', 'font-size', 
 | 
                            'font-weight' ], 
 | 
                } 
 | 
            }); 
 | 
  
 | 
            $('[data-toggle="tooltip"]').tooltip() 
 | 
  
 | 
        }); 
 | 
  
 | 
        function footCountTitle(data) { 
 | 
            return "<b>合计</b>"; 
 | 
        }; 
 | 
        function countColumn(data) { 
 | 
            if (data) { 
 | 
                var resultsumQuantity = parseFloat(data).toFixed(2);//保留有效数字 
 | 
                return resultsumQuantity; 
 | 
            } else { 
 | 
                return "-"; 
 | 
            } 
 | 
        }; 
 | 
  
 | 
        function buildVipNameJump(value, row, index) { 
 | 
            return '<a  onClick="vipDetail(\'' + row.t9 +'\')"   class="text-primary " >'+value+'</a>'; 
 | 
        } 
 | 
  
 | 
        function vipDetail(value) { 
 | 
            layer.full(layer.open({ 
 | 
                type : 2, 
 | 
                title : "订单详情", 
 | 
                maxmin : true, 
 | 
                area : MUI.SIZE_M, 
 | 
                content : [basePath+'/admin/redirect/hive/beautySalon/vip?vipPhone=' + value ] 
 | 
            })); 
 | 
        } 
 | 
  
 | 
        function exportExcel(){ 
 | 
  
 | 
            var param=MForm.toUrlParam("#serchform"); 
 | 
  
 | 
            window.location.href=basePath+"/admin/achieve/exportDailyInfoNew?"+param; 
 | 
        } 
 | 
         
 | 
    </script> 
 | 
</body> 
 | 
</html> 
 |