decode是sql中的三目函数

decode是sql中的三目函数

 

public QueryResult getHistoryRecords(Map<String, Object> params, Integer pageIdx, Integer pageSize)

    throws Exception

  {

    if ((params == null) || (params.get("CUSTOMER_KEY") == null)) {

      return null;

    }

    StringBuffer sql = new StringBuffer();

    Map<String, Object> paraMap = new HashMap();

    sql.append(" SELECT T.*,T1.CUSTOMER_ID,T1.CUSTOMER_STATUS,T1.CUSTOMER_NAME ,DECODE((SELECT COUNT(1) FROM TB_USER_BLIST T2 WHERE T2.BLIST_CUSTOMER_KEY=T.WL_CUSTOMER_KEY and T2.CUSTOMER_KEY=:CUSTOMER_KEY),0,'N','Y'  ) STATUS ");

    sql.append(" FROM VW_USER_WL T LEFT JOIN TB_CUS_FIRM T1 ON T.WL_CUSTOMER_KEY=T1.CUSTOMER_KEY WHERE 1=1 ");

    sql.append(" AND T.CUSTOMER_KEY =:CUSTOMER_KEY ");

    paraMap.put("CUSTOMER_KEY", params.get("CUSTOMER_KEY"));

    

    return this.commonDao.findMapDatas(sql.toString() + " ORDER BY T.WL_TIME DESC", paraMap, pageIdx, pageSize);

  }