/** * initialize this object (fill the array) with assignment histories * * @param int $bannerID banner id of student * @param int $term term to be searching * @return boolean flag to signal if the initialization was a success */ private function init() { $db = new PHPWS_DB('hms_assignment_history'); $db->addWhere('banner_id', $this->bannerId); $db->loadClass('hms', 'AssignmentHistory.php'); $db->addOrder(array('term DESC', 'assigned_on DESC')); $result = $db->getObjects('AssignmentHistory'); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } if (isset($result)) { $this->assignmentHistory = $result; } return true; }
public function loadAssignment() { $db = new PHPWS_DB('hms_assignment'); $db->addWhere('bed_id', $this->id); $db->addWhere('term', $this->term); $db->loadClass('hms', 'HMS_Assignment.php'); $result = $db->getObjects('HMS_Assignment'); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } else { if ($result == null) { return true; } elseif (sizeof($result) > 1) { PHPWS_Error::log(HMS_MULTIPLE_ASSIGNMENTS, 'hms', 'HMS_Bed::loadAssignment', "bedid : {$this->id}"); return false; } else { $this->_curr_assignment = $result[0]; return TRUE; } } }
/** * Pulls all the rooms associated with this floor and stores * them in the _room variable. */ public function loadRooms() { $db = new PHPWS_DB('hms_room'); $db->addWhere('floor_id', $this->id); $db->addOrder('room_number', 'ASC'); $db->loadClass('hms', 'HMS_Room.php'); $result = $db->getObjects('HMS_Room'); //test($result); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } else { $this->_rooms =& $result; return true; } }
/** * Pulls all the floors associated with this hall and stores them in * the _floors variable. */ public function loadFloors() { if (!$this->id) { $this->_floor = null; return null; } $db = new PHPWS_DB('hms_floor'); $db->addWhere('residence_hall_id', $this->id); $db->addOrder('floor_number', 'ASC'); $db->loadClass('hms', 'HMS_Floor.php'); $result = $db->getObjects('HMS_Floor'); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } $this->_floors =& $result; return true; }
/** * Function called by mod developer to add their * link or to just show the menu on that item */ public static function show() { \Layout::addJSHeader("<script type='text/javascript' src='" . PHPWS_SOURCE_HTTP . "javascript/responsive_img/responsive-img.min.js'></script>", 81); $seen = array(); $key = Key::getCurrent(); if (empty($key) || empty($key->title) || empty($key->url)) { return; } $db = new PHPWS_DB('menus'); $db->addWhere('menu_assoc.key_id', $key->id); $db->addWhere('id', 'menu_assoc.menu_id'); $db->loadClass('menu', 'Menu_Item.php'); Key::restrictView($db, 'menu'); $result = $db->getObjects('Menu_Item'); if (PHPWS_Error::isError($result)) { PHPWS_Error::log($result); } elseif (!empty($result)) { foreach ($result as $menu) { $seen[] = $menu->id; if ($menu->assoc_image) { Layout::set($menu->showAssocImage(), 'menu', 'image'); } Layout::set($menu->view(), 'menu', 'menu_' . $menu->id); } } }
/** * Pulls all beds associated with this room and stores them in * the _beds variable. * */ public function loadBeds() { $db = new PHPWS_DB('hms_bed'); $db->addWhere('room_id', $this->id); $db->addOrder('bedroom_label', 'ASC'); $db->addOrder('bed_letter', 'ASC'); $db->loadClass('hms', 'HMS_Bed.php'); $result = $db->getObjects('HMS_Bed'); if (PHPWS_Error::logIfError($result)) { throw new DatabaseException($result->toString()); } else { $this->_beds =& $result; return true; } }
public static function getEntries(PHPWS_DB $db, $limit, $offset = 0) { $db->resetColumns(); $db->setLimit($limit, $offset); $db->addOrder('sticky desc'); $db->addOrder('publish_date desc'); $db->loadClass('blog', 'Blog.php'); return $db->getObjects('Blog'); }