function getGrandeAreas()
{
$strsql = "SELECT * FROM grande_area";
$rs = $this->_db->databaseQuery($strsql);
$grandeAreas = array();
$grande = new GrandeArea();
foreach ($rs as $row) {
$grande->setID($row['id_grande_area']);
$grande->setLang($this->_grande_area->getLang());
$grande->setDescricao($row[$this->_grande_area->getLang()]);
array_push($grandeAreas, $grande);
}
return $grandeAreas;
}
function generateProfileArticleRelationship($profilesToCreate)
{
if ($profilesToCreate) {
// chamar serviço de associar palavras do perfil com os artigos
// deste resultado tratar o xml para
// gerar registros na tabela de profile_article,
// associando perfil a PID do artigo
$trigramaService = new TrigramaService();
$articleDAO = new ArticleDAO();
$profileArticleDAO = new ProfileArticleDAO();
foreach ($profilesToCreate as $newProfile) {
$subArea = new SubArea();
$subArea->setID($newProfile->getSubAreaID());
$subArea->loadSubArea();
$grandeArea = new GrandeArea();
$grandeArea->setLang('');
$grandeArea->setID($newProfile->getGrandeAreaID());
$grandeArea->loadGrandeArea();
$trigramaString = "";
$trigramaString .= $newProfile->getProfileText();
$trigramaString .= " " . $subArea->getDescricao();
$trigramaString .= " " . $grandeArea->getDescricao();
$trigramaService->setParams($trigramaString);
$articles = $trigramaService->getArticles();
$profileArticleDAO->setAsDeleted($newProfile->getProfileID());
foreach ($articles as $article) {
$foundArticle = $articleDAO->getArticle($article->getPID());
if (!$foundArticle || !$foundArticle->getPID()) {
$articleDAO->AddArticle($article);
} else {
$articleDAO->UpdateArticle($article);
}
$foundProfileArticle = $profileArticleDAO->getProfileArticle($article->getPID(), $newProfile->getProfileID());
$profileArticle = new ProfileArticle();
$profileArticle->setPID($article->getPID());
$profileArticle->setProfileID($newProfile->getProfileID());
$profileArticle->setRelevance($article->getRelevance());
if ($foundProfileArticle->getIsNew() == "3") {
$profileArticle->setIsNew(0);
$profileArticleDAO->UpdateProfileArticle($profileArticle);
} else {
$profileArticle->setIsNew(1);
$profileArticleDAO->AddProfileArticle($profileArticle);
}
}
$profileArticleDAO->deleteRelationship($newProfile->getProfileID());
}
}
}
echo ' </tr>' . "\n";
echo ' <tr>' . "\n";
echo ' <td class="label">' . "\n";
echo ' ' . FIELD_PROFILE_NAME . '' . "\n";
echo ' </td>' . "\n";
echo ' <td>' . "\n";
echo ' <input type="text" class="expression" name="profilename[]" value="' . $profileName . '"/>' . "\n";
echo ' </td>' . "\n";
echo ' </tr>' . "\n";
echo ' <tr>' . "\n";
echo ' <td class="label">' . "\n";
echo ' Areas de Interesse' . "\n";
echo ' </td>' . "\n";
echo ' <td>' . "\n";
$a = new GrandeArea();
$a->setLang($lang);
$arr = $a->getGrandeAreas();
?>
<select name="GrandeArea<?php
echo $id;
?>
" id="GrandeArea<?php
echo $id;
?>
" onchange="doBusca(this.options[this.selectedIndex].value,'SubArea<?php
echo $id;
?>
','<?php
echo $lang;
?>
')">
