Exemplo n.º 1
0
 public function addSubCategory(SxCms_Job_Category $category)
 {
     $this->subCats[$category->getId()] = $category;
     return $this;
 }
Exemplo n.º 2
0
 public function getByCat(SxCms_Job_Category $category)
 {
     $db = Zend_Registry::get('db');
     $select = $db->select()->from('Vacancy', array('*'))->where('date_published <= CURDATE()')->where('date_expired >= CURDATE()')->order('date_published DESC');
     if ($category->getId()) {
         $select->where('category_id = ?', $category->getId());
     }
     $stmt = $db->query($select);
     $result = $stmt->fetchAll();
     $jobs = array();
     foreach ($result as $job) {
         $vacancy = $this->getModelFromArray($job);
         $jobs[$vacancy->getId()] = $vacancy;
     }
     return $jobs;
 }