// 充值导出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);
}
// 充值查询列表
@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";
}