svn commit: r1003469 [2/7] - in /ofbiz/trunk/applications/acco
Locked
 
|
Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign?rev=1003469&view=auto ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign (added) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign Fri Oct 1 10:40:38 2010 @@ -0,0 +1,2033 @@ +<?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.base.util.collections) +importPackage(Packages.org.ofbiz.entity.util) +importPackage(Packages.org.ofbiz.entity.condition) + +module = "AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign"; + +organizationPartyId = params["organizationPartyId"].value; +userLoginId = params["userLoginId"].value; + +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())); + +// create debit/credit total variable +debitTotal = 0; +creditTotal = 0;]]></method> + <property name="iconFile">/templates/blank_report.gif</property> + <property name="bidiLayoutOrientation">ltr</property> + <parameters> + <scalar-parameter name="userLoginId" id="294"> + <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="346"> + <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="productId" id="347"> + <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="isPosted" id="348"> + <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="invoiceId" id="349"> + <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="acctgTransId" id="350"> + <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="glFiscalTypeId" id="351"> + <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="glAccountId" id="352"> + <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="shipmentId" id="353"> + <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="acctgTransTypeId" id="354"> + <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="fromDate" id="355"> + <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="workEffortId" id="356"> + <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="glJournalId" id="357"> + <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="partyId" id="358"> + <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="thruDate" id="359"> + <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="paymentId" id="360"> + <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> + </parameters> + <data-sources> + <script-data-source name="OFBiz" id="110"/> + </data-sources> + <data-sets> + <script-data-set name="AcctgTransAndEntries" id="260"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">glFiscalTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">acctgTransTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">transactionDate</property> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">postedDate</property> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">transDescription</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">glJournalId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">invoiceId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">paymentId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">debitCreditFlag</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">amount</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">currencyUomId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">origAmount</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">origCurrencyUomId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">glAccountTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">glAccountClassId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">partyId</property> + <property name="dataType">string</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">glFiscalTypeId</property> + <text-property name="displayName">glFiscalTypeId</text-property> + </structure> + <structure> + <property name="columnName">acctgTransTypeId</property> + <text-property name="displayName">acctgTransTypeId</text-property> + </structure> + <structure> + <property name="columnName">transactionDate</property> + <text-property name="displayName">transactionDate</text-property> + </structure> + <structure> + <property name="columnName">postedDate</property> + <text-property name="displayName">postedDate</text-property> + </structure> + <structure> + <property name="columnName">transDescription</property> + <text-property name="displayName">transDescription</text-property> + </structure> + <structure> + <property name="columnName">glJournalId</property> + <text-property name="displayName">glJournalId</text-property> + </structure> + <structure> + <property name="columnName">invoiceId</property> + <text-property name="displayName">invoiceId</text-property> + </structure> + <structure> + <property name="columnName">paymentId</property> + <text-property name="displayName">paymentId</text-property> + </structure> + <structure> + <property name="columnName">glAccountId</property> + <text-property name="displayName">glAccountId</text-property> + </structure> + <structure> + <property name="columnName">debitCreditFlag</property> + <text-property name="displayName">debitCreditFlag</text-property> + </structure> + <structure> + <property name="columnName">amount</property> + <text-property name="displayName">amount</text-property> + </structure> + <structure> + <property name="columnName">currencyUomId</property> + <text-property name="displayName">currencyUomId</text-property> + </structure> + <structure> + <property name="columnName">origAmount</property> + <text-property name="displayName">origAmount</text-property> + </structure> + <structure> + <property name="columnName">origCurrencyUomId</property> + <text-property name="displayName">origCurrencyUomId</text-property> + </structure> + <structure> + <property name="columnName">glAccountTypeId</property> + <text-property name="displayName">glAccountTypeId</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">accountName</text-property> + </structure> + <structure> + <property name="columnName">glAccountClassId</property> + <text-property name="displayName">glAccountClassId</text-property> + </structure> + <structure> + <property name="columnName">partyId</property> + <text-property name="displayName">partyId</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">glFiscalTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">acctgTransTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">transactionDate</property> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">postedDate</property> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">transDescription</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">glJournalId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">invoiceId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">paymentId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">glAccountId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">debitCreditFlag</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">amount</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">currencyUomId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">origAmount</property> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">origCurrencyUomId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">glAccountTypeId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">accountCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">accountName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">18</property> + <property name="name">glAccountClassId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">19</property> + <property name="name">partyId</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[var glAccountId = params["glAccountId"].value; +var acctgTransTypeId = params["acctgTransTypeId"].value; +var glFiscalTypeId = params["glFiscalTypeId"].value; +var glJournalId = params["glJournalId"].value; +var isPosted = params["isPosted"].value; +var partyId = params["partyId"].value; +var invoiceId = params["invoiceId"].value; +var paymentId = params["paymentId"].value; +var productId = params["productId"].value; +var workEffortId = params["workEffortId"].value; +var shipmentId = params["shipmentId"].value; +var acctgTransId = params["acctgTransId"].value; +var fromDate = params["fromDate"].value; +var thruDate = params["thruDate"].value; + +acctgTransAndEntries = null; + +try { + var conds = FastList.newInstance(); + if (glAccountId) conds.add(EntityCondition.makeCondition("glAccountId", EntityOperator.EQUALS, glAccountId)); + if (acctgTransTypeId) conds.add(EntityCondition.makeCondition("acctgTransTypeId", EntityOperator.EQUALS, acctgTransTypeId)); + if (glFiscalTypeId) conds.add(EntityCondition.makeCondition("glFiscalTypeId", EntityOperator.EQUALS, glFiscalTypeId)); + if (glJournalId) conds.add(EntityCondition.makeCondition("glJournalId", EntityOperator.EQUALS, glJournalId)); + if (isPosted) conds.add(EntityCondition.makeCondition("isPosted", EntityOperator.EQUALS, isPosted)); + if (partyId) conds.add(EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, partyId)); + if (invoiceId) conds.add(EntityCondition.makeCondition("invoiceId", EntityOperator.EQUALS, invoiceId)); + if (paymentId) conds.add(EntityCondition.makeCondition("paymentId", EntityOperator.EQUALS, paymentId)); + if (productId) conds.add(EntityCondition.makeCondition("productId", EntityOperator.EQUALS, productId)); + if (workEffortId) conds.add(EntityCondition.makeCondition("workEffortId", EntityOperator.EQUALS, workEffortId)); + if (shipmentId) conds.add(EntityCondition.makeCondition("shipmentId", EntityOperator.EQUALS, shipmentId)); + if (acctgTransId) conds.add(EntityCondition.makeCondition("acctgTransId", EntityOperator.EQUALS, acctgTransId)); + if (fromDate) conds.add(EntityCondition.makeCondition("transactionDate", EntityOperator.GREATER_THAN_EQUAL_TO, fromDate)); + if (thruDate) conds.add(EntityCondition.makeCondition("transactionDate", EntityOperator.LESS_THAN, thruDate)); + var orderBy = UtilMisc.toList("glAccountId", "-transactionDate"); + acctgTransAndEntries = delegator.findList("AcctgTransAndEntries", EntityCondition.makeCondition(conds), null, orderBy, null, false); +} catch (e) { + Debug.logInfo(e, module); +} + +totalRow = 0; +countOfRow = 0; + +if (acctgTransAndEntries) { + totalRow = acctgTransAndEntries.size(); +} +]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRow) return false; + +var acctgTransAndEntry = acctgTransAndEntries.get(countOfRow); +row["glFiscalTypeId"] = acctgTransAndEntry.get("glFiscalTypeId"); +row["acctgTransTypeId"] = acctgTransAndEntry.get("acctgTransTypeId"); +row["transactionDate"] = acctgTransAndEntry.get("transactionDate"); +row["postedDate"] = acctgTransAndEntry.get("postedDate"); +row["transDescription"] = acctgTransAndEntry.get("transDescription"); +row["glJournalId"] = acctgTransAndEntry.get("glJournalId"); +row["invoiceId"] = acctgTransAndEntry.get("invoiceId"); +row["paymentId"] = acctgTransAndEntry.get("paymentId"); +row["glAccountId"] = acctgTransAndEntry.get("glAccountId"); +row["debitCreditFlag"] = acctgTransAndEntry.get("debitCreditFlag"); +row["amount"] = acctgTransAndEntry.get("amount"); +row["currencyUomId"] = acctgTransAndEntry.get("currencyUomId"); +row["origAmount"] = acctgTransAndEntry.get("origAmount"); +row["origCurrencyUomId"] = acctgTransAndEntry.get("origCurrencyUomId"); +row["glAccountTypeId"] = acctgTransAndEntry.get("glAccountTypeId"); +row["accountCode"] = acctgTransAndEntry.get("accountCode"); +row["accountName"] = acctgTransAndEntry.get("accountName"); +row["glAccountClassId"] = acctgTransAndEntry.get("glAccountClassId"); +row["partyId"] = acctgTransAndEntry.get("partyId"); + +countOfRow ++; +return true;]]></method> + </script-data-set> + <script-data-set name="Organization" id="361"> + <list-property name="resultSetHints"> + <structure> + <property name="position">1</property> + <property name="name">partyId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">partyName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">address1</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">address2</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">city</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">stateProvinceAbbr</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">postalCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">countryName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">sendingPartyTaxId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">phoneCountryCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">phoneAreaCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">phoneContactNumber</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">emailAddress</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">webSiteAddress</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">eftAccountBankName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">eftAccountRoutingNumber</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">eftAccountAccountNumber</property> + <property name="dataType">string</property> + </structure> + </list-property> + <list-property name="columnHints"> + <structure> + <property name="columnName">partyId</property> + <text-property name="displayName">partyId</text-property> + </structure> + <structure> + <property name="columnName">partyName</property> + <text-property name="displayName">partyName</text-property> + </structure> + <structure> + <property name="columnName">address1</property> + <text-property name="displayName">address1</text-property> + </structure> + <structure> + <property name="columnName">address2</property> + <text-property name="displayName">address2</text-property> + </structure> + <structure> + <property name="columnName">city</property> + <text-property name="displayName">city</text-property> + </structure> + <structure> + <property name="columnName">stateProvinceAbbr</property> + <text-property name="displayName">stateProvinceAbbr</text-property> + </structure> + <structure> + <property name="columnName">postalCode</property> + <text-property name="displayName">postalCode</text-property> + </structure> + <structure> + <property name="columnName">countryName</property> + <text-property name="displayName">countryName</text-property> + </structure> + <structure> + <property name="columnName">sendingPartyTaxId</property> + <text-property name="displayName">sendingPartyTaxId</text-property> + </structure> + <structure> + <property name="columnName">phoneCountryCode</property> + <text-property name="displayName">phoneCountryCode</text-property> + </structure> + <structure> + <property name="columnName">phoneAreaCode</property> + <text-property name="displayName">phoneAreaCode</text-property> + </structure> + <structure> + <property name="columnName">phoneContactNumber</property> + <text-property name="displayName">phoneContactNumber</text-property> + </structure> + <structure> + <property name="columnName">emailAddress</property> + <text-property name="displayName">emailAddress</text-property> + </structure> + <structure> + <property name="columnName">webSiteAddress</property> + <text-property name="displayName">webSiteAddress</text-property> + </structure> + <structure> + <property name="columnName">eftAccountBankName</property> + <text-property name="displayName">eftAccountBankName</text-property> + </structure> + <structure> + <property name="columnName">eftAccountRoutingNumber</property> + <text-property name="displayName">eftAccountRoutingNumber</text-property> + </structure> + <structure> + <property name="columnName">eftAccountAccountNumber</property> + <text-property name="displayName">eftAccountAccountNumber</text-property> + </structure> + </list-property> + <structure name="cachedMetaData"> + <list-property name="resultSet"> + <structure> + <property name="position">1</property> + <property name="name">partyId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">2</property> + <property name="name">partyName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">3</property> + <property name="name">address1</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">4</property> + <property name="name">address2</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">5</property> + <property name="name">city</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">6</property> + <property name="name">stateProvinceAbbr</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">7</property> + <property name="name">postalCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">8</property> + <property name="name">countryName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">9</property> + <property name="name">sendingPartyTaxId</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">10</property> + <property name="name">phoneCountryCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">11</property> + <property name="name">phoneAreaCode</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">12</property> + <property name="name">phoneContactNumber</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">13</property> + <property name="name">emailAddress</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">14</property> + <property name="name">webSiteAddress</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">15</property> + <property name="name">eftAccountBankName</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">16</property> + <property name="name">eftAccountRoutingNumber</property> + <property name="dataType">string</property> + </structure> + <structure> + <property name="position">17</property> + <property name="name">eftAccountAccountNumber</property> + <property name="dataType">string</property> + </structure> + </list-property> + </structure> + <property name="dataSource">OFBiz</property> + <method name="open"><![CDATA[totalRows = 1; +countOfRow = 0;]]></method> + <method name="fetch"><![CDATA[if (countOfRow >= totalRows) return false; + +var context = FastMap.newInstance(); +var parameters = FastMap.newInstance(); +context.put("partyId", organizationPartyId); +context.put("nowTimestamp", UtilDateTime.nowTimestamp()); +context.put("locale", reportContext.getLocale()); +context.put("parameters", parameters); +context.put("delegator", delegator); +context.put("dispatcher", dispatcher); +GroovyUtil.runScriptAtLocation("component://order/webapp/ordermgr/WEB-INF/actions/order/CompanyHeader.groovy", context); +var postalAddress = context.get("postalAddress"); +var country = postalAddress.getRelatedOne("CountryGeo"); +var phone = context.get("phone"); +var email = context.get("email"); +var webSite = context.get("website"); +var eftAccount = context.get("eftAccount"); + +row["partyId"] = organizationPartyId; +row["partyName"] = context.get("companyName"); +row["sendingPartyTaxId"] = context.get("sendingPartyTaxId"); +row["stateProvinceAbbr"] = context.get("stateProvinceAbbr"); + +if (postalAddress) { + row["address1"] = postalAddress.get("address1"); + row["address2"] = postalAddress.get("address2"); + row["city"] = postalAddress.get("city"); + row["postalCode"] = postalAddress.get("postalCode"); +} + +if (country) { + row["countryName"] = country.get("geoName"); +} + +if (phone) { + row["phoneCountryCode"] = phone.get("countryCode"); + row["phoneAreaCode"] = phone.get("areaCode"); + row["phoneContactNumber"] = phone.get("contactNumber"); +} + +if (email) { + row["emailAddress"] = email.get("infoString"); +} + +if (webSite) { + row["webSiteAddress"] = webSite.get("infoString"); + row["eftAccountBankName"] = webSite.get("bankName"); + row["eftAccountRoutingNumber"] = webSite.get("routingNumber"); + row["eftAccountAccountName"] = webSite.get("accountName"); +} + +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">2in</property> + <page-header> + <grid id="7"> + <property name="width">10.363636363636363in</property> + <column id="8"> + <property name="width">0.797979797979798in</property> + <property name="fontWeight">normal</property> + <property name="textAlign">left</property> + </column> + <column id="9"> + <property name="width">4.393939393939394in</property> + </column> + <column id="46"> + <property name="width">2.585858585858586in</property> + <property name="fontSize">10pt</property> + <property name="fontWeight">bold</property> + <property name="textAlign">right</property> + </column> + <column id="56"> + <property name="width">2.585858585858586in</property> + </column> + <row id="10"> + <cell id="11"> + <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="37"/> + <cell id="47"/> + </row> + <row id="13"> + <cell id="14"> + <property name="colSpan">2</property> + <property name="rowSpan">1</property> + <data id="386"> + <property name="whiteSpace">nowrap</property> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">partyName</property> + <text-property name="displayName">partyName</text-property> + <expression name="expression" type="javascript">dataSetRow["partyName"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">partyName</property> + </data> + </cell> + <cell id="38"/> + <cell id="48"/> + </row> + <row id="16"> + <cell id="17"> + <data id="387"> + <property name="whiteSpace">nowrap</property> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">address1</property> + <text-property name="displayName">address1</text-property> + <expression name="expression" type="javascript">dataSetRow["address1"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">address1</property> + </data> + </cell> + <cell id="18"> + <data id="388"> + <property name="whiteSpace">nowrap</property> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">address2</property> + <text-property name="displayName">address2</text-property> + <expression name="expression" type="javascript">dataSetRow["address2"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">address2</property> + </data> + </cell> + <cell id="39"/> + <cell id="49"/> + </row> + <row id="19"> + <cell id="20"> + <property name="colSpan">2</property> + <property name="rowSpan">1</property> + <data id="400"> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">partyId</property> + <expression name="expression" type="javascript">dataSetRow["partyId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">partyName</property> + <expression name="expression" type="javascript">dataSetRow["partyName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">address1</property> + <expression name="expression" type="javascript">dataSetRow["address1"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">address2</property> + <expression name="expression" type="javascript">dataSetRow["address2"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">city</property> + <expression name="expression" type="javascript">dataSetRow["city"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">stateProvinceAbbr</property> + <expression name="expression" type="javascript">dataSetRow["stateProvinceAbbr"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">postalCode</property> + <expression name="expression" type="javascript">dataSetRow["postalCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">countryName</property> + <expression name="expression" type="javascript">dataSetRow["countryName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">sendingPartyTaxId</property> + <expression name="expression" type="javascript">dataSetRow["sendingPartyTaxId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">phoneCountryCode</property> + <expression name="expression" type="javascript">dataSetRow["phoneCountryCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">phoneAreaCode</property> + <expression name="expression" type="javascript">dataSetRow["phoneAreaCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">phoneContactNumber</property> + <expression name="expression" type="javascript">dataSetRow["phoneContactNumber"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">emailAddress</property> + <expression name="expression" type="javascript">dataSetRow["emailAddress"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">webSiteAddress</property> + <expression name="expression" type="javascript">dataSetRow["webSiteAddress"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">eftAccountBankName</property> + <expression name="expression" type="javascript">dataSetRow["eftAccountBankName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">eftAccountRoutingNumber</property> + <expression name="expression" type="javascript">dataSetRow["eftAccountRoutingNumber"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">eftAccountAccountNumber</property> + <expression name="expression" type="javascript">dataSetRow["eftAccountAccountNumber"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <method name="onCreate"><![CDATA[var address = ""; + +if (row["city"]) { + address += row["city"] + ", "; +} + +if (row["stateProvinceAbbr"]) { + address += row["stateProvinceAbbr"] + " "; +} + +if (row["postalCode"]) { + address += row["postalCode"] + " "; +} + +if (row["countryName"]) { + address += row["countryName"]; +} + +this.setDisplayValue(address);]]></method> + </data> + </cell> + <cell id="40"/> + <cell id="50"/> + </row> + <row id="279"> + <cell id="280"> + <label id="391"> + <text-property name="text">Party Tax: </text-property> + </label> + </cell> + <cell id="281"> + <data id="398"> + <property name="textAlign">left</property> + <property name="whiteSpace">nowrap</property> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">sendingPartyTaxId</property> + <text-property name="displayName">sendingPartyTaxId</text-property> + <expression name="expression" type="javascript">dataSetRow["sendingPartyTaxId"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">sendingPartyTaxId</property> + </data> + </cell> + <cell id="282"/> + <cell id="283"/> + </row> + <row id="392"> + <cell id="393"> + <label id="397"> + <text-property name="text">E-mail: </text-property> + </label> + </cell> + <cell id="394"> + <data id="399"> + <property name="textAlign">left</property> + <property name="whiteSpace">nowrap</property> + <property name="dataSet">Organization</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">emailAddress</property> + <text-property name="displayName">emailAddress</text-property> + <expression name="expression" type="javascript">dataSetRow["emailAddress"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <property name="resultSetColumn">emailAddress</property> + </data> + </cell> + <cell id="395"/> + <cell id="396"/> + </row> + <row id="273"> + <cell id="274"> + <property name="colSpan">4</property> + <property name="rowSpan">1</property> + <label id="430"> + <property name="fontSize">16pt</property> + <property name="fontWeight">bold</property> + <property name="textAlign">center</property> + <text-property name="text">Accounting Transactioin Entries</text-property> + </label> + </cell> + </row> + </grid> + </page-header> + <page-footer> + <grid id="138"> + <property name="height">0.4583333333333333in</property> + <property name="width">10.354166666666666in</property> + <column id="256"> + <property name="width">4.041666666666667in</property> + </column> + <column id="139"> + <property name="width">0.71875in</property> + </column> + <column id="140"> + <property name="width">0.3541666666666667in</property> + </column> + <column id="141"> + <property name="width">0.6875in</property> + </column> + <column id="257"> + <property name="width">4.552083333333333in</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="73"> + <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.464646464646465in</property> + <property name="dataSet">AcctgTransAndEntries</property> + <list-property name="boundDataColumns"> + <structure> + <property name="name">glFiscalTypeId</property> + <expression name="expression">dataSetRow["glFiscalTypeId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">acctgTransTypeId</property> + <expression name="expression">dataSetRow["acctgTransTypeId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">transactionDate</property> + <expression name="expression">dataSetRow["transactionDate"]</expression> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="name">postedDate</property> + <expression name="expression">dataSetRow["postedDate"]</expression> + <property name="dataType">date-time</property> + </structure> + <structure> + <property name="name">transDescription</property> + <expression name="expression">dataSetRow["transDescription"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">glJournalId</property> + <expression name="expression">dataSetRow["glJournalId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">invoiceId</property> + <expression name="expression">dataSetRow["invoiceId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">paymentId</property> + <expression name="expression">dataSetRow["paymentId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">glAccountId</property> + <expression name="expression">dataSetRow["glAccountId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">debitCreditFlag</property> + <expression name="expression">dataSetRow["debitCreditFlag"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">amount</property> + <expression name="expression">dataSetRow["amount"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">currencyUomId</property> + <expression name="expression">dataSetRow["currencyUomId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">origAmount</property> + <expression name="expression">dataSetRow["origAmount"]</expression> + <property name="dataType">decimal</property> + </structure> + <structure> + <property name="name">origCurrencyUomId</property> + <expression name="expression">dataSetRow["origCurrencyUomId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">glAccountTypeId</property> + <expression name="expression">dataSetRow["glAccountTypeId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountCode</property> + <expression name="expression">dataSetRow["accountCode"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">accountName</property> + <expression name="expression">dataSetRow["accountName"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">glAccountClassId</property> + <expression name="expression">dataSetRow["glAccountClassId"]</expression> + <property name="dataType">string</property> + </structure> + <structure> + <property name="name">partyId</property> + <text-property name="displayName">partyId</text-property> + <expression name="expression" type="javascript">dataSetRow["partyId"]</expression> + <property name="dataType">string</property> + </structure> + </list-property> + <column id="435"> + <property name="width">0.8181818181818182in</property> + </column> + <column id="86"> + <property name="width">0.7272727272727273in</property> + </column> + <column id="87"> + <property name="width">2.7676767676767677in</property> + </column> + <column id="365"> + <property name="width">0.6262626262626263in</property> + <property name="textAlign">center</property> + </column> + <column id="369"> + <property name="width">0.5959595959595959in</property> + <property name="textAlign">center</property> + </column> + <column id="375"> + <property name="width">1.7575757575757576in</property> + <property name="textAlign">center</property> + </column> + <column id="88"> + <property name="width">0.8181818181818182in</property> + <property name="textAlign">center</property> + </column> + <column id="307"> + <property name="width">0.9393939393939394in</property> + <property name="textAlign">center</property> + </column> + <column id="105"> + <property name="width">0.696969696969697in</property> + <property name="textAlign">center</property> + </column> + <column id="101"> + <property name="width">0.696969696969697in</property> + <property name="textAlign">center</property> + </column> + <header> + <row id="74"> + <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="431"> + <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="436"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_transactionDate");]]></method> + <text-property name="text">Date</text-property> + </label> + </cell> + <cell id="75"> + <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="92"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountCode");]]></method> + <text-property name="text">Account Code</text-property> + </label> + </cell> + <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="93"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_accountName");]]></method> + <text-property name="text">Account Name</text-property> + </label> + </cell> + <cell id="362"> + <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="370"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_invoiceId");]]></method> + <text-property name="text">Invoice ID</text-property> + </label> + </cell> + <cell id="366"> + <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="371"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_paymentId");]]></method> + <text-property name="text">Payment ID</text-property> + </label> + </cell> + <cell id="372"> + <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="376"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("CommonPartyId");]]></method> + <text-property name="text">Party</text-property> + </label> + </cell> + <cell id="77"> + <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="106"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("AccountingOriginalCurrency");]]></method> + <text-property name="text">Original Currency</text-property> + </label> + </cell> + <cell id="304"> + <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="308"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_exchangeRate");]]></method> + <text-property name="text">Exchange Rate</text-property> + </label> + </cell> + <cell id="102"> + <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"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_debit");]]></method> + <text-property name="text">Debit</text-property> + </label> + </cell> + <cell id="98"> + <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="109"> + <property name="fontSize">6pt</property> + <method name="onCreate"><![CDATA[this.text = uiLabelMap.get("FormFieldTitle_credit");]]></method> + <text-property name="text">Credit</text-property> + </label> + </cell> + </row> + </header> + <group id="401"> + <property name="groupName">glAccountClassId</property> + <property name="interval">none</property> + <property name="sortDirection">asc</property> + <expression name="keyExpr" type="javascript">row["glAccountClassId"]</expression> + <structure name="toc"> + <expression name="expressionValue" type="javascript">row["glAccountClassId"]</expression> + </structure> + <property name="repeatHeader">true</property> + <property name="hideDetail">false</property> + <property name="pageBreakAfter">auto</property> + <property name="pageBreakBefore">auto</property> + <property name="pageBreakInside">auto</property> + <header> + <row id="402"> + <cell id="432"> + <property name="colSpan">3</property> + <property name="rowSpan">1</property> + <data id="424"> + <property name="fontSize">8pt</property> + <property name="fontWeight">bold</property> + <method name="onCreate"><![CDATA[var glAccountClass = delegator.findOne("GlAccountClass", UtilMisc.toMap("glAccountClassId", row["glAccountClassId"]), false); +if (glAccountClass) { + this.setDisplayValue(glAccountClass.get("description")); +}]]></method> + <property name="resultSetColumn">glAccountClassId</property> + </data> + </cell> + <cell id="406"/> + <cell id="407"/> + <cell id="408"/> + <cell id="409"/> + <cell id="410"/> + <cell id="411"/> + <cell id="412"/> + </row> + </header> + </group> + <detail> + <row id="78"> + <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> + <cell id="433"> + <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="437"> + <property name="fontSize">6pt</property> + <structure name="dateTimeFormat"> + <property name="category">Custom</property> + <property name="pattern">d MMMM yyyy</property> + <property name="locale">en</property> + </structure> + <property name="textAlign">center</property> + <property name="whiteSpace">nowrap</property> [... 426 lines stripped ...] |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |