1 ## -*- coding: utf-
8 -*-
2 <%page
args=
"account, formatLang" />
3 %if account.ledger_lines and account.partners_order:
5 account_total_debit =
0.0
6 account_total_credit =
0.0
7 account_balance_cumul =
0.0
8 account_balance_cumul_curr =
0.0
11 <div class=
"account_title bg" style=
"width: 1080px; margin-top: 20px; font-size: 12px;">${account.code} - ${account.name}
</div>
13 %for partner_name, p_id, p_ref, p_name in account.partners_order:
18 cumul_balance_curr =
0.0
20 part_cumul_balance =
0.0
21 part_cumul_balance_curr =
0.0
23 <div class=
"act_as_table list_table" style=
"margin-top: 5px;">
24 <div class=
"act_as_caption account_title">
25 ${partner_name or _('No Partner')}
27 <div class=
"act_as_thead">
28 <div class=
"act_as_row labels">
30 <div class=
"act_as_cell first_column" style=
"width: 60px;">${_('Date')}
</div>
32 <div class=
"act_as_cell" style=
"width: 70px;">${_('Period')}
</div>
34 <div class=
"act_as_cell" style=
"width: 100px;">${_('Entry')}
</div>
36 <div class=
"act_as_cell" style=
"width: 70px;">${_('Journal')}
</div>
38 <div class=
"act_as_cell" style=
"width: 120px;">${_('Partner')}
</div>
40 <div class=
"act_as_cell" style=
"width: 100px;">${_('Reference')}
</div>
42 <div class=
"act_as_cell" style=
"width: 180px;">${_('Label')}
</div>
44 <div class=
"act_as_cell" style=
"width: 80px;">${_('Rec.')}
</div>
46 <div class=
"act_as_cell" style=
"width: 60px;">${_('Due Date')}
</div>
48 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Debit')}
</div>
50 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Credit')}
</div>
52 <div class=
"act_as_cell amount" style=
"width: 80px;">${_('Cumul. Bal.')}
</div>
53 %if amount_currency(data):
55 <div class=
"act_as_cell amount sep_left" style=
"width: 80px;">${_('Curr. Balance')}
</div>
57 <div class=
"act_as_cell amount" style=
"width: 30px; text-align: right;">${_('Curr.')}
</div>
61 <div class=
"act_as_tbody">
68 return text.replace('-', '
‑') # replace by a non-breaking hyphen (it will not word-wrap between hyphen and numbers)
70 %for line in account.ledger_lines.get(p_id, []):
72 total_debit += line.get('debit') or
0.0
73 total_credit += line.get('credit') or
0.0
75 label_elements = [line.get('lname') or '']
76 if line.get('invoice_number'):
77 label_elements.append(
"(%s)" % (line['invoice_number'],))
78 label = ' '.join(label_elements)
80 <div class=
"act_as_row lines ${line.get('is_from_previous_periods') and 'open_invoice_previous_line' or ''} ${line.get('is_clearance_line') and 'clearance_line' or ''}">
82 <div class=
"act_as_cell first_column">${formatLang(line.get('ldate') or '', date=True)}
</div>
84 <div class=
"act_as_cell">${line.get('period_code') or ''}
</div>
86 <div class=
"act_as_cell">${line.get('move_name') or ''}
</div>
88 <div class=
"act_as_cell">${line.get('jcode') or ''}
</div>
90 <div class=
"act_as_cell overflow_ellipsis">${line.get('partner_name') or ''}
</div>
92 <div class=
"act_as_cell">${line.get('lref') or ''}
</div>
94 <div class=
"act_as_cell">${label}
</div>
96 <div class=
"act_as_cell">${line.get('rec_name') or ''}
</div>
98 <div class=
"act_as_cell">${formatLang(line.get('date_maturity') or '', date=True)}
</div>
100 <div class=
"act_as_cell amount">${formatLang(line.get('debit') or
0.0) | amount }
</div>
102 <div class=
"act_as_cell amount">${formatLang(line.get('credit') or
0.0) | amount }
</div>
104 <% cumul_balance += line.get('balance') or
0.0 %
>
105 <div class=
"act_as_cell amount" style=
"padding-right: 1px;">${formatLang(cumul_balance) | amount }
</div>
106 %if amount_currency(data):
108 <div class=
"act_as_cell sep_left amount">${formatLang(line.get('amount_currency') or
0.0) | amount }
</div>
110 <div class=
"act_as_cell" style=
"text-align: right; ">${line.get('currency_code') or ''}
</div>
114 <div class=
"act_as_row lines labels">
116 <div class=
"act_as_cell first_column"></div>
118 <div class=
"act_as_cell"></div>
120 <div class=
"act_as_cell"></div>
122 <div class=
"act_as_cell"></div>
124 <div class=
"act_as_cell"></div>
126 <div class=
"act_as_cell"></div>
128 <div class=
"act_as_cell">${_('Cumulated Balance on Partner')}
</div>
130 <div class=
"act_as_cell"></div>
132 <div class=
"act_as_cell"></div>
134 <div class=
"act_as_cell amount">${formatLang(total_debit) | amount }
</div>
136 <div class=
"act_as_cell amount">${formatLang(total_credit) | amount }
</div>
138 <div class=
"act_as_cell amount" style=
"padding-right: 1px;">${formatLang(cumul_balance) | amount }
</div>
139 %if amount_currency(data):
140 %if account.currency_id:
142 <div class=
"act_as_cell sep_left amount" style=
"padding-right: 1px;">${formatLang(cumul_balance_curr) | amount }
</div>
144 <div class=
"act_as_cell sep_left amount" style=
"padding-right: 1px;">${ u'-' }
</div>
147 <div class=
"act_as_cell" style=
"text-align: right; ">${ account.currency_id.name if account.currency_id else u'' }
</div>
153 account_total_debit += total_debit
154 account_total_credit += total_credit
155 account_balance_cumul += cumul_balance
156 account_balance_cumul_curr += cumul_balance_curr
159 <div class=
"act_as_table list_table" style=
"margin-top:5px;">
160 <div class=
"act_as_row labels" style=
"font-weight: bold; font-size: 12px;">
161 <div class=
"act_as_cell first_column" style=
"width: 520px;">${account.code} - ${account.name}
</div>
163 <div class=
"act_as_cell" style=
"width: 320px;">${_(
"Cumulated Balance on Account")}
</div>
165 <div class=
"act_as_cell amount" style=
"width: 80px;">${ formatLang(account_total_debit) | amount }
</div>
167 <div class=
"act_as_cell amount" style=
"width: 80px;">${ formatLang(account_total_credit) | amount }
</div>
169 <div class=
"act_as_cell amount" style=
"width: 80px; ">${ formatLang(account_balance_cumul) | amount }
</div>
170 %if amount_currency(data):
171 ## currency balance cumulated
172 %if account.currency_id:
173 <div class=
"act_as_cell amount sep_left" style=
"width: 80px;">${ formatLang(account_balance_cumul_curr) | amount }
</div>
175 <div class=
"act_as_cell amount sep_left" style=
"width: 80px; padding-right: 1px;">${ u'-' }
</div>
178 <div class=
"act_as_cell amount" style=
"width: 30px; text-align: right;">${ account.currency_id.name if account.currency_id else u'' }
</div>