| | |
|---|
| | | |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @RequestMapping(value = "/backYys") |
|---|
| | | @ResponseBody |
|---|
| | | public Object backYys(Integer id) { |
|---|
| | | HashMap<String, Object> map = new HashMap<>(); |
|---|
| | | List<Integer> userPt = appUserClient.getUserYYs(id); |
|---|
| | | if(userPt.size()==0){ |
|---|
| | | userPt.add(-1); |
|---|
| | | } |
|---|
| | | ArrayList<Object> integers = new ArrayList<>(); |
|---|
| | | int year = DateUtil.year(new Date()); |
|---|
| | | List<TBackRecord> thisYear = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, year).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum5 = thisYear.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | map.put("thisYear",sum5); |
|---|
| | | |
|---|
| | | List<TBackRecord> thisMonth = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, new SimpleDateFormat("yyyy-MM").format(new Date())).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum6= thisMonth.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | map.put("thisMonth",sum6); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | for (int i = 0; i < 10; i++) { |
|---|
| | | integers.add(year-i); |
|---|
| | | } |
|---|
| | | List<Object> collect = integers.stream().sorted().collect(Collectors.toList()); |
|---|
| | | // 年 |
|---|
| | | ArrayList<Double> years = new ArrayList<>(); |
|---|
| | | for (Object o : collect) { |
|---|
| | | double sum=0.0; |
|---|
| | | String s = o.toString(); |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, s).in(TBackRecord::getUserId,userPt)); |
|---|
| | | sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | years.add(sum); |
|---|
| | | } |
|---|
| | | ArrayList<Double> months = new ArrayList<>(); |
|---|
| | | // 月 |
|---|
| | | for (int i = 1; i <= 12; i++) { |
|---|
| | | double sum=0.0; |
|---|
| | | String m=i+""; |
|---|
| | | if(i<10){ |
|---|
| | | m="0"+i; |
|---|
| | | } |
|---|
| | | String s = year + "-" + m; |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, s).in(TBackRecord::getUserId,userPt)); |
|---|
| | | sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | months.add(sum); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 获取最近四周 |
|---|
| | | LocalDateTime minNow = LocalDateTime.now().with(LocalTime.MIN); |
|---|
| | | LocalDateTime maxNow = LocalDateTime.now().with(LocalTime.MAX); |
|---|
| | | // 周度数据 |
|---|
| | | String s1 = minNow.minusDays(6).toString(); |
|---|
| | | String s2 = maxNow.toString(); |
|---|
| | | |
|---|
| | | String s3 = minNow.minusDays(13).toString(); |
|---|
| | | String s4 = maxNow.minusDays(6).toString(); |
|---|
| | | |
|---|
| | | |
|---|
| | | String s5 = minNow.minusDays(20).toString(); |
|---|
| | | String s6 = maxNow.minusDays(13).toString(); |
|---|
| | | |
|---|
| | | String s7 = minNow.minusDays(27).toString(); |
|---|
| | | String s8 = maxNow.minusDays(20).toString(); |
|---|
| | | |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s7,s8).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | |
|---|
| | | List<TBackRecord> list1 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s5,s6).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum1 = list1.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | List<TBackRecord> list2 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s3,s4).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum2 = list2.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | List<TBackRecord> list3 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s1,s2).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum3 = list3.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | |
|---|
| | | map.put("thisWeek",sum3); |
|---|
| | | |
|---|
| | | ArrayList<Double> week = new ArrayList<>(); |
|---|
| | | week.add(sum); |
|---|
| | | week.add(sum1); |
|---|
| | | week.add(sum2); |
|---|
| | | week.add(sum3); |
|---|
| | | |
|---|
| | | // 日 |
|---|
| | | ArrayList<Double> days = new ArrayList<>(); |
|---|
| | | Double thisDay=0.0; |
|---|
| | | for (int i = 6; i >= 0; i--) { |
|---|
| | | String s = minNow.minusDays(i).toString(); |
|---|
| | | String s9 = maxNow.minusDays(i).toString(); |
|---|
| | | List<TBackRecord> day = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s,s9).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum4 = day.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | days.add(sum4); |
|---|
| | | if(i==0){ |
|---|
| | | thisDay=sum4; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | map.put("thisDay",thisDay); |
|---|
| | | map.put("yearData",years); |
|---|
| | | map.put("monthData",months); |
|---|
| | | map.put("weekData",week); |
|---|
| | | map.put("dayData",days); |
|---|
| | | |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | @RequestMapping(value = "/backStore") |
|---|
| | | @ResponseBody |
|---|
| | | public Object backStore(Integer id) { |
|---|
| | | HashMap<String, Object> map = new HashMap<>(); |
|---|
| | | List<Integer> userPt = appUserClient.getUserStore(id); |
|---|
| | | if(userPt.size()==0){ |
|---|
| | | userPt.add(-1); |
|---|
| | | } |
|---|
| | | ArrayList<Object> integers = new ArrayList<>(); |
|---|
| | | int year = DateUtil.year(new Date()); |
|---|
| | | List<TBackRecord> thisYear = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, year).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum5 = thisYear.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | map.put("thisYear",sum5); |
|---|
| | | |
|---|
| | | List<TBackRecord> thisMonth = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, new SimpleDateFormat("yyyy-MM").format(new Date())).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum6= thisMonth.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | map.put("thisMonth",sum6); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | for (int i = 0; i < 10; i++) { |
|---|
| | | integers.add(year-i); |
|---|
| | | } |
|---|
| | | List<Object> collect = integers.stream().sorted().collect(Collectors.toList()); |
|---|
| | | // 年 |
|---|
| | | ArrayList<Double> years = new ArrayList<>(); |
|---|
| | | for (Object o : collect) { |
|---|
| | | double sum=0.0; |
|---|
| | | String s = o.toString(); |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, s).in(TBackRecord::getUserId,userPt)); |
|---|
| | | sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | years.add(sum); |
|---|
| | | } |
|---|
| | | ArrayList<Double> months = new ArrayList<>(); |
|---|
| | | // 月 |
|---|
| | | for (int i = 1; i <= 12; i++) { |
|---|
| | | double sum=0.0; |
|---|
| | | String m=i+""; |
|---|
| | | if(i<10){ |
|---|
| | | m="0"+i; |
|---|
| | | } |
|---|
| | | String s = year + "-" + m; |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().like(TBackRecord::getTime, s).in(TBackRecord::getUserId,userPt)); |
|---|
| | | sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | months.add(sum); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 获取最近四周 |
|---|
| | | LocalDateTime minNow = LocalDateTime.now().with(LocalTime.MIN); |
|---|
| | | LocalDateTime maxNow = LocalDateTime.now().with(LocalTime.MAX); |
|---|
| | | // 周度数据 |
|---|
| | | String s1 = minNow.minusDays(6).toString(); |
|---|
| | | String s2 = maxNow.toString(); |
|---|
| | | |
|---|
| | | String s3 = minNow.minusDays(13).toString(); |
|---|
| | | String s4 = maxNow.minusDays(6).toString(); |
|---|
| | | |
|---|
| | | |
|---|
| | | String s5 = minNow.minusDays(20).toString(); |
|---|
| | | String s6 = maxNow.minusDays(13).toString(); |
|---|
| | | |
|---|
| | | String s7 = minNow.minusDays(27).toString(); |
|---|
| | | String s8 = maxNow.minusDays(20).toString(); |
|---|
| | | |
|---|
| | | List<TBackRecord> list = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s7,s8).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum = list.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | |
|---|
| | | List<TBackRecord> list1 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s5,s6).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum1 = list1.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | List<TBackRecord> list2 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s3,s4).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum2 = list2.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | List<TBackRecord> list3 = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s1,s2).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum3 = list3.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | |
|---|
| | | map.put("thisWeek",sum3); |
|---|
| | | |
|---|
| | | ArrayList<Double> week = new ArrayList<>(); |
|---|
| | | week.add(sum); |
|---|
| | | week.add(sum1); |
|---|
| | | week.add(sum2); |
|---|
| | | week.add(sum3); |
|---|
| | | |
|---|
| | | // 日 |
|---|
| | | ArrayList<Double> days = new ArrayList<>(); |
|---|
| | | Double thisDay=0.0; |
|---|
| | | for (int i = 6; i >= 0; i--) { |
|---|
| | | String s = minNow.minusDays(i).toString(); |
|---|
| | | String s9 = maxNow.minusDays(i).toString(); |
|---|
| | | List<TBackRecord> day = backRecordService.list(new LambdaQueryWrapper<TBackRecord>().between(TBackRecord::getTime, s,s9).in(TBackRecord::getUserId,userPt)); |
|---|
| | | double sum4 = day.stream().mapToDouble(TBackRecord::getMoney).sum(); |
|---|
| | | days.add(sum4); |
|---|
| | | if(i==0){ |
|---|
| | | thisDay=sum4; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | map.put("thisDay",thisDay); |
|---|
| | | map.put("yearData",years); |
|---|
| | | map.put("monthData",months); |
|---|
| | | map.put("weekData",week); |
|---|
| | | map.put("dayData",days); |
|---|
| | | |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | @RequestMapping(value = "/userAndVipPt") |
|---|
| | | @ResponseBody |
|---|
| | | public Object userAndVipPt(Integer type) { |
|---|
| | | HashMap<String, Object> map = appUserClient.userAndVipPt(type); |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | @RequestMapping(value = "/actPt") |
|---|
| | | @ResponseBody |
|---|
| | | public Object actPt(Integer type) { |
|---|
| | | List<Integer> userPt = appUserClient.getUserPt(Arrays.asList(1)); |
|---|
| | | HashMap<String, Object> map = competitionClient.actPt(userPt); |
|---|
| | | |
|---|
| | | List<TStore> list = storeService.list(new LambdaQueryWrapper<TStore>().eq(TStore::getOperatorId, 0)); |
|---|
| | | for (TStore tStore : list) { |
|---|
| | | long l = DateUtil.betweenDay(tStore.getCreateTime(), new Date(), true); |
|---|
| | | tStore.getStartTime(); |
|---|
| | | } |
|---|
| | | return map; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 跳转到运营商统计数据页面 |
|---|
| | | */ |
|---|
