package com.dsh.course.servs;


import com.dsh.course.entity.TCoursePackagePayment;
import org.apache.ibatis.annotations.Param;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface CoursePackagePaymentRepository extends JpaRepository<TCoursePackagePayment, Long> {
    @Query(value = "SELECT * FROM t_course_package_payment "
            + "UNION ALL "
            + "SELECT * FROM t_course_package_payment1 "
            + "UNION ALL "
            + "SELECT * FROM t_course_package_payment2 "
            + "UNION ALL "
            + "SELECT * FROM t_course_package_payment3 "
            + "UNION ALL "
            + "SELECT * FROM t_course_package_payment4 "
            + "UNION ALL "
            + "SELECT * FROM t_course_package_payment5 "
            + "WHERE user_id = :userId", nativeQuery = true)
    List<TCoursePackagePayment> findByUserId(@Param ("userId") Integer userId);
}