// 充值查询列表
@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";
}
// 拒绝充值上账
@RequestMapping("/refusedRecharge")
@ResponseBody
public String refusedRecharge(
@RequestParam(required = false, defaultValue = "0") long id,
@RequestParam(required = false, defaultValue = "") String remark,
HttpServletRequest request) {
SysUser user = (SysUser) request.getSession().getAttribute("sysUser");
Map<String, Object> map = ResultUtil.result();
try {
if (id <= 0) {
map.put("code", 1);
map.put("msg", "缺少唯一主键");
} else {
int i = adminRechargeService.refusedRecharge(id, user.getId(), remark);
if (i > 0) {
map.put("code", 0);
map.put("msg", "更新成功");
} else {
map.put("code", 2);
map.put("msg", "更新失败");
}
}
} catch (Exception e) {
e.printStackTrace();
map.put("code", -1);
map.put("msg", "更新信息出现异常");
}
return ResultUtil.toJSON(map);
}
// 回填充值信息
@RequestMapping("/reLoadCharge")
@ResponseBody
public String reLoadCharge(
@RequestParam(required = false, defaultValue = "0") long id,
@RequestParam(required = false, defaultValue = "") String fowNo,
@RequestParam(required = false, defaultValue = "") String time,
@RequestParam(required = false, defaultValue = "0") Double amount,
@RequestParam(required = false, defaultValue = "0") long user_id,
HttpServletRequest request) {
SysUser user = (SysUser) request.getSession().getAttribute("sysUser");
Map<String, Object> map = ResultUtil.result();
try {
if (id <= 0) {
map.put("code", 1);
map.put("msg", "缺少唯一主键");
} else if (Validators.isBlank(fowNo)) {
map.put("code", 2);
map.put("msg", "请输入流水号");
} else if (!Validators.isDateTime(time)) {
map.put("code", 3);
map.put("msg", "请输入时间");
} else {
adminRechargeService.reLoadCharge(id, fowNo, time, user.getId(), amount, user_id);
map.put("code", 0);
map.put("msg", "更新成功");
}
} catch (Exception e) {
e.printStackTrace();
map.put("code", -1);
map.put("msg", "更新信息出现异常");
}
return ResultUtil.toJSON(map);
}
// 充值导出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);
}