svn commit: r1003469 [3/7] - in /ofbiz/trunk/applications/acco
Locked
 
|
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/BalanceSheet.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/BalanceSheet.rptdesign?rev=1003469&view=auto ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/BalanceSheet.rptdesign (added) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/BalanceSheet.rptdesign Fri Oct 1 10:40:38 2010 @@ -0,0 +1,1266 @@ +<?xml version="1.0" encoding="UTF-8"?> +<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.21" id="1"> + <property name="createdBy">Eclipse BIRT Designer Version 2.6.0.v20100531 Build <2.6.0.v20100609-1613></property> + <property name="units">in</property> + <method name="initialize"><![CDATA[importPackage(Packages.javolution.util) +importPackage(Packages.org.ofbiz.base.util) +importPackage(Packages.org.ofbiz.entity.util) + +module = "BalanceSheet.rptdesign"; +dateFormatter = new java.text.SimpleDateFormat("dd MMMMM yyyy"); + +// prepare uiLabelMap +uiLabelMap = FastMap.newInstance(); +uiLabelMap.putAll(UtilProperties.getResourceBundleMap("CommonUiLabels", reportContext.getLocale())); +uiLabelMap.putAll(UtilProperties.getResourceBundleMap("AccountingUiLabels", reportContext.getLocale())); + +fromDate = null; +thruDate = null; +glFiscalTypeId = null; + +// prepare parameters + +organizationPartyId = params["organizationPartyId"].value; +userLogin = delegator.findOne("UserLogin", UtilMisc.toMap("userLoginId", params["userLoginId"].value), false); +partyNameView = delegator.findOne("PartyNameView", UtilMisc.toMap("partyId", userLogin.getString("partyId")), false); + +fromDate = null; +if (params["fromDate"].value) { + fromDate = params["fromDate"].value; +} + +if (!params["thruDate"].value) { + thruDate = params["thruDate"].value; +} else { + thruDate = UtilDateTime.nowTimestamp(); +} + +if (!params["glFiscalTypeId"].value) { + glFiscalTypeId = params["glFiscalTypeId"].value; +} else { + glFiscalTypeId = "ACTUAL"; +} + +// call BalanceSheet.groovy script +context = FastMap.newInstance(); +context.put("organizationPartyId", organizationPartyId); +context.put("fromDate", fromDate); +context.put("thruDate", thruDate); +context.put("glFiscalTypeId", glFiscalTypeId); +context.put("delegator", delegator); +context.put("dispatcher", dispatcher); +context.put("userLogin", userLogin); +GroovyUtil.runScriptAtLocation("component://accounting/webapp/accounting/WEB-INF/actions/reports/BalanceSheet.groovy", context); + +// prepare data source lists +assetAccountBalanceList = context.get("assetAccountBalanceList"); +liabilityAccountBalanceList = context.get("liabilityAccountBalanceList"); +equityAccountBalanceList = context.get("equityAccountBalanceList"); +balanceTotalList = context.get("balanceTotalList");]]></method> + <property name="iconFile">/templates/blank_report.gif</property> + <property name="bidiLayoutOrientation">ltr</property> + <parameters> + <scalar-parameter name="fromDate" id="154"> + <property name="valueType">static</property> + <property name="isRequired">false</property> + <property name="dataType">dateTime</property> + <property name="distinct">true</property> + <property name="paramType">simple</property> + <property name="controlType">text-box</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="thruDate" id="155"> + <property name="valueType">static</property> + <property name="isRequired">false</property> + <property name="dataType">dateTime</property> + <property name="distinct">true</property> + <property name="paramType">simple</property> + <property name="controlType">text-box</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="glFiscalTypeId" id="156"> + <property name="valueType">static</property> + <property name="isRequired">false</property> + <property name="dataType">string</property> + <property name="distinct">true</property> + <property name="paramType">simple</property> + <property name="controlType">text-box</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + <scalar-parameter name="userLoginId" id="158"> + <property name="valueType">static</property> + <property name="dataType">string</property> + <property name="distinct">true</property> + <property name="paramType">simple</property> + <property name="controlType">text-box</property> + <structure name="format"> + <property name="category">Unformatted</property> + </structure> + </scalar-parameter> + </parameters> + <data-sources> + <script-data-source name="OFBiz" id="7"/> + </data-sources> + <data-sets> + <script-data-set name="Asset" id="39"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">glAccountId</property> + <text-property name="displayName">Account ID</text-property> + </structure> + <structure> + <property name="columnName">accountCode</property> + <text-property name="displayName">Account Code</text-property> + </structure> + <structure> + <property name="columnName">accountName</property> + <text-property name="displayName">Account Name</text-property> + </structure> + <structure> + <property name="columnName">balance</property> + <text-property name="displayName">Balance</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[totalRow = 0; +countOfRow = 0; + +if (assetAccountBalanceList.size) { + totalRow = assetAccountBalanceList.size(); +} +]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var assetAccountBalance = assetAccountBalanceList.get(countOfRow); +row["glAccountId"] = assetAccountBalance.get("glAccountId"); +row["accountCode"] = assetAccountBalance.get("accountCode"); +row["accountName"] = assetAccountBalance.get("accountName"); +row["balance"] = assetAccountBalance.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="Liability" id="71"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">glAccountId</property> + <text-property name="displayName">Account ID</text-property> + </structure> + <structure> + <property name="columnName">accountCode</property> + <text-property name="displayName">accountCode</text-property> + </structure> + <structure> + <property name="columnName">accountName</property> + <text-property name="displayName">Account Name</text-property> + </structure> + <structure> + <property name="columnName">balance</property> + <text-property name="displayName">Balance</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[totalRow = 0; +countOfRow = 0; + +if (liabilityAccountBalanceList.size) { + totalRow = liabilityAccountBalanceList.size(); +} +]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var liabilityAccountBalance = liabilityAccountBalanceList.get(countOfRow); +row["glAccountId"] = liabilityAccountBalance.get("glAccountId"); +row["accountCode"] = liabilityAccountBalance.get("accountCode"); +row["accountName"] = liabilityAccountBalance.get("accountName"); +row["balance"] = liabilityAccountBalance.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="Equity" id="102"> + <list-property name="resultSetHints"> + <structure> + <property name="position">0</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">1</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">glAccountId</property> + <text-property name="displayName">Account ID</text-property> + </structure> + <structure> + <property name="columnName">accountCode</property> + <text-property name="displayName">Account Code</text-property> + </structure> + <structure> + <property name="columnName">accountName</property> + <text-property name="displayName">Account Name</text-property> + </structure> + <structure> + <property name="columnName">balance</property> + <text-property name="displayName">Balance</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[totalRow = 0; +countOfRow = 0; + +if (equityAccountBalanceList.size) { + totalRow = equityAccountBalanceList.size(); +} +]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var equityAccountBalance = equityAccountBalanceList.get(countOfRow); +row["glAccountId"] = equityAccountBalance.get("glAccountId"); +row["accountCode"] = equityAccountBalance.get("accountCode"); +row["accountName"] = equityAccountBalance.get("accountName"); +row["balance"] = equityAccountBalance.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="BalanceTotal" id="260"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">totalName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">totalName</property> + <text-property name="displayName">Total Name</text-property> + </structure> + <structure> + <property name="columnName">balance</property> + <text-property name="displayName">Balance</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">totalName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">balance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[totalRow = 0; +countOfRow = 0; + +if (balanceTotalList.size) { + totalRow = balanceTotalList.size(); +}]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var balanceTotal = balanceTotalList.get(countOfRow); +row["totalName"] = balanceTotal.get("totalName"); +row["balance"] = balanceTotal.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + </data-sets> + <styles> + <style name="report" id="4"> + <property name="fontFamily">sans-serif</property> + <property name="fontSize">10pt</property> + </style> + <style name="crosstab-cell" id="5"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + <style name="crosstab" id="6"> + <property name="borderBottomColor">#CCCCCC</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">1pt</property> + <property name="borderLeftColor">#CCCCCC</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">1pt</property> + <property name="borderRightColor">#CCCCCC</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">1pt</property> + <property name="borderTopColor">#CCCCCC</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">1pt</property> + </style> + </styles> + <page-setup> + <simple-master-page name="Simple MasterPage" id="2"> + <property name="headerHeight">1.75in</property> + <page-header> + <grid id="8"> + <property name="backgroundColor">#FFFFFF</property> + <property name="height">1.6979166666666667in</property> + <property name="width">7.875in</property> + <column id="9"> + <property name="width">1.28125in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">left</property> + </column> + <column id="10"> + <property name="width">2.6770833333333335in</property> + </column> + <column id="11"> + <property name="width">1.2395833333333333in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">left</property> + </column> + <column id="27"> + <property name="width">2.6770833333333335in</property> + </column> + <row id="12"> + <property name="height">0.5416666666666666in</property> + <cell id="13"> + <property name="colSpan">2</property> + <property name="rowSpan">1</property> + <property name="textAlign">left</property> + <image id="28"> + <property name="height">43px</property> + <property name="width">238px</property> + <method name="onCreate"><![CDATA[// get organization logo +partyContents = delegator.findByAnd("PartyContent", UtilMisc.toMap("partyId", organizationPartyId, "partyContentTypeId", "LGOIMGURL")); +partyContents = EntityUtil.filterByDate(partyContents); +if (partyContents != null && partyContents.size() > 0) { + var dataResource = partyContents.get(0).getRelatedOne("Content").getRelatedOne("DataResource"); + var dataResourceTypeId = dataResource.getString("dataResourceTypeId"); + if ("LOCAL_FILE".equals(dataResourceTypeId)) { + this.file = dataResource.get("objectInfo"); + } else { + this.URL = dataResource.get("objectInfo"); + } +} else { + this.URL = "http://localhost:8080/images/ofbiz_logo.gif"; +}]]></method> + <property name="source">url</property> + <property name="fitToContainer">false</property> + </image> + </cell> + <cell id="15"> + <property name="textAlign">right</property> + <label id="29"> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonUsername") + ":";]]></method> + <text-property name="text">Username: </text-property> + </label> + </cell> + <cell id="24"> + <text-data id="151"> + <expression name="valueExpr">if (userLogin != null ) {partyNameView.getString("firstName") + "&nbsp;&nbsp;&nbsp;&nbsp;" + partyNameView.getString("lastName")}</expression> + <property name="contentType">html</property> + </text-data> + </cell> + </row> + <row id="16"> + <property name="height">0.2604166666666667in</property> + <cell id="17"/> + <cell id="18"/> + <cell id="19"> + <property name="textAlign">right</property> + <label id="30"> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonDate") + ":";]]></method> + <text-property name="text">Date: </text-property> + </label> + </cell> + <cell id="25"> + <text-data id="152"> + <expression name="valueExpr">dateFormatter.format(UtilDateTime.nowTimestamp())</expression> + <property name="contentType">html</property> + </text-data> + </cell> + </row> + <row id="132"> + <property name="height">0.22916666666666666in</property> + <cell id="133"> + <property name="textAlign">right</property> + <label id="31"> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_thruDate") + ":";]]></method> + <text-property name="text">Thru Date: </text-property> + </label> + </cell> + <cell id="134"> + <text-data id="153"> + <expression name="valueExpr">dateFormatter.format(thruDate)</expression> + <property name="contentType">html</property> + </text-data> + </cell> + <cell id="135"> + <label id="278"> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingCurrency") + ":";]]></method> + <text-property name="text">Currency: </text-property> + </label> + </cell> + <cell id="136"> + <text-data id="279"> + <expression name="valueExpr">delegator.findOne("PartyAcctgPreference", UtilMisc.toMap("partyId", organizationPartyId), false).getRelatedOne("Uom").getString("description")</expression> + <property name="contentType">html</property> + </text-data> + </cell> + </row> + <row id="20"> + <property name="height">0.21875in</property> + <cell id="21"> + <property name="textAlign">right</property> + <label id="37"> + <property name="fontWeight">bold</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_glFiscalTypeId") + ":";]]></method> + <text-property name="text">Fiscal Gl Type: </text-property> + </label> + </cell> + <cell id="22"> + <text-data id="165"> + <expression name="valueExpr">delegator.findOne("GlFiscalType", UtilMisc.toMap("glFiscalTypeId", glFiscalTypeId), false).getString("description")</expression> + <property name="contentType">html</property> + </text-data> + </cell> + <cell id="23"/> + <cell id="26"/> + </row> + <row id="171"> + <property name="height">0.4479166666666667in</property> + <cell id="172"> + <property name="colSpan">4</property> + <property name="rowSpan">1</property> + <property name="textAlign">right</property> + <text id="177"> + <method name="onPrepare"><![CDATA[this.content = "<CENTER><H3>" + uiLabelMap.get("AccountingBalanceSheet") + "</H3></CENTER>";]]></method> + <property name="contentType">html</property> + </text> + </cell> + </row> + </grid> + </page-header> + <page-footer> + <grid id="138"> + <property name="width">7.9375in</property> + <column id="170"> + <property name="width">2.8229166666666665in</property> + </column> + <column id="139"> + <property name="width">0.8333333333333334in</property> + </column> + <column id="140"> + <property name="width">0.3645833333333333in</property> + </column> + <column id="141"> + <property name="width">0.7395833333333334in</property> + </column> + <column id="168"> + <property name="width">3.1770833333333335in</property> + </column> + <row id="142"> + <cell id="169"/> + <cell id="143"> + <auto-text id="144"> + <property name="textAlign">right</property> + <property name="type">page-number</property> + </auto-text> + </cell> + <cell id="145"> + <text id="146"> + <property name="textAlign">center</property> + <property name="contentType">plain</property> + <text-property name="content"><![CDATA[of]]></text-property> + </text> + </cell> + <cell id="147"> + <property name="textAlign">right</property> + <auto-text id="148"> + <property name="textAlign">left</property> + <property name="type">total-page</property> + </auto-text> + </cell> + <cell id="167"> + <property name="textAlign">right</property> + </cell> + </row> + </grid> + </page-footer> + </simple-master-page> + </page-setup> + <body> + <label id="38"> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingAssets");]]></method> + <text-property name="text">Assets</text-property> + </label> + <table id="40"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="width">7.9393939393939394in</property> + <property name="dataSet">Asset</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">accountId</property> + <text-property name="displayName">Account ID</text-property> + <expression name="expression" type="javascript">dataSetRow["glAccountId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountCode</property> + <text-property name="displayName">Account Code</text-property> + <expression name="expression">dataSetRow["accountCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountName</property> + <text-property name="displayName">Account Name</text-property> + <expression name="expression">dataSetRow["accountName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">balance</property> + <text-property name="displayName">Balance</text-property> + <expression name="expression">dataSetRow["balance"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">AssetAblanceTotal</property> + <property name="dataType">float</property> + <property name="aggregateFunction">SUM</property> + <list-property name="arguments"> + <structure> + <property name="name">Expression</property> + <expression name="value" type="javascript">row["balance"]</expression> + </structure> + </list-property> + </structure> + </list-property> + <column id="65"> + <property name="width">1.0520833333333333in</property> + </column> + <column id="66"> + <property name="width">4.888888888888889in</property> + </column> + <column id="67"> + <property name="width">1.6767676767676767in</property> + </column> + <header> + <row id="41"> + <property name="backgroundColor">#BFBFBF</property> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <cell id="44"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <label id="45"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="46"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <label id="47"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="48"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <label id="49"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method> + <text-property name="text">Balance</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="50"> + <cell id="53"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="54"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="55"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="56"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="57"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="58"> + <property name="textAlign">right</property> + <property name="resultSetColumn">balance</property> + </data> + </cell> + </row> + </detail> + </table> + <label id="70"> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingLiabilities");]]></method> + <text-property name="text">Liabiliities</text-property> + </label> + <table id="72"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="width">7.9393939393939394in</property> + <property name="dataSet">Liability</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">glAccountId</property> + <text-property name="displayName">Account ID</text-property> + <expression name="expression">dataSetRow["glAccountId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountCode</property> + <text-property name="displayName">accountCode</text-property> + <expression name="expression">dataSetRow["accountCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountName</property> + <text-property name="displayName">Account Name</text-property> + <expression name="expression">dataSetRow["accountName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">balance</property> + <text-property name="displayName">Balance</text-property> + <expression name="expression">dataSetRow["balance"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">LiabilityBalanceTotal</property> + <property name="dataType">float</property> + <property name="aggregateFunction">SUM</property> + <list-property name="arguments"> + <structure> + <property name="name">Expression</property> + <expression name="value" type="javascript">row["balance"]</expression> + </structure> + </list-property> + </structure> + </list-property> + <column id="97"> + <property name="width">1.1515151515151516in</property> + </column> + <column id="98"> + <property name="width">5.03030303030303in</property> + </column> + <column id="99"> + <property name="width">1.7575757575757576in</property> + </column> + <header> + <row id="73"> + <property name="backgroundColor">#BFBFBF</property> + <property name="fontWeight">bold</property> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="textAlign">center</property> + <cell id="76"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="77"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="78"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="79"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="80"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="81"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method> + <text-property name="text">Balance</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="82"> + <cell id="85"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="86"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="87"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="88"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="89"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="90"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00</property> + </structure> + <property name="textAlign">right</property> + <property name="resultSetColumn">balance</property> + </data> + </cell> + </row> + </detail> + </table> + <label id="101"> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingEquities");]]></method> + <text-property name="text">Equities</text-property> + </label> + <table id="103"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="width">7.9393939393939394in</property> + <property name="dataSet">Equity</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">glAccountId</property> + <text-property name="displayName">Account ID</text-property> + <expression name="expression">dataSetRow["glAccountId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountCode</property> + <text-property name="displayName">Account Code</text-property> + <expression name="expression">dataSetRow["accountCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountName</property> + <text-property name="displayName">Account Name</text-property> + <expression name="expression">dataSetRow["accountName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">balance</property> + <text-property name="displayName">Balance</text-property> + <expression name="expression">dataSetRow["balance"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">EquityBalanceTotal</property> + <property name="dataType">float</property> + <property name="aggregateFunction">SUM</property> + <list-property name="arguments"> + <structure> + <property name="name">Expression</property> + <expression name="value" type="javascript">row["balance"]</expression> + </structure> + </list-property> + </structure> + </list-property> + <column id="128"> + <property name="width">1.1414141414141414in</property> + </column> + <column id="129"> + <property name="width">5.02020202020202in</property> + </column> + <column id="130"> + <property name="width">1.7777777777777777in</property> + </column> + <header> + <row id="104"> + <property name="backgroundColor">#BFBFBF</property> + <property name="fontWeight">bold</property> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <property name="textAlign">center</property> + <cell id="107"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="108"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="109"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="110"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="111"> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <label id="112"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_balance");]]></method> + <text-property name="text">Balance</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="113"> + <cell id="116"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="117"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="118"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="119"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="120"> + <property name="borderBottomColor">#000000</property> + <property name="borderBottomStyle">solid</property> + <property name="borderBottomWidth">thin</property> + <property name="borderLeftColor">#000000</property> + <property name="borderLeftStyle">solid</property> + <property name="borderLeftWidth">thin</property> + <property name="borderRightColor">#000000</property> + <property name="borderRightStyle">solid</property> + <property name="borderRightWidth">thin</property> + <property name="borderTopColor">#000000</property> + <property name="borderTopStyle">solid</property> + <property name="borderTopWidth">thin</property> + <data id="121"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00</property> + </structure> + <property name="textAlign">right</property> + <property name="resultSetColumn">balance</property> + </data> + </cell> + </row> + </detail> + </table> + <label id="261"> + <property name="fontSize">10pt</property> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonTotal");]]></method> + <text-property name="text">Total</text-property> + </label> + <table id="262"> + <property name="width">7.959595959595959in</property> + <property name="dataSet">BalanceTotal</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">totalName</property> + <text-property name="displayName">Total Name</text-property> + <expression name="expression">dataSetRow["totalName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">balance</property> + <text-property name="displayName">Balance</text-property> + <expression name="expression">dataSetRow["balance"]</expression> + <property name="dataType">decimal</property> + </structure> + </list-property> + <column id="276"> + <property name="width">2.9494949494949494in</property> + </column> + <column id="277"> + <property name="width">5.01010101010101in</property> + </column> + <detail> + <row id="268"> + <cell id="269"> + <data id="270"> + <method name="onRender"><![CDATA[var text = uiLabelMap.get(this.getValue()); +this.setDisplayValue(text);]]></method> + <property name="resultSetColumn">totalName</property> + </data> + </cell> + <cell id="271"> + <data id="272"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00</property> + </structure> + <property name="resultSetColumn">balance</property> + </data> + </cell> + </row> + </detail> + <footer> + <row id="273"> + <cell id="274"/> + <cell id="275"/> + </row> + </footer> + </table> + </body> +</report> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |