src/OroCRM/Bundle/MagentoBundle/Entity/Repository/CartRepository.php 1 location
|
@@ 115-119 (lines=5) @@
|
| 112 |
|
|
| 113 |
|
$queryBuilder->where($queryBuilder->expr()->in('workflowStep.name', $steps)); |
| 114 |
|
|
| 115 |
|
if ($dateFrom && $dateTo) { |
| 116 |
|
$queryBuilder->andWhere($queryBuilder->expr()->between('cart.createdAt', ':dateFrom', ':dateTo')) |
| 117 |
|
->setParameter('dateFrom', $dateFrom) |
| 118 |
|
->setParameter('dateTo', $dateTo); |
| 119 |
|
} |
| 120 |
|
|
| 121 |
|
if ($this->excludedStatuses) { |
| 122 |
|
$queryBuilder->andWhere($queryBuilder->expr()->notIn('status.name', $this->excludedStatuses)); |
src/OroCRM/Bundle/SalesBundle/Entity/Repository/SalesFunnelRepository.php 1 location
|
@@ 154-159 (lines=6) @@
|
| 151 |
|
->join('funnel.workflowStep', 'workflowStep') |
| 152 |
|
->groupBy('workflowStep.name'); |
| 153 |
|
|
| 154 |
|
if ($dateFrom && $dataTo) { |
| 155 |
|
$queryBuilder |
| 156 |
|
->where($queryBuilder->expr()->between('funnel.createdAt', ':dateFrom', ':dateTo')) |
| 157 |
|
->setParameter('dateFrom', $dateFrom) |
| 158 |
|
->setParameter('dateTo', $dataTo); |
| 159 |
|
} |
| 160 |
|
|
| 161 |
|
return $queryBuilder; |
| 162 |
|
} |
src/OroCRM/Bundle/SalesBundle/Entity/Repository/OpportunityRepository.php 1 location
|
@@ 70-74 (lines=5) @@
|
| 67 |
|
$qb->select('IDENTITY(opportunity.status) as name, SUM(opportunity.budgetAmount) as budget') |
| 68 |
|
->groupBy('opportunity.status'); |
| 69 |
|
|
| 70 |
|
if ($dateStart && $dateEnd) { |
| 71 |
|
$qb->where($qb->expr()->between('opportunity.createdAt', ':dateFrom', ':dateTo')) |
| 72 |
|
->setParameter('dateFrom', $dateStart) |
| 73 |
|
->setParameter('dateTo', $dateEnd); |
| 74 |
|
} |
| 75 |
|
$groupedData = $aclHelper->apply($qb)->getArrayResult(); |
| 76 |
|
|
| 77 |
|
foreach ($groupedData as $statusData) { |
orocrm /
crm
