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;
  }
Exemple #2
0
  @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);
  }
  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;
  }