orocrm /
crm
| @@ 616-625 (lines=10) @@ | ||
| 613 | * @param \DateTime|null $start |
|
| 614 | * @param \DateTime|null $end |
|
| 615 | */ |
|
| 616 | protected function setCreationPeriod(QueryBuilder $qb, \DateTime $start = null, \DateTime $end = null) |
|
| 617 | { |
|
| 618 | if ($start) { |
|
| 619 | $qb->andWhere('o.createdAt >= :dateStart')->setParameter('dateStart', $start); |
|
| 620 | } |
|
| 621 | ||
| 622 | if ($end) { |
|
| 623 | $qb->andWhere('o.createdAt <= :dateEnd')->setParameter('dateEnd', $end); |
|
| 624 | } |
|
| 625 | } |
|
| 626 | ||
| 627 | /** |
|
| 628 | * @param QueryBuilder $qb |
|
| @@ 632-641 (lines=10) @@ | ||
| 629 | * @param \DateTime|null $start |
|
| 630 | * @param \DateTime|null $end |
|
| 631 | */ |
|
| 632 | protected function setClosedPeriod(QueryBuilder $qb, \DateTime $start = null, \DateTime $end = null) |
|
| 633 | { |
|
| 634 | if ($start) { |
|
| 635 | $qb->andWhere('o.closedAt >= :dateStart')->setParameter('dateStart', $start); |
|
| 636 | } |
|
| 637 | ||
| 638 | if ($end) { |
|
| 639 | $qb->andWhere('o.closedAt <= :dateEnd')->setParameter('dateEnd', $end); |
|
| 640 | } |
|
| 641 | } |
|
| 642 | ||
| 643 | /** |
|
| 644 | * Returns count of opportunities grouped by lead source |
|
