public function testDateStart() { $cronTaskLogSearch = new CronTaskLogSearch(); $dateTime = new \DateTime(); $dateTime->setTime(0, 0, 0); $this->assertEquals($dateTime, $cronTaskLogSearch->getDateStart()); }
/** * @param CronTaskLogSearch $cronTaskLogSearch * @return CronTaskLog[] */ public function searchFinished(CronTaskLogSearch $cronTaskLogSearch) { $queryBuilder = $this->createQueryBuilder('cron_task_log'); $queryBuilder->select('cron_task_log'); $queryBuilder->where('cron_task_log.pid IS NULL'); $queryBuilder->andWhere('cron_task_log.dateStart >= :dateStart'); $queryBuilder->orderBy('cron_task_log.dateStart', 'desc'); $params = array('dateStart' => $cronTaskLogSearch->getDateStart()); if ($cronTaskLogSearch->getCronTask() !== null) { $queryBuilder->andWhere('cron_task_log.cronTask = :cronTask'); $params['cronTask'] = $cronTaskLogSearch->getCronTask(); } else { $queryBuilder->groupBy('cron_task_log.cronTask, cron_task_log.status'); } $queryBuilder->setParameters($params); $query = $queryBuilder->getQuery(); return $query->getResult(); }