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
File name
Commit message
Commit date
File name
Commit message
Commit date
2024-09-11
2024-07-22
package itn.let.mjo.pay.web;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Locale;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.HandlerMapping;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;
import egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper;
import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo;
import itn.com.cmm.EgovMessageSource;
import itn.com.cmm.LoginVO;
import itn.com.cmm.util.RedirectUrlMaker;
import itn.com.utl.fcc.service.EgovStringUtil;
import itn.let.mjo.pay.service.MjonPayService;
import itn.let.mjo.pay.service.MjonPrePayService;
import itn.let.mjo.pay.service.MjonPrePayVO;
import itn.let.uss.umt.service.EgovUserManageService;
@Controller
public class MjonPrePayController {
private static final Logger LOGGER = LoggerFactory.getLogger(MjonPrePayController.class);
@Resource(name = "mjonPayService")
private MjonPayService mjonPayService;
@Resource(name = "mjonPrePayService")
private MjonPrePayService mjonPrePayService;
/** EgovMessageSource */
@Resource(name="egovMessageSource")
EgovMessageSource egovMessageSource;
/** userManageService */
@Resource(name = "userManageService")
private EgovUserManageService userManageService;
//배열 정의{"컬럼순차번호, 컬럼이름, 컬럼내용, 컬럼이름에 붙여야할 내용(엑셀코드양식다운로드시 필요)"}
private String[][] sendPrePayExcelValue ={
{"0" ,"번호" , "1" , "" },
{"1", "아이디" , "아이디" , ""},
{"2", "전송사" , "개인전용계좌", ""},
{"3", "선결제일시" , "2021-06-08 11:05:38", ""},
{"4", "결제금액" , "1000", ""},
{"5", "등록일자" , "2021-06-08 11:05:38", ""},
} ;
/**
* 결제 리스트
* @param searchVO
* @param model
* @return "/uss/ion/msg/SendNumberList"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayList.do"})
public String selectPrePayList(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
ModelMap model) throws Exception{
String pattern = (String) request.getAttribute(HandlerMapping.BEST_MATCHING_PATTERN_ATTRIBUTE) ;
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
/** pageing */
PaginationInfo paginationInfo = new PaginationInfo();
paginationInfo.setCurrentPageNo(mjonPrePayVO.getPageIndex());
paginationInfo.setRecordCountPerPage(mjonPrePayVO.getPageUnit());
paginationInfo.setPageSize(mjonPrePayVO.getPageSize());
mjonPrePayVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
mjonPrePayVO.setLastIndex(paginationInfo.getLastRecordIndex());
mjonPrePayVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
mjonPrePayVO.setSearchSortCnd("prePayDate");
mjonPrePayVO.setSearchSortOrd("desc");
}
List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO);
model.addAttribute("resultList", resultList);
model.addAttribute("totSumPrice", resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotSum() : 0);
paginationInfo.setTotalRecordCount(resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotCnt() : 0);
model.addAttribute("paginationInfo", paginationInfo);
return "/uss/ion/pay/prePay/PrePayList";
}
/**
* 선결제 등록화면
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayRegist.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayRegist.do"})
public String PrePayRegist(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
ModelMap model) throws Exception{
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
return "/uss/ion/pay/prePay/PrePayRegist";
}
/**
* 선결제 등록 처리
* @param searchVO
* @param model
* @return "uss/ion/pay/insertPrePayRegistAjax"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/insertPrePayRegistAjax.do"})
public ModelAndView insertPrePayRegistAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
ModelMap model) throws Exception{
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
modelAndView.addObject("result", "loginFail");
modelAndView.addObject("message", "로그인이 필요합니다.");
return modelAndView;
}
try {
LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
String mberId = mjonPrePayVO.getMberId();
mjonPrePayVO.setFrstRegisterId(userId);
mjonPrePayVO.setLastUpdusrId(userId);
if(mjonPrePayVO.getAmt().length() == 0
|| mjonPrePayVO.getMberId().length() == 0
|| mjonPrePayVO.getPrePayDate().length() == 0) {
modelAndView.addObject("result", "dataFail");
modelAndView.addObject("message", "필수 입력값을 확인해 주세요.");
return modelAndView;
}
int mberCnt = mjonPrePayService.selectBLineMberCnt(mberId);
if(mberCnt > 0) {
int resultCnt = mjonPrePayService.insertPrePayInfo(mjonPrePayVO);
if(resultCnt > 0) {
modelAndView.addObject("result", "success");
modelAndView.addObject("message", "등록이 완료되었습니다.");
}else {
modelAndView.addObject("result", "insertFail");
modelAndView.addObject("message", "선결제 정보 등록 중 오류가 발생하였습니다.");
return modelAndView;
}
}else {
modelAndView.addObject("result", "mberFail");
modelAndView.addObject("message", mberId + "의 회원정보를 찾을 수 없습니다.");
return modelAndView;
}
} catch (Exception e) {
System.out.println("++++++++++++++ insertPrePayRegistAjax Controller Error !!! " + e);
modelAndView.addObject("result", "Error");
modelAndView.addObject("message", "등록 중 오류가 발생하였습니다.");
return modelAndView;
}
return modelAndView;
}
/**
* 선결제 삭제 처리
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayDelete.do"
* @throws Exception
*/
@RequestMapping(value = {"/uss/ion/pay/PrePayDelete.do"})
public String deleteCash(
@RequestParam("chkEach") String[] chkEach,
@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request , RedirectAttributes redirectAttributes,
Model model) throws Exception {
try {
LoginVO loginVO = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
if(userId == "") {
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("info.user.login"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uat/uia/EgovLoginUsr.do");
return redirectUrlMaker.getRedirectUrl();
}
for(String id: chkEach) {
mjonPrePayVO.setPrePayId(id);
mjonPrePayService.deletePrePayInfo(mjonPrePayVO);
}
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
return redirectUrlMaker.getRedirectUrl();
}catch(Exception e) {
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.delete"));
}
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
return redirectUrlMaker.getRedirectUrl();
}
/**
* 선결제 수정화면
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayModify.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayModify.do"})
public String PrePayModify(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request, RedirectAttributes redirectAttributes,
ModelMap model) throws Exception{
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
try {
MjonPrePayVO resultVO = mjonPrePayService.selectPrePayInfo(mjonPrePayVO);
model.addAttribute("resultVO", resultVO);
} catch (Exception e) {
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
return redirectUrlMaker.getRedirectUrl();
}
return "/uss/ion/pay/prePay/PrePayModify";
}
/**
* 선결제 수정화면
* @param searchVO
* @param model
* @return "/uss/ion/pay/updatePrePayModify.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/updatePrePayModify.do"})
public String updatePrePayModify(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request, RedirectAttributes redirectAttributes,
ModelMap model) throws Exception{
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
try {
String mberId = mjonPrePayVO.getMberId();
int mberCnt = mjonPrePayService.selectBLineMberCnt(mberId);
if(mberCnt > 0) {
LoginVO loginVO = EgovUserDetailsHelper.isAuthenticated()? (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser():null;
String userId = loginVO == null ? "" : EgovStringUtil.isNullToString(loginVO.getId());
mjonPrePayVO.setLastUpdusrId(userId);
mjonPrePayVO.setAmt(mjonPrePayVO.getAmt().replace(",", ""));
int resultCnt = mjonPrePayService.updatePrePayModify(mjonPrePayVO);
}else {
redirectAttributes.addFlashAttribute("message", mberId + "의 회원정보를 찾을 수 없습니다.");
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
return redirectUrlMaker.getRedirectUrl();
}
} catch (Exception e) {
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayList.do");
return redirectUrlMaker.getRedirectUrl();
}
return "redirect:/uss/ion/pay/PrePayList.do";
}
/**
* 결제 리스트 팝업
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayPopupListAjax.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayPopupListAjax.do"})
public String selectPrePayPopupListAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
ModelMap model) throws Exception{
String pattern = (String) request.getAttribute(HandlerMapping.BEST_MATCHING_PATTERN_ATTRIBUTE) ;
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
/** pageing */
PaginationInfo paginationInfo = new PaginationInfo();
paginationInfo.setCurrentPageNo(mjonPrePayVO.getPageIndex());
paginationInfo.setRecordCountPerPage(mjonPrePayVO.getPageUnit());
paginationInfo.setPageSize(mjonPrePayVO.getPageSize());
mjonPrePayVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
mjonPrePayVO.setLastIndex(paginationInfo.getLastRecordIndex());
mjonPrePayVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
mjonPrePayVO.setSearchSortCnd("prePayDate");
mjonPrePayVO.setSearchSortOrd("desc");
}
//특정 회원 정보리스트만 조회 되도록 검색값 셋팅
String mberId = mjonPrePayVO.getMberId();
List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO);
model.addAttribute("resultList", resultList);
model.addAttribute("totSumPrice", resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotSum() : 0);
paginationInfo.setTotalRecordCount(resultList.size() > 0 ? ((MjonPrePayVO)resultList.get(0)).getTotCnt() : 0);
model.addAttribute("paginationInfo", paginationInfo);
model.addAttribute("mberId", mberId);
return "/uss/ion/pay/prePay/popup/PrePayPopupList";
}
/**
* 선결제 등록화면
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayPopupRegistAjax.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayPopupRegistAjax.do"})
public String selectPrePayPopupRegistAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
ModelMap model) throws Exception{
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
System.out.println(mjonPrePayVO.getMberId());
String mberId = mjonPrePayVO.getMberId();
model.addAttribute("mberId", mberId);
return "/uss/ion/pay/prePay/popup/PrePayPopupRegist";
}
/**
* 선결제 수정화면
* @param searchVO
* @param model
* @return "/uss/ion/pay/PrePayModify.do"
* @throws Exception
*/
@RequestMapping(value= {"/uss/ion/pay/PrePayPopupModifyAjax.do"})
public String selectPrePayPopupModifyAjax(@ModelAttribute("searchVO") MjonPrePayVO mjonPrePayVO,
HttpServletRequest request, RedirectAttributes redirectAttributes,
ModelMap model) throws Exception{
// 미인증 사용자에 대한 보안처리
Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
if(!isAuthenticated) {
model.addAttribute("message", egovMessageSource.getMessage("fail.common.login"));
return "uat/uia/EgovLoginUsr";
}
try {
MjonPrePayVO resultVO = mjonPrePayService.selectPrePayInfo(mjonPrePayVO);
model.addAttribute("resultVO", resultVO);
} catch (Exception e) {
redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("fail.common.msg"));
RedirectUrlMaker redirectUrlMaker = new RedirectUrlMaker("/uss/ion/pay/PrePayPopupListAjax.do");
return redirectUrlMaker.getRedirectUrl();
}
return "/uss/ion/pay/prePay/popup/PrePayPopupModify";
}
//관리자 결제 엑셀 다운로드
@RequestMapping(value= {"/uss/ion/pay/SendPrePayExcelDownload.do"})
public void SendPrePayExcelDownload( MjonPrePayVO mjonPrePayVO,
HttpServletRequest request,
HttpServletResponse response ,
ModelMap model) throws Exception {
mjonPrePayVO.setRecordCountPerPage(5000);
mjonPrePayVO.setFirstIndex(0);
LoginVO loginVO = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
// 메모리에 100개의 행을 유지합니다. 행의 수가 넘으면 디스크에 적습니다.
SXSSFWorkbook wb = new SXSSFWorkbook(100);
CellStyle style = wb.createCellStyle();
style.setBorderBottom(CellStyle.BORDER_THIN); //테두리 두껍게
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setBorderTop(CellStyle.BORDER_THIN);
Font font = wb.createFont();
font.setBoldweight(Font.BOLDWEIGHT_BOLD); //글씨 bold
Cell cell = null;
Row row = null;
String fileName ="B선 회원 선결제내역";
String sheetTitle = "";
try{
if("".equals(mjonPrePayVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
mjonPrePayVO.setSearchSortCnd("prePayDate");
mjonPrePayVO.setSearchSortOrd("desc");
}
List<MjonPrePayVO> resultList = mjonPrePayService.selectPrePayList(mjonPrePayVO);
{ //화면 리스트
sheetTitle = "선결제내역" ; //제목
Sheet sheet = wb.createSheet(sheetTitle);
sheet.setColumnWidth(0, 2500);
sheet.setColumnWidth(1, 3500);
sheet.setColumnWidth(2, 3500);
sheet.setColumnWidth(3, 4000);
sheet.setColumnWidth(4, 3500);
sheet.setColumnWidth(5, 5000);
row = sheet.createRow(0);
for(int i=0 ; i < sendPrePayExcelValue.length ; i++) {
cell = row.createCell(i);
cell.setCellStyle(style);
cell.setCellValue(sendPrePayExcelValue[i][1]);
}
for(int i=0; i < resultList.size(); i++){
row = sheet.createRow(i+1);
for(int j=0 ; j < sendPrePayExcelValue.length ; j++) {
// 번호, 회원 아이디, 전용 전송사, 선결제 일자, 결제 금액, 등록일자
cell = row.createCell(j);
cell.setCellStyle(style);
if(j==0) cell.setCellValue(i+1); //번호
if(j==1) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getMberId()); //회원 아이디
if(j==2) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getAgentCodeDc()); //전용 전송사
if(j==3) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getPrePayDate() + " " + ((MjonPrePayVO)resultList.get(i)).getPrePayTime()); //선결제 일자
if(j==4) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getAmt()); //결제금액
if(j==5) cell.setCellValue(((MjonPrePayVO)resultList.get(i)).getLastUpdtPnttm()); //등록일자/수정일자
}
}
}
response.setHeader("Set-Cookie", "fileDownload=true; path=/");
SimpleDateFormat mSimpleDateFormat = new SimpleDateFormat ( "yyyy_MM_dd_HH_mm_ss", Locale.KOREA );
Date currentTime = new Date ();
String mTime = mSimpleDateFormat.format ( currentTime );
fileName = fileName+"("+mTime+")";
response.setHeader("Content-Disposition", String.format("attachment; filename=\""+new String((fileName).getBytes("KSC5601"),"8859_1")+".xlsx"));
wb.write(response.getOutputStream());
}catch(Exception e) {
response.setHeader("Set-Cookie", "fileDownload=false; path=/");
response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate");
response.setHeader("Content-Type","text/html; charset=utf-8");
OutputStream out = null;
try {
out = response.getOutputStream();
byte[] data = new String("fail..").getBytes();
out.write(data, 0, data.length);
} catch(Exception ignore) {
ignore.printStackTrace();
} finally {
if(out != null) try { out.close(); } catch(Exception ignore) {}
}
}finally {
// 디스크 적었던 임시파일을 제거합니다.
wb.dispose();
try { wb.close(); } catch(Exception ignore) {}
}
}
}