jQWidgets jqxGrid getcolumnaggregateddata()用法及代碼示例

jQWidgets是一個 JavaScript 框架，用於為 PC 和移動設備製作基於 Web 的應用程序。它是一個非常強大、優化、獨立於平台且得到廣泛支持的框架。這江青網格用於說明以表格形式顯示數據的 jQuery 小部件。此外，它還全麵支持數據連接、分頁、分組、排序、過濾和編輯。

getcolumnaggregateddata() 方法用於查找顯示的 jqxGrid 列的聚合詳細信息。它返回一個 JSON 對象。在這裏，數據字段的每個標簽都是聚合類型。例如‘count’, ‘min’, ‘max’, ‘sum’等等。

參數值：它接受 2 個參數，如下所述：

dataField: 它是指定列的數據字段。它是字符串類型。
aggregates: 它是一個聚合數組，即‘count’, ‘max’, ‘min’，依此類推。它是數組類型。

用法:

var gcad = $('#Selector').jqxGrid('getcolumnaggregateddata', 
    'pagenumber', ['count', 'sum']);

鏈接文件：下載jQWidgets從給定的鏈接。在 HTML 文件中，找到下載文件夾中的腳本文件。

<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/jqxgrid.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxgrid.selection.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqx-all.js”></script>

例子：下麵的例子說明了jqxGridgetcolumnaggregateddata()jQWidgets 中的方法。

HTML


<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" type="text/css" 
          href="jqwidgets/styles/jqx.base.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/jqxgrid.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxgrid.selection.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqx-all.js"> 
    </script>  
</head> 
  
<body> 
    <center> 
        <h1 style="color: green"> 
            GeeksforGeeks 
        </h1> 
        <h3>jQWidgets jqxGrid getcolumnaggregateddata() 
            method</h3> 
        <div id="jqxg"></div> 
        <div> 
            <input type="button" id="jqxBtn" 
                   style="margin-top: 25px" 
                   value="Click here" /> 
        </div> 
        <br /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            var d = new Array(); 
            var subjectNames = 
                ["C++", "Scala", "Java", "C", "R", "JavaScript"]; 
            var pageNumber = ["7", "8", "12", "11", "10", "19"]; 
            for (var j = 0; j < 5; j++) { 
                var r = {}; 
                r["subjectnames"] = subjectNames[(Math.floor( 
                    Math.random() * subjectNames.length))]; 
  
                r["pagenumber"] = pageNumber[(Math.floor( 
                    Math.random() * pageNumber.length))]; 
                d[j] = r; 
            } 
            var src = { 
                localdata: d, 
                datatype: "array", 
            }; 
            var data_Adapter = new $.jqx.dataAdapter(src); 
            $("#jqxg").jqxGrid({ 
                source: data_Adapter, 
                showstatusbar: true, 
                showaggregates: true, 
                columns: [{ 
                    text: "Subject Name", 
                    datafield: "subjectnames", 
                    width: "100px", 
                    aggregates: ['count'] 
                }, { 
                    text: "Page No.", 
                    datafield: "pagenumber", 
                    width: "140px", 
                    aggregates: ['sum'] 
                },], 
            }); 
            $("#jqxg").jqxGrid({ 
                height: "220px", 
                width: "230px", 
            }); 
            $("#jqxBtn").jqxButton({ 
                width: "100px", 
                height: "30px", 
            }); 
            $("#jqxBtn").on("click", function () { 
                var gcad = $("#jqxg").jqxGrid( 
                    'getcolumnaggregateddata', 
                    'pagenumber', 
                    ['count', 'sum']); 
                $("#log").text( 
                    "Count: "  
                  + gcad.count  
                  + ", Sum: "  
                  + gcad.sum 
                ); 
            }); 
        }); 
    </script> 
</body> 
</html>

輸出：

參考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm?search=

相關用法

注：本文由純淨天空篩選整理自nidhi1352singh大神的英文原創作品 jQWidgets jqxGrid getcolumnaggregateddata() Method。非經特殊聲明，原始代碼版權歸原作者所有，本譯文未經允許或授權，請勿轉載或複製。