public function getBookableFacilityResources($start, $end, $resourceId)
{
$sql = '';
$stm = 'SELECT facility_id from ' . Resources::FACILITY_SCHEDULE_DB . ' WHERE facility_id = ' . $resourceId . ' LIMIT 1';
$inTable = Yii::app()->db->createCommand($stm)->querycolumn();
$nonScheduledResources = FacilitySchedule::getNonScheduledResources();
//if ($inTable == null && $nonScheduledResources ){
if ($nonScheduledResources == 0) {
// $sql = 'SELECT f.id FROM '.Resources::FACILITY_DB.' f LEFT JOIN '.Resources::FACILITY_TYPES_DB.' t ON f.f_type = t.id WHERE t.id = '.$resourceId.' LIMIT 1';
// }
// else {
$sql = 'SELECT f_type FROM ' . Resources::FACILITY_DB . ' f ';
$sql .= 'JOIN ' . Resources::FACILITY_TYPES_DB . ' t ON f.f_type = t.id';
$sql .= ' JOIN ' . Resources::FACILITY_SCHEDULE_DB . ' s ON s.facility_id = f.id';
$sql .= ' WHERE (start_date NOT BETWEEN \'' . $start . '\' AND \'' . $end . '\')';
$sql .= ' OR (end_date NOT BETWEEN \'' . $start . '\' AND \'' . $end . '\')';
$sql .= ' AND f_type = ' . $resourceId;
$data = Yii::app()->db->createCommand($sql)->queryColumn();
$nonScheduledResources = $data[0][0];
}
return $nonScheduledResources;
}
