<?php
$sid=$convert->decode($_GET['id']);

$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);
$GetPhoto=mysql_query("SELECT * FROM `step3_document` WHERE `doc_type` = 1 AND `sid` = '$sid'");
										$GetPhoto1=mysql_fetch_assoc($GetPhoto);



?>

<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">
<div align="center"><img style="height:50px" src="http://www.gyanvihar.org/assets/img/logo-gv.jpg" /><br /><h3>Enrollment Slip</h3></div><br>

<table cellpadding="0" cellspacing="0" width="100%">
<tr><td width="85%">
<table cellpadding="0" cellspacing="0" width="100%">
<tr><td width="50%" style="padding:1px">Enrollment No: <b>

<?php
$GetChkenroll=mysql_query("SELECT * FROM  `old_student_enrollment` WHERE  `sid` ='$sid'");
$GetChkenroll1=mysql_num_rows($GetChkenroll);
$GetChkenroll2=mysql_fetch_assoc($GetChkenroll);
if($GetChkenroll1 > 0)
{
	echo $GetChkenroll2['enrollment'];
}
else
{

 $GetEnroll=mysql_query("SELECT * FROM `sgvu_enrollment` WHERE `sid` ='$sid'");
$GetEnroll1=mysql_fetch_assoc($GetEnroll);
echo $GetEnroll1['enrollment_no'];
}
?>


</b></td><td style="padding:1px"></td></tr>
<tr><td width="50%" style="padding:1px">Student Name: <?php echo $GetProStep1perosnal1['firstname']; ?> <?php echo $GetProStep1perosnal1['middlename']; ?> <?php echo $GetProStep1perosnal1['lastname']; ?></td><td style="padding:1px"> SID: <?php echo $sid; ?></td></tr>
<tr><td width="50%" style="padding:1px">Gender: <?php echo $GetProStep1perosnal1['sex']; ?></td><td style="padding:1px">DOB: 
<?php $dob=$GetProStep1perosnal1['dob']; ?>
<?php
$dob=strtotime($dob);
echo date('d M Y', $dob)
?>

</td></tr>
<tr><td width="50%" style="padding:1px">Religion: <?php 
													$GetStReligion=mysql_query("SELECT * FROM `religion` WHERE `id` ='$GetProStep1perosnal1[religion]'");
													$GetStReligion1=mysql_fetch_assoc($GetStReligion);
													echo $GetStReligion1['religion'];
													 ?></td><td style="padding:1px">Category: <?php 
													$GetStCat=mysql_query("SELECT * FROM `category` WHERE `id` ='$GetProStep1perosnal1[cat]'");
													$GetStCat1=mysql_fetch_assoc($GetStCat);
													echo $GetStCat1['category'];
													?></td></tr>
<tr><td width="50%" style="padding:1px">Father's Name: <?php echo $GetProStep1perosnal1['father_name']; ?></td><td style="padding:1px">Mother's Name: <?php echo $GetProStep1perosnal1['mother_name']; ?></td></tr>
<tr><td width="50%" style="padding:1px">Mobile No.: <?php echo $GetIniStep1['mobile']; ?></td><td style="padding:1px">Email ID: <?php echo $GetIniStep1['email']; ?></td></tr>

<tr><td width="50%" style="padding:1px">Course : <?php  
										$GetProg=mysql_query("SELECT * FROM `sgvu_courses` WHERE `course_id` = '$GetProStep1perosnal1[program]'");
										$GetProg1=mysql_fetch_assoc($GetProg);
										echo $GetProg1['coursename'];
										?>(<?php
										  $GetSem=mysql_query("SELECT * FROM  `sgvu_stu_sem_allocate` WHERE  `sid` =$sid");
										  $GetSem1=mysql_fetch_assoc($GetSem);
										  echo $GetSem1['sem'];
										  ?> Sem)</td><td style="padding:1px">Date: <?php echo date('d-m-Y H:i:s');?></td></tr>

</table>
<table cellpadding="0" cellspacing="0" width="100%">
<tr><td width="100%" style="padding:1px">Address: <?php echo $GetProStep1Contact1['add1'].', '.$GetProStep1Contact1['add2']; ?>, <?php 
$GetCity=mysql_query("SELECT * FROM `city` WHERE `city_id` ='$GetProStep1Contact1[city]'");
$GetCity1=mysql_fetch_assoc($GetCity);
echo $GetCity1['cityname'];
?>, <?php
$GetState=mysql_query("SELECT * FROM `state` WHERE `ids` ='$GetProStep1Contact1[state]'");
$GetState1=mysql_fetch_assoc($GetState);
echo $GetState1['state'];
?> - <?php echo $GetProStep1Contact1['pincode']; ?> </td></tr></table>

</td><td style="padding:10px"><img id="ContentPlaceHolder2_Image1" src="../new-admin/upload/<?php echo $GetPhoto1['image'];?>" style="height:100px;width:100px; padding:4px; background:#E9E9E9" class="img-rounded" ></td></tr>

</table>
<table cellpadding="0" cellspacing="0" width="100%">


<tr><td style="padding-top:30px">
<table cellpadding="0" cellspacing="0" width="100%" border="1">
<tr><td width="6%" style="padding:5px"><strong>S.No.</strong></td>
<td width="56%" style="padding:5px"><strong>Document Name</strong></td>
<td width="38%" style="padding:5px"><strong>Document Type</strong></td>
</tr>
<?php
$GetDoc=mysql_query("SELECT * FROM `sgvu_enroll_doc_submit` WHERE `sid` = '$sid' ORDER BY `sgvu_enroll_doc_submit`.`doc_type` ASC");
while($GetDoc1=mysql_fetch_assoc($GetDoc))
{
$s =$_REQUEST['v'];
$u = $s+0;
?>

<tr><td width="6%" style="padding:5px" align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
<td width="56%" style="padding:5px"><?php  
$GetDocName=mysql_query("SELECT * FROM `sgvu_enroll_docs` WHERE `id` ='$GetDoc1[doc_type]'");
$GetDocName1=mysql_fetch_assoc($GetDocName);
echo $GetDocName1['document'];
?></td>
<td width="38%" style="padding:5px"><?php if($GetDoc1['document'] =='1')
{
echo 'Original';
}
if($GetDoc1['document'] =='2')
{
echo 'Photocopy';
}
 ?></td>
</tr>
<?php
}
?>
</table>
</td></tr>


</table>
<br /><br /><br />
<br /><br />
<table cellpadding="0" cellspacing="0" width="100%"><tr><td width="50%"></td><td align="right">Dr(Acad.)/Authority</td></tr></table>
<br>
<style>
@media print {
  /* style sheet for print goes here */
  .hide-from-printer{  display:none; }
}
</style>
<br /><br />
<div align="center"><a href="javascript:window.print()" class="btn btn-inverse hide-from-printer"><i class="ti ti-printer"></i> Print</a></div>		
                </div>
            </div>
		</div>
		<div class="col-sm-8">
	



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

						