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

Nataniel Rabaioli 04/08/2016 (há 9 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á 9 anos)

Grato Nataniel. Vou tentar

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

Ficou perfeito Nataniel, muito grato.

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

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

Adriano Raposo - AUTOR DO POST 06/08/2016 (há 9 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();
    }
}
?>