jQWidgets jqxPivotGrid getPivotRows()用法及代码示例

jQWidgets是一个 JavaScript 框架，用于为 PC 和移动设备制作基于 Web 的应用程序。它是一个非常强大、优化、独立于平台且得到广泛支持的框架。这 jqxPivotGrid是一个函数强大且轻量级的数据可视化小部件，完全用JavaScript语言。该小部件提供了许多高级函数，并且可以根据不同的需求进行高度定制。

getPivotRows() 方法用于获取指定 jqxPivotGrid 小部件的数据透视表行。

用法:

var a = $('#myPivotGrid').jqxPivotGrid('getPivotRows');

参数：该方法不接受任何参数。

返回值：此方法返回数据透视表行。

链接文件：下载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/jqxsortable.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxmenu.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivot.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivotgrid.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqx-all.js”></script>

例子：下面的示例说明了 jQWidgets jqxPivotGridgetPivotRows()方法。

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-1.11.1.min.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/jqxmenu.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxpivot.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxpivotgrid.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqx-all.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3>jQWidgets jqxPivotGrid getPivotRows() Method</h3> 
        <div id="jqx_Pivot_Grid" style="height:160px;width:270px;"> 
        </div> 
        <input type="button" style="margin:10px;" 
               id="button_for_getPivotRows" 
               value="Get the Pivot rows" /> 
        <div id="log"></div> 
        <script type="text/javascript"> 
            $(document).ready(function () { 
                var data = new Array(); 
                var i = 0; 
                while (i <= 2) { 
                    var Column = ["Company"]; 
                    var Domain = ["Progamming", 
                        "CS subjects", 
                        "GATE preparation"]; 
                    var Rank = ["Ranking"]; 
                    var row = {}; 
                    row["Domain"] = Domain[i]; 
                    row["Column"] = "Company"; 
                    row["Rank"] = "Domain"; 
                    data.push(row); 
                    i++; 
                } 
                var dataAdapter = new $.jqx.dataAdapter({ 
                    localdata: data, 
                    datafields: 
                        [ 
                            { name: 'Rank', type: 'string' }, 
                            { name: 'Domain', type: 'string' }, 
                            { name: 'Column', type: 'string' }, 
                        ] 
                }); 
                var pivotDataSource = new $.jqx.pivot( 
                    dataAdapter, 
                    { 
                        values: [ 
                            { text: 'GeeksforGeeks' } 
                        ], 
                        columns: [{ dataField: 'Column' }], 
                        rows: [{ dataField: 'Rank' }, 
                        { dataField: 'Domain' }], 
                    } 
                ); 
                $('#jqx_Pivot_Grid').jqxPivotGrid({ 
                    source: pivotDataSource 
                }); 
                $("#button_for_getPivotRows").jqxButton({ 
                    width: 300 
                }); 
                $('#button_for_getPivotRows') 
                .jqxButton().click(function () { 
                    var a = $('#jqx_Pivot_Grid') 
                        .jqxPivotGrid('getPivotRows'); 
                    $("#log").html('This widget has '  
                        + a.items.length + ' row.'); 
                 }) 
            }); 
        </script> 
    </center> 
</body> 
  
</html>

输出：

jQWidgets jqxPivotGrid getPivotRows() Method

参考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxpivotgrid/jquery-pivotgrid-api.htm?search=

相关用法

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