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。非經特殊聲明，原始代碼版權歸原作者所有，本譯文未經允許或授權，請勿轉載或複製。