ContainerRepository
extends BaseRepository
in package
ContainerRepository
This class was generated by the Doctrine ORM. Add your own custom repository methods below.
Table of Contents
Constants
- deliveryMethodeSqlCondition = ["TRUSK" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'TRUSK'", "ecoIdf" => " (s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'ECO_IDF'", "etageIDF" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and (spp.real_shipping_method = 'ETAGE_IDF' or spp.real_shipping_method ='LIVRAISON_ETAGE')", "CHRONOPOST" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'CHRONOPOST'", "EXPRESS_CALBERSON" => "(s.shipping_country_id NOT IN ('IT','DE') and s.store_id = 3 ) and spp.real_shipping_method = 'EXPRESS_CALBERSON'", "it" => " s.store_id = 14 AND s.shipping_country_id = 'IT'", "german" => " s.store_id = 2 AND s.shipping_country_id = 'DE'", "ecoPrevote" => " spp.real_shipping_method = 'ECO_PREVOTE'", "ecoTdl" => " spp.real_shipping_method = 'ECO_TDL'", "gls" => " spp.real_shipping_method = 'GLS'", "tamdis" => " spp.real_shipping_method = 'TAMDIS'", "tamdisEtage" => " spp.real_shipping_method = 'TAMDIS_ETAGE'", "vir" => " spp.real_shipping_method = 'VIR'", "virBasImmeuble" => " spp.real_shipping_method = 'VIR_BAS_IMMEUBLE'", "meublePromo" => " s.source = 'MeublePromo'"]
- PDO_EXCEPTION_INTEGRITY_CONSTRAINT_VIOLATION = '23000'
- PDO Exception Integrity constraint violation
- PDO_EXCEPTION_UNIQUE_VIOLATION = '23505'
- PDO Exception Unique violation
Methods
- delete() : mixed
- Removes an entity
- findAll() : Collection
- Find all
- findById() : Entity
- Finds an entity by the identifier(s)
- getDispatchDataByContainer() : array<string|int, mixed>
- getSaleProductAsirGroup() : array<string|int, mixed>|float|int|string
- getSaleProductsToPrintByContainer() : array<string|int, mixed>|int|string
- insert() : mixed
- Inserts an entity
- queryFindAll() : QueryBuilder
- Find all in query
- save() : void
- Save an entity
- search() : mixed
- update() : mixed
- Updates an entity
Constants
deliveryMethodeSqlCondition
public
mixed
deliveryMethodeSqlCondition
= ["TRUSK" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'TRUSK'", "ecoIdf" => " (s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'ECO_IDF'", "etageIDF" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and (spp.real_shipping_method = 'ETAGE_IDF' or spp.real_shipping_method ='LIVRAISON_ETAGE')", "CHRONOPOST" => "(s.shipping_country_id NOT IN ('IT','DE') or s.store_id = 3) and spp.real_shipping_method = 'CHRONOPOST'", "EXPRESS_CALBERSON" => "(s.shipping_country_id NOT IN ('IT','DE') and s.store_id = 3 ) and spp.real_shipping_method = 'EXPRESS_CALBERSON'", "it" => " s.store_id = 14 AND s.shipping_country_id = 'IT'", "german" => " s.store_id = 2 AND s.shipping_country_id = 'DE'", "ecoPrevote" => " spp.real_shipping_method = 'ECO_PREVOTE'", "ecoTdl" => " spp.real_shipping_method = 'ECO_TDL'", "gls" => " spp.real_shipping_method = 'GLS'", "tamdis" => " spp.real_shipping_method = 'TAMDIS'", "tamdisEtage" => " spp.real_shipping_method = 'TAMDIS_ETAGE'", "vir" => " spp.real_shipping_method = 'VIR'", "virBasImmeuble" => " spp.real_shipping_method = 'VIR_BAS_IMMEUBLE'", "meublePromo" => " s.source = 'MeublePromo'"]
PDO_EXCEPTION_INTEGRITY_CONSTRAINT_VIOLATION
PDO Exception Integrity constraint violation
public
mixed
PDO_EXCEPTION_INTEGRITY_CONSTRAINT_VIOLATION
= '23000'
PDO_EXCEPTION_UNIQUE_VIOLATION
PDO Exception Unique violation
public
mixed
PDO_EXCEPTION_UNIQUE_VIOLATION
= '23505'
Methods
delete()
Removes an entity
public
delete(Entity $entity) : mixed
Parameters
- $entity : Entity
-
The entity to remove
Tags
findAll()
Find all
public
findAll([array<string|int, mixed> $parameters = array() ]) : Collection
Parameters
- $parameters : array<string|int, mixed> = array()
-
Parameters
Return values
CollectionfindById()
Finds an entity by the identifier(s)
public
findById(Entity $entity) : Entity
Parameters
- $entity : Entity
-
The entity to find
Return values
Entity —The entity
getDispatchDataByContainer()
public
getDispatchDataByContainer(mixed $idProduct, mixed $idContainer, mixed $groupByProduct, mixed $warehouse) : array<string|int, mixed>
Parameters
- $idProduct : mixed
- $idContainer : mixed
- $groupByProduct : mixed
- $warehouse : mixed
Tags
Return values
array<string|int, mixed>getSaleProductAsirGroup()
public
getSaleProductAsirGroup() : array<string|int, mixed>|float|int|string
Return values
array<string|int, mixed>|float|int|stringgetSaleProductsToPrintByContainer()
public
getSaleProductsToPrintByContainer(mixed $idContainer, mixed $warehouse[, mixed $groupByProduct = true ]) : array<string|int, mixed>|int|string
Parameters
- $idContainer : mixed
- $warehouse : mixed
- $groupByProduct : mixed = true
Return values
array<string|int, mixed>|int|stringinsert()
Inserts an entity
public
insert(Entity $entity) : mixed
Parameters
- $entity : Entity
-
The entity to insert
Tags
queryFindAll()
Find all in query
public
queryFindAll([array<string|int, mixed> $parameters = array() ]) : QueryBuilder
Parameters
- $parameters : array<string|int, mixed> = array()
-
Parameters
Return values
QueryBuildersave()
Save an entity
public
save(Entity $entity) : void
Parameters
- $entity : Entity
-
An entity that i want saved
search()
public
search(mixed $data[, mixed $page = 0 ][, mixed $max = NULL ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = NULL
- $getResult : mixed = true
update()
Updates an entity
public
update(Entity $entity) : mixed
Parameters
- $entity : Entity
-
The entity to update