{"id":4166,"date":"2015-02-06T23:01:49","date_gmt":"2015-02-06T22:01:49","guid":{"rendered":"http:\/\/sidor.webs5.uvigo.es\/chus-longa-sayans-en\/"},"modified":"2015-02-06T23:01:49","modified_gmt":"2015-02-06T22:01:49","slug":"chus-longa-sayans-en","status":"publish","type":"post","link":"https:\/\/sidor.uvigo.es\/en\/chus-longa-sayans-en\/","title":{"rendered":"Chus Longa Say\u00e1ns"},"content":{"rendered":"

{source}<\/p>\n

<?php
class LastPublication{ <\/p>\n

public function getID(){
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select(‘id’);
$query->from(‘#__jresearch_member’);
$query->where(‘firstname = “Chus”‘);<\/p>\n

$db->setQuery($query);
$result = $db->loadResult();<\/p>\n

return $result;
}<\/p>\n

public function getLatestPublications() {
$n = 0;
$db = JFactory::getDBO();
$latestPub = array();
$memberId = $this->getID();<\/p>\n

$query = ‘SELECT p.* FROM ‘.$db->quoteName(‘#__jresearch_publication_internal_author’).’ ia JOIN ‘.$db->quoteName(‘#__jresearch_publication’).’ p WHERE ‘.$db->quoteName(‘p’).’.’.$db->quoteName(‘id’).’ = ‘.$db->quoteName(‘ia’).’.’.$db->quoteName(‘id_publication’).’ ‘.’ AND ‘.$db->quoteName(‘ia’).’.’.$db->quoteName(‘id_staff_member’).’ = ‘.$db->Quote($memberId).’ AND p.published = ‘.$db->Quote(‘1′).’ AND p.internal = ‘.$db->Quote(‘1′).’ ORDER BY ‘.$db->quoteName(‘p’).’.’.$db->quoteName(‘year’).’ DESC, STR_TO_DATE(p.’.$db->quoteName(‘month’).’, \\’%M\\’ ) DESC, ‘.’p.’.$db->quoteName(‘created’).’ DESC’;<\/p>\n

if($n > 0){
$query .= ‘ LIMIT 0, ‘.$n;
}<\/p>\n

$db->setQuery($query);
$result = $db->loadAssocList();
foreach($result as $row){
$latestPub[] = $row;
}<\/p>\n

return $latestPub;
}<\/p>\n

}<\/p>\n

?>
<\/span>{\/source}<\/p>\n

Chus Longa Say\u00e1ns<\/h1>\n
\n
\n
\"Chus<\/div>\n
\n

Technical Staff<\/h3>\n

Statistics and Operations Research Area (265)<\/p>\n

Department of Statistics and Operations Research (C05)<\/a><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

Member of Local Organising Committee of:<\/strong><\/p>\n