@{
|
ViewBag.Title = "业务汇总"; //上下架记录（入库、领料、退料）
|
Layout = "~/Views/Shared/_LayoutVue.cshtml";
|
}
|
|
<script src="~/Content/js/echarts/echarts.min.js"></script>
|
<script src="~/Content/js/linq.js_ver2.2.0.2/linq.js"></script>
|
<style>
|
.el-table .warning-row {
|
background: #ffc5c5;
|
}
|
|
.el-table .success-row {
|
background: #c4ffc1;
|
}
|
</style>
|
<div id="list" v-cloak>
|
<el-card class="box-card">
|
<el-form label-width="90px" v-bind:model="formData" class="demo-ruleForm" v-bind:inline="true">
|
<el-form-item label="仓库名：">
|
<hh-select-url v-model="formData.stockCode"
|
url="/Basic/Common/StockList"
|
valuefield="CN_S_STOCK_CODE"
|
textfield="CN_S_STOCK_NAME"
|
datafield="Data">
|
</hh-select-url>
|
</el-form-item>
|
@*<el-form-item label="上/下架：">
|
<hh-select-url v-model="formData.type"
|
valuefield="CN_S_STOCK_CODE"
|
textfield="CN_S_STOCK_NAME"
|
datafield="Data">
|
</hh-select-url>
|
</el-form-item>*@
|
|
<el-form-item label="凭证性质：">
|
<hh-select-url v-model="formData.cn_s_ext2" url="/Basic/Common/GetDictionary?dictName=凭证性质"
|
valuefield="NAME"
|
textfield="NAME"
|
v-bind:usedefault="true"></hh-select-url>
|
</el-form-item>
|
|
@*<el-form-item label="凭证性质：">
|
<el-input v-model="formData.cn_s_ext2" size="mini"></el-input>
|
</el-form-item>*@
|
@*<el-form-item label="业务号：">
|
<el-input v-model="formData.opNo" size="mini"></el-input>
|
</el-form-item>*@
|
<el-form-item label="物料编号：">
|
<el-input v-model="formData.itemCode" size="mini"></el-input>
|
</el-form-item>
|
<el-form-item label="物料名称：">
|
<el-input v-model="formData.itemName" size="mini"></el-input>
|
</el-form-item>
|
<el-form-item label="规格型号：">
|
<el-input v-model="formData.model" size="mini"></el-input>
|
</el-form-item>
|
@*<el-form-item label="托盘码：">
|
<el-input v-model="formData.trayCode" size="mini"></el-input>
|
</el-form-item>*@
|
<el-form-item label="创建日期：" style="width:400px">
|
<el-date-picker v-model="formData.date"
|
type="daterange"
|
align="right"
|
unlink-panels
|
range-separator="至"
|
start-placeholder="开始日期"
|
end-placeholder="结束日期"
|
value-format="yyyy-MM-dd"
|
v-on:change="selectTime"
|
v-bind:picker-options="pickerOptions2" size="mini" style="width:300px">
|
</el-date-picker>
|
</el-form-item>
|
<el-form-item>
|
<el-button style="margin-top:2px;" size="mini" type="primary" v-on:click="search">查 询</el-button>
|
<el-button size="mini" type="primary" v-on:click="exportExecl">导 出</el-button>
|
</el-form-item>
|
|
</el-form>
|
@*<el-row style="padding-left: 10px; margin-top: 7px;"></el-row>*@
|
</el-card>
|
<hh-table v-bind:coloptions="outCols"
|
v-bind:paging="true"
|
v-bind:check="false"
|
v-bind:where="where"
|
v-bind:rowno="true"
|
v-bind:rowstyle="tableRowClassName"
|
dh="120"
|
url="@Url.Action("GetInventorySummary")"
|
ref="busslist"></hh-table>
|
@*<el-card class="box-card" >
|
<el-row v-bind:gutter="24" style="">
|
<el-col v-bind:span="10" style="padding:15px 12px;">
|
<div id="divBussLine" class="chart churuku" style="width:100%;height:200px"></div>
|
</el-col>
|
</el-row>
|
</el-card>*@
|
</div>
|
@section scripts{
|
<script>
|
var outList = new Vue({
|
data: {
|
formData: {
|
stockCode: "",
|
opType: "",
|
opNo: "",
|
itemCode: "",
|
itemName: "",
|
model: "",
|
location:"",
|
date: "",
|
valueDate: "",
|
trayCode: "",
|
cn_s_ext2: ""
|
},
|
where: {},
|
outCols: [
|
//{ f: "type", n: "+/-", w: 30 },
|
{ f: "CN_S_STOCK_CODE", n: "仓库", w: 120 },
|
//{ f: "CN_S_STOCK_AREA", n: "库区", w: 80 },
|
//{ f: "CN_S_LOCATION_CODE", n: "货位", w: 120 },
|
//{ f: "CN_S_EXT1", n: "料箱码", w: 120 },
|
//{ f: "CN_S_TRAY_CODE", n: "托盘", w: 120 },
|
|
//{ f: "CN_S_FROM_NO", n: "业务号", w: 100 },
|
{ f: "CN_S_ITEM_CODE", n: "物料编码", w: 160 },
|
{ f: "CN_S_ITEM_NAME", n: "物料名称", w: 200 },
|
{ f: "CN_S_MODEL", n: "规格型号", w: 220 },
|
//{ f: "CN_S_PRODUCTION_BATCH", n: "生产批次", w: 150 },
|
//{ f: "CN_S_ITEM_STATE", n: "物料状态", w: 80 },
|
{
|
f: "CN_F_QUANTITY", n: "数量", w: 80, format: function (row, column) {
|
if (row.type == "+") {
|
value = row.CN_F_QUANTITY;
|
} else if (row.type == "-") {
|
value = "-" + row.CN_F_QUANTITY;
|
} else {
|
value = row.CN_F_QUANTITY;
|
}
|
return value;
|
}
|
},
|
|
//{ f: "CN_F_PACKING_QTY", n: "包装数量", w: 60 },
|
{
|
f: "CN_S_MEASURE_UNIT", n: "单位", w: 60
|
},
|
//{ f: "CN_S_OP_FROM", n: "来源业务", w: 120 },
|
{ f: "CN_S_EXT2", n: "凭证性质", w: 100 },
|
{ f: "CN_S_LOT_NO", n: "指令批号", w: 100 },
|
//{ f: "CN_S_CREATOR_BY", n: "作业人", w: 80 },
|
//{ f: "CN_T_CREATE", n: "作业时间", w: 120 }
|
]
|
},
|
mounted: function () {
|
$this = this;
|
$this.pickerOptions2();
|
//data();
|
//$this.InitBuss(7);
|
},
|
methods: {
|
search: function () {
|
this.$refs.busslist.loadData(this.formData);
|
},
|
exportExecl: function () {
|
$this = this;
|
var v = { formData: $this.formData, columns: $this.outCols };
|
ajaxManage({
|
url: "@Url.Action("ExportInventorySummary")",
|
data: JSON.stringify(v),
|
success: function (result) {
|
if (result.Success)
|
location.href = "/Basic/Common/GetFile?fileName=" + result.Data.fileName
|
else
|
wms.error(result.Msg);
|
}
|
});
|
},
|
selectTime: function (val) {
|
$this = this;
|
if (val != null)
|
$this.formData.valueDate = JSON.stringify(val);
|
else
|
$this.formData.valueDate = "";
|
},
|
pickerOptions2: function () {
|
shortcuts: [{
|
text: '最近一周',
|
onClick: function onClick(picker) {
|
var end = new Date();
|
var start = new Date();
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 7);
|
picker.$emit('pick', [start, end]);
|
}
|
}, {
|
text: '最近一个月',
|
onClick: function onClick(picker) {
|
var end = new Date();
|
var start = new Date();
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 30);
|
picker.$emit('pick', [start, end]);
|
}
|
}, {
|
text: '最近三个月',
|
onClick: function onClick(picker) {
|
var end = new Date();
|
var start = new Date();
|
start.setTime(start.getTime() - 3600 * 1000 * 24 * 90);
|
picker.$emit('pick', [start, end]);
|
}
|
}]
|
},
|
InitBuss: function (day) {
|
$this = this;
|
var dayTitle = new Array()
|
var inData = new Array();
|
var outData = new Array();
|
|
ajaxManage({
|
url: '@Url.Action("HistoryLine", "Inventory")',
|
data: $this.formData,
|
success: function (data) {
|
result = data.Data;
|
//var inQty = Enumerable.From(result).Where("x=>x.type=='IN'").GroupBy("$.CN_T_CREATE", null,
|
// function (key, g) {
|
// var result = {
|
// CN_T_CREATE: key,
|
// QTY: parseInt(g.Sum("x=>x.qty"))
|
// }
|
// return result;
|
// });
|
var inQty = result;
|
|
var date = new Date();
|
date.setDate(date.getDate() - day)
|
for (var i = day; i > 0; i--) {
|
date.setDate(date.getDate() + 1);
|
dayTitle[day - i] = (date.getDate());
|
|
var fullDate = date.getFullYear() + "-" + getFormatDate(date.getMonth() + 1) + "-" + getFormatDate(date.getDate());
|
var inobj = inQty.Where("x=>x.INTIME=='" + fullDate + "'").ToArray();
|
if (inobj == null || inobj.length == 0)
|
inData[day - i] = 0;
|
else
|
inData[day - i] = inobj[0].QTY;
|
}
|
// var outobj = outQty.Where("x=>x.CN_T_CREATE=='" + fullDate + "'").ToArray();
|
// if (outobj == null || outobj.length == 0)
|
// outData[day - i] = 0;
|
// else
|
// outData[day - i] = outobj[0].QTY;
|
//}
|
}
|
});
|
var myChart = echarts.init(document.getElementById('divBussLine'));
|
var option = {
|
title: {
|
},
|
tooltip: {
|
trigger: 'axis'
|
},
|
legend: {
|
data: ['入库', '出库']
|
},
|
grid: {
|
top: '10%',
|
left: '3%',
|
right: '4%',
|
bottom: '11%',
|
containLabel: true
|
},
|
toolbox: {
|
feature: {
|
saveAsImage: {}
|
}
|
},
|
xAxis: {
|
type: 'category',
|
boundaryGap: false,
|
//data: dayTitle//['周一', '周二', '周三', '周四', '周五', '周六', '周日']
|
},
|
yAxis: {
|
type: 'value'
|
},
|
series: [
|
//{
|
// name: '出库',
|
// type: 'line',
|
// data: outData
|
//},
|
{
|
name: '入库',
|
type: 'line',
|
data: inData
|
}
|
]
|
};
|
myChart.setOption(option);
|
},
|
tableRowClassName: function (data, rowIndex) {
|
if (data.row.type === '-') {
|
return 'warning-row';
|
} else if (data.row.type === '+') {
|
return 'success-row';
|
}
|
return '';
|
}
|
},
|
el: '#list'
|
});
|
|
function getFormatDate(arg) {
|
if (arg == undefined || arg == '') {
|
return '';
|
}
|
var re = arg + '';
|
if (re.length < 2) {
|
re = '0' + re;
|
}
|
return re;
|
}
|
</script>
|
}
|
