ControleSafraDAO
extends Model
in package
Table of Contents
Properties
- $visualizar : mixed
Methods
- atualizar() : mixed
- atualizarLote() : mixed
- buildSQL() : mixed
- checkDirectAccessSecurity() : mixed
- commit() : mixed
- consultar() : mixed
- consultarAnoAgricolaAtivo() : mixed
- consultarAnoAgricolaCompra() : mixed
- consultarAnoAgricolaInativo() : mixed
- consultarAnoSafra() : mixed
- Busca os ano safra que estão disponíveis para visualizar
- consultarAnoSafraCadastrados() : mixed
- consultarDetalheAnoAgricola() : mixed
- consultarEditeLote() : mixed
- consultarTodos() : mixed
- Busca todos os anos safras (aberto/fechado)
- deletar() : mixed
- enableLogQuery() : mixed
- getGenericSQL() : mixed
- gridQuery() : mixed
- inserir() : mixed
- lastId() : mixed
- MOBILEconsultarTodos() : mixed
- new() : mixed
- printSQL() : mixed
- replaceFields() : bool
- rollBack() : mixed
- rowCount() : mixed
- runQuery() : mixed
- runRAWSelect() : mixed
- select_for_update() : mixed
- selectDropDownImport() : mixed
- startTransaction() : mixed
- totalRegistro() : mixed
- checkDisableEntitySecurity() : mixed
- logQuery() : mixed
- pdo_execute_sql() : mixed
Properties
$visualizar
private
mixed
$visualizar
= 0
Methods
atualizar()
public
atualizar(ControleSafraEntity $obj) : mixed
Parameters
- $obj : ControleSafraEntity
atualizarLote()
public
atualizarLote(ControleSafraEntity $obj, mixed $fields) : mixed
Parameters
- $obj : ControleSafraEntity
- $fields : 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
consultarAnoAgricolaAtivo()
public
consultarAnoAgricolaAtivo() : mixed
consultarAnoAgricolaCompra()
public
consultarAnoAgricolaCompra() : mixed
consultarAnoAgricolaInativo()
public
consultarAnoAgricolaInativo() : mixed
consultarAnoSafra()
Busca os ano safra que estão disponíveis para visualizar
public
consultarAnoSafra() : mixed
consultarAnoSafraCadastrados()
public
consultarAnoSafraCadastrados() : mixed
consultarDetalheAnoAgricola()
public
consultarDetalheAnoAgricola() : mixed
consultarEditeLote()
public
consultarEditeLote(mixed $chaves, mixed $fields) : mixed
Parameters
- $chaves : mixed
- $fields : mixed
consultarTodos()
Busca todos os anos safras (aberto/fechado)
public
consultarTodos() : 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
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
inserir()
public
inserir(ControleSafraEntity $obj) : mixed
Parameters
- $obj : ControleSafraEntity
lastId()
public
lastId() : mixed
MOBILEconsultarTodos()
public
MOBILEconsultarTodos() : 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 = ""
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 = []
selectDropDownImport()
public
selectDropDownImport() : 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