var refreshGirdData;
var OneInTimebegin = '';
var OneInTimeend = '';
var ProductTimebegin = '';
var ProductTimeend = '';
var logbegin = '';
var logend = '';
var StartTimeBegin = '';
var StartTimeend = '';
var EndTimeBegin = '';
var EndTimeend = '';
var bootstrap = function ($, learun) {
var psuid = "";
"use strict";
var page = {
init: function () {
page.initGird();
page.bind();
},
bind: function () {
$('#multiple_condition_query').lrMultipleQuery(function (queryJson) {
// 调用后台查询
// queryJson 查询条件
var starttime = $('#lr_search_date_StartTime').html();
if (starttime == '') {
StartTimeBegin = '';
StartTimeend = '';
}
var endtime = $('#lr_search_date_EndTime').html();
if (endtime == '') {
EndTimeBegin = '';
EndTimeend = '';
}
console.log(queryJson);
queryJson["AddTimeFrom"] = logbegin;
queryJson["AddTimeTo"] = logend;
queryJson["ContGrpBarCode"] = $("#ContGrpBarCode").val();
queryJson["MatCode"] = $("#MatCode").val();
queryJson["RFIDBarCode"] = $("#RFIDBarCode").val();
queryJson["MatName"] = $("#MatName").val();
queryJson["CellCode"] = $("#CellCode").val();
queryJson["Tunnel"] = $("#Tunnel").val();
queryJson["InvBarCode"] = $("#InvBarCode").val();
queryJson["StartTimeBegin"] = StartTimeBegin;
queryJson["StartTimeEnd"] = StartTimeend;
queryJson["EndTimeBegin"] = EndTimeBegin;
queryJson["EndTimeEnd"] = EndTimeend;
queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet();
queryJson["IsRework"] = $("#IsRework").lrselectGet();
queryJson["IsFast"] = $("#IsFast").lrselectGet();
queryJson["IsFail"] = $("#IsFail").lrselectGet();
queryJson["IsBack"] = $("#IsBack").lrselectGet();
page.search({ queryJson: JSON.stringify(queryJson) });
}, 250);
// 查询
$('#btn_Search').on('click', function () {
var keyword = $('#txt_Keyword').val();
page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
});
// 刷新
$('#lr_refresh').on('click', function () {
location.reload();
});
$('.datetime').each(function () {
$(this).lrdatetime({
dfdata: [
{ name: '今天', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00') }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
{ name: '近7天', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'd', -6) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
{ name: '近1个月', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'm', -1) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
{ name: '近3个月', begin: function () { return learun.getDate('yyyy-MM-dd 00:00:00', 'm', -3) }, end: function () { return learun.getDate('yyyy-MM-dd 23:59:59') } },
],
// 月
mShow: false,
premShow: false,
// 季度
jShow: false,
prejShow: false,
// 年
ysShow: false,
yxShow: false,
preyShow: false,
yShow: false,
// 默认
dfvalue: 'all',
selectfn: function (begin, end) {
let id = $(this).attr('id');
if (id == 'datesearch') {
logbegin = begin;
logend = end;
}
else if (id == 'StartTime') {
StartTimeBegin = begin;
StartTimeend = end;
}
else if (id == 'EndTime') {
EndTimeBegin = begin;
EndTimeend = end;
}
}
});
});
$('#ContGrpType').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/GetContGrpTypeList',
maxHeight: 180,
allowSearch: false
});
$('#InvStateCode').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/GetInvStateList',
maxHeight: 180,
allowSearch: false
});
$('#WarehouseId').lrselect({
url: top.$.rootUrl + '/FJManager/BaseWarehouse/GetSelectWarehouseNameListByType?typenum=1',
maxHeight: 180,
allowSearch: false
});
$('#IsSurplus').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsRework').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsFast').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsFail').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsBack').lrselect({
url: top.$.rootUrl + '/FJManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
// 导出数据
$('#lr_exportnow').on('click', function () {
var subsuid = "";
if (psuid == "") {
psuid = $('#gridtable').attr('id');
}
else if (psuid != "") {
var t = $('#' + psuid).attr('id');
if (t == undefined)
psuid = $('#gridtable').attr('id');
}
var mainGridId = $('#gridtable').attr('id');
learun.layerForm({
id: "ExcelExportForm",
title: '导出Excel数据',
url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("导出物料出入库报表")),
width: 500,
height: 380,
callBack: function (id) {
return top[id].acceptClick();
},
btn: ['导出Excel', '关闭']
});
});
$('#lr_exportall').on('click', function () {
//var where = $("#queryWhere").val();
var queryJson = $('#multiple_condition_query').lrGetFormData();
queryJson["AddTimeFrom"] = logbegin;
queryJson["AddTimeTo"] = logend;
queryJson["ContGrpBarCode"] = $("#ContGrpBarCode").val();
queryJson["MatCode"] = $("#MatCode").val();
queryJson["RFIDBarCode"] = $("#RFIDBarCode").val();
queryJson["MatName"] = $("#MatName").val();
queryJson["CellCode"] = $("#CellCode").val();
queryJson["Tunnel"] = $("#Tunnel").val();
queryJson["InvBarCode"] = $("#InvBarCode").val();
queryJson["StartTimeBegin"] = StartTimeBegin;
queryJson["StartTimeEnd"] = StartTimeend;
queryJson["EndTimeBegin"] = EndTimeBegin;
queryJson["EndTimeEnd"] = EndTimeend;
queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet();
queryJson["IsRework"] = $("#IsRework").lrselectGet();
queryJson["IsFast"] = $("#IsFast").lrselectGet();
queryJson["IsFail"] = $("#IsFail").lrselectGet();
queryJson["IsBack"] = $("#IsBack").lrselectGet();
queryJson["keyword"] = $('#txt_Keyword').val();
var query = JSON.stringify(queryJson);
learun.layerForm({
id: "ExcelExportForm",
title: '导出物料出入库报表',
// url: top.$.rootUrl + '/Utility/ExcelExportForm?mainGridId=' + mainGridId + '&gridId=' + psuid + '&filename=' + encodeURI(encodeURI("库存")),
url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=',
width: 500,
height: 380,
callBack: function (id) {
return top[id].acceptClick(function (data) {
learun.download({
method: "POST",
url: '/FJManager/report/ExportExcel',
param: {
fileName: "导出物料出入库报表",
queryJson: query,
exportField: JSON.stringify(data)
}
});
});
},
btn: ['导出Excel', '关闭']
});
});
},
// 初始化列表
initGird: function () {
$('#gridtable').jfGrid({
url: top.$.rootUrl + '/FJManager/Report/GetPageList',
headData: [
{ label: "仓库", name: "WarehouseName", width: 110, align: "left" },
{ label: "容器条码", name: "ContGrpBarCode", width: 120, align: "left" },
{ label: "操作状态", name: "InvStateName", width: 80, align: "left", sortname: "InvStateCode" },
{ label: "材料号", name: "InvBarCode", width: 110, align: "left" },
{ label: "货位号", name: "Code", width: 110, align: "left" },
{ label: "巷道号", name: "Tunnel", width: 80, align: "left" },
{ label: "物料编码", name: "MatCode", width: 120, align: "left" },
{ label: "物料名称", name: "MatName", width: 120, align: "left" },
{ label: "备注", name: "Memo", width: 130, align: "left" },
{ label: "RFID条码", name: "RFIDBarCode", width: 120, align: "left" },
{
label: "库存状态", name: "ExecStateCode", width: 80, align: "left", formatter: function (cellvalue) {
if (cellvalue == "InvState_Normal") {
return '正常';
}
if (cellvalue == "InvState_Lock") {
return '锁定';
}
}
},
{ label: "长度", name: "LengthQty", width: 80, align: "left" },
{ label: "生产时间", name: "ProductTime", width: 130, align: "left" },
{ label: "创建时间", name: "AddTime", width: 130, align: "left" },
{ label: "修改时间", name: "EditTime", width: 130, align: "left" },
{ label: "开始时间", name: "StartTime", width: 130, align: "left" },
{ label: "结束时间", name: "EndTime", width: 130, align: "left" },
{
label: "快投标记", name: "IsFast", width: 80, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
label: "是否异常", name: "IsFail", width: 80, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
label: "是否退料", name: "IsBack", width: 80, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{ label: "异常原因", name: "FailReason", width: 80, align: "left" },
{ label: "退料原因", name: "BackReason", width: 80, align: "left" },
{ label: "客户编码", name: "CustCode", width: 80, align: "left" },
{ label: "客户名称", name: "CustName", width: 80, align: "left" },
{ label: "执行单据号", name: "ExecDocsNo", width: 80, align: "left" },
{ label: "执行单据行号", name: "ExecDocsRowNo", width: 80, align: "left" },
{ label: "执行单据类型", name: "ExecDocsTypeCode", width: 80, align: "left" },
{ label: "入库单据号", name: "InDocsNo", width: 80, align: "left" },
{ label: "生产机台号", name: "ProductMachCode", width: 80, align: "left" },
{ label: "总重量", name: "TolWQty", width: 80, align: "left" },
{ label: "净量", name: "NetWQty", width: 80, align: "left" },
{ label: "皮重", name: "TareWQty", width: 80, align: "left" },
{ label: "供应商编码", name: "SuppCode", width: 80, align: "left" },
{ label: "供应商名称", name: "SuppName", width: 80, align: "left" },
],
mainId: 'Id',
isPage: true,
reloadSelected: true,
autowWidth: true,
sidx: 'AddTime',
sord: 'DESC',
});
page.search({ queryJson: JSON.stringify({ keyword: $('#txt_Keyword').val() }) });
},
search: function (param) {
$('#gridtable').jfGridSet('reload', param);
}
};
refreshGirdData = function () {
$('#gridtable').jfGridSet('reload');
};
page.init();
}