| | |
| | | @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(); |