function __construct() { parent::__construct(); $idcomponente = JRequest::getVar('idcomponente'); $this->_queryListagem = "SELECT * FROM " . ECOMP_TABLE_CATEGORIAS . " WHERE idcomponente = {$idcomponente} AND %where% ORDER BY ordering ASC, nome ASC"; $this->_queryCadastro = "SELECT * FROM " . ECOMP_TABLE_CATEGORIAS . " WHERE idcomponente = {$idcomponente} AND %where% ORDER BY ordering ASC, nome ASC"; }
function __construct() { parent::__construct(); $idcomponente = JRequest::getVar('idcomponente', 0); $idcadastro = JRequest::getVar('idcadastro', 0); $this->_queryListagem = "SELECT * FROM " . ECOMP_TABLE_CADASTROS_IMAGENS . " WHERE %where% AND idcomponente = {$idcomponente} AND idcadastro = {$idcadastro} ORDER BY ordering, id DESC, legenda ASC"; $this->_queryCadastro = "SELECT * FROM " . ECOMP_TABLE_CADASTROS_IMAGENS . " WHERE %where% AND idcomponente = {$idcomponente} AND idcadastro = {$idcadastro} ORDER BY ordering, legenda ASC"; }
function __construct() { parent::__construct(); $idcomponente = JRequest::getVar('idcomponente', 0); $componente = new JCRUD(ECOMP_TABLE_COMPONENTES, array('id' => $idcomponente)); $this->_campoTrashed = "trashed"; $this->_queryListagem = "SELECT * FROM " . ECOMP_TABLE_COMPONENTES . "_{$componente->alias} WHERE %where% ORDER BY ordering ASC"; $this->_queryCadastro = "SELECT * FROM " . ECOMP_TABLE_COMPONENTES . "_{$componente->alias} WHERE %where% ORDER BY ordering ASC"; }
function __construct() { parent::__construct(); $this->_queryListagem = "SELECT * FROM #__eformmail_formularios WHERE %where%"; $this->_queryCadastro = "SELECT * FROM #__eformmail_formularios WHERE %where%"; }
function __construct() { parent::__construct(); $this->_queryListagem = "SELECT * FROM " . ECOMP_TABLE_COMPONENTES . " WHERE %where% ORDER BY nome ASC"; $this->_queryCadastro = "SELECT * FROM " . ECOMP_TABLE_COMPONENTES . " WHERE %where% ORDER BY nome ASC"; }
function __construct() { parent::__construct(); $this->_queryListagem = "SELECT * ,(SELECT nome FROM " . ECOMP_TABLE_COMPONENTES . " WHERE id = idcomponente) AS 'componente', (SELECT nome FROM " . ECOMP_TABLE_TIPOS . " WHERE id = idtipo) AS 'tipo' FROM " . ECOMP_TABLE_CAMPOS . " WHERE %where% ORDER BY componente, ordering ASC"; $this->_queryCadastro = "SELECT * FROM #__ecomp_campos WHERE %where% ORDER BY nome ASC"; }