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 org.openbravo.erpCommon.utility.DateTimeData; 31 32 public class ReportExpense extends HttpSecureAppServlet { 33 34 35 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException { 36 VariablesSecureApp vars = new VariablesSecureApp(request); 37 38 if (vars.commandIn("DEFAULT")) { 39 String strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportExpense|dateFrom", ""); 40 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportExpense|dateTo", ""); 41 String strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId", ""); 42 String strPartner = vars.getGlobalVariable("inpPartner", "ReportExpense|partner", ""); 43 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner); 44 } else if (vars.commandIn("DIRECT")) { 45 String strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportExpense|dateFrom", ""); 46 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportExpense|dateTo", ""); 47 String strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId", ""); 48 String strPartner = vars.getGlobalVariable("inpPartner", "ReportExpense|partner", ""); 49 setHistoryCommand(request, "DIRECT"); 50 printPageDataHtml(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner); 51 } else if (vars.commandIn("FIND")) { 52 String strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportExpense|dateFrom"); 53 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportExpense|dateTo"); 54 String strcBpartnerId = vars.getRequestGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId"); 55 String strPartner = vars.getRequestGlobalVariable("inpPartner", "ReportExpense|partner"); 56 setHistoryCommand(request, "DIRECT"); 57 printPageDataHtml(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner); 58 } else pageError(response); 59 } 60 61 void printPageDataHtml(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcBpartnerId, String strPartner) 62 throws IOException, ServletException { 63 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 64 response.setContentType("text/html; charset=UTF-8"); 65 PrintWriter out = response.getWriter(); 66 XmlDocument xmlDocument=null; 67 ReportExpenseData[] data1 = null; 68 69 if (vars.commandIn("DEFAULT") && strDateFrom.equals("") && strDateTo.equals("") && strcBpartnerId.equals("") && strPartner.equals("")){ 70 74 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner); 75 } else { 76 data1 = ReportExpenseData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportExpense"), Utility.getContext(this, vars, "#User_Org", "ReportExpense"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strPartner); 77 } 78 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportExpenseEdit").createXmlDocument(); 79 80 81 82 83 84 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 85 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 86 87 88 xmlDocument.setData("structure1", data1); 89 90 out.println(xmlDocument.print()); 91 out.close(); 92 } 93 94 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcBpartnerId, String strPartner) 95 throws IOException, ServletException { 96 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 97 response.setContentType("text/html; charset=UTF-8"); 98 PrintWriter out = response.getWriter(); 99 XmlDocument xmlDocument=null; 100 ReportExpenseData[] data1 = null; 101 102 103 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportExpense").createXmlDocument(); 104 105 106 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportExpense", false, "", "", "",false, "ad_reports", strReplaceWith, false, true); 107 toolbar.prepareSimpleToolBarTemplate(); 108 xmlDocument.setParameter("toolbar", toolbar.toString()); 109 try { 110 KeyMap key = new KeyMap(this, vars, "ReportExpense.html"); 111 xmlDocument.setParameter("keyMap", key.getReportKeyMaps()); 112 } catch (Exception ex) { 113 throw new ServletException(ex); 114 } 115 try { 116 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportExpense"); 117 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); 118 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); 119 xmlDocument.setParameter("childTabContainer", tabs.childTabs()); 120 xmlDocument.setParameter("theme", vars.getTheme()); 121 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportExpense.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb()); 122 xmlDocument.setParameter("navigationBar", nav.toString()); 123 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportExpense.html", strReplaceWith); 124 xmlDocument.setParameter("leftTabs", lBar.manualTemplate()); 125 } catch (Exception ex) { 126 throw new ServletException(ex); 127 } 128 { 129 OBError myMessage = vars.getMessage("ReportExpense"); 130 vars.removeMessage("ReportExpense"); 131 if (myMessage!=null) { 132 xmlDocument.setParameter("messageType", myMessage.getType()); 133 xmlDocument.setParameter("messageTitle", myMessage.getTitle()); 134 xmlDocument.setParameter("messageMessage", myMessage.getMessage()); 135 } 136 } 137 138 139 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2)); 140 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 141 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 142 xmlDocument.setParameter("dateFrom", strDateFrom); 143 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 144 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 145 xmlDocument.setParameter("dateTo", strDateTo); 146 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 147 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 148 xmlDocument.setParameter("paramBPartnerId", strcBpartnerId); 149 xmlDocument.setParameter("bPartnerDescription", ReportExpenseData.selectBpartner(this, strcBpartnerId)); 150 xmlDocument.setParameter("partner", strPartner); 151 152 try { 153 ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "C_BPartner_ID", "C_BPartner Employee w Address", "", Utility.getContext(this, vars, "#User_Org", "ReportExpense"), Utility.getContext(this, vars, "#User_Client", "ReportExpense"), 0); 154 Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportExpense", ""); 155 xmlDocument.setData("reportC_BPartner_ID","liststructure", comboTableData.select(false)); 156 comboTableData = null; 157 } catch (Exception ex) { 158 throw new ServletException(ex); 159 } 160 161 162 163 out.println(xmlDocument.print()); 164 out.close(); 165 } 166 167 242 243 public String getServletInfo() { 244 return "Servlet ReportExpense. This Servlet was made by Jon Alegria"; 245 } } 247 | Popular Tags |