orocrm / crm

     *

     * @return array [value, source]

     */

    public function getOpportunitiesCountGroupByLeadSource(

        AclHelper $aclHelper,

        DateFilterProcessor $dateFilterProcessor,

        array $dateRange = [],

        array $owners = []

    ) {

        $qb = $this->getOpportunitiesGroupByLeadSourceQueryBuilder($dateFilterProcessor, $dateRange, $owners);

        $qb->addSelect('count(o.id) as value');

        return $aclHelper->apply($qb)->getArrayResult();

    }

    /**

     * Returns budget amount of opportunities grouped by lead source

     *

     * @return array [value, source]

     */

    public function getOpportunitiesAmountGroupByLeadSource(

        AclHelper $aclHelper,

        DateFilterProcessor $dateFilterProcessor,

        array $dateRange = [],

        array $owners = []

    ) {

        $qb = $this->getOpportunitiesGroupByLeadSourceQueryBuilder($dateFilterProcessor, $dateRange, $owners);

        $qb->addSelect("SUM(CASE WHEN o.status = 'won' THEN o.closeRevenue ELSE o.budgetAmount END) as value");

        return $aclHelper->apply($qb)->getArrayResult();

    }

    /**

     * Returns opportunities QB grouped by lead source filtered by $dateRange and $owners