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