/**
* @param int $status
* @param string $type
*
* @return QueryBuilder
*/
public function getFilteredQuery($status, $type)
{
$query = $this->createQueryBuilder('n');
if (is_int($status) && in_array($status, NoticeEntity::getStatuses())) {
$query->where('n.status = :status')->setParameter('status', $status);
}
if ($type) {
$query->andWhere('n.type = :type')->setParameter('type', $type);
}
return $query;
}
public function testGetStatuses()
{
$this->assertEquals([Notice::STATUS_CREATED, Notice::STATUS_SHOWN, Notice::STATUS_CLOSED], Notice::getStatuses());
}
