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; }
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; }