public function addSubCategory(SxCms_Job_Category $category) { $this->subCats[$category->getId()] = $category; return $this; }
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; }