/**
* {@inheritDoc}
*/
protected function fetchData()
{
parent::fetchData();
$query = '
SELECT
pub_auth.publication_id AS publicationId,
COUNT(cit.id) AS citationCount
FROM publications_authors pub_auth
LEFT JOIN citations cit ON (pub_auth.publication_id = cit.publication_id)
WHERE pub_auth.author_id = :authorId
GROUP BY publicationId
ORDER BY citationCount DESC
';
$statement = $this->db->prepare($query);
$statement->bindValue(':authorId', $this->parameters['authorId']['value'], PDO::PARAM_INT);
$statement->execute();
$data = array();
$data['publications'] = $statement->fetchAll(PDO::FETCH_ASSOC);
$data = IndexHelper::convertWrongDataTypes($this->dataFormat['publications']['int'], $data, 2, 0);
$this->setData($data);
}
/**
* {@inheritDoc}
*/
protected function fetchData()
{
parent::fetchData();
$data = array();
$data = $this->fetchPublicationsData($data);
$data = $this->fetchAuthorData($data);
$this->setData($data);
}
