{{extend 'plantilla.html'}}
<h1>Gastos</h1>
{{=forma}}
{{=excel}}
{{
	total=0
	iva=0
	subtotal=0
}}
<table border='1' width="100%">

{{=TR(TD('Fecha'),TD('Proveedor'),TD('Num Doc'),TD('Tipo Doc'),TD('Comentarios'),TD('Subtotal',_width="60"),TD('IVA',_width="60"),TD('Total',_width="60"),TD('Status'))}}
{{for r in consulta:
	subtotal=subtotal+r.subtotal
	iva=iva+r.iva
	total=total+r.total }}
{{=TR(TD(r.fecha.strftime('%Y-%m-%d')),TD(r.proveedor),TD(r.numdocumento),
    TD(r.tipodocumento),TD(r.comentarios),TD(DIV('%.2f'%r.subtotal,_align='right')),
    TD(DIV('%.2f'%r.iva,_align='right')),TD(DIV('%.2f'%r.total,_align='right')),
    TD(r.status))}}
{{pass}}
<tr style="background-color: yellow;text-align: right">
	<td>Totales</td>
	<td colspan="4"></td>
	<td align="right">{{='%.2f'%subtotal}}</td>
	<td align="right">{{='%.2f'%iva}}</td>
	<td align="right">{{='%.2f'%total}}</td>
	<td></td>
</tr>
</table>