销售订单：下查增加销售出库单

duhe

2023-12-11 62e3d56e1394385b1f6a5326459a694230c53170

 WebTM/views/ÏúÊÛ¹ÜÀí/ÏúÊÛ¶©µ¥/Xs_SeOrderBill_LookDown.html

@@ -26,6 +26,7 @@
                            <li lay-id="0" style="padding:1px;width:120px;" class="layui-this">销售订单变更单</li>
                            <li lay-id="1" style="padding:1px;">生产订单</li>
                            <li lay-id="2" style="padding:1px;">特批申请单</li>
                            <li lay-id="2" style="padding:1px;">销售出库单</li>
                        </ul>
                        <div class="layui-tab-content">
                            <!--销售订单变更单-->
@@ -52,6 +53,15 @@
                                <script type="text/html" id="toolbarDemo2">
                                    <div class="layui-btn-container">
                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn2"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                    </div>
                                </script>
                            </div>
                            <!--销售出库单-->
                            <div class="layui-tab-item">
                                <table class="layui-hide" id="mainTable3" lay-filter="mainTable3"></table>
                                <script type="text/html" id="toolbarDemo3">
                                    <div class="layui-btn-container">
                                        <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn3"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                    </div>
                                </script>
                            </div>
@@ -86,11 +96,13 @@
        var option0 = {};
        var option1 = {};
        var option2 = {};
        var option3 = {};

        //子表不需要显示的字段
        var titleData0 = ["hmainid","HMainSourceInterID","HMainSourceEntryID","HDeptID","HEmpID","HCurID","HCusID","HSSID","HSellSID","HOrgID","HMaterID","HUnitID","HSourceInterID","HSourceEntryID","HSourceBillNo","HSourceBillType"];
        var titleData1 = ["hmainid", "HEntryID", "HEmpID", "HBomID", "HRoutingInterID", "HPRDORGID", "hsubid", "HMaterID", "HUnitID", "HAuxPropID", "HDeptID", "HEntryCusID", "HCenterID", "HSourceID", "HSourceID_b", "HSourceName", "HBillStatus", "HAuxQty", "HAuxUnit", "HAuxUnitName", "HWidth", "HWeight", "HIsStockQty", "HCusID", "HSourceInterID", "HSourceEntryID", "HSourceBillNo", "HSourceBillType"];
        var titleData2 = ["hmainid", "HMainSourceInterID", "HMainSourceEntryID", "HDeptID", "HEmpID", "HCurID","HCusID","HManagerID","HOrgID"];
        var titleData2 = ["hmainid", "HMainSourceInterID", "HMainSourceEntryID", "HDeptID", "HEmpID", "HCurID", "HCusID", "HManagerID", "HOrgID"];
        var titleData3 = ["hmainid" ,"红蓝单标记","发货人","保管员", "hsupid", "HEmpID", "hmanagerid", "hsecmanagerid", "hkeeperid", "HDeptID", "hsubid", "hmaterid","hunitid"];
        
        //#endregion

@@ -139,6 +151,17 @@
                //列设置
                case 'set_HideColumn2':
                    get_HideColumn2();
                    break;
            }
        });
        //#endregion

        //#region å­è¡¨3：头工具栏事件
        table.on('toolbar(mainTable3)', function (obj) {
            switch (obj.event) {
                //列设置
                case 'set_HideColumn3':
                    get_HideColumn3();
                    break;
            }
        });
@@ -339,6 +362,59 @@
                //, limit: 50
                //, limits: [50, 500, 5000, 20000]
            };

            //动态显示列名
            option3 = {
                elem: '#mainTable3'
                , toolbar: '#toolbarDemo3'
                , height: 550
                //, page: true
                , cellMinWidth: 90
                //, limit: 50
                //, limits: [50, 500, 5000, 20000]
                , cols: [[
                    , { field: 'hmainid', title: 'hmainid', sort: true, hide: true }
                    , { field: '日期', title: '日期', width: 160, templet: "<div>{{d.日期 ==null ?'':layui.util.toDateString(d.日期, 'yyyy-MM-dd')}}</div>", sort: true }
                    , { field: '单据号', title: '单据号', width: 160, sort: true }
                    , { field: '状态', title: '状态', width: 160, sort: true }
                    , { field: '红蓝单标记', title: '红蓝单标记', width: 160, sort: true }
                    , { field: 'hsupid', title: 'hsupid', width: 200, hide: true, sort: true }
                    , { field: '客户', title: '客户', width: 200, sort: true }
                    , { field: 'HEmpID', title: 'HEmpID', width: 200, hide: true, sort: true }
                    , { field: '业务员', title: '业务员', width: 200, sort: true }
                    , { field: 'hmanagerid', title: 'hmanagerid', width: 200, hide: true, sort: true }
                    , { field: '主管', title: '主管', width: 200, sort: true }
                    , { field: 'hsecmanagerid', title: 'hsecmanagerid', width: 160, hide: true, sort: true }
                    , { field: '发货人', title: '发货人', width: 160, hide: true, sort: true }
                    , { field: 'hkeeperid', title: 'hkeeperid', width: 160, hide: true, sort: true }
                    , { field: '保管员', title: '保管员', width: 200, hide: true, sort: true }
                    , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true, sort: true }
                    , { field: '部门', title: '部门', width: 200, sort: true }
                    , { field: '销售方式', title: '销售方式', width: 200, hide: true, sort: true }
                    , { field: 'hsubid', title: 'hsubid', width: 200, hide: true, sort: true }
                    , { field: 'hmaterid', title: 'hmaterid', width: 200, hide: true, sort: true }
                    , { field: '物料代码', title: '物料代码', width: 200, sort: true }
                    , { field: '物料名称', title: '物料名称', width: 115, sort: true }
                    , { field: '规格型号', title: '规格型号', width: 115, sort: true }
                    , { field: 'hunitid', title: 'hunitid', width: 200, hide: true, sort: true }
                    , { field: '计量单位代码', title: '计量单位代码', width: 200, sort: true }
                    , { field: '计量单位', title: '计量单位', width: 115, sort: true }
                    , { field: '数量', title: '数量', totalRow: true, width: 200, sort: true }
                    , { field: '单价', title: '单价', width: 200, sort: true }
                    , { field: '金额', title: '金额', totalRow: true, width: 200, sort: true }
                    , { field: '制单人', title: '制单人', width: 125, sort: true }
                    , { field: '制单日期', title: '制单日期', width: 200, templet: "<div>{{d.制单日期 ==null ?'':layui.util.toDateString(d.制单日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
                    , { field: '审核人', title: '审核人', width: 125, sort: true }
                    , { field: '审核日期', title: '审核日期', width: 200, templet: "<div>{{d.审核日期 ==null ? '':layui.util.toDateString(d.审核日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
                    , { field: '修改人', title: '修改人', width: 125, sort: true }
                    , { field: '修改日期', title: '修改日期', width: 200, templet: "<div>{{d.修改日期 ==null ?'':layui.util.toDateString(d.修改日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
                    , { field: '关闭人', title: '关闭人', width: 125, sort: true }
                    , { field: '关闭日期', title: '关闭日期', width: 200, templet: "<div>{{d.关闭日期 ==null ?'':layui.util.toDateString(d.关闭日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }
                    , { field: '作废人', title: '作废人', width: 125, sort: true }
                    , { field: '作废日期', title: '作废日期', width: 200, templet: "<div>{{d.作废日期 ==null ?'':layui.util.toDateString(d.作废日期, 'yyyy-MM-dd HH:mm:ss')}}</div>", sort: true }

                ]]
            };
        }
        //#endregion

@@ -372,8 +448,14 @@
                        };
                        setInit_mainTable2(table2);

                        
                        //渲染表3
                        var table3 = {
                            "data": data1.data[3]
                            , "list": data1.list[3]
                        };
                        setInit_mainTable3(table3);

                        
                        layer.close(ajaxLoad);
                    } else {
                        layer.close(ajaxLoad);
@@ -514,6 +596,49 @@

            //刷新表格数据
            DisPlay_HideColumn2();
        }
        //#endregion

        //#region æ¸²æŸ“表3
        function setInit_mainTable3(data1) {
            //需要设置合计行的列
            var totalArray = [];

            //整理子表的列
            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, titleData3) > -1) {
                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                }
                else if ($.inArray(data[i].name, totalArray) > -1) {
                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                } 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 });
                    }
                }
            }

            //设置子表渲染参数的列集合和数据并渲染
            //option1.cols = [col];
            option3.data = data1.data;
            table.render(option3);

            //刷新表格数据
            DisPlay_HideColumn3();
        }
        //#endregion

@@ -871,6 +996,124 @@
        }
        //#endregion

        //#region å­è¡¨3：隐藏列设置
        function get_HideColumn3() {
            HModName = "Xs_SeOrderBill_LookDown_SellOutBill";
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option3.cols[0].length; i++) {
                colName += option3.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码

            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;

            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn3();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }
        //#endregion
        //#region å­è¡¨3：显示列数据
        function DisPlay_HideColumn3() {
            HModName = "Xs_SeOrderBill_LookDown_SellOutBill";
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                async: false,
                success: function (data1) {
                    if (data1.data.length != 0) {
                        var dataCol = [];//数据库查询出的列数据
                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option3.cols[0].length - 1; i++) {
                            var dataCols = dataCol[i].split('|');
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option3.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option3.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option3.cols[0][i + 1]["style"] += "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option3.cols[0][i + 1]["style"] += "font-size:100%";
                            }
                            //设置列宽
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option2.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option2.cols[0][i + 1]["width"] = "";
                            //}
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option3.cols[0][i + 1]["title"], titleData3) == -1) {
                                option3.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option3.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option3.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option3.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //取消冻结列
                        for (var i = 1; i < option3.cols[0].length - 1; i++) {
                            if (option3.cols[0][i]["fixed"] != null) {
                                option3.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option3.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option3.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option3);
                    } else {
                        table.render(option3);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }
        //#endregion

        //#region èŽ·å–参数
        function getUrlVars() {
            var vars = [], hash;