Skip to content

Instantly share code, notes, and snippets.

@carlosleonam

carlosleonam/adianti-framework-order-datagrid-column-by-relation-field.md

Created April 13, 2024 16:24
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlosleonam/ea4a75685beab2c533287b44b1344c90 to your computer and use it in GitHub Desktop.
Save carlosleonam/ea4a75685beab2c533287b44b1344c90 to your computer and use it in GitHub Desktop.
Download ZIP
Adianti Framework - TDATAGRID - Ordenação de Coluna por Campo Relacionado
Raw
adianti-framework-order-datagrid-column-by-relation-field.md

TDATAGRID - Ordenação de Coluna por Campo Relacionado

No criação do Datagrid adicionar:

$order_fk_FOR_CODIGO_FOR_NOME = new TAction(array($this, 'onReload'));
$order_fk_FOR_CODIGO_FOR_NOME->setParameter('order', 'fk_FOR_CODIGO->FOR_NOME');
$column_fk_FOR_CODIGO_FOR_NOME->setAction($order_FOR_CODIGO);

Na onReload() abaixo de:

// creates a criteria
$criteria = new TCriteria;

Acrescentar (adaptando) no código de ordenação das colunas:

if (isset($param['order']) AND $param['order'] == 'fk_FOR_CODIGO->FOR_NOME')
{
    $param['order'] = '(SELECT FORNECEDORES.FOR_NOME FROM FORNECEDORES WHERE FORNECEDORES.FOR_CODIGO = CTPAGAR.FOR_CODIGO)';
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment