ManutencaoAtivoDAO
extends Model
Table of Contents
Methods
-
apiManutencaoAtivo()
: mixed
-
atualizar()
: mixed
-
atualizarAnexo()
: mixed
-
atualizarIntegracaoFinanceira()
: mixed
-
atualizarTrocaOleoParaT()
: mixed
-
buildSQL()
: mixed
-
checkDirectAccessSecurity()
: mixed
-
commit()
: mixed
-
consultar()
: mixed
-
consultarAnoSafra()
: mixed
-
consultarCustoManutencao()
: mixed
-
consultarDadosDepreciacaoManutencaoAtivo()
: mixed
-
consultarDetalheManutencao()
: mixed
-
consultarDetalhes()
: mixed
-
consultarIdManutPorIdContasPagarLote()
: mixed
-
consultarManutencao()
: mixed
-
consultarManutencaoCadaAtivoRelatorio()
: mixed
-
consultarManutencaoComProdutoPorIdAtivo()
: mixed
-
consultarManutencaoRelatorioCustoAtivo()
: mixed
-
consultarMesManutencaoDrillDoisAtivoCategoriaVazio()
: mixed
-
consultarMesManutencaoDrillTres()
: mixed
-
consultarMesManutencaoDrillUm()
: mixed
-
consultarPeriodo()
: mixed
-
consultarRelatorioAviso()
: mixed
-
consultarRelatorioGeral()
: mixed
-
consultarValorTotalManutencao()
: mixed
-
consultaSubCategoria()
: mixed
-
deletar()
: mixed
-
drillManutencaoInicioRelatorioAuditoria()
: mixed
-
drillManutencaoRelatorioAuditoria()
: mixed
-
enableLogQuery()
: mixed
-
getGenericSQL()
: mixed
-
gridQuery()
: mixed
-
inserir()
: mixed
-
lastId()
: mixed
-
new()
: mixed
-
printSQL()
: mixed
-
replaceFields()
: bool
-
rollBack()
: mixed
-
rowCount()
: mixed
-
runQuery()
: mixed
-
runRAWSelect()
: mixed
-
selecionaManutencaoPessoas()
: mixed
-
select_for_update()
: mixed
-
startTransaction()
: mixed
-
taskAlertaManutencaoUsoCombustivelNao()
: mixed
-
taskAlertaManutencaoUsoCombustivelSim()
: mixed
-
taskCustoHoraMaquinaGetCustoManutencao()
: mixed
-
totalRegistro()
: mixed
-
validaFinanceiro()
: mixed
-
validarFornecedoresIguais()
: mixed
-
validarVinculoExistente()
: mixed
-
verificaManutencao()
: mixed
-
verificaPedidoFornecedor()
: mixed
-
checkDisableEntitySecurity()
: mixed
-
logQuery()
: mixed
-
pdo_execute_sql()
: mixed
apiManutencaoAtivo()
public
apiManutencaoAtivo(mixed $mes_ano) : mixed
Parameters
-
$mes_ano
: mixed
-
atualizar()
public
atualizar(ManutencaoAtivoEntity $obj) : mixed
Parameters
-
$obj
: ManutencaoAtivoEntity
-
atualizarAnexo()
public
atualizarAnexo(ManutencaoAtivoEntity $obj) : mixed
Parameters
-
$obj
: ManutencaoAtivoEntity
-
atualizarIntegracaoFinanceira()
public
atualizarIntegracaoFinanceira(ManutencaoAtivoEntity $obj) : mixed
Parameters
-
$obj
: ManutencaoAtivoEntity
-
atualizarTrocaOleoParaT()
public
atualizarTrocaOleoParaT(mixed $id_manut) : mixed
Parameters
-
$id_manut
: mixed
-
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
consultar()
public
consultar(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarAnoSafra()
public
consultarAnoSafra() : mixed
consultarCustoManutencao()
public
consultarCustoManutencao(mixed $ano_balanco, mixed $idFazenda, mixed $array_unidade_negocio, mixed $agrupa, mixed $tipo) : mixed
Parameters
-
$ano_balanco
: mixed
-
-
$idFazenda
: mixed
-
-
$array_unidade_negocio
: mixed
-
-
$agrupa
: mixed
-
-
$tipo
: mixed
-
consultarDadosDepreciacaoManutencaoAtivo()
public
consultarDadosDepreciacaoManutencaoAtivo(mixed $ano_balanco, mixed $idTipoAtivo, mixed $idFazenda, mixed $idUnidadeNegocio, mixed $idAtivo[, mixed $busca_unidade_negocio_sql = [] ]) : mixed
Parameters
-
$ano_balanco
: mixed
-
-
$idTipoAtivo
: mixed
-
-
$idFazenda
: mixed
-
-
$idUnidadeNegocio
: mixed
-
-
$idAtivo
: mixed
-
-
$busca_unidade_negocio_sql
: mixed
= []
-
consultarDetalheManutencao()
public
consultarDetalheManutencao(mixed $idAtivo, mixed $mes_ano_balanco) : mixed
Parameters
-
$idAtivo
: mixed
-
-
$mes_ano_balanco
: mixed
-
consultarDetalhes()
public
consultarDetalhes(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarIdManutPorIdContasPagarLote()
public
consultarIdManutPorIdContasPagarLote(mixed $arr_id_contas_pagar) : mixed
Parameters
-
$arr_id_contas_pagar
: mixed
-
consultarManutencao()
public
consultarManutencao(mixed $id) : mixed
Parameters
-
$id
: mixed
-
consultarManutencaoCadaAtivoRelatorio()
public
consultarManutencaoCadaAtivoRelatorio(mixed $idAtivo, mixed $mes_ano_balanco, mixed $data_inicio, mixed $data_final) : mixed
Parameters
-
$idAtivo
: mixed
-
-
$mes_ano_balanco
: mixed
-
-
$data_inicio
: mixed
-
-
$data_final
: mixed
-
consultarManutencaoComProdutoPorIdAtivo()
public
consultarManutencaoComProdutoPorIdAtivo(mixed $id_ativo) : mixed
Parameters
-
$id_ativo
: mixed
-
consultarManutencaoRelatorioCustoAtivo()
public
consultarManutencaoRelatorioCustoAtivo(mixed $idAtivo, mixed $mes_ano_balanco, mixed $data_inicio, mixed $data_final) : mixed
Parameters
-
$idAtivo
: mixed
-
-
$mes_ano_balanco
: mixed
-
-
$data_inicio
: mixed
-
-
$data_final
: mixed
-
consultarMesManutencaoDrillDoisAtivoCategoriaVazio()
public
consultarMesManutencaoDrillDoisAtivoCategoriaVazio(mixed $idTipoAtivoCategoria, mixed $mes_ano_balanco, mixed $idFazenda) : mixed
Parameters
-
$idTipoAtivoCategoria
: mixed
-
-
$mes_ano_balanco
: mixed
-
-
$idFazenda
: mixed
-
consultarMesManutencaoDrillTres()
public
consultarMesManutencaoDrillTres(mixed $idTipoAtivoCategoria, mixed $ativo, mixed $mes_ano_balanco, mixed $idFazenda) : mixed
Parameters
-
$idTipoAtivoCategoria
: mixed
-
-
$ativo
: mixed
-
-
$mes_ano_balanco
: mixed
-
-
$idFazenda
: mixed
-
consultarMesManutencaoDrillUm()
public
consultarMesManutencaoDrillUm(mixed $mes_ano_balanco, mixed $idFazenda) : mixed
Parameters
-
$mes_ano_balanco
: mixed
-
-
$idFazenda
: mixed
-
consultarPeriodo()
public
consultarPeriodo() : mixed
consultarRelatorioAviso()
public
consultarRelatorioAviso([mixed $params = [] ]) : mixed
Parameters
-
$params
: mixed
= []
-
consultarRelatorioGeral()
public
consultarRelatorioGeral(mixed $params) : mixed
Parameters
-
$params
: mixed
-
consultarValorTotalManutencao()
public
consultarValorTotalManutencao(mixed $id_manut) : mixed
Parameters
-
$id_manut
: mixed
-
consultaSubCategoria()
public
consultaSubCategoria(mixed $idSubCat) : mixed
Parameters
-
$idSubCat
: mixed
-
deletar()
public
deletar(mixed $id, mixed $motivo) : mixed
Parameters
-
$id
: mixed
-
-
$motivo
: mixed
-
drillManutencaoInicioRelatorioAuditoria()
public
drillManutencaoInicioRelatorioAuditoria(mixed $get_params) : mixed
Parameters
-
$get_params
: mixed
-
drillManutencaoRelatorioAuditoria()
public
drillManutencaoRelatorioAuditoria(mixed $get_params) : mixed
Parameters
-
$get_params
: mixed
-
enableLogQuery()
public
static enableLogQuery([bool $enable = true ]) : mixed
Parameters
-
$enable
: bool
= true
-
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 $filtro_ordenacao, mixed $filtro_busca_avancada) : mixed
Parameters
-
$sql_campos
: mixed
-
-
$inicio
: mixed
-
-
$limite
: mixed
-
-
$filtro_ordenacao
: mixed
-
-
$filtro_busca_avancada
: mixed
-
inserir()
public
inserir(ManutencaoAtivoEntity $obj) : mixed
Parameters
-
$obj
: ManutencaoAtivoEntity
-
lastId()
public
lastId() : 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
= ""
-
selecionaManutencaoPessoas()
public
selecionaManutencaoPessoas(mixed $id, mixed $dt_inicio, mixed $dt_final) : mixed
Parameters
-
$id
: mixed
-
-
$dt_inicio
: mixed
-
-
$dt_final
: 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
taskAlertaManutencaoUsoCombustivelNao()
public
taskAlertaManutencaoUsoCombustivelNao() : mixed
taskAlertaManutencaoUsoCombustivelSim()
public
taskAlertaManutencaoUsoCombustivelSim() : mixed
taskCustoHoraMaquinaGetCustoManutencao()
public
taskCustoHoraMaquinaGetCustoManutencao(mixed $id_ativo, mixed $dia_anterior_fechamento) : mixed
Parameters
-
$id_ativo
: mixed
-
-
$dia_anterior_fechamento
: mixed
-
totalRegistro()
public
totalRegistro([mixed $filtroBuscaAvancada = "" ]) : mixed
Parameters
-
$filtroBuscaAvancada
: mixed
= ""
-
validaFinanceiro()
public
validaFinanceiro(mixed $id) : mixed
Parameters
-
$id
: mixed
-
validarFornecedoresIguais()
public
validarFornecedoresIguais(mixed $arr_manut) : mixed
Parameters
-
$arr_manut
: mixed
-
validarVinculoExistente()
public
validarVinculoExistente(mixed $arr_id_manut) : mixed
Parameters
-
$arr_id_manut
: mixed
-
verificaManutencao()
public
verificaManutencao(mixed $chaves) : mixed
Parameters
-
$chaves
: mixed
-
verificaPedidoFornecedor()
public
verificaPedidoFornecedor(mixed $params) : mixed
Parameters
-
$params
: 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
-