FacturaScripts

Producto extends ModelClass Uses ModelTrait, TaxRelationTrait

Stores the data of an article.

Table of Contents

ROUND_DECIMALS 5
$actualizado Date when this product was updated. string
$bloqueado True => the articles are locked / obsolete. bool
$codfabricante Code of the manufacturer to which it belongs. In the manufacturer class. string
$codfamilia Code of the family to which it belongs. In the family class. string
$codsubcuentacom Sub-account code for purchases. string
$codsubcuentairpfcom Code for the shopping sub-account, but with IRPF. string
$codsubcuentaven Sub-account code for sales. string
$descripcion Description of the product. string
$fechaalta Date on which the product was registered. string
$idproducto Primary key. int
$nostock True -> do not control the stock. bool
$observaciones Observations of the article. string
$precio Price of the item, without taxes. float|int
$publico True -> will be synchronized with the online store. bool
$referencia Main product reference or SKU. string
$secompra True => the item is purchased. bool
$sevende True => the item is sold. bool
$stockfis Physical stock. float|int
$ventasinstock True -> allow sales without stock. bool
$fields List of fields in the table. array
$codimpuesto Tax identifier of the tax assigned. string
$taxes Containt all avaliable taxes. \FacturaScripts\Dinamic\Model\Impuesto[]
$checkedTables List of already tested tables. array
$dataBase It provides direct access to the database. DataBase
clear() Reset the values of all model properties. mixed
getVariants() \FacturaScripts\Core\Model\Variante[]
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. string
priceWithTax() float
primaryColumn() Returns the name of the column that is the model's primary key. string
primaryDescriptionColumn() Returns the name of the column that describes the model, such as name, description. string
setPriceWithTax() mixed
tableName() Returns the name of the table that uses this model. string
test() Returns True if the article's data is correct. bool
update() Updated product price or reference if any change in variants. mixed
saveInsert() Insert the model data in the database. bool
getModelFields() Returns the list of fields in the table. array
modelClassName() Returns the name of the class of the model. string
modelName() Returns the name of the model. string
loadModelFields() Loads table fields if is necessary. mixed
getTax() Returns the current tax or the default one Impuesto
all() Returns all models that correspond to the selected filters. static[]
codeModelAll() Allows to use this model as source in CodeModel special model. \FacturaScripts\Dinamic\Model\CodeModel[]
codeModelSearch() Allows to use this model as source in CodeModel special model. \FacturaScripts\Dinamic\Model\CodeModel[]
count() Returns the number of records in the model that meet the condition. int
delete() Remove the model data from the database. bool
exists() Returns true if the model data is stored in the database. bool
get() Returns the model whose primary column corresponds to the value $cod static|bool
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. bool
newCode() Returns the following code for the reported field or the primary key of the model. int
primaryDescriptionColumn() Returns the name of the column that describes the model, such as name, description. string
primaryDescription() Descriptive identifier for humans of the data record string
save() Stores the model data in the database. bool
test() Returns true if there are no errors in the values of the model properties. bool
url() Returns the url where to see / modify the data. string
saveInsert() Insert the model data in the database. bool
saveUpdate() Update the model data in the database. bool
getOrderBy() Convert an array of filters order by in string. string
getRecord() Read the record whose primary column corresponds to the value $cod or the first that meets the indicated condition. array
addExtension() Adds an extension to this model. mixed
pipe() Executes all $name methods added from the extensions. mixed
primaryColumn() Returns the name of the column that is the model's primary key. string
tableName() Returns the name of the table that uses this model. string
__construct() ModelClass constructor. mixed
changePrimaryColumnValue() Change the value of the primary column in the model and the database. bool
clear() Reset the values of all model properties. 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. string
loadFromData() Assign the values of the $data array to the model properties. mixed
primaryColumnValue() Returns the current value of the main column of the model. mixed
toArray() Returns an array with the model fields values. array
checkTable() Checks and updates the structure of the table if necessary. bool
getBoolValueForField() Returns the boolean value for the field. bool|null
getFloatValueForField() Returns the float value for the field. float|null
getIntergerValueForField() Returns the integer value by controlling special cases for the PK and FK. int|null
toolBox() ToolBox

Constants

ROUND_DECIMALS

mixed $ROUND_DECIMALS = 5

DATETIME_STYLE

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

Properties

$actualizado

Date when this product was updated.

public string $actualizado

$bloqueado

True => the articles are locked / obsolete.

public bool $bloqueado

$codfabricante

Code of the manufacturer to which it belongs. In the manufacturer class.

public string $codfabricante

$codfamilia

Code of the family to which it belongs. In the family class.

public string $codfamilia

$codsubcuentacom

Sub-account code for purchases.

public string $codsubcuentacom

$codsubcuentairpfcom

Code for the shopping sub-account, but with IRPF.

public string $codsubcuentairpfcom

$codsubcuentaven

Sub-account code for sales.

public string $codsubcuentaven

$descripcion

Description of the product.

public string $descripcion

$fechaalta

Date on which the product was registered.

public string $fechaalta

$idproducto

Primary key.

public int $idproducto

$nostock

True -> do not control the stock.

public bool $nostock
Activating it implies putting True $ventasinstock;

$observaciones

Observations of the article.

public string $observaciones

$precio

Price of the item, without taxes.

public float|int $precio

$publico

True -> will be synchronized with the online store.

public bool $publico

$referencia

Main product reference or SKU.

public string $referencia

$secompra

True => the item is purchased.

public bool $secompra

$sevende

True => the item is sold.

public bool $sevende

$stockfis

Physical stock.

public float|int $stockfis

$ventasinstock

True -> allow sales without stock.

public bool $ventasinstock

$fields

List of fields in the table.

protected static array $fields = []

$codimpuesto

Tax identifier of the tax assigned.

public string $codimpuesto

$taxes

Containt all avaliable taxes.

private static \FacturaScripts\Dinamic\Model\Impuesto[] $taxes = []

$checkedTables

List of already tested tables.

private static array $checkedTables = []

$dataBase

It provides direct access to the database.

protected static DataBase $dataBase

Methods

clear()

Reset the values of all model properties.

public clear( ) : mixed
Return values
mixed

getVariants()

public getVariants( ) : \FacturaScripts\Core\Model\Variante[]
Return values
\FacturaScripts\Core\Model\Variante[]

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

priceWithTax()

public priceWithTax( ) : float
Return values
float

primaryColumn()

Returns the name of the column that is the model's primary key.

public static primaryColumn( ) : 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

setPriceWithTax()

public setPriceWithTax( $price : float ) : mixed
Parameters
$price : float
Return values
mixed

tableName()

Returns the name of the table that uses this model.

public static tableName( ) : string
Return values
string

test()

Returns True if the article's data is correct.

public test( ) : bool

It runs inside the save method.

Return values
bool

update()

Updated product price or reference if any change in variants.

public update( ) : mixed
Return values
mixed

saveInsert()

Insert the model data in the database.

protected saveInsert( [ $values : array = [] ] ) : bool
Parameters
$values : array = []
Return values
bool

getModelFields()

Returns the list of fields in the table.

public abstract getModelFields( ) : array
Return values
array

modelClassName()

Returns the name of the class of the model.

public abstract modelClassName( ) : string
Return values
string

modelName()

Returns the name of the model.

protected abstract modelName( ) : string
Return values
string

loadModelFields()

Loads table fields if is necessary.

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

all()

Returns all models that correspond to the selected filters.

public all( [ $where : array = [] ] [, $order : array = [] ] , $offset : int [, $limit : int = 50 ] ) : static[]
Parameters
$where : array = []

filters to apply to model records.

$order : array = []

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

$offset : int
$limit : int = 50
Return values
static[]

codeModelAll()

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

public codeModelAll( [ $fieldCode : string = '' ] ) : \FacturaScripts\Dinamic\Model\CodeModel[]
Parameters
$fieldCode : string = ''
Return values
\FacturaScripts\Dinamic\Model\CodeModel[]

codeModelSearch()

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

public codeModelSearch( $query : string [, $fieldCode : string = '' ] [, $where : \FacturaScripts\Core\Base\DataBase\DataBaseWhere[] = [] ] ) : \FacturaScripts\Dinamic\Model\CodeModel[]
Parameters
$query : string
$fieldCode : string = ''
$where : \FacturaScripts\Core\Base\DataBase\DataBaseWhere[] = []
Return values
\FacturaScripts\Dinamic\Model\CodeModel[]

count()

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

public count( [ $where : \FacturaScripts\Core\Base\DataBase\DataBaseWhere[] = [] ] ) : int
Parameters
$where : \FacturaScripts\Core\Base\DataBase\DataBaseWhere[] = []

filters to apply to model records.

Return values
int

delete()

Remove the model data from the database.

public delete( ) : bool
Return values
bool

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( $code : string ) : static|bool
Parameters
$code : string
Return values
static|bool

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( $code : string [, $where : array = [] ] [, $orderby : array = [] ] ) : 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 = []
$orderby : array = []
Return values
bool

newCode()

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

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

primaryDescriptionColumn()

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

public primaryDescriptionColumn( ) : string

..

Return values
string

primaryDescription()

Descriptive identifier for humans of the data record

public primaryDescription( ) : string
Return values
string

save()

Stores the model data in the database.

public save( ) : bool
Return values
bool

test()

Returns true if there are no errors in the values of the model properties.

public test( ) : bool

It runs inside the save method.

Return values
bool

url()

Returns the url where to see / modify the data.

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

saveInsert()

Insert the model data in the database.

protected saveInsert( [ $values : array = [] ] ) : bool
Parameters
$values : array = []
Return values
bool

saveUpdate()

Update the model data in the database.

protected saveUpdate( [ $values : array = [] ] ) : bool
Parameters
$values : array = []
Return values
bool

getOrderBy()

Convert an array of filters order by in string.

private getOrderBy( $order : array ) : string
Parameters
$order : array
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( $code : string [, $where : array = [] ] [, $orderby : array = [] ] ) : array
Parameters
$code : string
$where : array = []
$orderby : array = []
Return values
array

addExtension()

Adds an extension to this model.

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

pipe()

Executes all $name methods added from the extensions.

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

primaryColumn()

Returns the name of the column that is the model's primary key.

public abstract static primaryColumn( ) : string
Return values
string

tableName()

Returns the name of the table that uses this model.

public abstract static tableName( ) : string
Return values
string

__construct()

ModelClass constructor.

public __construct( [ $data : array = [] ] ) : mixed
Parameters
$data : array = []
Return values
mixed

changePrimaryColumnValue()

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

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

clear()

Reset the values of all model properties.

public clear( ) : 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

loadFromData()

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

public loadFromData( [ $data : array = [] ] [, $exclude : array = [] ] ) : mixed
Parameters
$data : array = []
$exclude : array = []
Return values
mixed

primaryColumnValue()

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

public primaryColumnValue( ) : mixed
Return values
mixed

toArray()

Returns an array with the model fields values.

public toArray( ) : array
Return values
array

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( $field : array , $value : string ) : bool|null
Parameters
$field : array
$value : string
Return values
bool|null

getFloatValueForField()

Returns the float value for the field.

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

getIntergerValueForField()

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

private getIntergerValueForField( $field : array , $value : string ) : int|null
Parameters
$field : array
$value : string
Return values
int|null

Search results