Release of KoolReport v1.32.8 and Inputs package

Time to meet up and party again. We have released KoolReport v.1.32.8 and a very essential package called Inputs.

In this new version of KoolReport we have several important updates:

First, PDODataSource is now able to bind parameters to SQL Query as we understand that mixing query with parameter is looking bad. Here comes example:

function setup()
{
    $this->src('sale_database')
    ->query("
        SELECT *
        FROM tbl_orders
        WHERE
            orderDate > :startDate
            AND
            orderDate< :endDate
    ")
    ->params(array(
        ":startDate"=>$this->params["startDate"],
        ":endDate"=>$this->params["endDate"],
    ))
}

Second, the \koolreport\koolphp\Table has been able to set 'align' for each columns. Although this can be done through setting css class for column in previous version, it is handy to set directly to the column settings.

<?php
Table::create(array(
    ...
    "columns"=>array(
        "price"=>array(
            "align"=>"right"
        )
    )
));
?>

Third, we have fixed the errors of missing row in ColumnsSort and also created a new process called Map which is very versatile to transform data.

Please go to our website to acquire new version of KoolReport.

Save the best for last, the Inputs package, your simplest way to create a dynamic report.

From the beginning, report created on KoolReport is able to receive parameters. We can create our own form and transmit values from form to report to make it dynamic. However, the process is quite tedious. It requires us to create form and inputs controls and make them persistent to the state of user's input. That is the reason, we create Input package to simplify those tasks.

The Input package features:

1. Containing common inputs: TextBox, CheckBoxList, RadioList, Select, MultiSelect, DateRangePicker and DateTimePicker.
2. Input controls are able to bind to data to render
3. State of input are persistent through POST/GET and in sync with report's parameters.

Here are two short demos:

1. List of all input controls
2. Order Listing example using input controls

The package is Totally Free.

Thank you for your time to keep update with our work.

<3 koolreport team