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.EmailAddress;
  15 import org.cacert.gigi.Language;
  16 import org.cacert.gigi.User;
  17 import org.cacert.gigi.database.DatabaseConnection;
  18 import org.cacert.gigi.output.Form;
  19 import org.cacert.gigi.output.Outputable;
  20 import org.cacert.gigi.pages.LoginPage;
  21 import org.cacert.gigi.pages.Page;
  22 import org.cacert.gigi.util.RandomToken;
  23
  24 public class MailOverview extends Page {
  25         public static final String DEFAULT_PATH = "/account/mails";
  26         private MailTable t;
  27
  28         public MailOverview(String title) {
  29                 super(title);
  30                 t = new MailTable("res", "us");
  31         }
  32
  33         @Override
  34         public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
  35                 final User us = LoginPage.getUser(req);
  36                 Language lang = Page.getLanguage(req);
  37                 int id = us.getId();
  38                 try {
  39                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  40                                 "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
  41                         ps.setInt(1, id);
  42                         ResultSet rs = ps.executeQuery();
  43                         HashMap<String, Object> vars = new HashMap<>();
  44                         vars.put("mailData", t);
  45                         vars.put("res", rs);
  46                         vars.put("us", us.getEmail());
  47                         vars.put("addForm", new MailAddForm(req));
  48                         vars.put("manForm", new MailManagementForm(req));
  49                         getDefaultTemplate().output(resp.getWriter(), lang, vars);
  50                 } catch (SQLException e) {
  51                         e.printStackTrace();
  52                 }
  53         }
  54
  55         @Override
  56         public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
  57                 PrintWriter out = resp.getWriter();
  58                 User us = LoginPage.getUser(req);
  59                 if (req.getParameter("addmail") != null) {
  60                         MailAddForm f = Form.getForm(req, MailAddForm.class);
  61                         if (f.submit(out, req)) {
  62                                 EmailAddress addr = new EmailAddress(f.getMail(), us, RandomToken.generateToken(16));
  63                                 addr.insert(Page.getLanguage(req));
  64                         }
  65                 } else if (req.getParameter("makedefault") != null || req.getParameter("delete") != null) {
  66                         System.out.println("MakeDefault/Delete");
  67                         MailManagementForm f = Form.getForm(req, MailManagementForm.class);
  68                         f.submit(out, req);
  69                 }
  70                 super.doPost(req, resp);
  71         }
  72
  73         private class MailTable implements Outputable {
  74                 private String mails, userMail;
  75
  76                 public MailTable(String mails, String userMail) {
  77                         this.mails = mails;
  78                         this.userMail = userMail;
  79                 }
  80
  81                 @Override
  82                 public void output(PrintWriter out, Language l, Map<String, Object> vars) {
  83                         try {
  84                                 ResultSet rs = (ResultSet) vars.get(mails);
  85                                 String usM = (String) vars.get(userMail);
  86                                 while (rs.next()) {
  87                                         out.println("<tr>");
  88                                         out.println("<td><input type=\"radio\" name=\"emailid\" value=\"");
  89                                         int mailID = rs.getInt(1);
  90                                         out.print(mailID);
  91                                         out.print("\"/></td>");
  92                                         out.println("<td>");
  93                                         if (rs.getString(7).isEmpty()) {
  94                                                 out.print(l.getTranslation("Verified"));
  95                                         } else {
  96                                                 out.print(l.getTranslation("Unverified"));
  97                                         }
  98                                         out.print("</td>");
  99                                         out.println("<td>");
 100                                         String address = rs.getString(3);
 101                                         if (usM.equals(address)) {
 102                                                 out.print(l.getTranslation("N/A"));
 103                                         } else {
 104                                                 out.print("<input type=\"checkbox\" name=\"delid[]\" value=\"");
 105                                                 out.print(mailID);
 106                                                 out.print("\"/>");
 107                                         }
 108                                         out.print("</td>");
 109                                         out.println("<td>");
 110                                         out.print(address);
 111                                         out.print("</td>");
 112                                         out.println("</tr>");
 113                                 }
 114                         } catch (SQLException e) {
 115                                 e.printStackTrace();
 116                         }
 117                 }
 118
 119         }
 120 }