public String goList() {
String responseStr = null;
String[] paramkeys = {"cCode", "listCnt", "curPage"};
if (!ISParameter.isParameterOK(request, paramkeys)) {
responseStr = xmlMgr.xmlBasic(2);
logger.info("[_OPR_] 존 설정 리스트 조회 중 파라메타 에러");
} else {
int listCnt = 0;
int curPage = 0;
String strListCnt = request.getParameter("listCnt");
String strCur = request.getParameter("curPage");
try {
listCnt = Integer.parseInt(strListCnt);
curPage = Integer.parseInt(strCur);
} catch (NumberFormatException e) {
logger.info(
ISLogger.oprStrS("숫자형 문자열이어야함 [listCnt:" + strListCnt + ", curPage:" + strCur + "]"));
return xmlMgr.xmlBasic(2);
}
try {
listCnt = Integer.parseInt(request.getParameter("listCnt"));
curPage = Integer.parseInt(request.getParameter("curPage"));
} catch (NumberFormatException e) {
return xmlMgr.xmlBasic(2);
}
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(request.getParameter("cCode"));
int totalCnt = sqlSetUp.getTotalCount(sqlBox);
if (totalCnt == 0) return xmlMgr.xmlBasic(0);
String m_SumStr = UTILmgr.setPaging(totalCnt, listCnt, curPage);
String[] start_end_rows = m_SumStr.split(" ");
sqlBox.clear();
sqlBox.addElement(mcode);
sqlBox.addElement(request.getParameter("cCode"));
sqlBox.addElement(start_end_rows[0]);
sqlBox.addElement(start_end_rows[1]);
Vector<Properties> resultBox = new Vector<Properties>();
sqlSetUp.getZoneInfo(sqlBox, resultBox);
// int vSize = resultBox.size();
responseStr = xmlMgr.xmlMulti(1, resultBox, totalCnt, request.getParameter("curPage"));
}
return responseStr;
}
public String goDelete(String[] sz_idxs, String memId, String route) {
String responseStr = null;
Vector<String> sqlBox = new Vector<String>();
for (int i = 0; i < sz_idxs.length; ++i) {
sqlBox.addElement(sz_idxs[i]);
}
sqlSetUp.backupZoneInfo(sqlBox);
Vector<Properties> detailInfos = new Vector<Properties>();
sqlSetUp.getZoneDetailInfo(sqlBox, detailInfos);
int delCnt = sqlSetUp.deleteZoneInfo(sqlBox);
if (delCnt > 0) {
for (int i = 0; i < detailInfos.size(); ++i) {
Properties detailRec = detailInfos.elementAt(i);
String useFlagDb = detailRec.getProperty("USEFLAG");
if (useFlagDb.equals("1")) {
Vector<String> condVec = new Vector<String>();
condVec.addElement(detailRec.getProperty("STDT") + detailRec.getProperty("STMM"));
condVec.addElement(detailRec.getProperty("ENDT") + detailRec.getProperty("ENMM"));
condVec.addElement("_" + detailRec.getProperty("STMM").substring(1));
if (sqlSetUp.updateCount(condVec, detailRec.getProperty("WEEKP"), false) == 0) {
logger.info("[_DEV_] 존 설정 업데이트 건수 : 0건 (확인 요망)");
}
}
NspKTSMS nspKTSMS = new NspKTSMS(memId, route, "order");
nspKTSMS.smsOrder(
UTILmgr.getDateTime(), detailRec.getProperty("CCODE"), "DEVICE", "2", CommonDef.DEVICE);
}
responseStr = xmlMgr.xmlBasic(1);
logger.info("[_OPR_] 존 설정 정보 삭제");
} else {
responseStr = xmlMgr.xmlBasic(0);
}
return responseStr;
}
private String makeSZ_IDX(String cCode, String cPhone, String zoneFlag) {
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(cCode);
sqlBox.addElement(zoneFlag);
Vector<Properties> resultBox = new Vector<Properties>();
sqlSetUp.getPrimaryKey(sqlBox, resultBox);
String sz_idx = null;
if (zoneFlag.equals("0")) { // 안심존
if (resultBox.size() >= 3) {
sz_idx = null;
} else {
boolean firstFlag = true;
boolean secondFlag = true;
boolean thirdFlag = true;
for (int i = 0; i < resultBox.size(); ++i) {
Properties prop = resultBox.elementAt(i);
String pk = prop.getProperty("SZ_IDX");
if (pk.indexOf("s01") >= 0) {
firstFlag = false;
} else if (pk.indexOf("s02") >= 0) {
secondFlag = false;
} else if (pk.indexOf("s03") >= 0) {
thirdFlag = false;
}
}
if (firstFlag) {
sz_idx = cPhone + "_s01";
} else if (secondFlag) {
sz_idx = cPhone + "_s02";
} else if (thirdFlag) {
sz_idx = cPhone + "_s03";
}
}
} else if (zoneFlag.equals("1")) {
if (resultBox.size() >= 1) {
sz_idx = null;
} else {
sz_idx = cPhone + "_d01";
}
}
return sz_idx;
}
public String goDetail() {
String responseStr = null;
String[] paramkeys = {"cCode", "sz_idx"};
if (!ISParameter.isParameterOK(request, paramkeys)) {
responseStr = xmlMgr.xmlBasic(2);
logger.info("[_OPR_] 존정보 상세 조회중 파라메타 에러");
} else {
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(request.getParameter("sz_idx"));
Vector<Properties> resultBox = new Vector<Properties>();
sqlSetUp.getZoneDetailInfo(sqlBox, resultBox);
responseStr = xmlMgr.xmlMulti(1, resultBox);
}
return responseStr;
}
public String goDcount() {
String responseStr = null;
String[] paramkeys = {"cCode"};
if (!ISParameter.isParameterOK(request, paramkeys)) {
responseStr = xmlMgr.xmlBasic(2);
logger.info("[_OPR_] 위험존 개수 조회 중 파라메타 에러");
} else {
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(request.getParameter("cCode"));
int totalCnt = sqlSetUp.getTotalCountByZone(sqlBox, "1");
if (totalCnt > 1) {
logger.info("[_OPR_] Safe zone is over limit(3)");
responseStr = xmlMgr.xmlBasic(30);
} else {
responseStr = xmlMgr.xmlBasic(1);
}
}
return responseStr;
}
protected Properties adjustSettingTime(
String stdt,
int stmmNum,
String endt,
int enmmNum,
String weekp,
Vector<Properties> timeOfFull) {
int countLimit = Integer.parseInt(Config.pp.getProperty("MINUTE_MAN")); // 100 : 분당 100개까지 설정 가능
int minuteLimit = Integer.parseInt(Config.pp.getProperty("MINUTE_CUT")); // 6 : 6분 이하만 설정 가능
int lastDigit = getLastDigit(stmmNum);
if (lastDigit > minuteLimit) {
return null;
} else {
String[] weekFields = {
"SUNDAYCOUNT",
"MONDAYCOUNT",
"TUESDAYCOUNT",
"WEDNESDAYCOUNT",
"THURSDAYCOUNT",
"FRIDAYCOUNT",
"SATURDAYCOUNT"
};
String[] weekNames = {"일요일", "월요일", "화요일", "수요일", "목요일", "금요일", "토요일"};
String stmm = null;
String enmm = null;
if (stmmNum < 10) {
stmm = "0" + stmmNum;
} else {
stmm = "" + stmmNum;
}
if (enmmNum < 10) {
enmm = "0" + enmmNum;
} else {
enmm = "" + enmmNum;
}
for (int i = 0; i < weekFields.length; ++i) {
if (weekp.substring(i, i + 1).equals("1")) {
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(stdt + stmm);
sqlBox.addElement(endt + enmm);
sqlBox.addElement("_" + lastDigit);
if (!sqlSetUp.isAvailableToSet(sqlBox, timeOfFull, countLimit, weekFields[i])) {
Properties prop = timeOfFull.lastElement();
prop.setProperty("WEEK", weekNames[i]);
stmmNum++;
enmmNum++;
return adjustSettingTime(stdt, stmmNum, endt, enmmNum, weekp, timeOfFull);
}
}
}
Properties prop = new Properties();
prop.setProperty("STMM", stmm);
prop.setProperty("ENMM", enmm);
return prop;
}
}
public String goUpdate() {
String responseStr = null;
String[] paramkeys = {
"cCode",
"sz_idx",
"zoneFlag",
"stdt",
"endt",
"weekp",
"useFlag",
"radius",
"lat",
"lon",
"zoneAddr",
"zoneName",
"kind",
"stmm",
"enmm"
};
if (!ISParameter.isParameterOK(request, paramkeys)) {
responseStr = xmlMgr.xmlBasic(2);
logger.info("[_OPR_] 존 설정 업데이트 중 파라메타 에러");
} else {
try {
String stdt = request.getParameter("stdt");
String endt = request.getParameter("endt");
String stmm = request.getParameter("stmm");
String enmm = request.getParameter("enmm");
int stdtNum = Integer.parseInt(stdt);
int endtNum = Integer.parseInt(endt);
int stmmNum = Integer.parseInt(stmm);
int enmmNum = Integer.parseInt(enmm);
String weekp = request.getParameter("weekp");
String zoneName = request.getParameter("zoneName");
String zoneAddr = request.getParameter("zoneAddr");
try {
zoneName = new String(zoneName.getBytes("ISO-8859-1"), "EUC-KR");
zoneName = java.net.URLDecoder.decode(zoneName, "UTF-8");
zoneAddr = new String(zoneAddr.getBytes("ISO-8859-1"), "EUC-KR");
zoneAddr = java.net.URLDecoder.decode(zoneAddr, "UTF-8");
} catch (Exception e) {
logger.error("[EXCEPTION]", e);
}
if ((stdt.equals(endt) && stmm.equals(enmm))
|| stdtNum > 23
|| endtNum > 23
|| stdtNum > endtNum
|| (stdt.equals(endt) && (stmmNum > enmmNum))
|| stmmNum > 59
|| enmmNum > 59) {
responseStr = xmlMgr.xmlBasic(930);
logger.info("[_OPR_] 존 설정 시간이 규칙에 위반하여 실패");
} else if (weekp.length() != 7 || weekp.equals("0000000")) {
responseStr = xmlMgr.xmlBasic(930);
logger.info("[_OPR_] 존 설정 요일이 규칙에 위반하여 실패");
} else {
String stdt2 = null;
if (stdtNum < 10) stdt2 = "0" + stdtNum;
else stdt2 = "" + stdtNum;
String endt2 = null;
if (endtNum < 10) endt2 = "0" + endtNum;
else endt2 = "" + endtNum;
Vector<Properties> timeOfFull = new Vector<Properties>();
Properties prop = adjustSettingTime(stdt2, stmmNum, endt2, enmmNum, weekp, timeOfFull);
if (prop == null) {
Properties timeOfFullProp = timeOfFull.lastElement();
String fullWeek = timeOfFullProp.getProperty("WEEK");
String fullHour = timeOfFullProp.getProperty("HOURCODE");
String fullMinute = timeOfFullProp.getProperty("MINUTECODE");
String msg =
"죄송합니다. 설정하신 시간 중에 ("
+ fullWeek
+ ")["
+ fullHour
+ ":"
+ fullMinute.substring(0, 1)
+ "0]시간대가 이용량이 많아 설정할 수 없습니다. 해당 시간을 피해서 설정해주세요.";
responseStr = xmlMgr.xmlBasic(1040, msg);
logger.info("[_OPR_] 설정 시간대에 이용량이 많아 설정 실패");
} else {
stmm = prop.getProperty("STMM");
enmm = prop.getProperty("ENMM");
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(request.getParameter("cCode"));
sqlBox.addElement(request.getParameter("sz_idx"));
Vector<Properties> resultBox = new Vector<Properties>();
sqlSetUp.getZoneTimeInfoByCCODE(sqlBox, resultBox);
if (isOverDayLimit(stdt, stmm, endt, enmm, weekp, resultBox)) {
responseStr = xmlMgr.xmlBasic(940);
logger.info("[_OPR_] 하루 최대 측위 건수 초과하여 설정됨으로 실패");
} else {
resultBox.clear();
sqlBox.clear();
sqlBox.addElement(mcode);
sqlBox.addElement(request.getParameter("cCode"));
sqlSetUp.getCPhoneByCCODE(sqlBox, resultBox);
if (resultBox.size() == 0) {
responseStr = xmlMgr.xmlBasic(-2);
logger.info("[_OPR_] 입력된 코드에 해당하는 단말 번호 정보가 없음. 실패");
} else {
String cPhone = resultBox.elementAt(0).getProperty("CPHONE");
sqlBox.clear();
sqlBox.addElement(request.getParameter("sz_idx"));
Vector<Properties> detailInfo = new Vector<Properties>();
sqlSetUp.getZoneDetailInfo(sqlBox, detailInfo);
if (detailInfo.size() == 0) {
responseStr = xmlMgr.xmlBasic(-2);
logger.info("[_OPR_] 입력된 코드(sz_idx)에 해당하는 정보가 없음. 실패");
} else {
String zoneFlagDb = detailInfo.elementAt(0).getProperty("ZONEFLAG");
String sz_idx_forUpdate = null;
if (request.getParameter("zoneFlag").equals(zoneFlagDb)) {
sz_idx_forUpdate = request.getParameter("sz_idx");
} else {
sz_idx_forUpdate =
makeSZ_IDX(
request.getParameter("cCode"),
cPhone,
request.getParameter("zoneFlag"));
}
if (sz_idx_forUpdate == null) {
responseStr = xmlMgr.xmlBasic(30);
logger.info("[_OPR_] 존아이디 생성중 실패");
} else {
sqlBox.clear();
sqlBox.addElement(request.getParameter("sz_idx"));
sqlSetUp.backupZoneInfo(sqlBox);
Vector<String> sqlBoxUpdate = new Vector<String>();
sqlBoxUpdate.addElement(sz_idx_forUpdate);
sqlBoxUpdate.addElement(request.getParameter("cCode"));
sqlBoxUpdate.addElement(stdt);
sqlBoxUpdate.addElement(endt);
sqlBoxUpdate.addElement(stmm);
sqlBoxUpdate.addElement(enmm);
sqlBoxUpdate.addElement(weekp);
sqlBoxUpdate.addElement(request.getParameter("useFlag"));
sqlBoxUpdate.addElement(request.getParameter("radius"));
sqlBoxUpdate.addElement(request.getParameter("lat"));
sqlBoxUpdate.addElement(request.getParameter("lon"));
String encZoneAddr = null;
try {
StringEncrypter stEncrypt = new StringEncrypter();
// encZoneAddr = stEncrypt.encrypt(request.getParameter("zoneAddr"));
encZoneAddr = stEncrypt.encrypt(zoneAddr);
} catch (Exception e) {
encZoneAddr = "";
logger.error("[EXCEPTION]", e);
}
sqlBoxUpdate.addElement(encZoneAddr);
// sqlBoxUpdate.addElement(request.getParameter("zoneName"));
sqlBoxUpdate.addElement(zoneName);
sqlBoxUpdate.addElement(request.getParameter("zoneFlag"));
sqlBoxUpdate.addElement(request.getParameter("kind"));
sqlBoxUpdate.addElement(request.getParameter("sz_idx"));
if (sqlSetUp.updateZoneInfo(sqlBoxUpdate) == 0) {
responseStr = xmlMgr.xmlBasic(1110);
} else {
logger.info("[_OPR_] 존 설정 정보, DB 업데이트 성공");
Properties detailRec = detailInfo.elementAt(0);
String useFlagDb = detailRec.getProperty("USEFLAG");
if (useFlagDb.equals("1")) {
Vector<String> condVec = new Vector<String>();
condVec.addElement(
detailRec.getProperty("STDT") + detailRec.getProperty("STMM"));
condVec.addElement(
detailRec.getProperty("ENDT") + detailRec.getProperty("ENMM"));
condVec.addElement("_" + detailRec.getProperty("STMM").substring(1));
if (sqlSetUp.updateCount(condVec, detailRec.getProperty("WEEKP"), false)
== 0) {
logger.info("[_OPR_] 존 설정 업데이트 건수 : 0건 (확인 요망)");
}
}
if (request.getParameter("useFlag").equals("1")) {
Vector<String> condVec = new Vector<String>();
condVec.addElement(stdt + stmm);
condVec.addElement(endt + enmm);
condVec.addElement("_" + stmm.substring(1));
if (sqlSetUp.updateCount(condVec, weekp, true) == 0) {
logger.info("[_OPR_] 존 설정 업데이트 건수 : 0건 (확인 요망)");
}
}
String route = request.getParameter("route");
NspKTSMS nspKTSMS = new NspKTSMS(mcode, route, "order");
responseStr =
nspKTSMS.smsOrder(
UTILmgr.getDateTime(),
request.getParameter("cCode"),
"DEVICE",
"2",
CommonDef.DEVICE);
}
}
}
}
}
}
}
} catch (NumberFormatException e) {
responseStr = xmlMgr.xmlBasic(930);
logger.error("[_OPR_] 존 설정 시간이 숫자가 아니여서 실패", e);
}
}
return responseStr;
}
public String goInsert() {
String responseStr = null;
String[] paramkeys = {
"cCode",
"zoneFlag",
"stdt",
"endt",
"weekp",
"useFlag",
"radius",
"lat",
"lon",
"zoneAddr",
"zoneName",
"kind",
"stmm",
"enmm"
};
if (!ISParameter.isParameterOK(request, paramkeys)) {
responseStr = xmlMgr.xmlBasic(2);
logger.info("[_OPR_] 존 설정 중 파라메타 에러");
} else {
try {
String stdt = request.getParameter("stdt");
String endt = request.getParameter("endt");
String stmm = request.getParameter("stmm");
String enmm = request.getParameter("enmm");
int stdtNum = Integer.parseInt(stdt);
int endtNum = Integer.parseInt(endt);
int stmmNum = Integer.parseInt(stmm);
int enmmNum = Integer.parseInt(enmm);
String weekp = request.getParameter("weekp");
String zoneName = request.getParameter("zoneName");
String zoneAddr = request.getParameter("zoneAddr");
try {
zoneName = new String(zoneName.getBytes("ISO-8859-1"), "EUC-KR");
zoneName = java.net.URLDecoder.decode(zoneName, "UTF-8");
zoneAddr = new String(zoneAddr.getBytes("ISO-8859-1"), "EUC-KR");
zoneAddr = java.net.URLDecoder.decode(zoneAddr, "UTF-8");
} catch (Exception e) {
logger.error("[EXCEPTION]", e);
}
if ((stdt.equals(endt) && stmm.equals(enmm))
|| stdtNum > 23
|| endtNum > 23
|| stdtNum > endtNum
|| (stdt.equals(endt) && (stmmNum > enmmNum))
|| stmmNum > 59
|| enmmNum > 59) {
responseStr = xmlMgr.xmlBasic(930);
logger.info("[_OPR_] 존 설정 시간이 규칙에 위반하여 실패");
} else if (weekp.length() != 7 || weekp.equals("0000000")) {
responseStr = xmlMgr.xmlBasic(930);
logger.info("[_OPR_] 존 설정 요일이 규칙에 위반하여 실패");
} else {
String stdt2 = null;
if (stdtNum < 10) stdt2 = "0" + stdtNum;
else stdt2 = "" + stdtNum;
String endt2 = null;
if (endtNum < 10) endt2 = "0" + endtNum;
else endt2 = "" + endtNum;
Vector<Properties> timeOfFull = new Vector<Properties>();
Properties prop = adjustSettingTime(stdt2, stmmNum, endt2, enmmNum, weekp, timeOfFull);
if (prop == null) {
Properties timeOfFullProp = timeOfFull.lastElement();
String fullWeek = timeOfFullProp.getProperty("WEEK");
String fullHour = timeOfFullProp.getProperty("HOURCODE");
String fullMinute = timeOfFullProp.getProperty("MINUTECODE");
String msg =
"죄송합니다. 설정하신 시간 중에 ("
+ fullWeek
+ ")["
+ fullHour
+ ":"
+ fullMinute.substring(0, 1)
+ "0]시간대가 이용량이 많아 설정할 수 없습니다. 해당 시간을 피해서 설정해주세요.";
responseStr = xmlMgr.xmlBasic(1040, msg);
logger.info("[_OPR_] 설정 시간대에 이용량이 많아 설정 실패");
} else {
stmm = prop.getProperty("STMM");
enmm = prop.getProperty("ENMM");
Vector<String> sqlBox = new Vector<String>();
sqlBox.addElement(request.getParameter("cCode"));
Vector<Properties> resultBox = new Vector<Properties>();
sqlSetUp.getZoneTimeInfoByCCODE(sqlBox, resultBox);
if (isOverDayLimit(stdt, stmm, endt, enmm, weekp, resultBox)) {
responseStr = xmlMgr.xmlBasic(940);
logger.info("[_OPR_] 하루 최대 측위 건수 초과하여 설정됨으로 실패");
} else {
resultBox.clear();
sqlBox.clear();
sqlBox.addElement(mcode);
sqlBox.addElement(request.getParameter("cCode"));
sqlSetUp.getCPhoneByCCODE(sqlBox, resultBox);
if (resultBox.size() == 0) {
responseStr = xmlMgr.xmlBasic(-2);
logger.info("[_OPR_] 입력된 코드에 해당하는 단말 번호 정보가 없음. 실패");
} else {
String cPhone = resultBox.elementAt(0).getProperty("CPHONE");
String sz_idx =
makeSZ_IDX(
request.getParameter("cCode"), cPhone, request.getParameter("zoneFlag"));
if (sz_idx == null) {
responseStr = xmlMgr.xmlBasic(30);
logger.info("[_OPR_] 존아이디 생성중 실패");
} else {
Vector<String> sqlBoxInsert = new Vector<String>();
sqlBoxInsert.addElement(sz_idx);
sqlBoxInsert.addElement(mcode);
sqlBoxInsert.addElement(request.getParameter("cCode"));
sqlBoxInsert.addElement(stdt);
sqlBoxInsert.addElement(endt);
sqlBoxInsert.addElement(stmm);
sqlBoxInsert.addElement(enmm);
// sqlBoxInsert.addElement(period);
sqlBoxInsert.addElement(weekp);
sqlBoxInsert.addElement(request.getParameter("useFlag"));
sqlBoxInsert.addElement(request.getParameter("radius"));
sqlBoxInsert.addElement(request.getParameter("lat"));
sqlBoxInsert.addElement(request.getParameter("lon"));
String encZoneAddr = null;
try {
StringEncrypter stEncrypt = new StringEncrypter();
// encZoneAddr = stEncrypt.encrypt(request.getParameter("zoneAddr"));
encZoneAddr = stEncrypt.encrypt(zoneAddr);
} catch (Exception e) {
encZoneAddr = "";
logger.error("[EXCEPTION]", e);
}
sqlBoxInsert.addElement(encZoneAddr);
// sqlBoxInsert.addElement(request.getParameter("zoneName"));
sqlBoxInsert.addElement(zoneName);
sqlBoxInsert.addElement(request.getParameter("zoneFlag"));
sqlBoxInsert.addElement(request.getParameter("kind"));
java.text.SimpleDateFormat formatter =
new java.text.SimpleDateFormat("yyyyMMddHHmmss");
String indt = formatter.format(new java.util.Date());
sqlBoxInsert.addElement(indt);
sqlBoxInsert.addElement(indt);
if (sqlSetUp.insertZoneInfo(sqlBoxInsert) == 0) {
responseStr = xmlMgr.xmlBasic(1110);
logger.info("[_OPR_] 존 설정 인서트 건수 : 0건 (확인 요망)");
} else {
Vector<String> condVec = new Vector<String>();
condVec.addElement(stdt + stmm);
condVec.addElement(endt + enmm);
condVec.addElement("_" + stmm.substring(1));
if (sqlSetUp.updateCount(condVec, weekp, true) == 0) {
logger.info("[_OPR_] 존 설정 업데이트 건수 : 0건 (확인 요망)");
}
logger.info("[_OPR_] 존 설정 정보, DB 입력 성공");
sqlBox.clear();
sqlBox.addElement(request.getParameter("cCode"));
resultBox.clear();
int ret = sqlSetUp.getMode(sqlBox, resultBox);
if (ret == -1) {
responseStr = xmlMgr.xmlBasic(1100);
} else {
if (resultBox.size() > 0) {
Properties rec = resultBox.elementAt(0);
String mode = rec.getProperty("MODE");
if (mode.equals("2")) {
logger.info("[_OPR_] 서버모드 진행 [mode:" + mode + "]");
Vector<String> sqlBoxPlatForm = new Vector<String>();
sqlBoxPlatForm.addElement(sz_idx);
sqlBoxPlatForm.addElement(cPhone);
sqlBoxPlatForm.addElement(stdt);
sqlBoxPlatForm.addElement(stmm);
sqlBoxPlatForm.addElement(endt);
sqlBoxPlatForm.addElement(enmm);
sqlBoxPlatForm.addElement("10"); // 주기 10분
sqlBoxPlatForm.addElement(weekp);
sqlBoxPlatForm.addElement(request.getParameter("useFlag"));
if (sqlSetUp.insertOrder(sqlBoxPlatForm) == 0) {
logger.info("[_OPR_] Insert order error on Server Mode");
responseStr = xmlMgr.xmlBasic(1110);
} else {
responseStr = xmlMgr.xmlBasic(1);
logger.info("[_OPR_] 서버모드 : ORDER DB 입력 성공");
}
return responseStr;
} else { // if(model_mode.equals("1") || model_mode.equals("0"))
String route = request.getParameter("route");
NspKTSMS nspKTSMS = new NspKTSMS(mcode, route, "order");
responseStr =
nspKTSMS.smsOrder(
UTILmgr.getDateTime(),
request.getParameter("cCode"),
"DEVICE",
"2",
CommonDef.DEVICE);
logger.info(
"[_OPR_] Send Device Order : mcode="
+ mcode
+ ", ccode="
+ request.getParameter("cCode")
+ ", opt=2");
}
}
}
responseStr = xmlMgr.xmlBasic(1);
}
}
}
}
}
}
} catch (NumberFormatException e) {
responseStr = xmlMgr.xmlBasic(930);
logger.error("[_OPR_] 존 설정 시간이 숫자가 아니여서 실패", e);
}
}
return responseStr;
}