public function testDateStart() { $cronTaskLogSearch = new CronTaskLogSearch(); $dateTime = new \DateTime(); $dateTime->setTime(0, 0, 0); $this->assertEquals($dateTime, $cronTaskLogSearch->getDateStart()); }
public function testSubmit() { $dateTime = new \DateTime(); $dateTime->setTime(0, 0, 0); $dateTime->sub(new \DateInterval('P7D')); $cronTaskLogSearch = new CronTaskLogSearch(); $cronTaskLogSearch->setDateStart($dateTime); $form = $this->factory->create(new CronTaskLogSearchType(), $cronTaskLogSearch); $formData = array('dateStart' => $dateTime); $form->submit($formData); $this->assertTrue($form->isSynchronized()); $this->assertEquals($cronTaskLogSearch, $form->getData()); }
/** * @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(); }