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;
}
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;
}