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