public function actionIndex($id = '')
{
$intID = intval($id);
$check = false;
$mLineas = false;
$rel = false;
$inside = false;
$pubs = false;
$projs = false;
$colaboradores = false;
$patentes = false;
$productos = false;
$academico = false;
if ($intID >= 0) {
// echo $intID;
if ($intID == 0) {
//show all Lines
$data = explode(" ", $id);
if (!empty($data[0])) {
$check = true;
$mLineas = Yii::app()->db->createCommand()->from('sn_lineas')->where(array('like', 'nombre_linea', '%' . $data[0] . '%'))->queryAll();
if ($mLineas) {
$pubs = Yii::app()->db->createCommand()->select('a.id, a.titulo, a.pdf, a.thumbnail, a.anio, a.area, a.categoria as cat, c.categoria, a.enlace, a.resumen')->from('sn_lineas b')->join('sn_publicaciones a', 'b.id_categoria = a.area')->join('sn_categorias c', 'c.id_categoria = a.categoria')->where('b.id=:id', array(':id' => $id))->queryAll();
$colaboradores = array();
foreach ($pubs as $data) {
$colaboradores[$data['id']] = Yii::app()->db->createCommand()->from('sn_publicaciones_colaboradores')->where("id_publicacion = {$data['id']}")->queryAll();
}
$projs = Yii::app()->db->createCommand()->select('p.id, p.nombre_proyecto, p.tipo_proyecto, p.vigencia, rla.id_academico, a.nombre, a.apellido_paterno, a.titulo')->from('sn_lineas l')->join('rellin_acad rla', 'rla.id_lineas = l.id')->join('relProj_Acad rpa', 'rpa.id_academico = rla.id_academico')->join('sn_proyectos p', 'p.id = rpa.id_proyecto')->join('sn_academico a', 'a.id = rla.id_academico')->where('l.id = :id', array(':id' => $id))->queryAll();
}
} else {
$check = true;
$mLineas = SnLineas::model()->findAll();
}
}
if ($intID > 0) {
$mLineas = Yii::app()->db->createCommand()->from('sn_lineas')->where('id=:id', array(':id' => (int) $id))->queryRow();
if ($mLineas) {
$check = true;
$inside = true;
}
$academico = Yii::app()->db->createCommand()->select('a.*')->from('rellin_acad b')->join('sn_academico a', 'a.id = b.id_academico')->where('b.id_lineas = :id', array(':id' => $mLineas['id']))->queryAll();
$projs = Yii::app()->db->createCommand()->select('p.*')->from('sn_proyectos as p')->join('sn_academico as aca', 'aca.id = p.id_academico')->join('rellin_acad as rel', 'rel.id_academico = aca.id')->where('rel.id_lineas = :id', array(':id' => (int) $id))->queryAll();
$productos = array();
$patentes = array();
if ($projs) {
foreach ($projs as $data) {
$productos[$data['id']] = Yii::app()->db->createCommand()->from('sn_producto')->where("id_proyecto = {$data['id']}")->queryAll();
}
$patentes = Yii::app()->db->createCommand()->select('a.id, a.id_academico, a.nombre, a.figura, a.especifique, a.fecha')->from('sn_patentes a')->join('sn_academico b', 'b.id = a.id_academico')->leftJoin('rellin_acad c', 'c.id_academico = b.id')->where('c.id_lineas = :id', array(':id' => (int) $id))->queryAll();
$pubs = Yii::app()->db->createCommand()->select('a.id,a.id_academico, a.titulo, a.pdf, a.thumbnail, a.anio, a.area, a.categoria as cat, a.enlace, a.resumen')->from('sn_publicaciones a')->join('sn_academico b', 'b.id = a.id_academico')->leftJoin('rellin_acad c', 'c.id_academico = b.id')->where('c.id_lineas = :id', array(':id' => (int) $id))->queryAll();
$colaboradores = array();
if (count($pubs) > 0) {
foreach ($pubs as $data) {
$colaboradores[$data['id']] = Yii::app()->db->createCommand()->from('sn_publicaciones_colaboradores')->where("id_publicacion = {$data['id']}")->queryAll();
}
}
}
}
}
$this->render('index', array('data' => $id, 'inside' => $inside, 'Lineas' => $mLineas, 'academico' => $academico, 'productos' => $productos, 'patentes' => $patentes, 'colaboradores' => $colaboradores, 'check' => $check, 'pubs' => $pubs, 'proyectos' => $projs));
}
public function id_lineasChoices()
{
$m = SnLineas::model()->findAll();
$return = array();
foreach ($m as $data) {
$return[$data->id] = $data->nombre_linea;
}
return $return;
}
public function loadLines()
{
$mLin = SnLineas::model()->findAll();
foreach ($mLin as $m) {
$up = strtoupper($m['nombre_linea'][0]);
?>
<div id='lineas' class='main letter-<?php
echo $up;
?>
hidden'>
<div id='cardsInsideGridLines' class='tarjetas letter-<?php
echo $up;
?>
' >
<div id='containerAcademico'>
<div id='c1'><bText17><?php
echo $m['nombre_linea'];
?>
</bText17></div>
<a href='index.php/insideLine?id=<?php
echo $m['id'];
?>
'>
<div id='btnLink'> Leer más </div></a>
</div>
</div> </div>
<?php
}
// foreach($mLin as $data){
// $up = strtoupper($data['nombre_linea'][0]);
// // echo "<div id='lineas' class='main letter-{$up} hidden'>".$data['nombre_linea']."</div>";
// echo "<div id='lineas' class='main hidden letter-".$up." '>
// <a href='index.php/insideSite?id=".$data['id']."'>
// <div id='cardsMainGrid' class='institute letter-".$up." main ' >
// <div id='c1' class='hidden'>".$data['nombre_linea']."</div>
// </div>
// </a></div>";
// }
}
