增加 BOM层级展开报表,修复全程追溯报表 黑白标页签导出失败,工艺路线的表头查询优化页面排序

zrg

2025-01-17 3d240d150e6e1a4e2df1a9f87d00ddd03ace4ee5

 WebTM/views/¼Æ»®¹ÜÀí/¹¤ÒÕ·Ïß/Gy_RoutingBill.html

@@ -588,6 +588,7 @@
                , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                ,"HSubStdEmpAvg_S": 0
            }];
            var HModName = "Gy_RoutingBill";
            //#endregion
@@ -648,7 +649,9 @@
                    , { field: 'HQCSchemeID_Patrol', title: '巡检检验方案ID', hide: true }//f7
                    , { field: 'HQCSchemeNumber_Patrol', title: '巡检检验方案代码', edit: 'text', event: "HQCSchemeNumber_Patrol", width: 125 }
                    , { field: 'HQCSchemeName_Patrol', title: '巡检检验方案名称', width: 125 }//f7

                    , { field: 'HWorkQty', title: '加工数量', edit: 'text', width: 125 }
                    , { field: 'HSubStdEmpQty_S', title: '产线人数', edit: 'text', width: 125 }
                    , { field: 'HSubStdEmpAvg_S', title: '人均产能', edit: 'text', width: 125}
                    //, { field: 'HPassRate', title: '良率', edit: 'text' }//默认
                    //, { field: 'HProcID_S', title: '工段', edit: 'text' }
                    ////, { field: 'HCenterID_S', title: '产线中心id', hide: true }//hide: true
@@ -682,7 +685,8 @@
                    //, { field: 'HAutoTrunFlag', title: '自动移转', templet: "#HAutoTrunFlag" }//chenbox
                    //, { field: 'HProcCheckNote', title: '本工序确认记录', edit: 'text' }
                    //, { field: 'HProcWorkNum', title: '程序号', edit: 'text' }
                    //, { field: 'HWorkTimes_S', title: '产品单件工时', edit: 'text' }
                    /* , { field: 'HWorkTimes_S', title: '产品单件工时', edit: 'text' }*/
                    , { field: 'HWorkTimes_S', title: '单件生产节拍', edit: 'text' }
                    , { fixed: 'right', title: '操作', toolbar: '#barDemo' }
                ]]
                //, done: function (res, curr, count) {
@@ -1204,6 +1208,7 @@
                    , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                    , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                    , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                    , "HSubStdEmpAvg_S": 0
                };
                switch (obj.event) {
                    case 'btn-AddLine':
@@ -1368,6 +1373,33 @@
                }
            })

            //明细网格单元格编辑事件
            table.on('edit(mainTable)', function (obj) {
                var value = obj.value //得到修改后的值
                    , data = obj.data //得到所在行所有键值
                    , field = obj.field; //得到字段
                switch (field) {
                    case 'HSubStdEmpQty_S': //产线人数
                        if (value != 0 && value != "" && data.HSubStdEmpAvg_S != 0 && data.HSubStdEmpAvg_S != "") {
                            //同步更新表格和缓存对应的值
                            obj.update({
                                HWorkQty: Number((value * data.HSubStdEmpAvg_S).toFixed(2))
                            });
                            //table.render(option)
                        }                       
                        break;
                    case 'HSubStdEmpAvg_S': //产线人均产能
                        if (value != 0 && value != "" && data.HSubStdEmpQty_S != 0 && data.HSubStdEmpQty_S != "") {
                            //同步更新表格和缓存对应的值
                            obj.update({
                                HWorkQty: Number((value * data.HSubStdEmpQty_S).toFixed(2))
                            });
                            //table.render(option)
                        }
                        break;
                }
            })

            $('#HName').on('keydown', function (event) {//工艺路线名称
                if (event.keyCode == 118) {
                    layer.msg("工艺路线名称F7按钮")
@@ -1376,7 +1408,7 @@

            //保存提交
            form.on('submit(btnSave)', function (data) {//提交
                const procNos = table.cache["mainTable"].map(item => item.HProcNo);
                const procNos = table.cache["mainTable"].map(item => Number(item.HProcNo));
                if (isSortedAscending(procNos) && haveHProcNO9999()) {
                    if (AllowLoadData(data)) {
                        set_AddNew(data);
@@ -2208,7 +2240,8 @@
                                                , "HQCSchemeID_Fst": 0, "HQCSchemeNumber_Fst": "", "HQCSchemeName_Fst": ""
                                                , "HQCSchemeID_Proc": 0, "HQCSchemeNumber_Proc": "", "HQCSchemeName_Proc": ""
                                                , "HQCSchemeID_Patrol": 0, "HQCSchemeNumber_Patrol": "", "HQCSchemeName_Patrol": ""
                                                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false,"HMaterToSourceCtrl":false
                                                , "HQCFst": false, "HQCProc": false, "HQCPatrol": false, "HMaterToSourceCtrl": false
                                                , "HSubStdEmpAvg_S": 0
                                            })
                                            j++;
                                        }
@@ -2655,6 +2688,7 @@
                                    , "HQCSchemeID_Proc": d.data[i].HQCSchemeID_Proc, "HQCSchemeNumber_Proc": d.data[i].转序检验方案代码, "HQCSchemeName_Proc": d.data[i].转序检验方案
                                    , "HQCSchemeID_Patrol": d.data[i].HQCSchemeID_Patrol, "HQCSchemeNumber_Patrol": d.data[i].巡检检验方案代码, "HQCSchemeName_Patrol": d.data[i].巡检检验方案
                                    , "HQCFst": d.data[i].HQCFst == 1 ? true : false, "HQCProc": d.data[i].HQCProc == 1 ? true : false, "HQCPatrol": d.data[i].HQCPatrol == 1 ? true : false, "HMaterToSourceCtrl": d.data[i].HMaterToSourceCtrl == 1 ? true : false
                                    , "HSubStdEmpAvg_S": d.data[i].人均产能
                                }
                            )
                        }
@@ -2713,6 +2747,14 @@
                for (var i = 0; i < table.cache["mainTable"].length; i++) {
                    if (table.cache["mainTable"][i] != "") {
                        table.cache["mainTable"][i].LAY_TABLE_INDEX = i;

                        //加工数量=产线人数 * äº§çº¿äººå‡äº§èƒ½
                        if (table.cache["mainTable"][i].HSubStdEmpQty_S != 0 && table.cache["mainTable"][i].HSubStdEmpQty_S != "" && table.cache["mainTable"][i].HSubStdEmpAvg_S != 0 && table.cache["mainTable"][i].HSubStdEmpAvg_S != "") {

                            table.cache["mainTable"][i].HWorkQty = Number((table.cache["mainTable"][i].HSubStdEmpQty_S * table.cache["mainTable"][i].HSubStdEmpAvg_S).toFixed(2))

                        }

                        num.push(table.cache["mainTable"][i])
                    }                 
                }