Beispiel #1
0
 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;
 }
Beispiel #2
0
 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;
 }