Package com.eeit87t3.tickiteasy.order.repository

Interface ProdOrdersRepository

All Superinterfaces:

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

public interface ProdOrdersRepository
extends JpaRepository<ProdOrders,Integer>

Author:

tony475767

Method Summary

Modifier and Type	Method	Description
org.springframework.data.domain.Page<ProdOrders>	findByDate(String number, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<ProdOrders>	findByMemberId(Integer number, org.springframework.data.domain.Pageable pageable)
ProdOrders	findBypaymentInfo(String paymentInfo)
org.springframework.data.domain.Page<ProdOrders>	findByProdOrdersId(Integer number, org.springframework.data.domain.Pageable pageable)
List<ProdOrders>	findByStatusNotPaid()
List<ProdOrders>	findByStatusPaid()
ProdOrders	findLatestProdOrder()
List<ProdOrders>	findOrdersByMemberId(Integer memberId)

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

findLatestProdOrder

@Query(value="SELECT TOP 1 * FROM ProdOrders ORDER BY prodOrderID DESC",
       nativeQuery=true)
ProdOrders findLatestProdOrder()

findByDate

@Query(value="SELECT * FROM ProdOrders WHERE orderDate LIKE CONCAT(\'%\', :number, \'%\')",
       nativeQuery=true)
org.springframework.data.domain.Page<ProdOrders> findByDate(@Param("number")
 String number,
 org.springframework.data.domain.Pageable pageable)

findByProdOrdersId

@Query(value="SELECT * FROM ProdOrders WHERE prodOrderId LIKE CONCAT(\'%\', :number, \'%\')",
       nativeQuery=true)
org.springframework.data.domain.Page<ProdOrders> findByProdOrdersId(@Param("number")
 Integer number,
 org.springframework.data.domain.Pageable pageable)

findByMemberId

@Query(value="SELECT * FROM ProdOrders WHERE memberId LIKE CONCAT(\'%\', :number, \'%\')",
       nativeQuery=true)
org.springframework.data.domain.Page<ProdOrders> findByMemberId(@Param("number")
 Integer number,
 org.springframework.data.domain.Pageable pageable)

findByStatusPaid

@Query(value="SELECT * FROM ProdOrders WHERE status = \'\u5df2\u4ed8\u6b3e\'",
       nativeQuery=true)
List<ProdOrders> findByStatusPaid()

findByStatusNotPaid

@Query(value="SELECT * FROM ProdOrders WHERE status = \'\u672a\u4ed8\u6b3e\'",
       nativeQuery=true)
List<ProdOrders> findByStatusNotPaid()

findBypaymentInfo

@Query(value="SELECT * FROM ProdOrders WHERE paymentInfo = :paymentInfo",
       nativeQuery=true)
ProdOrders findBypaymentInfo(String paymentInfo)

findOrdersByMemberId

@Query(value="SELECT * FROM ProdOrders WHERE memberID = :memberID",
       nativeQuery=true)
List<ProdOrders> findOrdersByMemberId(@Param("memberID")
 Integer memberId)