<%@ 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 validity but also 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 (@) 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;
    }
%>

<%
    /**** VARIABLE DECLARATION and INITIALIZATION *****/
    boolean invalidDialUpChar = false, invalidEMailAdd = false;
    boolean areaCodeOK = false, incFax = false, withError = false;
    boolean noSType = false;
    byte bytMultiStatus = 0, bytStatus = 0;
    int intUserID = 0;
    String strAreaCode = "";
    String[] arrAreaCode = new String[2];
    String strTempDB = "product_tmpClientInfoDB";

    String strUserLogName  = request.getParameter("userLogName");
    int intSType           = Integer.parseInt(request.getParameter("stype"));
    String strUserFName    = request.getParameter("userFirstName");
    String strUserLName    = request.getParameter("userLastName");
    String strUserTelArea  = request.getParameter("userTelArea");
    String strUserTelNum   = request.getParameter("userTelNum");
    String strUserTelLocal = request.getParameter("userTelLocal");
    String strUserFaxArea  = request.getParameter("userFaxArea");
    String strUserFaxNum   = request.getParameter("userFaxNum");
    String strUserFaxLocal = request.getParameter("userFaxLocal");
    String strUserEMail    = request.getParameter("userEMail");
    String strCompanyName  = request.getParameter("userCoName");
    String strUserPosition = request.getParameter("userPosition");
    String strFirstTimer   = request.getParameter("userFirstTime");

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

    strUserFName = strUserFName.trim();
    strUserLName = strUserLName.trim();
    strUserTelArea = strUserTelArea.trim();
    strUserTelNum = strUserTelNum.trim();
    strUserTelLocal = strUserTelLocal.trim();
    strUserFaxArea = strUserFaxArea.trim();
    strUserFaxNum = strUserFaxNum.trim();
    strUserFaxLocal = strUserFaxLocal.trim();
    strUserEMail = strUserEMail.trim();
    strCompanyName = strCompanyName.trim();
    strUserPosition = strUserPosition.trim();

    strUserFName = firstLetterCap(strUserFName);
    strUserLName = firstLetterCap(strUserLName);
    strUserLName = replaceOrErase("De La ", strUserLName, "de la ");
    strUserLName = replaceOrErase("De ", strUserLName, "de ");
    strUserLName = replaceOrErase("Dela ", strUserLName, "dela ");
    strUserLName = replaceOrErase("Del ", strUserLName, "del ");
    strUserPosition = firstLetterCap(strUserPosition);
    strCompanyName = strCompanyName.toUpperCase();
    strUserEMail = strUserEMail.toLowerCase();
    strUserTelArea = dashAndZeroesAway(strUserTelArea);
    strUserTelNum = dashAndZeroesAway(strUserTelNum);
    strUserTelLocal = dashAndZeroesAway(strUserTelLocal);
    strUserFaxArea = dashAndZeroesAway(strUserFaxArea);
    strUserFaxNum = dashAndZeroesAway(strUserFaxNum);
    strUserFaxLocal = dashAndZeroesAway(strUserFaxLocal);

    arrAreaCode[0] = strUserTelArea;
    arrAreaCode[1] = strUserFaxArea;
    String SQLstmt = "SELECT Code FROM tblAreaCodesPh;";
    users.connect("product_areaCodesPhDB");
    ResultSet 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 (intSType==0) {
      withError = true;
      noSType = true;
    }
    if (foundEmptyBox(strUserFName)) {
      withError = true;
    } else if (foundEmptyBox(strUserLName)) {
      withError = true;
    } else if (foundEmptyBox(strCompanyName)) {
      withError = true;
    } else if (foundEmptyBox(strUserPosition)) {
      withError = true;
    }

    if (foundEmptyBox(strUserTelArea)) {
      withError = true;
    } else if (foundInvalidDialUpChar(strUserTelArea)) {
      withError = true;
      invalidDialUpChar = true;
    }
    if (foundEmptyBox(strUserTelNum)) {
      withError = true;
    } else if (foundInvalidDialUpChar(strUserTelNum)) {
      withError = true;
      invalidDialUpChar = true;
    }
    if (foundEmptyBox(strUserTelLocal)) {
    } else if (foundInvalidDialUpChar(strUserTelLocal)) {
      withError = true;
      invalidDialUpChar = true;
    }
    if (foundEmptyBox(strUserFaxArea)) {
    } else {
      if (foundInvalidDialUpChar(strUserFaxArea)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strUserFaxNum)) {
        withError = true;
        incFax = true;
      }
    }
    if (foundEmptyBox(strUserFaxNum)) {
    } else {
      if (foundInvalidDialUpChar(strUserFaxNum)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strUserFaxArea)) {
        withError = true;
        incFax = true;
      }
    }
    if (foundEmptyBox(strUserFaxLocal)) {
    } else {
      if (foundInvalidDialUpChar(strUserFaxLocal)) {
        withError = true;
        invalidDialUpChar = true;
      }
      if (foundEmptyBox(strUserFaxArea)) {
        withError = true;
        incFax = true;
      }
      if (foundEmptyBox(strUserFaxNum)) {
        withError = true;
        incFax = true;
      }
    }

    if (foundEmptyBox(strUserEMail)) {
      withError = true;
    } else if (foundInvalidEMail(strUserEMail)) {
      withError = true;
      invalidEMailAdd = true;
    }
 %>

<html>
<head><title> User Information </title></head>
<script language="javascript">
<!--
function selectSType() {
  for (var i=0; i<formNewUserInfo.stype.length; i++) {
    if (formNewUserInfo.stype.options[i].value == <%= intSType %>) {
      formNewUserInfo.stype.options[i].selected = true;
      break;
    }
  }
  history.go(1);
  formNewUserInfo.stype.focus();
}
-->
</script>
<body>


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

<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">User Registration</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) { %>
				<% if (strFirstTimer.equals("true")) { %>

					<P CLASS="main">Welcome <B><%= strUserLogName %>!</B><BR>
					Please fill up  the following:</p>
					<% } else { %>
					<P CLASS="main">INVALID ENTRY/ENTRIES were found in your registration form.<BR>
						<% if (noSType) { %>
							You had not selected a SUBSCRIPTION type.
							<% } %>
						<% if (invalidDialUpChar) { %>
							You had entered a non-numeric character on your PHONE/FAX 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. <I>( Valid samples of e-mail address: juan@skyinet.net john_smith@hotmail.com )</I>
							<% } %>
						<% if (areaCodeOK==false) { %>
							An area code entry (or entries) is not a valid Philippine telephone area code.
							<% } %>
						Also, please check if you left a mandatory field/fields (with ** on the label) BLANK or EMPTY.</P>
					<% } %>
				<form name="formNewUserInfo" action="processUserInfo.jsp" method="post">
					<P CLASS="main">
					<b>Subscription Type**: </b>
						<select name="stype" onMouseOver="window.status='Select type of subscription'" onMouseOut="window.status=''" >
							<option value="0"> - Please Select One - </option>
							<option value="1">Expanded Listing</option>
							<option value="2">Basic Listing</option>
						</select>
					</P>
					<P CLASS="main">
						<b>First name**: </b> <input type="text" name="userFirstName" maxlength="25" size="24" onMouseOver="window.status='Enter your first name up to 25 characters long.'" onMouseOut="window.status=''" value="<%= strUserFName %>"><BR>
						<b>Last name**: </b> <input type="text" name="userLastName" maxlength="20" size="24" onMouseOver="window.status='Enter your last name up to 20 characters long.'" onMouseOut="window.status=''" value="<%= strUserLName %>"><BR>
						<b>Position**: </b> <input type="text" name="userPosition" maxlength="30" size="36" onMouseOver="window.status='Enter your current position in your company up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strUserPosition %>"><BR>
						<b>Company name**: </b> <input type="text" name="userCoName" maxlength="50" size="60" onMouseOver="window.status='Enter your company name up to 50 characters long.'" onMouseOut="window.status=''" value="<%= strCompanyName %>"><BR>
					</P>
					<P CLASS="subtitle">Contact Information:</P>
					<P CLASS="main"><b><I>Telephone:</I></b><BR>
						<b>area code** </b> <input type="text" name="userTelArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code of your phone number.'" onMouseOut="window.status=''" value="<%= strUserTelArea %>">
						<b>phone number** </b> <input type="text" name="userTelNum" maxlength="7" size="7"  onMouseOver="window.status='Enter your phone number.'"  onMouseOut="window.status=''" value="<%= strUserTelNum %>">
						<b>local number </b> <input type="text" name="userTelLocal" maxlength="5" size="4" onMouseOver="window.status='Enter your phone\'s local number.'" onMouseOut="window.status=''" value="<%= strUserTelLocal %>"><BR>
					<b><I>Facsimile:</I></b><BR>
						<b>area code </b> <input type="text" name="userFaxArea" maxlength="5" size="4" onMouseOver="window.status='Enter area code of your fax number.'" onMouseOut="window.status=''" value="<%= strUserFaxArea %>">
						<b>fax number </b> <input type="text" name="userFaxNum" maxlength="7" size="7" onMouseOver="window.status='Enter your fax number.'" onMouseOut="window.status=''" value="<%= strUserFaxNum %>">
						<b>local number </b> <input type="text" name="userFaxLocal" maxlength="5" size="4" onMouseOver="window.status='Enter your fax\'s local number.'" onMouseOut="window.status=''" value="<%= strUserFaxLocal %>"><BR>
					<b>e-mail address**: </b> <input type="text" name="userEMail" maxlength="30" size="36" onMouseOver="window.status='Enter your e-mail address up to 30 characters long.'" onMouseOut="window.status=''" value="<%= strUserEMail %>">
					</P>

					<input type="hidden" name="userLogName" value="<%= strUserLogName %>">
					<input type="hidden" name="userFirstTime" value="false">
					<P CLASS="main">
						<input name="btnOk" type="submit" value="   Ok   ">
					</P>
				</form>
				<%
				} else {
					SQLstmt = "SELECT Pwd_ID, ApplicLvlStatus FROM tblUserPwd WHERE Usr_LogName=\"" + strUserLogName + "\";";
					users.connect(strTempDB);
					rs = users.listQuery(SQLstmt);
					while (rs.next()) {
						intUserID = rs.getInt("Pwd_ID");
						bytStatus = rs.getByte("ApplicLvlStatus");
						}

					if (bytStatus >= 2) {
						users.disconnect();
					%>
					<jsp:forward page="submitError.jsp" >
						<jsp:param name="whatDB"       value="tempDB"/>
						<jsp:param name="userLogName"  value="<%= strUserLogName %>"/>
					</jsp:forward>

					<%
					} else {
						users.addUserInfo(intUserID, strUserFName, strUserLName, strUserTelArea, strUserTelNum, strUserTelLocal, strUserFaxArea, strUserFaxNum, strUserFaxLocal, strUserEMail, bytMultiStatus);
						SQLstmt = "UPDATE tblUserPwd SET ApplicLvlStatus=2 WHERE Usr_LogName=\"" + strUserLogName + "\";";
						users.updateData(SQLstmt);
						users.disconnect();
					%>

					<jsp:forward page="processCoConflict.jsp">
						<jsp:param name="whatDB"       value="tempDB"/>
						<jsp:param name="userLogName"  value="<%= strUserLogName %>"/>
						<jsp:param name="stype"        value="<%= intSType %>"/>
						<jsp:param name="userCoName"   value="<%= strCompanyName %>"/>
						<jsp:param name="userPosition" value="<%= strUserPosition %>"/>
					</jsp:forward>
					<% } %>
				<% } %>

				</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>