Logidav Docs

ProductRepository extends BaseRepository
in package

ProductRepository

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

addManufacturerSql()  : mixed
delete()  : mixed
Removes an entity
findAll()  : Collection
Find all
findById()  : Entity
Finds an entity by the identifier(s)
findByName()  : mixed
findBySkuString()  : mixed
findOneByIdFast()  : mixed
findOneBySkuFast()  : mixed
findOneBySql()  : mixed
findProductsForMarketingScript()  : array<string|int, mixed>|int|string
getAllNewProductForColisEan()  : void
getAllProductMenzzoForEanColis()  : mixed
getAllProducts()  : array<string|int, mixed>|float|int|string
getAllProductWithCmpOffre()  : mixed
getAllPublishProduct()  : mixed
getArriving()  : array<string|int, mixed>|int|string
getArrivingCommand()  : array<string|int, mixed>|int|mixed|string|null
getAsirGroupProducts()  : mixed
getAsirInternalStock()  : Paginator
getAsirScannedAndUndeliveredOrders()  : Paginator
getAsirStock()  : Paginator
getComposedProduct()  : mixed
getFullSQL()  : int
Get SQL from query
getLastArrived()  : mixed
getListParamsByDql()  : mixed
getMaxCoeffProductInfo()  : mixed
getNewProductsOrderedByContainerArrivalDate()  : array<string|int, mixed>
getProductLibelles()  : array<string|int, mixed>|int|string
getProductSaleTotals()  : array<string|int, mixed>
getProductsForCommands()  : mixed
getProductsForMerchantSync()  : mixed
getProductsWithAttributeSetsHigherThan72()  : array<string|int, mixed>|float|int|string
getProductWithoutDropship()  : array<string|int, mixed>|int|string
getQtyCmdProcessing()  : mixed
getQtyContenaireCmdProcessing()  : mixed
getQtyContenaireNotArrived()  : mixed
getSaleProductAsirGroup()  : array<string|int, mixed>|float|int|string
getSaleShowProducts()  : array<string|int, mixed>
Get Sale Show products
getSameSkuProducts()  : mixed
getSumArrivingCommandQty()  : array<string|int, mixed>|int|mixed|string|null
getTheLastBuyingPriceCommand()  : void
insert()  : mixed
Inserts an entity
paginateProductPricePriceProposalAction()  : Paginator
Search all products
queryFindAll()  : QueryBuilder
Find all in query
removeManufacturerSql()  : mixed
save()  : void
Save an entity
saveProductSql()  : bool
searchAlertNoCmd()  : mixed
searchAllMediaProducts()  : Paginator
Search all media products
searchAllProducts()  : Paginator
Search all products
searchAllProductsBuyingPrice()  : Paginator
Search all products
searchAllProductsForDecoPhoto()  : Paginator
searchAllProductsForNewCategories()  : Paginator
searchAllProductsForUniver()  : Paginator
searchAllProductsForUpdateCategories()  : Paginator
searchDropshipOnline()  : Paginator
searchEmplacement()  : mixed
Search Emplacement
searchEndOfPoductStock()  : mixed
searchJolipaProductStock()  : mixed
searchMenzzoProductToVirExpedition()  : Paginator
searchPoductDictionaries()  : mixed
searchProductPrice()  : mixed
Seearch product price
searchProductPurchases()  : mixed
searchProductsByNameAndManufacturer()  : array<string|int, mixed>|float|int|string
Get products by name and manufacturer id
searchProductsByNameAndSku()  : array<string|int, mixed>|float|int|string
Get products by name and SKU
searchProductsForInventory()  : array<string|int, mixed>|int|string
searchProductsForSale()  : array<string|int, mixed>|int|string
searchProductsNoStock()  : mixed
searchProductStock()  : mixed
searchProductStockValue()  : mixed
searchProductTags()  : Paginator
searchUpStairsExtraShippingByProduct()  : mixed
update()  : mixed
Updates an entity
updateSupplierInternalStock()  : void
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

addManufacturerSql()

public addManufacturerSql(mixed $data) : mixed
Parameters
$data : mixed
Tags
throws
InvalidArgumentException

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

findByName()

public findByName(mixed $name) : mixed
Parameters
$name : mixed

findBySkuString()

public findBySkuString(mixed $sku) : mixed
Parameters
$sku : mixed

findOneByIdFast()

public findOneByIdFast(mixed $id) : mixed
Parameters
$id : mixed

findOneBySkuFast()

public findOneBySkuFast(mixed $sku) : mixed
Parameters
$sku : mixed

findOneBySql()

public findOneBySql(mixed $criteria) : mixed
Parameters
$criteria : mixed
Tags
throws
DBALException

findProductsForMarketingScript()

public findProductsForMarketingScript([mixed $query = null ]) : array<string|int, mixed>|int|string
Parameters
$query : mixed = null
Return values
array<string|int, mixed>|int|string

getAllProductMenzzoForEanColis()

public getAllProductMenzzoForEanColis() : mixed

getAllProducts()

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

getArriving()

public getArriving(mixed $productId) : array<string|int, mixed>|int|string
Parameters
$productId : mixed
Return values
array<string|int, mixed>|int|string

getArrivingCommand()

public getArrivingCommand(mixed $productId[, mixed $all = false ]) : array<string|int, mixed>|int|mixed|string|null
Parameters
$productId : mixed
$all : mixed = false
Tags
throws
NonUniqueResultException
Return values
array<string|int, mixed>|int|mixed|string|null

getAsirGroupProducts()

public getAsirGroupProducts(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

getAsirInternalStock()

public getAsirInternalStock(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : Paginator
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true
Return values
Paginator

getAsirScannedAndUndeliveredOrders()

public getAsirScannedAndUndeliveredOrders(mixed $data[, mixed $start = 0 ][, mixed $max = null ][, mixed $getResult = true ][, mixed $viewAllStatuses = false ]) : Paginator
Parameters
$data : mixed
$start : mixed = 0
$max : mixed = null
$getResult : mixed = true
$viewAllStatuses : mixed = false
Return values
Paginator

getAsirStock()

public getAsirStock(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : Paginator
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true
Return values
Paginator

getComposedProduct()

public getComposedProduct(mixed $sku) : mixed
Parameters
$sku : mixed

getFullSQL()

Get SQL from query

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

getLastArrived()

public getLastArrived(mixed $productId) : mixed
Parameters
$productId : mixed

getListParamsByDql()

public getListParamsByDql(mixed $dql) : mixed
Parameters
$dql : mixed

getMaxCoeffProductInfo()

public getMaxCoeffProductInfo(mixed $id) : mixed
Parameters
$id : mixed

getNewProductsOrderedByContainerArrivalDate()

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

getProductLibelles()

public getProductLibelles([mixed $dropship = false ]) : array<string|int, mixed>|int|string
Parameters
$dropship : mixed = false
Return values
array<string|int, mixed>|int|string

getProductSaleTotals()

public getProductSaleTotals([int $months = 2 ]) : array<string|int, mixed>
Parameters
$months : int = 2
Return values
array<string|int, mixed>

getProductsForCommands()

public getProductsForCommands([mixed $manufacturer = null ]) : mixed
Parameters
$manufacturer : mixed = null

getProductsForMerchantSync()

public getProductsForMerchantSync(mixed $filters, mixed $storeId, mixed $offset, mixed $limit) : mixed
Parameters
$filters : mixed
$storeId : mixed
$offset : mixed
$limit : mixed

getProductsWithAttributeSetsHigherThan72()

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

getProductWithoutDropship()

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

getQtyCmdProcessing()

public getQtyCmdProcessing(mixed $idprod) : mixed
Parameters
$idprod : mixed

getQtyContenaireCmdProcessing()

public getQtyContenaireCmdProcessing(mixed $idprod) : mixed
Parameters
$idprod : mixed

getQtyContenaireNotArrived()

public getQtyContenaireNotArrived(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

getSaleShowProducts()

Get Sale Show products

public getSaleShowProducts(Sale $sale) : array<string|int, mixed>
Parameters
$sale : Sale
Tags
todo

remove me and use ajax instead

Return values
array<string|int, mixed>

getSumArrivingCommandQty()

public getSumArrivingCommandQty(mixed $productId) : array<string|int, mixed>|int|mixed|string|null
Parameters
$productId : mixed
Tags
throws
NonUniqueResultException
Return values
array<string|int, mixed>|int|mixed|string|null

getTheLastBuyingPriceCommand()

public getTheLastBuyingPriceCommand(mixed $id) : void
Parameters
$id : 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

paginateProductPricePriceProposalAction()

Search all products

public paginateProductPricePriceProposalAction(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

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

removeManufacturerSql()

public removeManufacturerSql(mixed $data) : mixed
Parameters
$data : mixed
Tags
throws
InvalidArgumentException

save()

Save an entity

public save(Entity $entity) : void
Parameters
$entity : Entity

An entity that i want saved

saveProductSql()

public saveProductSql(mixed $data) : bool
Parameters
$data : mixed
Tags
throws
DBALException
Return values
bool

searchAlertNoCmd()

public searchAlertNoCmd(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchAllMediaProducts()

Search all media products

public searchAllMediaProducts(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProducts()

Search all products

public searchAllProducts(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProductsBuyingPrice()

Search all products

public searchAllProductsBuyingPrice(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProductsForDecoPhoto()

public searchAllProductsForDecoPhoto(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProductsForNewCategories()

public searchAllProductsForNewCategories(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProductsForUniver()

public searchAllProductsForUniver(mixed $data[, int $page = 0 ][, null $max = null ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
Return values
Paginator

searchAllProductsForUpdateCategories()

public searchAllProductsForUpdateCategories(mixed $data[, mixed $page = 0 ][, mixed $max = null ]) : Paginator
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
Return values
Paginator

searchDropshipOnline()

public searchDropshipOnline(mixed $data[, int $page = 0 ][, mixed $limit = null ], mixed $dropshipName) : Paginator
Parameters
$data : mixed
$page : int = 0
$limit : mixed = null
$dropshipName : mixed
Return values
Paginator

searchEmplacement()

Search Emplacement

public searchEmplacement(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : mixed
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true

searchEndOfPoductStock()

public searchEndOfPoductStock(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchJolipaProductStock()

public searchJolipaProductStock(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchMenzzoProductToVirExpedition()

public searchMenzzoProductToVirExpedition(mixed $data[, int $page = 0 ][, mixed $limit = NULL ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$limit : mixed = NULL
Return values
Paginator

searchPoductDictionaries()

public searchPoductDictionaries(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchProductPrice()

Seearch product price

public searchProductPrice(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : mixed
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true

searchProductPurchases()

public searchProductPurchases(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchProductsByNameAndManufacturer()

Get products by name and manufacturer id

public searchProductsByNameAndManufacturer(mixed $name, mixed $manufacturerId) : array<string|int, mixed>|float|int|string
Parameters
$name : mixed
$manufacturerId : mixed
Return values
array<string|int, mixed>|float|int|string

searchProductsByNameAndSku()

Get products by name and SKU

public searchProductsByNameAndSku(mixed $term) : array<string|int, mixed>|float|int|string
Parameters
$term : mixed
Return values
array<string|int, mixed>|float|int|string

searchProductsForInventory()

public searchProductsForInventory([null $query = null ][, int $all = 0 ]) : array<string|int, mixed>|int|string
Parameters
$query : null = null
$all : int = 0
Return values
array<string|int, mixed>|int|string

searchProductsForSale()

public searchProductsForSale([mixed $query = null ][, mixed $type = null ][, mixed $termToSkip = null ]) : array<string|int, mixed>|int|string
Parameters
$query : mixed = null
$type : mixed = null
$termToSkip : mixed = null
Return values
array<string|int, mixed>|int|string

searchProductsNoStock()

public searchProductsNoStock(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchProductStock()

public searchProductStock(mixed $data[, mixed $page = 0 ][, mixed $max = NULL ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = NULL
$getResult : mixed = true

searchProductStockValue()

public searchProductStockValue(mixed $data[, mixed $page = 0 ][, mixed $max = null ][, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$page : mixed = 0
$max : mixed = null
$getResult : mixed = true

searchProductTags()

public searchProductTags(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

searchUpStairsExtraShippingByProduct()

public searchUpStairsExtraShippingByProduct(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

Tags
throws
NonExistingObjectException

An NonExistingObjectException if the entity does not exist

throws
ExistingObjectException

An ExistingObjectException if the entity is already exist in database

updateSupplierInternalStock()

public updateSupplierInternalStock(Product $product, int $newQty, string $action, string $msg, User $user) : void
Parameters
$product : Product
$newQty : int
$action : string
$msg : string
$user : User

getParamsArray()

Get query params list

protected getParamsArray(Parameter $paramObj) : int
Parameters
$paramObj : Parameter
Tags
author

Yosef Kaminskyi yosefk@spotoption.com

Return values
int 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results