客户余额查询报表：优化

duhe

2024-02-27 1e77b7d40d876aed530522734e274d52f52d43e2

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

@@ -51,6 +51,35 @@
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
@@ -86,7 +115,7 @@
            var sWhere = "";
            var HModName = "Xs_CusBalanceReport";
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["客户内码","币别内码"];
            var titleData = ["客户内码","币别内码","组织内码"];
            //#endregion

            //#region è¿›å…¥é¡µé¢å³åŠ è½½
@@ -173,6 +202,7 @@
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , totalRow: true
                    //, cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 50000]
@@ -187,9 +217,10 @@
                $.ajax({
                    url: GetWEBURL() + '/Xs_CusBalanceReport/list',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"]},
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "userid": sessionStorage["Czybm"]},
                    success: function (data1) {
                        if (data1.count == 1) {
                            var totalArray = ["客户余额", "占用额度","可用额度"];
                            var data = [];
                            var col = [];
                            //给空的数组赋值
@@ -202,6 +233,9 @@
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                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) {
@@ -253,17 +287,45 @@
                var HCusName = $("#HCusName").val();//客户名称
                var HCurName = $("HCurName").val();//货币名称

                if (HCusNumber) {
                    sWhere += " and a.HNumber like '%" + HCusNumber + "%'";
                }
                if (HCusName) {
                    sWhere += " and a.HName like '%" + HCusName + "%'";
                }
                if (HCurName) {
                    sWhere += " and b.HName like '%" + HCusName + "%'";
                //任意字段过滤
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();

                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like ''%" + ColContent + "%''";
                            break;
                        case "8":
                            com = "like ''%" + ColContent + "''";
                            break;
                        case "9":
                            com = "like ''" + ColContent + "%''";
                            break;
                        case "10":
                            com = "not like ''%" + ColContent + "%''";
                            break;
                        default:
                            com = "" + Comparator + "''" + ColContent + "''";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }

                sWhere += " and a.HUSEORGID = " + sessionStorage["OrganizationID"];

                if (HCusNumber) {
                    sWhere += " and å®¢æˆ·ä»£ç  like ''%" + HCusNumber + "%''";
                }
                if (HCusName) {
                    sWhere += " and å®¢æˆ·åç§° like ''%" + HCusName + "%''";
                }
                if (HCurName) {
                    sWhere += " and å¸åˆ«åç§° like ''%" + HCusName + "%''";
                }

                sWhere += " and ç»„织内码 = " + sessionStorage["OrganizationID"];

                //根据用户过滤用户关联客户的记录
                sWhere += getSWhereByHUser();
@@ -278,6 +340,11 @@
                $("#HCusNumber").val("");
                $("#HCusName").val("");
                $("#HCurName").val("");

                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                form.render('select');

                sWhere = "";
            }
@@ -407,6 +474,20 @@
            }
            //#endregion

            //#region ä»»æ„å­—段过滤：列名显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
            }
            //#endregion

            //#region æ ¹æ®ç”¨æˆ·èŽ·å–用户关联客户的过滤条件
            function getSWhereByHUser() {
                var res = "";
@@ -428,7 +509,7 @@
                    }
                });

                res = res.replace("HCusID", "a.HItemID");
                res = res.replace("HCusID", "客户内码");

                return res;
            }