report/templates/open_invoices_inclusion.mako.html

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