指导书

yusijie

2024-04-25 8e2b58a4bbe75ed3d29f14d004d9dc69e73f2a1d

 WebTM/views/ÏúÊÛ¹ÜÀí/ÏúÊÛ¶©µ¥/Xs_SeOrderBillList.html

@@ -141,6 +141,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-PushReceivableBills" id="btn-PushReceivableBills"><i class="layui-icon layui-icon-delete"></i>多行下推(应收单)</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Refresh" id="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_LookDown" id="get_LookDown"><i class="layui-icon layui-icon-refresh-3"></i>下查</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_needClose" id="get_needClose"><i class="layui-icon layui-icon-refresh-3"></i>待关闭项</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-print" id="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_CheckBill" id="CheckBill"><i class="layui-icon layui-icon-form"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_AbandonCheck" id="AbandonCheck"><i class="layui-icon layui-icon-form"></i>反审核</button>
@@ -151,11 +152,12 @@
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_Drop" id="set_Drop"><i class="layui-icon layui-icon-radio"></i>作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_DeDrop" id="set_DeDrop"><i class="layui-icon layui-icon-radio"></i>反作废</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="btn-print" lay-event="btn-print"><i class="layui-icon layui-icon-form"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_export" id="get_export"><i class="layui-icon layui-icon-export"></i>导出</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>隐藏列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_QueryCondition" id="set_QueryCondition"><i class="layui-icon layui-icon-set"></i>高级过滤</button>
                                <!--<button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
    <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
    <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_QueryCondition" id="set_QueryCondition"><i class="layui-icon layui-icon-set"></i>高级过滤</button>-->
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Exit" id="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
@@ -192,6 +194,12 @@
            var HModName = "Xs_SeOrderBill";
            var HBillType = "1401";


            var ins;                        //用于导出excel
            //记录过滤条件用于排序时获取数据
            var sWhere_Bak = "";
            var get_needClose_Bar = 0;

            //#region ã€åŠ¨æ€èŽ·å–模块名称】
            var HModuleType = "1401";
            //通过单据类型，从数据库动态获取单据模块命名,引用js文件 PageTitle.js
@@ -221,6 +229,8 @@
            //#region ç›‘听事件
            //#region æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                //标记当前数据为 æŸ¥è¯¢æ•°æ®
                get_needClose_Bar = 0;
                get_FastQuery(table, option);
            });
            //#endregion
@@ -286,6 +296,10 @@
                    case 'get_LookDown':
                        set_LookDown();
                        break;
                    //待关闭项
                    case 'get_needClose':
                        get_needClose();
                        break;
                    //刷新
                    case 'get_Refresh': get_Refresh();
                        break;
@@ -319,6 +333,10 @@
                    //打印
                    case 'btn-print': get_PrintReport();
                        break;
                    //导出excel
                    case 'get_export':
                        get_Export();
                        break;
                    //隐藏列设置
                    case 'HideColumn':
                        get_HideColumn();
@@ -339,6 +357,48 @@
                        set_QueryCondition();
                        break;
                };
            });
            //#endregion

            //#region ç›‘听排序事件
            table.on('sort(mainTable)', function (obj) {
                // èŽ·å–排序字段和类型
                var field = obj.field;
                var type = obj.type;
                //记录过滤条件
                var temp = sWhere_Bak;

                //为过滤条件增加排序
                sWhere_Bak += " order by " + field + " " + (type == "null" ? "" : type) + " ";

                //获取排序后的数据并重新渲染
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
                    async: false,
                    type: "GET",
                    data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {

                            option.data = data1.data;
                            table.render(option);
                            layer.close(ajaxLoad);

                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });

                sWhere_Bak = temp;
            });
            //#endregion

@@ -502,12 +562,25 @@
                        //, { field: '计划跟踪号', title: '计划跟踪号', sort: true }
                        //, { field: '表体备注', title: '表体备注', sort: true }
                    ]]
                    , done: function () {
                    , done: function (res, curr, count) {
                        soulTable.render(this);

                        //刷新按钮显示
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);

                        //循环表数据根据flag状态给行上色
                        //$.each(res['data'], function (i, j) {
                        //    var HIsUsingMoney = j['剩余订金'] * 1;
                        //    var HRowCloseMan = j['行关闭人'];
                        //    var HCloseMan = j['关闭人'];
                        //    if ((HIsUsingMoney <= 500 && HIsUsingMoney > 0) && HRowCloseMan == "" && HCloseMan == "") {
                        //        Layui_SetDataTableRowColor('table', i + 1, 'red');
                        //    } else {
                        //        Layui_SetDataTableRowColor('table', i + 1, 'black');
                        //    }

                        //});
                    }
                };
            }
@@ -549,7 +622,7 @@


                            option.data = result;
                            table.render(option);
                            ins = table.render(option);
                            layer.close(ajaxLoad);

                            //刷新按钮显示
@@ -633,6 +706,8 @@
                //根据用户过滤用户关联客户的记录
                sWhere += getSWhereByHUser();

                sWhere_Bak = sWhere;

                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
                GetDataCols = "";
@@ -697,8 +772,12 @@
                    maxmin: true,
                    content: '../../销售管理/销售订单/Add_Edit_Xs_SeOrderBillList.html?OperationType=1&linterid=0&HSouceBillType=0&closeType=1',
                    end: function () {
                        //刷新页面,
                        $("#btnSearch").trigger('click');
                        //修改为功后刷新界面
                        if (get_needClose_Bar == 0) {
                            $("#btnSearch").trigger('click');
                        } else if (get_needClose_Bar == 1) {
                            $("#get_needClose").trigger('click');
                        }
                    },
                    success: function (layero, index) {

@@ -724,8 +803,12 @@
                        , content: '../../销售管理/销售订单/Add_Edit_Xs_SeOrderBillList.html?OperationType=2&linterid=' + hID + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            $("#btnSearch").trigger('click');
                            //修改为功后刷新界面
                            if (get_needClose_Bar == 0) {
                                $("#btnSearch").trigger('click');
                            } else if (get_needClose_Bar == 1) {
                                $("#get_needClose").trigger('click');
                            }
                        }
                        , cancel: function () {

@@ -755,8 +838,12 @@
                        , content: '../../销售管理/销售订单/Add_Edit_Xs_SeOrderBillList.html?OperationType=3&linterid=' + hID + '&HSouceBillType=0&closeType=1'
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            $("#btnSearch").trigger('click');
                            //修改为功后刷新界面
                            if (get_needClose_Bar == 0) {
                                $("#btnSearch").trigger('click');
                            } else if (get_needClose_Bar == 1) {
                                $("#get_needClose").trigger('click');
                            }
                        }
                        , cancel: function () {
                            
@@ -788,8 +875,12 @@
                                        var index = layer.getFrameIndex(window.name);
                                        //关闭当前frame
                                        layer.close(index);
                                        //修改为功后刷新界面
                                        $("#btnSearch").trigger('click');
                                        ////修改为功后刷新界面
                                        //if (get_needClose_Bar == 0) {
                                        //    $("#btnSearch").trigger('click');
                                        //} else if (get_needClose_Bar == 1) {
                                        //    $("#get_needClose").trigger('click');
                                        //}
                                    });

                                } else {
@@ -831,8 +922,12 @@
                        , content: '../../销售管理/销售订单变更单/Xs_SeOrderChangeBill.html?OperationType=4&linterid=' + hID + '&HSouceBillType=1401&closeType=1'
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                        , cancel: function () {

@@ -869,8 +964,12 @@
                        , content: '../../销售管理/特批申请单/Xs_ExceptiveCheckRequestBill.html?OperationType=4&linterid=' + hID + '&HSouceBillType=1401&closeType=1'
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                        , cancel: function () {

@@ -908,8 +1007,12 @@
                        , content: '../../生产管理/生产任务单/Sc_ICMOBillEdit_NoTable.html?OperationType=4&linterid=' + hID + '&hsubid=' + hsubid
                        , resize: false,
                        end: function () {
                            //刷新页面,
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                        , cancel: function () {

@@ -974,8 +1077,12 @@
                        , btn: [],
                        // æŒ‰é’®1 çš„回调
                        end: function (index, layero, that) {
                            //刷新页面
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                    })
                } else {
@@ -1036,8 +1143,12 @@
                        , btn: ['确定'],
                        // æŒ‰é’®1 çš„回调
                        end: function (index, layero, that) {
                            //刷新页面
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                    })
                } else {
@@ -1098,8 +1209,12 @@
                        , btn: ['确定'],
                        // æŒ‰é’®1 çš„回调
                        end: function (index, layero, that) {
                            //刷新页面
                            //$("#btnSearch").trigger('click');
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                    })
                } else {
@@ -1125,8 +1240,12 @@
                        , content: '../../销售管理/销售订单/Xs_SeOrderBill_LookDown.html?linterid=' + hID + '&HSouceBillType=1401&closeType=1'
                        , resize: false,
                        end: function () {
                            //刷新页面,
                           /* $("#btnSearch").trigger('click');*/
                            ////修改为功后刷新界面
                            //if (get_needClose_Bar == 0) {
                            //    $("#btnSearch").trigger('click');
                            //} else if (get_needClose_Bar == 1) {
                            //    $("#get_needClose").trigger('click');
                            //}
                        }
                        , cancel: function () {

@@ -1135,6 +1254,70 @@
                } else {
                    layer.msg('请选择一行数据编辑！');
                }
            }
            //#endregion

            //#region å¾…关闭项
            function get_needClose() {
                //记录过滤条件
                var temp = sWhere_Bak;
                //标记当前数据为 å¾…关闭项
                get_needClose_Bar = 1;

                //为过滤条件增加排序
                sWhere_Bak += " and å‰©ä½™è®¢é‡‘>0 and å‰©ä½™è®¢é‡‘<=500 and å…³é—­äºº='' and è¡Œå…³é—­äºº='' and çŠ¶æ€ = '已审核' order by å•æ®å· desc";

                //获取排序后的数据并重新渲染
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Xs_SeOrderBill/sortList',
                    async: false,
                    type: "GET",
                    data: { "sWhere": sWhere_Bak, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {

                            //设置列表同一个单据只有第一条数据显示主表信息，其它记录只显示子表信息
                            //获取子表列数据
                            var colList = [];
                            for (var i = 0; i < option.cols[0].length; i++) {
                                colList.push(option.cols[0][i].field);
                            }
                            //设置数据
                            var result = data1.data;
                            var temp = "";
                            for (var i = 0; i < result.length; i++) {
                                if (temp != result[i]["hmainid"]) {
                                    temp = result[i]["hmainid"];
                                } else {
                                    var initIndex = $.inArray("hmainid", colList);
                                    var lastIndex = $.inArray("hsubid", colList);
                                    for (var j = initIndex + 1; j < lastIndex; j++) {
                                        var fieldName = colList[j];
                                        result[i][fieldName] = "";
                                    }
                                }
                            }


                            option.data = result;
                            table.render(option);
                            layer.close(ajaxLoad);

                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });

                sWhere_Bak = temp;
            }
            //#endregion

@@ -1163,7 +1346,11 @@
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                    if (get_needClose_Bar == 0) {
                                        $("#btnSearch").trigger('click');
                                    } else if (get_needClose_Bar == 1) {
                                        $("#get_needClose").trigger('click');
                                    }
                                });

                            } else {
@@ -1199,7 +1386,11 @@
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                    if (get_needClose_Bar == 0) {
                                        $("#btnSearch").trigger('click');
                                    } else if (get_needClose_Bar == 1) {
                                        $("#get_needClose").trigger('click');
                                    }
                                });

                            } else {
@@ -1236,7 +1427,11 @@
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                    if (get_needClose_Bar == 0) {
                                        $("#btnSearch").trigger('click');
                                    } else if (get_needClose_Bar == 1) {
                                        $("#get_needClose").trigger('click');
                                    }
                                });

                            } else {
@@ -1272,7 +1467,11 @@
                                    //关闭当前frame
                                    layer.close(index);
                                    //修改为功后刷新界面
                                    $("#btnSearch").trigger('click');
                                    if (get_needClose_Bar == 0) {
                                        $("#btnSearch").trigger('click');
                                    } else if (get_needClose_Bar == 1) {
                                        $("#get_needClose").trigger('click');
                                    }
                                });

                            } else {
@@ -1314,6 +1513,28 @@
                else {
                    layer.msg('请选择一行数据打印！');
                }
            }
            //#endregion

            //#region å¯¼å‡ºExecel
            function get_Export() {
                var ModRightNameCheck = "Xs_SeOrderBillList_ExportExcel";

                //逻辑审核方法
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/LMES/getReportByModRightNameCheck", //方法所在页面和方法名
                    data: { "ModRightNameCheck": ModRightNameCheck, "user": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            table.exportFile(ins.config.id, option.data, "xls");
                        } else {
                            layer.alert("当前模块没有导出权限!", { icon: 5 });
                        }
                    }, error: function () {
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }
            //#endregion

@@ -1429,6 +1650,24 @@
            }
            //#endregion

            //#region ç»™table行上色
            function Layui_SetDataTableRowColor(TabDivId, RowIndex, ColorString) {
                try {
                    var div = $("[lay-id='mainTable'] tr:eq(" + RowIndex + ")");
                    if (div != null) //找到对象了
                    {
                        // console.log(div);
                        div.css("color", ColorString);

                    } else {
                        console.log('没有找到对象');
                    }
                } catch (e) {
                    console.log(e.message);
                }
            }
            //#endregion

            //#region ã€è¿‡æ»¤æ–¹æ¡ˆã€‘

            //获取当前用户的默认过滤方案