From a830a73fd10a21e3793c79a35be4e532de124c6f Mon Sep 17 00:00:00 2001 From: nickchange <126672920+nickchange@users.noreply.github.com> Date: 星期二, 17 十月 2023 17:25:16 +0800 Subject: [PATCH] 10.17.1 --- cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java | 110 +++++++++++++++++++++++++++++++++++++++++-------------- 1 files changed, 82 insertions(+), 28 deletions(-) diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java index b6122b6..9bfcbd9 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java @@ -7,6 +7,7 @@ import com.dsh.course.feignClient.account.model.*; import com.dsh.course.feignClient.activity.PointMercharsClient; import com.dsh.course.feignClient.competition.CompetitionClient; +import com.dsh.course.feignClient.competition.model.CompetionVO; import com.dsh.course.feignClient.competition.model.Competition; import com.dsh.course.feignClient.competition.model.CompetitionQuery; import com.dsh.course.feignClient.competition.model.PaymentCompetition; @@ -115,15 +116,6 @@ public Object getIncomeData(Integer operatorId,Integer storeId) { // 报名课程查询query RegisterOrderQuery query = new RegisterOrderQuery(); - - // 根据运营商ID 查询运营商下的所有门店 - if (operatorId!=null){ - List<TStore> stores = storeService.list(new QueryWrapper<TStore>().eq("operatorId", operatorId)); - // 拿到该运营商下的门店id集合 - List<Integer> storeIds = stores.stream().map(TStore::getId).collect(Collectors.toList()); - query.setStoresIds(storeIds); - } - // 充值记录查询query RechargeRecordsQuery rechargeRecordsQuery = new RechargeRecordsQuery(); // 赛事活动查询query @@ -132,11 +124,31 @@ IncomeQuery incomeQuery = new IncomeQuery(); // 场地预约记录查询query SiteBookingQuery siteBookingQuery = new SiteBookingQuery(); + // 筛选运营商的是时候使用 + List<Integer> storeIds = new ArrayList<>(); + // 根据运营商ID 查询运营商下的所有门店 + if (storeId==null){ + if (operatorId!=null){ + List<TStore> stores = storeService.list(new QueryWrapper<TStore>().eq("operatorId", operatorId)); + // 拿到该运营商下的门店id集合 + storeIds = stores.stream().map(TStore::getId).collect(Collectors.toList()); + query.setStoresIds(storeIds); + siteBookingQuery.setStoreIds(storeIds); + competitionQuery.setOperatorId(operatorId); + } + }else { + List<Integer> list = new ArrayList<>(); + list.add(storeId); + query.setStoresIds(list); + siteBookingQuery.setStoreIds(list); + competitionQuery.setStoreId(storeId); + } + + Integer roleType = UserExt.getUser().getObjectType(); rechargeRecordsQuery.setInsertType(roleType); query.setInsertType(roleType); competitionQuery.setInsertType(roleType); - incomeQuery.setInsertType(roleType); incomeQuery.setInsertType(roleType); List<IncomeVO> incomeVOS = new ArrayList<>(); // 会员支付记录 @@ -193,22 +205,26 @@ if (competition.getAmount() != null) { temp.setAmount(new BigDecimal(competition.getAmount().toString())); } - incomeVOS.add(temp); } // 预约场地 - List<SiteBooking> siteBookings = siteClient.listAll(siteBookingQuery); - for (SiteBooking siteBooking : siteBookings) { - IncomeVO temp = new IncomeVO(); - if(siteBooking.getStatus()!=3){ - continue; + // 说明当前运营商下没有门店 + if (operatorId!=null && storeIds.size()==0){ + }else{ + List<SiteBooking> siteBookings = siteClient.listAll(siteBookingQuery); + for (SiteBooking siteBooking : siteBookings) { + IncomeVO temp = new IncomeVO(); + if(siteBooking.getStatus()!=3){ + continue; + } + temp.setInsertTime(siteBooking.getPayTime()); + if (siteBooking.getPayMoney() != null) { + temp.setAmount(new BigDecimal(siteBooking.getPayMoney().toString())); + } + incomeVOS.add(temp); } - temp.setInsertTime(siteBooking.getPayTime()); - if (siteBooking.getPayMoney() != null) { - temp.setAmount(new BigDecimal(siteBooking.getPayMoney().toString())); - } - incomeVOS.add(temp); } + // 积分商品 List<PointMerchandiseIncomeVo> amount = pointMercharsClient.getAmount(); for (PointMerchandiseIncomeVo pointMerchandiseIncomeVo : amount) { @@ -258,7 +274,7 @@ int years = DateUtil.year(new Date()); for (int i = 0; i < 10; i++) { integers1.add(years-i); - } + } List<Object> collect = integers1.stream().sorted().collect(Collectors.toList()); List<Object> objects1 = new ArrayList<>(); for (Object o : collect) { @@ -815,11 +831,40 @@ HashMap<String, Object> map = appUserClient.stuPt(); return map; } + @RequestMapping(value = "/stuYys") + @ResponseBody + public Object stuYys(Integer id) { + HashMap<String, Object> map = appUserClient.stuYys(id); + return map; + } + @RequestMapping(value = "/stuStores") + @ResponseBody + public Object stuStores(Integer id) { + HashMap<String, Object> map = appUserClient.stuStores(id); + return map; + } + // 消耗课时数据-平台 @RequestMapping(value = "/coursePt") @ResponseBody public Object coursePt() { List<Integer> userPt = appUserClient.getUserPt(Arrays.asList(1)); + HashMap<String, Object> map = coursePackagePaymentClient.coursePt(userPt); + return map; + } + // 消耗课时数据-运营商 + @RequestMapping(value = "/courseYys") + @ResponseBody + public Object courseYys(Integer id) { + List<Integer> userPt = appUserClient.getUserPt(Arrays.asList(id)); + HashMap<String, Object> map = coursePackagePaymentClient.coursePt(userPt); + return map; + } + // 消耗课时数据-运营商 + @RequestMapping(value = "/courseStore") + @ResponseBody + public Object courseStore(Integer id) { + List<Integer> userPt = appUserClient.getUserPt(Arrays.asList(id)); HashMap<String, Object> map = coursePackagePaymentClient.coursePt(userPt); return map; } @@ -866,10 +911,14 @@ @RequestMapping(value = "/actYys") @ResponseBody public Object actYys(Integer id) { - List<Integer> userPt = appUserClient.getUserYYs(id); - HashMap<String, Object> map = competitionClient.actPt(userPt); + CompetionVO competionVO = new CompetionVO(); - List<TStore> list = storeService.list(new LambdaQueryWrapper<TStore>().eq(TStore::getOperatorId, 0)); + List<Integer> userPt = appUserClient.getUserYYs(id); + competionVO.setIds(userPt); + competionVO.setOperatorId(id); + HashMap<String, Object> map = competitionClient.actYys(competionVO); + + List<TStore> list = storeService.list(new LambdaQueryWrapper<TStore>().eq(TStore::getOperatorId, id)); long l1=0; for (TStore tStore : list) { long l = DateUtil.betweenDay(tStore.getCreateTime(), new Date(), true); @@ -883,7 +932,7 @@ if(integer==0 && integer1==0){ a=24; }else { - a= integer1-integer; + a= integer-integer1; } l1 += l * a; } @@ -926,9 +975,12 @@ @RequestMapping("/operator") public String operator(Model model) { Integer objectType = UserExt.getUser().getObjectType(); - List<TOperator> list = operatorService.list(new LambdaQueryWrapper<TOperator>().ne(TOperator::getState, 3)); + Integer objectId = UserExt.getUser().getObjectId(); + + List<TOperator> list = operatorService.list(new LambdaQueryWrapper<TOperator>().ne(TOperator::getState, 3).ne(TOperator::getId,0)); model.addAttribute("list",list); model.addAttribute("objectType",objectType); + model.addAttribute("objectId",objectId); return PREFIX + "operatorIncome.html"; } @@ -1156,6 +1208,7 @@ List<TStore> list = storeService.list(new LambdaQueryWrapper<TStore>().eq(TStore::getState, 1)); model.addAttribute("list",list); model.addAttribute("objectType",objectType); + model.addAttribute("objectId",UserExt.getUser().getObjectId()); return PREFIX + "storeIncome.html"; } @@ -1300,8 +1353,9 @@ @ResponseBody public Object stuUserDataYys(Integer id) { ArrayList<Integer> objects = new ArrayList<>(); + objects.add(1); - HashMap<String, Object> map = appUserClient.queryUserAgeYys(id); + HashMap<String, Object> map = appUserClient.queryUserAgeYys(operatorService.getById(id).getId()); return map; } -- Gitblit v1.7.1