Gerar relatorio PDF e imprimi-lo

jose.afonso. paulino 30/04/2019 (há 6 anos)
A principio eu criei um formulário mestre/detalhe para cadastrar Vendas (mestre) e ItensVenda (detalhes , até então tudo certo. Agora preciso de um página que liste todas as despesas com seus respectivos itens e com opção para gerar um relatório em PDF e impressão.
 <?php
/**
 * VendaForm Master/Detail
 * @author  <your name here>
 */
class VendaForm extends TPage
{
    protected $form; // form
    protected $detail_list;
    
    /**
     * Page constructor
     */
    public function __construct()
    {
        parent::__construct();
        
        // creates the form
        $this->form = new BootstrapFormBuilder('form_Venda');
        $this->form->setFormTitle('Venda');
        
        // master fields
        $ven_cod = new TEntry('ven_cod');
        $cliente = new TEntry('cliente');
        $cli_cod_fk = new TDBUniqueSearch('cli_cod_fk', 'bd_venda', 'Cliente', 'cli_cod', 'cli_nome');
        // detail fields
        $detail_itv_cod = new THidden('detail_itv_cod');
        $detail_cod_prod = new TDBUniqueSearch('detail_cod_prod', 'bd_venda', 'Produto', 'pro_cod', 'pro_nome');
        $detail_preco_venda = new TEntry('detail_preco_venda');
        $detail_quantidade = new TEntry('detail_quantidade');
       
       
        $detail_cod_prod->setChangeAction( new TAction([$this, 'onProductChange']));
        if (!empty($ven_cod))
        {
            $ven_cod->setEditable(FALSE);
        }
        
        // master fields
        $this->form->addFields( [new TLabel('Código')], [$ven_cod] );
        $this->form->addFields( [new TLabel('Cliente')], [$cliente] );
        $this->form->addFields( [new TLabel('Cliente Fidelizado')], [$cli_cod_fk] );
        
        // detail fields
        $this->form->addContent( ['<h4>Detalhes da Venda</h4><hr>'] );
        $this->form->addFields( [$detail_itv_cod] );
        
        $this->form->addFields( [new TLabel('Produto')], [$detail_cod_prod] );
        $this->form->addFields( [new TLabel('Preço ')], [$detail_preco_venda] );
        $this->form->addFields( [new TLabel('Quantidade')], [$detail_quantidade] );
       
        $add = TButton::create('add', [$this, 'onSaveDetail'], 'Register', 'fa:save');
        $this->form->addFields( [], [$add] )->style = 'background: whitesmoke; padding: 5px; margin: 1px;';
        
        $this->detail_list = new BootstrapDatagridWrapper(new TQuickGrid);
        $this->detail_list->style = "min-width: 700px; width:100%;margin-bottom: 10px";
        $this->detail_list->setId('Venda_list');
        
        // items
      $prod=   $this->detail_list->addQuickColumn('Produto', 'cod_prod', 'left', 50);
      $preco=  $this->detail_list->addQuickColumn('Preço ', 'preco_venda', 'left', 30);
        $this->detail_list->addQuickColumn('Quantidade', 'quantidade', 'left', 30);
      
        
        
         //Calcula o total da datagrid
        $subtotal = $this->detail_list->addQuickColumn('Subtotal', '={quantidade} *  {preco_venda}', 'right', 50);
   
         //Converte o valor numerico em milhares
        $format_value = function($value){
            if  (is_numeric($value))
            {
                return  'Kz '  .  number_format ($value,   2,   ' ,  ' ,  '  .  ');
            }
            return $value;
        };
        
        $subtotal->setTransformer($format_value);
        $preco->setTransformer($format_value);
 
       $subtotal->setTotalFunction(function($values){
           return array_sum((array) $values);
       });
       
       $prod-> setTransformer( function ($value)   {
             return Produto :: findInTransaction ( 'bd_venda' ,  $value  )->pro_nome;
       });
        // detail actions
        $this->detail_list->addQuickAction( 'Edit',   new TDataGridAction([$this, 'onEditDetail']),   'itv_cod', 'fa:edit blue');
        $this->detail_list->addQuickAction( 'Delete', new TDataGridAction([$this, 'onDeleteDetail']), 'itv_cod', 'fa:trash red');
        $this->detail_list->createModel();
        
        $panel = new TPanelGroup;
        $panel->add($this->detail_list);
        $panel->getBody()->style = 'overflow-x:auto';
        $this->form->addContent( [$panel] );
        $btn = $this->form->addAction( _t('Save'),  new TAction([$this, 'onSave']), 'fa:save');
        $btn->class = 'btn btn-sm btn-primary';
        $this->form->addAction( _t('Clear'), new TAction([$this, 'onClear']), 'fa:eraser red');
        
        // create the page container
        $container = new TVBox;
        $container->style = 'width: 100%';
        // $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        parent::add($container);
    }
    
     //METODO QUE BUSCA O PREÇO DO ITEM 
    public static function onProductChange( $params )
    {
        if(!empty($params['detail_cod_prod']))
        {
            try
            {
                TTransaction :: open('bd_venda');
                
                $produto = Produto :: find($params['detail_cod_prod']);
                $fill_data = new StdClass;
                $fill_data->detail_preco_venda  =  $produto->pro_preco;
                
                TForm :: sendData ('form_Venda', $fill_data);
                TTransaction::close();   
            }
            catch(Exception $e)
            {
                new TMessage('error', $e->getMessage());
                TTransaction::rollback();
            }
        }
    }
 
    /**
     * Clear form
     * @param $param URL parameters
     */
    public function onClear($param)
    {
        $this->form->clear(TRUE);
        TSession::setValue(__CLASS__.'_items', array());
        $this->onReload( $param );
    }
    
    /**
     * Save an item from form to session list
     * @param $param URL parameters
     */
    public function onSaveDetail( $param )
    {
        try
        {
            TTransaction::open('bd_venda');
            $data = $this->form->getData();
            
            /** validation sample
            if (empty($data->fieldX))
            {
                throw new Exception('The field fieldX is required');
            }
            **/
            
            $items = TSession::getValue(__CLASS__.'_items');
            $key = empty($data->detail_itv_cod) ? 'X'.mt_rand(1000000000, 1999999999) : $data->detail_itv_cod;
            
            $items[ $key ] = array();
            $items[ $key ]['itv_cod'] = $key;
            $items[ $key ]['cod_prod'] = $data->detail_cod_prod;
            $items[ $key ]['preco_venda'] = $data->detail_preco_venda;
            $items[ $key ]['quantidade'] = $data->detail_quantidade;
          
            
            TSession::setValue(__CLASS__.'_items', $items);
            
            // clear detail form fields
            $data->detail_itv_cod = '';
            $data->detail_cod_prod = '';
            $data->detail_preco_venda = '';
            $data->detail_quantidade = '';
          
            
            TTransaction::close();
            $this->form->setData($data);
            
            $this->onReload( $param ); // reload the items
        }
        catch (Exception $e)
        {
            $this->form->setData( $this->form->getData());
            new TMessage('error', $e->getMessage());
        }
        $this->form->clear(TRUE);  //Para Limpar os campos do formulario Mestre
    }
    
    /**
     * Load an item from session list to detail form
     * @param $param URL parameters
     */
    public static function onEditDetail( $param )
    {
        // read session items
        $items = TSession::getValue(__CLASS__.'_items');
        
        // get the session item
        $item = $items[ $param['key'] ];
        
        $data = new stdClass;
        $data->detail_itv_cod = $item['itv_cod'];
        $data->detail_cod_prod = $item['cod_prod'];
        $data->detail_preco_venda = $item['preco_venda'];
        $data->detail_quantidade = $item['quantidade'];
      
        
        // fill detail fields
        TForm::sendData( 'form_Venda', $data );
    }
    
    /**
     * Delete an item from session list
     * @param $param URL parameters
     */
    public static function onDeleteDetail( $param )
    {
        // reset items
        $data = new stdClass;
            $data->detail_cod_prod = '';
            $data->detail_preco_venda = '';
            $data->detail_quantidade = '';
            
        
        // clear form data
        TForm::sendData('form_Venda', $data );
        
        // read session items
        $items = TSession::getValue(__CLASS__.'_items');
        
        // get detail id
        $detail_id = $param['key'];
        
        // delete the item from session
        unset($items[ $detail_id ] );
        
        // rewrite session items
        TSession::setValue(__CLASS__.'_items', $items);
        
        // delete item from screen
        TScript::create("ttable_remove_row_by_id('Venda_list', '{$detail_id}')");
    }
    
    /**
     * Load the items list from session
     * @param $param URL parameters
     */
    public function onReload($param)
    {
        // read session items
        $items = TSession::getValue(__CLASS__.'_items');
        
        $this->detail_list->clear(); // clear detail list
        
        if ($items)
        {
            foreach ($items as $list_item)
            {
                $item = (object) $list_item;
                
                $row = $this->detail_list->addItem( $item );
                $row->id = $list_item['itv_cod'];
            }
        }
        
        $this->loaded = TRUE;
    }
    
    /**
     * Load Master/Detail data from database to form/session
     */
    public function onEdit($param)
    {
        try
        {
            TTransaction::open('bd_venda');
            
            if (isset($param['key']))
            {
                $key = $param['key'];
                
                $object = new Venda($key);
                $items  = Itensvenda::where('cod_venda', '=', $key)->load();
                
                $session_items = array();
                foreach( $items as $item )
                {
                    $item_key = $item->itv_cod;
                    $session_items[$item_key] = $item->toArray();
                    $session_items[$item_key]['itv_cod'] = $item->itv_cod;
                    $session_items[$item_key]['cod_prod'] = $item->cod_prod;
                    $session_items[$item_key]['preco_venda'] = $item->preco_venda;
                    $session_items[$item_key]['quantidade'] = $item->quantidade;
                   // $session_items[$item_key]['desconto'] = $item->desconto;
                }
                TSession::setValue(__CLASS__.'_items', $session_items);
                
                $this->form->setData($object); // fill the form with the active record data
                $this->onReload( $param ); // reload items list
                TTransaction::close(); // close transaction
            }
            else
            {
                $this->form->clear(TRUE);
                TSession::setValue(__CLASS__.'_items', null);
                $this->onReload( $param );
            }
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage());
            TTransaction::rollback();
        }
    }
    
    /**
     * Save the Master/Detail data from form/session to database
     */
    public function onSave()
    {
    
        try
        {
            // open a transaction with database
            TTransaction::open('bd_venda');
            
            $data = $this->form->getData();
            $master = new Venda; 
            $master->fromArray( (array) $data);
            $this->form->validate(); // Valida a data do formulario
            
            $master->store(); // save master object
            // delete details
            $old_items = Itensvenda::where('cod_venda', '=', $master->ven_cod)->load();
            
            $keep_items = array();
            
            // get session items
            $items = TSession::getValue(__CLASS__.'_items');
            
            if( $items )
            {
                foreach( $items as $item )
                {
                    if (substr($item['itv_cod'],0,1) == 'X' ) // new record
                    {
                        $detail = new Itensvenda;
                    }
                    else
                    {
                        $detail = Itensvenda::find($item['itv_cod']);
                    }
                    $detail->cod_prod  = $item['cod_prod'];
                    $detail->preco_venda  = $item['preco_venda'];
                    $detail->quantidade  = $item['quantidade'];
                    $detail->cod_venda = $master->ven_cod;
                    
                    // Criamos um Campo  ven_total  para guardar o total da venda
                     $detail->ven_total = ($detail->quantidade * ($detail->preco_venda));
                   
                    $detail->store(); // Guarda os itens dos detalhes
      
                    $this->form->setData($data); //  Preencha a Data no Formulário
                
                    $master->ven_total += $detail->ven_total;
                     
                    $master->venda_data = date('Y-m-d H:m:s');
                    
                    $keep_items[] = $detail->itv_cod;
                }
                      $master->store();
            }
            
            if ($old_items)
            {
                foreach ($old_items as $old_item)
                {
                    if (!in_array( $old_item->itv_cod, $keep_items))
                    {
                        $old_item->delete();
                    }
                }
            }
            
             
            TTransaction::close(); // close the transaction
            
            // reload form and session items
            $this->onEdit(array('key'=>$master->ven_cod));
            
            new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'));
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage());
            $this->form->setData( $this->form->getData() ); // keep form data
            TTransaction::rollback();
        }
        $this->form->clear(TRUE);  //Para Limpar os campos do formulario Mestre
    }
    
    
    
    /**
     * Show the page
     */
    public function show()
    {
        // check if the datagrid is already loaded
        if (!$this->loaded AND (!isset($_GET['method']) OR $_GET['method'] !== 'onReload') )
        {
            $this->onReload( func_get_arg(0) );
        }
        parent::show();
    }
}
Curso Dominando o Adianti Framework

Comentários (1)
