function getArticles() { $xml = $this->getXML(); $XML_XSL = new XSL_XML(); $content = $XML_XSL->xml_xsl($xml, dirname(__FILE__) . "/../../xsl/similarToArray.xsl"); $content = str_replace('<?xml version="1.0" encoding="ISO-8859-1"?>', '', $content); $articles = split('\\|SIMILAR_SPLIT\\|', $content); $article = new Article(); for ($i = 0; $i < count($articles) - 1; $i++) { $articles[$i] = split('\\|ITEM_SPLIT\\|', $articles[$i]); if (trim($articles[$i][0]) != '') { $article->setPID(trim($articles[$i][0])); $article->setPublicationDate(trim($articles[$i][1])); $article->setRelevance(trim($articles[$i][2])); $article->setURL(trim($articles[$i][3])); $article->setTitle(trim($articles[$i][4])); $article->setSerial(trim($articles[$i][5])); $article->setVolume(trim($articles[$i][6])); $article->setNumber(trim($articles[$i][7])); $article->setYear(trim($articles[$i][8])); $article->setSuppl(trim($articles[$i][9])); $article->setAuthorXML(str_replace("\n", "", trim($articles[$i][10]))); $article->setKeywordXML(trim($articles[$i][11])); $arrArticles[$i] = $article; } } // die(print_r($arrArticles)); return $arrArticles; }
function getMyProfileArticleList($article_profile) { // 1 - SELECT nos profiles do Usuarios // 2 - Pra cada Profile: pego a lista de artigos (olho na profiele_article // 3 - devolvo array de perfis com os artigos $this->setMyProfiles($article_profile->getUserID()); $profiles_result = $this->getMyProfiles(); //$articleProfileList[] = array(); for ($p = 0; $p < count($profiles_result); $p++) { $profile_id = $profiles_result[$p]['profile_id']; $profile_name = $profiles_result[$p]['profile_name']; $articleProfileList[intval($profile_id)] = array(); $order = $_GET['order']; switch ($order) { case "date": $order_by = " ORDER BY articles.publication_date desc"; break; case "relevance": $order_by = " ORDER BY relevance desc"; break; default: $order_by = null; } $where_new = isset($_GET['new']) ? ' and is_new=1' : null; $strsql = "SELECT profile_article.*,articles.publication_date FROM profile_article,articles WHERE articles.PID = profile_article.PID and profile_id = '" . $profile_id . "'" . $where_new . " " . $order_by; $result = $this->_db->databaseQuery($strsql); for ($i = 0; $i < count($result); $i++) { $relevance = $result[$i]['relevance']; $query_article = "SELECT * FROM articles WHERE PID = '" . $result[$i]['PID'] . "' LIMIT 1"; $article_result = $this->_db->databaseQuery($query_article); $articleProfile = new MyProfileArticle(); $article = new Article(); $article->setPID($article_result[0]['PID']); $article->setURL($article_result[0]['url']); $article->setTitle($article_result[0]['title']); $article->setSerial($article_result[0]['serial']); $article->setVolume($article_result[0]['volume']); $article->setNumber($article_result[0]['number']); $article->setSuppl($article_result[0]['suppl']); $article->setYear($article_result[0]['year']); $article->setAuthorXML($article_result[0]['authors_xml']); $article->setKeywordXML($article_result[0]['keywords_xml']); $article->setRelevance($relevance); $article->setPublicationDate($article_result[0]['publication_date']); array_push($articleProfileList[$profile_id], array($profile_name, $article)); //die(var_dump($articleProfileList)); } } //var_dump($articleProfileList);die; return $articleProfileList; }