private DiscrepancyNote createQuery(QueryServiceHelperBean helperBean, QueryBean queryBean)
throws Exception {
DiscrepancyNote dn = new DiscrepancyNote();
dn.setStudy(helperBean.getContainer().getStudy());
dn.setEntityType("itemData");
dn.setDescription("description");
dn.setDetailedNotes(queryBean.getComment());
dn.setDiscrepancyNoteType(new DiscrepancyNoteType(3));
if (queryBean.getStatus().equals("new")) {
dn.setResolutionStatus(resolutionStatusDao.findById(1));
} else if (queryBean.getStatus().equals("updated")) {
dn.setResolutionStatus(resolutionStatusDao.findById(2));
} else if (queryBean.getStatus().equals("closed")) {
dn.setResolutionStatus(resolutionStatusDao.findById(4));
}
String assignedTo = queryBean.getAssigned_to();
if (!StringUtils.isEmpty(assignedTo)) {
int endIndex = assignedTo.indexOf(")");
int begIndex = assignedTo.indexOf("(");
String userName = assignedTo.substring(begIndex + 1, endIndex);
UserAccount userAccount = userAccountDao.findByUserName(userName);
helperBean.setUserAccount(userAccount);
dn.setUserAccount(userAccount);
}
dn.setUserAccountByOwnerId(helperBean.getContainer().getUser());
// create itemData when a query is created without an autosaved itemdata
if (helperBean.getItemData() == null) {
helperBean.setItemData(createBlankItemData(helperBean));
}
dn.setDateCreated(new Date());
return dn;
}
private void saveQueryItemDatamap(QueryServiceHelperBean helperBean) {
// Create Mapping for new Discrepancy Note
DnItemDataMapId dnItemDataMapId = new DnItemDataMapId();
dnItemDataMapId.setDiscrepancyNoteId(helperBean.getDn().getDiscrepancyNoteId());
dnItemDataMapId.setItemDataId(helperBean.getItemData().getItemDataId());
dnItemDataMapId.setStudySubjectId(helperBean.getContainer().getSubject().getStudySubjectId());
dnItemDataMapId.setColumnName("value");
DnItemDataMap mapping = new DnItemDataMap();
mapping.setDnItemDataMapId(dnItemDataMapId);
mapping.setItemData(helperBean.getItemData());
mapping.setStudySubject(helperBean.getContainer().getSubject());
mapping.setActivated(false);
mapping.setDiscrepancyNote(helperBean.getDn());
dnItemDataMapDao.saveOrUpdate(mapping);
// updateParentQuery(helperBean);
}
private ItemData getItemData(QueryServiceHelperBean helperBean) {
ItemData id =
itemDataDao.findByEventCrfItemName(
helperBean.getContainer().getEventCrf().getEventCrfId(),
helperBean.getParentElementName(),
helperBean.getItemOrdinal());
return id;
}
private ItemData createBlankItemData(QueryServiceHelperBean helperBean) {
Item item =
itemDao.findByNameCrfId(
helperBean.getParentElementName(),
helperBean.getContainer().getCrfVersion().getCrf().getCrfId());
ItemData itemData = new ItemData();
itemData.setItem(item);
itemData.setEventCrf(helperBean.getContainer().getEventCrf());
itemData.setValue("");
itemData.setDateCreated(new Date());
itemData.setStatus(Status.AVAILABLE);
// TODO this value should change once you have an ordinal attribute specified in the query
itemData.setOrdinal(helperBean.getItemOrdinal());
itemData.setUserAccount(helperBean.getUserAccount());
itemData.setDeleted(false);
itemDataDao.saveOrUpdate(itemData);
return itemData;
}
private void prepareEmail(QueryServiceHelperBean helperBean) throws Exception {
StringBuffer message = new StringBuffer();
message.append(
MessageFormat.format(
respage.getString("mailDNHeader"),
helperBean.getUserAccount().getFirstName(),
helperBean.getUserAccount().getLastName()));
message.append(
"<A HREF='"
+ SQLInitServlet.getField("sysURL.base")
+ "ViewNotes?module=submit&listNotes_f_discrepancyNoteBean.user="******"&listNotes_f_entityName="
+ helperBean.getParentElementName()
+ "'>"
+ SQLInitServlet.getField("sysURL.base")
+ "</A><BR/>");
message.append(respage.getString("you_received_this_from"));
message.append(respage.getString("email_body_separator"));
message.append(respage.getString("disc_note_info"));
message.append(respage.getString("email_body_separator"));
message.append(
MessageFormat.format(
respage.getString("mailDNParameters1"),
helperBean.getDn().getDescription(),
helperBean.getDn().getDetailedNotes(),
helperBean.getUserAccount().getUserName()));
message.append(respage.getString("email_body_separator"));
message.append(respage.getString("entity_information"));
message.append(respage.getString("email_body_separator"));
message.append(
MessageFormat.format(
respage.getString("mailDNParameters2"),
helperBean.getDn().getStudy().getName(),
helperBean.getDn().getDescription()));
if (!("studySub".equalsIgnoreCase(helperBean.getDn().getEntityType())
|| "subject".equalsIgnoreCase(helperBean.getDn().getEntityType()))) {
message.append(
MessageFormat.format(
respage.getString("mailDNParameters3"),
helperBean.getContainer().getStudyEvent().getStudyEventDefinition().getName()));
if (!"studyEvent".equalsIgnoreCase(helperBean.getDn().getEntityType())) {
message.append(
MessageFormat.format(
respage.getString("mailDNParameters4"),
helperBean.getContainer().getCrfVersion().getCrf().getName()));
if (!"eventCrf".equalsIgnoreCase(helperBean.getDn().getEntityType())) {
message.append(
MessageFormat.format(
respage.getString("mailDNParameters6"), helperBean.getParentElementName()));
}
}
}
message.append(respage.getString("email_body_separator"));
message.append(
MessageFormat.format(
respage.getString("mailDNThanks"), helperBean.getDn().getStudy().getName()));
message.append(respage.getString("email_body_separator"));
message.append(respage.getString("disclaimer"));
message.append(respage.getString("email_body_separator"));
message.append(respage.getString("email_footer"));
String subject =
MessageFormat.format(
respage.getString("mailDNSubject"),
helperBean.getDn().getStudy().getName(),
helperBean.getParentElementName());
String emailBodyString = message.toString();
try {
sendEmail(helperBean.getUserAccount().getEmail().trim(), subject, emailBodyString, true);
} catch (Exception e) {
logger.error(e.getMessage());
throw e;
}
}