1. class
  2. Alligator
  3. \
  4. Business
  5. \
  6. Database
  7. \
  8. Statistic
  9. \
  10. StatisticRepository

StatisticRepository

class StatisticRepository extends EntityRepository

Class StatisticRepository is injected as alligator.statistic_repository service. StatisticRepository is used for crud operation for managed entity.

Use this class to work with database.

Constants

ALIAS

Alias for statistics
USER_ALIAS

Alias for user
PRODUCT_ALIAS

Alias for product
PRODUCT_ATTRIBUTE_VALUES_ALIAS

Alias for product attribute values
ORDER_ALIAS

Alias for order
SHOW_ROUTES

Array of routes to show

Methods

array
loadAllPlatformGraphData()

Load statistics data for graph representation

array
loadPlatformPieGraphData()

Load statistics data for graph representation

Statistics
saveStatistic(Statistics $statistics)

Persist new statistics

array
getTopProductsAdmin(int $maxResult)

Find top products by review, limit by $maxResult

array
getMostViewed(int $maxResult)

Find most viewed products, limit by $maxResult

array|bool
getTopRated(int $maxResult)

Find top rated products, limit by $maxResult

array
getFinancialGraphData(string|DateTime|null $currentDate = null, string|null $currency = null)

Find financial data for graph representation

array
getOrderForYearAndMonth(string|DateTime|null $currentDate = null, string|null $currency = null)

Find orders for month and year

array
getBestSellers(int $maxResult)

Find best seller products, limit by $maxResult

array
getDataForLiveActivityLog(int $page = 1, int $offset = 10, array|null $params = null)

Find last statistics data with pagination

array
getDataForOrderActivityLog(int $orderId)

Find order statistics data

array
findRowsByOrderId(int $id)

Find order statistic rows

EntityManager
getEntityManager()

No description

array
getLatestViewedProductsForUser(int|string $userId, int $numberOfProducts)

Find latest viewed products for specific user

array
getMostViewedProductsForUser(int|string $userId, int $numberOfProducts)

Find most viewed products for specific user

array
getAddedRemovedProductOlapData()

Find all data for OLAP

Details

at line 83
array loadAllPlatformGraphData()

Load statistics data for graph representation

Return Value

array

at line 108
array loadPlatformPieGraphData()

Load statistics data for graph representation

Return Value

array

at line 146
Statistics saveStatistic(Statistics $statistics)

Persist new statistics

Parameters

Statistics $statistics

Return Value

Statistics

Exceptions

ORMException
OptimisticLockException

at line 162
array getTopProductsAdmin(int $maxResult)

Find top products by review, limit by $maxResult

Parameters

int $maxResult

Return Value

array

at line 192
array getMostViewed(int $maxResult)

Find most viewed products, limit by $maxResult

Parameters

int $maxResult

Return Value

array

at line 230
array|bool getTopRated(int $maxResult)

Find top rated products, limit by $maxResult

Parameters

int $maxResult

Return Value

array|bool

at line 271
array getFinancialGraphData(string|DateTime|null $currentDate = null, string|null $currency = null)

Find financial data for graph representation

Parameters

string|DateTime|null $currentDate
string|null $currency

Return Value

array

at line 327
array getOrderForYearAndMonth(string|DateTime|null $currentDate = null, string|null $currency = null)

Find orders for month and year

Parameters

string|DateTime|null $currentDate
string|null $currency

Return Value

array

at line 361
array getBestSellers(int $maxResult)

Find best seller products, limit by $maxResult

Parameters

int $maxResult

Return Value

array

at line 400
array getDataForLiveActivityLog(int $page = 1, int $offset = 10, array|null $params = null)

Find last statistics data with pagination

Parameters

int $page
int $offset
array|null $params

Return Value

array

at line 467
array getDataForOrderActivityLog(int $orderId)

Find order statistics data

Parameters

int $orderId

Return Value

array

at line 496
array findRowsByOrderId(int $id)

Find order statistic rows

Parameters

int $id

Return Value

array

at line 508
EntityManager getEntityManager()

Return Value

EntityManager

at line 520
array getLatestViewedProductsForUser(int|string $userId, int $numberOfProducts)

Find latest viewed products for specific user

Parameters

int|string $userId
int $numberOfProducts

Return Value

array

at line 572
array getMostViewedProductsForUser(int|string $userId, int $numberOfProducts)

Find most viewed products for specific user

Parameters

int|string $userId
int $numberOfProducts

Return Value

array

at line 620
array getAddedRemovedProductOlapData()

Find all data for OLAP

Return Value

array

Exceptions

DBALException