|
<!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 matrix:btn="storeInoutSum-exportExcel" 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" id="shopSearch">
|
<label >所属门店</label> <select id="shopId"
|
class="form-control autoFull"
|
th:data-url="@{/admin/shopInfo/findShops}" data-value="id"
|
data-filed="shopName" data-def="" name="shopId">
|
<option value="">--请选择所属门店--</option>
|
</select>
|
</div>
|
<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" id="productCode" placeholder="输入商品名称/编码" class="form-control " name="name" >
|
</div>
|
<div class="form-group mr-20">
|
<label >操作人</label>
|
<input autocomplete="off" class="form-control " name="userName" >
|
</div>
|
<div class="form-group mr-20">
|
<label for="parentId">库存分类</label>
|
<select class="form-control select2" size="1" name="goodsSortId" id="parentId">
|
<option value="" selected="selected">--选择分类--</option>
|
</select>
|
</div>
|
<div class="form-group mr-20">
|
<label >单据类型</label>
|
<select class="form-control" name="orderType" id="goodType">
|
<option value=''>--请选择商品类型--</option>
|
<option value='消耗产品出库'>消耗产品出库</option>
|
<option value='盘亏出库'>盘亏出库</option>
|
<option value='采购入库'>采购入库</option>
|
<option value='退货入库'>退货入库</option>
|
<option value='其他入库'>其他入库</option>
|
<option value='盘盈入库'>盘盈入库</option>
|
</select>
|
</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="createTime">时间</th>
|
<th data-field="code">产品编码</th>
|
<th data-field="name">商品名称</th>
|
<th data-field="typeName">库存分类</th>
|
<th data-field="amount" data-footer-formatter="countColumn">出库数量</th>
|
<th data-field="goodsPrice" >出库单价</th>
|
<th data-field="totalPrice" data-footer-formatter="countColumn">出库金额</th>
|
<th data-field="orderNo">单据编号</th>
|
<th data-field="orderType">单据类型</th>
|
<th data-field="batch">库存批次</th>
|
<th data-field="userName">操作人</th>
|
<th data-field="remark">单据备注</th>
|
<th data-field="shopName">门店</th>
|
</tr>
|
</thead>
|
</table>
|
</div>
|
|
<div class="form-group " id="closeBtn" style="display: none;" >
|
<div class="col-sm-12 text-center fixed-button">
|
<a class="btn btn-danger radius" href="javascript:;"
|
onclick="MTools.closeForm()"><i class="fa fa-close"></i> 关闭</a>
|
</div>
|
</div>
|
|
<script type="text/javascript" th:src="@{/js/systools/MJsBase.js}"></script><script type="text/javascript">
|
|
//从外部跳入设置默认参数
|
var productCode=$.query.get('productCode');
|
$("#productCode").val(productCode);
|
var shopId=$.query.get('shopId');
|
if(shopId){
|
$("#shopSearch").html(' <input type="hidden" value="'+shopId+'" name="shopId" />');
|
$("#closeBtn").show();
|
}
|
|
|
|
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();
|
myGrid = MGrid.initGrid({
|
url : basePath+"/admin/storeInOut/showList",
|
showExport : true,
|
showFooter : true,
|
height:'auto',
|
width:'auto',
|
});
|
|
$('[data-toggle="tooltip"]').tooltip()
|
|
});
|
|
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 param=MForm.toUrlParam("#serchform");
|
window.location.href=basePath+"/admin/storeInOut/exportExcel?"+param;
|
}
|
initFunctionList();
|
function initFunctionList() {
|
$.AjaxProxy({
|
a: false,
|
c: false
|
}).invoke(basePath + "/admin/goodstype/all", function (loj) {
|
$("#parentId").createSelectTree(loj.attr("result").rows, {
|
append: true,
|
value: "typeName",
|
});
|
});
|
}
|
|
|
|
</script>
|
</body>
|
</html>
|
