1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
<!DOCTYPE html SYSTEM
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">
${css}
</style>
</head>
<body style="border:0; margin: 0;" onload="subst()" >
<!--
<h1><center>4 QTR | YTD</center></h1>
-->
%for obj in objects:
<table>
<tr>
<td width="30%">
<div>${helper.embed_image('jpeg',str(obj.company_id.logo),250, 120)}</div>
</td>
<td width="70%">
<table style="width: 100%; text-align:center;">
<tr><td><div class="td_company_title">${obj.company_id.name or ''|entity}</div></td></tr>
<tr><td><div class="td_company">${obj.get_parser_method('get_vat_by_country',data['form']) or ''|entity}</div></td></tr>
<tr><td><div class="td_company">${obj.get_parser_method('get_informe_text',data['form']) or ''| entity}</div></td></tr>
<tr><td><div class="td_company">${_(Expressed in data['form'] and (' %s'% obj.get_parser_method('exchange_name',data['form'])) or '')}</div></td></tr>
<tr><td><div class="td_company"> ${data['form'] and obj.get_parser_method('get_month',data['form']) or ''}</div></td></tr>
</table>
</td>
<td>
</td>
</tr>
</table>
<table style="widtd: 100%; text-align:center;">
<tr>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('Code')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="30%">${_('ACCOUNT')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('Q1')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('Q2')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('Q3')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('Q4')}</td>
<td class="celdaTituloTabla" style="text-align:center;"
width="10%">${_('YTD')}</td>
</tr>
%for line in obj.get_parser_method('lines',data['form']):
<tr>
%if line['type'] != 'view':
<tr class="prueba">
<td class="celdaLineDataName">${line['label']==True and line['code'] or ''}</td>
<td class="celdaLineDataName" >${ line['type']=='view' and line['name'].upper() or line['name'].title()}</td>
<td class="celdaLineDataName" style="text-align:right;">${(line['total']==True) and formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataName" style="text-align:right;">${(line['total']==True) and formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataName" style="text-align:right;">${(line['total']==True) and formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataName" style="text-align:right;">${(line['total']==True) and formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataName" style="text-align:right;">${(line['total']==True) and formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
</tr>
%elif line['total'] and not line['label']:
<tr class="prueba">
<td class="celdaLineDataTotal" style="font-style: italic;">${(line['label'] == True ) and line['code'] or ''}</td>
<td class="celdaLineDataTotal" style="text-align:right;">${(line['type'] == 'view') and line['name'].upper() or line['name'].title() or ''}</td>
<td class="celdaLineDataTotal">${(line['total']==True) and formatLang(line['bal1'] and (line['bal1'] * line.get('change_sign',1)) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataTotal">${(line['total']==True) and formatLang(line['bal2'] and line['bal2'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataTotal">${(line['total']==True) and formatLang(line['bal3'] and line['bal3'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataTotal">${(line['total']==True) and formatLang(line['bal4'] and line['bal4'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
<td class="celdaLineDataTotal">${(line['total']==True) and formatLang(line['bal5'] and line['bal5'] * line.get('change_sign',1) or 0.0, digits=2, grouping=True) or ''}</td>
</tr>
%else:
<tr class="prueba">
<i><td class="celdaLineDataView" width="10%">${(line['label'] == True ) and line['code'] or ''}</td></i>
<td class="celdaLineDataNameView" width="30%">${(line['type'] == 'view') and line['name'].upper() or line['name'].title() or ''}</td>
<td class="celdaLineDataNameView"></td>
<td class="celdaLineDataNameView"></td>
<td class="celdaLineDataNameView"></td>
<td class="celdaLineDataNameView"></td>
<td class="celdaLineDataNameView"></td>
</tr>
%endif
%endfor
%endfor
</body>
</html>
|