private function handleDateRangeFilter(\CDbCriteria $criteria, $filter = array())
{
$from = null;
if (isset($filter['date_from'])) {
$from = \Helper::convertNHS2MySQL($filter['date_from']);
}
$to = null;
if (isset($filter['date_to'])) {
$to = \Helper::convertNHS2MySQL($filter['date_to']);
}
if ($from && $to) {
if ($from > $to) {
$criteria->addBetweenCondition('event.event_date', $to, $from);
} else {
$criteria->addBetweenCondition('event.event_date', $from, $to);
}
} elseif ($from) {
$criteria->addCondition('event.event_date >= :from');
$criteria->params[':from'] = $from;
} elseif ($to) {
$criteria->addCondition('event.event_date <= :to');
$criteria->params[':to'] = $to;
}
}