public function __construct($pk = null) { parent::__construct('dl_painel_usuarios_recuperacoes', 'recuperacao_'); # Query de seleção $this->bd_select = 'SELECT %s' . ' FROM %s AS R' . ' INNER JOIN dl_painel_usuarios AS U ON( U.usuario_id = R.recuperacao_usuario )'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_modulos', 'modulo_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS M' . " LEFT JOIN {$this->bd_tabela} AS S ON( S.{$this->bd_prefixo}id = M.{$this->bd_prefixo}pai )" . ' WHERE M.%sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_contatos_leitura', 'leitura_contato_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS LC' . " INNER JOIN dl_site_contatos AS CS ON( CS.contato_site_id = LC.leitura_contato )" . " LEFT JOIN dl_painel_usuarios AS U ON ( U.usuario_id = LC.{$this->bd_prefixo}usuario )"; $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 %sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_albuns', 'album_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS 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_configuracoes', 'configuracao_'); $this->bd_select = 'SELECT %s FROM %s'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_usuarios', 'usuario_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS U' . ' INNER JOIN dl_painel_grupos_usuarios AS G ON( G.grupo_usuario_id = U.usuario_info_grupo )' . ' INNER JOIN dl_painel_idiomas AS I ON( I.idioma_id = U.usuario_pref_idioma )' . ' INNER JOIN dl_painel_temas AS T ON( T.tema_id = U.usuario_pref_tema )' . ' INNER JOIN dl_painel_formatos_data FD ON( FD.formato_data_id = U.usuario_pref_formato_data )' . ' WHERE %sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_idiomas', 'idioma_'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_modulos_funcs', 'func_modulo_'); $this->selecionarPK($pk); }
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('dl_painel_formatos_data', 'formato_data_'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_contatos', 'contato_site_'); $this->bd_select = 'SELECT %s' . ' FROM %s AS CS' . ' LEFT JOIN dl_site_assuntos_contato AS AC ON( AC.assunto_contato_id = CS.contato_site_assunto )' . " INNER JOIN dl_painel_registros_logs AS LR ON( LR.log_registro_regpk = CS.contato_site_id AND LR.log_registro_tabela = '{$this->bd_tabela}' AND LR.log_registro_acao = 'A' )" . ' WHERE CS.%sdelete = 0'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_registros_logs', 'log_registro_'); $this->bd_select = 'SELECT %s FROM %s'; $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_painel_email_config', 'config_email_'); $this->selecionarPK($pk); }
public function __construct($pk = null) { parent::__construct('dl_site_dados_contato_tipos', 'tipo_dado_'); $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_institucional', 'instit_'); $this->bd_select = 'SELECT %s FROM %s'; $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_painel_grupos_usuarios', 'grupo_usuario_'); $this->selecionarPK($pk); }