1 19 20 package org.openbravo.erpReports; 21 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 30 import org.openbravo.erpCommon.utility.DateTimeData; 31 32 public class RptC_Bpartner extends HttpSecureAppServlet { 33 34 35 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException { 36 VariablesSecureApp vars = new VariablesSecureApp(request); 37 38 42 43 if (vars.commandIn("DEFAULT")) { 44 String strcBpartnerId = vars.getSessionValue("RptC_Bpartner.inpcBpartnerId_R"); 45 46 if (strcBpartnerId.equals("")) strcBpartnerId = vars.getSessionValue("RptC_Bpartner.inpcBpartnerId"); 47 printPageDataSheet(response, vars, strcBpartnerId); 48 } else if (vars.commandIn("OPEN")){ 49 String strcBpartnerId = vars.getRequiredStringParameter("inpcBpartnerId"); 50 String strmProductTemplate = vars.getRequiredStringParameter("inpProductTemplate"); 51 String strmTypeDocument = vars.getRequiredStringParameter("inpTypeDocument"); 52 printPageAjaxResponse(response, vars, strcBpartnerId, strmProductTemplate); 53 } else if (vars.commandIn("OPENDOCUMENT")){ 54 String strcBpartnerId = vars.getRequiredStringParameter("inpcBpartnerId"); 55 String strmTypeDocument = vars.getRequiredStringParameter("inpTypeDocument"); 56 printPageAjaxDocumentResponse(response, vars, strcBpartnerId, strmTypeDocument); 57 } else pageError(response); 58 } 59 60 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strcBpartnerId) 61 throws IOException, ServletException { 62 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 63 response.setContentType("text/html; charset=UTF-8"); 64 PrintWriter out = response.getWriter(); 65 String discard[] = {"","","","","","","","","","",""}; 66 XmlDocument xmlDocument=null; 67 68 69 RptCBpartnerData[] dataPartner = RptCBpartnerData.select(this, strcBpartnerId); 70 RptCBpartnerData[] dataAccount = RptCBpartnerData.selectAccount(this, strcBpartnerId); 71 RptCBpartnerData[] dataShipper = RptCBpartnerData.selectShipper(this, strcBpartnerId); 72 RptCBpartnerData[] dataTemplate = RptCBpartnerData.selectTemplate(this, vars.getLanguage(), strcBpartnerId); 73 RptCBpartnerData[] dataDiscount = RptCBpartnerData.selectDiscount(this, strcBpartnerId); 74 RptCBpartnerCustomerData[] dataCustomer = RptCBpartnerCustomerData.select(this, strcBpartnerId); 75 RptCBpartnerVendorData[] dataVendor = RptCBpartnerVendorData.select(this, strcBpartnerId); 76 RptCBpartnerlocationData[] dataLocation = RptCBpartnerlocationData.select(this, strcBpartnerId); 77 RptCBpartnercontactData[] dataContact = RptCBpartnercontactData.select(this, strcBpartnerId); 78 RptCBpartnerSalesData[] dataSales = RptCBpartnerSalesData.selectOrder(this, strcBpartnerId); 79 RptCBpartnerSalesData[] dataInvoice = RptCBpartnerSalesData.select(this, strcBpartnerId); 80 RptCBpartnerSalesData[] dataInout = RptCBpartnerSalesData.selectinout(this, strcBpartnerId); 81 RptCBpartnerSalesData[] dataABC = RptCBpartnerSalesData.selectABC(this, DateTimeData.sysdateYear(this), DateTimeData.lastYear(this), strcBpartnerId); 82 83 84 if (dataAccount == null || dataAccount.length == 0) { 85 dataAccount = RptCBpartnerData.set(); 86 discard[0] = "selDelete1"; 87 } 88 if (dataShipper == null || dataShipper.length == 0) { 89 dataShipper = RptCBpartnerData.set(); 90 discard[1] = "selDelete2"; 91 } 92 if (dataTemplate == null || dataTemplate.length == 0) { 93 dataTemplate = RptCBpartnerData.set(); 94 discard[2] = "selDelete4"; 95 } 96 if (dataDiscount == null || dataDiscount.length == 0) { 97 dataDiscount = RptCBpartnerData.set(); 98 discard[3] = "selDelete3"; 99 } 100 if (dataCustomer == null || dataCustomer.length == 0) { 101 dataCustomer = RptCBpartnerCustomerData.set(); 102 discard[4] = "selDelete5"; 103 } 104 if (dataVendor == null || dataVendor.length == 0) { 105 dataVendor = RptCBpartnerVendorData.set(); 106 discard[5] = "selDelete6"; 107 } 108 if (dataLocation == null || dataLocation.length == 0) { 109 dataLocation = RptCBpartnerlocationData.set(); 110 discard[6] = "selDelete7"; 111 } 112 if (dataContact == null || dataContact.length == 0) { 113 dataContact = RptCBpartnercontactData.set(); 114 discard[7] = "selDelete8"; 115 } if (dataSales == null || dataSales.length == 0) { 116 dataSales = RptCBpartnerSalesData.set(); 117 discard[8] = "selDelete9"; 118 } if (dataSales == null || dataSales.length == 0) { 119 dataInvoice = RptCBpartnerSalesData.set(); 120 discard[9] = "selDelete10"; 121 } if (dataSales == null || dataSales.length == 0) { 122 dataInout = RptCBpartnerSalesData.set(); 123 discard[10] = "selDelete11"; 124 } 125 126 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_Bpartner",discard).createXmlDocument(); 127 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 128 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 129 xmlDocument.setParameter("paramBpartner", dataPartner[0].cBpartnerId); 130 xmlDocument.setParameter("paramSysdate", DateTimeData.today(this)); 131 132 xmlDocument.setData("structureAccount", dataAccount); 133 xmlDocument.setData("structureShipper", dataShipper); 134 xmlDocument.setData("structureTemplate", dataTemplate); 135 xmlDocument.setData("structureDiscount", dataDiscount); 136 xmlDocument.setData("structureCustomer", dataCustomer); 137 xmlDocument.setData("structureVendor", dataVendor); 138 xmlDocument.setData("structureLocation", dataLocation); 139 xmlDocument.setData("structureContact", dataContact); 140 xmlDocument.setData("structureSalesorder", dataSales); 141 xmlDocument.setData("structureSalesinvoice", dataInvoice); 142 xmlDocument.setData("structureSalesinout", dataInout); 143 xmlDocument.setData("structureABC", dataABC); 144 xmlDocument.setData("structure1", dataPartner); 145 146 out.println(xmlDocument.print()); 147 out.close(); 148 } 149 150 void printPageAjaxResponse(HttpServletResponse response, VariablesSecureApp vars, String strcBpartnerId, String strmProductTemplate) 151 throws IOException, ServletException { 152 if (log4j.isDebugEnabled()) log4j.debug("Output: ajaxreponse"); 153 XmlDocument xmlDocument=null; 154 155 156 157 RptCBpartnerData[] data = RptCBpartnerData.selectTemplateDetail(this, strcBpartnerId, strmProductTemplate); 158 159 if (data == null || data.length == 0) data = RptCBpartnerData.set(); 160 161 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerTemplateLines").createXmlDocument(); 162 163 164 response.setContentType("text/plain; charset=UTF-8"); 165 response.setHeader("Cache-Control", "no-cache"); 166 PrintWriter out = response.getWriter(); 167 168 xmlDocument.setData("structure", data); 169 out.println(xmlDocument.print()); 170 out.close(); 171 } 172 173 void printPageAjaxDocumentResponse(HttpServletResponse response, VariablesSecureApp vars, String strcBpartnerId, String strmTypeDocument) 174 throws IOException, ServletException { 175 if (log4j.isDebugEnabled()) log4j.debug("Output: ajaxreponse"); 176 XmlDocument xmlDocument=null; 177 178 RptCBpartnerSalesData[] data=null; 179 RptCBpartnerSalesData[] dataPeriod = RptCBpartnerSalesData.selectperiod(this); 180 181 182 if (strmTypeDocument.equals("INVOICE")) { 183 data = RptCBpartnerSalesData.selectInvoiceperiod(this, strcBpartnerId); 184 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerPeriodInvoice").createXmlDocument(); 185 xmlDocument.setData("structurePeriod", dataPeriod); 186 if (data == null || data.length == 0) data = RptCBpartnerSalesData.set(); 187 } 188 if (strmTypeDocument.equals("ORDER")) { 189 data = RptCBpartnerSalesData.selectOrderperiod(this, strcBpartnerId); 190 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerPeriodSales").createXmlDocument(); 191 xmlDocument.setData("structurePeriod", dataPeriod); 192 if (data == null || data.length == 0) data = RptCBpartnerSalesData.set(); 193 } 194 if (strmTypeDocument.equals("INOUT")) { 195 data = RptCBpartnerSalesData.selectInoutperiod(this, strcBpartnerId); 196 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerPeriodInout").createXmlDocument(); 197 xmlDocument.setData("structurePeriod", dataPeriod); 198 if (data == null || data.length == 0) data = RptCBpartnerSalesData.set(); 199 } 200 if (strmTypeDocument.equals("ABC")) { 201 data = RptCBpartnerSalesData.selectABCactualdetail(this, DateTimeData.sysdateYear(this), strcBpartnerId); 202 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerABC").createXmlDocument(); 203 } 204 if (strmTypeDocument.equals("ABCREF")) { 205 data = RptCBpartnerSalesData.selectABCrefdetail(this, DateTimeData.lastYear(this), strcBpartnerId); 206 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpReports/RptC_BpartnerABCref").createXmlDocument(); 207 } 208 209 response.setContentType("text/plain; charset=UTF-8"); 210 response.setHeader("Cache-Control", "no-cache"); 211 PrintWriter out = response.getWriter(); 212 xmlDocument.setData("structure", data); 213 out.println(xmlDocument.print()); 214 out.close(); 215 } 216 217 public String getServletInfo() { 218 return "Servlet RptC_Bpartner. This Servlet was made by Pablo Sarobe"; 219 } } 221 222 | Popular Tags |