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; ?> ')">