Dúvida sobre TDBSeekButton

Dúvida sobre TDBSeekButton Pessoal, me deparei com uma situação que não estou conseguindo uma solução: Neste TDBSeekButton coloquei o campo "description_codprod" (concatenação de codigo+description) que na verdade é um get na minha model Product , funciona perfeitamente até eu fazer uma pesquisa, aí recebo a mensagem que o campo não existe. Como posso resolver ? já tentei usar TCriteria mais não tive sucesso...

Fechado

Adriano Raposo 04/08/2016 (há 7 anos)

Pessoal, me deparei com uma situação que não estou conseguindo uma solução:
Neste TDBSeekButton coloquei o campo "description_codprod" (concatenação de codigo+description) que na verdade é um get na minha model Product , funciona perfeitamente até eu fazer uma pesquisa, aí recebo a mensagem que o campo não existe. Como posso resolver ? já tentei usar TCriteria mais não tive sucesso.
Grato.

<?php $product_id = new ">TDBSeekButton('product_id', 'catalogo', $this->form->getName(), 'Product', 'description_codprod', 'product_id', 'product_name',$criteria);?>

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 (5)

Nataniel Rabaioli 04/08/2016 (há 7 anos)

Acredito que você tenha que criar uma seek manual. A TDBSeekButton usa o mesmo parâmetro para exibição e busca...

Adriano Raposo - AUTOR DO POST 05/08/2016 (há 7 anos)

Grato Nataniel. Vou tentar

Adriano Raposo - AUTOR DO POST 05/08/2016 (há 7 anos)

Ficou perfeito Nataniel, muito grato.

Emanoel Evaristo 05/08/2016 (há 7 anos)

Adriano, também tenho a mesma dificuldade. Poderia postar sua solução?
Obrigado.

Adriano Raposo - AUTOR DO POST 06/08/2016 (há 7 anos)

Olá Emanoel, vamos lá:
Vou tentar explicar, sou iniciante em PHP .

No primeiro bloco é o meu form, onde instancio ProductSeek que uso para pesquisa pelo o ID e ProductSeekCodigo para pesquisa pelo codigo, esse criado em minha tabela/model (Product como index unique) e consequentemente em SaleItem .

Então, no meu form SaleForm, posso chamar o produto tanto pelo o ID quanto pelo codigo, em campos distintos. Ficou legal. Se a sua dúvida persistir, estou a disposição.

Tudo exemplificado no Tutor:
//-------------------------------------
//Sale form (Master/detail)
www.adianti.com.br/framework_files/tutor/index.php?class=SaleForm&am
//-------------------------------------
//Seek manual
www.adianti.com.br/framework_files/tutor/index.php?class=FormSeekBut

//bl 1

<?php
//SaleForm
$product_id = new TSeekButton('product_id');
$product_name = new TEntry('product_name');
$codigo = new TSeekButton('product_codigo');
// define the action for city_id1
$obj = new ProductSeek;
$action = new TAction(array($obj, 'onReload'));
$product_id->setAction($action);
//preciso mexer
$obj2 = new ProductSeekCodigo;
$action2 = new TAction(array($obj2, 'onReload'));
$codigo->setAction($action2);
//--------------------------------------
$subtable_product->addRowSet( $label_product = new TLabel('Produto (*)'), array($product_id,$product_name) );
$subtable_product->addRowSet( $label_codigo = new TLabel('Codigo (*)'), array($codigo));
?>

//bl2

<?php
/**
* Product Seek
*
* @version 1.0
* @package samples
* @subpackage tutor
* @author Pablo Dall'Oglio
* @copyright Copyright (c) 2006-2014 Adianti Solutions Ltd. (http://www.adianti.com.br)
* @license http://www.adianti.com.br/framework-license
*/
class ProductSeekCodigo extends TWindow
{
private $form; // form
private $datagrid; // datagrid
private $pageNavigation;
private $loaded;
/**
* Class constructor
* Creates the page, the search form and the listing
*/
public function __construct()
{
parent::__construct();
parent::setSize(700, 500);
parent::setTitle('Search record');
new TSession;
// creates the form
$this->form = new TQuickForm('form_search_product');
$this->form->class = 'tform';
$this->form->setFormTitle('Produtos');
// create the form fields
$codigo = new TEntry('codigo');
$codigo->setValue(TSession::getValue('product_codigo'));
$description = new TEntry('description');
$description->setValue(TSession::getValue('product_name'));
// add the form fields
$this->form->addQuickField('Código', $codigo, 60);
$this->form->addQuickField('Descrição', $description, 200);
// define the form action
$this->form->addQuickAction('Find', new TAction(array($this, 'onSearch')), 'ico_find.png');
// creates a DataGrid
$this->datagrid = new TQuickGrid;
$this->datagrid->style = 'width: 100%';
$this->datagrid->setHeight(230);
$this->datagrid->enablePopover('Title', 'Descrição {description}');
// creates the datagrid columns
$this->datagrid->addQuickColumn('Id', 'id', 'right', 40);
$this->datagrid->addQuickColumn('Código', 'codigo', 'right', 40);
$this->datagrid->addQuickColumn('Descrição', 'description', 'left', 340);
// creates two datagrid actions
$this->datagrid->addQuickAction('Select', new TDataGridAction(array($this, 'onSelect')), 'codigo', 'ico_apply.png');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation;
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates a container
$container = new TVBox;
$container->style = 'width: 100%';
$container->add($this->form);
$container->add($this->datagrid);
$container->add($this->pageNavigation);
// add the container inside the page
parent::add($container);
}
/**
* method onSearch()
* Register the filter in the session when the user performs a search
*/
function onSearch()
{
// get the search form data
$data = $this->form->getData();
// TSession::setValue('product_name', NULL);
// TSession::setValue('product_codigo', NULL);
TSession::setValue('product_filter', NULL);
// check if the user has filled the form
if (isset($data->description) and ($data->description))
{
// creates a filter using what the user has typed
$filter = new TFilter('description', 'like', "%{$data->description}%");
// stores the filter in the session
TSession::setValue('product_filter', $filter);
TSession::setValue('product_name', $data->description);
// fill the form with data again
$this->form->setData($data);
}
// if (isset($data->codigo) and $data->codigo)
if ($data->codigo)
{
// creates a filter using what the user has typed
$filter = new TFilter('codigo', '=', "{$data->codigo}");
// stores the filter in the session
TSession::setValue('product_filter', $filter);
TSession::setValue('product_codigo', $data->codigo);
// fill the form with data again
$this->form->setData($data);
}
// redefine the parameters for reload method
$param=array();
$param['offset'] =0;
$param['first_page']=1;
$this->onReload($param);
}
/**
* Load the datagrid with the database objects
*/
function onReload($param = NULL)
{
try
{
// open a transaction with database 'samples'
TTransaction::open('catalogo');
// creates a repository for Product
$repository = new TRepository('Product');
$limit = 10;
// creates a criteria
$criteria = new TCriteria;
// default order
if (!isset($param['order']))
{
$param['order'] = 'id';
$param['direction'] = 'asc';
}
$criteria->setProperties($param); // order, offset
$criteria->setProperty('limit', $limit);
if (TSession::getValue('product_filter'))
{
// add the filter stored in the session to the criteria
$criteria->add(TSession::getValue('product_filter'));
}
// TTransaction::setLogger(new TLoggerSTD); // standard output
// TTransaction::setLogger(new TLoggerTXT('log.txt')); // file
// load the objects according to the criteria
$products = $repository->load($criteria);
$this->datagrid->clear();
if ($products)
{
foreach ($products as $product)
{
// add the object inside the datagrid
$this->datagrid->addItem($product);
}
}
// 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();
}
}
/**
* Executed when the user chooses the record
*/
public function onSelect($param)
{
try
{
$key = $param['key'];
TTransaction::open('catalogo');
// load the active record
// creates a repository for Product
$repository = new TRepository('Product');
$limit = 10;
// creates a criteria
$criteria = new TCriteria;
$criteria->setProperties($param); // order, offset
$criteria->setProperty('limit', $limit);
$filter = new TFilter('codigo', '=', $key);
TSession::setValue('product_filter', $filter);
// add the filter stored in the session to the criteria
$criteria->add(TSession::getValue('product_filter'));
// TTransaction::setLogger(new TLoggerSTD); // standard output
// TTransaction::setLogger(new TLoggerTXT('log.txt')); // file
// load the objects according to the criteria
$products = $repository->load($criteria);
//$product = new Product($key);
foreach ($products as $product)
{
$product = new Product($product->id);
}
// closes the transaction
TTransaction::close();
$object = new StdClass;
$object->product_id = $product->id;
$object->product_name = $product->description;
$object->product_codigo = $product->codigo;
$object->product_price = $product->sale_price;
TForm::sendData('form_Sale', $object);
parent::closeWindow(); // closes the window
}
catch (Exception $e) // em caso de exceção
{
// clear fields
$object = new StdClass;
$object->product_id = '';
$object->product_name = '';
$object->product_codigo = '';
$object->product_price ='';
TForm::sendData('form_Sale', $object);
// undo pending operations
TTransaction::rollback();
}
}
/**
* Shows the page
*/
function show()
{
// if the datagrid was not loaded yet
if (!$this->loaded)
{
$this->onReload();
}
parent::show();
}
}
?>

//bl3

<?php
/**
* Product Seek
*
* @version 1.0
* @package samples
* @subpackage tutor
* @author Pablo Dall'Oglio
* @copyright Copyright (c) 2006-2014 Adianti Solutions Ltd. (http://www.adianti.com.br)
* @license http://www.adianti.com.br/framework-license
*/
class ProductSeek extends TWindow
{
private $form; // form
private $datagrid; // datagrid
private $pageNavigation;
private $loaded;
/**
* Class constructor
* Creates the page, the search form and the listing
*/
public function __construct()
{
parent::__construct();
parent::setSize(700, 500);
parent::setTitle('Search record');
new TSession;
// creates the form
$this->form = new TQuickForm('form_search_product');
$this->form->class = 'tform';
$this->form->setFormTitle('Produtos');
// create the form fields
$codigo = new TEntry('codigo');
$codigo->setValue(TSession::getValue('product_codigo'));
$description = new TEntry('description');
$description->setValue(TSession::getValue('product_name'));
// add the form fields
$this->form->addQuickField('Código', $codigo, 60);
$this->form->addQuickField('Descrição', $description, 200);
// define the form action
$this->form->addQuickAction('Find', new TAction(array($this, 'onSearch')), 'ico_find.png');
// creates a DataGrid
$this->datagrid = new TQuickGrid;
$this->datagrid->style = 'width: 100%';
$this->datagrid->setHeight(230);
$this->datagrid->enablePopover('Title', 'Descrição {description}');
// creates the datagrid columns
$this->datagrid->addQuickColumn('Id', 'id', 'right', 40);
$this->datagrid->addQuickColumn('Código', 'codigo', 'right', 40);
$this->datagrid->addQuickColumn('Descrição', 'description', 'left', 340);
// creates two datagrid actions
$this->datagrid->addQuickAction('Select', new TDataGridAction(array($this, 'onSelect')), 'id', 'ico_apply.png');
// create the datagrid model
$this->datagrid->createModel();
// creates the page navigation
$this->pageNavigation = new TPageNavigation;
$this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
// creates a container
$container = new TVBox;
$container->style = 'width: 100%';
$container->add($this->form);
$container->add($this->datagrid);
$container->add($this->pageNavigation);
// add the container inside the page
parent::add($container);
}
/**
* method onSearch()
* Register the filter in the session when the user performs a search
*/
function onSearch()
{
// get the search form data
$data = $this->form->getData();
// TSession::setValue('product_name', NULL);
// TSession::setValue('product_codigo', NULL);
TSession::setValue('product_filter', NULL);
// check if the user has filled the form
if (isset($data->description) and ($data->description))
{
// creates a filter using what the user has typed
$filter = new TFilter('description', 'like', "%{$data->description}%");
// stores the filter in the session
TSession::setValue('product_filter', $filter);
TSession::setValue('product_name', $data->description);
// fill the form with data again
$this->form->setData($data);
}
// if (isset($data->codigo) and $data->codigo)
if ($data->codigo)
{
// creates a filter using what the user has typed
$filter = new TFilter('codigo', '=', "{$data->codigo}");
// stores the filter in the session
TSession::setValue('product_filter', $filter);
TSession::setValue('product_codigo', $data->codigo);
// fill the form with data again
$this->form->setData($data);
}
// redefine the parameters for reload method
$param=array();
$param['offset'] =0;
$param['first_page']=1;
$this->onReload($param);
}
/**
* Load the datagrid with the database objects
*/
function onReload($param = NULL)
{
try
{
// open a transaction with database 'samples'
TTransaction::open('catalogo');
// creates a repository for Product
$repository = new TRepository('Product');
$limit = 10;
// creates a criteria
$criteria = new TCriteria;
// default order
if (!isset($param['order']))
{
$param['order'] = 'id';
$param['direction'] = 'asc';
}
$criteria->setProperties($param); // order, offset
$criteria->setProperty('limit', $limit);
if (TSession::getValue('product_filter'))
{
// add the filter stored in the session to the criteria
$criteria->add(TSession::getValue('product_filter'));
}
TTransaction::setLogger(new TLoggerSTD); // standard output
TTransaction::setLogger(new TLoggerTXT('log.txt')); // file
// load the objects according to the criteria
$products = $repository->load($criteria);
$this->datagrid->clear();
if ($products)
{
foreach ($products as $product)
{
// add the object inside the datagrid
$this->datagrid->addItem($product);
}
}
// 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();
}
}
/**
* Executed when the user chooses the record
*/
public function onSelect($param)
{
try
{
$key = $param['key'];
TTransaction::open('catalogo');
// load the active record
$product = new Product($key);
// closes the transaction
TTransaction::close();
$object = new StdClass;
$object->product_id = $product->id;
$object->product_name = $product->description;
$object->product_codigo = $product->codigo;
$object->product_price = $product->sale_price;
TForm::sendData('form_Sale', $object);
parent::closeWindow(); // closes the window
}
catch (Exception $e) // em caso de exceção
{
// clear fields
$object = new StdClass;
$object->product_id = '';
$object->product_name = '';
$object->product_codigo = '';
$object->product_price ='';
TForm::sendData('form_Sale', $object);
// undo pending operations
TTransaction::rollback();
}
}
/**
* Shows the page
*/
function show()
{
// if the datagrid was not loaded yet
if (!$this->loaded)
{
$this->onReload();
}
parent::show();
}
}
?>