MunicipioDAO
extends Model
in package
Table of Contents
Methods
- buildSQL() : mixed
- checkDirectAccessSecurity() : mixed
- commit() : mixed
- consultar() : mixed
- consultarIdMunicipioPorCodigo() : mixed
- consultarMunicipioEstado() : mixed
- consultarMunicipioEstadoPorCodigo() : mixed
- consultarMunicipioPorNome() : mixed
- consultarTodosMunicipioEstado() : mixed
- enableLogQuery() : mixed
- getListaMunicipiosByNomeEstado() : array<string|int, mixed>
- Retorna um array com os dados dos municípios filtrados pelo nome dos municipios e estados.
- lastId() : mixed
- new() : mixed
- printSQL() : mixed
- replaceFields() : bool
- rollBack() : mixed
- rowCount() : mixed
- runQuery() : mixed
- runRAWSelect() : mixed
- select2Ajax() : mixed
- select_for_update() : mixed
- startTransaction() : mixed
- checkDisableEntitySecurity() : mixed
- logQuery() : mixed
- pdo_execute_sql() : mixed
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
consultar()
public
consultar(mixed $id_municipio) : mixed
Parameters
- $id_municipio : mixed
consultarIdMunicipioPorCodigo()
public
consultarIdMunicipioPorCodigo(mixed $codigo_minicipio) : mixed
Parameters
- $codigo_minicipio : mixed
consultarMunicipioEstado()
public
consultarMunicipioEstado(mixed $estado) : mixed
Parameters
- $estado : mixed
consultarMunicipioEstadoPorCodigo()
public
consultarMunicipioEstadoPorCodigo(mixed $codigo_mun) : mixed
Parameters
- $codigo_mun : mixed
consultarMunicipioPorNome()
public
consultarMunicipioPorNome(mixed $nome_municipio) : mixed
Parameters
- $nome_municipio : mixed
consultarTodosMunicipioEstado()
public
consultarTodosMunicipioEstado() : mixed
enableLogQuery()
public
static enableLogQuery([bool $enable = true ]) : mixed
Parameters
- $enable : bool = true
getListaMunicipiosByNomeEstado()
Retorna um array com os dados dos municípios filtrados pelo nome dos municipios e estados.
public
getListaMunicipiosByNomeEstado([array<string|int, mixed> $where_array = null ][, string|array<string|int, mixed> $where_array_key = "" ][, mixed $callback = null ]) : array<string|int, mixed>
Parameters
- $where_array : array<string|int, mixed> = null
-
2-dim array com os campos 'nome_municipio' e 'estado'. Ex.: [ ['nome_municipio' => 'Campinas', 'estado' => 'SP'], ['nome_municipio' => 'Riberião Preto', 'estado' => 'SP'], ]
- $where_array_key : string|array<string|int, mixed> = ""
-
Chave ou chaves para indexar o resultado.
- $callback : mixed = null
Return values
array<string|int, mixed> —Array indexado pelos campos especificados em $where_array_key
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
Return values
boolrollBack()
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
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