• Overview
  • Example
• Properties
  • Css Properties
  • Level properties
  • Client events

LegacyDrillDown

Overview #

Note: LegacyDrillDown is the old DrillDown Widget. If you have used the old drilldown report, rename the class to LegacyDrillDown.

LegacyDrillDown is an widget that allows you to setup an drill-down report in fastest and easiest way. All you need to do are:

1. Setup SQL Statement to withdraw data
2. Setup multi-levels of drill-down.
3. On each level of drill-down, choose chart type to visualize data

Example #

<?php 
LegacyDrillDown::create(array(
    "name"=>"saleReportByLocation",
    "title"=>"Sale By Location",
    //Define dataSource which is SQL statement to load all table
    "dataSource"=>(
        $this->src("mydata")->query("SELECT country, state, city, sale_amount FROM orders")
    ),
    //What we want to calculate
    "calculate"=>array(
        "sum"=>"sale_amount"
    ),
    "levels"=>array(
        //Level 1: Group all table by country, showing all countries with `sale_amount` by country.
        array(
            "groupBy"=>"country",
            "widget"=>array(ColumnChart::class,array(
                "columns"=>array("country","sale_amount")
            ))
            "title"=>"All countries",
        ),
        //Level 2: When user select a country, the widget shows `sale_amount` by state of that country
        array(
            "groupBy"=>"state",
            "widget"=>array(ColumnChart::class,array(
                "columns"=>array("state","sale_amount")
            )),
            "title"=>function($params)
            {
                return $params["country"];
            }
        ),
        //Level 3: When user continues to select a state, then widget will show  `sale_amount` by city of that state
        array(
            "groupBy"=>"city",
            "widget"=>array(Table::class,array(
                "columns"=>array("city","sale_amount")
            )),
            "title"=>function($params)
            {
                return $params["city"];
            }
        )
    )
));
?>

Properties #

Css Properties #

Examples

<?php
LegacyDrillDown::create(array(
    ...
    "css"=>array(
        "btnBack"=>"font-style:italic";
        "body"=>"height:300px;"
    )
));
?>

Level properties #

As we have seen from example on the top of page, levels property is an array of each level. Before are the settings of a level

Client events #

LegacyDrillDown support following events:

Example

<?php
LegacyDrillDown::create(array(
    ...
    "clientEvents"=>array(
        "nexting"=>"function(params){
            return false;//Cancel action
        }",
        "nexted"=>"function(params){
            console.log('Nexted to'+params.level);
        }",
    );
));
?>