Hide Sections

The hideSections() method allows different elements of the report output to be hidden.

This allows production of more summary reports to show, for example, just charts or group summary data.



<?php
      
\Reportico\Engine\Builder::build()
          ...
          ->
hideSections("detail"|"critera"|"columnheaders"|"groupheaders"|"grouptrailers"|"charts")
          ...
          ->
execute();
?>
1


The following example shows the stock report that includes a charts and hides the detail section, meaning that the report only shows the group and chart output.

Run Demo


<?php

      
require_once(__DIR__ .'/../vendor/autoload.php');
      

      \
Reportico\Engine\Builder::build()
          ->
properties([ "bootstrap_preloaded" => true])
          ->
datasource()->database("mysql:host=localhost; dbname=DATABASE NAME")->user("USER")->password("PASSWORD")
          ->
title     ("Product Stock")
          ->
description     ("Produces a list of our employees")
          ->
sql       ("
              SELECT  ProductID id, ProductName product, UnitsInStock in_stock, UnitsOnOrder on_order, companyname Company, country, categoryname category
              FROM northwind_products 
              join northwind_suppliers on northwind_products.supplierid = northwind_suppliers.supplierid
              join northwind_categories on northwind_products.categoryid = northwind_categories.categoryid
              WHERE 1 = 1  
              ORDER BY categoryname
                "
)
          ->
expression("total_stock")->sum("in_stock","category")
          ->
group("category")
              ->
throwPageBefore()
              
//->trailer("total_stock")->below("in_stock")->label("Total")
              
->customTrailer("Total in stock for category {category} is {total_stock}""border: solid 2px #228; background-color: #222; color: #fff;  right: 0px; margin-left: auto;  width: 50%; padding: 10px;")
              ->
header("category")
          ->
chart("category")
              ->
title("Stock Levels")
              ->
plot("in_stock")->plotType("bar")->legend("In stock")
              ->
plot("reorder_level")->plotType("line")->legend("Reorder Level")
              ->
xlabels("product")
              ->
xtitle("Levels")
              ->
ytitle("Products")
          ->
column("in_stock")->justify("right")
          ->
column("on_order")->justify("right")
          ->
hideSections("detail")
          ->
execute();
?>