|
1
19 package org.openbravo.erpCommon.ad_reports;
20
21 import org.openbravo.erpCommon.utility.*;
22 import org.openbravo.erpCommon.businessUtility.WindowTabs;
23 import org.openbravo.base.secureApp.HttpSecureAppServlet;
24 import org.openbravo.base.secureApp.VariablesSecureApp;
25 import org.openbravo.xmlEngine.XmlDocument;
26 import java.io.*;
27 import javax.servlet.*;
28 import javax.servlet.http.*;
29
30 import java.util.*;
31 import net.sf.jasperreports.engine.*;
32 import net.sf.jasperreports.engine.design.JasperDesign;
33 import java.sql.Connection  ;
34 import net.sf.jasperreports.engine.xml.JRXmlLoader;
35 import net.sf.jasperreports.engine.export.JRHtmlExporter;
36 import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
37
38 import org.openbravo.erpCommon.ad_combos.OrganizationComboData;
39 import org.openbravo.erpCommon.utility.ComboTableData;
40
42 import org.openbravo.erpCommon.utility.DateTimeData;
43
44 public class ReportOrderNotInvoiceJR extends HttpSecureAppServlet {
45
46
47 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
48 VariablesSecureApp vars = new VariablesSecureApp(request);
49
50 if (!Utility.hasProcessAccess(this, vars, "", "ReportOrderNotInvoiceJR")) {
51 bdError(response, "AccessTableNoView", vars.getLanguage());
52 return;
53 }
54
55 if (vars.commandIn("DEFAULT")){
56 String strdateFrom = vars.getGlobalVariable("inpDateFrom", "ReportOrderNotInvoiceJR|dateFrom", "");
57 String strdateTo = vars.getGlobalVariable("inpDateTo", "ReportOrderNotInvoiceJR|dateTo", "");
58 String strcBpartnetId = vars.getGlobalVariable("inpcBPartnerId", "ReportOrderNotInvoiceJR|bpartner", "");
59 String strCOrgId = vars.getGlobalVariable("inpOrg", "ReportOrderNotInvoiceJR|Org", "");
60 String strInvoiceRule = vars.getGlobalVariable("inpInvoiceRule", "ReportOrderNotInvoiceJR|invoiceRule", "");
61 String strDetail = vars.getStringParameter("inpDetail", "0");
62 printPageDataSheet(response, vars, strdateFrom, strdateTo, strcBpartnetId, strCOrgId, strInvoiceRule, strDetail);
63 }else if (vars.commandIn("FIND")) {
64 String strdateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportOrderNotInvoiceJR|dateFrom");
65 String strdateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportOrderNotInvoiceJR|dateTo");
66 String strcBpartnetId = vars.getRequestGlobalVariable("inpcBPartnerId", "ReportOrderNotInvoiceJR|bpartner");
67 String strCOrgId = vars.getRequestGlobalVariable("inpOrg", "ReportOrderNotInvoiceJR|Org");
68 String strInvoiceRule = vars.getRequestGlobalVariable("inpInvoiceRule", "ReportOrderNotInvoiceJR|invoiceRule");
69 String strDetail = vars.getStringParameter("inpDetail", "0");
70 printPageHtml(response, vars, strdateFrom, strdateTo, strcBpartnetId, strCOrgId, strInvoiceRule, strDetail);
71 } else pageError(response);
72 }
73
74 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strdateFrom, String strdateTo, String strcBpartnetId, String strCOrgId, String strInvoiceRule, String strDetail) throws IOException, ServletException {
75 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
76 String discard[]={"discard"};
77 XmlDocument xmlDocument=null;
78 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR").createXmlDocument();
79
80 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportOrderNotInvoiceJR", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
81 toolbar.prepareSimpleToolBarTemplate();
82 xmlDocument.setParameter("toolbar", toolbar.toString());
83
84 try {
85 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportOrderNotInvoiceJR");
86 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
87 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
88 xmlDocument.setParameter("childTabContainer", tabs.childTabs());
89 xmlDocument.setParameter("theme", vars.getTheme());
90 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportOrderNotInvoiceJR.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
91 xmlDocument.setParameter("navigationBar", nav.toString());
92 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportOrderNotInvoiceJR.html", strReplaceWith);
93 xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
94 } catch (Exception ex) {
95 throw new ServletException(ex);
96 }
97 {
98 OBError myMessage = vars.getMessage("ReportOrderNotInvoiceJR");
99 vars.removeMessage("ReportOrderNotInvoiceJR");
100 if (myMessage!=null) {
101 xmlDocument.setParameter("messageType", myMessage.getType());
102 xmlDocument.setParameter("messageTitle", myMessage.getTitle());
103 xmlDocument.setParameter("messageMessage", myMessage.getMessage());
104 }
105 }
106
107 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
108 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
109 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
110 xmlDocument.setParameter("dateFrom", strdateFrom);
111 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
112 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
113 xmlDocument.setParameter("dateTo", strdateTo);
114 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
115 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
116 xmlDocument.setParameter("detail", strDetail);
117 xmlDocument.setParameter("paramBPartnerId", strcBpartnetId);
118 xmlDocument.setParameter("paramBPartnerDescription", ReportOrderNotInvoiceData.bPartnerDescription(this, strcBpartnetId));
119 xmlDocument.setParameter("invoiceRule", strInvoiceRule);
120 xmlDocument.setParameter("adOrgId", strCOrgId);
121 try {
122 ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "", "C_Order InvoiceRule", "", Utility.getContext(this, vars, "#User_Org", "ReportOrderNotInvoiceFilterJR"), Utility.getContext(this, vars, "#User_Client", "ReportOrderNotInvoiceJR"), 0);
123 Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportOrderNotInvoiceJR", strInvoiceRule);
124 xmlDocument.setData("reportInvoiceRule","liststructure", comboTableData.select(false));
125 comboTableData = null;
126 } catch (Exception ex) {
127 throw new ServletException(ex);
128 }
130 xmlDocument.setData("reportAD_ORGID", "liststructure", OrganizationComboData.selectCombo(this, vars.getRole()));
131 response.setContentType("text/html; charset=UTF-8");
132 PrintWriter out = response.getWriter();
133 out.println(xmlDocument.print());
134 out.close();
135 }
136
137 void printPageHtml(HttpServletResponse response, VariablesSecureApp vars, String strdateFrom, String strdateTo, String strcBpartnetId, String strCOrgId, String strInvoiceRule, String strDetail) throws IOException, ServletException{
138 if (log4j.isDebugEnabled()) log4j.debug("Output: print html");
139
140 ReportOrderNotInvoiceData[] data = null;
141 data = ReportOrderNotInvoiceData.select(this, vars.getLanguage(), Utility.getContext(this, vars, "#User_Client", "ReportOrderNotInvoiceJR"), Utility.getContext(this, vars, "#User_Org", "ReportOrderNotInvoiceJR"), strcBpartnetId, strCOrgId, strInvoiceRule, strdateFrom, DateTimeData.nDaysAfter(this, strdateTo,"1"));
142
143
144 JasperPrint jasperPrint;
145 String strOutput = "html";
146 String strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml";
147
148 HashMap<String , Object > parameters = new HashMap<String , Object >();
149 parameters.put("Title", classInfo.name);
150 parameters.put("Detail",new Boolean (strDetail.equals("-1")));
151 renderJR(vars, response, strReportName, strOutput, parameters, data, null );
152
153 }
154
155 public String getServletInfo() {
156 return "Servlet ReportOrderNotInvoiceFilter. This Servlet was made by Pablo Sarobe";
157 } }
159
160 |
Popular Tags |
Java API By Example, From Geeks To Geeks.