快速过滤

yangle

2022-09-27 a39bb1bf517471660da0d64b6b81eb36267c556c

 WebTM/views/Éú²ú¹ÜÀí/ÍËÁÏÉêÇëµ¥/JIT_CallGoodsBackRequestBillList.html

@@ -92,6 +92,33 @@
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:10px;">
                                        <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>
@@ -332,7 +359,10 @@
                $("#MaterialModel").val("");//规格型号
                $("#HDeptName").val("");//生产车间
                $("#ProcMul").val("");//工段

                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                form.render('select');
                $("#btnSearch").click();//刷新
                sWhere = "";
            }
@@ -350,7 +380,10 @@
                            option.data = data1.data;
                            table.render(option);
                            layer.close(ajaxLoad);
                            //layer.alert("查询成功", { icon: 1 });

                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                                ColFilter();
                            }
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
@@ -375,6 +408,32 @@
                var ProcMul = $("#ProcMul").val();//工段
                var Hmaker = sessionStorage["HUserName"] ;//当前用户
                var HOrgID = sessionStorage["OrganizationID"];//组织
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();

                var Arbitrarily = "";
                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;
                    }
                    Arbitrarily = " and " + ColName + " " + com;
                }

                sWhere = {
                    HBeginDate: HBeginDate,
@@ -386,7 +445,8 @@
                    HDeptName: HDeptName,
                    ProcMul: ProcMul,
                    Hmaker: Hmaker,
                    HOrgID: HOrgID
                    HOrgID: HOrgID,
                    Arbitrarily: Arbitrarily
                }

                get_Display(JSON.stringify(sWhere));
@@ -536,6 +596,18 @@
                })
            }

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

            //以上是layui模块