File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
2023-08-29
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;
}