Examples with StudyEventDAO org.akaza.openclinica.dao.managestudy.StudyEventDAO used on opensource projects

Example 56 with StudyEventDAO

use of org.akaza.openclinica.dao.managestudy.StudyEventDAO in project OpenClinica by OpenClinica.

the class ViewStudySubjectServlet method getDisplayEventCRFs.

/**
     * Each of the event CRFs with its corresponding CRFBean. Then generates a
     * list of DisplayEventCRFBeans, one for each event CRF.
     *
     * @param eventCRFs
     *            The list of event CRFs for this study event.
     * @param eventDefinitionCRFs
     *            The list of event definition CRFs for this study event.
     * @return The list of DisplayEventCRFBeans for this study event.
     */
public static ArrayList getDisplayEventCRFs(DataSource ds, ArrayList eventCRFs, ArrayList eventDefinitionCRFs, UserAccountBean ub, StudyUserRoleBean currentRole, SubjectEventStatus status, StudyBean study) {
    ArrayList answer = new ArrayList();
    // HashMap definitionsById = new HashMap();
    int i;
    /*
         * for (i = 0; i < eventDefinitionCRFs.size(); i++) {
         * EventDefinitionCRFBean edc = (EventDefinitionCRFBean)
         * eventDefinitionCRFs.get(i); definitionsById.put(new
         * Integer(edc.getStudyEventDefinitionId()), edc); }
         */
    StudyEventDAO sedao = new StudyEventDAO(ds);
    CRFDAO cdao = new CRFDAO(ds);
    CRFVersionDAO cvdao = new CRFVersionDAO(ds);
    FormLayoutDAO fldao = new FormLayoutDAO(ds);
    ItemDataDAO iddao = new ItemDataDAO(ds);
    EventDefinitionCRFDAO edcdao = new EventDefinitionCRFDAO(ds);
    for (i = 0; i < eventCRFs.size(); i++) {
        EventCRFBean ecb = (EventCRFBean) eventCRFs.get(i);
        // populate the event CRF with its crf bean
        int crfVersionId = ecb.getCRFVersionId();
        int formLayoutId = ecb.getFormLayoutId();
        CRFBean cb = cdao.findByLayoutId(formLayoutId);
        ecb.setCrf(cb);
        CRFVersionBean cvb = (CRFVersionBean) cvdao.findByPK(crfVersionId);
        ecb.setCrfVersion(cvb);
        FormLayoutBean flb = (FormLayoutBean) fldao.findByPK(formLayoutId);
        ecb.setFormLayout(flb);
        // then get the definition so we can call
        // DisplayEventCRFBean.setFlags
        int studyEventId = ecb.getStudyEventId();
        int studyEventDefinitionId = sedao.getDefinitionIdFromStudyEventId(studyEventId);
        // EventDefinitionCRFBean edc = (EventDefinitionCRFBean)
        // definitionsById.get(new Integer(
        // studyEventDefinitionId));
        // fix problem of the above code(commented out), find the correct
        // edc, note that on definitionId can be related to multiple
        // eventdefinitioncrfBeans
        EventDefinitionCRFBean edc = edcdao.findByStudyEventDefinitionIdAndCRFId(study, studyEventDefinitionId, cb.getId());
        // rules updated 112007 tbh
        if (status.equals(SubjectEventStatus.LOCKED) || status.equals(SubjectEventStatus.SKIPPED) || status.equals(SubjectEventStatus.STOPPED)) {
            ecb.setStage(DataEntryStage.LOCKED);
        // we need to set a SED-wide flag here, because other edcs
        // in this event can be filled in and change the status, tbh
        } else if (status.equals(SubjectEventStatus.INVALID)) {
            ecb.setStage(DataEntryStage.LOCKED);
        } else if (!cb.getStatus().equals(Status.AVAILABLE)) {
            ecb.setStage(DataEntryStage.LOCKED);
        } else if (!cvb.getStatus().equals(Status.AVAILABLE)) {
            ecb.setStage(DataEntryStage.LOCKED);
        }
        // TODO need to refactor since this is similar to other code, tbh
        if (edc != null) {
            // System.out.println("edc is not null, need to set flags");
            DisplayEventCRFBean dec = new DisplayEventCRFBean();
            dec.setEventDefinitionCRF(edc);
            // System.out.println("edc.isDoubleEntry()" +
            // edc.isDoubleEntry() + ecb.getId());
            dec.setFlags(ecb, ub, currentRole, edc.isDoubleEntry());
            if (dec.isLocked()) {
            // System.out.println("*** found a locked DEC:
            // "+edc.getCrfName());
            }
            ArrayList idata = iddao.findAllByEventCRFId(ecb.getId());
            if (!idata.isEmpty()) {
                // consider an event crf started only if item data get
                // created
                answer.add(dec);
            }
        }
    }
    return answer;
}

Example 57 with StudyEventDAO

use of org.akaza.openclinica.dao.managestudy.StudyEventDAO in project OpenClinica by OpenClinica.

the class DisplaySectionBeanHandler method getDisplaySectionBeans.

/**
     * This method creates a List of DisplaySectionBeans, returning them in the
     * order that the sections appear in a CRF. This List is "lazily"
     * initialized the first time it is requested.
     *
     * @return A List of DisplaySectionBeans.
     * @see org.akaza.openclinica.control.managestudy.PrintCRFServlet
     * @see org.akaza.openclinica.control.managestudy.PrintDataEntryServlet
     */
public List<DisplaySectionBean> getDisplaySectionBeans() {
    FormBeanUtil formBeanUtil;
    ViewPersistanceHandler persistanceHandler;
    ArrayList<SectionBean> allCrfSections;
    // DAO classes for getting item definitions
    SectionDAO sectionDao;
    CRFVersionDAO crfVersionDao;
    if (displaySectionBeans == null) {
        displaySectionBeans = new ArrayList<DisplaySectionBean>();
        formBeanUtil = new FormBeanUtil();
        if (hasStoredData)
            persistanceHandler = new ViewPersistanceHandler();
        // We need a CRF version id to populate the form display
        if (this.crfVersionId == 0) {
            return displaySectionBeans;
        }
        sectionDao = new SectionDAO(dataSource);
        allCrfSections = (ArrayList) sectionDao.findByVersionId(this.crfVersionId);
        // for the purposes of null values, try to obtain a valid
        // eventCrfDefinition id
        EventDefinitionCRFBean eventDefBean = null;
        EventCRFBean eventCRFBean = new EventCRFBean();
        if (eventCRFId > 0) {
            EventCRFDAO ecdao = new EventCRFDAO(dataSource);
            eventCRFBean = (EventCRFBean) ecdao.findByPK(eventCRFId);
            StudyEventDAO sedao = new StudyEventDAO(dataSource);
            StudyEventBean studyEvent = (StudyEventBean) sedao.findByPK(eventCRFBean.getStudyEventId());
            EventDefinitionCRFDAO eventDefinitionCRFDAO = new EventDefinitionCRFDAO(dataSource);
            StudyDAO sdao = new StudyDAO(dataSource);
            StudyBean study = sdao.findByStudySubjectId(eventCRFBean.getStudySubjectId());
            eventDefBean = eventDefinitionCRFDAO.findByStudyEventIdAndCRFVersionId(study, studyEvent.getId(), this.crfVersionId);
        }
        eventDefBean = eventDefBean == null ? new EventDefinitionCRFBean() : eventDefBean;
        // Create an array or List of DisplaySectionBeans representing each
        // section
        // for printing
        DisplaySectionBean displaySectionBean;
        for (SectionBean sectionBean : allCrfSections) {
            displaySectionBean = formBeanUtil.createDisplaySectionBWithFormGroupsForPrint(sectionBean.getId(), this.crfVersionId, dataSource, eventDefBean.getId(), eventCRFBean, context);
            displaySectionBeans.add(displaySectionBean);
        }
    }
    return displaySectionBeans;
}

Example 58 with StudyEventDAO

use of org.akaza.openclinica.dao.managestudy.StudyEventDAO in project OpenClinica by OpenClinica.

the class SDVUtil method getFilteredItemsSubject.

@SuppressWarnings("unchecked")
private Collection<SubjectSDVContainer> getFilteredItemsSubject(FilterSet filterSet, SortSet sortSet, int rowStart, int rowEnd, int studyId, int studySubjectId, HttpServletRequest request) {
    EventCRFDAO eventCRFDAO = new EventCRFDAO(dataSource);
    StudyEventDAO studyEventDAO = new StudyEventDAO(dataSource);
    List<EventCRFBean> eventCRFBeans = new ArrayList<EventCRFBean>();
    String label = "";
    String eventName = "";
    String eventDate = "";
    String sdvStatus = "";
    String crfStatus = "";
    if (filterSet.getFilter("studySubjectId") != null) {
        label = filterSet.getFilter("studySubjectId").getValue().trim();
        eventCRFBeans = eventCRFDAO.getEventCRFsByStudySubjectLabelLimit(label, studyId, studyId, rowEnd - rowStart, rowStart);
    } else if (filterSet.getFilter("eventName") != null) {
        eventName = filterSet.getFilter("eventName").getValue().trim();
    // eventCRFBeans = eventCRFDAO.getEventCRFsByEventNameLimit(eventName,
    //   rowEnd-rowStart,rowStart);
    } else if (filterSet.getFilter("eventDate") != null) {
        eventDate = filterSet.getFilter("eventDate").getValue().trim();
    //  eventCRFBeans = eventCRFDAO.getEventCRFsByEventDateLimit(studyId,eventDate,
    //    rowEnd-rowStart,rowStart);
    } else if (filterSet.getFilter("crfStatus") != null) {
        crfStatus = filterSet.getFilter("crfStatus").getValue().trim();
    //Get the study event for the event crf
    // eventCRFBeans = eventCRFDAO.getEventCRFsByCRFStatus(studyId,
    //   SubjectEventStatus.getSubjectEventStatusIdByName(crfStatus),
    //   rowEnd-rowStart,rowStart);
    } else if (filterSet.getFilter("sdvStatusActions") != null) {
        sdvStatus = filterSet.getFilter("sdvStatusActions").getValue().trim();
    //  eventCRFBeans = eventCRFDAO.getEventCRFsByStudySDV(studyId,
    //    ("complete".equalsIgnoreCase(sdvStatus)),
    //   rowEnd-rowStart,rowStart);
    } else {
        eventCRFBeans = eventCRFDAO.getEventCRFsByStudySubjectLimit(studySubjectId, studyId, studyId, rowEnd - rowStart, rowStart);
    }
    return getSubjectRows(eventCRFBeans, request);
}

Example 59 with StudyEventDAO

use of org.akaza.openclinica.dao.managestudy.StudyEventDAO in project OpenClinica by OpenClinica.

the class SDVUtil method getSubjectRows.

/*
    Generate the rows for the study table. Each row represents an Event CRF.
    */
public Collection<SubjectSDVContainer> getSubjectRows(List<EventCRFBean> eventCRFBeans, HttpServletRequest request) {
    if (eventCRFBeans == null || eventCRFBeans.isEmpty()) {
        return new ArrayList<SubjectSDVContainer>();
    }
    getEventNamesForEventCRFs(eventCRFBeans);
    StudySubjectDAO studySubjectDAO = new StudySubjectDAO(dataSource);
    SubjectDAO subjectDAO = new SubjectDAO(dataSource);
    StudyDAO studyDAO = new StudyDAO(dataSource);
    StudyEventDAO studyEventDAO = new StudyEventDAO(dataSource);
    EventDefinitionCRFDAO eventDefinitionCRFDAO = new EventDefinitionCRFDAO(dataSource);
    StudySubjectBean studySubjectBean = null;
    SubjectBean subjectBean = null;
    StudyEventBean studyEventBean = null;
    StudyBean studyBean = null;
    EventDefinitionCRFBean eventDefinitionCRFBean = null;
    Collection<SubjectSDVContainer> allRows = new ArrayList<SubjectSDVContainer>();
    SubjectSDVContainer tempSDVBean = null;
    StringBuilder actions = new StringBuilder("");
    for (EventCRFBean crfBean : eventCRFBeans) {
        tempSDVBean = new SubjectSDVContainer();
        studySubjectBean = (StudySubjectBean) studySubjectDAO.findByPK(crfBean.getStudySubjectId());
        studyEventBean = (StudyEventBean) studyEventDAO.findByPK(crfBean.getStudyEventId());
        subjectBean = (SubjectBean) subjectDAO.findByPK(studySubjectBean.getSubjectId());
        //find out the study's identifier
        studyBean = (StudyBean) studyDAO.findByPK(studySubjectBean.getStudyId());
        tempSDVBean.setStudyIdentifier(studyBean.getIdentifier());
        eventDefinitionCRFBean = eventDefinitionCRFDAO.findByStudyEventIdAndCRFVersionId(studyBean, studyEventBean.getId(), crfBean.getCRFVersionId());
        SourceDataVerification sourceData = eventDefinitionCRFBean.getSourceDataVerification();
        if (sourceData != null) {
            tempSDVBean.setSdvRequirementDefinition(sourceData.toString());
        } else {
            tempSDVBean.setSdvRequirementDefinition("");
        }
        tempSDVBean.setCrfNameVersion(getCRFName(crfBean.getCRFVersionId()) + "/ " + getCRFVersionName(crfBean.getCRFVersionId()));
        if (crfBean.getStatus() != null) {
            Integer status = crfBean.getStage().getId();
            if (studyEventBean.getSubjectEventStatus() == SubjectEventStatus.LOCKED || studyEventBean.getSubjectEventStatus() == SubjectEventStatus.STOPPED || studyEventBean.getSubjectEventStatus() == SubjectEventStatus.SKIPPED) {
                status = DataEntryStage.LOCKED.getId();
            }
            tempSDVBean.setCrfStatus(getCRFStatusIconPath(status, request, studySubjectBean.getId(), crfBean.getId(), crfBean.getCRFVersionId()));
        }
        tempSDVBean.setStudyEventStatus(studyEventBean.getStatus().getName());
        //TODO: I18N Date must be formatted properly
        Locale locale = LocaleResolver.getLocale(request);
        SimpleDateFormat sdformat = I18nFormatUtil.getDateFormat(locale);
        if (studySubjectBean.getEnrollmentDate() != null) {
            tempSDVBean.setEnrollmentDate(sdformat.format(studySubjectBean.getEnrollmentDate()));
        } else {
        //tempSDVBean.setEnrollmentDate("unknown");
        }
        //TODO: I18N Date must be formatted properly
        //Fix OC 1888
        StudyEventDAO sedao = new StudyEventDAO(dataSource);
        StudyEventBean seBean = (StudyEventBean) sedao.findByPK(crfBean.getStudyEventId());
        tempSDVBean.setEventDate(sdformat.format(seBean.getDateStarted()));
        //            if (crfBean.getCreatedDate() != null) {
        //                tempSDVBean.setEventDate(sdformat.format(crfBean.getCreatedDate()));
        //            } else {
        //                //tempSDVBean.setEventDate("unknown");
        //
        //            }
        //crfBean.getEventName()
        tempSDVBean.setEventName(crfBean.getEventName());
        //The checkbox is next to the study subject id
        StringBuilder sdvStatus = new StringBuilder("");
        //"This Event CRF has been Source Data Verified. If you uncheck this box, you are removing Source Data Verification for the Event CRF and you will have to repeat the process. Select OK to continue and Cancel to cancel this transaction."
        if (crfBean.isSdvStatus()) {
            sdvStatus.append("<center><a href='javascript:void(0)' onclick='prompt(document.sdvForm,");
            sdvStatus.append(crfBean.getId());
            sdvStatus.append(")'>");
            sdvStatus.append(getIconForSdvStatusPrefix()).append("DoubleCheck").append(ICON_FORCRFSTATUS_SUFFIX).append("</a></center>");
        } else {
            sdvStatus.append("<center><input style='margin-right: 5px' type='checkbox' ").append("class='sdvCheck'").append(" name='").append(CHECKBOX_NAME).append(crfBean.getId()).append("' /></center>");
        }
        //sdvStatus.append(studySubjectBean.getLabel());
        tempSDVBean.setSdvStatus(sdvStatus.toString());
        tempSDVBean.setStudySubjectId(studySubjectBean.getLabel());
        if (subjectBean != null) {
            tempSDVBean.setPersonId(subjectBean.getUniqueIdentifier());
        } else {
            tempSDVBean.setPersonId("");
        }
        //studySubjectBean.getSecondaryLabel()
        tempSDVBean.setSecondaryId(studySubjectBean.getSecondaryLabel());
        String statusName = studySubjectBean.getStatus().getName();
        int statusId = studySubjectBean.getStatus().getId();
        if (statusName != null) {
            tempSDVBean.setStudySubjectStatus(statusName);
        }
        //TODO: I18N Date must be formatted properly
        if (crfBean.getUpdatedDate() != null) {
            tempSDVBean.setLastUpdatedDate(sdformat.format(crfBean.getUpdatedDate()));
        } else {
            tempSDVBean.setLastUpdatedDate("unknown");
        }
        if (crfBean.getUpdater() != null) {
            tempSDVBean.setLastUpdatedBy(crfBean.getUpdater().getFirstName() + " " + crfBean.getUpdater().getLastName());
        }
        actions = new StringBuilder("");
        //append("<input type='hidden' name='crfId' value='").append(crfBean.getId()).append("'").append("/> ")
        if (!crfBean.isSdvStatus()) {
            StringBuilder jsCodeString = new StringBuilder("this.form.method='GET'; this.form.action='").append(request.getContextPath()).append("/pages/handleSDVGet").append("';").append("this.form.crfId.value='").append(crfBean.getId()).append("';").append("this.form.submit();");
            actions.append("<input type=\"submit\" class=\"button_medium\" value=\"SDV\" name=\"sdvSubmit\" ").append("onclick=\"").append(jsCodeString.toString()).append("\" />");
        }
        //Only implement the view icon if it is a event crf request
        /*String bool = (String) request.getAttribute("isViewSubjectRequest");
            if(! "y".equalsIgnoreCase(bool)){
                StringBuilder urlPrefix = new StringBuilder("<a href='javascript:void(0)' onclick=\"document.location.href='");
                StringBuilder path = new StringBuilder(request.getContextPath()).append("/pages/viewAllSubjectSDV?studyId=").append(studySubjectBean.getStudyId()).append("&studySubjectId=");
                path.append(studySubjectBean.getId());

                urlPrefix.append(path).append("'\">");
                actions.append("&nbsp;").append(urlPrefix).append(VIEW_ICON_HTML).append("</a>");
            }*/
        tempSDVBean.setSdvStatusActions(actions.toString());
        allRows.add(tempSDVBean);
    }
    return allRows;
}

Example 60 with StudyEventDAO

use of org.akaza.openclinica.dao.managestudy.StudyEventDAO in project OpenClinica by OpenClinica.

the class SDVUtil method getEventNamesForEventCRFs.

public void getEventNamesForEventCRFs(List<EventCRFBean> eventCRFBeans) {
    if (eventCRFBeans == null || eventCRFBeans.isEmpty())
        return;
    StudyEventDAO studyEventDAO = new StudyEventDAO(dataSource);
    StudyEventDefinitionDAO studyEventDefinitionDAO = new StudyEventDefinitionDAO(dataSource);
    StudyEventBean studyEventBean = null;
    StudyEventDefinitionBean studyEventDefBean = null;
    //Provide a value for the eventName property of the EventCRF
    for (EventCRFBean eventCRFBean : eventCRFBeans) {
        if ("".equalsIgnoreCase(eventCRFBean.getEventName())) {
            studyEventBean = (StudyEventBean) studyEventDAO.findByPK(eventCRFBean.getStudyEventId());
            studyEventDefBean = (StudyEventDefinitionBean) studyEventDefinitionDAO.findByPK(studyEventBean.getStudyEventDefinitionId());
            eventCRFBean.setEventName(studyEventDefBean.getName() + "(" + studyEventBean.getSampleOrdinal() + ")");
        }
    }
}