public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
javax.servlet.jsp.PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=ISO-8859-1");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
User user = null;
UserFactory userFactory = UserFactory.getInstance();
String userID = request.getParameter("userID");
try {
UserFactory.init();
user = userFactory.getUser(userID);
} catch (Exception e) {
throw new ServletException("Could not find user " + userID + " in user factory.", e);
}
out.write("\n");
out.write("<html>\n");
out.write("<head>\n ");
out.write("<title>WebTelemetry - | User Management | User Detail");
out.write("</title>\n ");
out.write("<base HREF=\"");
out.print(org.opennms.web.Util.calculateUrlBase(request));
out.write("\" />\n ");
out.write(
"<link rel=\"stylesheet\" type=\"text/css\" href=\"/wt-portal/css/default.css\" />\n\t");
out.write("<script type=\"text/javascript\" src=\"/wt-portal/javascript/WTtools.js\">");
out.write("</script>\n");
out.write("</head>\n");
out.write("<body>\n");
String title = " User Management - Detail Summary for: " + userID;
out.write("\n");
/* ---- c:if ---- */
org.apache.taglibs.standard.tag.el.core.IfTag _jspx_th_c_if_0 =
(org.apache.taglibs.standard.tag.el.core.IfTag)
_jspx_tagPool_c_if_test.get(org.apache.taglibs.standard.tag.el.core.IfTag.class);
_jspx_th_c_if_0.setPageContext(pageContext);
_jspx_th_c_if_0.setParent(null);
_jspx_th_c_if_0.setTest("${not param.orgAdminPopup}");
int _jspx_eval_c_if_0 = _jspx_th_c_if_0.doStartTag();
if (_jspx_eval_c_if_0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
do {
out.write("\n ");
JspRuntimeLibrary.include(
request,
response,
"/includes/header.jsp"
+ "?"
+ "title="
+ java.net.URLEncoder.encode("" + title)
+ "&"
+ "help="
+ "monitoringadmin%2Fusers%2FWTHelp_User.html",
out,
false);
out.write("\n");
int evalDoAfterBody = _jspx_th_c_if_0.doAfterBody();
if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
} while (true);
}
if (_jspx_th_c_if_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) return;
_jspx_tagPool_c_if_test.reuse(_jspx_th_c_if_0);
out.write("\n");
if (_jspx_meth_c_if_1(pageContext)) return;
out.write("\n\n");
out.write("<!-- BEGIN FRAMING TABLE:open tags, keep at 100%-->\n");
out.write("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n\t");
out.write("<tr>\n\t\t");
out.write("<td width=\"10\">");
out.write(
"<img src=\"/wt-portal/images/spacers/spacer.gif\" height=\"1\" width=\"10\" border=\"0\" alt=\"WebTelemetry\">");
out.write("</td>\n\t\t");
out.write("<td>\n");
out.write("<!-- END FRAMING TABLE:open tags, keep at 100%-->\n");
out.write("<table width=\"98%\"border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n ");
out.write("<tr class=\"tableHeader\">\n ");
out.write("<td class=\"tableHeader\" colspan=\"2\">User Information");
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" width=\"25%\">");
out.write("<b>Full Name:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\" width=\"75%\">");
out.print(user.getFullName());
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowDark\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Comments:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(user.getUserComments());
out.write("</td>\n ");
out.write("</tr>\n");
out.write("</table>\n");
out.write("<br>\n");
out.write("<table width=\"98%\"border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n ");
out.write("<tr class=\"tableHeader\">\n ");
out.write("<td class=\"tableHeader\" colspan=\"2\">Notification Information");
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" width=\"25%\">");
out.write("<b>Email:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\" width=\"75%\">");
out.print(userFactory.getEmail(userID));
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowDark\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Pager Email:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(userFactory.getPagerEmail(userID));
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Numerical Service:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(userFactory.getNumericPage(userID));
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowDark\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Numerical Pin:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(userFactory.getNumericPin(userID));
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Text Service:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(userFactory.getTextPage(userID));
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowDark\">\n ");
out.write("<td class=\"tableText\">");
out.write("<b>Text Pin:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\">");
out.print(userFactory.getTextPin(userID));
out.write("</td>\n ");
out.write("</tr>\n");
out.write("</table>\n");
out.write("<br>\n");
out.write("<table width=\"98%\"border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n ");
out.write("<tr class=\"tableHeader\">\n ");
out.write("<td class=\"tableHeader\" colspan=\"2\">Duty Schedules");
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" colspan=\"2\">");
out.write("<br />\n ");
out.write("<!-- weekly schedule -->\n ");
out.write(
"<table width=\"50%\" border=\"1\" bordercolor=\"#999999\" cellspacing=\"0\" cellpadding=\"2\" >\n\t\t\t");
Collection dutySchedules = user.getDutyScheduleCollection();
out.write("\n ");
int i = 0;
Iterator iter = dutySchedules.iterator();
while (iter.hasNext()) {
DutySchedule tmp = new DutySchedule((String) iter.next());
Vector curSched = tmp.getAsVector();
i++;
out.write("\n ");
out.write("<tr>\n ");
ChoiceFormat days = new ChoiceFormat("0#Mo|1#Tu|2#We|3#Th|4#Fr|5#Sa|6#Su");
for (int j = 0; j < 7; j++) {
Boolean curDay = (Boolean) curSched.get(j);
out.write("\n ");
out.write("<td width=\"5%\">\n ");
out.print((curDay.booleanValue() ? days.format(j) : "X"));
out.write("\n ");
out.write("</td>\n ");
}
out.write("\n ");
out.write("<td width=\"5%\">\n ");
out.print(curSched.get(7));
out.write("\n ");
out.write("</td>\n ");
out.write("<td width=\"5%\">\n ");
out.print(curSched.get(8));
out.write("\n ");
out.write("</td>\n ");
out.write("</tr>\n ");
}
out.write("\n ");
out.write("</table>\n ");
out.write("<!-- end weekly schedule --> \n ");
out.write("</td>\n ");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" colspan=\"2\">");
out.write(
"<img src=\"/wt-portal/images/spacers/spacer.gif\" height=\"4\" width=\"10\" border=\"0\" alt=\"WebTelemetry\">");
out.write("</td>\n ");
out.write("</tr> \n");
out.write("</table>\n");
out.write("<br>");
out.write("<br>\n");
out.write("<b>Member of the Following Organizations & Groups:");
out.write("</b>\n");
out.write("<!-- BEGIN: NEW ASSIGNED GROUPS TABLE -->\n");
out.write("<table width=\"98%\"border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n\n ");
// Get the user's orgs
WTOrganizationDAO orgDAO = DAOImpl.OrgDAO;
WTOrganization[] orgs = orgDAO.getWTOrganization();
if (orgs != null) {
// Loop thru orgs
for (int idx = 0; idx < orgs.length; idx++) {
out.write("\n\n ");
out.write("<tr class=\"tableHeader\">\n ");
out.write("<td class=\"tableHeader\" colspan=\"2\">Organization Name: ");
out.print(orgs[idx].getName());
out.write("</td>\n\t");
out.write("</tr>\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" width=\"25%\">");
out.write("<b>Assigned Groups:");
out.write("</b>");
out.write("</td>\n ");
out.write("<td class=\"tableText\" width=\"75%\">\n ");
// Get the orgs groups
WTGroupManager grpMgr = ManagersImpl.GroupManager;
int[] orgids = {orgs[idx].getID()};
List groups = grpMgr.getUserGroups(user.getUserId(), orgids);
if (groups != null) {
// Loop thru the groups
for (Iterator iterGrps = groups.iterator(); iterGrps.hasNext(); ) {
WTGroup group = (WTGroup) iterGrps.next();
WTRole role = (group.getRoles() == null ? null : (WTRole) group.getRoles().get(0));
out.write("\n ");
out.print(group.getName());
out.write(" (");
out.print((role == null ? "" : role.getName()));
out.write(")");
out.write("<br/>\n ");
}
}
out.write("\n\n ");
out.write("</td>\n\t");
out.write("</tr>\n\n ");
}
}
out.write("\n\n ");
out.write("<tr class=\"tableRowLight\">\n ");
out.write("<td class=\"tableText\" colspan=\"2\">");
out.write(
"<img src=\"/wt-portal/images/spacers/spacer.gif\" height=\"4\" width=\"10\" border=\"0\" alt=\"WebTelemetry\">");
out.write("</td>\n ");
out.write("</tr> \n");
out.write("</table>\n");
out.write("<!-- END: NEW ASSIGNED GROUPS TABLE -->\n\n\n");
out.write("<!-- BEGIN FRAMING TABLE:close tags-->\n\t\t");
out.write("</td>\n\t");
out.write("</tr>\n");
out.write("</table>\n");
out.write("<!-- END FRAMING TABLE:close tags-->\n");
out.write("<br>\n\n");
JspRuntimeLibrary.include(request, response, "/includes/footer.jsp", out, false);
out.write("\n");
out.write("</body>\n");
out.write("</html>\n\n");
} catch (Throwable t) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
PreparedStatement pstmt = null;
Connection conn = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
GridParams pars = (GridParams) inputPar;
BigDecimal rootProgressiveHIE01 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.ROOT_PROGRESSIVE_HIE01);
BigDecimal progressiveHIE01 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_HIE01);
BigDecimal progressiveHIE02 =
(BigDecimal) pars.getOtherGridParams().get(ApplicationConsts.PROGRESSIVE_HIE02);
Boolean productsOnly =
(Boolean) pars.getOtherGridParams().get(ApplicationConsts.PRODUCTS_ONLY);
Boolean compsOnly =
(Boolean) pars.getOtherGridParams().get(ApplicationConsts.COMPONENTS_ONLY);
HierarchyLevelVO vo =
(HierarchyLevelVO) pars.getOtherGridParams().get(ApplicationConsts.TREE_FILTER);
if (vo != null) {
progressiveHIE01 = vo.getProgressiveHIE01();
progressiveHIE02 = vo.getProgressiveHie02HIE01();
}
// retrieve companies list...
ArrayList companiesList =
((JAIOUserSessionParameters) userSessionPars).getCompanyBa().getCompaniesList("ITM01");
String companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
String sql =
"select ITM01_ITEMS.COMPANY_CODE_SYS01,ITM01_ITEMS.ITEM_CODE,SYS10_TRANSLATIONS.DESCRIPTION,ITM01_ITEMS.PROGRESSIVE_HIE02,ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02,"
+ "ITM01_ITEMS.PROGRESSIVE_HIE01,ITM01_ITEMS.SERIAL_NUMBER_REQUIRED,REG02_MEASURE_UNITS.DECIMALS "
+ " from ITM01_ITEMS,SYS10_TRANSLATIONS,REG02_MEASURE_UNITS where "
+ "ITM01_ITEMS.PROGRESSIVE_HIE02=? and "
+ "ITM01_ITEMS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "ITM01_ITEMS.COMPANY_CODE_SYS01 in ("
+ companies
+ ") and "
+ "ITM01_ITEMS.ENABLED='Y' and "
+ "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02=REG02_MEASURE_UNITS.UM_CODE ";
if (productsOnly != null && productsOnly.booleanValue())
sql += " and ITM01_ITEMS.MANUFACTURE_CODE_PRO01 is not null ";
if (compsOnly != null && compsOnly.booleanValue())
sql += " and ITM01_ITEMS.MANUFACTURE_CODE_PRO01 is null ";
if (rootProgressiveHIE01 == null || !rootProgressiveHIE01.equals(progressiveHIE01)) {
// retrieve all subnodes of the specified node...
pstmt =
conn.prepareStatement(
"select HIE01_LEVELS.PROGRESSIVE,HIE01_LEVELS.PROGRESSIVE_HIE01,HIE01_LEVELS.LEV from HIE01_LEVELS "
+ "where ENABLED='Y' and PROGRESSIVE_HIE02=? and PROGRESSIVE>=? "
+ "order by LEV,PROGRESSIVE_HIE01,PROGRESSIVE");
pstmt.setBigDecimal(1, progressiveHIE02);
pstmt.setBigDecimal(2, progressiveHIE01);
ResultSet rset = pstmt.executeQuery();
HashSet currentLevelNodes = new HashSet();
HashSet newLevelNodes = new HashSet();
String nodes = "";
int currentLevel = -1;
while (rset.next()) {
if (currentLevel != rset.getInt(3)) {
// next level...
currentLevel = rset.getInt(3);
currentLevelNodes = newLevelNodes;
newLevelNodes = new HashSet();
}
if (rset.getBigDecimal(1).equals(progressiveHIE01)) {
newLevelNodes.add(rset.getBigDecimal(1));
nodes += rset.getBigDecimal(1) + ",";
} else if (currentLevelNodes.contains(rset.getBigDecimal(2))) {
newLevelNodes.add(rset.getBigDecimal(1));
nodes += rset.getBigDecimal(1) + ",";
}
}
rset.close();
pstmt.close();
if (nodes.length() > 0) nodes = nodes.substring(0, nodes.length() - 1);
sql += " and PROGRESSIVE_HIE01 in (" + nodes + ")";
}
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01ITM01", "ITM01_ITEMS.COMPANY_CODE_SYS01");
attribute2dbField.put("itemCodeITM01", "ITM01_ITEMS.ITEM_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("progressiveHie02ITM01", "ITM01_ITEMS.PROGRESSIVE_HIE02");
attribute2dbField.put(
"minSellingQtyUmCodeReg02ITM01", "ITM01_ITEMS.MIN_SELLING_QTY_UM_CODE_REG02");
attribute2dbField.put("progressiveHie01ITM01", "ITM01_ITEMS.PROGRESSIVE_HIE01");
attribute2dbField.put("serialNumberRequiredITM01", "ITM01_ITEMS.SERIAL_NUMBER_REQUIRED");
attribute2dbField.put("decimalsREG02", "REG02_MEASURE_UNITS.DECIMALS");
ArrayList values = new ArrayList();
values.add(progressiveHIE02);
values.add(serverLanguageId);
// read from ITM01 table...
Response answer =
QueryUtil.getQuery(
conn,
userSessionPars,
sql,
values,
attribute2dbField,
GridItemVO.class,
"Y",
"N",
context,
pars,
50,
true);
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while fetching items list",
ex);
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}