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

Eduardo Soares 11/12/2015 (há 8 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 ' ';
$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á 8 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á 8 anos)

adaptação* :)