public function getAll()
{
$db = Zend_Registry::get('db');
$select = $db->select()->from('VacancyProf', array('*'))->where('language = ?', $_SESSION['System']['lng']);
$stmt = $db->query($select);
$result = $stmt->fetchAll();
$professions = array();
foreach ($result as $pub) {
$profession = new SxCms_Job_Profession();
$profession->setId($pub['vacancy_prof_id'])->setLanguage($pub['language'])->setName($pub['name'])->setDescription($pub['description']);
$professions[$profession->getId()] = $profession;
}
return $professions;
}
