function loadSubArea($subArea, $lang = '')
{
$strsql = "SELECT * FROM sub_area WHERE id_sub_area = " . $subArea->getID();
$row = $this->_db->databaseQuery($strsql);
$sub = new SubArea();
$sub->setID($row[0]['id_sub_area']);
$sub->setGrandeAreaID($row[0]['id_grande_area']);
if ($lang != '') {
$sub->setDescricao($row[0][$lang]);
} else {
/*
jah que eh pra trigrama msm vai em todos os idiomas hehehe
*/
$sub->setDescricao($row[0]['pt'] . $row[0]['en'] . $row[0]['es']);
}
return $sub;
}
function getSubAreas()
{
$strsql = "SELECT * FROM sub_area WHERE id_grande_area = " . $this->_grande_area->getID();
$rs = $this->_db->databaseQuery($strsql);
$subAreas = array();
$sub = new SubArea();
foreach ($rs as $row) {
$sub->setID($row['id_sub_area']);
$sub->setGrandeAreaID($row['id_grande_area']);
$sub->setDescricao($row[$this->_grande_area->getLang()]);
array_push($subAreas, $sub);
}
return $subAreas;
}
