From c0db57abe71d3cedf5ad8326a03b8ad6cbfea43c Mon Sep 17 00:00:00 2001 From: liujie <liujie> Date: 星期三, 25 十月 2023 09:38:01 +0800 Subject: [PATCH] 10.13bug2 --- cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/CoursePackagePaymentController.java | 7 +++ cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/TStudentController.java | 13 ++++-- cloud-server-course/src/main/resources/mapper/CoursePackagePaymentConfigMapper.xml | 5 ++ cloud-server-other/src/main/java/com/dsh/other/entity/BookingQuery.java | 2 cloud-server-account/src/main/resources/mapper/TStudentMapper.xml | 5 ++ cloud-server-account/src/main/java/com/dsh/account/dto/StudentSearch.java | 3 + cloud-server-management/src/main/java/com/dsh/course/dto/StudentSearch.java | 4 ++ cloud-server-management/src/main/webapp/WEB-INF/view/system/dataStatistics/storeIncome.html | 1 cloud-server-course/src/main/java/com/dsh/course/controller/CourseStudentController.java | 11 +++++ cloud-server-course/src/main/java/com/dsh/course/model/CoursePackagePaymentQuery.java | 2 + cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/DataStatisticsController.java | 23 +++++++++++ cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/dto/BookingQuery.java | 2 cloud-server-other/src/main/resources/mapper/GameMapper.xml | 6 +++ cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/TCoursePackageController.java | 2 cloud-server-management/src/main/java/com/dsh/course/feignClient/course/CoursePackageClient.java | 7 +++ cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java | 4 ++ cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/CoursePackagePaymentQuery.java | 3 + 17 files changed, 93 insertions(+), 7 deletions(-) diff --git a/cloud-server-account/src/main/java/com/dsh/account/dto/StudentSearch.java b/cloud-server-account/src/main/java/com/dsh/account/dto/StudentSearch.java index 32d455a..be30987 100644 --- a/cloud-server-account/src/main/java/com/dsh/account/dto/StudentSearch.java +++ b/cloud-server-account/src/main/java/com/dsh/account/dto/StudentSearch.java @@ -4,6 +4,8 @@ import lombok.Data; import lombok.NoArgsConstructor; +import java.util.List; + @Data @AllArgsConstructor @NoArgsConstructor @@ -12,4 +14,5 @@ private String city;String name; private String userName; private String phone; + private List<Integer> ids; } diff --git a/cloud-server-account/src/main/resources/mapper/TStudentMapper.xml b/cloud-server-account/src/main/resources/mapper/TStudentMapper.xml index c4a040b..145ba1c 100644 --- a/cloud-server-account/src/main/resources/mapper/TStudentMapper.xml +++ b/cloud-server-account/src/main/resources/mapper/TStudentMapper.xml @@ -51,6 +51,11 @@ <if test="item.phone != null and item.phone != ''"> and o.phone LIKE CONCAT('%',#{item.phone},'%') </if> + <if test="item.ids != null and item.ids.size >0 "> + and o.appUserId in <foreach collection="item.ids" separator="," open="(" item="id" close=")"> + #{id} + </foreach> + </if> </where> </select> diff --git a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseStudentController.java b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseStudentController.java index ee637bb..cf5625e 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/controller/CourseStudentController.java +++ b/cloud-server-course/src/main/java/com/dsh/course/controller/CourseStudentController.java @@ -3,6 +3,7 @@ import cn.hutool.core.date.DateUtil; import com.baomidou.mybatisplus.core.conditions.Wrapper; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.dsh.course.entity.*; @@ -85,6 +86,16 @@ } + @ResponseBody + @PostMapping("/queryIdsByStore") + public List<Integer> queryIdsByStore(@RequestBody Integer objectId){ + List<TCoursePackage> list = packageService.list(new LambdaQueryWrapper<TCoursePackage>().eq(TCoursePackage::getStoreId, objectId)); + List<Integer> collect = list.stream().map(TCoursePackage::getId).collect(Collectors.toList()); + if(collect.size()==0){ + collect.add(-1); + } + return collect; + } //获取学员课时数信息 diff --git a/cloud-server-course/src/main/java/com/dsh/course/model/CoursePackagePaymentQuery.java b/cloud-server-course/src/main/java/com/dsh/course/model/CoursePackagePaymentQuery.java index b96c46b..fd8a135 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/model/CoursePackagePaymentQuery.java +++ b/cloud-server-course/src/main/java/com/dsh/course/model/CoursePackagePaymentQuery.java @@ -27,4 +27,6 @@ private String payUser; // 购买学员 private String payStudent; + + private List<Integer> ids; } diff --git a/cloud-server-course/src/main/resources/mapper/CoursePackagePaymentConfigMapper.xml b/cloud-server-course/src/main/resources/mapper/CoursePackagePaymentConfigMapper.xml index b83d53b..997be48 100644 --- a/cloud-server-course/src/main/resources/mapper/CoursePackagePaymentConfigMapper.xml +++ b/cloud-server-course/src/main/resources/mapper/CoursePackagePaymentConfigMapper.xml @@ -51,6 +51,11 @@ <if test="query.payStatus!=null and query.payStatus!= ''"> and t1.payStatus = #{query.payStatus} </if> + <if test="query.ids !=null and query.ids.size >0"> + and t2.storeId in <foreach collection="query.ids" close=")" item="id" open="(" separator=","> + #{id} + </foreach> + </if> </where> </select> <select id="listAllRegister" resultType="com.dsh.course.model.RegisterOrderVO"> diff --git a/cloud-server-management/src/main/java/com/dsh/course/dto/StudentSearch.java b/cloud-server-management/src/main/java/com/dsh/course/dto/StudentSearch.java index 8f9a1a4..4b3449f 100644 --- a/cloud-server-management/src/main/java/com/dsh/course/dto/StudentSearch.java +++ b/cloud-server-management/src/main/java/com/dsh/course/dto/StudentSearch.java @@ -4,6 +4,8 @@ import lombok.Data; import lombok.NoArgsConstructor; +import java.util.List; + @Data @AllArgsConstructor @@ -14,4 +16,6 @@ private String name; private String userName; private String phone; + + private List<Integer> ids; } diff --git a/cloud-server-management/src/main/java/com/dsh/course/feignClient/course/CoursePackageClient.java b/cloud-server-management/src/main/java/com/dsh/course/feignClient/course/CoursePackageClient.java index c5c328e..f08f08c 100644 --- a/cloud-server-management/src/main/java/com/dsh/course/feignClient/course/CoursePackageClient.java +++ b/cloud-server-management/src/main/java/com/dsh/course/feignClient/course/CoursePackageClient.java @@ -84,4 +84,11 @@ @PostMapping("/courdent/bypac") List<Map<String, Object>> bypac(PacQueryDto pacQueryDto); + + + @PostMapping("/courdent/queryIdsByStore") + List<Integer> queryIdsByStore(Integer objectId); + + + } diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/CoursePackagePaymentController.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/CoursePackagePaymentController.java index 1de7b5d..175193d 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/CoursePackagePaymentController.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/CoursePackagePaymentController.java @@ -120,6 +120,13 @@ @RequestMapping(value = "/listAll") @ResponseBody public List<CoursePackagePaymentVO> listAll(CoursePackagePaymentQuery query) { + Integer objectType = UserExt.getUser().getObjectType(); + List<Integer> ids =new ArrayList<>(); + if(objectType==3){ + // 找出当前门店的课包 + ids = coursePackageClient.queryIdsByStore(UserExt.getUser().getObjectId()); + query.setIds(ids); + } return coursePackagePaymentClient.listAll(query); } 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 9bfcbd9..e712d61 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 @@ -714,6 +714,9 @@ @RequestMapping(value = "/backStore") @ResponseBody public Object backStore(Integer id) { + if(UserExt.getUser().getObjectType()==3){ + id = UserExt.getUser().getObjectId(); + } HashMap<String, Object> map = new HashMap<>(); List<Integer> userPt = appUserClient.getUserStore(id); if(userPt.size()==0){ @@ -878,6 +881,9 @@ @RequestMapping(value = "/userAndVipStore") @ResponseBody public Object userAndVipStore(Integer id) { + if(UserExt.getUser().getObjectType()==3){ + id = UserExt.getUser().getObjectId(); + } HashMap<String, Object> map = appUserClient.userAndVipStore(id); return map; } @@ -942,6 +948,12 @@ @RequestMapping(value = "/actStore") @ResponseBody public Object actStore(Integer id) { + + + Integer objectType = UserExt.getUser().getObjectType(); + if(objectType==3){ + id = UserExt.getUser().getObjectId(); + } List<Integer> userPt = appUserClient.getUserStore(id); HashMap<String, Object> map = competitionClient.actPt(userPt); @@ -1104,6 +1116,10 @@ // 找出平台的用户 List<User> list = sysUserService.list(new LambdaQueryWrapper<User>().eq(User::getObjectType, 2)); List<Integer> ids = list.stream().map(User::getId).collect(Collectors.toList()); + Integer objectType = UserExt.getUser().getObjectType(); + if(objectType==3){ + id = UserExt.getUser().getObjectId(); + } List<Integer> userIds = appUserClient.getUserStore(id); QueryDataFee queryDataFee = new QueryDataFee(time, userIds); // 会员费 @@ -1362,6 +1378,9 @@ @RequestMapping("/stuUserDataStore") @ResponseBody public Object stuUserDataStore(Integer id) { + if(UserExt.getUser().getObjectType()==3){ + id = UserExt.getUser().getObjectId(); + } ArrayList<Integer> objects = new ArrayList<>(); objects.add(1); HashMap<String, Object> map = appUserClient.queryUserAgeStore(id); @@ -1397,6 +1416,10 @@ @RequestMapping("/selectStoreJx") @ResponseBody public Object selectStoreJx(Integer id) { + Integer objectType = UserExt.getUser().getObjectType(); + if(objectType==3){ + id = UserExt.getUser().getObjectId(); + } ArrayList<Integer> objects = new ArrayList<>(); objects.add(1); HashMap<String, Object> map1 = appUserClient.queryUserAgeStore1(id); diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/TCoursePackageController.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/TCoursePackageController.java index 7d86135..d229586 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/TCoursePackageController.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/code/TCoursePackageController.java @@ -1092,7 +1092,7 @@ * @return */ @ResponseBody - @PostMapping("/queryWalkInStudentList") + @PostMapping("/queryWalkInStudentListqueryCoursePackageLists") public Object queryWalkInStudentList(Long coursePackageSchedulingId, String userName, String studentName){ Page<Map<String, Object>> page = coursePackageService.queryWalkInStudentList(coursePackageSchedulingId, userName, studentName); return super.packForBT(page); diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java index e656163..a1e3151 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/BallController.java @@ -880,6 +880,10 @@ @RequestMapping("/yuyuelist") @ResponseBody public List<Map<String,Object>> yuyuelist(BookingQuery bookingQuery) { + Integer objectType = UserExt.getUser().getObjectType(); + if(objectType==3){ + bookingQuery.setStoreId(UserExt.getUser().getObjectId()); + } List<Map<String,Object>> orders = ballClient.listorder(bookingQuery); System.out.println("=======ballQueryDto=========="+bookingQuery); diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/TStudentController.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/TStudentController.java index fa7e8a3..a33be2c 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/TStudentController.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/controller/system/TStudentController.java @@ -44,10 +44,7 @@ import java.math.RoundingMode; import java.text.ParseException; import java.text.SimpleDateFormat; -import java.util.Date; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; /** * 控制器 @@ -340,7 +337,15 @@ @RequestMapping("/list") @ResponseBody public List<TStudentDto> list(StudentSearch search) { + List<Integer> ids = new ArrayList<>(); + if(UserExt.getUser().getObjectType()==3){ + ids = appUserClient.getUserStore(UserExt.getUser().getObjectId()); + if(ids.size()==0){ + ids.add(-1); + } + search.setIds(ids); + } System.out.println("============学员查询接口========="); return itStudentService.listAll(search); } diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/CoursePackagePaymentQuery.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/CoursePackagePaymentQuery.java index e452de5..e6c06cf 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/CoursePackagePaymentQuery.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/CoursePackagePaymentQuery.java @@ -27,4 +27,7 @@ private String payUser; // 购买学员 private String payStudent; + + + private List<Integer> ids; } diff --git a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/dto/BookingQuery.java b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/dto/BookingQuery.java index b667169..fc66086 100644 --- a/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/dto/BookingQuery.java +++ b/cloud-server-management/src/main/java/com/dsh/guns/modular/system/model/dto/BookingQuery.java @@ -15,5 +15,5 @@ Integer state; Integer payMethod; - + Integer storeId; } diff --git a/cloud-server-management/src/main/webapp/WEB-INF/view/system/dataStatistics/storeIncome.html b/cloud-server-management/src/main/webapp/WEB-INF/view/system/dataStatistics/storeIncome.html index 7e2c0a4..4ec90bb 100644 --- a/cloud-server-management/src/main/webapp/WEB-INF/view/system/dataStatistics/storeIncome.html +++ b/cloud-server-management/src/main/webapp/WEB-INF/view/system/dataStatistics/storeIncome.html @@ -1766,6 +1766,7 @@ if(type==1){ srtj() tuifei() + income() } if(type==2){ diff --git a/cloud-server-other/src/main/java/com/dsh/other/entity/BookingQuery.java b/cloud-server-other/src/main/java/com/dsh/other/entity/BookingQuery.java index 4bbde6e..3dfd08a 100644 --- a/cloud-server-other/src/main/java/com/dsh/other/entity/BookingQuery.java +++ b/cloud-server-other/src/main/java/com/dsh/other/entity/BookingQuery.java @@ -15,5 +15,5 @@ Integer state; Integer payMethod; - + Integer storeId; } diff --git a/cloud-server-other/src/main/resources/mapper/GameMapper.xml b/cloud-server-other/src/main/resources/mapper/GameMapper.xml index 16290e2..df086c5 100644 --- a/cloud-server-other/src/main/resources/mapper/GameMapper.xml +++ b/cloud-server-other/src/main/resources/mapper/GameMapper.xml @@ -14,6 +14,9 @@ <if test ="query.type==3"> and st.id =#{query.id} </if> + <if test ="query.type==2"> + and ga.operationId =#{query.id} + </if> <if test="query.provinceCode!=null and query.provinceCode!=''"> and ga.provinceCode = #{query.provinceCode} @@ -68,6 +71,9 @@ <if test="state!=null "> and bk.status=#{state} </if> + <if test="storeId!=null "> + and st.id=#{storeId} + </if> </where> -- Gitblit v1.7.1