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;