report/templates/grouped_by_curr_open_invoices_inclusion.mako.html

   1 ## -*- coding: utf-8 -*-
   2 <%page args="account, formatLang" />
   3 %if account.grouped_ledger_lines and account.partners_order:
   4     <%
   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
   9     %>
  10    %for partner_name, p_id, p_ref, p_name in account.partners_order:
  11     <div class="account_title bg" style="width: 1080px; margin-top:
  12       20px; font-size: 12px;">${account.code} - ${account.name} --  ${partner_name or _('No Partner')} </div>
  13
  14
  15
  16     %for curr, grouped_lines in account.grouped_ledger_lines.get(p_id, []):
  17     <%
  18       total_debit = 0.0
  19       total_credit = 0.0
  20       cumul_balance = 0.0
  21       cumul_balance_curr = 0.0
  22
  23       part_cumul_balance = 0.0
  24       part_cumul_balance_curr = 0.0
  25     %>
  26     <div class="act_as_table list_table" style="margin-top: 5px;">
  27         <div class="act_as_caption account_title">
  28            <b>${curr or company.currency_id.name}</b>
  29         </div>
  30         <div class="act_as_thead">
  31             <div class="act_as_row labels">
  32                 ## date
  33                 <div class="act_as_cell first_column" style="width: 60px;">${_('Date')}</div>
  34                 ## period
  35                 <div class="act_as_cell" style="width: 70px;">${_('Period')}</div>
  36                 ## move
  37                 <div class="act_as_cell" style="width: 100px;">${_('Entry')}</div>
  38                 ## journal
  39                 <div class="act_as_cell" style="width: 70px;">${_('Journal')}</div>
  40                 ## move reference
  41                 <div class="act_as_cell" style="width: 100px;">${_('Reference')}</div>
  42                 ## label
  43                 <div class="act_as_cell" style="width: 180px;">${_('Label')}</div>
  44                 ## reconcile
  45                 <div class="act_as_cell" style="width: 80px;">${_('Rec.')}</div>
  46                 ## maturity
  47                 <div class="act_as_cell" style="width: 60px;">${_('Due Date')}</div>
  48                 ## debit
  49                 <div class="act_as_cell amount" style="width: 80px;">${_('Debit')}</div>
  50                 ## credit
  51                 <div class="act_as_cell amount" style="width: 80px;">${_('Credit')}</div>
  52                 ## balance cumulated
  53                <div class="act_as_cell amount" style="width: 80px;">${_('Cumul. Bal.')}</div>
  54                ## currency balance
  55                <div class="act_as_cell amount sep_left" style="width: 80px;">${_('Curr. Balance')}</div>
  56                ## curency code
  57                <div class="act_as_cell amount" style="width: 30px; text-align: right;">${_('Curr.')}</div>
  58             </div>
  59         </div>
  60         <div class="act_as_tbody">
  61             <%
  62             total_debit = 0.0
  63             total_credit = 0.0
  64             %>
  65            <%!
  66             def amount(text):
  67                 return text.replace('-', '&#8209;')  # replace by a non-breaking hyphen (it will not word-wrap between hyphen and numbers)
  68             %>
  69             %for line in grouped_lines:
  70               <%
  71               total_debit += line.get('debit') or 0.0
  72               total_credit += line.get('credit') or 0.0
  73
  74               label_elements = [line.get('lname') or '']
  75               if line.get('invoice_number'):
  76                 label_elements.append("(%s)" % (line['invoice_number'],))
  77               label = ' '.join(label_elements)
  78               %>
  79                 <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 ''}">
  80                   ## date
  81                   <div class="act_as_cell first_column">${formatLang(line.get('ldate') or '', date=True)}</div>
  82                   ## period
  83                   <div class="act_as_cell">${line.get('period_code') or ''}</div>
  84                   ## move
  85                   <div class="act_as_cell">${line.get('move_name') or ''}</div>
  86                   ## journal
  87                   <div class="act_as_cell">${line.get('jcode') or ''}</div>
  88                    ## move reference
  89                   <div class="act_as_cell">${line.get('lref') or ''}</div>
  90                   ## label
  91                   <div class="act_as_cell">${label}</div>
  92                   ## reconcile
  93                   <div class="act_as_cell">${line.get('rec_name') or ''}</div>
  94                   ## maturity date
  95                   <div class="act_as_cell">${formatLang(line.get('date_maturity') or '', date=True)}</div>
  96                   ## debit
  97                   <div class="act_as_cell amount">${formatLang(line.get('debit') or 0.0) | amount }</div>
  98                   ## credit
  99                   <div class="act_as_cell amount">${formatLang(line.get('credit') or 0.0) | amount }</div>
 100                   ## balance cumulated
 101                   <% cumul_balance += line.get('balance') or 0.0 %>
 102                   <div class="act_as_cell amount" style="padding-right: 1px;">${formatLang(cumul_balance) | amount }</div>
 103                   ## currency balance
 104                   <div class="act_as_cell sep_left amount">${formatLang(line.get('amount_currency') or 0.0) | amount }</div>
 105                   ## curency code
 106                   <div class="act_as_cell" style="text-align: right; ">${line.get('currency_code') or ''}</div>
 107               </div>
 108             %endfor
 109             <div class="act_as_row lines labels">
 110               ## date
 111               <div class="act_as_cell first_column"></div>
 112               ## period
 113               <div class="act_as_cell"></div>
 114               ## move
 115               <div class="act_as_cell"></div>
 116               ## journal
 117               <div class="act_as_cell"></div>
 118               ## move reference
 119               <div class="act_as_cell"></div>
 120               ## label
 121               <div class="act_as_cell">${_('Cumulated Balance on Partner')}</div>
 122               ## reconcile
 123               <div class="act_as_cell"></div>
 124               ## maturity date
 125               <div class="act_as_cell"></div>
 126               ## debit
 127               <div class="act_as_cell amount">${formatLang(total_debit) | amount }</div>
 128               ## credit
 129               <div class="act_as_cell amount">${formatLang(total_credit) | amount }</div>
 130               ## balance cumulated
 131               <div class="act_as_cell amount" style="padding-right: 1px;">${formatLang(cumul_balance) | amount }</div>
 132               %if account.currency_id:
 133                   ## currency balance
 134                   <div class="act_as_cell sep_left amount" style="padding-right: 1px;">${formatLang(cumul_balance_curr) | amount }</div>
 135               %else:
 136                   <div class="act_as_cell sep_left amount" style="padding-right: 1px;">${ u'-' }</div>
 137               %endif
 138               ## curency code
 139               <div class="act_as_cell" style="text-align: right; ">${ account.currency_id.name if account.currency_id else u'' }</div>
 140           </div>
 141         </div>
 142     </div>
 143     <%
 144         account_total_debit += total_debit
 145         account_total_credit += total_credit
 146         account_balance_cumul += cumul_balance
 147         account_balance_cumul_curr += cumul_balance_curr
 148     %>
 149     %endfor
 150 %endfor
 151        <div class="act_as_table list_table" style="margin-top:5px;">
 152         <div class="act_as_row labels" style="font-weight: bold; font-size: 12px;">
 153                 <div class="act_as_cell first_column" style="width: 450px;">${account.code} - ${account.name}</div>
 154                 ## label
 155                 <div class="act_as_cell" style="width: 320px;">${_("Cumulated Balance on Account")}</div>
 156                 ## debit
 157                 <div class="act_as_cell amount" style="width: 80px;">${ formatLang(account_total_debit) | amount }</div>
 158                 ## credit
 159                 <div class="act_as_cell amount" style="width: 80px;">${ formatLang(account_total_credit) | amount }</div>
 160                 ## balance cumulated
 161                 <div class="act_as_cell amount" style="width: 80px; ">${ formatLang(account_balance_cumul) | amount }</div>
 162                 ## currency balance cumulated
 163                 %if account.currency_id:
 164                     <div class="act_as_cell amount sep_left" style="width: 80px;">${ formatLang(account_balance_cumul_curr) | amount }</div>
 165                 %else:
 166                     <div class="act_as_cell amount sep_left" style="width: 80px; padding-right: 1px;">${ u'-' }</div>
 167                 %endif
 168                 ## curency code
 169                 <div class="act_as_cell amount" style="width: 30px; text-align: right;">${ account.currency_id.name if account.currency_id else u'' }</div>
 170             </div>
 171         </div>
 172     </div>
 173 %endif