orocrm /
crm
| @@ 635-641 (lines=7) @@ | ||
| 632 | * @param \DateTime|null $start |
|
| 633 | * @param \DateTime|null $end |
|
| 634 | */ |
|
| 635 | protected function setCreationPeriod(QueryBuilder $qb, \DateTime $start = null, \DateTime $end = null) |
|
| 636 | { |
|
| 637 | $qb |
|
| 638 | ->andWhere($qb->expr()->between('o.createdAt', ':dateStart', ':dateEnd')) |
|
| 639 | ->setParameter('dateStart', $start) |
|
| 640 | ->setParameter('dateEnd', $end); |
|
| 641 | } |
|
| 642 | ||
| 643 | /** |
|
| 644 | * @param QueryBuilder $qb |
|
| @@ 648-654 (lines=7) @@ | ||
| 645 | * @param \DateTime|null $start |
|
| 646 | * @param \DateTime|null $end |
|
| 647 | */ |
|
| 648 | protected function setClosedPeriod(QueryBuilder $qb, \DateTime $start = null, \DateTime $end = null) |
|
| 649 | { |
|
| 650 | $qb |
|
| 651 | ->andWhere($qb->expr()->between('o.closeDate', ':dateStart', ':dateEnd')) |
|
| 652 | ->setParameter('dateStart', $start) |
|
| 653 | ->setParameter('dateEnd', $end); |
|
| 654 | } |
|
| 655 | ||
| 656 | /** |
|
| 657 | * Returns count of opportunities grouped by lead source |
|
