Example usage for org.hibernate.type StringType StringType

Introduction

In this page you can find the example usage for org.hibernate.type StringType StringType.

Prototype

public StringType() 

Source Link

Usage

From source file:br.gov.jfrj.siga.wf.relatorio.RelTempoDoc.java

License:Open Source License

/**
 * Retorna os docs no perodo indicado, ordenadas pelo tempo de
 * demora, podendo estar ou no finalizados.
 * /*ww w .j ava2  s.co  m*/
 * Exemplo da query:
 * 
 * SELECT PI.START_,PI.END_,VI.STRINGVALUE_,PI.ID_ FROM
 * SIGAWF.JBPM_PROCESSINSTANCE PI, (SELECT DISTINCT PROCESSINSTANCE_,
 * STRINGVALUE_ FROM SIGAWF.JBPM_VARIABLEINSTANCE WHERE NAME_ LIKE 'doc_%'
 * AND STRINGVALUE_ LIKE '%-_' AND STRINGVALUE_ IS NOT NULL) VI, (SELECT *
 * FROM SIGAWF.JBPM_PROCESSDEFINITION WHERE NAME_ = 'Contratao: fase de
 * anlise') PD WHERE PI.PROCESSDEFINITION_=PD.ID_ AND PI.END_ IS NOT NULL
 * AND PI.ID_ = VI.PROCESSINSTANCE_ AND (PI.START_ >= To_Date('01/03/2011')
 * and PI.START_ <= To_Date('31/03/2011')) AND (PI.END_ >=
 * To_Date('01/03/2011') and PI.END_ <= To_Date('31/05/2011')) ;
 * 
 * 
 * @param dataInicial
 * @param dataFinal
 * @param dataFinalAte
 * @param dataFinalDe
 * @param incluirAbertos 
 * @return
 */
private Set<Doc> consultarDocs(String nomeProcedimento, Date dataInicialDe, Date dataInicialAte,
        Date dataFinalDe, Date dataFinalAte, Boolean incluirAbertos) {
    SQLQuery query = null;
    if (incluirAbertos) {
        query = (SQLQuery) WfDao.getInstance().getSessao()
                .createSQLQuery(getSQLConsultarDocumentosFinalizadosEAbertosNoPeriodo());
    } else {
        query = (SQLQuery) WfDao.getInstance().getSessao()
                .createSQLQuery(getSQLConsultarDocumentosFinalizadosNoPeriodo());
    }

    query.addScalar("START_", new CalendarType());
    query.addScalar("END_", new CalendarType());
    query.addScalar("STRINGVALUE_", new StringType());
    query.addScalar("ID_", new LongType());

    dataInicialAte = inclusiveData(dataInicialAte);
    dataFinalAte = inclusiveData(dataFinalAte);

    query.setString("nomeProcedimento", nomeProcedimento);
    query.setDate("dataInicialDe", dataInicialDe);
    query.setDate("dataInicialAte", dataInicialAte);
    query.setDate("dataFinalDe", dataFinalDe);
    query.setDate("dataFinalAte", dataFinalAte);
    List<Object[]> resultado = query.list();
    Set<Doc> docs = new TreeSet<Doc>(new DocComparator());
    for (Object[] o : resultado) {
        Doc s = new Doc();
        Calendar inicio = (Calendar) o[0];
        Calendar fim = (Calendar) o[1];
        s.setNumeroDoc(o[2].toString());
        s.setInicio(inicio);
        s.setFim(fim);
        s.setProcessInstanceID((Long) (o[3]));
        docs.add(s);
    }

    return docs;
}

---

From source file:br.gov.jfrj.siga.wf.relatorio.RelTempoDocDetalhado.java

License:Open Source License

private Set<Tarefa> consultarTarefas(String nomeProcedimento, Date dataInicialDe, Date dataInicialAte,
        Date dataFinalDe, Date dataFinalAte, Boolean incluirAbertos) {
    // ArrayList<Tarefa> tarefas = new ArrayList<Tarefa>();
    // Tarefa t1 = new Tarefa();
    // Tarefa t2 = new Tarefa();
    ///*from   w ww.  ja  va  2s .  com*/
    // t1.setNome("t1");
    // t1.setDataFim("01/01/2000");
    // t1.setDataInicio("01/01/2000");
    // t1.setDuracao("5 seg");
    //
    // t2.setNome("t2");
    // t2.setDataFim("01/01/1999");
    // t2.setDataInicio("01/01/1888");
    // t2.setDuracao("5 seg");
    //
    // tarefas.add(t1);
    // tarefas.add(t2);
    // return tarefas;

    // String sql =
    // "SELECT PI.START_,PI.END_,VI.STRINGVALUE_,PI.ID_ FROM JBPM_PROCESSINSTANCE PI, (SELECT DISTINCT PROCESSINSTANCE_, STRINGVALUE_ FROM JBPM_VARIABLEINSTANCE WHERE NAME_ LIKE 'doc_%' AND STRINGVALUE_ LIKE '%-_' AND STRINGVALUE_ IS NOT NULL) VI, (SELECT ID_ FROM JBPM_PROCESSDEFINITION WHERE NAME_ = :nomeProcedimento) PD WHERE PI.PROCESSDEFINITION_=PD.ID_ AND PI.END_ IS NOT NULL AND PI.ID_ = VI.PROCESSINSTANCE_ AND  (PI.START_ >= :dataInicialDe and PI.START_ <= :dataInicialAte) AND (PI.END_ >= :dataFinalDe and PI.END_ <= :dataFinalAte)";

    SQLQuery query = null;
    if (incluirAbertos) {
        query = (SQLQuery) WfDao.getInstance().getSessao()
                .createSQLQuery(getSQLConsultarDocumentosFinalizadosEAbertosNoPeriodo());
    } else {
        query = (SQLQuery) WfDao.getInstance().getSessao()
                .createSQLQuery(getSQLConsultarDocumentosFinalizadosNoPeriodo());
    }

    query.addScalar("stringvalue_", new StringType());
    query.addScalar("pd_name", new StringType());
    query.addScalar("p_start", new CalendarType());
    query.addScalar("p_end", new CalendarType());
    query.addScalar("t_name", new StringType());
    query.addScalar("t_create", new CalendarType());
    query.addScalar("t_end", new CalendarType());

    query.setString("nomeProcedimento", nomeProcedimento);
    query.setDate("dataInicialDe", dataInicialDe);
    query.setDate("dataInicialAte", dataInicialAte);
    query.setDate("dataFinalDe", dataFinalDe);
    query.setDate("dataFinalAte", dataFinalAte);

    List<Object[]> resultado = query.list();
    Set<Tarefa> tarefas = new TreeSet<Tarefa>(new TarefaComparator());
    for (Object[] o : resultado) {
        Tarefa t = new Tarefa();
        t.setDataInicioProcedimento((Calendar) o[2]);
        t.setDataFimProcedimento((Calendar) o[3]);
        t.setNumeroDocumento((String) o[0]);
        t.setNome((String) o[4]);
        t.setDataInicio((Calendar) o[5]);
        t.setDataFim((Calendar) o[6]);

        tarefas.add(t);

    }
    // Set<Doc> secs = new TreeSet<Doc>(new DocComparator());
    // for (Object[] o : resultado) {
    // Doc s = new Doc();
    // Calendar inicio = (Calendar) o[0];
    // Calendar fim = (Calendar) o[1];
    // s.setNumeroDoc(o[2].toString());
    // s.setInicio(inicio);
    // s.setFim(fim);
    // s.setProcessInstanceID((Long) (o[3]));
    // secs.add(s);
    // }
    //
    return tarefas;

}

---

From source file:com.amalto.core.storage.hibernate.ClassNameProjection.java

License:Open Source License

@Override
public Type[] getTypes(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException {
    return new Type[] { new StringType() };
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getListProviderFromMineName(String mineName, Map<String, String> map) {
    List<AppParamsDTO> listAppParams = null;
    String taxAuthority = map.get("taxAuthority");
    String startFromDate = map.get("startFromDate");
    String endFromDate = map.get("endFromDate");
    String startToDate = map.get("startToDate");
    String endToDate = map.get("endToDate");
    String fromDateRegister = map.get("fromDateRegister");
    String toDateRegister = map.get("toDateRegister");
    StringBuilder sb = new StringBuilder();
    sb.append("      SELECT    PAR_ID parId,   ");
    sb.append("              DESCRIPTION description,   ");
    sb.append("              PAR_CODE parCode,   ");
    sb.append("              PAR_NAME parName,   ");
    sb.append("              PAR_ORDER parOrder,   ");
    sb.append("              PAR_TYPE parType,   ");
    sb.append("              STATUS status   ");
    sb.append("        FROM APP_PARAMS a   ");
    sb.append("        WHERE a.PAR_TYPE = 'PROVIDER' ");
    sb.append("                     AND lower(a.PAR_CODE) = ANY   ");
    sb.append("              (SELECT DISTINCT lower(ti.PROVIDER)   ");
    sb.append("                 FROM TERM_INFORMATION ti   ");
    sb.append(/* w  w w. j a  v a 2 s  . com*/
            "                 LEFT JOIN CUSTOMER_STATUS cs on ti.TAX_CODE=cs.TAX_CODE and ti.MINE_NAME = cs.MINE_NAME ");
    sb.append("                 JOIN CUSTOMER c on c.TAX_CODE = ti.TAX_CODE ");
    sb.append("                 WHERE ti.IS_CONTACT_INFO is null AND cs.TAX_CODE IS NULL   ");
    sb.append("                 AND ti.MINE_NAME = ANY (:mineName)   ");

    if (!DataUtil.isStringNullOrEmpty(taxAuthority)) {
        sb.append("         and c.TAX_AUTHORITY = ANY(:taxAuthority)   ");
    }

    if (!DataUtil.isStringNullOrEmpty(startFromDate)) {
        sb.append("         and ti.START_TIME >= TO_DATE(:startFromDate,'dd/MM/yyyy') - 1   ");
    }
    if (!DataUtil.isStringNullOrEmpty(endFromDate)) {
        sb.append("         and ti.START_TIME <= TO_DATE(:endFromDate,'dd/MM/yyyy')   + 1 ");
    }
    if (!DataUtil.isStringNullOrEmpty(startToDate)) {
        sb.append("         and ti.END_TIME >= TO_DATE(:startToDate,'dd/MM/yyyy') - 1    ");
    }
    if (!DataUtil.isStringNullOrEmpty(endToDate)) {
        sb.append("         and ti.END_TIME <= TO_DATE(:endToDate,'dd/MM/yyyy') + 1   ");
    }
    if (!DataUtil.isStringNullOrEmpty(fromDateRegister)) {
        sb.append("   AND ti.DATE_REGISTER >= TO_DATE(:fromDateRegister,'dd/MM/yyyy') - 1 ");
    }
    if (!DataUtil.isStringNullOrEmpty(toDateRegister)) {
        sb.append("   AND ti.DATE_REGISTER <= TO_DATE(:toDateRegister,'dd/MM/yyyy') + 1");
    }
    sb.append("              )   ");
    sb.append("        ORDER BY a.PAR_CODE asc   ");
    SQLQuery query;
    try {
        query = getSession().createSQLQuery(sb.toString());
        //Thuc hien chuyen du lieu lay ve thanh thanh doi tuong            
        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
        if (!DataUtil.isStringNullOrEmpty(taxAuthority)) {
            query.setParameterList("taxAuthority", DataUtil.parseInputListString(taxAuthority));
        }
        if (!DataUtil.isStringNullOrEmpty(startFromDate)) {
            query.setString("startFromDate", startFromDate);
        }
        if (!DataUtil.isStringNullOrEmpty(endFromDate)) {
            query.setString("endFromDate", endFromDate);
        }
        if (!DataUtil.isStringNullOrEmpty(startToDate)) {
            query.setString("startToDate", startToDate);
        }
        if (!DataUtil.isStringNullOrEmpty(endToDate)) {
            query.setString("endToDate", endToDate);
        }
        if (!DataUtil.isStringNullOrEmpty(fromDateRegister)) {
            query.setString("fromDateRegister", fromDateRegister);
        }
        if (!DataUtil.isStringNullOrEmpty(toDateRegister)) {
            query.setString("toDateRegister", toDateRegister);
        }
        listAppParams = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return listAppParams;
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getProviderFromStaffCode(String staffCode, String mineName) {
    List<AppParamsDTO> lstCategoryList = null;
    StringBuilder sb = new StringBuilder();
    sb.append("   SELECT    PAR_ID parId,   ");
    sb.append("           DESCRIPTION description,   ");
    sb.append("           PAR_CODE parCode,   ");
    sb.append("           PAR_NAME parName,   ");
    sb.append("           PAR_ORDER parOrder,   ");
    sb.append("           PAR_TYPE parType,   ");
    sb.append("           STATUS status   ");
    sb.append("        FROM APP_PARAMS a   ");
    sb.append("    WHERE        a.PAR_TYPE       = 'PROVIDER' ");
    sb.append("         AND a.STATUS = '1' ");
    sb.append("         AND lower(a.PAR_CODE) IN ");
    sb.append("      ( SELECT DISTINCT lower(ti.provider) ");
    sb.append("        FROM TERM_INFORMATION ti ");
    sb.append("        WHERE ti.IS_CONTACT_INFO is NULL AND exists ");
    sb.append("             (   SELECT DISTINCT cs.tax_code ");
    sb.append("                 FROM customer_status cs ");
    sb.append("                 WHERE 1 = 1 ");
    sb.append("                 AND cs.tax_code = ti.tax_code  ");
    if (!StringUtils.isStringNullOrEmpty(staffCode)) {
        sb.append("             AND cs.staff_code = :staffCode ");
    } else { //Add 15/04/2017 Them dieu kien neu la admin
        return getProviderFromMineName(mineName);
    }// w  w w.j av a2 s  .  c o  m
    if (!StringUtils.isStringNullOrEmpty(mineName)) {
        if (mineName.contains(",")) {
            sb.append("             AND cs.mine_name IN (:mineName) ");
        } else {
            sb.append("             AND cs.mine_name = :mineName ");
        }
    }
    sb.append("             ) ");
    sb.append("      ) ");
    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        //            if (!DataUtil.isStringNullOrEmpty(mineName)) {
        //                
        //                query.setParameter("mineName", mineName);
        //            }
        if (!DataUtil.isStringNullOrEmpty(mineName)) {
            if (mineName.contains(",")) {
                query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
            } else {
                query.setParameter("mineName", mineName);
            }
        }
        if (!StringUtils.isStringNullOrEmpty(staffCode)) {
            query.setParameter("staffCode", staffCode);
        }
        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getProviderFromStaffCodeAndConditions(String staffCode, Map<String, String> map) {

    List<AppParamsDTO> lstCategoryList = null;
    String mineName = map.get("mineName");
    String taxAuthority = map.get("taxAuthority");
    String status = map.get("status");

    if (StringUtils.isStringNullOrEmpty(staffCode)) {
        //Add 17/04/2017 Them dieu kien neu la admin + cac dieu kien status, tinh
        return getProviderFromOtherConditions(mineName, taxAuthority, status);
    }//from   ww  w  .j  ava 2  s .  c o m
    StringBuilder sb = new StringBuilder();
    sb.append("   SELECT    PAR_ID parId,   ");
    sb.append("           DESCRIPTION description,   ");
    sb.append("           PAR_CODE parCode,   ");
    sb.append("           PAR_NAME parName,   ");
    sb.append("           PAR_ORDER parOrder,   ");
    sb.append("           PAR_TYPE parType,   ");
    sb.append("           STATUS status   ");
    sb.append("        FROM APP_PARAMS a   ");
    sb.append("    WHERE        a.PAR_TYPE       = 'PROVIDER' ");
    sb.append("         AND a.STATUS = '1' ");
    sb.append("         AND lower(a.PAR_CODE) IN ");
    sb.append("      ( SELECT DISTINCT lower(ti.provider) ");
    sb.append("        FROM TERM_INFORMATION ti ");

    if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
        sb.append("        INNER JOIN CUSTOMER c ON c.TAX_CODE = ti.TAX_CODE ");
    }
    sb.append("        WHERE 1= 1 ");
    if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
        sb.append("    AND c.TAX_AUTHORITY = ANY(:taxAuthority) ");
    }
    sb.append("        AND  exists ");
    sb.append("             (   SELECT DISTINCT cs.tax_code ");
    sb.append("                 FROM customer_status cs ");
    sb.append("                 WHERE 1 = 1  ");
    sb.append("                 AND cs.tax_code = ti.tax_code  ");
    if (!StringUtils.isStringNullOrEmpty(status)) {
        sb.append("                 AND cs.status = ANY (:status) ");
    }
    if (!StringUtils.isStringNullOrEmpty(staffCode)) {
        sb.append("             AND cs.staff_code = :staffCode ");
    } else { //Add 17/04/2017 Them dieu kien neu la admin + cac dieu kien status, tinh
        return getProviderFromOtherConditions(mineName, taxAuthority, status);
    }
    if (!StringUtils.isStringNullOrEmpty(mineName)) {
        if (mineName.contains(",")) {
            sb.append("             AND cs.mine_name IN (:mineName) ");
        } else {
            sb.append("             AND cs.mine_name = :mineName ");
        }
    }
    sb.append("             ) ");
    sb.append("      ) ");
    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        if (!DataUtil.isStringNullOrEmpty(mineName)) {
            if (mineName.contains(",")) {
                query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
            } else {
                query.setParameter("mineName", mineName);
            }
        }
        if (!StringUtils.isStringNullOrEmpty(staffCode)) {
            query.setParameter("staffCode", staffCode);
        }
        if (!StringUtils.isStringNullOrEmpty(status)) {
            query.setParameterList("status", DataUtil.parseInputListString(status));
        }
        if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
            query.setParameterList("taxAuthority", DataUtil.parseInputListString(taxAuthority));
        }
        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getProviderFromMineName(String mineName) {
    List<AppParamsDTO> lstCategoryList = null;
    StringBuilder sb = new StringBuilder();
    sb.append("   SELECT    ap.PAR_ID parId,   ");
    sb.append("           ap.DESCRIPTION description,   ");
    sb.append("           ap.PAR_CODE parCode,   ");
    sb.append("           ap.PAR_NAME parName,   ");
    sb.append("           ap.PAR_ORDER parOrder,   ");
    sb.append("           ap.PAR_TYPE parType,   ");
    sb.append("           ap.STATUS status   ");
    sb.append("   FROM APP_PARAMS ap ");
    sb.append("   WHERE PAR_CODE IN ");
    sb.append("     (SELECT DISTINCT provider ");
    sb.append("     FROM term_information ti ");
    sb.append("     WHERE ti.IS_CONTACT_INFO is NULL AND lower(ti.PROVIDER) LIKE (lower(ap.par_code)||'%') ");
    if (!StringUtils.isStringNullOrEmpty(mineName)) {
        if (mineName.contains(",")) {
            sb.append("             AND ti.mine_name IN (:mineName) ");
        } else {/*from   w ww. j  a v a  2  s  .  c o m*/
            sb.append("             AND ti.mine_name = :mineName ");
        }
        //            sb.append("     AND ti.MINE_NAME = :mineName ");
    }
    sb.append("     ) ");
    sb.append("   ORDER BY ap.PAR_ORDER ");

    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        if (!DataUtil.isStringNullOrEmpty(mineName)) {
            if (mineName.contains(",")) {
                query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
            } else {
                query.setParameter("mineName", mineName);
            }
        }

        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getProviderFromOtherConditions(String mineName, String taxAuthority, String status) {
    List<AppParamsDTO> lstCategoryList = null;
    StringBuilder sb = new StringBuilder();
    sb.append("   SELECT    ap.PAR_ID parId,   ");
    sb.append("           ap.DESCRIPTION description,   ");
    sb.append("           ap.PAR_CODE parCode,   ");
    sb.append("           ap.PAR_NAME parName,   ");
    sb.append("           ap.PAR_ORDER parOrder,   ");
    sb.append("           ap.PAR_TYPE parType,   ");
    sb.append("           ap.STATUS status   ");
    sb.append("   FROM APP_PARAMS ap ");
    sb.append("   WHERE lower(PAR_CODE) IN ");
    sb.append("     (SELECT DISTINCT lower(provider) ");
    sb.append("     FROM term_information ti ");
    if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
        sb.append("     INNER JOIN CUSTOMER c ON c.TAX_CODE = ti.TAX_CODE ");
    }/*from  ww w.  ja  v  a  2 s  .  c  o  m*/
    if (!StringUtils.isStringNullOrEmpty(status)) {
        sb.append("     INNER JOIN CUSTOMER_STATUS cs ON cs.TAX_CODE = ti.TAX_CODE ");
    }
    sb.append("     WHERE ti.IS_CONTACT_INFO is NULL AND lower(ti.PROVIDER) = (lower(ap.par_code))");
    if (!StringUtils.isStringNullOrEmpty(mineName)) {
        if (mineName.contains(",")) {
            sb.append("             AND ti.mine_name IN (:mineName) ");
        } else {
            sb.append("             AND ti.mine_name = :mineName ");
        }
    }
    if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
        sb.append("     AND c.TAX_AUTHORITY = ANY (:taxAuthority) ");
    }
    if (!StringUtils.isStringNullOrEmpty(status)) {
        sb.append("     AND cs.STATUS = :status ");
    }
    sb.append("     ) ");
    sb.append("   ORDER BY ap.PAR_ORDER ");

    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        if (!DataUtil.isStringNullOrEmpty(mineName)) {
            if (mineName.contains(",")) {
                query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
            } else {
                query.setParameter("mineName", mineName);
            }
        }
        if (!StringUtils.isStringNullOrEmpty(taxAuthority)) {
            query.setParameterList("taxAuthority", DataUtil.parseInputListString(taxAuthority));
        }
        if (!StringUtils.isStringNullOrEmpty(status)) {
            query.setParameter("status", status);
        }
        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

From source file:com.cms.dao.AppParamsDAO.java

License:Open Source License

public List<AppParamsDTO> getStatusFromStaffCode(String staffCode, String mineName) {
    List<AppParamsDTO> lstCategoryList = null;
    StringBuilder sb = new StringBuilder();
    sb.append("   SELECT    PAR_ID parId,   ");
    sb.append("           DESCRIPTION description,   ");
    sb.append("           PAR_CODE parCode,   ");
    sb.append("           PAR_NAME parName,   ");
    sb.append("           PAR_ORDER parOrder,   ");
    sb.append("           PAR_TYPE parType,   ");
    sb.append("           STATUS status   ");
    sb.append("        FROM APP_PARAMS a   ");
    sb.append("    WHERE        a.PAR_TYPE       = 'CUSTOMER_SERVICE_STATUS' ");
    sb.append("         AND a.STATUS = '1' ");
    sb.append("         AND a.PAR_CODE IN ");
    sb.append("             (   SELECT DISTINCT cs.status ");
    sb.append("                 FROM customer_status cs ");
    sb.append("                 WHERE 1 = 1  ");
    if (!StringUtils.isStringNullOrEmpty(staffCode)) {
        sb.append("             AND cs.staff_code = :staffCode ");
    }//  www  . j a v a  2  s .  c  o m
    if (!StringUtils.isStringNullOrEmpty(mineName)) {
        if (mineName.contains(",")) {
            sb.append("             AND cs.mine_name IN (:mineName) ");
        } else {
            sb.append("             AND cs.mine_name = :mineName ");
        }
    }
    sb.append("             ) ");
    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        if (!DataUtil.isStringNullOrEmpty(mineName)) {
            if (mineName.contains(",")) {
                query.setParameterList("mineName", DataUtil.parseInputListString(mineName));
            } else {
                query.setParameter("mineName", mineName);
            }

        }
        if (!StringUtils.isStringNullOrEmpty(staffCode)) {
            query.setParameter("staffCode", staffCode);
        }
        query.setResultTransformer(Transformers.aliasToBean(AppParamsDTO.class));
        query.addScalar("parId", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("parCode", new StringType());
        query.addScalar("parName", new StringType());
        query.addScalar("parOrder", new StringType());
        query.addScalar("parType", new StringType());
        query.addScalar("status", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

From source file:com.cms.dao.CategoryListDAO.java

License:Open Source License

public List<CategoryListDTO> getCategoryListFromStaffCode(String staffCode, String service) {
    List<CategoryListDTO> lstCategoryList = null;
    StringBuilder sb = new StringBuilder();
    sb.append("    SELECT cl.code code, ");
    sb.append("      cl.id id, ");
    sb.append("      cl.name name, ");
    sb.append("      to_char(cl.RECEIVED_DATE,'dd/MM/yyyy') receivedDate, ");
    sb.append("      to_char(cl.END_DATE,'dd/MM/yyyy') endDate, ");
    sb.append("      cl.DESCRIPTION description, ");
    sb.append("      cl.CREATOR creator ");
    sb.append("    FROM category_list cl ");
    sb.append("    WHERE cl.ID IN ");
    sb.append("      (SELECT DISTINCT mine_name FROM customer_status WHERE 1 = 1 ");
    if (!DataUtil.isStringNullOrEmpty(staffCode)) {
        sb.append("      AND staff_code= :staffCode ");
    }/*from w ww .  j  a v a2  s.  c om*/
    sb.append("      ) ");
    if (!DataUtil.isStringNullOrEmpty(service)) {
        sb.append("      AND cl.service= :service ");
    }
    sb.append("      AND cl.cust_quantity > 0 ");
    try {
        SQLQuery query = getSession().createSQLQuery(sb.toString());
        if (!DataUtil.isStringNullOrEmpty(staffCode)) {
            query.setParameter("staffCode", staffCode);
        }
        if (!DataUtil.isStringNullOrEmpty(service)) {
            query.setParameter("service", service);
        }
        query.setResultTransformer(Transformers.aliasToBean(CategoryListDTO.class));
        query.addScalar("code", new StringType());
        query.addScalar("id", new StringType());
        query.addScalar("name", new StringType());
        query.addScalar("receivedDate", new StringType());
        query.addScalar("endDate", new StringType());
        query.addScalar("description", new StringType());
        query.addScalar("creator", new StringType());
        lstCategoryList = query.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return lstCategoryList;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »