cloud-server-account/src/main/resources/mapper/TAppUserMapper.xml
@@ -66,7 +66,7 @@ and t1.salesmanUserId = #{query.salesmanUser} </if> <if test="query.userIds!=null and query.userIds.size()>0"> t1.id in and t1.id in <foreach collection="query.userIds" item="id" index="index" open="(" close=")" separator=","> #{id} </foreach> cloud-server-course/src/main/java/com/dsh/course/controller/CoursePackageController.java
@@ -50,6 +50,8 @@ @Resource private ICoursePackagePaymentConfigService icppconfigService; @Autowired private ICoursePackageOrderService coursePackageOrderService; @Autowired @@ -72,9 +74,15 @@ if (courseIds.size() == 0) { return new ArrayList<>(); } else { List<Integer> userIds = tcppmenService.list(new QueryWrapper<TCoursePackagePayment>().in("coursePackageId", courseIds) List<Integer> userIds = tcppmenService.list(new QueryWrapper<TCoursePackagePayment>() .in("coursePackageId", courseIds) .eq("payStatus",2)) .stream().map(TCoursePackagePayment::getAppUserId).collect(Collectors.toList()); List<Integer> collect = coursePackageOrderService.list(new QueryWrapper<CoursePackageOrder>() .in("coursePackageId", courseIds) .eq("payStatus", 2) ).stream().map(CoursePackageOrder::getAppUserId).collect(Collectors.toList()); userIds.addAll(collect); return userIds; } cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java
@@ -1026,6 +1026,21 @@ List<Integer> coursePackageByStoreIds = tCoursePackages.stream().distinct().map(TCoursePackage::getId).collect(Collectors.toList()); studentQeryDto.setCoursePackageIds(coursePackageByStoreIds); } // 如果当前登陆人是门店 只查询该门店下的课包的数据 if(UserExt.getUser().getObjectType() == 3){ // 先查询这个运营商下的所有门店ids List<Integer> storeIds = new ArrayList<>(); storeIds.add(UserExt.getUser().getObjectId()); // 根据门店ids 查询所有课包ids List<TCoursePackage> tCoursePackages = new ArrayList<>(); for (Integer storeId : storeIds) { List<TCoursePackage> coursePackageByStoreId = coursePackageClient.getCoursePackageByStoreId(storeId); tCoursePackages.addAll(coursePackageByStoreId); } List<Integer> coursePackageByStoreIds = tCoursePackages.stream().distinct().map(TCoursePackage::getId).collect(Collectors.toList()); studentQeryDto.setCoursePackageIds(coursePackageByStoreIds); } List<Map<String, Object>> pays = coursePackageClient.getStudentTotal(studentQeryDto); return pays; }