Author: hansbak
Date: Thu Jul 11 03:14:30 2013
New Revision: 1502093
URL: http://svn.apache.org/r1502093
Log:
add a csv import/export invoices at an organizational level with partyid and
productid translation functions, more imports/exports will follow
Added:
ofbiz/trunk/framework/base/lib/commons/commons-csv-1.0.jar (with props)
Modified:
ofbiz/trunk/.classpath
ofbiz/trunk/LICENSE
ofbiz/trunk/applications/accounting/config/AccountingUiLabels.xml
ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml
ofbiz/trunk/applications/accounting/data/DemoPaymentsInvoices.xml
ofbiz/trunk/applications/accounting/entitydef/entitymodel_reports.xml
ofbiz/trunk/applications/accounting/servicedef/services_invoice.xml
ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/invoice/InvoiceServices.java
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml
ofbiz/trunk/applications/accounting/widget/GlSetupForms.xml
ofbiz/trunk/applications/accounting/widget/GlSetupScreens.xml
ofbiz/trunk/framework/common/config/CommonUiLabels.xml
Modified: ofbiz/trunk/.classpath
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/.classpath?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/.classpath (original)
+++ ofbiz/trunk/.classpath Thu Jul 11 03:14:30 2013
@@ -83,6 +83,7 @@
<classpathentry kind="lib"
path="framework/base/lib/commons/commons-pool-1.3.jar"/>
<classpathentry kind="lib"
path="framework/base/lib/commons/commons-primitives-1.0.jar"/>
<classpathentry kind="lib"
path="framework/base/lib/commons/commons-validator-1.4.0.jar"/>
+ <classpathentry kind="lib"
path="framework/base/lib/commons/commons-csv-1.0.jar"/>
<classpathentry kind="lib"
path="framework/base/lib/j2eespecs/geronimo-activation_1.0.2_spec-1.0.jar"/>
<classpathentry kind="lib"
path="framework/base/lib/j2eespecs/geronimo-j2ee-connector_1.5_spec-1.0.jar"/>
<classpathentry kind="lib"
path="framework/base/lib/j2eespecs/geronimo-jaxr_1.0_spec-1.0.jar"/>
Modified: ofbiz/trunk/LICENSE
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/LICENSE?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/LICENSE (original)
+++ ofbiz/trunk/LICENSE Thu Jul 11 03:14:30 2013
@@ -44,6 +44,7 @@ framework/base/lib/commons/commons-cli-1
framework/base/lib/commons/commons-codec-1.6.jar
framework/base/lib/commons/commons-collections-3.2.1.jar
framework/base/lib/commons/commons-compress-1.4.1.jar
+framework/base/lib/commons/commons-csv-1.0.jar
framework/base/lib/commons/commons-digester3-3.2.jar
framework/base/lib/commons/commons-discovery-0.4.jar
framework/base/lib/commons/commons-el-1.0.jar
@@ -2729,4 +2730,5 @@ This package also includes the following
donated by SyncRO Soft Ltd., the publishers of the oXygen XML Editor.
* Cosmetic improvements provided by OpenStack.
-Webhelp for DocBook was developed as a Google Summer of Code project. August
2010
\ No newline at end of file
+Webhelp for DocBook was developed as a Google Summer of Code project. August
2010
+
Modified: ofbiz/trunk/applications/accounting/config/AccountingUiLabels.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/config/AccountingUiLabels.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/config/AccountingUiLabels.xml (original)
+++ ofbiz/trunk/applications/accounting/config/AccountingUiLabels.xml Thu Jul
11 03:14:30 2013
@@ -5010,6 +5010,9 @@
<value
xml:lang="zh">åºå®èµäº§æ°æ®ä¸çææ使ç¨å¯¿å½ç»æ为空ã</value>
<value
xml:lang="zh_TW">åºå®è³ç¢è³æä¸çææ使ç¨å£½å½çµæçºç©ºã</value>
</property>
+ <property key="AccountingExportInvoices">
+ <value xml:lang="en">Export Invoices</value>
+ </property>
<property key="AccountingExpenses">
<value xml:lang="de">Aufwendungen</value>
<value xml:lang="en">Expenses</value>
Modified: ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml (original)
+++ ofbiz/trunk/applications/accounting/data/AccountingTypeData.xml Thu Jul 11
03:14:30 2013
@@ -1087,4 +1087,7 @@ under the License.
<CustomMethod customMethodId="STR_LINE_DEP_FORMULA"
customMethodTypeId="DEPRECIATION_FORMULA"
customMethodName="straightLineDepreciation" description="Straight Line
depreciatiion algorithm for fixed asset((purchaseCost -
salvageCost)/expectedLifeInYears)"/>
<CustomMethod customMethodId="DBL_DECL_DEP_FORMULA"
customMethodTypeId="DEPRECIATION_FORMULA"
customMethodName="doubleDecliningBalanceDepreciation" description="Double
decline depreciatiion algorithm for fixed asset((NetBookValue -
salvageCost)*2/remainingLifeInYears)"/>
+ <!-- invoice export replacement Id types -->
+ <GoodIdentificationType description="replacement value for partyId in the
invoice export function in accounting"
goodIdentificationTypeId="INVOICE_EXPORT"/>
+ <PartyIdentificationType description="replacement value for partyId in the
invoice export function in accounting"
partyIdentificationTypeId="INVOICE_EXPORT"/>
</entity-engine-xml>
Modified: ofbiz/trunk/applications/accounting/data/DemoPaymentsInvoices.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/data/DemoPaymentsInvoices.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/data/DemoPaymentsInvoices.xml (original)
+++ ofbiz/trunk/applications/accounting/data/DemoPaymentsInvoices.xml Thu Jul
11 03:14:30 2013
@@ -224,4 +224,7 @@ under the License.
partyId="Company" transactionDate="2009-07-18 00:00:01.000"
entryDate="2009-08-11 12:28:45.315" performedByPartyId="admin"
statusId="FINACT_TRNS_CREATED" paymentId="8002"/>
<Payment paymentId="8002" finAccountTransId="9104"/>
+ <!-- invoice export demo data for replacement id's -->
+ <GoodIdentification goodIdentificationTypeId="INVOICE_EXPORT"
idValue="GZ-2644-replaced" productId="GZ-2644"/>
+ <PartyIdentification idValue="DemoCustomer2" partyId="DemoCustomer"
partyIdentificationTypeId="INVOICE_EXPORT"/>
</entity-engine-xml>
Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel_reports.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel_reports.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/entitydef/entitymodel_reports.xml
(original)
+++ ofbiz/trunk/applications/accounting/entitydef/entitymodel_reports.xml Thu
Jul 11 03:14:30 2013
@@ -77,4 +77,51 @@ under the License.
<key-map field-name="productId"/>
</view-link>
</view-entity>
+
+ <view-entity entity-name="InvoiceExport"
package-name="org.ofbiz.accounting.reports">
+ <member-entity entity-alias="INV" entity-name="Invoice"/>
+ <member-entity entity-alias="ITM" entity-name="InvoiceItem"/>
+ <member-entity entity-alias="PFR" entity-name="PartyIdentification"/>
+ <member-entity entity-alias="PTO" entity-name="PartyIdentification"/>
+ <member-entity entity-alias="GI" entity-name="GoodIdentification"/>
+ <alias entity-alias="INV" name="invoiceId" />
+ <alias entity-alias="INV" name="invoiceDate"/>
+ <alias entity-alias="INV" name="invoiceTypeId"/>
+ <alias entity-alias="INV" name="description"/>
+ <alias entity-alias="INV" name="partyIdFrom"/>
+ <alias entity-alias="PFR" name="partyIdFromTrans" field="idValue"/>
+ <alias entity-alias="INV" name="partyId"/>
+ <alias entity-alias="PTO" name="partyIdTrans" field="idValue"/>
+ <alias entity-alias="INV" name="currencyUomId"/>
+ <alias entity-alias="INV" name="referenceNum"/>
+ <alias entity-alias="ITM" name="invoiceItemSeqId"/>
+ <alias entity-alias="ITM" name="invoiceItemTypeId"/>
+ <alias entity-alias="ITM" name="itemDescription" field="description"/>
+ <alias entity-alias="ITM" name="productId"/>
+ <alias entity-alias="GI" name="productIdTrans" field="idValue"/>
+ <alias entity-alias="ITM" name="quantity"/>
+ <alias entity-alias="ITM" name="amount"/>
+ <view-link entity-alias="INV" rel-entity-alias="ITM"
rel-optional="true">
+ <key-map field-name="invoiceId"/>
+ </view-link>
+ <view-link entity-alias="INV" rel-entity-alias="PFR"
rel-optional="true">
+ <key-map field-name="partyIdFrom" rel-field-name="partyId"/>
+ <entity-condition>
+ <condition-expr entity-alias="PFR"
field-name="partyIdentificationTypeId" value="INVOICE_EXPORT"/>
+ </entity-condition>
+ </view-link>
+ <view-link entity-alias="INV" rel-entity-alias="PTO"
rel-optional="true">
+ <key-map field-name="partyId"/>
+ <entity-condition>
+ <condition-expr entity-alias="PTO"
field-name="partyIdentificationTypeId" value="INVOICE_EXPORT"/>
+ </entity-condition>
+ </view-link>
+ <view-link entity-alias="ITM" rel-entity-alias="GI"
rel-optional="true">
+ <key-map field-name="productId"/>
+ <entity-condition>
+ <condition-expr entity-alias="GI"
field-name="goodIdentificationTypeId"/>
+ </entity-condition>
+ </view-link>
+ </view-entity>
+
</entitymodel>
Modified: ofbiz/trunk/applications/accounting/servicedef/services_invoice.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/servicedef/services_invoice.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/servicedef/services_invoice.xml
(original)
+++ ofbiz/trunk/applications/accounting/servicedef/services_invoice.xml Thu Jul
11 03:14:30 2013
@@ -430,5 +430,12 @@ under the License.
<attribute name="invoiceId" type="String" mode="IN" optional="false"/>
<attribute name="isForeign" type="Boolean" mode="OUT"
optional="false"/>
</service>
+ <service name="importInvoice" engine="java"
+ location="org.ofbiz.accounting.invoice.InvoiceServices"
invoke="importInvoice" auth="true">
+ <description>Import an invoice with invoiceitems in csv
format</description>
+ <permission-service service-name="acctgInvoicePermissionCheck"
main-action="CREATE"/>
+ <attribute mode="INOUT" name="organizationPartyId" type="String"
optional="false"/>
+ <attribute mode="IN" name="uploadedFile" type="java.nio.ByteBuffer"
optional="true" />
+ </service>
</services>
Modified:
ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/invoice/InvoiceServices.java
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/invoice/InvoiceServices.java?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
---
ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/invoice/InvoiceServices.java
(original)
+++
ofbiz/trunk/applications/accounting/src/org/ofbiz/accounting/invoice/InvoiceServices.java
Thu Jul 11 03:14:30 2013
@@ -18,7 +18,16 @@
*******************************************************************************/
package org.ofbiz.accounting.invoice;
+import org.apache.commons.csv.CSVFormat;
+import org.apache.commons.csv.CSVFormat.CSVFormatBuilder;
+import org.apache.commons.csv.CSVRecord;
+
+import java.io.BufferedReader;
+import java.io.IOException;
+import java.io.StringReader;
import java.math.BigDecimal;
+import java.nio.ByteBuffer;
+import java.nio.charset.Charset;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Iterator;
@@ -3334,5 +3343,164 @@ public class InvoiceServices {
return ServiceUtil.returnError(ee.getMessage());
}
}
+
+ public static Map<String, Object> importInvoice(DispatchContext dctx,
Map<String, Object> context) {
+ Delegator delegator = dctx.getDelegator();
+ LocalDispatcher dispatcher = dctx.getDispatcher();
+ GenericValue userLogin = (GenericValue) context.get("userLogin");
+ ByteBuffer fileBytes = (ByteBuffer) context.get("uploadedFile");
+ String organizationPartyId = (String)
context.get("organizationPartyId");
+ String encoding = System.getProperty("file.encoding");
+ String csvString =
Charset.forName(encoding).decode(fileBytes).toString();
+ final BufferedReader csvReader = new BufferedReader(new
StringReader(csvString));
+ final CSVFormatBuilder builder =
CSVFormat.newBuilder(',').withQuoteChar('"').withHeader();
+ CSVFormat fmt = builder.build();
+ List<String> errMsgs = FastList.newInstance();
+ List<String> newErrMsgs = FastList.newInstance();
+ String lastInvoiceId = null;
+ String currentInvoiceId = null;
+ String newInvoiceId = null;
+ int invoicesCreated = 0;
+
+ if (fileBytes == null) {
+ return ServiceUtil.returnError("Uploaded file data not found");
+ }
+
+ try {
+ for(final CSVRecord rec : fmt.parse(csvReader)) {
+ currentInvoiceId = rec.get("invoiceId");
+ if (lastInvoiceId == null ||
!currentInvoiceId.equals(lastInvoiceId)) {
+ newInvoiceId = null;
+ Map<String, Object> invoice = UtilMisc.toMap(
+ "invoiceTypeId",
rec.get("invoiceTypeId"),
+ "partyIdFrom", rec.get("partyIdFrom"),
+ "partyId", rec.get("partyId"),
+ "invoiceDate", rec.get("invoiceDate"),
+ "dueDate", rec.get("dueDate"),
+ "currencyUomId",
rec.get("currencyUomId"),
+ "description", rec.get("description"),
+ "referenceNum", rec.get("referenceNum")
+ " Imported: orginal InvoiceId: " + currentInvoiceId,
+ "userLogin", userLogin
+ );
+
+ // replace values if required
+ if
(UtilValidate.isNotEmpty(rec.get("partyIdFromTrans"))) {
+ invoice.put("partyIdFrom",
rec.get("partyIdFromTrans"));
+ }
+ if
(UtilValidate.isNotEmpty(rec.get("partyIdTrans"))) {
+ invoice.put("partyId",
rec.get("partyIdTrans"));
+ }
+
+ // invoice validation
+ try {
+ newErrMsgs = FastList.newInstance();
+ if (UtilValidate.isEmpty(invoice.get("partyIdFrom"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Mandatory Party Id From and Party Id From Trans
missing for invoice: " + currentInvoiceId);
+ } else if (delegator.findOne("Party",
UtilMisc.<String, Object>toMap("partyId", invoice.get("partyIdFrom")), false)
== null) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": partyIdFrom: " + invoice.get("partyIdFrom") + " not
found for invoice: " + currentInvoiceId);
+ }
+ if (UtilValidate.isEmpty(invoice.get("partyId"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Mandatory Party Id and Party Id Trans missing for
invoice: " + currentInvoiceId);
+ } else if (delegator.findOne("Party",
UtilMisc.<String, Object>toMap("partyId", invoice.get("partyId")), false) ==
null) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": partyId: " + invoice.get("partyId") + " not found
for invoice: " + currentInvoiceId);
+ }
+ if
(UtilValidate.isEmpty(invoice.get("invoiceTypeId"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Mandatory Invoice Type missing for invoice: " +
currentInvoiceId);
+ } else if (delegator.findOne("InvoiceType",
UtilMisc.<String, Object>toMap("invoiceTypeId", invoice.get("invoiceTypeId")),
false) == null) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": InvoiceItem type id: " +
invoice.get("invoiceTypeId") + " not found for invoice: " + currentInvoiceId);
+ }
+ GenericValue invoiceType =
delegator.findOne("InvoiceType", UtilMisc.<String,
Object>toMap("invoiceTypeId", invoice.get("invoiceTypeId")), false);
+ if
("PURCHASE_INVOICE".equals(invoiceType.getString("parentTypeId")) &&
!invoice.get("partyId").equals(organizationPartyId)) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": A purchase type invoice should have the partyId 'To'
being the organizationPartyId(=" + organizationPartyId + ")! however is " +
invoice.get("partyId") +"! invoice: " + currentInvoiceId);
+ }
+ if
("SALES_INVOICE".equals(invoiceType.getString("parentTypeId")) &&
!invoice.get("partyIdFrom").equals(organizationPartyId)) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": A sales type invoice should have the partyId 'from'
being the organizationPartyId(=" + organizationPartyId + ")! however is " +
invoice.get("partyIdFrom") +"! invoice: " + currentInvoiceId);
+ }
+
+
+ } catch (GenericEntityException e) {
+ Debug.logError("Valication checking problem against
database. due to " + e.getMessage(), module);
+ }
+
+ if (newErrMsgs.size() > 0) {
+ errMsgs.addAll(newErrMsgs);
+ } else {
+ Map<String, Object> invoiceResult = null;
+ try {
+ invoiceResult =
dispatcher.runSync("createInvoice", invoice);
+ } catch (GenericServiceException e) {
+ Debug.logError(e, module);
+ return
ServiceUtil.returnError(e.getMessage());
+ }
+ newInvoiceId = (String) invoiceResult.get("invoiceId");
+ invoicesCreated++;
+ }
+ lastInvoiceId = currentInvoiceId;
+ }
+
+
+ if (newInvoiceId != null) {
+ Map<String, Object> invoiceItem =
UtilMisc.toMap(
+ "invoiceId", newInvoiceId,
+ "invoiceItemSeqId", rec.get("invoiceItemSeqId"),
+ "invoiceItemTypeId",
rec.get("invoiceItemTypeId"),
+ "productId", rec.get("productId"),
+ "description", rec.get("itemDescription"),
+ "amount", rec.get("amount"),
+ "quantity", rec.get("quantity"),
+ "userLogin", userLogin
+ );
+
+ if
(UtilValidate.isNotEmpty(rec.get("productIdTrans"))) {
+ invoiceItem.put("productId",
rec.get("productIdTrans"));
+ }
+ // invoice item validation
+ try {
+ newErrMsgs = FastList.newInstance();
+ if
(UtilValidate.isEmpty(invoiceItem.get("invoiceItemSeqId"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Mandatory item sequence Id missing for invoice: " +
currentInvoiceId);
+ }
+ if
(UtilValidate.isEmpty(invoiceItem.get("invoiceItemTypeId"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Mandatory invoice item type missing for invoice: " +
currentInvoiceId);
+ } else if (delegator.findOne("InvoiceItemType",
UtilMisc.<String, Object>toMap("invoiceItemTypeId",
invoiceItem.get("invoiceItemTypeId")), false) == null) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": InvoiceItem Item type id: " +
invoiceItem.get("invoiceItemTypeId") + " not found for invoice: " +
currentInvoiceId + " Item seqId:" + invoiceItem.get("invoiceItemSeqId"));
+ }
+ if (UtilValidate.isEmpty(invoiceItem.get("productId"))
&& UtilValidate.isEmpty(invoiceItem.get("description"))) {
+ }
+ if
(UtilValidate.isNotEmpty(invoiceItem.get("productId")) &&
delegator.findOne("Product", UtilMisc.<String, Object>toMap("productId",
invoiceItem.get("productId")), false) == null) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Product Id: " + invoiceItem.get("productId") + " not
found for invoice: " + currentInvoiceId + " Item seqId:" +
invoiceItem.get("invoiceItemSeqId"));
+ }
+ if (UtilValidate.isEmpty(invoiceItem.get("amount")) &&
UtilValidate.isEmpty(invoiceItem.get("quantity"))) {
+ newErrMsgs.add("Line number " +
rec.getRecordNumber() + ": Either or both quantity and amount is required for
invoice: " + currentInvoiceId + " Item seqId:" +
invoiceItem.get("invoiceItemSeqId"));
+ }
+ } catch (GenericEntityException e) {
+ Debug.logError("Validation checking problem against
database. due to " + e.getMessage(), module);
+ }
+
+ if (newErrMsgs.size() > 0) {
+ errMsgs.addAll(newErrMsgs);
+ } else {
+ try {
+ dispatcher.runSync("createInvoiceItem",
invoiceItem);
+ } catch (GenericServiceException e) {
+ Debug.logError(e, module);
+ return
ServiceUtil.returnError(e.getMessage());
+ }
+ }
+ }
+ }
+
+ } catch (IOException e) {
+ Debug.logError(e, module);
+ return ServiceUtil.returnError(e.getMessage());
+ }
+
+ if (errMsgs.size() > 0) {
+ return ServiceUtil.returnError(errMsgs);
+ }
+ Map<String, Object> result = ServiceUtil.returnSuccess(invoicesCreated
+ " new invoice(s) created");
+ result.put("organizationPartyId", organizationPartyId);
+ return result;
+ }
}
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=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
---
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml
(original)
+++
ofbiz/trunk/applications/accounting/webapp/accounting/WEB-INF/controller.xml
Thu Jul 11 03:14:30 2013
@@ -753,6 +753,23 @@ under the License.
<security https="true" auth="true"/>
<response name="success" type="view" value="ListGlAccountOrgCsv"/>
</request-map>
+
+ <!-- Import export -->
+ <request-map uri="ImportExport">
+ <security https="true" auth="true"/>
+ <response name="success" type="view" value="ImportExport"/>
+ </request-map>
+
+ <request-map uri="PartyAccountsExportInvoicesCsv.csv">
+ <security https="true" auth="true"/>
+ <response name="success" type="view"
value="PartyAccountsExportInvoicesCsv"/>
+ </request-map>
+ <request-map uri="uploadInvoice">
+ <security auth="true" https="true"/>
+ <event invoke="importInvoice" path="" type="service"/>
+ <response name="success" type="request" value="ImportExport"/>
+ <response name="error" type="view" value="ImportExport"/>
+ </request-map>
<!-- TO BE REMOVED
<request-map uri="EditGlobalGlAccountOrganizations"><security https="true"
auth="true"/><response name="success" type="view"
value="EditGlobalGlAccountOrganizations"/></request-map>
@@ -2768,6 +2785,10 @@ under the License.
<view-map name="ListGlAccountOrgPdf" type="screenfop"
page="component://accounting/widget/GlSetupScreens.xml#ListGlAccountOrgPdf"
content-type="application/pdf" encoding="none"/>
<view-map name="ListGlAccountOrgCsv" type="screencsv"
page="component://accounting/widget/GlSetupScreens.xml#ListGlAccountOrgCsv"
content-type="text/csv" encoding="none"/>
+ <!-- import export -->
+ <view-map name="ImportExport" type="screen"
page="component://accounting/widget/GlSetupScreens.xml#ImportExport"/>
+ <view-map name="PartyAccountsExportInvoicesCsv" type="screencsv"
page="component://accounting/widget/GlSetupScreens.xml#PartyAccountsExportInvoicesCsv"
content-type="text/csv" encoding="none"/>
+
<!-- Manual Credit Card Transaction -->
<view-map name="FindGatewayResponses"
page="component://accounting/widget/TransactionScreens.xml#FindGatewayResponses"
type="screen"/>
<view-map name="ViewGatewayResponse"
page="component://accounting/widget/TransactionScreens.xml#ViewGatewayResponse"
type="screen"/>
Modified: ofbiz/trunk/applications/accounting/widget/GlSetupForms.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/GlSetupForms.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/widget/GlSetupForms.xml (original)
+++ ofbiz/trunk/applications/accounting/widget/GlSetupForms.xml Thu Jul 11
03:14:30 2013
@@ -34,6 +34,11 @@ under the License.
<parameter param-name="organizationPartyId"
from-field="partyId"/>
</hyperlink>
</field>
+ <field name="importexport" title=" " use-when="hasBasicPermission"
widget-style="buttontext">
+ <hyperlink target="ImportExport"
description="${uiLabelMap.CommonImportExport}">
+ <parameter param-name="organizationPartyId"
from-field="partyId"/>
+ </hyperlink>
+ </field>
</form>
<form name="ListGlAccountOrganization" list-name="listIt" target=""
title="" type="list" view-size="50"
@@ -71,6 +76,55 @@ under the License.
<field name="submitButton"
title="${uiLabelMap.AccountingNewCompany}"><submit
button-type="button"/></field>
</form>
+ <form name="ExportInvoice" type="single"
target="PartyAccountsExportInvoicesCsv.csv" title="" >
+ <field name="organizationPartyId"><hidden
value="${parameters.organizationPartyId}"/></field>
+ <field name="invoiceId"><lookup
target-form-name="LookupInvoice"/></field>
+ <field name="startDate"><date-time/></field>
+ <field name="submitButton" title="${uiLabelMap.CommonSubmit}"><submit
button-type="button"/></field>
+ </form>
+
+ <form name="PartyAccountsExportInvoicesCsv" list-name="listIt" target=""
title="" type="list" view-size="99999"
+ odd-row-style="alternate-row" header-row-style="header-row-2"
default-table-style="basic-table hover-bar" paginate="false">
+ <actions>
+ <entity-condition entity-name="InvoiceExport">
+ <condition-list combine="and">
+ <condition-list combine="or">
+ <condition-expr field-name="partyIdFrom"
from-field="organizationPartyId" operator="equals"/>
+ <condition-expr field-name="partyId"
from-field="organizationPartyId" operator="equals"/>
+ </condition-list>
+ <condition-expr field-name="invoiceDate"
operator="greater-equals" from-field="parameters.startDate"
ignore-if-empty="true"/>
+ <condition-expr field-name="invoiceId" operator="equals"
from-field="parameters.invoiceId" ignore-if-empty="true"/>
+ </condition-list>
+ <order-by field-name="invoiceId"/>
+ </entity-condition>
+ </actions>
+ <field name="organizationPartyId"><hidden
value="${organizationPartyId}"/></field>
+ <field name="invoiceId" title="invoiceId"><display/></field>
+ <field name="invoiceTypeId" title="invoiceTypeId"><display/></field>
+ <field name="invoiceDate" title="invoiceDate"><display/></field>
+ <field name="dueDate" title="dueDate"><display/></field>
+ <field name="partyIdFrom" title="partyIdFrom"><display/></field>
+ <field name="partyIdFromTrans"
title="partyIdFromTrans"><display/></field>
+ <field name="partyId" title="partyId"><display/></field>
+ <field name="partyIdTrans" title="partyIdTrans"><display/></field>
+ <field name="currencyUomId" title="currencyUomId"><display/></field>
+ <field name="description" title="description"><display/></field>
+ <field name="referenceNum" title="referenceNum"><display/></field>
+ <field name="invoiceItemSeqId"
title="invoiceItemSeqId"><display/></field>
+ <field name="invoiceItemTypeId"
title="invoiceItemTypeId"><display/></field>
+ <field name="productId" title="productId"><display/></field>
+ <field name="productIdTrans" title="productIdTrans"><display/></field>
+ <field name="itemDescription"
title="itemDescription"><display/></field>
+ <field name="quantity" title="quantity"><display/></field>
+ <field name="amount" title="amount"><display/></field>
+ </form>
+
+ <form name="ImportInvoice" type="upload" target="uploadInvoice" title="" >
+ <field name="organizationPartyId"><hidden
value="${parameters.organizationPartyId}"/></field>
+ <field name="uploadedFile"><file/></field>
+ <field name="submitButton" title="${uiLabelMap.CommonUpload}"><submit
button-type="button"/></field>
+ </form>
+
<form name="AssignGlAccount" type="single"
target="createGlAccountOrganization" title="" default-map-name="account"
header-row-style="header-row" default-table-style="basic-table">
<field name="organizationPartyId"><hidden/></field>
Modified: ofbiz/trunk/applications/accounting/widget/GlSetupScreens.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/widget/GlSetupScreens.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/applications/accounting/widget/GlSetupScreens.xml (original)
+++ ofbiz/trunk/applications/accounting/widget/GlSetupScreens.xml Thu Jul 11
03:14:30 2013
@@ -51,7 +51,6 @@ under the License.
<screen name="ListCompanies">
<section>
<actions>
- <property-map resource="AccountingUiLabels"
map-name="uiLabelMap" global="true"/>
<set field="titleProperty"
value="AccountingAvailableInternalOrganizations"/>
<set field="headerItem" value="companies"/>
<set field="labelTitleProperty"
value="${uiLabelMap.AccountingAvailableInternalOrganizations}"/>
@@ -80,7 +79,6 @@ under the License.
<screen name="AddCompany">
<section>
<actions>
- <property-map resource="AccountingUiLabels"
map-name="uiLabelMap" global="true"/>
<set field="titleProperty" value="AccountingNewCompany"/>
</actions>
<widgets>
@@ -94,6 +92,32 @@ under the License.
</widgets>
</section>
</screen>
+ <screen name="ImportExport">
+ <section>
+ <actions>
+ <set field="titleProperty" value="CommonImportExport"/>
+ <entity-one entity-name="PartyGroup" value-field="partyGroup">
+ <field-map field-name="partyId"
from-field="parameters.organizationPartyId"/>
+ </entity-one>
+ </actions>
+ <widgets>
+ <decorator-screen name="main-decorator"
location="${parameters.mainDecoratorLocation}">
+ <decorator-section name="body">
+ <screenlet title="${uiLabelMap.AccountingInvoice}
${uiLabelMap.CommonImportExport} ${uiLabelMap.CommonFor}:
${partyGroup.groupName} [${parameters.organizationPartyId}]">
+ <container style="lefthalf">
+ <label
style="h2">${uiLabelMap.CommonImport}</label>
+ <include-form name="ImportInvoice"
location="component://accounting/widget/GlSetupForms.xml"/>
+ </container>
+ <container style="righthalf">
+ <label
style="h2">${uiLabelMap.CommonExport}</label>
+ <include-form name="ExportInvoice"
location="component://accounting/widget/GlSetupForms.xml"/>
+ </container>
+ </screenlet>
+ </decorator-section>
+ </decorator-screen>
+ </widgets>
+ </section>
+ </screen>
<screen name="ListGlAccountOrganization">
<section>
<actions>
@@ -559,6 +583,18 @@ under the License.
</widgets>
</section>
</screen>
+ <screen name="PartyAccountsExportInvoicesCsv">
+ <section>
+ <actions>
+ <property-map resource="CommonUiLabels" map-name="uiLabelMap"
global="true"/>
+ <property-map resource="AccountingUiLabels"
map-name="uiLabelMap" global="true"/>
+ <set field="organizationPartyId"
from-field="parameters.organizationPartyId"/>
+ </actions>
+ <widgets>
+ <include-form name="PartyAccountsExportInvoicesCsv"
location="component://accounting/widget/GlSetupForms.xml"/>
+ </widgets>
+ </section>
+ </screen>
<screen name="FindGlAccountCategory">
<section>
<actions>
Added: ofbiz/trunk/framework/base/lib/commons/commons-csv-1.0.jar
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/framework/base/lib/commons/commons-csv-1.0.jar?rev=1502093&view=auto
==============================================================================
Binary file - no diff available.
Propchange: ofbiz/trunk/framework/base/lib/commons/commons-csv-1.0.jar
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Modified: ofbiz/trunk/framework/common/config/CommonUiLabels.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/framework/common/config/CommonUiLabels.xml?rev=1502093&r1=1502092&r2=1502093&view=diff
==============================================================================
--- ofbiz/trunk/framework/common/config/CommonUiLabels.xml (original)
+++ ofbiz/trunk/framework/common/config/CommonUiLabels.xml Thu Jul 11 03:14:30
2013
@@ -5166,6 +5166,12 @@
<value xml:lang="vi">Ảnh</value>
<value xml:lang="zh">å¾ç</value>
</property>
+ <property key="CommonImport">
+ <value xml:lang="en">Import</value>
+ </property>
+ <property key="CommonImportExport">
+ <value xml:lang="en">Import/Export</value>
+ </property>
<property key="CommonIn">
<value xml:lang="ar">داخÙ</value>
<value xml:lang="cs">V</value>
