|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.60 Web Server : LiteSpeed System : Linux in-mum-web1259.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u490972518 ( 490972518) PHP Version : 5.6.40 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : ON | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u490972518/domains/ppschool.org.in/public_html/code/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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'];
$session=$_POST['session'];
$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,session) values('$class','$fees','$reg','$add','$ann','$comp','$gen','$diary','$tie','$other','$datetime','$session')";
if($res=mysqli_query($conn,$ins))
{
echo"submit";
}
else
{
echo"not submit";
}
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: ['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>Session</th><th>Class</th><th>Tution Fee</th><th>Registraion</th><th>Miscellaneous</th><th>Annual New</th><th>Computer</th><th>Generator</th><th>Annual Old</th><th>Tie+Belt</th><th>Other</th><th>Edit</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Session</th><th>Class</th><th>Tution Fee</th><th>Registraion</th><th>Miscellaneous</th><th>Annual New</th><th>Computer</th><th>Generator</th><th>Annual Old</th><th>Tie+Belt</th><th>Other</th><th>Edit</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['session'];?></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="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 31:
?>
<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>Annual Charge Old</th><th>Tie+Belt</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>Annual Charge Old</th><th>Tie+Belt</th>
</tr>
</tfoot>
<tbody>
<?php
$session=$_POST['session'];
$sel="select * from fees where session='$session'";
$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>
</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>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;
}
?>