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
package itn.web;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Map;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.apache.commons.lang3.StringUtils;
import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;
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.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import com.google.gson.JsonObject;
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;
import com.mashape.unirest.http.exceptions.UnirestException;
import itn.com.uss.olh.hpc.service.HackIpService;
import itn.com.uss.olh.hpc.service.HackIpVO;
import itn.let.lett.service.LetterService;
import itn.let.lett.service.LetterVO;
import itn.let.mjo.pay.service.MjonPayVO;
import itn.let.schdlr.service.SchdlrManageService;
import itn.let.uss.ion.cnt.service.CntManageVO;
import itn.let.uss.ion.cnt.service.EgovCntManageService;
@Controller
public class ContentController{
@Resource(name = "egovCntManageService")
private EgovCntManageService egovCntManageService;
@Resource(name = "hackIpService")
private HackIpService hackIpService;
@Resource(name = "SchdlrManageService")
private SchdlrManageService schdlrManageService;
@Resource(name = "LetterService")
private LetterService letterService;
/*인사말*/
@RequestMapping(value="/web/intro/intro.do")
public String intro(@RequestParam Map<String, Object> commandMap, Model model) throws Exception {
//selectNaviList(68, model);
return "/web/intro/intro";
}
/* content*/
@RequestMapping(value="/web/content.do")
public String contentIntro(@RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
if(commandMap.get("proFn")==null){
return "blank";
}
cntManageVO.setProgrmFileNm((String)commandMap.get("proFn"));
cntManageVO = egovCntManageService.selectContentVo(cntManageVO);
if(cntManageVO==null){ //매뉴에 등록되지 않았으면 cnt_manage 에서라도 가져옴.(proFn 으로 무조건 content 가져옴)
cntManageVO = new CntManageVO();
cntManageVO.setProgrmFileNm((String)commandMap.get("proFn"));
cntManageVO = egovCntManageService.selectContentByProFn(cntManageVO) ;
if(cntManageVO == null){
return "blank";
}
return "cnt/"+cntManageVO.getCntId() ;
}
if(cntManageVO.getMenuCours()!=null){ //매뉴구조
cntManageVO.setMenuCours(cntManageVO.getMenuCours().replace("|" , " > "));
}
if(null != commandMap.get("proFn")) {
cntManageVO.setMenuNo((String)commandMap.get("proFn"));
}
model.addAttribute("cntManageVO", cntManageVO);
String sLocationUrl = "cnt/"+cntManageVO.getCntId();
return sLocationUrl ;
}
/* 관리자 컨텐츠 content*/
@RequestMapping(value="/web/adminContent.do")
public String adminContent(@RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
//selectNaviList(68, model);
String tempCntDtId = "" ;
if(cntManageVO.getCntDtId() != null){ //관리자 미리보기 화면
tempCntDtId = cntManageVO.getCntDtId();
//cntManageVO = egovCntManageService.selectContentByCntDtId(cntManageVO);
cntManageVO = egovCntManageService.selectCntDtDetail(cntManageVO);
if(cntManageVO!=null){
if(cntManageVO.getMenuCours()!=null){ //매뉴구조
cntManageVO.setMenuCours(cntManageVO.getMenuCours().replace("|" , " > "));
}
}
if(cntManageVO.getCntCn().contains("bbsLoad")) {
cntManageVO.setCntCn(cntManageVO.getCntCn().replace("id=\"bbsLoad\"" , ""));
}
model.addAttribute("cntManageVO", cntManageVO);
}
String sLocationUrl = "cntsource/ckeditorPriview";
return sLocationUrl ;
}
/* 관리자 컨텐츠 content*/
@RequestMapping(value="/{siteId}/web/adminContent.do")
public String siteAdminContent(@PathVariable("siteId") String siteId, @RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
//selectNaviList(68, model);
String tempCntDtId = "" ;
if(cntManageVO.getCntDtId() != null){ //관리자 미리보기 화면
tempCntDtId = cntManageVO.getCntDtId();
//cntManageVO = egovCntManageService.selectContentByCntDtId(cntManageVO);
cntManageVO = egovCntManageService.selectCntDtDetail(cntManageVO);
if(cntManageVO!=null){
if(cntManageVO.getMenuCours()!=null){ //매뉴구조
cntManageVO.setMenuCours(cntManageVO.getMenuCours().replace("|" , " > "));
}
}
model.addAttribute("cntManageVO", cntManageVO);
}
String sLocationUrl = "cntsource/ckeditorPriview";
return sLocationUrl ;
}
/* 컨텐츠 등록시 실제 파일로 테스트 해봄*/
@RequestMapping(value="/web/contentTemp.do")
public String contentTempWrite(@RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
cntManageVO.setMenuCours("기관소개|인사말".replace("|" , " > "));
model.addAttribute("cntManageVO", cntManageVO);
return "cntsource/contentTemp";
}
/* 컨텐츠 에디터 미리보기 해봄*/
@RequestMapping(value="/web/ckeditorPriview.do")
public String ckeditorPriview(@RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
model.addAttribute("cntManageVO", cntManageVO);
String sLocationUrl = "cntsource/ckeditorPriview";
return sLocationUrl ;
}
/* 컨텐츠 에디터 미리보기 해봄*/
@RequestMapping(value="/{siteId}/web/ckeditorPriview.do")
public String siteCkeditorPriview(@PathVariable("siteId") String siteId , @RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
model.addAttribute("cntManageVO", cntManageVO);
String sLocationUrl = "cntsource/siteIdCkeditorPriview";
return sLocationUrl ;
}
/* siteId content*/
@RequestMapping(value="/{siteId}/web/content.do")
public String siteContentIntro(@PathVariable("siteId") String siteId ,@RequestParam Map<String, Object> commandMap, CntManageVO cntManageVO , HttpServletRequest request, Model model) throws Exception {
if(commandMap.get("proFn")==null){
return "blank";
}
cntManageVO.setProgrmFileNm((String)commandMap.get("proFn"));
cntManageVO.setSiteId(""); //수퍼 관리자 등록시 siteId 안들어감.
cntManageVO = egovCntManageService.selectContentVo(cntManageVO);
if(cntManageVO==null){ //매뉴에 등록되지 않았으면 cnt_manage 에서라도 가져옴.(proFn 으로 무조건 content 가져옴)
cntManageVO = new CntManageVO();
cntManageVO.setProgrmFileNm((String)commandMap.get("proFn"));
cntManageVO = egovCntManageService.selectContentByProFn(cntManageVO) ;
if(cntManageVO == null){
return "blank";
}
return "cnt/"+cntManageVO.getCntId() ;
}
if(cntManageVO.getMenuCours()!=null){ //매뉴구조
cntManageVO.setMenuCours(cntManageVO.getMenuCours().replace("|" , " > "));
}
model.addAttribute("cntManageVO", cntManageVO);
model.addAttribute("siteId", siteId);
String siteFolder = "site/"+siteId ;
model.addAttribute("site_path", "/"+siteFolder);
String sLocationUrl = "cnt/"+cntManageVO.getCntId();
return sLocationUrl ;
}
/* siteId content*/
@RequestMapping(value="/web/pop/infoPop.do")
public String siteContentIntro(@ModelAttribute CntManageVO cntManageVO, HttpServletRequest request, Model model) throws Exception {
String test = cntManageVO.getPageType();
model.addAttribute("pageType", test);
return "/web/pop/infoListPop";
}
/**
* 금융결제원 통합API포털 Callback URL
* @param kisaVO
* @param model
* @return modelAndView
* @throws Exception
* /web/bank/bankingApiCallbackAjax.do
*/
@RequestMapping(value = {"/web/bank/bankingApiCallbackAjax.do"})
public ModelAndView updateKisaAjax(
HttpServletRequest request
, String code) throws Exception {
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
modelAndView.addObject("code", code);
return modelAndView;
}
// 금융결제원 통합API포털 호출
@RequestMapping(value="/web/bank/bankingRealNameApiAccessTokenAjax.do")
public ModelAndView bankingRealNameApiAccessTokenAjax(@ModelAttribute("mjonPayVO") MjonPayVO mjonPayVO,
HttpServletRequest request) throws Exception {
boolean isSuccess = true;
String msg = "";
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
String rspCode = ""; // 최종 return 될 코드 값 Ex) O0002
String rspMessage = ""; // 최종 return 될 메시지 값 Ex) Access Token 거부
String accessToken = ""; // 토큰값
String accountHolderName = ""; // 예금주명
try {
// Step 1. Get Token
String client_id = "";
String client_secret = "";
String scope = "oob";
String grant_type = "client_credentials";
String bodyParams = "client_id=" + client_id + "&client_secret=" + client_secret + "&scope=" + scope + "&grant_type=" + grant_type;
// Unirest.post
HttpResponse<String> response = Unirest.post("https://testapi.openbanking.or.kr/oauth/2.0/token")
.header("content-type", "application/x-www-form-urlencoded; charset=UTF-8")
.header("cache-control", "no-cache")
.body(bodyParams)
.asString();
System.out.println("Step1 Web Response : " + response.getBody().toString());
// Response Parshing
JSONParser jsonParser = new JSONParser();
JSONObject jsonObject = (JSONObject) jsonParser.parse(response.getBody().toString());
accessToken = jsonObject.get("access_token").toString();
System.out.println("accessToken :: " + accessToken);
// Step 2. Real Name Check
Date now = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
String nowTime = sdf.format(now);
SimpleDateFormat sdf2 = new SimpleDateFormat("ddHHmmss");
String nowTime2 = sdf2.format(now);
String bankCode = ""; // 은행코드
switch(mjonPayVO.getBankNm()) {
case "국민은행" :
bankCode = "004";
break;
case "기업은행" :
bankCode = "003";
break;
case "농협은행" :
bankCode = "011";
break;
case "신한은행" :
bankCode = "088";
break;
case "우리은행" :
bankCode = "020";
break;
case "하나은행" :
bankCode = "081";
break;
case "카카오뱅크" :
bankCode = "090";
break;
}
String bank_tran_id = "이용기관코드" + nowTime2 + "Z"; // 은행거래번호 (이용기관코드 => Ex:M000000000U) + 일련번호)
String bank_code_std = bankCode; // 은행코드
String account_num = mjonPayVO.getAccountNum(); // 계좌번호
String account_holder_info_type = " "; // 생년월일 비교방식
String account_holder_info = mjonPayVO.getBirthDate(); // 생년월일
String tran_dtime = nowTime;
JsonObject params = new JsonObject();
params.addProperty("bank_tran_id", bank_tran_id);
params.addProperty("bank_code_std", bank_code_std);
params.addProperty("account_num", account_num);
params.addProperty("account_holder_info_type", account_holder_info_type);
params.addProperty("account_holder_info", account_holder_info);
params.addProperty("tran_dtime", tran_dtime);
// Unirest.post
HttpResponse<String> response2 = Unirest.post("https://testapi.openbanking.or.kr/v2.0/inquiry/real_name")
.header("content-type", "application/json; charset=UTF-8")
.header("cache-control", "no-cache")
.header("Authorization", "Bearer " + accessToken)
.body(params.toString())
.asString();
//System.out.println("Step1 Web Response : " + response2.getBody().toString());
// Response Parshing
JSONParser jsonParser2 = new JSONParser();
JSONObject jsonObject2 = (JSONObject) jsonParser2.parse(response2.getBody().toString());
rspCode = jsonObject2.get("rsp_code").toString();
rspMessage = jsonObject2.get("rsp_message").toString();
accountHolderName = jsonObject2.get("account_holder_name").toString();
System.out.println("rspCode :: " + rspCode);
System.out.println("rspMessage :: " + rspMessage);
} catch (UnirestException e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
modelAndView.addObject("rspCode", rspCode);
modelAndView.addObject("rspMessage", rspMessage);
modelAndView.addObject("accountHolderName", accountHolderName);
return modelAndView;
}
/**
* Whois 국가코드 Check
* @param kisaVO
* @param model
* @return modelAndView
* @throws Exception
* https://www.data.go.kr => itn0202 계정 인코딩된 서비스키 사용
*/
@RequestMapping(value="/web/whois/whoisIpCountryAjax.do")
public ModelAndView whoisIpCountryAjax(
HttpServletRequest request) throws Exception {
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
String response = "";
String result = "";
String whois = "";
String rspCode = "";
String countryCode = ""; // 국가코드
StringBuilder sb = new StringBuilder();
try {
String ipAddress = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
if (ipAddress == null) {
ipAddress = request.getRemoteAddr();
}
//ipAddress = "219.240.88.15"; // 국내IP
//ipAddress = "102.216.212.0"; // 해외IP
//ipAddress = "58.236.220.240";
System.out.println("ipAddress :: " + ipAddress);
// IP Check
if (StringUtils.isNotEmpty(ipAddress) && !ipAddress.equals("127.0.0.1") && !ipAddress.equals("0:0:0:0:0:0:0:1")) {
StringBuilder urlBuilder = new StringBuilder("http://apis.data.go.kr/B551505/whois/ipas_country_code");
// 인코딩된 서비스키
urlBuilder.append("?" + URLEncoder.encode("ServiceKey","UTF-8") + "=aEjBXkHxYU%2FVrzFOU22Zqujv8JEFJ0y2AmmxqkEv0O411NTNcpE2FbwvD7BxbG0sbepQbNp0%2FVj7HwbrrwV%2FOA%3D%3D");
urlBuilder.append("&" + URLEncoder.encode("query","UTF-8") + "=" + URLEncoder.encode(ipAddress, "UTF-8"));
urlBuilder.append("&" + URLEncoder.encode("answer","UTF-8") + "=" + URLEncoder.encode("JSON", "UTF-8"));
URL url = new URL(urlBuilder.toString());
HttpURLConnection conn = (HttpURLConnection) url.openConnection();
conn.setRequestMethod("GET");
conn.setRequestProperty("Content-type", "application/json");
//System.out.println("Response code: " + conn.getResponseCode());
BufferedReader rd;
if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
} else {
rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
}
String line;
while ((line = rd.readLine()) != null) {
sb.append(line);
}
rd.close();
conn.disconnect();
//System.out.println("Return: " + sb.toString());
// 전달받은 데이터 파싱
JSONParser jsonParser = new JSONParser();
JSONObject jsonObject = (JSONObject) jsonParser.parse(sb.toString());
response = jsonObject.get("response").toString();
JSONParser jsonParser2 = new JSONParser();
JSONObject jsonObject2 = (JSONObject) jsonParser2.parse(response.toString());
result = jsonObject2.get("result").toString();
JSONParser jsonParser3 = new JSONParser();
JSONObject jsonObject3 = (JSONObject) jsonParser3.parse(result.toString());
rspCode = jsonObject3.get("result_code").toString();
JSONParser jsonParser22 = new JSONParser();
JSONObject jsonObject22 = (JSONObject) jsonParser22.parse(response.toString());
whois = jsonObject22.get("whois").toString();
JSONParser jsonParser33 = new JSONParser();
JSONObject jsonObject33 = (JSONObject) jsonParser33.parse(whois.toString());
countryCode = jsonObject33.get("countryCode").toString();
System.out.println("rspCode :: " + rspCode);
System.out.println("countryCode :: " + countryCode);
}
else {
isSuccess = false;
msg = "ipNoCheck";
}
} catch (Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
modelAndView.addObject("rspCode", rspCode);
modelAndView.addObject("countryCode", countryCode);
return modelAndView;
}
/**
* Whois 국가코드 Check
* @param kisaVO
* @param model
* @return modelAndView
* @throws Exception
* https://www.data.go.kr => itn0202 계정 인코딩된 서비스키 사용
*/
@RequestMapping(value="/web/ipAjax.do")
public ModelAndView ipAjax(
HttpServletRequest request
, String ip) throws Exception {
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
String response = "";
String result = "";
String whois = "";
String rspCode = "";
String countryCode = ""; // 국가코드
StringBuilder sb = new StringBuilder();
String ipAddress = ip;
try {
System.out.println("ipAddress :: " + ipAddress);
// IP Check
if (StringUtils.isNotEmpty(ipAddress) && !ipAddress.equals("127.0.0.1") && !ipAddress.equals("0:0:0:0:0:0:0:1")) {
StringBuilder urlBuilder = new StringBuilder("http://apis.data.go.kr/B551505/whois/ipas_country_code");
// 인코딩된 서비스키
urlBuilder.append("?" + URLEncoder.encode("ServiceKey","UTF-8") + "=aEjBXkHxYU%2FVrzFOU22Zqujv8JEFJ0y2AmmxqkEv0O411NTNcpE2FbwvD7BxbG0sbepQbNp0%2FVj7HwbrrwV%2FOA%3D%3D");
urlBuilder.append("&" + URLEncoder.encode("query","UTF-8") + "=" + URLEncoder.encode(ipAddress, "UTF-8"));
urlBuilder.append("&" + URLEncoder.encode("answer","UTF-8") + "=" + URLEncoder.encode("JSON", "UTF-8"));
URL url = new URL(urlBuilder.toString());
HttpURLConnection conn = (HttpURLConnection) url.openConnection();
conn.setRequestMethod("GET");
conn.setRequestProperty("Content-type", "application/json");
//System.out.println("Response code: " + conn.getResponseCode());
BufferedReader rd;
if(conn.getResponseCode() >= 200 && conn.getResponseCode() <= 300) {
rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
} else {
rd = new BufferedReader(new InputStreamReader(conn.getErrorStream()));
}
String line;
while ((line = rd.readLine()) != null) {
sb.append(line);
}
rd.close();
conn.disconnect();
//System.out.println("Return: " + sb.toString());
// 전달받은 데이터 파싱
JSONParser jsonParser = new JSONParser();
JSONObject jsonObject = (JSONObject) jsonParser.parse(sb.toString());
response = jsonObject.get("response").toString();
JSONParser jsonParser2 = new JSONParser();
JSONObject jsonObject2 = (JSONObject) jsonParser2.parse(response.toString());
result = jsonObject2.get("result").toString();
JSONParser jsonParser3 = new JSONParser();
JSONObject jsonObject3 = (JSONObject) jsonParser3.parse(result.toString());
rspCode = jsonObject3.get("result_code").toString();
JSONParser jsonParser22 = new JSONParser();
JSONObject jsonObject22 = (JSONObject) jsonParser22.parse(response.toString());
whois = jsonObject22.get("whois").toString();
JSONParser jsonParser33 = new JSONParser();
JSONObject jsonObject33 = (JSONObject) jsonParser33.parse(whois.toString());
countryCode = jsonObject33.get("countryCode").toString();
System.out.println("rspCode :: " + rspCode);
System.out.println("countryCode :: " + countryCode);
}
else {
isSuccess = false;
msg = "ipNoCheck";
}
} catch (Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
modelAndView.addObject("rspCode", rspCode);
modelAndView.addObject("ipAddress", ipAddress);
modelAndView.addObject("countryCode", countryCode);
return modelAndView;
}
// 차단IP 여부
@RequestMapping(value = "/web/whois/ignoreIpCntAjax.do")
public ModelAndView ignoreIpCntAjax(
@ModelAttribute("hackIpVO") HackIpVO hackIpVO
, HttpServletRequest request) throws Exception {
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
int ignoreIpCnt = 0;
// 0:0:0:0:0:0:0:1
String ipAddress = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
if (ipAddress == null) {
ipAddress = request.getRemoteAddr();
}
try {
hackIpVO.setIgnoreIp(ipAddress);
ignoreIpCnt = hackIpService.selectIgnoreIpCnt(hackIpVO);
}
catch(Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
modelAndView.addObject("ipAddress", ipAddress);
modelAndView.addObject("ignoreIpCnt", ignoreIpCnt);
return modelAndView;
}
/**
* IP Block 화면
* @param request
* @param model
* @param addrVO
* @param redirectAttributes
* @return
* @throws Exception
*/
@RequestMapping("/web/block/blockAjax.do")
public String blockAjax(HttpServletRequest request, ModelMap model) throws Exception {
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
// 0:0:0:0:0:0:0:1
String ipAddress = request.getHeader("X-Forwarded-For") == null ? request.getHeader("X-Forwarded-For") : request.getHeader("X-Forwarded-For").replaceAll("10.12.107.11", "").replaceAll(",", "").trim();
if (ipAddress == null) {
ipAddress = request.getRemoteAddr();
}
model.addAttribute("ipAddress", ipAddress);
return "/block/Block";
}
/*서비스소개*/
@RequestMapping(value="/web/info/mjonInfo.do")
public String mjonInfo(@RequestParam Map<String, Object> commandMap, Model model) throws Exception {
//selectNaviList(68, model);
System.out.println("=====================mjonInfo");
model.addAttribute("url", "mjonInfo");
return "/cnt/mjonInfo";
}
/*주요기능*/
@RequestMapping(value="/web/info/mjonFunc.do")
public String mjonFunc(@RequestParam Map<String, Object> commandMap, Model model) throws Exception {
//selectNaviList(68, model);
System.out.println("=====================mjonFunc");
model.addAttribute("url", "mjonFunc");
return "/cnt/mjonFunc";
}
@RequestMapping(value = "/web/main/mainTest.do")
public String mainTest(HttpServletRequest request, ModelMap model, HttpSession session,
@RequestParam(value="message", defaultValue="0") String message, LetterVO letterVO) throws Exception{
return "web/main/mainTest";
}
// 배너 클릭 업데이트
@RequestMapping(value= {"/web/main/bannerClickUpdateAjax.do"})
public ModelAndView bannerClickUpdate(HttpServletRequest request,
ModelMap model) throws Exception{
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
try {
String mCode = request.getParameter("mCode");
String bCode = request.getParameter("bCode");
System.out.println("#############################################################");
System.out.println("mCode : " + mCode);
System.out.println("bCode : " + bCode);
}
catch(Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
return modelAndView;
}
// 전용계좌 스케줄러 실행
@RequestMapping(value= {"/web/main/vacsAutoChargeAjax.do"})
public ModelAndView vacsAutoCharge(HttpServletRequest request,
ModelMap model) throws Exception{
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
try {
schdlrManageService.vacsAutoCharge();
}
catch(Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
return modelAndView;
}
/*
@Resource(name = "mberGrdService")
MberGrdService mberGrdService;
// test
@RequestMapping(value= {"/web/main/testAjax.do"})
public ModelAndView testAjax(HttpServletRequest request,
ModelMap model) throws Exception{
ModelAndView modelAndView = new ModelAndView();
modelAndView.setViewName("jsonView");
boolean isSuccess = true;
String msg = "";
try {
MberGrdVO mberGrdVO = new MberGrdVO();
mberGrdVO.setFirstIndex(0);
mberGrdVO.setLastIndex(1000);
mberGrdVO.setRecordCountPerPage(1000);
if("".equals(mberGrdVO.getSearchSortCnd())){ //최초조회시 최신것 조회List
mberGrdVO.setSearchSortCnd("regDate");
mberGrdVO.setSearchSortOrd("desc");
}
List<MberGrdVO> resultList = mberGrdService.selectMberGrdList(mberGrdVO);
for (MberGrdVO item : resultList) {
mberGrdVO.setGrdNewDate("2022-01-01");
mberGrdVO.setMberId(item.getMberId());
// System.out.println("Step 3. 누적결제금액(이벤트금액 제외) 추출 및 등급 조회");
MberGrdVO mberGrdVO3 = new MberGrdVO();
mberGrdVO3 = mberGrdService.selectMberGrdAmtDetail(mberGrdVO);
System.out.println("MberId : " + item.getMberId());
System.out.println("MberGrdVO3 : " + mberGrdVO3);
if (null != mberGrdVO3) {
System.out.println("GrdSetNo() : " + mberGrdVO3.getGrdSetNo());
}
System.out.println("");
}
MberGrdVO mberGrdVO1 = new MberGrdVO();
if (!StringUtils.isEmpty(mberGrdVO1.getMberId())) {
System.out.println("mberGrdVO1 : NOT NULL");
}
else {
System.out.println("mberGrdVO1 : NULL");
}
MberGrdVO mberGrdVO2 = new MberGrdVO();
mberGrdVO2.setMberId("nopay");
if (!StringUtils.isEmpty(mberGrdVO2.getMberId())) {
System.out.println("mberGrdVO2 : NOT NULL");
}
else {
System.out.println("mberGrdVO2 : NULL");
}
}
catch(Exception e) {
isSuccess = false;
msg = e.getMessage();
}
modelAndView.addObject("isSuccess", isSuccess);
modelAndView.addObject("msg", msg);
return modelAndView;
}
*/
}