工艺路线工序添加tableSelect

wtt

2025-02-05 452c8e50b38939cccfebfc36588ae0f3a36b6fc8

工艺路线工序添加tableSelect

 WebTM/layuiadmin/modules/tableSelect.js

@@ -43,7 +43,7 @@
            //渲染TABLE
            opt.table.elem = "#"+tableName;
            opt.table.id = tableName;
            //若没有where表示为前端分页
            //若没有url表示为前端分页
            if (opt.table.url != undefined) {
                opt.table.where['sWhere'] = opt.sWhere
            } else {
@@ -247,7 +247,13 @@
            //按钮选中
            tableBox.find('.tableSelect_btn_select').on('click', function() {
                var checkStatus = table.checkStatus(tableName);
                selectDone(checkStatus);
                if (checkStatus.data.length > 0) {
                    selectDone(checkStatus);
                } else {
                    tableBox.remove();
                    delete table.cache[tableName];
                }
                
            })

            //写值回调和关闭

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

@@ -555,7 +555,7 @@
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'table', 'element'], function () {
        }).use(['index', 'form', 'laydate', 'table', 'element','tableSelect'], function () {

            //#region å…¬å…±å˜é‡

@@ -564,7 +564,8 @@
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , element = layui.element;
                , element = layui.element
                , tableSelect = layui.tableSelect;

            //定义全局变量
            var HReasonName, ReasonID, EmpName, SQProcName,
@@ -2596,6 +2597,146 @@
                    }

                })

                //工序表格下拉搜索框
                tableSelect.render({
                    elem: 'td[data-field="工序"] .layui-table-edit',
                    searchKey: '工序代码,工序名称',
                    sWhere: " and æ˜Žç»†æ ‡è®° = 'Y' and ç¦ç”¨æ ‡è®° != 'Y'",//table搜索sWhere条件
                    ajaxSelect: function (sWhere) {
                        var data = '';
                        $.ajax({
                            url: GetWEBURL() + '/Gy_Process/list',
                            type: "GET", 
                            data: { "sWhere": sWhere, "user": '翁涛涛'},
                            async: false,
                            success: function (data1) {
                                if (data1.count == 1) {
                                    data = data1.data
                                }
                            },
                            error: function () {
                                layer.alert('获取列表失败！', { icon: 15, title: '通信错误' });
                            }
                        });
                        return data;
                    },//设置前端分页时可以设置的
                    table: {
                        cols: [[
                            { type: 'radio', fixed: 'left' },
                            { field: 'HItemID', title: 'HItemID', hide: true  },
                            { field: '工序代码', title: '工序代码' },
                            { field: '工序名称', title: '工序名称' },
                            { field: 'HProcMulID', title: 'HProcMulID', hide: true },
                            { field: '工段名称', title: '工段名称' }
                        ]],
                        page: true,
                        limit: 5,
                        //limits: [5]
                    },
                    done: function (elem, data) {
                        $(".layui-table-edit").blur();//单元格失去焦点
                        //获取工序代码
                        var ProcessNumber = [];
                        for (var i = 0; i < data.data.length; i++) {
                            ProcessNumber.push("'" + data.data[i]["工序代码"] + "'");
                        }

                        //获取当前位置所在行数
                        var NowNum = 0;
                        for (var i = 0; i < option.data.length; i++) {
                            if (obj.data["HProcNo"] == option.data[i]["HProcNo"]) {
                                NowNum = i + 1;
                            }
                        }

                        //查询工作中心的数据
                        var WorkCente = [];
                        var sWhere = "select  isnull(a.HItemID,'') HCenterID, isnull(a.HNumber,'') å·¥ä½œä¸­å¿ƒä»£ç , isnull(a.HName,'') å·¥ä½œä¸­å¿ƒåç§° ,p.HItemID HProcID,p.HName å·¥åºåç§°  from Gy_Process p left join Gy_WorkCenter a on p.HWorkCenterID=a.HItemID  where p.HNumber in (" + ProcessNumber.toString() + ") order by p.HNumber ";
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "/Gy_SOPBillList/WindowPrintList", //方法所在页面和方法名
                            async: false,
                            data: { "sWhere": sWhere },
                            success: function (data) {
                                if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                    WorkCente = data.data;
                                }
                                else {
                                    layer.msg(data.Message, { icon: 5 });
                                }
                                layer.closeAll("loading");
                            },
                            error: function (err) {
                                layer.msg("错误:" + err, { icon: 5 });
                            }
                        });

                        //判断选择的数据总数 æ˜¯å¦å¤§äºŽè¡¨æ ¼çŽ°æœ‰çš„数据
                        if (ProcessNumber.length > option.data.length - (NowNum - 1)) {
                            //获取表格剩余行数量
                            var num = ProcessNumber.length - option.data.length + (NowNum - 1);
                            //循环赋值  åœ¨å·²æœ‰çš„表格赋值
                            var j = 0;
                            for (var i = (NowNum - 1); i < option.data.length; i++) {
                                option.data[i]["工序"] = WorkCente[j]["工序名称"];
                                option.data[i]["工序代码"] = ProcessNumber[j].substring(1, ProcessNumber[j].length - 1);
                                option.data[i]["HProcID"] = WorkCente[j]["HProcID"];
                                option.data[i]["工作中心"] = WorkCente[j]["工作中心名称"];
                                option.data[i]["HCenterID"] = WorkCente[j]["HCenterID"];
                                option.data[i]["工作中心代码"] = WorkCente[j]["工作中心代码"];
                                option.data[i]["HProcID_S"] = data.data[j]["HProcMulID"];
                                option.data[i]["工段"] = data.data[j]["工段名称"];
                                j++;
                            }

                            //在下方添加新的表格数据
                            for (var i = 0; i < num; i++) {
                                option.data.push({
                                    "HProcNo": (table.cache["mainTable"].length + i + 1) * 10, "HProcID_S": 0, "HProcType": "主工序", "HCenterID_S": 0, "HCenterID_SName": "", "工序代码": ProcessNumber[j].substring(1, ProcessNumber[j].length - 1)
                                    , "HWorkQty_S": 0, "HSubStdEmpQty_S": 0, "HMouldNo": "", "HChangeMould": 0, "HPackStd": ""
                                    , "HPack": "", "HPutArea": "", "HMyWorkDays": 0, "HMyFixWorkDays": 0, "工序": WorkCente[j]["工序名称"]
                                    , "HProcID": WorkCente[j]["HProcID"], "工作中心代码": WorkCente[j]["工作中心代码"], "HCenterID": WorkCente[j]["HCenterID"], "工作中心": WorkCente[j]["工作中心名称"], "HSupID": 0
                                    , "供应商代码": "", "供应商": "", "HSupFlag": false, "HSortProcFlag": false, "HTimeUnit": "", "HUnitTime": 0
                                    , "HWorkQty": 1, "HSNCtrl": false, "HPassRate": 100, "HOverRate": 0, "HReadyTime": 0, "HQueueTime": 0
                                    , "HMoveTime": 0, "HNextProcFlag": false, "HFlowProc": false, "HSubStdEmpQty": 0, "HSubCanUseSourceQty": 0
                                    , "HFixPrice": 0, "HProcPrice": 0, "HBadPrice": 0, "HWasterPrice": 0, "HStdFlag": false
                                    , "HBeginDayQty": 0, "HBeginFixQty": 0, "HFixWorkDays": 0, "HTrunWorkDays": 0, "HReadyTimes": 0
                                    , "HICMOReadyTimes": 0, "HAutoTrunFlag": false, "HTechnologyParameter": "", "HPicNum": "", "HProcCheckNote": ""
                                    , "HProcWorkNum": "", "HBadWHID": 0, "HBadWHName": "", "HWasterWHID": 0, "HWasterWHName": ""
                                    , "HWHID": 0, "HWHName": "", "HRemark": "", "HWorkTimes_S": 0
                                    , "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
                                    , "HSubStdEmpAvg_S": 0
                                })
                                j++;
                            }
                        } else {
                            //循环赋值  åœ¨å·²æœ‰çš„表格赋值
                            var j = 0;
                            for (var i = (NowNum - 1); i < (NowNum - 1) + ProcessNumber.length; i++) {
                                option.data[i]["工序"] = WorkCente[j]["工序名称"];
                                option.data[i]["工序代码"] = ProcessNumber[j].substring(1, ProcessNumber[j].length - 1);
                                option.data[i]["HProcID"] = WorkCente[j]["HProcID"];
                                option.data[i]["工作中心"] = WorkCente[j]["工作中心名称"];
                                option.data[i]["HCenterID"] = WorkCente[j]["HCenterID"];
                                option.data[i]["工作中心代码"] = WorkCente[j]["工作中心代码"];
                                option.data[i]["HProcID_S"] = data.data[j]["HProcMulID"];
                                option.data[i]["工段"] = data.data[j]["工段名称"];
                                j++;
                            }
                        }
                        table.render(option);



                        //setTableByHMater(obj, data);
                    }
                })


            }

            //编辑 é¡µé¢èµ‹å€¼