package itn.let.mjo.pay.service; import java.util.List; import javax.servlet.http.HttpServletRequest; public interface MjonPayService { List<MjonPayVO> selectPayList(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectCashList(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectCashRemainList(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectCashRemainNewList(MjonPayVO mjonPayVO) throws Exception; int selectCashRemainNewCnt(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectMemberCashList(MjonPayVO mjonPayVO) throws Exception; MjonPayVO selectCashVO(MjonPayVO mjonPayVO) throws Exception; void insertCash(MjonPayVO mjonPayVO) throws Exception; void updateCash(MjonPayVO mjonPayVO) throws Exception; void deleteCash(MjonPayVO mjonPayVO) throws Exception; MjonPayVO insertPay(MjonPayVO mjonPayVO, HttpServletRequest request, String p_payment_comp) throws Exception; MjonPayVO selectPayVO(MjonPayVO searchVO) throws Exception; MjonPayVO cancelPay(MjonPayVO mjonPayVO, HttpServletRequest request) throws Exception; List<MjonPayVO> selectPointList(MjonPayVO mjonPayVO) throws Exception; public String insertVcCharge(StVcVO paramVO) throws Exception; MjonPayVO selectPointVO(MjonPayVO mjonPayVO) throws Exception; void insertPoint(MjonPayVO mjonPayVO) throws Exception; void deletePoint(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectUsedCashTotCnt(MjonPayVO mjonPayVO) throws Exception; //전용계좌 문자발송 로그 기록 입력 int insertVaMsgLogInfo(MjonVaMsgLogVO mjonVaMsgLogVO) throws Exception; //일일 전용계좌 문자발성 건수 불러오기 MjonVaMsgLogVO selectMyAcctSendCnt(MjonVaMsgLogVO mjonVaMsgLogVO) throws Exception; // 모바일(KG 모빌리언스) 인서트 void insertKgm(MjonPayVO mjonPayVO) throws Exception; // 모바일(KG 모빌리언스) 인서트 All void insertKgmAll(MjonPayVO mjonPayVO) throws Exception; // KG 모빌리언스 결제(카드, 계좌이체, 휴대폰) 인서트 All void insertKgmAllV2(MjonPayVO mjonPayVO) throws Exception; // 모바일(KG 모빌리언스) VO MjonPayVO selectKgmVO(MjonPayVO mjonPayVO) throws Exception; // 포인트전환(사용자) void insertPointUse(MjonPayVO mjonPayVO) throws Exception; // 포인트전환(관리자) void insertPointUseAdm(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectPointUseList(MjonPayVO mjonPayVO) throws Exception; MjonPayVO selectPointUseDetail(MjonPayVO mjonPayVO) throws Exception; void updatePointUse(MjonPayVO mjonPayVO) throws Exception; void updatePointUseByCase(MjonPayVO mjonPayVO) throws Exception; String selectSumPayMoney(String userId) throws Exception; String selectAgentSumPayMoney(String userId) throws Exception; String selectSumPoint(String userId) throws Exception; List<MjonPayVO> selectPayListForRefund(MjonPayVO mjonPayVO) throws Exception; void updateMemberCash(MjonPayVO mjonPayVO) throws Exception; int updateMjonPgStatus(RefundVO refundVO) throws Exception; List<MjonPayVO> selectPayDayChart(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectPayMonthChart(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectPayDayChartDashboard(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectPayMonthChartDashboard(MjonPayVO mjonPayVO) throws Exception; MjonPayVO selectPayYearChart(MjonPayVO mjonPayVO) throws Exception; int selectMemerPayCount(String userId) throws Exception; int selectPayCountByTid(String tid) throws Exception; int updateMjonPgStatusAfterPay(MjonPayVO mjonPayVO) throws Exception; void updateMjonPgStatusAfterPayPointSave(MjonPayVO mjonPayVO) throws Exception; String selectOneYearPayCnt(String userId) throws Exception; public MjonPayVO selectFrstPayInfoByUserId(String userId) throws Exception; public MjonPayVO selectFrstPointInfoByUserId(MjonPayVO mjonPayVO) throws Exception; public MjonPayVO selectPayInfoByMoid(String moid) throws Exception; int selectCashPointSendIdCnt(String userId) throws Exception; MjonPayVO selectCashPoint(String userId) throws Exception; void insertMjCashPointSend(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectCashPointSendList(MjonPayVO mjonPayVO) throws Exception; // 문자 발송단가 할인여부 int selectMsgSalePriceCnt(String userId) throws Exception; //총 사용금액 - 카카오 추가 List<MjonPayVO> selectUsedCashWithKakaoTotCnt(MjonPayVO mjonPayVO) throws Exception; List<MjonPayVO> selectCashInfoList(String userId) throws Exception; List<MjonPayVO> selectPointInfoList(String userId) throws Exception; //누적 사용금액 조회 (캐시 테이블에서 현재까지 사용된 금액 합산 - 캐시 테이블에서 "-"로 사용된 금액만 합산) public String selectTotalSumCashForAfterPay(String userId) throws Exception; //누적 사용 포인트 조회 (포인트 테이블에서 현재까지 사용된 포인트 합산 - 회원 포인트 정보 업데이트시 사용되는 쿼리 이용) public String selectTotalSumPointForAfterPay(String userId) throws Exception; //누적 납부금액 조회 (후불회원이 사용금액을 실 납부한 금액 합산 - 미납 금액 제외한 총 합산 금액) public String selectTotSumPaymentAfterPay(String userId) throws Exception; }