Logidav Docs

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
throws
NonExistingObjectException

An NonExistingObjectException if the entity does not exist

findAll()

Find all

public findAll([array<string|int, mixed> $parameters = array() ]) : Collection
Parameters
$parameters : array<string|int, mixed> = array()

Parameters

Return values
Collection

findById()

Finds an entity by the identifier(s)

public findById(Entity $entity) : Entity
Parameters
$entity : Entity

The entity to find

Return values
Entity

The entity

findByShippedAtTodayMinus15Days()

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

findItemBySource()

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|string

getFullSQL()

Get SQL from query

public getFullSQL(Query $query) : int
Parameters
$query : Query
Return values
int

getGroupTransporter()

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
throws
NoResultException
throws
NonUniqueResultException
Return values
int|mixed|string

getNbrSales()

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|string

getQtyProduct()

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|string

getSaleProductByTracking()

Get Sale products by tracking

public getSaleProductByTracking(mixed $trackingId) : mixed
Parameters
$trackingId : mixed
Tags
throws
DBALException

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|string

getSaleProductsPromoOnNullRepo()

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

insert()

Inserts an entity

public insert(Entity $entity) : mixed
Parameters
$entity : Entity

The entity to insert

Tags
throws
ExistingObjectException

An ExistingObjectException if the entity already exists

throws
PDOException

PDO Exception

queryFindAll()

Find all in query

public queryFindAll([array<string|int, mixed> $parameters = array() ]) : QueryBuilder
Parameters
$parameters : array<string|int, mixed> = array()

Parameters

Return values
QueryBuilder

save()

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
Paginator

searchShippedChronopost()

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
throws
NonExistingObjectException

An NonExistingObjectException if the entity does not exist

throws
ExistingObjectException

An ExistingObjectException if the entity is already exist in database


        
On this page

Search results