Version 2.78.0

Jul 13th, 2018

1. EnhancementTable: Add responsive property to Table widget
2. EnhancementGoogleChart: Add formatValue to column so that user can do custom value format.
3. EnhancementGoogleChart: Make width of GoogleChart default 100%
4. EnhancementSubReport: Enhance the partial render
5. EnhancementPdoDataSource: Fix issue with Oracle
6. EnhancementKoolReport: Reduce reload settings() by saving to $reportSettings
7. EnhancementKoolReport: src() will take the first datasource if name is not specify
8. EnhancementUtility: Add advanced jsonEncode() function to enable js function definition inside php array.
9. EnhancementAdding version factor to KoolReport as well as its widget so that everytime we upgrade core libray as well as package, the widget is able to create new assets folder with updated resource
10. EnhancementKoolReport: Adding DifferenceColumn process to calculate the difference between row and the previous one.
11. EnhancementKoolReport: Adding AppendRow process to add custom row to data flow.
12. EnhancementGoogleChart: On select, itemSelect, the selectedRow will contain associate values the array of values.
13. EnhancementTable: On rowClick, the selectedRow will contain associate values the array of values.
14. EnhancementDataSource: Improve the parameter escape string
15. EnhancementDataSource: Make MySQLDataSource, PostgreSQLDateaSource, SQLSRVDataSource, OracleDataSource share database connection to reduce response time and memory.
16. FixedFixed several minor bugs

Version 2.43.0

Apr 20th, 2018

1. FixedFix issue with GoogleChart when working with numeric column but in string form.

Version 2.42.0

Mar 19th, 2018

1. EnhancementChange namespace ::class to use classname in string so that KoolReport is compatible with PHP 5.4
2. FixedPdoDataSource: Fix charset issue with PostgreSQL

Version 2.41.3

Mar 02nd, 2018

1. EnhancementAdding AccumulativeColumn to generate accumulative column.
2. EnhancementMake KoolReport loaded with composer autoload
3. FixedFix Group process for not counting records correctly.
4. FixedA bundle of small fixes

Version 2.31.8

Feb 05th, 2018

1. FixedPdoDataSource: Revert back to previous param binding to support array data binding

Version 2.31.7

Jan 26th, 2018

1. EnhancementWidget: Adding default dataSource and backward dataStore property.
2. EnhancementWidget: Able to set dataStore object, array data and even the adhoc process.
3. EnhancementTable: Remove the data property and start using the dataSource
4. EnhancementGoogleCharts: Remove data property and start using dataSource instead
5. EnhancementDataStore: Adding requestDataSending() to manually request data piping from source.
6. EnhancementNew events:Adding events OnBeforeResourceAttached and OnResourceAttached
7. EnhancementTable: Add ability to set multilevel group headers.
8. EnhancementPdoDataSource: Adding SQL Query error handling
9. EnhancementCopyColumn: Change input format from "orginal"=>"copy" to "copy"=>"orginal"
10. EnhancementDataStore: Function process() can accept a series of piping processes.
11. EnhancementGoogleCharts: Add property pointerOnHover to set whether pointer will be used when user holds mouse over the item of chart.
12. EnhancementGoogleCharts: Automatic set pointerOnHover=>true if there is "itemSelect", "rowSelect", "columnSelect" event registered.
13. EnhancementTable: Change "goPage" event to "pageChanged" event
14. EnhancementNew Process: ColumnRename process is added to help developer to rename column
15. EnhancementProcess: Add static function process() to support new process creating style
16. FixedFix the bug of incorrect active report when subReport is used.

Version 2.0.0

Dec 23rd, 2017

1. EnhancementDataStore: Add process() function to further process data
2. EnhancementPdoDataSource: Update the bindParams() function.
3. EnhancementTable: Handle the case when there is no data
4. EnhancementTable: Show custom messages
5. EnhancementWidget: Able to load language/localization
6. EnhancementPdoDataSource, MySQLDataSource, SQLSRVDataSource: Update parameter binding.
7. EnhancementAdd ability to contain sub report, supporting partial report rendering.
8. EnhancementWidget: Enhance the template() function
9. EnhancementGoogle Charts: Rewrite library to support ajax loading and work well with SubReport
10. EnhancementTable: Ability to work with sub report and ajax loading
11. EnhancementTable: Adding client event handling capability.

Version 1.72.8

Oct 30th, 2017

1. EnhancementTimeBucket: Change month bucket format from Y-n to Y-m to support sorting
2. EnhancementDataStore: Add $offset parameter to the function top().
3. EnhancementDataStore: Add function min(), max(), sum(), avg()
4. EnhancementFilter: Add "in" and "notIn" operator
5. EnhancementDataStore::filter() Add "startWith","notStartWith", "endWith" and "notEndWith"
6. EnhancementCalculatedColumn: Able to generate new column containing row number as value by settings "rowNum"=>"{#}"
7. EnhancementTable: New feature of pagination
8. EnhancementMake KoolReport run debug() if could not find the view file.
9. FixedDataStore: Fix the function get() which previously did not return correct row

Version 1.61.5

Sep 27th, 2017

1. FixedFix sql parameters issue in PDODataSource, MySQLDataSource, SQLSRVDataSource as reported in here

Version 1.61.2

Sep 21st, 2017

1. EnhancementAdd html() method to Widget to allow return html of widget
2. EnhancementAdd $return to create() method of Widget to return html instead of echo html.
3. EnhancementAdd innerView() to KoolReport to allow rendering sub view
4. EnhancementAdd function get() to DataStore to get any value in table
5. EnhancementMake Transpose process take the label as data if the label of column is available.
6. EnhancementReturn content on event "OnRenderEnd"`
7. EnhancementAllow cancel rendering using `"OnBeforeRender"` event
8. EnhancementAdd previous() function to Node for navigation
9. EnhancementResourceManager now will fire the OnResourceInit event
10. EnhancementTable has data property to input data on fly.
11. EnhancementGoogle chart has data property to input data on fly.
12. EnhancementAdd filter() function to DataStore to filter data base on condition.
13. EnhancementAdd top() and `topByPercent()` function to DataStore to get the top rows
14. EnhancementAdd bottom() and `bottomByPercent()` function to DataStore to get the bottom rows
15. EnhancementAdd sort() function to DataStore to get data sorted.
16. EnhancementAdd "footer"=>"count" to Table column settings.
17. FixedFix the isEnd() function of Node
18. FixedFix Group to allow multiple sources to pipe to group process
19. FixedFix the ProcessGroup to enable transferring data smoothly

Version 1.47.3

Aug 23rd, 2017

1. EnhancementNew AggregatedColumn process to calculate aggregated table result and save to a new column
2. EnhancementTable is now able to show footer
3. EnhancementThe Table footer can be shown at bottom or on top of data
4. EnhancementAdd footerText property
5. Enhancementdd showHeader to Table widget
6. EnhancementAbility to set cssStyle for each columns. cssStyle can be string or array containing components td,th and tf.
7. EnhancementImprove DataSource class
8. EnhancementNew process Transpose to transpose column and row of data flow
9. EnhancementThe Node now has getReport() function which return the report.
10. FixedFix double quote issue of PDODataSource
11. FixedFix the Timeline in google charts
12. FixedFix the Group process by removing the space in column name

Version 1.34.9

July 25th, 2017

1. EnhancementAdd load() function to ArrayDataSource
2. EnhancementAdd formatValue column settings in \koolreport\widgets\koolphp\Table.
3. FixedSolve issue of empty data source given to table.

Version 1.32.8

July 5th, 2017

1. EnhancementTable has align property for columns
2. EnhancementAdding event OnInit and OnInitDone to KoolReport
3. EnhancementAdding event OnBeforeSetup and OnSetup to KoolReport
4. EnhancementAdding function params() in PDODataSource to set params for SQL statement.
5. EnhancementAdding process Map which is versatile way to transform data.
6. FixedSolve issue of empty data source given to table.
7. FixedSolve the bug of missing row in ColumnsSort process.

Version 1.27.6

May 22th, 2017

1. EnhancementMove the ExcelDataSource from the core to separate package to reduce the size of core.
2. EnhancementMove MongoDataSource to separate package as well.
3. EnhancementAdd namespace 'clients' to contain most common used clients library such as jQuery, Bootstrap
4. EnhancementAdding the colorScheme to Koolreport to manage color of charts and others.
5. EnhancementWe now can create theme for KoolReport
6. EnhancementEnhance the Widget Asset Manager
7. EnhancementAdd functionpublishAssetFolder() to KoolReport.
8. EnhancementAdd the MySQLDataSource
9. EnhancementAdd the SQLSRVDataSource
10. EnhancementAdd ColumnsSort process to sort columns by name of label.
11. EnhancementThe Sort process now can sort by custom comparison function.
12. EnhancementAdd function debug() in KoolReport, this function will display all available data stores.
13. FixedFix Google Chart initiation bug,this bug is actually due to the change from Google library.

Version 1.15.4

May 22th, 2017

1. EnhancementAdd ResourceManager to manage report's resources such as js, css and any others.
2. EnhancementImprove the loading of Google Charts library with new ResourceManager to avoid loading redundancy.
3. EnhancementAdd event register and event handling mechanism.
4. EnhancementAdd OnBeforeRun,OnRunEnd,OnBeforeRender,OnRenderEnd event.
5. EnhancementAllow to set full path for report's assets folder settings

Version 1.11.4

May 4th, 2017

1. EnhancementAdd ReportDataSource to pull data from another report
2. EnhancementAllow to set "role" to columns for google chart
3. EnhancementFilter process is now allowed or operator
4. EnhancementAllow ValueMap to set custom function
5. EnhancementMake Google Charts responsive to the change of screen size
6. EnhancementAdd saveTo() function to Node class
7. EnhancementEnhance the mechanism of google chart library loader
8. EnhancementKoolphp Table can remove duplicated value
9. EnhancementAdd popStart() and pop() function to DataStore class which helps to reduce memory usage
10. EnhancementEnhance CSVDataSource and ExcelDataSource to reduce memory usage
11. EnhancementAllow CalculatedColumn to add custom function and set meta data on the fly.
12. EnhancementMake removeDuplicate of koolphp\Table be list of columns you want to remove duplicated data.
13. FixedFix autoload.php bug in loading packages
14. FixedFix OnlyColumn bug
15. FixedFix koolphp's Table bug when column header is number
16. FixedFix google charts duplicated chart id problem

Version 1.0.0

April 4th, 2017

1. Establish middle-ware structure of KoolReport
2. Build the most common datasource connectors
3. Build the most common data processes
4. Create PHP wrapper for Googe Charts library

First brick

Jan 1st, 2017

• It was a nice day!
• Paper and pencil
• Two guys
• In a garden