code: private function getRevenueQuery()
      {
          if (null !== $this->revenueQuery) {
              return $this->revenueQuery;
          }
  
          $qb = $this->createQueryBuilder('o');
          $expr = $qb->expr();
  
          return $this->revenueQuery = $qb
              ->select(['o.date', 'o.revenue', 'o.details'])
              ->andWhere($expr->eq('o.type', ':type'))
              ->andWhere($expr->gte('o.date', ':from'))
              ->andWhere($expr->lte('o.date', ':to'))
              ->addOrderBy('o.date')
              ->getQuery();
      }
docs: Returns the revenues query.
  
  @return \Doctrine\ORM\AbstractQuery