<?php

include("../link/databaseconnection.php");
$flag=$_REQUEST['flag'];
switch($flag)
{
case 1:
	$class=$_POST['class'];
	$fees=$_POST['fees'];
	$month=$_POST['month'];
	$exam=$_POST['exam'];
	$adm=$_POST['adm'];
	$date1=$_POST['date'];
	 $flag1=$_POST['flag1'];
	
	$session=$_POST['session'];
		$board=$_POST['board'];
	
	$date=date("d-m-Y");
	date_default_timezone_set("asia/kolkata");
	$time=date("h:i:sa");
	$datetime=$date.$time;
	if($flag1=='')
	{
	    foreach($_POST['check_list'] as $check) {
	$ins="insert into fees(class,fees,month,exam,adm,date,datetime,session,board) values('$check','$fees','$month','$exam','$adm','$date1','$datetime','$session','$board')";
	if($res=mysqli_query($conn,$ins))
	{
		echo"submit";
		
	}
	else
	{
		echo"not submit";
	}
}
}
else
{
	$up="update fees set class='$class',fees='$fees',month='$month',exam='$exam',adm='$adm', date='$date1',board='$board' where id='$flag1'";
	if(mysqli_query($conn,$up))
	{
		echo"Update";
	}
else
{
	echo"no Update";
}
	
}
	
	
	break;
	//=============================================
	case 2:
	$conv=$_POST['conv'];
	$code=$_POST['code'];
	$session=$_POST['session'];
	
	$villm=$_POST['vill'];
	$vill= strtoupper($villm);
	$ins="insert into convence(conv,vill,code,session) values('$conv','$vill','$code','$session')";
	if($res=mysqli_query($conn,$ins))
	{
		echo"submit";
		
	}
	else
	{
		echo"not submit";
	}
	break;
	////////////////////////////////////
	case 3:
	
	?>
	

	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: [ 'csv', 'excel', 'pdf', 'print']
    });
	
});
</script>


	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr>
                <th>Sr.</th><th>Session</th><th>Month</th><th>Class</th><th>Tution Fee</th><th>Exam/Development/Sports/Admission</th><th>Board</th><th>Edit</th><th>Delete</th>
            </tr>
        </thead>
<tfoot>
             <tr>
                <th>Sr.</th><th>Session</th><th>Month</th><th>Class</th><th>Tution Fee</th><th>Exam/Development/Sports/Admission</th><th>Board</th><th>Edit</th><th>Delete</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  $sel="select * from fees where month!='2'";
	$res=mysqli_query($conn,$sel);
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$str=$row['month'];
		
	$sel4="select * from  plan where id ='$str'";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$m1=$row4['month'];

		?>
		 
	<tr class="text-center">
	<td><?php echo $s;?></td><td><?php echo $row['session'];?></td><td><?php echo $m1;?></td><td><?php echo $row['class'];?></td><td><?php echo $row['fees'];?></td><td><?php echo $row['exam'];?></td><td><?php echo $row['board'];?></td>
	<td><a href="fees.php?flag=<?php echo $row['id'];?>"><span class="glyphicon glyphicon-pencil"></span></a></td>
	<td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
	
	
	</tr>
	<?php
	$s++;
	}
	?>
	 </tbody>
    </table>
	
	</div>
	
	
	<?php
	break;
	case 31:
	
	?>
	

	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: [ 'csv', 'excel', 'pdf', 'print']
    });
	
});
</script>


	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr>
                <th>Sr.</th><th>Session</th><th>Month</th><th>Class</th><th>Tution Fee</th><th>Exam/Development/Sports/Admission</th><th>Due Date</th>
            </tr>
        </thead>
<tfoot>
             <tr>
                <th>Sr.</th><th>Session</th><th>Month</th><th>Class</th><th>Tution Fee</th><th>Exam/Development/Sports/Admission</th><th>Due Date</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  $session=$_POST['session'];
  $sel="select * from fees where session='$session' and month!='2'";
	$res=mysqli_query($conn,$sel);
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$str=$row['month'];
		
	$sel4="select * from  plan where id ='$str'";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$m1=$row4['month'];


		?>
		 
	<tr class="text-center">
	<td><?php echo $s;?></td><td><?php echo $row['session'];?></td><td><?php echo $m1;?></td><td><?php echo $row['class'];?></td><td><?php echo $row['fees'];?></td><td><?php echo $row['exam'];?></td><td><?php echo $row['date'];?></td>
	
	
	</tr>
	<?php
	$s++;
	}
	?>
	 </tbody>
    </table>
	
	</div>
	
	
	<?php
	break;
	//////////////////
	case 4:
	$id=$_POST['rowid'];
	
	$del="delete from fees where id='$id'";
	if(mysqli_query($conn,$del))
	{
		echo"deleted Successfully";
		
	}
	else
	{
		echo"Not Deleted";
	}
	break;
	//////////////////////////
	case 5:
	
	?>
	

	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: [ 'csv', 'excel', 'pdf', 'print']
    });
	
});
</script>


	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr>
                <th>Sr.</th><th>Session</th><th>Village</th><th>Conveyance Charge</th><th>Code</th><th>Edit</th><th>Delete</th>
            </tr>
        </thead>
<tfoot>
            <tr>
               <th>Sr.</th><th>Session</th><th>Village</th><th>Conveyance Charge</th><th>Code</th><th>Edit</th><th>Delete</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  $sel="select * from convence order by code asc";
	$res=mysqli_query($conn,$sel);
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		
		?>
		 
	<tr class="text-center">
	<td><?php echo $s;?></td><td><?php echo $row['session'];?></td><td><?php echo $row['vill'];?></td><td><?php echo $row['conv'];?></td><td><?php echo $row['code'];?></td>
	<td><a href="javascript:;" onclick="editrow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-pencil"></span></a></td>
	<td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
	
	
	</tr>
	<?php
	$s++;
	}
	?>
	 </tbody>
    </table>
	
	</div>
	
	
	<?php
	break;
	///////////////////////
	case 6:
	$id=$_POST['rowid'];
	
	$del="delete from convence where id='$id'";
	if(mysqli_query($conn,$del))
	{
		echo"deleted Successfully";
		
	}
	else
	{
		echo"Not Deleted";
	}
	break;
	
	case 7:
	$eid=$_REQUEST['id'];
	//echo"$eid";
	$sel="select * from  fees where id='$eid'";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	?>
	
	
	<div class="panel-group">
				<div class="panel panel-primary">
				
				
				<div class="panel-body">
				

<script>
$(document).ready(function(){
	
	$("#myform").submit(function(e){
		
		e.preventDefault();	
		$("#btn").prop("disabled",true);
		$.ajax({
					url:"../code/registrationcode.php?flag=1",
					type:"POST",
					data:new FormData(this),
					contentType:false,
					processData:false,
					success:function(res){
						alert(res);
						if(res=="Submit")
						{
						window.location.href="student_print.php";
						$("#myform").trigger("reset");
						}
					},
					error:function(){
						alert("error");
					}
				
				});
	});
	
	
});
</script>
		
<script>
$(document).ready(function(){
	
	$("#check").change(function(){
		var c=$("#city").val();
		var v=$("#village").val();
		var po=$("#postoffice").val();
		var d=$("#dist").val();
		var s=$("#state").val();
		var m=$("#mobile").val();
		var pi=$("#pincode").val();
		if($(this).prop("checked")==true)
		{
			$("#city1").val(c);
			$("#village1").val(v);
			$("#postoffice1").val(po);
			$("#dist1").val(d);
			$("#state1").val(s);
			$("#mobile1").val(m);
			$("#pincode1").val(pi);
		}
		else
		{
			$("#city1").val("");
			$("#village1").val("");
			$("#postoffice1").val("");
			$("#dist1").val("");
			$("#state1").val("");
			$("#mobile1").val("");
			$("#pincode1").val("");
		}
		
	});
	
	
	
	
});
$(document).ready(function(){
	$("#chek").change(function(){
		
		if($(this).prop("checked")==true)
		{
			$("#show").css("display","none");
		    $("#btn").prop("disabled",false);
		
		}
		else
		{
			$("#show").css("display","inline-block");
			$("#btn").prop("disabled",true);
		
		}
	
	});

		
	});
	$(document).ready(function(){
		$("#per").focus(function(){
			
			var o=$("#omark").val();
			var t=$("#tmark").val();
			var result1=o/t*100;
			var result=parseInt(result1);
			$("#per").val(result);
		});
		
		
		
	});
	$(document).ready(function(){
		
		$("#select").change(function(){
			var a=$("#select").val();
			if(a=="high")
			{
				$("#inter1").attr("disabled","true");
				$("#high1").removeAttr("disabled");
			}
			else if(a=="inter")
			{
				$("#high1").attr("disabled","true");
				$("#inter1").removeAttr("disabled");
				
			}
			else if(a=="L.K.G"||a=="U.K.G"||a=="1"||a=="2"||a=="3"||a=="4"||a=="5"||a=="6"||a=="7"||a=="8")
			{
				$("#high1").attr("disabled","true");
				$("#inter1").attr("disabled","true");
				
			}
			
			else
			{
				$("#high1").removeAttr("disabled");
				$("#inter1").removeAttr("disabled");
			}
		});
		
		
		
	});
	
	$(document).ready(function(){
		$("#select").change(function(){
			var classc =$(this).val();
		$.ajax({
			url:"../code/registrationcode.php?flag=4",
			type:"POST",
			data: {class12:classc},
			success:function(res){
				//alert(res);
				$("#sel12").html(res);
			},
			error:function(){
				alert("error");
			}
		});
		});
	});
</script>


		



	<!-- header -->
	
	<!-- //header -->
		<!-- gallery -->
		<div >
	<div id="lab" class="">
		<div class="container-fluid">
	
			<div class="row">
			<div class="panel-group">
				<div class="panel panel-primary">
				
				
				<div class="panel-body">
				<form class="form-horizontal" onsubmit="return updaterow(this)">
				
				<div class="col-sm-8">
				
				<div class="form-group">
				<label class="col-sm-3 control-label">Class</label>
				<div class="col-sm-3"><select class="form-control"  name="class" required>
	<option value="">---select---</option>
	<option <?php if($row['class']=='NURSERY'){echo'selected';}?>>NURSERY</option>
	<option <?php if($row['class']=='LKG'){echo'selected';}?>>LKG</option>
	<option <?php if($row['class']=='UKG'){echo'selected';}?>>UKG</option>
	<option <?php if($row['class']=='PLAY GROUP'){echo'selected';}?>>PLAY GROUP</option>
	<option <?php if($row['class']=='FIRST'){echo'selected';}?>>FIRST</option>
	<option <?php if($row['class']=='SECOND'){echo'selected';}?>>SECOND</option>
	<option <?php if($row['class']=='THIRD'){echo'selected';}?>>THIRD</option>
	<option <?php if($row['class']=='FOURTH'){echo'selected';}?>>FOURTH</option>
	<option <?php if($row['class']=='FIFTH'){echo'selected';}?>>FIFTH</option>
	<option <?php if($row['class']=='SIXTH'){echo'selected';}?>>SIXTH</option>
	<option <?php if($row['class']=='SEVENTH'){echo'selected';}?>>SEVENTH</option>
	<option <?php if($row['class']=='EIGHTH'){echo'selected';}?>>EIGHTH</option>
	<option <?php if($row['class']=='NINTH'){echo'selected';}?>>NINTH</option>
	<option <?php if($row['class']=='TENTH'){echo'selected';}?>>TENTH</option>
	<option <?php if($row['class']=='ELEVENTH'){echo'selected';}?>>ELEVENTH</option>
		<option <?php if($row['class']=='TWELFTH'){echo'selected';}?>>TWELFTH</option>
		
		</select>	</div>
				<div class="form-group">
    <label  class="col-sm-3 control-label">Tution Fee-</label>
    <div class="col-sm-3">
      <input type="number" class="form-control"  value="<?php echo $row['fees'];?>" name="fees" required>
	  <input type="hidden" class="form-control"  value="<?php echo $eid ?>" name="id" required>
    </div>
  </div>
  
    <label  class="col-sm-3 control-label">Registration Fee-</label>
    <div class="col-sm-3">
      <input type="number" class="form-control"  value="<?php echo $row['reg'];?>"name="reg" >
    </div>
   
  
 
    <label  class="col-sm-3 control-label">Miscellaneous Fee-</label>
    <div class="col-sm-3">
      <input type="number" class="form-control"  value="<?php echo $row['addm'];?>" name="add" >
    <br/>
	</div>
  <label  class="col-sm-3 control-label">Annual Charge New-</label>
    <div class="col-sm-3">
      <input type="number" class="form-control" value="<?php echo $row['ann'];?>" name="ann" >
    </div>
 <div class="form-group">
    <label  class="col-sm-3 control-label">Annual Charge Old</label>
    <div class="col-sm-3">
      <input type="number" class="form-control"  value="<?php echo $row['diary'];?>" name="diary" >
    </div>
  </div>
  <div class="form-group">
    <label  class="col-sm-3 control-label">Tie+Belt</label>
    <div class="col-sm-3">
      <input type="number" class="form-control" value="<?php echo $row['tie'];?>" name="tie" >
    </div>
  </div>
  <div class="form-group">
    <label  class="col-sm-3 control-label">Others</label>
    <div class="col-sm-3">
      <input type="number" class="form-control" value="<?php echo $row['other'];?>" name="other" >
    </div>
  </div>
   <div class="form-group">
  <br/>
    <label  class="col-sm-3 control-label">Session <span style="color:red">*</span></label>
    <div class="col-sm-3">
	<?php 
	$selc="select * from session";
	$resc=mysqli_query($conn,$selc);
	?>
	<select class="form-control" style="font-weight:bold" id="select" name="session">
	
	 
	  <?php 
	  
	  while($rowc=mysqli_fetch_array($resc,MYSQLI_BOTH))
	  {
	  ?>
	  <option <?php if($rowc['session']==$row['session']){echo'selected';}?>><?php echo $rowc['session'];?></option>
	  <?php
	  }
	  
	  ?>
	  </select>

	</div>
	</div>
    
				</div>
				<!------ phli finish row-->
				</div>
				<!------ dusri row-->
				<div class="col-sm-4">
				
				<div class="form-group">
    
  
  <div class="form-group">
    <label  class="col-sm-3 control-label">Computer Fee-</label>
    <div class="col-sm-8">
      <input type="number" class="form-control" value="<?php echo $row['comp'];?>" name="comp" >
    </div>
  </div>
  
  
  
    <label  class="col-sm-3 control-label">Generator Fee-</label>
    <div class="col-sm-8">
      <input type="number" class="form-control" value="<?php echo $row['gen'];?>" name="gen" >
    <br/>
	</div>
	
				</div>
				
				<!------ dusari finish row-->
				
				
				<br/>
				
  
  
  
 
  
    
  
  
    
 
  
    
  
  <div class="form-group">
    
    <div class="col-sm-5">
      
	   <br/>
				<center><button class="btn btn-primary">Submit</button>
				
				</center>
				</div>
				</form>
	</div>
	</div>
	
	</div>
  <div id="show"></div>
</div>





		
		
		</div>
		</div>
	<!-- //gallery -->

	<!-- footer
	<!-- //footer -->

	
</div>
</div>
</div>
</div>
	


	</div>
	</div>
	
	
	
	
	
	
	
	
	
	
	<?php
	break;
	//// for update fees
	case 8:
	$id=$_POST['id'];
	$class=$_POST['class'];
	$fees=$_POST['fees'];
	$reg=$_POST['reg'];
	$add=$_POST['add'];
	$ann=$_POST['ann'];
	$comp=$_POST['comp'];
	$gen=$_POST['gen'];
	$diary=$_POST['diary'];
	$tie=$_POST['tie'];
	$other=$_POST['other'];
	$session=$_POST['session'];
	
	
	$date=date("d-m-Y");
	date_default_timezone_set("asia/kolkata");
	$time=date("h:i:sa");
	$datetime=$date.$time;
	$ins="update fees set class='$class',fees='$fees',reg='$reg',addm='$add',ann='$ann',comp='$comp',gen='$gen',diary='$diary',tie='$tie',other='$other',datetime='$datetime',session='$session' where id ='$id'";
	if($res=mysqli_query($conn,$ins))
	{
		echo"Update";
		
	}
	else
	{
		echo"not submit";
	}
	
	break;
	
	case 9:
	$eid=$_REQUEST['id'];
	//echo"$eid";
	$sel="select * from  convence where id='$eid'";
	$res=mysqli_query($conn,$sel);
	$row=mysqli_fetch_array($res,MYSQLI_BOTH);
	?>
	
	
	<div class="panel-group">
				<div class="panel panel-primary">
				
				
				<div class="panel-body">
			
	<!-- header -->
	
	<!-- //header -->
		<!-- gallery -->
		<div >
	<div id="lab" class="">
		<div class="container-fluid">
	
			<div class="row">
			<div class="panel-group">
				<div class="panel panel-primary">
				
				
				<div class="panel-body">
				<form class="form-horizontal" onsubmit="return updaterow(this)">
				
				<div class="col-sm-8">
				
				<div class="form-group">
				
				
   
  
 
    
 
  
   <div class="form-group">
  
    <label  class="col-sm-3 control-label">Session <span style="color:red">*</span></label>
    <div class="col-sm-3">
	
	<select class="form-control"  name="session" required>
	<option value="">---select---</option>
				<option <?php if($row['session']=='2018-2019'){echo'selected';}?>>2018-2019</option>
				<option <?php if($row['session']=='2019-2020'){echo'selected';}?>>2019-2020</option>
				<option <?php if($row['session']=='2020-2021'){echo'selected';}?>>2020-2021</option>
				<option <?php if($row['session']=='2021-2022'){echo'selected';}?>>2021-2022</option>
				<option <?php if($row['session']=='2022-2023'){echo'selected';}?>>2022-2023</option>
	</select>
	</div>
	</div>
    
				</div>
				<!------ phli finish row-->
				</div>
				<!------ dusri row-->
				<div class="col-sm-6">
				
				<div class="form-group">
    
  
  <div class="form-group">
    <label  class="col-sm-3 control-label">Vill</label>
    <div class="col-sm-8">
      <input type="text" class="form-control" value="<?php echo $row['vill'];?>" name="vill" >
      <input type="hidden" class="form-control" value="<?php echo $eid;?>" name="id" >
    </div>
  </div>
  
  </div>
  <div class="form-group">
    <label  class="col-sm-3 control-label">Code</label>
    <div class="col-sm-8">
      <input type="number" class="form-control" value="<?php echo $row['code'];?>" name="code" >
    </div>
  </div>
  </div>
  <div class="col-sm-6">
				
				<div class="form-group">
    
  
  <div class="form-group">
    <label  class="col-sm-3 control-label">Conv Charge--</label>
    <div class="col-sm-8">
      <input type="number" class="form-control" value="<?php echo $row['conv'];?>" name="conv" >
    <br/>
	</div>
	</div>
	</div>
	</div>
	 
	
				
				
				<!------ dusari finish row-->
				
				
				<br/>
				
  <div class="form-group">
    
    <div class="col-sm-5">
      
	   <br/>
				<center><button class="btn btn-primary">Submit</button>
				
				</center>
				</div>
				</form>
	</div>
	
	
	</div>
  <div id="show"></div>
</div>
		</div>
		</div>
	<!-- //gallery -->

	<!-- footer
	<!-- //footer -->

	
</div>
</div>
</div>
</div>
	


	</div>
	</div>
	
	<?php
	break;
	case 10:
	$id=$_POST['id'];
	$conv=$_POST['conv'];
	$code=$_POST['code'];
	$session=$_POST['session'];
	
	$villm=$_POST['vill'];
	$vill= strtoupper($villm);
	$ins="update convence set conv='$conv',vill='$vill',code='$code',session='$session' where id='$id'";
	if($res=mysqli_query($conn,$ins))
	{
		echo"Update";
		
	}
	else
	{
		echo"not submit";
	}
	break;
		case 2971:
	
	?>
	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: ['pdf','print','excel']
    });
	
});
</script>

	


	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr >
               <th style="text-align:center">Sch.No.</th><th style="text-align:center">Name</th><th style="text-align:center">Father</th><th style="text-align:center">Class</th><th style="text-align:center">Date</th><th style="text-align:center">Status</th>
            </tr>
        </thead>

<tbody>		
  <?php
  
	
  $session=$_POST['session'];
  $sdate=$_POST['sdate'];
  $edate=$_POST['edate'];
	$class=$_POST['class'];
	$sch12=$_POST['sch'];
		$sel12="select * from  registration where session='$session' and application='$sch12' and status='' ";
	$res12=mysqli_query($conn,$sel12);
	$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
	$sch=$row12['application'];
	
//	$sch=$_POST['sch'];
	/////
	$sel2="select * from  present1 where session='$session' and class='$class' and sch=$sch and status='P' and date between '$sdate' and '$edate' ";
	$res2=mysqli_query($conn,$sel2);
	$count=mysqli_num_rows($res2);
//	echo $count;
	
	$sel21="select * from  present1 where session='$session' and class='$class' and sch=$sch and status='A' and date between '$sdate' and '$edate' ";
	$res21=mysqli_query($conn,$sel21);
	$count1=mysqli_num_rows($res21);
	
	$sel211="select * from  present1 where session='$session' and status='A' and date between '$sdate' and '$edate' ";
	$res211=mysqli_query($conn,$sel211);
	$count11=mysqli_num_rows($res211);
	
	$sel2111="select * from  present1 where session='$session' and status='P' and date between '$sdate' and '$edate' ";
	$res2111=mysqli_query($conn,$sel2111);
	$count111=mysqli_num_rows($res2111);
//	echo $count1;
	//$s=0;
	
	//echo $s++;
	/////
  $sel="select * from  present1 where session='$session' and class='$class'  and sch='$sch'  and date between '$sdate' and '$edate'";
	$res=mysqli_query($conn,$sel);
	
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		
//$edate=date("d-m-Y",strtotime($date1));
//echo $edate;
	date_default_timezone_set("asia/kolkata");
	//$d=$row['mobile'];
	$sel1="select * from  present1 where session='$session' and class='$class' and sch='$sch'  and  date between '$sdate' and '$edate'";
	$res1=mysqli_query($conn,$sel1);
	$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
	$status1=$row1['status'];
	$date12=$row['date'];
	$date=date("d-m-Y",strtotime($date12));
		?>
		 
	<tr class="text-center">
	<td><?php echo $sch12;?></td><td><?php echo $row['name'];?></td><td><?php echo $row['fname']?></td><td><?php echo $row['class'] ;?></td><td><?php echo $date;?></td><td><?php echo $row['status'] ;?></td>
	
	
	
	</tr>
	
	<?php
	$s++;
	}
	
	?>
	
	
		<tr class="text-center">
	<td style="font-weight:bold" > Record </td><td style="font-weight:bold;color:green"> PRESENT</td><td style="font-weight:bold;color:green;font-size:18px"><?php echo $count;?></td><td style="font-weight:bold"> ABSENT</td><td style="font-weight:bold;color:red;font-size:18px"><?php echo $count1 ;?></td><td></td>
	
	</tr>
	 </tbody>
    </table>
	
	</div>
	
	
	
	
	
	
	<?php
	break;
		case 24:
	
	$sch=$_POST['std'];
	$session=$_POST['year'];
	
	
	
	
	$sel="select * from  registration where application='$sch' and session='$session' and status='' ";
	
	$res=mysqli_query($conn,$sel);
	$sel1="select * from  registration where application='$sch' and session='$session' and status=''";
	
	$res1=mysqli_query($conn,$sel1);
	$row1=mysqli_num_rows($res1);
	if($row1==" ")
	{
		echo"<font color=red size=6pt>Not Admission Submit Or Invailid Session and Scholar Number.</font>";
	}
else
{
	
	?>
		<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr >
                <th style="text-align:center">Photo</th><th style="text-align:center">Sesion</th><th style="text-align:center">Name</th><th style="text-align:center">Father Name</th><th style="text-align:center">Mother Name</th><th style="text-align:center"> Class</th><th style="text-align:center">Address</th><th style="text-align:center">Admission Datetime</th>
            </tr>
        </thead>
<tfoot>
            <tr>
              <th style="text-align:center">Photo</th><th style="text-align:center">Session</th><th style="text-align:center">Name</th><th style="text-align:center">Father Name</th><th style="text-align:center">Mother Name</th><th style="text-align:center"> Class</th><th style="text-align:center">Address</th><th style="text-align:center">Admission Datetime</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  
	$s=1;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$vil=$row['village'];
		$dist=$row['dist'];
		$add=$vil." ".$dist;
		?>
		 
	<tr class="text-center">
	<td><img src="code/img/<?php echo $row['picture'];?>" height="60px" width="60px;"></td><td><?php echo $row['session'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['fname'];?></td><td><?php echo $row['mname'];?></td><td><?php echo $row['subject'];?></td><td><?php echo $add;?></td><td><?php echo $row['datetime'];?></td>
	
	
	</tr>
	<?php
	$s++;
	}
	?>
	 </tbody>
    </table>
	
	
	<?php
		
}

	
	break;
		case 73:
	$applicationr12=$_POST['scholer'];
	$session=$_POST['session'];
	
	
		$selr2="select * from  registration where sr ='$applicationr12' and session='$session' and status=''";
$resr2=mysqli_query($conn,$selr2);
$rowr2=mysqli_fetch_array($resr2,MYSQLI_BOTH);
$applicationr=$rowr2['application'];
	$selr="select * from  registration where application ='$applicationr' and session='$session' and status=''";
$resr=mysqli_query($conn,$selr);
$rowr=mysqli_fetch_array($resr,MYSQLI_BOTH);
$sessionr=$rowr['session'];
//echo $sessionr;
$applicationr=$rowr['application'];

$sel1="select * from  fees_paid where sch ='$applicationr' and session='$sessionr' and status=''";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
//$search=$row1['search'];
$sel="select * from  registration where application ='$applicationr' and session='$sessionr' and status=''";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);


$selb="select * from  registration where application ='$applicationr' and session='sessionr' and status='' order by id desc";
$resb=mysqli_query($conn,$selb);
$rowb=mysqli_fetch_array($resb,MYSQLI_BOTH);

$date=date("d/m/Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
?>
<html>
<head>
<style>
#name2
{
	font-weight:bold;
	font-size:12px;
}
#name3
{
    font-size:12px;
}
</style>

	
<script>

$(document).ready(function(){

	$("#print").click(function(){
		$("#pay").css("visibility","hidden");
		$("#back").css("visibility","hidden");
		$("#print").css("visibility","hidden");
		window.print();
		
	});
	$("#back").click(function(){
		window.location.href='student_showfees.php';
	});
});

</script>
<link href="css/student_print.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id='DivIdToPrint'  >
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo.png" height="70px" width="70px"/></span></td><td align="center"><span id="name"  style="font-size:20px;font-weight:bold">PARAMOUNT INTERNATIONAL SCHOOL </span><br/>Dhanauli , Doharighat Mau<br/><span id="name1" style="font-size:18px;font-weight:bold"></span></td><td style="font-size:14px"><b>Contact-</b>9473725359<br/>9696136245 </td>
</tr>
</table>
<table border="1px;" width="100%" cellspacing="0">
<caption style="font-size:18px;font-weight:bold">Fees Statement <?php echo $row1['session'];?></caption>
<tr>
<td width="30%"><span id="name2">Scho. Number</span></td><td><span id="name3"><?php echo $row['application'];?></span></td><td><b>Class</b></td><td><?php echo $row['subject'];?></td><td width="10%"align="right" rowspan="3"><span><img src="../code/img/<?php echo $row['picture'];?>" style="width:100%;" class="img-responsive" ></span></td>
</tr>
<tr>
<td width="30%"><span id="name2">Student Name</span></td><td width="" colspan="3"><span id="name3"><?php echo $row['name'];?></span></td>
</tr>
<tr>
<td width="30%"><span id="name2"> Father Name</span></td><td colspan="3"><span id="name3"><?php echo $row['fname'];?></span></td>
</tr>


</table>
<div class="table-responsive">
<table border="1px" width="100%" cellspacing="0px" >
<tr>
<td colspan='15' align="center"><span id="name4" style="font-size:18px;font-weight:bold">Fees Receipt</span></td>

</tr>
<tr align="center">

<td><span id="name2">Sr.</span></td>
<td><span id="name2">Month</span></td>
<td><span id="name2" >Tution Fee</span></td>
<td><span id="name2" >Conv Fee</span></td>
<td><span id="name2" >Exam</span></td>

<td><span id="name2">Other</span></td>
<td><span id="name2">Other Remark</span></td>
<td><span id="name2">Con</span></td>
<td><span id="name2">Cons Remark</span></td>
<td><span id="name2">Pre Dues</span></td>

<td><span id="name2">Paid</span></td>

<td><span id="name2">Dues</span></td>

<td><span id="name2">Date</span></td>
<td><span id="name2">Print</span></td>

</tr>
<?php

$sum=0;
$sum1=0;

$remain1=0;


$sel2="select * from  fees_paid where sch='$applicationr' and session='$sessionr' and status=''";
$res2=mysqli_query($conn,$sel2);
while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
{
	$tot=$row2['total'];
	$paid13=$row2['paid'];
	
	$remain12=$row2['remain'];
	$sum=$tot+$sum;
	$sum1=$paid13+$sum1;
	$remain1=$remain12+$remain1;
	$tags = explode(',',$row2['month']);
	$m='';
foreach($tags as $key) {    
     $key;    
	
	$sel4="select * from  plan where id ='$key'";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$m1=$row4['month'];
$m=$m1.','.$m;
}
?>
<tr align="center">

<td><span id="name3"><?php echo $row2['id'];?></span></td>
<td><span id="name3"><?php echo $m;?></span></td>
<td><span id="name3"><?php echo $row2['fees'];?></span></td>
<td><span id="name3"><?php echo $row2['conv'];?></span></td>
<td><span id="name3"><?php echo $row2['exam'];?></span></td>
<td><span id="name3"><?php echo $row2['other'];?></span></td>
<td><span id="name3"><?php echo $row2['remark'];?></span></td>
<td><span id="name3"><?php echo $row2['cons'];?></span></td>
<td ><span id="name3"><?php echo $row2['cons_remark'];?></span></td>
<td><span id="name3"><?php echo $row2['pre_dues'];?></span></td>

<td><span id="name3"><?php echo $row2['paid'];?></span></td>

<td><span id="name3"><?php echo $row2['remain'];?></span></td>
<?php $daten=$row2['date'];
$date1=date("d-m-Y",strtotime($daten));  ?>
<td><span id="name3"><?php echo $date1;?></span></td>
<td></td>

</tr>


<?php
}
?>
<tr align="center">

<td colspan="10" style="font-weight:bold;font-size:19px">Sub Total</td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2"><?php echo $sum1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2">
    <?php
    $sel23="select * from  studentfees where search='$applicationr' and year='$sessionr' and status='' order by id desc";
$res23=mysqli_query($conn,$sel23);
$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
	$remain23=$row23['remain'];
    
    
    echo $remain12;?></span></td>

</tr>
</table>
</div>
<table width="100%" frame="border" cellspacing="0">
<tr align="center">
<td width="50%"  align="left"><span id="name3" style="font-size:15px;font-weight:bold">Datetime</span></td>
</tr>
<tr>
<td  width="70%" align="left"><span ><?php echo $datetime;?></span></td><td><br/><br/></td><td width="50%" align="right"><span id="name3" style="font-size:15px;font-weight:bold" align="rightt">Sign Of Received Staff</span></td>
</tr>
</table>
</div>
<br/>
<br/><br/>


<input type='button' id='btn' value='Print' onclick='printDiv();'>
	  <script>
	function printDiv() 
{
var divToPrint=document.getElementById('DivIdToPrint');
var newWin=window.open('','Print-Window');
newWin.document.open();
newWin.document.write('<html><body onload="window.print()">'+divToPrint.innerHTML+'</body></html>');
newWin.document.close();

}
	
	</script>
</body>
</html>









<?php


	
	
	
	
	break;
	
}
?>