销售出库单：选择源单，对源单记录进行过滤（已审核 未关闭的数据），允许选择多行 多源单（不同客户），保存时 判断 源单是否是审核未关闭状态

duhe

2024-01-17 2ae420c05e704553910956fb95f22dc2da40de72

销售出库单：选择源单，对源单记录进行过滤（已审核  未关闭的数据），允许选择多行 多源单（不同客户），保存时 判断 源单是否是审核未关闭状态

 WebTM/Properties/PublishProfiles/JFTM.pubxml.user

@@ -5256,7 +5256,7 @@
      <publishTime>04/11/2023 16:34:43</publishTime>
    </File>
    <File Include="views/销售管理/销售订单/Xs_SeOrderBillList.html">
      <publishTime>01/17/2024 12:44:48</publishTime>
      <publishTime>01/17/2024 16:10:28</publishTime>
    </File>
    <File Include="views/采购管理/委外订单/WW_EntrustOrderBillList.html">
      <publishTime>11/03/2023 21:45:51</publishTime>
@@ -5277,7 +5277,7 @@
      <publishTime>11/03/2023 21:45:51</publishTime>
    </File>
    <File Include="views/销售管理/销售订单/Xs_SeOrderBillList.html">
      <publishTime>01/17/2024 12:44:48</publishTime>
      <publishTime>01/17/2024 16:10:28</publishTime>
    </File>
    <File Include="views/销售管理/销售订单/Xs_SeOrderBill_LookDown.html">
      <publishTime>12/11/2023 16:22:03</publishTime>
@@ -5439,10 +5439,10 @@
      <publishTime>04/11/2023 16:34:43</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBill.html">
      <publishTime>01/17/2024 14:47:31</publishTime>
      <publishTime>01/17/2024 16:22:35</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBill.html">
      <publishTime>01/17/2024 14:47:31</publishTime>
      <publishTime>01/17/2024 16:22:35</publishTime>
    </File>
    <File Include="views/领料发货/销售出库/Kf_SellOutBillList.html">
      <publishTime>01/16/2024 14:21:41</publishTime>

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

@@ -559,6 +559,8 @@
                    sWhere += " and ä¸»ç®¡ like '%" + HMangerID + "%'";
                }

                sWhere += addSWhereByOpenType();

                //根据用户过滤用户关联客户的记录
                sWhere += getSWhereByHUser();

@@ -1219,6 +1221,33 @@
            }
            //#endregion

            //#region èŽ·å–参数
            function getUrlVars() {
                var vars = [], hash;
                var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
                for (var i = 0; i < hashes.length; i++) {
                    hash = hashes[i].split('=');
                    vars.push(hash[0]);
                    vars[hash[0]] = hash[1];
                }
                return vars;
            }
            //#endregion
            //#region åˆ¤æ–­æ˜¯ç›´æŽ¥æ‰“开页面还是其它页面通过选择按钮打开，并显示相应数据
            function addSWhereByOpenType() {
                //获取参数
                var params = getUrlVars();
                var openType = params[params[0]]; //从参数中获取 æ‰“开方式  1直接打开 2其它页面通过选择按钮打开
                var HOrgID = params[params[1]];

                var addSWhere = "";

                if (openType == 2) {
                    addSWhere = " and çŠ¶æ€ = '已审核' and HOrgID = " + HOrgID;
                }
                return addSWhere;
            }
            //#endregion
            //#endregion

            //以上是layui模块

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

@@ -526,7 +526,7 @@

            //#region ä¿å­˜æŒ‰é’®
            form.on('submit(Saver)', function (data) {
                if (OperationType == 4) {
                if (OperationType == 1 || OperationType == 4) {
                    //#region åˆ¤æ–­æºå•çŠ¶æ€
                    for (var i = 0; i < option.data.length; i++) {
                        var HSourceBillData = "";
@@ -1303,9 +1303,10 @@

            //#region é€‰æ‹©æºå•
            function get_checkMainSource() {
                var HOrgID = $("#HOrgID").val();
                var url = "";
                if ($("#BillType").val() == "1401") {
                    url = "../../销售管理/销售订单/Xs_SeOrderBillList.html";
                    url = "../../销售管理/销售订单/Xs_SeOrderBillList.html?openType=2&HOrgID=" + HOrgID;
                } else {
                    return layer.msg('当前不支持改源单选择！！');
                }
@@ -1326,8 +1327,7 @@
                        }

                        if ($("#BillType").val() == "1401") {
                            setInitBySeOrderBill(checkStatus.data[0].hmainid);
                            getCustomerBalance($("#HSupID").val());
                            setInitBySeOrderBill(checkStatus);
                        }
                        layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }
@@ -2332,116 +2332,107 @@
            //#endregion

            //#region é€‰æ‹©æºå•-销售订单
            function setInitBySeOrderBill(HMainSourceInterID) {
                //查询销售是否存在并初始化页面
                $.ajax({
                    url: GetWEBURL() + "/Xs_SeOrderBill/loadXs_SeOrderBill_Edit",
                    async: false,
                    type: "GET",
                    data: {
                        "HInterID": HMainSourceInterID
                    },
                    success: function (result) {
                        if (result.code == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            var data = result.data[0];

                            form.val("component-form-group", { //formTest å³ class="layui-form" æ‰€åœ¨å…ƒç´ å±žæ€§ lay-filter="" å¯¹åº”的值
                                "HDeptID": data.HDeptID
                                , "HDeptName": data.部门
                                , "HEmpID": data.HEmpID
                                , "HEmpName": data.业务员
                                , "HManagerID": data.HManagerID
                                , "HManagerName": data.主管
                                , "HMainSourceInterID": HMainSourceInterID
                                , "HMainSourceEntryID": "0"
                                , "HMainSourceBillNo": data.单据号
                                , "HMainSourceBillType": $("#BillType").val()
                                , "HSupID": data.HCusID
                                , "HSupName": data.客户
                                , "HLinkMan": data.联系人
                                , "HLinkPhone": data.联系电话
                                , "HSellSID": data.HSellSID
                                , "HSellSName": data.销售方式
                                , "HCurID": data.HCurID
                                , "HCurName": data.币别
                                , "HExRate": data.汇率
                            });

                            //子表  èµ‹å€¼
                            var rowdata = [];
                            for (var i = 0; i < result.data.length; i++) {
                                rowdata.push(
                                    {
                                        "HMaterID": result.data[i].HMaterID
                                        , "物料代码": result.data[i].物料代码
                                        , "物料名称": result.data[i].物料名称
                                        , "规格型号": result.data[i].规格型号
                                        , "HUnitID": result.data[i].HUnitID
                                        , "计量单位": result.data[i].计量单位
                                        , "HQtyMust": dealDoubleToFixed(result.data[i].数量, 1)
                                        , "HQty": dealDoubleToFixed(result.data[i].数量, 1)
                                        , "HPrice": dealDoubleToFixed(result.data[i].单价, 3)
                                        , "HTaxPrice": dealDoubleToFixed(result.data[i].含税单价, 3)
                                        , "HTaxRate": result.data[i].税率
                                        , "HMoney": dealDoubleToFixed(result.data[i].金额, 2)
                                        , "HTaxMoney": dealDoubleToFixed(result.data[i].价税合计, 2)
                                        , "HWHID": $("#HWHID").val()
                                        , "发货仓库": $("#HWHName").val()
                                        , "HRemark": ""

                                        , "HQty_Full": "0"
                                        , "HQty_Empty": "0"
                                        , "HQty_Back": "0"
                                        , "HCostPrice": "0"
                                        , "HCostMoney": "0"
                                        , "HSalePrice": "0"

                                        , "HSeOrderInterID": result.data[i].hmainid
                                        , "HSeOrderEntryID": result.data[i].hsubid
                                        , "HSeOrderBillNo": result.data[i].单据号

                                        , "HSourceInterID": result.data[i].hmainid
                                        , "HSourceEntryID": result.data[i].hsubid
                                        , "HSourceBillNo": result.data[i].单据号
                                        , "HSourceBillType": result.data[i].HBillType
                                        , "HRelationQty": "0"
                                        , "HRelationMoney": "0"

                                        , 'HSPID': "0"
                                        , 'HSPName': ""
                                        , 'HSPGroupID': "0"
                                        , "HSPGroupName": ""
                                        , 'HSCWHID': "0"
                                        , 'HSCWHName': ""
                                        , 'HSCSPID': "0"
                                        , 'HSCSPName': ""
                                        , 'HBatchNo': ""
                                        , 'HPOOrderInterID': "0"
                                        , 'HPOOrderEntryID': "0"
                                        , 'HPOOrderBillNo': ""

                                        , 'HPropertyID': "0"
                                        , 'HPropertyName': ""
                                        , 'HSecUnitID': "0"
                                        , 'HSecUnitName': ""
                                        , 'HSecUnitRate': "0"


                                        , 'HEngineNum': ""
                                        , 'HUnderPanNum': ""
                                        , 'HLeaveFactCard': ""
                                    }
                                );
                            }
                            option.data = rowdata;
                            table.render(option);
                        } else {
                            layer.alert(result.msg, { icon: 5, btn: ['退出'], time: 100000, offset: 't' });
                        }
                    }, error: function () {
                        layer.alert("发生错误!", { icon: 5 });
            function setInitBySeOrderBill(checkStatus) {
                var dataArray = [];
                for (var i = 0; i < checkStatus.data.length; i++) {
                    var temp = getPushSourceBillInit(checkStatus.data[i].hmainid, checkStatus.data[i].hsubid);
                    if (temp != "none") {
                        dataArray.push(temp);
                    } else {
                        return;
                    }
                }

                form.val("component-form-group", { //formTest å³ class="layui-form" æ‰€åœ¨å…ƒç´ å±žæ€§ lay-filter="" å¯¹åº”的值
                    "HDeptID": dataArray[0].HDeptID
                    , "HDeptName": dataArray[0].部门
                    , "HEmpID": dataArray[0].HEmpID
                    , "HEmpName": dataArray[0].业务员
                    , "HManagerID": dataArray[0].HManagerID
                    , "HManagerName": dataArray[0].主管
                    , "HMainSourceInterID": "0"
                    , "HMainSourceEntryID": "0"
                    , "HMainSourceBillNo": ""
                    , "HMainSourceBillType": $("#BillType").val()
                    , "HSupID": dataArray[0].HCusID
                    , "HSupName": dataArray[0].客户
                    , "HLinkMan": dataArray[0].联系人
                    , "HLinkPhone": dataArray[0].联系电话
                    , "HSellSID": dataArray[0].HSellSID
                    , "HSellSName": dataArray[0].销售方式
                    , "HCurID": dataArray[0].HCurID
                    , "HCurName": dataArray[0].币别
                    , "HExRate": dataArray[0].汇率
                });

                //子表  èµ‹å€¼
                var rowdata = [];
                for (var i = 0; i < dataArray.length; i++) {
                    rowdata.push(
                        {
                            "HMaterID": dataArray[i].HMaterID
                            , "物料代码": dataArray[i].物料代码
                            , "物料名称": dataArray[i].物料名称
                            , "规格型号": dataArray[i].规格型号
                            , "HUnitID": dataArray[i].HUnitID
                            , "计量单位": dataArray[i].计量单位
                            , "HQtyMust": dealDoubleToFixed(dataArray[i].数量, 1)
                            , "HQty": dealDoubleToFixed(dataArray[i].数量, 1)
                            , "HPrice": dealDoubleToFixed(dataArray[i].单价, 3)
                            , "HTaxPrice": dealDoubleToFixed(dataArray[i].含税单价, 3)
                            , "HTaxRate": dataArray[i].税率
                            , "HMoney": dealDoubleToFixed(dataArray[i].金额, 2)
                            , "HTaxMoney": dealDoubleToFixed(dataArray[i].价税合计, 2)
                            , "HWHID": $("#HWHID").val()
                            , "发货仓库": $("#HWHName").val()
                            , "HRemark": ""

                            , "HQty_Full": "0"
                            , "HQty_Empty": "0"
                            , "HQty_Back": "0"
                            , "HCostPrice": "0"
                            , "HCostMoney": "0"
                            , "HSalePrice": "0"

                            , "HSeOrderInterID": dataArray[i].hmainid
                            , "HSeOrderEntryID": dataArray[i].hsubid
                            , "HSeOrderBillNo": dataArray[i].单据号

                            , "HSourceInterID": dataArray[i].hmainid
                            , "HSourceEntryID": dataArray[i].hsubid
                            , "HSourceBillNo": dataArray[i].单据号
                            , "HSourceBillType": dataArray[i].HBillType
                            , "HRelationQty": "0"
                            , "HRelationMoney": "0"

                            , 'HSPID': "0"
                            , 'HSPName': ""
                            , 'HSPGroupID': "0"
                            , "HSPGroupName": ""
                            , 'HSCWHID': "0"
                            , 'HSCWHName': ""
                            , 'HSCSPID': "0"
                            , 'HSCSPName': ""
                            , 'HBatchNo': ""
                            , 'HPOOrderInterID': "0"
                            , 'HPOOrderEntryID': "0"
                            , 'HPOOrderBillNo': ""

                            , 'HPropertyID': "0"
                            , 'HPropertyName': ""
                            , 'HSecUnitID': "0"
                            , 'HSecUnitName': ""
                            , 'HSecUnitRate': "0"


                            , 'HEngineNum': ""
                            , 'HUnderPanNum': ""
                            , 'HLeaveFactCard': ""
                        }
                    );
                }
                option.data = rowdata;
                table.render(option);
            }
            //#endregion