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

项目:AvoinApotti    文件:DocumentCategoryConfigImpl.java   
/**
 * List all the Reports that are active
 */
public TemplateForPatientDocumentVoCollection listReports(String templateName, TemplateBoRefVoCollection notThisOnes, DocumentCategory cat)
{

    String hql = "select tem from TemplateBo as tem left join tem.report as rep where (tem.name like :name and tem.isActive = 1 and rep.isActive = 1 and tem.isRIE is null ";
    ArrayList<String> paramNames = new ArrayList<String>();
    paramNames.add("name");
    ArrayList<Object> paramValues = new ArrayList<Object>();
    paramValues.add(templateName != null ? "%" + templateName + "%" : "%");

    if (notThisOnes != null && notThisOnes.size() > 0)
    {
        hql += "    and tem.id not in (";
        for (int i = 0; i < notThisOnes.size(); i++)
        {
            hql += notThisOnes.get(i).getID_TemplateBo();
            if (i < (notThisOnes.size() - 1))
            {
                hql += ",";
            }
        }

        hql += " )";
    }

    // Only not configured or configured for this category
    if (cat != null)
    {
        hql += " and tem.id not in " + "(select dtem.id from DocumentCategoryConfig as dcc left join dcc.template as dtem " + "where (dcc.category.id <> :cat))  ";
        paramNames.add("cat");
        paramValues.add(cat.getId());
    }

    hql += ") order by upper(rep.reportName) asc, upper(tem.name) asc";//       WDEV-13654

    List<?> dOs = getDomainFactory().find(hql, paramNames, paramValues);
    if (dOs == null || dOs.size() == 0)
        return null;
    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(dOs);

}
项目:AvoinApotti    文件:ClinicLetterBatchCreateImpl.java   
public TemplateForPatientDocumentVoCollection searchReports(String templateName, String listOfMandatorySeeds, DocumentCategory documentType, Specialty specialty) 
{
    DomainFactory factory = getDomainFactory();
    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    String subHql = "";

    if(listOfMandatorySeeds != null && listOfMandatorySeeds.length() > 0)
    {
        subHql = " and r21.bOName not in (" + listOfMandatorySeeds + ")";
    }

    String mainHql = "select t from DocumentCategoryConfig as d left join d.template as t left join t.report as r";
    String whereHql = " where t.id not in (select t11.id from TemplateBo as t11 left join t11.report as r11 left join r11.seeds as r21  where (r21.canBeNull = 0" + subHql + ")) and r.reportXml is not null  and t.templateXml is not null and r.isActive = 1 and t.isActive = 1";//WDEV-13547

    if(templateName != null && templateName.length() > 0)
    {
        whereHql += " and upper(t.name) like :templateName";//WDEV-13750
        markers.add("templateName");
        values.add(templateName.toUpperCase() + "%");//WDEV-13750
    }

    if(documentType != null)
    {
        whereHql += " and d.category.id = :catId";
        markers.add("catId");
        values.add(documentType.getID());
    }

    if(specialty != null)
    {
        mainHql += " left join d.specialty as s left join s.instance as i";
        whereHql += " and i.id = :specialtyId";
        markers.add("specialtyId");
        values.add(specialty.getID());
    }

    String hql = mainHql + whereHql + " order by upper(r.reportName) asc, upper(t.name) asc";//WDEV-13547
    List<?> list = factory.find(hql, markers, values);

    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(list);//WDEV-13547
}
项目:openMAXIMS    文件:DocumentCategoryConfigImpl.java   
/**
 * List all the Reports that are active
 */
public TemplateForPatientDocumentVoCollection listReports(String templateName, TemplateBoRefVoCollection notThisOnes, DocumentCategory cat)
{

    String hql = "select tem from TemplateBo as tem left join tem.report as rep where (tem.name like :name and tem.isActive = 1 and rep.isActive = 1 and tem.isRIE is null ";
    ArrayList<String> paramNames = new ArrayList<String>();
    paramNames.add("name");
    ArrayList<Object> paramValues = new ArrayList<Object>();
    paramValues.add(templateName != null ? "%" + templateName + "%" : "%");

    if (notThisOnes != null && notThisOnes.size() > 0)
    {
        hql += "    and tem.id not in (";
        for (int i = 0; i < notThisOnes.size(); i++)
        {
            hql += notThisOnes.get(i).getID_TemplateBo();
            if (i < (notThisOnes.size() - 1))
            {
                hql += ",";
            }
        }

        hql += " )";
    }

    // Only not configured or configured for this category
    if (cat != null)
    {
        hql += " and tem.id not in " + "(select dtem.id from DocumentCategoryConfig as dcc left join dcc.template as dtem " + "where (dcc.category.id <> :cat))  ";
        paramNames.add("cat");
        paramValues.add(cat.getId());
    }

    hql += ") order by upper(rep.reportName) asc, upper(tem.name) asc";//       WDEV-13654

    List<?> dOs = getDomainFactory().find(hql, paramNames, paramValues);
    if (dOs == null || dOs.size() == 0)
        return null;
    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(dOs);

}
项目:openMAXIMS    文件:ClinicLetterBatchCreateImpl.java   
public TemplateForPatientDocumentVoCollection searchReports(String templateName, String listOfMandatorySeeds, DocumentCategory documentType, Specialty specialty) 
{
    DomainFactory factory = getDomainFactory();
    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    String subHql = "";

    if(listOfMandatorySeeds != null && listOfMandatorySeeds.length() > 0)
    {
        subHql = " and r21.bOName not in (" + listOfMandatorySeeds + ")";
    }

    String mainHql = "select t from DocumentCategoryConfig as d left join d.template as t left join t.report as r";
    String whereHql = " where t.id not in (select t11.id from TemplateBo as t11 left join t11.report as r11 left join r11.seeds as r21  where (r21.canBeNull = 0" + subHql + ")) and r.reportXml is not null  and t.templateXml is not null and r.isActive = 1 and t.isActive = 1";//WDEV-13547

    if(templateName != null && templateName.length() > 0)
    {
        whereHql += " and upper(t.name) like :templateName";//WDEV-13750
        markers.add("templateName");
        values.add(templateName.toUpperCase() + "%");//WDEV-13750
    }

    if(documentType != null)
    {
        whereHql += " and d.category.id = :catId";
        markers.add("catId");
        values.add(documentType.getID());
    }

    if(specialty != null)
    {
        mainHql += " left join d.specialty as s left join s.instance as i";
        whereHql += " and i.id = :specialtyId";
        markers.add("specialtyId");
        values.add(specialty.getID());
    }

    String hql = mainHql + whereHql + " order by upper(r.reportName) asc, upper(t.name) asc";//WDEV-13547
    List<?> list = factory.find(hql, markers, values);

    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(list);//WDEV-13547
}
项目:openMAXIMS    文件:DocumentCategoryConfigImpl.java   
/**
 * List all the Reports that are active
 */
public TemplateForPatientDocumentVoCollection listReports(String templateName, TemplateBoRefVoCollection notThisOnes, DocumentCategory cat)
{

    String hql = "select tem from TemplateBo as tem left join tem.report as rep where (tem.name like :name and tem.isActive = 1 and rep.isActive = 1 and tem.isRIE is null ";
    ArrayList<String> paramNames = new ArrayList<String>();
    paramNames.add("name");
    ArrayList<Object> paramValues = new ArrayList<Object>();
    paramValues.add(templateName != null ? "%" + templateName + "%" : "%");

    if (notThisOnes != null && notThisOnes.size() > 0)
    {
        hql += "    and tem.id not in (";
        for (int i = 0; i < notThisOnes.size(); i++)
        {
            hql += notThisOnes.get(i).getID_TemplateBo();
            if (i < (notThisOnes.size() - 1))
            {
                hql += ",";
            }
        }

        hql += " )";
    }

    // Only not configured or configured for this category
    if (cat != null)
    {
        hql += " and tem.id not in " + "(select dtem.id from DocumentCategoryConfig as dcc left join dcc.template as dtem " + "where (dcc.category.id <> :cat))  ";
        paramNames.add("cat");
        paramValues.add(cat.getId());
    }

    hql += ") order by upper(rep.reportName) asc, upper(tem.name) asc";//       WDEV-13654

    List<?> dOs = getDomainFactory().find(hql, paramNames, paramValues);
    if (dOs == null || dOs.size() == 0)
        return null;
    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(dOs);

}
项目:openMAXIMS    文件:ClinicLetterBatchCreateImpl.java   
public TemplateForPatientDocumentVoCollection searchReports(String templateName, String listOfMandatorySeeds, DocumentCategory documentType, Specialty specialty) 
{
    DomainFactory factory = getDomainFactory();
    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    String subHql = "";

    if(listOfMandatorySeeds != null && listOfMandatorySeeds.length() > 0)
    {
        subHql = " and r21.bOName not in (" + listOfMandatorySeeds + ")";
    }

    String mainHql = "select t from DocumentCategoryConfig as d left join d.template as t left join t.report as r";
    String whereHql = " where t.id not in (select t11.id from TemplateBo as t11 left join t11.report as r11 left join r11.seeds as r21  where (r21.canBeNull = 0" + subHql + ")) and r.reportXml is not null  and t.templateXml is not null and r.isActive = 1 and t.isActive = 1";//WDEV-13547

    if(templateName != null && templateName.length() > 0)
    {
        whereHql += " and upper(t.name) like :templateName";//WDEV-13750
        markers.add("templateName");
        values.add(templateName.toUpperCase() + "%");//WDEV-13750
    }

    if(documentType != null)
    {
        whereHql += " and d.category.id = :catId";
        markers.add("catId");
        values.add(documentType.getID());
    }

    if(specialty != null)
    {
        mainHql += " left join d.specialty as s left join s.instance as i";
        whereHql += " and i.id = :specialtyId";
        markers.add("specialtyId");
        values.add(specialty.getID());
    }

    String hql = mainHql + whereHql + " order by upper(r.reportName) asc, upper(t.name) asc";//WDEV-13547
    List<?> list = factory.find(hql, markers, values);

    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(list);//WDEV-13547
}
项目:openmaxims-linux    文件:DocumentCategoryConfigImpl.java   
/**
 * List all the Reports that are active
 */
public TemplateForPatientDocumentVoCollection listReports(String templateName, TemplateBoRefVoCollection notThisOnes, DocumentCategory cat)
{

    String hql = "select tem from TemplateBo as tem left join tem.report as rep where (tem.name like :name and tem.isActive = 1 and rep.isActive = 1 and tem.isRIE is null ";
    ArrayList<String> paramNames = new ArrayList<String>();
    paramNames.add("name");
    ArrayList<Object> paramValues = new ArrayList<Object>();
    paramValues.add(templateName != null ? "%" + templateName + "%" : "%");

    if (notThisOnes != null && notThisOnes.size() > 0)
    {
        hql += "    and tem.id not in (";
        for (int i = 0; i < notThisOnes.size(); i++)
        {
            hql += notThisOnes.get(i).getID_TemplateBo();
            if (i < (notThisOnes.size() - 1))
            {
                hql += ",";
            }
        }

        hql += " )";
    }

    // Only not configured or configured for this category
    if (cat != null)
    {
        hql += " and tem.id not in " + "(select dtem.id from DocumentCategoryConfig as dcc left join dcc.template as dtem " + "where (dcc.category.id <> :cat))  ";
        paramNames.add("cat");
        paramValues.add(cat.getId());
    }

    hql += ") order by upper(rep.reportName) asc, upper(tem.name) asc";//       WDEV-13654

    List<?> dOs = getDomainFactory().find(hql, paramNames, paramValues);
    if (dOs == null || dOs.size() == 0)
        return null;
    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(dOs);

}
项目:openmaxims-linux    文件:ClinicLetterBatchCreateImpl.java   
public TemplateForPatientDocumentVoCollection searchReports(String templateName, String listOfMandatorySeeds, DocumentCategory documentType, Specialty specialty) 
{
    DomainFactory factory = getDomainFactory();
    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    String subHql = "";

    if(listOfMandatorySeeds != null && listOfMandatorySeeds.length() > 0)
    {
        subHql = " and r21.bOName not in (" + listOfMandatorySeeds + ")";
    }

    String mainHql = "select t from DocumentCategoryConfig as d left join d.template as t left join t.report as r";
    String whereHql = " where t.id not in (select t11.id from TemplateBo as t11 left join t11.report as r11 left join r11.seeds as r21  where (r21.canBeNull = 0" + subHql + ")) and r.reportXml is not null  and t.templateXml is not null and r.isActive = 1 and t.isActive = 1";//WDEV-13547

    if(templateName != null && templateName.length() > 0)
    {
        whereHql += " and upper(t.name) like :templateName";//WDEV-13750
        markers.add("templateName");
        values.add(templateName.toUpperCase() + "%");//WDEV-13750
    }

    if(documentType != null)
    {
        whereHql += " and d.category.id = :catId";
        markers.add("catId");
        values.add(documentType.getID());
    }

    if(specialty != null)
    {
        mainHql += " left join d.specialty as s left join s.instance as i";
        whereHql += " and i.id = :specialtyId";
        markers.add("specialtyId");
        values.add(specialty.getID());
    }

    String hql = mainHql + whereHql + " order by upper(r.reportName) asc, upper(t.name) asc";//WDEV-13547
    List<?> list = factory.find(hql, markers, values);

    return TemplateForPatientDocumentVoAssembler.createTemplateForPatientDocumentVoCollectionFromTemplateBo(list);//WDEV-13547
}