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