src/org/cacert/gigi/pages/account/MailOverview.java

   1 package org.cacert.gigi.pages.account;
   2
   3 import java.io.IOException;
   4 import java.io.PrintWriter;
   5 import java.sql.PreparedStatement;
   6 import java.sql.ResultSet;
   7 import java.sql.SQLException;
   8 import java.util.HashMap;
   9 import java.util.Map;
  10
  11 import javax.servlet.http.HttpServletRequest;
  12 import javax.servlet.http.HttpServletResponse;
  13
  14 import org.cacert.gigi.Language;
  15 import org.cacert.gigi.User;
  16 import org.cacert.gigi.database.DatabaseConnection;
  17 import org.cacert.gigi.output.Outputable;
  18 import org.cacert.gigi.pages.LoginPage;
  19 import org.cacert.gigi.pages.Page;
  20
  21 public class MailOverview extends Page {
  22         public static final String DEFAULT_PATH = "/account/mails";
  23         private MailTable t;
  24
  25         public MailOverview(String title) {
  26                 super(title);
  27                 t = new MailTable("res", "us");
  28         }
  29
  30         @Override
  31         public void doGet(HttpServletRequest req, HttpServletResponse resp)
  32                         throws IOException {
  33                 final User us = LoginPage.getUser(req);
  34                 Language lang = Page.getLanguage(req);
  35                 int id = us.getId();
  36                 try {
  37                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  38                                         "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
  39                         ps.setInt(1, id);
  40                         ResultSet rs = ps.executeQuery();
  41                         HashMap<String, Object> vars = new HashMap<>();
  42                         vars.put("mailData", t);
  43                         vars.put("res", rs);
  44                         vars.put("us", us.getEmail());
  45                         getDefaultTemplate().output(resp.getWriter(), lang, vars);
  46                 } catch (SQLException e) {
  47                         e.printStackTrace();
  48                 }
  49         }
  50
  51         private class MailTable implements Outputable {
  52                 private String mails, userMail;
  53
  54                 public MailTable(String mails, String userMail) {
  55                         this.mails = mails;
  56                         this.userMail = userMail;
  57                 }
  58
  59                 @Override
  60                 public void output(PrintWriter out, Language l, Map<String, Object> vars) {
  61                         try {
  62                                 ResultSet rs = (ResultSet) vars.get(mails);
  63                                 String usM = (String) vars.get(userMail);
  64                                 while (rs.next()) {
  65                                         out.println("<tr>");
  66                                         out.println("<td class=\"DataTD\"><input type=\"radio\" name=\"emailid\" value=\"");
  67                                         int mailID = rs.getInt(1);
  68                                         out.print(mailID);
  69                                         out.print("\"/></td>");
  70                                         out.println("<td class=\"DataTD\">");
  71                                         if (rs.getString(7).isEmpty()) {
  72                                                 out.print(l.getTranslation("Verified"));
  73                                         } else {
  74                                                 out.print(l.getTranslation("Unverified"));
  75                                         }
  76                                         out.print("</td>");
  77                                         out.println("<td class=\"DataTD\">");
  78                                         String address = rs.getString(3);
  79                                         if (usM.equals(address)) {
  80                                                 out.print(l.getTranslation("N/A"));
  81                                         } else {
  82                                                 out.print("<input type=\"checkbox\" name=\"delid[]\" value=\"");
  83                                                 out.print(mailID);
  84                                                 out.print("\"/>");
  85                                         }
  86                                         out.print("</td>");
  87                                         out.println("<td>");
  88                                         out.print(address);
  89                                         out.print("</td>");
  90                                         out.println("</tr>");
  91                                 }
  92                         } catch (SQLException e) {
  93                                 e.printStackTrace();
  94                         }
  95                 }
  96
  97         }
  98 }