puzhibing
2024-02-05 640ff18d2d7f4be02ddb7f8f75e899f05545eb98
cloud-server-course/src/main/java/com/dsh/course/mapper/TCoursePackagePaymentMapper.java
@@ -1,8 +1,20 @@
package com.dsh.course.mapper;
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;
/**
 * <p>
@@ -15,9 +27,9 @@
public interface TCoursePackagePaymentMapper extends BaseMapper<TCoursePackagePayment> {
    /**
     * 获取课包购买人数
     *
     * @param coursePackageId
     * @return
     */
@@ -25,4 +37,54 @@
    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);
}