Package com.eeit87t3.tickiteasy.cwdfunding.repository

Interface FundOrderRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<FundOrder,Integer>, JpaRepository<FundOrder,Integer>, org.springframework.data.repository.ListCrudRepository<FundOrder,Integer>, org.springframework.data.repository.ListPagingAndSortingRepository<FundOrder,Integer>, org.springframework.data.repository.PagingAndSortingRepository<FundOrder,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<FundOrder>, org.springframework.data.repository.Repository<FundOrder,Integer>

public interface FundOrderRepository
extends JpaRepository<FundOrder,Integer>

Author:

TingXD (chen19990627)

Method Summary

Modifier and Type	Method	Description
Integer	countMembers(Integer projectID)
List<FundOrder>	findByMemberID(Integer memberID)
FundOrder	findByTickitID(String tickitID)
FundOrder	isDonated(Integer projectID, Integer memberID)
List<Integer>	memberIDList(Integer projectID)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findByMemberID

@Query(value="select * from fundingOrder where memberID= :m",
       nativeQuery=true)
List<FundOrder> findByMemberID(@Param("m")
 Integer memberID)

findByTickitID

@Query(value="select * from fundingOrder where tickitID= :t",
       nativeQuery=true)
FundOrder findByTickitID(@Param("t")
 String tickitID)

countMembers

@Query(value="select count(*) from fundingOrder where projectID= :p",
       nativeQuery=true)
Integer countMembers(@Param("p")
 Integer projectID)

memberIDList

@Query(value="select memberID from fundingOrder where projectID= :p",
       nativeQuery=true)
List<Integer> memberIDList(@Param("p")
 Integer projectID)

isDonated

@Query(value="select * from fundingOrder where projectID= :p AND memberID= :m",
       nativeQuery=true)
FundOrder isDonated(@Param("p")
 Integer projectID,
 @Param("m")
 Integer memberID)