<?php
$sid=$_REQUEST['sid'];

$GetIniStep=mysql_query("SELECT * FROM `student_registration` WHERE `sid` = '$sid'");
$GetIniStep1=mysql_fetch_assoc($GetIniStep);

$GetProStep1perosnal=mysql_query("SELECT * FROM `step1_perosonal` WHERE `sid` = '$sid'");
$GetProStep1perosnal1=mysql_fetch_assoc($GetProStep1perosnal);

$GetProStep1Contact=mysql_query("SELECT * FROM `step1_contact` WHERE `sid` = '$sid'");
$GetProStep1Contact1=mysql_fetch_assoc($GetProStep1Contact);


?>

<div class="page-content">
                            <ol class="breadcrumb">
                                
<li class=""><a href="index.html">Home</a></li>
<li class="active"><a href="index.html">Student Profile</a></li>
                            </ol>
                            <div class="container-fluid">
                                



<div data-widget-group="group1">
	


	


	

	<div class="row">
		<div class="col-md-12">
			<div class="panel panel-realtime" data-widget='{"draggable": "false"}'>
                <div class="panel-heading">
                    
                </div>
                <div class="panel-body">
<font size="+1"><table cellpadding="0" cellspacing="0" width="100%">
<tr><td>
<font color="#990000"><b>Program Details</b></font>
<hr />
<table cellpadding="0" cellspacing="0" width="100%" class="">
<tr><td width="70%" valign="top">
<table cellpadding="0" cellspacing="0" width="100%">
<tr style="line-height:35px"><td width="40%">
<strong>Program</strong></td><td width="60%"><?php  
										$GetProg=mysql_query("SELECT * FROM `sgvu_courses` WHERE `course_id` = '$GetProStep1perosnal1[program]'");
										$GetProg1=mysql_fetch_assoc($GetProg);
										echo $GetProg1['coursename'];
										?></td></tr>
                                        <tr style="line-height:35px">
                                          <td width="40%">
<strong><font size="+1">Status</font></strong></td>
                                          <td width="60%"><font color="#990000"><?php 
								   if($GetIniStep1['step']=='1')
								   {
								   echo 'Personal Desk';
								   }
								   if($GetIniStep1['step']=='2')
								   {
								   echo 'Academic Desk';
								   }
								   if($GetIniStep1['step']=='3')
								   {
								   echo 'Document Desk';
								   }
								   if($GetIniStep1['step']=='4')
								   {
								   echo 'Payment Desk';
								   }
								   if($GetIniStep1['step']=='5')
								   {
								   echo 'DD Desk';
								   }
								   if($GetIniStep1['step']=='6')
								   {
								   echo 'Scrutinizer Desk';
								   }
								   if($GetIniStep1['step']=='7')
								   {
								   echo 'Senior Desk';
								   }
								   if($GetIniStep1['step']=='8')
								   {
								   echo 'Finance Desk';
								   }
								   if($GetIniStep1['step']=='9')
								   {
								   echo 'Verifier Desk';
								   }
								   if($GetIniStep1['step']=='10')
								   {
								   echo 'Enrollment Desk';
								   }
								   if($GetIniStep1['step']=='11')
								   {
								   echo 'Admission Done';
								   }
								   
								    ?></font></td></tr>
<tr style="line-height:35px"><td width="40%"><strong>SID/Password</strong></td><td width="60%"><?php echo $GetIniStep1['sid'];?>/<?php echo $GetIniStep1['password'];?></td></tr>

</table>

</td><td width="30%"> <?php
										$GetPhoto=mysql_query("SELECT * FROM `step3_document` WHERE `doc_type` = 1 AND `sid` = '$sid'");
										$GetPhoto1=mysql_fetch_assoc($GetPhoto);
										
										?>
										<img id="ContentPlaceHolder2_Image1" src="../new-admin/upload/<?php echo $GetPhoto1['image'];?>" style="height:120px;width:120px; padding:4px; background:#E9E9E9" class="img-rounded" ></td></tr>

</table>

</td></tr>

<tr><td>
<font color="#990000"><b>Student's Details</b></font> <hr />
<table cellpadding="0" cellspacing="0" width="100%">
<tr style="line-height:35px"><td width="20%"><strong>Name</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['firstname']; ?> <?php echo $GetProStep1perosnal1['middlename']; ?> <?php echo $GetProStep1perosnal1['lastname']; ?></td><td width="20%"><strong>Gender</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['sex']; ?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Date of Birth</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['dob']; ?></td><td width="20%"><strong>Religion</strong></td><td width="30%"><?php 
													$GetStReligion=mysql_query("SELECT * FROM `religion` WHERE `id` ='$GetProStep1perosnal1[religion]'");
													$GetStReligion1=mysql_fetch_assoc($GetStReligion);
													echo $GetStReligion1['religion'];
													 ?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Category</strong></td><td width="30%"> <?php 
													$GetStCat=mysql_query("SELECT * FROM `category` WHERE `id` ='$GetProStep1perosnal1[cat]'");
													$GetStCat1=mysql_fetch_assoc($GetStCat);
													echo $GetStCat1['category'];
													?></td><td width="20%"><strong>Nationality</strong></td><td width="30%">INDIA</td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Mobile No.</strong></td><td width="30%"><?php echo $GetIniStep1['mobile']; ?></td><td width="20%"><strong>Email Id</strong></td><td width="30%"><?php echo $GetIniStep1['email']; ?></td></tr>
</table>
</td></tr>

<tr><td style="padding-top:30px">
<font color="#990000"><b>Parent's  Details</b></font><hr/>
<table cellpadding="0" cellspacing="0" width="100%">
<tr style="line-height:35px"><td width="20%"><strong>Father's Name</strong></td><td width="30%"> <?php echo $GetProStep1perosnal1['father_name']; ?></td><td width="20%"><strong>Mother's Name</strong></td><td width="30%"> <?php echo $GetProStep1perosnal1['mother_name']; ?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Father's Occupation</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['father_occupation']; ?></td><td width="20%"><strong>Mother's Occupation</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['mother_occupation']; ?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Father's Annual Income</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['father_anuual_income']; ?></td><td width="20%"><strong>Mother's Annual Income</strong></td><td width="30%"><?php echo $GetProStep1perosnal1['mother_income']; ?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Parent's Mobile No.</strong></td><td width="30%"><?php echo $GetProStep1Contact1['parent_mobile']; ?></td><td width="20%"><strong>Parent's Email Id</strong></td><td width="30%"><?php echo $GetProStep1Contact1['parent_email']; ?></td></tr>
</table>
</td></tr>

<tr><td style="padding-top:30px">
<font color="#990000"><b>Postal Address</b></font><hr />
<table cellpadding="0" cellspacing="0" width="100%">
<tr style="line-height:35px"><td width="20%"><strong>Address</strong></td><td width="30%"><?php echo $GetProStep1Contact1['add1']; ?>, <?php echo $GetProStep1Contact1['add2']; ?></td><td width="20%"><strong>City</strong></td><td width="30%"><?php echo $GetProStep1Contact1['city1'];
																$GetCity=mysql_query("SELECT * FROM `city` WHERE `city_id` ='$GetProStep1Contact1[city]'");
																$GetCity1=mysql_fetch_assoc($GetCity);
																?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>District</strong></td><td width="30%"><?php echo $GetCity1['cityname'];?></td><td width="20%"><strong>State</strong></td>
<td width="30%"> <?php 
																$GetState=mysql_query("SELECT * FROM `state` WHERE `ids` = '$GetProStep1Contact1[state]'");
																$GetState1=mysql_fetch_assoc($GetState);
																echo $GetState1['state'];
																?></td></tr>
<tr style="line-height:35px"><td width="20%"><strong>Pincode </strong></td>
<td width="30%"><?php echo $GetProStep1Contact1['pincode']; ?></td><td width="20%"><strong>Country</strong></td>
<td width="30%">India</td></tr>
</table>
</td></tr>

<tr><td style="padding-top:30px">
<font color="#990000"><b>Academic  Details</b></font>  <hr />
<table cellpadding="0" cellspacing="0" width="100%">
<tr height="35" bgcolor="#f5f5f5"><td width="5%" style="border:1px #000000 solid; padding:5px"><strong>S.No.</strong></td>
<td width="15%" style="border:1px #000000 solid; padding:5px"><strong>Examination</strong></td>
<td width="21%" style="border:1px #000000 solid; padding:5px"><strong>Board/University</strong></td>
<td width="22%" style="border:1px #000000 solid; padding:5px"><strong>School/College</strong></td>
<td width="22%" style="border:1px #000000 solid; padding:5px"><strong>Year of Passed/Appearing</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Max Marks</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Obtained Marks</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Percentage</strong></td>
<td width="7%" style="border:1px #000000 solid; padding:5px"><strong>Grade</strong></td>
</tr>
<?php
$GetStEdu=mysql_query("SELECT * FROM `step2_education` WHERE `sid` = '$sid' ORDER BY `step2_education`.`education_level` DESC");
while($GetStEdu1=mysql_fetch_assoc($GetStEdu))
{
$s =$_REQUEST['v'];

					$u = $s+0;
?>

<tr height="35">
<td style="border:1px #000000 solid; padding:5px"><?php echo $_REQUEST['v'] = $s+1; ?>.</td>
<td style="border:1px #000000 solid; padding:5px"><?php 
$GetLevel=mysql_query("SELECT * FROM `student_edu` WHERE `id` ='$GetStEdu1[education_level]'");
$GetLevel1=mysql_fetch_assoc($GetLevel);
echo $GetLevel1['education_level'];
?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetStEdu1['board_university']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetStEdu1['inst_name']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetStEdu1['year']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $stmax=$GetStEdu1['max_marks']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $stob=$GetStEdu1['obtained_marks']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php $per=($stob*100)/$stmax; 
echo round($per, 2); ?>%</td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetStEdu1['grade']; ?></td></tr>
<?php
}
?>
								  </table></td></tr>


<tr><td style="padding-top:30px">
<?php
$ChkEn=mysql_query("SELECT * FROM `step2_entrance` WHERE `sid` = '$sid'");
$ChkEn1=mysql_num_rows($ChkEn);
if($ChkEn1 >0)
{
?>

<font color="#990000"><b>Entrance Examination</b></font> <hr />
<table cellpadding="0" cellspacing="0" width="100%">
<tr height="35" bgcolor="#f5f5f5"><td width="5%" style="border:1px #000000 solid; padding:5px"><strong>S.No.</strong></td>
<td width="15%" style="border:1px #000000 solid; padding:5px"><strong>Name of Entrance Exam</strong></td>
<td width="21%" style="border:1px #000000 solid; padding:5px"><strong>Roll No.</strong></td>
<td width="22%" style="border:1px #000000 solid; padding:5px"><strong>Year of Appearing</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Max Marks</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Obtained Marks</strong></td>
<td width="10%" style="border:1px #000000 solid; padding:5px"><strong>Rank</strong></td>
</tr>
<?php
$GetEntra=mysql_query("SELECT * FROM `step2_entrance` WHERE `sid` = '$sid'");
while($GetEntra1=mysql_fetch_assoc($GetEntra))
{
$s1 =$_REQUEST['v1'];

					$u = $s+0;
?>

<tr height="35">
<td style="border:1px #000000 solid; padding:5px"><?php echo $_REQUEST['v1'] = $s1+1; ?>.</td>
<td style="border:1px #000000 solid; padding:5px"><?php 
echo $GetEntra1['entrance_exam'];
?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetEntra1['entrance_roll']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetEntra1['entrance_year']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetEntra1['entrance_max_marks']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetEntra1['entrance_obtained']; ?></td>
<td style="border:1px #000000 solid; padding:5px"><?php echo $GetEntra1['rank']; ?></td>
</tr>
<?php
}
?>
								  </table>
								  <?php
								  }
								  ?>
								  
</td></tr>



</table></font>			
<div align="center"><a href="javascript:window.print()" class="btn btn-inverse"><i class="ti ti-printer"></i></a></div>		
                </div>
            </div>
		</div>
		<div class="col-sm-8">
	
		<!-- /input-group -->


	    <!--<div class="panel panel-inbox" style="visibility: visible; opacity: 1; display: block; transform: translateY(0px);">
				<div class="panel-body">
					<div class="inbox-mail-heading">
						<div class="clearfix">
							<div class="pull-left">
								<div class="btn-group">
						           <h4>Inbox</h4>
						           
						        </div>
						    </div>
						</div>
					</div>
					<table class="table table-hover table-inbox table-vam">
						<tbody>
							<tr class="unread">
								<td class="inbox-msg-check" width="5%"><div class="checkbox-inline icheck"><div class="icheckbox_minimal-blue" style="position: relative;"><input type="checkbox" value="" style="position: absolute; opacity: 0;"><ins class="iCheck-helper" style="position: absolute; top: 0%; left: 0%; display: block; width: 100%; height: 100%; margin: 0px; padding: 0px; border: 0px; opacity: 0; background: rgb(255, 255, 255);"></ins></div></div> </td>
								<td class="inbox-msg-from hidden-xs hidden-sm" width="20%"><div><a href="#">Terrell Tilson</a></div></td>
								<td class="inbox-msg-snip"><span class="label label-primary" width="58%">Work</span>Sed ut perspiciatis unde omnis iste natus error sit voluptatem</td>
								<td class="inbox-msg-attach"><i class="ti ti-paperclip" width="5%"></i> </td>
								<td class="inbox-msg-time" width="12%">13:42</td>
							</tr>
						
						</tbody>
					</table>
					<div class="inbox-mail-footer">
						<div class="clearfix">
						    <div class="pull-right">
						    	<strong>1</strong> of <strong>50</strong>
						    	<div class="btn-group ml-sm">
		                            <a href="#" class="btn btn-lg btn-default"><i class="ti ti-angle-left"></i></a>
		                            <a href="#" class="btn btn-lg btn-default"><i class="ti ti-angle-right"></i></a>
		                        </div>
						    </div>
						</div>
					</div>
				</div>
			</div>-->

	</div>
	</div>
	<div class="row">
                    <div class="col-md-12">
                       
                    </div>
                </div>
	
</div>
                            </div> <!-- .container-fluid -->
</div>
						

<script type="text/javascript" src="assets/js/jquery-1.10.2.min.js"></script> 							<!-- Load jQuery -->
<script type="text/javascript" src="assets/js/jqueryui-1.10.3.min.js"></script> 							<!-- Load jQueryUI -->
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script> 								<!-- Load Bootstrap -->
<script type="text/javascript" src="assets/js/enquire.min.js"></script> 									<!-- Load Enquire -->

<script type="text/javascript" src="assets/plugins/velocityjs/velocity.min.js"></script>					<!-- Load Velocity for Animated Content -->
<script type="text/javascript" src="assets/plugins/velocityjs/velocity.ui.min.js"></script>

<script type="text/javascript" src="assets/plugins/wijets/wijets.js"></script>     						<!-- Wijet -->

<script type="text/javascript" src="assets/plugins/codeprettifier/prettify.js"></script> 				<!-- Code Prettifier  -->
<script type="text/javascript" src="assets/plugins/bootstrap-switch/bootstrap-switch.js"></script> 		<!-- Swith/Toggle Button -->

<script type="text/javascript" src="assets/plugins/bootstrap-tabdrop/js/bootstrap-tabdrop.js"></script>  <!-- Bootstrap Tabdrop -->

<script type="text/javascript" src="assets/plugins/iCheck/icheck.min.js"></script>     					<!-- iCheck -->

<script type="text/javascript" src="assets/plugins/nanoScroller/js/jquery.nanoscroller.min.js"></script> <!-- nano scroller -->

<script type="text/javascript" src="assets/js/application.js"></script>
<script type="text/javascript" src="assets/demo/demo.js"></script>
<script type="text/javascript" src="assets/demo/demo-switcher.js"></script>

<!-- End loading site level scripts -->
    
    <!-- Load page level scripts-->
    
<!-- Charts -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.min.js"></script>             	<!-- Flot Main File -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.pie.min.js"></script>             <!-- Flot Pie Chart Plugin -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.stack.min.js"></script>       	<!-- Flot Stacked Charts Plugin -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.orderBars.min.js"></script>   	<!-- Flot Ordered Bars Plugin-->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.resize.min.js"></script>          <!-- Flot Responsive -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.tooltip.min.js"></script> 		<!-- Flot Tooltips -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.spline.js"></script> 				<!-- Flot Curved Lines -->

<script type="text/javascript" src="assets/plugins/sparklines/jquery.sparklines.min.js"></script> 			 <!-- Sparkline -->

<script type="text/javascript" src="assets/plugins/jvectormap/jquery-jvectormap-2.0.2.min.js"></script>       <!-- jVectorMap -->
<script type="text/javascript" src="assets/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>   <!-- jVectorMap -->

<script type="text/javascript" src="assets/plugins/switchery/switchery.js"></script>     					<!-- Switchery -->
<script type="text/javascript" src="assets/plugins/easypiechart/jquery.easypiechart.js"></script>
<script type="text/javascript" src="assets/plugins/fullcalendar/moment.min.js"></script> 		 			<!-- Moment.js Dependency -->
<script type="text/javascript" src="assets/plugins/fullcalendar/fullcalendar.min.js"></script>   			<!-- Calendar Plugin -->

<script type="text/javascript" src="assets/demo/demo-index.js"></script> 									<!-- Initialize scripts for this page-->

						