<?php
function onGenerate()
    {
        try
        {
            // open a transaction with database 'samples'
            TTransaction::open('guttierre');
            
            // load all customers
            $repository = new TRepository('Custo');
            $criteria   = new TCriteria;
            $Custo = $repository->load($criteria);
            
            $data = $this->form->getData('Custo');
            $this->form->validate();
            
            $designer = new TPDFDesigner;
            $designer->fromXml('app/reports/ListaCusto.pdf.xml');
            $designer->generate();
                                    
            $fill = TRUE;
            $designer->gotoAnchorXY('');
            $designer->SetFont('Arial', '', 8);
            $designer->setFontColorRGB( '#000000' );
           
           $designer->setAutoPageBreak(true,0);
           
            if ($Custo)
            {
                foreach ($Custo as $Custo)
                {
                    $designer->gotoAnchorX('');
                    $designer->Ln(18);
                    $designer->Cell(70,10, DateTime::createFromFormat('Y-m-d', $Custo->data_custo)->format( 'd/m/Y' ), 0, 0, 'C', $fill);
                    $designer->Cell(410, 12, utf8_decode($Custo->fornecedor->descricao), 0, 0, 'L', $fill);
                    $designer->Cell(85, 12, utf8_decode($Custo->custo_total), 0, 0, 'R', $fill);
                    // cabeçalho
                    $designer->Image('http://zeromeia.com/apps/zeromeia/app/images/ZeroMeia_640x286.jpg',20,18,-300);
                    $designer->SetY(75);
                    $designer->SetFont('Arial', '', 18);
                    $designer->setFontColorRGB( '#000000' );
                    $designer->SetxY(50,86);
                    $designer->SetFont('Arial', '', 10);
                    $designer->setFontColorRGB( '#000000' );
                    $designer->Cell(0, 10, utf8_decode('www.zeromeia.com'),0,0,'L');
                                                             
                                                             
                    // rodapé
                    $designer->SetY(-12);
                    $designer->SetFont('Arial', '', 8);
                    $designer->setFontColorRGB( '#000000' ); 
                    $designer->Cell(590, 10, utf8_decode('Pág. ').$designer->PageNo().' de {nb}',0,0,'R');                                         
                    $designer->SetY(-12);
                    $designer->Cell(122, 10, utf8_decode('Zero Meia Tecnologia © 2018 '),0,0,'R'); 
                    $designer->SetY(-12);
                    $designer->Cell(340,10,utf8_decode("Impresso em ".date("d/m/Y H:i:s"."")),0,1,'R');
                    $designer->SetY(-12);
                    $designer->Cell(410,10,utf8_decode(" - ".TSession::getValue('username')),0,1,'R'); //nome do usuário
                    
                    // grid background
                    $fill = !$fill;
                }
            }
            
            $file = 'app/output/ListaCusto.pdf';
            
            if (!file_exists($file) OR is_writable($file))
            {
                $designer->save($file);
                parent::openFile($file);
            }
            else
            {
                throw new Exception(_t('Permission denied') . ': ' . $file);
            }
            
           // new TMessage('info', 'Relatório gerado. Por favor, habilite os popups no seu navegador.');
            
            // close the transaction
            TTransaction::close();
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', '<b>Error</b> ' . $e->getMessage());
            TTransaction::rollback();
        }
    }
?>