{{extend 'plantilla.html'}}
{{from decimal import Decimal}}
{{
	import locale
	locale.setlocale( locale.LC_ALL, '' )
}}
<h1>Acumulado de ingresos</h1>
{{=forma}}
{{=excel}}
{{=pdf}}
<table>
	<thead>
	<tr	>
		<th colspan="2">Bancos</th>
	</tr>
	</thead>
	<tr>
		<td>
			Cheques
		</td>
		<td  style="text-align:right">
		{{=locale.format('%.2f', cheques, True)}}
		</td>
	</tr>
	<tr>
		<td>
			Transferencia
		</td>
		<td  style="text-align:right">
			{{=locale.format('%.2f', transferencia, True)}}
		</td>
	</tr>
	<tr>
		<td>
			Tarjeta
		</td>
		<td  style="text-align:right">
			{{=locale.format('%.2f', tarjeta, True)}}
		</td>
	</tr>
	<tr style="background-color: yellow;text-align: right">
		<td>
			Total
		</td>
		<td >
			{{=locale.format('%.2f', totalbancos, True)}}
		</td>
	</tr>
</table>
<br />
<br />
<table>
	<thead>
	<tr	>
		<th colspan="2">Caja</th>
	</tr>
	</thead>
	<tr>
		<td>
			Efectivo
		</td>
		<td>
			{{=locale.format('%.2f', efectivo, True)}}
		</td>
	</tr>

</table>
<br />
<br />
<table>
	<thead>
		<tr>
			<td colspan="7"><h4>Gastos Pendientes</h4></td>
		</tr>
		<tr>
			<td><strong>Fecha</strong></td>
			<td><strong>Proveedor</strong></td>
			<td><strong>Num Docto</strong></td>
			<td><strong>Tipo Docto</strong></td>
			<td><strong>Comentarios</strong></td>
			<td><strong>Subtotal</strong></td>
			<td><strong>IVA</strong></td>
			<td><strong>Total</strong></td>
		</tr>
	</thead>
{{	
	totalgp=0
	ivagp=0
	subtotalgp=0
	for r in gastospendientes:
            ivagp=ivagp+r.iva
            subtotalgp=subtotalgp+r.subtotal
            totalgp=totalgp+r.total    
            =TR(TD(r.fecha),TD(r.proveedor),TD(r.numdocumento),TD(r.tipodocumento),TD(r.comentarios),TD(locale.format('%.2f', r.subtotal, True),_style="text-align:right"),TD(locale.format('%.2f', r.iva, True),_style="text-align:right"),TD(locale.format('%.2f', r.total, True), _style="text-align:right"))
   pass
   =TR(TD('Totales'),TD('',_colspan="4"),TD(locale.format('%.2f', subtotalgp, True),_style="text-align:right"),TD(locale.format('%.2f', ivagp, True),_style="text-align:right"),TD(locale.format('%.2f', totalgp, True),_style="text-align:right"),_style="background-color: yellow")         
}}

</table>
<br />
<br />
<table>
	<thead>
		<tr>
			<td colspan="7"><h4>Gastos Pagados</h4></td>
		</tr>
		<tr>
			<td><strong>Fecha</strong></td>
			<td><strong>Proveedor</strong></td>
			<td><strong>Num Docto</strong></td>
			<td><strong>Tipo Docto</strong></td>
			<td><strong>Comentarios</strong></td>
			<td><strong>Subtotal</strong></td>
			<td><strong>IVA</strong></td>
			<td><strong>Total</strong></td>
		</tr>
	</thead>
{{	
	totalg=0
	ivag=0
	subtotalg=0
	for r in gastos:
            ivag=ivag+r.iva
            subtotalg=subtotalg+r.subtotal
            totalg=totalg+r.total    
            =TR(TD(r.fecha),TD(r.proveedor),TD(r.numdocumento),TD(r.tipodocumento),TD(r.comentarios),TD('%.2f'%r.subtotal,_style="text-align:right"),TD('%.2f'%r.iva, _style="text-align:right"),TD('%.2f'%r.total,_style="text-align:right"))
   pass
   =TR(TD('Totales'),TD('',_colspan="4"),TD(locale.format('%.2f', subtotalg, True),_style="text-align:right"),TD(locale.format('%.2f', ivag, True), _style="text-align:right"),TD(locale.format('%.2f', totalg, True), _style="text-align:right"),_style="background-color: yellow")         
}}

</table>