Java 类ims.core.vo.domain.ServiceLiteVoAssembler 实例源码

public ims.core.vo.ServiceLiteVoCollection getServices()
{
    DomainFactory factory = getDomainFactory();
    StringBuffer hql = new StringBuffer("from Service as service where service.isRIE is null and service.isActive = :isActive");
    List list = factory.find(hql.toString(), new String[]{"isActive"}, new Object[]{true});
    ServiceLiteVoCollection serviceLiteVoColl = ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(list);

    if (serviceLiteVoColl.size() > 0)
    {
        return serviceLiteVoColl;
    }
    else
    {
        return null;
    }
}

public ServiceLiteVoCollection listActiveServiceLiteByNameAndCategories(String name, ServiceCategoryCollection categoryCollection)
{
    DomainFactory factory = getDomainFactory();
    StringBuffer query = new StringBuffer("from Service s where s.upperName like :serviceName and s.isActive = :isActive");
    for (int i = 0; i < categoryCollection.size(); i++)
    {
        if (i == 0)
            query.append(" and s.serviceCategory.id in(");
        query.append(categoryCollection.get(i).getID());

        if (i < (categoryCollection.size() - 1))
            query.append(", ");
        else
            query.append(")");
    }
    List services = factory.find(query.toString(), new String[]{"serviceName", "isActive"}, new Object[]{"%" + name.toUpperCase() + "%", Boolean.TRUE});
    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(services).sort();
}

@SuppressWarnings("rawtypes")
public ServiceLiteVo getModality(OrderInvestigationRefVo orderInv)
{
    if(orderInv == null || orderInv.getID_OrderInvestigation() == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public ServiceLiteVo getModality(Integer orderInvId)
{
    if(orderInvId == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(appt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo voAppt)
{
    if (voAppt == null || voAppt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(voAppt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment) getDomainFactory().getDomainObject(appt);
    if (doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

/**
* getModality
*/
public ims.core.vo.ServiceLiteVo getModality(Integer orderInvId)
{
    if(orderInvId == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public ServiceLiteVoCollection listClinicalServices(String serviceName) throws DomainInterfaceException
{
    if (serviceName == null || serviceName.length() == 0)
        throw new DomainInterfaceException("Service name is mandatory for search.");

    StringBuilder query = new StringBuilder("SELECT srv FROM Service AS srv");
    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    query.append(" WHERE srv.upperName LIKE :SRV_NAME AND srv.serviceCategory.id = :CLINICAL AND srv.isActive = 1"); //WDEV-20219 UPPER(srv.serviceName)
    paramNames.add("SRV_NAME");
    paramValues.add(serviceName.toUpperCase() + '%');
    paramNames.add("CLINICAL");
    paramValues.add(ServiceCategory.CLINICAL.getID());

    query.append(" ORDER BY srv.upperName"); //WDEV-20219 UPPER(srv.serviceName)

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(getDomainFactory().find(query.toString(), paramNames, paramValues));
}

@Override
public ServiceLiteVoCollection listActiveClinicalServices(String value) 
{
    DomainFactory factory = getDomainFactory();

    ArrayList<String> paramName = new ArrayList<String>();
    ArrayList<Object> paramValue = new ArrayList<Object>();

    StringBuilder hql = new StringBuilder("FROM Service service WHERE service.isActive = :isActive AND service.serviceCategory.id = :serviceCategoryID ");

    paramName.add("isActive");              paramValue.add(Boolean.TRUE);
    paramName.add("serviceCategoryID");     paramValue.add(ServiceCategory.CLINICAL.getID());

    if(value != null)
    {
        hql.append(" and service.upperName LIKE :SERVICE_NAME");
        paramName.add("SERVICE_NAME");
        paramValue.add("%" + value + "%");
    }

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(factory.find(hql.toString(), paramName, paramValue));
}

public ims.core.vo.ServiceLiteVoCollection getServices()
{
    DomainFactory factory = getDomainFactory();

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

    String hql = "from Service service where service.isActive = :isActive and service.canBeScheduled = :canBeScheduled and service.serviceCategory.id != :serviceCategoryID " ;

    markers.add("isActive");
    values.add(Boolean.TRUE);

    markers.add("canBeScheduled");
    values.add(Boolean.TRUE);

    markers.add("serviceCategoryID");
    values.add(ServiceCategory.RADIOLOGY_MODALITY.getID());

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(factory.find(hql, markers, values));
}

public ServiceLiteVoCollection getServices()
{
    DomainFactory factory = getDomainFactory();

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

    String hql = "from Service service where service.isActive = :isActive and service.canBeScheduled = :canBeScheduled and service.serviceCategory.id != :serviceCategoryID " ;

    markers.add("isActive");
    values.add(Boolean.TRUE);

    markers.add("canBeScheduled");
    values.add(Boolean.TRUE);

    markers.add("serviceCategoryID");
    values.add(ServiceCategory.RADIOLOGY_MODALITY.getID());

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(factory.find(hql, markers, values));
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ims.core.vo.ServiceLiteVoCollection listService(String name)
{
    DomainFactory factory = getDomainFactory();

    StringBuilder hql = new StringBuilder("select s from Service s where s.isActive = 1 and s.canBeScheduled = 1 ");

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

    if (name != null)
    {
        hql.append(" and s.upperName like :ServiceName ");
        markers.add("ServiceName");
        values.add(name.toUpperCase() + "%");
    }

    hql.append( " order by s.upperName asc" );
    List services = factory.find(hql.toString(), markers, values);

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(services);
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(appt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public ims.core.vo.ServiceLiteVoCollection getServices()
{
    DomainFactory factory = getDomainFactory();
    StringBuffer hql = new StringBuffer("from Service as service where service.isRIE is null and service.isActive = :isActive order by service.serviceName asc");  //wdev-20862
    List list = factory.find(hql.toString(), new String[]{"isActive"}, new Object[]{true});
    ServiceLiteVoCollection serviceLiteVoColl = ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(list);

    if (serviceLiteVoColl.size() > 0)
    {
        return serviceLiteVoColl;
    }
    else
    {
        return null;
    }
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceLiteVoCollection listActiveServiceLiteByNameAndCategories(String name, ServiceCategoryCollection categoryCollection)
{
    DomainFactory factory = getDomainFactory();
    StringBuffer query = new StringBuffer("from Service s where s.upperName like :serviceName and s.isActive = :isActive");
    for (int i = 0; i < categoryCollection.size(); i++)
    {
        if (i == 0)
            query.append(" and s.serviceCategory.id in(");
        query.append(categoryCollection.get(i).getID());

        if (i < (categoryCollection.size() - 1))
            query.append(", ");
        else
            query.append(")");
    }
    List services = factory.find(query.toString(), new String[]{"serviceName", "isActive"}, new Object[]{"%" + name.toUpperCase() + "%", Boolean.TRUE});
    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(services).sort();
}

@SuppressWarnings("rawtypes")
public ServiceLiteVo getModality(OrderInvestigationRefVo orderInv)
{
    if(orderInv == null || orderInv.getID_OrderInvestigation() == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public ServiceLiteVo getModality(Integer orderInvId)
{
    if(orderInvId == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public ServiceLiteVoCollection listActiveServiceLiteByNameAndCategories(String name, ServiceCategoryCollection categoryCollection)
{
    DomainFactory factory = getDomainFactory();
    StringBuffer query = new StringBuffer("from Service s where s.upperName like :serviceName and s.isActive = :isActive");
    for (int i = 0; i < categoryCollection.size(); i++)
    {
        if (i == 0)
            query.append(" and s.serviceCategory.id in(");
        query.append(categoryCollection.get(i).getID());

        if (i < (categoryCollection.size() - 1))
            query.append(", ");
        else
            query.append(")");
    }
    List services = factory.find(query.toString(), new String[]{"serviceName", "isActive"}, new Object[]{"%" + name.toUpperCase() + "%", Boolean.TRUE});
    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(services).sort();
}

public ServiceLiteVo getServiceForReferral(CatsReferralRefVo referral)
{
    if (referral == null || referral.getID_CatsReferral() == null)
        return null;

    StringBuilder query = new StringBuilder("SELECT service FROM CatsReferral AS referral ");
    query.append(" LEFT JOIN referral.referralDetails AS referralDetails ");
    query.append(" LEFT JOIN referralDetails.service AS service ");

    query.append(" WHERE ");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    query.append(" referral.id = :REFERRAL_ID ");

    paramNames.add("REFERRAL_ID");
    paramValues.add(referral.getID_CatsReferral());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceLiteVo getReferralService(CatsReferralRefVo referral)
{
    if (referral == null || referral.getID_CatsReferral() == null)
        return null;

    DomainFactory factory = getDomainFactory();

    String hql = " select serv from CatsReferral as referral left join referral.referralDetails as refDetails left join refDetails.service as serv " +
                 " where referral.id = :referralID";

    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Serializable> values = new ArrayList<Serializable>();

    markers.add("referralID");
    values.add(referral.getID_CatsReferral());

    List <?> list = factory.find(hql, markers, values);

    if (list == null || list.size() == 0)
        return null;

    return ServiceLiteVoAssembler.create((Service)list.get(0));
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo voAppt)
{
    if (voAppt == null || voAppt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(voAppt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment) getDomainFactory().getDomainObject(appt);
    if (doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(appt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public ims.core.vo.ServiceLiteVoCollection getServices()
{
    DomainFactory factory = getDomainFactory();
    StringBuffer hql = new StringBuffer("from Service as service where service.isRIE is null and service.isActive = :isActive");
    List list = factory.find(hql.toString(), new String[]{"isActive"}, new Object[]{true});
    ServiceLiteVoCollection serviceLiteVoColl = ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(list);

    if (serviceLiteVoColl.size() > 0)
    {
        return serviceLiteVoColl;
    }
    else
    {
        return null;
    }
}

public ServiceLiteVoCollection listActiveServiceLiteByNameAndCategories(String name, ServiceCategoryCollection categoryCollection)
{
    DomainFactory factory = getDomainFactory();
    StringBuffer query = new StringBuffer("from Service s where s.upperName like :serviceName and s.isActive = :isActive");
    for (int i = 0; i < categoryCollection.size(); i++)
    {
        if (i == 0)
            query.append(" and s.serviceCategory.id in(");
        query.append(categoryCollection.get(i).getID());

        if (i < (categoryCollection.size() - 1))
            query.append(", ");
        else
            query.append(")");
    }
    List services = factory.find(query.toString(), new String[]{"serviceName", "isActive"}, new Object[]{"%" + name.toUpperCase() + "%", Boolean.TRUE});
    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(services).sort();
}

@SuppressWarnings("rawtypes")
public ServiceLiteVo getModality(OrderInvestigationRefVo orderInv)
{
    if(orderInv == null || orderInv.getID_OrderInvestigation() == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInv.getID_OrderInvestigation()});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public ServiceLiteVo getModality(Integer orderInvId)
{
    if(orderInvId == null)
        throw new CodingRuntimeException("orderInv parameter is null in method getModality");

    DomainFactory factory = getDomainFactory();
    String hql = "select o2_1.discipline from OrderInvestigation as o1_1 join o1_1.specimen as o2_1 where (o1_1.id = (:ID)) ";
    List list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    //if current OrderInvestigation doesn't have a specimen we get the modality as follows:
    //OrderInvestigation.investigation.providerService.locationService.service
    hql = "select l2_1.service from OrderInvestigation as o1_1 left join o1_1.investigation as i1_1 left join i1_1.providerService as l1_1 left join l1_1.locationService as l2_1 left join l2_1.service as s1_1 where (o1_1.id = :ID)";
    list = factory.find(hql,new String[] {"ID"},new Object[] {orderInvId});

    if(list.size() > 0)
        return ServiceLiteVoAssembler.create((Service) list.get(0));

    return null;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment)getDomainFactory().getDomainObject(appt);
    if(doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public TheatreProcedureServiceAndConsultantLiteVo getTheatreServiceProcedureAndConsultant(Booking_AppointmentRefVo appt)
{
    if (appt == null || appt.getID_Booking_Appointment() == null)
        throw new CodingRuntimeException("appt is null or id not provided in method getTheatreServiceProcedureAndConsultant");

    TheatreProcedureServiceAndConsultantLiteVo voPsc = null;

    Booking_Appointment doAppt = (Booking_Appointment) getDomainFactory().getDomainObject(appt);
    if (doAppt != null)
    {
        ServiceLiteVo voService = ServiceLiteVoAssembler.create(doAppt.getSession() != null ? doAppt.getSession().getService() : null);
        ProcedureLiteVo voProc = ProcedureLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getProcedure() : null);
        HcpLiteVo voMos = HcpLiteVoAssembler.create(doAppt.getTheatreBooking() != null ? doAppt.getTheatreBooking().getConsultant() : null);

        voPsc = new TheatreProcedureServiceAndConsultantLiteVo();
        voPsc.setService(voService);
        voPsc.setProcedure(voProc);
        voPsc.setConsultant(voMos);
    }

    return voPsc;
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceRefVo getServiceForEpisodeOfCareSpecialty(EpisodeOfCareRefVo episodeOfCare)
{
    if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull())
        return null;

    StringBuilder query = new StringBuilder();

    query.append("select service from Service as service left join service.specialty as specialty where specialty in ");
    query.append(" (select spec from EpisodeOfCare as eoc left join eoc.specialty as spec where eoc.id = :EOC_ID)");
    query.append("  and service.isRIE is null and service.isActive = 1");

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    paramNames.add("EOC_ID");
    paramValues.add(episodeOfCare.getID_EpisodeOfCare());

    return ServiceLiteVoAssembler.create((Service) getDomainFactory().findFirst(query.toString(), paramNames, paramValues));
}

public ServiceLiteVoCollection getServicesBySpecialty(Specialty specialty)
{
    if (specialty == null)
        return null;

    ArrayList<String> paramNames = new ArrayList<String>();
    ArrayList<Object> paramValues = new ArrayList<Object>();

    String query = "SELECT serv FROM Service AS serv LEFT JOIN serv.specialty AS serviceSpecialty WHERE serviceSpecialty.id = :SPECIALTY_ID AND serv.isActive = 1";
    paramNames.add("SPECIALTY_ID");
    paramValues.add(specialty.getID());

    return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(getDomainFactory().find(query, paramNames, paramValues));
}

@SuppressWarnings("rawtypes")
//  @Override
    public ServiceLiteVoCollection listModality()
    {
        String hql = "from Service as s1_1 order by s1_1.serviceName asc";
        DomainFactory factory = getDomainFactory();

        List list = factory.find(hql.toString());

        return ServiceLiteVoAssembler.createServiceLiteVoCollectionFromService(list);
    }