Documentation

ContaAnaliticaDAO extends Model
in package

Table of Contents

Constants

CENTRO_GERENCIAL_ATIVO  = 14
CENTRO_GERENCIAL_ENTRADA  = 16
CENTRO_GERENCIAL_PASSIVO  = 15
CENTRO_GERENCIAL_SAIDA  = 17

Methods

apiPlanoConta()  : mixed
atualizar()  : mixed
atualizarIntegracaoContabil()  : mixed
atualizarLote()  : mixed
buildSQL()  : mixed
checkDirectAccessSecurity()  : mixed
commit()  : mixed
consultar()  : mixed
consultarCentroCusto()  : mixed
consultarCentroCustoDuplicarPlanejamento()  : mixed
consultarContaAnalitica()  : mixed
consultarContaAnaliticaBalancoPatrimonialTask()  : mixed
consultarDadosIntegracaoContabil()  : mixed
consultarDetalhes()  : mixed
consultarEditeLote()  : mixed
consultaridCentroCustoDoPlanoConta()  : array<string|int, mixed>
consultarImpactarContaPagar()  : mixed
consultarPlanoCompraServico()  : mixed
consultarPlanoCompraServicoRateado()  : mixed
consultarPlanoConta()  : mixed
consultarPlanoContaCentroCusto()  : mixed
consultarPlanoContaCentroCustoPlanejamento()  : mixed
consultarPlanoContaFinanceiro()  : mixed
consultarPlanoContaFinanciamento()  : mixed
consultarPlanoContaFinanciamentoDespesa()  : mixed
consultarPlanoContaFinanciamentoJuros()  : mixed
consultarPlanoContaFinanciamentoPagar()  : mixed
consultarPlanoContaFinanciamentoReceita()  : mixed
consultarPlanoContaIdNegocioObrigatorio()  : mixed
consultarPlanoContaIntegracao()  : mixed
consultarPlanoContaIntegracaoContabil()  : mixed
consultarPlanoContaPagar()  : mixed
consultarPlanoContaPorCentroCusto()  : mixed
consultarPlanoContaPorId()  : mixed
consultarPlanoContaProduto()  : mixed
consultarPlanodeContaContaPagarReceber()  : mixed
consultarRelatorioControleDespesa()  : mixed
consultarRendimentoNegativo()  : mixed
consultarRendimentoPositivo()  : mixed
consultarSQLPlanoConta()  : mixed
consultarTrocarDestino()  : mixed
consultarTrocarOrigem()  : mixed
deletar()  : mixed
enableLogQuery()  : mixed
executarConsultaBalancoPatrimonialTask()  : mixed
executarRAWSQLPlanoConta()  : mixed
executarRAWSQLPlanoContaAtivo()  : mixed
getEntitySecurityData()  : mixed
getGenericSQL()  : mixed
gridQuery()  : mixed
inserir()  : mixed
inserirImport()  : mixed
lastId()  : mixed
listarIdPlanoContaPagarInativo()  : mixed
listarPlanosContasPagarStatusAtivo()  : mixed
listarPlanosContasReceberStatusAtivo()  : mixed
new()  : mixed
printSQL()  : mixed
relatorioBalanceteDescricao()  : mixed
relatorioBalanceteSubNivel()  : mixed
relatorioBalancoPatrimonial()  : mixed
relatorioPlanoContaFinanceiro()  : mixed
replaceFields()  : bool
rollBack()  : mixed
rowCount()  : mixed
runQuery()  : mixed
runRAWSelect()  : mixed
select2Ajax()  : mixed
select_for_update()  : mixed
selectDropDownImport()  : mixed
selectPlanoConta()  : mixed
startTransaction()  : mixed
totalRegistro()  : mixed
checkDisableEntitySecurity()  : mixed
logQuery()  : mixed
pdo_execute_sql()  : mixed
__validarSql()  : mixed
inserirUpdate()  : mixed
validarSql()  : mixed

Constants

Methods

buildSQL()

public buildSQL(SQL $sql) : mixed
Parameters
$sql : SQL

checkDirectAccessSecurity()

public static checkDirectAccessSecurity(mixed $pk, mixed $entity) : mixed
Parameters
$pk : mixed
$entity : mixed

commit()

public commit() : mixed

consultarCentroCusto()

public consultarCentroCusto(mixed $id) : mixed
Parameters
$id : mixed

consultarCentroCustoDuplicarPlanejamento()

public consultarCentroCustoDuplicarPlanejamento() : mixed

consultarContaAnaliticaBalancoPatrimonialTask()

public consultarContaAnaliticaBalancoPatrimonialTask() : mixed

consultarDadosIntegracaoContabil()

public consultarDadosIntegracaoContabil() : mixed

consultarDetalhes()

public consultarDetalhes(mixed $id) : mixed
Parameters
$id : mixed
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesPassivo' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesCentroCusto' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesPlanoConta' => true]

consultarEditeLote()

public consultarEditeLote(mixed $chaves, mixed $fields) : mixed
Parameters
$chaves : mixed
$fields : mixed

consultaridCentroCustoDoPlanoConta()

public consultaridCentroCustoDoPlanoConta(string|int $id_plano_conta) : array<string|int, mixed>
Parameters
$id_plano_conta : string|int
Return values
array<string|int, mixed>

consultarImpactarContaPagar()

public consultarImpactarContaPagar(mixed $id) : mixed
Parameters
$id : mixed

consultarPlanoCompraServico()

public consultarPlanoCompraServico([mixed $edit = false ]) : mixed
Parameters
$edit : mixed = false

consultarPlanoCompraServicoRateado()

public consultarPlanoCompraServicoRateado(mixed $array_ids_plano_contas) : mixed
Parameters
$array_ids_plano_contas : mixed

consultarPlanoContaCentroCusto()

public consultarPlanoContaCentroCusto(mixed $option) : mixed
Parameters
$option : mixed

consultarPlanoContaCentroCustoPlanejamento()

public consultarPlanoContaCentroCustoPlanejamento(mixed $id[, mixed $ano_data = false ][, mixed $view_plan = '' ]) : mixed
Parameters
$id : mixed
$ano_data : mixed = false
$view_plan : mixed = ''

consultarPlanoContaFinanceiro()

public consultarPlanoContaFinanceiro(mixed $id) : mixed
Parameters
$id : mixed

consultarPlanoContaFinanciamento()

public consultarPlanoContaFinanciamento() : mixed

consultarPlanoContaFinanciamentoDespesa()

public consultarPlanoContaFinanciamentoDespesa() : mixed

consultarPlanoContaFinanciamentoJuros()

public consultarPlanoContaFinanciamentoJuros() : mixed

consultarPlanoContaFinanciamentoPagar()

public consultarPlanoContaFinanciamentoPagar() : mixed

consultarPlanoContaFinanciamentoReceita()

public consultarPlanoContaFinanciamentoReceita() : mixed

consultarPlanoContaIdNegocioObrigatorio()

public consultarPlanoContaIdNegocioObrigatorio(mixed $id_plano_conta) : mixed
Parameters
$id_plano_conta : mixed

consultarPlanoContaIntegracao()

public consultarPlanoContaIntegracao(mixed $idPlanoConta, mixed $total, mixed $whereplanoconta) : mixed
Parameters
$idPlanoConta : mixed
$total : mixed
$whereplanoconta : mixed

consultarPlanoContaIntegracaoContabil()

public consultarPlanoContaIntegracaoContabil() : mixed

consultarPlanoContaPorCentroCusto()

public consultarPlanoContaPorCentroCusto(mixed $id) : mixed
Parameters
$id : mixed
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\relatorio\BalancoPatrimonialController::montarDadosRelatorio' => true]

consultarPlanoContaPorId()

public consultarPlanoContaPorId(array<string|int, mixed> $array_idplanoconta) : mixed
Parameters
$array_idplanoconta : array<string|int, mixed>
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\financeiro\IntegracaoContaPagar::buscaPlanoContaRateio' => true]

consultarPlanodeContaContaPagarReceber()

public consultarPlanodeContaContaPagarReceber(mixed $id) : mixed
Parameters
$id : mixed

consultarRelatorioControleDespesa()

public consultarRelatorioControleDespesa() : mixed

consultarRendimentoNegativo()

public consultarRendimentoNegativo(mixed $id) : mixed
Parameters
$id : mixed

consultarRendimentoPositivo()

public consultarRendimentoPositivo(mixed $id) : mixed
Parameters
$id : mixed

consultarSQLPlanoConta()

public consultarSQLPlanoConta(mixed $dado_sql_buscar) : mixed
Parameters
$dado_sql_buscar : mixed
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\relatorio\BalancoPatrimonialController::montarDadosRelatorioAtual' => true]

consultarTrocarOrigem()

public consultarTrocarOrigem(mixed $id) : mixed
Parameters
$id : 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

executarConsultaBalancoPatrimonialTask()

public executarConsultaBalancoPatrimonialTask(mixed $sql) : mixed
Parameters
$sql : mixed

executarRAWSQLPlanoConta()

public executarRAWSQLPlanoConta(mixed $dado_script[, mixed $fetch = false ][, mixed $option = "" ][, mixed $id_plano_conta = "" ]) : mixed
Parameters
$dado_script : mixed
$fetch : mixed = false
$option : mixed = ""
$id_plano_conta : mixed = ""
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\relatorio\BalancoPatrimonialController::montarDadosRelatorioAtual' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesPassivo' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesCentroCusto' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesPlanoConta' => true]

executarRAWSQLPlanoContaAtivo()

public executarRAWSQLPlanoContaAtivo(mixed $dado_script[, mixed $fetch = false ][, mixed $option = "" ]) : mixed
Parameters
$dado_script : mixed
$fetch : mixed = false
$option : mixed = ""
Attributes
#[DisableEntitySecurity]
$callers: ['src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesAtivo' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesCentroCustoAtivo' => true, 'src\controllers\relatorio\BalancoPatrimonialController::drillDetalhesPlanoConta' => true]

getEntitySecurityData()

public getEntitySecurityData(mixed $id_usuario) : mixed
Parameters
$id_usuario : 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

lastId()

public lastId() : mixed

listarIdPlanoContaPagarInativo()

public listarIdPlanoContaPagarInativo() : mixed

listarPlanosContasPagarStatusAtivo()

public listarPlanosContasPagarStatusAtivo() : mixed

listarPlanosContasReceberStatusAtivo()

public listarPlanosContasReceberStatusAtivo() : mixed

new()

public static new() : mixed

printSQL()

public printSQL(SQL $sql[, bool $print = true ]) : mixed
Parameters
$sql : SQL
$print : bool = true

relatorioBalanceteDescricao()

public relatorioBalanceteDescricao(mixed $array_filtro) : mixed
Parameters
$array_filtro : mixed

relatorioBalanceteSubNivel()

public relatorioBalanceteSubNivel([mixed $params = [] ][, mixed $existe_config_intsys = false ]) : mixed
Parameters
$params : mixed = []
$existe_config_intsys : mixed = false

relatorioBalancoPatrimonial()

public relatorioBalancoPatrimonial(mixed $id) : mixed
Parameters
$id : mixed

relatorioPlanoContaFinanceiro()

public relatorioPlanoContaFinanceiro(mixed $id_centro_custo) : mixed
Parameters
$id_centro_custo : mixed

replaceFields()

public replaceFields(mixed &$sql_campos, mixed $cur_field, mixed $new_field) : bool
Parameters
$sql_campos : mixed
$cur_field : mixed
$new_field : mixed
Return values
bool

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 = []

startTransaction()

public startTransaction() : mixed

totalRegistro()

public totalRegistro([mixed $filtroBuscaAvancada = "" ]) : mixed
Parameters
$filtroBuscaAvancada : 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

__validarSql()

private __validarSql(string $tipo_database, string $query[, mixed $error_title = null ]) : mixed
Parameters
$tipo_database : string
$query : string
$error_title : mixed = null

inserirUpdate()

private inserirUpdate(mixed $obj) : mixed
Parameters
$obj : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results