svn commit: r1003469 [4/7] - in /ofbiz/trunk/applications/acco
Locked
 
|
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign?rev=1003469&view=auto ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign (added) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/IncomeStatement.rptdesign Fri Oct 1 10:40:38 2010 @@ -0,0 +1,1173 @@ +<?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 = "IncomeStatement.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 IncomeStatement.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/IncomeStatement.groovy", context); + +// prepare data source lists +revenueAccountBalanceList = context.get("revenueAccountBalanceList"); +expenseAccountBalanceList = context.get("expenseAccountBalanceList"); +incomeAccountBalanceList = context.get("incomeAccountBalanceList"); +balanceTotalList = context.get("balanceTotalList");]]></method> + <property name="iconFile">/templates/blank_report.gif</property> + <property name="bidiLayoutOrientation">ltr</property> + <data-sources> + <script-data-source name="OFBiz" id="149"/> + </data-sources> + <data-sets> + <script-data-set name="Revenue" id="150"> + <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 (revenueAccountBalanceList.size) { + totalRow = revenueAccountBalanceList.size(); +}]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var revenueAccountBalance = revenueAccountBalanceList.get(countOfRow); +row["glAccountId"] = revenueAccountBalance.get("glAccountId"); +row["accountCode"] = revenueAccountBalance.get("accountCode"); +row["accountName"] = revenueAccountBalance.get("accountName"); +row["balance"] = revenueAccountBalance.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="Expense" id="151"> + <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 (expenseAccountBalanceList.size) { + totalRow = expenseAccountBalanceList.size(); +}]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var expenseAccountBalance = expenseAccountBalanceList.get(countOfRow); +row["glAccountId"] = expenseAccountBalance.get("glAccountId"); +row["accountCode"] = expenseAccountBalance.get("accountCode"); +row["accountName"] = expenseAccountBalance.get("accountName"); +row["balance"] = expenseAccountBalance.get("balance"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="Income" id="152"> + <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 (incomeAccountBalanceList.size) { + totalRow = incomeAccountBalanceList.size(); +} +]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var incomeAccountBalance = incomeAccountBalanceList.get(countOfRow); +row["glAccountId"] = incomeAccountBalance.get("glAccountId"); +row["accountCode"] = incomeAccountBalance.get("accountCode"); +row["accountName"] = incomeAccountBalance.get("accountName"); +row["balance"] = incomeAccountBalance.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">2in</property> + <page-header> + <grid id="8"> + <property name="height">2.875in</property> + <property name="width">7.84375in</property> + <column id="9"> + <property name="width">1.2916666666666667in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + </column> + <column id="10"> + <property name="width">2.6354166666666665in</property> + </column> + <column id="11"> + <property name="width">1.9583333333333333in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + </column> + <column id="27"> + <property name="width">1.9583333333333333in</property> + </column> + <row id="12"> + <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"> + <label id="29"> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <property name="textAlign">right</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="243"> + <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"> + <cell id="17"/> + <cell id="18"/> + <cell id="19"> + <label id="30"> + <property name="fontWeight">bold</property> + <property name="textAlign">right</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="244"> + <expression name="valueExpr">dateFormatter.format(UtilDateTime.nowTimestamp())</expression> + <property name="contentType">html</property> + </text-data> + </cell> + </row> + <row id="132"> + <cell id="133"> + <label id="137"> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_fromDate") + ":";]]></method> + <text-property name="text">From Date: </text-property> + </label> + </cell> + <cell id="134"> + <text-data id="153"> + <expression name="valueExpr">dateFormatter.format(fromDate)</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"> + <cell id="21"> + <label id="31"> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_thruDate") + ":";]]></method> + <text-property name="text">Thru Date: </text-property> + </label> + </cell> + <cell id="22"> + <text-data id="251"> + <expression name="valueExpr">dateFormatter.format(thruDate)</expression> + <property name="contentType">html</property> + </text-data> + </cell> + <cell id="23"/> + <cell id="26"/> + </row> + <row id="32"> + <property name="height">0.5104166666666666in</property> + <cell id="33"> + <label id="37"> + <property name="fontWeight">bold</property> + <property name="textAlign">right</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="34"> + <text-data id="252"> + <expression name="valueExpr">delegator.findOne("GlFiscalType", UtilMisc.toMap("glFiscalTypeId", glFiscalTypeId), false).getString("description")</expression> + <property name="contentType">html</property> + </text-data> + </cell> + <cell id="35"/> + <cell id="36"/> + </row> + <row id="245"> + <cell id="246"> + <property name="colSpan">4</property> + <property name="rowSpan">1</property> + <text id="250"> + <method name="onPrepare"><![CDATA[this.content = "<CENTER><H3>" + uiLabelMap.get("AccountingIncomeStatement") + "</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="256"> + <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="257"> + <property name="width">3.1770833333333335in</property> + </column> + <row id="142"> + <cell id="258"/> + <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="259"> + <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("AccountingRevenues");]]></method> + <text-property name="text">Revenues</text-property> + </label> + <table id="154"> + <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.947916666666667in</property> + <property name="dataSet">Revenue</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" type="javascript">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" type="javascript">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">RevenueTotalBalance</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="179"> + <property name="width">1.3020833333333333in</property> + </column> + <column id="180"> + <property name="width">4.71875in</property> + </column> + <column id="181"> + <property name="width">1.7916666666666667in</property> + </column> + <header> + <row id="155"> + <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="158"> + <label id="159"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="160"> + <label id="161"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="162"> + <label id="163"> + <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="164"> + <cell id="167"> + <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="168"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="169"> + <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="170"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="171"> + <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="172"> + <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="182"> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingExpenses");]]></method> + <text-property name="text">Expenses</text-property> + </label> + <table id="183"> + <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.947916666666667in</property> + <property name="dataSet">Expense</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" type="javascript">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" type="javascript">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">ExpenseTotalBalance</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="208"> + <property name="width">1.3125in</property> + </column> + <column id="209"> + <property name="width">4.802083333333333in</property> + </column> + <column id="210"> + <property name="width">1.7916666666666667in</property> + </column> + <header> + <row id="184"> + <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="187"> + <label id="188"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="189"> + <label id="190"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="191"> + <label id="192"> + <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="193"> + <cell id="196"> + <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="197"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="198"> + <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="199"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="200"> + <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="201"> + <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="211"> + <property name="fontWeight">bold</property> + <property name="fontStyle">italic</property> + <property name="paddingTop">10pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingIncome");]]></method> + <text-property name="text">Incomes</text-property> + </label> + <table id="212"> + <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.947916666666667in</property> + <property name="dataSet">Income</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" type="javascript">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" type="javascript">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">IncomeTotalBalance</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="237"> + <property name="width">1.28125in</property> + </column> + <column id="238"> + <property name="width">4.75in</property> + </column> + <column id="239"> + <property name="width">1.78125in</property> + </column> + <header> + <row id="213"> + <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="216"> + <label id="217"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="218"> + <label id="219"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="220"> + <label id="221"> + <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="222"> + <cell id="225"> + <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="226"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="227"> + <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="228"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="229"> + <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="230"> + <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.8585858585858586in</property> + </column> + <column id="277"> + <property name="width">5.101010101010101in</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 |