/**
* Lista de comunicados enviados (SENT)
*/
function listEnviados()
{
global $uid;
$db = new DB();
$sql = "SELECT consecu, fecha, asunto, tipmens, fecvence, categoria, documto_id, borrado ";
$sql .= "FROM mensajes WHERE documto_id = '{$uid}' AND borrado = '0' ORDER BY consecu DESC ";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=comunicados&do=list');
$res = $objpag->result;
$data = array();
$x = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$x]['consecu'] = $line->consecu;
$data[$x]['fecha'] = $line->fecha;
$data[$x]['asunto'] = $line->asunto;
$data[$x]['tipmens'] = $line->tipmens;
$data[$x]['fecvence'] = $line->fecvence;
$data[$x]['categoria'] = $line->categoria;
$x++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Erudio_Smarty();
$tpl->assign('com', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('comunicados/comunicadosEnviados.tpl');
}
function listEncuestas()
{
global $uid, $uperms;
$where = "";
if (!$uperms['encuestas_w']) {
$where = "WHERE publicado = 's'";
}
$db = new DB();
$sql = "SELECT * FROM encuestas {$where}";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=encuestas&do=list');
$res = $objpag->result;
$data = array();
$x = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$x]['id'] = $line->id;
$data[$x]['titulo'] = $line->titulo;
$data[$x]['observaciones'] = $line->observaciones;
$data[$x]['fecha'] = $line->fecha;
$x++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Elfic_Smarty();
$tpl->assign('lista', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('encuestas/encuestasList.tpl');
}
/**
* @desc Construye listado de usuarios e imprime template
* @param $search
* @return void (imprime plantilla)
*/
function listAll($search = "", $grupo = "")
{
$where = "";
if ($search != "") {
$where .= "AND nombres LIKE '%{$search}%' OR apellidos LIKE '%{$search}%' ";
}
if ($grupo != "") {
$where .= "AND id IN (SELECT usuario_id " . "FROM usuarios_grupos_links WHERE usuarios_grupo_id = {$grupo}) ";
}
$db = new DB();
$sql = "SELECT * FROM usuarios ";
$sql .= "WHERE id > 0 " . $where;
$sql .= " ORDER BY nombres ASC";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=usuarios&do=search');
$res = $objpag->result;
$data = array();
$i = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$i]['id'] = $line->id;
$data[$i]['nombres'] = $line->nombres;
$data[$i]['apellidos'] = $line->apellidos;
$data[$i]['email'] = $line->email;
$data[$i]['creado'] = $line->creado;
$data[$i]['modificado'] = $line->modificado;
$data[$i]['ultimoingreso'] = $line->ultimoingreso;
$data[$i]['activo'] = $this->getIcon($line->activo);
$data[$i]['esadmin'] = $this->getIcon($line->esadmin);
$i++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Elfic_Smarty();
$g = new Grupos();
$tpl->assign('grupos', $g->getGruposArray());
$tpl->assign('grupo_id', $grupo);
$tpl->assign('u', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('usuarios/usuariosList.tpl');
}
function _buildReport($mid = "", $full = 0)
{
if ($mid != "") {
$and = "AND u.municipio_id = {$mid} ";
}
$sql = "SELECT u.id, u.name, u.username, u.email, u.usertype, u.block, u.sendEmail, ";
$sql .= "u.gid, u.registerDate, u.lastvisitDate, u.cedula, u.perfil, u.pais, ";
$sql .= "u.departamento, u.id_municipio, vereda, u.direccion, u.info_dir, ";
$sql .= "u.telefono, u.celular, u.fax, u.visito, u.aprobo, m.municipio, d.departamento ";
$sql .= "FROM mmb_users u ";
$sql .= "INNER JOIN municipio m ON m.id_municipio = u.id_municipio ";
$sql .= "INNER JOIN departamento d ON d.id_departamento = u.departamento ";
$sql .= "WHERE u.perfil IN(2,4,6,7) " . $and;
$sql .= " ORDER BY u.registerDate DESC";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 100, 'index2.php?com=reportes&do=usuarios');
$res = $objpag->result;
if ($full == 1) {
$db = new DB();
$res = $db->query($sql);
}
$d = array();
$x = 0;
$line = "";
while ($line = $objpag->fetchNextObject($res)) {
$d[$x]['id'] = $line->id;
$d[$x]['name'] = $line->name;
$d[$x]['username'] = $line->username;
$d[$x]['perfil'] = Usuarios::getNombrePerfil($line->perfil);
$d[$x]['municipio'] = $line->municipio;
$d[$x]['departamento'] = $line->departamento;
$d[$x]['productos'] = $this->getProductos($line->id);
$d[$x]['registerDate'] = $line->registerDate;
$x++;
}
$this->anchors = $objpag->anchors;
$this->total = $objpag->total;
return $d;
}
function listAsistenciaFuncionarios($funcionario = "")
{
global $uid, $uperms;
$and = "";
if (!$uperms['asistencia_w']) {
$and = "AND usuario_id = {$uid} ";
}
if ($funcionario != '') {
$and .= "AND a.usuario_id = {$funcionario} ";
}
$db = new DB();
$sql = "SELECT a.id, a.usuario_id, a.entrada, a.salida, a.comentarios, " . "CONCAT(u.nombres, ' ', u.apellidos) AS funcionario " . "FROM " . TBL_ASISTENCIA . " a INNER JOIN " . TBL_USUARIOS . " u ON u.id = a.usuario_id " . "WHERE a.id > 0 {$and} AND a.id NOT IN (SELECT asistencias_id FROM asistencias_tutores " . "WHERE asistencias_id = a.id)";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=asistencia&do=list_fun');
$res = $objpag->result;
$data = array();
$x = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$x]['id'] = $line->id;
$data[$x]['usuario_id'] = $line->usuario_id;
$data[$x]['funcionario'] = $line->funcionario;
$data[$x]['entrada'] = $line->entrada;
$data[$x]['salida'] = $line->salida;
$data[$x]['comentarios'] = $line->comentarios;
$x++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Elfic_Smarty();
$tpl->assign('funcionarios', Grupos::getUsuariosGrupo(3));
$tpl->assign('sel_func', $funcionario);
$tpl->assign('lista', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('asistencia/asistenciaFuncionariosList.tpl');
}
public function listar($curso = "", $tutor = "")
{
global $uid, $uperms, $starting;
$and = "";
if (!$uperms['evaluacion_w']) {
$and .= "AND e.estudiante_id = '{$uid}'";
}
if ($curso != "") {
$and .= "AND ct.nombre LIKE '%{$curso}%' ";
}
if ($tutor != "") {
$and .= "AND t.nombres LIKE '%{$tutor}%' OR t.apellidos LIKE '%{$tutor}%' ";
}
$db = new DB();
$sql = "SELECT e.id, e.estudiante_id, e.tutor_id, e.curso_id, e.concepto_tutor, " . "CONCAT(u.nombres, ' ', u.apellidos) AS estudiante, ct.nombre, ct.nombre AS catedra, " . "CONCAT(t.nombres, ' ', t.apellidos) AS tutor " . "FROM eval_tutores_estu e " . "INNER JOIN usuarios u ON e.estudiante_id = u.id " . "INNER JOIN usuarios t ON e.tutor_id = t.id " . "INNER JOIN cursos c ON e.curso_id = c.id " . "INNER JOIN catedra ct ON c.catedra_id = ct.id " . $and . " ORDER BY e.id DESC";
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=evaluacion');
$res = $objpag->result;
$data = array();
$x = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$x]['id'] = $line->id;
$data[$x]['estudiante_id'] = $line->estudiante_id;
$data[$x]['estudiante'] = $line->estudiante;
$data[$x]['curso_id'] = $line->curso_id;
$data[$x]['curso'] = $line->catedra;
$data[$x]['tutor_id'] = $line->tutor_id;
$data[$x]['tutor'] = Utils::getNombreUsuario($line->tutor_id);
$data[$x]['concepto'] = $line->concepto_tutor;
$x++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Elfic_Smarty();
$tpl->assign('data', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('evaluacion' . DS . 'evaluacionList.tpl');
}
public function listAll($curso = "")
{
global $uid, $uperms;
$and = "";
if (!$uperms['cursos_w']) {
$and .= "AND c.tutor_id = '{$uid}' ";
}
if ($curso != "") {
$and .= "AND ct.nombre LIKE '%{$curso}%' ";
}
$db = new DB();
$sql = "SELECT c.id, c.grupo, c.dia, c.hora, c.estado, ct.nombre, c.tutor_id, " . "CONCAT(p.anio,'-',p.semestre) AS periodo, " . "pr.programa, CONCAT(u.nombres, ' ', u.apellidos) AS tutor FROM cursos c " . "INNER JOIN catedra ct ON c.catedra_id = ct.id " . "INNER JOIN periodos p ON c.periodo_id = p.id " . "INNER JOIN programas pr ON ct.programas_id = pr.id " . "INNER JOIN usuarios u ON c.tutor_id = u.id " . "WHERE c.id > 0 {$and}";
if (isset($_GET['starting'])) {
$starting = $_GET['starting'];
} else {
$starting = 0;
}
$objpag = new Pagination($sql, $starting, 20, 'index2.php?com=cursos&do=search');
$res = $objpag->result;
$data = array();
$x = 0;
while ($line = $objpag->fetchNextObject($res)) {
$data[$x]['id'] = $line->id;
$data[$x]['programa'] = $line->programa;
$data[$x]['grupo'] = $line->grupo;
$data[$x]['curso'] = $line->nombre;
$data[$x]['periodo'] = $line->periodo;
$data[$x]['tutor'] = $line->tutor;
$data[$x]['tutor_id'] = $line->tutor_id;
$data[$x]['dia'] = CatManUtils::getDiaNombre($line->dia);
$data[$x]['hora'] = $line->hora;
$data[$x]['agenda'] = $this->siTieneAgenda($line->id);
$data[$x]['estado'] = Elfic::getBlockIcon($line->estado);
$x++;
}
$anchors = $objpag->anchors;
$total = $objpag->total;
$tpl = new Elfic_Smarty();
$tpl->assign('data', $data);
$tpl->assign('anchors', $anchors);
$tpl->assign('total', $total);
$tpl->display('cursos/cursosList.tpl');
}
