<?php
class PainelAgr01 extends TPage {
    private $form;
    private $notebook;
    private $datagrid1; 
    private $sql1 = '';
    function __construct() {
        parent::__construct();
        
        $this->sql1 = ' SELECT T1.COD_PES,
                               T1.DESC_PES,
                               T1.COD_FAZ,
                               T1.DESC_FAZ,
                               T1.DT_MES,
                               T1.DT_ANOMES,
                               T1.FG_TIPO,
                               T1.QT_DIST,
                               T1.QT_TON_ENT,
                               T1.QT_ATR_COLH,
                               T1.QT_ATR_PGTO,
                               T1.VR_ATR_PGTO,
                               T1.QT_TON_DESC,
                               T1.QT_ATR_DESC,
                               T1.VR_ATR_DESC,
                               T1.VR_TOT_PGTO,
                               T1.VR_DESC_CT,
                               T1.VR_DESC_T,
                               T1.VR_DESC_INS,
                               T1.VR_DESC_FIN,
                               T1.VR_DESC_OUT,
                               T1.VR_DESC_FUNRURAL,
                               T1.VR_DESC_ASSOC,
                               T1.VR_PGTO_PERC,
                               T1.VR_PGTO_ACERT1,
                               T1.VR_PGTO_ACERT2,
                               T1.VR_PGTO_ACERT3,
                               T1.VR_PGTO_ACERT4,
                               T1.VR_PGTO_ACERT_FIN
                          FROM VAGR_PAINEL01 T1';
        
        
        //Inclui CSS novo
        //======================================================================
        parent::include_css('app/resources/styles.css');
        
        //Cria Formulário
        //======================================================================
        $this->form = new TQuickForm('form_PainelAgr01');
        $this->form->class = 'tform'; // change CSS class
        $this->form->style = 'display: table;width:100%'; // change style
        $this->form->setFormTitle('Painel de Fornecedores');
        //Campos de Filtro
        //======================================================================
        $EdFiltroAno = new TEntry('EdFiltroAno');
         
        //Linha da Tabela para Campos
        //======================================================================
        $row = $this->form->addRow();
        $row->addCell(new TLabel('Ano'));
        $row->addMultiCell($EdFiltroAno);
        $this->form->addQuickAction(_t('Find'), new TAction(array($this, 'onSearch')), 'ico_find.png');
        
        //Cria Notebook
        //======================================================================
        $this->notebook = new TNotebook(500, 400);
        //Cria Páginas dentro notebook
        //======================================================================
        $page1 = new TTable;
        $page2 = new TTable;
        $page1->style = "margin: 4px";
        $page2->style = "margin: 4px";
        $this->notebook->appendPage('Por Mês', $page1);
        $this->notebook->appendPage('Resumo', $page2);
        
        //======================================================================        
        //Datagrid por Mes
        //======================================================================
        $this->datagrid1 = new BootstrapDatagridWrapper(new TDataGrid);
        $this->datagrid1->style = 'width: 99%';
        $this->datagrid1->setHeight(320);
        $this->datagrid1->makeScrollable(); 
        $this->datagrid1->datatable = 'true';
        //======================================================================  
        //Datagrid por Mes - Colunas
        //======================================================================        
        $column_COD_PES            = new TDataGridColumn('COD_PES','Cód. Pessoa','left',180);
        $this->datagrid1->addColumn($column_COD_PES);
        
        $column_DESC_PES           = new TDataGridColumn('DESC_PES','Descrição','left',180);
        $this->datagrid1->addColumn($column_DESC_PES);
        
        $column_COD_FAZ            = new TDataGridColumn('COD_FAZ','Cód. Fazenda','left',180);
        $this->datagrid1->addColumn($column_COD_FAZ);
        
        $column_DESC_FAZ           = new TDataGridColumn('DESC_FAZ','Descrição','left',180);
        $this->datagrid1->addColumn($column_DESC_FAZ);
        
        $column_DT_ANOMES          = new TDataGridColumn('DT_ANOMES','Ano/Mês','left',100);
        $this->datagrid1->addColumn($column_DT_ANOMES);
        
        $column_QT_DIST            = new TDataGridColumn('QT_DIST','Distância','right',180);
        $this->datagrid1->addColumn($column_QT_DIST);
        
        $column_QT_TON_ENT         = new TDataGridColumn('QT_TON_ENT','Qtd. Entrada','right',180);
        $this->datagrid1->addColumn($column_QT_TON_ENT);    
        
        $column_QT_ATR_COLH        = new TDataGridColumn('QT_ATR_COLH','Qtd. ATR Col.','right',180);
        $this->datagrid1->addColumn($column_QT_ATR_COLH);         
        
        $column_QT_ATR_PGTO        = new TDataGridColumn('QT_ATR_PGTO','Qtd. ATR Pgto.','right',180);
        $this->datagrid1->addColumn($column_QT_ATR_PGTO); 
        
        $column_VR_ATR_PGTO        = new TDataGridColumn('VR_ATR_PGTO','Vr. ATR Pgto.','right',180);
        $this->datagrid1->addColumn($column_VR_ATR_PGTO); 
        
        $column_VR_TOT_PGTO        = new TDataGridColumn('VR_TOT_PGTO','Vr. Total Pgto.','right',180);
        $this->datagrid1->addColumn($column_VR_TOT_PGTO); 
        
            
        //Cria Modelo de Dados
        //======================================================================
        $this->datagrid1->createModel();
        //Cria Paginação
        //======================================================================
        $this->datagrid1->disableDefaultClick();
        
        $page1->add($this->datagrid1);
        
        $this->form->setFields(array($EdFiltroAno));
        
        //Cria BreadCrumb do Menu
        //======================================================================
        $container = new TVBox;
        $container->style = 'width: 90%';
        //$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        $container->add($this->notebook);
        
        parent::add($container);
    }
     public function onSearch()     {
        
        //Busca Dados dentro Foms
        //======================================================================
        $data = $this->form->getData();
        
        //Limpa/Grava Variáveis para Filtro
        //======================================================================
        TSession::setValue('form_PainelAgr01_filter_EdFiltroAno',   NULL);
        if (isset($data->DT_ANO) AND ($data->DT_ANO)) {
            //$filter = new TFilter('DT_ANO', '=', "$data->DT_ANO");
            //TSession::setValue('form_PainelAgr01_filter_EdFiltroAno',$filter);
        }
        
        //Grava Dados no Form e Variáveis
        //======================================================================
        $this->form->setData($data);
        TSession::setValue('form_PainelAgr01_filter_data', $data);
        
        //Prepara parametro de Passagem
        //======================================================================        
        $param=array();
        $param['offset']    =0;
        $param['first_page']=1;
        $this->onReloadDbg1($param);
    }
     public function onReloadDbg1($param = NULL)
     {
        try
        {
            //Abrindo Conexão
            //======================================================================            
            TTransaction::open('permission');
            $conn = TTransaction::get();
            //Montando Filtros
            //====================================================================== 
     
            //Carregas Objetos do Repositório
            //====================================================================== 
            $result1 = $conn->query($this->sql1);
  
            //Carregas DataGrid
            //====================================================================== 
            $this->datagrid1->clear();
            $count = 0;
            if ($result1)
            {
                foreach ($result1 as $row)
                {
                    $item = new StdClass;
                    $item->COD_PES            = $row['COD_PES'];
                    $item->DESC_PES           = $row['DESC_PES'];
                    $item->COD_FAZ            = $row['COD_FAZ'];
                    $item->DESC_FAZ           = $row['DESC_FAZ'];
                    $item->DT_ANOMES          = $row['DT_ANOMES'];
                    $item->QT_DIST            = $row['QT_DIST'];
                    $item->QT_TON_ENT         = $row['QT_TON_ENT'];
                    $item->QT_ATR_COLH        = $row['QT_ATR_COLH'];
                    $item->QT_ATR_PGTO        = $row['QT_ATR_PGTO'];
                    $item->VR_ATR_PGTO        = $row['VR_ATR_PGTO'];
                    $item->VR_TOT_PGTO        = $row['VR_TOT_PGTO'];
                    $this->datagrid1->addItem($item);
                    $count++;
                }
            }
            
            //Fecha Conexão
            //======================================================================
            TTransaction::close();
            $this->loaded = true;
        }
        catch (Exception $e)
        {
            new TMessage('error', $e->getMessage());
            TTransaction::rollback();
        }
  
    
    } 
    
    public function show()
    {
         parent::show();
    }    
}//TPage
?>