| | |
| | | @ApiImplicitParam(value = "管理员", name = "head", dataType = "String"), |
| | | @ApiImplicitParam(value = "手机号码", name = "phone", dataType = "String"), |
| | | @ApiImplicitParam(value = "管辖城市", name = "city", dataType = "String"), |
| | | @ApiImplicitParam(value = "充值/扣款起始时间", name = "date1", dataType = "String"), |
| | | @ApiImplicitParam(value = "充值/扣款结束时间", name = "date2", dataType = "String"), |
| | | @ApiImplicitParam(value = "页码", name = "pageNum", dataType = "Integer", required = true), |
| | | @ApiImplicitParam(value = "每页条数", name = "pageSize", dataType = "Integer", required = true) |
| | | }) |
| | | public R<RencentBalance> recentmoney(String name, String head, String phone, String city, |
| | | String date1,String date2, |
| | | @RequestParam(name = "pageNum", defaultValue = "1") Integer pageNum, |
| | | @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) { |
| | | BigDecimal balance = new BigDecimal(0); |
| | |
| | | for (Franchisee franchisee : list) { |
| | | balance = balance.add(franchisee.getBalance()); |
| | | } |
| | | |
| | | //充值的金额 |
| | | BigDecimal balance1 = new BigDecimal(0); |
| | | List<TFranchiseeBalanceChange> list1 = balanceChangeService.lambdaQuery() |
| | | .in(TFranchiseeBalanceChange::getFranchiseeId,collect) |
| | | .between(date1!=null,TFranchiseeBalanceChange::getCreateTime, date1, date2) |
| | | .eq(TFranchiseeBalanceChange::getType, 1).list(); |
| | | for (TFranchiseeBalanceChange franchiseeBalanceChange : list1) { |
| | | balance1 = balance1.add(franchiseeBalanceChange.getAmount()); |
| | |
| | | List<TFranchiseeBalanceChange> list2 = balanceChangeService.lambdaQuery() |
| | | .in(TFranchiseeBalanceChange::getFranchiseeId,collect) |
| | | .eq(TFranchiseeBalanceChange::getType, 2) |
| | | .between(date1!=null,TFranchiseeBalanceChange::getCreateTime, date1, date2) |
| | | .eq(TFranchiseeBalanceChange::getIs_pay,1).list(); |
| | | for (TFranchiseeBalanceChange franchiseeBalanceChange : list2) { |
| | | balance2 = balance2.add(franchiseeBalanceChange.getAmount()); |
| | |
| | | .like(moneyRecentQuery.getName() != null && !"".equals(moneyRecentQuery.getName()), TFranchiseeBalanceChange::getFranchiseeName, moneyRecentQuery.getName()) |
| | | .ge(moneyRecentQuery.getDate1() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate1()) |
| | | .le(moneyRecentQuery.getDate2() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate2()) |
| | | .eq(moneyRecentQuery.getFranchId()!=null, TFranchiseeBalanceChange::getFranchiseeId, moneyRecentQuery.getFranchId()) |
| | | .eq(TFranchiseeBalanceChange::getIs_pay,1) |
| | | .orderByDesc(TFranchiseeBalanceChange::getCreateTime) |
| | | .page(Page.of(moneyRecentQuery.getPageNum(), moneyRecentQuery.getPageSize())); |
| | |
| | | .eq(moneyRecentQuery.getName() != null && !"".equals(moneyRecentQuery.getName()), TFranchiseeBalanceChange::getFranchiseeName, moneyRecentQuery.getName()) |
| | | .ge(moneyRecentQuery.getDate1() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate1()) |
| | | .le(moneyRecentQuery.getDate2() != null, TFranchiseeBalanceChange::getCreateTime, moneyRecentQuery.getDate2()) |
| | | .eq(moneyRecentQuery.getFranchId()!=null, TFranchiseeBalanceChange::getFranchiseeId, moneyRecentQuery.getFranchId()) |
| | | .eq(TFranchiseeBalanceChange::getIs_pay,1) |
| | | .orderByDesc(TFranchiseeBalanceChange::getCreateTime) |
| | | .list(); |
| | |
| | | map.put("p4_Cur", "1"); /**交易币种 */ |
| | | map.put("q5_OpenId", openId); |
| | | map.put("p5_ProductName", "加盟商充值"); /** 商品名称 */ |
| | | map.put("p9_NotifyUrl", "https://v7ro848ar5jx.ngrok.xiaomiqiu123.top/admin/franchisee/callBack"); /** 服务器异步通知地址 */ |
| | | map.put("p9_NotifyUrl", "http://101.34.55.62:9100/admin/franchisee/callBack"); /** 服务器异步通知地址 */ |
| | | map.put("q1_FrpCode", "WEIXIN_APP3"); /** 交易类型*/ |
| | | map.put("q7_AppId", "wx1a4a7760be53a835"); /** 交易类型*/ |
| | | map.put("qa_TradeMerchantNo", "777165000859101"); /** 777开头的报备商户号 必填!*/ |
| | |
| | | map.put("p5_ProductName", "充值"); /** 商品名称 */ |
| | | map.put("p6_ProductDesc", "加盟商充值"); /** 商品名称 */ |
| | | // map.put("p7_Mp", ""); /** 如果商户请求时传递了该参数,则返回给商户时会原值传 回。 */ |
| | | map.put("p9_NotifyUrl", "https://v7ro848ar5jx.ngrok.xiaomiqiu123.top/admin/franchisee/callBack"); /** 服务器异步通知地址 */ |
| | | map.put("p9_NotifyUrl", "http://101.34.55.62:9100/admin/franchisee/callBack"); /** 服务器异步通知地址 */ |
| | | map.put("q1_FrpCode", "WEIXIN_NATIVE"); /** 微信扫码(主扫)【注:此为用户主扫,商户被扫】*/ |
| | | map.put("q4_IsShowPic", "1"); /** 是否展示二 维码图片 1表示输出*/ |
| | | map.put("q7_AppId", "wx1a4a7760be53a835"); /** 交易类型*/ |