/** * This servlet init method sets up business logic EJBs. Servlet init method is only executed once * * @param config - default parameter * @exception ServletException */ public void init(ServletConfig config) throws ServletException { super.init(config); USFEnv.getLog().writeDebug("initializing buslogic EJB home interfaces", this, null); try { workorderdetHome = (WorkOrderDetailHome) USFEnv.ic.lookup(WORKORDERDETS_INFORMATION_EJBEAN); } catch (NamingException e) { USFEnv.getLog().writeDebug("Failed to ic.lookup Naming Exception", this, null); } }
public void init(ServletConfig config) throws ServletException { super.init(config); try { RhccInvviewHome invviewhome = (RhccInvviewHome) USFEnv.ic.lookup(RHCCINVVIEW_EJBEAN); invviewEJBean = invviewhome.create(); RhccInvgenHome invgenhome = (RhccInvgenHome) USFEnv.ic.lookup(RHCCINVGEN_EJBEAN); invgenEJBean = invgenhome.create(); } catch (NamingException e) { USFEnv.getLog().writeDebug("RhccInvviewServlet: Inside Naming Exception", this, null); } catch (CreateException e) { USFEnv.getLog().writeDebug("RhccInvviewServlet: Inside Create Exception", this, null); } catch (RemoteException e) { USFEnv.getLog().writeDebug("RhccInvviewServlet: Inside Remote Exception", this, null); } }
/** * This calls the itemselection.jsp and list all items available for a WorkOrder and a WorkOrder's * item list * * @param workorderid - the WO_ID of the parent WorkOrder * @param request - servlet request * @param response - servlet response */ private void listProducts( long workorderId, WorkOrderDetailRemote workorderdetEJBean, HttpSession session, HttpServletRequest req, HttpServletResponse resp) { try { // If any product object is left over in session remove it session.removeValue("itemObj"); // Create db connection for EJB workorderdetEJBean.connect(); // Get the 2D Array which has the List of Items for the WorkOrder // grouped by the Billing System. Object[][] productList = workorderdetEJBean.getWorkOrderItems(workorderId); // Get the WorkOrder Object WorkOrder workorderObj = workorderdetEJBean.getWorkOrderInfo(workorderId); // Get the List of all Product Names for the WorkOrder String[] productNameList = workorderdetEJBean.getProdList(workorderId); for (int w = 0; w < productNameList.length; w++) USFEnv.getLog() .writeDebug("VALUES INSIDE productNameList is" + productNameList[w], this, null); // Set the attributes to the itemselection JSP req.setAttribute("productNameList", productNameList); req.setAttribute("productList", productList); req.setAttribute("workorderObj", workorderObj); // Release db connection for EJB workorderdetEJBean.release(); // Include the JSP includeJSP(req, resp, ITEM_JSP_PATH, "itemselection"); return; } catch (Exception e) { String errorMsg = "Fail to list products for a WORKORDER " + workorderId; USFEnv.getLog().writeCrit(errorMsg, this, e); errorJSP(req, resp, errorMsg); } }
/** * This is the main controller logic for item selection servlet. This determines whether to show a * list of items for a WorkOrder, add a item, edit a item's detail information, or delete a item. * The product_action parameter is past to this servlet to determine what action to perform. The * product_action parameter is a button defined by JSPs related to product presentation screens. * * <p>The default action is to show all product related to a parent WorkOrder. * * @param req HttpServlet request * @param resp HttpServlet response */ public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { WorkOrderDetailRemote workorderdetEJBean = null; securityChecks(req, resp); // Get the current session HttpSession session = req.getSession(false); if (session == null) return; String sTmp = ""; // Get a new business logic EJB (custInfoEJBean) USFEnv.getLog().writeDebug("getting buslogic EJB", this, null); try { workorderdetEJBean = workorderdetHome.create(); USFEnv.getLog().writeDebug("EJBean Created", this, null); } catch (CreateException e) { String errorMsg = "Critical Exception in ItemsServlet"; USFEnv.getLog().writeCrit(errorMsg + " failed EJB creation", this, e); errorJSP(req, resp, errorMsg); return; } catch (RemoteException e) { String errorMsg = "Critical Exception in ItemsServlet"; USFEnv.getLog().writeCrit(errorMsg + " failed EJB connect", this, e); errorJSP(req, resp, errorMsg); return; } catch (Exception e) { String errorMsg = "Critical Exception no EJB created"; USFEnv.getLog().writeCrit(errorMsg + " failed EJB creation", this, e); errorJSP(req, resp, errorMsg); return; } try { // Button user pressed in the itemselection.jsp String sJSPAction = req.getParameter("product_action"); USFEnv.getLog().writeWarn("product_action from JSP: " + sJSPAction, this, null); short year = Short.valueOf((String) session.getValue("Iyear")).shortValue(); long customerId = Long.valueOf((String) session.getValue("rcustId")).longValue(); long applicationId = Long.valueOf((String) session.getValue("rappid")).longValue(); long workorderId = 0; long bkId = 0; long billkeyId = 0; long bsId = 0; long wodId = 0; String editflag = ""; String bsNm = ""; java.sql.Date strtDate = null; java.sql.Date endDate = null; String prodError = ""; // Check to make sure session does have an WorkOrder ID if (session.getValue("WorkOrderId") != null) { // If Yes get the parent WorkOrder ID from session workorderId = Long.valueOf((String) session.getValue("WorkOrderId")).longValue(); } // Button Action from JSP is empty then show the Default page of the // Product Listing. if (USFUtil.isBlank(sJSPAction)) { USFEnv.getLog().writeDebug("Display product list for FRN.", this, null); // list items for parent Work Order Number Vector billingsystems = null; WrkOrdrDets workorderdets = new WrkOrdrDets(); billingsystems = workorderdets.getBillingSystems(); req.setAttribute("BillingSystems", billingsystems); for (int s = 0; s < billingsystems.size(); s++) USFEnv.getLog() .writeDebug("INSIDE BILLING SYSTEMS " + billingsystems.elementAt(s), this, null); listProducts(workorderId, workorderdetEJBean, session, req, resp); return; } // Button action from JSP is to Add a new Item else if (sJSPAction.equals("add")) { // Remove the Product Object from session session.removeValue("prodObj"); editflag = "addnew"; req.setAttribute("editflag", editflag); // Read the Item and the Billing System for adding the New // Item. String formProdBsId = (String) req.getParameter("formProdId"); String formProdId = formProdBsId.substring(0, formProdBsId.indexOf("|")); String formProdName = formProdBsId.substring(formProdBsId.indexOf("|") + 1); long rscId = (new Long(formProdId).longValue()); // bsId = (new Long( formBsId ).longValue()) ; String billSystem = formProdName.substring(0, formProdName.indexOf("-")); String itemName = formProdName.substring(formProdName.indexOf("-") + 1); BlgSys blgSys = new BlgSys(); bsId = blgSys.getBsId(billSystem); // Create db connection for EJB workorderdetEJBean.connect(); // Get the WorkOrder Object. WorkOrder woObj = workorderdetEJBean.getWorkOrderInfo(workorderId); // Get the list of Billing Keys for the Billing System. String[] blgKeys = workorderdetEJBean.getBillingKeys(customerId, bsId); // Release db connection for EJB workorderdetEJBean.release(); // If no Billing Keys for the Billing System selected then redirect // to the List Items screen and show the error Message. if (blgKeys == null) { BlgSys blgsys = new BlgSys(); Hashtable bSysList = (Hashtable) blgsys.searchBlgSys(); // Hashtable bSysList = (Hashtable) USFEnv.getBillSystems(); // Set the JSP error message req.setAttribute("errorMsg", "No BTNs for Billing System " + billSystem); // list products for parent WorkOrder Number listProducts(workorderId, workorderdetEJBean, session, req, resp); return; } req.setAttribute("prodcredit", "N"); req.setAttribute("bsystem", String.valueOf(bsId)); req.setAttribute("bkList", blgKeys); req.setAttribute("prodId", formProdId); String wid = String.valueOf(workorderId); session.putValue("workorderId", wid); req.setAttribute("billingsystem", billSystem); req.setAttribute("itemname", itemName); // Include the JSP to Edit Product includeJSP(req, resp, ITEM_JSP_PATH, "editItem"); return; } // Button action from JSP is to Edit a Product else if (sJSPAction.equals("edit")) { String bsysid = req.getParameter("bsId"); session.putValue("bysysidforedit", bsysid); wodId = (new Long((String) req.getParameter("wodId"))).longValue(); // bkId = (new Long( (String) req.getParameter("bkId"))).longValue() ; session.putValue("workorderdetid", String.valueOf(wodId)); bsId = (new Long((String) req.getParameter("bsId"))).longValue(); BlgSys blgSys = new BlgSys(); bsNm = blgSys.getBsName(bsId); // Create db connection for EJB workorderdetEJBean.connect(); // WorkOrder woObj = workorderdetEJBean.getWorkOrderInfo(workorderId); // Get the WorkOrder Number Object WrkOrdrDets wodets_obj = new WrkOrdrDets(); wodets_obj = workorderdetEJBean.getProductInfo(wodId); // Get the List of Billing Keys for the Billing System. String[] blgKeys = workorderdetEJBean.getBillingKeys(customerId, bsId); // Check if the Item has any Credits. If any credits then Billing // Key is not Editable else Editable. if (workorderdetEJBean.hasCredits(wodId)) { req.setAttribute("prodcredit", "Y"); } else { req.setAttribute("prodcredit", "N"); } // Release db connection for EJB workorderdetEJBean.release(); // If Item Object is not null (which generally is the case) then // set the Attributes for the JSP. if (wodets_obj != null) { // Put the Item Object in session editflag = "edit"; session.putValue("wodets", wodets_obj); req.setAttribute("editflag", editflag); // Set the attributes for the Billing System, Billing Key List, req.setAttribute("bkList", blgKeys); req.setAttribute("bsname", bsNm); // Include the JSP to Edit the Item. includeJSP(req, resp, ITEM_JSP_PATH, "editItem"); return; } // If Item Object is null (which generally should not Occur) show // the Default page of Item List for the WorkOrder Number else { // Set the JSP error message req.setAttribute( "errorMsg", "Product Key - " + wodId + " Information not available in the Data Base"); // list items for parent WorkOrder Number listProducts(workorderId, workorderdetEJBean, session, req, resp); return; } } // Button action from JSP is to Delete an Item else if (sJSPAction.equals("delete")) { String formWodId = req.getParameter("wodId"); wodId = (new Long((String) req.getParameter("wodId"))).longValue(); // Create db connection for EJB workorderdetEJBean.connect(); // Delete the Item if (workorderdetEJBean.deleteProduct(wodId)) { req.setAttribute("errorMsg", "Product Key - " + wodId + " Deleted"); } else { req.setAttribute( "errorMsg", "Deletion Failed. Product Key - " + wodId + " is associated with amounts."); } // Release db connection for EJB workorderdetEJBean.release(); // Show the Item List screen listProducts(workorderId, workorderdetEJBean, session, req, resp); return; } // Button action from JSP is to Save a Product. This includes Insertion // of New Product or Updation of an Existing Product. else if (sJSPAction.equals("save")) { boolean save = false; boolean newProd = false; // long qty=0; // Read the Billing System Id String formBsId = (String) req.getParameter("bs_id"); String bsysid = (String) req.getParameter("bsysid"); /* String trans_type = (String) req.getParameter("trans_type"); //String quantity = (String) req.getParameter("qty"); String quantity=""; if (!(req.getParameter("qty").equals(""))) { quantity=(String) req.getParameter("qty"); qty = (new Long(quantity).longValue()); } */ String prod_stat = (String) req.getParameter("prod_stat"); double nrcg_dscnt = (new Double((String) req.getParameter("NonRecurringDiscount"))).doubleValue(); double rcg_dscnt = (new Double((String) req.getParameter("RecurringDiscount"))).doubleValue(); String start_month = (String) req.getParameter("strt_month"); String start_day = (String) req.getParameter("strt_day"); String start_year = (String) req.getParameter("strt_year"); String end_month = (String) req.getParameter("end_month"); String end_day = (String) req.getParameter("end_day"); String end_year = (String) req.getParameter("end_year"); String start_date = start_month + "-" + start_day + "-" + start_year; String end_date = end_month + "-" + end_day + "-" + end_year; long wrkordrid = (new Long((String) session.getValue("WorkOrderId"))).longValue(); String for_editing = req.getParameter("for_editing"); String for_new = req.getParameter("for_new"); String formBkId = (String) req.getParameter("bk_id"); String formBKId = formBkId.substring(0, formBkId.indexOf("|")); String formBTN = formBkId.substring(formBkId.indexOf("|") + 1); billkeyId = (new Long(formBKId)).longValue(); try { bsId = (new Long((String) req.getParameter("bs_id"))).longValue(); } catch (Exception e) { USFEnv.getLog().writeDebug("Exception is " + e, this, null); } RHCCBlgKeys blgkeys = new RHCCBlgKeys(); if (for_editing.equals("editing")) { blgkeys.setRbkId(billkeyId); blgkeys.setRbkKeys(formBTN); blgkeys.setBsId(new Long(bsysid).longValue()); } if (for_new.equals("new")) { blgkeys.setRbkId(billkeyId); blgkeys.setRbkKeys(formBTN); blgkeys.setBsId(bsId); } int index = 0; WrkOrdrDets wod_obj = new WrkOrdrDets(); // wod_obj.setTxTyp(trans_type); // wod_obj.setQty(qty); wod_obj.setNonRcrgDscnt(nrcg_dscnt); wod_obj.setRcrgDscnt(rcg_dscnt); wod_obj.setRBKID(billkeyId); wod_obj.setWodStat(prod_stat); wod_obj.setWOID(wrkordrid); if (!(start_date.equals(""))) { strtDate = new java.sql.Date((new SimpleDateFormat("MM-dd-yyyy")).parse(start_date).getTime()); wod_obj.setStrtDat(strtDate); } // Else if the Start Date is null update the Item Object Date to // null else { wod_obj.setStrtDat(null); } // If Item Service End Date is not null read the date and update // the Item Object with the date if (!(end_date.equals(""))) { endDate = new java.sql.Date((new SimpleDateFormat("MM-dd-yyyy")).parse(end_date).getTime()); wod_obj.setEndDat(endDate); } // Else if the End Date is null update the Item Object Date to null else { wod_obj.setEndDat(null); } // Check if the Start Date is after the End Date or equals End Date if ((strtDate != null) && (endDate != null) && (strtDate.after(endDate))) { prodError = "Product Service Start Date is after Product Service End Date. \n"; index = 1; } else if ((strtDate != null) && (endDate != null) && (strtDate.equals(endDate))) { prodError = "Product Service Start Date equals Product Service End Date. \n"; } workorderdetEJBean.connect(); if (for_editing.equals("editing")) { long workorderdetID = (new Long((String) session.getValue("workorderdetid"))).longValue(); wod_obj.setWODID(workorderdetID); if (index == 0) { save = workorderdetEJBean.saveProduct(wod_obj); } if (save) { prodError = prodError + "<BR> Product Key - " + wod_obj.getWODID() + " Information updated"; req.setAttribute("error", prodError); } else { prodError = prodError + "<BR> Failed to update Product Information"; req.setAttribute("error", prodError); } } if (for_new.equals("new")) { if (index == 0) { int prodId = Integer.parseInt(req.getParameter("prod_Id")); wod_obj.setProd_id(prodId); save = workorderdetEJBean.saveProduct(wod_obj); } if (save) { prodError = prodError + "<BR> Product Key - " + wod_obj.getWODID() + " Information Saved"; req.setAttribute("error", prodError); } else { prodError = prodError + "<BR> Failed to Save Product Information"; req.setAttribute("error", prodError); } } workorderdetEJBean.release(); listProducts(wrkordrid, workorderdetEJBean, session, req, resp); } } // End of try block catch (Exception e) { if (workorderdetEJBean != null) { // calling bean release method try { workorderdetEJBean.release(); } catch (Exception ex) { USFEnv.getLog().writeCrit(" Exception in calling release() method ", this, e); } } String errorMsg = "Processing Exception in Items Servlet: "; USFEnv.getLog().writeCrit(errorMsg, this, e); errorJSP(req, resp, errorMsg); } // End of catch block } // end of doPost()
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { String jsppath = "rhccinvoice"; String year = ""; String spin = ""; String frn = ""; String invid = ""; String invno = ""; String spinnm = ""; String frame = ""; String user = ""; Vector vector = new Vector(); HttpSession session = request.getSession(false); if (session == null) { jsppath = "login"; USFEnv.getLog().writeCrit("RhccInvviewServlet: Inside Session is null", this, null); USFEnv.getLog() .writeWarn("RhccInvviewServlet: Inside frame session calling JSP Login", this, null); includeJSP(request, response, jsppath, "Login"); } else { jsppath = "rhccinvoice"; frame = request.getParameter("frame"); user = (String) session.getValue("cuid"); USFEnv.getLog() .writeDebug("RhccInvviewServlet: Inside doPost Login CUID is: " + user, this, null); USFEnv.getLog() .writeWarn("RhccInvviewServlet: Inside InvreconServlet Frame is:" + frame, this, null); if (frame.equals("iview_frn")) { boolean discountview_flag = false; if ((request.getParameter("idiscountview") != null) && (request.getParameter("idiscountview").equals("TRUE"))) { year = request.getParameter("iyear"); session.putValue("Iyear", year); discountview_flag = true; } if ((discountview_flag) || (session.getValue("Iyear") != null)) { if ((request.getParameter("ifrn")) != null) { frn = request.getParameter("ifrn"); USFEnv.getLog().writeDebug("RhccInvviewServlet: FRN Value :" + frn, this, null); if (!(discountview_flag)) { year = (String) session.getValue("Iyear"); } Vector frninvnos = new Vector(); Vector invnolist = new Vector(); Vector invpending = new Vector(); boolean frn_flag = false; String frnerrmsg = ""; try { invviewEJBean.connect(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame rhcciview_frn connected to RhccInvviewBean", this, null); if (discountview_flag) { frn_flag = true; } else { frn_flag = invviewEJBean.validateFRN(frn, year); USFEnv.getLog() .writeWarn( "RhccInvviewServlet:Inside frame rhcciview_frn data from validateFRN" + frn_flag, this, null); } if (frn_flag) { frninvnos = invviewEJBean.getFrninvnos(year, frn); USFEnv.getLog().writeWarn("ouside the block", this, null); invviewEJBean.release(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame Rhcciview_frn released RhccInvviewBean", this, null); } else { USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn Inside the else block", this, null); frnerrmsg = invviewEJBean.setErrmsg(); invviewEJBean.release(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn released RhccInvviewBean" + frnerrmsg, this, null); invgenEJBean.connect(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn connected to RhccInvgenBean" + invnolist, this, null); invnolist = invgenEJBean.getRhccInvnos(year); USFEnv.getLog().writeWarn("outside of this " + invnolist, this, null); invgenEJBean.release(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn released RhccInvgenBean", this, null); } USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn Inside the else block--2--", this, null); if (discountview_flag) { USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside -3---" + discountview_flag, this, null); USFEnv.getLog().writeWarn("RhccInvviewServlet: Inside -3---" + frn, this, null); USFEnv.getLog().writeWarn("RhccInvviewServlet: Inside -3---" + year, this, null); session.putValue("Ifrn", frn); invgenEJBean.connect(); USFEnv.getLog() .writeWarn("RhccInvviewServlet: Inside frame----88 " + frn, this, null); invpending = invgenEJBean.getRhccInvpending(null, year, frn); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn connected to InvgenBean", this, null); invgenEJBean.release(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn released InvgenBean", this, null); } } catch (RemoteException e) { USFEnv.getLog().writeCrit("I m here", this, null); USFEnv.getLog() .writeCrit( "RhccInvviewServlet: Inside Remote Exception of getFrninvnos ", this, null); } if (frn_flag) { USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn calling JSP RhccIInvviewfrn" + frn_flag, this, null); request.setAttribute("frn", frn); request.setAttribute("frninv", frninvnos); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn calling JSP RhccIInvviewfrn", this, null); if (discountview_flag) { if ((request.getParameter("invrejn") != null) && (request.getParameter("invrejn").equals("true"))) request.setAttribute("invrejn", "true"); request.setAttribute("frnpend", invpending); includeJSP(request, response, jsppath, "RhccIDiscountview"); } else { USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn calling JSP RhccIInvviewfrn inside else", this, null); includeJSP(request, response, jsppath, "RhccIInvviewfrn"); } } else { request.setAttribute("invnolist", invnolist); request.setAttribute("invviewmsg", frnerrmsg); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_frn calling JSP IMenu", this, null); includeJSP(request, response, jsppath, "RhccIMenu"); } } } } if (frame.equals("iview_file")) { boolean discountview_flag = false; frn = request.getParameter("ifrn"); invid = request.getParameter("iview_no"); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_file released InvviewBean" + frn, this, null); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_file released InvviewBean" + invid, this, null); Vector invfil = new Vector(); if ((request.getParameter("idiscountview") != null) && (request.getParameter("idiscountview").equals("TRUE"))) { year = request.getParameter("iyear"); session.putValue("Iyear", year); discountview_flag = true; } if (invid != null) { if (session.getValue("Iyear") != null) { year = (String) session.getValue("Iyear"); try { invviewEJBean.connect(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_file connected to RhccInvviewBean", this, null); invno = invviewEJBean.getInvno(invid); spinnm = invviewEJBean.getSPINname(invid); invfil = invviewEJBean.getFiledetails(frn, invid, year); invviewEJBean.release(); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_file released RhccInvviewBean", this, null); } catch (RemoteException e) { USFEnv.getLog() .writeCrit("RhccInvviewServlet: Inside Remote Exception for Inv ", this, null); } } } if (discountview_flag) { request.setAttribute("vdsflag", "TRUE"); } if ((request.getParameter("invrejn") != null) && (request.getParameter("invrejn").equals("true"))) request.setAttribute("invrejn", "true"); request.setAttribute("frn", frn); request.setAttribute("invno", invno); request.setAttribute("spinnm", spinnm); request.setAttribute("invfil", invfil); USFEnv.getLog() .writeWarn( "RhccInvviewServlet: Inside frame iview_file calling JSP RhccIInvviewfil", this, null); includeJSP(request, response, jsppath, "RhccIInvviewfil"); } } } catch (Exception e) { if (invviewEJBean != null) { // calling bean release method try { invviewEJBean.release(); } catch (Exception ex) { USFEnv.getLog().writeCrit(" Exception in calling release() method ", this, e); } } USFEnv.getLog().writeCrit("RhccInvviewServlet: Inside Exception" + e, this, null); USFEnv.getLog() .writeWarn("RhccInvviewServlet: Inside Exception calling JSP Login", this, null); includeJSP(request, response, "login", "Login"); } }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { USFEnv.getLog().writeWarn("RhccInvviewServlet: Inside RhccInvviewServlet", this, null); doPost(request, response); }