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 ReportProductMovement 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", "ReportProductMovement|dateFrom", ""); 40 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportProductMovement|dateTo", ""); 41 String strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportProductMovement|cBpartnerId", ""); 42 String strmProductId = vars.getGlobalVariable("inpmProductId", "ReportProductMovement|mProductId", ""); 43 String strInout = vars.getGlobalVariable("inpInout", "ReportProductMovement|inout", "-1"); 44 String strInventory = vars.getGlobalVariable("inpInventory", "ReportProductMovement|inventory", "-1"); 45 String strMovement = vars.getGlobalVariable("inpMovement", "ReportProductMovement|movement", "-1"); 46 String strProduction = vars.getGlobalVariable("inpProduction", "ReportProductMovement|production", "-1"); 47 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strmProductId, strInout, strInventory, strMovement, strProduction); 48 } else if (vars.commandIn("DIRECT")) { 49 String strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportProductMovement|dateFrom", ""); 50 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportProductMovement|dateTo", ""); 51 String strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportProductMovement|cBpartnerId", ""); 52 String strmProductId = vars.getGlobalVariable("inpmProductId", "ReportProductMovement|mProductId", ""); 53 String strInout = vars.getGlobalVariable("inpInout", "ReportProductMovement|inout", ""); 54 String strInventory = vars.getGlobalVariable("inpInventory", "ReportProductMovement|inventory", ""); 55 String strMovement = vars.getGlobalVariable("inpMovement", "ReportProductMovement|movement", ""); 56 String strProduction = vars.getGlobalVariable("inpProduction", "ReportProductMovement|production", ""); 57 setHistoryCommand(request, "DIRECT"); 58 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strmProductId, strInout, strInventory, strMovement, strProduction); 59 } else if (vars.commandIn("FIND")) { 60 String strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportProductMovement|dateFrom"); 61 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportProductMovement|dateTo"); 62 String strcBpartnerId = vars.getRequestGlobalVariable("inpcBPartnerId", "ReportProductMovement|cBpartnerId"); 63 String strmProductId = vars.getRequestGlobalVariable("inpmProductId", "ReportProductMovement|mProductId"); 64 String strInout = vars.getRequestGlobalVariable("inpInout", "ReportProductMovement|inout"); 65 String strInventory = vars.getRequestGlobalVariable("inpInventory", "ReportProductMovement|inventory"); 66 String strMovement = vars.getRequestGlobalVariable("inpMovement", "ReportProductMovement|movement"); 67 String strProduction = vars.getRequestGlobalVariable("inpProduction", "ReportProductMovement|production"); 68 setHistoryCommand(request, "DIRECT"); 69 printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strmProductId, strInout, strInventory, strMovement, strProduction); 70 } else pageError(response); 71 } 72 73 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcBpartnerId, String strmProductId, String strInout, String strInventory, String strMovement, String strProduction) 74 throws IOException, ServletException { 75 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 76 response.setContentType("text/html; charset=UTF-8"); 77 PrintWriter out = response.getWriter(); 78 XmlDocument xmlDocument=null; 79 ReportProductMovementData[] data = null; 80 ReportProductMovementData[] data1 = null; 81 ReportProductMovementData[] data2 = null; 82 ReportProductMovementData[] data3 = null; 83 String discard[] = {"discard", "discard", "discard", "discard"}; 84 if (strDateFrom.equals("") && strDateTo.equals("")){ 85 strDateTo = DateTimeData.today(this); 86 strDateFrom = DateTimeData.weekBefore(this); 87 } 88 if (vars.commandIn("FIND", "DIRECT")){ 89 if (strInout.equals("-1")){ 90 data = ReportProductMovementData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportProductMovement"), Utility.getContext(this, vars, "#User_Org", "ReportProductMovement"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strmProductId); 91 if (data == null || data.length == 0){ 92 discard[0] = "selEliminar1"; 93 data = ReportProductMovementData.set(); 94 } 95 } 96 else { 97 discard[0] = "selEliminar1"; 98 data = ReportProductMovementData.set(); 99 } 100 if (strInventory.equals("-1")){ 101 data1 = ReportProductMovementData.selectInventory(this, Utility.getContext(this, vars, "#User_Client", "ReportProductMovement"), Utility.getContext(this, vars, "#User_Org", "ReportProductMovement"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strmProductId); 102 if (data1 == null || data1.length == 0){ 103 discard[1] = "selEliminar2"; 104 data1 = ReportProductMovementData.set(); 105 } 106 } 107 else { 108 discard[1] = "selEliminar2"; 109 data1 = ReportProductMovementData.set(); 110 } 111 if (strMovement.equals("-1")){ 112 data2 = ReportProductMovementData.selectMovement(this, Utility.getContext(this, vars, "#User_Client", "ReportProductMovement"), Utility.getContext(this, vars, "#User_Org", "ReportProductMovement"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strmProductId); 113 if (data2 == null || data2.length == 0){ 114 discard[2] = "selEliminar3"; 115 data2 = ReportProductMovementData.set(); 116 } 117 } 118 else { 119 discard[2] = "selEliminar3"; 120 data2 = ReportProductMovementData.set(); 121 } 122 if (strProduction.equals("-1")){ 123 data3 = ReportProductMovementData.selectProduction(this, Utility.getContext(this, vars, "#User_Client", "ReportProductMovement"), Utility.getContext(this, vars, "#User_Org", "ReportProductMovement"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strmProductId); 124 if (data3 == null || data3.length == 0){ 125 discard[3] = "selEliminar4"; 126 data3 = ReportProductMovementData.set(); 127 } 128 } 129 else { 130 discard[3] = "selEliminar4"; 131 data3 = ReportProductMovementData.set(); 132 } 133 } 134 else { 135 discard[0] = "selEliminar1"; 136 discard[1] = "selEliminar2"; 137 discard[2] = "selEliminar3"; 138 discard[3] = "selEliminar4"; 139 data = ReportProductMovementData.set(); 140 data1 = ReportProductMovementData.set(); 141 data2 = ReportProductMovementData.set(); 142 data3 = ReportProductMovementData.set(); 143 } 144 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportProductMovement", discard).createXmlDocument(); 145 146 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportProductMovement", false, "", "", "",false, "ad_reports", strReplaceWith, false, true); 147 toolbar.prepareSimpleToolBarTemplate(); 148 xmlDocument.setParameter("toolbar", toolbar.toString()); 149 150 try { 151 KeyMap key = new KeyMap(this, vars, "ReportProductMovement.html"); 152 xmlDocument.setParameter("keyMap", key.getReportKeyMaps()); 153 } catch (Exception ex) { 154 throw new ServletException(ex); 155 } 156 try { 157 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportProductMovement"); 158 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); 159 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); 160 xmlDocument.setParameter("childTabContainer", tabs.childTabs()); 161 xmlDocument.setParameter("theme", vars.getTheme()); 162 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportProductMovement.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb()); 163 xmlDocument.setParameter("navigationBar", nav.toString()); 164 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportProductMovement.html", strReplaceWith); 165 xmlDocument.setParameter("leftTabs", lBar.manualTemplate()); 166 } catch (Exception ex) { 167 throw new ServletException(ex); 168 } 169 { 170 OBError myMessage = vars.getMessage("ReportProductMovement"); 171 vars.removeMessage("ReportProductMovement"); 172 if (myMessage!=null) { 173 xmlDocument.setParameter("messageType", myMessage.getType()); 174 xmlDocument.setParameter("messageTitle", myMessage.getTitle()); 175 xmlDocument.setParameter("messageMessage", myMessage.getMessage()); 176 } 177 } 178 179 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2)); 180 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 181 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 182 xmlDocument.setParameter("dateFrom", strDateFrom); 183 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 184 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 185 xmlDocument.setParameter("dateTo", strDateTo); 186 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat")); 187 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat")); 188 xmlDocument.setParameter("paramBPartnerId", strcBpartnerId); 189 xmlDocument.setParameter("mProduct", strmProductId); 190 xmlDocument.setParameter("bPartnerDescription", ReportProductMovementData.selectBpartner(this, strcBpartnerId)); 191 xmlDocument.setParameter("productDescription", ReportWarehousePartnerData.selectMproduct(this, strmProductId)); 192 xmlDocument.setParameter("inout", strInout); 193 xmlDocument.setParameter("inventory", strInventory); 194 xmlDocument.setParameter("movement", strMovement); 195 xmlDocument.setParameter("production", strProduction); 196 xmlDocument.setData("structure1", data); 197 xmlDocument.setData("structure2", data1); 198 xmlDocument.setData("structure3", data2); 199 xmlDocument.setData("structure4", data3); 200 201 out.println(xmlDocument.print()); 202 out.close(); 203 } 204 205 public String getServletInfo() { 206 return "Servlet ReportProductMovement. This Servlet was made by Jon Alegria"; 207 } } 209 | Popular Tags |