Imprimir Nota Gerada Pelo PDF Designer por meio de uma Listagem

Imprimir Nota Gerada Pelo PDF Designer por meio de uma Listagem Pessoal, a situação é a seguinte, tenho o Adianti Studio Pro, e gostaria de após gerar minha LISTAGEM de NOTAS, quero inserir uma ação que, ao clicar nesse botão, eu imprima(gere) a Nota chamando o arquivo nfe.pdf.xml. Mas vejam o detalhe. Eu gostaria de gerar por meio de minha listagem gerada pelo Adianti Studio Pro. Um exemplo é, nessa lista: www.adianti.com.br/framework_files/tutor/in...

Paulo Silva 25/04/2019 (há 6 anos)

Pessoal, a situação é a seguinte, tenho o Adianti Studio Pro, e gostaria de após gerar minha LISTAGEM de NOTAS, quero inserir uma ação que, ao clicar nesse botão, eu imprima(gere) a Nota chamando o arquivo nfe.pdf.xml. Mas vejam o detalhe. Eu gostaria de gerar por meio de minha listagem gerada pelo Adianti Studio Pro.
Um exemplo é, nessa lista: www.adianti.com.br/framework_files/tutor/index.php?class=SaleList
Quero criar uma ação colocando um botão para gerar a NOTA de acordo com a venda selecionada.

Desde já agradeço a todos.

Curso Dominando o Adianti Framework

O material mais completo de treinamento do Framework.
Curso em vídeo aulas + Livro completo + Códigos fontes do projeto ERPHouse.
Conteúdo Atualizado!

Dominando o Adianti Framework Quero me inscrever agora!

Comentários (18)

Nataniel Rabaioli 29/04/2019 (há 6 anos)

Paulo, qual é exatamente sua dúvida? Já conseguiu gerar a ação na listagem e falta só instanciar a classe PDFDesigner?

Segue mais ou menos a estrutura de código necessária:

 <?php
public function onPrintNota($param)
{
         ...
         $object = new SeuModel($param['key']);
         ...
         $designer = new TPDFDesigner;
         $designer->fromXml('app/reports/nfe.pdf.xml');
         $designer->generate();
         ...
}
?>

Paulo Silva - AUTOR DO POST 02/05/2019 (há 6 anos)

Minha dúvida é a seguinte:
Tenho essa Listagem de Vendas, nela tem os itens da venda que posso editar em um formulário mestre detalhe certo. O que quero é colocar um botão na listagem, igual o botão Editar que, ao clicar nesse botão eu imprima a nota 'app/reports/nfe.pdf.xml' e seus respectivos itens dessa venda selecionada. Segue o código da minha listagem:

 <?php
/**
 * VendasLista Listing
 * @author  <your name here>
 */
class VendasLista extends TPage
{
    private $form; // form
    private $datagrid; // listing
    private $pageNavigation;
    private $formgrid;
    private $loaded;
    private $deleteButton;
    
    /**
     * Class constructor
     * Creates the page, the form and the listing
     */
    public function __construct()
    {
        parent::__construct();
        
        // creates the form
        $this->form = new BootstrapFormBuilder('form_Vendas');
        $this->form->setFormTitle('Vendas');
        
        // create the form fields
        $id = new TEntry('id');
        $data_venda = new TEntry('data_venda');
        // add the fields
        $this->form->addFields( [ new TLabel('Id') ], [ $id ] );
        $this->form->addFields( [ new TLabel('Data Venda') ], [ $data_venda ] );
        // set sizes
        $id->setSize('100%');
        $data_venda->setSize('100%');
        
        // keep the form filled during navigation with session data
        $this->form->setData( TSession::getValue('Vendas_filter_data') );
        
        // add the search form actions
        $btn = $this->form->addAction(_t('Find'), new TAction([$this, 'onSearch']), 'fa:search');
        $btn->class = 'btn btn-sm btn-primary';
        $this->form->addActionLink(_t('New'), new TAction(['VendasForm', 'onEdit']), 'fa:plus green');
        
        // creates a Datagrid
        $this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
        $this->datagrid->style = 'width: 100%';
        $this->datagrid->datatable = 'true';
        // $this->datagrid->enablePopover('Popover', 'Hi <b> {name} </b>');
        
        // creates the datagrid columns
        $column_id = new TDataGridColumn('id', 'Id', 'right');
        $column_data_venda = new TDataGridColumn('data_venda', 'Data Venda', 'left');
        $column_qtde_itens = new TDataGridColumn('qtde_itens', 'Qtde Itens', 'left');
        $column_total_vendas = new TDataGridColumn('total_vendas', 'Total Vendas', 'left');
        // add the columns to the DataGrid
        $this->datagrid->addColumn($column_id);
        $this->datagrid->addColumn($column_data_venda);
        $this->datagrid->addColumn($column_qtde_itens);
        $this->datagrid->addColumn($column_total_vendas);
        
        // create EDIT action
        $action_edit = new TDataGridAction(['VendasForm', 'onEdit']);
        //$action_edit->setUseButton(TRUE);
        //$action_edit->setButtonClass('btn btn-default');
        $action_edit->setLabel(_t('Edit'));
        $action_edit->setImage('fa:pencil-square-o blue fa-lg');
        $action_edit->setField('id');
        $this->datagrid->addAction($action_edit);
        
        // create DELETE action
        $action_del = new TDataGridAction(array($this, 'onDelete'));
        //$action_del->setUseButton(TRUE);
        //$action_del->setButtonClass('btn btn-default');
        $action_del->setLabel(_t('Delete'));
        $action_del->setImage('fa:trash-o red fa-lg');
        $action_del->setField('id');
        $this->datagrid->addAction($action_del);
        
        // create the datagrid model
        $this->datagrid->createModel();
        
        // creates the page navigation
        $this->pageNavigation = new TPageNavigation;
        $this->pageNavigation->setAction(new TAction([$this, 'onReload']));
        $this->pageNavigation->setWidth($this->datagrid->getWidth());
        
        // vertical box container
        $container = new TVBox;
        $container->style = 'width: 90%';
        // $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        $container->add(TPanelGroup::pack('', $this->datagrid, $this->pageNavigation));
        
        parent::add($container);
    }
    
    /**
     * Inline record editing
     * @param $param Array containing:
     *              key: object ID value
     *              field name: object attribute to be updated
     *              value: new attribute content 
     */
    public function onInlineEdit($param)
    {
        try
        {
            // get the parameter $key
            $field = $param['field'];
            $key   = $param['key'];
            $value = $param['value'];
            
            TTransaction::open('estoque'); // open a transaction with database
            $object = new Vendas($key); // instantiates the Active Record
            $object->{$field} = $value;
            $object->store(); // update the object in the database
            TTransaction::close(); // close the transaction
            
            $this->onReload($param); // reload the listing
            new TMessage('info', "Record Updated");
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage()); // shows the exception error message
            TTransaction::rollback(); // undo all pending operations
        }
    }
    
    /**
     * Register the filter in the session
     */
    public function onSearch()
    {
        // get the search form data
        $data = $this->form->getData();
        
        // clear session filters
        TSession::setValue('VendasLista_filter_id',   NULL);
        TSession::setValue('VendasLista_filter_data_venda',   NULL);
        if (isset($data->id) AND ($data->id)) {
            $filter = new TFilter('id', '=', "$data->id"); // create the filter
            TSession::setValue('VendasLista_filter_id',   $filter); // stores the filter in the session
        }
        if (isset($data->data_venda) AND ($data->data_venda)) {
            $filter = new TFilter('data_venda', '=', "$data->data_venda"); // create the filter
            TSession::setValue('VendasLista_filter_data_venda',   $filter); // stores the filter in the session
        }
        
        // fill the form with data again
        $this->form->setData($data);
        
        // keep the search data in the session
        TSession::setValue('Vendas_filter_data', $data);
        
        $param = array();
        $param['offset']    =0;
        $param['first_page']=1;
        $this->onReload($param);
    }
    
    /**
     * Load the datagrid with data
     */
    public function onReload($param = NULL)
    {
        try
        {
            // open a transaction with database 'estoque'
            TTransaction::open('estoque');
            
            // creates a repository for Vendas
            $repository = new TRepository('Vendas');
            $limit = 10;
            // creates a criteria
            $criteria = new TCriteria;
            
            // default order
            if (empty($param['order']))
            {
                $param['order'] = 'id';
                $param['direction'] = 'asc';
            }
            $criteria->setProperties($param); // order, offset
            $criteria->setProperty('limit', $limit);
            
            if (TSession::getValue('VendasLista_filter_id')) {
                $criteria->add(TSession::getValue('VendasLista_filter_id')); // add the session filter
            }
            if (TSession::getValue('VendasLista_filter_data_venda')) {
                $criteria->add(TSession::getValue('VendasLista_filter_data_venda')); // add the session filter
            }
            
            // load the objects according to criteria
            $objects = $repository->load($criteria, FALSE);
            
            if (is_callable($this->transformCallback))
            {
                call_user_func($this->transformCallback, $objects, $param);
            }
            
            $this->datagrid->clear();
            if ($objects)
            {
                // iterate the collection of active records
                foreach ($objects as $object)
                {
                    // add the object inside the datagrid
                    $this->datagrid->addItem($object);
                }
            }
            
            // reset the criteria for record count
            $criteria->resetProperties();
            $count= $repository->count($criteria);
            
            $this->pageNavigation->setCount($count); // count of records
            $this->pageNavigation->setProperties($param); // order, page
            $this->pageNavigation->setLimit($limit); // limit
            
            // close the transaction
            TTransaction::close();
            $this->loaded = true;
        }
        catch (Exception $e) // in case of exception
        {
            // shows the exception error message
            new TMessage('error', $e->getMessage());
            // undo all pending operations
            TTransaction::rollback();
        }
    }
    
    /**
     * Ask before deletion
     */
    public static function onDelete($param)
    {
        // define the delete action
        $action = new TAction([__CLASS__, 'Delete']);
        $action->setParameters($param); // pass the key parameter ahead
        
        // shows a dialog to the user
        new TQuestion(TAdiantiCoreTranslator::translate('Do you really want to delete ?'), $action);
    }
    
    /**
     * Delete a record
     */
    public static function Delete($param)
    {
        try
        {
            $key=$param['key']; // get the parameter $key
            TTransaction::open('estoque'); // open a transaction with database
            $object = new Vendas($key, FALSE); // instantiates the Active Record
            $object->delete(); // deletes the object from the database
            TTransaction::close(); // close the transaction
            
            $pos_action = new TAction([__CLASS__, 'onReload']);
            new TMessage('info', TAdiantiCoreTranslator::translate('Record deleted'), $pos_action); // success message
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage()); // shows the exception error message
            TTransaction::rollback(); // undo all pending operations
        }
    }
    
    
    /**
     * method show()
     * Shows the page
     */
    public function show()
    {
        // check if the datagrid is already loaded
        if (!$this->loaded AND (!isset($_GET['method']) OR !(in_array($_GET['method'],  array('onReload', 'onSearch')))) )
        {
            if (func_num_args() > 0)
            {
                $this->onReload( func_get_arg(0) );
            }
            else
            {
                $this->onReload();
            }
        }
        parent::show();
    }
}
</your>

Paulo Silva - AUTOR DO POST 02/05/2019 (há 6 anos)

Segue também o código do meu formulário de Edição da venda com seus itens:

 <?php
/**
 * VendasForm Master/Detail
 * @author  <your name here>
 */
class VendasForm extends TPage
{
    protected $form; // form
    protected $detail_list;
    
    /**
     * Page constructor
     */
    public function __construct()
    {
        parent::__construct();
        
        // creates the form
        $this->form = new BootstrapFormBuilder('form_Vendas');
        $this->form->setFormTitle('Vendas');
        
        // master fields
        $id = new TEntry('id');
        $data_venda = new TDate('data_venda');
        $qtde_itens = new TEntry('qtde_itens');
        $total_vendas = new TEntry('total_vendas');
        // detail fields
        $detail_id = new THidden('detail_id');
        $detail_produtos_id = new TDBUniqueSearch('detail_produtos_id', 'estoque', 'Produtos', 'id', 'nome');
        $detail_qtde = new TEntry('detail_qtde');
        $detail_total_item = new TEntry('detail_total_item');
        $detail_preco = new TEntry('detail_preco');
        if (!empty($id))
        {
            $id->setEditable(FALSE);
        }
        
        // master fields
        $this->form->addFields( [new TLabel('Id')], [$id] );
        $this->form->addFields( [new TLabel('Data Venda')], [$data_venda] );
        $this->form->addFields( [new TLabel('Qtde Itens')], [$qtde_itens] );
        $this->form->addFields( [new TLabel('Total Vendas')], [$total_vendas] );
        
        // detail fields
        $this->form->addContent( ['<h4>Details</h4><hr>'] );
        $this->form->addFields( [$detail_id] );
        
        $this->form->addFields( [new TLabel('Produtos Id')], [$detail_produtos_id] );
        $this->form->addFields( [new TLabel('Qtde')], [$detail_qtde] );
        $this->form->addFields( [new TLabel('Total Item')], [$detail_total_item] );
        $this->form->addFields( [new TLabel('Preco')], [$detail_preco] );
        $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('Vendas_list');
        
        // items
        $this->detail_list->addQuickColumn('Produtos Id', 'produtos_id', 'left', 100);
        $this->detail_list->addQuickColumn('Qtde', 'qtde', 'left', 100);
        $this->detail_list->addQuickColumn('Total Item', 'total_item', 'left', 100);
        $this->detail_list->addQuickColumn('Preco', 'preco', 'left', 100);
        // detail actions
        $this->detail_list->addQuickAction( 'Edit',   new TDataGridAction([$this, 'onEditDetail']),   'id', 'fa:edit blue');
        $this->detail_list->addQuickAction( 'Delete', new TDataGridAction([$this, 'onDeleteDetail']), 'id', '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: 90%';
        // $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        parent::add($container);
    }
    
    
    /**
     * 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('estoque');
            $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_id) ? 'X'.mt_rand(1000000000, 1999999999) : $data->detail_id;
            
            $items[ $key ] = array();
            $items[ $key ]['id'] = $key;
            $items[ $key ]['produtos_id'] = $data->detail_produtos_id;
            $items[ $key ]['qtde'] = $data->detail_qtde;
            $items[ $key ]['total_item'] = $data->detail_total_item;
            $items[ $key ]['preco'] = $data->detail_preco;
            
            TSession::setValue(__CLASS__.'_items', $items);
            
            // clear detail form fields
            $data->detail_id = '';
            $data->detail_produtos_id = '';
            $data->detail_qtde = '';
            $data->detail_total_item = '';
            $data->detail_preco = '';
            
            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());
        }
    }
    
    /**
     * 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_id = $item['id'];
        $data->detail_produtos_id = $item['produtos_id'];
        $data->detail_qtde = $item['qtde'];
        $data->detail_total_item = $item['total_item'];
        $data->detail_preco = $item['preco'];
        
        // fill detail fields
        TForm::sendData( 'form_Vendas', $data );
    }
    
    /**
     * Delete an item from session list
     * @param $param URL parameters
     */
    public static function onDeleteDetail( $param )
    {
        // reset items
        $data = new stdClass;
            $data->detail_produtos_id = '';
            $data->detail_qtde = '';
            $data->detail_total_item = '';
            $data->detail_preco = '';
        
        // clear form data
        TForm::sendData('form_Vendas', $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('Vendas_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['id'];
            }
        }
        
        $this->loaded = TRUE;
    }
    
    /**
     * Load Master/Detail data from database to form/session
     */
    public function onEdit($param)
    {
        try
        {
            TTransaction::open('estoque');
            
            if (isset($param['key']))
            {
                $key = $param['key'];
                
                $object = new Vendas($key);
                $items  = ItendVenda::where('vendas_id', '=', $key)->load();
                
                $session_items = array();
                foreach( $items as $item )
                {
                    $item_key = $item->id;
                    $session_items[$item_key] = $item->toArray();
                    $session_items[$item_key]['id'] = $item->id;
                    $session_items[$item_key]['produtos_id'] = $item->produtos_id;
                    $session_items[$item_key]['qtde'] = $item->qtde;
                    $session_items[$item_key]['total_item'] = $item->total_item;
                    $session_items[$item_key]['preco'] = $item->preco;
                }
                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('estoque');
            
            $data = $this->form->getData();
            $master = new Vendas;
            $master->fromArray( (array) $data);
            $this->form->validate(); // form validation
            
            $master->store(); // save master object
            // delete details
            $old_items = ItendVenda::where('vendas_id', '=', $master->id)->load();
            
            $keep_items = array();
            
            // get session items
            $items = TSession::getValue(__CLASS__.'_items');
            
            if( $items )
            {
                foreach( $items as $item )
                {
                    if (substr($item['id'],0,1) == 'X' ) // new record
                    {
                        $detail = new ItendVenda;
                    }
                    else
                    {
                        $detail = ItendVenda::find($item['id']);
                    }
                    $detail->produtos_id  = $item['produtos_id'];
                    $detail->qtde  = $item['qtde'];
                    $detail->total_item  = $item['total_item'];
                    $detail->preco  = $item['preco'];
                    $detail->vendas_id = $master->id;
                    $detail->store();
                    
                    $keep_items[] = $detail->id;
                }
            }
            
            if ($old_items)
            {
                foreach ($old_items as $old_item)
                {
                    if (!in_array( $old_item->id, $keep_items))
                    {
                        $old_item->delete();
                    }
                }
            }
            TTransaction::close(); // close the transaction
            
            // reload form and session items
            $this->onEdit(array('key'=>$master->id));
            
            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();
        }
    }
    
    /**
     * 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();
    }
}
</your>

Nataniel Rabaioli 03/05/2019 (há 6 anos)

Veja a função da minha primeira resposta. É isso que você precisa. Instanciar o objeto através do parâmetro "key" e depois chamar a PDFDesigner

Paulo Silva - AUTOR DO POST 03/05/2019 (há 6 anos)

Sim, mas eu preciso preencher os dados da nota com minhas informações de vendas. Como procedo então?

Nataniel Rabaioli 04/05/2019 (há 6 anos)

Para os itens da venda você provavelmente terá que criar uma âncora, conforme exemplo abaixo:
www.adianti.com.br/framework_files/tutor/index.php?class=PDFDesignNF

 <?php
$object = new SeuModel($param['key']);
$itens = $object->getItens();
$designer->gotoAnchorXY('details'); // posicionar no x e y da ancora
foreach ($itens as $item)
{
       $designer->gotoAnchorX('details'); // posicionar somente no x da ancora, pois o y sera modificado apos cada item
       
       $designer->Cell( 62, 10, $item->codigo, 1, 0, 'C');       
       $designer->Cell( 62, 10, $item->descricao, 1, 0, 'C');
       ...
       $designer->Ln(10);
}
?>

Paulo Silva - AUTOR DO POST 04/05/2019 (há 6 anos)

Nataniel, agradeço muito pelo apoio, mas poderia colocar essa chamada dentro do meu código, estou meio enrolado. Agradeço.

 <?php
/**
 * VendasLista Listing
 * @author  <your name here>
 */
class VendasLista extends TPage
{
    private $form; // form
    private $datagrid; // listing
    private $pageNavigation;
    private $formgrid;
    private $loaded;
    private $deleteButton;
    
    /**
     * Class constructor
     * Creates the page, the form and the listing
     */
    public function __construct()
    {
        parent::__construct();
        
        // creates the form
        $this->form = new BootstrapFormBuilder('form_Vendas');
        $this->form->setFormTitle('Vendas');
        
        // create the form fields
        $id = new TEntry('id');
        $data_venda = new TEntry('data_venda');
        // add the fields
        $this->form->addFields( [ new TLabel('Id') ], [ $id ] );
        $this->form->addFields( [ new TLabel('Data Venda') ], [ $data_venda ] );
        // set sizes
        $id->setSize('100%');
        $data_venda->setSize('100%');
        
        // keep the form filled during navigation with session data
        $this->form->setData( TSession::getValue('Vendas_filter_data') );
        
        // add the search form actions
        $btn = $this->form->addAction(_t('Find'), new TAction([$this, 'onSearch']), 'fa:search');
        $btn->class = 'btn btn-sm btn-primary';
        $this->form->addActionLink(_t('New'), new TAction(['VendasForm', 'onEdit']), 'fa:plus green');
        
        // creates a Datagrid
        $this->datagrid = new BootstrapDatagridWrapper(new TDataGrid);
        $this->datagrid->style = 'width: 100%';
        $this->datagrid->datatable = 'true';
        // $this->datagrid->enablePopover('Popover', 'Hi <b> Paulo Silva </b>');
        
        // creates the datagrid columns
        $column_id = new TDataGridColumn('id', 'Id', 'right');
        $column_data_venda = new TDataGridColumn('data_venda', 'Data Venda', 'left');
        $column_qtde_itens = new TDataGridColumn('qtde_itens', 'Qtde Itens', 'left');
        $column_total_vendas = new TDataGridColumn('total_vendas', 'Total Vendas', 'left');
        // add the columns to the DataGrid
        $this->datagrid->addColumn($column_id);
        $this->datagrid->addColumn($column_data_venda);
        $this->datagrid->addColumn($column_qtde_itens);
        $this->datagrid->addColumn($column_total_vendas);
        
        // create EDIT action
        $action_edit = new TDataGridAction(['VendasForm', 'onEdit']);
        //$action_edit->setUseButton(TRUE);
        //$action_edit->setButtonClass('btn btn-default');
        $action_edit->setLabel(_t('Edit'));
        $action_edit->setImage('fa:pencil-square-o blue fa-lg');
        $action_edit->setField('id');
        $this->datagrid->addAction($action_edit);
        
        // create DELETE action
        $action_del = new TDataGridAction(array($this, 'onDelete'));
        //$action_del->setUseButton(TRUE);
        //$action_del->setButtonClass('btn btn-default');
        $action_del->setLabel(_t('Delete'));
        $action_del->setImage('fa:trash-o red fa-lg');
        $action_del->setField('id');
        $this->datagrid->addAction($action_del);
        
        // create the datagrid model
        $this->datagrid->createModel();
        
        // creates the page navigation
        $this->pageNavigation = new TPageNavigation;
        $this->pageNavigation->setAction(new TAction([$this, 'onReload']));
        $this->pageNavigation->setWidth($this->datagrid->getWidth());
        
        // vertical box container
        $container = new TVBox;
        $container->style = 'width: 90%';
        // $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        $container->add(TPanelGroup::pack('', $this->datagrid, $this->pageNavigation));
        
        parent::add($container);
    }
    
    /**
     * Inline record editing
     * @param $param Array containing:
     *              key: object ID value
     *              field name: object attribute to be updated
     *              value: new attribute content 
     */
    public function onInlineEdit($param)
    {
        try
        {
            // get the parameter $key
            $field = $param['field'];
            $key   = $param['key'];
            $value = $param['value'];
            
            TTransaction::open('estoque'); // open a transaction with database
            $object = new Vendas($key); // instantiates the Active Record
            $object->{$field} = $value;
            $object->store(); // update the object in the database
            TTransaction::close(); // close the transaction
            
            $this->onReload($param); // reload the listing
            new TMessage('info', "Record Updated");
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage()); // shows the exception error message
            TTransaction::rollback(); // undo all pending operations
        }
    }
    
    /**
     * Register the filter in the session
     */
    public function onSearch()
    {
        // get the search form data
        $data = $this->form->getData();
        
        // clear session filters
        TSession::setValue('VendasLista_filter_id',   NULL);
        TSession::setValue('VendasLista_filter_data_venda',   NULL);
        if (isset($data->id) AND ($data->id)) {
            $filter = new TFilter('id', '=', "$data->id"); // create the filter
            TSession::setValue('VendasLista_filter_id',   $filter); // stores the filter in the session
        }
        if (isset($data->data_venda) AND ($data->data_venda)) {
            $filter = new TFilter('data_venda', '=', "$data->data_venda"); // create the filter
            TSession::setValue('VendasLista_filter_data_venda',   $filter); // stores the filter in the session
        }
        
        // fill the form with data again
        $this->form->setData($data);
        
        // keep the search data in the session
        TSession::setValue('Vendas_filter_data', $data);
        
        $param = array();
        $param['offset']    =0;
        $param['first_page']=1;
        $this->onReload($param);
    }
    
    /**
     * Load the datagrid with data
     */
    public function onReload($param = NULL)
    {
        try
        {
            // open a transaction with database 'estoque'
            TTransaction::open('estoque');
            
            // creates a repository for Vendas
            $repository = new TRepository('Vendas');
            $limit = 10;
            // creates a criteria
            $criteria = new TCriteria;
            
            // default order
            if (empty($param['order']))
            {
                $param['order'] = 'id';
                $param['direction'] = 'asc';
            }
            $criteria->setProperties($param); // order, offset
            $criteria->setProperty('limit', $limit);
            
            if (TSession::getValue('VendasLista_filter_id')) {
                $criteria->add(TSession::getValue('VendasLista_filter_id')); // add the session filter
            }
            if (TSession::getValue('VendasLista_filter_data_venda')) {
                $criteria->add(TSession::getValue('VendasLista_filter_data_venda')); // add the session filter
            }
            
            // load the objects according to criteria
            $objects = $repository->load($criteria, FALSE);
            
            if (is_callable($this->transformCallback))
            {
                call_user_func($this->transformCallback, $objects, $param);
            }
            
            $this->datagrid->clear();
            if ($objects)
            {
                // iterate the collection of active records
                foreach ($objects as $object)
                {
                    // add the object inside the datagrid
                    $this->datagrid->addItem($object);
                }
            }
            
            // reset the criteria for record count
            $criteria->resetProperties();
            $count= $repository->count($criteria);
            
            $this->pageNavigation->setCount($count); // count of records
            $this->pageNavigation->setProperties($param); // order, page
            $this->pageNavigation->setLimit($limit); // limit
            
            // close the transaction
            TTransaction::close();
            $this->loaded = true;
        }
        catch (Exception $e) // in case of exception
        {
            // shows the exception error message
            new TMessage('error', $e->getMessage());
            // undo all pending operations
            TTransaction::rollback();
        }
    }
    
    /**
     * Ask before deletion
     */
    public static function onDelete($param)
    {
        // define the delete action
        $action = new TAction([__CLASS__, 'Delete']);
        $action->setParameters($param); // pass the key parameter ahead
        
        // shows a dialog to the user
        new TQuestion(TAdiantiCoreTranslator::translate('Do you really want to delete ?'), $action);
    }
    
    /**
     * Delete a record
     */
    public static function Delete($param)
    {
        try
        {
            $key=$param['key']; // get the parameter $key
            TTransaction::open('estoque'); // open a transaction with database
            $object = new Vendas($key, FALSE); // instantiates the Active Record
            $object->delete(); // deletes the object from the database
            TTransaction::close(); // close the transaction
            
            $pos_action = new TAction([__CLASS__, 'onReload']);
            new TMessage('info', TAdiantiCoreTranslator::translate('Record deleted'), $pos_action); // success message
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage()); // shows the exception error message
            TTransaction::rollback(); // undo all pending operations
        }
    }
    
    
    /**
     * method show()
     * Shows the page
     */
    public function show()
    {
        // check if the datagrid is already loaded
        if (!$this->loaded AND (!isset($_GET['method']) OR !(in_array($_GET['method'],  array('onReload', 'onSearch')))) )
        {
            if (func_num_args() > 0)
            {
                $this->onReload( func_get_arg(0) );
            }
            else
            {
                $this->onReload();
            }
        }
        parent::show();
    }
}</your>

Nataniel Rabaioli 06/05/2019 (há 6 anos)

 <?php
// construct
// create PDF action
$action_pdf = new TDataGridAction(array($this, 'onPrintNota'));
...
$this->datagrid->addAction($action_edit);
...
// fim construct
public function onPrintNota($param)
{
         ...
         $object = new SeuModel($param['key']);
         ...
         $designer = new TPDFDesigner;
         $designer->fromXml('app/reports/nfe.pdf.xml');
         $designer->generate();
         ...
}
?>

Paulo Silva - AUTOR DO POST 09/05/2019 (há 6 anos)

Inseri os seguintes códigos, porém, sem sucesso. Pode verificar o que há de errado por gentileza.

// create EDIT action
//$action_edit = new TDataGridAction(['VendasForm', 'onEdit']);
$action_pdf = new TDataGridAction(array($this, 'onPrintNota'));
//$action_edit->setUseButton(TRUE);
//$action_edit->setButtonClass('btn btn-default');
$action_pdf->setLabel(_t('Edit'));
$action_pdf->setImage('fa:pencil-square-o blue fa-lg');
$action_pdf->setField('id');
$this->datagrid->addAction($action_pdf);

public function onPrintNota($param)
{
$object = new Vendas($param['id']);
$designer = new TPDFDesigner;
$designer->fromXml('app/reports/nfe.pdf.xml');
$designer->generate();
}

Paulo Silva - AUTOR DO POST 09/05/2019 (há 6 anos)

 <?php
// create EDIT action 
//$action_edit = new TDataGridAction(['VendasForm', 'onEdit']); 
$action_pdf = new TDataGridAction(array($this, 'onPrintNota')); 
//$action_edit->setUseButton(TRUE); 
//$action_edit->setButtonClass('btn btn-default'); 
$action_pdf->setLabel(_t('Edit')); 
$action_pdf->setImage('fa:pencil-square-o blue fa-lg'); 
$action_pdf->setField('id'); 
$this->datagrid->addAction($action_pdf); 
public function onPrintNota($param) 
{ 
$object = new Vendas($param['id']); 
$designer = new TPDFDesigner; 
$designer->fromXml('app/reports/nfe.pdf.xml'); 
$designer->generate(); 
} 
?>

Paulo Silva - AUTOR DO POST 09/05/2019 (há 6 anos)

Poderia criar um exemplo pra mim baseado em uma tabela com o Adianti Studio ?

Eu agradeço amigo.

Paulo Silva - AUTOR DO POST 10/05/2019 (há 6 anos)

Veja o código que digitei, consigo chamar o 'app/reports/nfe.pdf.xml', porém, como populo o ,xml com meus dados.

 <?php
        // create EDIT action
        //$action_edit = new TDataGridAction(['VendasForm', 'onEdit']);
        $action_pdf = new TDataGridAction(array($this, 'onPrintNota'));
        //$action_edit->setUseButton(TRUE);
        //$action_edit->setButtonClass('btn btn-default');
        $action_pdf->setLabel(_t('Edit'));
        $action_pdf->setImage('fa:pencil-square-o blue fa-lg');
        $action_pdf->setField('id');
        $this->datagrid->addAction($action_pdf);
......
    public function onPrintNota($param)
    {
            $object = new VendasLista($param['id']);             
            $designer = new TPDFDesigner;
            $designer->fromXml('app/reports/nfe.pdf.xml');
            $designer->generate();
            
            $designer->SetFont('Arial', 'B', 8);
            $designer->setFontColorRGB( '#4C4491' );
            $designer->writeAtAnchor('for_ie',        '23234234234');
            $designer->writeAtAnchor('for_cnpj',      '001.111.222.0001/00');
            $designer->writeAtAnchor('nome',          utf8_decode('Cliente demonstração da silva'));
            $designer->writeAtAnchor('endereco',      utf8_decode('Rua das demonstrações'));
            $designer->writeAtAnchor('bairro',        'Centro');
            $designer->writeAtAnchor('municipio',     'Cidade teste');
            
            
            $file = 'app/output/nfe.pdf';
            
            if (!file_exists($file) OR is_writable($file))
            {
                $designer->save($file);
                //parent::openFile($file);
                
                $window = TWindow::create(_t('Designed PDF NFE'), 0.8, 0.8);
                $object = new TElement('object');
                $object->data  = $file;
                $object->type  = 'application/pdf';
                $object->style = "width: 100%; height:calc(100% - 10px)";
                $window->add($object);
                $window->show();
            }
            else
            {
                throw new Exception(_t('Permission denied') . ': ' . $file);
            }
             
    }    
?>

Paulo Silva - AUTOR DO POST 15/05/2019 (há 6 anos)

Pessoal boa tarde a todos...
Alguém poderia me ajudar neste tópico por gentileza...

Preciso com urgência.

Desde já agradeço.

Paulo Silva - AUTOR DO POST 17/05/2019 (há 6 anos)

Nataniel, com esse código eu consegui carregar o PDF.

 <?php
// construct
// create PDF action
$action_pdf = new TDataGridAction(array($this, 'onPrintNota'));
...
$this->datagrid->addAction($action_edit);
...
// fim construct
public function onPrintNota($param)
{
         ...
         $object = new SeuModel($param['key']);
         ...
         $designer = new TPDFDesigner;
         $designer->fromXml('app/reports/nfe.pdf.xml');
         $designer->generate();
         ...
}
?>

Mas como preencho as ancoras com os dados do Banco de Dados ?

Nataniel Rabaioli 17/05/2019 (há 6 anos)

 <?php
...
$object = new SeuModel($param['key']);
...
$designer->writeAtAnchor('for_cnpj',    $object->nome_coluna);
?>

Paulo Silva - AUTOR DO POST 17/05/2019 (há 6 anos)

Amigo, fiz dessa forma mas o recibo esta vindo em branco, veja o que pode estar errado no meu código por gentileza.

 <?php
    public function onPrintRecibo()
    {            
            // open a transaction with database 
            TTransaction::open('pedido'); 
            
            // load all customers 
            $repository = new TRepository('Recibos'); 
            $criteria = new TCriteria; 
            $Recibos = $repository->load($criteria); 
            
            $data = $this->form->getData('Recibos'); 
            $this->form->validate();     
             
            $object = new RecibosList($param['key']);
            $designer = new TPDFDesigner;
            $designer->fromXml('app/reports/recibo.pdf.xml');
            $designer->generate();
            
            $designer->SetFont('Arial', 'B', 8);
            $designer->setFontColorRGB( '#4C4491' );
            $designer->writeAtAnchor('pagador',   $object->nome);
            $designer->writeAtAnchor('valorreal', $object->valor);
            $designer->writeAtAnchor('referente', $object->refere);                      
            
            $file = 'app/output/recibo.pdf';
            
            if (!file_exists($file) OR is_writable($file))
            {
                $designer->save($file);
                //parent::openFile($file);
                
                $window = TWindow::create(_t('Designed PDF RECIBO'), 0.8, 0.8);
                $object = new TElement('object');
                $object->data  = $file;
                $object->type  = 'application/pdf';
                $object->style = "width: 100%; height:calc(100% - 10px)";
                $window->add($object);
                $window->show();
            }
            else
            {
                throw new Exception(_t('Permission denied') . ': ' . $file);
            }
            TTransaction::close();
             
    } //fim do onPrintNota   
?>

Paulo Silva - AUTOR DO POST 17/05/2019 (há 6 anos)

Veja o código da chamada...

 <?php
        //CRIA AÇÃO DE IMPRESSÃO
        $action_pdf = new TDataGridAction(array($this, 'onPrintRecibo'));
        //$action_pdf->setUseButton(TRUE);
        //$action_pdf->setButtonClass('btn btn-default');
        $action_pdf->setLabel(_t('Edit'));
        $action_pdf->setImage('fa:pencil-square-o blue fa-lg');
        $action_pdf->setField('id');
        $this->datagrid->addAction($action_pdf);
?>

Nataniel Rabaioli 20/05/2019 (há 6 anos)

Você está instanciando a list invés do model:

 <?php
//$object = new RecibosList($param['key']);
$object = new Recibos($param['key']);
?>

Novo Comentário