生产日记报表里， 增加 业务员 列， 和增加 业务员过滤（根据名称模糊过滤即可） 功能以及 自定义过滤功能；

yangle

2023-11-28 941a5e5828bb575568990f593f3e353953fdb099

生产日记报表里， 增加 业务员 列， 和增加 业务员过滤（根据名称模糊过滤即可） 功能以及 自定义过滤功能；

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/SC_DayRkReport.html

@@ -99,6 +99,33 @@
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin:10px 0px">
                                        <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>
@@ -210,6 +237,8 @@

                //加载数据到网格
                get_FastQuery();

                ColFilter();
               // DisPlay_HideColumn();
            }

@@ -363,6 +392,19 @@
                })
            }

            //列明显示下拉框
            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');
            }

            //快速过滤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();//下达日期 å¼€å§‹æ—¥æœŸ
@@ -371,6 +413,37 @@
                var HCustomerName = $("#HCustomerName").val();          //单据号
                var HProductName = $("#HProductName").val();//产品名称
                var HEmpName = $("#HEmpName").val();//业务员
                //任意字段条件过滤 æ¡ä»¶æå–
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();

              

                //拼接任一字段过滤查询条件
                var com = "";
                if (ColName != 0 && Comparator != 0) {
                    ColName = "[" + ColName + "]";
                    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;
                    }
                    com = " and (" + ColName + " " + com + ")";
                }


                if (HBeginDate != "" && HEndDate != "") {
                   
@@ -388,7 +461,8 @@
                    HCustomerName: HCustomerName,
                    HProductName: HProductName,
                    HEndDate: HEndDate,
                    HEmpName: HEmpName
                    HEmpName: HEmpName,
                    sWheres: com,
                    HOtherSearch: (HOtherSearch == null || HOtherSearch == "undefine") ? " and 1=1 " : HOtherSearch
                };

@@ -442,6 +516,11 @@
                $("#HMaterNumber").val("");
                $("#HCustomerName").val("");
                $("#HProductName").val("");
                $("#HEmpName").val("");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                ColFilter();
                sWhere = "";
            }