|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.20 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/ppsj/css/../admin/temp/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<html>
<head>
<?php include("../link/admin_headconnection.php");
include("../link/databaseconnection.php");
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:index.php");
}
$session1=$_POST['session'];
$_SESSION['admin1']=$session1;
$lg1=$session1;
if(!$lg1)
{
header("location:http://gcschool.co.in/admin/balance1.php");
}
?>
<link href="../css/dashboard.css" rel="stylesheet" type="text/css"/>
<link href="../css/dashboardmenu.css" rel="stylesheet" type="text/css"/>
<link href="../css/student_details_side_menu.css" rel="stylesheet" type="text/css"/>
<link href="../css/student_details.css" rel="stylesheet" type="text/css"/>
<style>
<link href="../css/student_details.css" rel="stylesheet" type="text/css"/>
.work
{
min-height:200px;
}
.gap
{
height:100px;
}
</style>
<link href="jq/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="jq/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
<script src="jq/jquery.dataTables.min.js"></script>
<script src="jq/dataTables.buttons.min.js"></script>
<script src="jq/buttons.flash.min.js"></script>
<script src="jq/jszip.min.js"></script>
<script src="jq/pdfmake.min.js"></script>
<script src="jq/vfs_fonts.js"></script>
<script src="jq/buttons.html5.min.js"></script>
<script src="jq/buttons.print.min.js"></script>
<script>
///for application
$(document).ready(function(){
$("#myform21").submit(function(e){
e.preventDefault();
$.ajax({
url:"../code/student_detailscode.php?flag=36",
type:"POST",
data: new FormData(this),
contentType:false,
processData:false,
success:function(res){
//alert(res);
$("#modal").html(res);
},
error:function(){
alert("error");
}
});
});
});
///for application
//FEES UPDATE ///
function feesupdate(form)
{
var app=$("#application").val();
var a=confirm("Are you Sure");
if(a==true)
{
$.ajax({
url:"../code/student_detailscode.php?flag=43",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
// cache:false,
success:function(res){
alert(res);
$("#editmodel89").modal("hide");
var b=confirm(" Dues Paid ! Print Slip");
if(b==true)
{
/////FOR FEES slip new
//alert(application);
$("#editbody12111").load("../code/student_detailscode.php?flag=72&app="+app);
$("#editmodel12111").modal("show");
// printDiv1();
/////FOR FEES slip new
}
},
error:function(){
alert("error");
}
});
}
return false;
}
function dues123(application)
{
//alert(application);
$("#editmodel89").modal("show");
$("#editbody89").load("../code/student_detailscode.php?flag=42&application="+application);
}
//FEES UPDATE ///
function editrow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=3&id="+id);
}
function transferrow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=31&id="+id);
}
/////FOR FEES DETAILS
function app1234(id)
{
//alert(application);
$("#editmodel120").modal("show");
$("#editbody120").load("../code/student_detailscode.php?flag=71&id="+id);
}
/////FOR FEES slip new
function app12345(id)
{
//alert(application);
$("#editmodel120").modal("show");
$("#editbody120").load("../code/student_detailscode.php?flag=72&id="+id);
}
/////FOR FEES slip new
function feesrow(id)
{
//alert(id);
$("#editmodel121").modal("show");
$("#editbody121").load("../code/student_detailscode.php?flag=9&id="+id);
}
//===message==//
function messagerow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=7&id="+id);
}
function app12(application)
{
// alert(application);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=34&application="+application);
}
function app123(application)
{
//alert(application);
$("#editmodel125").modal("show");
$("#editbody125").load("../code/student_detailscode.php?flag=27&application="+application);
}
/////FOR FEES slip new
function app12345(id)
{
//alert(application);
$("#editmodel120").modal("show");
$("#editbody120").load("../code/student_detailscode.php?flag=72&id="+id);
}
/////FOR FEES slip new
$(document).ready(function(){
///$("#modal").load("../code/student_detailscode.php?flag=36");
});
//== message==///
function deleterow(id)
{
//alert(id);
var a=confirm("Are you Sure");
if(a==true)
{
$.ajax({
url:"../code/student_detailscode.php?flag=2",
type:"POST",
data:{rowid:id},
success:function(res){
//alert(res);
//$("#modal").html(res);
$("#myform21").submit();
},
error:function(){
alert("error");
}
});
}
}
$(document).ready(function(){
//$("#modal").load("../code/student_detailscode.php?flag=1");
});
function updaterow(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=4",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
cache:false,
success:function(res){
alert(res);
if(res=="ok")
{
$("#editmodel12").modal("hide");
$("#myform21").submit();
}
},
error:function(){
alert("error");
}
});
return false;
}
////
function changerow(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=32",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
cache:false,
success:function(res){
alert(res);
if(res=="Transfered")
{
$("#editmodel12").modal("hide");
}
},
error:function(){
alert("error");
}
});
return false;
}
///
function result(id)
{
$("#editmodel").modal("show");
$("#editbody").load("../code/student_detailscode.php?flag=5&id="+id);
}
function go()
{
alert("ok");
$("#editmodel12").modal("show");
}
function data(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=6",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
alert(res);
if(res=="ok")
{
$("#editmodel").modal("hide");
}
},
error:function(){
alert("error");
}
});
return false;
}
function go(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=35",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
$("#editmodel").modal("hide");
},
error:function(){
alert("error");
}
});
return false;
}
function feesdata(form)
{
var app=$("#app").val();
var a=confirm("Are you Sure");
if(a==true)
{
$("#btn").prop("disabled",true);
$.ajax({
url:"../code/student_detailscode.php?flag=10",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
// alert(res);
$("#editmodel121").modal("hide");
var b=confirm(" Fees Submitted ! Print Slip");
if(b==true)
{
/////FOR FEES slip new
//alert(application);
$("#editbody12111").load("../code/student_detailscode.php?flag=72&app="+app);
$("#editmodel12111").modal("show");
// printDiv1();
/////FOR FEES slip new
}
},
error:function(){
alert("error");
}
});
}
return false;
}
</script>
<script>
function feesdatanew(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=47",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
alert(res);
$("#editmodel125").modal("hide");
},
error:function(){
alert("error");
}
});
return false;
}
</script>
</head>
<body>
<div class="container-fluid">
<div class="row">
<?php include("../link/admin_dashboardmenu .php");?>
</div>
<div class="row">
<!--menu-->
<div class="col-sm-2">
<?php include("../link/student_details_side_menu.php");?>
</div>
<!--menu--close-->
<div class="col-sm-10">
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-heading"><center><span style="font-size:25px">TOTAL FEES AND CONVENIENCE </span></center></div>
<div class="panel-body">
<div class="row">
<?php
$sel="select * from registration where session='$session1' and code!='' and subject='PLAY GROUP'";
$res=mysqli_query($conn,$sel);
$s=0;
while( $row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$code1=$row['code'];
//echo $code1;
$selv="select * from convence where session='$session1' and code='$code1'";
$resv=mysqli_query($conn,$selv);
$rowv=mysqli_fetch_array($resv,MYSQLI_BOTH);
$codev=$rowv['conv'];
$s=$s+$codev;
// echo $s;
}
$selo="select * from registration where session='$session1' and subject='PLAY GROUP'";
$reso=mysqli_query($conn,$selo);
$so=0;
while( $rowo=mysqli_fetch_array($reso,MYSQLI_BOTH))
{
$selw="select * from fees where session='$session1' and class='PLAY GROUP'";
$resw=mysqli_query($conn,$selw);
$roww=mysqli_fetch_array($resw,MYSQLI_BOTH);
$feesw=$roww['fees'];
$so=$so+$feesw;
// echo $s;
}
//// NURSERY
?>
<div class="col-sm-3" style="background-color:#00695c;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">PLAY GROUP</H5>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-   <?php echo $s;?><br/><br/><BR/>Fees Total-   <?php echo $so;?></h6>
<center><a href='balanceshow.php?flag=PLAY GROUP'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#2BBBAD;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">NURSERY</H5>
<?php
$seln="select * from registration where session='$session1' and code!='' and subject='NURSERY'";
$resn=mysqli_query($conn,$seln);
$sn=0;
while( $rown=mysqli_fetch_array($resn,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$coden1=$rown['code'];
//echo $code1;
$selvn="select * from convence where session='$session1' and code='$coden1'";
$resvn=mysqli_query($conn,$selvn);
$rowvn=mysqli_fetch_array($resvn,MYSQLI_BOTH);
$codevn=$rowvn['conv'];
$sn=$sn+$codevn;
// echo $s;
}
$selon="select * from registration where session='$session1' and subject='NURSERY'";
$reson=mysqli_query($conn,$selon);
$son=0;
while( $rowon=mysqli_fetch_array($reson,MYSQLI_BOTH))
{
$selwn="select * from fees where session='$session1' and class='NURSERY'";
$reswn=mysqli_query($conn,$selwn);
$rowwn=mysqli_fetch_array($reswn,MYSQLI_BOTH);
$feeswn=$rowwn['fees'];
$son=$son+$feeswn;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sn;?><br/><BR/><br/>Fees Total -   <?php echo $son;?></h6>
<center><a href='balanceshow.php?flag=NURSERY'><button>Conv Students Show</button></a> </center>
</div>
<div class="col-sm-3" style="background-color:#0099CC;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">LKG</H5>
</center>
<?php
$sell="select * from registration where session='$session1' and code!='' and subject='LKG'";
$resl=mysqli_query($conn,$sell);
$sl=0;
while( $rowl=mysqli_fetch_array($resl,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codel1=$rowl['code'];
//echo $code1;
$selvl="select * from convence where session='$session1' and code='$codel1'";
$resvl=mysqli_query($conn,$selvl);
$rowvl=mysqli_fetch_array($resvl,MYSQLI_BOTH);
$codevl=$rowvl['conv'];
$sl=$sl+$codevl;
// echo $s;
}
$selol="select * from registration where session='$session1' and subject='LKG'";
$resol=mysqli_query($conn,$selol);
$sol=0;
while( $rowol=mysqli_fetch_array($resol,MYSQLI_BOTH))
{
$selwl="select * from fees where session='$session1' and class='LKG'";
$reswl=mysqli_query($conn,$selwl);
$rowwl=mysqli_fetch_array($reswl,MYSQLI_BOTH);
$feeswl=$rowwl['fees'];
$sol=$sol+$feeswl;
// echo $s;
}
//// NURSERY
?>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sl;?><br/><BR/><br/>Fees Total -    <?php echo $sol;?></h6>
<center><a href='balanceshow.php?flag=LKG'><button>Conv Students Show</button></a></a> </center>
</div>
<div class="col-sm-3" style="background-color:green;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">UKG</H5>
<?php
$selu="select * from registration where session='$session1' and code!='' and subject='UKG'";
$resu=mysqli_query($conn,$selu);
$su=0;
while( $rowu=mysqli_fetch_array($resu,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codeu1=$rowu['code'];
//echo $code1;
$selvu="select * from convence where session='$session1' and code='$codeu1'";
$resvu=mysqli_query($conn,$selvu);
$rowvu=mysqli_fetch_array($resvu,MYSQLI_BOTH);
$codevu=$rowvu['conv'];
$su=$su+$codevu;
// echo $s;
}
$selou="select * from registration where session='$session1' and subject='UKG'";
$resou=mysqli_query($conn,$selou);
$sou=0;
while( $rowou=mysqli_fetch_array($resou,MYSQLI_BOTH))
{
$selwu="select * from fees where session='$session1' and class='UKG'";
$reswu=mysqli_query($conn,$selwu);
$rowwu=mysqli_fetch_array($reswu,MYSQLI_BOTH);
$feeswu=$rowwu['fees'];
$sou=$sou+$feeswu;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $su;?><br/><BR/><br/>Fees Total -    <?php echo $sou;?></h6>
<center><a href='balanceshow.php?flag=UKG'><button>Conv Students Show</button></a></center>
</div>
</div>
<BR/>
<div class="row">
<div class="col-sm-3" style="background-color:#00695c;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">FIRST</H5>
<?php
$self="select * from registration where session='$session1' and code!='' and subject='FIRST'";
$resf=mysqli_query($conn,$self);
$sf=0;
while( $rowf=mysqli_fetch_array($resf,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codef1=$rowf['code'];
//echo $code1;
$selvf="select * from convence where session='$session1' and code='$codef1'";
$resvf=mysqli_query($conn,$selvf);
$rowvf=mysqli_fetch_array($resvf,MYSQLI_BOTH);
$codevf=$rowvf['conv'];
$sf=$sf+$codevf;
// echo $s;
}
$selof="select * from registration where session='$session1' and subject='FIRST'";
$resof=mysqli_query($conn,$selof);
$sof=0;
while( $rowof=mysqli_fetch_array($resof,MYSQLI_BOTH))
{
$selwf="select * from fees where session='$session1' and class='FIRST'";
$reswf=mysqli_query($conn,$selwf);
$rowwf=mysqli_fetch_array($reswf,MYSQLI_BOTH);
$feeswf=$rowwf['fees'];
$sof=$sof+$feeswf;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sf;?><br/><BR/><br/>Fees Total -    <?php echo $sof;?></h6>
<center><a href='balanceshow.php?flag=FIRST'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#2BBBAD;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">SECOND</H5>
<?php
$sels1="select * from registration where session='$session1' and code!='' and subject='SECOND'";
$ress1=mysqli_query($conn,$sels1);
$ss1=0;
while( $rows1=mysqli_fetch_array($ress1,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codes11=$rows1['code'];
//echo $code1;
$selvs1="select * from convence where session='$session1' and code='$codes11'";
$resvs1=mysqli_query($conn,$selvs1);
$rowvs1=mysqli_fetch_array($resvs1,MYSQLI_BOTH);
$codevs1=$rowvs1['conv'];
$ss1=$ss1+$codevs1;
// echo $s;
}
$selos1="select * from registration where session='$session1' and subject='SECOND'";
$resos1=mysqli_query($conn,$selos1);
$sos1=0;
while( $rowos1=mysqli_fetch_array($resos1,MYSQLI_BOTH))
{
$selws1="select * from fees where session='$session1' and class='SECOND'";
$resws1=mysqli_query($conn,$selws1);
$rowws1=mysqli_fetch_array($resws1,MYSQLI_BOTH);
$feesws1=$rowws1['fees'];
$sos1=$sos1+$feesws1;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $ss1;?><br/><BR/><br/>Fees Total -    <?php echo $sos1;?></h6>
<center><a href='balanceshow.php?flag=SECOND'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#0099CC;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">THIRD</H5>
<?php
$selt="select * from registration where session='$session1' and code!='' and subject='THIRD'";
$rest=mysqli_query($conn,$selt);
$st=0;
while( $rowt=mysqli_fetch_array($rest,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codet1=$rowt['code'];
//echo $code1;
$selvt="select * from convence where session='$session1' and code='$codet1'";
$resvt=mysqli_query($conn,$selvt);
$rowvt=mysqli_fetch_array($resvt,MYSQLI_BOTH);
$codevt=$rowvt['conv'];
$st=$st+$codevt;
// echo $s;
}
$selot1="select * from registration where session='$session1' and subject='THIRD'";
$resot1=mysqli_query($conn,$selot1);
$nh=mysqli_num_rows($resot1);
// echo $nh;
$nh1= $nh*480;
$sot=0;
while( $rowot1=mysqli_fetch_array($resot1,MYSQLI_BOTH))
{
$selwt="select * from fees where session='$session1' and class='THIRD'";
$reswt=mysqli_query($conn,$selwt);
$rowwt=mysqli_fetch_array($reswt,MYSQLI_BOTH);
$feeswt=$rowwt['fees'];
$sot=$sot+$feesw;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $st;?><br/><BR/><br/>Fees Total -    <?php echo $nh1;?></h6>
<center><a href="balanceshow.php?flag=THIRD & flag1=$session1" ><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:green;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">FOURTH</H5>
<?php
$self1="select * from registration where session='$session1' and code!='' and subject='FOURTH'";
$resf1=mysqli_query($conn,$self1);
$sf1=0;
while( $rowf1=mysqli_fetch_array($resf1,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codef11=$rowf1['code'];
//echo $code1;
$selvf1="select * from convence where session='$session1' and code='$codef11'";
$resvf1=mysqli_query($conn,$selvf1);
$rowvf1=mysqli_fetch_array($resvf1,MYSQLI_BOTH);
$codevf1=$rowvf1['conv'];
$sf1=$sf1+$codevf1;
// echo $s;
}
$selof1="select * from registration where session='$session1' and subject='FOURTH'";
$resof1=mysqli_query($conn,$selof1);
$sof1=0;
while( $rowof1=mysqli_fetch_array($resof1,MYSQLI_BOTH))
{
$selwf1="select * from fees where session='$session1' and class='FOURTH'";
$reswf1=mysqli_query($conn,$selwf1);
$rowwf1=mysqli_fetch_array($reswf1,MYSQLI_BOTH);
$feeswf1=$rowwf1['fees'];
$sof1=$sof1+$feeswf1;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sf1;?><br/><BR/><br/>Fees Total -    <?php echo $sof1;?></h6>
<center><a href='balanceshow.php?flag=FOURTH'><button>Conv Students Show</button></a></center>
</div>
</div>
<BR/>
<div class="row">
<div class="col-sm-3" style="background-color:#00695c;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">FIFTH</H5>
<?php
$self12="select * from registration where session='$session1' and code!='' and subject='FIFTH'";
$resf12=mysqli_query($conn,$self12);
$sf12=0;
while( $rowf12=mysqli_fetch_array($resf12,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codef121=$rowf12['code'];
//echo $code1;
$selvf12="select * from convence where session='$session1' and code='$codef121'";
$resvf12=mysqli_query($conn,$selvf12);
$rowvf12=mysqli_fetch_array($resvf12,MYSQLI_BOTH);
$codevf12=$rowvf12['conv'];
$sf12=$sf12+$codevf12;
// echo $s;
}
$selof12="select * from registration where session='$session1' and subject='FIFTH'";
$resof12=mysqli_query($conn,$selof12);
$sof12=0;
while( $rowof12=mysqli_fetch_array($resof12,MYSQLI_BOTH))
{
$selwf12="select * from fees where session='$session1' and class='FIFTH'";
$reswf12=mysqli_query($conn,$selwf12);
$rowwf12=mysqli_fetch_array($reswf12,MYSQLI_BOTH);
$feeswf12=$rowwf12['fees'];
$sof12=$sof12+$feeswf12;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sf12;?><br/><BR/><br/>Fees Total -    <?php echo $sof12;?></h6>
<center><a href='balanceshow.php?flag=FIFTH'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#2BBBAD;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">SIXTH</H5>
<?php
$self12s="select * from registration where session='$session1' and code!='' and subject='SIXTH'";
$resf12s=mysqli_query($conn,$self12s);
$sf12s=0;
while( $rowf12s=mysqli_fetch_array($resf12s,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codef121s=$rowf12s['code'];
//echo $code1;
$selvf12s="select * from convence where session='$session1' and code='$codef121s'";
$resvf12s=mysqli_query($conn,$selvf12s);
$rowvf12s=mysqli_fetch_array($resvf12s,MYSQLI_BOTH);
$codevf12s=$rowvf12s['conv'];
$sf12s=$sf12s+$codevf12s;
// echo $s;
}
$selof12s="select * from registration where session='$session1' and subject='SIXTH'";
$resof12s=mysqli_query($conn,$selof12s);
$nh4=mysqli_num_rows($resof12s);
// echo $nh4;
$nh6= $nh4*600;
$sof12s=0;
while( $rowof12s=mysqli_fetch_array($resof12s,MYSQLI_BOTH))
{
$selwf12s="select * from fees where session='$session1' and class='SIXTH'";
$reswf12s=mysqli_query($conn,$selwf12s);
$rowwf12s=mysqli_fetch_array($reswf12s,MYSQLI_BOTH);
$feeswf12s=$rowwf12s['fees'];
$sof12s=$sof12s+$feeswf12;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sf12s;?><br/><BR/><br/>Fees Total -    <?php echo $nh6;?></h6>
<center><a href='balanceshow.php?flag=SIXTH'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#0099CC;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">SEVENTH</H5>
<?php
$sels3="select * from registration where session='$session1' and code!='' and subject='SEVENTH'";
$ress3=mysqli_query($conn,$sels3);
$ss3=0;
while( $rows3=mysqli_fetch_array($ress3,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codes31=$rows3['code'];
//echo $code1;
$selvs3="select * from convence where session='$session1' and code='$codes31'";
$resvs3=mysqli_query($conn,$selvs3);
$rowvs3=mysqli_fetch_array($resvs3,MYSQLI_BOTH);
$codevs3=$rowvs3['conv'];
$ss3=$ss3+$codevs3;
// echo $s;
}
$selos3="select * from registration where session='$session1' and subject='SEVENTH'";
$resos3=mysqli_query($conn,$selos3);
$sos3=0;
while( $rowos3=mysqli_fetch_array($resos3,MYSQLI_BOTH))
{
$selws3="select * from fees where session='$session1' and class='SEVENTH'";
$resws3=mysqli_query($conn,$selws3);
$rowws3=mysqli_fetch_array($resws3,MYSQLI_BOTH);
$feesws3=$rowws3['fees'];
$sos3=$sos3+$feesws3;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $ss3;?><br/><BR/><br/>Fees Total -    <?php echo $sos3;?></h6>
<center><a href='balanceshow.php?flag=SEVENTH'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:green;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">EIGHTH</H5>
<?php
$sele2="select * from registration where session='$session1' and code!='' and subject='EIGHTH'";
$rese2=mysqli_query($conn,$sele2);
$se2=0;
while( $rowe2=mysqli_fetch_array($rese2,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codee21=$rowe2['code'];
//echo $code1;
$selve2="select * from convence where session='$session1' and code='$codee21'";
$resve2=mysqli_query($conn,$selve2);
$rowve2=mysqli_fetch_array($resve2,MYSQLI_BOTH);
$codeve2=$rowve2['conv'];
$se2=$se2+$codeve2;
// echo $s;
}
$seloe2="select * from registration where session='$session1' and subject='EIGHTH'";
$resoe2=mysqli_query($conn,$seloe2);
$soe2=0;
while( $rowoe2=mysqli_fetch_array($resoe2,MYSQLI_BOTH))
{
$selwe2="select * from fees where session='$session1' and class='EIGHTH'";
$reswe2=mysqli_query($conn,$selwe2);
$rowwe2=mysqli_fetch_array($reswe2,MYSQLI_BOTH);
$feeswe2=$rowwe2['fees'];
$soe2=$soe2+$feeswe2;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $se2;?><br/><BR/><br/>Fees Total -    <?php echo $soe2;?></h6>
<center><a href='balanceshow.php?flag=EIGHTH'><button>Conv Students Show</button></a></center>
</div>
</div>
<br/>
<div class="row">
<div class="col-sm-3" style="background-color:#00695c;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">NINTH CBSE</H5>
<?php
$sely="select * from registration where session='$session1' and code!='' and subject='NINTH CBSE'";
$resy=mysqli_query($conn,$sely);
$sny=0;
while( $rowy=mysqli_fetch_array($resy,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codey=$rowy['code'];
//echo $code1;
$selvy="select * from convence where session='$session1' and code='$codey'";
$resvy=mysqli_query($conn,$selvy);
$rowvy=mysqli_fetch_array($resvy,MYSQLI_BOTH);
$convy=$rowvy['conv'];
$sny=$sny+$convy;
// echo $s;
}
$seloy="select * from registration where session='$session1' and subject='NINTH CBSE'";
$resoy=mysqli_query($conn,$seloy);
$sony=0;
while( $rowoy=mysqli_fetch_array($resoy,MYSQLI_BOTH))
{
$selwy="select * from fees where session='$session1' and class='NINTH CBSE'";
$reswy=mysqli_query($conn,$selwy);
$rowwy=mysqli_fetch_array($reswy,MYSQLI_BOTH);
$feeswy=$rowwy['fees'];
$sony=$sony+$feeswy;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sny;?><br/><BR/><br/>Fees Total -    <?php echo $sony;?></h6>
<center><a href='balanceshow.php?flag=NINTH CBSE'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#2BBBAD;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">TENTH</H5>
<?php
$sely1="select * from registration where session='$session1' and code!='' and subject='TENTH'";
$resy1=mysqli_query($conn,$sely1);
$sny1=0;
while( $rowy1=mysqli_fetch_array($resy1,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$codey1=$rowy1['code'];
//echo $code1;
$selvy1="select * from convence where session='$session1' and code='$codey1'";
$resvy1=mysqli_query($conn,$selvy1);
$rowvy1=mysqli_fetch_array($resvy1,MYSQLI_BOTH);
$convy1=$rowvy1['conv'];
$sny1=$sny1+$convy1;
// echo $s;
}
$seloy1="select * from registration where session='$session1' and subject='TENTH'";
$resoy1=mysqli_query($conn,$seloy1);
$sony1=0;
while( $rowoy1=mysqli_fetch_array($resoy1,MYSQLI_BOTH))
{
$selwy1="select * from fees where session='$session1' and class='TENTH'";
$reswy1=mysqli_query($conn,$selwy1);
$rowwy1=mysqli_fetch_array($reswy1,MYSQLI_BOTH);
$feeswy1=$rowwy1['fees'];
$sony1=$sony1+$feeswy1;
// echo $s;
}
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Total-    <?php echo $sny1;?><br/><BR/><br/>Fees Total -    <?php echo $sony1;?></h6>
<center><a href='balanceshow.php?flag=TENTH'><button>Conv Students Show</button></a></center>
</div>
<div class="col-sm-3" style="background-color:#0099CC;height:170px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">FREE </H5>
<?php
$selyf="select * from free where session='$session1' and fee='YES' ";
$resyf=mysqli_query($conn,$selyf);
$nuf=mysqli_num_rows($resyf);
// echo $nuf;
$snyf=0;
while( $rowyf=mysqli_fetch_array($resyf,MYSQLI_BOTH))
{
//$fee=$row['fee'];
// echo $sch;
// $codey=$rowy['code'];
$class2=$rowyf['class'];
//echo $code1;
$selvyf="select * from fees where session='$session1' and class='$class2'";
$resvyf=mysqli_query($conn,$selvyf);
$rowvyf=mysqli_fetch_array($resvyf,MYSQLI_BOTH);
$convyf=$rowvyf['fees'];
$snyf=$snyf+$convyf;
// echo $s;
}
//// for fix
$selyfg="select * from free where session='$session1' ";
$resyfg=mysqli_query($conn,$selyfg);
$nufg=mysqli_num_rows($resyfg);
// echo $nuf;
$snyfg=0;
while( $rowyfg=mysqli_fetch_array($resyfg,MYSQLI_BOTH))
{
//$fee=$row['fee'];
// echo $sch;
// $codey=$rowy['fix'];
$fix2=$rowyfg['fix'];
//echo $code1;
$snyfg=$snyfg+$fix2;
// echo $s;
}
$selyfb="select * from free where session='$session1' and conv='YES' ";
$resyfb=mysqli_query($conn,$selyfb);
$nufb=mysqli_num_rows($resyfb);
// echo $nufb;
// echo '<br/>';
$snyfb=0;
while( $rowyfb=mysqli_fetch_array($resyfb,MYSQLI_BOTH))
{
$sch=$rowyfb['sch'];
// echo $sch;
// echo '<br/>';
// $codey=$rowy['code'];
$class2=$rowyfb['class'];
//echo $code1;
$selvyfb="select * from registration where session='$session1' and application='$sch'";
$resvyfb=mysqli_query($conn,$selvyfb);
$rowvyfb=mysqli_fetch_array($resvyfb,MYSQLI_BOTH);
$codef=$rowvyfb['code'];
$selvy1b="select * from convence where session='$session1' and code='$codef'";
$resvy1b=mysqli_query($conn,$selvy1b);
$rowvy1b=mysqli_fetch_array($resvy1b,MYSQLI_BOTH);
$convy1b=$rowvy1b['conv'];
$snyfb=$snyfb+$convy1b;
// echo $s;
}
// echo $snyfb;
$seloy="select * from registration where session='$session1' and subject='NINTH CBSE'";
$resoy=mysqli_query($conn,$seloy);
//// NURSERY
?>
</center>
<h6 style="font-weight:bold;color:white">Conv Free Total-    <?php echo $snyfb;?><br/><BR/>Fees Free Total -    <?php echo $snyf;?><br/><br/>Cons-Fixed -      <?php echo $snyfg;?></h6>
<center><hr/></center>
<p style="font-weight:bold;color:white"> Total-        <?php echo $snyfb + $snyf + $snyfg;?></p>
</div>
<div class="col-sm-3" style="background-color:green;height:150px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">CALCULATION</H5>
<?php
$sele2r="select * from registration where session='$session1' and code!='' ";
$rese2r=mysqli_query($conn,$sele2r);
$se2r=0;
while( $rowe2r=mysqli_fetch_array($rese2r,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$code2r=$rowe2r['code'];
//echo $code1;
$selve2r="select * from convence where session='$session1' and code='$codee21'";
$resve2r=mysqli_query($conn,$selve2r);
$rowve2r=mysqli_fetch_array($resve2r,MYSQLI_BOTH);
$codeve2r=$rowve2r['conv'];
$se2r=$se2r+$codeve2r;
// echo $s;
}
$seloe2r="select * from registration where session='$session1' ";
$resoe2r=mysqli_query($conn,$seloe2r);
$soe2r=0;
while( $rowoe2r=mysqli_fetch_array($resoe2r,MYSQLI_BOTH))
{
$class23r=$rowoe2r['subject'];
$selwe2r="select * from fees where class='$class23r'";
$reswe2r=mysqli_query($conn,$selwe2r);
$rowwe2r=mysqli_fetch_array($reswe2r,MYSQLI_BOTH);
$feeswe2r=$rowwe2r['fees'];
$soe2r=$soe2r+$feeswe2r;
// echo $s;
}
//// NURSERY
?>
</center>
<h5 style="font-weight:bold;color:white">Conv Total-    <?php echo $s+$sn+$sl+$su+$sf+$ss1+$st+$sf1+$sf12+$sf12s+$ss3+$se2+$sny+$sny1.' - '. $snyfb;?> <br/><BR/><br/>Fees Total -    <?php echo $so+$son+$sol+$sou+$sof+$sos1+$nh1+$sof1+$sof12+$nh6+$sos3+$soe2+$sony+$sony1.' - '. $snyf;?></h5>
</div>
</div>
<br/>
<div class='row'>
<div class="col-sm-6" style="background-color:00695c;height:350px">
<center> <H5 style="color:white;font-weight:bold;background-color:red">TOTAL</H5>
<?php
$sele2r="select * from registration where session='$session1' and code!='' ";
$rese2r=mysqli_query($conn,$sele2r);
$se2r=0;
while( $rowe2r=mysqli_fetch_array($rese2r,MYSQLI_BOTH))
{
//$sch=$row['code'];
// echo $sch;
$code2r=$rowe2r['code'];
//echo $code1;
$selve2r="select * from convence where session='$session1' and code='$codee21'";
$resve2r=mysqli_query($conn,$selve2r);
$rowve2r=mysqli_fetch_array($resve2r,MYSQLI_BOTH);
$codeve2r=$rowve2r['conv'];
$se2r=$se2r+$codeve2r;
// echo $s;
}
$seloe2r="select * from registration where session='$session1' ";
$resoe2r=mysqli_query($conn,$seloe2r);
$soe2r=0;
while( $rowoe2r=mysqli_fetch_array($resoe2r,MYSQLI_BOTH))
{
$class23r=$rowoe2r['subject'];
$selwe2r="select * from fees where class='$class23r'";
$reswe2r=mysqli_query($conn,$selwe2r);
$rowwe2r=mysqli_fetch_array($reswe2r,MYSQLI_BOTH);
$feeswe2r=$rowwe2r['fees'];
$soe2r=$soe2r+$feeswe2r;
// echo $s;
}
//// NURSERY
?>
</center>
<h4 style="font-weight:bold;color:white">Conv Total-    <?php echo $s+$sn+$sl+$su+$sf+$ss1+$st+$sf1+$sf12+$sf12s+$ss3+$se2+$sny+$sny1-$snyfb;?><br/><BR/><br/>Fees Total -    <?php echo $so+$son+$sol+$sou+$sof+$sos1+$nh1+$sof1+$sof12+$nh6+$sos3+$soe2+$sony+$sony1-$snyf;?></h4>
<center><hr/></center>
<h4 style="font-weight:bold;color:white"> Total-       <?php echo $s+$sn+$sl+$su+$sf+$ss1+$st+$sf1+$sf12+$sf12s+$ss3+$se2+$sny+$sny1+$so+$son+$sol+$sou+$sof+$sos1+$nh1+$sof1+$sof12+$nh6+$sos3+$soe2+$sony+$sony1-$snyfb-$snyf;?></h4>
<center><hr/></center>
<h4 style="font-weight:bold;color:white"> Balance-          <?php echo $s+$sn+$sl+$su+$sf+$ss1+$st+$sf1+$sf12+$sf12s+$ss3+$se2+$sny+$sny1+$so+$son+$sol+$sou+$sof+$sos1+$nh1+$sof1+$sof12+$nh6+$sos3+$soe2+$sony+$sony1-$snyfb-$snyf;?><br/><br/>Cons Fixed-         <?php echo $snyfg ;?></h4>
<center><hr/></center>
<h4 style="font-weight:bold;color:white;background-color:red"> Net Balance-         <?php echo $s+$sn+$sl+$su+$sf+$ss1+$st+$sf1+$sf12+$sf12s+$ss3+$se2+$sny+$sny1+$so+$son+$sol+$sou+$sof+$sos1+$nh1+$sof1+$sof12+$nh6+$sos3+$soe2+$sony+$sony1-$snyfb-$snyf-$snyfg;?></h4>
</div>
</div>
</form>
<br/>
<div id="modal"></div>
</div>
</div>
</div>
</div>
<br/>
<br/>
<div id="show" style="display:none"></div>
</div>
<!-- modal for result-->
<div class="modal fade" id="editmodel">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> Load Data </h2> </center>
</div>
<div class="modal-body" id="editbody">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- modal for result-->
<!-- modal for result-->
<div class="modal fade" id="editmodel234">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> Fill Data</h2> </center>
</div>
<div class="modal-body" id="editbody1234">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- modal for result-->
<div class="modal fade" id="editmodel12">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> SLIP PRINT </h2> </center>
</div>
<div class="modal-body" id="editbody12">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<div class="modal fade bs-example-modal-lg" id="editmodel121">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-heading">
</div>
<div class="modal-body" id="editbody121">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<div class="modal fade bs-example-modal-lg" id="editmodel125">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> UPDATION CASH RECEIPT </h2> </center>
</div>
<div class="modal-body" id="editbody125">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-----for dus--->
<div class="modal fade bs-example-modal-lg" id="editmodel89">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-heading">
</div>
<div class="modal-body" id="editbody89">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- modal for result-->
<div class="modal fade bs-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" id="editmodel120">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span style='font-size:40px'> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> FEES DETAILS</h2> </center>
</div>
<div class="modal-body" id="editbody120">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- modal for slip new-->
<div class="modal fade bs-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" id="editmodel12111">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span style='font-size:40px'> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> FEES SLIP</h2> </center>
</div>
<div class="modal-body" id="editbody12111">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
</form>
</div>
</body>
</html>