|
<!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>
|
<button onclick="exportExcel()" type="button" class="btn btn-default btn-sm"><i class="fa fa-download" ></i> 导出</button>
|
</div>
|
</div>
|
<div class="form-group mr-20">
|
<label >选择年月</label> <select
|
class="form-control" name="year" id="select_year">
|
<option value="">年份</option>
|
<option value="2010">2010</option>
|
<option value="2011">2011</option>
|
<option value="2012">2012</option>
|
<option value="2013">2013</option>
|
<option value="2014">2014</option>
|
<option value="2015">2015</option>
|
<option value="2016">2016</option>
|
<option value="2017">2017</option>
|
<option value="2018">2018</option>
|
<option value="2019">2019</option>
|
<option value="2020">2020</option>
|
<option value="2021">2021</option>
|
</select> <select class="form-control" name="month" id="select_month">
|
<option value="01">1</option>
|
<option value="02">2</option>
|
<option value="03">3</option>
|
<option value="04">4</option>
|
<option value="05">5</option>
|
<option value="06">6</option>
|
<option value="07">7</option>
|
<option value="08">8</option>
|
<option value="09">9</option>
|
<option value="10">10</option>
|
<option value="11">11</option>
|
<option value="12">12</option>
|
</select>
|
|
<select class="form-control" name="day" id="select_month">
|
<option value="">日</option>
|
<th:block th:each="i:${#numbers.sequence(1, 31)}" >
|
<option th:value="${i }" th:text="${i }"></option>
|
</th:block>
|
</select>
|
</div>
|
<div class="form-group mr-20">
|
<label>日期范围</label>
|
<input autocomplete="off" name="beginTime" type="text" class="form-control datetimepicker" id="beginTime">-
|
<input autocomplete="off" name="endTime" type="text" class="form-control datetimepicker" id="endTime">
|
</div>
|
|
|
</form>
|
|
|
<table id="mgrid">
|
<thead>
|
<tr>
|
<th data-formatter="MGrid.indexfn" data-align="center"
|
data-width="30px" data-footer-formatter="footCountTitle">序号</th>
|
<th data-field="year">年</th>
|
<th data-field="month">月</th>
|
<th data-field="day">日</th>
|
<th data-field="staffName">员工</th>
|
<th data-field="postName">职位</th>
|
<th data-field="zkTotal" data-footer-formatter="countColumn">总金额</th>
|
<th data-field="cardCash" data-footer-formatter="countColumn">卡项</th>
|
<th data-field="projCash" data-footer-formatter="countColumn">现金单次</th>
|
<th data-field="goodsCash" data-footer-formatter="countColumn">现金产品</th>
|
<th data-field="consume" data-footer-formatter="countColumn">划扣</th>
|
<th data-field="hisConsume" data-footer-formatter="countColumn">本金消耗</th>
|
<th data-field="freeConsume" data-footer-formatter="countColumn">赠消</th>
|
<th data-field="projPercentage" data-footer-formatter="countColumn">提成</th>
|
<th data-field="numberOfPeople" data-footer-formatter="countColumn">人头</th>
|
<th data-field="projNum" data-footer-formatter="countColumn">项目个数</th>
|
<th data-field="projTime" data-footer-formatter="countColumn">项目时间</th>
|
<th data-field="shopName">门店</th>
|
</tr>
|
</thead>
|
</table>
|
</div>
|
|
<script type="text/javascript" th:src="@{/js/systools/MJsBase.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({});
|
|
var date = new Date();
|
var year = date.getFullYear();
|
var month = date.getMonth() + 1;
|
var year_options = "";
|
for (var i = 9; i > 0; i--) {
|
year_options += "<option value='" + (year - i) + "'>" + (year - i)
|
+ "</option>";
|
}
|
year_options += "<option value='"+year+"' selected='selected'>" + year
|
+ "</option>";
|
$("#select_year").html(year_options);
|
$("#select_month").find("option").each(function(row) {
|
var option_month = $(this).val();
|
if (month == option_month) {
|
$(this).attr("selected", true);
|
}
|
});
|
|
$(function() {
|
MTools.autoFullSelect();
|
myGrid = MGrid.initGrid({
|
url : basePath+"/form/vip/findStaffDailyInfoNew",
|
showExport : true,
|
showFooter : true,
|
height:'',
|
width:'',
|
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' ],
|
}
|
});
|
});
|
|
function footCountTitle(data) {
|
return "<b>合计</b>";
|
};
|
function countColumn(data) {
|
console.log(data)
|
field = this.field;
|
var resultsumQuantity = parseFloat((data.reduce(function(sum, row) {
|
console.log(sum,row[field]);
|
return sum + (+row[field]);
|
}, 0)).toFixed(2));//保留有效数字
|
return "<b>"+resultsumQuantity+"</b>";
|
};
|
|
function exportExcel(){
|
var select_begin = $("#beginTime").val();
|
var select_end = $("#endTime").val();
|
var shopId = $("#select_id").val();
|
|
var year = $("#select_year").val();
|
var month = $("#select_month").val();
|
|
|
window.location.href=basePath+"/form/vip/exportStaffDailyInfoNew?beginTime="+select_begin+"&endTime="+select_end+"&shopId="+shopId+"&month="+month+"&year="+year;
|
}
|
|
|
|
</script>
|
</body>
|
</html>
|
