KoolReport v1.72.8

October 30, 2017

GREAT NEWS! We have released KoolReport 1.72.8 with some important enhancements: Table Pagination, DataStore Aggregation, new Filter's Operators and more.

Table Pagination

We have added the pagination feature to koolphp\Table. To enable this feature, we only need to add "paging" settings to the Table:

Table::create(array(
    "paging"=>array(
        "pageSize"=>10,
    )
))

You may view example here.

DataStore Aggregation

We have added 4 new methods to DataStore: min(), max(), avg() and sum(). So in the case you want to get total of an specific column you may do:

$totalSaleAmount = $this->dataStore("sales")->sum("amount");

Filter's Operators

The Filter process now has "in" and "notIn" operators. The "in" works like the IN operators in SQL which accept only rows with column value within an array:

->pipe(new Filter(array(
    array("firstName","in",array("Peter","Karl","David")),
)))

Bug fixes

We have fixed small bug in get() method of DataStore. In the previous version, the method returned wrong row. Issue has been fixed now.

KoolReport Pro

KoolReport Pro 1.5.0 has been released with latest core and extended packages. The packages updated in this version are Export 2.5.0, Inputs 2.7.0 and Pivot 2.2.0.

Reminder: Today is the last day of our promotion 30% OFF for KoolReport Pro. If you are interested in KoolReport Pro licenses, please purchase now before getting too late. Don't miss it!

<3 koolreport team

The KoolReport Blog