//$op = Request::get("op");
//$r = Request::get("r");
$filtro = Request::get("filtro");
if ($filtro === null) {
$params = array();
$condicion = "1=1";
} else {
$params["filtro"] == $filtro . "%";
$condicion = "Name like :filtro";
}
$order = Request::get("order");
$orderby = "Name, CountryCode, ID";
if ($order !== null) {
$orderby = "{$order}, {$orderby}";
}
$registros = $gestor->count($condicion, $params);
$paginacion = new Pager($registros, Request::get("rpp"), Request::get("pagina"));
$parametros = new QueryString();
$op = null;
$ciudades = $gestor->getList($paginacion->getPaginaActual(), $order, $paginacion->getRpp(), $condicion, $parametros);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>City</title>
<style>
body{
width: 100%;
margin: 0 auto;
}
<?php
require '../clases/AutoCarga.php';
header('Contet-Type: application/json');
$sesion = new Session();
$no = json_encode(array('login' => false));
$pagina = Request::req("pagina");
if ($pagina === null) {
$pagina = 1;
}
if ($sesion->isLogged()) {
$bd = new DataBase();
$gestor = new ManageCity($bd);
$pager = new Pager($gestor->count());
$paginas = $pager->getPaginas();
$ciudades = $gestor->getListJson($pagina);
echo '{"ciudades":' . $ciudades . ', "paginas": ' . $paginas . '}';
$bd->close();
} else {
echo $no;
}
