// 充值查询列表
 @RequestMapping("/rechargeList")
 public String rechargeList(
     @RequestParam(required = false, defaultValue = "1") int pageNumber,
     @RequestParam(required = false, defaultValue = "0") int type,
     @RequestParam(required = false, defaultValue = "") String flow,
     @RequestParam(required = false, defaultValue = "") String account,
     @RequestParam(required = false, defaultValue = "") String name,
     @RequestParam(required = false, defaultValue = "") String mobile,
     @RequestParam(required = false, defaultValue = "0") Double smoney,
     @RequestParam(required = false, defaultValue = "0") Double emoney,
     @RequestParam(required = false, defaultValue = "") String startTime,
     @RequestParam(required = false, defaultValue = "") String endTime,
     HttpServletRequest request) {
   SysUser user = (SysUser) request.getSession().getAttribute("sysUser");
   if (user == null) {
     return "redirect:/admin/login";
   }
   Searchable searchable = new Searchable();
   if (type > 0) {
     searchable.addCondition(
         new Condition("recType", SearchOperator.eq, type == 1 ? "A01" : "A02"));
   }
   if (!flow.equals("")) {
     searchable.addCondition(new Condition("flowNo", SearchOperator.eq, flow));
   }
   if (!account.equals("")) {
     searchable.addCondition(new Condition("account", SearchOperator.eq, account));
   }
   if (!name.equals("")) {
     searchable.addCondition(new Condition("customername", SearchOperator.eq, name));
   }
   if (!mobile.equals("")) {
     searchable.addCondition(new Condition("mobile", SearchOperator.eq, mobile));
   }
   if (smoney > 0) {
     searchable.addCondition(new Condition("amount", SearchOperator.gte, smoney));
   }
   if (emoney > 0) {
     searchable.addCondition(new Condition("amount", SearchOperator.lte, emoney));
   }
   if (!startTime.equals("")) {
     searchable.addCondition(new Condition("recTime", SearchOperator.gte, startTime));
   }
   if (!endTime.equals("")) {
     searchable.addCondition(new Condition("recTime", SearchOperator.lte, endTime));
   }
   searchable.addCondition(new Condition("a.status", SearchOperator.eq, 0));
   PageInfo pageInfo = adminRechargeService.rechargeList(searchable, pageNumber, 20);
   request.setAttribute("page", pageInfo);
   request.setAttribute("type", type);
   request.setAttribute("flow", flow);
   request.setAttribute("account", account);
   request.setAttribute("name", name);
   request.setAttribute("mobile", mobile);
   request.setAttribute("smoney", smoney);
   request.setAttribute("emoney", emoney);
   request.setAttribute("startTime", startTime);
   request.setAttribute("endTime", endTime);
   return "/admin/recharge/rechargeList";
 }
  // 充值导出EXCEL
  @RequestMapping("/exportRechargeList")
  public void exportRechargeList(
      @RequestParam(required = false, defaultValue = "0") int type,
      @RequestParam(required = false, defaultValue = "") String flow,
      @RequestParam(required = false, defaultValue = "") String account,
      @RequestParam(required = false, defaultValue = "") String name,
      @RequestParam(required = false, defaultValue = "") String mobile,
      @RequestParam(required = false, defaultValue = "0") Double smoney,
      @RequestParam(required = false, defaultValue = "0") Double emoney,
      @RequestParam(required = false, defaultValue = "") String startTime,
      @RequestParam(required = false, defaultValue = "") String endTime,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {
    Searchable searchable = new Searchable();
    if (type > 0) {
      searchable.addCondition(
          new Condition("recType", SearchOperator.eq, type == 1 ? "A01" : "A02"));
    }
    if (!flow.equals("")) {
      searchable.addCondition(new Condition("flowNo", SearchOperator.eq, flow));
    }
    if (!account.equals("")) {
      searchable.addCondition(new Condition("account", SearchOperator.eq, account));
    }
    if (!name.equals("")) {
      searchable.addCondition(new Condition("customername", SearchOperator.eq, name));
    }
    if (!mobile.equals("")) {
      searchable.addCondition(new Condition("mobile", SearchOperator.eq, mobile));
    }
    if (smoney > 0) {
      searchable.addCondition(new Condition("amount", SearchOperator.gte, smoney));
    }
    if (emoney > 0) {
      searchable.addCondition(new Condition("amount", SearchOperator.lte, emoney));
    }
    if (!startTime.equals("")) {
      searchable.addCondition(new Condition("recTime", SearchOperator.gte, startTime));
    }
    if (!endTime.equals("")) {
      searchable.addCondition(new Condition("recTime", SearchOperator.lte, endTime));
    }
    searchable.addCondition(new Condition("a.status", SearchOperator.eq, 0));
    Map<String, String> map = new LinkedHashMap<String, String>();
    map.put("编号", "编号");
    map.put("充值方式", "充值方式");
    map.put("第三方流水号", "第三方流水号");
    map.put("账号", "账号");
    map.put("姓名", "姓名");
    //        map.put("充值银行", "充值银行");
    //        map.put("转账银行", "转账银行");
    map.put("交易银行", "交易银行");
    map.put("银行账号", "银行账号");
    map.put("手机号", "手机号");
    map.put("充值金额", "充值金额");
    map.put("充值时间", "充值时间");

    Map<String, String> mapKey = new LinkedHashMap<String, String>();
    mapKey.put("id", "id");
    mapKey.put("recTypes", "recTypes");
    mapKey.put("flowNo", "flowNo");
    mapKey.put("account", "account");
    mapKey.put("customername", "customername");
    mapKey.put("rechargeBankName", "rechargeBankName");
    //        mapKey.put("userBankName", "userBankName");
    mapKey.put("cardnumber", "cardnumber");
    mapKey.put("mobile", "mobile");
    mapKey.put("amount", "amount");
    mapKey.put("recTime", "recTime");
    List<Map<String, Object>> list = adminRechargeService.rechargeList(searchable);
    Excel.ExportExcel(request, response, map, mapKey, list);
  }