public function __construct($pk = null) { parent::__construct('dl_site_dados_contato', 'dado_contato_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS DC' . " INNER JOIN {$this->bd_tabela}_tipos AS TD ON( TD.tipo_dado_id = DC.dado_contato_tipo )" . ' WHERE DC.%sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('tabela', 'prefixo'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_google_analytics', 'ga_'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_assuntos_contato', 'assunto_contato_'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_albuns', 'album_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS A' . " INNER JOIN dl_painel_registros_logs AS LR ON( LR.log_registro_tabela = '{$this->bd_tabela}' AND LR.log_registro_regpk = A.album_id AND LR.log_registro_acao = 'A' )" . " LEFT JOIN {$this->bd_tabela}_fotos AS FC ON ( FC.foto_album = A.album_id AND FC.foto_album_capa = 1 )" . ' WHERE A.%sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_albuns_fotos', 'foto_album_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS F' . ' INNER JOIN dl_site_albuns AS A ON( A.album_id = F.foto_album )' . ' WHERE F.%sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_institucional', 'instit_'); $this->bd_select = 'SELECT %s FROM %s'; $this->selecionarPK($pk); }