gistfile1.txt

    public function findByThisMonthToTodayOrderCount(\DateTime $firstDayOfMonth, \DateTime $currentDatetime)
    {
        $currentDatetimeString = $currentDatetime->format('Y-m-d');
        $firstDayOfMonthString = $firstDayOfMonth->format('Y-m-d');

/*
        $qb = $this->createQueryBuilder();
        $qb->add('select', 'COUNT(*) as targetAmount, orders.created as targetMonth');
        $qb->add('from', self::ORDER_CLASS.' as orders');

        $where = $qb->expr()->andx(
            $qb->expr()->gte('orders.createdAt', ':firstDayOfMonthString'),
            $qb->expr()->lt('orders.createdAt', ':currentDatetimeString')
        );

        $qb->add('where', $where);
        $qb->add('groupBy', "MONTH(orders.createdAt)");
        $qb->setParameter('firstDayOfMonthString', $firstDayOfMonthString);
        $qb->setParameter('currentDatetimeString', $currentDatetimeString);
 */

        $queryString  = 'SELECT COUNT(*)';
        $queryString .= ' FROM orders';
        $queryString .= ' WHERE (';
        $queryString .= ' orders.createdAt >= "'.$firstDayOfMonthString.'"';
        $queryString .= ' AND';
        $queryString .= ' orders.createdAt < "'.$currentDatetimeString.'"';
        $queryString .= ' )';
        $queryString .= ' GROUP BY MONTH(orders.createdAt)';

        $result = $this->_em
            ->getConnection()
            ->executeQuery($queryString)
            ->fetchColumn();

        return isset($result) ? $result : 0;
    }