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;
}
@RequestMapping(value = "/index")
public ModelAndView index(
HttpServletRequest request, HttpServletResponse response, ModelAndView mv) {
mv.addObject("currentTime", Tools.getLongTime());
PageData pd = new PageData(request);
HashMap<String, Object> borrowList = thisService.getBorrowList(pd, mv);
mv.addObject("borrowList", borrowList);
HashMap<String, Object> xborrow = thisService.getXBorrowList();
mv.addObject("xborrow", xborrow.get("data"));
// logger.info("s当是人城"+xborrow);
HashMap<String, String> indexFlashAd = (HashMap<String, String>) Common.getCacheAd("51", false);
if (!Common.isBlankInMap(indexFlashAd, "content"))
mv.addObject(
"indexAdImgs",
(List<HashMap<String, String>>) JacksonUtil.listFromJson(indexFlashAd.get("content")));
// 网站公告
Map<String, Object> notice = categoryService.getCategoryArticle("427", 6);
mv.addObject("notice", notice);
// 公司动态
Map<String, Object> trace = categoryService.getCategoryArticle("389", 3);
mv.addObject("trace", trace);
// 新闻动态
Map<String, Object> news = categoryService.getCategoryArticle("377", 6);
mv.addObject("news", news);
// 图片新闻
Map<String, Object> imgnews = categoryService.getCategoryArticleImg("539", 6);
mv.addObject("imgnews", imgnews);
WhereUtil mapUtil = new WhereUtil();
mapUtil.getStringCondition("borrow_status", "2,4,6,7", "in");
Map<String, String> summary =
BaseService.getOne(
"borrow_info",
mapUtil.getParamConditionList(),
"sum(repayment_interest) as repayment_interest,sum(borrow_money) as borrow_money");
Map<String, String> userSum =
BaseService.getOne("user", Tools.BuildWhereMap("id", "0", ">"), "count(id) as num");
Tools.printData(summary);
summary.put("user_count", userSum.get("num"));
mv.addObject("summary", summary);
return this.getTplView(request, response, tplPath, mv);
}