上下模单优化

yangle

2024-06-06 d6db3fa707f470fd8a6160c6daf6bcea75b8a6ce

 WebTM/views/Ó¦ÊÕ¹ÜÀí/±¨±í·ÖÎö/YS_CusShouldIncomeReport.html

@@ -278,7 +278,23 @@

            //#region å¯¼å‡ºExecel
            function get_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
                var ModRightNameCheck = "YS_CusShouldIncomeReport_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

@@ -295,6 +311,11 @@

                sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HCustomer + "'," + HStockOrgID;

                //根据用户过滤用户关联客户的记录
                sWhere += ",'";
                sWhere += getSWhereByHUser();
                sWhere += "'";

                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
@@ -303,6 +324,7 @@
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var totalArray = ["期初余额", "本期应收","本期实收","期末余额"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -321,6 +343,9 @@
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if ($.inArray(data[i].name, totalArray) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 });
                                }
                                else {
                                    switch (data[i].Type) {
@@ -544,6 +569,30 @@
            }
            //#endregion

            //#region æ ¹æ®ç”¨æˆ·èŽ·å–用户关联客户的过滤条件
            function getSWhereByHUser() {
                var res = "";
                $.ajax({
                    type: "GET",
                    async: false,
                    url: GetWEBURL() + "/Xs_SeOrderBill/getCusIDListByUser", //方法所在页面和方法名
                    data: { "CurUserID": sessionStorage["Czybm"], "CurUserName": sessionStorage["HUserName"] },
                    success: function (result) {
                        if (result.count == 1) {
                            res = result.data;
                        } else {
                            res = result.data;
                            layer.alert(result.code + result.Message, { icon: 5 });
                        }
                    }, error: function (err) {
                        res = " and 1 = 0";
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
                res = res.replaceAll("'", "''");
                return res;
            }
            //#endregion
        //#endregion