<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, users.databases.*" %> Conflict Found <%! /*** function ERASE-LAST-SUBSTR removes the last instance of a substring in a string ***/ String eraseLastSubstr (String strSubstrToErase, String strSource) { String newString = " " + strSource; int intLastIndex = newString.lastIndexOf(strSubstrToErase); int intTargetIndex = newString.length()-strSubstrToErase.length(); if (intLastIndex==intTargetIndex && intLastIndex != -1){ newString = newString.substring(0,intTargetIndex); } newString = newString.trim(); return newString; } String stringReplaceX (String strSubstrToModify, String strSource, String strSubstrReplacement) { String newString = strSource; while (newString.indexOf(strSubstrToModify) != -1 ) { newString = newString.substring(0,newString.indexOf(strSubstrToModify)) + strSubstrReplacement + newString.substring((newString.indexOf(strSubstrToModify) + strSubstrToModify.length()),newString.length()); } return newString; } /*** function GET-FIRST-WORD get the first word of a an extended string, if string is empty returns "s" ***/ String getFirstWord (String strSource) { String newString = strSource + " " + "s"; byte pos = 0; boolean wordFound = false; while (pos != newString.length()-1 && (wordFound == false)) { if (newString.charAt(pos) == ' ') { wordFound = true; } pos++; } newString = newString.substring(0, pos); newString = newString.trim(); return newString; } /*** function COMPRESS-COMPANY-NAME removes all optional strings and chars, USES REPLACE-OR-ERASE-X ***/ String compressCompanyName (String strCoName) { String newString = strCoName.toLowerCase(); newString = " " + newString + " "; newString = stringReplaceX(".", newString, " "); newString = stringReplaceX(",", newString, " "); newString = stringReplaceX("-", newString, " "); newString = stringReplaceX("_", newString, " "); newString = stringReplaceX(":", newString, " "); newString = stringReplaceX(";", newString, " "); newString = stringReplaceX("(", newString, " "); newString = stringReplaceX(")", newString, " "); newString = stringReplaceX("'s ", newString, " "); newString = stringReplaceX("'", newString, " "); newString = stringReplaceX(" the ", newString, " "); newString = stringReplaceX(" in ", newString, " "); newString = stringReplaceX(" of ", newString, " "); newString = stringReplaceX(" & ", newString, " "); newString = stringReplaceX(" and ", newString, " "); newString = stringReplaceX(" ", newString, " "); String subNewString = newString; newString = stringReplaceX(" ltd ", newString, " "); newString = stringReplaceX(" limited ", newString, " "); newString = stringReplaceX(" ultd ", newString, " "); newString = stringReplaceX(" unlimited ", newString, " "); newString = stringReplaceX(" mfg ", newString, " "); newString = stringReplaceX(" manufacturing ", newString, " "); newString = stringReplaceX(" mdsg ", newString, " "); newString = stringReplaceX(" merchandising ", newString, " "); newString = stringReplaceX(" mdse ", newString, " "); newString = stringReplaceX(" merchandise ", newString, " "); newString = stringReplaceX(" enterprise ", newString, " ent "); newString = stringReplaceX(" enterprises ", newString, " ent "); newString = stringReplaceX(" system ", newString, " sy "); // SINCE SYS WILL RETURN SY, S ENDING REMOVED newString = stringReplaceX(" systems ", newString, " sy "); newString = stringReplaceX(" cooperative ", newString, " coop "); newString = stringReplaceX(" cooperatives ", newString, " coop "); newString = stringReplaceX(" general ", newString, " gen "); newString = stringReplaceX(" management ", newString, " mngt "); newString = stringReplaceX(" managing ", newString, " mngt "); newString = stringReplaceX(" national ", newString, " natl "); newString = stringReplaceX(" service ", newString, " svc "); newString = stringReplaceX(" services ", newString, " svc "); newString = stringReplaceX(" servicing ", newString, " svc "); newString = stringReplaceX(" commercial ", newString, " comml "); newString = stringReplaceX(" marketing ", newString, " mktg "); newString = stringReplaceX(" construction ", newString, " const "); newString = stringReplaceX(" constructions ", newString, " const "); newString = stringReplaceX(" constructing ", newString, " const "); newString = stringReplaceX(" devt ", newString, " dev "); newString = stringReplaceX(" development ", newString, " dev "); newString = stringReplaceX(" developing ", newString, " dev "); newString = stringReplaceX(" communication ", newString, " comm "); newString = stringReplaceX(" communications ", newString, " comm "); newString = stringReplaceX(" security ", newString, " sec "); newString = stringReplaceX(" securities ", newString, " sec "); newString = stringReplaceX(" firm ", newString, " "); newString = stringReplaceX(" firms ", newString, " "); newString = stringReplaceX(" inc ", newString, " "); newString = stringReplaceX(" incorporated ", newString, " "); newString = stringReplaceX(" incorporation ", newString, " "); newString = stringReplaceX(" corp ", newString, " "); newString = stringReplaceX(" corporation ", newString, " "); newString = stringReplaceX(" co ", newString, " "); newString = stringReplaceX(" company ", newString, " "); newString = stringReplaceX(" phil ", newString, " "); newString = stringReplaceX(" phils ", newString, " "); newString = stringReplaceX(" philippines ", newString, " "); newString = stringReplaceX(" intl ", newString, " "); newString = stringReplaceX(" international ", newString, " "); newString = stringReplaceX(" ", newString, ""); if (newString.equals("")) { newString = subNewString; newString = getFirstWord(newString); newString = " " + newString + " "; newString = stringReplaceX(" incorporated ", newString, " inc "); newString = stringReplaceX(" incorporation ", newString, " inc "); newString = stringReplaceX(" corporation ", newString, " corp "); newString = stringReplaceX(" company ", newString, " co "); newString = stringReplaceX(" philippines ", newString, " phil "); newString = stringReplaceX(" enterprise ", newString, " ent "); newString = stringReplaceX(" enterprises ", newString, " intl "); newString = stringReplaceX(" systems ", newString, " sy "); newString = stringReplaceX(" system ", newString, " sy "); newString = stringReplaceX(" cooperative ", newString, " coop "); newString = stringReplaceX(" cooperatives ", newString, " coop "); newString = stringReplaceX(" general ", newString, " gen "); newString = stringReplaceX(" management ", newString, " mngt "); newString = stringReplaceX(" managing ", newString, " mngt "); newString = stringReplaceX(" national ", newString, " natl "); newString = stringReplaceX(" service ", newString, " svc "); newString = stringReplaceX(" services ", newString, " svc "); newString = stringReplaceX(" servicing ", newString, " svc "); newString = stringReplaceX(" commercial ", newString, " comml "); newString = stringReplaceX(" marketing ", newString, " mktg "); newString = stringReplaceX(" construction ", newString, " const "); newString = stringReplaceX(" constructions ", newString, " const "); newString = stringReplaceX(" constructing ", newString, " const "); newString = stringReplaceX(" devt ", newString, " dev "); newString = stringReplaceX(" development ", newString, " dev "); newString = stringReplaceX(" communication ", newString, " comm "); newString = stringReplaceX(" communications ", newString, " comm "); newString = stringReplaceX(" security ", newString, " sec "); newString = stringReplaceX(" securities ", newString, " sec "); newString = stringReplaceX(" merchandising ", newString, " mdsg "); newString = stringReplaceX(" merchandise ", newString, " mdse "); newString = stringReplaceX(" ", newString, ""); } newString = newString.trim(); return newString; } %> <% /**** VARIABLE DECLARATION and INITIALIZATION *****/ int intConflictStatus = 0, intUserID = 0, intCompanyID = 0; int[] listOfCoID = new int [3]; int[] tempList; int idx = 0, idxBreak = 0, intID = 0; boolean foundSimilarCoName = false; String strTempDB = "product_tmpClientInfoDB"; String strMainDB = "product_pgpClientInfoDB"; String strWhatDB = request.getParameter("whatDB"); String strUserLogName = request.getParameter("userLogName"); int intSType = Integer.parseInt(request.getParameter("stype")); String strCompanyName = request.getParameter("userCoName"); String strUserPosition = request.getParameter("userPosition"); strCompanyName = strCompanyName.trim(); String strCoRefName = compressCompanyName(strCompanyName); /***** MAIN *****/ String SQLstmt = "SELECT Co_ReferenceName, Co_ID FROM tblCompanyInfo;"; users.connect(strMainDB); ResultSet rs = users.listQuery(SQLstmt); while (rs.next()) { String strName = rs.getString("Co_ReferenceName"); if (strName.equals(strCoRefName)) { foundSimilarCoName = true; intID = rs.getInt("Co_ID"); listOfCoID[idx] = intID; idx++; if (idx % 3 == 0) { tempList = new int[idx]; for (int i=0; i
         

Company Name Conflict


 
<% if (foundSimilarCoName) { %>

We found in our database company name/s similar to the name of your company. Please select if one of the addresses below is the address of the company you are registering with us.

None of the addresses below is our company's address. <% int intCoID = listOfCoID[0]; users.connect(strMainDB); for (int i=0; i <% strName = rs.getString("CoHO_StreetAdd"); %> <% strName = strName + " " + rs.getString("CoHO_BrgyAdd"); %> <%= strName %> <% strName = rs.getString("CoHO_CityAdd"); %> <% strName = "          " + strName + " " + rs.getString("CoHO_ProvAdd"); %> <%= strName %> <% } } users.disconnect(); users.connect(strTempDB); for (int i=idxBreak; i <% strName = rs.getString("CoHO_StreetAdd"); %> <% strName = strName + " " + rs.getString("CoHO_BrgyAdd"); %> <%= strName %> <% strName = rs.getString("CoHO_CityAdd"); %> <% strName = "          " + strName + " " + rs.getString("CoHO_ProvAdd"); %> <%= strName %> <% } %> <% } %> <% users.disconnect(); %>

<% } else { // IF DID NOT FIND SIMILAR COMPANY NAME ON DATABASE %> <% } %>
 

Copyright © 2001-2003 by Grafikoncepts and Designs, Inc.
A joint project of Grafikoncepts and Designs, Inc. and Digital Management and Solutions, Inc.
Layout by MVMG (VPIT), Digital Management and Solutions, Inc.