AND r.status = rs.id
AND r.fecha BETWEEN '20090101' AND '20090131'
AND r.status IN (1,2,3,4)
AND r.tipo IN (1,2,3,4)
GROUP BY a.nombre,
t.nombre ,
r.fecha ,
tr.nombre ,
rs.nombre
) resultados
GROUP BY resultados.Agencias,
resultados.Fecha ,
resultados.Tipo ";
#" LIMIT 0,5";
$g = new Grid();
GridDataSource::Fill($g, $sql);
#$g->AppendRowsTotal();
$total_adultos = array(1,3,5,7);
$total_ninios = array(2,4,6,8);
#$g->SpecialRowTotal($g->grid[1], $total_adultos);
$g->AppendSpecialRowsTotal($total_adultos);
$g->AppendSpecialRowsTotal($total_ninios);
#--------------------------------
$g->AppendColumnTotal(1);
$g->AppendColumnTotal(2);
$g->AppendColumnTotal(3);
#include("../../infopix.core.php5/Security/SecurityManager.class.php");
include("../../infopix.core.php5/Utilities/Application.class.php");
#include("../../includes/lock.php");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<div id="">
<h3>Sites</h3>
<a href="../insert/sites.php" class="agregar">Agregar</a><br />
<?
$sql = "SELECT * FROM sites";
$g = new Grid();
GridDataSource::Fill($g, GridSorter::SortQuery($sql, $_REQUEST[order]));
$a = new htmlLink("../select/userinfo.php?id=","Detalles",0,"?id=","newWindow('../usersinfo.php?id=*','windowTittle')");
$b = new htmlLink("../update/sites.php?id=","Editar",0,"", "");
$c = new htmlLink("../delete/delete.php?tabla=sites&redirect=../select/sites.php&id=", "Eliminar", 0, "", "");
$links = array($a, $b, $c);
echo GridSortPage::Render($sql, $links, $_REQUEST['order'], 50, $_REQUEST['pag']);
?>
</div>
</body>
</html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<div id="">
<h3>ALBUMS</h3>
<a href="javascript:;" onClick="get('insert/albums.php','content')" class="agregar">Agregar album</a><br />
<?
$order="";
$pag="";
if(isset($_GET['order']) && $_GET['order']!="") $order=$_GET['order'];
if(isset($_GET['pag']) && $_GET['pag']!="") $pag=$_GET['pag'];
$sql = "SELECT * FROM albums";
$g = new Grid();
GridDataSource::Fill($g, GridSorter::SortQuery($sql, $order));
//$a = new htmlLink("../select/userinfo.php?id=","Detalles",0,"?id=","newWindow('../usersinfo.php?id=*','windowTittle')");
$b = new htmlLink("javascript:;","Editar",0,"", "get('update/albums.php?id=*','content')");
$c = new htmlLink("javascript:;", "Eliminar", 0, "", "get('delete/albums.php?id=*','content'); get('select/albums.php','content'); $('#mensajes').empty(); $('#mensajes').show(); desaparece('mensajes'); ");
$links = array( $b, $c);
echo GridSortPage::Render($sql, $links, $order, 25, $pag);
?>
<a href="javascript:;" onClick="get('select/fotos.php','content')" class="agregar">Administrador de Fotos</a><br />
</div>
</body>
</html>