{{extend 'plantilla.html'}}
<h1>Inventario</h1>
<h2>{{=excel}}</h2>
{{=forma}}
<table border='1'>

{{=TR(TD('Fecha'),TD('Tipo'),TD('Cantidad'),TD('Costo'),TD('Alumno'),TD('Subtotal'),TD('IVA'),TD('Total'))}}
{{for r in consulta:}}
{{=TR(TD(r.kardex.fecha.strftime('%Y-%m-%d')),TD(r.kardex.tipo),TD(r.kardex.cantidad),
    TD(r.kardex.costo),TD(r.alumnos.nombre),TD(DIV("",_align='right')),
    TD(DIV("",_align='right')),TD(DIV("",_align='right')))}}
{{pass}}
<tr style="background-color: yellow">
	<td>Totales</td>
	<td colspan="4"></td>
	<td align="right"><div>{{=subtotal}}</div></td>
	<td align="right"><div>{{=iva}}</div></td>
	<td align="right"><div>{{=total}}</div></td>
</tr>
</table>