public function delete($value)
{
// formating hours on date
$date = new \DateTime(strtotime(time()));
$date = $date->modify('-' . $value . 'hours')->format('Y-m-d H:i:s');
// deleting rows by doctrine with cascade delete entity settings in db schema
$qb = $this->em->createQueryBuilder();
$q = $qb->delete(Search::getClassName(), 's')->where($qb->expr()->lt('s.date', '?1'))->setParameter(1, $date)->getQuery();
return $numberDeleted = $q->getResult();
}
public function renderDefault($id)
{
if (!is_null($id)) {
$search = $this->em->find(Search::getClassName(), $id);
if (!$search) {
$this->flashMessage('Data not found for this id', 'error');
$this->redirect('Homepage:');
}
} else {
$this->flashMessage('Data not found for this id', 'error');
}
$this->template->search = $search;
}
public function renderDefault($page)
{
// initial dao object
$dao = $this->em->getRepository(Search::getClassName());
$searchQuery = new SearchQuery();
// initial paginator
$paginator = new Nette\Utils\Paginator();
$paginator->setPage($page);
$searchs = $dao->fetch($searchQuery)->applySorting(array('Search.date' => 'DESC'))->applyPaginator($paginator, self::ROWSONPAGE);
$numberRows = $searchs->getTotalCount();
$paginator->setItemCount($numberRows);
// push data to template
$this->template->search = $searchs;
$this->template->paginator = $paginator;
$this->template->page = $page;
}
