入职申请、工资结算单(个人)、工资结算单(集体)：文本框监听，实现数据关联

duhe

2023-07-21 50973d7c3023227bee0aed5fce017e6e38483f5f

入职申请、工资结算单(个人)、工资结算单(集体)：文本框监听，实现数据关联

 WebTM/Properties/PublishProfiles/JFTM.pubxml.user

@@ -1728,7 +1728,7 @@
      <publishTime>04/11/2023 16:34:43</publishTime>
    </File>
    <File Include="views/人事管理/入职申请/HR_EmpEngageRequestBill.html">
      <publishTime>07/21/2023 11:01:52</publishTime>
      <publishTime>07/21/2023 15:40:30</publishTime>
    </File>
    <File Include="views/人事管理/入职申请/HR_EmpEngageRequestBillList.html">
      <publishTime>07/21/2023 08:25:45</publishTime>
@@ -2685,7 +2685,7 @@
      <publishTime>10/19/2021 09:27:19</publishTime>
    </File>
    <File Include="views/工资管理/工资结算单%28个人%29/Pay_SingleBalBillEdit.html">
      <publishTime>07/19/2023 22:05:52</publishTime>
      <publishTime>07/21/2023 14:49:14</publishTime>
    </File>
    <File Include="views/工资管理/工资结算单%28个人%29/Pay_SingleBalBillEdit1.html">
      <publishTime>07/18/2023 10:57:22</publishTime>
@@ -2718,7 +2718,7 @@
      <publishTime>10/19/2021 09:27:19</publishTime>
    </File>
    <File Include="views/工资管理/工资结算单%28集体%29/Pay_GroupBalBillEdit.html">
      <publishTime>07/20/2023 18:48:24</publishTime>
      <publishTime>07/21/2023 15:04:29</publishTime>
    </File>
    <File Include="views/工资管理/工资结算单%28集体%29/Pay_GroupBalBillEdit1.html">
      <publishTime>04/11/2023 16:34:43</publishTime>

 WebTM/views/ÈËʹÜÀí/ÈëÖ°ÉêÇë/HR_EmpEngageRequestBill.html

@@ -580,6 +580,29 @@
            //#endregion
            //#endregion

            //#region æ–‡æœ¬æ¡†ç›‘听
            $(document).ready(function () {
                //#region åˆå§‹æ—¥æœŸæ–‡æœ¬æ¡†ç›‘听
                $("#HBirthday").on('input proprytychange', function (data) {
                    if (data.currentTarget.value == "") {
                        $("#HAge").val("");
                    } else {
                        var HBirthDay = data.currentTarget.value;                       //出生日期
                        var HToday = Format(new Date(), "yyyy-MM-dd");                  //当天日期
                        var year = HToday.split("-")[0] - HBirthDay.split("-")[0];      
                        var month = HToday.split("-")[1] - HBirthDay.split("-")[1];
                        var day = HToday.split("-")[2] - HBirthDay.split("-")[2];
                        if (month > 0 || (month == 0 && day >= 0)) {
                            $("#HAge").val(year);
                        } else {
                            $("#HAge").val(year-1);
                        }
                    }
                });
                //#endregion
            });
            //#endregion 

            //#region æ“ä½œæŒ‰é’®è§¦å‘事件
            //#region ä¿å­˜æäº¤
            form.on('submit(btnSave)', function (data) {//提交

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

@@ -560,7 +560,216 @@
            })
            //#endregion

            //#region å­è¡¨ï¼šå•å…ƒæ ¼ç¼–辑监听
            table.on('edit(mainTable)', function (obj) {
                // å•å…ƒæ ¼ç¼–辑之前的值
                var oldText = $(this).prev().text();
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段
                //正则表达式-校验非负浮点数
                var ref = /^\d+(\.\d+)?$/;

                switch (field) {
                    case "HQty":                                            //数量
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HQty: oldText
                            });
                            layer.msg("数量：数据错误，请输入非负小数")
                        } else {
                            var HQty = value;                               //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;             //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                            });
                        }
                        break;
                    case "HPrice":                                          //工价
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HPrice: oldText
                            });
                            layer.msg("工价：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = value;                             //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;             //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                            });
                        }
                        break;
                    case "HPriceRate":                                      //定额浮动比率
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HPriceRate: oldText
                            });
                            layer.msg("定额浮动比率：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = value;                         //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;             //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                            });
                        }
                        break;
                    case "HSubsidyQty":                                     //补贴数量
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HSubsidyQty: oldText
                            });
                            layer.msg("补贴数量：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = value;                        //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                                , HSubsidyMoney: HSubsidyQty * HPrice                                                                                       //补贴金额=补贴数量*工价
                            });
                        }
                        break;
                    case "HSubsidyTotal":                                       //补贴合计
                        if (!ref.test(value)) {                                 //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HSubsidyTotal: oldText
                            });
                            layer.msg("补贴合计：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;              //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;         //扣款小计
                            var HSubsidyTotal = value * 1;                  //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                            });
                        }
                        break;
                    case "HDeuctTotal":                                         //扣款小计
                        if (!ref.test(value)) {                                 //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HDeuctTotal: oldText
                            });
                            layer.msg("扣款小计：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;              //补贴数量

                            var HPackQty = data.HPackQty;                   //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = value * 1;                    //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;      //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                            });
                        }
                        break;
                    case "HPackQty":                                        //包装数量
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HPackQty: oldText
                            });
                            layer.msg("包装数量：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = data.HPrice;                       //工价
                            var HPriceRate = data.HPriceRate;               //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;              //补贴数量

                            var HPackQty = value;                          //包装数量
                            var HPackPrice = data.HPackPrice;               //包装单价

                            var HDeuctTotal = data.HDeuctTotal * 1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal * 1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                                , HPackMoney: HPackQty * HPackPrice                                                                                         //包装金额= åŒ…装数量*包装单价
                            });
                        }
                        break;
                    case "HPackPrice":                                          //包装单价
                        if (!ref.test(value)) {                                 //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HPackPrice: oldText
                            });
                            layer.msg("包装单价：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                               //数量
                            var HPrice = data.HPrice;                           //工价
                            var HPriceRate = data.HPriceRate;                   //定额浮动比率

                            var HSubsidyQty = data.HSubsidyQty;                 //补贴数量

                            var HPackQty = data.HPackQty;                       //包装数量
                            var HPackPrice = value;                             //包装单价

                            var HDeuctTotal = data.HDeuctTotal*1;               //扣款小计
                            var HSubsidyTotal = data.HSubsidyTotal*1;           //补贴合计

                            obj.update({
                                HMoney: (HQty * HPrice * HPriceRate) + (HSubsidyQty * HPrice) + (HPackQty * HPackPrice) + HSubsidyTotal - HDeuctTotal       //金额= (数量*单价*定额浮动比率) + (补贴数量*工价) + (包装数量*包装单价) - è¡¥è´´åˆè®¡ - æ‰£æ¬¾å°è®¡
                                , HPackMoney: HPackQty * HPackPrice                                                                                         //包装金额= åŒ…装数量*包装单价
                            });
                        }
                        break;
                    default:
                }
            });
            //#endregion

            //
            form.on('submit(Cancel)', function () {
@@ -644,15 +853,15 @@
                        , { field: 'HEmpNumber', title: '职员代码', edit: 'text', event: "HEmpNumber" }     //f7
                        , { field: 'HEmpName', title: '职员名称' }
                        , { field: 'HTimes', title: '工时', edit: 'text'}
                        , { field: 'HQty', title: '数量', edit: 'text', event: "HQty" }
                        , { field: 'HPrice', title: '工价', edit: 'text', event: "HPrice" }
                        , { field: 'HPriceRate', title: '定额浮动比率', edit: 'text', event: "HPriceRate" }
                        , { field: 'HSubsidyQty', title: '补贴数量', edit: 'text', event: "HSubsidyQty" }
                        , { 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', event: "HSubsidyTotal" }
                        , { field: 'HDeuctTotal', title: '扣款小计', edit: 'text', event: "HDeuctTotal" }
                        , { field: 'HPackQty', title: '包装数量', edit: 'text', event: "HPackQty" }
                        , { field: 'HPackPrice', title: '包装单价', edit: 'text', event: "HPackPrice" }
                        , { field: 'HSubsidyTotal', title: '补贴合计', edit: 'text' }
                        , { field: 'HDeuctTotal', title: '扣款小计', edit: 'text' }
                        , { field: 'HPackQty', title: '包装数量', edit: 'text' }
                        , { field: 'HPackPrice', title: '包装单价', edit: 'text' }
                        , { field: 'HPackMoney', title: '包装金额'}
                        , { field: 'HPackMaterID', title: '包装类型ID', hide: true }
                        //, { field: 'HPackMaterNumber', title: '包装类型代码' }     //f7

 WebTM/views/¹¤×ʹÜÀí/¹¤×ʽáËãµ¥(¼¯Ìå)/Pay_GroupBalBillEdit.html

@@ -674,6 +674,51 @@
            });
            //#endregion

            //#region å­è¡¨1：单元格编辑监听
            table.on('edit(mainTable)', function (obj) {
                // å•å…ƒæ ¼ç¼–辑之前的值
                var oldText = $(this).prev().text();
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段
                //正则表达式-校验非负浮点数
                var ref = /^\d+(\.\d+)?$/;

                switch (field) {
                    case "HQty":                                            //数量
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HQty: oldText
                            });
                            layer.msg("数量：数据错误，请输入非负小数")
                        } else {
                            var HQty = value;                               //数量
                            var HPrice = data.HPrice;                       //工价
                           
                            obj.update({
                                HMoney: HQty * HPrice                       //金额= æ•°é‡*工价
                            });
                        }
                        break;
                    case "HPrice":                                          //工价
                        if (!ref.test(value)) {                             //若输入值格式不正确，则变回原来的值
                            obj.update({
                                HPrice: oldText
                            });
                            layer.msg("工价：数据错误，请输入非负小数")
                        } else {
                            var HQty = data.HQty;                           //数量
                            var HPrice = value;                             //工价
                           
                            obj.update({
                                HMoney: HQty * HPrice                       //金额= æ•°é‡*工价
                            });
                        }
                        break;
                    default:
                }
            });
            //#endregion
     
            //
            form.on('submit(Cancel)', function () {
@@ -762,7 +807,7 @@
                        , { field: 'HTimes', title: '工时', edit: 'text' }
                        , { field: 'HQty', title: '数量', edit: 'text' }
                        , { field: 'HPrice', title: '工价', edit: 'text' }
                        , { field: 'HMoney', title: '金额', edit: 'text' }
                        , { field: 'HMoney', title: '金额' }
                        , { field: 'HRemark', title: '备注', edit: 'text' }
                        , { field: 'HICMOInterID', title: '生产任务单ID' }
                        , { field: 'HICMOBillNo', title: '生产任务单号'}