java类ims.core.vo.domain.ActivityVoAssembler的实例源码

public ActivityVoCollection listActivitiesByService(ServiceRefVo serviceRef, Boolean isFlexible)
{
    if( serviceRef == null )
        return null;

    DomainFactory factory = getDomainFactory();
    // For profile Slot, we want to list
    // all activities for appointment activity type
    String hql= null;
    if( Boolean.TRUE.equals(isFlexible))
    {
        hql = "select s1_1.activity from ServiceActivity as s1_1 left join s1_1.activity as a1_1 where (s1_1.isActive = 1 and a1_1.isActive = 1 and s1_1.service.id = :serviceId and s1_1.isFlexible = 1 )";    //wdev-20262
    }
    else
    {
        hql = "select s1_1.activity from ServiceActivity as s1_1 left join s1_1.activity as a1_1 where (s1_1.isActive = 1 and a1_1.isActive = 1 and s1_1.service.id = :serviceId and (s1_1.isFlexible = 0 or s1_1.isFlexible is null))"; //wdev-20262
    }

    List lst = factory.find(hql, new String[]{"serviceId"}, new Object[]{new Integer(serviceRef.getID_Service())});
    return (ActivityVoAssembler.createActivityVoCollectionFromActivity(lst));
}

/**
* listActivities
*/
public ActivityVoCollection listActivities() 
{   
    DomainFactory factory = getDomainFactory();
    // For profile Slot, we want to list
    // all activities for appointment activity type
    String hql = " from Activity act where act.activityType.id = :activityType and act.isActive = :active";
    List lst = factory.find(hql, new String[]{"activityType", "active"}, new Object[]{new Integer(ActivityType.APPOINTMENTTYPES.getId()), Boolean.TRUE});
    return (ActivityVoAssembler.createActivityVoCollectionFromActivity(lst));
}

/**
    * Returns a list of all activities, or a list of active activities
    */
    public ims.core.vo.ActivityVoCollection listActivities(Boolean bActive)
    {              
        DomainFactory factory = getDomainFactory();     
        List activities = null;     
        StringBuffer hql = new StringBuffer(" ");
        String query = "from Activity a ";

        if (bActive.equals(Boolean.TRUE))
        {
            ArrayList markers = new ArrayList();
            ArrayList values = new ArrayList();

            hql.append(" a.isActive = :isActive");
            markers.add("isActive");
            values.add(bActive);            

            if (markers.size() > 0) query += " where ";
            query += hql.toString();

            activities = factory.find(query, markers, values, 1000);
        }   
        else
        {
            activities = factory.find(query,1000);          
        }

        return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ims.core.vo.ActivityVo getActivity(Integer activityId)
{   
    DomainFactory factory = getDomainFactory();
    ims.core.resource.place.domain.objects.Activity domActivity = (ims.core.resource.place.domain.objects.Activity) factory.getDomainObject(Activity.class, activityId);
    return (ActivityVoAssembler.create(domActivity));

}

public ActivityVo saveActivity(ActivityVo activityVo) throws StaleObjectException, UniqueKeyViolationException
{
    if (!activityVo.isValidated())
    {
        throw new DomainRuntimeException("Activity has not been validated");
    }

    DomainFactory factory = getDomainFactory();

    if(Activity.recordExistForNameAndIsActiveAndActivityType(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType())))
    {
        if(activityVo.getID_ActivityIsNotNull())
        {
            Activity doConflictingActivity = Activity.getActivityFromactivity_unq1(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType()));
            if(!doConflictingActivity.getId().equals(activityVo.getID_Activity()))
                throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
        }
        else
            throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
    }


    ims.core.resource.place.domain.objects.Activity domActivity = ActivityVoAssembler.extractActivity(factory, activityVo);             

    try
    {
        factory.save(domActivity);
    }
    catch (UnqViolationUncheckedException e)
    {
        throw new UniqueKeyViolationException("An activity with the same code mapping exists");
    }

    return ActivityVoAssembler.create(domActivity);
}

public ActivityVoCollection listNTPFActivities(Boolean isActive, LookupInstanceCollection activityTypeInstancesToExclude) 
{
    DomainFactory factory = getDomainFactory();     

    String hql = " from Activity act "; 
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    if(isActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive" );
        markers.add("isActive");
        values.add(isActive);       
        andStr = " and ";
    }
    if(activityTypeInstancesToExclude != null)
    {
        for(int i=0;i<activityTypeInstancesToExclude.size();i++)
        {
            String paramName = "actType" + String.valueOf(i);
            condStr.append(andStr + " act.activityType <> " + ":" + paramName );
            markers.add(paramName);
            values.add(getDomLookup(activityTypeInstancesToExclude.getIndex(i)));       
            andStr = " and ";
        }
    }

    if(andStr.equals( " and "))
        hql += " where ";

    hql += condStr.toString();
    List activities = factory.find(hql,markers,values);
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();       

}

/**
* listActivities
*/  
//WDEV-22973 
public ActivityVoCollection listActivities(CatsReferralRefVo catsReferralRef, ServiceRefVo serviceRef)
{
    if (catsReferralRef != null && serviceRef != null)
    {   
        DomainFactory factory = getDomainFactory();
        String query = null;

        Long noConsultationActivityRequiredForReferral = factory.countWithHQL("select count(cats.id) from CatsReferral as cats where cats.id = :CatsReferralId and (cats.consultationActivityRequired = 0 or cats.consultationActivityRequired is null) ", new String[] {"CatsReferralId"}, new Object[] {catsReferralRef.getID_CatsReferral()});

        if (noConsultationActivityRequiredForReferral == null || noConsultationActivityRequiredForReferral == 0) //WDEV-22672
        {
            Long appointmentsCount = factory.countWithHQL("select count(appts.id) from CatsReferral as cats right join cats.appointments as appts where appts.theatreBooking is null and cats.id = :CatsReferralId", new String[] {"CatsReferralId"}, new Object[] {catsReferralRef.getID_CatsReferral()});
            query = "select act from ServiceActivity as servActivity left join servActivity.activity as act left join servActivity.service as serv where serv.id = :serviceID and act.activityType.id = :actType and servActivity.isActive = :isActive" + ((appointmentsCount == null || appointmentsCount == 0) ? " and (act.firstAppointment = 1 or act.diagnostic = 1)" : "") + " order by act.name asc";            }
        else
        {
            query = "select act from ServiceActivity as servActivity left join servActivity.activity as act left join servActivity.service as serv where serv.id = :serviceID and act.activityType.id = :actType and servActivity.isActive = :isActive order by act.name asc";
        }

        if(query != null && query.length() > 0)
        {
            List<?> results = factory.find(query, new String[]{"serviceID", "actType", "isActive"}, new Object[]{serviceRef.getID_Service(), ActivityType.APPOINTMENTTYPES.getId(), Boolean.TRUE});
            if (results == null || results.isEmpty())
                return null;
            return ActivityVoAssembler.createActivityVoCollectionFromActivity(results);
        }       

    }
    ProfilesSlotGeneric impl = (ProfilesSlotGeneric) getDomainImpl(ProfilesSlotGenericImpl.class);
    return impl.listActivities();

}

/**
* listActivities
*/
public ActivityVoCollection listActivities() 
{   
    DomainFactory factory = getDomainFactory();
    // For profile Slot, we want to list
    // all activities for appointment activity type
    String hql = " from Activity act where act.activityType.id = :activityType and act.isActive = :active";
    List lst = factory.find(hql, new String[]{"activityType", "active"}, new Object[]{new Integer(ActivityType.APPOINTMENTTYPES.getId()), Boolean.TRUE});
    return (ActivityVoAssembler.createActivityVoCollectionFromActivity(lst));
}

/**
    * Returns a list of all activities, or a list of active activities
    */
    public ims.core.vo.ActivityVoCollection listActivities(Boolean bActive)
    {              
        DomainFactory factory = getDomainFactory();     
        List activities = null;     
        StringBuffer hql = new StringBuffer(" ");
        String query = "from Activity a ";

        if (bActive.equals(Boolean.TRUE))
        {
            ArrayList markers = new ArrayList();
            ArrayList values = new ArrayList();

            hql.append(" a.isActive = :isActive");
            markers.add("isActive");
            values.add(bActive);            

            if (markers.size() > 0) query += " where ";
            query += hql.toString();

            activities = factory.find(query, markers, values, 1000);
        }   
        else
        {
            activities = factory.find(query,1000);          
        }

        return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ims.core.vo.ActivityVo getActivity(Integer activityId)
{   
    DomainFactory factory = getDomainFactory();
    ims.core.resource.place.domain.objects.Activity domActivity = (ims.core.resource.place.domain.objects.Activity) factory.getDomainObject(Activity.class, activityId);
    return (ActivityVoAssembler.create(domActivity));

}

public ActivityVo saveActivity(ActivityVo activityVo) throws StaleObjectException, UniqueKeyViolationException
{
    if (!activityVo.isValidated())
    {
        throw new DomainRuntimeException("Activity has not been validated");
    }

    DomainFactory factory = getDomainFactory();

    if(Activity.recordExistForNameAndIsActiveAndActivityType(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType())))
    {
        if(activityVo.getID_ActivityIsNotNull())
        {
            Activity doConflictingActivity = Activity.getActivityFromactivity_unq1(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType()));
            if(!doConflictingActivity.getId().equals(activityVo.getID_Activity()))
                throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
        }
        else
            throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
    }


    ims.core.resource.place.domain.objects.Activity domActivity = ActivityVoAssembler.extractActivity(factory, activityVo);             

    try
    {
        factory.save(domActivity);
    }
    catch (UnqViolationUncheckedException e)
    {
        throw new UniqueKeyViolationException("An activity with the same code mapping exists");
    }

    return ActivityVoAssembler.create(domActivity);
}

public ActivityVoCollection listNTPFActivities(Boolean isActive, LookupInstanceCollection activityTypeInstancesToExclude) 
{
    DomainFactory factory = getDomainFactory();     

    String hql = " from Activity act "; 
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    if(isActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive" );
        markers.add("isActive");
        values.add(isActive);       
        andStr = " and ";
    }
    if(activityTypeInstancesToExclude != null)
    {
        for(int i=0;i<activityTypeInstancesToExclude.size();i++)
        {
            String paramName = "actType" + String.valueOf(i);
            condStr.append(andStr + " act.activityType <> " + ":" + paramName );
            markers.add(paramName);
            values.add(getDomLookup(activityTypeInstancesToExclude.getIndex(i)));       
            andStr = " and ";
        }
    }

    if(andStr.equals( " and "))
        hql += " where ";

    hql += condStr.toString();
    List activities = factory.find(hql,markers,values);
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();       

}

/**
* listActivities
*/
public ActivityVoCollection listActivities() 
{   
    DomainFactory factory = getDomainFactory();
    // For profile Slot, we want to list
    // all activities for appointment activity type
    String hql = " from Activity act where act.activityType.id = :activityType and act.isActive = :active";
    List lst = factory.find(hql, new String[]{"activityType", "active"}, new Object[]{new Integer(ActivityType.APPOINTMENTTYPES.getId()), Boolean.TRUE});
    return (ActivityVoAssembler.createActivityVoCollectionFromActivity(lst));
}

/**
    * Returns a list of all activities, or a list of active activities
    */
    public ims.core.vo.ActivityVoCollection listActivities(Boolean bActive)
    {              
        DomainFactory factory = getDomainFactory();     
        List activities = null;     
        StringBuffer hql = new StringBuffer(" ");
        String query = "from Activity a ";

        if (bActive.equals(Boolean.TRUE))
        {
            ArrayList markers = new ArrayList();
            ArrayList values = new ArrayList();

            hql.append(" a.isActive = :isActive");
            markers.add("isActive");
            values.add(bActive);            

            if (markers.size() > 0) query += " where ";
            query += hql.toString();

            activities = factory.find(query, markers, values, 1000);
        }   
        else
        {
            activities = factory.find(query,1000);          
        }

        return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ims.core.vo.ActivityVo getActivity(Integer activityId)
{   
    DomainFactory factory = getDomainFactory();
    ims.core.resource.place.domain.objects.Activity domActivity = (ims.core.resource.place.domain.objects.Activity) factory.getDomainObject(Activity.class, activityId);
    return (ActivityVoAssembler.create(domActivity));

}

public ActivityVo saveActivity(ActivityVo activityVo) throws StaleObjectException, UniqueKeyViolationException
{
    if (!activityVo.isValidated())
    {
        throw new DomainRuntimeException("Activity has not been validated");
    }

    DomainFactory factory = getDomainFactory();

    if(Activity.recordExistForNameAndIsActiveAndActivityType(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType())))
    {
        if(activityVo.getID_ActivityIsNotNull())
        {
            Activity doConflictingActivity = Activity.getActivityFromactivity_unq1(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType()));
            if(!doConflictingActivity.getId().equals(activityVo.getID_Activity()))
                throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
        }
        else
            throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
    }


    ims.core.resource.place.domain.objects.Activity domActivity = ActivityVoAssembler.extractActivity(factory, activityVo);             

    try
    {
        factory.save(domActivity);
    }
    catch (UnqViolationUncheckedException e)
    {
        throw new UniqueKeyViolationException("An activity with the same code mapping exists");
    }

    return ActivityVoAssembler.create(domActivity);
}

public ActivityVoCollection listNTPFActivities(Boolean isActive, LookupInstanceCollection activityTypeInstancesToExclude) 
{
    DomainFactory factory = getDomainFactory();     

    String hql = " from Activity act "; 
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    if(isActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive" );
        markers.add("isActive");
        values.add(isActive);       
        andStr = " and ";
    }
    if(activityTypeInstancesToExclude != null)
    {
        for(int i=0;i<activityTypeInstancesToExclude.size();i++)
        {
            String paramName = "actType" + String.valueOf(i);
            condStr.append(andStr + " act.activityType <> " + ":" + paramName );
            markers.add(paramName);
            values.add(getDomLookup(activityTypeInstancesToExclude.getIndex(i)));       
            andStr = " and ";
        }
    }

    if(andStr.equals( " and "))
        hql += " where ";

    hql += condStr.toString();
    List activities = factory.find(hql,markers,values);
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();       

}

/**
* listActivities
*/
public ActivityVoCollection listActivities() 
{   
    DomainFactory factory = getDomainFactory();
    // For profile Slot, we want to list
    // all activities for appointment activity type
    String hql = " from Activity act where act.activityType.id = :activityType and act.isActive = :active";
    List lst = factory.find(hql, new String[]{"activityType", "active"}, new Object[]{new Integer(ActivityType.APPOINTMENTTYPES.getId()), Boolean.TRUE});
    return (ActivityVoAssembler.createActivityVoCollectionFromActivity(lst));
}

/**
    * Returns a list of all activities, or a list of active activities
    */
    public ims.core.vo.ActivityVoCollection listActivities(Boolean bActive)
    {              
        DomainFactory factory = getDomainFactory();     
        List activities = null;     
        StringBuffer hql = new StringBuffer(" ");
        String query = "from Activity a ";

        if (bActive.equals(Boolean.TRUE))
        {
            ArrayList markers = new ArrayList();
            ArrayList values = new ArrayList();

            hql.append(" a.isActive = :isActive");
            markers.add("isActive");
            values.add(bActive);            

            if (markers.size() > 0) query += " where ";
            query += hql.toString();

            activities = factory.find(query, markers, values, 1000);
        }   
        else
        {
            activities = factory.find(query,1000);          
        }

        return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ims.core.vo.ActivityVo getActivity(Integer activityId)
{   
    DomainFactory factory = getDomainFactory();
    ims.core.resource.place.domain.objects.Activity domActivity = (ims.core.resource.place.domain.objects.Activity) factory.getDomainObject(Activity.class, activityId);
    return (ActivityVoAssembler.create(domActivity));

}

public ActivityVo saveActivity(ActivityVo activityVo) throws StaleObjectException, UniqueKeyViolationException
{
    if (!activityVo.isValidated())
    {
        throw new DomainRuntimeException("Activity has not been validated");
    }

    DomainFactory factory = getDomainFactory();

    if(Activity.recordExistForNameAndIsActiveAndActivityType(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType())))
    {
        if(activityVo.getID_ActivityIsNotNull())
        {
            Activity doConflictingActivity = Activity.getActivityFromactivity_unq1(factory, activityVo.getName(), activityVo.getIsActive(), getDomLookup( activityVo.getActivityType()));
            if(!doConflictingActivity.getId().equals(activityVo.getID_Activity()))
                throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
        }
        else
            throw new UniqueKeyViolationException("An " + (activityVo.getIsActive() ? "active" : "inactive") + " Activity of this Type and Name already exists");
    }


    ims.core.resource.place.domain.objects.Activity domActivity = ActivityVoAssembler.extractActivity(factory, activityVo);             

    try
    {
        factory.save(domActivity);
    }
    catch (UnqViolationUncheckedException e)
    {
        throw new UniqueKeyViolationException("An activity with the same code mapping exists");
    }

    return ActivityVoAssembler.create(domActivity);
}

public ActivityVoCollection listNTPFActivities(Boolean isActive, LookupInstanceCollection activityTypeInstancesToExclude) 
{
    DomainFactory factory = getDomainFactory();     

    String hql = " from Activity act "; 
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    if(isActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive" );
        markers.add("isActive");
        values.add(isActive);       
        andStr = " and ";
    }
    if(activityTypeInstancesToExclude != null)
    {
        for(int i=0;i<activityTypeInstancesToExclude.size();i++)
        {
            String paramName = "actType" + String.valueOf(i);
            condStr.append(andStr + " act.activityType <> " + ":" + paramName );
            markers.add(paramName);
            values.add(getDomLookup(activityTypeInstancesToExclude.getIndex(i)));       
            andStr = " and ";
        }
    }

    if(andStr.equals( " and "))
        hql += " where ";

    hql += condStr.toString();
    List activities = factory.find(hql,markers,values);
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();       

}

public ActivityVoCollection listActivity(LocationServiceActivityVo locationServiceActivity) throws DomainInterfaceException
{
    DomainFactory factory = getDomainFactory();

    if (locationServiceActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    ActivityVoCollection voCollActivity = new ActivityVoCollection();

    String hql = "select locServiceActivity from LocationServiceActivity locServiceActivity, Procedure proc join proc.keywords as kw";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    condStr.append(andStr + " where locServiceActivity.serviceActivity is not null and locServiceActivity.serviceActivity.activity = proc.activity");
    andStr = " and ";

    if (locationServiceActivity.getLocationService() != null)
    {
        condStr.append(andStr + " locServiceActivity.locationService.id = :locService");
        markers.add("locService");
        values.add(locationServiceActivity.getLocationService().getID_LocationService());
        andStr = " and ";
    }

    if ((locationServiceActivity.getServiceActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivity().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.serviceActivity.activity.isActive = :isActive");
        markers.add("isActive");
        values.add(locationServiceActivity.getServiceActivity().getActivity().getIsActive());
        andStr = " and ";
    }

    if ((locationServiceActivity.getLocationServiceIsNotNull()) && (locationServiceActivity.getLocationService().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.isActive = :isLSActive");
        markers.add("isLSActive");
        values.add(locationServiceActivity.getLocationService().getIsActive());
        andStr = " and ";
    }

    hql += condStr.toString();

    LocationServiceActivityVoCollection voCollLocServiceActivity = null;
    voCollLocServiceActivity = LocationServiceActivityVoAssembler.createLocationServiceActivityVoCollectionFromLocationServiceActivity(Keywords.searchByKeywords(factory, locationServiceActivity.getServiceActivity().getActivity().getName(), hql.toString(), markers, values));
    factory.getDomainSession().clearMessages();

    for (int i = 0; i < voCollLocServiceActivity.size(); i++)
    {
        if (voCollLocServiceActivity.get(i).getServiceActivityIsNotNull())
            voCollActivity.add(voCollLocServiceActivity.get(i).getServiceActivity().getActivity());
    }
    return voCollActivity.sort();
}

public ActivityVoCollection listActivity(ActivityVo filterActivity, Boolean checkDuplicate)
{
    DomainFactory factory = getDomainFactory();

    if (filterActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    String hql = " from Activity activity ";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    if (filterActivity.getNameIsNotNull())
    {
        // Checks the exact match
        if (checkDuplicate != null && checkDuplicate.booleanValue())
            condStr.append(andStr + " upper(activity.name) = :activityName");
        else
            condStr.append(andStr + " upper(activity.name) like :activityName");

        markers.add("activityName");
        values.add("%" + filterActivity.getName().toUpperCase() + "%");
        andStr = " and ";
    }
    if (filterActivity.getIsActiveIsNotNull())
    {
        condStr.append(andStr + " activity.isActive = :active");
        markers.add("active");
        values.add(filterActivity.getIsActive());
        andStr = " and ";
    }
    if (filterActivity.getActivityTypeIsNotNull())
    {
        condStr.append(andStr + " activity.activityType = :activityType");
        markers.add("activityType");
        values.add(getDomLookup(filterActivity.getActivityType()));
        andStr = " and ";
    }

    if (filterActivity.getIsWorkQueueIsNotNull())
    {
        condStr.append(andStr + " activity.isWorkQueue = :workQ ");
        markers.add("workQ");
        values.add(filterActivity.getIsWorkQueue());
        andStr = " and ";
    }

    if (andStr.equals(" and "))
        hql += " where ";

    hql += condStr.toString();
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.find(hql, markers, values)).sort();
}

public ActivityVoCollection listActivity(String nameFilter, ActivityType activityType, Boolean bActive) throws DomainInterfaceException
{
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";
    String hql = null;
    DomainFactory factory = getDomainFactory();

    if (ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && activityType.equals(ActivityType.PROCEDURE))
    {
        hql = "select act from Activity act, Procedure proc join proc.keywords as kw";
        condStr.append(andStr + " where act = proc.activity");
        andStr = " and ";

    }
    else
    {
        hql = "select act from Activity act";
        condStr.append(" where");
        andStr = " ";
    }

    if (bActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive");
        markers.add("isActive");
        values.add(bActive);
        andStr = " and ";
    }
    if (activityType != null)
    {
        condStr.append(andStr + " act.activityType =:actType");
        markers.add("actType");
        values.add(getDomLookup(activityType));
        andStr = " and ";
    }
    if (!ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && nameFilter != "")
    {
        condStr.append(andStr + " act.name like :filterStr ");
        markers.add("filterStr");
        values.add(nameFilter + "%");
    }

    hql += condStr.toString();
    List activities = null;
    if (ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && activityType.equals(ActivityType.PROCEDURE))
        activities = Keywords.searchByKeywords(factory, nameFilter, hql.toString(), markers, values);
    else
        activities = factory.find(hql, markers, values, 1000);

    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ActivityVoCollection listActivity(LocationServiceActivityVo locationServiceActivity) throws DomainInterfaceException
{
    DomainFactory factory = getDomainFactory();

    if (locationServiceActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    ActivityVoCollection voCollActivity = new ActivityVoCollection();

    String hql = "select locServiceActivity from LocationServiceActivity locServiceActivity, Procedure proc join proc.keywords as kw";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    condStr.append(andStr + " where locServiceActivity.serviceActivity is not null and locServiceActivity.serviceActivity.activity = proc.activity");
    andStr = " and ";

    if (locationServiceActivity.getLocationService() != null)
    {
        condStr.append(andStr + " locServiceActivity.locationService.id = :locService");
        markers.add("locService");
        values.add(locationServiceActivity.getLocationService().getID_LocationService());
        andStr = " and ";
    }

    if ((locationServiceActivity.getServiceActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivity().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.serviceActivity.activity.isActive = :isActive");
        markers.add("isActive");
        values.add(locationServiceActivity.getServiceActivity().getActivity().getIsActive());
        andStr = " and ";
    }

    if ((locationServiceActivity.getLocationServiceIsNotNull()) && (locationServiceActivity.getLocationService().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.isActive = :isLSActive");
        markers.add("isLSActive");
        values.add(locationServiceActivity.getLocationService().getIsActive());
        andStr = " and ";
    }

    hql += condStr.toString();

    LocationServiceActivityVoCollection voCollLocServiceActivity = null;
    voCollLocServiceActivity = LocationServiceActivityVoAssembler.createLocationServiceActivityVoCollectionFromLocationServiceActivity(Keywords.searchByKeywords(factory, locationServiceActivity.getServiceActivity().getActivity().getName(), hql.toString(), markers, values));
    factory.getDomainSession().clearMessages();

    for (int i = 0; i < voCollLocServiceActivity.size(); i++)
    {
        if (voCollLocServiceActivity.get(i).getServiceActivityIsNotNull())
            voCollActivity.add(voCollLocServiceActivity.get(i).getServiceActivity().getActivity());
    }
    return voCollActivity.sort();
}

public ActivityVoCollection listActivity(ActivityVo filterActivity, Boolean checkDuplicate)
{
    DomainFactory factory = getDomainFactory();

    if (filterActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    String hql = " from Activity activity ";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    if (filterActivity.getNameIsNotNull())
    {
        // Checks the exact match
        if (checkDuplicate != null && checkDuplicate.booleanValue())
            condStr.append(andStr + " upper(activity.name) = :activityName");
        else
            condStr.append(andStr + " upper(activity.name) like :activityName");

        markers.add("activityName");
        values.add("%" + filterActivity.getName().toUpperCase() + "%");
        andStr = " and ";
    }
    if (filterActivity.getIsActiveIsNotNull())
    {
        condStr.append(andStr + " activity.isActive = :active");
        markers.add("active");
        values.add(filterActivity.getIsActive());
        andStr = " and ";
    }
    if (filterActivity.getActivityTypeIsNotNull())
    {
        condStr.append(andStr + " activity.activityType = :activityType");
        markers.add("activityType");
        values.add(getDomLookup(filterActivity.getActivityType()));
        andStr = " and ";
    }

    if (filterActivity.getIsWorkQueueIsNotNull())
    {
        condStr.append(andStr + " activity.isWorkQueue = :workQ ");
        markers.add("workQ");
        values.add(filterActivity.getIsWorkQueue());
        andStr = " and ";
    }

    if (andStr.equals(" and "))
        hql += " where ";

    hql += condStr.toString();
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.find(hql, markers, values)).sort();
}

public ActivityVoCollection listActivity(String nameFilter, ActivityType activityType, Boolean bActive) throws DomainInterfaceException
{
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";
    String hql = null;
    DomainFactory factory = getDomainFactory();

    if (ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && activityType.equals(ActivityType.PROCEDURE))
    {
        hql = "select act from Activity act, Procedure proc join proc.keywords as kw";
        condStr.append(andStr + " where act = proc.activity");
        andStr = " and ";

    }
    else
    {
        hql = "select act from Activity act";
        condStr.append(" where");
        andStr = " ";
    }

    if (bActive != null)
    {
        condStr.append(andStr + " act.isActive = :isActive");
        markers.add("isActive");
        values.add(bActive);
        andStr = " and ";
    }
    if (activityType != null)
    {
        condStr.append(andStr + " act.activityType =:actType");
        markers.add("actType");
        values.add(getDomLookup(activityType));
        andStr = " and ";
    }
    if (!ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && nameFilter != "")
    {
        condStr.append(andStr + " act.name like :filterStr ");
        markers.add("filterStr");
        values.add(nameFilter + "%");
    }

    hql += condStr.toString();
    List activities = null;
    if (ConfigFlag.DOM.LINK_ACTIVITY_TO_PROCEDURE.getValue() && activityType.equals(ActivityType.PROCEDURE))
        activities = Keywords.searchByKeywords(factory, nameFilter, hql.toString(), markers, values);
    else
        activities = factory.find(hql, markers, values, 1000);

    return ActivityVoAssembler.createActivityVoCollectionFromActivity(activities).sort();
}

public ActivityVoCollection listActivity(LocationServiceActivityVo locationServiceActivity) throws DomainInterfaceException
{
    DomainFactory factory = getDomainFactory();

    if (locationServiceActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    ActivityVoCollection voCollActivity = new ActivityVoCollection();

    String hql = "select locServiceActivity from LocationServiceActivity locServiceActivity, Procedure proc join proc.keywords as kw";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    condStr.append(andStr + " where locServiceActivity.serviceActivity is not null and locServiceActivity.serviceActivity.activity = proc.activity");
    andStr = " and ";

    if (locationServiceActivity.getLocationService() != null)
    {
        condStr.append(andStr + " locServiceActivity.locationService.id = :locService");
        markers.add("locService");
        values.add(locationServiceActivity.getLocationService().getID_LocationService());
        andStr = " and ";
    }

    if ((locationServiceActivity.getServiceActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivityIsNotNull()) && (locationServiceActivity.getServiceActivity().getActivity().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.serviceActivity.activity.isActive = :isActive");
        markers.add("isActive");
        values.add(locationServiceActivity.getServiceActivity().getActivity().getIsActive());
        andStr = " and ";
    }

    if ((locationServiceActivity.getLocationServiceIsNotNull()) && (locationServiceActivity.getLocationService().getIsActiveIsNotNull()))
    {
        condStr.append(andStr + " locServiceActivity.isActive = :isLSActive");
        markers.add("isLSActive");
        values.add(locationServiceActivity.getLocationService().getIsActive());
        andStr = " and ";
    }

    hql += condStr.toString();

    LocationServiceActivityVoCollection voCollLocServiceActivity = null;
    voCollLocServiceActivity = LocationServiceActivityVoAssembler.createLocationServiceActivityVoCollectionFromLocationServiceActivity(Keywords.searchByKeywords(factory, locationServiceActivity.getServiceActivity().getActivity().getName(), hql.toString(), markers, values));
    factory.getDomainSession().clearMessages();

    for (int i = 0; i < voCollLocServiceActivity.size(); i++)
    {
        if (voCollLocServiceActivity.get(i).getServiceActivityIsNotNull())
            voCollActivity.add(voCollLocServiceActivity.get(i).getServiceActivity().getActivity());
    }
    return voCollActivity.sort();
}

public ActivityVoCollection listActivity(ActivityVo filterActivity, Boolean checkDuplicate)
{
    DomainFactory factory = getDomainFactory();

    if (filterActivity == null)
        return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.listDomainObjects(Activity.class));

    String hql = " from Activity activity ";
    StringBuffer condStr = new StringBuffer();
    String andStr = " ";

    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    if (filterActivity.getNameIsNotNull())
    {
        // Checks the exact match
        if (checkDuplicate != null && checkDuplicate.booleanValue())
            condStr.append(andStr + " upper(activity.name) = :activityName");
        else
            condStr.append(andStr + " upper(activity.name) like :activityName");

        markers.add("activityName");
        values.add("%" + filterActivity.getName().toUpperCase() + "%");
        andStr = " and ";
    }
    if (filterActivity.getIsActiveIsNotNull())
    {
        condStr.append(andStr + " activity.isActive = :active");
        markers.add("active");
        values.add(filterActivity.getIsActive());
        andStr = " and ";
    }
    if (filterActivity.getActivityTypeIsNotNull())
    {
        condStr.append(andStr + " activity.activityType = :activityType");
        markers.add("activityType");
        values.add(getDomLookup(filterActivity.getActivityType()));
        andStr = " and ";
    }

    if (filterActivity.getIsWorkQueueIsNotNull())
    {
        condStr.append(andStr + " activity.isWorkQueue = :workQ ");
        markers.add("workQ");
        values.add(filterActivity.getIsWorkQueue());
        andStr = " and ";
    }

    if (andStr.equals(" and "))
        hql += " where ";

    hql += condStr.toString();
    return ActivityVoAssembler.createActivityVoCollectionFromActivity(factory.find(hql, markers, values)).sort();
}