package com.cypress.ecn.servlet.rel; /* * $Id: RelAdminHandler.java,v 1.5 2007/02/01 10:06:51 ons Exp $ * * Copyright (c) 2006 by Cypress Semiconductor * * Description : * Handler class for the Reliability Database Admin Utility * * Revision History : * * 12/07/2006 btg Initial version * */ import java.sql.Connection; import java.util.ArrayList; import java.util.Vector; import java.util.Iterator; import java.util.Date; import java.text.SimpleDateFormat; import java.sql.Timestamp; import javax.servlet.RequestDispatcher; import javax.servlet.ServletContext; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.cypress.ecn.container.rel.*; import com.cypress.ecn.servlet.ChangeManagementServlet; import com.cypress.ecn.servlet.NoticeAdminHandler; import cypress.shared.util.Logger; import cypress.shared.util.sql.SQLUtil; public class RelAdminHandler implements NoticeAdminHandler { /* Global Variables */ protected ChangeManagementServlet servlet = null; private static Logger log = new Logger(RelAdminHandler.class.getName()); /** * Set the calling servlet. * */ public void setServlet(HttpServlet servlet) { this.servlet = (ChangeManagementServlet) servlet; } /* End of setServlet */ /** * Method declaration * * * @param request * @param response * * @see */ public void handle( HttpServletRequest request, HttpServletResponse response, String schema, Connection connection) { try { if (servlet == null) { log.error(Logger.COMPONENT, "Need to setServlet() before handle ()"); return; } // only if user logged in is a Cypress Employee Boolean isRelUser = new Boolean(true); // default to true since CMS login handles this validation String doWhat = (String) request.getAttribute("doWhat"); if ( isRelUser != null && isRelUser.booleanValue()) { String userID = (String) request.getAttribute("userID"); Boolean hasRelAdminAccess = RelAdmin.isRelAdmin(connection, schema, userID); request.setAttribute("hasRelAdminAccess", hasRelAdminAccess); if(doWhat != null) { if(doWhat.equals("manageQTP")) { doManageQTP(request, response, connection, schema); } else if (doWhat.equals("backToMain")) { showPage(request, connection, schema, "admin/rel/adminUtil.jsp"); } else if(doWhat.equals("manage")) { doAdminManageRefData(request, response, connection, schema); } else if (doWhat.equals("searchQTP")) { doSearchQTP(request, response, connection, schema); } else if (doWhat.equals("customSearchQTP")) { doCustomSearchQTP(request, response, connection, schema); } else if (doWhat.equals("saveCSV")) { doSaveCSV(request, response, connection, schema); } else if (doWhat.equals("addRule")) { doAddRule(request, response, connection, schema); } else if (doWhat.equals("addOrder")) { doAddOrder(request, response, connection, schema); } else if (doWhat.equals("removeRule")) { doRemoveRule(request, response, connection, schema); } else if (doWhat.equals("removeOrder")) { doRemoveOrder(request, response, connection, schema); } else if (doWhat.equals("resetRules")) { doResetRules(request, response, connection, schema); } else if (doWhat.equals("resetOrderBy")) { doResetOrderBy(request, response, connection, schema); } else if (doWhat.equals("resetEquation")) { doResetEquation(request, response, connection, schema); } else if (doWhat.equals("addRuleTV")) { doAddRuleTV(request, response, connection, schema); } else if (doWhat.equals("addOrderTV")) { doAddOrderTV(request, response, connection, schema); } else if (doWhat.equals("removeRuleTV")) { doRemoveRuleTV(request, response, connection, schema); } else if (doWhat.equals("removeOrderTV")) { doRemoveOrderTV(request, response, connection, schema); } else if (doWhat.equals("resetRulesTV")) { doResetRulesTV(request, response, connection, schema); } else if (doWhat.equals("resetOrderByTV")) { doResetOrderByTV(request, response, connection, schema); } else if (doWhat.equals("resetEquationTV")) { doResetEquationTV(request, response, connection, schema); } else if (doWhat.equals("addRuleStress")) { doAddRuleStress(request, response, connection, schema); } else if (doWhat.equals("addOrderStress")) { doAddOrderStress(request, response, connection, schema); } else if (doWhat.equals("removeRuleStress")) { doRemoveRuleStress(request, response, connection, schema); } else if (doWhat.equals("removeOrderStress")) { doRemoveOrderStress(request, response, connection, schema); } else if (doWhat.equals("resetRulesStress")) { doResetRulesStress(request, response, connection, schema); } else if (doWhat.equals("resetOrderByStress")) { doResetOrderByStress(request, response, connection, schema); } else if (doWhat.equals("resetEquationStress")) { doResetEquationStress(request, response, connection, schema); } else if (doWhat.equals("addRuleTest")) { doAddRuleTest(request, response, connection, schema); } else if (doWhat.equals("addOrderTest")) { doAddOrderTest(request, response, connection, schema); } else if (doWhat.equals("removeRuleTest")) { doRemoveRuleTest(request, response, connection, schema); } else if (doWhat.equals("removeOrderTest")) { doRemoveOrderTest(request, response, connection, schema); } else if (doWhat.equals("resetRulesTest")) { doResetRulesTest(request, response, connection, schema); } else if (doWhat.equals("resetOrderByTest")) { doResetOrderByTest(request, response, connection, schema); } else if (doWhat.equals("resetEquationTest")) { doResetEquationTest(request, response, connection, schema); } else if (doWhat.equals("customSearch")) { doCustomSearch(request, response, connection, schema); } else if (doWhat.equals("search")) { doSearch(request, response, connection, schema); } else if (doWhat.equals("viewQTP")) { doViewQTP(request, response, connection, schema); } else if (doWhat.equals("editQTP")) { doEditQTP(request, response, connection, schema); } else if (doWhat.equals("newQTP")) { doNewQTP(request, response, connection, schema); } else if (doWhat.equals("saveQTP")) { doSaveQTP(request, response, connection, schema); } else if (doWhat.equals("resetQTP")) { doResetQTP(request, response, connection, schema); } else if (doWhat.equals("cancelQTP")) { doCancelQTP(request, response, connection, schema); } else if (doWhat.equals("deleteQTP")) { doDeleteQTP(request, response, connection, schema); } else if (doWhat.equals("addNewTV")) { doAddNewTV(request, response, connection, schema); } else if (doWhat.equals("deleteTV")) { doDeleteTV(request, response, connection, schema); } else if (doWhat.equals("viewTV")) { doViewTV(request, response, connection, schema); } else if (doWhat.equals("editTV")) { doEditTV(request, response, connection, schema); } else if (doWhat.equals("cancelTV")) { doCancelTV(request, response, connection, schema); } else if (doWhat.equals("resetTV")) { doResetTV(request, response, connection, schema); } else if (doWhat.equals("saveTV")) { doSaveTV(request, response, connection, schema); } else if (doWhat.equals("addNewStress")) { doAddNewStress(request, response, connection, schema); } else if (doWhat.equals("deleteStress")) { doDeleteStress(request, response, connection, schema); } else if (doWhat.equals("viewStress")) { doViewStress(request, response, connection, schema); } else if (doWhat.equals("editStress")) { doEditStress(request, response, connection, schema); } else if (doWhat.equals("cancelStress")) { doCancelStress(request, response, connection, schema); } else if (doWhat.equals("resetStress")) { doResetStress(request, response, connection, schema); } else if (doWhat.equals("saveStress")) { doSaveStress(request, response, connection, schema); } else if (doWhat.equals("setStressInfo")) { doSetStressInfo(request, response, connection, schema); } else if (doWhat.equals("addNewTest")) { doAddNewTest(request, response, connection, schema); } else if (doWhat.equals("deleteTest")) { doDeleteTest(request, response, connection, schema); } else if (doWhat.equals("cancelTest")) { doCancelTest(request, response, connection, schema); } else if (doWhat.equals("saveTest")) { doSaveTest(request, response, connection, schema); } else { showPage(request, connection, schema, "admin/rel/adminUtil.jsp"); } } else { showPage(request, connection, schema, "admin/rel/adminUtil.jsp"); } } else { request.setAttribute("MAIN_PAGE", "admin/rel/adminAccessDenied.jsp"); } if(!(doWhat != null && doWhat.equals("saveCSV"))) { ServletContext context = servlet.getServletContext(); RequestDispatcher dispatcher = context.getRequestDispatcher("/template.jsp"); log.debug("handle(): Before forward."); dispatcher.forward(request, response); log.debug("handle(): After forward."); } } catch (Exception e) { log.debug("RelAdminhandler: An error occurred while handling a request : ", e); servlet.showSystemErrorPage(request,response, e); } } private void showPage( HttpServletRequest request, Connection connection, String schema, String page) throws Exception{ request.setAttribute("MAIN_PAGE", page); } private void showAdminMain( HttpServletRequest request, Connection connection, String schema, String mainPage) throws Exception{ request.setAttribute("MAIN_PAGE", mainPage); } private boolean isDateValid(String dateIn, String dateOut) { try { Date dtInTmp = new SimpleDateFormat("MM/dd/yyyy").parse(dateIn.trim()); Date dtOutTmp = new SimpleDateFormat("MM/dd/yyyy").parse(dateOut.trim()); if (dtInTmp.compareTo(dtOutTmp) > 0) return false; } catch (Exception e) { e.printStackTrace(); } return true; } protected void doManageQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doViewQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String searchQtpNumber = (String) request.getAttribute("searchQtpNumber"); RelQTPMainInfo resultMainInfo = null; ArrayList resultTVList = null; if(searchQtpNumber != null && !searchQtpNumber.trim().equals("")) { resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, searchQtpNumber.trim()); resultTVList = RelTVInfo.getTVs(connection, schema, searchQtpNumber.trim()); } HttpSession session = request.getSession(true); if(session != null) { if(resultMainInfo != null) { session.setAttribute("evalNum", resultMainInfo.getEvalNum()); } } request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("resultTVList", resultTVList); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doViewTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String searchTvNum = (String) request.getAttribute("searchTvNum"); RelTVInfo resultTvInfo = null; ArrayList resultStressList = null; HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } if(searchTvNum != null && !searchTvNum.trim().equals("")) { resultTvInfo = RelTVInfo.getInstance(connection, schema, searchTvNum.trim(), evalNum); resultStressList = RelStressInfo.getStresses(connection, schema, searchTvNum.trim(), resultTvInfo.getEvalNum()); } request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doViewStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String searchStressInfoNum = (String) request.getAttribute("searchStressInfoNum"); RelStressInfo resultStressInfo = null; ArrayList resultTestList = null; if(searchStressInfoNum != null && !searchStressInfoNum.trim().equals("")) { resultStressInfo = RelStressInfo.getInstance(connection, schema, searchStressInfoNum.trim()); resultTestList = RelTestInfo.getTests(connection, schema, searchStressInfoNum.trim()); } request.setAttribute("resultStressInfo", resultStressInfo); HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("resultTestList", resultTestList); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSearchQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ setSearchLists(request, connection, schema); HttpSession session = request.getSession(); if(session != null) { session.removeAttribute("result"); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSaveCSV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(); ArrayList result = null; String searchType = (String) request.getAttribute("searchType"); if(session != null) { result = (ArrayList) session.getAttribute("result"); session.setAttribute("result", result); } ServletContext context = servlet.getServletContext (); RequestDispatcher dispatcher = null; if(searchType != null && !searchType.equals("")) { if(searchType.equals("customSearch")) { dispatcher = context.getRequestDispatcher ("/admin/rel/qtpCustomSearchCSV.jsp"); } else { dispatcher = context.getRequestDispatcher ("/admin/rel/qtpSearchCSV.jsp"); } dispatcher.forward (request, response); } } protected void doCustomSearchQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ setCustomSearchLists(request, connection, schema); HttpSession session = request.getSession(true); if(session != null) { session.removeAttribute("rulesList"); session.removeAttribute("equation"); session.removeAttribute("orderList"); session.removeAttribute("rulesListTV"); session.removeAttribute("equationTV"); session.removeAttribute("orderListTV"); session.removeAttribute("rulesListStress"); session.removeAttribute("equationStress"); session.removeAttribute("orderListStress"); session.removeAttribute("rulesListTest"); session.removeAttribute("equationTest"); session.removeAttribute("orderListTest"); session.removeAttribute("result"); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddRule( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesList = null; if(session != null) { rulesList = (ArrayList) session.getAttribute("rulesList"); if(rulesList != null) { Iterator iter = rulesList.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String field = (String) request.getAttribute("field_" + ruleNum); String operator = (String) request.getAttribute("operator_" + ruleNum); String value = (String) request.getAttribute("value_" + ruleNum); rule.setField(field); rule.setOperator(operator); rule.setValue(value); ruleNum++; } } } if(rulesList == null) { rulesList = new ArrayList(); } RelCustomSearchRule rule = new RelCustomSearchRule(); rulesList.add(rule); if(session != null) { session.setAttribute("rulesList", rulesList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddRuleTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListTV = null; if(session != null) { rulesListTV = (ArrayList) session.getAttribute("rulesListTV"); if(rulesListTV != null) { Iterator iter = rulesListTV.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTV = (String) request.getAttribute("fieldTV_" + ruleNum); String operatorTV = (String) request.getAttribute("operatorTV_" + ruleNum); String valueTV = (String) request.getAttribute("valueTV_" + ruleNum); rule.setField(fieldTV); rule.setOperator(operatorTV); rule.setValue(valueTV); ruleNum++; } } } if(rulesListTV == null) { rulesListTV = new ArrayList(); } RelCustomSearchRule rule = new RelCustomSearchRule(); rulesListTV.add(rule); if(session != null) { session.setAttribute("rulesListTV", rulesListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddRuleStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListStress = null; if(session != null) { rulesListStress = (ArrayList) session.getAttribute("rulesListStress"); if(rulesListStress != null) { Iterator iter = rulesListStress.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldStress = (String) request.getAttribute("fieldStress_" + ruleNum); String operatorStress = (String) request.getAttribute("operatorStress_" + ruleNum); String valueStress = (String) request.getAttribute("valueStress_" + ruleNum); rule.setField(fieldStress); rule.setOperator(operatorStress); rule.setValue(valueStress); ruleNum++; } } } if(rulesListStress == null) { rulesListStress = new ArrayList(); } RelCustomSearchRule rule = new RelCustomSearchRule(); rulesListStress.add(rule); if(session != null) { session.setAttribute("rulesListStress", rulesListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddRuleTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListTest = null; if(session != null) { rulesListTest = (ArrayList) session.getAttribute("rulesListTest"); if(rulesListTest != null) { Iterator iter = rulesListTest.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTest = (String) request.getAttribute("fieldTest_" + ruleNum); String operatorTest = (String) request.getAttribute("operatorTest_" + ruleNum); String valueTest = (String) request.getAttribute("valueTest_" + ruleNum); rule.setField(fieldTest); rule.setOperator(operatorTest); rule.setValue(valueTest); ruleNum++; } } } if(rulesListTest == null) { rulesListTest = new ArrayList(); } RelCustomSearchRule rule = new RelCustomSearchRule(); rulesListTest.add(rule); if(session != null) { session.setAttribute("rulesListTest", rulesListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetRules( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesList = new ArrayList(); if(session != null) { session.setAttribute("rulesList", rulesList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetRulesTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListTV = new ArrayList(); if(session != null) { session.setAttribute("rulesListTV", rulesListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetRulesStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListStress = new ArrayList(); if(session != null) { session.setAttribute("rulesListStress", rulesListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetRulesTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList rulesListTest = new ArrayList(); if(session != null) { session.setAttribute("rulesListTest", rulesListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetEquation( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); String equation = ""; if(session != null) { session.setAttribute("equation", equation); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetEquationTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); String equationTV = ""; if(session != null) { session.setAttribute("equationTV", equationTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetEquationStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); String equationStress = ""; if(session != null) { session.setAttribute("equationStress", equationStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetEquationTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); String equationTest = ""; if(session != null) { session.setAttribute("equationTest", equationTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetOrderBy( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderList = new ArrayList(); if(session != null) { session.setAttribute("orderList", orderList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetOrderByTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListTV = new ArrayList(); if(session != null) { session.setAttribute("orderListTV", orderListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetOrderByStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListStress = new ArrayList(); if(session != null) { session.setAttribute("orderListStress", orderListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetOrderByTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListTest = new ArrayList(); if(session != null) { session.setAttribute("orderListTest", orderListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddOrder( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderList = null; if(session != null) { orderList = (ArrayList) session.getAttribute("orderList"); } if(orderList == null) { orderList = new ArrayList(); } String order = ""; orderList.add(order); if(session != null) { session.setAttribute("orderList", orderList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddOrderTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListTV = null; if(session != null) { orderListTV = (ArrayList) session.getAttribute("orderListTV"); } if(orderListTV == null) { orderListTV = new ArrayList(); } String order = ""; orderListTV.add(order); if(session != null) { session.setAttribute("orderListTV", orderListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddOrderStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListStress = null; if(session != null) { orderListStress = (ArrayList) session.getAttribute("orderListStress"); } if(orderListStress == null) { orderListStress = new ArrayList(); } String order = ""; orderListStress.add(order); if(session != null) { session.setAttribute("orderListStress", orderListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddOrderTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(true); ArrayList orderListTest = null; if(session != null) { orderListTest = (ArrayList) session.getAttribute("orderListTest"); } if(orderListTest == null) { orderListTest = new ArrayList(); } String order = ""; orderListTest.add(order); if(session != null) { session.setAttribute("orderListTest", orderListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveRule( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeRuleNum = Integer.parseInt((String) request.getAttribute("ruleNum")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList rulesList = null; if(session != null) { rulesList = (ArrayList) session.getAttribute("rulesList"); if(rulesList != null) { Iterator iter = rulesList.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String field = (String) request.getAttribute("field_" + ruleNum); String operator = (String) request.getAttribute("operator_" + ruleNum); String value = (String) request.getAttribute("value_" + ruleNum); rule.setField(field); rule.setOperator(operator); rule.setValue(value); ruleNum++; } } } if(rulesList != null) { rulesList.remove(removeRuleNum); } if(session != null) { session.setAttribute("rulesList", rulesList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveRuleTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeRuleNum = Integer.parseInt((String) request.getAttribute("ruleNumTV")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList rulesListTV = null; if(session != null) { rulesListTV = (ArrayList) session.getAttribute("rulesListTV"); if(rulesListTV != null) { Iterator iter = rulesListTV.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTV = (String) request.getAttribute("fieldTV_" + ruleNum); String operatorTV = (String) request.getAttribute("operatorTV_" + ruleNum); String valueTV = (String) request.getAttribute("valueTV_" + ruleNum); rule.setField(fieldTV); rule.setOperator(operatorTV); rule.setValue(valueTV); ruleNum++; } } } if(rulesListTV != null) { rulesListTV.remove(removeRuleNum); } if(session != null) { session.setAttribute("rulesListTV", rulesListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveRuleStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeRuleNum = Integer.parseInt((String) request.getAttribute("ruleNumStress")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList rulesListStress = null; if(session != null) { rulesListStress = (ArrayList) session.getAttribute("rulesListStress"); if(rulesListStress != null) { Iterator iter = rulesListStress.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldStress = (String) request.getAttribute("fieldStress_" + ruleNum); String operatorStress = (String) request.getAttribute("operatorStress_" + ruleNum); String valueStress = (String) request.getAttribute("valueStress_" + ruleNum); rule.setField(fieldStress); rule.setOperator(operatorStress); rule.setValue(valueStress); ruleNum++; } } } if(rulesListStress != null) { rulesListStress.remove(removeRuleNum); } if(session != null) { session.setAttribute("rulesListStress", rulesListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveRuleTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeRuleNum = Integer.parseInt((String) request.getAttribute("ruleNumTest")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList rulesListTest = null; if(session != null) { rulesListTest = (ArrayList) session.getAttribute("rulesListTest"); if(rulesListTest != null) { Iterator iter = rulesListTest.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTest = (String) request.getAttribute("fieldTest_" + ruleNum); String operatorTest = (String) request.getAttribute("operatorTest_" + ruleNum); String valueTest = (String) request.getAttribute("valueTest_" + ruleNum); rule.setField(fieldTest); rule.setOperator(operatorTest); rule.setValue(valueTest); ruleNum++; } } } if(rulesListTest != null) { rulesListTest.remove(removeRuleNum); } if(session != null) { session.setAttribute("rulesListTest", rulesListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveOrder( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeOrderNum = Integer.parseInt((String) request.getAttribute("orderNum")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList orderList = null; if(session != null) { orderList = (ArrayList) session.getAttribute("orderList"); } if(orderList != null) { orderList.remove(removeOrderNum); } if(session != null) { session.setAttribute("orderList", orderList); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void manageRefDataSearch( HttpServletRequest request, HttpServletResponse response, String type, Connection connection, String schema) throws Exception { if(type != null && !type.trim().equals("")) { if (type.equals("sites")) { log.debug("doAdminManageRefData(): entry confirmed"); String siteName = (String) request.getAttribute("searchSiteName"); String siteDescription = (String) request.getAttribute("searchSiteDescription"); ArrayList searchResultRS = RelSite.searchSites(connection, schema, siteName, siteDescription); HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("searchResultRS", searchResultRS); } } else if (type.equals("divisions")) { String divisionName = (String) request.getAttribute("searchDivisionName"); String divisionDescription = (String) request.getAttribute("searchDivisionDescription"); ArrayList searchResultDivision = RelDivision.searchDivisions(connection, schema, divisionName, divisionDescription); HttpSession session = request.getSession(true); if (session != null) { session.setAttribute("searchResultDivision", searchResultDivision); } } else if (type.equals("bizUnits")) { String bizUnit = (String) request.getAttribute("searchBizUnit"); String bizUnitDescription = (String) request.getAttribute("searchBizUnitDescription"); ArrayList searchResultBizUnit = RelBizUnit.searchBizUnits(connection, schema, bizUnit, bizUnitDescription); HttpSession session = request.getSession(true); if (session != null) { session.setAttribute("searchResultBizUnit", searchResultBizUnit); } } } } protected void doRemoveOrderTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeOrderNum = Integer.parseInt((String) request.getAttribute("orderNumTV")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList orderListTV = null; if(session != null) { orderListTV = (ArrayList) session.getAttribute("orderListTV"); } if(orderListTV != null) { orderListTV.remove(removeOrderNum); } if(session != null) { session.setAttribute("orderListTV", orderListTV); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveOrderStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeOrderNum = Integer.parseInt((String) request.getAttribute("orderNumStress")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList orderListStress = null; if(session != null) { orderListStress = (ArrayList) session.getAttribute("orderListStress"); } if(orderListStress != null) { orderListStress.remove(removeOrderNum); } if(session != null) { session.setAttribute("orderListStress", orderListStress); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doRemoveOrderTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ int removeOrderNum = Integer.parseInt((String) request.getAttribute("orderNumTest")); updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList orderListTest = null; if(session != null) { orderListTest = (ArrayList) session.getAttribute("orderListTest"); } if(orderListTest != null) { orderListTest.remove(removeOrderNum); } if(session != null) { session.setAttribute("orderListTest", orderListTest); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAdminManageRefData( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String doWhat = (String) request.getAttribute("doWhat"); String type = (String) request.getAttribute("type"); String mode = (String) request.getAttribute("mode"); String noticeType = (String) request.getAttribute("noticeType"); log.debug("doAdminManageRefData(): doWhat = "+doWhat+""); log.debug("doAdminManageRefData(): type = "+type+""); log.debug("doAdminManageRefData(): mode = "+mode+""); log.debug("doAdminManageRefData(): noticeType = "+noticeType+""); Boolean displaySearchResult = new Boolean(false); Boolean displayAddEdit = new Boolean(false); request.setAttribute("mode", mode); request.setAttribute("type", type); request.setAttribute("doWhat", doWhat); if(mode != null) { if( mode.equals("edit") || mode.equals("search") || (mode.equals("cancel"))) { displaySearchResult = Boolean.TRUE; } if( mode.equals("add") || mode.equals("edit") || mode.equals("test") || mode.equals("save")) { displayAddEdit = Boolean.TRUE; } if(mode.equals("search")) { manageRefDataSearch(request, response, type, connection, schema); } else if(mode.equals("add")) { // manageRefDataAdd(request, response, type, connection, schema); } else if(mode.equals("edit")) { // manageRefDataEdit(request, response, type, connection, schema); } else if(mode.equals("save")) { // manageRefDataSave(request, response, type, connection, schema); } else if(mode.equals("cancel")) { // manageRefDataCancel(request, response, type, connection, schema); } else if(mode.equals("test")) { // manageRefDataTest(request, response, type, connection, schema); } else if(mode.equals("remove")) { // manageRefDataRemove(request, response, type, connection, schema); } } request.setAttribute("displaySearchResult", displaySearchResult); request.setAttribute("displayAddEdit", displayAddEdit); if(type.equals("sites")) { ArrayList allSitesList = RelSite.getAllSites(connection, schema); request.setAttribute("allSitesList", allSitesList); } if(type.equals("divisions")) { ArrayList allDivisionsList = RelDivision.getAllDivisions(connection, schema); request.setAttribute("allDivisionsList", allDivisionsList); } if(type.equals("bizUnits")) { ArrayList allBizUnitsList = RelBizUnit.getAllBizUnits(connection, schema); request.setAttribute("allBizUnitsList", allBizUnitsList); } if(type.equals("technology")) { ArrayList allTechnologiesList = RelTechnology.getAllTechnologies(connection, schema); request.setAttribute("allTechnologiesList", allTechnologiesList); } if(type.equals("qtpCategories")) { ArrayList allQTPCategoriesList = RelQTPCategory.getAllQTPCategories(connection, schema); request.setAttribute("allQTPCategoriesList", allQTPCategoriesList); } if(type.equals("packages")) { ArrayList allPackagesList = RelPackage.getAllPackages(connection, schema); request.setAttribute("allPackagesList", allPackagesList); } if(type.equals("assylocs")) { ArrayList allAssyLocsList = RelAssyLoc.getAllAssyLocs(connection, schema); request.setAttribute("allAssyLocsList", allAssyLocsList); } if(type.equals("stress")) { ArrayList allRelStressCodesList = RelStress.getAllRelStressCodes(connection, schema); request.setAttribute("allRelStressCodesList", allRelStressCodesList); } request.setAttribute("MAIN_PAGE", "admin/rel/adminEdit.jsp"); String MAIN_PAGE = (String) request.getAttribute("MAIN_PAGE"); log.debug("doAdminManageRefData(): MAIN_PAGE = "+MAIN_PAGE+""); if(mode != null && mode.equals("back")) { showAdminMain(request, connection, schema, "admin/rel/adminUtil.jsp"); } } protected void doCustomSearch( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ updateCustomSearchInputs(request, connection, schema); HttpSession session = request.getSession(); ArrayList result = null; // main info ArrayList rulesList = null; String equation = null; ArrayList orderList = null; if(session != null) { rulesList = (ArrayList) session.getAttribute("rulesList"); equation = (String) session.getAttribute("equation"); orderList = (ArrayList) session.getAttribute("orderList"); } // tv info ArrayList rulesListTV = null; String equationTV = null; ArrayList orderListTV = null; if(session != null) { rulesListTV = (ArrayList) session.getAttribute("rulesListTV"); equationTV = (String) session.getAttribute("equationTV"); orderListTV = (ArrayList) session.getAttribute("orderListTV"); } // stress info ArrayList rulesListStress = null; String equationStress = null; ArrayList orderListStress = null; if(session != null) { rulesListStress = (ArrayList) session.getAttribute("rulesListStress"); equationStress = (String) session.getAttribute("equationStress"); orderListStress = (ArrayList) session.getAttribute("orderListStress"); } // test info ArrayList rulesListTest = null; String equationTest = null; ArrayList orderListTest = null; if(session != null) { rulesListTest = (ArrayList) session.getAttribute("rulesListTest"); equationTest = (String) session.getAttribute("equationTest"); orderListTest = (ArrayList) session.getAttribute("orderListTest"); } if((rulesList != null && rulesList.size() > 0) || (rulesListTV != null && rulesListTV.size() > 0) || (rulesListStress != null && rulesListStress.size() > 0) || (rulesListTest != null && rulesListTest.size() > 0) || (equation != null && !equation.equals("")) || (equationTV != null && !equationTV.equals("")) || (equationStress != null && !equationStress.equals("")) || (equationTest != null && !equationTest.equals(""))) { result = RelQTPMainInfo.customSearchQTP( connection, schema, rulesList, equation, orderList, rulesListTV, equationTV, orderListTV, rulesListStress, equationStress, orderListStress, rulesListTest, equationTest, orderListTest); } if(session != null) { session.setAttribute("result", result); } setCustomSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpCustomSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSearch( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String qtpNumber = (String) request.getAttribute("qtpNumber"); String owner = (String) request.getAttribute("owner"); String division = (String) request.getAttribute("division"); String product = (String) request.getAttribute("product"); String category = (String) request.getAttribute("category"); String relSite = (String) request.getAttribute("relSite"); String bizUnit = (String) request.getAttribute("bizUnit"); String status = (String) request.getAttribute("status"); ArrayList result = RelQTPMainInfo.searchQTP(connection, schema, qtpNumber, owner, division, product, category, relSite, bizUnit, status); HttpSession session = request.getSession(); if(session != null) { session.setAttribute("result", result); } setSearchLists(request, connection, schema); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpSearchQTP.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); if(session != null) { RelQTPMainInfo editMainInfo = (RelQTPMainInfo) session.getAttribute("editMainInfo"); if(editMainInfo != null) { if(editMode.equals("edit")) { editMainInfo = RelQTPMainInfo.getInstance(connection, schema, editMainInfo.getEvalNum()); } else { if(editMode.equals("add")) { editMainInfo.clearAllDataFields(); } } session.setAttribute("editMainInfo", editMainInfo); } } setQTPDataLists(request, connection, schema); request.setAttribute("editMode", editMode); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); RelTVInfo editTvInfo = (RelTVInfo) session.getAttribute("editTvInfo"); if(editTvInfo != null) { if(editMode.equals("edit")) { editTvInfo = RelTVInfo.getInstance(connection, schema, editTvInfo.getTvNum(), evalNum); } else { if(editMode.equals("add")) { editTvInfo.clearAllDataFields(); } } session.setAttribute("editTvInfo", editTvInfo); } } setTVDataLists(request, connection, schema); request.setAttribute("editMode", editMode); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpTVDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doResetStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); if(session != null) { RelStressInfo editStressInfo = (RelStressInfo) session.getAttribute("editStressInfo"); if(editStressInfo != null) { if(editMode.equals("edit")) { editStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfo.getStressInfoNum()); } else { if(editMode.equals("add")) { editStressInfo.clearAllDataFields(); } } session.setAttribute("editStressInfo", editStressInfo); } } setStressDataLists(request, connection, schema); request.setAttribute("editMode", editMode); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doNewQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(true); if(session != null) { RelQTPMainInfo editMainInfo = new RelQTPMainInfo(); session.setAttribute("editMainInfo", editMainInfo); } setQTPDataLists(request, connection, schema); request.setAttribute("editMode", "add"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSaveQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ RelQTPMainInfo editMainInfo = null; Vector inputErrors = new Vector(); String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); if(session != null) { editMainInfo = (RelQTPMainInfo) session.getAttribute("editMainInfo"); } if(editMainInfo != null) { String editQTPNumber = (String) request.getAttribute("editQTPNumber"); String editPurpose = (String) request.getAttribute("editPurpose"); String editRelEngr = (String) request.getAttribute("editRelEngr"); String editOwner = (String) request.getAttribute("editOwner"); String editRelSite = (String) request.getAttribute("editRelSite"); String editDivision = (String) request.getAttribute("editDivision"); String editBizUnit = (String) request.getAttribute("editBizUnit"); String editProduct = (String) request.getAttribute("editProduct"); String editProcess = (String) request.getAttribute("editProcess"); String editFabSite = (String) request.getAttribute("editFabSite"); String editDieSize = (String) request.getAttribute("editDieSize"); String editCustomerNotice = (String) request.getAttribute("editCustomerNotice"); String editDPlanGetsNum = (String) request.getAttribute("editDPlanGetsNum"); String editDReceivedParts = (String) request.getAttribute("editDReceivedParts"); String editDStarted1stStress = (String) request.getAttribute("editDStarted1stStress"); String editStatus = (String) request.getAttribute("editStatus"); String editQTPCategory = (String) request.getAttribute("editQTPCategory"); String editRelStress = (String) request.getAttribute("editRelStress"); String editEntitlement = (String) request.getAttribute("editEntitlement"); String editDeviceVCC = (String) request.getAttribute("editDeviceVCC"); String editProductsFamily = (String) request.getAttribute("editProductsFamily"); String editBurnInConditions = (String) request.getAttribute("editBurnInConditions"); String editMoistureLevel = (String) request.getAttribute("editMoistureLevel"); String editPackage = (String) request.getAttribute("editPackage"); String editMoldingCompound = (String) request.getAttribute("editMoldingCompound"); String editDieAttach = (String) request.getAttribute("editDieAttach"); String editWADiameter = (String) request.getAttribute("editWADiameter"); String editAssemblySite = (String) request.getAttribute("editAssySite"); String editSolderReflowTemp = (String) request.getAttribute("editSolderReflowTemp"); String editSort1 = (String) request.getAttribute("editSort1"); String editSort2 = (String) request.getAttribute("editSort2"); String editSort3 = (String) request.getAttribute("editSort3"); String editSort4 = (String) request.getAttribute("editSort4"); String editClassHot = (String) request.getAttribute("editClassHot"); String editClassRoom = (String) request.getAttribute("editClassRoom"); String editClassCold = (String) request.getAttribute("editClassCold"); String editQA = (String) request.getAttribute("editQA"); if(editMode.equals("add")) { if(editQTPNumber != null && !editQTPNumber.trim().equals("")) { if(RelQTPMainInfo.isEvalNumAlreadyUsed(connection, schema, editQTPNumber.trim())) { inputErrors.addElement("EVAL NUM has already existing record/s for QTP General Information."); } else { editMainInfo.setEvalNum(editQTPNumber.trim()); } } else { inputErrors.addElement("EVAL NUM is blank."); } } if(editPurpose != null && !editPurpose.trim().equals("")) { editMainInfo.setPurpose(editPurpose.trim()); } else { inputErrors.addElement("Purpose is blank."); } if(editRelEngr != null && !editRelEngr.trim().equals("")) { editMainInfo.setRelEngr(editRelEngr.trim()); } else { inputErrors.addElement("Rel Engineer is blank."); } if(editOwner != null && !editOwner.trim().equals("")) { editMainInfo.setOwner(editOwner.trim()); } else { inputErrors.addElement("Owner is blank."); } if(editRelSite != null && !editRelSite.trim().equals("")) { editMainInfo.setRelSite(editRelSite.trim()); } else { inputErrors.addElement("No Rel Site selected."); } if(editDivision != null && !editDivision.trim().equals("")) { editMainInfo.setDivision(editDivision.trim()); } else { inputErrors.addElement("No Division selected."); } if(editBizUnit != null && !editBizUnit.trim().equals("")) { editMainInfo.setBizUnit(editBizUnit.trim()); } else { inputErrors.addElement("No Biz Unit selected."); } if(editProduct != null && !editProduct.trim().equals("")) { editMainInfo.setProduct(editProduct.trim()); } else { inputErrors.addElement("Product is blank."); } if(editProcess != null && !editProcess.trim().equals("")) { editMainInfo.setProcess(editProcess.trim()); } else { inputErrors.addElement("Process is blank."); } if(editFabSite != null && !editFabSite.trim().equals("")) { editMainInfo.setFabSite(editFabSite.trim()); } else { inputErrors.addElement("No Fab Site selected."); } if(editDieSize != null && !editDieSize.trim().equals("")) { editMainInfo.setDieSize(editDieSize.trim()); } else { inputErrors.addElement("Die Size is blank."); } if(editCustomerNotice != null && !editCustomerNotice.trim().equals("")) { editMainInfo.setCustomerNotice(editCustomerNotice.trim()); } else { inputErrors.addElement("Customer Notice is blank."); } if(editDPlanGetsNum != null && !editDPlanGetsNum.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDPlanGetsNum.trim()); editMainInfo.setDPlanGetsNum(new Timestamp(date.getTime())); } // else { // inputErrors.addElement("Date QTP Completed is blank."); // } if(editDReceivedParts != null && !editDReceivedParts.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDReceivedParts.trim()); editMainInfo.setDReceivedParts(new Timestamp(date.getTime())); } else { inputErrors.addElement("Date Received Parts is blank."); } if(editDStarted1stStress != null && !editDStarted1stStress.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDStarted1stStress.trim()); editMainInfo.setDStarted1stStress(new Timestamp(date.getTime())); } else { inputErrors.addElement("Date Started 1st Stress is blank."); } if(editStatus != null && !editStatus.trim().equals("")) { editMainInfo.setStatus(editStatus.trim()); } else { inputErrors.addElement("No Status selected."); } if(editQTPCategory != null && !editQTPCategory.trim().equals("")) { editMainInfo.setQtpCat(editQTPCategory.trim()); } else { inputErrors.addElement("No QTP Category selected."); } if(editRelStress != null && !editRelStress.trim().equals("")) { editMainInfo.setRelStress(editRelStress.trim()); } else { inputErrors.addElement("Rel Stress is blank."); } if(editEntitlement != null && !editEntitlement.trim().equals("")) { editMainInfo.setEntitlement(new Integer(editEntitlement.trim())); } else { inputErrors.addElement("Entitlement is blank."); } if(editDeviceVCC != null && !editDeviceVCC.trim().equals("")) { editMainInfo.setDeviceVCC(new Double(editDeviceVCC.trim())); } else { inputErrors.addElement("Device VCC is blank."); } if(editProductsFamily != null && !editProductsFamily.trim().equals("")) { editMainInfo.setProductsFamily(editProductsFamily.trim()); } else { inputErrors.addElement("Products Family is blank."); } if(editBurnInConditions != null && !editBurnInConditions.trim().equals("")) { editMainInfo.setBurnInConditions(editBurnInConditions.trim()); } else { inputErrors.addElement("Burn-In Conditions is blank."); } if(editMoistureLevel != null && !editMoistureLevel.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editMoistureLevel.trim().equals("na") || editMoistureLevel.trim().equals("NA") || editMoistureLevel.trim().equals("n/a") || editMoistureLevel.trim().equals("N/A") || editMoistureLevel.trim().equals("N/a") || editMoistureLevel.trim().equals("N/a")) { inputErrors.addElement("Moisture Level is invalid for QTP Category."); } else editMainInfo.setMoistureLevel(editMoistureLevel.trim()); } else editMainInfo.setMoistureLevel(editMoistureLevel.trim()); } else { inputErrors.addElement("No Moisture Level selected."); } if(editPackage != null && !editPackage.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editPackage.trim().equals("na") || editPackage.trim().equals("NA") || editPackage.trim().equals("n/a") || editPackage.trim().equals("N/A") || editPackage.trim().equals("N/a") || editPackage.trim().equals("N/a")) { inputErrors.addElement("Package is invalid for QTP Category."); } else editMainInfo.setPkg(editPackage.trim()); } else editMainInfo.setPkg(editPackage.trim()); } else { inputErrors.addElement("Package is blank."); } if(editMoldingCompound != null && !editMoldingCompound.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editMoldingCompound.trim().equals("na") || editMoldingCompound.trim().equals("NA") || editMoldingCompound.trim().equals("n/a") || editMoldingCompound.trim().equals("N/A") || editMoldingCompound.trim().equals("N/a") || editMoldingCompound.trim().equals("N/a")) { inputErrors.addElement("Molding Compound is invalid for QTP Category."); } else editMainInfo.setMoldingCompound(editMoldingCompound.trim()); } else editMainInfo.setMoldingCompound(editMoldingCompound.trim()); } else { inputErrors.addElement("Molding Compound is blank."); } if(editDieAttach != null && !editDieAttach.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editDieAttach.trim().equals("na") || editDieAttach.trim().equals("NA") || editDieAttach.trim().equals("n/a") || editDieAttach.trim().equals("N/A") || editDieAttach.trim().equals("N/a") || editDieAttach.trim().equals("N/a")) { inputErrors.addElement("Die Attach is invalid for QTP Category."); } else editMainInfo.setDieAttach(editDieAttach.trim()); } else editMainInfo.setDieAttach(editDieAttach.trim()); } else { inputErrors.addElement("Die Attach is blank."); } if(editWADiameter != null && !editWADiameter.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editWADiameter.trim().equals("na") || editWADiameter.trim().equals("NA") || editWADiameter.trim().equals("n/a") || editWADiameter.trim().equals("N/A") || editWADiameter.trim().equals("N/a") || editWADiameter.trim().equals("N/a")) { inputErrors.addElement("Wire Material Diameter is invalid for QTP Category."); } else editMainInfo.setWireMaterialDiameter(editWADiameter.trim()); } else editMainInfo.setWireMaterialDiameter(editWADiameter.trim()); } else { inputErrors.addElement("Wire Material Diameter is blank."); } if(editAssemblySite != null && !editAssemblySite.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editAssemblySite.trim().equals("na") || editAssemblySite.trim().equals("NA") || editAssemblySite.trim().equals("n/a") || editAssemblySite.trim().equals("N/A") || editAssemblySite.trim().equals("N/a") || editAssemblySite.trim().equals("N/a")) { inputErrors.addElement("Assembly Site is invalid for QTP Category."); } else editMainInfo.setAssySite(editAssemblySite.trim()); } else editMainInfo.setAssySite(editAssemblySite.trim()); } else { inputErrors.addElement("No Assembly Site selected."); } if(editSolderReflowTemp != null && !editSolderReflowTemp.trim().equals("")) { if (editQTPCategory.trim().equals("Automotive") || editQTPCategory.trim().equals("Assembly or Packaging QTP")) { if (editSolderReflowTemp.trim().equals("na") || editSolderReflowTemp.trim().equals("NA") || editSolderReflowTemp.trim().equals("n/a") || editSolderReflowTemp.trim().equals("N/A") || editSolderReflowTemp.trim().equals("N/a") || editSolderReflowTemp.trim().equals("N/a")) { inputErrors.addElement("Solder Reflow Temp is invalid for QTP Category."); } else editMainInfo.setSolderReflowTemp(editSolderReflowTemp.trim()); } else editMainInfo.setSolderReflowTemp(editSolderReflowTemp.trim()); } else { inputErrors.addElement("No Solder Reflow Temp selected."); } if(editSort1 != null && !editSort1.trim().equals("")) { editMainInfo.setSort1(editSort1.trim()); } if(editSort2 != null && !editSort2.trim().equals("")) { editMainInfo.setSort2(editSort2.trim()); } if(editSort3 != null && !editSort3.trim().equals("")) { editMainInfo.setSort3(editSort3.trim()); } if(editSort4 != null && !editSort4.trim().equals("")) { editMainInfo.setSort4(editSort4.trim()); } if(editClassHot != null && !editClassHot.trim().equals("")) { editMainInfo.setClassHot(editClassHot.trim()); } if(editClassRoom != null && !editClassRoom.trim().equals("")) { editMainInfo.setClassRoom(editClassRoom.trim()); } if(editClassCold != null && !editClassCold.trim().equals("")) { editMainInfo.setClassCold(editClassCold.trim()); } if(editQA != null && !editQA.trim().equals("")) { editMainInfo.setQa(editQA.trim()); } if(inputErrors.size() > 0) { setQTPDataLists(request, connection, schema); request.setAttribute("inputErrors", inputErrors); session.setAttribute("editMainInfo", editMainInfo); request.setAttribute("MAIN_SECTION", "qtpDataEdit.jsp"); request.setAttribute("editMode", editMode); } else { Boolean saveSuccess = editMainInfo.put(connection, schema); if(saveSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelQTPMainInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editMainInfo.getRelQtpDataID(), RelConstants.ACTION_SAVE); if(session != null) { if(editMainInfo != null) { session.setAttribute("evalNum", editMainInfo.getEvalNum()); } } } // refreshing main info and tvList from DB RelQTPMainInfo resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, editMainInfo.getEvalNum()); request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("saveSuccess", saveSuccess); ArrayList resultTVList = RelTVInfo.getTVs(connection, schema, resultMainInfo.getEvalNum()); request.setAttribute("resultTVList", resultTVList); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); } } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSaveTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ RelTVInfo editTvInfo = null; Vector inputErrors = new Vector(); Boolean saveSuccess = null; String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); String evalNum = null; if(session != null) { editTvInfo = (RelTVInfo) session.getAttribute("editTvInfo"); evalNum = (String) session.getAttribute("evalNum"); } if(editTvInfo != null) { String editTvNumber = (String) request.getAttribute("editTvNumber"); String editMfgDevice = (String) request.getAttribute("editMfgDevice"); String editMktgDevice = (String) request.getAttribute("editMktgDevice"); String editBuildKit = (String) request.getAttribute("editBuildKit"); String editTestProgram = (String) request.getAttribute("editTestProgram"); String editBin = (String) request.getAttribute("editBin"); String editAssyLocation = (String) request.getAttribute("editAssyLocation"); String editMarkLot = (String) request.getAttribute("editMarkLot"); String editAssyLot = (String) request.getAttribute("editAssyLot"); String editFabLot = (String) request.getAttribute("editFabLot"); String editDc = (String) request.getAttribute("editDc"); String editTechnology = (String) request.getAttribute("editTechnology"); String editFamily = (String) request.getAttribute("editFamily"); String editAssyProcess = (String) request.getAttribute("editAssyProcess"); if(editMode.equals("add")) { if(editTvNumber != null && !editTvNumber.trim().equals("")) { if(RelTVInfo.isTVNumAlreadyUsed(connection, schema, editTvNumber.trim(), evalNum)) { inputErrors.addElement("TV NUM has already existing record/s for Test Vehicle Information."); } else { editTvInfo.setTvNum(editTvNumber.trim()); } } else { inputErrors.addElement("TV NUM is blank."); } } if(editMfgDevice != null && !editMfgDevice.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editMfgDevice.trim().equals("DUMMY")) { inputErrors.addElement("Mfg Device is inconsistent with Assy Lot"); } else { editTvInfo.setMfgDevice(editMfgDevice.trim()); } } else { inputErrors.addElement("Mfg Device is blank."); } if(editMktgDevice != null && !editMktgDevice.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editMktgDevice.trim().equals("DUMMY")) { inputErrors.addElement("Mktg Device is inconsistent with Assy Lot"); } else { editTvInfo.setMktgDevice(editMktgDevice.trim()); } } else { inputErrors.addElement("Mktg Device is blank."); } if(editBuildKit != null && !editBuildKit.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editBuildKit.trim().equals("DUMMY")) { inputErrors.addElement("Build Kit is inconsistent with Assy Lot"); } else { editTvInfo.setBuildKit(editBuildKit.trim()); } } else { inputErrors.addElement("Build Kit is blank."); } if(editTestProgram != null && !editTestProgram.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editTestProgram.trim().equals("DUMMY")) { inputErrors.addElement("Test Program is inconsistent with Assy Lot"); } else { editTvInfo.setTestProgram(editTestProgram.trim()); } } else { inputErrors.addElement("Test Program is blank."); } if(editBin != null && !editBin.trim().equals("")) { editTvInfo.setBin(editBin.trim()); } else { inputErrors.addElement("Bin is blank."); } if(editAssyLocation != null && !editAssyLocation.trim().equals("")) { editTvInfo.setAssyLoc(editAssyLocation.trim()); } else { inputErrors.addElement("Assy Location is blank."); } if(editMarkLot != null && !editMarkLot.trim().equals("")) { editTvInfo.setMLot(editMarkLot.trim()); } else { inputErrors.addElement("Mark Lot is blank."); } if(editAssyLot != null && !editAssyLot.trim().equals("")) { editTvInfo.setAssyLot(editAssyLot.trim()); } else { inputErrors.addElement("Assy Lot is blank."); } if(editFabLot != null && !editFabLot.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editFabLot.trim().equals("DUMMY")) { inputErrors.addElement("Fab Lot is inconsistent with Assy Lot"); } else { editTvInfo.setFabLot(editFabLot.trim()); } } else { inputErrors.addElement("Fab Lot is blank."); } if(editDc != null && !editDc.trim().equals("")) { if (editAssyLot.trim().equals("DUMMY") && editDc.trim().equals("DUMMY")) { inputErrors.addElement("Date Code is inconsistent with Assy Lot"); } else { editTvInfo.setDc(editDc.trim()); } } else { inputErrors.addElement("Date Code is blank."); } if(editTechnology != null && !editTechnology.trim().equals("")) { editTvInfo.setTechnology(editTechnology.trim()); } else { inputErrors.addElement("No Technology selected."); } if(editFamily != null && !editFamily.trim().equals("")) { editTvInfo.setFamily(editFamily.trim()); } else { inputErrors.addElement("No Family selected."); } if(editAssyProcess != null && !editAssyProcess.trim().equals("")) { editTvInfo.setAssyProcess(editAssyProcess.trim()); } else { inputErrors.addElement("Assy Process is blank."); } if(inputErrors.size() > 0) { setTVDataLists(request, connection, schema); request.setAttribute("inputErrors", inputErrors); session.setAttribute("editTvInfo", editTvInfo); request.setAttribute("MAIN_SECTION", "qtpTVDataEdit.jsp"); request.setAttribute("editMode", editMode); } else { saveSuccess = editTvInfo.put(connection, schema); if(saveSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelTVInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editTvInfo.getTvDataID(), RelConstants.ACTION_SAVE); } if(editMode != null && editMode.equals("edit")) { RelTVInfo resultTvInfo = RelTVInfo.getInstance(connection, schema, editTvInfo.getTvNum(), evalNum); ArrayList resultStressList = RelStressInfo.getStresses(connection, schema, editTvInfo.getTvNum(), resultTvInfo.getEvalNum()); request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); } else if(editMode != null && editMode.equals("add")) { RelQTPMainInfo resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, editTvInfo.getEvalNum()); ArrayList resultTVList = RelTVInfo.getTVs(connection, schema, editTvInfo.getEvalNum()); request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("resultTVList", resultTVList); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); } } } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSaveStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ RelStressInfo editStressInfo = null; Vector inputErrors = new Vector(); Boolean saveSuccess = null; String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); String evalNum = null; if(session != null) { editStressInfo = (RelStressInfo) session.getAttribute("editStressInfo"); evalNum = (String) session.getAttribute("evalNum"); } if(editStressInfo != null) { String editStressCode = (String) request.getAttribute("editStressCode"); String editStressLevel = (String) request.getAttribute("editStressLevel"); String editDCommitted = (String) request.getAttribute("editDCommitted"); String editDReceived = (String) request.getAttribute("editDReceived"); String editStressClass = (String) request.getAttribute("editStressClass"); String editQty0Hr = (String) request.getAttribute("editQty0Hr"); String editProgRej = (String) request.getAttribute("editProgRej"); String editRej0Hr = (String) request.getAttribute("editRej0Hr"); String editDTest0Hr = (String) request.getAttribute("editDTest0Hr"); String editMrb = (String) request.getAttribute("editMrb"); String editEngr = (String) request.getAttribute("editEngr"); String editComment0 = (String) request.getAttribute("editComment0"); String editMethodCond = (String) request.getAttribute("editMethodCond"); String editTemp = (String) request.getAttribute("editTemp"); String editVolt = (String) request.getAttribute("editVolt"); String editVendor = (String) request.getAttribute("editVendor"); String editSpares = (String) request.getAttribute("editSpares"); String editDCompleted = (String) request.getAttribute("editDCompleted"); String editComments = (String) request.getAttribute("editComments"); String editCCode = (String) request.getAttribute("editCCode"); String editCost = (String) request.getAttribute("editCost"); if(editStressCode != null && !editStressCode.trim().equals("")) { editStressInfo.setStressCode(editStressCode.trim()); } else { inputErrors.addElement("No STRESS CODE selected."); } if(editStressLevel != null && !editStressLevel.trim().equals("")) { editStressInfo.setStressLevel(new Double(editStressLevel.trim())); } if(editDCommitted != null && !editDCommitted.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDCommitted.trim()); editStressInfo.setDCommitted(new Timestamp(date.getTime())); } else { inputErrors.addElement("Date Committed is blank."); } if(editDReceived != null && !editDReceived.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDReceived.trim()); editStressInfo.setDReceived(new Timestamp(date.getTime())); } else { inputErrors.addElement("Date Received is blank."); } if(editStressClass != null && !editStressClass.trim().equals("")) { editStressInfo.setStressClass(editStressClass.trim()); } if(editQty0Hr != null && !editQty0Hr.trim().equals("")) { editStressInfo.setQty0Hr(new Integer(editQty0Hr.trim())); } if(editProgRej != null && !editProgRej.trim().equals("")) { editStressInfo.setProgRej(new Integer(editProgRej.trim())); } if(editRej0Hr != null && !editRej0Hr.trim().equals("")) { editStressInfo.setRej0Hr(new Integer(editRej0Hr.trim())); } if(editDTest0Hr != null && !editDTest0Hr.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDTest0Hr.trim()); editStressInfo.setDTest0Hr(new Timestamp(date.getTime())); } if(editMrb != null && !editMrb.trim().equals("")) { editStressInfo.setMrb(editMrb.trim()); } if(editEngr != null && !editEngr.trim().equals("")) { editStressInfo.setEngr(editEngr.trim()); } if(editComment0 != null && !editComment0.trim().equals("")) { editStressInfo.setComment0(editComment0.trim()); } if(editMethodCond != null && !editMethodCond.trim().equals("")) { editStressInfo.setMethodCond(editMethodCond.trim()); } else { inputErrors.addElement("Method Cond is blank."); } if(editTemp != null && !editTemp.trim().equals("")) { editStressInfo.setTemp(new Integer(editTemp.trim())); } else { if (editStressCode.trim().startsWith("EFR", 0) || editStressCode.trim().startsWith("LFR", 0) || editStressCode.trim().startsWith("DRET", 0) || editStressCode.trim().startsWith("T/C", 0) || editStressCode.trim().startsWith("HAST", 0) || editStressCode.trim().startsWith("PCT", 0) || editStressCode.trim().startsWith("HTS", 0) || editStressCode.trim().startsWith("BI", 0) || editStressCode.trim().startsWith("TH", 0) || editStressCode.trim().startsWith("T/SHOCK", 0) || editStressCode.trim().startsWith("SDERBILTY", 0) || editStressCode.trim().startsWith("BURN IN", 0) || editStressCode.trim().startsWith("LATCH-UP", 0) || editStressCode.trim().startsWith("LIFE TEST", 0) || editStressCode.trim().startsWith("LIFE VER", 0) || editStressCode.trim().startsWith("LTOL", 0) || editStressCode.trim().startsWith("TEMP/HUMID", 0)) { inputErrors.addElement("Temp is invalid for Stress Code."); } } if(editVolt != null && !editVolt.trim().equals("")) { editStressInfo.setVolt(new Double(editVolt.trim())); } else { if (editStressCode.trim().startsWith("EFR", 0) || editStressCode.trim().startsWith("LFR", 0) || editStressCode.trim().startsWith("BI", 0) || editStressCode.trim().startsWith("BURN IN", 0) || editStressCode.trim().startsWith("HTSSL", 0) || editStressCode.trim().startsWith("HAST", 0)) { inputErrors.addElement("Voltage is invalid for Stress Code."); } } if(editVendor != null && !editVendor.trim().equals("")) { editStressInfo.setVendor(editVendor.trim()); } if(editSpares != null && !editSpares.trim().equals("")) { editStressInfo.setSpares(new Integer(editSpares.trim())); } if(editDCompleted != null && !editDCompleted.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDCompleted.trim()); editStressInfo.setDCompleted(new Timestamp(date.getTime())); } if(editComments != null && !editComments.trim().equals("")) { editStressInfo.setComments(editComments.trim()); } if(editCCode != null && !editCCode.trim().equals("")) { editStressInfo.setCCode(editCCode.trim()); } if(editCost != null && !editCost.trim().equals("")) { editStressInfo.setCost(new Double(editCost.trim())); } if(inputErrors.size() > 0) { setStressDataLists(request, connection, schema); request.setAttribute("inputErrors", inputErrors); session.setAttribute("editStressInfo", editStressInfo); request.setAttribute("MAIN_SECTION", "qtpStressDataEdit.jsp"); request.setAttribute("editMode", editMode); } else { saveSuccess = editStressInfo.put(connection, schema); if(saveSuccess != null && saveSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelStressInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editStressInfo.getStressDataID(), RelConstants.ACTION_SAVE); } if(editMode != null && editMode.equals("edit")) { RelStressInfo resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfo.getStressInfoNum()); ArrayList resultTestList = RelTestInfo.getTests(connection, schema, editStressInfo.getStressInfoNum()); request.setAttribute("resultStressInfo", resultStressInfo); request.setAttribute("resultTestList", resultTestList); request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); } else if(editMode != null && editMode.equals("add")) { RelStress stress = RelStress.getInstance(connection, schema, editStressInfo.getStressCode()); if(stress != null) { ArrayList readpoints = RelStress.getReadpoints(connection, schema, stress.getReadpointSetID()); if(readpoints != null && readpoints.size() > 0) { Iterator iter = readpoints.iterator(); while(iter.hasNext()) { String readpoint = (String) iter.next(); RelTestInfo testInfo = new RelTestInfo(); testInfo.setTestID(RelTestInfo.getNewTestID(connection, schema)); testInfo.setReadpoint(readpoint); testInfo.setStressInfoNum(editStressInfo.getStressInfoNum()); testInfo.put(connection, schema); } } } RelTVInfo resultTvInfo = RelTVInfo.getInstance(connection, schema, editStressInfo.getTvNum(), evalNum); ArrayList resultStressList = RelStressInfo.getStresses(connection, schema, editStressInfo.getTvNum(), resultTvInfo.getEvalNum()); request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); } } } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSaveTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ ArrayList resultTestList = null; int failedSave = 0; Boolean saveSuccess = null; Vector inputErrors = new Vector(); HttpSession session = request.getSession(); if(session != null) { resultTestList = (ArrayList) session.getAttribute("resultTestList"); } if(resultTestList != null) { Iterator iter = resultTestList.iterator(); while(iter.hasNext()) { RelTestInfo testInfo = (RelTestInfo) iter.next(); Integer testID = testInfo.getTestID(); Vector errors = new Vector(); String editReadpt = (String) request.getAttribute("editReadpt_" + testID); String editQtyIn = (String) request.getAttribute("editQtyIn_" + testID); String editDateIn = (String) request.getAttribute("editDateIn_" + testID); String editQtyOut = (String) request.getAttribute("editQtyOut_" + testID); String editDateOut = (String) request.getAttribute("editDateOut_" + testID); String editQtyInTst = (String) request.getAttribute("editQtyInTst_" + testID); String editDateInTst = (String) request.getAttribute("editDateInTst_" + testID); String editQtyOutTst = (String) request.getAttribute("editQtyOutTst_" + testID); String editDateOutTst = (String) request.getAttribute("editDateOutTst_" + testID); String editRej = (String) request.getAttribute("editRej_" + testID); String editFA = (String) request.getAttribute("editFA_" + testID); String editDateInFA = (String) request.getAttribute("editDateInFA_" + testID); String editDateOutFA = (String) request.getAttribute("editDateOutFA_" + testID); String editComment = (String) request.getAttribute("editComment_" + testID); if(editReadpt != null && !editReadpt.trim().equals("")) { testInfo.setReadpoint(editReadpt.trim()); } if(editQtyIn != null && !editQtyIn.trim().equals("")) { testInfo.setQtyIn(new Integer(editQtyIn.trim())); } if(editDateIn != null && !editDateIn.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateIn.trim()); testInfo.setDIn(new Timestamp(date.getTime())); } if(editQtyOut != null && !editQtyOut.trim().equals("")) { testInfo.setQtyOut(new Integer(editQtyOut.trim())); } if(editDateOut != null && !editDateOut.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOut.trim()); testInfo.setDOut(new Timestamp(date.getTime())); } if(editQtyInTst != null && !editQtyInTst.trim().equals("")) { testInfo.setQtyInTst(new Integer(editQtyInTst.trim())); } if(editDateInTst != null && !editDateInTst.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateInTst.trim()); testInfo.setDInTst(new Timestamp(date.getTime())); } if(editQtyOutTst != null && !editQtyOutTst.trim().equals("")) { testInfo.setQtyOutTst(new Integer(editQtyOutTst.trim())); } if(editDateOutTst != null && !editDateOutTst.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOutTst.trim()); testInfo.setDOutTst(new Timestamp(date.getTime())); } if(editRej != null && !editRej.trim().equals("")) { testInfo.setRej(new Integer(editRej.trim())); } if(editFA != null && !editFA.trim().equals("")) { testInfo.setFa(editFA.trim()); } if(editDateInFA != null && !editDateInFA.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateInFA.trim()); testInfo.setDInFa(new Timestamp(date.getTime())); } if(editDateOutFA != null && !editDateOutFA.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOutFA.trim()); testInfo.setDOutFa(new Timestamp(date.getTime())); } if(editComment != null && !editComment.trim().equals("")) { testInfo.setComments(editComment.trim()); } // Date Validation if(!isDateValid(editDateIn, editDateOut)) { errors.addElement("Date In should not come after Date Out"); } if(!isDateValid(editDateInTst, editDateOutTst)) { errors.addElement("Date In Test should not come after Date Out Test"); } if(errors.size() > 0) { inputErrors.addAll(errors); failedSave++; } else { saveSuccess = testInfo.put(connection, schema); if(saveSuccess.booleanValue()) { String userID = (String)request.getAttribute("userID"); RelTestInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), testInfo.getTestDataID(), RelConstants.ACTION_SAVE); } else { failedSave++; } } } if(failedSave > 0) { saveSuccess = new Boolean(false); } } // refresh stress info and tests list from db String editStressInfoNum = (String) request.getAttribute("editStressInfoNum"); RelStressInfo resultStressInfo = null; if(editStressInfoNum != null && !editStressInfoNum.trim().equals("")) { resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfoNum.trim()); resultTestList = RelTestInfo.getTests(connection, schema, editStressInfoNum.trim()); } request.setAttribute("resultStressInfo", resultStressInfo); if(session != null) { session.setAttribute("resultTestList", resultTestList); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doEditQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editQtpNumber = (String) request.getAttribute("editQtpNumber"); RelQTPMainInfo editMainInfo = null; if(editQtpNumber != null && !editQtpNumber.trim().equals("")) { editMainInfo = RelQTPMainInfo.getInstance(connection, schema, editQtpNumber.trim()); } HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("editMainInfo", editMainInfo); } setQTPDataLists(request, connection, schema); request.setAttribute("editMode", "edit"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doEditTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editTvNum = (String) request.getAttribute("editTvNum"); RelTVInfo editTvInfo = null; HttpSession session = request.getSession(true); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } if(editTvNum != null && !editTvNum.trim().equals("")) { editTvInfo = RelTVInfo.getInstance(connection, schema, editTvNum.trim(), evalNum); } if(session != null) { session.setAttribute("editTvInfo", editTvInfo); } setTVDataLists(request, connection, schema); request.setAttribute("editMode", "edit"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpTVDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doEditStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editStressInfoNum = (String) request.getAttribute("editStressInfoNum"); RelStressInfo editStressInfo = null; if(editStressInfoNum != null && !editStressInfoNum.trim().equals("")) { editStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfoNum.trim()); } HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("editStressInfo", editStressInfo); } setStressDataLists(request, connection, schema); request.setAttribute("editMode", "edit"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doCancelQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); RelQTPMainInfo editMainInfo = (RelQTPMainInfo) session.getAttribute("editMainInfo"); if(editMainInfo != null && editMode != null && editMode.equals("edit")) { RelQTPMainInfo resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, editMainInfo.getEvalNum()); ArrayList resultTVList = RelTVInfo.getTVs(connection, schema, editMainInfo.getEvalNum()); request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("resultTVList", resultTVList); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doCancelTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } RelTVInfo editTvInfo = (RelTVInfo) session.getAttribute("editTvInfo"); if(editTvInfo != null) { if(editMode != null && editMode.equals("edit")) { RelTVInfo resultTvInfo = RelTVInfo.getInstance(connection, schema, editTvInfo.getTvNum(), evalNum); ArrayList resultStressList = RelStressInfo.getStresses(connection, schema, editTvInfo.getTvNum(), resultTvInfo.getEvalNum()); request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); } else if(editMode != null && editMode.equals("add")) { RelQTPMainInfo resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, editTvInfo.getEvalNum()); ArrayList resultTVList = RelTVInfo.getTVs(connection, schema, editTvInfo.getEvalNum()); request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("resultTVList", resultTVList); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); } } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doCancelStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editMode = (String) request.getAttribute("editMode"); HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } RelStressInfo editStressInfo = (RelStressInfo) session.getAttribute("editStressInfo"); if(editStressInfo != null) { if(editMode != null && editMode.equals("edit")) { RelStressInfo resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfo.getStressInfoNum()); ArrayList resultTestList = RelTestInfo.getTests(connection, schema, editStressInfo.getStressInfoNum()); request.setAttribute("resultStressInfo", resultStressInfo); request.setAttribute("resultTestList", resultTestList); request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); } else if(editMode != null && editMode.equals("add")) { RelTVInfo resultTvInfo = RelTVInfo.getInstance(connection, schema, editStressInfo.getTvNum(), evalNum); ArrayList resultStressList = RelStressInfo.getStresses(connection, schema, editStressInfo.getTvNum(), resultTvInfo.getEvalNum()); request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); } } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doCancelTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editStressInfoNum = (String) request.getAttribute("editStressInfoNum"); RelStressInfo resultStressInfo = null; ArrayList resultTestList = null; if(editStressInfoNum != null && !editStressInfoNum.trim().equals("")) { resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfoNum.trim()); resultTestList = RelTestInfo.getTests(connection, schema, editStressInfoNum.trim()); } request.setAttribute("resultStressInfo", resultStressInfo); HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("resultTestList", resultTestList); } request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doSetStressInfo( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(); RelStressInfo editStressInfo = null; if(session != null) { editStressInfo = (RelStressInfo) session.getAttribute("editStressInfo"); if(editStressInfo != null) { String editStressCode = (String) request.getAttribute("editStressCode"); String editStressLevel = (String) request.getAttribute("editStressLevel"); String editDCommitted = (String) request.getAttribute("editDCommitted"); String editDReceived = (String) request.getAttribute("editDReceived"); String editStressClass = (String) request.getAttribute("editStressClass"); String editQty0Hr = (String) request.getAttribute("editQty0Hr"); String editProgRej = (String) request.getAttribute("editProgRej"); String editRej0Hr = (String) request.getAttribute("editRej0Hr"); String editDTest0Hr = (String) request.getAttribute("editDTest0Hr"); String editMrb = (String) request.getAttribute("editMrb"); String editEngr = (String) request.getAttribute("editEngr"); String editComment0 = (String) request.getAttribute("editComment0"); String editMethodCond = (String) request.getAttribute("editMethodCond"); String editTemp = (String) request.getAttribute("editTemp"); String editVolt = (String) request.getAttribute("editVolt"); String editVendor = (String) request.getAttribute("editVendor"); String editSpares = (String) request.getAttribute("editSpares"); String editDCompleted = (String) request.getAttribute("editDCompleted"); String editComments = (String) request.getAttribute("editComments"); String editCCode = (String) request.getAttribute("editCCode"); String editCost = (String) request.getAttribute("editCost"); if(editStressCode != null && !editStressCode.trim().equals("")) { editStressInfo.setStressCode(editStressCode.trim()); } if(editStressLevel != null && !editStressLevel.trim().equals("")) { editStressInfo.setStressLevel(new Double(editStressLevel.trim())); } if(editDCommitted != null && !editDCommitted.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDCommitted.trim()); editStressInfo.setDCommitted(new Timestamp(date.getTime())); } if(editDReceived != null && !editDReceived.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDReceived.trim()); editStressInfo.setDReceived(new Timestamp(date.getTime())); } if(editStressClass != null && !editStressClass.trim().equals("")) { editStressInfo.setStressClass(editStressClass.trim()); } if(editQty0Hr != null && !editQty0Hr.trim().equals("")) { editStressInfo.setQty0Hr(new Integer(editQty0Hr.trim())); } if(editProgRej != null && !editProgRej.trim().equals("")) { editStressInfo.setProgRej(new Integer(editProgRej.trim())); } if(editRej0Hr != null && !editRej0Hr.trim().equals("")) { editStressInfo.setRej0Hr(new Integer(editRej0Hr.trim())); } if(editDTest0Hr != null && !editDTest0Hr.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDTest0Hr.trim()); editStressInfo.setDTest0Hr(new Timestamp(date.getTime())); } if(editMrb != null && !editMrb.trim().equals("")) { editStressInfo.setMrb(editMrb.trim()); } if(editEngr != null && !editEngr.trim().equals("")) { editStressInfo.setEngr(editEngr.trim()); } if(editComment0 != null && !editComment0.trim().equals("")) { editStressInfo.setComment0(editComment0.trim()); } if(editMethodCond != null && !editMethodCond.trim().equals("")) { editStressInfo.setMethodCond(editMethodCond.trim()); } if(editTemp != null && !editTemp.trim().equals("")) { editStressInfo.setTemp(new Integer(editTemp.trim())); } if(editVolt != null && !editVolt.trim().equals("")) { editStressInfo.setVolt(new Double(editVolt.trim())); } if(editVendor != null && !editVendor.trim().equals("")) { editStressInfo.setVendor(editVendor.trim()); } if(editSpares != null && !editSpares.trim().equals("")) { editStressInfo.setSpares(new Integer(editSpares.trim())); } if(editDCompleted != null && !editDCompleted.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDCompleted.trim()); editStressInfo.setDCompleted(new Timestamp(date.getTime())); } if(editComments != null && !editComments.trim().equals("")) { editStressInfo.setComments(editComments.trim()); } if(editCCode != null && !editCCode.trim().equals("")) { editStressInfo.setCCode(editCCode.trim()); } if(editCost != null && !editCost.trim().equals("")) { editStressInfo.setCost(new Double(editCost.trim())); } // set applicable stress info based on stress code if(editStressCode != null && !editStressCode.trim().equals("")) { RelStress stress = RelStress.getInstance(connection, schema, editStressCode.trim()); if(stress != null) { editStressInfo.setTemp(stress.getTemp()); editStressInfo.setVolt(stress.getVolt()); editStressInfo.setCost(stress.getCost()); } } } session.setAttribute("editStressInfo", editStressInfo); } setStressDataLists(request, connection, schema); request.setAttribute("editMode", "add"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddNewTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(true); if(session != null) { String editQtpNumber = (String) request.getAttribute("editQtpNumber"); if(editQtpNumber != null && !editQtpNumber.trim().equals("")) { RelTVInfo editTvInfo = new RelTVInfo(); editTvInfo.setEvalNum(editQtpNumber.trim()); session.setAttribute("editTvInfo", editTvInfo); } } setTVDataLists(request, connection, schema); request.setAttribute("editMode", "add"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpTVDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddNewStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(true); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } if(session != null) { String editTvNum = (String) request.getAttribute("editTvNum"); if(editTvNum != null && !editTvNum.trim().equals("")) { RelStressInfo editStressInfo = new RelStressInfo(); editStressInfo.setTvNum(editTvNum.trim()); editStressInfo.setEvalNum(evalNum.trim()); editStressInfo.setStressInfoNum(RelStressInfo.getNewStressInfoNum(connection, schema).toString()); session.setAttribute("editStressInfo", editStressInfo); } } setStressDataLists(request, connection, schema); request.setAttribute("editMode", "add"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataEdit.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doAddNewTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editStressInfoNum = (String) request.getAttribute("editStressInfoNum"); RelStressInfo resultStressInfo = null; ArrayList resultTestList = null; ArrayList updatedList = new ArrayList(); // refresh stress info if(editStressInfoNum != null && !editStressInfoNum.trim().equals("")) { resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfoNum.trim()); } request.setAttribute("resultStressInfo", resultStressInfo); // update current list HttpSession session = request.getSession(); if(session != null) { resultTestList = (ArrayList) session.getAttribute("resultTestList"); } if(resultTestList != null) { Iterator iter = resultTestList.iterator(); while(iter.hasNext()) { RelTestInfo testInfo = (RelTestInfo) iter.next(); Integer testID = testInfo.getTestID(); String editReadpt = (String) request.getAttribute("editReadpt_" + testID); String editQtyIn = (String) request.getAttribute("editQtyIn_" + testID); String editDateIn = (String) request.getAttribute("editDateIn_" + testID); String editQtyOut = (String) request.getAttribute("editQtyOut_" + testID); String editDateOut = (String) request.getAttribute("editDateOut_" + testID); String editQtyInTst = (String) request.getAttribute("editQtyInTst_" + testID); String editDateInTst = (String) request.getAttribute("editDateInTst_" + testID); String editQtyOutTst = (String) request.getAttribute("editQtyOutTst_" + testID); String editDateOutTst = (String) request.getAttribute("editDateOutTst_" + testID); String editRej = (String) request.getAttribute("editRej_" + testID); String editFA = (String) request.getAttribute("editFA_" + testID); String editDateInFA = (String) request.getAttribute("editDateInFA_" + testID); String editDateOutFA = (String) request.getAttribute("editDateOutFA_" + testID); String editComment = (String) request.getAttribute("editComment_" + testID); if(editReadpt != null && !editReadpt.trim().equals("")) { testInfo.setReadpoint(editReadpt.trim()); } if(editQtyIn != null && !editQtyIn.trim().equals("")) { testInfo.setQtyIn(new Integer(editQtyIn.trim())); } if(editDateIn != null && !editDateIn.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateIn.trim()); testInfo.setDIn(new Timestamp(date.getTime())); } if(editQtyOut != null && !editQtyOut.trim().equals("")) { testInfo.setQtyOut(new Integer(editQtyOut.trim())); } if(editDateOut != null && !editDateOut.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOut.trim()); testInfo.setDOut(new Timestamp(date.getTime())); } if(editQtyInTst != null && !editQtyInTst.trim().equals("")) { testInfo.setQtyInTst(new Integer(editQtyInTst.trim())); } if(editDateInTst != null && !editDateInTst.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateInTst.trim()); testInfo.setDInTst(new Timestamp(date.getTime())); } if(editQtyOutTst != null && !editQtyOutTst.trim().equals("")) { testInfo.setQtyOutTst(new Integer(editQtyOutTst.trim())); } if(editDateOutTst != null && !editDateOutTst.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOutTst.trim()); testInfo.setDOutTst(new Timestamp(date.getTime())); } if(editRej != null && !editRej.trim().equals("")) { testInfo.setRej(new Integer(editRej.trim())); } if(editFA != null && !editFA.trim().equals("")) { testInfo.setFa(editFA.trim()); } if(editDateInFA != null && !editDateInFA.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateInFA.trim()); testInfo.setDInFa(new Timestamp(date.getTime())); } if(editDateOutFA != null && !editDateOutFA.trim().equals("")) { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yyyy"); java.util.Date date = df.parse(editDateOutFA.trim()); testInfo.setDOutFa(new Timestamp(date.getTime())); } if(editComment != null && !editComment.trim().equals("")) { testInfo.setComments(editComment.trim()); } updatedList.add(testInfo); } resultTestList = updatedList; } // add new test to list if(resultTestList == null) { resultTestList = new ArrayList(); } RelTestInfo newTest = new RelTestInfo(); newTest.setTestID(RelTestInfo.getNewTestID(connection, schema)); newTest.setStressInfoNum(editStressInfoNum.trim()); resultTestList.add(newTest); if(session != null) { session.setAttribute("resultTestList", resultTestList); } request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doDeleteQTP( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String editQtpNumber = (String) request.getAttribute("editQtpNumber"); Boolean deleteSuccess = null; if(editQtpNumber != null && !editQtpNumber.trim().equals("")) { RelQTPMainInfo editMainInfo = RelQTPMainInfo.getInstance(connection, schema, editQtpNumber.trim()); if(editMainInfo != null) { deleteSuccess = RelQTPMainInfo.deleteQTPMainInfo(connection, schema, editQtpNumber.trim()); if(deleteSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelQTPMainInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editMainInfo.getRelQtpDataID(), RelConstants.ACTION_DELETE); } } } request.setAttribute("deleteSuccess", deleteSuccess); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doDeleteTV( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String[] deleteTVNums = (String[]) request.getParameterValues("removeTvNum"); Boolean deleteSuccess = null; int failedDelete = 0; HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } if(deleteTVNums != null && deleteTVNums.length > 0) { deleteSuccess = new Boolean(true); for(int x = 0; x < deleteTVNums.length; x++) { if(!deleteTVNums[x].trim().equals("")) { String tvNum = deleteTVNums[x].trim(); RelTVInfo tvInfo = RelTVInfo.getInstance(connection, schema, tvNum, evalNum); if(tvInfo != null) { deleteSuccess = RelTVInfo.deleteTVInfo(connection, schema, tvNum, tvInfo.getEvalNum()); if(deleteSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelTVInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), tvInfo.getTvDataID(), RelConstants.ACTION_DELETE); } else { failedDelete++; } } } } if(failedDelete > 0) { deleteSuccess = new Boolean(false); } } request.setAttribute("deleteSuccess", deleteSuccess); // refresh qtp info and tv list from db String editQtpNumber = (String) request.getAttribute("editQtpNumber"); RelQTPMainInfo resultMainInfo = null; ArrayList resultTVList = null; if(editQtpNumber != null && !editQtpNumber.trim().equals("")) { resultMainInfo = RelQTPMainInfo.getInstance(connection, schema, editQtpNumber.trim()); resultTVList = RelTVInfo.getTVs(connection, schema, editQtpNumber.trim()); } request.setAttribute("resultMainInfo", resultMainInfo); request.setAttribute("resultTVList", resultTVList); request.setAttribute("MAIN_SECTION", "qtpDataView.jsp"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doDeleteStress( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String[] deleteStressInfoNums = (String[]) request.getParameterValues("removeStressInfoNum"); Boolean deleteSuccess = null; int failedDelete = 0; if(deleteStressInfoNums != null && deleteStressInfoNums.length > 0) { deleteSuccess = new Boolean(true); for(int x = 0; x < deleteStressInfoNums.length; x++) { if(!deleteStressInfoNums[x].trim().equals("")) { String stressInfoNum = deleteStressInfoNums[x].trim(); RelStressInfo editStressInfo = RelStressInfo.getInstance(connection, schema, stressInfoNum); if(editStressInfo != null) { deleteSuccess = RelStressInfo.deleteStressInfo(connection, schema, stressInfoNum); if(deleteSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelStressInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editStressInfo.getStressDataID(), RelConstants.ACTION_DELETE); } else { failedDelete++; } } } } if(failedDelete > 0) { deleteSuccess = new Boolean(false); } } request.setAttribute("deleteSuccess", deleteSuccess); // refresh tv info and stress list from DB String editTvNum = (String) request.getAttribute("editTvNum"); RelTVInfo resultTvInfo = null; ArrayList resultStressList = null; HttpSession session = request.getSession(); String evalNum = null; if(session != null) { evalNum = (String) session.getAttribute("evalNum"); } if(editTvNum != null && !editTvNum.trim().equals("")) { resultTvInfo = RelTVInfo.getInstance(connection, schema, editTvNum.trim(), evalNum); resultStressList = RelStressInfo.getStresses(connection, schema, editTvNum.trim(), resultTvInfo.getEvalNum()); } request.setAttribute("resultTvInfo", resultTvInfo); request.setAttribute("resultStressList", resultStressList); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); request.setAttribute("MAIN_SECTION", "qtpTVDataView.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } protected void doDeleteTest( HttpServletRequest request, HttpServletResponse response, Connection connection, String schema) throws Exception{ String[] deleteTestIDs = (String[]) request.getParameterValues("removeTestID"); Boolean deleteSuccess = null; int failedDelete = 0; if(deleteTestIDs != null && deleteTestIDs.length > 0) { deleteSuccess = new Boolean(true); for(int x = 0; x < deleteTestIDs.length; x++) { if(!deleteTestIDs[x].trim().equals("")) { Integer testID = new Integer(deleteTestIDs[x].trim()); RelTestInfo editTestInfo = RelTestInfo.getInstance(connection, schema, testID); if(editTestInfo != null) { deleteSuccess = RelTestInfo.deleteTestInfo(connection, schema, testID); if(deleteSuccess.booleanValue()) { String userID = (String) request.getAttribute("userID"); RelTestInfo.logDBTransaction(connection, schema, userID, SQLUtil.sqlGetTimestamp(), editTestInfo.getTestDataID(), RelConstants.ACTION_DELETE); } else { failedDelete++; } } } } if(failedDelete > 0) { deleteSuccess = new Boolean(false); } } request.setAttribute("deleteSuccess", deleteSuccess); // refresh stress info and tests list from db String editStressInfoNum = (String) request.getAttribute("editStressInfoNum"); RelStressInfo resultStressInfo = null; ArrayList resultTestList = null; if(editStressInfoNum != null && !editStressInfoNum.trim().equals("")) { resultStressInfo = RelStressInfo.getInstance(connection, schema, editStressInfoNum.trim()); resultTestList = RelTestInfo.getTests(connection, schema, editStressInfoNum.trim()); } request.setAttribute("resultStressInfo", resultStressInfo); HttpSession session = request.getSession(true); if(session != null) { session.setAttribute("resultTestList", resultTestList); } request.setAttribute("MAIN_SECTION", "qtpStressDataView.jsp"); request.setAttribute("TOP_SECTION", "qtpSearch.jsp"); showPage(request, connection, schema, "admin/rel/qtpTemplate.jsp"); } private void setQTPDataLists( HttpServletRequest request, Connection connection, String schema) throws Exception{ ArrayList allRelSitesList = RelSite.getAllSites(connection, schema); ArrayList allDivisionsList = RelDivision.getAllDivisions(connection, schema); ArrayList allBizUnitsList = RelBizUnit.getAllBizUnits(connection, schema); ArrayList allFabSitesList = RelFabSite.getAllFabSites(connection, schema); ArrayList allStatusList = RelStatus.getAllStatus(connection, schema); ArrayList allQTPCategoriesList = RelQTPCategory.getAllQTPCategories(connection, schema); ArrayList allMoistureLevelsList = RelMoistureLevel.getAllMoistureLevels(connection, schema); ArrayList allAssySitesList = RelAssySite.getAllAssySites(connection, schema); ArrayList allSolderReflowTempsList = RelSolderReflowTemp.getAllSolderReflowTemps(connection, schema); request.setAttribute("allRelSitesList", allRelSitesList); request.setAttribute("allDivisionsList", allDivisionsList); request.setAttribute("allBizUnitsList", allBizUnitsList); request.setAttribute("allFabSitesList", allFabSitesList); request.setAttribute("allStatusList", allStatusList); request.setAttribute("allQTPCategoriesList", allQTPCategoriesList); request.setAttribute("allMoistureLevelsList", allMoistureLevelsList); request.setAttribute("allAssySitesList", allAssySitesList); request.setAttribute("allSolderReflowTempsList", allSolderReflowTempsList); } private void setTVDataLists( HttpServletRequest request, Connection connection, String schema) throws Exception{ ArrayList allTechnologiesList = RelTechnology.getAllTechnologies(connection, schema); ArrayList allFamiliesList = RelFamily.getAllFamilies(connection, schema); request.setAttribute("allFamiliesList", allFamiliesList); request.setAttribute("allTechnologiesList", allTechnologiesList); } private void setStressDataLists( HttpServletRequest request, Connection connection, String schema) throws Exception{ ArrayList allStressCodesList = RelStress.getAllRelStressCodes(connection, schema); request.setAttribute("allStressCodesList", allStressCodesList); } private void setCustomSearchLists( HttpServletRequest request, Connection connection, String schema) throws Exception{ String[] searchFields = RelQTPMainInfo.SEARCH_FIELDS; String[] types = RelQTPMainInfo.FIELD_TYPES; request.setAttribute("searchFields", searchFields); request.setAttribute("types", types); String[] searchFieldsTV = RelTVInfo.SEARCH_FIELDS; String[] typesTV = RelTVInfo.FIELD_TYPES; request.setAttribute("searchFieldsTV", searchFieldsTV); request.setAttribute("typesTV", typesTV); String[] searchFieldsStress = RelStressInfo.SEARCH_FIELDS; String[] typesStress = RelStressInfo.FIELD_TYPES; request.setAttribute("searchFieldsStress", searchFieldsStress); request.setAttribute("typesStress", typesStress); String[] searchFieldsTest = RelTestInfo.SEARCH_FIELDS; String[] typesTest = RelTestInfo.FIELD_TYPES; request.setAttribute("searchFieldsTest", searchFieldsTest); request.setAttribute("typesTest", typesTest); } private void setSearchLists( HttpServletRequest request, Connection connection, String schema) throws Exception{ ArrayList allRelSitesList = RelSite.getAllSites(connection, schema); ArrayList allDivisionsList = RelDivision.getAllDivisions(connection, schema); ArrayList allBizUnitsList = RelBizUnit.getAllBizUnits(connection, schema); ArrayList allStatusList = RelStatus.getAllStatus(connection, schema); ArrayList allQTPCategoriesList = RelQTPCategory.getAllQTPCategories(connection, schema); request.setAttribute("allRelSitesList", allRelSitesList); request.setAttribute("allDivisionsList", allDivisionsList); request.setAttribute("allBizUnitsList", allBizUnitsList); request.setAttribute("allStatusList", allStatusList); request.setAttribute("allQTPCategoriesList", allQTPCategoriesList); } private void updateCustomSearchInputs( HttpServletRequest request, Connection connection, String schema) throws Exception{ HttpSession session = request.getSession(); ArrayList rulesList = null; String equation = null; ArrayList orderList = null; ArrayList rulesListTV = null; String equationTV = null; ArrayList orderListTV = null; ArrayList rulesListStress = null; String equationStress = null; ArrayList orderListStress = null; ArrayList rulesListTest = null; String equationTest = null; ArrayList orderListTest = null; if(session != null) { // Main info filters rulesList = (ArrayList) session.getAttribute("rulesList"); if(rulesList != null) { Iterator iter = rulesList.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String field = (String) request.getAttribute("field_" + ruleNum); String operator = (String) request.getAttribute("operator_" + ruleNum); String value = (String) request.getAttribute("value_" + ruleNum); rule.setField(field); rule.setOperator(operator); rule.setValue(value); ruleNum++; } } equation = (String) request.getAttribute("equation"); orderList = (ArrayList) session.getAttribute("orderList"); ArrayList updatedOrderList = new ArrayList(); if(orderList != null) { Iterator iter = orderList.iterator(); int orderNum = 0; while(iter.hasNext()) { String order = (String) request.getAttribute("order_" + orderNum); updatedOrderList.add(order); orderNum++; iter.next(); } } session.setAttribute("rulesList", rulesList); session.setAttribute("equation", equation); session.setAttribute("orderList", updatedOrderList); // tv filters rulesListTV = (ArrayList) session.getAttribute("rulesListTV"); if(rulesListTV != null) { Iterator iter = rulesListTV.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTV = (String) request.getAttribute("fieldTV_" + ruleNum); String operatorTV = (String) request.getAttribute("operatorTV_" + ruleNum); String valueTV = (String) request.getAttribute("valueTV_" + ruleNum); rule.setField(fieldTV); rule.setOperator(operatorTV); rule.setValue(valueTV); ruleNum++; } } equationTV = (String) request.getAttribute("equationTV"); orderListTV = (ArrayList) session.getAttribute("orderListTV"); ArrayList updatedOrderListTV = new ArrayList(); if(orderListTV != null) { Iterator iter = orderListTV.iterator(); int orderNum = 0; while(iter.hasNext()) { String orderTV = (String) request.getAttribute("orderTV_" + orderNum); updatedOrderListTV.add(orderTV); orderNum++; iter.next(); } } session.setAttribute("rulesListTV", rulesListTV); session.setAttribute("equationTV", equationTV); session.setAttribute("orderListTV", updatedOrderListTV); // stress info rulesListStress = (ArrayList) session.getAttribute("rulesListStress"); if(rulesListStress != null) { Iterator iter = rulesListStress.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldStress = (String) request.getAttribute("fieldStress_" + ruleNum); String operatorStress = (String) request.getAttribute("operatorStress_" + ruleNum); String valueStress = (String) request.getAttribute("valueStress_" + ruleNum); rule.setField(fieldStress); rule.setOperator(operatorStress); rule.setValue(valueStress); ruleNum++; } } equationStress = (String) request.getAttribute("equationStress"); orderListStress = (ArrayList) session.getAttribute("orderListStress"); ArrayList updatedOrderListStress = new ArrayList(); if(orderListStress != null) { Iterator iter = orderListStress.iterator(); int orderNum = 0; while(iter.hasNext()) { String orderStress = (String) request.getAttribute("orderStress_" + orderNum); updatedOrderListStress.add(orderStress); orderNum++; iter.next(); } } session.setAttribute("rulesListStress", rulesListStress); session.setAttribute("equationStress", equationStress); session.setAttribute("orderListStress", updatedOrderListStress); // test info rulesListTest = (ArrayList) session.getAttribute("rulesListTest"); if(rulesListTest != null) { Iterator iter = rulesListTest.iterator(); int ruleNum = 0; while(iter.hasNext()) { RelCustomSearchRule rule = (RelCustomSearchRule) iter.next(); String fieldTest = (String) request.getAttribute("fieldTest_" + ruleNum); String operatorTest = (String) request.getAttribute("operatorTest_" + ruleNum); String valueTest = (String) request.getAttribute("valueTest_" + ruleNum); rule.setField(fieldTest); rule.setOperator(operatorTest); rule.setValue(valueTest); ruleNum++; } } equationTest = (String) request.getAttribute("equationTest"); orderListTest = (ArrayList) session.getAttribute("orderListTest"); ArrayList updatedOrderListTest = new ArrayList(); if(orderListTest != null) { Iterator iter = orderListTest.iterator(); int orderNum = 0; while(iter.hasNext()) { String orderTest = (String) request.getAttribute("orderTest_" + orderNum); updatedOrderListTest.add(orderTest); orderNum++; iter.next(); } } session.setAttribute("rulesListTest", rulesListTest); session.setAttribute("equationTest", equationTest); session.setAttribute("orderListTest", updatedOrderListTest); } } }