SaleProductRepository
extends BaseRepository
in package
SaleProductRepository
This class was generated by the Doctrine ORM. Add your own custom repository methods below.
Table of Contents
Constants
- PDO_EXCEPTION_INTEGRITY_CONSTRAINT_VIOLATION = '23000'
- PDO Exception Integrity constraint violation
- PDO_EXCEPTION_UNIQUE_VIOLATION = '23505'
- PDO Exception Unique violation
Methods
- checkIsNonComplaint() : mixed
- delete() : mixed
- Removes an entity
- findAll() : Collection
- Find all
- findById() : Entity
- Finds an entity by the identifier(s)
- findByNot() : mixed
- findByShippedAtTodayMinus15Days() : array<string|int, mixed>|float|int|string
- findItemBySource() : mixed
- Get item by source
- findRetraitSaleProductsByIncrementId() : mixed
- getCanceledTruskSaleProductsByDates() : array<string|int, mixed>|int|string
- getFullSQL() : int
- Get SQL from query
- getGroupTransporter() : mixed
- getListParamsByDql() : mixed
- getNbrProductSales() : int|mixed|string
- getNbrSales() : mixed
- getProductSaledLastHour() : array<string|int, mixed>|int|string
- getQtyProduct() : mixed
- getQtyProductNoStock() : mixed
- getSaleProductAsirGroup() : array<string|int, mixed>|float|int|string
- getSaleProductByTracking() : mixed
- Get Sale products by tracking
- getSaleProductDispo() : mixed
- getSaleProductsBySaleIdsForGeodisInterface() : mixed
- getSaleProductsBySaleIdsForIdfInterface() : mixed
- getSaleProductsBySaleIdsForTamdisInterface() : mixed
- getSaleProductsProcessingNotPrintedNoStockByProductId() : array<string|int, mixed>|int|string
- getSaleProductsPromoOnNullRepo() : array<string|int, mixed>
- getSaleProductTotalVolume() : mixed
- getSaleProductTotalWeight() : mixed
- getSalesSkuStats() : mixed
- getSalesSkuStatsSql() : mixed
- getSalesSkuStatsSqlDropShip() : mixed
- getSalesStat() : mixed
- getStatByProductFamily() : mixed
- getTruskSaleProductsToShip() : mixed
- insert() : mixed
- Inserts an entity
- queryFindAll() : QueryBuilder
- Find all in query
- save() : void
- Save an entity
- searchIdfDeliveryReport() : mixed
- searchNonConformColis() : mixed
- searchProcessingNotPrintedNoStock() : mixed
- searchProductArrivalDate() : Paginator
- searchShippedChronopost() : mixed
- searchShippedGls() : mixed
- searchShippedIdf() : mixed
- searchShippedTamdis() : mixed
- searchShippedVir() : mixed
- setAsBadlyPackagedParcel() : mixed
- setAsNonComplaint() : mixed
- update() : mixed
- Updates an entity
- getParamsArray() : int
- Get query params list
Constants
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
checkIsNonComplaint()
public
checkIsNonComplaint(int $saleProductId) : mixed
Parameters
- $saleProductId : int
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
findByNot()
public
findByNot(mixed $params) : mixed
Parameters
- $params : mixed
findByShippedAtTodayMinus15Days()
public
findByShippedAtTodayMinus15Days() : array<string|int, mixed>|float|int|string
Return values
array<string|int, mixed>|float|int|stringfindItemBySource()
Get item by source
public
findItemBySource(mixed $itemId, mixed $source) : mixed
Parameters
- $itemId : mixed
- $source : mixed
findRetraitSaleProductsByIncrementId()
public
findRetraitSaleProductsByIncrementId(mixed $incrementId[, mixed $deliveryMethod = 'RETRAIT' ]) : mixed
Parameters
- $incrementId : mixed
- $deliveryMethod : mixed = 'RETRAIT'
getCanceledTruskSaleProductsByDates()
public
getCanceledTruskSaleProductsByDates(mixed $dates) : array<string|int, mixed>|int|string
Parameters
- $dates : mixed
Return values
array<string|int, mixed>|int|stringgetFullSQL()
Get SQL from query
public
getFullSQL(Query $query) : int
Parameters
- $query : Query
Return values
intgetGroupTransporter()
public
getGroupTransporter(mixed $start, mixed $end[, mixed $order = 'ASC' ]) : mixed
Parameters
- $start : mixed
- $end : mixed
- $order : mixed = 'ASC'
getListParamsByDql()
public
getListParamsByDql(mixed $dql) : mixed
Parameters
- $dql : mixed
getNbrProductSales()
public
getNbrProductSales(mixed $id) : int|mixed|string
Parameters
- $id : mixed
Tags
Return values
int|mixed|stringgetNbrSales()
public
getNbrSales(mixed $idprod, mixed $start, mixed $end) : mixed
Parameters
- $idprod : mixed
- $start : mixed
- $end : mixed
getProductSaledLastHour()
public
getProductSaledLastHour() : array<string|int, mixed>|int|string
Return values
array<string|int, mixed>|int|stringgetQtyProduct()
public
getQtyProduct(mixed $idprod, mixed $date) : mixed
Parameters
- $idprod : mixed
- $date : mixed
getQtyProductNoStock()
public
getQtyProductNoStock(mixed $idprod) : mixed
Parameters
- $idprod : mixed
getSaleProductAsirGroup()
public
getSaleProductAsirGroup() : array<string|int, mixed>|float|int|string
Return values
array<string|int, mixed>|float|int|stringgetSaleProductByTracking()
Get Sale products by tracking
public
getSaleProductByTracking(mixed $trackingId) : mixed
Parameters
- $trackingId : mixed
Tags
getSaleProductDispo()
public
getSaleProductDispo(mixed $product, mixed $availability) : mixed
Parameters
- $product : mixed
- $availability : mixed
getSaleProductsBySaleIdsForGeodisInterface()
public
getSaleProductsBySaleIdsForGeodisInterface(mixed $saleIds) : mixed
Parameters
- $saleIds : mixed
getSaleProductsBySaleIdsForIdfInterface()
public
getSaleProductsBySaleIdsForIdfInterface(mixed $saleIds) : mixed
Parameters
- $saleIds : mixed
getSaleProductsBySaleIdsForTamdisInterface()
public
getSaleProductsBySaleIdsForTamdisInterface(mixed $saleIds) : mixed
Parameters
- $saleIds : mixed
getSaleProductsProcessingNotPrintedNoStockByProductId()
public
getSaleProductsProcessingNotPrintedNoStockByProductId(mixed $productId) : array<string|int, mixed>|int|string
Parameters
- $productId : mixed
Return values
array<string|int, mixed>|int|stringgetSaleProductsPromoOnNullRepo()
public
getSaleProductsPromoOnNullRepo() : array<string|int, mixed>
Return values
array<string|int, mixed>getSaleProductTotalVolume()
public
getSaleProductTotalVolume(array<string|int, mixed> $saleProductIds) : mixed
Parameters
- $saleProductIds : array<string|int, mixed>
getSaleProductTotalWeight()
public
getSaleProductTotalWeight(array<string|int, mixed> $saleProductIds) : mixed
Parameters
- $saleProductIds : array<string|int, mixed>
getSalesSkuStats()
public
getSalesSkuStats(mixed $from, mixed $to[, mixed $manufacturer = null ][, mixed $label = null ][, mixed $sousCategory = null ]) : mixed
Parameters
- $from : mixed
- $to : mixed
- $manufacturer : mixed = null
- $label : mixed = null
- $sousCategory : mixed = null
getSalesSkuStatsSql()
public
getSalesSkuStatsSql(mixed $from, mixed $to[, mixed $manufacturer = null ][, mixed $label = null ][, mixed $sousCategory = null ]) : mixed
Parameters
- $from : mixed
- $to : mixed
- $manufacturer : mixed = null
- $label : mixed = null
- $sousCategory : mixed = null
getSalesSkuStatsSqlDropShip()
public
getSalesSkuStatsSqlDropShip(mixed $from, mixed $to[, mixed $manufacturer = null ][, mixed $label = null ][, mixed $sousCategory = null ]) : mixed
Parameters
- $from : mixed
- $to : mixed
- $manufacturer : mixed = null
- $label : mixed = null
- $sousCategory : mixed = null
getSalesStat()
public
getSalesStat(mixed $idprod, mixed $start, mixed $end) : mixed
Parameters
- $idprod : mixed
- $start : mixed
- $end : mixed
getStatByProductFamily()
public
getStatByProductFamily(mixed $idprod, mixed $parentId, mixed $start, mixed $end) : mixed
Parameters
- $idprod : mixed
- $parentId : mixed
- $start : mixed
- $end : mixed
getTruskSaleProductsToShip()
public
getTruskSaleProductsToShip() : mixed
insert()
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
searchIdfDeliveryReport()
public
searchIdfDeliveryReport(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchNonConformColis()
public
searchNonConformColis(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchProcessingNotPrintedNoStock()
public
searchProcessingNotPrintedNoStock(mixed $data[, mixed $page = 0 ][, mixed $max = NULL ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = NULL
- $getResult : mixed = true
searchProductArrivalDate()
public
searchProductArrivalDate(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : Paginator
Parameters
- $data : mixed
- $page : int = 0
- $max : null = null
- $getResult : bool = true
Return values
PaginatorsearchShippedChronopost()
public
searchShippedChronopost(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchShippedGls()
public
searchShippedGls(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchShippedIdf()
public
searchShippedIdf(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchShippedTamdis()
public
searchShippedTamdis(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
searchShippedVir()
public
searchShippedVir(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
- $data : mixed
- $page : mixed = 0
- $max : mixed = null
- $getResult : mixed = true
setAsBadlyPackagedParcel()
public
setAsBadlyPackagedParcel(string $colis, int $saleProductId) : mixed
Parameters
- $colis : string
- $saleProductId : int
setAsNonComplaint()
public
setAsNonComplaint(string $colis, int $saleProductId) : mixed
Parameters
- $colis : string
- $saleProductId : int
update()
Updates an entity
public
update(Entity $entity) : mixed
Parameters
- $entity : Entity
-
The entity to update
Tags
getParamsArray()
Get query params list
protected
getParamsArray(Parameter $paramObj) : int
Parameters
- $paramObj : Parameter