TABCOLANCEntity
extends Entity
in package
Table of Contents
Constants
- auditlog = []
- Allowed keys: 'exclude_fields': <...> 'object_rel': <...>
- const_values = []
- database = \config\Config::DB_INTSYS_FISCAL
- db_table = 'TABCOLANC'
- pk_field = 'EMPRE_LANC'
- sanitize = []
- security = []
- Allowed keys: 'select': <...> 'update': <...> 'delete': <...> 'insert': <...>
- tracking = true
- validations = []
Properties
- $COMPE_LANC : mixed
- $COMPL_LANC : mixed
- $CONCI_LANC : mixed
- $CUSTO_LANC : mixed
- $DTEXT_LANC : mixed
- $EMPRE_LANC : mixed
- $ENCER_LANC : mixed
- $HISTO_LANC : mixed
- $IDSISTEMAGERE : mixed
- $LOCAL_LANC : mixed
- $NLOTE_LANC : mixed
- $NODIA_LANC : mixed
- $NUMER_LANC : mixed
- $ORDEM_LANC : mixed
- $PARTI_LANC : mixed
- $PLANO_LANC : mixed
- $REDUC_LANC : mixed
- $REDUD_LANC : mixed
- $TIPOL_LANC : mixed
- $TIPOP_LANC : mixed
- $VALOR_LANC : mixed
Methods
- __construct() : mixed
- delete() : mixed
- delete_where() : mixed
- getAuditlog() : mixed
- getCOMPE_LANC() : mixed
- Get the value of COMPE_LANC
- getCOMPL_LANC() : mixed
- Get the value of COMPL_LANC
- getCONCI_LANC() : mixed
- Get the value of CONCI_LANC
- getConst() : mixed
- getConstObj() : mixed
- getCUSTO_LANC() : mixed
- Get the value of CUSTO_LANC
- getDatabase() : mixed
- getDBDriver() : mixed
- getDBTable() : mixed
- getDTEXT_LANC() : mixed
- Get the value of DTEXT_LANC
- getEMPRE_LANC() : mixed
- Get the value of EMPRE_LANC
- getENCER_LANC() : mixed
- Get the value of ENCER_LANC
- getHISTO_LANC() : mixed
- Get the value of HISTO_LANC
- getIDSISTEMAGERE() : mixed
- Get the value of IDSISTEMAGERE
- getLOCAL_LANC() : mixed
- Get the value of LOCAL_LANC
- getNLOTE_LANC() : mixed
- Get the value of NLOTE_LANC
- getNODIA_LANC() : mixed
- Get the value of NODIA_LANC
- getNUMER_LANC() : mixed
- Get the value of NUMER_LANC
- getORDEM_LANC() : mixed
- Get the value of ORDEM_LANC
- getPARTI_LANC() : mixed
- Get the value of PARTI_LANC
- getPLANO_LANC() : mixed
- Get the value of PLANO_LANC
- getREDUC_LANC() : mixed
- Get the value of REDUC_LANC
- getREDUD_LANC() : mixed
- Get the value of REDUD_LANC
- getTable() : mixed
- getTIPOL_LANC() : mixed
- Get the value of TIPOL_LANC
- getTIPOP_LANC() : mixed
- Get the value of TIPOP_LANC
- getVALOR_LANC() : mixed
- Get the value of VALOR_LANC
- hasField() : mixed
- insert() : null|Entity
- insert_or_select() : null|Entity
- Funcao que insere ou seleciona se existe
- insert_or_update() : array<string|int, mixed>
- Funcao que insere ou atualiza uma entidade no banco de dados
- securityDelete() : bool
- securityInsert() : bool
- securitySelect() : array<string|int, mixed>
- securityUpdate() : bool
- setCOMPE_LANC() : self
- Set the value of COMPE_LANC
- setCOMPL_LANC() : self
- Set the value of COMPL_LANC
- setCONCI_LANC() : self
- Set the value of CONCI_LANC
- setCUSTO_LANC() : self
- Set the value of CUSTO_LANC
- setDTEXT_LANC() : self
- Set the value of DTEXT_LANC
- setEMPRE_LANC() : self
- Set the value of EMPRE_LANC
- setENCER_LANC() : self
- Set the value of ENCER_LANC
- setHISTO_LANC() : self
- Set the value of HISTO_LANC
- setIDSISTEMAGERE() : self
- Set the value of IDSISTEMAGERE
- setLOCAL_LANC() : self
- Set the value of LOCAL_LANC
- setNLOTE_LANC() : self
- Set the value of NLOTE_LANC
- setNODIA_LANC() : self
- Set the value of NODIA_LANC
- setNUMER_LANC() : self
- Set the value of NUMER_LANC
- setORDEM_LANC() : self
- Set the value of ORDEM_LANC
- setPARTI_LANC() : self
- Set the value of PARTI_LANC
- setPLANO_LANC() : self
- Set the value of PLANO_LANC
- setREDUC_LANC() : self
- Set the value of REDUC_LANC
- setREDUD_LANC() : self
- Set the value of REDUD_LANC
- setTIPOL_LANC() : self
- Set the value of TIPOL_LANC
- setTIPOP_LANC() : self
- Set the value of TIPOP_LANC
- setVALOR_LANC() : self
- Set the value of VALOR_LANC
- update() : mixed
- A função update pode atualizar uma Entity já instanciada, desde que a chave primária esteja setada, ou pode atualizar uma Entity vazia informando o valor da chave primária no segundo parâmetro (pk_value)
- validateFields() : bool
- where() : Collection
- Rudimentary ORM functions
Constants
auditlog
Allowed keys: 'exclude_fields': <...> 'object_rel': <...>
public
mixed
auditlog
= []
const_values
public
mixed
const_values
= []
database
public
mixed
database
= \config\Config::DB_INTSYS_FISCAL
db_table
public
mixed
db_table
= 'TABCOLANC'
pk_field
public
mixed
pk_field
= 'EMPRE_LANC'
sanitize
public
mixed
sanitize
= []
security
Allowed keys: 'select': <...> 'update': <...> 'delete': <...> 'insert': <...>
public
mixed
security
= []
tracking
public
mixed
tracking
= true
validations
public
mixed
validations
= []
Properties
$COMPE_LANC
private
mixed
$COMPE_LANC
$COMPL_LANC
private
mixed
$COMPL_LANC
$CONCI_LANC
private
mixed
$CONCI_LANC
$CUSTO_LANC
private
mixed
$CUSTO_LANC
$DTEXT_LANC
private
mixed
$DTEXT_LANC
$EMPRE_LANC
private
mixed
$EMPRE_LANC
$ENCER_LANC
private
mixed
$ENCER_LANC
$HISTO_LANC
private
mixed
$HISTO_LANC
$IDSISTEMAGERE
private
mixed
$IDSISTEMAGERE
$LOCAL_LANC
private
mixed
$LOCAL_LANC
$NLOTE_LANC
private
mixed
$NLOTE_LANC
$NODIA_LANC
private
mixed
$NODIA_LANC
$NUMER_LANC
private
mixed
$NUMER_LANC
$ORDEM_LANC
private
mixed
$ORDEM_LANC
$PARTI_LANC
private
mixed
$PARTI_LANC
$PLANO_LANC
private
mixed
$PLANO_LANC
$REDUC_LANC
private
mixed
$REDUC_LANC
$REDUD_LANC
private
mixed
$REDUD_LANC
$TIPOL_LANC
private
mixed
$TIPOL_LANC
$TIPOP_LANC
private
mixed
$TIPOP_LANC
$VALOR_LANC
private
mixed
$VALOR_LANC
Methods
__construct()
public
__construct([array<string|int, mixed> $values = [] ]) : mixed
Parameters
- $values : array<string|int, mixed> = []
delete()
public
delete(mixed $motivo) : mixed
Parameters
- $motivo : mixed
delete_where()
public
static delete_where(mixed $motivo[, mixed $where = [] ]) : mixed
Parameters
- $motivo : mixed
- $where : mixed = []
getAuditlog()
public
getAuditlog([string|null $key = null ]) : mixed
Parameters
- $key : string|null = null
getCOMPE_LANC()
Get the value of COMPE_LANC
public
getCOMPE_LANC() : mixed
getCOMPL_LANC()
Get the value of COMPL_LANC
public
getCOMPL_LANC() : mixed
getCONCI_LANC()
Get the value of CONCI_LANC
public
getCONCI_LANC() : mixed
getConst()
public
static getConst(string $field[, mixed $const_value = null ]) : mixed
Parameters
- $field : string
- $const_value : mixed = null
getConstObj()
public
static getConstObj(string $field[, mixed $const_value = null ]) : mixed
Parameters
- $field : string
- $const_value : mixed = null
getCUSTO_LANC()
Get the value of CUSTO_LANC
public
getCUSTO_LANC() : mixed
getDatabase()
public
getDatabase() : mixed
getDBDriver()
public
static getDBDriver() : mixed
getDBTable()
public
static getDBTable() : mixed
getDTEXT_LANC()
Get the value of DTEXT_LANC
public
getDTEXT_LANC() : mixed
getEMPRE_LANC()
Get the value of EMPRE_LANC
public
getEMPRE_LANC() : mixed
getENCER_LANC()
Get the value of ENCER_LANC
public
getENCER_LANC() : mixed
getHISTO_LANC()
Get the value of HISTO_LANC
public
getHISTO_LANC() : mixed
getIDSISTEMAGERE()
Get the value of IDSISTEMAGERE
public
getIDSISTEMAGERE() : mixed
getLOCAL_LANC()
Get the value of LOCAL_LANC
public
getLOCAL_LANC() : mixed
getNLOTE_LANC()
Get the value of NLOTE_LANC
public
getNLOTE_LANC() : mixed
getNODIA_LANC()
Get the value of NODIA_LANC
public
getNODIA_LANC() : mixed
getNUMER_LANC()
Get the value of NUMER_LANC
public
getNUMER_LANC() : mixed
getORDEM_LANC()
Get the value of ORDEM_LANC
public
getORDEM_LANC() : mixed
getPARTI_LANC()
Get the value of PARTI_LANC
public
getPARTI_LANC() : mixed
getPLANO_LANC()
Get the value of PLANO_LANC
public
getPLANO_LANC() : mixed
getREDUC_LANC()
Get the value of REDUC_LANC
public
getREDUC_LANC() : mixed
getREDUD_LANC()
Get the value of REDUD_LANC
public
getREDUD_LANC() : mixed
getTable()
public
getTable() : mixed
getTIPOL_LANC()
Get the value of TIPOL_LANC
public
getTIPOL_LANC() : mixed
getTIPOP_LANC()
Get the value of TIPOP_LANC
public
getTIPOP_LANC() : mixed
getVALOR_LANC()
Get the value of VALOR_LANC
public
getVALOR_LANC() : mixed
hasField()
public
static hasField(mixed $field) : mixed
Parameters
- $field : mixed
insert()
public
insert() : null|Entity
Return values
null|Entityinsert_or_select()
Funcao que insere ou seleciona se existe
public
insert_or_select([mixed $where = [] ]) : null|Entity
Parameters
- $where : mixed = []
Return values
null|Entityinsert_or_update()
Funcao que insere ou atualiza uma entidade no banco de dados
public
insert_or_update([mixed $where = [] ][, mixed $update_fields = ['*'] ]) : array<string|int, mixed>
Parameters
- $where : mixed = []
- $update_fields : mixed = ['*']
Return values
array<string|int, mixed>securityDelete()
public
securityDelete(mixed $table, mixed $where) : bool
Parameters
- $table : mixed
- $where : mixed
Return values
boolsecurityInsert()
public
securityInsert(mixed $fields) : bool
Parameters
- $fields : mixed
Return values
bool —return 'true' if the security function didn't find any security issue and 'false' otherwise
securitySelect()
public
securitySelect(mixed $table, mixed $fields, mixed $where) : array<string|int, mixed>
Parameters
- $table : mixed
- $fields : mixed
- $where : mixed
Return values
array<string|int, mixed> —return an array with information to be appended in the SQL select
securityUpdate()
public
securityUpdate(mixed $fields, mixed $where) : bool
Parameters
- $fields : mixed
- $where : mixed
Return values
bool —return 'true' if the security function didn't find any security issue and 'false' otherwise
setCOMPE_LANC()
Set the value of COMPE_LANC
public
setCOMPE_LANC(mixed $COMPE_LANC) : self
Parameters
- $COMPE_LANC : mixed
Return values
selfsetCOMPL_LANC()
Set the value of COMPL_LANC
public
setCOMPL_LANC(mixed $COMPL_LANC) : self
Parameters
- $COMPL_LANC : mixed
Return values
selfsetCONCI_LANC()
Set the value of CONCI_LANC
public
setCONCI_LANC(mixed $CONCI_LANC) : self
Parameters
- $CONCI_LANC : mixed
Return values
selfsetCUSTO_LANC()
Set the value of CUSTO_LANC
public
setCUSTO_LANC(mixed $CUSTO_LANC) : self
Parameters
- $CUSTO_LANC : mixed
Return values
selfsetDTEXT_LANC()
Set the value of DTEXT_LANC
public
setDTEXT_LANC(mixed $DTEXT_LANC) : self
Parameters
- $DTEXT_LANC : mixed
Return values
selfsetEMPRE_LANC()
Set the value of EMPRE_LANC
public
setEMPRE_LANC(mixed $EMPRE_LANC) : self
Parameters
- $EMPRE_LANC : mixed
Return values
selfsetENCER_LANC()
Set the value of ENCER_LANC
public
setENCER_LANC(mixed $ENCER_LANC) : self
Parameters
- $ENCER_LANC : mixed
Return values
selfsetHISTO_LANC()
Set the value of HISTO_LANC
public
setHISTO_LANC(mixed $HISTO_LANC) : self
Parameters
- $HISTO_LANC : mixed
Return values
selfsetIDSISTEMAGERE()
Set the value of IDSISTEMAGERE
public
setIDSISTEMAGERE(mixed $IDSISTEMAGERE) : self
Parameters
- $IDSISTEMAGERE : mixed
Return values
selfsetLOCAL_LANC()
Set the value of LOCAL_LANC
public
setLOCAL_LANC(mixed $LOCAL_LANC) : self
Parameters
- $LOCAL_LANC : mixed
Return values
selfsetNLOTE_LANC()
Set the value of NLOTE_LANC
public
setNLOTE_LANC(mixed $NLOTE_LANC) : self
Parameters
- $NLOTE_LANC : mixed
Return values
selfsetNODIA_LANC()
Set the value of NODIA_LANC
public
setNODIA_LANC(mixed $NODIA_LANC) : self
Parameters
- $NODIA_LANC : mixed
Return values
selfsetNUMER_LANC()
Set the value of NUMER_LANC
public
setNUMER_LANC(mixed $NUMER_LANC) : self
Parameters
- $NUMER_LANC : mixed
Return values
selfsetORDEM_LANC()
Set the value of ORDEM_LANC
public
setORDEM_LANC(mixed $ORDEM_LANC) : self
Parameters
- $ORDEM_LANC : mixed
Return values
selfsetPARTI_LANC()
Set the value of PARTI_LANC
public
setPARTI_LANC(mixed $PARTI_LANC) : self
Parameters
- $PARTI_LANC : mixed
Return values
selfsetPLANO_LANC()
Set the value of PLANO_LANC
public
setPLANO_LANC(mixed $PLANO_LANC) : self
Parameters
- $PLANO_LANC : mixed
Return values
selfsetREDUC_LANC()
Set the value of REDUC_LANC
public
setREDUC_LANC(mixed $REDUC_LANC) : self
Parameters
- $REDUC_LANC : mixed
Return values
selfsetREDUD_LANC()
Set the value of REDUD_LANC
public
setREDUD_LANC(mixed $REDUD_LANC) : self
Parameters
- $REDUD_LANC : mixed
Return values
selfsetTIPOL_LANC()
Set the value of TIPOL_LANC
public
setTIPOL_LANC(mixed $TIPOL_LANC) : self
Parameters
- $TIPOL_LANC : mixed
Return values
selfsetTIPOP_LANC()
Set the value of TIPOP_LANC
public
setTIPOP_LANC(mixed $TIPOP_LANC) : self
Parameters
- $TIPOP_LANC : mixed
Return values
selfsetVALOR_LANC()
Set the value of VALOR_LANC
public
setVALOR_LANC(mixed $VALOR_LANC) : self
Parameters
- $VALOR_LANC : mixed
Return values
selfupdate()
A função update pode atualizar uma Entity já instanciada, desde que a chave primária esteja setada, ou pode atualizar uma Entity vazia informando o valor da chave primária no segundo parâmetro (pk_value)
public
update(array<string|int, mixed> $values[, mixed $pk_value = null ]) : mixed
Parameters
- $values : array<string|int, mixed>
- $pk_value : mixed = null
validateFields()
public
validateFields([array<string|int, mixed> $fields = [] ]) : bool
Parameters
- $fields : array<string|int, mixed> = []
Return values
boolwhere()
Rudimentary ORM functions
public
static where([mixed $where = [] ][, mixed $select = '*' ]) : Collection
Parameters
- $where : mixed = []
- $select : mixed = '*'