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á 5 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 completo Meu Negócio Pronto

Use para si, ou transforme em um negócio: Inclui aulas e códigos-fontes
Gestor de conteúdo (SITE) + Loja Virtual (E-Commerce) + Emissor de Notas para infoprodutos

Meu negócio pronto Quero me inscrever agora!

Comentários (18)

Nataniel Rabaioli 29/04/2019 (há 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 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á 4 anos)

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

Paulo Silva - AUTOR DO POST 17/05/2019 (há 4 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á 4 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á 4 anos)

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

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

Novo Comentário