/**
*Retorna um array de objetos Shelf
*Lê a base de dados, e retorna um array de objetos Shelf dos artigos marcados para alerta de acesso
*@param Shelf shelf objeto shelf que contém o ID do usuário que se quer ter a shelf carregada
*@returns mixed Array de objetos Shelf
*/
function getAccessedAlertList($shelf)
{
$strsql = "SELECT * FROM user_shelf, articles WHERE user_id = '" . $shelf->getUserID() . "' and user_shelf.pid = articles.pid and user_shelf.access_stat = 1";
$result = $this->_db->databaseQuery($strsql);
$shelfList = array();
for ($i = 0; $i < count($result); $i++) {
$shelf = new Shelf();
$article = new Article();
$article->setPID($result[$i]['PID']);
$article->setURL($result[$i]['url']);
$article->setTitle($result[$i]['title']);
$article->setSerial($result[$i]['serial']);
$article->setVolume($result[$i]['volume']);
$article->setNumber($result[$i]['number']);
$article->setSuppl($result[$i]['suppl']);
$article->setYear($result[$i]['year']);
$article->setAuthorXML($result[$i]['authors_xml']);
$article->setKeywordXML($result[$i]['keywords_xml']);
$shelf->setPID($result[$i]['PID']);
$shelf->setCitedStat($result[$i]['cited_stat']);
$shelf->setAccessStat($result[$i]['access_stat']);
$shelf->setUserID($result[$i]['user_id']);
$shelf->setVisible($result[$i]['visible']);
$shelf->setArticle($article);
array_push($shelfList, $shelf);
}
return $shelfList;
}
