1 19 package org.openbravo.erpCommon.ad_forms; 20 21 import org.openbravo.erpCommon.utility.Utility; 22 import org.openbravo.base.secureApp.HttpSecureAppServlet; 23 import org.openbravo.base.secureApp.VariablesSecureApp; 24 import org.openbravo.xmlEngine.XmlDocument; 25 import java.io.*; 26 import javax.servlet.*; 27 import javax.servlet.http.*; 28 29 import org.openbravo.erpCommon.utility.DateTimeData; 30 31 32 public class InformeInOut extends HttpSecureAppServlet { 33 34 35 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException { 36 VariablesSecureApp vars = new VariablesSecureApp(request); 37 38 if (!Utility.hasFormAccess(this, vars, "", "org.openbravo.erpCommon.ad_forms.InformeInOut")) { 39 bdError(response, "AccessTableNoView", vars.getLanguage()); 40 return; 41 } 42 43 if (vars.commandIn("DEFAULT")) { 44 String strDesde = vars.getStringParameter("inpDesde",DateTimeData.today(this)); 45 String strHasta = vars.getStringParameter("inpHasta",DateTimeData.today(this)); 46 printPageSelector(response, vars, strDesde, strHasta); 47 } else if (vars.commandIn("FIND")) { 48 String strDesde = vars.getStringParameter("inpDesde"); 49 String strHasta = vars.getStringParameter("inpHasta"); 50 setHistoryCommand(request, "DEFAULT"); 51 String strCategoriaProducto = vars.getStringParameter("inpClaveCategoriaProducto",""); 52 printPage(response, vars, strDesde, strHasta, strCategoriaProducto); 53 } else pageError(response); 54 } 55 56 private void printPageSelector(HttpServletResponse response, VariablesSecureApp vars, String strDesde, String strHasta) throws IOException, ServletException{ 57 XmlDocument xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_forms/InformeInOut").createXmlDocument(); 58 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2)); 59 xmlDocument.setParameter("fechaDesde",strDesde); 60 xmlDocument.setParameter("fechaHasta",strHasta); 61 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 62 xmlDocument.setParameter("language", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 63 xmlDocument.setData("reportCategoriaProducto", "structure1", CategoriaProductoComboData.select(this)); 64 response.setContentType("text/html; charset=UTF-8"); 65 PrintWriter out = response.getWriter(); 66 out.println(xmlDocument.print()); 67 out.close(); 68 } 69 70 void printPage(HttpServletResponse response, VariablesSecureApp vars, String strDesde, String strHasta, String strCategoriaProducto) throws IOException, ServletException { 71 response.setContentType("application/xls"); 72 XmlDocument xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_forms/InformeInOut_Excel").createXmlDocument(); 73 xmlDocument.setData("structure1", InformeInOutData.select(this, vars.getSqlDateFormat(), strHasta, strDesde, strCategoriaProducto)); 74 75 76 response.setContentType("application/xls"); 77 PrintWriter out = response.getWriter(); 78 out.println(xmlDocument.print()); 79 out.close(); 80 } 81 82 83 public String getServletInfo() { 84 return "Servlet for the media reports generation"; 85 } } 87 | Popular Tags |