/* Decoded by unphp.net */

?><?php
include("../../libreria/engine.php");
$condicion = "";
if(!isset($_GET["TxtFecha"]))
{
	echo "<script language='javascript'> actualizarPestana(); </script>";	
	exit();
}


if($_GET)
{
	
	$fecha = isset($_GET["TxtFecha"])?$_GET["TxtFecha"]:"";


	$sql = "SELECT m.cod as ckb,m.cod, m.fecha, m.det, b.titulo, m.cred AS monto, m.stad 
			FROM af_banco m
			LEFT JOIN af_mbanco b ON b.fondo = m.fdo
			WHERE det LIKE '%LEY%'
			AND m.tipo = 'DP'
			AND m.fecha <= '$fecha'
			ORDER BY m.fecha DESC";

	$dt = new dataTable($sql);
	$total = 0;
	if ($dt->numRows > 0)
	
	{
	
		foreach($dt->data["ckb"] as &$celda1)
		{
			$celda1 = "<label style='white-space:nowrap; '><input name='chkboxTransfer[]' type='checkbox' value='$celda1'></label>";
				} 
		
		foreach($dt->data["titulo"] as $pos=>&$valor)
		{
			$total += $dt->data["monto"][$pos];
			$dt->data["monto"][$pos] = "<div align='right'>". number_format($dt->data["monto"][$pos],2)."</div>";
			$dt->data["titulo"][$pos] = "<div align='center'>". $dt->data["titulo"][$pos]."</div>";
			$dt->rowActivo[$pos] =  ($dt->data["stad"][$pos]>0)?1:0;
		}
	}
	$grid = new dataGrid($dt);
	$grid->noVisibles = array("fondo");
	$grid->cambiarLabel("ckb" ,"<input type='checkbox' name='chkboxTransfer[]' onclick='seleccionarChecks(this);' />");
	$grid->cambiarLabel("titulo" ,"Cuenta Bancaria");
	$grid->cambiarLabel("det" ,"Detalles");
	$grid->cambiarLabel("monto" ,"Transferido");
	
	$grid->noVisibles = array("stad", "cod");
}
?>

<style>
	#divBotonesMV button
	{
		margin-left:70px;
	
	}

</style>
<div id ="divresultadotransfer"></div>
Se Muestran <?php $dt->numRows; ?> Registros por $  <?php $total; ?>

<div id="divBotonesMV">
		<button type="button" onclick="ImprimirPDF('modulos/reporte/banco/RListaTransfer.php')" class="btnPrint" title = "Imprimir Lista" style = ''></button>
</div>

<div style="overflow:auto; height:300px;">
	<?php $grid->display(); ?>
</div>

	

<script language="javascript">
	

</script>