public function actionIndex($id = '')
{
$m = false;
$i = 0;
$publicaciones = false;
$colaboradores = false;
$patentes = false;
$listado = false;
$filtrado = false;
$mRelAcadLin = false;
if ($id != '') {
$intID = intval($id);
if ($intID > 0) {
$m = Yii::app()->db->createCommand()->from('sn_academico')->where('id_sitio = :id', array(':id' => (int) $id))->queryAll();
$publicaciones = Yii::app()->db->createCommand()->select('pub.titulo as nombre_pub, pub.id_academico, pub.thumbnail, pub.pdf, pub.anio, pub.area, pub.categoria as cat, c.categoria, pub.enlace, pub.resumen, aca.*, pub.id as iden')->from('sn_academico as aca')->leftJoin('sn_publicaciones as pub', 'pub.id_academico = aca.id')->join('sn_categorias c', 'c.id_categoria = pub.categoria')->where('aca.id_sitio = :id', array(':id' => (int) $id))->queryAll();
if (count($publicaciones) > 0) {
$colaboradores = array();
foreach ($publicaciones as $data) {
$colaboradores[$data['iden']] = Yii::app()->db->createCommand()->from('sn_publicaciones_colaboradores')->where("id_publicacion = {$data['iden']}")->queryAll();
}
}
$patentes = Yii::app()->db->createCommand()->select('pa.*')->from('sn_academico as aca')->leftJoin('sn_patentes as pa', 'pa.id_academico = aca.id')->where('aca.id_sitio = :id', array(':id' => (int) $id))->queryAll();
$laboratorios = Yii::app()->db->createCommand()->from('sn_laboratorios')->where('id_sitio = :id', array(':id' => (int) $id))->queryAll();
$i = Yii::app()->db->createCommand()->from('sn_sitios')->where('id=:id', array(':id' => (int) $id))->queryRow();
if (!empty($i)) {
$listado = Yii::app()->db->createCommand()->from('sn_lineas')->where('id_sitios=:idL', array(':idL' => $i['id']))->queryAll();
}
} else {
// echo "Es cadena";
$i = Yii::app()->db->createCommand()->from('sn_sitios')->where(array('like', 'nombre_instituto', '%' . $id . '%'))->queryRow();
if ($i) {
$m = Yii::app()->db->createCommand()->from('sn_academico')->where('id_sitio=:id', array(':id' => $i['id']))->queryAll();
$laboratorios = Yii::app()->db->createCommand()->from('sn_laboratorios')->where('id_sitio = :id', array(':id' => (int) $i['id']))->queryAll();
}
}
$this->render('index', array('dataAcademico' => $m, 'dataInstitucion' => $i, 'publicaciones' => $publicaciones, 'colaboradores' => $colaboradores, 'laboratorios' => $laboratorios, 'lineas' => $listado, 'patentes' => $patentes, 'check' => true, 'filter' => false, 'lines' => false, 'inst' => false, 'acad' => false, 'rel_linea_academico' => false));
} else {
$i = SnSitios::model()->findAll();
$this->render('index', array('dataInstitucion' => $i, 'dataAcademico' => false, 'check' => false, 'listado' => false, 'filter' => false, 'rel_linea_academico' => $mRelAcadLin));
}
}
public function getSitio($id)
{
$data1 = SnSitios::model()->findByPk($id);
if (!empty($id)) {
return '(' . $data1->siglas_instituto . ')' . $data1->nombre_instituto;
} else {
return "No hay Sitio registrado";
}
}
public function id_sitioChoices()
{
$m = SnSitios::model()->findAll();
$return = array();
foreach ($m as $data) {
$return[$data->id] = $data->nombre_instituto;
}
return $return;
}
public function actionIndex($id = '')
{
$mSitios = SnSitios::model()->findAll();
$this->render('index', array('data' => $mSitios, 'check' => true));
}
public function loadInst()
{
$baseUrl = Yii::app()->baseUrl;
$imgURL = $baseUrl . "/uploads/snsitios/logo_instituto/";
$mIns = SnSitios::model()->findAll();
//---
foreach ($mIns as $m) {
$up = strtoupper($m['nombre_instituto'][0]);
if ($m['logo_instituto'] != "") {
$img = $imgURL . $m['logo_instituto'];
} else {
$img = $baseUrl . "/images/institute.png";
}
// echo $baseUrl."/uploads/snsitios/logo_instituto/".$m['logo_instituto'];
echo "<div id='institucion' class='main hidden letter-" . $up . "'>\n <a href='" . $baseUrl . "/index.php/insideSite?id=" . $m['id'] . "'>\n <div id='cardsMainGrid' class='institute letter-" . $up . " main ' >\n <div id='c1' class='hidden'>" . $m['nombre_instituto'] . "</div>\n <img id='imgCards' src='" . $img . "'>\n </div>\n </a></div>";
}
// foreach($mIns as $data){
// echo "<div id='institucion' class='main hidden'>".$data['nombre_instituto']."</div>";
// }
}
