import org.cacert.gigi.output.Menu;
import org.cacert.gigi.output.PageMenuItem;
import org.cacert.gigi.output.SimpleMenuItem;
+import org.cacert.gigi.output.template.Form.CSRFException;
import org.cacert.gigi.output.template.Outputable;
import org.cacert.gigi.output.template.Template;
-import org.cacert.gigi.output.template.Form.CSRFException;
import org.cacert.gigi.pages.LoginPage;
import org.cacert.gigi.pages.LogoutPage;
import org.cacert.gigi.pages.MainPage;
import org.cacert.gigi.pages.account.domain.DomainOverview;
import org.cacert.gigi.pages.account.mail.MailOverview;
import org.cacert.gigi.pages.admin.TTPAdminPage;
+import org.cacert.gigi.pages.admin.support.FindDomainPage;
+import org.cacert.gigi.pages.admin.support.FindUserPage;
+import org.cacert.gigi.pages.admin.support.SupportUserDetailsPage;
import org.cacert.gigi.pages.error.AccessDenied;
import org.cacert.gigi.pages.error.PageNotFound;
import org.cacert.gigi.pages.main.RegisterPage;
putPage(TTPAdminPage.PATH + "/*", new TTPAdminPage(), "Admin");
putPage(CreateOrgPage.DEFAULT_PATH, new CreateOrgPage(), "Organisation Admin");
putPage(ViewOrgPage.DEFAULT_PATH + "/*", new ViewOrgPage(), "Organisation Admin");
+ putPage(FindDomainPage.PATH, new FindDomainPage("Find Domain"), "System Admin");
+ putPage(FindUserPage.PATH, new FindUserPage("Find User"), "System Admin");
+ putPage(SupportUserDetailsPage.PATH + "*", new SupportUserDetailsPage("Support: User Details"), null);
if (testing) {
try {
Class<?> manager = Class.forName("org.cacert.gigi.pages.Manager");
import java.util.Calendar;
import java.util.Collections;
import java.util.HashSet;
+import java.util.LinkedList;
import java.util.List;
import java.util.Locale;
import java.util.Set;
return User.getById(rs.getInt(1));
}
+ public static User[] findByEmail(String mail) {
+ LinkedList<User> results = new LinkedList<User>();
+ GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT users.id FROM users inner join certOwners on certOwners.id=users.id WHERE users.email LIKE ? AND deleted is null GROUP BY users.id ASC LIMIT 100");
+ ps.setString(1, mail);
+ GigiResultSet rs = ps.executeQuery();
+ while (rs.next()) {
+ results.add(User.getById(rs.getInt(1)));
+ System.out.println("Found user");
+ }
+ return results.toArray(new User[results.size()]);
+ }
+
public boolean canIssue(CertificateProfile p) {
switch (p.getCAId()) {
case 0:
return false;
}
}
+
}
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import java.io.PrintWriter;
+import java.util.Map;
+
+import javax.servlet.http.HttpServletRequest;
+
+import org.cacert.gigi.GigiApiException;
+import org.cacert.gigi.dbObjects.Domain;
+import org.cacert.gigi.localisation.Language;
+import org.cacert.gigi.output.template.Form;
+import org.cacert.gigi.output.template.Template;
+
+public class FindDomainForm extends Form {
+
+ private int userId = -1;
+
+ private static Template t;
+ static {
+ t = new Template(FindDomainForm.class.getResource("FindDomainForm.templ"));
+ }
+
+ public FindDomainForm(HttpServletRequest hsr) {
+ super(hsr);
+ }
+
+ @Override
+ public boolean submit(PrintWriter out, HttpServletRequest req) throws GigiApiException {
+ String request = req.getParameter("domain");
+ if (request.matches("#[0-9]+")) {
+ try {
+ Domain domainById = Domain.getById(Integer.parseInt(request.substring(1)));
+ userId = domainById.getOwner().getId();
+ } catch (IllegalArgumentException e) {
+ throw (new GigiApiException("No personal domains found matching the id " + request.substring(1) + "."));
+ }
+ } else {
+ userId = Domain.searchUserIdByDomain(request);
+ }
+ if (userId == -1) {
+ throw (new GigiApiException("No personal domains found matching " + request));
+ }
+ return true;
+ }
+
+ @Override
+ protected void outputContent(PrintWriter out, Language l, Map<String, Object> vars) {
+ t.output(out, l, vars);
+ }
+
+ public int getUserId() {
+ return userId;
+ }
+
+}
--- /dev/null
+<table class="wrapper dataTable">
+ <tbody><tr>
+ <th colspan="2"><?=_Find User by Domain?></th>
+ </tr>
+ <tr>
+ <td><?=_Domain?>:</td>
+ <td><input type="text" value="" name="domain" placeholder="<?=_For search by ID use # prefix e.g. #123456?>"></td>
+ </tr>
+ <tr>
+ <td colspan="2"><input type="submit" value="<?=_Next?>" name="process"></td>
+ </tr>
+</tbody>
+</table>
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import org.cacert.gigi.output.template.Form;
+import org.cacert.gigi.pages.OneFormPage;
+
+public class FindDomainPage extends OneFormPage {
+
+ public static final String PATH = "/support/find/domain";
+
+ public FindDomainPage(String title) {
+ super(title, FindDomainForm.class);
+ }
+
+ @Override
+ public String getSuccessPath(Form f) {
+ return SupportUserDetailsPage.PATH + ((FindDomainForm) f).getUserId();
+ }
+}
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import java.io.PrintWriter;
+import java.util.Map;
+
+import javax.servlet.http.HttpServletRequest;
+
+import org.cacert.gigi.GigiApiException;
+import org.cacert.gigi.dbObjects.User;
+import org.cacert.gigi.localisation.Language;
+import org.cacert.gigi.output.template.Form;
+import org.cacert.gigi.output.template.Template;
+
+public class FindUserForm extends Form {
+
+ private User users[];
+
+ private static Template t;
+ static {
+ t = new Template(FindDomainForm.class.getResource("FindUserForm.templ"));
+ }
+
+ public FindUserForm(HttpServletRequest hsr) {
+ super(hsr);
+ }
+
+ @Override
+ public boolean submit(PrintWriter out, HttpServletRequest req) throws GigiApiException {
+ User[] users = User.findByEmail(req.getParameter("email"));
+ if (users.length == 0) {
+ throw (new GigiApiException("No users found matching " + req.getParameter("email")));
+ }
+ this.users = users;
+ return true;
+ }
+
+ @Override
+ protected void outputContent(PrintWriter out, Language l, Map<String, Object> vars) {
+ t.output(out, l, vars);
+ }
+
+ public User[] getUsers() {
+ return users;
+ }
+
+}
--- /dev/null
+<? if($usertable) {?>
+<p>Multiple users where found.</p>
+<table class="dataTable wrapper">
+<tr>
+<th>Id</th><th>E-Mail</th></tr>
+<? foreach($usertable) {?>
+ <tr><td><a href="/support/user/<?=$usrid?>"><?=$usrid?></a></td><td><a href="/support/user/<?=$usrid?>"><?=$usermail?></a></td></tr>
+<? } ?>
+</table>
+<? } ?>
+<? if($first) {?>
+<table class="wrapper dataTable">
+ <tbody><tr>
+ <th colspan="2"><?=_Find User?></th>
+ </tr>
+ <tr>
+ <td><?=_Email?>:</td>
+ <td><input name="email" value="" size="30" title="<?=_use % as wildcard?>" placeholder="<?=_use % as wildcard?>" type="text"/></td>
+ </tr>
+ <tr>
+ <td colspan="2"><input name="process" value="<?=_Next?>" type="submit"/></td>
+ </tr>
+</tbody></table>
+<? } ?>
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import java.io.IOException;
+import java.util.HashMap;
+import java.util.Map;
+
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.cacert.gigi.GigiApiException;
+import org.cacert.gigi.dbObjects.User;
+import org.cacert.gigi.localisation.Language;
+import org.cacert.gigi.output.template.Form;
+import org.cacert.gigi.output.template.IterableDataset;
+import org.cacert.gigi.pages.Page;
+
+public class FindUserPage extends Page {
+
+ public static final String PATH = "/support/find/user";
+
+ public FindUserPage(String title) {
+ super(title);
+ }
+
+ @Override
+ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
+ HashMap<String, Object> vars = new HashMap<String, Object>();
+ vars.put("first", true);
+ new FindUserForm(req).output(resp.getWriter(), Page.getLanguage(req), vars);
+ }
+
+ @Override
+ public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
+ FindUserForm form = Form.getForm(req, FindUserForm.class);
+ try {
+ form.submit(resp.getWriter(), req);
+ final User[] users = form.getUsers();
+ if (users.length == 1) {
+ resp.sendRedirect(SupportUserDetailsPage.PATH + users[0].getId());
+ } else {
+ HashMap<String, Object> vars = new HashMap<String, Object>();
+ vars.put("first", false);
+ vars.put("usertable", new IterableDataset() {
+
+ int i = 0;
+
+ @Override
+ public boolean next(Language l, Map<String, Object> vars) {
+ if (i == users.length) {
+ return false;
+ }
+ vars.put("usrid", users[i].getId());
+ vars.put("usermail", users[i].getEmail());
+ i++;
+ return true;
+ }
+ });
+ form.output(resp.getWriter(), getLanguage(req), vars);
+ }
+ } catch (GigiApiException e) {
+ e.format(resp.getWriter(), Page.getLanguage(req));
+ doGet(req, resp);
+ }
+ }
+
+}
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import java.io.PrintWriter;
+import java.util.Map;
+
+import javax.servlet.http.HttpServletRequest;
+
+import org.cacert.gigi.GigiApiException;
+import org.cacert.gigi.localisation.Language;
+import org.cacert.gigi.output.template.Form;
+
+public class SupportUserDetailsForm extends Form {
+
+ public SupportUserDetailsForm(HttpServletRequest hsr) {
+ super(hsr);
+ }
+
+ @Override
+ public boolean submit(PrintWriter out, HttpServletRequest req) throws GigiApiException {
+ return false;
+ }
+
+ @Override
+ protected void outputContent(PrintWriter out, Language l, Map<String, Object> vars) {}
+
+}
--- /dev/null
+package org.cacert.gigi.pages.admin.support;
+
+import java.io.IOException;
+
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import org.cacert.gigi.pages.Page;
+
+public class SupportUserDetailsPage extends Page {
+
+ public static final String PATH = "/support/user/";
+
+ public SupportUserDetailsPage(String title) {
+ super(title);
+ }
+
+ @Override
+ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {}
+
+}