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; }