protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
MySQLcon db = new MySQLcon();
db.Upd(
"UPDATE Messages SET Messages.Read=1 WHERE idMessages='"
+ (String) request.getParameter("id")
+ "';");
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession(true);
PrintWriter out = response.getWriter();
MySQLcon db = new MySQLcon();
out.println("<table border=\"2\" cellpadding=\"0\" cellspacing=\"0\" class=\"navbar\">");
ResultSet r1;
ResultSet r =
db.Quer(
"SELECT idUsers_team FROM Users_team WHERE Team_idTeam='"
+ (String) session.getAttribute("teamid")
+ "' AND Users_idUsers='"
+ (String) session.getAttribute("userid")
+ "';");
try {
r.first();
String myWall = r.getString("idUsers_team");
r =
db.Quer(
"SELECT * FROM Messages WHERE Users_team_idUsers_team='"
+ myWall
+ "' AND Users_idUsers!='"
+ (String) session.getAttribute("userid")
+ "' AND Messages.Read=0;");
while (r.next()) {
r1 =
db.Quer(
"SELECT Name, Surname FROM Users WHERE idUsers='"
+ r.getString("Users_idUsers")
+ "';");
r1.first();
out.println("<tr class=\"tablelinkprof\">");
out.println("<td class=\"tablelinkprof\">");
out.println(
"<a target=\"tools\" href=\"ReadApp_msg.jsp?id="
+ r.getString("idMessages")
+ "&idu="
+ r.getString("Users_idUsers")
+ "\" class=\"boxlinkprof\">");
out.println("From: " + r1.getString("Name") + " " + r1.getString("Surname") + "<br/>");
out.println(
"<div style=\"text-align: center; padding-top: 3px; padding-bottom: 3px;\">Subject:</div>");
out.println("<div style=\"text-align: center;\">" + r.getString("Subject") + "</div>");
out.println("</a>");
out.println("</td>");
out.println("</tr>");
}
} catch (Exception e) {
e.printStackTrace();
}
String Query = "SELECT * FROM Messages WHERE ( ";
r =
db.Quer(
"SELECT idUsers_team FROM Users_team WHERE Team_idTeam='"
+ (String) session.getAttribute("teamid")
+ "' AND Users_idUsers!='"
+ (String) session.getAttribute("userid")
+ "';");
ArrayList<String> Wall = new ArrayList<String>();
try {
while (r.next()) {
Wall.add(r.getString("idUsers_team"));
}
for (int i = 0; i < Wall.size(); i++) {
Query += "( Users_team_idUsers_team='" + Wall.get(i) + "' AND ";
r1 =
db.Quer(
"SELECT Users_idUsers FROM Users_team WHERE idUsers_team='" + Wall.get(i) + "';");
r1.first();
Query += "Users_idUsers='" + r1.getString("Users_idUsers") + "' )";
if (i < (Wall.size() - 1)) Query += " OR ";
}
} catch (Exception e) {
e.printStackTrace();
}
Query += ") AND Messages.Read=0 ORDER BY Date ASC;";
r = db.Quer(Query);
try {
while (r.next()) {
r1 =
db.Quer(
"SELECT Name, Surname FROM Users WHERE idUsers='"
+ r.getString("Users_idUsers")
+ "';");
r1.first();
out.println("<tr class=\"tablelink\">");
out.println("<td class=\"tablelink\">");
out.println(
"<a target=\"tools\" href=\"ReadApp_msg.jsp?id="
+ r.getString("idMessages")
+ "&idu="
+ r.getString("Users_idUsers")
+ "\" class=\"boxlink\">");
out.println("From: " + r1.getString("Name") + " " + r1.getString("Surname") + "<br/>");
out.println(
"<div style=\"text-align: center; padding-top: 3px; padding-bottom: 3px;\">Subject:</div>");
out.println("<div style=\"text-align: center;\">" + r.getString("Subject") + "</div>");
out.println("</a>");
out.println("</td>");
out.println("</tr>");
}
} catch (Exception e) {
e.printStackTrace();
}
out.println("</table>");
}
