Guriddo PivotGrid PHP

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 used when you want to get summation and pivot features that aren’t provided in the Guriddo jqGrid PHP. This component is included as a part of Guriddo jqGrid PHP and is a bonus to the package.

Download License/Pricing

FEATURES

php-logo

PURE PHP


Guriddo 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.

Free
AUTOMATIC OPERATIONS

The PHP component automatically handles data retrieval. No need for custom code – you can have a fully functional pivot grid with just a few lines of PHP

database
MULTIPLE DATABASE SUPPORT

Up 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)


Multibrowser

MULTIPLATFORM


Browser 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.

pivotphp
BASICS

Basic pivot require minimal settings. To break down the dataset into simple summary, you just have to configure the xDimention object.

pivotagragates
MULTIPLE LEVELS


Multiple 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’s 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.

MORE FEATURES

  • Automatically grouping of data when xDimension has more than one item
  • We support summary at for the group if a summaryType is set in agregates items
  • Frozen columns for easy reading the report
  • We can have unlimited summary rows. In this case we need to set the aggregates array.
  • Searching a already constructed pivot

Stay connected with us in your favorite flavor!