A Must Upgraded KoolReport 2.78.0July 16, 2018
LET PARTY to celebrate the new version of KoolReport 2.78.0. We are very proud because we thought everything was just perfect in the previous version but still this new one comes with a lot of improvements. We have been working hard to find every enhancement point even tiny. So here come the new version, all are backward compatible so you need not to worry. Please upgrade!
In this version, we have reviewed all datasource classes once more time to assure they are totally safe from any security threats. Furthermore, we have improved datasources for MySQL, Postgre, SQLSRV and Oracle to reduce their response time and memory usage by enabling the connection sharing. It means that, if you have multiple queries to the same database, connection will be shared between them thus reducing the unneccessary of re-connecting time. This technique has been implemented for PdoDataSource but have not done for others.
We have improved the
src($name) function as well. Previously, this method requires us to specify the name of datasource. However we found that 80% of the cases, we have only ONE datasource. So we thought that it would be nicer to just write
src() without any parameter, KoolReport will automatically get the first datasource to use. A tiny improvement but it can free our mind and reduce the typo of datasource name which resulted in error.
We have also enhanced the SubReport feature. In the previous version, we use HTML comment tags to mark subreport section but we found that some web servers remove the HTML comment tags for the purpose of optimization which will cause big issue for SubReport so we change to use HTML element. As a result, SubReport now works perfectly.
In previous version of KoolReport, we may need to remove the resources folder when upgrade to new version. It is quite troublesome and easy to forget. In this version, we use KoolReport's version and widget's version as a factor to generate widget's url. It helps us to reduce the unneccessary work when upgrade library, KoolReport will make sure all generated resources files stay updated.
Last, we have improved the event of
Google Chart and
Table. Now in those events like rowClick or itemSelect, we will receive selectedRow with associate data beside the array one. For example, you can access the row id by
selectedRow or by
selectedRow['id']. This will add convenience to get data cell value for further processing.
Above are highlights, you may view the full release note.
Together with the new core, we have release below new package version:
- DataGrid 1.5.0: Adding formatValue for footer and enable data-search and and data-order feature.
- Pivot 4.1.0: Add count percentage and sum percentage to pivot process
- Cube 2.1.0: New
- Excel 3.0.0: Change to advanced
PHPOffice/PHPSpeadsheetlibrary and discard the deprecated
- ChartJS 1.2.0: Return associative array on event
- SparkLines 1.20: Add ability to write js in widget creation.
- Inputs 3.5.0: Add ability to write js in widget creation.
- Morris Chart 2.0.0: Use advanced jsonEncode() function.
- DrillDown 2.0.0: Ability to work with
Beside the new version of above packages, we have add two brand new packages
Those two packages are free and born to make KoolReport work seamlessly in CodeIgniter and Laravel environment. In the future, we will add more packages like those two to support KoolReport working in other PHP Frameworks like Symfony, Yii2 and etc.
And not to forget, we released KoolReport Pro 2.78.0 containing all above released packages. If you own KoolReport Pro, you may upgrade now.
Have thought that the previous version was perfect, we are proved to be wrong by this new releases with a lot of enhancements. Listening to users is the key point and we will continue to do so. We thank you so much for all of your suggestions, bug reports, your case of usages that you shared with us. That's priceless! Thank you!
If you have any questions or comments, please post on this forum topic.
<3 koolreport team