From eb6b6dbb35a9f029e0b7d269773685c19fd40976 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期四, 11 七月 2024 10:47:51 +0800 Subject: [PATCH] 玩湃微信商户认证代码 --- cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java | 74 +++++++++++++++++++++++++++++++++++- 1 files changed, 71 insertions(+), 3 deletions(-) diff --git a/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java b/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java index b0c9d4f..1d3a63f 100644 --- a/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java +++ b/cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java @@ -1,8 +1,18 @@ package com.dsh.course.mapper; -import com.dsh.course.entity.TCoursePackagePayment; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.dsh.course.entity.PacQueryDto; +import com.dsh.course.entity.TCoursePackagePayment; +import com.dsh.course.entity.dto.StudentQeryDto; +import com.dsh.course.model.QueryRegistrationRecord; +import com.dsh.course.model.BillingRequest; +import io.swagger.models.auth.In; import org.apache.ibatis.annotations.Param; + +import java.util.Date; +import java.util.List; +import java.util.Map; import java.util.List; @@ -16,7 +26,65 @@ */ public interface TCoursePackagePaymentMapper extends BaseMapper<TCoursePackagePayment> { - List<TCoursePackagePayment> queryAllCoursePackage(@Param("stuId") Integer stuId, - @Param("appUserId") Integer appUserId); + /** + * 获取课包购买人数 + * + * @param coursePackageId + * @return + */ + Integer queryCountNumber(@Param("coursePackageId") Integer coursePackageId); + + TCoursePackagePayment getCoursePackagePaymentByCode(@Param("code") String code); + + List<BillingRequest> billingDataRequestVo(@Param("appUserId") Integer appUserId, + @Param("monthStart") String monthStart, + @Param("monthEnd") String monthEnd); + + + /** + * 获取课包报名信息 + * + * @param page + * @return + */ + List<Map<String, Object>> queryRegistrationRecord(Page<Map<String, Object>> page, @Param("coursePackageId") Integer coursePackageId, + @Param("userIds") List<Integer> userIds, @Param("studentIds") List<Integer> studentIds); + List<Map<String, Object>> queryRegistrationRecord1(Page<Map<String, Object>> page, @Param("coursePackageId") Integer coursePackageId, + @Param("userIds") List<Integer> userIds, @Param("studentIds") List<Integer> studentIds); + + + /** + * 获取未预约排课学员列表 + * + * @param page + * @param coursePackagePaymentId + * @param userIds + * @param studentIds + * @return + */ + List<Map<String, Object>> queryWalkInStudentList(Page<Map<String, Object>> page, @Param("coursePackageId") Integer coursePackageId, @Param("coursePackagePaymentId") List<Long> coursePackagePaymentId, + @Param("userIds") List<Integer> userIds, @Param("studentIds") List<Integer> studentIds); + + void updateUseTime(@Param("id") Long id, @Param("date") Date date); + + List<Integer> getStudentIds(@Param("id") Long payId, @Param("classId") Integer classId, @Param("appId") Integer appId); + + boolean updateHoursById(@Param("id") Long id, @Param("i") int i); + + boolean updateHoursById1(@Param("id") Long id, @Param("i") int i); + + void updateBytime(@Param("coursePackagePayment") TCoursePackagePayment coursePackagePayment); + + List<Map<String, Object>> getStudentTotal(@Param("appUserIds") List<Integer> appUserIds, @Param("start") String start, + @Param("end") String end); + + List<Map<String, Object>> pacQueryDto(@Param("start") String start, @Param("end") String end, + @Param("storeIds") List<Integer> storeIds, @Param("name") String name); + + List<TCoursePackagePayment> listOne(@Param("ids") List<Integer> ids); + + Integer queryStore(String code); + + List<Map<String, Object>> queryRegistrationRecord3(Integer coursePackageId, List<Integer> userIds, List<Integer> studentIds); } -- Gitblit v1.7.1