TsaCustomerDao.java 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224
  1. package com.style24.admin.biz.dao;
  2. import java.util.Collection;
  3. import org.springframework.stereotype.Repository;
  4. import com.style24.core.support.annotation.ShopDs;
  5. import com.style24.persistence.domain.Counsel;
  6. import com.style24.persistence.domain.Coupon;
  7. import com.style24.persistence.domain.CustContactHst;
  8. import com.style24.persistence.domain.CustGrade;
  9. import com.style24.persistence.domain.Customer;
  10. import com.style24.persistence.domain.CustomerSearch;
  11. import com.style24.persistence.domain.GiftCard;
  12. import com.style24.persistence.domain.Order;
  13. import com.style24.persistence.domain.Point;
  14. import com.style24.persistence.domain.Review;
  15. /**
  16. * 회원 Dao
  17. *
  18. * @author jsshin
  19. * @since 2020. 11. 3
  20. */
  21. @ShopDs
  22. @Repository
  23. public interface TsaCustomerDao {
  24. /**
  25. * 활동회원 건수
  26. * @param customerSearch - 검색조건
  27. * @return int
  28. * @author jsshin
  29. * @since 2021. 2. 01
  30. */
  31. int getCustomerActiveListCount(CustomerSearch customerSearch);
  32. /**
  33. * 활동회원 목록
  34. * @param customerSearch - 검색조건
  35. * @return Collection<Customer>
  36. * @author jsshin
  37. * @since 2021. 01. 12
  38. */
  39. Collection<Customer> getCustomerActiveList(CustomerSearch customerSearch);
  40. /**
  41. * 회원정보 수정
  42. * @param customer - 고객정보
  43. * @author jsshin
  44. * @since 2021. 01. 20
  45. */
  46. void updateCustomerInfo(Customer customer);
  47. /**
  48. * 회원 휴대전화번호 수정
  49. * @param customer - 고객정보
  50. * @author jsshin
  51. * @since 2021. 01. 25
  52. */
  53. void updateCustomerCellPhnno(Customer customer);
  54. /**
  55. * 회원 주문내역
  56. * @param customerSearch - 고객번호
  57. * @return Collection<Order>
  58. * @author jsshin
  59. * @since 2021. 01. 21
  60. */
  61. int getCustomerOrderListCount(CustomerSearch customerSearch);
  62. /**
  63. * 회원 주문내역
  64. * @param custNo - 고객번호
  65. * @return Collection<Order>
  66. * @author jsshin
  67. * @since 2021. 01. 21
  68. */
  69. Collection<Order> getCustomerOrderList(CustomerSearch customerSearch);
  70. /**
  71. * 회원상세-쿠폰내역
  72. *
  73. * @param custNo -고객일련번호
  74. * @return Collection<Coupon>
  75. * @author jsshin
  76. * @since 2021. 01. 21
  77. */
  78. Collection<Coupon> getCustomerCouponList(Integer custNo);
  79. /**
  80. * 회원상세-포인트
  81. *
  82. * @param custNo -고객일련번호
  83. * @return Point
  84. * @author jsshin
  85. * @since 2021. 01. 25
  86. */
  87. Point getCustomerPoint(Integer custNo);
  88. /**
  89. * 회원상세-포인트내역
  90. *
  91. * @param custNo -고객일련번호
  92. * @return Collection<Coupon>
  93. * @author jsshin
  94. * @since 2021. 01. 21
  95. */
  96. Collection<Point> getCustomerPointList(Integer custNo);
  97. /**
  98. * 회원상세-상품권내역
  99. *
  100. * @param custNo -고객일련번호
  101. * @return Collection<GiftCard>
  102. * @author jsshin
  103. * @since 2021. 01. 21
  104. */
  105. Collection<GiftCard> getCustomerGiftCardList(Integer custNo);
  106. /**
  107. * 회원상세-상품평내역
  108. *
  109. * @param custNo -고객일련번호
  110. * @return Collection<Review>
  111. * @author jsshin
  112. * @since 2021. 01. 21
  113. */
  114. Collection<Review> getCustomerReviewList(Integer custNo);
  115. /**
  116. * 회원상세- 1:1문의 내역
  117. *
  118. * @param custNo -고객일련번호
  119. * @return Collection<Counsel>
  120. * @author jsshin
  121. * @since 2021. 01. 21
  122. */
  123. Collection<Counsel> getCustomerCounselList(Integer custNo);
  124. /**
  125. * 회원상세- 상품문의 내역
  126. *
  127. * @param custNo -고객일련번호
  128. * @return Collection<Counsel>
  129. * @author jsshin
  130. * @since 2021. 01. 21
  131. */
  132. Collection<Counsel> getCustomerGoodsQnaList(Integer custNo);
  133. /**
  134. * 회원상세- 등급변경 내역
  135. *
  136. * @param custNo -고객일련번호
  137. * @return Collection<Counsel>
  138. * @author jsshin
  139. * @since 2021. 01. 21
  140. */
  141. Collection<CustGrade> getCustomerChangeGradeList(Integer custNo);
  142. /**
  143. * 회원상세- 접촉내역
  144. *
  145. * @param custNo -고객일련번호
  146. * @return Collection<Counsel>
  147. * @author jsshin
  148. * @since 2021. 01. 21
  149. */
  150. Collection<CustContactHst> getCustomerContactList(Integer custNo);
  151. /**
  152. * 탈퇴회원 목록 건수
  153. * @param customerSearch - 검색조건
  154. * @return Collection<Customer>
  155. * @author jsshin
  156. * @since 2021. 02. 01
  157. */
  158. int getCustomerSecedeListCount(CustomerSearch customerSearch);
  159. /**
  160. * 탈퇴회원 목록
  161. * @param customerSearch - 검색조건
  162. * @return Collection<Customer>
  163. * @author jsshin
  164. * @since 2021. 01. 14
  165. */
  166. Collection<Customer> getCustomerSecedeList(CustomerSearch customerSearch);
  167. /**
  168. * 휴면회원 목록 건수
  169. * @param customerSearch - 검색조건
  170. * @return Collection<Customer>
  171. * @author jsshin
  172. * @since 2021. 02. 01
  173. */
  174. int getCustomerDormantListCount(CustomerSearch customerSearch);
  175. /**
  176. * 휴면회원 목록
  177. * @param customerSearch - 검색조건
  178. * @return Collection<Customer>
  179. * @author jsshin
  180. * @since 2021. 01. 14
  181. */
  182. Collection<Customer> getCustomerDormantList(CustomerSearch customerSearch);
  183. /**
  184. * 휴대전화 번호 조회
  185. * @param customerSearch - 검색조건
  186. * @return int - 고객 수
  187. * @author jsshin
  188. * @since 2021. 02. 23
  189. */
  190. int getCustomerFindByCellPhone(CustomerSearch customerSearch);
  191. /**
  192. * 휴대전화번호와 CI 삭제
  193. * @param customer - 고객 정보
  194. * @author gagamel
  195. * @since 2021. 11. 22
  196. */
  197. void deleteCellPhnno(Customer customer);
  198. }