ContaCorrenteDAO
extends Model
Table of Contents
Methods
-
atualizar()
: mixed
-
atualizarOfx()
: mixed
-
atualizarProximaAtualizacaoOfxTask()
: mixed
-
atualizarUltimaDataSaldoConfere()
: mixed
-
buildSQL()
: mixed
-
buscarContasAuditoriaParametros()
: mixed
-
checkDirectAccessSecurity()
: mixed
-
commit()
: mixed
-
consultar()
: mixed
-
consultarBuscaOfx()
: mixed
-
consultarCodigoEmpresaINTSYS()
: mixed
-
consultarConciliacaoBancaria()
: mixed
-
consultarContaBancaria()
: mixed
-
consultarContaBancariaAdiantamentoClienteFornecedor()
: mixed
-
consultarContaBancariaControlaChequeTerceiro()
: mixed
-
consultarContaBancariaFinanceiro()
: mixed
-
consultarContaBancariaFluxoDiario()
: mixed
-
consultarContaCorrente()
: mixed
-
consultarContaCorrentePermissao()
: mixed
-
consultarContaCorrentePermissaoRemesssa()
: mixed
-
consultarContaCorrenteSelect2()
: mixed
-
consultarContasBancarias()
: mixed
-
consultarContasBancariasContaConfirmada()
: mixed
-
consultarContasBancariasMovimentacao()
: mixed
-
consultarContasBancariasRemessa()
: mixed
-
consultarDadosContaBancariaFluxoDiario()
: mixed
-
consultarExtrato()
: mixed
-
consultarIdBanco()
: mixed
-
consultarInfoContaAtualizaExtratoTask()
: mixed
-
consultarMovimentacaoVerificaSaldoBancoTask()
: mixed
-
consultarRelatorio()
: mixed
-
consultarRelatorioAnalisPatrimonial()
: mixed
-
consultarRelatorioAnalisPatrimonialDetalhes()
: mixed
-
consultarSaldoChequeAberto()
: mixed
-
consultarSaldoContaBancaria()
: mixed
-
consultarTodasContaBancaria()
: mixed
-
consultarTodasContaBancariaParaInsert()
: mixed
-
consultarTotalBanco()
: mixed
-
deletar()
: mixed
-
enableLogQuery()
: mixed
-
getContaBancoInfo()
: mixed
-
getGenericSQL()
: mixed
-
gridQuery()
: mixed
-
importarOfx()
: mixed
-
inserir()
: mixed
-
inserirImport()
: mixed
-
lastId()
: mixed
-
listarContasBancariasAtivas()
: mixed
-
new()
: mixed
-
printSQL()
: mixed
-
replaceFields()
: bool
-
rollBack()
: mixed
-
rowCount()
: mixed
-
runQuery()
: mixed
-
runRAWSelect()
: mixed
-
select2Ajax()
: mixed
-
select_for_update()
: mixed
-
selectSecurity()
: mixed
-
startTransaction()
: mixed
-
totalRegistro()
: mixed
-
verificaExisteSaldoMaiorQueZero()
: mixed
-
checkDisableEntitySecurity()
: mixed
-
logQuery()
: mixed
-
pdo_execute_sql()
: mixed
-
consultarSaldoBancoPorIdContaBancaria()
: mixed
atualizar()
public
atualizar(ContaCorrenteEntity $obj) : mixed
Parameters
-
$obj
: ContaCorrenteEntity
-
atualizarOfx()
public
atualizarOfx(ContaCorrenteEntity $obj) : mixed
Parameters
-
$obj
: ContaCorrenteEntity
-
atualizarProximaAtualizacaoOfxTask()
public
atualizarProximaAtualizacaoOfxTask(mixed $id_conta_bancaria, mixed $horas_apos_busca) : mixed
Parameters
-
$id_conta_bancaria
: mixed
-
-
$horas_apos_busca
: mixed
-
atualizarUltimaDataSaldoConfere()
public
atualizarUltimaDataSaldoConfere(mixed $id_conta_bancaria) : mixed
Parameters
-
$id_conta_bancaria
: mixed
-
buildSQL()
public
buildSQL(SQL $sql) : mixed
Parameters
-
$sql
: SQL
-
buscarContasAuditoriaParametros()
public
buscarContasAuditoriaParametros() : mixed
-
#[DisableEntitySecurity]
-
$callers: ['src\controllers\gestao_fiscal\LivroCaixaDigitalController::relatorioAuditoriaParametrizacoes' => true]
checkDirectAccessSecurity()
public
static checkDirectAccessSecurity(mixed $pk, mixed $entity) : mixed
Parameters
-
$pk
: mixed
-
-
$entity
: mixed
-
commit()
public
commit() : mixed
consultar()
public
consultar(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarBuscaOfx()
public
consultarBuscaOfx(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarCodigoEmpresaINTSYS()
public
consultarCodigoEmpresaINTSYS() : mixed
consultarConciliacaoBancaria()
public
consultarConciliacaoBancaria(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarContaBancaria()
public
consultarContaBancaria() : mixed
consultarContaBancariaAdiantamentoClienteFornecedor()
public
consultarContaBancariaAdiantamentoClienteFornecedor(mixed $origem) : mixed
Parameters
-
$origem
: mixed
-
consultarContaBancariaControlaChequeTerceiro()
public
consultarContaBancariaControlaChequeTerceiro() : mixed
consultarContaBancariaFinanceiro()
public
consultarContaBancariaFinanceiro() : mixed
consultarContaBancariaFluxoDiario()
public
consultarContaBancariaFluxoDiario() : mixed
consultarContaCorrente()
public
consultarContaCorrente() : mixed
consultarContaCorrentePermissao()
public
consultarContaCorrentePermissao() : mixed
consultarContaCorrentePermissaoRemesssa()
public
consultarContaCorrentePermissaoRemesssa() : mixed
consultarContaCorrenteSelect2()
public
consultarContaCorrenteSelect2(mixed $params) : mixed
Parameters
-
$params
: mixed
-
consultarContasBancarias()
public
consultarContasBancarias() : mixed
consultarContasBancariasContaConfirmada()
public
consultarContasBancariasContaConfirmada() : mixed
consultarContasBancariasMovimentacao()
public
consultarContasBancariasMovimentacao(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarContasBancariasRemessa()
public
consultarContasBancariasRemessa() : mixed
consultarDadosContaBancariaFluxoDiario()
public
consultarDadosContaBancariaFluxoDiario(mixed $params) : mixed
Parameters
-
$params
: mixed
-
public
consultarExtrato(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarIdBanco()
public
consultarIdBanco(mixed $id) : mixed
Parameters
-
$id
: mixed
-
public
consultarInfoContaAtualizaExtratoTask() : mixed
consultarMovimentacaoVerificaSaldoBancoTask()
public
consultarMovimentacaoVerificaSaldoBancoTask(mixed $id_usuario) : mixed
Parameters
-
$id_usuario
: mixed
-
consultarRelatorio()
public
consultarRelatorio(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarRelatorioAnalisPatrimonial()
public
consultarRelatorioAnalisPatrimonial() : mixed
consultarRelatorioAnalisPatrimonialDetalhes()
public
consultarRelatorioAnalisPatrimonialDetalhes() : mixed
consultarSaldoChequeAberto()
public
consultarSaldoChequeAberto(mixed $idContaBancaria) : mixed
Parameters
-
$idContaBancaria
: mixed
-
consultarSaldoContaBancaria()
public
consultarSaldoContaBancaria([mixed $params = [] ]) : mixed
Parameters
-
$params
: mixed
= []
-
consultarTodasContaBancaria()
public
consultarTodasContaBancaria() : mixed
consultarTodasContaBancariaParaInsert()
public
consultarTodasContaBancariaParaInsert() : mixed
consultarTotalBanco()
public
consultarTotalBanco(mixed $sql_unidade_negocio) : mixed
Parameters
-
$sql_unidade_negocio
: mixed
-
deletar()
public
deletar(mixed $id, mixed $motivo) : mixed
Parameters
-
$id
: mixed
-
-
$motivo
: mixed
-
enableLogQuery()
public
static enableLogQuery([bool $enable = true ]) : mixed
Parameters
-
$enable
: bool
= true
-
getContaBancoInfo()
public
getContaBancoInfo(mixed $id_conta_bancaria) : mixed
Parameters
-
$id_conta_bancaria
: mixed
-
getGenericSQL()
public
getGenericSQL([array<string|int, mixed>|string $where_filter = [] ]) : mixed
Parameters
-
$where_filter
: array<string|int, mixed>|string
= []
-
gridQuery()
public
gridQuery(mixed $sql_campos, mixed $inicio, mixed $limite, mixed $filtroOrdenacao, mixed $filtroBuscaAvancada) : mixed
Parameters
-
$sql_campos
: mixed
-
-
$inicio
: mixed
-
-
$limite
: mixed
-
-
$filtroOrdenacao
: mixed
-
-
$filtroBuscaAvancada
: mixed
-
importarOfx()
public
importarOfx(mixed $id) : mixed
Parameters
-
$id
: mixed
-
inserir()
public
inserir(ContaCorrenteEntity $obj) : mixed
Parameters
-
$obj
: ContaCorrenteEntity
-
inserirImport()
public
inserirImport(ContaCorrenteEntity $obj) : mixed
Parameters
-
$obj
: ContaCorrenteEntity
-
lastId()
public
lastId() : mixed
listarContasBancariasAtivas()
public
listarContasBancariasAtivas() : mixed
new()
public
static new() : mixed
printSQL()
public
printSQL(SQL $sql[, bool $print = true ]) : mixed
Parameters
-
$sql
: SQL
-
-
$print
: bool
= true
-
replaceFields()
public
replaceFields(mixed &$sql_campos, mixed $cur_field, mixed $new_field) : bool
Parameters
-
$sql_campos
: mixed
-
-
$cur_field
: mixed
-
-
$new_field
: mixed
-
rollBack()
public
rollBack() : mixed
rowCount()
public
rowCount() : mixed
runQuery()
public
runQuery(SQL $sql) : mixed
Parameters
-
$sql
: SQL
-
runRAWSelect()
public
runRAWSelect(string $raw[, array<string|int, mixed> $values = [] ][, bool $fetchAll = false ][, array<string|int, mixed> $security_extra_fields = [] ][, bool $print = false ][, array<string|int, mixed> $database = Entity::database ][, string $security_only_for_this_table_or_alias = "" ]) : mixed
Parameters
-
$raw
: string
-
-
$values
: array<string|int, mixed>
= []
-
-
$fetchAll
: bool
= false
-
-
$security_extra_fields
: array<string|int, mixed>
= []
-
-
$print
: bool
= false
-
-
$database
: array<string|int, mixed>
= Entity::database
-
-
$security_only_for_this_table_or_alias
: string
= ""
-
select2Ajax()
public
select2Ajax(mixed $search, mixed $limit, mixed $resultCount[, mixed $options = null ][, mixed $array_params = [] ]) : mixed
Parameters
-
$search
: mixed
-
-
$limit
: mixed
-
-
$resultCount
: mixed
-
-
$options
: mixed
= null
-
-
$array_params
: mixed
= []
-
select_for_update()
public
select_for_update(mixed $entity, mixed $select_fields, mixed $where_str, mixed $where_values[, mixed $join_str = "" ][, mixed $join_values = [] ]) : mixed
Parameters
-
$entity
: mixed
-
-
$select_fields
: mixed
-
-
$where_str
: mixed
-
-
$where_values
: mixed
-
-
$join_str
: mixed
= ""
-
-
$join_values
: mixed
= []
-
selectSecurity()
public
selectSecurity(array<string|int, mixed> $where) : mixed
Parameters
-
$where
: array<string|int, mixed>
-
startTransaction()
public
startTransaction() : mixed
totalRegistro()
public
totalRegistro([mixed $filtroBuscaAvancada = "" ]) : mixed
Parameters
-
$filtroBuscaAvancada
: mixed
= ""
-
verificaExisteSaldoMaiorQueZero()
public
verificaExisteSaldoMaiorQueZero(mixed $id) : mixed
Parameters
-
$id
: mixed
-
checkDisableEntitySecurity()
protected
checkDisableEntitySecurity() : mixed
logQuery()
protected
logQuery(string $sql, array<string|int, mixed> $values, int $query_type) : mixed
Parameters
-
$sql
: string
-
-
$values
: array<string|int, mixed>
-
-
$query_type
: int
-
pdo_execute_sql()
protected
pdo_execute_sql(array<string|int, mixed> $db_data_array, string $sql, array<string|int, mixed> $values, bool $fetchAll, int $query_type) : mixed
Parameters
-
$db_data_array
: array<string|int, mixed>
-
-
$sql
: string
-
-
$values
: array<string|int, mixed>
-
-
$fetchAll
: bool
-
-
$query_type
: int
-
consultarSaldoBancoPorIdContaBancaria()
private
consultarSaldoBancoPorIdContaBancaria(mixed $id_conta_bancaria) : mixed
Parameters
-
$id_conta_bancaria
: mixed
-