I have a drilldown report with multiselect. For the first selection all is working fine, but clicking on year column [No data available in chart] is displayed, because (i think) multiselect values are not passed.

<?php

class SalesByZones extends \koolreport\KoolReport
{

    use \koolreport\inputs\Bindable;
    use \koolreport\inputs\POSTBinding;



    protected function defaultParamValues()
    {
        return array(
            "categories" => array(
                "0"
            ),
        );
    }

    protected function bindParamsToInputs()
    {
        return array(
            "categories"=>"categories",
        );
    }


    public function settings()
    {
        return array(
            "dataSources"=>array(
                "sales"=>array(
                    "connectionString"=>"",
                    "username"=>"",
                    "password"=>"",
                    "charset"=>"utf8"
                )
            )
        );
    }

    function setup()
    {
        $node = $this->src('sales')
            ->query("SELECT * FROM services WHERE company_id=".CURRENT_LOGIN_COMPANY_ID." AND is_product=0 AND zone_number>0")

            ->pipe($this->dataStore('categories'));
    }


}

<?php
use \koolreport\drilldown\DrillDown;
use \koolreport\processes\CopyColumn;
use \koolreport\processes\DateTimeFormat;
use \koolreport\widgets\google\ColumnChart;
//use \koolreport\chartjs\ColumnChart;
use \koolreport\inputs\MultiSelect;

?>

    <div class="text-center">

    </div>
    <hr/>
    <form method="post">
        <div class="row">
            <div class="col-md-8 col-md-offset-2">

                <div class="form-group">
                    <?php
                    MultiSelect::create(array(
                        "name"=>"categories",
                        "dataStore"=>$this->dataStore("categories"),
                        "dataBind"=>array(
                            "text"=>"service_name",
                            "value"=>"id",
                        ),
                        "attributes"=>array(
                            "class"=>"form-control",
                            "size"=>20,
                        )
                    ));
                    ?>
                </div>
                <div class="form-group text-center">
                    <button class="btn btn-success"><i class="glyphicon glyphicon-refresh"></i> Genera</button>
                </div>
            </div>
        </div>
    </form>

    <hr/>
<?php
DrillDown::create(array(
    "name"=>"saleDrillDown",
    "title"=>"Report Zone",
    "btnBack"=>true,
    "dataSource"=>(
    $this->src('sales')
        ->query("SELECT s.zone_number, DATE(appointment_date) AS adate FROM appointments a join services s on s.id=a.service_id WHERE a.service_id IN (:categories) AND a.status='paid'")
        ->params(array(
            ":categories"=>$this->params["categories"][0]
        ))
        ->pipe(new CopyColumn(array(
            "year"=>"adate",
            "month"=>"adate",
            "day"=>"adate",
        )))
        ->pipe(new DateTimeFormat(array(
            "year"=>"Y",
            "month"=>"m",
            "day"=>"d",
        )))
    ),
    "calculate"=>array(
        "sum"=>"zone_number"
    ),
    "levels"=>array(
        array(
            "groupBy"=>"year",
            "widget"=>array(ColumnChart::class,array(
                "columns"=>array("year","zone_number"=>array(
                    "label"=>"Zone",
                    "suffix"=>' zone'
                )),
                "colorScheme"=>array("#3b9b00"),
            )),
            "title"=>"All Years",
        ),
        array(
            "groupBy"=>"month",
            "widget"=>array(ColumnChart::class,array(
                "columns"=>array("month","zone_number"=>array(
                    "label"=>"Zone",
                    "suffix"=>' zone'
                )),
                "colorScheme"=>array("#af17b5"),
            )),
            "title"=>function($params)
            {
                return "Year ".$params["year"];
            },
        ),
        array(
            "groupBy"=>"day",
            "widget"=>array(ColumnChart::class,array(
                "columns"=>array("day","zone_number"=>array(
                    "label"=>"Zone",
                    "suffix"=>' zone'
                )),
                "colorScheme"=>array("#e0dc00"),
            )),
            "title"=>function($params)
            {
                return date('F', mktime(0, 0, 0, $params["month"], 10));
            },
        ),
    ),
));
?>

Please, i need answer on this topic. Thanks

Support is dead?

Sorry, tested but not working

[No data available in chart]

Please, answer this, thanks a lot

No errors