WEBUI/WMS.BZWeb/Areas/SXManager/Views/Inventorys/Index.js

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["Tunnel"] = $("#Tunnel").val();
                queryJson["Code"] = $("#Code").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["IsTimeOut"] = $("#IsTimeOut").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/Inventorys/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["Tunnel"] = $("#Tunnel").val();
                query["Code"] = $("#Code").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["IsTimeOut"] = $("#IsTimeOut").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/Inventorys/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/Inventorys/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 '<span class=\"label label-success\"  >启用</span>';
                            } else {
                                return '<span class=\"label  label-default\" >禁用</span>';
                            }
                        }
                    },
                    { 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 '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
},
                    {
                        label: "是否需要扭转", name: "IsTorsChk", width: 90, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        } },
                    {
                        label: "是否芯股", name: "IsCore", width: 90, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        } },

                    { 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 '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "是否黑盘", name: "IsBlack", width: 80, align: "left"
                        , formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "返工标记", name: "IsRework", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "快投标记", name: "IsFast", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "是否异常", name: "IsFail", width: 80, align: "left", formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    {
                        label: "是否锁定", name: "ExecStateCode", width: 80, align: "left"
                        , formatter: function (cellvalue) {
                            if (cellvalue == "InvState_Normal") {
                                return '<span class=\"label label-default\"  >否</span>';
                            } else {
                                return '<span class=\"label  label-success\" >是</span>';
                            }
                        }
                    },
                    {
                        label: "是否已扭转", name: "TorsChkQty", width: 80, align: "left"
                        , formatter: function (cellvalue) {
                            if (cellvalue == true) {
                                return '<span class=\"label label-success\"  >是</span>';
                            } else {
                                return '<span class=\"label  label-default\" >否</span>';
                            }
                        }
                    },
                    { 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();
}