1 package org.cacert.gigi.pages.account;
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;
11 import javax.servlet.http.HttpServletRequest;
12 import javax.servlet.http.HttpServletResponse;
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;
22 public class MailOverview extends Page {
23 public static final String DEFAULT_PATH = "/account/mails";
26 public MailOverview(String title) {
28 t = new MailTable("res", "us");
32 public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
33 final User us = LoginPage.getUser(req);
34 Language lang = Page.getLanguage(req);
37 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
38 "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
40 ResultSet rs = ps.executeQuery();
41 HashMap<String, Object> vars = new HashMap<>();
42 vars.put("mailData", t);
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) {
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);
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);
67 super.doPost(req, resp);
70 private class MailTable implements Outputable {
71 private String mails, userMail;
73 public MailTable(String mails, String userMail) {
75 this.userMail = userMail;
79 public void output(PrintWriter out, Language l, Map<String, Object> vars) {
81 ResultSet rs = (ResultSet) vars.get(mails);
82 String usM = (String) vars.get(userMail);
85 out.println("<td><input type=\"radio\" name=\"emailid\" value=\"");
86 int mailID = rs.getInt(1);
88 out.print("\"/></td>");
90 if (rs.getString(7).isEmpty()) {
91 out.print(l.getTranslation("Verified"));
93 out.print(l.getTranslation("Unverified"));
97 String address = rs.getString(3);
98 if (usM.equals(address)) {
99 out.print(l.getTranslation("N/A"));
101 out.print("<input type=\"checkbox\" name=\"delid[]\" value=\"");
109 out.println("</tr>");
111 } catch (SQLException e) {