FacturaScripts

PedidoCliente extends SalesDocument
in package
Uses ModelTrait

Customer order.

Tags
author

Carlos García Gómez [email protected]

Table of Contents

AUDIT_CHANNEL  = 'audit'
DATE_STYLE  = 'd-m-Y'
DATETIME_STYLE  = 'd-m-Y H:i:s'
HOUR_STYLE  = 'H:i:s'
MODEL_NAMESPACE  = '\\FacturaScripts\\Dinamic\\Model\\'
$apartado  : string
Mailbox of the client.
$cifnif  : string
VAT number of the customer or supplier.
$ciudad  : string
Customer's city.
$codagente  : string
Agent who created this document. Agente model.
$codalmacen  : string
Warehouse in which the merchandise enters.
$codcliente  : string
Customer of this document.
$coddivisa  : string
Currency of the document.
$codejercicio  : string
Exercise code.
$codigo  : string
Unique identifier for humans.
$codigoenv  : string
Shipping tracking code.
$codpago  : string
Payment method code.
$codpais  : string
Customer's country.
$codpostal  : string
Customer's postal code.
$codserie  : string
$codtrans  : string
Shipping code for the shipment.
$direccion  : string
Customer's address
$dtopor1  : float
Percentage of discount.
$dtopor2  : float
Percentage of discount.
$editable  : bool
Indicates whether the document can be modified
$fecha  : string
Date of the document.
$femail  : string
Date on which the document was sent by email.
$finoferta  : string
Date on which the validity of the estimation ends.
$hora  : string
Document time.
$idcontactoenv  : int
ID of contact for shippment.
$idcontactofact  : int
ID of contact for invoice.
$idempresa  : int
$idestado  : int
Document status, from EstadoDocumento model.
$idpedido  : int
Primary key.
$irpf  : float|int
Default retention for this document. Each line can have a different retention.
$neto  : float|int
Sum of the pvptotal of lines. Total of the document before taxes.
$netosindto  : float|int
Sum of the pvptotal of lines. Total of the document before taxes and global discounts.
$nick  : string
User who created this document. User model.
$nombrecliente  : string
Customer name.
$numdocs  : int
Number of attached documents.
$numero  : string
Number of the document. Unique within the series.
$numero2  : string
Optional number available to the user.
$observaciones  : string
Notes of the document.
$operacion  : string
Indicates the type of document operation, example: intra-community
$provincia  : string
Customer's province.
$tasaconv  : float|int
Rate of conversion to Euros of the selected currency.
$total  : float|int
Total sum of the document, with taxes.
$totalbeneficio  : float
sum total of the benefits of the lines.
$totalcoste  : float
total sum of the costs of the lines.
$totaleuros  : float|int
Total expressed in euros, if it were not the currency of the document.
$totalirpf  : float|int
Total sum of the IRPF withholdings of the lines.
$totaliva  : float|int
Sum of the VAT of the lines.
$totalrecargo  : float|int
Total sum of the equivalence surcharge of the lines.
$totalsuplidos  : float|int
Total sum of supplied lines.
$checkedTables  : array<string|int, mixed>
List of already tested tables.
$dataBase  : DataBase
It provides direct access to the database.
$dont_copy_fields  : array<string|int, mixed>
$fields  : array<string|int, mixed>
List of fields in the table.
$previousData  : array<string|int, mixed>
Previous data array.
$documentGeneration  : bool
$estados  : array<string|int, EstadoDocumento>
__construct()  : mixed
ModelClass constructor.
addExtension()  : mixed
Adds an extension to this model.
all()  : array<string|int, static>
Returns all models that correspond to the selected filters.
changePrimaryColumnValue()  : bool
Change the value of the primary column in the model and the database.
childrenDocuments()  : array<string|int, TransformerDocument>
Returns all children documents of this one.
clear()  : mixed
Reset the values of all model properties.
codeModelAll()  : array<string|int, CodeModel>
Allows to use this model as source in CodeModel special model.
codeModelSearch()  : array<string|int, CodeModel>
Allows to use this model as source in CodeModel special model.
count()  : int
Returns the number of records in the model that meet the condition.
country()  : string
delete()  : bool
Remove the model data from the database.
dontCopyField()  : void
dontCopyFields()  : array<string|int, mixed>
exists()  : bool
Returns true if the model data is stored in the database.
get()  : static|false
Returns the model whose primary column corresponds to the value $cod
getAvailableStatus()  : array<string|int, EstadoDocumento>
Returns all available status for this type of document.
getCompany()  : Empresa
getEUDiscount()  : float
Returns the Equivalent Unified Discount.
getExercise()  : Ejercicio
getLines()  : array<string|int, LineaPedidoCliente>
Returns the lines associated with the order.
getModelFields()  : array<string|int, mixed>
Returns the list of fields in the table.
getNewLine()  : LineaPedidoCliente
Returns a new line for the document.
getNewProductLine()  : mixed
Returns a new line for this business document completed with the product data.
getPaymentMethod()  : FormaPago
getRate()  : Tarifa
getSerie()  : Serie
getStatus()  : EstadoDocumento
Returns the EstadoDocumento model for this document.
getSubject()  : mixed
Returns the subject of this document.
install()  : string
This function is called when creating the model table. Returns the SQL that will be executed after the creation of the table. Useful to insert values default.
loadFromCode()  : bool
Fill the class with the registry values whose primary column corresponds to the value $cod, or according to the condition where indicated, if value is not reported in $cod.
loadFromData()  : mixed
Assign the values of the $data array to the model properties.
modelClassName()  : string
Returns the name of the class of the model.
newCode()  : int
Returns the following code for the reported field or the primary key of the model.
paid()  : bool
parentDocuments()  : array<string|int, TransformerDocument>
Returns all parent document of this one.
pipe()  : mixed
Executes all $name methods added from the extensions.
pipeFalse()  : bool
Executes all $name methods added from the extensions until someone returns false.
primaryColumn()  : string
primaryColumnValue()  : mixed
Returns the current value of the main column of the model.
primaryDescription()  : string
Descriptive identifier for humans of the data record
primaryDescriptionColumn()  : string
Returns the name of the column that describes the model, such as name, description.
save()  : bool
Stores the model data in the database.
setAuthor()  : bool
Sets the author for this document.
setCurrency()  : mixed
setDate()  : bool
Assign the date and find an accounting exercise.
setDocumentGeneration()  : mixed
setIntracomunitaria()  : bool
setSubject()  : bool
Sets subject for this document.
setWarehouse()  : bool
Sets warehouse and company for this document.
subjectColumn()  : mixed
Returns the name of the column for subject.
subjectColumnValue()  : string
table()  : DbQuery
tableName()  : string
test()  : bool
Returns True if there is no errors on properties values.
toArray()  : array<string|int, mixed>
Returns an array with the model fields values.
updateSubject()  : bool
Updates subjects data in this document.
url()  : string
Returns the url where to see / modify the data.
loadModelFields()  : mixed
Loads table fields if is necessary.
modelName()  : string
Returns the name of the model.
onChange()  : bool
This method is called before save (update) when some field has changed.
onDelete()  : mixed
This method is called after a record is removed from the database.
onInsert()  : mixed
This method is called after a new record is saved on the database (saveInsert).
onUpdate()  : mixed
This method is called after a record is updated on the database (saveUpdate).
saveInsert()  : bool
Insert the model data in the database.
saveUpdate()  : bool
Update the model data in the database.
setContact()  : bool
setCustomer()  : bool
setPreviousData()  : mixed
Saves previous values.
toolBox()  : ToolBox
Returns a new instance of the ToolBox class.
checkTable()  : bool
Checks and updates the structure of the table if necessary.
getBoolValueForField()  : bool|null
Returns the boolean value for the field.
getFloatValueForField()  : float|null
Returns the float value for the field.
getIntegerValueForField()  : int|null
Returns the integer value by controlling special cases for the PK and FK.
getOrderBy()  : string
Convert an array of filters order by in string.
getRecord()  : array<string|int, mixed>
Read the record whose primary column corresponds to the value $cod or the first that meets the indicated condition.

Constants

AUDIT_CHANNEL

public mixed AUDIT_CHANNEL = 'audit'

DATE_STYLE

public mixed DATE_STYLE = 'd-m-Y'

DATETIME_STYLE

public mixed DATETIME_STYLE = 'd-m-Y H:i:s'

HOUR_STYLE

public mixed HOUR_STYLE = 'H:i:s'

Properties

$codagente

Agent who created this document. Agente model.

public string $codagente

$codalmacen

Warehouse in which the merchandise enters.

public string $codalmacen

$codcliente

Customer of this document.

public string $codcliente

$codtrans

Shipping code for the shipment.

public string $codtrans

$femail

Date on which the document was sent by email.

public string $femail

$finoferta

Date on which the validity of the estimation ends.

public string $finoferta

$idcontactoenv

ID of contact for shippment.

public int $idcontactoenv

$idcontactofact

ID of contact for invoice.

public int $idcontactofact

$irpf

Default retention for this document. Each line can have a different retention.

public float|int $irpf

$neto

Sum of the pvptotal of lines. Total of the document before taxes.

public float|int $neto

$netosindto

Sum of the pvptotal of lines. Total of the document before taxes and global discounts.

public float|int $netosindto

$numero

Number of the document. Unique within the series.

public string $numero

$numero2

Optional number available to the user.

public string $numero2

$operacion

Indicates the type of document operation, example: intra-community

public string $operacion

$totalbeneficio

sum total of the benefits of the lines.

public float $totalbeneficio

$totalcoste

total sum of the costs of the lines.

public float $totalcoste

$totaleuros

Total expressed in euros, if it were not the currency of the document.

public float|int $totaleuros

totaleuros = total / tasaconv It is not necessary to fill it, when doing save() the value is calculated.

$totalirpf

Total sum of the IRPF withholdings of the lines.

public float|int $totalirpf

$totalrecargo

Total sum of the equivalence surcharge of the lines.

public float|int $totalrecargo

$totalsuplidos

Total sum of supplied lines.

public float|int $totalsuplidos

$checkedTables

List of already tested tables.

protected static array<string|int, mixed> $checkedTables = []

$dataBase

It provides direct access to the database.

protected static DataBase $dataBase

$dont_copy_fields

protected static array<string|int, mixed> $dont_copy_fields = ['codejercicio', 'codigo', 'codigorect', 'fecha', 'femail', 'hora', 'idasiento', 'idestado', 'idfacturarect', 'neto', 'netosindto', 'numero', 'pagada', 'total', 'totalirpf', 'totaliva', 'totalrecargo', 'totalsuplidos']

$fields

List of fields in the table.

protected static array<string|int, mixed> $fields = []

$previousData

Previous data array.

protected array<string|int, mixed> $previousData = []

Methods

__construct()

ModelClass constructor.

public __construct([array<string|int, mixed> $data = [] ]) : mixed
Parameters
$data : array<string|int, mixed> = []
Return values
mixed

addExtension()

Adds an extension to this model.

public abstract static addExtension(mixed $extension) : mixed
Parameters
$extension : mixed
Return values
mixed

all()

Returns all models that correspond to the selected filters.

public static all([array<string|int, mixed> $where = [] ][, array<string|int, mixed> $order = [] ], int $offset[, int $limit = 50 ]) : array<string|int, static>
Parameters
$where : array<string|int, mixed> = []

filters to apply to model records.

$order : array<string|int, mixed> = []

fields to use in the sorting. For example ['code' => 'ASC']

$offset : int
$limit : int = 50
Return values
array<string|int, static>

changePrimaryColumnValue()

Change the value of the primary column in the model and the database.

public changePrimaryColumnValue(mixed $newValue) : bool
Parameters
$newValue : mixed
Return values
bool

clear()

Reset the values of all model properties.

public clear() : mixed
Return values
mixed

codeModelAll()

Allows to use this model as source in CodeModel special model.

public codeModelAll([string $fieldCode = '' ]) : array<string|int, CodeModel>
Parameters
$fieldCode : string = ''
Return values
array<string|int, CodeModel>

codeModelSearch()

Allows to use this model as source in CodeModel special model.

public codeModelSearch(string $query[, string $fieldCode = '' ][, array<string|int, DataBaseWhere$where = [] ]) : array<string|int, CodeModel>
Parameters
$query : string
$fieldCode : string = ''
$where : array<string|int, DataBaseWhere> = []
Return values
array<string|int, CodeModel>

count()

Returns the number of records in the model that meet the condition.

public count([array<string|int, DataBaseWhere$where = [] ]) : int
Parameters
$where : array<string|int, DataBaseWhere> = []

filters to apply to model records.

Return values
int

country()

public country() : string
Return values
string

delete()

Remove the model data from the database.

public delete() : bool
Return values
bool

dontCopyField()

public static dontCopyField(string $field) : void
Parameters
$field : string
Return values
void

dontCopyFields()

public static dontCopyFields() : array<string|int, mixed>
Return values
array<string|int, mixed>

exists()

Returns true if the model data is stored in the database.

public exists() : bool
Return values
bool

get()

Returns the model whose primary column corresponds to the value $cod

public get(string $code) : static|false
Parameters
$code : string
Return values
static|false

getEUDiscount()

Returns the Equivalent Unified Discount.

public getEUDiscount() : float
Return values
float

getModelFields()

Returns the list of fields in the table.

public abstract getModelFields() : array<string|int, mixed>
Return values
array<string|int, mixed>

getNewLine()

Returns a new line for the document.

public getNewLine([array<string|int, mixed> $data = [] ][, array<string|int, mixed> $exclude = ['actualizastock', 'idlinea', 'idpedido', 'servido'] ]) : LineaPedidoCliente
Parameters
$data : array<string|int, mixed> = []
$exclude : array<string|int, mixed> = ['actualizastock', 'idlinea', 'idpedido', 'servido']
Return values
LineaPedidoCliente

getNewProductLine()

Returns a new line for this business document completed with the product data.

public abstract getNewProductLine(mixed $reference) : mixed
Parameters
$reference : mixed
Return values
mixed

getSubject()

Returns the subject of this document.

public abstract getSubject() : mixed
Return values
mixed

install()

This function is called when creating the model table. Returns the SQL that will be executed after the creation of the table. Useful to insert values default.

public install() : string
Return values
string

loadFromCode()

Fill the class with the registry values whose primary column corresponds to the value $cod, or according to the condition where indicated, if value is not reported in $cod.

public loadFromCode(string $code[, array<string|int, mixed> $where = [] ][, array<string|int, mixed> $order = [] ]) : bool

Initializes the values of the class if there is no record that meet the above conditions. Returns True if the record exists and False otherwise.

Parameters
$code : string
$where : array<string|int, mixed> = []
$order : array<string|int, mixed> = []
Return values
bool

loadFromData()

Assign the values of the $data array to the model properties.

public loadFromData([array<string|int, mixed> $data = [] ][, array<string|int, mixed> $exclude = [] ]) : mixed
Parameters
$data : array<string|int, mixed> = []
$exclude : array<string|int, mixed> = []
Return values
mixed

modelClassName()

Returns the name of the class of the model.

public abstract modelClassName() : string
Return values
string

newCode()

Returns the following code for the reported field or the primary key of the model.

public newCode([string $field = '' ][, array<string|int, mixed> $where = [] ]) : int
Parameters
$field : string = ''
$where : array<string|int, mixed> = []
Return values
int

pipe()

Executes all $name methods added from the extensions.

public abstract pipe(string $name, array<string|int, mixed> ...$arguments) : mixed
Parameters
$name : string
$arguments : array<string|int, mixed>
Return values
mixed

pipeFalse()

Executes all $name methods added from the extensions until someone returns false.

public abstract pipeFalse(string $name, array<string|int, mixed> ...$arguments) : bool
Parameters
$name : string
$arguments : array<string|int, mixed>
Return values
bool

primaryColumn()

public static primaryColumn() : string
Return values
string

primaryColumnValue()

Returns the current value of the main column of the model.

public primaryColumnValue() : mixed
Return values
mixed

primaryDescription()

Descriptive identifier for humans of the data record

public primaryDescription() : string
Return values
string

primaryDescriptionColumn()

Returns the name of the column that describes the model, such as name, description.

public primaryDescriptionColumn() : string

..

Return values
string

save()

Stores the model data in the database.

public save() : bool
Return values
bool

setAuthor()

Sets the author for this document.

public abstract setAuthor(mixed $user) : bool
Parameters
$user : mixed
Return values
bool

setCurrency()

public setCurrency(string $coddivisa[, bool $purchase = false ]) : mixed
Parameters
$coddivisa : string
$purchase : bool = false
Return values
mixed

setDate()

Assign the date and find an accounting exercise.

public setDate(string $date, string $hour) : bool
Parameters
$date : string
$hour : string
Return values
bool

setDocumentGeneration()

public setDocumentGeneration(bool $value) : mixed
Parameters
$value : bool
Return values
mixed

setSubject()

Sets subject for this document.

public abstract setSubject(mixed $subject) : bool
Parameters
$subject : mixed
Return values
bool

setWarehouse()

Sets warehouse and company for this document.

public setWarehouse(string $codalmacen) : bool
Parameters
$codalmacen : string
Return values
bool

subjectColumn()

Returns the name of the column for subject.

public abstract subjectColumn() : mixed
Return values
mixed

subjectColumnValue()

public subjectColumnValue() : string
Return values
string

tableName()

public static tableName() : string
Return values
string

test()

Returns True if there is no errors on properties values.

public test() : bool
Return values
bool

toArray()

Returns an array with the model fields values.

public toArray() : array<string|int, mixed>
Return values
array<string|int, mixed>

updateSubject()

Updates subjects data in this document.

public abstract updateSubject() : bool
Return values
bool

url()

Returns the url where to see / modify the data.

public url([string $type = 'auto' ][, string $list = 'List' ]) : string
Parameters
$type : string = 'auto'
$list : string = 'List'
Return values
string

loadModelFields()

Loads table fields if is necessary.

protected abstract loadModelFields(DataBase &$dataBase, string $tableName) : mixed
Parameters
$dataBase : DataBase
$tableName : string
Return values
mixed

modelName()

Returns the name of the model.

protected abstract modelName() : string
Return values
string

onChange()

This method is called before save (update) when some field has changed.

protected onChange(string $field) : bool
Parameters
$field : string
Return values
bool

onDelete()

This method is called after a record is removed from the database.

protected onDelete() : mixed
Return values
mixed

onInsert()

This method is called after a new record is saved on the database (saveInsert).

protected onInsert() : mixed
Return values
mixed

onUpdate()

This method is called after a record is updated on the database (saveUpdate).

protected onUpdate() : mixed
Return values
mixed

saveInsert()

Insert the model data in the database.

protected saveInsert([array<string|int, mixed> $values = [] ]) : bool
Parameters
$values : array<string|int, mixed> = []
Return values
bool

saveUpdate()

Update the model data in the database.

protected saveUpdate([array<string|int, mixed> $values = [] ]) : bool
Parameters
$values : array<string|int, mixed> = []
Return values
bool

setPreviousData()

Saves previous values.

protected setPreviousData([array<string|int, mixed> $fields = [] ]) : mixed
Parameters
$fields : array<string|int, mixed> = []
Return values
mixed

toolBox()

Returns a new instance of the ToolBox class.

protected static toolBox() : ToolBox
Tags
deprecated

since version 2023.1

Return values
ToolBox

checkTable()

Checks and updates the structure of the table if necessary.

private checkTable() : bool
Return values
bool

getBoolValueForField()

Returns the boolean value for the field.

private getBoolValueForField(array<string|int, mixed> $field, mixed $value) : bool|null
Parameters
$field : array<string|int, mixed>
$value : mixed
Return values
bool|null

getFloatValueForField()

Returns the float value for the field.

private getFloatValueForField(array<string|int, mixed> $field, string $value) : float|null
Parameters
$field : array<string|int, mixed>
$value : string
Return values
float|null

getIntegerValueForField()

Returns the integer value by controlling special cases for the PK and FK.

private getIntegerValueForField(array<string|int, mixed> $field, string $value) : int|null
Parameters
$field : array<string|int, mixed>
$value : string
Return values
int|null

getOrderBy()

Convert an array of filters order by in string.

private static getOrderBy(array<string|int, mixed> $order) : string
Parameters
$order : array<string|int, mixed>
Return values
string

getRecord()

Read the record whose primary column corresponds to the value $cod or the first that meets the indicated condition.

private getRecord(string $code[, array<string|int, mixed> $where = [] ][, array<string|int, mixed> $order = [] ]) : array<string|int, mixed>
Parameters
$code : string
$where : array<string|int, mixed> = []
$order : array<string|int, mixed> = []
Return values
array<string|int, mixed>

Search results