<head>
<title>Consulta de Caja</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="estilos.css">
<style>P {page-break-before: always}</style>
</head>
<body>
<CENTER>
<TABLE width="90%"><tr>
<TD align=left><img src="images/logo.jpg" height="40" ></TD>
<TD align=center>
<TABLE cellspacing=0 border=0 cellpadding=0>
<?php
echo "<TR><TD><B>" . traevalor("TITULO1") . "</B></TD></TR>";
echo "<TR><TD align=center><FONT SIZE=-1>" . traevalor("SUCURSAL") . "</FONT></TD></TR>";
echo "<TR><TD align=center><FONT SIZE=-1>" . traevalor("TITULO7") . "</FONT></TD></TR>";
?>
</TR></TABLE>
</TD>
<TD align=right><img src="images/hiperdata.jpg" height="40" ></TD>
</TR>
</TABLE>
<b class="style3">ARQUEO DE CAJAS AL <?php
echo $fecha;
?>
</b>
<br>
<TABLE width=90% border=1><tr><td><B>CIERRE DE CAJEROS</B></TD></TR></TABLE>
<?php
$query = "SELECT a.caja, b.nombre, a.trecibe, a.computa,\n if(a.trecibe-a.computa<0,a.trecibe-a.computa,0),\n if(a.trecibe-a.computa>0,a.trecibe-a.computa,0)\n FROM dine AS a LEFT JOIN scaj AS b ON a.cajero=b.cajero\n WHERE a.fecha={$qfecha} AND MID(a.caja,1,1)='0' ORDER BY a.caja ";
$query_result_handle = damecur($query);
# FORMATOS
$h =& $wb->addformat(array("bold" => 1, "size" => 16, "merge" => 1));
$h1 =& $wb->addformat(array("bold" => 1, "size" => 11, "align" => 'left'));
$titulo =& $wb->addformat(array("bold" => 1, "size" => 9, "merge" => 0, "fg_color" => 'silver'));
$cuerpo =& $wb->addformat(array("size" => 9));
$cuerpoc =& $wb->addformat(array("size" => 9, "align" => 'center', "merge" => 1));
$cuerpob =& $wb->addformat(array("size" => 9, "align" => 'center', "bold" => 1, "merge" => 1));
$numero =& $wb->addformat(array("num_format" => '#,##0.00', "size" => 9));
$Tnumero =& $wb->addformat(array("num_format" => '#,##0.00', "size" => 9, "bold" => 1, "fg_color" => 'silver'));
$Rnumero =& $wb->addformat(array("num_format" => '#,##0.00', "size" => 9, "bold" => 1, "align" => 'right'));
# COMIENZA A ESCRIBIR
$nomes = substr($mes, 4, 2);
$nomes1 = $anomeses[$nomes];
$hs = "LIBRO DE VENTAS CORRESPONDIENTE AL MES DE " . $anomeses[$nomes] . " DEL " . substr($mes, 0, 4);
$ws->write(1, 0, traevalor('TITULO1'), $h1);
$ws->write(2, 0, "RIF: " . traevalor('RIF'), $h1);
$ws->write(4, 0, $hs, $h);
for ($i = 1; $i < 20; $i++) {
$ws->write_blank(4, $i, $h);
}
//$ws->write_string( $mm, $ii , $mvalor );
$mm = 6;
// TITULOS
$ws->write_string($mm, 0, "", $titulo);
$ws->write_string($mm + 1, 0, "Fecha", $titulo);
$ws->write_string($mm + 2, 0, "", $titulo);
$ws->write_string($mm, 1, "Nombre, Razon Social", $titulo);
$ws->write_string($mm + 1, 1, "o Denominacion del ", $titulo);
$ws->write_string($mm + 2, 1, "Comprador", $titulo);
$ws->write_string($mm, 2, "", $titulo);
$ws->write_string($mm + 1, 2, "R.I.F. o", $titulo);