@RequestMapping("/admin-add-group") public String addGroup( @ModelAttribute InvitationGroup group, @RequestParam("groupLanguage") String language) { if (StringUtils.hasText(group.getGroupName())) { group.setId(randomId()); group.setLanguage(language); db.create(group); } return "redirect:admin"; }
@RequestMapping("/bulk-invite") public String bulkInvite(@RequestParam("invitees") MultipartFile invitees) throws Exception { if (!invitees.isEmpty()) { Map<String, InvitationGroup> groupsByName = new HashMap<String, InvitationGroup>(); ViewQuery query = new ViewQuery().designDocId("_design/groups").viewName("groups").includeDocs(true); for (InvitationGroup existing : db.queryView(query, InvitationGroup.class)) { groupsByName.put(standardizeName(existing.getGroupName()), existing); } BufferedReader r = new BufferedReader(new InputStreamReader(invitees.getInputStream())); for (String row = r.readLine(); row != null; row = r.readLine()) { String[] cells = row.split(","); if (cells[0].equals("Group Name")) continue; if (!(StringUtils.hasText(cells[0]) && StringUtils.hasText(cells[1]) && StringUtils.hasText(cells[2]))) throw new RuntimeException("Malformed row: " + row); if (cells[0].startsWith("\"") && cells[0].endsWith("\"")) cells[0] = cells[0].substring(1, cells[0].length() - 1); InvitationGroup group = groupsByName.get(cells[0].trim()); if (group == null) { group = new InvitationGroup(); group.setGroupName(cells[0].trim()); throw new RuntimeException("Only updates now! Couldn't find " + cells[0]); } group.setEmail(cells[1].trim()); group.setLanguage(cells[2].trim()); group.setInvitedTours(StringUtils.hasText(cells[3])); group.setInvitedRehearsal(StringUtils.hasText(cells[4])); if (group.getInvitees() != null) group.getInvitees().clear(); for (int i = 5; i < cells.length; ++i) { if (StringUtils.hasText(cells[i].trim())) { Invitee invitee = new Invitee(); invitee.setName(cells[i].trim()); group.addInvitee(invitee); } } if (group.getInvitees().size() == 0) throw new RuntimeException("Group with no invitees: " + row); if (group.getId() == null) { group.setId(randomId()); db.create(group); System.out.println("Created " + group.getGroupName()); } else { db.update(group); System.out.println("Updated " + group.getId() + " " + group.getGroupName()); } } } return "redirect:admin"; }