<?php

include("../link/databaseconnection.php");
$flag=$_REQUEST['flag'];
switch($flag)
{
case 1:
	$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'];
	
	
	$date=date("d-m-Y");
	date_default_timezone_set("asia/kolkata");
	$time=date("h:i:sa");
	$datetime=$date.$time;
	$ins="insert into fees(class,fees,reg,addm,ann,comp,gen,diary,tie,other,datetime) values('$class','$fees','$reg','$add','$ann','$comp','$gen','$diary','$tie','$other','$datetime')";
	if($res=mysqli_query($conn,$ins))
	{
		echo"submit";
		
	}
	else
	{
		echo"not submit";
	}
	
	break;
	//=============================================
	case 2:
	$conv=$_POST['conv'];
	$code=$_POST['code'];
	
	$villm=$_POST['vill'];
	$vill= strtoupper($villm);
	$ins="insert into convence(conv,vill,code) values('$conv','$vill','$code')";
	if($res=mysqli_query($conn,$ins))
	{
		echo"submit";
		
	}
	else
	{
		echo"not submit";
	}
	break;
	////////////////////////////////////
	case 3:
	
	?>
	

	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: ['copy', '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>Class</th><th>Monthly Fee</th><th>Registraion</th><th>Admission</th><th>Annual</th><th>Computer</th><th>Generator</th><th>Diary</th><th>Tie+Belt</th><th>Other</th><th>Delete</th>
            </tr>
        </thead>
<tfoot>
            <tr>
                <th>Sr.</th><th>Class</th><th>Monthly Fee</th><th>Registraion</th><th>Admission</th><th>Annual</th><th>Computer</th><th>Generator</th><th>Diary</th><th>Tie+Belt</th><th>Other</th><th>Delete</th>
            </tr>
        </tfoot>
<tbody>		
  <?php
  $sel="select * from fees";
	$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['class'];?></td><td><?php echo $row['fees'];?></td><td><?php echo $row['reg'];?></td><td><?php echo $row['addm'];?></td><td><?php echo $row['ann'];?></td><td><?php echo $row['comp'];?></td><td><?php echo $row['gen'];?></td>
	<td><?php echo $row['diary'];?></td><td><?php echo $row['tie'];?></td><td><?php echo $row['other'];?></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 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: ['copy', '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>Village</th><th>Conveyance Charge</th><th>Code</th><th>Delete</th>
            </tr>
        </thead>
<tfoot>
            <tr>
               <th>Sr.</th><th>Village</th><th>Conveyance Charge</th><th>Code</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['vill'];?></td><td><?php echo $row['conv'];?></td><td><?php echo $row['code'];?></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;
}
?>