comparativebalance.ftl

Sequoia ERP是一个真正的企业级开源ERP解决方案。它提供的模块包括：电子商务应用(e-commerce), POS系统(point of sales),知识管理,存货与仓库管理

<#--
 * Copyright (C) 2006  Open Source Strategies, Inc.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 *  
-->
<#assign currencyUomId = parameters.orgCurrencyUomId>  <!-- for some reason, putting this in context in main-decorator.bsh does not work -->
<#macro listBalances type accounts balances>
  <#assign total = 0.0>
  <#assign fromDateAccounts = fromDateAccountBalances.get(type)/>
  <#assign thruDateAccounts = thruDateAccountBalances.get(type)/>
    <#list accounts as account>
     <#if account?has_content>
      <tr>
        <td class="tabletext"><a href="<@ofbizUrl>AccountActivitiesDetail?glAccountId=${account.glAccountId?if_exists}&organizationPartyId=${organizationPartyId}</@ofbizUrl>">${account.glAccountId?if_exists}</a> ${account.accountName?if_exists}</td>
        <td class="tabletext" align="right"><@ofbizCurrency amount=fromDateAccounts.get(account) isoCode=currencyUomId/></td>
        <td class="tabletext" align="right"><@ofbizCurrency amount=thruDateAccounts.get(account) isoCode=currencyUomId/></td>
        <td class="tabletext" align="right"><@ofbizCurrency amount=balances.get(account) isoCode=currencyUomId/></td>
      </tr>
      <#assign total = total + balances.get(account)>
     </#if>
    </#list>
      <tr><td colspan="4"><hr/></td></tr>
      <tr>
        <td colspan="4" class="tableheadtext" align="right"><@ofbizCurrency amount=total isoCode=currencyUomId/></td>
      </tr>
      <tr><td colspan="4">&nbsp;</td></tr>
</#macro>

<#if assetAccounts?has_content>
<div style="border: 1px solid #999999; margin-top: 20px; margin-bottom: 20px;"></div>
<div class="tabletext">
<table>
  <tr>
     <td colspan="4" class="tableheadtext" align="center">${uiLabelMap.FinancialsComparativeBalanceSheet} for ${parameters.organizationName?if_exists} (${organizationPartyId})</td>
  </tr>
  <tr>
     <td colspan="4" class="tabletext" align="center">
     <#if customTimePeriod?has_content>
     ${uiLabelMap.CommonFor} ${customTimePeriod.getRelatedOne("PeriodType").get("description")}
     ${customTimePeriod.periodNum} (${customTimePeriod.fromDate?string("EEEE, MMMM dd, yyyy")} ${uiLabelMap.CommonThru} ${customTimePeriod.thruDate?string("EEEE, MMMM dd, yyyy")})
     </#if>
     ${uiLabelMap.CommonFromDate} ${fromDate?string("EEEE, MMMM dd, yyyy")}
     ${uiLabelMap.CommonThruDate} ${thruDate?string("EEEE, MMMM dd, yyyy")}
     </td>
  </tr>
   <tr><td colspan="4">&nbsp;</td></tr>
      
   <tr><td class="tableheadtext" align="left">${uiLabelMap.AccountingAssets}</td><td class="tableheadtext" align="right">${fromDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">${thruDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">Difference</td></tr>
   <@listBalances type="assetAccountBalances" accounts=assetAccounts balances=assetAccountBalances/>
   
   <tr><td class="tableheadtext" align="left">${uiLabelMap.AccountingLiabilities}</td><td class="tableheadtext" align="right">${fromDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">${thruDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">Difference</td></tr>
   <@listBalances type="liabilityAccountBalances" accounts=liabilityAccounts balances=liabilityAccountBalances/>

   <tr><td class="tableheadtext" align="left">${uiLabelMap.AccountingEquities}</td><td class="tableheadtext" align="right">${fromDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">${thruDate?string("EEEE, MMMM dd, yyyy")}</td><td class="tableheadtext" align="right">Difference</td></tr>
   <@listBalances type="equityAccountBalances" accounts=equityAccounts balances=equityAccountBalances/>
</table>
</#if>