Bioneuroemoción® Colombia - Cursos, conferencias y prácticas grupales

{source}
<?php
header('Content-Type: text/html; charset=utf-8');
if (!defined('_JEXEC')) define( '_JEXEC', 1 );
if (!defined('JPATH_BASE')) define( 'JPATH_BASE', realpath(dirname(__FILE__).'/..' ));
require_once ( JPATH_BASE . '/includes/defines.php' );
require_once ( JPATH_BASE . '/includes/framework.php' );

$country_code = 'CO';

$db = JFactory::getDbo();
$db->setQuery('SET NAMES latin1');
$db->query();

$query = "
SELECT
Evento.*,
GROUP_CONCAT(Categoria.description ORDER BY Categoria.id SEPARATOR ', ') as requisitos
FROM eci_eventos Evento
INNER JOIN eci_localizations Localization ON Localization.id = Evento.localization_id
LEFT JOIN eci_eventos_categorias EventoCat ON EventoCat.model = Evento.model AND EventoCat.model_id = Evento.model_id
LEFT JOIN eci_categorias Categoria ON Categoria.id = EventoCat.categoria_id
WHERE
Localization.country_code = '$country_code'
AND visible = 1
AND fecha > NOW()
GROUP BY Evento.model, Evento.model_id
ORDER BY fecha
";
$db->setQuery($query);
$eventos = $db->loadAssocList();

$modalidad = ['O' => 'Online', 'P' => 'Presencial', 'SP' => 'Semipresencial'];
?>
<script type="application/javascript" src="https://www.enriccorberainstitute.com/templates/yoo_joy/warp/vendor/uikit/js/components/grid.js"></script>
<style>

h2{
font-weight: 600;
letter-spacing: normal;
}
.uk-text-large {
font-size: 25px;
line-height: 36px;
font-weight: 600;
}
li{
color: #404042;
}
.uk-button-small{
padding: 0 25px;
}

</style>
<div class="uk-grid uk-margin-small-top">
<?php if (sizeof($eventos) == 0) echo '<div class="uk-width-1-1 uk-text-center" data-uk-grid-margin=""><p class="uk-h4">Por el momento, no tenemos eventos programados.</p></div>';
else{
foreach($eventos as $i => $evento){ ?>
<div class="uk-width-1-1 uk-margin-bottom">
<div class="uk-grid uk-grid-small" data-uk-grid-margin="">
<div class="uk-width-small-1-1 uk-width-medium-3-4">
<h2 class="uk-h4"><?php echo $evento['titulo']; ?></h2>
<ul class="uk-list">
<?php if (!empty($evento['ponente'])){ ?><li><strong class="text-uppercase">Ponente:</strong> <?php echo $evento['ponente']; ?></li><?php } ?>
<?php if($evento['modality'] != 'O'){ ?> <li><strong class="text-uppercase">Localización:</strong> <?php echo $evento['titulo']; ?></li><?php } ?>
<li><strong class="text-uppercase">Modalidad:</strong> <?php echo $modalidad[$evento['modality']] ?: ''; ?></li>
<li><strong class="text-uppercase">Día y hora inicial:</strong> <?php echo Date('j/m/Y \- G:m\h', strtotime($evento['fecha'])); ?></li>
<li><strong class="text-uppercase">Día y hora final:</strong> <?php echo Date('j/m/Y \- G:m\h', strtotime($evento['fecha_fin'])); ?></li>
<li><strong class="text-uppercase">Requisitos:</strong>&nbsp;<?php echo $evento['requisitos'] ?: 'Este evento no requiere ninguna formación en bioneuroemoción previa'; ?></li>
</ul>
</div>
<div class="uk-width-small-1-1 uk-width-medium-1-4 uk-text-right uk-panel uk-hidden-small">
<span class="uk-text-large"><?php echo number_format($evento['precio'], 2); ?>&euro;</span>
<br/>
<?php if ($evento['plazas_disponibles'] > 0 && !$evento['cerrado']){ ?>
<a class="uk-button uk-button-primary uk-margin-small uk-button-small" href="/<?php echo $evento['url']; ?>">Más información</a>
<?php }else{ ?>
<a class="uk-button uk-button-primary uk-margin-small uk-button-small uk-badge-danger" href="/<?php echo $evento['url']; ?>">Plazas agotadas</a>
<?php } ?>
</div>
<div class="uk-width-1-1">
<hr>
</div>
</div>
</div>
<?php }} ?>
</div>
<script>jQuery('title').text('Conferencias y Seminarios Bioneuroemoción - Enric Corbera Institute');</script>
<!-- remarketing -->
<script type="text/javascript">
var google_tag_params = {
edu_pid: ["<?php echo implode('","', array_map(function($evento){ return $evento['model_adwords'] . $evento['model_id']; }, $eventos)); ?>"],
edu_pagetype: "program"
};
</script>