<%@ page language="java"
    import="java.sql.*, java.io.*, java.util.*, users.databases.*"
%>

<jsp:useBean id="users" class="users.databases.tmpDataList" />

<%!
    /***** METHOD DECLARATION *****/

    /*** function FOUND-INVALID-DIAL-UP-CHAR checks for null entry but accepts '-' char ***/
    boolean foundInvalidDialUpChar (String strToSearch) {
      int strLength = strToSearch.length();
      boolean found = false;
      for (int pos=0; pos<strLength; pos++) {
        char strChar = strToSearch.charAt(pos);
        if (Character.isDigit(strChar) || strChar == '-' ) {
        } else {
          found = true;
        }
      }
      return found;
    }

    /*** function ERASE-SUBSTR removes all occurances of any substring from a string ***/
    String eraseSubstr (String strSubstrToErase, String strSource) {
      String newString = "";
      if (strSource.equals("")) {
        strSource = strSubstrToErase;
      }
      int count = 0;
      int index = 0; 
      do {
        ++count;
        index = strSource.indexOf(strSubstrToErase, index);
        if (index != -1) {
          index += strSubstrToErase.length();
        }
      } while (index != -1);

      String[] subStr = new String[count];

      index = 0;
      int endIndex = 0;
      for (int i=0; i<count; i++) {
        endIndex = strSource.indexOf(strSubstrToErase,index);
        if (endIndex == -1)
          subStr[i] = strSource.substring(index);
        else
          subStr[i] = strSource.substring(index, endIndex);
        index = endIndex + strSubstrToErase.length();
      }
      for (int i=0; i<subStr.length; i++) {
        newString = newString + subStr[i];
      }
      return newString;
    }

    /*** function REPLACE-OR-ERASE removes all occurances of any substring from a string, includes ERASE-LAST-SUBSTR ***/
    String replaceOrErase (String strSubstrToErase, String strSource, String strReplacement) {
      String newString = "";
      int count = 0;
      int index = 0;
      do {
        ++count;
        index = strSource.indexOf(strSubstrToErase, index);
        if (index != -1) {
          index += strSubstrToErase.length();
        }
      } while (index != -1);

      if (count > 1) {
        String[] subStr = new String[count];
        index = 0;
        int endIndex = 0;
        for (int i=0; i<count; i++) {
          endIndex = strSource.indexOf(strSubstrToErase,index);
          if (endIndex == -1) {
            subStr[i] = strSource.substring(index);
          } else {
            subStr[i] = strSource.substring(index, endIndex);
          }
          index = endIndex + strSubstrToErase.length();
        }

        for (int i=0; i<subStr.length; i++) {
          if (i==(subStr.length-1)) {
            newString = newString + subStr[i];
          } else {
            newString = newString + subStr[i] + strReplacement;
          }
        }
      } else {
        newString = strSource;
      }
      newString = newString.trim();
      return newString;
    }

    /*** function DASH-AND-ZEROES-AWAY removes leading zeroes and dashes on numerical entries ***/
    String dashAndZeroesAway (String strToClean) {
      String newString = eraseSubstr("-",strToClean);
      if (newString.equals("")) {
      } else {
        int pos = 0;
        while (newString.charAt(pos) == '0' && pos != newString.length()-1) {
          pos++;
        }
        if (newString.charAt(pos) == '0') {
          newString = "";
        } else {
          newString = newString.substring(pos);
        }
      }
      return newString;
    }

    /*** function FOUND-EMPTY-BOX checks for null entry or empty textbox ***/
    boolean foundEmptyBox (String strBoxValue) {
      boolean found = false;
      if (strBoxValue.equals("")) {
        found = true;
      }
      return found;
    }

    /*** function FIRST-LETTER-CAP transform the first letter of every word to upper case and the rest to lower case ***/
    String firstLetterCap (String strSource) {
      String newString = strSource.trim();
      if (newString.equals("")) {
      } else {
        newString = newString.toLowerCase();
        char[] arrNewString = newString.toCharArray();
        arrNewString[0] = Character.toUpperCase(arrNewString[0]);
        byte pos = 0;
        while (pos != newString.length()-1) {
          if (newString.charAt(pos) == ' ' || newString.charAt(pos) == '.' || newString.charAt(pos) == ',') {
            arrNewString[pos+1] = Character.toUpperCase(arrNewString[pos+1]);
          }
          pos++;
        }
        newString = String.copyValueOf(arrNewString);
      }
      return newString;
    }

    /*** function FOUND-INVALID-EMAIL checks for the presence of an at sign (@) and dot (.) in the e-mail address ***/
    boolean foundInvalidEMail (String strBoxValue) {
      int strLength = strBoxValue.length();
      boolean found = false;
      boolean atSignFound = false;
      for (int pos=0; pos<strLength; pos++) {
        char strChar = strBoxValue.charAt(pos);
        if (strChar == ' ') {
          found = true;
          break;
        } else if (strChar == '@') {
          atSignFound = true;
        } else if (atSignFound) {
          if (strChar == '.') {
            found = false;
            break;
          }
        } else {
        found = true;
        }
      }
      return found;
    }

    /*** function FOUND-INVALID-SITE checks for the presence of a dot (.) in the website entry ***/
    boolean foundInvalidSite (String strBoxValue) {
      int strLength = strBoxValue.length();
      boolean found = false;
      boolean atSignFound = false;
      for (int pos=0; pos<strLength; pos++) {
        char strChar = strBoxValue.charAt(pos);
        if (strChar == ' ') {
          found = true;
          break;
        } else if (strChar == '.') {
          found = false;
          break;
        } else {
          found = true;
        }
      }
      return found;
    }
%>

<%
    /***** VARIABLE DECLARATION and INITIALIZATION *****/
    boolean invalidDialUpChar = false, invalidEMailAdd = false, invalidWebsite = false, areaCodeOK = false;
    boolean noProvSelected = false, withError = false, cp1Inc = false, cp2Inc = false, cp3Inc = false, switchButton = false;
    boolean noContactPerson = false, incFax = false, cp1NotEmpty = true, cp2NotEmpty = true, cp3NotEmpty = true;
    String[] arrAreaCode = new String[5];
    String strCpUser = "", strCheckBox = "", strAreaCode = "";
    String strTblName = "", strFieldName = "", strPageTitle = "", strFormTitle = "";
    String strTempDB = "product_tmpClientInfoDB";
    String strCodeDB = "product_areaCodesPhDB";

    String strUserLogName   = request.getParameter("usrLog");
    int intCompanyID        = Integer.parseInt(request.getParameter("CoID"));
    String strCompanyName   = request.getParameter("CoName");
    String strFirstTimer    = request.getParameter("usr1st");
    byte bytButtonID        = Byte.parseByte(request.getParameter("btnID"));
    String strRepeat        = request.getParameter("repeat");

    switch (bytButtonID) {
      case 1:
        strTblName   = "tblForeignOfc";
        strFieldName = "ForeignOfc";
        strPageTitle = "Foreign Office";
        strFormTitle = "FOREIGN OFFICE ADDRESS";
        break;
      case 2:
        strTblName   = "tblSalesOfc";
        strFieldName = "SalesOfc";
        strPageTitle = "Sales Office";
        strFormTitle = "COMPANY SALES OFFICE ADDRESS";
        break;
      case 3:
        strTblName   = "tblShowRm";
        strFieldName = "ShowRm";
        strPageTitle = "Showroom";
        strFormTitle = "COMPANY SHOWROOM ADDRESS";
        break;
      case 4:
        strTblName   = "tblWareHse";
        strFieldName = "PlantAndWHse";
        strPageTitle = "Plant/Warehouse";
        strFormTitle = "COMPANY PLANT OR WAREHOUSE ADDRESS";
        break;
      case 5:
        strTblName   = "tblTechSvc";
        strFieldName = "TechlSvc";
        strPageTitle = "Technical Services Office";
        strFormTitle = "TECHNICAL SERVICES OFFICE ADDRESS";
    }

    /***** INTERMISSION *****/
%>

<html>
<head><title> <%= strPageTitle %> Information </title>
<script language="javascript">
<!--

function checkCode() {
  str1 = "" + frmInfo.TArea.value;
  str = "0";
  ctr = 0;
  while (str=="0") {
    str = str1.substring(ctr,ctr+1);
    ctr++;
  }
  if (ctr==str1.length) {
    str1 = str1.substring(ctr-1,ctr);
  } else {
    str1 = str1.substring(ctr-1,ctr+1);
  }
  if (str1=="") {
  } else if (frmInfo.Prov.value=="000") {
    alert ("You have NOT selected a province.");
  } else {
    str2 = frmInfo.Prov.value;
    str3 = str2.substring(2,str2.length); // NAME OF PROVINCE
    str2 = str2.substring(0,2);
    if (str2.substring(0,1)=="0") {
      str2 = str2.substring(1,2);
      str1 = str1.substring(0,1);
    }
    if (str1!=str2) {
      alert("Telephone Area code for province " + str3 + " should be " + str2 +
            "\nor for exceptional areas of the province, start with this number.\n" +
            "\nIf you made a mistake, please correct it now.");
    }
  }
}

function cancelForm() {
  document.frmInfo.repeat.value = "Cancel";
  frmInfo.submit('getbp.jsp');
}

-->
</script>
<LINK REL="stylesheet" HREF="../v3_css-js/sitemain.css">
</head>
<BODY TOPMARGIN="10" LEFTMARGIN="10" MARGINWIDTH="10" MARGINHEIGHT="10" onLoad="selectProv()">

<%
    String SQLstmt = "SELECT " + strFieldName + " FROM tblCoInfoIndicator WHERE Co_ID=" + intCompanyID + ";";
    users.connect(strTempDB);
    ResultSet rs = users.listQuery(SQLstmt);
    while (rs.next()) {
      byte bytValue = rs.getByte(strFieldName);
      if (bytValue==1) {
        switchButton = true;
      }
    }
    if (strRepeat.equals("Cancel")) {
      switchButton = true;
    }
%>
    <% if (switchButton) { %>

          <jsp:forward page="accessTen.jsp">
            <jsp:param name="usrLog" value="<%= strUserLogName %>"/>
            <jsp:param name="CoID"   value="<%= intCompanyID %>"/>
            <jsp:param name="CoName" value="<%= strCompanyName %>"/>
          </jsp:forward>

    <% } %>
    <% /***** END OF INTERMISSION *****/ %>
<%
    String strOfcStreetAdd = "";
    String strOfcBrgyAdd   = "";
    String strOfcCityAdd   = "";
    String strOfcProvAdd   = "";
    String strProvAdd      = "000";
    String strOfcZipCode   = "";
    String strOfcTelArea   = "";
    String strOfcTelNum    = "";
    String strOfcTelLocal  = "";
    String strOfcFaxArea   = "";
    String strOfcFaxNum    = "";
    String strOfcFaxLocal  = "";
    String strOfcEmail     = "";
    String strOfcWebsite   = "";
    String strCP1FName     = "";
    String strCP1LName     = "";
    String strCP1Position  = "";
    String strCP1TelArea   = "";
    String strCP1TelNum    = "";
    String strCP1TelLocal  = "";
    String strCP1EMail     = "";
    String strCP2FName     = "";
    String strCP2LName     = "";
    String strCP2Position  = "";
    String strCP2TelArea   = "";
    String strCP2TelNum    = "";
    String strCP2TelLocal  = "";
    String strCP2EMail     = "";
    String strCP3FName     = "";
    String strCP3LName     = "";
    String strCP3Position  = "";
    String strCP3TelArea   = "";
    String strCP3TelNum    = "";
    String strCP3TelLocal  = "";
    String strCP3EMail     = "";

    if (strFirstTimer.equals("true")) {
    } else {
      strOfcStreetAdd = request.getParameter("St");
      strOfcBrgyAdd   = request.getParameter("Brgy");
      strOfcCityAdd   = request.getParameter("City");
      strOfcProvAdd   = request.getParameter("Prov");
      strProvAdd      = strOfcProvAdd.substring(2);

      strOfcZipCode   = request.getParameter("ZCode");
      strOfcTelArea   = request.getParameter("TArea");
      strOfcTelNum    = request.getParameter("TNum");
      strOfcTelLocal  = request.getParameter("TLoc");
      strOfcFaxArea   = request.getParameter("FArea");
      strOfcFaxNum    = request.getParameter("FNum");
      strOfcFaxLocal  = request.getParameter("FLoc");
      strOfcEmail     = request.getParameter("EMail");
      strOfcWebsite   = request.getParameter("WSite");

      strCpUser       = request.getParameter("cpUsr");
      strCP1FName     = request.getParameter("cp1FN");
      strCP1LName     = request.getParameter("cp1LN");
      strCP1Position  = request.getParameter("cp1Pos");
      strCP1TelArea   = request.getParameter("cp1TArea");
      strCP1TelNum    = request.getParameter("cp1TNum");
      strCP1TelLocal  = request.getParameter("cp1TLoc");
      strCP1EMail     = request.getParameter("cp1EMail");
      strCP2FName     = request.getParameter("cp2FN");
      strCP2LName     = request.getParameter("cp2LN");
      strCP2Position  = request.getParameter("cp2Pos");
      strCP2TelArea   = request.getParameter("cp2TArea");
      strCP2TelNum    = request.getParameter("cp2TNum");
      strCP2TelLocal  = request.getParameter("cp2TLoc");
      strCP2EMail     = request.getParameter("cp2EMail");
      strCP3FName     = request.getParameter("cp3FN");
      strCP3LName     = request.getParameter("cp3LN");
      strCP3Position  = request.getParameter("cp3Pos");
      strCP3TelArea   = request.getParameter("cp3TArea");
      strCP3TelNum    = request.getParameter("cp3TNum");
      strCP3TelLocal  = request.getParameter("cp3TLoc");
      strCP3EMail     = request.getParameter("cp3EMail");
    }


%>
    <script language="javascript">
    <!--
    function selectProv() {
      for (var i=0; i<frmInfo.Prov.length; i++) {
        if (frmInfo.Prov.options[i].text == '<%= strProvAdd %>') {
          frmInfo.Prov.options[i].selected = true;
          break;
        }
      }
      history.go(1);
      frmInfo.St.focus();
    }
    -->
    </script>
<%

    /***** MAIN *****/

    if (strFirstTimer.equals("true")) {
      withError = true;
    } else {
      strOfcStreetAdd = firstLetterCap(strOfcStreetAdd);
      strOfcStreetAdd = replaceOrErase("De La ", strOfcStreetAdd, "de la ");
      strOfcStreetAdd = replaceOrErase("De ", strOfcStreetAdd, "de ");
      strOfcStreetAdd = replaceOrErase("Dela ", strOfcStreetAdd, "dela ");
      strOfcStreetAdd = replaceOrErase("Del ", strOfcStreetAdd, "del ");
      strOfcBrgyAdd   = firstLetterCap(strOfcBrgyAdd);
      strOfcBrgyAdd   = replaceOrErase("De La ", strOfcBrgyAdd, "de la ");
      strOfcBrgyAdd   = replaceOrErase("De ", strOfcBrgyAdd, "de ");
      strOfcBrgyAdd   = replaceOrErase("Dela ", strOfcBrgyAdd, "dela ");
      strOfcBrgyAdd   = replaceOrErase("Del ", strOfcBrgyAdd, "del ");
      strOfcCityAdd   = firstLetterCap(strOfcCityAdd);
      strOfcCityAdd   = replaceOrErase("De La ", strOfcCityAdd, "de la ");
      strOfcCityAdd   = replaceOrErase("De ", strOfcCityAdd, "de ");
      strOfcCityAdd   = replaceOrErase("Dela ", strOfcCityAdd, "dela ");
      strOfcCityAdd   = replaceOrErase("Del ", strOfcCityAdd, "del ");
      strOfcZipCode   = strOfcZipCode.trim();
      strOfcTelArea   = strOfcTelArea.trim();
      strOfcTelNum    = strOfcTelNum.trim();
      strOfcTelLocal  = strOfcTelLocal.trim();
      strOfcFaxArea   = strOfcFaxArea.trim();
      strOfcFaxNum    = strOfcFaxNum.trim();
      strOfcFaxLocal  = strOfcFaxLocal.trim();
      strOfcEmail     = strOfcEmail.toLowerCase();
      strOfcWebsite   = strOfcWebsite.toLowerCase();
      strOfcZipCode   = eraseSubstr("-",strOfcZipCode);
      strOfcTelArea   = dashAndZeroesAway(strOfcTelArea);
      strOfcTelNum    = dashAndZeroesAway(strOfcTelNum);
      strOfcTelLocal  = dashAndZeroesAway(strOfcTelLocal);
      strOfcFaxArea   = dashAndZeroesAway(strOfcFaxArea);
      strOfcFaxNum    = dashAndZeroesAway(strOfcFaxNum);
      strOfcFaxLocal  = dashAndZeroesAway(strOfcFaxLocal);
      strOfcEmail     = strOfcEmail.trim();
      strOfcWebsite   = strOfcWebsite.trim();

      strCP1TelArea    = strCP1TelArea.trim();
      strCP1TelNum     = strCP1TelNum.trim();
      strCP1TelLocal   = strCP1TelLocal.trim();
      strCP2TelArea    = strCP2TelArea.trim();
      strCP2TelNum     = strCP2TelNum.trim();
      strCP2TelLocal   = strCP2TelLocal.trim();
      strCP3TelArea    = strCP3TelArea.trim();
      strCP3TelNum     = strCP3TelNum.trim();
      strCP3TelLocal   = strCP3TelLocal.trim();

      strCP1FName      = firstLetterCap(strCP1FName);
      strCP1LName      = firstLetterCap(strCP1LName);
      strCP1LName      = replaceOrErase("De La ", strCP1LName, "de la ");
      strCP1LName      = replaceOrErase("De ", strCP1LName, "de ");
      strCP1LName      = replaceOrErase("Dela ", strCP1LName, "dela ");
      strCP1LName      = replaceOrErase("Del ", strCP1LName, "del ");
      strCP1Position   = firstLetterCap(strCP1Position);
      strCP1TelArea    = dashAndZeroesAway(strCP1TelArea);
      strCP1TelNum     = dashAndZeroesAway(strCP1TelNum);
      strCP1TelLocal   = dashAndZeroesAway(strCP1TelLocal);
      strCP1EMail      = strCP1EMail.trim();
      strCP1EMail      = strCP1EMail.toLowerCase();
      strCP2FName      = firstLetterCap(strCP2FName);
      strCP2LName      = firstLetterCap(strCP2LName);
      strCP2LName      = replaceOrErase("De La ", strCP2LName, "de la ");
      strCP2LName      = replaceOrErase("De ", strCP2LName, "de ");
      strCP2LName      = replaceOrErase("Dela ", strCP2LName, "dela ");
      strCP2LName      = replaceOrErase("Del ", strCP2LName, "del ");
      strCP2Position   = firstLetterCap(strCP2Position);
      strCP2TelArea    = dashAndZeroesAway(strCP2TelArea);
      strCP2TelNum     = dashAndZeroesAway(strCP2TelNum);
      strCP2TelLocal   = dashAndZeroesAway(strCP2TelLocal);
      strCP2EMail      = strCP2EMail.trim();
      strCP2EMail      = strCP2EMail.toLowerCase();
      strCP3FName      = firstLetterCap(strCP3FName);
      strCP3LName      = firstLetterCap(strCP3LName);
      strCP3LName      = replaceOrErase("De La ", strCP3LName, "de la ");
      strCP3LName      = replaceOrErase("De ", strCP3LName, "de ");
      strCP3LName      = replaceOrErase("Dela ", strCP3LName, "dela ");
      strCP3LName      = replaceOrErase("Del ", strCP3LName, "del ");
      strCP3Position   = firstLetterCap(strCP3Position);
      strCP3TelArea    = dashAndZeroesAway(strCP3TelArea);
      strCP3TelNum     = dashAndZeroesAway(strCP3TelNum);
      strCP3TelLocal   = dashAndZeroesAway(strCP3TelLocal);
      strCP3EMail      = strCP3EMail.trim();
      strCP3EMail      = strCP3EMail.toLowerCase();

      arrAreaCode[0] = strOfcTelArea;
      arrAreaCode[1] = strOfcFaxArea;
      arrAreaCode[2] = strCP1TelArea;
      arrAreaCode[3] = strCP2TelArea;
      arrAreaCode[4] = strCP3TelArea;


      SQLstmt = "SELECT Code FROM tblAreaCodesPh;";
      users.connect(strCodeDB);
      rs = users.listQuery(SQLstmt);
      for (int i=0; i<arrAreaCode.length; i++) {
        if (arrAreaCode[i].equals("")) {
          areaCodeOK = true;
        } else {
          while (rs.next()) {
            strAreaCode = "" + rs.getInt("Code");
            if (arrAreaCode[i].equals(strAreaCode)) {
              areaCodeOK = true;
              rs.beforeFirst();
              break;
            }
            areaCodeOK = false;
          }
          if (areaCodeOK==false) {
            break;
          }
        }
      }
      users.disconnect();

      if  (areaCodeOK==false) {
        withError = true;
      }

      if (strOfcProvAdd.equals("000")) {
        withError = true;
        noProvSelected = true;
      } else if (foundEmptyBox(strOfcStreetAdd)) {
        withError = true;
      } else if (foundEmptyBox(strOfcCityAdd)) {
        withError = true;
      }

      if (foundEmptyBox(strOfcZipCode)) {
        withError = true;
      } else if (foundInvalidDialUpChar(strOfcZipCode)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strOfcTelArea)) {
        withError = true;
      } else if (foundInvalidDialUpChar(strOfcTelArea)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strOfcTelNum)) {
        withError = true;
      } else if (foundInvalidDialUpChar(strOfcTelNum)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strOfcTelLocal)) {
      } else if (foundInvalidDialUpChar(strOfcTelLocal)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strOfcFaxArea)) {
      } else {
        if (foundInvalidDialUpChar(strOfcFaxArea)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strOfcFaxNum)) {
          withError = true;
          incFax = true;
        }
      }
      if (foundEmptyBox(strOfcFaxNum)) {
      } else {
        if (foundInvalidDialUpChar(strOfcFaxNum)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strOfcFaxArea)) {
          withError = true;
          incFax = true;
        }
      }
      if (foundEmptyBox(strOfcFaxLocal)) {
      } else {
        if (foundInvalidDialUpChar(strOfcFaxLocal)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strOfcFaxArea)) {
          withError = true;
          incFax = true;
        }
        if (foundEmptyBox(strOfcFaxNum)) {
          withError = true;
          incFax = true;
        }
      }
      if (foundEmptyBox(strOfcEmail)) {
      } else if (foundInvalidEMail(strOfcEmail)) {
        withError = true;
        invalidEMailAdd = true;
      }
      if (foundEmptyBox(strOfcWebsite)) {
      } else if (foundInvalidSite(strOfcWebsite)) {
        withError = true;
        invalidWebsite = true;
      }

      if (foundEmptyBox(strCP1FName)==false) {
      } else if (foundEmptyBox(strCP1LName)==false) {
      } else if (foundEmptyBox(strCP1Position)==false) {
      } else if (foundEmptyBox(strCP1TelArea)==false) {
      } else if (foundEmptyBox(strCP1TelNum)==false) {
      } else if (foundEmptyBox(strCP1TelLocal)==false) {
      } else if (foundEmptyBox(strCP1EMail)==false) {
      } else {
        cp1NotEmpty = false; // CONTACT PERSON1 HAS NO DETAILS
      }

      if (foundEmptyBox(strCP2FName)==false) {
      } else if (foundEmptyBox(strCP2LName)==false) {
      } else if (foundEmptyBox(strCP2Position)==false) {
      } else if (foundEmptyBox(strCP2TelArea)==false) {
      } else if (foundEmptyBox(strCP2TelNum)==false) {
      } else if (foundEmptyBox(strCP2TelLocal)==false) {
      } else if (foundEmptyBox(strCP2EMail)==false) {
      } else {
        cp2NotEmpty = false; // CONTACT PERSON2 HAS NO DETAILS
      }

      if (foundEmptyBox(strCP3FName)==false) {
      } else if (foundEmptyBox(strCP3LName)==false) {
      } else if (foundEmptyBox(strCP3Position)==false) {
      } else if (foundEmptyBox(strCP3TelArea)==false) {
      } else if (foundEmptyBox(strCP3TelNum)==false) {
      } else if (foundEmptyBox(strCP3TelLocal)==false) {
      } else if (foundEmptyBox(strCP3EMail)==false) {
      } else {
        cp3NotEmpty = false; // CONTACT PERSON2 HAS NO DETAILS
      }

      if (strCpUser==null) {
        if ((cp1NotEmpty==false) && (cp2NotEmpty==false) && (cp3NotEmpty==false)) {
          withError = true;
          noContactPerson = true;
        }
      } else {
        strCheckBox = "checked";
      }

      if (cp1NotEmpty) {
        if (foundEmptyBox(strCP1FName)) {
          withError = true;
          cp1Inc = true;
        } else if (foundEmptyBox(strCP1LName)) {
          withError = true;
          cp1Inc = true;
        } else if (foundEmptyBox(strCP1Position)) {
          withError = true;
          cp1Inc = true;
        }
        if (foundEmptyBox(strCP1TelArea)) {
          withError = true;
          cp1Inc = true;
        } else if (foundInvalidDialUpChar(strCP1TelArea)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP1TelNum)) {
          withError = true;
          cp1Inc = true;
        } else if (foundInvalidDialUpChar(strCP1TelNum)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP1TelLocal)) {
        } else if (foundInvalidDialUpChar(strCP1TelLocal)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP1EMail)) {
        } else if (foundInvalidEMail(strCP1EMail)) {
          withError = true;
          invalidEMailAdd = true;
        }
      }

      if (cp2NotEmpty) {
        if (foundEmptyBox(strCP2FName)) {
          withError = true;
          cp2Inc = true;
        } else if (foundEmptyBox(strCP2LName)) {
          withError = true;
          cp2Inc = true;
        } else if (foundEmptyBox(strCP2Position)) {
          withError = true;
          cp2Inc = true;
        }
        if (foundEmptyBox(strCP2TelArea)) {
          withError = true;
          cp2Inc = true;
        } else if (foundInvalidDialUpChar(strCP2TelArea)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP2TelNum)) {
          withError = true;
          cp2Inc = true;
        } else if (foundInvalidDialUpChar(strCP2TelNum)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP2TelLocal)) {
        } else if (foundInvalidDialUpChar(strCP2TelLocal)) {
           withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP2EMail)) {
        } else if (foundInvalidEMail(strCP2EMail)) {
          withError = true;
          invalidEMailAdd = true;
        }
      }

      if (cp3NotEmpty) {
        if (foundEmptyBox(strCP3FName)) {
          withError = true;
          cp3Inc = true;
        } else if (foundEmptyBox(strCP3LName)) {
          withError = true;
          cp3Inc = true;
        } else if (foundEmptyBox(strCP3Position)) {
          withError = true;
          cp3Inc = true;
        }
        if (foundEmptyBox(strCP3TelArea)) {
          withError = true;
          cp3Inc = true;
        } else if (foundInvalidDialUpChar(strCP3TelArea)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP3TelNum)) {
          withError = true;
          cp3Inc = true;
        } else if (foundInvalidDialUpChar(strCP3TelNum)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP3TelLocal)) {
        } else if (foundInvalidDialUpChar(strCP3TelLocal)) {
          withError = true;
          invalidDialUpChar = true;
        }
        if (foundEmptyBox(strCP3EMail)) {
        } else if (foundInvalidEMail(strCP3EMail)) {
          withError = true;
          invalidEMailAdd = true;
        }
      }
    }

%>

<TABLE WIDTH="750" ALIGN="CENTER" BORDER="0" CELLSPACING="0" CELLPADDING="0">
	<TR>
		<TD WIDTH="160">�</TD>
		<TD WIDTH="268">�</TD>
		<TD WIDTH="121">�</TD>
		<TD WIDTH="182">�</TD>
		<TD WIDTH="19">�</TD>
	</TR>
	<TR VALIGN="CENTER">
		<TD WIDTH="160">
		<IMG SRC="../v3_images/logosub.jpg" BORDER="0" HEIGHT="100" WIDTH="160"><BR>
		</TD>
		<TD COLSPAN="4">

		<TABLE WIDTH="550" CELLPADDING="15" CELLSPACING="0" BORDER="0" ALIGN="center">
			<TR VALIGN="TOP">
				<TD>
				<P CLASS="title">�</P>
				</TD>
			</TR>
		</TABLE>

		</TD>
	</TR><TR>
		<TD COLSPAN="5">
		<IMG SRC="../v3_images/space_hline.jpg" BORDER="0"><BR>
		</TD>
	</TR>
	<TR VALIGN="TOP">
		<TD WIDTH="160">
		�<BR>

		</TD>
		<TD COLSPAN="4">

		<TABLE WIDTH="550" CELLPADDING="15" CELLSPACING="0" BORDER="0" ALIGN="center">
			<TR VALIGN="TOP">
				<TD>
				<% if (withError) { %>
					<P CLASS="main"><B>Log-in Name:</B> <%= strUserLogName %><BR>
					<B>Company:</B> <%= strCompanyName %></P>
					<% if (strFirstTimer.equals("true")) { %>
						<P CLASS="main">For other appropriate information of your company, please fill up the form below.</P>
					<% } else { %>
						<P CLASS="main">INVALID ENTRY/ENTRIES were found in your registration form.<BR>
					<% if (invalidDialUpChar) { %>
						You had entered a non-numeric character on your PHONE/FAX/ZIPCODE number.
						<% } %>
					<% if (incFax) { %>
						FAX should at least have an AREA CODE and it's NUMBER to be valid.
						<% } %>
					<% if (invalidEMailAdd) { %>
						You had entered an invalid or INCOMPLETE e-mail address entry. <I>( Valid samples of e-mail address: juan@skyinet.net and john_smith@hotmail.com )</I>
						<% } %>
					<% if (invalidWebsite) { %>
						Your website entry is not a valid site address. <I>( Samples of valid website: www.productguide.com and http://www.website.net.ph )</I>
						<% } %>
					<% if (areaCodeOK==false) { %>
						An area code entry (or entries) is not a valid Philippine telephone area code.
						<% } %>
					<% if (noContactPerson) { %>
						You have not indicated a contact person.
						<% } %>
					<% if (cp1Inc) { %>
						Your entries on Contact Person 1 is incomplete. <I>( You have left a field/fields with an asterisk (*) in Contact Person 1 empty )</I>
						<% } %>
					<% if (cp2Inc) { %>
						Your entries on Contact Person 2 is incomplete. <I>( You have left a field/fields with an asterisk (*) in Contact Person 2 empty )</I>
						<% } %>
					<% if (cp3Inc) { %>
						Your entries on Contact Person 3 is incomplete. <I>( You have left a field/fields with an asterisk (*) in Contact Person 3 empty )</I>
						<% } %>
					<% if (noProvSelected) { %>
						You have not SELECTED a province.
						<% } %>
					Also, please check if you left a mandatory field/fields (with ** on the label) BLANK or EMPTY.</P>
					<% } %>

					<form name="frmInfo" action="getofc.jsp" method="post">
						<P CLASS="subtitle"><%= strFormTitle %></P>
						<P CLASS="main"><b>Street**:</b> <input type="text" name="St" maxlength="25" size="30" onMouseOver="window.status='Enter street up to 25 characters long.'" onMouseOut="window.status=''" value="<%= strOfcStreetAdd %>"><BR>
						<b>Barangay/District:</b> <input type="text" name="Brgy" maxlength="25" size="30" onMouseOver="window.status='Enter barangay up to 25 characters long.'" onMouseOut="window.status=''" value="<%= strOfcBrgyAdd %>"><BR>
						<b>Municipality/City**:</b> <input type="text" name="City" maxlength="25" size="30"  onMouseOver="window.status='Enter municipality/city up to 25 characters long.'" onMouseOut="window.status=''" value="<%= strOfcCityAdd %>"><BR>
						<b>Province**:</b>
							<select name="Prov" onMouseOver="window.status='Select province from the list'" onMouseOut="window.status=''" onChange="checkCode()">
								<option value="000"> - Please Select One - </option>
								<option value="02Metro Manila">Metro Manila</option>
								<option value="74Abra">Abra</option>
								<option value="85Agusan del Norte">Agusan del Norte</option>
								<option value="85Agusan del Sur">Agusan del Sur</option>
								<option value="36Aklan">Aklan</option>
								<option value="52Albay">Albay</option>
								<option value="36Antique">Antique</option>
								<option value="42Aurora">Aurora</option>
								<option value="62Basilan">Basilan</option>
								<option value="47Bataan">Bataan</option>
								<option value="78Batanes">Batanes</option>
								<option value="43Batangas">Batangas</option>
								<option value="74Benguet">Benguet</option>
								<option value="53Biliran">Biliran</option>
								<option value="38Bohol">Bohol</option>
								<option value="88Bukidnon">Bukidnon</option>
								<option value="44Bulacan">Bulacan</option>
								<option value="78Cagayan">Cagayan</option>
								<option value="54Camarines Norte">Camarines Norte</option>
								<option value="54Camarines Sur">Camarines Sur</option>
								<option value="88Camiguin">Camiguin</option>
								<option value="36Capiz">Capiz</option>
								<option value="52Catanduanes">Catanduanes</option>
								<option value="46Cavite">Cavite</option>
								<option value="32Cebu">Cebu</option>
								<option value="82Davao">Davao</option>
								<option value="84Davao del Norte">Davao del Norte</option>
								<option value="82Davao del Sur">Davao del Sur</option>
								<option value="87Davao Oriental">Davao Oriental</option>
								<option value="55Eastern Samar">Eastern Samar</option>
								<option value="33Guimaras">Guimaras</option>
								<option value="74Ifugao">Ifugao</option>
								<option value="77Ilocos Norte">Ilocos Norte</option>
								<option value="77Ilocos Sur">Ilocos Sur</option>
								<option value="33Iloilo">Iloilo</option>
								<option value="78Isabela">Isabela</option>
								<option value="74Kalinga-Apayao">Kalinga-Apayao</option>
								<option value="72La Union">La Union</option>
								<option value="49Laguna">Laguna</option>
								<option value="63Lanao del Norte">Lanao del Norte</option>
								<option value="63Lanao del Sur">Lanao del Sur</option>
								<option value="53Leyte">Leyte</option>
								<option value="64Maguindanao">Maguindanao</option>
								<option value="42Marinduque">Marinduque</option>
								<option value="56Masbate">Masbate</option>
								<option value="43Mindoro Occidental">Mindoro Occidental</option>
								<option value="43Mindoro Oriental">Mindoro Oriental</option>
								<option value="88Misamis Occidental">Misamis Occidental</option>
								<option value="88Misamis Oriental">Misamis Oriental</option>
								<option value="74Mountain Province">Mountain Province</option>
								<option value="02NCR">NCR</option>
								<option value="34Negros Occidental">Negros Occidental</option>
								<option value="35Negros Oriental">Negros Oriental</option>
								<option value="64North Cotabato">North Cotabato</option>
								<option value="44Nueva Ecija">Nueva Ecija</option>
								<option value="78Nueva Vizcaya">Nueva Vizcaya</option>
								<option value="48Palawan">Palawan</option>
								<option value="45Pampanga">Pampanga</option>
								<option value="75Pangasinan">Pangasinan</option>
								<option value="42Quezon">Quezon</option>
								<option value="78Quirino">Quirino</option>
								<option value="02Rizal">Rizal</option>
								<option value="42Romblon">Romblon</option>
								<option value="83Saranggani">Saranggani</option>
								<option value="35Siquijor">Siquijor</option>
								<option value="56Sorsogon">Sorsogon</option>
								<option value="83South Cotabato">South Cotabato</option>
								<option value="64Sultan Kudarat">Sultan Kudarat</option>
								<option value="86Surigao del Norte">Surigao del Norte</option>
								<option value="86Surigao del Sur">Surigao del Sur</option>
								<option value="45Tarlac">Tarlac</option>
								<option value="55Western Samar">Western Samar</option>
								<option value="47Zambales">Zambales</option>
								<option value="65Zamboanga del Norte">Zamboanga del Norte</option>
								<option value="62Zamboanga del Sur">Zamboanga del Sur</option>
							</select><BR>
						<b>Zip Code**:</b> <input type="text" name="ZCode" maxlength="4" size="4" onMouseOver="window.status='Enter zip code.'" onMouseOut="window.status=''" value="<%= strOfcZipCode %>"></P>

						<P CLASS="subtitle">Contact Numbers</P>
						<P CLASS="main">
						<b><I>Telephone:</I></b><BR>
						 	<b>area code**</b> <input type="text" name="TArea" maxlength="5" size="4"  onMouseOver="window.status='Enter phone\'s area code.'" onMouseOut="window.status=''" onChange="checkCode()" value="<%= strOfcTelArea %>">
							<b>phone number**</b> <input type="text" name="TNum" maxlength="7" size="7" onMouseOver="window.status='Enter phone number.'" onMouseOut="window.status=''" value="<%= strOfcTelNum %>">
							<b>local number</b> <input type="text" name="TLoc" maxlength="5" size="4" onMouseOver="window.status='Enter phone\'s local number.'" onMouseOut="window.status=''" value="<%= strOfcTelLocal %>"><BR>
						<b><I>Facsimile:</I></b><BR>
							<b>area code</b> <input type="text" name="FArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code for fax.'" onMouseOut="window.status=''" value="<%= strOfcFaxArea %>">
							<b>fax number</b> <input type="text" name="FNum" maxlength="7" size="7" onMouseOver="window.status='Enter fax number.'" onMouseOut="window.status=''" value="<%= strOfcFaxNum %>">
							<b>fax local</b> <input type="text" name="FLoc" maxlength="5" size="4" onMouseOver="window.status='Enter local number if any.'" onMouseOut="window.status=''" value="<%= strOfcFaxLocal %>"><BR>
						<b>Company email address:</b> <input type="text" name="EMail" maxlength="30" size="36" onMouseOver="window.status='Enter sales ofc e-mail address.'" onMouseOut="window.status=''" value="<%= strOfcEmail %>"><BR>
						<b>Company website:</b> <input type="text" name="WSite" maxlength="30" size="36" onMouseOver="window.status='Enter sales ofc website address if any.'" onMouseOut="window.status=''" value="<%= strOfcWebsite %>"></P>

						<P CLASS="subtitle">Contact Numbers<BR>
						<I>(Please supply complete information to at least one contact person.)</i></P>
						<P CLASS="main"><input type="checkbox" name="cpUsr" value="Yes" <%= strCheckBox %>> Check this box if you are one of the main contact persons for <%= strPageTitle %>.</P>

						<P CLASS="main"><b>Contact Person 1:</b><BR>
						<b>First name*: </b> <input type="text" name="cp1FN" maxlength="20" size="24" onMouseOver="window.status='Enter first name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP1FName %>"><BR>
						<b>Last name*: </b> <input type="text" name="cp1LN" maxlength="20" size="24"  onMouseOver="window.status='Enter last name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP1LName %>"><BR>
						<b>Position*: </b> <input type="text" name="cp1Pos" maxlength="30" size="36"  onMouseOver="window.status='Enter position in the company up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP1Position %>"><BR>
						<b><I>Telephone:</I></b><BR>
							<b>area code* </b> <input type="text" name="cp1TArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code of phone number.'" onMouseOut="window.status=''" value="<%= strCP1TelArea %>">
							<b>phone number* </b> <input type="text" name="cp1TNum" maxlength="7" size="7" onMouseOver="window.status='Enter phone number.'" onMouseOut="window.status=''" value="<%= strCP1TelNum %>">
							<b>local number </b> <input type="text" name="cp1TLoc" maxlength="5" size="4" onMouseOver="window.status='Enter phone\'s local number.'" onMouseOut="window.status=''" value="<%= strCP1TelLocal %>"><BR>
						<b>e-mail address: </b> <input type="text" name="cp1EMail" maxlength="30" size="36" onMouseOver="window.status='Enter e-mail address up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP1EMail %>"></P>
						<P CLASS="main"><b>Contact Person 2:</b><BR>
						<b>First name*: </b> First name*: </b> <input type="text" name="cp2FN" maxlength="20" size="24" onMouseOver="window.status='Enter first name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP2FName %>"><BR>
						<b>Last name*: </b> <input type="text" name="cp2LN" maxlength="20" size="24" onMouseOver="window.status='Enter last name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP2LName %>"><BR>
						<b>Position*: </b> <input type="text" name="cp2Pos" maxlength="30" size="36" onMouseOver="window.status='Enter position in the company up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP2Position %>"><BR>
						<b><I>Telephone:</I></b><BR>
							<b>area code* </b> <input type="text" name="cp2TArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code of phone number.'" onMouseOut="window.status=''" value="<%= strCP2TelArea %>">
							<b>phone number* </b> <input type="text" name="cp2TNum" maxlength="7" size="7" onMouseOver="window.status='Enter phone number.'" onMouseOut="window.status=''" value="<%= strCP2TelNum %>">
							<b>local number </b> <input type="text" name="cp2TLoc" maxlength="5" size="4" onMouseOver="window.status='Enter phone\'s local number.'" onMouseOut="window.status=''" value="<%= strCP2TelLocal %>"><BR>
						<b>e-mail address: </b> <input type="text" name="cp2EMail" maxlength="30" size="36" onMouseOver="window.status='Enter e-mail address up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP2EMail %>"></P>
						<P CLASS="main"><b>Contact Person 3:</b><BR>
						<b>First name*: </b> First name*: </b> <input type="text" name="cp3FN" maxlength="20" size="24" onMouseOver="window.status='Enter first name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP3FName %>"><BR>
						<b>Last name*: </b> <input type="text" name="cp3LN" maxlength="20" size="24" onMouseOver="window.status='Enter last name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strCP3LName %>"><BR>
						<b>Position*: </b> <input type="text" name="cp3Pos" maxlength="30" size="36" onMouseOver="window.status='Enter position in the company up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP3Position %>"><BR>
						<b><I>Telephone:</I></b><BR>
							<b>area code* </b> <input type="text" name="cp3TArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code of phone number.'" onMouseOut="window.status=''" value="<%= strCP3TelArea %>">
							<b>phone number* </b> <input type="text" name="cp3TNum" maxlength="7" size="7" onMouseOver="window.status='Enter phone number.'" onMouseOut="window.status=''" value="<%= strCP3TelNum %>">
							<b>local number </b> <input type="text" name="cp3TLoc" maxlength="5" size="4" onMouseOver="window.status='Enter phone\'s local number.'" onMouseOut="window.status=''" value="<%= strCP3TelLocal %>"><BR>
						<b>e-mail address: </b> <input type="text" name="cp3EMail" maxlength="30" size="36" onMouseOver="window.status='Enter e-mail address up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strCP3EMail %>"></P>

						
						<input type="hidden" name="usrLog" value="<%= strUserLogName %>">
						<input type="hidden" name="CoName" value="<%= strCompanyName %>">
						<input type="hidden" name="CoID" value="<%= intCompanyID %>">
						<input type="hidden" name="btnID" value="<%= bytButtonID %>">
						<input type="hidden" name="usr1st" value="false">
						<input type="hidden" name="repeat" value="Yes">
						<P CLASS="main">
						<input type="submit" name="btnOk" value="   Ok   " >
						<input type="button" name="btnCncl" value="Cancel" onClick="cancelForm()">
						</P>
					</form>
					<% } else { %>
					<%
						byte cpctr = 0;
						if (bytButtonID == 1) {
							bytButtonID = 10;
							}
						users.connect(strTempDB);
						if (cp1NotEmpty) {
							cpctr++;
							SQLstmt = "INSERT INTO tblContactPersons VALUES (" + intCompanyID + ", " + bytButtonID + ", '" + strCP1FName + "', '" + strCP1LName + "', '" + strCP1Position + "', '" + strCP1TelArea + "', '" + strCP1TelNum + "', '" + strCP1TelLocal + "', '" + strCP1EMail + "', " + cpctr + ");";
							users.updateData(SQLstmt);
							}
						if (cp2NotEmpty) {
							cpctr++;
							SQLstmt = "INSERT INTO tblContactPersons VALUES (" + intCompanyID + ", " + bytButtonID + ", '" + strCP2FName + "', '" + strCP2LName + "', '" + strCP2Position + "', '" + strCP2TelArea + "', '" + strCP2TelNum + "', '" + strCP2TelLocal + "', '" + strCP2EMail + "', " + cpctr + ");";
							users.updateData(SQLstmt);
							}
						if (cp3NotEmpty) {
							cpctr++;
							SQLstmt = "INSERT INTO tblContactPersons VALUES (" + intCompanyID + ", " + bytButtonID + ", '" + strCP3FName + "', '" + strCP3LName + "', '" + strCP3Position + "', '" + strCP3TelArea + "', '" + strCP3TelNum + "', '" + strCP3TelLocal + "', '" + strCP3EMail + "', " + cpctr + ");";
							users.updateData(SQLstmt);
							}
						byte cpuser = 0;
						if (strCheckBox.equals("checked")) {
							cpuser = 1;
							}
						SQLstmt = "INSERT INTO tblCPIndicator VALUES (" + intCompanyID + ", " + bytButtonID + ", " + cpuser + ", " + cpctr + ");";
						users.updateData(SQLstmt);
						SQLstmt = "UPDATE tblCoInfoIndicator SET " + strFieldName + " = 1 WHERE Co_ID = " + intCompanyID + ";";
						users.updateData(SQLstmt);
						byte bytStatus = 1;
						users.addCoEtcInfo(strTblName, intCompanyID, strOfcStreetAdd, strOfcBrgyAdd, strOfcCityAdd, strProvAdd, strOfcZipCode, strOfcTelArea, strOfcTelNum, strOfcTelLocal, strOfcFaxArea, strOfcFaxNum, strOfcFaxLocal, strOfcEmail ,strOfcWebsite, bytStatus);
						users.disconnect();
					%>
					<jsp:forward page="accessTen.jsp">
						<jsp:param name="usrLog" value="<%= strUserLogName %>"/>
						<jsp:param name="CoID"   value="<%= intCompanyID %>"/>
						<jsp:param name="CoName" value="<%= strCompanyName %>"/>
					</jsp:forward>
				 <% } %></P>

				</TD>
			</TR>
		</TABLE>

		</TD>
	</TR>
	<TR VALIGN="TOP">
		<TD COLSPAN="2">
		�
		</TD>
		<TD COLSPAN="3">
		<P CLASS="copy">Copyright � 2001-2003 by Grafikoncepts and Designs, Inc.<BR>
		A joint project of Grafikoncepts and Designs, Inc. and Digital Management and Solutions, Inc.<BR>
		Layout by MVMG (VPIT), Digital Management and Solutions, Inc.</P>
		</TD>
	</TR>
</TABLE>

</BODY>
</HTML>