svn commit: r802840 - in /ofbiz/trunk/applications/acco
Locked
 
|
Author: apatel
Date: Mon Aug 10 16:10:19 2009 New Revision: 802840 URL: http://svn.apache.org/viewvc?rev=802840&view=rev Log: Pdf export of Cost Center reports. Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl (with props) Modified: ofbiz/trunk/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.ftl ofbiz/trunk/applications/accounting/widget/ReportFinancialSummaryScreens.xml Modified: ofbiz/trunk/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml?rev=802840&r1=802839&r2=802840&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml (original) +++ ofbiz/trunk/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml Mon Aug 10 16:10:19 2009 @@ -2522,10 +2522,12 @@ <set field="fromDate" from-field="customTimePeriod.fromDate" type="Timestamp"/> <set field="thruDate" from-field="customTimePeriod.thruDate" type="Timestamp"/> </if-empty> - + <set field="organizationPartyId" from-field="parameters.organizationPartyId"/> + <set field="partyIds" value="${groovy:org.ofbiz.party.party.PartyWorker.getAssociatedPartyIdsByRelationshipType(delegator, organizationPartyId, 'GROUP_ROLLUP')}" type="List"/> + <set field="partyIds[]" from-field="organizationPartyId"/> <entity-condition entity-name="GlAccountOrganization" list="glAccountOrganizations" use-cache="true"> <condition-list> - <condition-expr field-name="organizationPartyId" from-field="parameters.organizationPartyId"/> + <condition-expr field-name="organizationPartyId" operator="in" from-field="partyIds"/> <condition-expr field-name="postedBalance" operator="not-equals" value=""/> <condition-list combine="or"> <condition-expr field-name="fromDate" operator="greater-equals" from-field="fromDate"/> Modified: ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml?rev=802840&r1=802839&r2=802840&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml (original) +++ ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml Mon Aug 10 16:10:19 2009 @@ -2396,6 +2396,12 @@ <response name="success" type="view" value="CostCenterReport"/> <response name="error" type="view" value="CostCenterReport"/> </request-map> + + <request-map uri="CostCentersReport.pdf"> + <security auth="true" https="true"/> + <response name="success" type="view" value="CostCentersReportPdf"/> + </request-map> + <!-- end of request mappings --> <!-- View Mappings --> @@ -2686,5 +2692,7 @@ <view-map name="EditGlAccountCategoryMember" type="screen" page="component://accounting/widget/GlSetupScreens.xml#EditGlAccountCategoryMember"/> <view-map name="CostCenters" type="screen" page="component://accounting/widget/GlobalGlAccountsScreens.xml#CostCenters"/> <view-map name="CostCenterReport" type="screen" page="component://accounting/widget/ReportFinancialSummaryScreens.xml#CostCenterReport"/> + <view-map name="CostCentersReportPdf" type="screenfop" page="component://accounting/widget/ReportFinancialSummaryScreens.xml#CostCentersReportPdf" content-type="application/pdf" encoding="none"/> + <!-- end of view mappings --> </site-conf> Added: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl?rev=802840&view=auto ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl (added) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl Mon Aug 10 16:10:19 2009 @@ -0,0 +1,70 @@ +<#-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + +http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> +<#escape x as x?xml> + <#if glAcctgOrgAndCostCenterMapList?has_content && glAccountCategories?has_content> + <fo:table border="1pt solid" border-width=".1mm" width="19cm"> + <fo:table-header> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${uiLabelMap.FormFieldTitle_glAccountId}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${uiLabelMap.FormFieldTitle_accountCode}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${uiLabelMap.FormFieldTitle_accountName}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${uiLabelMap.FormFieldTitle_postedBalance} - (${currencyUomId?if_exists})</fo:block> + </fo:table-cell> + <#list glAccountCategories as glAccountCategory> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${glAccountCategory.description?if_exists} - (${currencyUomId?if_exists})</fo:block> + </fo:table-cell> + </#list> + </fo:table-header> + <fo:table-body> + <#list glAcctgOrgAndCostCenterMapList as glAcctgOrgAndCostCenterMap> + <#if glAcctgOrgAndCostCenterMap?has_content> + <fo:table-row> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${glAcctgOrgAndCostCenterMap.glAccountId?if_exists}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${glAcctgOrgAndCostCenterMap.accountCode?if_exists}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${glAcctgOrgAndCostCenterMap.accountName?if_exists}</fo:block> + </fo:table-cell> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${glAcctgOrgAndCostCenterMap.postedBalance?if_exists!}</fo:block> + </fo:table-cell> + <#list glAccountCategories as glAccountCategory> + <fo:table-cell border="1pt solid" border-width=".1mm"> + <fo:block text-align="center">${(glAcctgOrgAndCostCenterMap[glAccountCategory.glAccountCategoryId?if_exists]?if_exists)}</fo:block> + </fo:table-cell> + </#list> + </fo:table-row> + </#if> + </#list> + </fo:table-body> + </fo:table> + <#else> + <fo:block text-align="center">${uiLabelMap.AccountingNoRecordFound}</fo:block> + </#if> +</#escape> Propchange: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl ------------------------------------------------------------------------------ svn:eol-style = native Propchange: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl ------------------------------------------------------------------------------ svn:keywords = Date Rev Author URL Id Propchange: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.fo.ftl ------------------------------------------------------------------------------ svn:mime-type = text/plain Modified: ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.ftl URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.ftl?rev=802840&r1=802839&r2=802840&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.ftl (original) +++ ofbiz/trunk/applications/accounting/webapp/accounting/reports/CostCentersReport.ftl Mon Aug 10 16:10:19 2009 @@ -18,6 +18,13 @@ under the License. --> <#if glAcctgOrgAndCostCenterMapList?has_content && glAccountCategories?has_content> + <form name="costCentersReportPdfForm" method="post" action="<@ofbizUrl>CostCentersReport.pdf</@ofbizUrl>"> + <input type="hidden" name="organizationPartyId" value="${parameters.organizationPartyId}"/> + <input type="hidden" name="fromDate" value="${parameters.fromDate}"/> + <input type="hidden" name="thruDate" value="${parameters.thruDate}"/> + <input type="hidden" name="timePeriod" value="${parameters.timePeriod}"/> + <a href="javascript:document.costCentersReportPdfForm.submit();" class="buttontext">${uiLabelMap.AccountingExportAsPdf}</a> + </form> <table class="basic-table hover-bar" cellspacing="0"> <tr class="header-row"> <th>${uiLabelMap.FormFieldTitle_glAccountId}</th> Modified: ofbiz/trunk/applications/accounting/widget/ReportFinancialSummaryScreens.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/ReportFinancialSummaryScreens.xml?rev=802840&r1=802839&r2=802840&view=diff ============================================================================== --- ofbiz/trunk/applications/accounting/widget/ReportFinancialSummaryScreens.xml (original) +++ ofbiz/trunk/applications/accounting/widget/ReportFinancialSummaryScreens.xml Mon Aug 10 16:10:19 2009 @@ -1065,11 +1065,13 @@ </or> </condition> <widgets> - <platform-specific> - <html> - <html-template location="component://accounting/webapp/accounting/reports/CostCentersReport.ftl"/> - </html> - </platform-specific> + <screenlet title="${uiLabelMap.FormFieldTitle_costCenters}"> + <platform-specific> + <html> + <html-template location="component://accounting/webapp/accounting/reports/CostCentersReport.ftl"/> + </html> + </platform-specific> + </screenlet> </widgets> </section> </decorator-section> @@ -1077,4 +1079,32 @@ </widgets> </section> </screen> + + <screen name="CostCentersReportPdf"> + <section> + <actions> + <property-map resource="CommonUiLabels" map-name="uiLabelMap" global="true"/> + <property-map resource="AccountingUiLabels" map-name="uiLabelMap" global="true"/> + <service service-name="getPartyAccountingPreferences" result-map="result" auto-field-map="true"/> + <set field="partyAcctgPreference" from-field="result.partyAccountingPreference"/> + <set field="currencyUomId" from-field="partyAcctgPreference.baseCurrencyUomId"/> + <entity-condition entity-name="GlAccountCategory" list="glAccountCategories"> + <condition-expr field-name="glAccountCategoryTypeId" operator="equals" value="COST_CENTER"/> + </entity-condition> + <service service-name="getGlAcctgOrgWithPostedBalanceSplit" result-map="result" auto-field-map="true"/> + <set field="glAcctgOrgAndCostCenterMapList" from-field="result.glAcctgOrgAndCostCenterMapList" type="List"/> + </actions> + <widgets> + <decorator-screen name="SimpleDecorator" location="component://common/widget/CommonScreens.xml"> + <decorator-section name="body"> + <platform-specific> + <xsl-fo> + <html-template location="component://accounting/webapp/accounting/reports/CostCentersReport.fo.ftl"/> + </xsl-fo> + </platform-specific> + </decorator-section> + </decorator-screen> + </widgets> + </section> + </screen> </screens> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |