public EntityBean update(EntityBean eb) {
ItemDataBean idb = (ItemDataBean) eb;
idb.setActive(false);
HashMap variables = new HashMap();
variables.put(new Integer(1), new Integer(idb.getEventCRFId()));
variables.put(new Integer(2), new Integer(idb.getItemId()));
variables.put(new Integer(3), new Integer(idb.getStatus().getId()));
variables.put(new Integer(4), idb.getValue());
variables.put(new Integer(5), new Integer(idb.getUpdaterId()));
variables.put(new Integer(6), new Integer(idb.getId()));
this.execute(digester.getQuery("update"), variables);
if (isQuerySuccessful()) {
idb.setActive(true);
}
return idb;
}
@Override
public void processRequest() throws Exception {
FormProcessor fp = new FormProcessor(request);
int studySubId = fp.getInt(STUDY_SUB_ID, true);
int eventCRFId = fp.getInt(EVENT_CRF_ID);
String action = request.getParameter("action");
StudyEventDAO sedao = new StudyEventDAO(sm.getDataSource());
StudySubjectDAO subdao = new StudySubjectDAO(sm.getDataSource());
EventCRFDAO ecdao = new EventCRFDAO(sm.getDataSource());
StudyDAO sdao = new StudyDAO(sm.getDataSource());
if (eventCRFId == 0) {
addPageMessage(respage.getString("please_choose_an_event_CRF_to_delete"));
request.setAttribute("id", new Integer(studySubId).toString());
forwardPage(Page.VIEW_STUDY_SUBJECT_SERVLET);
} else {
EventCRFBean eventCRF = (EventCRFBean) ecdao.findByPK(eventCRFId);
StudySubjectBean studySub = (StudySubjectBean) subdao.findByPK(studySubId);
request.setAttribute("studySub", studySub);
// construct info needed on view event crf page
CRFDAO cdao = new CRFDAO(sm.getDataSource());
CRFVersionDAO cvdao = new CRFVersionDAO(sm.getDataSource());
int crfVersionId = eventCRF.getCRFVersionId();
CRFBean cb = cdao.findByVersionId(crfVersionId);
eventCRF.setCrf(cb);
CRFVersionBean cvb = (CRFVersionBean) cvdao.findByPK(crfVersionId);
eventCRF.setCrfVersion(cvb);
// then get the definition so we can call
// DisplayEventCRFBean.setFlags
int studyEventId = eventCRF.getStudyEventId();
StudyEventBean event = (StudyEventBean) sedao.findByPK(studyEventId);
int studyEventDefinitionId = sedao.getDefinitionIdFromStudyEventId(studyEventId);
StudyEventDefinitionDAO seddao = new StudyEventDefinitionDAO(sm.getDataSource());
StudyEventDefinitionBean sed =
(StudyEventDefinitionBean) seddao.findByPK(studyEventDefinitionId);
event.setStudyEventDefinition(sed);
request.setAttribute("event", event);
EventDefinitionCRFDAO edcdao = new EventDefinitionCRFDAO(sm.getDataSource());
StudyBean study = (StudyBean) sdao.findByPK(studySub.getStudyId());
EventDefinitionCRFBean edc =
edcdao.findByStudyEventDefinitionIdAndCRFId(study, studyEventDefinitionId, cb.getId());
DisplayEventCRFBean dec = new DisplayEventCRFBean();
dec.setEventCRF(eventCRF);
dec.setFlags(eventCRF, ub, currentRole, edc.isDoubleEntry());
// find all item data
ItemDataDAO iddao = new ItemDataDAO(sm.getDataSource());
dnDao = new DiscrepancyNoteDAO(sm.getDataSource());
ArrayList<ItemDataBean> itemData = iddao.findAllByEventCRFId(eventCRF.getId());
request.setAttribute("items", itemData);
if ("confirm".equalsIgnoreCase(action)) {
request.setAttribute("displayEventCRF", dec);
forwardPage(Page.DELETE_EVENT_CRF);
} else {
logger.info("submit to delete the event CRF from event");
// OC-6303 Deleting Event CRF resets Show / Hide logic
// delete records from DynamicItemForm and DynamicItemGroup
getDynamicsItemFormMetadataDao().delete(eventCRFId);
getDynamicsItemGroupMetadataDao().delete(eventCRFId);
eventCRF.setOldStatus(eventCRF.getStatus());
eventCRF.setStatus(Status.RESET);
eventCRF.setUpdater(ub);
ecdao.update(eventCRF);
for (ItemDataBean itemdata : itemData) {
// OC-6343 Rule behaviour must be reset if an Event CRF is deleted
// delete the records from ruleActionRunLogDao
getRuleActionRunLogDao().delete(itemdata.getId());
// OC-6344 Notes & Discrepancies must be set to "closed" when event CRF is deleted
// parentDiscrepancyNoteList is the list of the parent DNs records only
ArrayList<DiscrepancyNoteBean> parentDiscrepancyNoteList =
getDnDao().findParentNotesOnlyByItemData(itemdata.getId());
for (DiscrepancyNoteBean parentDiscrepancyNote : parentDiscrepancyNoteList) {
if (parentDiscrepancyNote.getResolutionStatusId()
!= 4) { // if the DN's resolution status is not set to Closed
String description = resword.getString("dn_auto-closed_description");
String detailedNotes = resword.getString("dn_auto_closed_detailed_notes");
// create new DN record , new DN Map record , also update the parent record
createDiscrepancyNoteBean(
description, detailedNotes, itemdata.getId(), study, ub, parentDiscrepancyNote);
}
}
iddao = new ItemDataDAO(sm.getDataSource());
ifmdao = new ItemFormMetadataDAO(sm.getDataSource());
ItemDataBean idBean = (ItemDataBean) iddao.findByPK(itemdata.getId());
ItemFormMetadataBean ifmBean =
ifmdao.findByItemIdAndCRFVersionId(idBean.getItemId(), crfVersionId);
// Updating Dn_item_data_map actovated column into false for the existing DNs
ArrayList<DiscrepancyNoteBean> dnBeans =
getDnDao().findExistingNotesForItemData(itemdata.getId());
if (dnBeans.size() != 0) {
DiscrepancyNoteBean dnBean = new DiscrepancyNoteBean();
dnBean.setEntityId(itemdata.getId());
dnBean.setActivated(false);
getDnDao().updateDnMapActivation(dnBean);
}
// Default Values are not addressed
itemdata.setValue("");
itemdata.setOldStatus(itemdata.getStatus());
itemdata.setOwner(ub);
itemdata.setStatus(Status.AVAILABLE);
itemdata.setUpdater(ub);
iddao.updateUser(itemdata);
iddao.update(itemdata);
}
// OC-6291 event_crf status change
eventCRF.setOldStatus(eventCRF.getStatus());
eventCRF.setStatus(Status.AVAILABLE);
eventCRF.setUpdater(ub);
ecdao.update(eventCRF);
if (event.getSubjectEventStatus().isCompleted()
|| event.getSubjectEventStatus().isSigned()) {
event.setSubjectEventStatus(SubjectEventStatus.DATA_ENTRY_STARTED);
event.setUpdater(ub);
sedao = new StudyEventDAO(sm.getDataSource());
sedao.update(event);
}
String emailBody =
respage.getString("the_event_CRF")
+ cb.getName()
+ respage.getString("has_been_deleted_from_the_event")
+ event.getStudyEventDefinition().getName()
+ ". "
+ respage.getString("has_been_deleted_from_the_event_cont");
addPageMessage(emailBody);
// sendEmail(emailBody);
request.setAttribute("id", new Integer(studySubId).toString());
forwardPage(Page.VIEW_STUDY_SUBJECT_SERVLET);
}
}
}
@Override
@SuppressWarnings(value = "unchecked")
public void processRequest() throws Exception {
ItemDataDAO itemDataDao = new ItemDataDAO(sm.getDataSource());
EventCRFDAO eventCrfDao = new EventCRFDAO(sm.getDataSource());
CrfBusinessLogicHelper crfBusinessLogicHelper = new CrfBusinessLogicHelper(sm.getDataSource());
String action = request.getParameter("action");
FormProcessor fp = new FormProcessor(request);
// checks which module the requests are from
String module = fp.getString(MODULE);
request.setAttribute(MODULE, module);
resetPanel();
panel.setStudyInfoShown(false);
panel.setOrderedData(true);
setToPanel(resword.getString("create_CRF"), respage.getString("br_create_new_CRF_entering"));
setToPanel(
resword.getString("create_CRF_version"), respage.getString("br_create_new_CRF_uploading"));
setToPanel(
resword.getString("revise_CRF_version"), respage.getString("br_if_you_owner_CRF_version"));
setToPanel(
resword.getString("CRF_spreadsheet_template"),
respage.getString("br_download_blank_CRF_spreadsheet_from"));
setToPanel(
resword.getString("example_CRF_br_spreadsheets"),
respage.getString("br_download_example_CRF_instructions_from"));
if ("confirm".equalsIgnoreCase(action)) {
List<DisplayItemBeanWrapper> displayItemBeanWrappers =
(List<DisplayItemBeanWrapper>) session.getAttribute("importedData");
logger.info("Size of displayItemBeanWrappers : " + displayItemBeanWrappers.size());
forwardPage(Page.VERIFY_IMPORT_CRF_DATA);
}
if ("save".equalsIgnoreCase(action)) {
List<DisplayItemBeanWrapper> displayItemBeanWrappers =
(List<DisplayItemBeanWrapper>) session.getAttribute("importedData");
// System.out.println("Size of displayItemBeanWrappers : " + displayItemBeanWrappers.size());
for (DisplayItemBeanWrapper wrapper : displayItemBeanWrappers) {
int eventCrfBeanId = -1;
EventCRFBean eventCrfBean = new EventCRFBean();
// TODO : tom , the wrapper object has all the necessary data -
// as you see we check the
// is to see if this data is Savable if it is then we go ahead
// and save it. if not we discard.
// So the change needs to happen here , instead of discarding we
// need to file discrepancy notes
// and save the data. If you look in the
// Page.VERIFY_IMPORT_CRF_DATA jsp file you can see how I am
// pulling the errors. and use that in the same way.
logger.info("right before we check to make sure it is savable: " + wrapper.isSavable());
if (wrapper.isSavable()) {
ArrayList<Integer> eventCrfInts = new ArrayList<Integer>();
// based on the use case: "If any of the data does not meet
// validations specified in the CRF
// Template, a discrepancy note is automatically logged.
// The DN will have a type of Failed Validation Check, and
// a message of Failed Validation check."
// System.out.println("wrapper problems found : " +
// wrapper.getValidationErrors().toString());
for (DisplayItemBean displayItemBean : wrapper.getDisplayItemBeans()) {
eventCrfBeanId = displayItemBean.getData().getEventCRFId();
eventCrfBean = (EventCRFBean) eventCrfDao.findByPK(eventCrfBeanId);
logger.info("found value here: " + displayItemBean.getData().getValue());
logger.info("found status here: " + eventCrfBean.getStatus().getName());
// System.out.println("found event crf bean name here: "
// +
// eventCrfBean.getEventName()+" id "+eventCrfBean.getId
// ());
// SO, items can be created in a wrapper which is set to
// overwrite
// we get around this by checking the bean first, to
// make sure it's not null
ItemDataBean itemDataBean = new ItemDataBean();
itemDataBean =
itemDataDao.findByItemIdAndEventCRFIdAndOrdinal(
displayItemBean.getItem().getId(),
eventCrfBean.getId(),
displayItemBean.getData().getOrdinal());
if (wrapper.isOverwrite() && itemDataBean.getStatus() != null) {
// ItemDataBean itemDataBean = new ItemDataBean();
// itemDataBean =
// itemDataDao.findByItemIdAndEventCRFIdAndOrdinal(
// displayItemBean.getItem().getId(),
// eventCrfBean.getId(), displayItemBean
// .getData().getOrdinal());
// itemDataBean =
// itemDataDao.findByEventCRFIdAndItemName(
// eventCrfBean,
// displayItemBean.getItem().getName());
logger.info(
"just tried to find item data bean on item name "
+ displayItemBean.getItem().getName());
itemDataBean.setUpdatedDate(new Date());
itemDataBean.setUpdater(ub);
itemDataBean.setValue(displayItemBean.getData().getValue());
// set status?
itemDataDao.update(itemDataBean);
logger.info("updated: " + itemDataBean.getItemId());
// need to set pk here in order to create dn
displayItemBean.getData().setId(itemDataBean.getId());
} else {
itemDataDao.create(displayItemBean.getData());
logger.info(
"created: "
+ displayItemBean.getData().getItemId()
+ "event CRF ID = "
+ eventCrfBean.getId()
+ "CRF VERSION ID ="
+ eventCrfBean.getCRFVersionId());
// does this dao function work for repeating
// events/groups?
// ItemDataBean itemDataBean =
// itemDataDao.findByEventCRFIdAndItemName(
// eventCrfBean,
// displayItemBean.getItem().getName());
ItemDataBean itemDataBean2 =
itemDataDao.findByItemIdAndEventCRFIdAndOrdinal(
displayItemBean.getItem().getId(),
eventCrfBean.getId(),
displayItemBean.getData().getOrdinal());
logger.info(
"found: id " + itemDataBean2.getId() + " name " + itemDataBean2.getName());
displayItemBean.getData().setId(itemDataBean2.getId());
}
// logger.info("created item data bean:
// "+displayItemBean.getData().getId());
// logger.info("created:
// "+displayItemBean.getData().getName());
// logger.info("continued:
// "+displayItemBean.getData().getItemId());
ItemDAO idao = new ItemDAO(sm.getDataSource());
ItemBean ibean = (ItemBean) idao.findByPK(displayItemBean.getData().getItemId());
// logger.info("continued2: getName " +
// ibean.getName());
// System.out.println("*** checking for validation errors: " + ibean.getName());
String itemOid =
displayItemBean.getItem().getOid()
+ "_"
+ wrapper.getStudyEventRepeatKey()
+ "_"
+ displayItemBean.getData().getOrdinal()
+ "_"
+ wrapper.getStudySubjectOid();
if (wrapper.getValidationErrors().containsKey(itemOid)) {
ArrayList messageList = (ArrayList) wrapper.getValidationErrors().get(itemOid);
// if
// (wrapper.getValidationErrors().containsKey(ibean
// .getName())) {
// ArrayList messageList = (ArrayList)
// wrapper.getValidationErrors
// ().get(ibean.getName());
// could be more then one will have to iterate
// could it be more than one? tbh 08/2008
for (int iter = 0; iter < messageList.size(); iter++) {
String message = (String) messageList.get(iter);
DiscrepancyNoteBean parentDn =
ImportSpringJob.createDiscrepancyNote(
ibean,
message,
eventCrfBean,
displayItemBean,
null,
ub,
sm.getDataSource(),
currentStudy);
ImportSpringJob.createDiscrepancyNote(
ibean,
message,
eventCrfBean,
displayItemBean,
parentDn.getId(),
ub,
sm.getDataSource(),
currentStudy);
// System.out.println("*** created disc note with message: " + message);
// displayItemBean);
}
}
// logger.info("created:
// "+displayItemBean.getDbData().getName());
if (!eventCrfInts.contains(new Integer(eventCrfBean.getId()))) {
crfBusinessLogicHelper.markCRFComplete(eventCrfBean, ub);
// System.out.println("*** just updated event crf bean: " + eventCrfBean.getId());
eventCrfInts.add(new Integer(eventCrfBean.getId()));
}
}
// end of item datas, tbh
// crfBusinessLogicHelper.markCRFComplete(eventCrfBean, ub);
// System .out.println("*** just updated event crf bean: "+
// eventCrfBean.getId());
// need to update the study event status as well, tbh
// crfBusinessLogicHelper.updateStudyEvent(eventCrfBean,
// ub);
// above should do it for us, tbh 08/2008
}
}
addPageMessage(respage.getString("data_has_been_successfully_import"));
// forwardPage(Page.SUBMIT_DATA_SERVLET);
forwardPage(Page.LIST_STUDY_SUBJECTS_SERVLET);
// replaced tbh, 06/2009
}
}
@Override
protected DisplayItemBean validateDisplayItemBean(
DiscrepancyValidator v, DisplayItemBean dib, String inputName) {
org.akaza.openclinica.bean.core.ResponseType rt =
dib.getMetadata().getResponseSet().getResponseType();
boolean isSingleItem = false;
if (StringUtil.isBlank(inputName)) { // for single items
inputName = getInputName(dib);
isSingleItem = true;
}
// we only give warning to user if data entered in DDE is different from
// IDE when the first
// time user hits 'save'
int keyId = ecb.getId();
Integer validationCount = (Integer) session.getAttribute(COUNT_VALIDATE + keyId);
ItemDataBean valueToCompare = dib.getData();
if (!isSingleItem) {
valueToCompare = dib.getDbData();
}
boolean showOriginalItem =
getItemMetadataService()
.isShown(dib.getItem().getId(), ecb, valueToCompare); // was dib.getData()
boolean showItem = dib.getMetadata().isShowItem();
boolean showDuplicateItem =
getItemMetadataService()
.hasPassedDDE(
dib.getMetadata(),
ecb,
valueToCompare); // .isShown(dib.getItem().getId(), ecb, dib.getDbData());// where
// is the set db data?
logger.debug(
"*** show original item has value "
+ dib.getData().getValue()
+ " and show item has value "
+ valueToCompare.getValue());
logger.debug(
"--- show original: "
+ showOriginalItem
+ " show duplicate: "
+ showDuplicateItem
+ " and just show item: "
+ showItem);
logger.debug("VALIDATION COUNT " + validationCount);
if (showOriginalItem && showDuplicateItem || showItem) {
// it should either be shown already, OR shown in the database?
// logger.debug("=== we passed, adding validation here");
Integer indValidationCount =
(Integer) session.getAttribute(COUNT_VALIDATE + keyId + dib.getMetadata().getId());
if (rt.equals(org.akaza.openclinica.bean.core.ResponseType.TEXT)
|| rt.equals(org.akaza.openclinica.bean.core.ResponseType.TEXTAREA)
|| rt.equals(org.akaza.openclinica.bean.core.ResponseType.FILE)) {
dib = validateDisplayItemBeanText(v, dib, inputName);
// necessary?
// if (indValidationCount == null || validationCount == null || validationCount.intValue()
// == 0) {
logger.debug("=== we passed, adding validation here TEXT " + valueToCompare.getId());
v.addValidation(
inputName, Validator.MATCHES_INITIAL_DATA_ENTRY_VALUE, valueToCompare, false);
v.setErrorMessage(
respage.getString("value_you_specified")
+ " "
+ valueToCompare.getValue()
+ " "
+ respage.getString("from_initial_data_entry"));
// session.setAttribute(COUNT_VALIDATE + keyId + dib.getMetadata().getId(), new Integer(1));
// }
} else if (rt.equals(org.akaza.openclinica.bean.core.ResponseType.RADIO)
|| rt.equals(org.akaza.openclinica.bean.core.ResponseType.SELECT)) {
dib = validateDisplayItemBeanSingleCV(v, dib, inputName);
// ItemFormMetadataBean ifmdb = dib.getMetadata();
// ResponseSetBean rsBean = ifmdb.getResponseSet();
// logger.info("### found a response set count of "+inputName+"
// "+rsBean.getOptions().size());
// TODO sees it at this end tbh 1878
// if (indValidationCount == null || validationCount == null || validationCount.intValue()
// == 0) {
logger.debug("=== we passed, adding validation here RADIO " + valueToCompare.getId());
v.addValidation(
inputName, Validator.MATCHES_INITIAL_DATA_ENTRY_VALUE, valueToCompare, false);
String errorValue = valueToCompare.getValue();
java.util.ArrayList options = dib.getMetadata().getResponseSet().getOptions();
for (int u = 0; u < options.size(); u++) {
ResponseOptionBean rob = (ResponseOptionBean) options.get(u);
if (rob.getValue().equals(errorValue)) {
errorValue = rob.getText();
}
}
v.setErrorMessage(
respage.getString("value_you_specified")
+ " "
+ errorValue
+ " "
+ respage.getString("from_initial_data_entry"));
// session.setAttribute(COUNT_VALIDATE + keyId + dib.getMetadata().getId(), new Integer(1));
// }
} else if (rt.equals(org.akaza.openclinica.bean.core.ResponseType.CHECKBOX)
|| rt.equals(org.akaza.openclinica.bean.core.ResponseType.SELECTMULTI)) {
dib = validateDisplayItemBeanMultipleCV(v, dib, inputName);
// if (indValidationCount == null || validationCount == null || validationCount.intValue()
// == 0) {
logger.debug("=== we passed, adding validation here CHECKBOX " + valueToCompare.getId());
v.addValidation(
inputName, Validator.MATCHES_INITIAL_DATA_ENTRY_VALUE, valueToCompare, true);
// repeated from above, tbh 112007
String errorValue = valueToCompare.getValue();
String errorTexts = "";
java.util.ArrayList options = dib.getMetadata().getResponseSet().getOptions();
for (int u = 0; u < options.size(); u++) {
ResponseOptionBean rob = (ResponseOptionBean) options.get(u);
if (errorValue.contains(rob.getValue())) {
errorTexts = errorTexts + rob.getText();
if (u < options.size() - 1) {
// the values for multi-select are seperated by
// comma
errorTexts = errorTexts + ", ";
}
}
}
v.setErrorMessage(
respage.getString("value_you_specified")
+ " "
+ errorTexts
+ " "
+ respage.getString("from_initial_data_entry"));
// session.setAttribute(COUNT_VALIDATE + keyId + dib.getMetadata().getId(), new Integer(1));
// }
}
}
// only load form value when an item is not in a group,
// if in group, the value is already loaded
// see formGroups = loadFormValueForItemGroup(digb,digbs,formGroups);
if (isSingleItem) {
dib = loadFormValue(dib);
}
return dib;
}
