/** * @param WorkingMonth $workingMonth * @return RepeatedDrivingAssertionPlan[] */ public function findActivePlansInRangeOfWorkingMonth(WorkingMonth $workingMonth) { /** @var \DateTime $startDate */ $startDate = clone $workingMonth->getDate(); /** @var \DateTime $endDate */ $endDate = clone $workingMonth->getDate(); $endDate->modify('last day of this month'); $qb = parent::createQueryBuilder('p'); $qb->where('p.anchorDate <= :endDate')->andWhere('p.endingDate >= :startDate'); $qb->setParameter('startDate', $startDate->format('Y-m-d')); $qb->setParameter('endDate', $endDate->format('Y-m-d')); return $qb->getQuery()->getResult(); }