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.ad_combos.AccountNumberComboData; 31 32 import org.openbravo.erpCommon.utility.DateTimeData; 33 34 public class ReportBank extends HttpSecureAppServlet { 35 36 37 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException { 38 VariablesSecureApp vars = new VariablesSecureApp(request); 39 40 if (!Utility.hasProcessAccess(this, vars, "", "RV_ReportBank")) { 41 bdError(response, "AccessTableNoView", vars.getLanguage()); 42 return; 43 } 44 45 if (vars.commandIn("DEFAULT")) { 46 String strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportBank|DateFrom", ""); 47 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportBank|DateTo", ""); 48 String strcbankaccount = vars.getGlobalVariable("inpmProductId", "ReportBank|C_Bankaccount_ID", ""); 49 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcbankaccount); 50 } else if (vars.commandIn("FIND")) { 51 String strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportBank|DateFrom"); 52 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportBank|DateTo"); 53 String strcbankaccount = vars.getRequestGlobalVariable("inpcBankAccountId", "ReportBank|C_Bankaccount_ID"); 54 printPageDataHtml(response, vars, strDateFrom, strDateTo, strcbankaccount); 55 } else pageError(response); 56 } 57 58 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcbankaccount) 59 throws IOException, ServletException { 60 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 61 response.setContentType("text/html; charset=UTF-8"); 62 PrintWriter out = response.getWriter(); 63 String strMessage=""; 64 65 XmlDocument xmlDocument=null; 66 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportBank").createXmlDocument(); 67 68 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportBank", false, "", "", "",false, "ad_reports", strReplaceWith, false, true); 69 toolbar.prepareSimpleToolBarTemplate(); 70 xmlDocument.setParameter("toolbar", toolbar.toString()); 71 72 try { 73 KeyMap key = new KeyMap(this, vars, "ReportBank.html"); 74 xmlDocument.setParameter("keyMap", key.getReportKeyMaps()); 75 } catch (Exception ex) { 76 throw new ServletException(ex); 77 } 78 try { 79 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportBank"); 80 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); 81 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); 82 xmlDocument.setParameter("childTabContainer", tabs.childTabs()); 83 xmlDocument.setParameter("theme", vars.getTheme()); 84 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportBank.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb()); 85 xmlDocument.setParameter("navigationBar", nav.toString()); 86 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportBank.html", strReplaceWith); 87 xmlDocument.setParameter("leftTabs", lBar.manualTemplate()); 88 } catch (Exception ex) { 89 throw new ServletException(ex); 90 } 91 { 92 OBError myMessage = vars.getMessage("ReportBank"); 93 vars.removeMessage("ReportBank"); 94 if (myMessage!=null) { 95 xmlDocument.setParameter("messageType", myMessage.getType()); 96 xmlDocument.setParameter("messageTitle", myMessage.getTitle()); 97 xmlDocument.setParameter("messageMessage", myMessage.getMessage()); 98 } 99 } 100 101 102 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2)); 103 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 104 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 105 xmlDocument.setParameter("cBankAccount", strcbankaccount); 106 xmlDocument.setParameter("dateFrom", strDateFrom); 107 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 108 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 109 xmlDocument.setParameter("dateTo", strDateTo); 110 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 111 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 112 xmlDocument.setParameter("paramMessage", (strMessage.equals("")?"":"alert('" + strMessage + "');")); 113 xmlDocument.setData("reportC_ACCOUNTNUMBER","liststructure",AccountNumberComboData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportBank"), Utility.getContext(this, vars, "#User_Org", "ReportBank"))); 114 115 out.println(xmlDocument.print()); 116 out.close(); 117 } 118 119 void printPageDataHtml(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcbankaccount) 120 throws IOException, ServletException { 121 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 122 response.setContentType("text/html; charset=UTF-8"); 123 PrintWriter out = response.getWriter(); 124 String strMessage=""; 125 String discard[]={"sectionAmount"}; 126 XmlDocument xmlDocument=null; 127 ReportBankData[] data=null; 128 if (strDateFrom.equals("") && strDateTo.equals("")) { 129 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportBank", discard).createXmlDocument(); 130 data = ReportBankData.set(); 131 if (vars.commandIn("FIND")) { 132 strMessage=Utility.messageBD(this, "BothDatesCannotBeBlank", vars.getLanguage()); 133 log4j.warn("Both dates are blank"); 134 } 135 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportBank", false, "", "", "",false, "ad_reports", strReplaceWith, false, true); 136 toolbar.prepareSimpleToolBarTemplate(); 137 xmlDocument.setParameter("toolbar", toolbar.toString()); 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("cBankAccount", strcbankaccount); 143 xmlDocument.setParameter("dateFrom", strDateFrom); 144 xmlDocument.setParameter("dateTo", strDateTo); 145 xmlDocument.setParameter("paramMessage", (strMessage.equals("")?"":"alert('" + strMessage + "');")); 146 xmlDocument.setData("reportC_ACCOUNTNUMBER","liststructure",AccountNumberComboData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportBank"), Utility.getContext(this, vars, "#User_Org", "ReportBank"))); 147 } else { 148 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportBankEdit").createXmlDocument(); 149 data = ReportBankData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportBank"), Utility.getContext(this, vars, "#User_Org", "ReportBank"),strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcbankaccount); 150 xmlDocument.setParameter("sumAmount", ReportBankData.BeginningBalance(this, Utility.getContext(this, vars, "#User_Client", "ReportBank"), Utility.getContext(this, vars, "#User_Org", "ReportBank"),strDateFrom, strcbankaccount)); 151 } 152 153 154 xmlDocument.setData("structure1", data); 155 out.println(xmlDocument.print()); 156 out.close(); 157 } 158 159 public String getServletInfo() { 160 return "Servlet ReportBank. This Servlet was made by Pablo Sarobe"; 161 } } 163 164 | Popular Tags |