{"id":102680,"date":"2014-11-26T11:12:20","date_gmt":"2014-11-26T09:12:20","guid":{"rendered":"http:\/\/guriddo.net\/?page_id=102680"},"modified":"2014-12-07T14:06:37","modified_gmt":"2014-12-07T12:06:37","slug":"pivotgrid-php","status":"publish","type":"page","link":"http:\/\/guriddo.net\/?page_id=102680","title":{"rendered":"Guriddo PivotGrid PHP"},"content":{"rendered":"
\n

What is Guriddo PivotGrid PHP?<\/h2>\n

\nGuriddo PivotGrid for PHP inherits the jqGrid for PHP class, so you can use most of the features you are already familiar with: column resizing, formatter, cell renderers, row\/cell events etc. The PivotGrid can be used when you want to get summation and pivot features that aren\u2019t provided in the Guriddo jqGrid PHP. This component is included as a part of Guriddo jqGrid PHP and is a bonus to the package.\n<\/p>\n\n\n\n
\n<\/td>\n\nDownload<\/a><\/td>\nLicense\/Pricing<\/a><\/td>\n\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

FEATURES<\/h3>\n

\n\"php-logo\"<\/a><\/p>\n

PURE PHP<\/h4>\n


\nGuriddo TreeGrid PHP is written in pure PHP. This means that the class can be integrated in any PHP framework including Zend, Cake PHP, Doctrine PHP and much more.\n<\/p>\n

\n \"Free\"<\/a>
\nAUTOMATIC OPERATIONS<\/h4>\n

\nThe PHP component automatically handles data retrieval. No need for custom code \u2013 you can have a fully functional pivot grid with just a few lines of PHP<\/p>\n

\n\"database\"<\/a>
\nMULTIPLE DATABASE SUPPORT<\/h4>\n

\nUp to the moment Guriddo PivotGrid PHP Supports the following Databases: AdoDB wrapper, Array data, IBM DB2, MongoDB, Microsoft SQL Serrver, MySQLi, ODBC, Oracle, PDO (with MySQL, PostgreSQL, SQLite, SQL Server)\n<\/p>\n

\n
\n\"Multibrowser\"<\/a><\/p>\n

MULTIPLATFORM<\/h4>\n


\nBrowser support is an important part of our grid. Guriddo support all modern mobile and desktop browsers including the iPhone\/iPad and Internet Explorer from version 8. Browser support reference is tested regularly with all major browsers. <\/p>\n

\n\"pivotphp\"<\/a>
\nBASICS<\/h4>\n

\nBasic pivot require minimal settings. To break down the dataset into simple summary, you just have to configure the xDimention object.\n<\/p>\n

\n\"pivotagragates\"<\/a>
\nMULTIPLE LEVELS<\/h4>\n


\nMultiple levels are supported, so you can just specify them in the y and x Dimensions. Grouping the rows and\/or columns is done automatically when two or more levels are set in xDimension and\/or yDimension. Now that you broke down the dataset on the y and x Dimension, it\u2019s time to aggregate the cell values. Several kinds of aggregations are available including: sum, min, max, count etc. Future release will provide your own aggregation function.\n<\/p>\n

MORE FEATURES<\/h4>\n
\n
    \n
  • Automatically grouping of data when xDimension has more than one item <\/li>\n
  • We support summary at for the group if a summaryType is set in agregates items <\/li>\n
  • Frozen columns for easy reading the report<\/li>\n
  • We can have unlimited summary rows. In this case we need to set the aggregates array. <\/li>\n
  • Searching a already constructed pivot<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    What is Guriddo PivotGrid PHP? Guriddo PivotGrid for PHP inherits the jqGrid for PHP class, so you can use most of the features you are already familiar with: column resizing, formatter, cell renderers, row\/cell events etc. The PivotGrid can be […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":102675,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"blank.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"_links":{"self":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102680"}],"collection":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=102680"}],"version-history":[{"count":11,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102680\/revisions"}],"predecessor-version":[{"id":103498,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102680\/revisions\/103498"}],"up":[{"embeddable":true,"href":"http:\/\/guriddo.net\/index.php?rest_route=\/wp\/v2\/pages\/102675"}],"wp:attachment":[{"href":"http:\/\/guriddo.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=102680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}