public boolean isValidParty(PartyLovVO partyLovVO) throws Exception {
boolean validParty = false;
Connection connection = null;
StringBuilder finalQry = new StringBuilder();
PreparedStatement pstmt = null;
ResultSet rs = null;
QueryFields fields = null;
String whereCond = "";
try {
fields = new QueryFields();
fields.put("BP.DCS_STATUS", "1");
fields.put("PR.DCS_CODE", partyLovVO.getPartyRole());
fields.put("BP.DCS_CODE", partyLovVO.getPartyId());
if (!StringUtility.isNullEmpty(partyLovVO.getRelatedParty())) {
fields.put("BP.DCS_CODE", partyLovVO.getRelatedParty());
fields.put("PR.DCS_CODE", partyLovVO.getRelationShipType());
}
whereCond = " AND " + QueryBuilderUtil.buildWhereCond(fields);
finalQry.append(PartyLovQueries.validatePartyIdQry).append(whereCond);
connection = getConnection();
pstmt = connection.prepareStatement(finalQry.toString());
rs = pstmt.executeQuery();
if (rs.next()) {
if (rs.getInt(1) > 0) {
validParty = true;
} else {
validParty = false;
}
}
} finally {
ConnectionUtil.closeConnection(connection, pstmt, rs);
}
return validParty;
}
public void setSrchResults(RELabelSetupSrchParams searchParams) throws Exception {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
ArrayList<RELabelSetupSrchParams> searchResults = new ArrayList<RELabelSetupSrchParams>();
String labelFetchQry =
"SELECT ID, SCREEN_ID,DESCRIPTION,JSP_NAME,VO_CLASS,HANDLER_CLASS,"
+ "REMARKS,STATUS FROM SOFTWARE_SERVICES ";
try {
QueryFields fields = new QueryFields();
fields.put("SCREEN_ID", searchParams.getScrnId(), QueryConstants.LIKE_COND);
fields.put("DESCRIPTION", searchParams.getDesc(), QueryConstants.LIKE_COND);
fields.put("JSP_NAME", searchParams.getJspName(), QueryConstants.LIKE_COND);
fields.put("VO_CLASS", searchParams.getVoClass(), QueryConstants.LIKE_COND);
fields.put("HANDLER_CLASS", searchParams.getHandlerClass(), QueryConstants.DATE_TYPE);
fields.put("REMARKS", searchParams.getRemarks(), QueryConstants.LIKE_COND);
fields.put("STATUS", searchParams.getRemarks(), QueryConstants.LIKE_COND);
String whereCond = QueryBuilderUtil.buildWhereCond(fields);
String finalQry = labelFetchQry;
if (!TagLibStringUtility.isNullEmpty(whereCond)) {
finalQry = finalQry + " WHERE " + whereCond;
}
finalQry = finalQry + "ORDER BY SCREEN_ID DESC";
con = TagLibConnectionUtil.getConnection();
searchParams.totalRecords = QueryBuilderUtil.getTotalRowCount(finalQry, con);
String pagedQry =
QueryBuilderUtil.getPaginationQry(
finalQry, searchParams.startNumber, searchParams.endNumber);
pstmt = con.prepareStatement(pagedQry);
rs = pstmt.executeQuery();
while (rs.next()) {
RELabelSetupSrchParams labelSetup = new RELabelSetupSrchParams();
labelSetup.setId(rs.getLong("ID"));
labelSetup.setScrnId(rs.getString("SCREEN_ID"));
labelSetup.setDesc(rs.getString("DESCRIPTION"));
labelSetup.setJspName(rs.getString("JSP_NAME"));
labelSetup.setVoClass(rs.getString("VO_CLASS"));
labelSetup.setHandlerClass(rs.getString("HANDLER_CLASS"));
labelSetup.setRemarks(rs.getString("REMARKS"));
labelSetup.setStatus(rs.getString("STATUS"));
searchResults.add(labelSetup);
}
searchParams.setSearchResults(searchResults);
} catch (Exception e) {
e.printStackTrace();
} finally {
TagLibConnectionUtil.closePreparedStatement(pstmt, rs);
TagLibConnectionUtil.closeConnection(con);
}
}
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;
}
public String loadConsigneeOnBlurAjaxData(
PartyLovVO lovAttributes, ESupplyGlobalParameters loginBean, String xmlString)
throws Exception {
StringBuilder finalQry = new StringBuilder();
PreparedStatement pstmt = null;
ResultSet rs = null;
String invoiceBranch = null;
Connection connection = null;
String whereCond = "";
String invoiceDept = null;
String collectParty = null;
String stParty = null;
String collectCon = null;
String stCon = null;
String collectType = null;
String onBlurSeq = null;
String[] onBlurSeqAry = null;
try {
QueryFields fields = new QueryFields();
finalQry.append(PartyLovQueries.loadConsigneeOnBlurAjaxQry);
fields.put("BP.DCS_STATUS", "1");
fields.put("PR.DCS_CODE", lovAttributes.getPartyRole());
fields.put("BP.DCS_CODE", lovAttributes.getPartyId());
whereCond = " AND " + QueryBuilderUtil.buildWhereCond(fields);
finalQry.append(whereCond);
connection = getConnection();
pstmt = connection.prepareStatement(finalQry.toString());
rs = pstmt.executeQuery();
if (rs.next()) {
onBlurSeq = lovAttributes.getOnBlurSeq();
invoiceBranch = StringUtility.noNull(rs.getString("INVOICE_BRANCH"));
invoiceDept = StringUtility.noNull(rs.getString("INVOICE_DEPT"));
collectParty = StringUtility.noNull(rs.getString("COLLECT_PARTY"));
stParty = StringUtility.noNull(rs.getString("ST_PARTY"));
collectCon = StringUtility.noNull(rs.getString("COLLECT_CON"));
stCon = StringUtility.noNull(rs.getString("ST_CON"));
if (!StringUtility.isNullEmpty(onBlurSeq)) {
onBlurSeqAry = onBlurSeq.split(",");
}
if (onBlurSeqAry != null && onBlurSeqAry.length > 0) {
for (String onBlurFinalSeq : onBlurSeqAry) {
if ("1".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
xmlString += "<invoicebranch>" + invoiceBranch + "</invoicebranch>";
xmlString += "<invoicedept>" + invoiceDept + "</invoicedept>";
}
if ("2".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
if (!"0".equals(collectCon) && !"1".equals(collectCon)) {
collectType =
"1".equals(stCon) ? "Export" : ("2".equals(stCon) ? "Import" : "Both");
} else if (collectParty != "0" && "1" != collectParty) {
collectType =
"1".equals(stParty) ? "Export" : ("2".equals(stParty) ? "Import" : "Both");
}
xmlString += "<collectshipment>" + collectType + "</collectshipment>";
}
}
}
}
} finally {
ConnectionUtil.closeConnection(connection, pstmt, rs);
}
return xmlString;
}
public String loadCustomerOnBlurAjaxData(
PartyLovVO lovAttributes, ESupplyGlobalParameters loginBean, String xmlString)
throws Exception {
StringBuilder finalQry = new StringBuilder();
PreparedStatement pstmt = null;
ResultSet rs = null;
String invoiceBranch = null;
String partyId = "";
Connection connection = null;
String whereCond = "";
String invoiceDept = null;
String tradeTerms = "NoTradeTerm";
boolean ro = false;
String creditLimit = null;
String collectParty = null;
String stParty = null;
String collectCon = null;
String stCon = null;
String csr = null;
String salesPersonId = null;
String salesPersonIdNickName = null;
String collectType = null;
String onBlurSeq = null;
String[] onBlurSeqAry = null;
try {
QueryFields fields = new QueryFields();
finalQry.append(PartyLovQueries.loadCustomerOnBlurAjaxQry);
fields.put("BP.DCS_STATUS", "1");
fields.put("PR.DCS_CODE", lovAttributes.getPartyRole());
fields.put("BP.DCS_CODE", lovAttributes.getPartyId());
whereCond = " AND " + QueryBuilderUtil.buildWhereCond(fields);
finalQry.append(whereCond);
connection = getConnection();
pstmt = connection.prepareStatement(finalQry.toString());
rs = pstmt.executeQuery();
if (rs.next()) {
onBlurSeq = lovAttributes.getOnBlurSeq();
partyId = StringUtility.noNull(rs.getString("DCS_CODE"));
invoiceBranch = StringUtility.noNull(rs.getString("INVOICE_BRANCH"));
invoiceDept = StringUtility.noNull(rs.getString("INVOICE_DEPT"));
tradeTerms = StringUtility.noNull(rs.getString("TRADE_TERMS"));
creditLimit = StringUtility.noNull(rs.getString("CREDIT_LIMIT"));
collectParty = StringUtility.noNull(rs.getString("COLLECT_PARTY"));
stParty = StringUtility.noNull(rs.getString("ST_PARTY"));
collectCon = StringUtility.noNull(rs.getString("COLLECT_CON"));
stCon = StringUtility.noNull(rs.getString("ST_CON"));
csr = StringUtility.noNull(rs.getString("CSR"));
salesPersonId = StringUtility.noNull(rs.getString("SALESPERSONID"));
salesPersonIdNickName = StringUtility.noNull(rs.getString("SALESPERSONIDNICKNAME"));
if (!StringUtility.isNullEmpty(onBlurSeq)) {
onBlurSeqAry = onBlurSeq.split(",");
}
if (onBlurSeqAry != null && onBlurSeqAry.length > 0) {
for (String onBlurFinalSeq : onBlurSeqAry) {
if ("1".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
xmlString += "<invoicebranch>" + invoiceBranch + "</invoicebranch>";
xmlString += "<invoicedept>" + invoiceDept + "</invoicedept>";
}
if ("2".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
ro = StringUtility.noNull(rs.getString("RO")).equals("1") ? true : false;
xmlString += "<tradeterm>" + tradeTerms + "</tradeterm>";
xmlString += "<ro>" + ro + "</ro>";
}
if ("3".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
if (!"0".equals(collectCon) && !"1".equals(collectCon)) {
collectType =
"1".equals(stCon) ? "Export" : ("2".equals(stCon) ? "Import" : "Both");
} else if (collectParty != "0" && "1" != collectParty) {
collectType =
"1".equals(stParty) ? "Export" : ("2".equals(stParty) ? "Import" : "Both");
}
xmlString += "<collectshipment>" + collectType + "</collectshipment>";
}
if ("4".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
xmlString += "<creditlimit>" + creditLimit + "</creditlimit>";
}
if ("5".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
String[] csrTeam = csr.split(",");
String csrXmlString = "";
if (!StringUtility.isNullEmpty(csrTeam)) {
if ("csrAETeam".equals(lovAttributes.getCsrType()) && csrTeam.length > 0) {
csrXmlString = csrTeam[0];
} else if ("csrAITeam".equals(lovAttributes.getCsrType()) && csrTeam.length > 1) {
csrXmlString = csrTeam[1];
} else if ("csrOETeam".equals(lovAttributes.getCsrType()) && csrTeam.length > 2) {
csrXmlString = csrTeam[2];
} else if ("csrOITeam".equals(lovAttributes.getCsrType()) && csrTeam.length > 3) {
csrXmlString = csrTeam[3];
} else {
if (csrTeam.length > 4) {
csrXmlString = csrTeam[4];
}
}
}
xmlString += "<csr>" + csrXmlString + "</csr>";
}
if ("6".equals(onBlurFinalSeq) || "0".equals(onBlurFinalSeq)) {
String[] salesPerson =
getDefaultSalespersonForCustomer(partyId, loginBean.getTerminalId());
salesPersonId = !StringUtility.isNullEmpty(salesPerson) ? salesPerson[0] : "";
salesPersonIdNickName = !StringUtility.isNullEmpty(salesPerson) ? salesPerson[1] : "";
xmlString += "<salespersonid>" + salesPersonId + "</salespersonid>";
xmlString +=
"<salespersonidnickname>" + salesPersonIdNickName + "</salespersonidnickname>";
}
}
}
}
} finally {
ConnectionUtil.closeConnection(connection, pstmt, rs);
}
return xmlString;
}