Inserir mais de dois campos na janela do TSeekButton

Inserir mais de dois campos na janela do TSeekButton Olá pessoal, boa tarde, estou com dúvidas referente a janela do TSeekButton, onde apenas mostra dois campos "ID" e "Campo" no datagrid, gostaria de saber se tem a possibilidade de inserir mais de dois campos no datagrid e inserir um titulo para cada coluna. Agraço pelas respostas. Segue um print de exemplo. ...

Fechado

Felipe Vicente 10/12/2015 (há 9 anos)

Olá pessoal, boa tarde, estou com dúvidas referente a janela do TSeekButton, onde apenas mostra dois campos "ID" e "Campo" no datagrid, gostaria de saber se tem a possibilidade de inserir mais de dois campos no datagrid e inserir um titulo para cada coluna.

Agraço pelas respostas.
Segue um print de exemplo.

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

Eduardo Soares 11/12/2015 (há 9 anos)

Rapaz, fiz uma gambiarra aqui e está funcionando. Quero melhorar este código talvez com uma array com os campos adicionais, mas ainda não consegui fazer isso. Segue os arquivos modificados que devem ficar na pasta applibwidget

TDBSeekButton2.php

 <?php
//namespace Adianti\Widget\Wrapper;
use Adianti\Core\AdiantiCoreTranslator;
use Adianti\Database\TCriteria;
use Adianti\Control\TAction;
//use Exception;
/**
 * Abstract Record Lookup Widget: Creates a lookup field used to search values from associated entities
 *
 * @version    2.0
 * @package    widget
 * @subpackage wrapper
 * @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 TDBSeekButton2 extends TSeekButton2
{
    /**
     * Class Constructor
     * @param  $name name of the form field
     * @param  $database name of the database connection
     * @param  $form name of the parent form
     * @param  $model name of the Active Record to be searched
     * @param  $display_field name of the field to be searched and shown
     * @param  $receive_key name of the form field to receive the primary key
     * @param  $receive_display_field name of the form field to receive the "display field"
     * @param  $display_field2 name of the #2 field to be searched and shown
     */
    public function __construct($name, $database, $form, $model, $display_field, $receive_key, $receive_display_field, TCriteria $criteria = NULL, $display_field2=NULL)
    {
        parent::__construct($name);
        
        if (empty($database))
        {
            throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'database', __CLASS__));
        }
        
        if (empty($model))
        {
            throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'model', __CLASS__));
        }
        
        if (empty($display_field))
        {
            throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'display_field', __CLASS__));
        }
        
        $obj = new TStandardSeek2;
        
        // define the action parameters
        $action = new TAction(array($obj, 'onSetup'));
        $action->setParameter('database',      $database);
        $action->setParameter('parent',        $form);
        $action->setParameter('model',         $model);
        $action->setParameter('display_field', $display_field);
        $action->setParameter('receive_key',   $receive_key);
        $action->setParameter('receive_field', $receive_display_field);
        $action->setParameter('criteria',      base64_encode(serialize($criteria)));
        $action->setParameter('display_field2', $display_field2);
        parent::setAction($action);
    }
}
?>

TSeekButton2.php

 <?php
//namespace Adianti\Widget\Form;
use Adianti\Widget\Form\AdiantiWidgetInterface;
use Adianti\Control\TAction;
use Adianti\Widget\Base\TElement;
use Adianti\Widget\Base\TScript;
use Adianti\Widget\Form\TForm;
use Adianti\Widget\Form\TField;
use Adianti\Widget\Form\TEntry;
use Adianti\Widget\Util\TImage;
use Adianti\Core\AdiantiCoreTranslator;
//use Exception;
//use ReflectionClass;
/**
 * Record Lookup Widget: Creates a lookup field used to search values from associated entities
 *
 * @version    2.0
 * @package    widget
 * @subpackage form
 * @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 TSeekButton2 extends TEntry implements AdiantiWidgetInterface
{
    private $action;
    private $auxiliar;
    private $useOutEvent;
    private $button;
    protected $formName;
    protected $name;
    
    /**
     * Class Constructor
     * @param  $name name of the field
     */
    public function __construct($name)
    {
        parent::__construct($name);
        $this->useOutEvent = TRUE;
        $this->setProperty('class', 'tfield tseekentry', TRUE);   // classe CSS
        $image = new TImage('lib/adianti/images/ico_find.png');
        
        $this->button = new TElement('button');
        $this->button->{'class'} = 'btn btn-default tseekbutton';
        $this->button->{'type'} = 'button';
        $this->button->{'onmouseover'} = 'style.cursor = \'pointer\'';
        $this->button->{'name'} = '_' . $this->name . '_link';
        $this->button->{'onmouseout'}  = 'style.cursor = \'default\'';
        $this->button->add($image);
    }
    
    /**
     * Returns a property value
     * @param $name     Property Name
     */
    public function __get($name)
    {
        if ($name == 'button')
        {
            return $this->button;
        }
        else
        {
            return parent::__get($name);
        }
    }
    
    /**
     * Define it the out event will be fired
     */
    public function setUseOutEvent($bool)
    {
        $this->useOutEvent = $bool;
    }
    
    /**
     * Define the action for the SeekButton
     * @param $action Action taken when the user
     * clicks over the Seek Button (A TAction object)
     */
    public function setAction(TAction $action)
    {
        $this->action = $action;
    }
    
    /**
     * Define an auxiliar field
     * @param $object any TField object
     */
    public function setAuxiliar(TField $object)
    {
        $this->auxiliar = $object;
    }
    
    /**
     * Enable the field
     * @param $form_name Form name
     * @param $field Field name
     */
    public static function enableField($form_name, $field)
    {
        TScript::create( " tseekbutton_enable_field('{$form_name}', '{$field}'); " );
    }
    
    /**
     * Disable the field
     * @param $form_name Form name
     * @param $field Field name
     */
    public static function disableField($form_name, $field)
    {
        TScript::create( " tseekbutton_disable_field('{$form_name}', '{$field}'); " );
    }
    
    /**
     * Show the widget
     */
    public function show()
    {
        // check if it's not editable
        if (parent::getEditable())
        {
            if (!TForm::getFormByName($this->formName) instanceof TForm)
            {
                throw new Exception(AdiantiCoreTranslator::translate('You must pass the ^1 (^2) as a parameter to ^3', __CLASS__, $this->name, 'TForm::setFields()') );
            }
            
            $serialized_action = '';
            if ($this->action)
            {
                // get the action class name
                if (is_array($callback = $this->action->getAction()))
                {
                    if (is_object($callback[0]))
                    {
                        $rc = new ReflectionClass($callback[0]);
                        $classname = $rc->getShortName();
                    }
                    else
                    {
                        $classname  = $callback[0];
                    }
                    $inst       = new $classname;
                    $ajaxAction = new TAction(array($inst, 'onSelect'));
                    
                    if (in_array($classname, array('TStandardSeek2')))
                    {
                        $ajaxAction->setParameter('parent',  $this->action->getParameter('parent'));
                        $ajaxAction->setParameter('database',$this->action->getParameter('database'));
                        $ajaxAction->setParameter('model',   $this->action->getParameter('model'));
                        $ajaxAction->setParameter('display_field', $this->action->getParameter('display_field'));
                        $ajaxAction->setParameter('receive_key',   $this->action->getParameter('receive_key'));
                        $ajaxAction->setParameter('receive_field', $this->action->getParameter('receive_field'));
                        $ajaxAction->setParameter('criteria',      $this->action->getParameter('criteria'));
                        $ajaxAction->setParameter('display_field2', $this->action->getParameter('display_field2'));
                    }
                    else
                    {
                        if($actionParameters = $this->action->getParameters())
                        {
                            foreach ($actionParameters as $key => $value) 
                            {
                                $ajaxAction->setParameter($key, $value);
                            }                            
                        }                                            
                    }
                    $ajaxAction->setParameter('form_name', $this->formName);
                    $string_action = $ajaxAction->serialize(FALSE);
                    if ($this->useOutEvent)
                    {
                        $this->setProperty('seekaction', "__adianti_post_lookup('{$this->formName}', '{$string_action}', document.{$this->formName}.{$this->name})");
                        $this->setProperty('onBlur', $this->getProperty('seekaction'), FALSE);
                    }
                }
                $this->action->setParameter('form_name', $this->formName);
                $serialized_action = $this->action->serialize(FALSE);
            }
            parent::show();
            
            $this->button-> onclick = "javascript:serialform=(\$('#{$this->formName}').serialize());
                  __adianti_append_page('engine.php?{$serialized_action}&'+serialform)";
            
            $this->button->show();
            
            if ($this->auxiliar)
            {
                echo '&nbsp;';
                $this->auxiliar->show();
            }
        }
        else
        {
            parent::show();
        }
    }
}
?>

TStandardSeek2.php

 <?php
//namespace Adianti\Base;
use Adianti\Core\AdiantiCoreTranslator;
use Adianti\Widget\Dialog\TMessage;
use Adianti\Widget\Container\TTable;
use Adianti\Widget\Container\TVBox;
use Adianti\Widget\Form\TForm;
use Adianti\Widget\Form\TEntry;
use Adianti\Widget\Form\TLabel;
use Adianti\Widget\Form\TButton;
use Adianti\Widget\Datagrid\TDataGrid;
use Adianti\Widget\Datagrid\TDataGridColumn;
use Adianti\Widget\Datagrid\TDataGridAction;
use Adianti\Widget\Datagrid\TPageNavigation;
use Adianti\Control\TWindow;
use Adianti\Control\TAction;
use Adianti\Database\TTransaction;
use Adianti\Database\TRepository;
use Adianti\Database\TRecord;
use Adianti\Database\TFilter;
use Adianti\Database\TCriteria;
use Adianti\Registry\TSession;
use Adianti\Widget\Container\TPanelGroup;
//use Exception;
//use StdClass;
/**
 * Standard Page controller for Seek buttons
 *
 * @version    2.0
 * @package    base
 * @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 TStandardSeek2 extends TWindow
{
    private $form;      // search form
    private $datagrid;  // listing
    private $pageNavigation;
    private $parentForm;
    private $loaded;
    
    /**
     * Constructor Method
     * Creates the page, the search form and the listing
     */
    public function __construct()
    {
        parent::__construct();
        parent::setTitle( AdiantiCoreTranslator::translate('Search record') );
        parent::setSize(0.7, 640);
        
        // creates a new form
        $this->form = new TForm('form_standard_seek');
        // creates a new table
        $table = new TTable;
        $table->{'width'} = '100%';
        // adds the table into the form
        $this->form->add($table);
        
        // create the form fields
        $display_field= new TEntry('display_field');
        $display_field->setSize('90%');
        
        // keeps the field's value
        $display_field->setValue(TSession::getValue('tstandardseek_display_value') );
        
        // create the action button
        $find_button = new TButton('busca');
        // define the button action
        $find_button->setAction(new TAction(array($this, 'onSearch')), AdiantiCoreTranslator::translate('Search'));
        $find_button->setImage('fa:search blue');
        
        // add a row for the filter field
        $table->addRowSet( new TLabel(_t('Search').': '), $display_field, $find_button);
        
        // define wich are the form fields
        $this->form->setFields(array($display_field, $find_button));
        
        // creates a new datagrid
        $this->datagrid = new TDataGrid;
        $this->datagrid->{'style'} = 'width: 100%';
        
        // create two datagrid columns
        $id      = new TDataGridColumn('id',            'ID',    'right', '16%');
        $display = new TDataGridColumn('display_field', AdiantiCoreTranslator::translate('Field'), 'left');
        $display2 = new TDataGridColumn('display_field2', AdiantiCoreTranslator::translate('Field'), 'left');
        
        // add the columns to the datagrid
        $this->datagrid->addColumn($id);
        $this->datagrid->addColumn($display);
        $this->datagrid->addColumn($display2);
        
        // create a datagrid action
        $action1 = new TDataGridAction(array($this, 'onSelect'));
        $action1->setLabel(AdiantiCoreTranslator::translate('Select'));
        $action1->setImage('fa:check-circle-o green');
        $action1->setUseButton(TRUE);
        $action1->setField('id');
        
        // add the actions to the datagrid
        $this->datagrid->addAction($action1);
        
        // create the datagrid model
        $this->datagrid->createModel();
        
        // creates the paginator
        $this->pageNavigation = new TPageNavigation;
        $this->pageNavigation->setAction(new TAction(array($this, 'onReload')));
        $this->pageNavigation->setWidth($this->datagrid->getWidth());
        
        $panel = new TPanelGroup();
        $panel->add($this->form);
        
        // creates the container
        $vbox = new TVBox;
        $vbox->add($panel);
        $vbox->add($this->datagrid);
        $vbox->add($this->pageNavigation);
        $vbox->{'style'} = 'width: 100%';
        
        // add the container to the page
        parent::add($vbox);
    }
    
    /**
     * Register the user filter in the section
     */
    public function onSearch()
    {
        // get the form data
        $data = $this->form->getData();
        
        // check if the user has filled the form
        if (isset($data-> display_field) AND ($data-> display_field))
        {
            // creates a filter using the form content
            $display_field = TSession::getValue('standard_seek_display_field');
            $filter = new TFilter($display_field, 'like', "%{$data-> display_field}%");
            
            // store the filter in section
            TSession::setValue('tstandardseek_filter',        $filter);
            TSession::setValue('tstandardseek_display_value', $data-> display_field);
        }
        else
        {
            TSession::setValue('tstandardseek_filter',        NULL);
            TSession::setValue('tstandardseek_display_value', '');
        }
        
        TSession::setValue('tstandardseek_filter_data', $data);
        
        // set the data back to the form
        $this->form->setData($data);
        
        $param=array();
        $param['offset']    =0;
        $param['first_page']=1;
        $this->onReload($param);
    }
    
    /**
     * Load the datagrid with the active record objects
     */
    public function onReload($param = NULL)
    {
        try
        {
            $model    = TSession::getValue('standard_seek_model');
            $database = TSession::getValue('standard_seek_database');
            
            $pk   = constant("{$model}::PRIMARYKEY");
            
            // begins the transaction with database
            TTransaction::open($database);
            
            // creates a repository for the model
            $repository = new TRepository($model);
            $limit = 10;
            
            // creates a criteria
            if (TSession::getValue('standard_seek_criteria'))
            {
                $criteria = clone TSession::getValue('standard_seek_criteria');
            }
            else
            {
                $criteria = new TCriteria;
                
                // default order
                if (empty($param['order']))
                {
                    $param['order'] = $pk;
                    $param['direction'] = 'asc';
                }
            }
            $criteria->setProperties($param); // order, offset
            $criteria->setProperty('limit', $limit);
            
            if (TSession::getValue('tstandardseek_filter'))
            {
                // add the filter to the criteria
                $criteria->add(TSession::getValue('tstandardseek_filter'));
            }
            
            // load all objects according with the criteria
            $objects = $repository->load($criteria, FALSE);
            $this->datagrid->clear();
            if ($objects)
            {
                $display_field = TSession::getValue('standard_seek_display_field');
                $display_field2 = TSession::getValue('standard_seek_display_field2');
                foreach ($objects as $object)
                {
                    
                    $item = $object;
                    $item-> id = $object->$pk;
                    $item-> display_field = $object->$display_field;
                    // @todo testar
                    $item-> display_field2 = $object->$display_field2;
                    // add the object into the datagrid
                    $this->datagrid->addItem($item);
                }
            }
            
            // clear the crieteria to count the records
            $criteria->resetProperties();
            $count= $repository->count($criteria);
            
            $this->pageNavigation->setCount($count); // count of records
            $this->pageNavigation->setProperties($param); // order, page
            $this->pageNavigation->setLimit($limit); // limit
            
            // closes the transaction
            TTransaction::close();
            $this->loaded = true;
        }
        catch (Exception $e) // in case of exception
        {
            // shows the exception genearated message
            new TMessage('error', '<b>Erro</b> ' . $e->getMessage());
            // rollback all the database operations 
            TTransaction::rollback();
        }
    }
    
    /**
     * define the standars seek parameters
     */
    public function onSetup($param=NULL)
    {
        // store the parameters in the section
        TSession::setValue('tstandardseek_filter', NULL);
        TSession::setValue('tstandardseek_display_value', NULL);
        TSession::setValue('standard_seek_receive_key',   $param['receive_key']);
        TSession::setValue('standard_seek_receive_field', $param['receive_field']);
        TSession::setValue('standard_seek_display_field', $param['display_field']);
        TSession::setValue('standard_seek_display_field2', $param['display_field2']);
        TSession::setValue('standard_seek_model',         $param['model']);
        TSession::setValue('standard_seek_database',      $param['database']);
        TSession::setValue('standard_seek_parent',        $param['parent']);
        if (isset($param['criteria']) AND $param['criteria'])
        {
            TSession::setValue('standard_seek_criteria',  unserialize(base64_decode($param['criteria'])));
        }
        $this->onReload();
    }
    
    /**
     * Select the register by ID and return the information to the main form
     *     When using onblur signal, AJAX passes all needed parameters via GET
     *     instead of calling onSetup before.
     */
    public static function onSelect($param)
    {
        $key = $param['key'];
        $database      = isset($param['database'])      ? $param['database'] : TSession::getValue('standard_seek_database');
        $receive_key   = isset($param['receive_key'])   ? $param['receive_key']   : TSession::getValue('standard_seek_receive_key');
        $receive_field = isset($param['receive_field']) ? $param['receive_field'] : TSession::getValue('standard_seek_receive_field');
        $display_field = isset($param['display_field']) ? $param['display_field'] : TSession::getValue('standard_seek_display_field');
        $parent        = isset($param['parent'])        ? $param['parent']        : TSession::getValue('standard_seek_parent');
        
        try
        {
            TTransaction::open($database);
            // load the active record
            $model = isset($param['model']) ? $param['model'] : TSession::getValue('standard_seek_model');
            $activeRecord = new $model($key);
            
            $pk   = constant("{$model}::PRIMARYKEY");
            
            $object = new StdClass;
            $object->$receive_key   = isset($activeRecord->$pk) ? $activeRecord->$pk : '';
            $object->$receive_field = isset($activeRecord->$display_field) ? $activeRecord->$display_field : '';
            TTransaction::close();
            
            TForm::sendData($parent, $object);
            parent::closeWindow(); // closes the window
        }
        catch (Exception $e) // in case of exception
        {
            // clear fields
            $object = new StdClass;
            $object->$receive_key   = '';
            $object->$receive_field = '';
            TForm::sendData($parent, $object);
            
            // undo all pending operations
            TTransaction::rollback();
        }
    }
}
?>

Felipe Vicente - AUTOR DO POST 11/12/2015 (há 9 anos)

Boa tarde Eduardo Soares, consegui resolver. Eu estava utilizando o padrão do Adianti Studio, onde é criado um xml e lá da opção de um campo receber o ID e outro um Campo qualquer como ta no meu print. Criei uma classe que xtends TWindow, na própia classe inseri um campo de de busca e um datagrid normal e foi resolvido.

Mesmo assim valeu, ficou legal sua adotação.

Felipe Vicente - AUTOR DO POST 11/12/2015 (há 9 anos)

adaptação* :)