public function getStatisticListAction() { try { $limit =
(int) $this->
Request()->
getParam('limit'
);
$offset =
(int) $this->
Request()->
getParam('start'
);
$partnerId =
(int) $this->
Request()->
getParam('partnerId'
);
// Order data
$order =
(array) $this->
Request()->
getParam('sort',
[]);
$fromDate =
$this->
getFromDate();
$toDate =
$this->
getToDate();
$repository =
$this->
get('models'
)->
getRepository(Partner::
class);
$dataQuery =
$repository->
getStatisticListQuery($order,
$offset,
$limit,
$partnerId, false,
$fromDate,
$toDate);
$totalCount =
$this->
getStatisticListTotalCount($dataQuery);
$data =
$dataQuery->
getArrayResult();
$summaryQuery =
$repository->
getStatisticListQuery($order,
$offset,
$limit,
$partnerId, true,
$fromDate,
$toDate);
$summaryData =
$summaryQuery->
getOneOrNullResult(AbstractQuery::HYDRATE_ARRAY
);