public static function findAvailableFacilityResource($resourceDb, $start, $end, $name) { //CHECK WETHER THERE IS A RESOURCE OF TYPE $type LEFT (COUNT $booked AGAINST $available??? // NEEDED: // -NR. OF RESOURCES OF TYPE $type // -NR OF RESOUCRES LEFT AFTER SUBTRACTING $booked // -ASSIGN A RESOURCE_ID IF POSSIBLE $fid = 0; $id = Resources::getResourceIdByName($name, $resourceDb); $numberOfResources = FacilitySchedule::getNrOfAvailableResources($id); $reservedResources = FacilitySchedule::getNrOfReservedFacilityResources($start, $end, $id); if ($numberOfResources - $reservedResources > 0) { $fid = FacilitySchedule::getBookableFacilityResources($start, $end, $id); } else { $error = Yii::app()->clientScript; $error->registerScript('error', 'alert("No resource ' . $name . ' Available!");', CClientScript::POS_READY); } return $fid; }