function loadGrandeArea()
{
$strsql = "SELECT * FROM grande_area WHERE id_grande_area = " . $this->_grande_area->getID();
$row = $this->_db->databaseQuery($strsql);
$sub = new GrandeArea();
$sub->setID($row[0]['id_grande_area']);
if ($this->_grande_area->getLang() != '') {
$sub->setDescricao($row[0][$this->_grande_area->getLang()]);
} else {
$sub->setDescricao($row[0]['pt'] . $row[0]['en'] . $row[0]['es']);
}
return $sub;
}
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 ' </td>' . "\n";
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;
?>
<?php
header("Content-Type: application/xhtml+xml; charset=iso-8859-1");
require_once dirname(__FILE__) . "/../classes/GrandeArea.php";
$idGrandeArea = $_REQUEST['id_grande_area'];
$lang = $_REQUEST['lang'];
$a = new GrandeArea();
$a->setID($idGrandeArea);
if ($lang != "") {
$a->setLang($lang);
}
$arr = $a->getSubAreas();
$str = '';
foreach ($arr as $item) {
$str .= '' . $item->getID() . ',' . urldecode($item->getDescricao()) . '|';
}
$str = ereg_replace("\\|\$", "", $str);
echo $str;
