WebTM/views/³µ¼ä¹ÜÀí/¹¤ÐòÁ÷ת¿¨/Gy_ProcessBatchReport.html
@@ -159,8 +159,11 @@
                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                            <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="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="btn_PaddingQty"><i class="layui-icon layui-icon-form"></i>填充数量</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_PaddingEmp"><i class="layui-icon layui-icon-form"></i>填充操作员</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                        </div>
                    </script>
                </form>
@@ -178,6 +181,10 @@
        <option value="false">否</option>
        <option value="true">是</option>
    </select>
</script>
<!--复选框(转下道)-->
<script type="text/html" id="HLastSubProc">
    <input type="checkbox" value="{{d.HLastSubProc}}" lay-skin="primary" id="HLastSubProc{{d.LAY_TABLE_INDEX+1}}" lay-filter="HLastSubProc" {{ d.HLastSubProc == 1 ? 'checked' : '' }} disabled>
</script>
<script>
    layui.config({
@@ -197,7 +204,8 @@
        var option;
        var StationOutID = [];
        var StationOutBillNo = [];
        var HModName = "Gy_ProcessBatchReport";
        var HEmpNumber_Enter = "";
        //#endregion
        //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -263,7 +271,8 @@
                "HSourceID": 0, "HSourceNumber": "", "HSourceName": "", "HEmpID": 0, "HEmpNumber": "", "HEmpName": "",
                "HPlanQty": 0, "HQty": 0, "HWasterQty": 0, "HICMOBillNo": "", "HICMOInterID": 0, "HICMOEntryID": 0,
                "HInterID": 0, "HBillNo": "", "HProcID": 0, "HCenterID": 0, "HWorkCenterNumber": "", "HWorkCenterName": "",
                "HICMOQty": 0, "HPlanQty": 0
                "HICMOQty": 0, "HProcessExchangeQty": 0, "HLastSubProc": true, "HMainSourceInterID": 0, "HMainSourceEntryID": 0, "HMainSourceBillNo": "",
                "NoOutboundHqty":0
            };
            switch (obj.event) {
@@ -295,6 +304,26 @@
                        }
                        form.render('select');
                    }
                    break;
                //填充数量
                case 'btn_PaddingQty':
                    if (data.length != 1) {
                        layer.msg("请勾选一行数据获取需要填充的数量!");
                    }
                    PaddingQty(data, obj);
                    break;
                //填充操作员
                case 'btn_PaddingEmp':
                    if (data.length != 1) {
                        layer.msg("请勾选一行数据获取需要填充的操作员!");
                    }
                    PaddingEmp(data, obj);
                    break;
                //列设置
                case 'set_HideColumn':
                    get_HideColumn();
                    break;
            }
        });
@@ -341,9 +370,24 @@
                    }
                    $input.val(val.replace(/[^\d]/g, ''));
                });
            } else if (obj.event == 'HEmpNumber') {
                $(obj.tr).find(".layui-table-edit").keyup(function () {
                    var $input = $(this), val = $input.val();
                    if (!val) {
                        val = "0";
                    }
                    if (val.length > 1) {
                        var firstNum = val.substring(0, 1); //截取字符串第一位数,判断是否为0;
                        if (firstNum == 0) { //如果第一位数为0,则删除第一位数
                            val = val.substring(1, val.length);
                        }
                    }
                    //$input.val(val.replace(/[^\d]/g, ''));
                    HEmpNumber_Enter = val;
                });
            }
            //#region [ è¡¨ä½“F7事件 ]
            //#region [ è¡¨ä½“F7,回车事件 ]
            $(document).off('keydown', ".layui-table-edit").on('keydown', '.layui-table-edit', function (e) {
                if (event.key == "F7") {
                    if (obj.event == 'HSourceCheck') {
@@ -415,6 +459,31 @@
                    obj.event = "";
                    return false;
                }
                if (event.key == "Enter") {
                    if (obj.event == 'HEmpNumber') {
                        $.ajax({
                            url: GetWEBURL() + '/Cj_StationInBill/GetMessageByEmpNumber',
                            type: "GET",
                            data: { "HEmpNumber": HEmpNumber_Enter },
                            success: function (data1) {
                                if (data1.count == 1) {
                                    obj.update({
                                        HEmpName: data1.data[0].HName
                                        , HEmpID: data1.data[0].HItemID
                                        , HEmpNumber: data1.data[0].HNumber
                                    });
                                }
                                else {
                                    layer.alert(data1.code + data1.Message, { icon: 5 });
                                }
                            }, error: function () {
                                layer.alert("接口请求失败!", { icon: 5 });
                            }
                        });
                    }
                    obj.event = "";
                    return false;
                }
            })
            //#endregion
@@ -438,6 +507,18 @@
        //打印
        form.on('submit(btn_print)', function (data) {
            get_print(data);
        });
        //转下道
        form.on('checkbox(HLastSubProc)', function (data) {
            //获取下拉框选中的值
            var elem = data.othis.parents('tr');
            var dataindex = elem.attr("data-index");
            $.each(option.data, function (index, value) {
                if (value.LAY_TABLE_INDEX == dataindex) {
                    value.HLastSubProc = data.elem.checked;//把选中下拉框id值赋值给表格缓存
                }
            });
        });
        //#region æ­¤é¡µé¢æ‰€æœ‰çš„æ–¹æ³•
@@ -480,8 +561,6 @@
                , { type: 'numbers', title: '序号', totalRow: true }
                , { field: 'lngBillKey', title: '流转卡ID', hide: true }
                , { field: 'lngBillSubKey', title: '流转卡子ID', hide: true }
                , { field: 'HCenterID', title: '工作中心ID', hide: true }
                , { field: 'HWorkCenterName', title: '工作中心名称' }
                , { field: 'HSourceBillType', title: '单据类型', hide: true }
                , { field: 'HProcNo', title: '流水号', width: 80 }
                , { field: 'HICMOQty', title: '任务单数量', hide: true }
@@ -489,25 +568,32 @@
                , { field: 'HProcID', title: '工序ID', hide: true }
                , { field: 'HProcName', title: '工序名称' }
                , { field: 'HMaterID', title: '产品ID', hide: true }
                , { field: 'HMaterNumber', title: '产品代码'}
                , { field: 'HMaterNumber', title: '产品代码' }
                , { field: 'HMaterName', title: '产品名称' }
                , { field: 'HMaterModel', title: '规格型号' }
                , { field: 'HQty', title: '合格数量', edit: 'text', width: 90, event:"inputHQty" }
                , { field: 'HQty', title: '合格数量', edit: 'text', width: 90, event: "inputHQty" }
                , { field: 'HWasterQty', title: '报废数量', edit: 'text', width: 90, event: "inputWasterHQty" }
                , { field: 'HEmpID', title: '操作员ID', hide: true }
                , { field: 'HEmpNumber', title: '操作员代码', edit: 'text', event: "HEmpNumber" }
                , { field: 'HEmpName', title: '操作员名称' }
                , { field: 'HProcExchBillNo', title: '派工单号', width: 150 }
                , { field: 'HPlanQty', title: '流转卡数量', width: 100 }
                , { field: 'HProcExchBillNo', title: '流转卡号', width: 150 }
                , { field: 'HProcessExchangeQty', title: '流转卡数量', width: 100 }
                , { field: 'NoOutboundHqty', title: '未出站数量', width: 100 }
                , { field: 'HInterID', title: '工序汇报ID', hide: true }
                , { field: 'HBillNo', title: '工序汇报单号', width: 195 }
                , { field: 'HWorkCenterNumber', title: '工作中心代码', edit: 'text'}
                , { field: 'HCenterID', title: '工作中心ID', hide: true }
                , { field: 'HWorkCenterNumber', title: '工作中心代码', edit: 'text' }
                , { field: 'HWorkCenterName', title: '工作中心名称' }
                , { field: 'HSourceID', title: '生产资源ID', hide: true }
                , { field: 'HSourceNumber', title: '生产资源代码', edit: 'text', event: "HSourceCheck" }
                , { field: 'HSourceName', title: '生产资源名称' }
                , { field: 'HLastSubProc', title: '转下道', templet: '#HLastSubProc', unresize: false }
                , { field: 'HICMOBillNo', title: '任务单号', hide: true }
                , { field: 'HICMOInterID', title: '任务单ID', hide: true }
                , { field: 'HICMOEntryID', title: '任务单子内码', hide: true }
                , { field: 'HMainSourceInterID', title: '源单内码', hide: true }
                , { field: 'HMainSourceEntryID', title: '源单子内码', hide: true }
                , { field: 'HMainSourceBillNo', title: '源单单号', hide: true }
                //, { fixed: 'right', title: '操作', toolbar: '#barDemo' }
            ];
            option = {
@@ -543,7 +629,8 @@
                "HProcNo": 0, "HProcName": "", "HMaterID": 0, "HMaterNumber": "", "HMaterName": "", "HMaterModel": "",
                "HSourceID": 0, "HSourceNumber": "", "HSourceName": "", "HEmpID": 0, "HEmpNumber": "", "HEmpName": "",
                "HPlanQty": 0, "HQty": 0, "HWasterQty": 0, "HICMOBillNo": "", "HICMOInterID": 0, "HICMOEntryID": 0, "HInterID": 0,
                "HBillNo": "", "HProcID": 0, "HCenterID": 0, "HWorkCenterNumber": "", "HWorkCenterName": "", "HICMOQty": 0, "HPlanQty": 0
                "HBillNo": "", "HProcID": 0, "HCenterID": 0, "HWorkCenterNumber": "", "HWorkCenterName": "", "HICMOQty": 0, "HProcessExchangeQty": 0,
                "HLastSubProc": true, "HMainSourceInterID": 0, "HMainSourceEntryID": 0, "HMainSourceBillNo": "", "NoOutboundHqty": 0
            }];
            table.render(option);
@@ -566,13 +653,16 @@
                                    "lngBillKey": result.data[i]["hmainid"], "lngBillSubKey": result.data[i]["HEntryID"], "HProcExchBillNo": result.data[i]["单据号"], "HSourceBillType": result.data[i]["HBillType"],
                                    "HProcNo": result.data[i]["流水号"], "HProcName": result.data[i]["工序名称"], "HMaterID": result.data[i]["HMaterID"], "HMaterNumber": result.data[i]["产品代码"], "HMaterName": result.data[i]["产品名称"], "HMaterModel": result.data[i]["规格型号"],
                                    "HSourceID": result.data[i]["HSourceID"], "HSourceNumber": result.data[i]["生产资源代码"], "HSourceName": result.data[i]["生产资源"], "HEmpID": result.data[i]["HWorkerID"], "HEmpNumber": result.data[i]["操作工代码"], "HEmpName": result.data[i]["操作工"],
                                    "HPlanQty": result.data[i]["流转卡数量"], "HQty": 0, "HWasterQty": 0, "HICMOBillNo": result.data[i]["任务单号"], "HICMOInterID": result.data[i]["hicmointerid"], "HICMOEntryID": result.data[i]["HICMOEntryID"], "HBillNo": StationOutBillNo[i], "HInterID": StationOutID[i], "HProcID": result.data[i]["HProcID"], "HCenterID": result.data[i]["HCenterID"], "HWorkCenterNumber": result.data[i]["工作中心代码"], "HWorkCenterName": result.data[i]["工作中心"]
                                    "HProcessExchangeQty": result.data[i]["流转卡数量"], "HQty": 0, "HWasterQty": 0, "HICMOBillNo": result.data[i]["任务单号"], "HICMOInterID": result.data[i]["hicmointerid"], "HICMOEntryID": result.data[i]["HICMOEntryID"], "HICMOQty": result.data[i]["生产订单数量"], "HBillNo": StationOutBillNo[i], "HInterID": StationOutID[i], "HProcID": result.data[i]["HProcID"], "HCenterID": result.data[i]["HCenterID"], "HWorkCenterNumber": result.data[i]["工作中心代码"], "HWorkCenterName": result.data[i]["工作中心"], "HLastSubProc": true, "HMainSourceInterID": result.data[i]["源单主内码"], "HMainSourceEntryID": result.data[i]["源单子内码"], "HMainSourceBillNo": result.data[i]["流转卡号"], "NoOutboundHqty": Number(result.data[i]["流转卡数量"]) - Number(result.data[i]["出站报废关联数量"]) - Number(result.data[i]["出站关联数量"])
                                }
                            )
                        }
                        option.data = rowdata;
                        table.render(option);
                        form.render('select');
                        //刷新表格数据
                        DisPlay_HideColumn();
                    } else {
                        layer.msg(result.code + result.Message, { icon: 5 });
                    }
@@ -604,9 +694,9 @@
                        layer.msg("第" + (i + 1) + "行:操作员不能为空!");
                        return false;
                    }
                    //派工单号不为空
                    //流转卡号
                    if (option.data[i]["lngBillKey"] == "0") {
                        layer.msg("第" + (i + 1) + "行:派工单不能为空!");
                        layer.msg("第" + (i + 1) + "行:流转卡不能为空!");
                        return false;
                    }
                    //物料不为空
@@ -636,7 +726,6 @@
            var sMainStr = JSON.stringify(data.field);
            var sSubStr = JSON.stringify(num_1);
            var sMainSub = sMainStr + ';' + sessionStorage["HUserName"] + ';' + sSubStr + ";" + OperationType;
            var index = layer.load();
            $.ajax({
                type: "POST",
@@ -662,6 +751,30 @@
            });
        }
        //填充汇报数量
        function PaddingQty(data, obj) {
            //获取当前行的索引
            var rowIndex = $(obj.tr).attr("data-index");
            for (let i = 0; i < option.data.length; i++) {
                option.data[i].HQty = data[0].HQty;
                option.data[i].HWasterQty = data[0].HWasterQty;
            }
            table.render(option);
        }
        //填充操作员
        function PaddingEmp(data, obj) {
            for (let i = 0; i < option.data.length; i++) {
                option.data[i].HEmpID = data[0].HEmpID;
                option.data[i].HEmpNumber = data[0].HEmpNumber;
                option.data[i].HEmpName = data[0].HEmpName;
            }
            table.render(option);
        }
        function get_UrlVars() {
            var vars = [], hash;
            var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
@@ -673,6 +786,127 @@
            return vars;
        }
        //隐藏列设置
        function get_HideColumn() {
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;
            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }
        //显示列数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {
                        var dataCol = [];//数据库查询出的列数据
                        var titleData = ["单据类型", "任务单数量", "任务单号", "计划数量", "流转卡ID", "流转卡子ID", "工序ID", "产品ID", "操作员ID", "工序汇报ID", "工作中心ID", "任务单ID", "生产资源ID", "源单内码", "源单子内码", "源单单号", "任务单子内码"];//不需要显示的字段 å¯æ‰©å±•
                        dataCol = data1.data[0].HGridString.split(',');
                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                            if (dataCol[i]) {
                                var dataCols = dataCol[i].split('|');
                            }
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //设置列宽
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //}
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(å·¦ å±…中 å³)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }
                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }
        //#endregion
    })
</script>