jQWidgets jqxDataTable applyFilters()用法及代码示例

jQWidgets 是一个 JavaScript 框架，用于为 PC 和移动设备制作基于 Web 的应用程序。它是一个非常强大、经过优化、独立于平台且得到广泛支持的框架。 jqxDataTable 用于读取和显示 HTML 表中的数据。这也用于显示来自各种数据源(如 XML、JSON、Array、CSV 或 TSV)的数据。

applyFilters() 方法用于应用添加或删除的过滤器。该函数不接受任何参数。

用法:

$("#dataTable").jqxDataTable('applyFilters');

链接文件：从给定的链接下载 jQWidgets。在 HTML 文件中，找到下载文件夹中的脚本文件。

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

例：下面的示例说明了 jQWidgets applyFilters() 方法。在本例中，数据表内容根据公司名称 “GeeksforGeeks” 进行过滤。

HTML


<!DOCTYPE html>
<html lang="en">
   <head>
      <link rel="stylesheet" 
         href="jqwidgets/styles/jqx.base.css"
         type="text/css" />
      <script type="text/javascript"
         src="scripts/jquery.js"></script>
      <script type="text/javascript"
         src="jqwidgets/jqxcore.js"></script>
      <script type="text/javascript" 
         src="jqwidgets/jqxdata.js"></script>
      <script type="text/javascript"
         src="jqwidgets/jqxbuttons.js"></script>
      <script type="text/javascript" 
         src="jqwidgets/jqxscrollbar.js"></script>
      <script type="text/javascript"
         src="jqwidgets/jqxlistbox.js"></script>
      <script type="text/javascript" 
         src="jqwidgets/jqxdropdownlist.js"></script>
      <script type="text/javascript"
         src="jqwidgets/jqxdatatable.js"></script>
      <script>
         $(document).ready(function () {
             var data = new Array();
             var Employee_Name = [
                  "Ravi", "Sumit", "Amit", "Aakash"];
             var Company = [
               "GeeksforGeeks",
               "Amazon", "Google",
               "GeeksforGeeks"];
             var Designation = [
               "Content Writer", "Software Engineer", 
               "Data Scientist", "HR"];
           
         for (var i = 0; i < 4; i++) {
             var row = {};
             row["Employee_Name"] = Employee_Name[i];
             row["Company"] = Company[i];
             row["Designation"] = Designation[i]
             data[i] = row;
         }
           
         var source = {
             localData:data,
             dataType:"array",
             dataFields:[{
                 name:'Employee_Name',
                 type:'string'
             }, {
                 name:'Company',
                 type:'string'
             }, {
                 name:'Designation',
                 type:'string'
             }]
         };
           
         var dataAdapter = 
             new $.jqx.dataAdapter(source);
         $("#table").jqxDataTable({
             width:550,
             theme:'energyblue',
             pageable:true,
             editable:true,
             source:dataAdapter,
             columns:[{
                 text:'Employee_Name',
                 dataField:'Employee_Name',
                 width:200
             }, {
                 text:'Company',
                 dataField:'Company',
                 width:160
             }, {
                 text:'Designation',
                 dataField:'Designation',
                 width:190
             }]
         });
         $("#jqxbutton").jqxButton({
             theme:'energyblue',
             width:200,
             height:30
         });
         $('#jqxbutton').click(function () {
             var filtertype = 'stringfilter';
             var filtergroup = new $.jqx.filter();
             var filter_or_operator = 1;
             var filtervalue = "GeeksforGeeks";
             var filtercondition = 'equal';
             var filter = filtergroup.createfilter(
               filtertype, filtervalue, filtercondition);
             filtergroup.addfilter(filter_or_operator, filter);
             $("#table").jqxDataTable(
               'addFilter', 'Company', filtergroup
             );
             $("#table").jqxDataTable('applyFilters');
         });
         });
      </script>
   </head>
   <body>
      <center>
         <h1 style="color:green;"> GeeksforGeeks </h1>
         <h3> jQWidgets jqxDataTable 
            applyFilters() Method 
         </h3>
         <div id="table"></div>
         <input type="button" style="margin:20px;"
            id="jqxbutton" 
            value="Apply the filters" />
      </center>
   </body>
</html>

输出：

参考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdatatable/jquery-datatable-api.htm

相关用法

注：本文由纯净天空筛选整理自Kanchan_Ray大神的英文原创作品 jQWidgets jqxDataTable applyFilters() Method。非经特殊声明，原始代码版权归原作者所有，本译文未经允许或授权，请勿转载或复制。