/* (non-Javadoc)
* @see org.jivesoftware.openfire.roster.RosterItemProvider#getItems(java.lang.String)
*/
public Iterator<RosterItem> getItems(String username) {
LinkedList<RosterItem> itemList = new LinkedList<RosterItem>();
Connection con = null;
Connection con2 = null;
PreparedStatement pstmt = null;
PreparedStatement gstmt = null;
try {
con2 = DbConnectionManager.getConnection();
gstmt = con2.prepareStatement(LOAD_ROSTER_ITEM_GROUPS);
// Load all the contacts in the roster
con = DbConnectionManager.getConnection();
pstmt = con.prepareStatement(LOAD_ROSTER);
pstmt.setString(1, username);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
// Create a new RosterItem (ie. user contact) from the stored information
RosterItem item =
new RosterItem(
rs.getLong(2),
new JID(rs.getString(1)),
RosterItem.SubType.getTypeFromInt(rs.getInt(3)),
RosterItem.AskType.getTypeFromInt(rs.getInt(4)),
RosterItem.RecvType.getTypeFromInt(rs.getInt(5)),
rs.getString(6),
null);
// Load the groups for the loaded contact
ResultSet gs = null;
gstmt.setLong(1, item.getID());
gs = gstmt.executeQuery();
while (gs.next()) {
item.getGroups().add(gs.getString(1));
}
// Close the result set
gs.close();
// Add the loaded RosterItem (ie. user contact) to the result
itemList.add(item);
}
} catch (SQLException e) {
Log.error(LocaleUtils.getLocalizedString("admin.error"), e);
} finally {
try {
if (pstmt != null) {
pstmt.close();
}
} catch (Exception e) {
Log.error(e);
}
try {
if (con != null) {
con.close();
}
} catch (Exception e) {
Log.error(e);
}
try {
if (gstmt != null) {
gstmt.close();
}
} catch (Exception e) {
Log.error(e);
}
try {
if (con2 != null) {
con2.close();
}
} catch (Exception e) {
Log.error(e);
}
}
return itemList.iterator();
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(this, request, response, "error.jsp", true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\n\n\n\n\n\n\n\n\n\n\n\n");
org.jivesoftware.util.WebManager webManager = null;
synchronized (_jspx_page_context) {
webManager =
(org.jivesoftware.util.WebManager)
_jspx_page_context.getAttribute("webManager", PageContext.PAGE_SCOPE);
if (webManager == null) {
webManager = new org.jivesoftware.util.WebManager();
_jspx_page_context.setAttribute("webManager", webManager, PageContext.PAGE_SCOPE);
}
}
out.write('\n');
out.write('\n');
// Get parameters
boolean cancel = request.getParameter("cancel") != null;
String username = ParamUtils.getParameter(request, "username");
String jid = ParamUtils.getParameter(request, "jid");
String nickname = ParamUtils.getParameter(request, "nickname");
String groups = ParamUtils.getParameter(request, "groups");
Integer sub = ParamUtils.getIntParameter(request, "sub", 0);
boolean save = ParamUtils.getBooleanParameter(request, "save");
// Handle a cancel
if (cancel) {
response.sendRedirect("user-roster.jsp?username="******"UTF-8"));
return;
}
// Load the user's roster object
Roster roster = webManager.getRosterManager().getRoster(username);
// Load the roster item from the user's roster.
RosterItem item = roster.getRosterItem(new JID(jid));
// Handle a roster item delete:
if (save) {
List<String> groupList = new ArrayList<String>();
if (groups != null) {
for (String group : groups.split(",")) {
groupList.add(group.trim());
}
}
item.setNickname(nickname);
item.setGroups(groupList);
item.setSubStatus(RosterItem.SubType.getTypeFromInt(sub));
// Delete the roster item
roster.updateRosterItem(item);
// Log the event
webManager.logEvent("deleted roster item from " + username, "roster item:\njid = " + jid);
// Done, so redirect
response.sendRedirect(
"user-roster.jsp?username="******"UTF-8")
+ "&editsuccess=true");
return;
}
out.write("\n\n<html>\n <head>\n <title>");
if (_jspx_meth_fmt_message_0(_jspx_page_context)) return;
out.write(
"</title>\n <meta name=\"subPageID\" content=\"user-roster\"/>\n <meta name=\"extraParams\" content=\"");
out.print("username="******"UTF-8"));
out.write("\"/>\n </head>\n <body>\n\n<p>\n");
// fmt:message
org.apache.taglibs.standard.tag.rt.fmt.MessageTag _jspx_th_fmt_message_1 =
(org.apache.taglibs.standard.tag.rt.fmt.MessageTag)
_jspx_tagPool_fmt_message_key.get(
org.apache.taglibs.standard.tag.rt.fmt.MessageTag.class);
_jspx_th_fmt_message_1.setPageContext(_jspx_page_context);
_jspx_th_fmt_message_1.setParent(null);
_jspx_th_fmt_message_1.setKey("user.roster.edit.info");
int _jspx_eval_fmt_message_1 = _jspx_th_fmt_message_1.doStartTag();
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE) {
out = _jspx_page_context.pushBody();
_jspx_th_fmt_message_1.setBodyContent((javax.servlet.jsp.tagext.BodyContent) out);
_jspx_th_fmt_message_1.doInitBody();
}
do {
out.write("\n ");
// fmt:param
org.apache.taglibs.standard.tag.rt.fmt.ParamTag _jspx_th_fmt_param_0 =
(org.apache.taglibs.standard.tag.rt.fmt.ParamTag)
_jspx_tagPool_fmt_param_value_nobody.get(
org.apache.taglibs.standard.tag.rt.fmt.ParamTag.class);
_jspx_th_fmt_param_0.setPageContext(_jspx_page_context);
_jspx_th_fmt_param_0.setParent((javax.servlet.jsp.tagext.Tag) _jspx_th_fmt_message_1);
_jspx_th_fmt_param_0.setValue(StringUtils.escapeForXML(username));
int _jspx_eval_fmt_param_0 = _jspx_th_fmt_param_0.doStartTag();
if (_jspx_th_fmt_param_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
_jspx_tagPool_fmt_param_value_nobody.reuse(_jspx_th_fmt_param_0);
return;
}
_jspx_tagPool_fmt_param_value_nobody.reuse(_jspx_th_fmt_param_0);
out.write('\n');
int evalDoAfterBody = _jspx_th_fmt_message_1.doAfterBody();
if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
} while (true);
if (_jspx_eval_fmt_message_1 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE)
out = _jspx_page_context.popBody();
}
if (_jspx_th_fmt_message_1.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
_jspx_tagPool_fmt_message_key.reuse(_jspx_th_fmt_message_1);
return;
}
_jspx_tagPool_fmt_message_key.reuse(_jspx_th_fmt_message_1);
out.write("\n</p>\n\n<fieldset>\n <legend>");
if (_jspx_meth_fmt_message_2(_jspx_page_context)) return;
out.write(
"</legend>\n <div>\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_3(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(jid));
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_4(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(item.getNickname()));
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_5(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
List<String> groupList = item.getGroups();
if (!groupList.isEmpty()) {
int count = 0;
for (String group : groupList) {
if (count != 0) {
out.print(",");
}
out.print(StringUtils.escapeForXML(group));
count++;
}
} else {
out.print("<i>None</i>");
}
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n <a href=\"group-summary.jsp\">");
if (_jspx_meth_fmt_message_6(_jspx_page_context)) return;
out.write("</a>:\n </td>\n <td>\n ");
Collection<Group> sharedGroups = item.getSharedGroups();
if (!sharedGroups.isEmpty()) {
int count = 0;
for (Group group : sharedGroups) {
if (count != 0) {
out.print(",");
}
out.print(
"<a href='group-edit.jsp?group="
+ URLEncoder.encode(group.getName(), "UTF-8")
+ "'>");
out.print(StringUtils.escapeForXML(group.getName()));
out.print("</a>");
count++;
}
} else {
out.print("<i>None</i>");
}
out.write(
"\n </td>\n </tr>\n <tr>\n <td class=\"c1\">\n ");
if (_jspx_meth_fmt_message_7(_jspx_page_context)) return;
out.write(":\n </td>\n <td>\n ");
out.print(StringUtils.escapeHTMLTags(item.getSubStatus().getName()));
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n</fieldset>\n\n<br><br>\n\n<form style=\"display: inline\" action=\"user-roster-edit.jsp\">\n<input type=\"hidden\" name=\"jid\" value=\"");
out.print(StringUtils.escapeForXML(jid));
out.write("\">\n<input type=\"hidden\" name=\"username\" value=\"");
out.print(StringUtils.escapeForXML(username));
out.write("\">\n<input type=\"submit\" value=\"");
if (_jspx_meth_fmt_message_8(_jspx_page_context)) return;
out.write("\">\n</form>\n\n");
if (sharedGroups.isEmpty()) {
out.write(
"\n<form style=\"display: inline\" action=\"user-roster-delete.jsp\">\n<input type=\"hidden\" name=\"jid\" value=\"");
out.print(StringUtils.escapeForXML(jid));
out.write("\">\n<input type=\"hidden\" name=\"username\" value=\"");
out.print(StringUtils.escapeForXML(username));
out.write("\">\n<input type=\"submit\" value=\"");
if (_jspx_meth_fmt_message_9(_jspx_page_context)) return;
out.write("\">\n</form>\n");
}
out.write("\n\n </body>\n</html>\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}