public HashMap<String, Object> getBorrow_failrecheckList(PageData pd, ModelAndView mv) {
    Connection conn = MySQL.getConnectionReadOnly(true);

    HashMap<String, Object> list = null;
    HashMap<String, Object> rp = new HashMap<String, Object>();
    WhereUtil whereUtil = new WhereUtil();
    whereUtil.setAlias("m", "user");
    whereUtil.setAlias("bi", "borrow_info");
    whereUtil.setAlias("v", "borrow_verify");
    whereUtil.parseSearchMap(pd, whereUtil, conn);
    whereUtil.getStringCondition("borrow_status", "5", "=");
    HashMap<String, String> defaultMap = whereUtil.getCommonMap();

    rp.put("paramCondition", whereUtil.getParamConditionList());
    mv.addObject("defaultMap", defaultMap);

    // 注册时间
    baseService.timeFrame("bi.add_time", whereUtil, pd, mv);

    // 影响积分
    baseService.compareNum("bi.borrow_money", whereUtil, pd, mv);

    try {

      list = thisDao.getBorrow_failrecheckList(conn, rp);
    } catch (Exception e) {
      logger.error("getBorrow_checkList失败", e);
    } finally {
      MySQL.closeConnection(conn);
    }
    return list;
  }
예제 #2
0
  public HashMap<String, Object> getUser_referList(PageData pd, ModelAndView mv) {
    Connection conn = MySQL.getConnectionReadOnly(true);

    HashMap<String, Object> list = null;
    HashMap<String, Object> rp = new HashMap<String, Object>();
    WhereUtil whereUtil = new WhereUtil();
    whereUtil.setAlias("m", "user");
    whereUtil.setAlias("rm", "user");
    whereUtil.setAlias("mi", "user_info");
    whereUtil.parseSearchMap(pd, whereUtil, conn);
    HashMap<String, String> defaultMap = whereUtil.getCommonMap();

    rp.put("paramCondition", whereUtil.getParamConditionList());
    if (pd.rqst().containsKey("pagebar")) rp.put("pagebar", pd.rqst("pagebar"));
    mv.addObject("defaultMap", defaultMap);

    // 是否VIP
    baseService.isVip("isVip", whereUtil, pd, mv);

    // 注册时间
    baseService.timeFrame("m.reg_time", whereUtil, pd, mv);

    try {

      list = thisDao.getUser_referList(conn, rp);
    } catch (Exception e) {
      logger.error("getUser_bankList失败", e);
    } finally {
      MySQL.closeConnection(conn);
    }
    return list;
  }