933 18 08 28
HAZTE SOCIO{source}
<div id="seleccion" class="seleccion" style="display:none;">
<p style="text-align:center;"><img src="images/actualidad/pdf/logo-UPM-149x90.png" alt="logos cursos pdf" width="140" /></p>
<table border='1' style="font-size:10px;">
<tr>
<th>Categoría</th>
<th>Nombre</th>
<th>Fecha inicio</th>
<th>Fecha final</th>
<th>Expediente</th>
<th>Horas</th>
<th>Modalidad</th>
<th>Población</th>
<th>Horario</th>
</tr>
<?php
$nowdate = JFactory::getDate('now', new DateTimeZone('Europe/Madrid'));
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select($db->quoteName(array('a.id', 'a.catid', 'a.state','a.title','a.startdate','a.enddate','b.slug','b.value')))
->select($db->quoteName(array('c.title', 'a.title'), array('titulo','curso')))
->from($db->quoteName('jos_icagenda_events','a'))
->join ('INNER', $db->quoteName('jos_icagenda_customfields_data','b') . ' ON ' . $db->quoteName('a.id') . ' = ' . $db->quoteName('b.parent_id'))
->join ('INNER', $db->quoteName('jos_icagenda_category','c') . ' ON ' . $db->quoteName('a.catid') . ' = ' . $db->quoteName('c.id'))
->where ($db->quoteName('a.catid').' IN (4,5,6,7,8,9,10,11,12,13,14,15,21)')
->where ($db->quoteName('a.state'). ' = 1')
->where ($db->quoteName('a.enddate'). ' >= '. $db->quote($nowdate))
->group ('a.id')
->order ('a.catid ASC');
$db->setQuery($query);
$db->execute;
$results = $db->loadObjectList();
foreach ($results as $row){
$fecha_emp = new JDate($row->startdate);
$fecha_emp2 = $fecha_emp->format('j F Y');
$fecha_acab = new JDate($row->enddate);
$fecha_acab2 = $fecha_acab->format('j F Y');
?>
<tr>
<td><?php echo $row->titulo ?></td>
<td><?php echo $row->curso ?></td>
<td><?php echo $fecha_emp2 ?></td>
<td><?php echo $fecha_acab2 ?></td>
<?php
$db2 = JFactory::getDbo();
$query2 = $db2->getQuery(true);
$query2
->select($db2->quoteName(array( 'slug','value')))
->from($db2->quoteName('jos_icagenda_customfields_data'))
->where ($db2->quoteName('parent_id').' = '. $row->id)
->where ($db2->quoteName('slug'). 'IN ("expediente","horas_del_curso","modalidad","lugar_de_imparticion","horario")')
->order ('slug ASC');
$db2->setQuery($query2);
$db2->execute;
$results2 = $db2->loadAssocList();
?>
<td><?php echo $results2['0']['value']; ?></td>
<td><?php echo $results2['2']['value']; ?></td>
<td><?php echo $results2['4']['value']; ?></td>
<td><?php echo $results2['3']['value']; ?></td>
<td><?php echo $results2['1']['value']; ?></td>
</tr>
<?php } ?>
</table>
</div>
{/source}