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。非经特殊声明，原始代码版权归原作者所有，本译文未经允许或授权，请勿转载或复制。