IdtViewDao.java

package org.akaza.openclinica.dao.hibernate;

import java.util.ArrayList;
import java.util.List;

import org.akaza.openclinica.domain.datamap.IdtView;
import org.akaza.openclinica.domain.datamap.ItemData;

public class IdtViewDao extends AbstractDomainDao<IdtView> {

    @Override
    Class<IdtView> domainClass() {
        // TODO Auto-generated method stub
        return IdtView.class;
    }


    
    public List<IdtView> findFilter1(int studyId, int pStudyId, int per_page, int page, ArrayList<String> studySubjects,
            ArrayList<String>eventDefs,ArrayList<String> crfs , int tagId, String operation) {

        String query = " from " + getDomainClassName() + " where tagId ="+ tagId ;

        if (studySubjects.size() !=0)
            query = query + " and studySubjectId in (" + getListOf(studySubjects) + ")";

        if (eventDefs.size()!=0)
            query = query + " and sedOid in (" + getListOf(eventDefs) + ")";

         query = query + " and eventCrfId in (select eventCrfId from " +getDomainClassName() + " where  path is not null and (itemDataWorkflowStatus is null or itemDataWorkflowStatus!='done') group by eventCrfId))";  // EventCrf done       
        
        query = query + " and ((";

        if (crfs.size() !=0)
            query = query + " crfName in (" + getListOf(crfs) + ") and";
        query = query + " eventCrfStatusId=1) or eventCrfStatusId=2)  and (studyId= " + studyId + " " + operation + " parentStudyId=" + pStudyId +") ) "; 
 
        query = query + " order by itemDataId";
       
        org.hibernate.Query q = getCurrentSession().createQuery(query);
        q.setMaxResults(per_page); // limit
        q.setFirstResult((page - 1) * per_page); // offset
        return (List<IdtView>) q.list();
    }

    
    public String getListOf(ArrayList<String> objects){
        String str="";
        String netStr="";
        for (String object:objects){
            str= str+ ",'"+object+"'";            
        }
        
        netStr=str.substring(1);
       return netStr; 
    }
    
    
}