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;
}
