| | |
| | | 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; |
| | | |
| | | /** |
| | |
| | | */ |
| | | public interface TCoursePackagePaymentMapper extends BaseMapper<TCoursePackagePayment> { |
| | | |
| | | List<TCoursePackagePayment> queryAllCoursePackage(@Param("startTime")Date startTime, |
| | | @Param("endTime")Date endTime , |
| | | @Param("coursePackId") Integer coursePackId, |
| | | @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); |
| | | } |