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) throws IOException {
  32                 final User us = LoginPage.getUser(req);
  33                 Language lang = Page.getLanguage(req);
  34                 int id = us.getId();
  35                 try {
  36                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  37                                 "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
  38                         ps.setInt(1, id);
  39                         ResultSet rs = ps.executeQuery();
  40                         HashMap<String, Object> vars = new HashMap<>();
  41                         vars.put("mailData", t);
  42                         vars.put("res", rs);
  43                         vars.put("us", us.getEmail());
  44                         vars.put("addForm", new MailAddForm(req));
  45                         vars.put("manForm", new MailManagementForm(req));
  46                         getDefaultTemplate().output(resp.getWriter(), lang, vars);
  47                 } catch (SQLException e) {
  48                         e.printStackTrace();
  49                 }
  50         }
  51
  52         @Override
  53         public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
  54                 System.out.println();
  55                 super.doPost(req, resp);
  56         }
  57
  58         private class MailTable implements Outputable {
  59                 private String mails, userMail;
  60
  61                 public MailTable(String mails, String userMail) {
  62                         this.mails = mails;
  63                         this.userMail = userMail;
  64                 }
  65
  66                 @Override
  67                 public void output(PrintWriter out, Language l, Map<String, Object> vars) {
  68                         try {
  69                                 ResultSet rs = (ResultSet) vars.get(mails);
  70                                 String usM = (String) vars.get(userMail);
  71                                 while (rs.next()) {
  72                                         out.println("<tr>");
  73                                         out.println("<td><input type=\"radio\" name=\"emailid\" value=\"");
  74                                         int mailID = rs.getInt(1);
  75                                         out.print(mailID);
  76                                         out.print("\"/></td>");
  77                                         out.println("<td>");
  78                                         if (rs.getString(7).isEmpty()) {
  79                                                 out.print(l.getTranslation("Verified"));
  80                                         } else {
  81                                                 out.print(l.getTranslation("Unverified"));
  82                                         }
  83                                         out.print("</td>");
  84                                         out.println("<td>");
  85                                         String address = rs.getString(3);
  86                                         if (usM.equals(address)) {
  87                                                 out.print(l.getTranslation("N/A"));
  88                                         } else {
  89                                                 out.print("<input type=\"checkbox\" name=\"delid[]\" value=\"");
  90                                                 out.print(mailID);
  91                                                 out.print("\"/>");
  92                                         }
  93                                         out.print("</td>");
  94                                         out.println("<td>");
  95                                         out.print(address);
  96                                         out.print("</td>");
  97                                         out.println("</tr>");
  98                                 }
  99                         } catch (SQLException e) {
 100                                 e.printStackTrace();
 101                         }
 102                 }
 103
 104         }
 105 }