/**
* 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);
}
}
/** Required Method Implementation */
public void ejbCreate() throws CreateException, RemoteException {
try {
// Data validation EJB
rhcccustValidateHome = (RhccCustomerHome) USFEnv.ic.lookup(RHCC_VALIDATION_EJBEAN);
rhcccustValidate = rhcccustValidateHome.create();
} catch (NamingException e) {
USFEnv.getLog().writeCrit("Inside Naming exception", this, e);
} catch (CreateException e) {
USFEnv.getLog().writeCrit("Inside Create exception", this, e);
} catch (RemoteException e) {
USFEnv.getLog().writeCrit("Inside Remote exception", this, e);
}
USFEnv.getLog().writeDebug("EJB Created, ref:" + this.toString(), this, null);
}
public List retrieveAttachmentsByCustomerId(long customerId) throws RemoteException {
List attachments = new ArrayList();
AttachmentDAO attachmentDAO = new AttachmentDAO(conn);
attachments = attachmentDAO.retrieveAttachmentsByCustomerId(customerId);
USFEnv.getLog().writeDebug("attachments size is......" + attachments.size(), this, null);
return attachments;
}
/**
* 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);
}
}
/**
* Business unit of work This method is used to delete an existing customer
*
* @param customer Id
* @return true or false whether the customer is deleted or not
*/
public boolean delCustomer(String customerId) throws RemoteException {
USFEnv.getLog().writeWarn(" Inside delCustomer", this, null);
boolean bTmp = false;
// Get the connection
RhccCustInfos rhcc_obj = new RhccCustInfos(conn);
try {
if (conn != null) {
bTmp = rhcc_obj.deleteCustomer(Long.parseLong(customerId));
USFEnv.getLog()
.writeDebug("delCustomer DB connection, ref: " + conn.toString(), this, null);
}
} catch (Exception e) {
USFEnv.getLog().writeCrit("Error in business EJB: ", this, e);
}
return bTmp;
}
/**
* Business unit of work This method is used to update an existing customer after editing
*
* @param customer details
* @return true or false whether the customer is updated or not
*/
public boolean updateCustomer(RhccCustInfos updateCustomer) throws RemoteException {
USFEnv.getLog().writeWarn(" Inside updateCustomer", this, null);
boolean bTmp = false;
// Get the connection
RhccCustInfos rhcc_obj = new RhccCustInfos(conn);
try {
if (conn != null) {
bTmp = rhcc_obj.updateCustomerInfo(updateCustomer);
USFEnv.getLog()
.writeDebug("newCustomer DB connection, ref: " + conn.toString(), this, null);
}
} catch (Exception e) {
USFEnv.getLog().writeCrit("Error in business EJB: ", this, e);
}
return bTmp;
}
/** This method used to connect to the Conection pool */
public void connect() throws ConnectException, RemoteException {
try {
conn = null;
conn = dbconn.open();
USFEnv.getLog().writeDebug("created db connection(), ref: " + conn.toString(), this, null);
} catch (Exception e) {
throw new ConnectException("Database connection failure");
}
}
/**
* Business unit of work This method is used to view a particular selected Customer
*
* @param customer Id
* @return customer details
*/
public RhccCustInfos viewCustomer(String customerId) throws RemoteException {
RhccCustInfos cTmp = null;
USFEnv.getLog().writeWarn(" Inside viewCustomer", this, null);
// Get the connection
RhccCustInfos rhcc_obj = new RhccCustInfos(conn);
try {
if (conn != null) {
cTmp = rhcc_obj.searchCustomerInfo(customerId);
USFEnv.getLog()
.writeDebug("viewCustomer DB connection, ref: " + conn.toString(), this, null);
}
} catch (Exception e) {
USFEnv.getLog().writeCrit("Error in business EJB: ", this, e);
}
return cTmp;
}
/**
* Business unit of work This method show all the RHCC customers for a funding year
*
* @param year - funding year
* @return vCustnmid - Customers for a Funding Year
*/
public Vector getAllRHCCCustomers(short year) throws RemoteException, NullPointerException {
Vector vCustnmid = null;
USFEnv.getLog().writeWarn("Inside getAllRHCCCustomers", this, null);
// Get the connection
RhccCustInfos rhcc_obj = new RhccCustInfos();
try {
vCustnmid = rhcc_obj.getAllRHCCCustomers(year);
USFEnv.getLog()
.writeDebug("getAllRHCCCustomers DB connection, ref: " + conn.toString(), this, null);
} catch (Exception e) {
USFEnv.getLog().writeCrit("Error in business EJB: ", this, e);
}
return vCustnmid;
}
/**
* Business unit of work This method is used to save a new Customer or an existing customer after
* editing
*
* @param new customer details
* @return true or false whether the customer is saved or not
*/
public boolean saveCustomer(RhccCustInfos saveCustomer, Hashtable custErrors)
throws RemoteException {
USFEnv.getLog().writeWarn(" Inside saveCustomer", this, null);
long customerId;
boolean bCustErr = false;
boolean bTmp = false;
// Get the connection
RhccCustInfos rhcc_obj = new RhccCustInfos(conn);
try {
customerId = saveCustomer.getCustomerId();
if (conn != null) {
USFEnv.getLog()
.writeDebug("saveCustomer DB connection, ref: " + conn.toString(), this, null);
}
// Check business logic field value validation
bCustErr = rhcccustValidate.customerBusVal(saveCustomer, custErrors);
// Check if critial error occured
if (!bCustErr) {
// Saving a new customer
if (customerId == 0) {
// One time funding year set for new customer record
bTmp = newCustomer(saveCustomer);
USFEnv.getLog()
.writeWarn(
"new RhccCustInfo created, RCI_ID: " + saveCustomer.getCustomerId(), this, null);
} else {
// Saving an exiting customer
bTmp = updateCustomer(saveCustomer);
}
}
} catch (Exception e) {
USFEnv.getLog().writeCrit("Error in business EJB: ", this, e);
}
return bTmp;
}
/**
* This Method checks if the passed product key has any credits. returns a boolean value based on
* the check Result.
*
* @param wodId - Product Key WOD_ID of the WRK_ORDR_DETS table
* @return boolean - TRUE ( If product has credits) FALSE (If product has no credits)
*/
public boolean hasCredits(long wodId) throws RemoteException {
WrkOrdrDets wrkordrdts_obj = new WrkOrdrDets(conn);
// Check if the Product credit is greater than zero
if (wrkordrdts_obj.getProductDiscount(wodId) > (new Double("0.00")).doubleValue()) {
// If Yes Return True
USFEnv.getLog().writeDebug("Item has Discounts", this, null);
return true;
}
// Return False
return false;
}
/**
* This Method is the Unit of Work related to a Item Deletion. This returns a boolean value based
* on the Deletion Result.
*
* @param wodId - WorkOrder Detail Id(Product Key) Primary Key of WRK_ORDR_DETS table
* @return boolean - TRUE ( If Deletion Success) FALSE (Deletion Failed)
*/
public boolean deleteProduct(long wodId) throws RemoteException {
WrkOrdrDets wrkordrdts_obj = new WrkOrdrDets(conn);
// Check if the Product credit is greater than zero
if (wrkordrdts_obj.getProductDiscount(wodId) > (new Double("0.00")).doubleValue()) {
// If Yes return False as product cant be deleted
USFEnv.getLog().writeWarn("Cannot Delete Item. Item has Discounts", this, null);
return false;
}
// Else if credit not greater than zero Delete the Product.
return wrkordrdts_obj.deleteWrkOrdrDets(wodId);
}
/**
* 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()
/** Required Method Implementation */
public void ejbPassivate() {
USFEnv.getLog().writeDebug("WorkOrderDetailBean: WorkOrder Detail Bean passivated", this, null);
}
/** Required Method Implementation */
public void ejbRemove() {
USFEnv.getLog().writeDebug("WorkOrderDetailBean: WorkOrder Detail Bean Removed", this, null);
}
/**
* Required Method Implementation
*
* @exception CreateException, RemoteException
*/
public void ejbCreate() throws CreateException, RemoteException {
USFEnv.getLog().writeDebug("workorderdetailBean: WorkOrderDetail Bean Created", this, null);
}
public void setSessionContext(SessionContext context) {
USFEnv.getLog().writeDebug("FrnDetailBean: Session Context Created", this, null);
this.context = context;
}
/** Required Method Implementation */
public void ejbPassivate() {
USFEnv.getLog().writeDebug("RhccInfoBean: RhccInfo Bean Passivated", this, null);
}
/** Required Method Implementation */
public void ejbRemove() {
USFEnv.getLog().writeDebug("RhccInfoBean: RhccInfo Bean Removed", this, null);
}