public function getResourceRights()
{
$res = array();
$db = new ReservationDBInterface();
$vars = array('res_resource_name', 'res_resource_capacity', 'res_group_right');
$res = $db->select(array('res_group', 'res_resource'), $vars, array('res_resource_group_id=res_group_id'), __METHOD__, array('ORDER BY' => array('res_group_right', 'res_resource_name')));
return $res;
}
public function getAllowableResources()
{
$db = new ReservationDBInterface();
$vars = array('res_resource_name', 'res_resource_id');
$res = $db->select(array('res_group', 'res_resource'), $vars, array('res_resource_group_id=res_group_id', 'res_group_right' => $this->getRights()));
return $res;
}
public function getResourceLabels()
{
$ret = array();
$db = new ReservationDBInterface();
$vars = array('res_resource_name', 'res_resource_id');
$ret = $db->select(array('res_resource'), $vars, array(), __METHOD__, array('ORDER BY' => array('res_resource_name')));
$rsort = array();
if (count($ret) > 0) {
$rsort = array();
for ($i = 0, $ii = count($ret); $i < $ii; $i++) {
$rsort[$ret[$i]['res_resource_id']] = " " . $ret[$i]['res_resource_name'];
}
}
return $rsort;
}