示例#1
0
 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";
 }
示例#2
0
 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";
 }
示例#3
0
 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";
 }
示例#4
0
 function __construct()
 {
     parent::__construct();
     $this->_queryListagem = "SELECT * FROM #__eformmail_formularios WHERE %where%";
     $this->_queryCadastro = "SELECT * FROM #__eformmail_formularios WHERE %where%";
 }
示例#5
0
 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";
 }
示例#6
0
 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";
 }