<?

if($_POST['submit'])
	{
		$studNo = $_POST["stud_no"];
		$fname = $_POST["fname"];
		$mname = $_POST["mname"];
		$lname = $_POST["lname"];
			$mon = $_POST["mon"];
			$day = $_POST["day"];
			$yrs = $_POST["yr"];
		$bday = $mon."-".$day."-".$yrs;
		$age = $_POST["ages"];
		$year = $_POST["year"];
		$active = $_POST["active"];
		$course = $_POST["course"];
		$scho = $_POST["scho"];

		$username = $_POST["username"];
		$password = md5($_POST["password"]);
		$utype = $_POST["u_type"];

		$addStud = mysql_query("INSERT INTO student_info (student_id, student_firstname, student_middlename, student_lastname, student_bday, student_age, student_year, student_active, course_code, student_scholar) VALUES ('$studNo', '$fname', '$mname', '$lname', '$bday', '$age', '$_POST[studentyear]', '$active', '$course', '$scho')");

		$addUser = mysql_query("INSERT INTO users (user_username, user_password, student_id, user_type, user_login, user_logs) VALUES ('$username', '$password', $studNo, '$utype', '00-00-0000 00:00:00', '0')");

		if(($addStud) && ($addUser))
		{
			$_SESSION['success_msg'] = "User Record was successfully added in the database!";
			echo "<META http-equiv='refresh' content='0;URL=index.php?mod=user&add=success'>";
			echo "<div id='success_message'>Please wait while updating database...</div>";

			$cUser = $_SESSION["username"];

			$msg = $cUser." has added a record in Users Collection";
			$stat = mysql_query("INSERT INTO table_updates(update_event) VALUES ('$msg')");

		}
		else
		{
			$_SESSION['error_msg'] = "User Record was not successfully added in the database!".mysql_error();
			echo "<META http-equiv='refresh' content='0;URL=index.php?mod=user&add=failed'>";
			echo "<div id='success_message'>Please wait while updating database...</div>";
		}


	}

?>

<script type="text/javascript">

function val()
	{
		var err = "";
		var ctr = 0;
		var sID = document.getElementById("stud_no").value;
		var lname = document.getElementById("lname").value;
		var mname = document.getElementById("mname").value;
		var fname = document.getElementById("fname").value;


		if(lname==" ") {
			err += "No spaces pls\n";
			ctr++;

		}

			if(fname==" ") {
			err += "No spaces pls\n";
			ctr++;
		}

			if(mname==" ") {
			err += "No spaces pls\n";
			ctr++;
		}


		if(isNaN(sID))
		{
			err += "Please enter integer for User Number!\n";
			ctr++;
		}

		if(!isNaN(lname))
		{
			err += "Please enter only alphabet for the Lastname!\n";
			ctr++;
		}

		if(!isNaN(mname))
		{
			err += "Please enter only alphabet for the Middlename!\n";
			ctr++;
		}

		if(!isNaN(fname))
		{
			err += "Please enter only alphabet for the Firstname!\n";
			ctr++;
		}



		if(ctr > 0)
		{
			alert(err);

		}

		else {
		document.holycow.submit();

		}

	}

</script>




<script src="contents/control_panel/SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<link href="contents/control_panel/SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<script src="contents/control_panel/SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<script src="contents/control_panel/SpryAssets/SpryValidationPassword.js" type="text/javascript"></script>
<script src="contents/control_panel/SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
<link href="contents/control_panel/SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
<link href="contents/control_panel/SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css" />
<link href="contents/control_panel/SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" />
<p id="headings">USER MANAGER</p>

<form id="form1s" name="holycow" method="post" action="">
<table width="60%" border="0" align="center" cellspacing="3">
  <tr>
    <td width="20%" align="right"><strong>User Number:</strong></td>
    <td width="80%"><span id="sprytextfield1">
      <input name="stud_no" type="text" id="stud_no" maxlength="9" />
      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>First Name:</strong></td>
    <td><span id="sprytextfield2">
      <input type="text" name="fname" id="fname" style="width: 60%" />
      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Middle Name:</strong></td>
    <td><span id="sprytextfield3">
      <input name="mname" type="text" id="mname" style="width: 60%" />
      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Last Name:</strong></td>
    <td><span id="sprytextfield5">
      <input type="text" name="lname" id="lname" style="width: 60%" />
      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Birthday:</strong></td>
    <td><span id="spryselect1">
      </span>
      <span id="spryselect3">
      <select name="mon" id="mon">
        <option value="">Month</option>
        <?
	  		for($ctr=1; $ctr<=12; $ctr++)
			{
				if($ctr<=9) { $ctr = "0".$ctr; }
				echo "<option value='$ctr'>$ctr</option>";
			}
	  ?>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span> -
      <span id="spryselect4">
      <select name="day" id="day">
        <option value="" >Day</option>
        <?
	  		for($ctr=1; $ctr<=31; $ctr++)
			{
				if($ctr<=9) { $ctr = "0".$ctr; }
				echo "<option value='$ctr'>$ctr</option>";
			}
	  ?>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span> -
      <span id="spryselect5">
      <select name="yr" id="year" onchange="yeahba();">
        <option value="">Year</option>
        <?
	  		for($ctr=1980; $ctr<=2006; $ctr++) { echo "<option value='$ctr'>$ctr</option>"; }
	  ?>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span> FORMAT: MM-DD-YYYY</td>
  </tr>
  <tr>
    <td align="right"><strong>Age:</strong></td>
    <td><span id="sprytextfield4">
      <input name="ages" type="text" id="age" readonly />

      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>

  <script type="text/javascript">
  function yeahba() {


var x = document.form1.yr.selectedIndex;
var y =document.form1.yr.options[x].value;
  //var x =2010;
  //var y= form1.yr.selectedindex.value;

  //alert (y);
  //alert("tae");
  document.getElementById("age").value = 2010 -  y;
  //alert(form1.yr.selectedindex.value);
  }
  </script>
  <!-- <tr>
    <td align="right"><strong>Year:</strong></td>
    <td><span id="spryselect2">
      <select name="year" id="year" style="width:150px">
        <option value="" >Please select an item</option>
        <option value="1">First Year</option>
        <option value="2">Second Year</option>
        <option value="3">Third Year</option>
        <option value="4">Fourth Year</option>
        <option value="5">TERMINAL</option>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span></td>
  </tr>
  -->
  <tr>
    <td align="right"><strong>Status:</strong></td>
    <td><span id="spryselect6">
      <select name="active" id="active" style="width:150px">
        <option value="" >Status</option>
        <option value="1">Active</option>
        <option value="0">Inactive</option>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Course:</strong></td>
    <td><span id="spryselect7">
      <select name="course" id="course" style="width: 60%">
        <option value="">Select Course</option>
        <?

	$openCourses = mysql_query("SELECT * from course_collection");
	while($row = mysql_fetch_array($openCourses))
	{
		$itemCode = $row["course_code"];
		$itemDesc = $row["course_desc"];
		$itemActive = $row["course_active"];

		if($itemActive == 1)
		echo "<option value='$itemCode'>$itemDesc</option>";
	}

	$openUsers = mysql_query("SELECT * from users WHERE student_id = '$get_user'");
	$row = mysql_fetch_array($openUsers);

	$username = $row["user_username"];
	$password = $row["user_password"];
	$utype = $row["user_type"];
	$u = $utype;
		if($u == 1) { $u = "Administrator"; }
		else if($u == 2) { $u = "Faculty"; }
		else if($u == 3) { $u = "Student"; }
	$ulogs = $row["user_logs"];
		if($ulogs == 1) { $ulogs = "ONLINE"; }
		else { $ulogs = "OFFLINE"; }
	$last = $row["user_login"];

	?>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Scholarship:</strong></td>
    <td><select name="scho" id="scho">
    	<option value="0" selected="selected">None</option>
        <option value="50">50% Scholarship Grant</option>
        <option value="75">75% Scholarship Grant</option>
        <option value="100">100% Scholarship Grant</option>
    </select></td>
  </tr>

    <tr>
    <td align="right"><strong>Student year:</strong></td>
    <td><select name="studentyear" id="schos">

        <option value="first">First</option>
        <option value="second">Second</option>
        <option value="third">Third</option>
		<option value="fourth">Fourth</option>
		<option value="fifth">Fifth</option>
    </select></td>
  </tr>


    <tr>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="right"><strong>Username:</strong></td>
    <td><span id="sprytextfield6">
      <input name="username" type="text" id="username" style="width: 60%" />
      <span class="textfieldRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>New Password:</strong></td>
    <td><span id="sprypassword1">
      <input name="password" type="password" id="password1" style="width: 60%" value="" />
      <span class="passwordRequiredMsg">&nbsp;A value is required.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>Confirm Password:</strong></td>
    <td><span id="spryconfirm1">
      <input name="password2" type="password" id="password2" style="width: 60%" value="" />
      <span class="confirmRequiredMsg">A value is required.</span><span class="confirmInvalidMsg">&nbsp;The values don't match.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right"><strong>User Type:</strong></td>
    <td><span id="spryselect8">
      <select name="u_type" id="u_type" style="width: 60%">
        <option value="">Select User Type</option>
        ";


        <option value="1">Administrator</option>
        <option value="2">Faculty</option>
        <option value="3">Student</option>
      </select>
      <span class="selectRequiredMsg">&nbsp;Please select an item.&nbsp;</span></span></td>
  </tr>
  <tr>
    <td align="right">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="right">&nbsp;</td>
    <td align="left">
	<input type="submit" name="submitt" id="submit" value="SUBMIT" onclick='val();' />
      <a href="index.php?mod=user"><input type="button" name="button2" id="button2" value="CANCEL" /></a></td>
  </tr>
</table>
</form>
<p>&nbsp;</p>










<? mysql_close(); ?>