/** * {@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); }