TsaCustomerDao.java 5.2 KB

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