<?php
class Grafico_Recebimentos extends TPage
{
    function __construct() 
    { 
        parent::__construct(); 
       
           
        
        $table = new TTable; 
        $div = new TElement('div'); 
        $div->id = 'imprimirpizza'; 
        $div->style = "width:590px;height:280px"; 
        $table->addRow()->addCell($div); 
        TTransaction::open('cta'); 
            
        $conn = TTransaction::get(); 
        $sql = " (SELECT month(pagamento), sum(valor)as Valor FROM ctarec 
                  where situacao='LQ'
                  group by month(pagamento)) "; 
        $colunas = $conn->query($sql);  
        $dados = ''; 
        
        $meses = array('Jan', 'Fev', 'Mar', 'Abr', 'Mai', 'Jun',  'Jul', 'Ago', 'Set', 'Out', 'Nov', 'Dez');  
    
        
        foreach ($colunas as $coluna) 
        { 
        $xmes = $meses[$coluna[0]-1];
        $dados = $dados . '["'.$xmes.'",'.$coluna[1].'],'; 
        
      
        
        } 
        TTransaction::close(); 
      
   $script = new TElement('script');
        $script->type = 'text/javascript';
        $javascript = "
         $('#imprimirpizza').highcharts({
                chart: {
                    plotBackgroundColor: null,
                    plotBorderWidth: null,
                    plotShadow: false
                },
                title: {text: 'Receita dos Últimos 12 meses.' },
                plotOptions: {
                    line: {
                        allowPointSelect: true,
                        cursor: 'pointer',
                        dataLabels: {
                            enabled: true,
                            format: '<b>{point.name}</b>: {point.y:.2f}',
                            style: {
                                color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'blue'
                            },
                            
                        }
                    }
                },
                 xAxis:
                 {categories: [".$coluna[1]."] },
                 yAxis:
                 {title: { text: 'R$'}},
                 
                series: [{
                   
                    name: 'R$',
                    data: [".$dados."],
                                       
                    
                }]
            });
        
        "; 
        $script->add($javascript); 
        parent::add($table);   
        parent::add($script); 
    }
}