View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Examples/Window and Tab

ERP 2.50:Developers Guide


Warning.png   This document is still a work in progress. It may contain inaccuracies or errors.

Print Button

Create a process:

Id: RptC_Tiquet
Name: RptC_Tiquet
Data access: Entity/Organization
Report checkbox: Checked

(Image IiP.png)

Action: Process
Default value checkbox: Checked
Java class name: org.openbravo.erpReports.RptC_Tiquet

(Image PC.png)

Mapping name: /RptC_Tiquet
Default value checkbox: Checked

(Image PM.png)

Use as a model the following code in java.

package org.openbravo.erpReports;
import org.openbravo.erpCommon.utility.*;
import org.openbravo.erpCommon.businessUtility.Tree;
import org.openbravo.erpCommon.businessUtility.TreeData;
import org.openbravo.erpCommon.businessUtility.WindowTabs;
import org.openbravo.base.secureApp.HttpSecureAppServlet;
import org.openbravo.base.secureApp.VariablesSecureApp;
import org.openbravo.xmlEngine.XmlDocument;
import java.util.HashMap;
import java.util.Date;
import java.text.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.openbravo.utils.Replace;
import org.openbravo.erpCommon.ad_combos.OrganizationComboData;
import org.openbravo.erpCommon.utility.DateTimeData;
import net.sf.jasperreports.engine.*;
import java.sql.Connection;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
public class RptC_Tiquet extends HttpSecureAppServlet {  
 public void init (ServletConfig config) {
   boolHist = false;
 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
   VariablesSecureApp vars = new VariablesSecureApp(request);
   if (vars.commandIn("DEFAULT")) {
     String strcOrderId = vars.getSessionValue("RptC_Tiquet.inpcOrderId_R");
     strcOrderId = vars.getStringParameter("inpcOrderId");
     if (strcOrderId.equals("")) strcOrderId = vars.getSessionValue("RptC_Tiquet.inpcOrderId");
     if (log4j.isDebugEnabled()) log4j.debug("strcOrderId: "+ strcOrderId);
     printPagePartePDF(response, vars, strcOrderId);
   } else pageError(response);
  void printPagePartePDF(HttpServletResponse response, VariablesSecureApp vars, String strcOrderId) throws IOException,ServletException{
   if (log4j.isDebugEnabled()) log4j.debug("Output: RptC_TiquetJR - pdf");
   JasperPrint jasperPrint;    
   String strReportName = "@basedesign@/org/openbravo/erpReports/C_TiquetJR.jrxml";
   response.setHeader("Content-disposition", "inline; filename=SalesOrderJR.pdf");
   strcOrderId=strcOrderId.replace("(", "");
   strcOrderId=strcOrderId.replace(")", "");
   strcOrderId=strcOrderId.replace("\'", "");
   HashMap<String, Object> parameters = new HashMap<String, Object>();
   parameters.put("C_ORDER_ID", strcOrderId);    
   renderJR(vars, response, strReportName, "pdf", parameters, null, null );    
 public String getServletInfo() {
   return "Servlet that presents the RptCOrders seeker";
 } // End of getServletInfo() method}

Copy it into /home/openbravo/OpenbravoERP/AppsOpenbravo/src/org/openbravo/erpReports

In your .jrxml file you get the parameter C_ORDER_ID from the .java writing your SQL so:


Copy your jasper template (.jrxml file) into /home/openbravo/OpenbravoERP/AppsOpenbravo/src/org/openbravo/erpReports

Then compile the changes using:

ant compile.development -Dtab=xxx

Now, you should change the current process that the print button from (i.e.) Sales Order windows executes. Go to Windows, Tab and Fields. Then look for the windows Sales Order and in the Header tab, locate the Process field. Change the value for your newly created RptC_Tiquet.

Then, compile the windows

ant compile.development -Dtab="Sales Order"

If you want to see your changes, restart apache-tomcat.

Display Role in Menu

To display the rolename currently selected by the logged in user next to the username in the leftside menu, update the following two files:

<SqlMethod name="getRoleName" type="preparedStatement" return="String" default="">
    WHERE AD_Role_ID = ?
  <Parameter name="adRoleId"/>
xmlDocument.setParameter("userName", MenuData.getUserName(this, vars.getUser()) + " (" + MenuData.getRoleName(this, vars.getRole()) + ")");

Then, compile the manual code from the commandline, positioned inside the OpenbravoERP/AppsOpenbravo:

ant compile.development -Dtab=XXX


Adding a Callout

Modifying a Callout to show a Message to the user, for clients checked as debtors, always that they try to buy NOT in cash (in certain windows with periodical payments).

1.- Create a new column in the C_BPARTNER table called isdebtor as char. Don't forget to Synchronize. Add this field to the windows Partner.

2.- Create a new message in the AD called isdebtor, with the alert wanted to show to the user.

3.- Add the next Sqlmethod to the file SE_Order_BPartner_data.xsql located under ~/OpenbravoERP/AppsOpenbravo/src/org/openbravo/erpCommon/ad_callouts/ if you are using Linux. This method gets if the partner was checked as debtor.

 <SqlMethod name="partnerDebtor" type="preparedStatement" return="String" default="">
     select isdebtor
     from c_bpartner
     where c_bpartner_id = ?
   <Parameter name="cBpartnerId"/>
   <Field name="isdebtor" value=""/>

4.- At the end of file located in the same directory, add the following java code. Pay attention to the if-condition to see if it fulfil your requirements.

   //Modified BEGINS
   //Get if the partner was checked as debtor
   String debtor = SEOrderBPartnerData.partnerDebtor(this, strBPartner);
   char[] is_debtor = debtor.toCharArray();

   //Get windows_id
   int intWindowId = Integer.parseInt(strWindowId);

   //If Partner is Debtor and Windows isn't "Cash windows" and Windows isn't Ticket Windows  
   if(is_debtor[0]=='Y' && intWindowId!=100001 && intWindowId!=100003)
      resultado.append(", new Array('MESSAGE', \"" + Utility.messageBD(this, "isdebtor", vars.getLanguage()) + "\")");
   //Modified END

   xmlDocument.setParameter("array", resultado.toString());
   xmlDocument.setParameter("frameName", "frameAplicacion");
   response.setContentType("text/html; charset=UTF-8");
   PrintWriter out = response.getWriter();

5.- Compile

ERP 2.50:Developers Guide/Examples/SOAP WebService | ERP 2.50:Developers Guide/Examples/Data Access Layer and REST 

Retrieved from ""

This page has been accessed 9,959 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.