public function getDistinctRegions() { $db = Zend_Registry::get('db'); $select = $db->select()->from('Event', array('DISTINCT(location) AS region'))->order('location ASC'); $result = $db->fetchAll($select); $regions = array(); foreach ($result as $region) { $address = new SxCms_Address(); $address->setRegion($region['region']); $regions[] = $address; } return $regions; }
public function loadState() { $db = Zend_Registry::get('db'); $select = $db->select()->from('Vacancy', array('*'))->where('vacancy_id = ?', $this->id); $stmt = $db->query($select); $result = $stmt->fetchAll(); foreach ($result as $job) { $this->setId($job['vacancy_id'])->setJobTitle($job['title'])->setPhone($job['phone'])->setMobile($job['mobile'])->setEmail($job['email'])->setTerm($job['term'])->setDescription($job['description'])->setExpireDate($job['date_expired'])->setPublicationDate($job['date_published'])->setSeekerFirstName($job['seeker_name'])->setSeekerName($job['seeker_fname']); $category = new SxCms_Job_Category(); $category->setId($job['category_id']); $this->setCategory($category); $address = new SxCms_Address(); $address->setRegion($job['region']); $this->setAddress($address)->setHours($job['hours'])->setNotes($job['notes']); } return $this; }