access(); if(!$user->admin && $user->acceso == 'n'){ header('Location: main.php?error=1'); }else{ $user->print_to_log('Avisos'); } $fac = $user->facultad['facultad_id']; if($user->admin){ $fac = null; } $limit = 20; if(isset($_POST['filter_fecha']) && $_POST['filter_fecha'] != ""){ $filter_fecha = $_POST['filter_fecha']; } else{ $filter_fecha = null; } if(isset($_GET['pag'])){ $pag = $_GET['pag'] - 1; }else{ $pag = 0; } if($user->admin){ $count = query("SELECT count(1) FROM fs_aviso(null, :fecha, :facultad_id, null, 0, null)", [':fecha' => $filter_fecha, ':facultad_id' => $fac], true); $fs_avisos = query("SELECT * FROM fs_aviso(null, :fecha, :facultad_id, :limite, :offset, null)", [':fecha' => $filter_fecha, ':facultad_id' => $fac, ':limite' => $limit, ':offset' => $pag * $limit], false); }else{ $count = query("SELECT count(1) FROM fs_aviso(null, :fecha, :facultad_id, null, 0, true)", [':fecha' => $filter_fecha, ':facultad_id' => $fac], true); $fs_avisos = query("SELECT * FROM fs_aviso(null, :fecha, :facultad_id, :limite, :offset, true)", [':fecha' => $filter_fecha, ':facultad_id' => $fac, ':limite' => $limit, ':offset' => $pag * $limit], false); } $paginas = ceil($count['count'] / $limit); ?>