1

yangle

2024-05-13 1c6a4c87cc53dfe72d4af0cff53e627d406589eb

 WebTM/views/²Ö´æ¹ÜÀí/·Ö²½Ê½µ÷Èëµ¥/Fb_StepFoldinBillEdit.html

@@ -96,7 +96,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">供应商</label>
                                            <label class="layui-form-label">供应商<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HSupName" id="HSupName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HSupID" id="HSupID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -106,7 +106,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">仓管员</label>
                                            <label class="layui-form-label">仓管员<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HEmpName" id="HEmpName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HEmpID" id="HEmpID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -118,7 +118,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">负责人</label>
                                            <label class="layui-form-label">负责人<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HManagerName" id="HManagerName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HManagerID" id="HManagerID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -128,7 +128,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">调入仓库</label>
                                            <label class="layui-form-label">调入仓库<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HWHName" id="HWHName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HWHID" id="HWHID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -138,7 +138,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">调出仓库</label>
                                            <label class="layui-form-label">调出仓库<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HSCWHName" id="HSCWHName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HSCWHID" id="HSCWHID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -150,7 +150,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">验收</label>
                                            <label class="layui-form-label">验收<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HSecManagerName" id="HSecManagerName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HSecManagerID" id="HSecManagerID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -160,7 +160,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">保管员</label>
                                            <label class="layui-form-label">保管员<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HKeeperName" id="HKeeperName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HKeeperID" id="HKeeperID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -170,7 +170,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">部门</label>
                                            <label class="layui-form-label">部门<label style="color:red"> * </label></label>
                                            <div class="layui-input-inline">
                                                <input type="text" name="HDeptName" id="HDeptName" class="layui-input" value="" style="float:left;width:150px;">
                                                <input type="hidden" name="HDeptID" id="HDeptID" class="layui-input" value="0" style="float:left;width:150px;">
@@ -311,7 +311,7 @@
            var shijian = year + "-" + month + "-" + day;
            var allVal;
            //双击返回全局变量
            window.OptionData = {};
            window.OptionData = [];
            //#endregion


@@ -552,6 +552,109 @@
                table.render(option);
            }

            //#region ç›‘听单元格编辑  å•å…ƒæ ¼ç¼–辑后 å˜æ›´
            table.on('edit(mainTable)', function (obj) {
                //数值格式校验工具
                var ref = /^\d+(\.\d+)?$/;          //非负数正则表达式
                var temp = "";

                // å•å…ƒæ ¼ç¼–辑之前的值
                var oldText = $(this).prev().text();
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段

                switch (field) {
                    case "HQty":                                         //数量
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp) || temp == 0) {
                            //恢复数据到编辑前
                            obj.update({
                                HQty: oldText
                            });
                            table.render(option);

                            layer.msg("数量请输入大于0的数字!");
                            return;
                        }


                        //数据校验合格，重算记录
                        var HQty = value * 1;                           //数量
                        var HPrice = obj.data.HPrice * 1;               //单价
                        var HMoney = HQty * HPrice;                     //金额=数量*单价



                        //同步更新表格和缓存对应的值
                        obj.update({
                            HQty: HQty
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                        /* table.render(option);*/
                        break;
                    case "HPrice":                                         //单价
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp) || temp == 0) {
                            //恢复数据到编辑前
                            obj.update({
                                HPrice: oldText
                            });
                            /* table.render(option);*/

                            layer.msg("单价请输入大于0的数字!");
                            return;
                        }

                        //数据校验合格，重算记录
                        var HQty = obj.data.HQty * 1;                   //数量
                        var HPrice = value * 1;
                        var HMoney = HQty * HPrice;                     //金额=数量*单价


                        //同步更新表格和缓存对应的值
                        obj.update({
                            HQty: HQty
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                        break;
                    case "HMoney":                                         //金额
                        //数据格式校验
                        temp = value + "";
                        if (!ref.test(temp) || temp == 0) {
                            //恢复数据到编辑前
                            obj.update({
                                HMoney: oldText
                            });
                            /* table.render(option);*/

                            layer.msg("金额请输入大于0的数字!");
                            return;
                        }

                        //数据校验合格，重算记录
                        var HQty = obj.data.HQty * 1;                   //数量
                        var HMoney = value * 1;
                        var HPrice = (HMoney / HQty).toFixed(2);       //单价=金额/数量


                        //同步更新表格和缓存对应的值
                        obj.update({
                            HQty: HQty
                            , HPrice: HPrice
                            , HMoney: HMoney
                        });
                        break;
                        table.render(option);
                    default:
                }
            });
            //#endregion

            //#region åŠ è½½è¡¨å¤´
            function RoadBillMain(linterid) {
                //查询检验方案单是否存在
@@ -564,70 +667,70 @@
                    },
                    success: function (result) {
                        if (result.code == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            var data = result.data[0];
                            var data = result.data;
                            allVal = result.data[0];
                            form.val("component-form-group", { //formTest å³ class="layui-form" æ‰€åœ¨å…ƒç´ å±žæ€§ lay-filter="" å¯¹åº”的值
                                "HBillNo": data.单据号
                                , "HDate": formatDate(data.日期)
                                "HBillNo": data[0].单据号
                                , "HDate": formatDate(data[0].日期)
                                /*, "HSSDate": formatDate(data.结算日期)*/
                                //, "HInnerBillNo": data.内部单据号
                                , "HAddress": data.交货地点
                                , "HDeptName": data.部门
                                , "HDeptID": data.HDeptID
                                , "HSupID": data.HSupID
                                , "HSupName": data.供应商
                                , "HEmpID": data.HEmpID
                                , "HEmpName": data.仓管员
                                , "HCurID": data.HCurID
                                , "HCurName": data.币别
                                , "HExRate": data.汇率
                                , "HWHID": data.HWHID
                                , "HWHName": data.调入仓库
                                , "HSCWHID": data.HSCWHID
                                , "HSCWHName": data.调出仓库
                                , "HManagerName": data.负责人
                                , "HManagerID": data.HManagerID
                                , "HSecManagerID": data.HSecManagerID
                                , "HSecManagerName": data.验收
                                , "HKeeperID": data.HKeeperID
                                , "HKeeperName": data.保管员
                                , "HPSStyleID": data.HPSStyleID
                                , "HPSStyleName": data.采购方式
                                , "HSourceBillType": data.源单类型
                                , "HSSID": data.HSSID
                                , "HSSName": data.结算方式
                                , "HLinkMan": data.联系人
                                , "HLinkPhone": data.联系电话
                                , "HInnerBillNo": data.辅助字段
                                , "HRemark": data.表头备注
                                , "HMaker": data.制单人
                                , "HMakeDate": data.制单日期
                                , "HUpDater": data.修改人
                                , "HUpDateDate": data.修改日期
                                , "HChecker": data.审核人
                                , "HCheckDate": data.审核日期
                                , "HCloseMan": data.关闭人
                                , "HCloseDate": data.关闭日期
                                , "HDeleteMan": data.作废人
                                , "HDeleteDate": data.作废日期
                                , "HAddress": data[0].交货地点
                                , "HDeptName": data[0].部门
                                , "HDeptID": data[0].HDeptID
                                , "HSupID": data[0].HSupID
                                , "HSupName": data[0].供应商
                                , "HEmpID": data[0].HEmpID
                                , "HEmpName": data[0].仓管员
                                , "HCurID": data[0].HCurID
                                , "HCurName": data[0].币别
                                , "HExRate": data[0].汇率
                                , "HWHID": data[0].HWHID
                                , "HWHName": data[0].调入仓库
                                , "HSCWHID": data[0].HSCWHID
                                , "HSCWHName": data[0].调出仓库
                                , "HManagerName": data[0].负责人
                                , "HManagerID": data[0].HManagerID
                                , "HSecManagerID": data[0].HSecManagerID
                                , "HSecManagerName": data[0].验收
                                , "HKeeperID": data[0].HKeeperID
                                , "HKeeperName": data[0].保管员
                                , "HPSStyleID": data[0].HPSStyleID
                                , "HPSStyleName": data[0].采购方式
                                , "HSourceBillType": data[0].源单类型
                                , "HSSID": data[0].HSSID
                                , "HSSName": data[0].结算方式
                                , "HLinkMan": data[0].联系人
                                , "HLinkPhone": data[0].联系电话
                                , "HInnerBillNo": data[0].辅助字段
                                , "HRemark": data[0].表头备注
                                , "HMaker": data[0].制单人
                                , "HMakeDate": data[0].制单日期
                                , "HUpDater": data[0].修改人
                                , "HUpDateDate": data[0].修改日期
                                , "HChecker": data[0].审核人
                                , "HCheckDate": data[0].审核日期
                                , "HCloseMan": data[0].关闭人
                                , "HCloseDate": data[0].关闭日期
                                , "HDeleteMan": data[0].作废人
                                , "HDeleteDate": data[0].作废日期
                            });

                            //子表  èµ‹å€¼
                            var rowdata = [];
                            for (var i = 0; i < 1; i++) {
                            for (var i = 0; i < data.length; i++) {
                                rowdata.push(
                                    {
                                        "HMaterID": data.HMaterID, "物料代码": data.物料代码, "物料名称": data.物料名称
                                        , "规格型号": data.规格型号, "HUnitID": data.HUnitID
                                        , "计量单位": data.计量单位, "HQtyMust": data.应收数量, "HQty": data.实收数量, "HRemark": data.表体备注
                                        , "HPrice": data.单价, "HMoney": data.金额, "HOrderPrice": data.采购金额, "HWHID": data.HWHID, "调入仓库": data.调入仓库, "HSCWHID": data.HSCWHID, "调出仓库": data.调出仓库, "HTaxRate": data.税率
                                        , "HTaxMoney": data.金额 * data.税率, "HlineTotal": data.金额 + data.税额, "HlineTotalBB": (data.金额 + data.税额) * data.汇率
                                        , "HTaxPrice": data.含税单价, "HDiscountRate": data.折扣率, "HRelTaxPrice": data.实际含税单价
                                        , "HDate": Format(new Date(data.交货日期), "yyyy-MM-dd"), "HBatchNo": data.批次,
                                          "HSourceBillNo": data.源单单号,    //源单号
                                        "HSourceBillType": data.源单类型,   //源单类型
                                        "HSourceInterID": data.源单主内码,   //源单主内码
                                        "HSourceEntryID": data.源单子内码     //源单子内码
                                        "HMaterID": data[i].HMaterID, "物料代码": data[i].物料代码, "物料名称": data[i].物料名称
                                        , "规格型号": data[i].规格型号, "HUnitID": data[i].HUnitID
                                        , "计量单位": data[i].计量单位, "HQtyMust": data[i].应收数量, "HQty": data[i].实收数量, "HRemark": data[i].表体备注
                                        , "HPrice": data[i].单价, "HMoney": data[i].金额, "HOrderPrice": data[i].采购金额, "HWHID": data[i].HWHID, "调入仓库": data[i].调入仓库, "HSCWHID": data[i].HSCWHID, "调出仓库": data[i].调出仓库, "HTaxRate": data[i].税率
                                        , "HTaxMoney": data[i].金额 * data[i].税率, "HlineTotal": data[i].金额 + data[i].税额, "HlineTotalBB": (data[i].金额 + data[i].税额) * data[i].汇率
                                        , "HTaxPrice": data[i].含税单价, "HDiscountRate": data[i].折扣率, "HRelTaxPrice": data[i].实际含税单价
                                        , "HDate": Format(new Date(data[i].交货日期), "yyyy-MM-dd"), "HBatchNo": data[i].批次,
                                        "HSourceBillNo": data[i].源单单号,    //源单号
                                        "HSourceBillType": data[i].源单类型,   //源单类型
                                        "HSourceInterID": data[i].源单主内码,   //源单主内码
                                        "HSourceEntryID": data[i].源单子内码     //源单子内码
                                    }
                                )
                            }
@@ -651,7 +754,30 @@
            //#region ä¿å­˜æ–¹æ³•
            function set_SaveBill(data) {


                if ($("#HSupID").val() == 0) {
                    layer.msg("请选择供应商！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HEmpID").val() == 0) {
                    layer.msg("请选择仓管员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HManagerID").val() == 0) {
                    layer.msg("请选择负责人！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HSecManagerID").val() == 0) {
                    layer.msg("请选择验收员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HKeeperID").val() == 0) {
                    layer.msg("请选择保管员！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HDeptID").val() == 0) {
                    layer.msg("请选择部门！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
                }
                if ($("#HWHID").val() == 0) {
                    layer.msg("请选择调入仓库！", { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    return;
@@ -670,24 +796,24 @@
                    }
                }

                checkDuplicateData(num);
                const duplicateRows = checkDuplicateData(num);
                if (duplicateRows.length > 0) {
                    let message = '表格中存在重复数据，重复行数为：';
                //checkDuplicateData(num);
                //const duplicateRows = checkDuplicateData(num);
                //if (duplicateRows.length > 0) {
                //    let message = '表格中存在重复数据，重复行数为：';

                    for (let i = 0; i < duplicateRows.length; i++) {
                        const { row1, row2 } = duplicateRows[i];
                        message += `第${row1}行与第${row2}行相同`;
                //    for (let i = 0; i < duplicateRows.length; i++) {
                //        const { row1, row2 } = duplicateRows[i];
                //        message += `第${row1}行与第${row2}行相同`;

                        if (i !== duplicateRows.length - 1) {
                            message += '，';
                        }
                    }
                //        if (i !== duplicateRows.length - 1) {
                //            message += '，';
                //        }
                //    }

                    message += '，请删除其中一行';
                    layer.alert(message);
                    return;
                }
                //    message += '，请删除其中一行';
                //    layer.alert(message);
                //    return;
                //}

                var sMainStr = JSON.stringify(data.field);
                var sSubStr = JSON.stringify(num);
@@ -759,9 +885,9 @@
                                    layer.close(index);//关闭弹窗
                                }
                                , end: function () {
                                    if (OptionData.length>0) {
                                    if (OptionData != null && OptionData.length == undefined) {
                                        obj.update({
                                            "HMaterID": OptionData.HMaterID
                                            "HMaterID": OptionData.HItemID
                                            , "物料代码": OptionData.物料代码
                                            , "物料名称": OptionData.物料名称
                                            , "规格型号": OptionData.规格型号
@@ -770,6 +896,7 @@
                                        })
                                        OptionData = [];
                                    }
                                   
                                    
                                }
                            })
@@ -784,7 +911,7 @@
                                , shift: 2 //弹出动画
                                , area: ["90%", "90%"] //窗体大小
                                , maxmin: true //设置最大最小按钮是否显示
                                , content: ['../../基础资料/公用基础资料/Gy_Unit.html', 'yes']
                                , content: ['../../基础资料/公用基础资料/Gy_Unit.html?type=AuxiliaryUnit', 'yes']
                                , btn: ["确定", "取消"]
                                , btn1: function (index, laero) {
                                    //按钮一  çš„回调
@@ -804,8 +931,8 @@
                                , end: function () {
                                    if (OptionData.length > 0) {
                                        obj.update({
                                            "HUnitID": OptionData.HItemID
                                            , "计量单位": OptionData.计量单位名称
                                            "HUnitID": OptionData[0].HItemID
                                            , "计量单位": OptionData[0].计量单位名称
                                        })
                                        OptionData = [];
                                    }
@@ -880,13 +1007,14 @@
                                    layer.close(index);//关闭弹窗
                                }
                                , end: function () {
                                    if (OptionData.length > 0) {
                                    if (OptionData != null && OptionData.length == undefined) {
                                        obj.update({
                                            "HWHID": OptionData.HItemID
                                            , "调入仓库": OptionData.仓库名称
                                        })
                                        OptionData = [];
                                    }
                                    
                                
                            }
                            })
@@ -919,13 +1047,14 @@
                                    layer.close(index);//关闭弹窗
                                }
                                , end: function () {
                                    if (OptionData.length > 0) {
                                    if (OptionData != null && OptionData.length == undefined) {
                                        obj.update({
                                            "HSCWHID": OptionData.HItemID
                                            , "调出仓库": OptionData.仓库名称
                                        })
                                        OptionData = [];
                                    }
                                   
                               
                            }
                            })
@@ -1399,7 +1528,7 @@
             OptionData = data
         }
           //双击返回计量单位
         function GetGyUnit(data) {
        function GetAuxiliaryUnitValue(data) {
             OptionData = data
         }