物料后端分页，采购销售选择源单控制

wtt

2024-09-13 516b7093c79f622f8514ff35d7df4bd57b947051

物料后端分页，采购销售选择源单控制

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_Material.html

@@ -175,6 +175,7 @@
                            <div>
                                <table class="" id="mainTable" lay-filter="mainTable"></table>
                            </div>
                            <div id="page"></div>
                        </div>
                    </div>
                </div>
@@ -206,11 +207,12 @@
            var Organization = sessionStorage["Organization"];
            var HModName = "Gy_Material";
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "HUnitID", "HParentID", "HUSEORGID", "HMinPickQty", "HEndFlag", "HStopFlag"];
            var titleData = ["HItemID", "HUnitID", "HParentID", "HUSEORGID", "HMinPickQty", "HEndFlag", "HStopFlag","选择"];

            var ins;                        //用于导出excel
            var HMaterTypeID = 0;              //物料分类节点id

            var page = 1;//分页数据
            var size = 50;
            //获取参数
            var params = getUrlVars();
            var openType = params[params[0]]; //从参数中获取 æ‰“开方式  1直接打开 2其它页面通过选择按钮打开
@@ -328,12 +330,7 @@

            //#region æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                if ($("#HProject").val() == "0") {
                    get_FastQuery();
                }
                else {
                    get_FastQuery(2);
                }
            });
            //#endregion

@@ -445,28 +442,9 @@
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 500
                    , page: true
                    , limits: [50, 500, 5000, 50000]
                    , limit: 50
                    //, cols: [[
                    //    { type: 'checkbox', fixed: 'left' }
                    //    , { field: 'HItemID', title: 'HItemID', sort: true, hide: true }
                    //    , { field: '物料代码', title: '物料代码' }
                    //    , { field: '物料名称', title: '物料名称' }
                    //    , { field: '规格型号', title: '规格型号' }
                    //    , { field: 'HUnitID', title: 'HUnitID', hide: true }
                    //    , { field: '计量单位代码', title: '计量单位代码' }
                    //    , { field: '计量单位名称', title: '计量单位名称' }
                    //    , { field: 'HMinPickQty', title: 'HMinPickQty', hide: true }
                    //    , { field: '明细标记', title: '明细标记' }
                    //    , { field: '禁用标记', title: '禁用标记' }
                    //    , { field: '组织名称', title: '组织名称' }
                    //    , { field: 'HEndFlag', title: 'HEndFlag', hide: true }
                    //    , { field: 'HStopFlag', title: 'HStopFlag', hide: true }
                    //    , { field: 'HParentID', title: 'HParentID', hide: true }
                    //    , { field: 'HUSEORGID', title: 'HUSEORGID', hide: true }
                    //]]
                    , height: 'full-80'
                    , page: false
                    , limit: 50 
                    , done: function (res, curr, count) {
                        var $data = $('div[lay-id="mainTable"]').find('.layui-table-body').find('tr').eq(0).find('td');
                        var $head = $('div[lay-id="mainTable"]').find('.layui-table-header').find('tr').eq(0).find('th');
@@ -484,6 +462,29 @@
                        }
                    }
                };
                optionPage = {
                    elem: 'page', //注意，这里的 page æ˜¯ ID，不用加 # å·
                    count: 10000, //数据总数，从服务端得到
                    limit: 50,
                    limits: [50, 500, 5000, 50000],
                    layout: ['count', 'prev', 'page', 'next', 'limit', 'skip'],
                    jump: function (obj, first) {
                        //console.log(obj)
                        //obj包含了当前分页的所有参数，比如：
                        //console.log(obj.curr); //得到当前页，以便向服务端请求对应页的数据。
                        //console.log(obj.limit); //得到每页显示的条数

                        //首次不执行
                        if (!first) {
                            //do something
                            console.log(obj)
                            page = obj.curr;
                            size = obj.limit;
                            get_FastQuery();
                        }
                    }
                }
                laypage.render(optionPage);
            }
            //#endregion

@@ -512,7 +513,7 @@
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": Organization},
                    success: function (data1) {
                        if (data1.count == 1) {
                        if (data1.count != 0) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -538,18 +539,9 @@
                                }
                            }

                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-80'
                                , page: true
                                , limits: [50, 500, 5000, 50000]
                                , limit: 50
                                , cellMinWidth: 90
                            }
                            
                            option.cols = [col];
                            option.data = data1.data;
                            ins = table.render(option);

                            //刷新表格数据
@@ -572,7 +564,69 @@
            }
            //#endregion

            //#region æŸ¥è¯¢
            function get_DisplayPage(sWhere) {
                var wait = layer.load();//遮罩
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Gy_Material/page',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": Organization, "page": page, "size": size },
                    success: function (data1) {
                        option.limit = size;//改变表格页大小
                        if (data1.count != 0) {
                            optionPage.count = data1.count;//改变列表数据总数
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 120 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 120 });
                                    }
                                }
                            }


                            option.cols = [col];
                            option.data = data1.data;
                            ins = table.render(option);
                            laypage.render(optionPage);
                            //刷新表格数据
                            DisPlay_HideColumn();

                            layer.close(ajaxLoad);
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                            }
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            option.data = [[]]
                            table.render(option);
                            layer.close(ajaxLoad);
                            /*layer.alert(data1.code + data1.Message, { icon: 5 });*/
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion


            //#region å¿«é€Ÿè¿‡æ»¤
@@ -590,40 +644,39 @@
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            com = "like''%" + ColContent + "%''";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            com = "like''%" + ColContent + "''";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            com = "like''" + ColContent + "%''";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            com = "not like''%" + ColContent + "%''";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            com = "" + Comparator + "''" + ColContent + "''";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (HNumber) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + HNumber + "%'";
                    sWhere += " and ç‰©æ–™ä»£ç  like ''%" + HNumber + "%''";
                }
                if (HName) {
                    sWhere += " and ç‰©æ–™åç§° like '%" + HName + "%'";
                    sWhere += " and ç‰©æ–™åç§° like ''%" + HName + "%''";
                }
                if (HModel) {
                    sWhere += " and è§„格型号 like '%" + HModel + "%'";
                    sWhere += " and è§„格型号 like ''%" + HModel + "%''";
                }
                if (HOrgName) {
                    sWhere += " and ç»„织名称 like '%" + HOrgName + "%'";
                    sWhere += " and ç»„织名称 like ''%" + HOrgName + "%''";
                }
                if (number==2) {
                    if (HProject) {
                        sWhere += " and é¡¹ç›®å· like '%" + HProject + "%'";
                    }
                if (HProject) {
                    sWhere += " and é¡¹ç›®å· like ''%" + HProject + "%''";
                }

                if (GetDataCols != "") {
                    sWhere += GetDataCols;
                }
@@ -631,7 +684,7 @@
                    sWhere += sql;
                }
                addSWhereByOpenType();
                get_Display(sWhere);
                get_DisplayPage(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
                GetDataCols = "";
            }
@@ -1015,10 +1068,10 @@
                            sql = "";
                            HMaterTypeID = 0;
                        } else {
                            sql = " and HMaterTypeID='" + data.id + "' ";
                            sql = " and HMaterTypeID=''" + data.id + "'' ";
                            HMaterTypeID = data.id;
                        }
                        get_Display(sql);
                        get_FastQuery()
                    }
                });
            }
@@ -1334,7 +1387,7 @@
                var openType = params[params[0]]; //从参数中获取 æ‰“开方式  1直接打开 2其它页面通过选择按钮打开
                var HOrgID = params[params[1]];
                if (openType == 2) {
                    sWhere += " and ç¦ç”¨æ ‡è®° = '' ";
                    sWhere += " and ç¦ç”¨æ ‡è®° = '''' ";
                    Organ(HOrgID);
                }
            }
@@ -1369,7 +1422,7 @@
                                    $("#" + data[i].过滤字段ID).find("option[value='" + data[i].过滤值 + "']").attr("selected", true);
                                }
                            }
                            get_FastQuery(2);
                            get_FastQuery();
                            form.render("select");
                        } else {
                            //当前用户没有设置默认的过滤方案
@@ -1377,7 +1430,7 @@
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            //执行查询方法
                            //查询
                            get_FastQuery(2);
                            get_FastQuery();
                            form.render("select");
                        }
                    }, error: function () {

 WebTM/views/²É¹º¹ÜÀí/¸¶¿îµ¥/YF_PayMentBill.html

@@ -980,6 +980,18 @@
                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');

                        }
                        var HSupID = checkStatus.data[0]["HSupID"];;//判断供应商
                        //if (HSupID == 0 || HSupID == '') {
                        //    HSupID = checkStatus.data[0]["HSupID"];
                        //}
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HSupID"] != HSupID) {
                                layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                                layer.close(index);//关闭弹窗
                                return;
                            }
                        }
                        setPayableBill(checkStatus);


 WebTM/views/²É¹º¹ÜÀí/Ó¦¸¶µ¥/Cg_PayableBill.html

@@ -1239,7 +1239,17 @@
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }

                        var HSupID = $("#HSupID").val();//判断供应商
                        if (HSupID == 0 || HSupID == '') {
                            HSupID = checkStatus.data[0]["HSupID"];
                        }
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HSupID"] != HSupID) {
                                layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                                layer.close(index);//关闭弹窗
                                return;
                            }
                        }
                        if ($("#BillType").val() == "1102") {
                            setInitByPOOrderBill(checkStatus);
                        }

 WebTM/views/²É¹º¹ÜÀí/ÊÕÁÏ֪ͨµ¥/Add_Edit_Cg_POInStockBillList.html

@@ -2164,10 +2164,19 @@
                        if (checkStatus.data.length == 0) {
                            return layer.msg("请至少选择一条数据!");
                        }
                        var HSupID = $("#HSupID").val();//判断供应商
                        if (HSupID == 0 || HSupID == '') {
                            HSupID = checkStatus.data[0]["HSupID"];
                        }
                        //layer.alert("你已选择" + checkStatus.data.length + "条数据");
                        //获取收料通知单代码
                        var ProcessNumber = [];
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HSupID"] != HSupID) {
                                layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                                layer.close(index);//关闭弹窗
                                return;
                            }
                            ProcessNumber.push(checkStatus.data[i]);
                        }


 WebTM/views/²É¹º¹ÜÀí/ÊÕÁÏ֪ͨµ¥/Cg_POInStockBillList.html

@@ -780,6 +780,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -810,6 +811,10 @@
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }

                    var datajson = {

 WebTM/views/²É¹º¹ÜÀí/²É¹º¶©µ¥/Cg_POOrderBillList.html

@@ -1054,6 +1054,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -1080,6 +1081,10 @@
                        }
                        if (data[i].业务员 != HEmpName) {
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }
@@ -1117,6 +1122,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -1143,6 +1149,10 @@
                        }
                        if (data[i].业务员 != HEmpName) {
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }
@@ -1179,6 +1189,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -1203,10 +1214,14 @@
                            layer.msg("下推失败!已经选中的记录中存在不同客户!");
                            return;
                        }
                        //if (data[i].业务员 != HEmpName) {
                        //    layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                        //    return;
                        //}
                        if (data[i].业务员 != HEmpName) {
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }

                    var datajson = {
@@ -1242,6 +1257,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -1270,6 +1286,10 @@
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }

                    var datajson = {

 WebTM/views/ÏúÊÛ¹ÜÀí/·¢»õ֪ͨµ¥/Add_Edit_Xs_SeOutStockBillList.html

@@ -805,9 +805,18 @@
                        if (checkStatus.data.length == 0) {
                            return layer.msg("请至少选择一条数据!");
                        }
                        var HCusID = $("#HCusID").val();//判断客户
                        if (HCusID == 0 || HCusID == '') {
                            HCusID = checkStatus.data[0]["HCusID"];
                        }
                        //获取销售订单代码
                        var ProcessNumber = [];
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HCusID"] != HCusID) {
                                layer.msg("下推失败!已经选中的记录中存在不同客户!");
                                layer.close(index);
                                return;
                            }
                            ProcessNumber.push(checkStatus.data[i]);
                        }
                        for (var i = 0; i < ProcessNumber.length; i++) {

 WebTM/views/ÏúÊÛ¹ÜÀí/Ó¦ÊÕµ¥/Xs_ReceivableBill.html

@@ -1590,7 +1590,17 @@
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }

                        var HCusID = $("#HCusID").val();//判断客户
                        if (HCusID == 0 || HCusID == '') {
                            HCusID = checkStatus.data[0]["HCusID"];
                        }
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HCusID"] != HCusID) {
                                layer.msg("下推失败!已经选中的记录中存在不同客户!");
                                layer.close(index);
                                return;
                            }
                        }
                        if ($("#BillType").val() == "1401") {
                            setInitBySeOrderBill(checkStatus);
                        }

 WebTM/views/ÏúÊÛ¹ÜÀí/ÊÕ¿îµ¥/YS_ReceiveBill.html

@@ -1161,6 +1161,17 @@
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }
                        var HCusID = $("#HCusID").val();//判断客户
                        if (HCusID == 0 || HCusID == '') {
                            HCusID = checkStatus.data[0]["HCusID"];
                        }
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HCusID"] != HCusID) {
                                layer.msg("下推失败!已经选中的记录中存在不同客户!");
                                layer.close(index);
                                return;
                            }
                        }
                        setReceivableBill(checkStatus);

                        layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的

 WebTM/views/ÁìÁÏ·¢»õ/ÏúÊÛ³ö¿â/Kf_SellOutBill.html

@@ -1874,7 +1874,17 @@
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }
                        
                        var HCusID = $("#HCusID").val();//判断客户
                        if (HCusID == 0 || HCusID == '') {
                            HCusID = checkStatus.data[0]["HCusID"];
                        }
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HCusID"] != HCusID) {
                                layer.msg("下推失败!已经选中的记录中存在不同客户!");
                                layer.close(index);
                                return;
                            }
                        }
                        if ($("#BillType").val() == "1401") {
                            setInitBySeOrderBill(checkStatus);
                        } else if ($("#BillType").val() == "1402") {

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Add_Edit_Kf_POStockInBillList.html

@@ -2256,10 +2256,18 @@
                        if (checkStatus.data.length == 0) {
                            return layer.msg("请至少选择一条数据!");
                        }
                      
                        var HSupID = $("#HSupID").val();//判断供应商
                        if (HSupID == 0 || HSupID == '') {
                            HSupID = checkStatus.data[0]["HSupID"];
                        }
                        //获取收料通知单代码
                        var ProcessNumber = [];
                        for (var i = 0; i < checkStatus.data.length; i++) {
                            if (checkStatus.data[i]["HSupID"] != HSupID) {
                                layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                                layer.close(index);//关闭弹窗
                                return;
                            }
                            ProcessNumber.push(checkStatus.data[i]);
                        }


 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Kf_POStockInBillList.html

@@ -937,6 +937,7 @@
                    var dataArray = [];
                    var HCusName = data[0].客户;
                    var HEmpName = data[0].业务员;
                    var HSupName = data[0].供应商;
                    for (var i = 0; i < data.length; i++) {
                        var temp = {
                            "hmainid": data[i].hmainid
@@ -961,10 +962,14 @@
                            layer.msg("下推失败!已经选中的记录中存在不同客户!");
                            return;
                        }
                        //if (data[i].业务员 != HEmpName) {
                        //    layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                        //    return;
                        //}
                        if (data[i].业务员 != HEmpName) {
                            layer.msg("下推失败!已经选中的记录中存在不同业务员!");
                            return;
                        }
                        if (data[i].供应商 != HSupName) {
                            layer.msg("下推失败!已经选中的记录中存在不同供应商!");
                            return;
                        }
                    }

                    var datajson = {