File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
2024-08-23
File name
Commit message
Commit date
File name
Commit message
Commit date
2024-08-23
File name
Commit message
Commit date
File name
Commit message
Commit date
2024-09-11
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;
}