orocrm / crm

        $qb->select('IDENTITY(opportunity.status) as name, SUM(opportunity.budgetAmount) as budget')

            ->groupBy('opportunity.status');

        if ($dateStart && $dateEnd) {

            $qb->where($qb->expr()->between('opportunity.createdAt', ':dateFrom', ':dateTo'))

                ->setParameter('dateFrom', $dateStart)

                ->setParameter('dateTo', $dateEnd);

        }

        if ($owners) {

            QueryUtils::applyOptimizedIn($qb, 'opportunity.owner', $owners);

            ->join('funnel.workflowStep', 'workflowStep')

            ->groupBy('workflowStep.name');

        if ($dateFrom && $dataTo) {

            $queryBuilder

                ->where($queryBuilder->expr()->between('funnel.createdAt', ':dateFrom', ':dateTo'))

                ->setParameter('dateFrom', $dateFrom)

                ->setParameter('dateTo', $dataTo);

        }

        return $queryBuilder;

    }