<?php
class GraficoBensPorTipoProd extends TPage
{
    private $form;
    
    function __construct( $show_breadcrumb = true )
    {
        parent::__construct();
        
        $html = new THtmlRenderer('app/resources/google_column_chart.html');
        
        //$data = array();
        //$data[] = [ 'Day', 'Value 1', 'Value 2', 'Value 3' ];
        //$data[] = [ 'Day 1',   100,       120,       140 ];
        //$data[] = [ 'Day 2',   120,       140,       160 ];
        //$data[] = [ 'Day 3',   140,       160,       180 ];
        
        # PS: If you use values from database ($row['total'), 
        # cast to float. Ex: (float) $row['total']
        
        TTransaction::open('patrimonio');
        $conn = TTransaction::get();
        
        $colunas = $conn->query('SELECT * FROM viewgraficobensportipo');
        $dados[] = ['Categoria','Valor'];
        
        
        
        
        foreach($colunas as $coluna)
        {
            $dados[] = [$coluna[0],$coluna[1]];
        }
        
        
        echo'<pre>';
        print_r($dados);
        echo'</pre>';
        
        
        // replace the main section variables
        $html->enableSection('main', array('data'   => $dados,
                                           'width'  => '100%',
                                           'height'  => '300px',
                                           'title'  => 'Bens por Tipo',
                                           'ytitle' => 'Valores', 
                                           'xtitle' => 'Tipo',
                                           'uniqid' => uniqid()));
        
        // add the template to the page
        $container = new TVBox;
        $container->style = 'width: 100%';
        if ($show_breadcrumb)
        {
            //$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        }
        $container->add($html);
        parent::add($container);
    }
    
}