工资结算单(个人)：部分问题修改

duhe

2023-07-31 e01b56dff67628c7bfaca6f488c89970989e824c

工资结算单(个人)：部分问题修改

 WebTM/views/¹¤×ʹÜÀí/¹¤×ʽáËãµ¥(¸öÈË)/Pay_SingleBalBillEdit.html

@@ -75,20 +75,20 @@
                                <div class="layui-form-item" style="padding-top: 10px;">
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">单据号*</label>
                                            <label class="layui-form-label" style="width: 85px;">单据号<label style="color:red"> * </label></label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HBillNo" lay-verify="HBillNo" id="HBillNo" style="background-color:#efefef4d;" readonly>
                                                <input type="hidden" name="HInterID" id="HInterID" lay-verify="HInterID">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">日期</label>
                                            <label class="layui-form-label" style="width: 85px;">日期<label style="color:red"> * </label></label>
                                            <div class="layui-input-block" style="margin-left: 120px; width:180px;">
                                                <input type="date" class="layui-input" lay-verify="HDate" name="HDate" id="HDate" style="padding-left: 80px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">内部单据号<label style="color:red"> * </label></label>
                                            <label class="layui-form-label" style="width: 85px;">内部单据号</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" lay-verify="HInnerBillNo" name="HInnerBillNo" id="HInnerBillNo">
                                            </div>
@@ -96,7 +96,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">班组*</label>
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">班组<label style="color:red"> * </label></label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="text" class="layui-input" lay-verify="HGroupName" name="HGroupName" id="HGroupName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="hidden" name="HGroupID" id="HGroupID" lay-verify="HGroupID" value="0">
@@ -106,7 +106,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">部门*</label>
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">部门<label style="color:red"> * </label></label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="text" class="layui-input" lay-verify="HDeptName" name="HDeptName" id="HDeptName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="hidden" name="HDeptID" id="HDeptID" lay-verify="HDeptID" value="0">
@@ -116,7 +116,7 @@
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">主管*</label>
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">主管</label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="text" class="layui-input" lay-verify="HEmpName" name="HEmpName" id="HEmpName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="hidden" name="HEmpID" id="HEmpID" lay-verify="HEmpID" value="0">
@@ -128,7 +128,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">工资类型*</label>
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">工资类型<label style="color:red"> * </label></label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="text" class="layui-input" lay-verify="HPayTypeName" name="HPayTypeName" id="HPayTypeName" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="hidden" name="HPayTypeID" id="HPayTypeID" lay-verify="HPayTypeID" value="0">
@@ -159,7 +159,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">摘要<label style="color:red"> * </label></label>
                                            <label class="layui-form-label" style="width: 85px;">摘要</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 501px;">
                                                <input type="text" class="layui-input" lay-verify="HExplanation" name="HExplanation" id="HExplanation">
                                            </div>
@@ -167,7 +167,7 @@
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">备注<label style="color:red"> * </label></label>
                                            <label class="layui-form-label" style="width: 85px;">备注</label>
                                            <div class="layui-input-block" style="margin-left: 120px; width: 501px;">
                                                <input type="text" class="layui-input" lay-verify="HRemark" name="HRemark" id="HRemark">
                                            </div>
@@ -277,8 +277,8 @@
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-AddLine"><i class="layui-icon layui-icon-form"></i>增加一行</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-CopyLine"><i class="layui-icon layui-icon-form"></i>复制一行</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_up"><i class="layui-icon layui-icon-form"></i>上一行</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_under"><i class="layui-icon layui-icon-form"></i>下一行</button>
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_up"><i class="layui-icon layui-icon-form"></i>上一行</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_under"><i class="layui-icon layui-icon-form"></i>下一行</button>-->
                        </div>
                    </script>
                </form>
@@ -833,14 +833,13 @@
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: true
                    , limit: 500
                    , limits: [50, 500, 5000, 50000]
                    , page: false
                    , totalRow: true
                    , cellMinWidth: 120
                    , height: 400
                    , cols: [[
                        { type: 'checkbox', totalRowText: '合计行' }
                        , { type: 'numbers', title: '序号', totalRow: true }
                        , { type: 'numbers', title: '序号'}
                        , { field: 'RowID', title: '行号', hide: true }                                                   //行标识，用于下一行、上一行识别所在行
                        , { field: 'HMaterID', title: '物料ID', hide: true }
                        , { field: 'HMaterNumber', title: '物料代码', edit: 'text', event: "HMaterNumber" }     //f7
@@ -856,34 +855,34 @@
                        , { field: 'HQty', title: '数量', edit: 'text' }
                        , { field: 'HPrice', title: '工价', edit: 'text'}
                        , { field: 'HPriceRate', title: '定额浮动比率', edit: 'text' }
                        , { field: 'HSubsidyQty', title: '补贴数量', edit: 'text' }
                        , { field: 'HSubsidyMoney', title: '补贴金额'}
                        , { field: 'HSubsidyTotal', title: '补贴合计', edit: 'text' }
                        , { field: 'HDeuctTotal', title: '扣款小计', edit: 'text' }
                        , { field: 'HPackQty', title: '包装数量', edit: 'text' }
                        , { field: 'HPackPrice', title: '包装单价', edit: 'text' }
                        , { field: 'HPackMoney', title: '包装金额'}
                        , { field: 'HSubsidyQty', title: '补贴数量', hide: true }
                        , { field: 'HSubsidyMoney', title: '补贴金额', hide: true}
                        , { field: 'HSubsidyTotal', title: '补贴合计', hide: true }
                        , { field: 'HDeuctTotal', title: '扣款小计', hide: true }
                        , { field: 'HPackQty', title: '包装数量', hide: true }
                        , { field: 'HPackPrice', title: '包装单价', hide: true }
                        , { field: 'HPackMoney', title: '包装金额', hide: true}
                        , { field: 'HPackMaterID', title: '包装类型ID', hide: true }
                        //, { field: 'HPackMaterNumber', title: '包装类型代码' }     //f7
                        , { field: 'HPackMaterName', title: '包装类型', edit: 'text', event: "HPackMaterName" }
                        , { field: 'HMoney', title: '金额'}
                        , { field: 'HICMOInterID', title: '生产任务单ID', edit: 'text' }
                        , { field: 'HICMOBillNo', title: '生产任务单号', edit: 'text' }
                        , { field: 'HProcReportInterID', title: '工序汇报单ID', edit: 'text' }
                        , { field: 'HProcReportEntryID', title: '工序汇报单子ID', edit: 'text' }
                        , { field: 'HProcReportBillNo', title: '工序汇报单号', edit: 'text' }
                        , { field: 'HProcPlanInterID', title: '工序计划单ID', edit: 'text' }
                        , { field: 'HProcPlanEntryID', title: '工序计划单子ID', edit: 'text' }
                        , { field: 'HProcPlanBillNo', title: '工序计划单号', edit: 'text' }
                        , { field: 'HPackMaterName', title: '包装类型', hide: true, event: "HPackMaterName" }
                        , { field: 'HMoney', title: '金额', totalRow:true }
                        , { field: 'HICMOInterID', title: '生产任务单ID', hide: true }
                        , { field: 'HICMOBillNo', title: '生产任务单号', hide: true }
                        , { field: 'HProcReportInterID', title: '工序汇报单ID', hide: true }
                        , { field: 'HProcReportEntryID', title: '工序汇报单子ID', hide: true }
                        , { field: 'HProcReportBillNo', title: '工序汇报单号', hide: true }
                        , { field: 'HProcPlanInterID', title: '工序计划单ID', hide: true }
                        , { field: 'HProcPlanEntryID', title: '工序计划单子ID', hide: true }
                        , { field: 'HProcPlanBillNo', title: '工序计划单号', hide: true }
                        , { field: 'HRemark', title: '备注', edit: 'text' }
                        , { field: 'HSourceInterID', title: '源单主内码' }
                        , { field: 'HSourceEntryID', title: '源单子内码' }
                        , { field: 'HSourceBillNo', title: '源单单号' }
                        , { field: 'HSourceBillType', title: '源单类型' }
                        , { field: 'HRelationQty', title: '关联数量' }
                        , { field: 'HRelationMoney', title: '关联金额' }
                        , { field: 'HCloseMan', title: '行关闭人' }
                        , { field: 'HEntryCloseDate', title: '行关闭时间' }
                        , { field: 'HSourceInterID', title: '源单主内码', hide: true }
                        , { field: 'HSourceEntryID', title: '源单子内码', hide: true }
                        , { field: 'HSourceBillNo', title: '源单单号', hide: true }
                        , { field: 'HSourceBillType', title: '源单类型', hide: true }
                        , { field: 'HRelationQty', title: '关联数量', hide: true }
                        , { field: 'HRelationMoney', title: '关联金额', hide: true }
                        , { field: 'HCloseMan', title: '行关闭人', hide: true }
                        , { field: 'HEntryCloseDate', title: '行关闭时间', hide: true }
                        , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                    ]]
                }
@@ -950,7 +949,7 @@
                    , shift: 2                                          //弹出动画
                    , area: ["90%", "90%"]                              //窗体大小
                    , maxmin: true                                      //设置最大最小按钮是否显示
                    , content: ["../../../views/Baseset/基础资料/Gy_GetProductionTeamList.html?Type=HGroupID", "yes"]
                    , content: ["../../../views/基础资料/工资基础资料/Gy_Group.html?Type=HGroupID", "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //按钮一  çš„回调
@@ -961,8 +960,11 @@
                            return layer.msg("请选择一条数据");
                        }

                        $("#HGroupID").val(checkStatus.data[0].HItemID);//内码
                        $("#HGroupName").val(checkStatus.data[0].班组);//名称
                        $("#HGroupID").val(checkStatus.data[0].HItemID);//班组内码
                        $("#HGroupName").val(checkStatus.data[0].班组名称);//班组名称
                        $("#HDeptID").val(checkStatus.data[0].HDeptID);//部门代码
                        $("#HDeptName").val(checkStatus.data[0].部门名称);//部门名称
                        
                        layer.close(index);//关闭弹窗
                    }
                    , btn2: function (index, layero) { }
@@ -1053,6 +1055,12 @@
                        if (checkStatus.data.length != 1) {
                            return layer.msg("请选择一条数据");
                        }
                        var HStopFlag = checkStatus.data[0].禁用标记;
                        if (HStopFlag == 'Y') {
                            layer.msg("该工资类型已被禁用，请重新选择！");
                            return;
                        }


                        $("#HPayTypeID").val(checkStatus.data[0].HItemID);//内码
                        $("#HPayTypeName").val(checkStatus.data[0].工资类型名称);//名称
@@ -1284,23 +1292,19 @@
                    layer.msg("单据号不能为空!");
                    return false;
                }
                if ($("#HInnerBillNo").val() == "") {
                    layer.msg("内部单据号不能为空!");
                if ($("#HDate").val() == "") {
                    layer.msg("日期不能为空!");
                    return false;
                }
                if ($("#HGroupName").val() == "") {
                if ($("#HGroupID").val() == "0") {
                    layer.msg("班组未选择!");
                    return false;
                }
                if ($("#HDeptName").val() == "") {
                if ($("#HDeptID").val() == "0") {
                    layer.msg("部门未选择!");
                    return false;
                }
                if ($("#HEmpName").val() == "") {
                    layer.msg("主管未选择!");
                    return false;
                }
                if ($("#HPayTypeName").val() == "") {
                if ($("#HPayTypeID").val() == "0") {
                    layer.msg("工资类型未选择!");
                    return false;
                }
@@ -1314,14 +1318,14 @@
                var value1_ = ["工时", "数量", "工价", "定额浮动比率", "补贴数量", "补贴金额", "补贴合计", "扣款小计", "包装数量", "包装单价", "包装金额", "金额"];  ////子表需要进行浮点数验证的属性清单对应的列名清单
                var value2 = ["HICMOInterID", "HProcReportInterID", "HProcReportEntryID", "HProcPlanInterID", "HProcPlanEntryID"];  //子表需要整数检验的属性清单 
                var value2_ = ["生产任务单ID","工序汇报单ID", "工序汇报单子ID", "工序计划单ID", "工序计划单子ID"]; //子表需要整数检验的属性清单对应的列名清单
                var value3 = ["HMaterNumber", "HProcNumber", "HEmpNumber", "HPackMaterName"];       //子表需要进行非空检验的属性清单
                var value3_ = ["物料", "工序", "职员", "包装方式"];                                 //子表需要进行非空检验的属性清单对应的列名清单
                var value3 = ["HMaterID", "HProcID", "HEmpID"];       //子表需要进行非空检验的属性清单
                var value3_ = ["物料", "工序", "职员"];                                 //子表需要进行非空检验的属性清单对应的列名清单
                for (var i = 0; i < option.data.length; i++) {
                    if (option.data[i] != "") {
                        //非空检验
                        for (var j = 0; j < value3.length; j++) {
                            temp = option.data[i][value3[j]] + "";
                            if (temp == "") {
                            if (temp == "0") {
                                layer.msg("第" + (i + 1) + "行:" + value3_[j] + "未选择!");
                                return false;
                            }
@@ -1348,8 +1352,17 @@
                                return false;
                            }
                        }
                        //特殊检验
                        temp = option.data[i]["HQty"] + "";
                        if (temp == "0") {
                            layer.msg("第" + (i + 1) + "行:数量不能为0!")
                            return false;
                        }
                    }
                }
                //#endregion

                //#region å­è¡¨å…³é”®å­—段重复检验
                //#endregion
                return true;
            }
@@ -1446,13 +1459,30 @@
                                    if (checkStatus.data.length != 1) {
                                        return layer.msg("请选择一条数据");
                                    }
                                    //更新表格缓存的数据
                                    obj.update({
                                        "HMaterID": checkStatus.data[0].HItemID
                                        , "HMaterNumber": checkStatus.data[0].HNumber
                                        , "HMaterName": checkStatus.data[0].HName
                                        , "HMaterModel": checkStatus.data[0].HModel
                                    })

                                    //获取工价
                                    var HMaterID = checkStatus.data[0].HItemID;
                                    var HProcID = obj.data.hasOwnProperty("HProcID") ? obj.data.HProcID + "":"0";
                                    var HSourceID = obj.data.hasOwnProperty("HSourceID") ? obj.data.HSourceID + "": "0";
                                    var HPrice = subTable_GetHPrice(HMaterID, HProcID, HSourceID);

                                    if (HPrice != -1) {
                                        //更新表格缓存的数据
                                        obj.update({
                                            "HMaterID": checkStatus.data[0].HItemID
                                            , "HMaterNumber": checkStatus.data[0].HNumber
                                            , "HMaterName": checkStatus.data[0].HName
                                            , "HMaterModel": checkStatus.data[0].HModel
                                            , "HPrice": HPrice
                                        })
                                    } else {
                                        obj.update({
                                            "HMaterID": checkStatus.data[0].HItemID
                                            , "HMaterNumber": checkStatus.data[0].HNumber
                                            , "HMaterName": checkStatus.data[0].HName
                                            , "HMaterModel": checkStatus.data[0].HModel
                                        })
                                    }
                                    layer.close(index);//关闭弹窗
                                }
                            })
@@ -1478,12 +1508,28 @@
                                    if (checkStatus.data.length != 1) {
                                        return layer.msg("请选择一条数据");
                                    }

                                    //获取工价
                                    var HMaterID = obj.data.hasOwnProperty("HMaterID") ? obj.data.HMaterID + "" : "0";
                                    var HProcID = checkStatus.data[0].HItemID;
                                    var HSourceID = obj.data.hasOwnProperty("HSourceID") ? obj.data.HSourceID + "" : "0";
                                    var HPrice = subTable_GetHPrice(HMaterID, HProcID, HSourceID);

                                    //更新表格缓存的数据
                                    obj.update({
                                        "HProcID": checkStatus.data[0].HItemID
                                        , "HProcNumber": checkStatus.data[0].工序代码
                                        , "HProcName": checkStatus.data[0].工序
                                    })
                                    if (HPrice != -1) {
                                        obj.update({
                                            "HProcID": checkStatus.data[0].HItemID
                                            , "HProcNumber": checkStatus.data[0].工序代码
                                            , "HProcName": checkStatus.data[0].工序
                                            , "HPrice": HPrice
                                        })
                                    } else {
                                        obj.update({
                                            "HProcID": checkStatus.data[0].HItemID
                                            , "HProcNumber": checkStatus.data[0].工序代码
                                            , "HProcName": checkStatus.data[0].工序
                                        })
                                    }
                                    layer.close(index);//关闭弹窗
                                }
                            })
@@ -1603,7 +1649,7 @@
                    success: function (data1) {
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = ["行号","物料ID","工序ID","职员ID","包装类型ID"];//不需要显示的字段 å¯æ‰©å±•
                            var titleData = ["行号","物料ID","工序ID","职员ID","包装类型ID","补贴数量","补贴金额","补贴合计","扣款小计","包装数量","包装单价","包装金额","包装类型ID","包装类型","生产任务单ID","生产任务单号","工序汇报单ID","工序汇报单子ID","工序汇报单号","工序计划单ID","工序计划单子ID","工序计划单号","源单主内码","源单子内码","源单单号","源单类型","关联数量","关联金额","行关闭人","行关闭时间"];//不需要显示的字段 å¯æ‰©å±•

                            dataCol = data1.data[0].HGridString.split(',');

@@ -1676,6 +1722,37 @@
            }
            //#endregion

            //#region å­è¡¨ç‰©æ–™ã€å·¥åºå¸¦å‡ºå·¥ä»·
            function subTable_GetHPrice(HMaterID, HProcID, HSourceID) {
                var HPrice;
                if (HMaterID != "0" && HProcID != "0") {
                    $.ajax({
                        type: "Get",
                        url: GetWEBURL() + "/Pay_SingleBalBill/get_HPrice_BaseMaterHProcHSource",
                        async: false,
                        data: { "HMaterID": HMaterID, "HProcID": HProcID, "HSourceID": HSourceID },
                        success: function (res) {
                            if (res.count == 1) {
                                HPrice = res.data;
                            }
                            else {
                                layer.msg(res.Message, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                                HPrice = 0;
                            }
                        },
                        error: function (err) {
                            layer.msg("错误:" + err, { icon: 5, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            HPrice = 0;
                        }
                    });
                    return HPrice;
                } else {
                    HPrice = -1;
                    return HPrice;
                }
            }
            //#endregion

            //#endregion