<?php
class ConsumoParceiroBarChartView extends TPage
{
    /**
     * Class constructor
     * Creates the page
     */
    function __construct( $show_breadcrumb = true, $params = NULL)
    {
        parent::__construct();
        
        $html = new THtmlRenderer('app/resources/google_bar_horizontal_chart.html');
        try {
            TTransaction::open(App::Database());
            $consumo_parceiros = array();
            
            $sql  = 'select ';
            $sql .= 'pessoa.fantasia, ';
            $sql .= 'count(vconsumo.id) as consumo ';
            $sql .= 'from vconsumo ';
            $sql .= 'inner join pessoa on pessoa.id = vconsumo.pessoa_id ';
            $sql .= 'where (vconsumo.edicao_id = '. $params['edicao_id'] .') ';
            $sql .= 'group by pessoa.fantasia ';
            $sql .= 'order by consumo';
            
            $conn = TTransaction::get();
            $result = $conn->query($sql);
            $consumo_parceiros = array();
            foreach ($result as $row);
            {
                $consumo_parceiros[] = [$row['fantasia'],$row['consumo']];     
            }
            
            var_dump($consumo_parceiros);
            TTransaction::close();
            
        } catch (Exception $e) {
            
            var_dump($e->getMessage());
            TTransaction::rollback();
        }
        
        # PS: If you use values from database ($row['total'), 
        # cast to float. Ex: (float) $row['total']
        
        $panel = new TPanelGroup($params['title']);
        $panel->style = 'width: 100%';
        $panel->add($html);
        
        $data = $consumo_parceiros; 
        // replace the main section variables
        $html->enableSection('main', array('data'   => json_encode($data),
                                           'width'  => $params['width'],
                                           'height' => $params['height'],
                                           'title'  => $params['title'],
                                           'ytitle' => $params['ytitle'], 
                                           'xtitle' => $params['xtitle'],
                                           '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($panel);
        parent::add($container);
    }
}
</code>