/** * @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'); }