Пример #1
0
  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);
Пример #2
0
#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>
Пример #3
0
<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>