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>
|
* 用户课程包购买记录 Mapper 接口
|
* </p>
|
*
|
* @author administrator
|
* @since 2023-06-14
|
*/
|
public interface TCoursePackagePaymentMapper extends BaseMapper<TCoursePackagePayment> {
|
|
|
/**
|
* 获取课包购买人数
|
*
|
* @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);
|
|
|
/**
|
* 获取未预约排课学员列表
|
*
|
* @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(StudentQeryDto studentQeryDto);
|
|
List<Map<String, Object>> pacQueryDto(PacQueryDto pacQueryDto);
|
|
List<TCoursePackagePayment> listOne(@Param("ids") List<Integer> ids);
|
|
Integer queryStore(String code);
|
}
|
