<?
	$req_login=false;
	include "framework.php";
	
	
	if($h_action=="login")
	{
		$mobile=addslashes(trim($_REQUEST['mobile'])); //echo $mobile.'**** ';
		$dob=$_REQUEST['dob'];
		$a1=explode("/",$dob);
		$dob_ts=strtotime($a1[1]."/".$a1[0]."/".$a1[2]." 10:00:00");
		
		$aid=0;
		$full_name=$email=""; $dup_counter=0;
		//echo "<!-- select id,full_name,email,mobile_num from a_applications where (mobile_num='".$mobile."' or id in(select application_id from a_applications_hs where roll_num='".$mobile."')) and dob=".$dob_ts." and id in(select application_id from b_merit_lists_entries where list_id>=72 and current_status=5) -->";
		//$query_result = mysqli_query($connection,"select id,full_name,email,mobile_num from a_applications where (mobile_num='".$mobile."' or id in(select application_id from a_applications_hs where roll_num='".$mobile."')) and dob=".$dob_ts." and id in(select application_id from b_merit_lists_entries where list_id>=97 and current_status=5)");
		$query_result = mysqli_query($connection,"select id,full_name,email,mobile_num from a_applications where (mobile_num='".$mobile."' or id in(select application_id from a_applications_hs where roll_num='".$mobile."')) and dob=".$dob_ts);
		while($qdata = mysqli_fetch_array($query_result))
		{
			$aid=$qdata['id'];
			$full_name=stripslashes($qdata['full_name']);
			$email=stripslashes($qdata['email']);
			$mobile=stripslashes($qdata['mobile_num']);
			$dup_counter++;
		}
		
		/*$sql_ck_board=mysqli_fetch_array(mysqli_query($connection,"select council_id from a_applications_hs where application_id='$aid'"));
		$council_id=$sql_ck_board['council_id'];
		if($council_id==1){
			$aid=0;
			
		}*/
		
		if($aid<=0)
		{
			$error_msg="Sorry. Invalid credentials or you do not have permission to log in.";
		}
		else
		{
			$otp_req=false;
			$new_otp="AAABBB";

			if($dup_counter<=1)
			{
				$cur_applicant['id']=$aid;
				$cur_applicant['name']=stripslashes($full_name);
				$cur_applicant['email']=stripslashes($email);
				$cur_applicant['phone']=stripslashes($mobile_num);
				
				$mem_key=md5($aid.$mobile.$email.$now.$_SERVER['REMOTE_ADDR']);
				$ip_key=md5($_SERVER['REMOTE_ADDR']);
				setcookie($mem_key, $ip_key, time() + (86400 * 30), "/");
				mysqli_query($connection,"insert into x_applicants_login_keys values(null,$aid,$now,'$mem_key','$ip_key')");
				$new_key_id=mysqli_insert_id($connection);
				$otp_matched=1;
				
				mysqli_query($connection,"insert into x_applicants_login_otps set key_id=$new_key_id,otp='$new_otp',is_matched=$otp_matched");
				
				//header("Location: dashboard_merit_position.php?mk=".$mem_key);
				header("Location: apply_page_3_status.php?mk=".$mem_key);
			}
			else
			{
				$sep="!@!(@)!@!";
				$key_list="";

				//$query_result = mysqli_query($connection,"select id,full_name,email,mobile_num from a_applications where (mobile_num='".$mobile."' or id in(select application_id from a_applications_hs where roll_num='".$mobile."')) and dob=".$dob_ts." and id in(select application_id from b_merit_lists_entries where list_id>=72 and current_status=5)");
				$query_result = mysqli_query($connection,"select id,full_name,email,mobile_num from a_applications where (mobile_num='".$mobile."' or id in(select application_id from a_applications_hs where roll_num='".$mobile."')) and dob=".$dob_ts);
				while($qdata = mysqli_fetch_array($query_result))
				{
					$aid=$qdata['id'];
					$full_name=stripslashes($qdata['full_name']);
					$email=stripslashes($qdata['email']);
					$mobile=stripslashes($qdata['mobile_num']);					
								
					$mem_key=md5($aid.$mobile.$email.$now.$_SERVER['REMOTE_ADDR']);
					$ip_key=md5($_SERVER['REMOTE_ADDR']);
					setcookie($mem_key, $ip_key, time() + (86400 * 30), "/");
					mysqli_query($connection,"insert into x_applicants_login_keys values(null,$aid,$now,'$mem_key','$ip_key')");
					$new_key_id=mysqli_insert_id($connection);
					
						
					$otp_matched=1;
					mysqli_query($connection,"insert into x_applicants_login_otps set key_id=$new_key_id,otp='$new_otp',is_matched=$otp_matched");
					
					if($key_list!=""){$key_list.=$sep;}
					$key_list.=$mem_key;
					
				}
				
				header("Location: decider.php?kl=".$key_list);
			}
		}
	}
	
	$red_star="<span style='color:blue;'>*</span>";
	$apply_active="active";
?>
<!DOCTYPE html>
<html class="no-js" lang="en">
<head>
<title>Online College Management System - </title>
<? include "css_js.php";?>

<style>
.error{border:1px solid red; background-color:#f8bcbc; color:white;}
.error2{color:red;}
</style>

<script>
	function check_form()
	{
		var err_list="";
		$(".error").removeClass("error");
		$("#inline_error").html("");
		
		if($("#mobile").val()=="")
		{
			err_list+="<br>Please enter a 10 digit mobile number or your Roll Number for 10+2 Exam.";
			$("#mobile").addClass("error");
		}
		
		if($("#dob").val()=="")
		{
			err_list+="<br>Please enter your date of birth.";
			$("#dob").addClass("error");
		}

		if(err_list!="")
		{
			$("#inline_error").html(err_list);
		}
		else
		{
			$("#h_action").val("login");
			document.form1.submit();
		}
	}
</script>
</head>
<body>

  
    <?
		$page_heading="You are about to log in to your aplication dashboard at ".$college_name;
		include "header.php";
		include "page_header.php";
		include "status_msg.php";
	?>
    
    <div class="container">
        <div class="row">
		
            <div class="col-md-8">
				<div class="widget-item">
                    <div class="request-information">
                        <h4 class="widget-title">Log In to your dashboard </h4>
						<span id="inline_error" class="error2"></span>
                        <form name="form1" method="post" enctype="multipart/form-data" class="request-info clearfix"> 
							<input type="hidden" name="h_action" id="h_action" />
							<input type="hidden" name="h_id" id="h_id" />
							<input type="hidden" name="mk" id="h_mk" />
						
							<div class="full-row">
                                <label>Mobile Number or University Roll Number: </label>
                                <input type="text" id="mobile" name="mobile">
                            </div>

							<div class="full-row">
                                <label>Date of Birth: </label>
                                <input type="text" id="dob" name="dob" class="ebdate" value="01/01/2006">
                            </div>
							
						</form>
					</div>
					<p align="center">
						<button type="button" class="btn btn-primary" onclick="check_form()">Submit</button>
						<!-- font style="color:red;">Log in not allowed any more.</font -->
					</p>
				</div>
            </div>
			
			 <div class="col-md-4">
			 
				<div class="widget-main">
                    <div class="widget-main-title"><h4 class="widget-title">Important Tips</h4></div>
                    <div class="widget-inner">
					
                        <div class="event-small-list clearfix">
                            <div class="calendar-small">
                                <span class="s-month">Tip</span>
                                <span class="s-date">1</span>
                            </div>
                            <div class="event-small-details">
                                <h5 class="event-small-title"><a href="#">Be Accurate</a></h5>
                                <p class="event-small-meta small-text">It is important that you are accurate with these information.</p>
                            </div>
                        </div>
						
						<div class="event-small-list clearfix">
                            <div class="calendar-small">
                                <span class="s-month">Tip</span>
                                <span class="s-date">2</span>
                            </div>
                            <div class="event-small-details">
                                <h5 class="event-small-title"><a href="#">Full Name</a></h5>
                                <p class="event-small-meta small-text">Enter full name and not abbreviated ones.</p>
                            </div>
                        </div>
						
						<div class="event-small-list clearfix">
                            <div class="calendar-small">
                                <span class="s-month">Tip</span>
                                <span class="s-date">3</span>
                            </div>
                            <div class="event-small-details">
                                <h5 class="event-small-title"><a href="#">Double Check</a></h5>
                                <p class="event-small-meta small-text">You are not allowed to edit this information in the future.</p>
                            </div>
                        </div>
						
						<div class="event-small-list clearfix">
                            <div class="calendar-small">
                                <span class="s-month">Tip</span>
                                <span class="s-date">3</span>
                            </div>
                            <div class="event-small-details">
                                <h5 class="event-small-title"><a href="#">Mobile & Email</a></h5>
                                <p class="event-small-meta small-text">If these are not correct, you will not get any updates about your application.</p>
                            </div>
                        </div>
						
					</div>
				</div>
				
			</div>
			
		</div>
    </div>


    <? include "footer.php"; ?>
	<? include "extra_js.php"; ?>

    

</body>
</html>