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();
}
