[MODULE] +v1.1.0 from https://www.odoo.com/apps/7.0/account_financial_report_webkit/

[burette/account_financial_report_webkit.git] / report / templates / grouped_by_curr_open_invoices_inclusion.mako.html

diff --git a/report/templates/grouped_by_curr_open_invoices_inclusion.mako.html b/report/templates/grouped_by_curr_open_invoices_inclusion.mako.html
new file mode 100644 (file)
index 0000000..91c49e4
--- /dev/null
+++ b/report/templates/grouped_by_curr_open_invoices_inclusion.mako.html
@@ -0,0 +1,173 @@
+## -*- coding: utf-8 -*-
+<%page args="account, formatLang" />
+%if account.grouped_ledger_lines and account.partners_order:
+    <%
+    account_total_debit = 0.0
+    account_total_credit = 0.0
+    account_balance_cumul = 0.0
+    account_balance_cumul_curr = 0.0
+    %>
+   %for partner_name, p_id, p_ref, p_name in account.partners_order:
+    <div class="account_title bg" style="width: 1080px; margin-top:
+      20px; font-size: 12px;">${account.code} - ${account.name} --  ${partner_name or _('No Partner')} </div>
+
+
+
+    %for curr, grouped_lines in account.grouped_ledger_lines.get(p_id, []):
+    <%
+      total_debit = 0.0
+      total_credit = 0.0
+      cumul_balance = 0.0
+      cumul_balance_curr = 0.0
+
+      part_cumul_balance = 0.0
+      part_cumul_balance_curr = 0.0
+    %>
+    <div class="act_as_table list_table" style="margin-top: 5px;">
+        <div class="act_as_caption account_title">
+           <b>${curr or company.currency_id.name}</b>
+        </div>
+        <div class="act_as_thead">
+            <div class="act_as_row labels">
+                ## date
+                <div class="act_as_cell first_column" style="width: 60px;">${_('Date')}</div>
+                ## period
+                <div class="act_as_cell" style="width: 70px;">${_('Period')}</div>
+                ## move
+                <div class="act_as_cell" style="width: 100px;">${_('Entry')}</div>
+                ## journal
+                <div class="act_as_cell" style="width: 70px;">${_('Journal')}</div>
+                ## move reference
+                <div class="act_as_cell" style="width: 100px;">${_('Reference')}</div>
+                ## label
+                <div class="act_as_cell" style="width: 180px;">${_('Label')}</div>
+                ## reconcile
+                <div class="act_as_cell" style="width: 80px;">${_('Rec.')}</div>
+                ## maturity
+                <div class="act_as_cell" style="width: 60px;">${_('Due Date')}</div>
+                ## debit
+                <div class="act_as_cell amount" style="width: 80px;">${_('Debit')}</div>
+                ## credit
+                <div class="act_as_cell amount" style="width: 80px;">${_('Credit')}</div>
+                ## balance cumulated
+               <div class="act_as_cell amount" style="width: 80px;">${_('Cumul. Bal.')}</div>
+               ## currency balance
+               <div class="act_as_cell amount sep_left" style="width: 80px;">${_('Curr. Balance')}</div>
+               ## curency code
+               <div class="act_as_cell amount" style="width: 30px; text-align: right;">${_('Curr.')}</div>
+            </div>
+        </div>
+        <div class="act_as_tbody">
+            <%
+            total_debit = 0.0
+            total_credit = 0.0
+            %>
+           <%!
+            def amount(text):
+                return text.replace('-', '&#8209;')  # replace by a non-breaking hyphen (it will not word-wrap between hyphen and numbers)
+            %>
+            %for line in grouped_lines:
+              <%
+              total_debit += line.get('debit') or 0.0
+              total_credit += line.get('credit') or 0.0
+
+              label_elements = [line.get('lname') or '']
+              if line.get('invoice_number'):
+                label_elements.append("(%s)" % (line['invoice_number'],))
+              label = ' '.join(label_elements)
+              %>
+                <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 ''}">
+                  ## date
+                  <div class="act_as_cell first_column">${formatLang(line.get('ldate') or '', date=True)}</div>
+                  ## period
+                  <div class="act_as_cell">${line.get('period_code') or ''}</div>
+                  ## move
+                  <div class="act_as_cell">${line.get('move_name') or ''}</div>
+                  ## journal
+                  <div class="act_as_cell">${line.get('jcode') or ''}</div>
+                   ## move reference
+                  <div class="act_as_cell">${line.get('lref') or ''}</div>
+                  ## label
+                  <div class="act_as_cell">${label}</div>
+                  ## reconcile
+                  <div class="act_as_cell">${line.get('rec_name') or ''}</div>
+                  ## maturity date
+                  <div class="act_as_cell">${formatLang(line.get('date_maturity') or '', date=True)}</div>
+                  ## debit
+                  <div class="act_as_cell amount">${formatLang(line.get('debit') or 0.0) | amount }</div>
+                  ## credit
+                  <div class="act_as_cell amount">${formatLang(line.get('credit') or 0.0) | amount }</div>
+                  ## balance cumulated
+                  <% cumul_balance += line.get('balance') or 0.0 %>
+                  <div class="act_as_cell amount" style="padding-right: 1px;">${formatLang(cumul_balance) | amount }</div>
+                  ## currency balance
+                  <div class="act_as_cell sep_left amount">${formatLang(line.get('amount_currency') or 0.0) | amount }</div>
+                  ## curency code
+                  <div class="act_as_cell" style="text-align: right; ">${line.get('currency_code') or ''}</div>
+              </div>
+            %endfor
+            <div class="act_as_row lines labels">
+              ## date
+              <div class="act_as_cell first_column"></div>
+              ## period
+              <div class="act_as_cell"></div>
+              ## move
+              <div class="act_as_cell"></div>
+              ## journal
+              <div class="act_as_cell"></div>
+              ## move reference
+              <div class="act_as_cell"></div>
+              ## label
+              <div class="act_as_cell">${_('Cumulated Balance on Partner')}</div>
+              ## reconcile
+              <div class="act_as_cell"></div>
+              ## maturity date
+              <div class="act_as_cell"></div>
+              ## debit
+              <div class="act_as_cell amount">${formatLang(total_debit) | amount }</div>
+              ## credit
+              <div class="act_as_cell amount">${formatLang(total_credit) | amount }</div>
+              ## balance cumulated
+              <div class="act_as_cell amount" style="padding-right: 1px;">${formatLang(cumul_balance) | amount }</div>
+              %if account.currency_id:
+                  ## currency balance
+                  <div class="act_as_cell sep_left amount" style="padding-right: 1px;">${formatLang(cumul_balance_curr) | amount }</div>
+              %else:
+                  <div class="act_as_cell sep_left amount" style="padding-right: 1px;">${ u'-' }</div>
+              %endif
+              ## curency code
+              <div class="act_as_cell" style="text-align: right; ">${ account.currency_id.name if account.currency_id else u'' }</div>
+          </div>
+        </div>
+    </div>
+    <%
+        account_total_debit += total_debit
+        account_total_credit += total_credit
+        account_balance_cumul += cumul_balance
+        account_balance_cumul_curr += cumul_balance_curr
+    %>
+    %endfor
+%endfor
+       <div class="act_as_table list_table" style="margin-top:5px;">
+        <div class="act_as_row labels" style="font-weight: bold; font-size: 12px;">
+                <div class="act_as_cell first_column" style="width: 450px;">${account.code} - ${account.name}</div>
+                ## label
+                <div class="act_as_cell" style="width: 320px;">${_("Cumulated Balance on Account")}</div>
+                ## debit
+                <div class="act_as_cell amount" style="width: 80px;">${ formatLang(account_total_debit) | amount }</div>
+                ## credit
+                <div class="act_as_cell amount" style="width: 80px;">${ formatLang(account_total_credit) | amount }</div>
+                ## balance cumulated
+                <div class="act_as_cell amount" style="width: 80px; ">${ formatLang(account_balance_cumul) | amount }</div>
+                ## currency balance cumulated
+                %if account.currency_id:
+                    <div class="act_as_cell amount sep_left" style="width: 80px;">${ formatLang(account_balance_cumul_curr) | amount }</div>
+                %else:
+                    <div class="act_as_cell amount sep_left" style="width: 80px; padding-right: 1px;">${ u'-' }</div>
+                %endif
+                ## curency code
+                <div class="act_as_cell amount" style="width: 30px; text-align: right;">${ account.currency_id.name if account.currency_id else u'' }</div>
+            </div>
+        </div>
+    </div>
+%endif