Logidav Docs

SaleRepository extends SaleRepository

FinalYes

Class SaleRepository

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

amazonScannedOrders()  : mixed
calendarByTransporter()  : mixed
delete()  : mixed
Removes an entity
findAll()  : Collection
Find all
findAllSaleList()  : mixed
findAllSaleListSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
findAllSaleListSqlCount()  : array<string|int, mixed>|bool|string
Get all sale list with sql
findAsirSummaryReportSaleListSql()  : array<string|int, mixed>|bool|string
Get Asir report
findById()  : Entity
Finds an entity by the identifier(s)
findByNot()  : mixed
findSaleById()  : float|int|mixed|string|null
Find sale by id
findSalesByIds()  : array<string|int, mixed>|float|int|string
Find sales by ids
findSalesUpdated()  : array<string|int, mixed>|int|string
findSalesWithSaleProductsAndProductsByIds()  : array<string|int, mixed>|float|int|string
Find sales by ids
findSpecificSales()  : mixed
getAllCompletSalesEspange()  : array<string|int, mixed>|float|int|string
getAllCouponCode()  : mixed
getAllInvoicedEdenRedOrders()  : void
getAllSaleForShippingAmountFrom()  : array<string|int, mixed>|int|string
getAllSalesToPrint()  : mixed
Get All sales
getAsirSaleProducts()  : array<string|int, mixed>
getCalbersonOrdersForPrint()  : mixed
getCartCheckOrder()  : mixed
getCartSendSmsCheckOrder()  : mixed
getChronopostOrdersForPrint()  : mixed
getCountAmazonShippingNotPrinted()  : mixed
getCountEspagneShippingNotPrinted()  : mixed
getCountShippingNotPrinted()  : mixed
getCountStoreNotPrinted()  : mixed
getCyfeSaleStat()  : mixed
getFullSQL()  : int
Get SQL from query
getGlsSalesToGenerateTicketsFor()  : array<string|int, mixed>|float|int|string
getIdfSalesToGenerateTicketsFor()  : array<string|int, mixed>|float|int|string
getLastId()  : mixed
Get Last sale id
getLastSaleDate()  : mixed
getLastSaleDropShipDate()  : int|mixed|string
getLengowSalesHavingApiShipError()  : mixed
getLengowSalesShippedButProcessing()  : mixed
getListParamsByDql()  : mixed
getNotioSaleProducts()  : array<string|int, mixed>
getOldRetrait()  : mixed
getOrdersByRange()  : mixed
getPaylinePaymentStats()  : mixed
getPaymentStat()  : mixed
getProcessingSalesForCheckAndFix()  : array<string|int, mixed>|int|string
getRetraitSalesToPrint()  : array<string|int, mixed>|int|string
getSaleByNumberAccountBankAndCreatedAtAndGrandTotal()  : mixed
getSaleByUser()  : mixed
getSaleProductAsirGroup()  : array<string|int, mixed>|float|int|string
getSalesShippingReport()  : mixed
getSalesStats()  : mixed
getSalesStatsDropShip()  : mixed
getSalesStatsForDashboard()  : mixed
Get sales stats
getSalesWithMoreThanOneProduct()  : mixed
Get sales with more than one product
getSalesWithOneSaleProductGroupedByEmplacementToPrint()  : mixed
Get sales with more than one product grouped by Emplacement
getSalesWithOneSaleProductGroupedByLabelToPrint()  : mixed
Get sales with more than one product grouped by label
getSalesWithOneSaleProductToPrintGroupedBySku()  : mixed
Get sales with more than one product
getSdenOrdersForPrint()  : mixed
getShipmentCreatedAtFromLog()  : mixed
Get Shipment created at from log
getShippedCalberson()  : array<string|int, mixed>
Get Shipped with calberson
getShippedChronopost()  : array<string|int, mixed>
Get shipped chronopost in the last 8 months
getStatistiqueNbrPaymentAlma()  : mixed
getTamdisSalesToGenerateTicketsFor()  : array<string|int, mixed>|float|int|string
getTruskSalesForTrusker()  : array<string|int, mixed>
getTruskSalesRdvByRange()  : array<string|int, mixed>|int|string
getTruskSalesToExport()  : Query
Trusk sles to export
getTruskSalesToNotify()  : array<string|int, mixed>|int|string
getTruskSalesToPrint()  : array<string|int, mixed>|int|string
getTruskSalesToPrintV2()  : array<string|int, mixed>
getTruskSalesToSend()  : array<string|int, mixed>|int|string
getTruskSalesToShip()  : array<string|int, mixed>|int|string
getUrgentSalesToPrint()  : mixed
Get urgent sales
getVirSalesToGenerateTicketsFor()  : array<string|int, mixed>|float|int|string
getWaitingStoreAcceptanceSales()  : mixed
insert()  : mixed
Inserts an entity
paginateAllDropSales()  : Paginator
Paginate all drop sales
queryFindAll()  : QueryBuilder
Find all in query
salesByDate()  : mixed
save()  : void
Save an entity
search()  : mixed
searchAllApiShoppingSalesSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
searchAllGoogleSalesSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
searchAllLengowSalesSql()  : array<string|int, mixed>|bool|string
Get all Lengow sales
searchAllSalesSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
searchAllShopdecoSalesSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
searchApiShoppingInvoicedSales()  : Paginator
Search Shopdeco invoiced sales
searchApiShoppingPending()  : Paginator
Search for pending invoice sales
searchFull()  : mixed
searchIdfPlanning()  : mixed
searchIdfPlanningPdf()  : mixed
searchIdfSalesToValidate()  : mixed
searchIdfTransporter()  : mixed
searchInvoicedSales()  : Paginator
Search Lengow invoiced sales
searchLengowPendingInvoices()  : Paginator
Search lengow pending invoice
searchOrdersUpdated()  : mixed
searchPendingApiShoppingSales()  : Paginator
Search pending apiShoping Sales
searchPendingGoogleSales()  : Paginator
Search pending Google Sales
searchPendingLengowSales()  : Paginator
Search pending Lengow Sales
searchPendingPayment()  : Paginator
searchPendingSales()  : Paginator
Search pending Sales
searchPendingShopdecoSales()  : Paginator
Search pending Shopdeco Sales
searchProcessingNotPrinted()  : mixed
searchProcessingOldRetrait()  : mixed
searchProcessingRetraitNew()  : mixed
searchProcessingRetraitNotPrinted()  : mixed
searchRecapCommandesMarketplaces()  : mixed
searchReconciliationOfPaymentsSaleList()  : Paginator
Get all sale list
searchSaleDropInvoiced()  : mixed
searchSaleDropPending()  : mixed
searchSaleSendExpedition()  : mixed
searchSalesForPrintInvoices()  : array<string|int, mixed>|int|string
Search for sales to print
searchScanedIdfSales()  : Paginator
searchShippedCalberson()  : mixed
searchShippedChronopost()  : mixed
searchShippedGoogleSales()  : Paginator
Search Shipped Google Sales
searchShippedLengowSales()  : Paginator
Search Shipped Lengow Sales
searchShippedPendingInvoice()  : Paginator
Search for shipped pending invoice sales
searchShippedSden()  : Paginator
searchShippedShopdecoSales()  : Paginator
Search Shipped Shopdeco Sales
searchShopdecoInvoicedSales()  : Paginator
Search Shopdeco invoiced sales
searchShopdecoPending()  : Paginator
Search for pending invoice sales
searchShopdecoSaleErrorsSql()  : array<string|int, mixed>|bool|string
Get all sale list with sql
searchSpainShipment()  : mixed
searchStock0Scans()  : Paginator
searchTrusk()  : mixed
searchUpStairsPlanning()  : mixed
searchUpStairsTransporter()  : mixed
Get UpStairs Transporter
searchVir()  : mixed
searchVirAsir()  : mixed
sumShipping()  : mixed
update()  : mixed
Updates an entity
getParamsArray()  : int
Get query params list
getCustomConditionsForSalePrint()  : string
Custom conditions for sale print

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

amazonScannedOrders()

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

calendarByTransporter()

public calendarByTransporter(mixed $data) : mixed
Parameters
$data : mixed

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

findAllSaleList()

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

findAllSaleListSql()

Get all sale list with sql

public findAllSaleListSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ][, mixed $filterSales = null ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
$filterSales : mixed = null
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

findAllSaleListSqlCount()

Get all sale list with sql

public findAllSaleListSqlCount(mixed $filters[, mixed $filterSales = null ]) : array<string|int, mixed>|bool|string
Parameters
$filters : mixed
$filterSales : mixed = null
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

findAsirSummaryReportSaleListSql()

Get Asir report

public findAsirSummaryReportSaleListSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ][, null $filterSales = null ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
$filterSales : null = null
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

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

findByNot()

public findByNot(mixed $params) : mixed
Parameters
$params : mixed

findSaleById()

Find sale by id

public findSaleById(mixed $saleId) : float|int|mixed|string|null
Parameters
$saleId : mixed
Tags
throws
NonUniqueResultException
Return values
float|int|mixed|string|null

findSalesByIds()

Find sales by ids

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

findSalesUpdated()

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

findSalesWithSaleProductsAndProductsByIds()

Find sales by ids

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

getAllCompletSalesEspange()

public getAllCompletSalesEspange(mixed $from, mixed $to) : array<string|int, mixed>|float|int|string
Parameters
$from : mixed
$to : mixed
Return values
array<string|int, mixed>|float|int|string

getAllInvoicedEdenRedOrders()

public getAllInvoicedEdenRedOrders(mixed $rangeDate, mixed $accountId) : void
Parameters
$rangeDate : mixed
$accountId : mixed

getAllSaleForShippingAmountFrom()

public getAllSaleForShippingAmountFrom(mixed $from, mixed $to) : array<string|int, mixed>|int|string
Parameters
$from : mixed
$to : mixed
Return values
array<string|int, mixed>|int|string

getAllSalesToPrint()

Get All sales

public getAllSalesToPrint(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed

getAsirSaleProducts()

public getAsirSaleProducts(mixed $page[, mixed $lastMenzzoOrderNumber = null ][, mixed $dateFrom = null ][, mixed $dateTo = null ][, mixed $orderNumber = null ]) : array<string|int, mixed>
Parameters
$page : mixed
$lastMenzzoOrderNumber : mixed = null
$dateFrom : mixed = null
$dateTo : mixed = null
$orderNumber : mixed = null
Return values
array<string|int, mixed>

getCalbersonOrdersForPrint()

public getCalbersonOrdersForPrint(mixed $ids) : mixed
Parameters
$ids : mixed

getCartCheckOrder()

public getCartCheckOrder(mixed $cart) : mixed
Parameters
$cart : mixed

getCartSendSmsCheckOrder()

public getCartSendSmsCheckOrder(mixed $cart, mixed $sendAt) : mixed
Parameters
$cart : mixed
$sendAt : mixed

getChronopostOrdersForPrint()

public getChronopostOrdersForPrint(mixed $ids) : mixed
Parameters
$ids : mixed

getCountAmazonShippingNotPrinted()

public getCountAmazonShippingNotPrinted(mixed $shippingMethode) : mixed
Parameters
$shippingMethode : mixed

getCountEspagneShippingNotPrinted()

public getCountEspagneShippingNotPrinted() : mixed

getCountShippingNotPrinted()

public getCountShippingNotPrinted(mixed $realShippingMethod) : mixed
Parameters
$realShippingMethod : mixed

getCountStoreNotPrinted()

public getCountStoreNotPrinted(mixed $storeId) : mixed
Parameters
$storeId : mixed

getCyfeSaleStat()

public getCyfeSaleStat(mixed $from, mixed $to) : mixed
Parameters
$from : mixed
$to : mixed

getFullSQL()

Get SQL from query

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

getGlsSalesToGenerateTicketsFor()

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

getIdfSalesToGenerateTicketsFor()

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

getLastId()

Get Last sale id

public getLastId(mixed $source) : mixed
Parameters
$source : mixed
Tags
throws
NoResultException
throws
NonUniqueResultException

getLastSaleDate()

public getLastSaleDate() : mixed
Tags
throws
NoResultException
throws
NonUniqueResultException

getLastSaleDropShipDate()

public getLastSaleDropShipDate() : int|mixed|string
Tags
throws
NoResultException
throws
NonUniqueResultException
Return values
int|mixed|string

getLengowSalesHavingApiShipError()

public getLengowSalesHavingApiShipError() : mixed

getLengowSalesShippedButProcessing()

public getLengowSalesShippedButProcessing() : mixed

getListParamsByDql()

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

getNotioSaleProducts()

public getNotioSaleProducts(mixed $page[, mixed $lastMenzzoOrderNumber = null ][, mixed $dateFrom = null ][, mixed $dateTo = null ]) : array<string|int, mixed>
Parameters
$page : mixed
$lastMenzzoOrderNumber : mixed = null
$dateFrom : mixed = null
$dateTo : mixed = null
Return values
array<string|int, mixed>

getOrdersByRange()

public getOrdersByRange(mixed $start, mixed $end) : mixed
Parameters
$start : mixed
$end : mixed
Tags
throws
Exception

getPaylinePaymentStats()

public getPaylinePaymentStats(mixed $start, mixed $end[, mixed $order = 'ASC' ]) : mixed
Parameters
$start : mixed
$end : mixed
$order : mixed = 'ASC'

getPaymentStat()

public getPaymentStat(mixed $start, mixed $end[, mixed $order = 'ASC' ]) : mixed
Parameters
$start : mixed
$end : mixed
$order : mixed = 'ASC'

getProcessingSalesForCheckAndFix()

public getProcessingSalesForCheckAndFix(mixed $from[, mixed $to = null ][, mixed $page = 1 ][, mixed $customFilters = [] ]) : array<string|int, mixed>|int|string
Parameters
$from : mixed
$to : mixed = null
$page : mixed = 1
$customFilters : mixed = []
Return values
array<string|int, mixed>|int|string

getRetraitSalesToPrint()

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

getSaleByNumberAccountBankAndCreatedAtAndGrandTotal()

public getSaleByNumberAccountBankAndCreatedAtAndGrandTotal(mixed $createdAt, mixed $numberAccountBank, string $grandTotal) : mixed
Parameters
$createdAt : mixed
$numberAccountBank : mixed
$grandTotal : string
Tags
throws
Exception

getSaleByUser()

public getSaleByUser(mixed $mail, mixed $name, mixed $date[, mixed $serchInInfo = false ]) : mixed
Parameters
$mail : mixed
$name : mixed
$date : mixed
$serchInInfo : mixed = false

getSaleProductAsirGroup()

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

getSalesShippingReport()

public getSalesShippingReport(mixed $from, mixed $to) : mixed
Parameters
$from : mixed
$to : mixed

getSalesStats()

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

getSalesStatsDropShip()

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

getSalesStatsForDashboard()

Get sales stats

public getSalesStatsForDashboard(mixed $from, mixed $to[, null $storeId = null ]) : mixed
Parameters
$from : mixed
$to : mixed
$storeId : null = null
Tags
throws
DBALException

getSalesWithMoreThanOneProduct()

Get sales with more than one product

public getSalesWithMoreThanOneProduct(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed

getSalesWithOneSaleProductGroupedByEmplacementToPrint()

Get sales with more than one product grouped by Emplacement

public getSalesWithOneSaleProductGroupedByEmplacementToPrint(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed
Tags
throws
DBALException

getSalesWithOneSaleProductGroupedByLabelToPrint()

Get sales with more than one product grouped by label

public getSalesWithOneSaleProductGroupedByLabelToPrint(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed
Tags
throws
DBALException

getSalesWithOneSaleProductToPrintGroupedBySku()

Get sales with more than one product

public getSalesWithOneSaleProductToPrintGroupedBySku(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed
Tags
throws
DBALException

getSdenOrdersForPrint()

public getSdenOrdersForPrint(mixed $ids) : mixed
Parameters
$ids : mixed

getShipmentCreatedAtFromLog()

Get Shipment created at from log

public getShipmentCreatedAtFromLog(mixed $sale) : mixed
Parameters
$sale : mixed
Tags
throws
DBALException

getShippedCalberson()

Get Shipped with calberson

public getShippedCalberson() : array<string|int, mixed>
Tags
throws
Exception
Return values
array<string|int, mixed>

getShippedChronopost()

Get shipped chronopost in the last 8 months

public getShippedChronopost() : array<string|int, mixed>
Tags
throws
Exception
Return values
array<string|int, mixed>

getStatistiqueNbrPaymentAlma()

public getStatistiqueNbrPaymentAlma(mixed $from, mixed $to) : mixed
Parameters
$from : mixed
$to : mixed

getTamdisSalesToGenerateTicketsFor()

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

getTruskSalesForTrusker()

public getTruskSalesForTrusker() : array<string|int, mixed>
Tags
throws
DBALException
Return values
array<string|int, mixed>

getTruskSalesRdvByRange()

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

getTruskSalesToExport()

Trusk sles to export

public getTruskSalesToExport(mixed $saleProductIds) : Query
Parameters
$saleProductIds : mixed
Return values
Query

getTruskSalesToNotify()

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

getTruskSalesToPrint()

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

getTruskSalesToPrintV2()

public getTruskSalesToPrintV2([mixed $dateTime = null ]) : array<string|int, mixed>
Parameters
$dateTime : mixed = null
Tags
throws
DBALException
Return values
array<string|int, mixed>

getTruskSalesToSend()

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

getTruskSalesToShip()

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

getUrgentSalesToPrint()

Get urgent sales

public getUrgentSalesToPrint(mixed $carrier, mixed $warehouseId) : mixed
Parameters
$carrier : mixed
$warehouseId : mixed

getVirSalesToGenerateTicketsFor()

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

getWaitingStoreAcceptanceSales()

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

paginateAllDropSales()

Paginate all drop sales

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

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

salesByDate()

public salesByDate(mixed $filterDate) : mixed
Parameters
$filterDate : mixed

save()

Save an entity

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

An entity that i want saved

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

searchAllApiShoppingSalesSql()

Get all sale list with sql

public searchAllApiShoppingSalesSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

searchAllGoogleSalesSql()

Get all sale list with sql

public searchAllGoogleSalesSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

searchAllLengowSalesSql()

Get all Lengow sales

public searchAllLengowSalesSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
todo

refactor and create new repository for erp bundle

Return values
array<string|int, mixed>|bool|string

searchAllSalesSql()

Get all sale list with sql

public searchAllSalesSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

searchAllShopdecoSalesSql()

Get all sale list with sql

public searchAllShopdecoSalesSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

searchApiShoppingInvoicedSales()

Search Shopdeco invoiced sales

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

searchApiShoppingPending()

Search for pending invoice sales

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

searchFull()

public searchFull(mixed $data) : mixed
Parameters
$data : mixed

searchIdfPlanning()

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

searchIdfPlanningPdf()

public searchIdfPlanningPdf(mixed $data[, mixed $getResult = true ]) : mixed
Parameters
$data : mixed
$getResult : mixed = true

searchIdfSalesToValidate()

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

searchIdfTransporter()

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

searchInvoicedSales()

Search Lengow invoiced sales

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

searchLengowPendingInvoices()

Search lengow pending invoice

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

searchOrdersUpdated()

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

searchPendingApiShoppingSales()

Search pending apiShoping Sales

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

searchPendingGoogleSales()

Search pending Google Sales

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

searchPendingLengowSales()

Search pending Lengow Sales

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

searchPendingPayment()

public searchPendingPayment(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : Paginator
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
Exception
Return values
Paginator

searchPendingSales()

Search pending Sales

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

searchPendingShopdecoSales()

Search pending Shopdeco Sales

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

searchProcessingNotPrinted()

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

searchProcessingOldRetrait()

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

searchProcessingRetraitNew()

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

searchProcessingRetraitNotPrinted()

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

searchRecapCommandesMarketplaces()

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

searchReconciliationOfPaymentsSaleList()

Get all sale list

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

searchSaleDropInvoiced()

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

searchSaleDropPending()

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

searchSaleSendExpedition()

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

searchSalesForPrintInvoices()

Search for sales to print

public searchSalesForPrintInvoices([array<string|int, mixed> $filters = [] ]) : array<string|int, mixed>|int|string
Parameters
$filters : array<string|int, mixed> = []
Return values
array<string|int, mixed>|int|string

searchScanedIdfSales()

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

searchShippedCalberson()

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

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

searchShippedGoogleSales()

Search Shipped Google Sales

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

searchShippedLengowSales()

Search Shipped Lengow Sales

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

searchShippedPendingInvoice()

Search for shipped pending invoice sales

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

searchShippedSden()

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

searchShippedShopdecoSales()

Search Shipped Shopdeco Sales

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

searchShopdecoInvoicedSales()

Search Shopdeco invoiced sales

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

searchShopdecoPending()

Search for pending invoice sales

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

searchShopdecoSaleErrorsSql()

Get all sale list with sql

public searchShopdecoSaleErrorsSql(mixed $data[, int $page = 0 ][, null $max = null ][, bool $getResult = true ]) : array<string|int, mixed>|bool|string
Parameters
$data : mixed
$page : int = 0
$max : null = null
$getResult : bool = true
Tags
throws
DBALException
Return values
array<string|int, mixed>|bool|string

searchSpainShipment()

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

searchStock0Scans()

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

searchTrusk()

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

searchUpStairsPlanning()

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

searchUpStairsTransporter()

Get UpStairs Transporter

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

searchVir()

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

searchVirAsir()

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

sumShipping()

public sumShipping(mixed $from, mixed $to) : mixed
Parameters
$from : mixed
$to : mixed

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

getParamsArray()

Get query params list

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

Yosef Kaminskyi yosefk@spotoption.com

Return values
int

getCustomConditionsForSalePrint()

Custom conditions for sale print

private getCustomConditionsForSalePrint(mixed $carrier[, mixed $saleProductAlias = 'sp' ]) : string
Parameters
$carrier : mixed
$saleProductAlias : mixed = 'sp'
Return values
string

        
On this page

Search results