svn commit: r1003469 [7/7] - in /ofbiz/trunk/applications/acco
Locked
 
|
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/TrialBalance.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/TrialBalance.rptdesign?rev=1003469&view=auto ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/TrialBalance.rptdesign (added) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/TrialBalance.rptdesign Fri Oct 1 10:40:38 2010 @@ -0,0 +1,833 @@ +<?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.condition) +importPackage(Packages.org.ofbiz.entity.util) + +module = "TrialBalance.rptdesign"; + +// prepare uiLabelMap +uiLabelMap = FastMap.newInstance(); +uiLabelMap.putAll(UtilProperties.getResourceBundleMap("CommonUiLabels", reportContext.getLocale())); +uiLabelMap.putAll(UtilProperties.getResourceBundleMap("AccountingUiLabels", reportContext.getLocale())); + +dateFormatter = new java.text.SimpleDateFormat("dd MMMMM yyyy"); + +// 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); +customTimePeriodId = params["customTimePeriodId"].value; +customerTimePeriod = delegator.findOne("CustomTimePeriod", UtilMisc.toMap("customTimePeriodId", customTimePeriodId), false); + +// prepare parties list +partyIds = org.ofbiz.party.party.PartyWorker.getAssociatedPartyIdsByRelationshipType(delegator, organizationPartyId, "GROUP_ROLLUP"); +parties = FastList.newInstance(); +try { + var + parties = delegator.findList("Party", EntityCondition.makeCondition("partyId", EntityOperator.IN, partyIds), null, null, null, false); +} catch (e) { + Debug.logError(e, module); +} +partyIds.add(organizationPartyId); + +// call TrialBalance.groovy script +context = FastMap.newInstance(); +context.put("parties", parties); +context.put("delegator", delegator); +context.put("dispatcher", dispatcher); +context.put("userLogin", userLogin); +GroovyUtil.runScriptAtLocation("component://accounting/webapp/accounting/WEB-INF/actions/reports/TrialBalance.groovy", context); +partyNameList = context.partyNameList; + +// get grand totoal posted +var condList = FastList.newInstance(); +condList.add(EntityCondition.makeCondition("organizationPartyId", EntityOperator.IN, partyIds)); +condList.add(EntityCondition.makeCondition("customTimePeriodId", EntityOperator.EQUALS, customTimePeriodId)); +var cond = EntityCondition.makeCondition(condList); +var fieldsToSelect = UtilMisc.toSet("totalPostedDebits", "totalPostedCredits"); +grandTotalPosted = FastList.newInstance(); +try { + grandTotalPosted = delegator.findList("GlAccountAndHistoryTotals", cond, fieldsToSelect, null, null, false); +} catch (e) { + Debug.logError(e, module); +} +grandTotalPostedRecord = grandTotalPosted.get(0);]]></method> + <property name="iconFile">/templates/blank_report.gif</property> + <property name="bidiLayoutOrientation">ltr</property> + <parameters> + <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> + <scalar-parameter name="organizationPartyId" id="282"> + <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> + <scalar-parameter name="customTimePeriodId" id="283"> + <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="280"/> + </data-sources> + <data-sets> + <script-data-set name="TrialBalance" id="281"> + <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">totalPostedDebits</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">totalPostedCredits</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">totalEndingBalance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">glAccountId</property> + <text-property name="displayName">Gl 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">totalPostedDebits</property> + <text-property name="displayName">Total Posted Debits</text-property> + </structure> + <structure> + <property name="columnName">totalPostedCredits</property> + <text-property name="displayName">Total Posted Credits</text-property> + </structure> + <structure> + <property name="columnName">totalEndingBalance</property> + <text-property name="displayName">Total Ending 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">totalPostedDebits</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">totalPostedCredits</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">totalEndingBalance</property> + <property name="dataType">decimal</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[// get Gl account history totals +var condList = FastList.newInstance(); +condList.add(EntityCondition.makeCondition("organizationPartyId", EntityOperator.IN, partyIds)); +condList.add(EntityCondition.makeCondition("customTimePeriodId", EntityOperator.EQUALS, customTimePeriodId)); +var cond = EntityCondition.makeCondition(condList); +var fieldsToSelect = UtilMisc.toSet("glAccountId", "accountCode", "accountName", "totalPostedDebits", "totalPostedCredits", "totalEndingBalance"); +var orderBy = UtilMisc.toList("accountCode"); +glAccountAndHistories = FastList.newInstance(); +try { + glAccountAndHistories = delegator.findList("GlAccountAndHistoryTotals", cond, fieldsToSelect, orderBy, null, false); +} catch (e) { + Debug.logError(e, module); +} + +totalRow = 0; +countOfRow = 0; + +if (glAccountAndHistories.size) { + totalRow = glAccountAndHistories.size(); +}]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var glAccountAndHistory = glAccountAndHistories.get(countOfRow); +row["glAccountId"] = glAccountAndHistory.get("glAccountId"); +row["accountCode"] = glAccountAndHistory.get("accountCode"); +row["accountName"] = glAccountAndHistory.get("accountName"); +row["totalPostedDebits"] = glAccountAndHistory.get("totalPostedDebits"); +row["totalPostedCredits"] = glAccountAndHistory.get("totalPostedCredits"); +var totalEndingBalance = glAccountAndHistory.get("totalEndingBalance"); +if (!totalEndingBalance) { + totalEndingBalance = glAccountAndHistory.get("totalPostedDebits") - glAccountAndHistory.get("totalPostedCredits"); +} +row["totalEndingBalance"] = totalEndingBalance; + +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="orientation">landscape</property> + <property name="headerHeight">1.5in</property> + <page-header> + <grid id="8"> + <property name="backgroundColor">#FFFFFF</property> + <property name="height">1.6979166666666667in</property> + <property name="width">10.424242424242424in</property> + <column id="9"> + <property name="width">2.272727272727273in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">left</property> + </column> + <column id="10"> + <property name="width">3.0606060606060606in</property> + </column> + <column id="11"> + <property name="width">2.3636363636363638in</property> + <property name="fontWeight">bold</property> + <property name="textAlign">left</property> + </column> + <column id="27"> + <property name="width">2.727272727272727in</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="fontSize">10pt</property> + <property name="fontWeight">bold</property> + <property name="textUnderline">none</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingCurrentCustomTimePeriod") + ":";]]></method> + <text-property name="text">Current Custom Time Period: </text-property> + </label> + </cell> + <cell id="134"> + <text-data id="153"> + <property name="fontSize">10pt</property> + <method name="onCreate"><![CDATA[var fromDate = customerTimePeriod.get("fromDate"); +var thruDate = customerTimePeriod.get("thruDate"); +this.text = dateFormatter.format(fromDate) + " - " + dateFormatter.format(thruDate);]]></method> + <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="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("AccountingTrialBalance") + "</H3></CENTER>";]]></method> + <property name="contentType">html</property> + </text> + </cell> + </row> + </grid> + </page-header> + <page-footer> + <grid id="138"> + <property name="height">0.4583333333333333in</property> + <property name="width">10.353535353535353in</property> + <column id="256"> + <property name="width">4.444444444444445in</property> + </column> + <column id="139"> + <property name="width">0.5151515151515151in</property> + </column> + <column id="140"> + <property name="width">0.5454545454545454in</property> + </column> + <column id="141"> + <property name="width">0.5555555555555556in</property> + </column> + <column id="257"> + <property name="width">4.303030303030303in</property> + </column> + <row id="142"> + <property name="height">0.4583333333333333in</property> + <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> + <table id="284"> + <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">10.474747474747474in</property> + <property name="dataSet">TrialBalance</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">glAccountId</property> + <text-property name="displayName">Gl 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">totalPostedDebits</property> + <text-property name="displayName">Total Posted Debits</text-property> + <expression name="expression">dataSetRow["totalPostedDebits"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">totalPostedCredits</property> + <text-property name="displayName">Total Posted Credits</text-property> + <expression name="expression">dataSetRow["totalPostedCredits"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">totalEndingBalance</property> + <text-property name="displayName">Total Ending Balance</text-property> + <expression name="expression">dataSetRow["totalEndingBalance"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">EndingBalanceTotal</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["totalEndingBalance"]</expression> + </structure> + </list-property> + </structure> + </list-property> + <column id="319"> + <property name="width">1.101010101010101in</property> + </column> + <column id="320"> + <property name="width">5.333333333333333in</property> + </column> + <column id="321"> + <property name="width">1.3434343434343434in</property> + </column> + <column id="322"> + <property name="width">1.3636363636363635in</property> + </column> + <column id="332"> + <property name="width">1.3232323232323233in</property> + </column> + <header> + <row id="285"> + <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="288"> + <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="289"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <cell id="290"> + <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="291"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="292"> + <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="293"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_debit");]]></method> + <text-property name="text">Debit</text-property> + </label> + </cell> + <cell id="294"> + <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="295"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_credit");]]></method> + <text-property name="text">Credit</text-property> + </label> + </cell> + <cell id="329"> + <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="335"> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingEndingBalance");]]></method> + <text-property name="text">Ending Balance</text-property> + </label> + </cell> + </row> + </header> + <detail> + <row id="298"> + <cell id="301"> + <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="302"> + <property name="resultSetColumn">accountCode</property> + </data> + </cell> + <cell id="303"> + <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="304"> + <property name="resultSetColumn">accountName</property> + </data> + </cell> + <cell id="305"> + <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="306"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <property name="resultSetColumn">totalPostedDebits</property> + </data> + </cell> + <cell id="307"> + <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="308"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <property name="resultSetColumn">totalPostedCredits</property> + </data> + </cell> + <cell id="330"> + <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="336"> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <property name="whiteSpace">nowrap</property> + <property name="resultSetColumn">totalEndingBalance</property> + </data> + </cell> + </row> + </detail> + <footer> + <row id="311"> + <cell id="313"/> + <cell id="314"> + <label id="326"> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonTotal");]]></method> + <text-property name="text">Total: </text-property> + </label> + </cell> + <cell id="315"> + <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="327"> + <property name="fontWeight">bold</property> + <property name="textUnderline">underline</property> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.setDisplayValue(grandTotalPostedRecord.get("totalPostedDebits"));]]></method> + </data> + </cell> + <cell id="316"> + <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="328"> + <property name="fontWeight">bold</property> + <property name="textUnderline">underline</property> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <method name="onCreate"><![CDATA[this.setDisplayValue(grandTotalPostedRecord.get("totalPostedCredits"));]]></method> + </data> + </cell> + <cell id="331"> + <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="337"> + <property name="fontWeight">bold</property> + <property name="textUnderline">underline</property> + <structure name="numberFormat"> + <property name="category">Currency</property> + <property name="pattern">#,##0.00{RoundingMode=HALF_UP}</property> + </structure> + <property name="textAlign">right</property> + <property name="resultSetColumn">EndingBalanceTotal</property> + </data> + </cell> + </row> + </footer> + </table> + </body> +</report> Modified: ofbiz/trunk/applications/accounting/widget/AccountingMenus.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/AccountingMenus.xml?rev=1003469&r1=1003468&r2=1003469&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/widget/AccountingMenus.xml (original) +++ ofbiz/trunk/applications/accounting/widget/AccountingMenus.xml Fri Oct 1 10:40:38 2010 @@ -338,6 +338,20 @@ under the License. <parameter param-name="invoiceId" from-field="invoice.invoiceId"/> </link> </menu-item> + <menu-item name="acctgTransEntriesPdf" title="Acctg Trans Entries PDF"> + <condition> + <and> + <not><if-empty field="invoice.invoiceId"/></not> + <or> + <if-compare field="invoice.statusId" operator="equals" value="INVOICE_READY"/> + <if-compare field="invoice.statusId" operator="equals" value="INVOICE_PAID"/> + </or> + </and> + </condition> + <link target="InvoiceAcctgTransEntriesPdf"> + <parameter param-name="invoiceId" from-field="invoice.invoiceId"/> + </link> + </menu-item> </menu> <menu name="PaymentTabBar" extends="CommonTabBarMenu" extends-resource="component://common/widget/CommonMenus.xml"> @@ -472,6 +486,20 @@ under the License. <parameter param-name="paymentId" from-field="payment.paymentId"/> </link> </menu-item> + <menu-item name="acctgTransEntriesPDF" title="Acctg Trans Entries PDF"> + <condition> + <and> + <not><if-empty field="payment.paymentId"/></not> + <or> + <if-compare field="payment.statusId" operator="equals" value="PMNT_RECEIVED"/> + <if-compare field="payment.statusId" operator="equals" value="PMNT_SENT"/> + </or> + </and> + </condition> + <link target="PaymentAcctgTransEntriesPdf"> + <parameter param-name="paymentId" from-field="payment.paymentId"/> + </link> + </menu-item> </menu> <menu name="PaymentGroupTabBar" extends="CommonTabBarMenu" extends-resource="component://common/widget/CommonMenus.xml"> Modified: ofbiz/trunk/applications/accounting/widget/GlScreens.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/GlScreens.xml?rev=1003469&r1=1003468&r2=1003469&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/widget/GlScreens.xml (original) +++ ofbiz/trunk/applications/accounting/widget/GlScreens.xml Fri Oct 1 10:40:38 2010 @@ -195,6 +195,23 @@ under the License. <parameter param-name="thruDate" from-field="parameters.thruDate"/> <parameter param-name="paymentId" from-field="parameters.paymentId"/> </link> + <link text="${uiLabelMap.AccountingExportWithInvoiceAndPaymentAsPdf}" style="buttontext" target="AcctgTransEntriesSearchResultsInvoiceAndPaymentPdf.pdf"> + <parameter param-name="organizationPartyId"/> + <parameter param-name="produtId" from-field="parameters.produtId"/> + <parameter param-name="isPosted" from-field="parameters.isPosted"/> + <parameter param-name="invoiceId" from-field="parameters.invoiceId"/> + <parameter param-name="acctgTransId" from-field="parameters.acctgTransId"/> + <parameter param-name="glFiscalTypeId" from-field="parameters.glFiscalTypeId"/> + <parameter param-name="glAccountId" from-field="parameters.glAccountId"/> + <parameter param-name="shipmentId" from-field="parameters.shipmentId"/> + <parameter param-name="acctgTransTypeId" from-field="parameters.acctgTransTypeId"/> + <parameter param-name="fromDate" from-field="parameters.fromDate"/> + <parameter param-name="workEffortId" from-field="parameters.workEffortId"/> + <parameter param-name="glJournalId" from-field="parameters.glJournalId"/> + <parameter param-name="partyId" from-field="parameters.partyId"/> + <parameter param-name="thruDate" from-field="parameters.thruDate"/> + <parameter param-name="paymentId" from-field="parameters.paymentId"/> + </link> <include-form name="ListFindAcctgTransEntriesByAccount" location="component://accounting/widget/GlForms.xml"/> </screenlet> </widgets> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |