DataGrid com Criterios

DataGrid com Criterios estou tentando filtrar os itens exibidos em um datagrid mas não estou tendo sucesso, gostaria de saber se tem como usar a classe TCriteria para filtrar estou tentando utilizar o criterio no bloco de código abaixo da função onReload. ...

Pablo Leandro Pippi 20/04/2017 (há 8 anos)

estou tentando filtrar os itens exibidos em um datagrid mas não estou tendo sucesso, gostaria de saber se tem como usar a classe TCriteria para filtrar estou tentando utilizar o criterio no bloco de código abaixo da função onReload.

<?php
if (TSession::getValue('ListaList_filter_id')) {
$criteria->add(TSession::getValue('ListaList_filter_id')); // add the session filter
}
if (TSession::getValue('ListaList_filter_nome')) {
$criteria->add(TSession::getValue('ListaList_filter_nome')); // add the session filter
}
?>

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

Nataniel Rabaioli 20/04/2017 (há 8 anos)

Não retorna nenhum dado na grid ou os dados não estão considerando o filtro?

Execute o comando abaixo para verificar o sql que está sendo executado:

<?php
TTransaction::setLogger(new TLoggerSTD());
?>

Pablo Leandro Pippi - AUTOR DO POST 23/04/2017 (há 8 anos)

Não consideram o filtro

Nataniel Rabaioli 24/04/2017 (há 8 anos)

Poste o código

Pablo Leandro Pippi - AUTOR DO POST 24/04/2017 (há 8 anos)

<?php

<?php
/**
* PerfilForm Form
* @author <gestoo ti>
*/
class PerfilForm extends TPage
{
protected $form; // form
/**
* Form constructor
* @param $param Request
*/
public function __construct( $param )
{
parent::__construct();
// creates the form
$this->form = new TQuickForm('form_Perfil');
$this->form->class = 'tform'; // change CSS class
$this->form = new BootstrapFormWrapper($this->form);
$this->form->style = 'display: table;width:100%'; // change style
// define the form title
$this->form->setFormTitle('Perfil');
// create the form fields
$id = new TEntry('id');
$system_user_id = new TDBCombo('system_user_id', 'sample', 'system');
$nome = new TEntry('nome');
$cpf = new TEntry('cpf');
$cnpj = new TEntry('cnpj');
$email = new TEntry('email');
$telefone = new TEntry('telefone');
$endereco = new TEntry('endereco');
$cidade = new TCombo('cidade');
$uf = new TEntry('uf');
$this->form->setFieldsByRow(2); // numero de colunas do formulario
// add the fields
$this->form->addQuickField('Id', $id, 100 );
$this->form->addQuickField('Usuário', $system_user_id, 100 );
$this->form->addQuickField('Nome', $nome, 200 );
$this->form->addQuickField('CPF', $cpf, 200 );
$this->form->addQuickField('CNPJ', $cnpj, 200 );
$this->form->addQuickField('Email', $email, 200 );
$this->form->addQuickField('Telefone', $telefone, 200 );
$this->form->addQuickField('Endereço', $endereco, 200 );
$this->form->addQuickField('Cidade', $cidade, 200 );
$this->form->addQuickField('UF', $uf, 200 );
$system_user_id->setSize('100%');
$nome->setSize('100%');
$cpf->setSize('100%');
$cnpj->setSize('100%');
$email->setSize('100%');
$telefone->setSize('100%');
$endereco->setSize('100%');
$cidade->setSize('100%');
$uf->setSize('100%');
if (!empty($id))
{
$id->setEditable(FALSE);
}
/** samples
$this->form->addQuickFields('Date', array($date1, new TLabel('to'), $date2)); // side by side fields
$fieldX->addValidation( 'Field X', new TRequiredValidator ); // add validation
$fieldX->setSize( 100, 40 ); // set size
**/
// create the form actions
$this->form->addQuickAction(_t('Save'), new TAction(array($this, 'onSave')), 'fa:floppy-o');
$this->form->addQuickAction(_t('New'), new TAction(array($this, 'onClear')), 'bs:plus-sign green');
// vertical box container
$container = new TVBox;
$container->style = 'width: 100%';
$container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->add(TPanelGroup::pack('Cadastro de Perfil', $this->form));
parent::add($container);
}
/**
* Save form data
* @param $param Request
*/
public function onSave( $param )
{
try
{
TTransaction::open('sample'); // open a transaction
/**
// Enable Debug logger for SQL operations inside the transaction
TTransaction::setLogger(new TLoggerSTD); // standard output
TTransaction::setLogger(new TLoggerTXT('log.txt')); // file
**/
$this->form->validate(); // validate form data
$object = new Perfil; // create an empty object
$data = $this->form->getData(); // get form data as array
$object->fromArray( (array) $data); // load the object with data
$object->store(); // save the object
// get the generated id
$data->id = $object->id;
$this->form->setData($data); // fill form data
TTransaction::close(); // close the transaction
new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'));
}
catch (Exception $e) // in case of exception
{
new TMessage('error', $e->getMessage()); // shows the exception error message
$this->form->setData( $this->form->getData() ); // keep form data
TTransaction::rollback(); // undo all pending operations
}
}
/**
* Clear form data
* @param $param Request
*/
public function onClear( $param )
{
$this->form->clear(TRUE);
}
/**
* Load object to form data
* @param $param Request
*/
public function onEdit( $param )
{
try
{
if (isset($param['key']))
{
$key = $param['key']; // get the parameter $key
TTransaction::open('sample'); // open a transaction
$object = new Perfil($key); // instantiates the Active Record
$this->form->setData($object); // fill the form
TTransaction::close(); // close the transaction
}
else
{
$this->form->clear(TRUE);
}
}
catch (Exception $e) // in case of exception
{
new TMessage('error', $e->getMessage()); // shows the exception error message
TTransaction::rollback(); // undo all pending operations
}
}
}
?>

</gestoo>

Pablo Leandro Pippi - AUTOR DO POST 24/04/2017 (há 8 anos)

Desculpa o código correto.

<?php

<?php
/**
* ListaList Listing
* @author <your name here>
*/
class ListaList 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 TQuickForm('form_search_Lista');
$this->form->class = 'tform'; // change CSS class
$this->form = new BootstrapFormWrapper($this->form);
$this->form->style = 'display: table;width:100%'; // change style
$this->form->setFormTitle('Lista');
// create the form fields
$id = new TEntry('id');
$nome = new TEntry('nome');
$system_user_id = new TEntry('system_user_id');
// add the fields
$this->form->addQuickField('Id', $id, 200 );
$this->form->addQuickField('Nome', $nome, 200 );
$this->form->addQuickField('Usuário', $system_user_id, 200 );
// keep the form filled during navigation with session data
$this->form->setData( TSession::getValue('Lista_filter_data') );
// add the search form actions
$this->form->addQuickAction(_t('Find'), new TAction(array($this, 'onSearch')), 'fa:search');
$this->form->addQuickAction(_t('New'), new TAction(array('ListaForm', 'onEdit')), 'bs:plus-sign green');
// creates a Datagrid
$this->datagrid = new TDataGrid;
$this->datagrid = new BootstrapDatagridWrapper($this->datagrid);
$this->datagrid->style = 'width: 100%';
$this->datagrid->datatable = 'true';
// $this->datagrid->enablePopover('Popover', 'Hi <b> {name} </b>');
// creates the datagrid columns
$column_check = new TDataGridColumn('check', '', 'center');
$column_id = new TDataGridColumn('id', 'Id', 'right');
$column_nome = new TDataGridColumn('nome', 'Nome', 'left');
$column_system_user_id = new TDataGridColumn('system_user_id', 'Usuário', 'right');
// add the columns to the DataGrid
$this->datagrid->addColumn($column_check);
$this->datagrid->addColumn($column_id);
$this->datagrid->addColumn($column_nome);
$this->datagrid->addColumn($column_system_user_id);
// create EDIT action
$action_edit = new TDataGridAction(array('ListaForm', '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(array($this, 'onReload')));
$this->pageNavigation->setWidth($this->datagrid->getWidth());
$this->datagrid->disableDefaultClick();
// put datagrid inside a form
$this->formgrid = new TForm;
$this->formgrid->add($this->datagrid);
// creates the delete collection button
$this->deleteButton = new TButton('delete_collection');
$this->deleteButton->setAction(new TAction(array($this, 'onDeleteCollection')), AdiantiCoreTranslator::translate('Delete selected'));
$this->deleteButton->setImage('fa:remove red');
$this->formgrid->addField($this->deleteButton);
$gridpack = new TVBox;
$gridpack->style = 'width: 100%';
$gridpack->add($this->formgrid);
$gridpack->add($this->deleteButton)->style = 'background:whiteSmoke;border:1px solid #cccccc; padding: 3px;padding: 5px;';
$this->transformCallback = array($this, 'onBeforeLoad');
// vertical box container
$container = new TVBox;
$container->style = 'width: 90%';
// $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
$container->add(TPanelGroup::pack('Title', $this->form));
$container->add($gridpack);
$container->add($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('sample'); // open a transaction with database
$object = new Lista($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', '<b>Error</b> ' . $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('ListaList_filter_id', NULL);
TSession::setValue('ListaList_filter_nome', NULL);
TSession::setValue('ListaList_filter_system_user_id', NULL);
if (isset($data->id) AND ($data->id)) {
$filter = new TFilter('id', 'like', "%{$data->id}%"); // create the filter
TSession::setValue('ListaList_filter_id', $filter); // stores the filter in the session
}
if (isset($data->nome) AND ($data->nome)) {
$filter = new TFilter('nome', 'like', "%{$data->nome}%"); // create the filter
TSession::setValue('ListaList_filter_nome', $filter); // stores the filter in the session
}
if (isset($data->system_user_id) AND ($data->system_user_id)) {
$filter = new TFilter('system_user_id', '=', "$data->system_user_id"); // create the filter
TSession::setValue('ListaList_filter_system_user_id', $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('Lista_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 'sample'
TTransaction::open('sample');
// creates a repository for Lista
$repository = new TRepository('Lista');
$limit = 10;
// creates a criteria
$criteria = new TCriteria;
//$criteria->add(new TFilter('system_user_id' = 1);
// default order
if (empty($param['order']))
{
$param['order'] = 'id';
$param['direction'] = 'asc';
}
$criteria->setProperties($param); // order, offset
$criteria->setProperty('limit', $limit);
if (TSession::getValue('ListaList_filter_id')) {
$criteria->add(TSession::getValue('ListaList_filter_id')); // add the session filter
}
if (TSession::getValue('ListaList_filter_nome')) {
$criteria->add(TSession::getValue('ListaList_filter_nome')); // add the session filter
}
if (TSession::getValue('ListaList_filter_system_user_id')) {
$criteria->add(TSession::getValue('ListaList_filter_system_user_id')); // 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 function onDelete($param)
{
// define the delete action
$action = new TAction(array($this, 'Delete'));
$action->setParameters($param); // pass the key parameter ahead
// shows a dialog to the user
new TQuestion(AdiantiCoreTranslator::translate('Do you really want to delete ?'), $action);
}
/**
* Delete a record
*/
public function Delete($param)
{
try
{
$key=$param['key']; // get the parameter $key
TTransaction::open('sample'); // open a transaction with database
$object = new Lista($key, FALSE); // instantiates the Active Record
$object->delete(); // deletes the object from the database
TTransaction::close(); // close the transaction
$this->onReload( $param ); // reload the listing
new TMessage('info', AdiantiCoreTranslator::translate('Record deleted')); // 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
}
}
/**
* Ask before delete record collection
*/
public function onDeleteCollection( $param )
{
$data = $this->formgrid->getData(); // get selected records from datagrid
$this->formgrid->setData($data); // keep form filled
if ($data)
{
$selected = array();
// get the record id's
foreach ($data as $index => $check)
{
if ($check == 'on')
{
$selected[] = substr($index,5);
}
}
if ($selected)
{
// encode record id's as json
$param['selected'] = json_encode($selected);
// define the delete action
$action = new TAction(array($this, 'deleteCollection'));
$action->setParameters($param); // pass the key parameter ahead
// shows a dialog to the user
new TQuestion(AdiantiCoreTranslator::translate('Do you really want to delete ?'), $action);
}
}
}
/**
* method deleteCollection()
* Delete many records
*/
public function deleteCollection($param)
{
// decode json with record id's
$selected = json_decode($param['selected']);
try
{
TTransaction::open('sample');
if ($selected)
{
// delete each record from collection
foreach ($selected as $id)
{
$object = new Lista;
$object->delete( $id );
}
$posAction = new TAction(array($this, 'onReload'));
$posAction->setParameters( $param );
new TMessage('info', AdiantiCoreTranslator::translate('Records deleted'), $posAction);
}
TTransaction::close();
}
catch (Exception $e)
{
new TMessage('error', $e->getMessage());
TTransaction::rollback();
}
}
/**
* Transform datagrid objects
* Create the checkbutton as datagrid element
*/
public function onBeforeLoad($objects, $param)
{
// update the action parameters to pass the current page to action
// without this, the action will only work for the first page
$deleteAction = $this->deleteButton->getAction();
$deleteAction->setParameters($param); // important!
$gridfields = array( $this->deleteButton );
foreach ($objects as $object)
{
$object->check = new TCheckButton('check' . $object->id);
$object->check->setIndexValue('on');
$gridfields[] = $object->check; // important
}
$this->formgrid->setFields($gridfields);
}
/**
* 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 24/04/2017 (há 8 anos)

O que aconteceu aqui foi o seguinte: os filtros funcionam quando clico no botão buscar, mas não funcionam com o enter.

Veja se acontece o mesmo com você. Se for o caso, utilize a classe BootstrapFormBuilder ao invés de BootstrapFormWrapper.

Pablo Leandro Pippi - AUTOR DO POST 25/04/2017 (há 8 anos)

Ok isso eu já entendi, o que necessito é que o data grid já carregue com os filtros.

Novo Comentário