Use the Document Service in Your Java Application

The invoice PDF document is stored in the document service repository. Its path needs to be updated in the SalesOrderHeader class by adding property for storing the invoice link.

1. Switch to the Java EE perspective.
2. Go to

   Module: espm-cloud-jpa

   Path: src/main/java > com.sap.espm.model

   JPA Entity Class: SalesOrderHeader

   Add the following property for storing the invoice link. Then add its getter and setter methods.

@Column(name = "INVOICE_LINK", length = 200)
   private String invoiceLink;
}

public void setInvoiceLink(String invoiceLink) {
		this.invoiceLink = invoiceLink;
	}

	public String getInvoiceLink() {
		return this.invoiceLink;
	}

1. Add the below dependency references to the Apache PDFBox in the pom.xml file.

   The Apache PDFBox library is an open source Java tool for working with PDF documents. It can be used for creation of new PDF documents, manipulation of existing ones, and to extract content from documents. For more information, see PDFBox.

   Module: espm-cloud-web

          <!-- PDF Box Dependencies -->
            <dependency>
            <groupId>org.apache.pdfbox</groupId>
            <artifactId>pdfbox-app</artifactId>
            <version>1.8.10</version>
          </dependency>

1. Add the dependency references to Apache Chemistry OpenCMIS in the pom.xml file.

   Applications access the document service using OASIS standard protocol Content Management Interoperability Service (CMIS).
   Java applications running on SAP Cloud Platform can easily consume the document service using the provided client library.
   Since the document service is exposed using a standard protocol, it can also be considered by any other technology that supports the CMIS protocol.
   For more information about the OpenCMIS, see Apache Chemistry

   Module: espm-cloud-web

<dependency>
     		  <groupId>org.apache.chemistry.opencmis</groupId>
     		  <artifactId>chemistry-opencmis-commons-impl</artifactId>
     		  <version>0.13.0</version>
     	  </dependency>
     	  <dependency>
     		  <groupId>org.apache.chemistry.opencmis</groupId>
     		  <artifactId>chemistry-opencmis-commons-api</artifactId>
     		  <version>0.13.0</version>
     	  </dependency>
     	  <dependency>
     		  <groupId>org.apache.chemistry.opencmis</groupId>
     		  <artifactId>chemistry-opencmis-client-api</artifactId>
     		  <version>0.13.0</version>
     	  </dependency>
     	  <dependency>
     		  <groupId>org.apache.chemistry.opencmis</groupId>
     		  <artifactId>chemistry-opencmis-client-impl</artifactId>
     		  <version>0.13.0</version>
     		  <exclusions>
     			  <exclusion>
     				  <artifactId>
     					  chemistry-opencmis-client-bindings
     				  </artifactId>
     				  <groupId>org.apache.chemistry.opencmis</groupId>
     			  </exclusion>
     		  </exclusions>
     	  </dependency>

1. Define a resource reference in the web.xml in order to connect to the ECMService in the web.xml file.

   Module: espm-cloud-web
   Path: src > main > webapp > WEB-INF > web.xml

<resource-ref>
    <res-ref-name>EcmService</res-ref-name>
    <res-type>com.sap.ecm.api.EcmService</res-type>
</resource-ref>

1. The Java properties file config.properties is used to store properties required for creating document service and read from it.

   Add the config.properties file in the following path with the below content.

   Module: espm-cloud-web

   Path: espm-cloud-web > src > main > resources

  #ESPM Document Repository Properties  
  uniqueName=espmdocs.repository  
  secretKey=Espm@1234567890  

1. Create a class ReadProperties.java.
   This file will read properties from config.properties for the document service.

   Module: espm-cloud-web

   Package: com.sap.espm.model.util

   Use the following code to implement the class.
   [DONE]

The following steps describe how to create classes for generating the Invoice PDF document, storing it in the document service repository, and for a return path to it.
1. Create the exception class CMISConnectionException.java for handling CMIS exceptions.

  Module: `espm-cloud-web`

  Package: `com.sap.espm.model.exception`

  Use [the following code](https://github.com/SAP/cloud-espm-v2/blob/master/espm-cloud-web/src/main/java/com/sap/espm/model/exception/CMISConnectionException.java) to implement the class.

1. Create a new class CMISSessionHelper.java. This class provides the implementation to connect to the document service and create the repository.

   Module: espm-cloud-web

   Package: com.sap.espm.model.documentservice

   Use the following code to implement the class.

2. Create the exception class for handling the PDF generation exceptions ReportGenerationException.java.

   Module: espm-cloud-web

   Package: com.sap.espm.model.exception

   Use the following code to implement the class.

3. Create class InvoiceBuilder.java for creating invoice PDF document, storing it in the repository, and for a return path to it.

   Module: espm-cloud-web

   Package: com.sap.espm.model.documentservice

   Use the following code to implement the class.

4. Create a Servlet Class CmisRead.java.

   When users click on any sales order from the list of sales orders, it will call CmisRead Servlet with a get URL parameter which contains the ID of the file/document clicked.
   This ID is what we will be saving in the database when we persist a file to document services repository during Sales Order Creation in ESPM.
   The CmisRead Servlet will read the file as stream based on the ID and force it to be downloaded by the browser.

   Module: espm-cloud-web

   Package: com.sap.espm.model.pdf.generator

   Use the following code to implement the class.

5. Add the Servlet mapping in the web.xml file.

<servlet>
        <description></description>
        <display-name>CmisRead</display-name>
        <servlet-name>CmisRead</servlet-name>
        <servlet-class>com.sap.espm.model.pdf.generator.CmisRead</servlet-class>
</servlet>
<servlet-mapping>
        <servlet-name>CmisRead</servlet-name>
        <url-pattern>/CmisRead</url-pattern>
</servlet-mapping>

1. When the end user creates an order, the instance of the invoiceBuilder class needs to be called to create the PDF document and update the sales order.
   For this, the class SalesOrderProcessor.java has to be modified. The code snipped below should be added in the get SalesOrderById method.

   Package: com.sap.espm.model.function.impl

   Class: SalesOrderProcessor.java

   Method: getSalesOrderById

try {

   Query query = em.createQuery("SELECT soi FROM SalesOrderItem soi where soi.id.salesOrderId= :salesOrderId");
   query.setParameter("salesOrderId", salesOrderId);

   try {

   	soiList = query.getResultList();
   	if (soiList != null && soiList.size() >= 1) {

   		for (SalesOrderItem salesOrderItem : soiList) {
   			query = em.createQuery(
   					"SELECT product FROM Product product where product.productId = :productId");
   			query.setParameter("productId", salesOrderItem.getProductId());
   			Product product = (Product) query.getSingleResult();
   			salesOrderItem.setProduct(product);

   		}
   		// if the sales order are fetched successfully, generate the
   		// pdf report data.
   		if (CMISSessionHelper.getSession() != null) {
   			InvoiceBuilder builder = new InvoiceBuilder();
   			String reportPath = builder.generateInvoice(soiList);
   			updateSalesOrderHeader(reportPath, soiList, em);
   		}


   	}

   } catch (NoResultException e) {
   	throw new ODataApplicationException("No matching Sales Order with Sales Order Id:" + salesOrderId,
   			Locale.ENGLISH, HttpStatusCodes.BAD_REQUEST);
   } catch (ReportGenerationException reportGenerationException) {
   	//LOGGER.error("Exception while generating the report : " + reportGenerationException.getMessage());
   	reportGenerationException.printStackTrace();
   	throw new ODataApplicationException("PDF Report Generation Error for :" + salesOrderId,
   			Locale.ENGLISH, HttpStatusCodes.INTERNAL_SERVER_ERROR);
   } catch(Throwable throwable){
   	throw new ODataApplicationException("PDF Report Generation Error for :" + salesOrderId,
   			Locale.ENGLISH, HttpStatusCodes.INTERNAL_SERVER_ERROR);
   }

   return soiList;

1. Add the import statements as shown in the snipped below.

import com.sap.espm.model.documentservice.CMISSessionHelper;
import com.sap.espm.model.documentservice.InvoiceBuilder;
import com.sap.espm.model.documentservice.ReportGenerationException;

1. Add the function for updating the SalesOrderHeader with path to the invoice PDF document.

   Package: com.sap.espm.model.function.impl

   Class: SalesOrderProcessor.java

   Method: updateSalesOrderHeather

/**
 * Function Import implementation for updating SalesOrderHeader with report path
 */
private void updateSalesOrderHeader(String reportPath, List<SalesOrderItem> soiList, EntityManager em) {
    SalesOrderHeader soh = null;
    // update the SalesOrderHeader with the report path
    if (soiList != null && soiList.size() >= 1) {
   	 EntityTransaction transaction = em.getTransaction();
   	 try {
   		 transaction.begin();
   		 soh = soiList.get(0).getSalesOrderHeader();
   		 soh..setInvoiceLink(reportPath);
   		 // save the soiList.
   		 em.merge(soh);

   	 }catch (Exception e){

   	 }finally{
   		 transaction.commit();
   	 }
    }
}

Add UI changes for viewing the Sales Order information and downloading the invoice PDF document.
For the end user to view their new orders, there is a separate view that needs to be enabled.

This view is shown on click of the View my sales orders button in the home page of the application.

Path: espm-cloud-web > src > main > webapp > webshop > controller

The below code snippet needs to be added to the function onOrdersButtonPressed in the Home.controller.js file.

  //var oBundle = this.getView().getModel('i18n').getResourceBundle();
  //MessageBox.information(oBundle.getText("soPopup.notImplemented"));
  var oRouter = UIComponent.getRouterFor(this);
  oRouter.navTo("SalesOrder");

1. Do a Maven build of the project.
   • Right click on the espm project > Run As > Maven build…
   • In the Goals field type in clean install and choose Run. In a couple of minutes the project will be build.
2. After the build is done, do a Maven update on the project.
   • Right click on the espm project > Maven > Update Project.
   • Choose OK from the box that appears.

Prerequisite: In order to be able to download the pdf version of the sales order you have to place an order first.

1. From the application home page choose (**_View my sales orders_**) in the upper right corner.
2. In the Email address box that appears enter the registered email ID and choose the Get sales orders list button.
3. Once the Sales order list appears select the sales order you placed and information about the customer and the selected product will be displayed on the right side of the screen.
4. Choose the Download PDF file button in the bottom right corner.