public String isValidNickName(PartyLovVO partyLovVO) {
Statement st = null;
Connection connection = null;
ResultSet rs = null;
String ret = "Invalid";
String partyRole = partyLovVO.getPartyRole();
String visiblePartyId = partyLovVO.getPartyNickName();
String hiddenPartyId = partyLovVO.getPartyId();
try {
boolean partyMatch =
visiblePartyId.equalsIgnoreCase(getNickNameInNickNameMode(hiddenPartyId));
if (!partyMatch) {
hiddenPartyId = "";
partyLovVO.setPartyId("");
}
if (!isValidParty(partyLovVO) || StringUtility.isNullEmpty(hiddenPartyId)) {
boolean temp = false;
if (!StringUtility.isNullEmpty(hiddenPartyId) && partyMatch) {
temp = isValidParty(partyLovVO);
if (!temp && ("*PU_LOCN".equals(partyRole) || "*DEL_LOCN".equals(partyRole))) {
if ("*PU_LOCN".equals(partyRole)) {
partyLovVO.setPartyRole("*SHIPPER");
} else {
partyLovVO.setPartyRole("*CONSIGNEE");
}
temp = isValidParty(partyLovVO);
}
}
if (!temp) {
connection = getConnection();
st =
connection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs =
st.executeQuery(
"SELECT DCS_CODE FROM ET_BUSINESS_PARTY WHERE DCS_NICK_NAME='"
+ visiblePartyId
+ "' AND DCS_PARTY_TYPE LIKE '%"
+ partyRole
+ "%'");
int count = 0;
if (rs.next()) {
rs.last();
count = rs.getRow();
rs.beforeFirst();
}
if (count == 0) {
ret = "InValidNickName";
} else if (count == 1) {
if (rs.first()) {
partyLovVO.setPartyId(rs.getString("DCS_CODE"));
temp = isValidParty(partyLovVO);
if (!temp && ("*PU_LOCN".equals(partyRole) || "*DEL_LOCN".equals(partyRole))) {
if ("*PU_LOCN".equals(partyRole)) {
partyLovVO.setPartyRole("*SHIPPER");
} else {
partyLovVO.setPartyRole("*CONSIGNEE");
}
temp = isValidParty(partyLovVO);
}
if (temp) {
ret = partyLovVO.getPartyId();
}
} else {
}
} else {
ret = "Duplicate";
}
} else {
ret = hiddenPartyId;
}
} else {
ret = hiddenPartyId;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionUtil.closeConnection(connection, st, rs);
}
return ret;
}
public String loadAJAXData(PartyLovVO lovAttributes, ESupplyGlobalParameters loginBean)
throws Exception {
StringBuilder finalQry = new StringBuilder();
PreparedStatement pstmt = null;
ResultSet rs = null;
String xmlString = "";
String userDisplaySeparator = "-";
String partyNickName = "";
String partyId = "";
String partyName = "";
String userDisplay = null;
String toolTip = null;
Connection connection = null;
String whereCond = "";
try {
QueryFields fields = new QueryFields();
if (ETPartyLovConstants.typeAheadLevel1.equals(lovAttributes.getTypeAheadLevel())
|| ETPartyLovConstants.typeAheadLevel3.equals(lovAttributes.getTypeAheadLevel())) {
finalQry.append("SELECT ");
finalQry.append(" USER_DISPLAY,");
finalQry.append(" TOOL_TIP,");
finalQry.append(" DCS_CODE,");
finalQry.append(" DCS_NICK_NAME,");
finalQry.append(" DCS_PARTY_NAME ");
finalQry.append(" FROM (" + PartyLovQueries.loadAjaxQuery_LEVEl1);
fields.put("BP.DCS_NICK_NAME", lovAttributes.getPartyNickName(), QueryConstants.LIKE_COND);
fields.put("BP.DCS_STATUS", "1");
fields.put("PR.DCS_CODE", lovAttributes.getPartyRole());
if (!StringUtility.isNullEmpty(lovAttributes.getRelatedParty())) {
fields.put("BP.DCS_CODE", lovAttributes.getRelatedParty());
fields.put("PR.DCS_CODE", lovAttributes.getRelationShipType());
}
whereCond = " AND " + QueryBuilderUtil.buildWhereCond(fields);
whereCond +=
" ORDER BY "
+ lovAttributes.getSearchMode()
+ " ) WHERE ROWNUM<="
+ lovAttributes.getDisplayRows();
finalQry.append(whereCond);
connection = getConnection();
pstmt = connection.prepareStatement(finalQry.toString());
rs = pstmt.executeQuery();
xmlString = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>";
xmlString += "<partyData>";
while (rs.next()) {
partyNickName = StringUtility.noNull(rs.getString("DCS_NICK_NAME"));
partyId = StringUtility.noNull(rs.getString("DCS_CODE"));
partyName = StringUtility.noNull(rs.getString("DCS_PARTY_NAME"));
userDisplay = StringUtility.noNull(rs.getString("USER_DISPLAY"));
toolTip = StringUtility.noNull(rs.getString("TOOL_TIP"));
xmlString += "<row>";
if (ETPartyLovConstants.typeAheadLevel1.equals(lovAttributes.getTypeAheadLevel())) {
xmlString += "<userdisplay>" + userDisplay + "</userdisplay>";
} else if (ETPartyLovConstants.typeAheadLevel3.equals(
lovAttributes.getTypeAheadLevel())) {
xmlString +=
"<userdisplay>" + userDisplay + userDisplaySeparator + partyName + "</userdisplay>";
}
xmlString += "<tooltip>" + toolTip + "</tooltip>";
if ("NickNameMode".equals(loginBean.getPartyMode())) {
xmlString += "<partynickname>" + partyNickName + "</partynickname>";
} else {
xmlString += "<partynickname>" + partyId + "</partynickname>";
}
xmlString += "<partycode>" + partyId + "</partycode>";
xmlString += "<partyName>" + partyName + "</partyName>";
xmlString += "</row>";
}
xmlString = xmlString + "</partyData>";
} else if (ETPartyLovConstants.typeAheadLevel2.equals(lovAttributes.getTypeAheadLevel())
|| ETPartyLovConstants.typeAheadLevel4.equals(lovAttributes.getTypeAheadLevel())) {
finalQry.append("SELECT ");
finalQry.append(" USER_DISPLAY,");
finalQry.append(" TOOL_TIP,");
finalQry.append(" DCS_CODE,");
finalQry.append(" DCS_NICK_NAME,");
finalQry.append(" DCS_PARTY_NAME,");
finalQry.append(" DCS_ADDRESS_NAME,");
finalQry.append(" DCS_ADDRESS_NAME2,");
finalQry.append(" DCS_BUILDING_NAME,");
finalQry.append(" DCS_STREET_NAME,");
finalQry.append(" DCS_CITY_TOWN,");
finalQry.append(" DCS_PHONE_NO,");
finalQry.append(" DCS_FAX,");
finalQry.append(" DCS_COUNTRY_STATE_CODE,");
finalQry.append(" DCS_POS_CODE,");
finalQry.append(" DCS_COUNTRY_CODE,");
finalQry.append(" DCS_FORMATTED_ADDRESS");
finalQry.append(" FROM (" + PartyLovQueries.loadAjaxQuery_LEVEl2);
fields.put("BP.DCS_NICK_NAME", lovAttributes.getPartyNickName(), QueryConstants.LIKE_COND);
fields.put("BP.DCS_STATUS", "1");
fields.put("PR.DCS_CODE", lovAttributes.getPartyRole());
if (!StringUtility.isNullEmpty(lovAttributes.getRelatedParty())) {
fields.put("BP.DCS_CODE", lovAttributes.getRelatedParty());
fields.put("PR.DCS_CODE", lovAttributes.getRelationShipType());
}
whereCond = " AND " + QueryBuilderUtil.buildWhereCond(fields);
whereCond +=
" ORDER BY "
+ lovAttributes.getSearchMode()
+ " ) WHERE ROWNUM<="
+ lovAttributes.getDisplayRows();
finalQry.append(whereCond);
connection = getConnection();
pstmt = connection.prepareStatement(finalQry.toString());
rs = pstmt.executeQuery();
xmlString = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>";
xmlString += "<partyData>";
while (rs.next()) {
partyNickName = StringUtility.noNull(rs.getString("DCS_NICK_NAME"));
partyId = StringUtility.noNull(rs.getString("DCS_CODE"));
partyName = StringUtility.noNull(rs.getString("DCS_PARTY_NAME"));
userDisplay = StringUtility.noNull(rs.getString("USER_DISPLAY"));
toolTip = StringUtility.noNull(rs.getString("TOOL_TIP"));
xmlString += "<row>";
xmlString += "<userdisplay>" + userDisplay + "</userdisplay>";
xmlString += "<tooltip>" + toolTip + "</tooltip>";
if ("NickNameMode".equals(loginBean.getPartyMode())) {
xmlString += "<partynickname>" + partyNickName + "</partynickname>";
} else {
xmlString += "<partynickname>" + partyId + "</partynickname>";
}
xmlString += "<partycode>" + partyId + "</partycode>";
xmlString += "<partyName>" + partyName + "</partyName>";
xmlString += "<addressname1>" + rs.getString("DCS_ADDRESS_NAME") + "</addressname1>";
xmlString += "<addressname2>" + rs.getString("DCS_ADDRESS_NAME2") + "</addressname2>";
xmlString += "<buildingname>" + rs.getString("DCS_BUILDING_NAME") + "</buildingname>";
xmlString += "<streetname>" + rs.getString("DCS_STREET_NAME") + "</streetname>";
xmlString += "<citytown>" + rs.getString("DCS_CITY_TOWN") + "</citytown>";
xmlString += "<phoneno>" + rs.getString("DCS_PHONE_NO") + "</phoneno>";
xmlString += "<fax>" + rs.getString("DCS_FAX") + "</fax>";
xmlString +=
"<countrystate>" + rs.getString("DCS_COUNTRY_STATE_CODE") + "</countrystate>";
xmlString += "<poscode>" + rs.getString("DCS_POS_CODE") + "</poscode>";
xmlString += "<countrycode>" + rs.getString("DCS_COUNTRY_CODE") + "</countrycode>";
xmlString +=
"<formatedaddress>" + rs.getString("DCS_FORMATTED_ADDRESS") + "</formatedaddress>";
xmlString += "</row>";
}
xmlString = xmlString + "</partyData>";
}
} catch (Exception e) {
e.printStackTrace();
throw e;
} finally {
ConnectionUtil.closeResultSet(rs);
ConnectionUtil.closePreparedStatement(pstmt);
ConnectionUtil.closeConnection(connection);
}
return xmlString;
}
