public function getTheatres($date, $firm_id = false)
{
if (empty($date)) {
throw new Exception('Date is required.');
}
$criteria = new CDbCriteria();
if (empty($firm_id) || $firm_id == 'EMG') {
$criteria->addCondition('sessions.firm_id is null');
} else {
$criteria->addCondition('sessions.firm_id = :firmId');
$criteria->params[':firmId'] = $firm_id;
}
$criteria->addCondition('sessions.date = :date');
$criteria->params[':date'] = $date;
$criteria->order = 'sessions.start_time';
return OphTrOperationbooking_Operation_Theatre::model()->with('sessions')->active()->findAll($criteria);
}