var refreshGirdData;
var OneInTimebegin = '';
var OneInTimeend = '';
var ProductTimebegin = '';
var ProductTimeend = '';
var logbegin = '';
var logend = '';
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 oneintime = $('#lr_search_date_OneInTime').html();
if (oneintime == '') {
OneInTimebegin = '';
OneInTimeend = '';
}
var producttime = $('#lr_search_date_ProductTime').html();
if (producttime == '') {
ProductTimebegin = '';
ProductTimeend = '';
}
console.log(queryJson);
queryJson["MatCode"] = $("#MatCode").val();
queryJson["MatName"] = $("#MatName").val();
queryJson["BoxBarCode"] = $("#BoxBarCode").val();
queryJson["InvBarCode"] = $("#InvBarCode").val();
queryJson["PutRow"] = $("#PutRow").val();
queryJson["PutCol"] = $("#PutCol").val();
queryJson["PutLayer"] = $("#PutLayer").val();
queryJson["OneInTimeBegin"] = $("#OneInTimebegin").val();
queryJson["OneInTimeEnd"] = $("#OneInTimeend").val();
queryJson["ProductTimeBegin"] = $("#ProductTimebegin").val();
queryJson["ProductTimeEnd"] = $("#ProductTimeend").val();
queryJson["Grade"] = $("#Grade").val();
queryJson["DoseNo"] = $("#DoseNo").val();
queryJson["ContGrpType"] = $("#ContGrpType").lrselectGet();
queryJson["InvStateCode"] = $("#InvStateCode").lrselectGet();
queryJson["IsSurplus"] = $("#IsSurplus").lrselectGet();
queryJson["IsRework"] = $("#IsRework").lrselectGet();
queryJson["IsFast"] = $("#IsFast").lrselectGet();
queryJson["IsFail"] = $("#IsFail").lrselectGet();
queryJson["IsBlack"] = $("#IsBlack").lrselectGet();
queryJson["ExecStateCode"] = $("#ExecStateCode").lrselectGet();
queryJson["WbGroupCode"] = $("#WbGroupCode").val();
queryJson["SolderCount"] = $("#SolderCount").val();
queryJson["HoldTime"] = $("#HoldTime").val();
queryJson["IsControlpanel"] = $("#IsControlpanel").lrselectGet();
queryJson["IsTorsChk"] = $("#IsTorsChk").lrselectGet();
queryJson["IsCore"] = $("#IsCore").lrselectGet();
queryJson["TorsChkQty"] = $("#TorsChkQty").lrselectGet();
queryJson["Wind"] = $("#Wind").val();
page.search({ queryJson: JSON.stringify(queryJson) });
}, 250);
// 查询
$('#btn_Search').on('click', function () {
var keyword = $('#txt_Keyword').val();
page.search({ queryJson: JSON.stringify({ keyword: keyword }) });
});
// 刷新
$('#lr_refresh').on('click', function () {
location.reload();
});
//$('#lr_pass').on('click', function () {
// var postData = $('#gridtable').jfGridGet("rowdata");
// if (postData.length == 0) {
// learun.alert.error('未选择行!');
// return false;
// }
// learun.layerConfirm('是否确认放行该箱号!', function (res) {
// if (res) {
// learun.postForm(top.$.rootUrl + '/SXManager/BillInvflowHistory/UpdatePassStates', { ids: JSON.stringify(postData.map((item) => item.Id)) }, function () {
// refreshGirdData();
// });
// }
// });
//});
// 导出数据
$('#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 query = $('#multiple_condition_query').lrGetFormData();
// query["Btime"] = logbegin;
// query["Etime"] = logend;
// query["keyword"] = $('#txt_Keyword').val();
// var queryJson = JSON.stringify(query);
// if ($('#jfgrid_head_' + psuid).length == 0) {
// learun.alert.warning('请任意展开一行子表');
// return false;
// }
// learun.layerForm({
// id: "ExcelExportColumn",
// title: '导出Excel数据',
// url: top.$.rootUrl + '/Utility/ExcelExportColumn?gridId=' + $('#gridtable').attr('id') + '&subgridId=' + psuid,
// width: 600,
// height: 480,
// callBack: function (id) {
// return top[id].acceptClick(function (data) {
// learun.download({
// method: "POST",
// url: top.$.rootUrl + '/TaskManager/EquipmentTask_Dis/ExportExcel',
// param: {
// fileName: encodeURI("WCS历史任务"),
// queryJson: queryJson,
// exportField: JSON.stringify(data)
// }
// });
// });
// },
// btn: ['导出Excel', '关闭']
// });
//});
//导出
$('#lr_exportall').on('click', function () {
//var where = $("#queryWhere").val();
var query = $('#multiple_condition_query').lrGetFormData();
query["MatCode"] = $("#MatCode").val();
query["MatName"] = $("#MatName").val();
query["BoxBarCode"] = $("#BoxBarCode").val();
query["InvBarCode"] = $("#InvBarCode").val();
query["PutRow"] = $("#PutRow").val();
query["PutCol"] = $("#PutCol").val();
query["PutLayer"] = $("#PutLayer").val();
query["OneInTimeBegin"] = $("#OneInTimebegin").val();
query["OneInTimeEnd"] = $("#OneInTimeend").val();
query["ProductTimeBegin"] = $("#ProductTimebegin").val();
query["ProductTimeEnd"] = $("#ProductTimeend").val();
query["Grade"] = $("#Grade").val();
query["DoseNo"] = $("#DoseNo").val();
query["ContGrpType"] = $("#ContGrpType").lrselectGet();
query["InvStateCode"] = $("#InvStateCode").lrselectGet();
query["IsSurplus"] = $("#IsSurplus").lrselectGet();
query["IsRework"] = $("#IsRework").lrselectGet();
query["IsFast"] = $("#IsFast").lrselectGet();
query["IsFail"] = $("#IsFail").lrselectGet();
query["IsBlack"] = $("#IsBlack").lrselectGet();
query["ExecStateCode"] = $("#ExecStateCode").lrselectGet();
query["WbGroupCode"] = $("#WbGroupCode").val();
query["SolderCount"] = $("#SolderCount").val();
query["HoldTime"] = $("#HoldTime").val();
query["IsControlpanel"] = $("#IsControlpanel").lrselectGet();
query["IsTorsChk"] = $("#IsTorsChk").lrselectGet();
query["IsCore"] = $("#IsCore").lrselectGet();
query["TorsChkQty"] = $("#TorsChkQty").lrselectGet();
query["Wind"] = $("#Wind").val();
query["keyword"] = $('#txt_Keyword').val();
var queryJson = JSON.stringify(query);
learun.layerForm({
id: "ExcelExportForm",
title: '导出Excel数据',
// 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: '/SXManager/BillInvflowHistory/ExportExcel',
param: {
fileName: "导出流水历史报表",
queryJson: queryJson,
exportField: JSON.stringify(data)
}
});
});
},
btn: ['导出Excel', '关闭']
});
});
$('#OneInTime').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) {
OneInTimebegin = begin;
OneInTimeend = end;
}
});
$('#ProductTime').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) {
ProductTimebegin = begin;
ProductTimeend = end;
}
});
$('#ContGrpType').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/GetContGrpTypeList',
maxHeight: 180,
allowSearch: false
});
$('#InvStateCode').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/GetInvStateList',
maxHeight: 180,
allowSearch: false
});
$('#ExecStateCode').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/InvLockStateList',
maxHeight: 60,
allowSearch: false
});
$('#IsSurplus').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsRework').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsFast').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsFail').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsBlack').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsControlpanel').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsTorsChk').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsCore').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#IsTimeOut').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
$('#TorsChkQty').lrselect({
url: top.$.rootUrl + '/SXManager/Enums/YesNoList',
maxHeight: 60,
allowSearch: false
});
},
// 初始化列表
initGird: function () {
$('#gridtable').jfGrid({
url: top.$.rootUrl + '/SXManager/BillInvflowHistory/GetPageList',
headData: [
{ label: "容器条码", name: "ContGrpBarCode", width: 130, align: "left" },
{
label: "库存类型", name: "ContGrpTypeName", width: 60, align: "left", sortname: "ContGrpType"
},
{ label: "材料号", name: "InvBarCode", width: 110, align: "left" },
{ label: "库存状态", name: "InvStateName", width: 80, align: "left", sortname: "InvStateCode" },
//{ label: "巷道", name: "Tunnel", width: 50, align: "left" },
//{ label: "货位号", name: "Code", width: 100, align: "left" },
//{
// label: "货位状态", name: "CellState", width: 80, align: "left"
// , formatter: function (cellvalue) {
// if (cellvalue == 0) {
// return '启用';
// } else {
// return '禁用';
// }
// }
//},
{ label: "箱号", name: "BoxBarCode", width: 120, align: "left" },
{ label: "SKU", name: "SkuCode", width: 80, align: "left" },
{ label: "机台组", name: "WbGroupCode", width: 80, align: "left" },
{ label: "工字轮类型", name: "HWTypeCode", width: 90, align: "left" },
{ label: "焊点数量", name: "SolderCount", width: 90, align: "left" },
{ label: "静止时长", name: "HoldTime", width: 90, align: "left" },
{
label: "是否控制盘", name: "IsControlpanel", width: 90, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
label: "是否需要扭转", name: "IsTorsChk", width: 90, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
} },
{
label: "是否芯股", name: "IsCore", width: 90, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
} },
{ label: "预锁单号", name: "SalesDoc", width: 120, align: "left" },
{ label: "行", name: "PutRow", width: 40, align: "left" },
{ label: "列", name: "PutCol", width: 40, align: "left" },
{ label: "层", name: "PutLayer", width: 40, align: "left" },
{ label: "首次入库时间", name: "OneInTime", width: 130, align: "left" },
learun.jfFormatter.col_DateTime("生产时间", "ProductTime"),
{ label: "物料编码", name: "MatCode", width: 110, align: "left" },
{ label: "物料名称", name: "MatName", 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: "LengthQty", width: 80, align: "left" },
{
label: "是否余料", name: "IsSurplus", width: 80, align: "left"
, formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
label: "是否黑盘", name: "IsBlack", width: 80, align: "left"
, formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
label: "返工标记", name: "IsRework", width: 80, align: "left", formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{
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: "ExecStateCode", width: 80, align: "left"
, formatter: function (cellvalue) {
if (cellvalue == "InvState_Normal") {
return '否';
} else {
return '是';
}
}
},
{
label: "是否已扭转", name: "TorsChkQty", width: 80, align: "left"
, formatter: function (cellvalue) {
if (cellvalue == true) {
return '是';
} else {
return '否';
}
}
},
{ label: "预锁库存", name: "PreStock", width: 120, align: "left" },
{ label: "绕向", name: "Wind", width: 120, align: "left" },
{ label: "异常原因", name: "FailReason", width: 80, align: "left" },
{ label: "等级", name: "Grade", width: 80, align: "left" },
{ label: "退料原因", name: "BackReason", width: 80, align: "left" },
{ label: "工序订单号", name: "ProcessDocsCode", width: 120, align: "left" },
{ label: "生产机台号", name: "ProductMachCode", width: 80, align: "left" },
{ label: "产线编号", name: "ProductLineNo", width: 80, align: "left" },
{ label: "入库单号", name: "InDocsNo", width: 120, align: "left" },
{ label: "入库单行号", name: "InDocsRowNo", width: 120, align: "left" },
{ label: "扭转检测弓高", name: "TorsChkChord", width: 80, align: "left" },
{ label: "弓高是否合格", name: "TorsChkChordIsGood", width: 80, align: "left" },
{ label: "扭转检测平直度", name: "TorsChkFlatness", width: 80, align: "left" },
{ label: "平直度是否合格", name: "TorsChkFlatnessIsGood", width: 80, align: "left" },
{ label: "扭转机台工位", name: "TorsChkStation", width: 80, align: "left" },
{ label: "扭转值是否合格", name: "TorsChkValueIsGood", width: 80, align: "left" },
{ label: "创建时间", name: "AddTime", width: 130, align: "left" },
{ label: "更新时间", name: "EditTime", width: 130, 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();
}