|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.161 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/admin/../sale_new/code/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../php-includes/connect.php");
$flag=$_REQUEST['flag'];
switch($flag)
{
case 1:
$year1=$_POST['session'];
$sel1="select * from registration where session ='$year1' order by id asc";
$res1=mysqli_query($conn,$sel1);
$count=mysqli_num_rows($res1);
if($count!="")
{
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: []
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th style="text-align:center">Sr.</th><th style="text-align:center">Sch No.</th><th style="text-align:center">Photo</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Address</th><th style="text-align:center">Action</th>
</tr>
</thead>
<tfoot>
<tr>
<th style="text-align:center">Sr.</th><th style="text-align:center">Sch No.</th><th style="text-align:center">Photo</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Address</th><th style="text-align:center">Action</th>
</tr>
</tfoot>
<tbody>
<?php
$year=$_POST['session'];
$sel="select * from registration where session ='$year' order by application asc";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$e=$row['mobile'];
$d=$a." ".$c;
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['application'];?></td><td><img src="../code/img/<?php echo $row['picture'];?>" height="90px" width="90px;"></td><td><?php echo $row['2']."<br/>"." <b>Father-</b>".$row['fname']."<br/>"." <b>Mother-</b>".$row['mname']."<br/>". "<b>D.O.B-</b>".$row['dob']."<br/>"."<b>Adh-</b>".$row['adhar'];?></td><td><?php echo $row['subject'];?></td><td><?php echo "<b>Vill-</b>".$a."<br/>"."<b>Post-</b>".$b."<br/>"."<b>Dist-</b>".$c."<br/>"."<b>Mob-</b>".$row['mobile'];?></td>
<td><a href="javascript:;" onclick="editrow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-pencil"></span></a>
 <a href="javascript:;" onclick="messagerow(<?php echo $row['id'];?>)"> <span class="glyphicon glyphicon-envelope"></span></a>
<br/><br/> <a href="registration_print.php?flag=<?php echo $row['id'];?>"><span class="fa fa-print"></span></a>
 <a href="javascript:;" onclick="transferrow(<?php echo $row['id'];?>)"> <span class=""></span>Trans</a>
 <a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt> NO DATA Available</font>";
}
break;
case 2:
$id=$_POST['rowid'];
$del="delete from user where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
case 3:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from registration where uplineid='$eid'";
$res=mysqli_query($conn,$sel);
//$application=$row['application'];
?>
<div class="col-sm-12">
<script>
$(document).ready(function(){
$('#example1').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example1" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th colspan='9'>
<center>ALL DOWNLINE PERSONS OF <?PHP echo $row['uplineid'];?></center>
</th>
</tr>
<tr>
<th>Sr.</th><th>Upline Id</th><th>Dist. Id</th><th>Dist. Name</th><th>Mobile</th><th>Email</th><th>Address</th><th>Datetime</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Upline Id</th><th>Dist. Id</th><th>Dist. Name</th><th>Mobile</th><th>Email</th><th>Address</th><th>Datetime</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['uplineid'];?></td><td><?php echo $row['identy'];?></td><td><?php echo $row['distributor'];?></td><td><?php echo $row['mobile'];?></td><td><?php echo $row['email'];?></td><td><textarea colspan="15" rowspan="4" style=""><?php echo $row['address'];?></textarea></td><td><?php echo $row['datetime'];?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
</div>
<?php
break;
case 4:
$name=$_POST['name'];
$code=$_POST['code'];
$adhar=$_POST['adhar'];
$mediam=$_POST['mediam'];
$caste=$_POST['caste'];
$minority=$_POST['minority'];
//echo"$name";
//echo"<br/>";
$father=$_POST['father'];
//echo"$father";
$mother=$_POST['mother'];
//echo"$mother";
//echo"<br/>";
$app=$_POST['app'];
$id=$_POST['id1234'];
//echo"$app";
//echo"<br/>";
$gender=$_POST['gnd'];
$session=$_POST['session'];
//echo"$gender";
$dob1=$_POST['dob'];
//echo"$dob";
$dob=date("d-m-Y",strtotime($dob1));
$class=$_POST['class'];
//echo"$class";
//echo"$high1";
$subject=$_POST['group'];
//echo"$inter1";
$ele=$_POST['ele'];
//echo"$ele";
$board=$_POST['board'];
//echo"$board";
$year=$_POST['year'];
//echo"$year";
$tmark=$_POST['tmark'];
//echo"$tmark";
$omark=$_POST['omark'];
//echo"$omark";
$per=$_POST['per'];
//echo $per";
$grade=$_POST['grade'];
//echo $grade;
$city=$_POST['city'];
//echo"$city";
$city1=$_POST['city1'];
//echo"$city";
$village=$_POST['village'];
//echo"$village";
$village1=$_POST['village1'];
//echo"$village1";
$postoffice=$_POST['postoffice'];
//echo"$postoffice";
$postoffice1=$_POST['postoffice1'];
//echo"$postoffice1";
$dist=$_POST['dist'];
//echo"$dist";
$dist1=$_POST['dist1'];
//echo"$dist1";
$state=$_POST['state'];
//echo"$state";
$state1=$_POST['state1'];
//echo"$state1";
$mobile=$_POST['mobile'];
//echo"$mobile";
$mobile1=$_POST['mobile1'];
//echo"$mobile1";
$pincode=$_POST['pincode'];
//echo"$pincode";
$pincode1=$_POST['pincode1'];
//echo"$pincode1";
$imgname=$_FILES['picture']['name'];
//echo"$imgname";
$size=$_FILES['picture']['size'];
//echo"$size";
$type=$_FILES['picture']['type'];
//echo"$type";
$tempname=$_FILES['picture']['tmp_name'];
//echo"$tempname";
$pathinfo=pathinfo($imgname,PATHINFO_EXTENSION);
//echo"$pathinfo";
if($pathinfo!=""|| $pathinfo!=null)
{
$newimgname=time()."_".$name.".".$pathinfo;
//echo$newimgname;
}
else
{
$newimgname="";
}
echo $newimgname;
$date=date("d/m/Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$location="img/";
$location1="img/";
$size=$size/1024;
//--------------------------------------------------------------------
$sel12="select * from registration where application='$app'";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
$app12=$row12['application'];
//echo "<br/>";
// echo $app12;
$pic=$row12['picture'];
$location1="../code/img/".$pic;
$location="../code/img/";
// for updation and image
if($imgname=="" || $imgname==null)
{
$up="update registration set application='$app',name='$name',fname='$father',mname='$mother',dob='$dob',gender='$gender',class='$class',ele='$ele',board='$board',year='$year',total='$tmark',obtain='$omark',per='$per',grade='$grade',subject='$subject',city='$city',village='$village',postoffice='$postoffice',dist='$dist',state='$state',mobile='$mobile',pincode='$pincode',city1='$city1',village1='$village1',postoffice1='$postoffice1',dist1='$dist1', state1='$state1',mobile1='mobile1',pincode1='$pincode1',session='$session',mediam='$mediam',adhar='$adhar',datetime='$datetime',minority='$minority',caste='$caste',code='$code' where id='$id' ";
if(mysqli_query($conn,$up))
{
echo"ok";
}
else
{
echo"not update";
}
}
else
{
$up1="update registration set application='$app',name='$name',picture='$imgname',fname='$father',mname='$mother',dob='$dob',gender='$gender',class='$class',ele='$ele',board='$board',year='$year',total='$tmark',obtain='$omark',per='$per',grade='$grade',subject='$subject',city='$city',village='$village',postoffice='$postoffice',dist='$dist',state='$state',mobile='$mobile',pincode='$pincode',city1='$city1',village1='$village1',postoffice1='$postoffice1',dist1='$dist1', state1='$state1',mobile1='mobile1',pincode1='$pincode1',session='$session',mediam='$mediam',adhar='$adhar',datetime='$datetime',minority='$minority',caste='$caste',code='$code' where id='$id' ";
if(mysqli_query($conn,$up1))
{
unlink($location1);
move_uploaded_file($tempname,$location.$imgname);
echo"ok";
}
else
{
echo"not update";
}
}
// for updation and image
//
//-------------------------------------------------------------
break;
case 5:
$id=$_REQUEST['id'];
$sel="select * from registration where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<form class="form-horizontal" id="regform12" onsubmit="return data(this)">
<div class="form-group">
<label class="col-sm-6 control-label"> Student Name </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['name'];?>" name="name" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Father Name</label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['fname'];?>" name="fname" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Mother Name </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['mname'];?>" name="mname" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">class </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['class'];?>" name="class" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">DOB</label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['dob'];?>" name="dob" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Session</label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['session'];?>" name="session" ></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">HINDI </label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark1" placeholder="Marks1" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">ENGLISH </label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark2" placeholder="Marks 2" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">MATHEMATICS</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark3" placeholder="Marks 3" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">SCIENCE</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark4" placeholder="Marks 4"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">SOCIAL SCIENCE</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark5" placeholder="Marks 5"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">AGRICULTURE</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark6" placeholder="Marks 6"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">SANSKRIT</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark7" placeholder="Marks 7"></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">ART</label>
<div class="col-sm-6"><input type="text" class="form-control" name="mark8" placeholder="Marks 8"></div>
</div>
<center><button class="btn btn-primary" > Submit</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
<marquee> If Not Available subjects and Marks fillup NA in Box </marquee>
</form>
<?php
break;
//// FOR PAID INVOICE
case 6:
$name=$_POST['name'];
$dis=$_POST['dis'];
$amount=$_POST['amount'];
$date=$_POST['date'];
$by=$_POST['bypaid'];
$ins1="insert into recieve(dis,name,amount,date,bypaid) values('$dis','$name','$amount','$date','$by')";
if(mysqli_query($con,$ins1))
{
echo"Submit";
}
else
{
echo"not ok";
}
break;
case 7:
$sel1="select * from recieve order by id desc";
$res1=mysqli_query($con,$sel1);
$count=mysqli_num_rows($res1);
if($count!="")
{
?>
<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 style="text-align:center">SR.</th><th style="text-align:center">DIST ID</th><th style="text-align:center">NAME</th><th style="text-align:center">AMOUNT</th><th style="text-align:center">DATE</th><th style="text-align:center">IFSC</th><th style="text-align:center">A/C</th><th style="text-align:center">BANK</th><th style="text-align:center">LOCATION</th><th style="text-align:center">PAID BY</th><th style="text-align:center">ACTION</th>
</tr>
</thead>
<tfoot>
<tr>
<th style="text-align:center">SR.</th><th style="text-align:center">DIST ID</th><th style="text-align:center">NAME</th><th style="text-align:center">AMOUNT</th><th style="text-align:center">DATE</th><th style="text-align:center">IFSC</th><th style="text-align:center">A/C</th><th style="text-align:center">BANK</th><th style="text-align:center">LOCATION</th><th style="text-align:center">PAID BY</th><th style="text-align:center">ACTION</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$dist1=$row['dis'];
$sel2="select * from user where email='$dist1' order by id desc";
$res2=mysqli_query($con,$sel2);
$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
$ifc=$row2['ifc'];
$acn=$row2['account'];
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['dis'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['amount'];?></td><td><?php echo $row['date'];?></td><td><?php echo $ifc;?></td><td><?php echo $acn;?></td><td><?php echo $row2['bank'];?></td><td><?php echo $row2['location'];?></td><td><?php echo $row['bypaid'];?></td>
<td><a href="javascript:;" onclick="editrow(<?php echo $row['id'];?>)"><span class=""><button class="btn btn info">Edit</button></span></a>
 <a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class=""><button class="btn btn-danger">Delete</button></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt> NO DATA Available</font>";
}
break;
case 8:
$id=$_POST['rowid'];
$del="delete from recieve where id='$id'";
if(mysqli_query($con,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
case 9:
$id=$_REQUEST['id'];
$sel="select * from recieve where id='$id'";
$res=mysqli_query($con,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$dis=$row['dis'];
$sel1="select * from user where email='$dis'";
$res1=mysqli_query($con,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
?>
<form class="form-horizontal" id="regform12" onsubmit="return data2(this)">
<div class="form-group">
<label class="col-sm-6 control-label"> Dist Id </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['dis'];?>" name="dis" readonly></div>
<input type="hidden" class="form-control" value="<?php echo $row['id'];?>" name="id" >
<input type="hidden" class="form-control" value="<?php echo $dis;?>" name="dis" >
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label"> Name</label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['name'];?>" name="name" readonly></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Amount </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['amount'];?>" name="amount" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Date </label>
<div class="col-sm-6"><input type="date" class="form-control" value="<?php echo $row['date'];?>" name="date" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Paid By </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row['bypaid'];?>" name="bypaid" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Account </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row1['account'];?>" name="account" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Ifsc </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row1['ifc'];?>" name="ifc" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Bank </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row1['bank'];?>" name="bank" required></div>
</div>
<div class="form-group">
<br/>
<label class="col-sm-6 control-label">Location of Bank </label>
<div class="col-sm-6"><input type="text" class="form-control" value="<?php echo $row1['location'];?>" name="location" required></div>
</div>
<center><button class="btn btn-primary" > Submit</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</form>
<?php
break;
/// paid close work
case 10:
// echo $ch;
$dis=$_POST['dis'];
$id=$_POST['id'];
$name=$_POST['name'];
$amount=$_POST['amount'];
$date=$_POST['date'];
$bypaid=$_POST['bypaid'];
$account=$_POST['account'];
$ifc=$_POST['ifc'];
$dis=$_POST['dis'];
$bank=$_POST['bank'];
$location=$_POST['location'];
//echo $edate;
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$up1="update recieve set amount='$amount',date='$date',bypaid='$bypaid' where id='$id'";
if(mysqli_query($con,$up1))
{
$up2="update user set account='$account',ifc='$ifc',location='$location',bank='$bank' where email='$dis'";
mysqli_query($con,$up2);
echo"Update";
}
else
{
echo"Not update";
}
break;
//=========================================================message==//
case 11:
$year=$_POST['year'];
$date=date("d-m-Y");
$message=$_POST['message'];
$sel="select * from registration where session='$year'";
$res=mysqli_query($conn,$sel);
$mob="";
$mess=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$mobile1=$row['mobile'];
$mob= $mobile1.",".$mob;
$mess++;
}
$username="AwadheshYadav";
$password="AwadheshYadav";
$senderid="GCSNNJ";
$msg=urlencode($message);
$rest=substr($mob,0,-1);
$to=$rest;
$api="http://sms.jupitersms.com/api/sendmsg.php?user=brkweb&pass=india&sender=$senderid&phone=$to&text=$msg&priority=ndnd&stype=normal";
$result=file_get_contents($api);
if($result)
{
$ins="insert into message (message,count) value('$message','$mess')";
$res=mysqli_query($conn,$ins);
$insme="insert into message1 (message,date) value('$message','$date')";
$resme=mysqli_query($conn,$insme);
echo"sms send";
}
else
{
echo"sms not send";
}
break ;
case 13:
$year=$_POST['year'];
$class=$_POST['class'];
$sel="select * from studentfees where year='$year' and class='$class' order by date desc ";
$res=mysqli_query($conn,$sel);
$sel1="select * from studentfees where year='$year' and class='$class' ";
$res1=mysqli_query($conn,$sel1);
$row2=mysqli_num_rows($res1);
if($row2!=" ")
{
?>
<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>Sch No.</th><th>Session</th><th>Name</th><th>Class</th><th> Month</th><th>Month Fee</th><th>Annual Fee</th><th>Exam Fee</th><th>Conveyance </th><th>Admission.</th><th>Dues Charge</th><th>Other Charge</th><th> Total</th><th>DateTime</th><th>Update</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Sch No.</th><th>Session</th><th>Name</th><th>Class</th><th> Month</th><th>Month Fee</th><th>Annual Fee</th><th>Exam Fee</th><th>Conveyance </th><th>Admission.</th><th>Dues Charge</th><th>Other Charge</th><th> Total</th><th>DateTime</th><th>Update</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['search'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td><td><?php echo $row['month'];?></td><td><?php echo $row['fee'];?></td><td><?php echo $row['ann'];?></td><td><?php echo $row['exam'];?></td><td><?php echo $row['van'];?></td><td><?php echo $row['addm'];?></td><td><?php echo $row['remain'];?></td><td><?php echo $row['other'];?></td><td><?php echo $row['total'];?></td><td><?php echo $row['date'];?></td>
<td><a href="javascript:;" onclick="feeuprow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-pencil"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt>Not Record Available.</font>";
}
break;
case 14:
$id=$_POST['rowid'];
$del="delete from studentfees where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
case 15:
$rol=$_POST['rol'];
$sel="select * from studentfees where search='$rol' order by date desc";
$res=mysqli_query($conn,$sel);
$sel1="select * from studentfees where search='$rol'";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_num_rows($res1);
if($row1==" ")
{
echo"<font color=red size=6pt>Not Fees Submit Or Invailid Session and Application Number.</font>";
}
else
{
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: [ 'pdf', 'print']
});
});
</script>
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr >
<th style="text-align:center">Session</th><th style="text-align:center">Month</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Fees</th><th style="text-align:center">Exam</th><th style="text-align:center">Van</th><th style="text-align:center">Admission</th><th style="text-align:center">Total</th><th style="text-align:center">Date</th>
</tr>
</thead>
<tfoot>
<tr>
<th style="text-align:center">Session</th><th style="text-align:center">Month</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Fees</th><th style="text-align:center">Exam</th><th style="text-align:center">Van</th><th style="text-align:center">Admission</th><th style="text-align:center">Total</th><th style="text-align:center">Date</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
</td><td><?php echo $row['year'];?></td><td><?php echo $row['month'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td><td><?php echo $row['fee'];?></td><td><?php echo $row['exam'];?></td><td><?php echo $row['van'];?></td><td><?php echo $row['other'];?></td><td><?php echo $row['total'];?></td><td><?php echo $row['date'];?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
<?php
}
break;
// contact---
case 16:
$name=$_POST['name'];
$message1=$_POST['message'];
$mobile=$_POST['mobile'];
$subject=$_POST['subject'];
$email=$_POST['email'];
$from=$email;
$to="fmazm.meyer14@gmail.com";
$message=$name." mob-".$mobile." "."Msg-".$message1;
//echo"$message";
//echo"<br/>";
$headers="MIME-Version:1.0"."\r\n"; // header ko call krta hai header path
$headers=
"Content-type:text/html;charset:UTF-8"."\r\n";
if(mail($to,$subject,$message,$from))
{
echo"Submit";
}
else
{
echo"query not send";
}
break;
case 17:
$name=$_POST['name'];
$year=$_POST['year'];
$class=$_POST['class'];
$total=$_POST['total'];
$obtain=$_POST['obtain'];
$per1=$obtain/$total;
$per2=$per1*100;
$per=substr($per2,0,5);
$picture=$_FILES['picture']['name'];
$tempname=$_FILES['picture']['tmp_name'];
$location="img/".$picture;
$ins="insert into topper(name,year,class,total,obtain,picture,per) value('$name','$year','$class','$total','$obtain','$picture','$per')";
if($res=mysqli_query($conn,$ins))
{
echo "Submit";
move_uploaded_file($tempname,$location);
}
else
{
echo"not submit";
}
break;
case 18:
?>
<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>Photo</th><th>Name</th><th>Year</th><th>class</th><th>Total</th><th>Obtain</th><th>Per</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Photo</th><th>Name</th><th>Year</th><th>class</th><th>Total</th><th>Obtain</th><th>Per</th><th>Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from topper order by id desc";
$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><img src="../code/img/<?php echo $row['picture'];?>" height="60px" width="60px;"></td><td><?php echo $row['name'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['class'];?></td><td><?php echo $row['total'];?></td><td><?php echo $row['obtain'];?></td><td><?php echo $row['per'];?></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 22:
$id=$_POST['rowid'];
$sel="select * from topper where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$photo=$row['picture'];
$location="../code/img/".$photo;
$del="delete from topper where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
unlink($location);
}
else
{
echo"Not Deleted";
}
break;
case 23:
$year=$_POST['year'];
$slip=$_POST['slip'];
$sel="select * from studentfees where year='$year' and search='$slip' ";
$res=mysqli_query($conn,$sel);
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: []
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Scho. No.</th><th>Session</th><th>Name</th><th>Class</th><th>Fees Details</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Scho. No.</th><th>Session</th><th>Name</th><th>Class</th><th>Fees Details</th>
</tr>
</tfoot>
<tbody>
<?php
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<tr class="text-center">
<td><?php echo $row['search'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td>
<td><a href="../admin/slip2.php?flag=<?php echo $row['search'];?>"><button class="btn btn-primary">Fees Details</button></a></td>
</tr>
</tbody>
</table>
</div>
<?php
break;
case 24:
$rol=$_POST['std'];
$sel="select * from registration where id='$rol' ";
$res=mysqli_query($conn,$sel);
$sel1="select * from registration where id='$rol'";
$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 Application 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">Year</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">Year</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['year'];?></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 47:
$userid='';
$sel1234="select * from withdraw where userid='$userid' and plan='Pair' ";
$res1234=mysqli_query($con,$sel1234);
//$row1234=mysqli_fetch_array($res1234,MYSQLI_BOTH);
$sel12341="select * from recieve where dis='$userid' and plan='Pair' and status='Yes' ";
$res12341=mysqli_query($con,$sel12341);
$tot1=0;
while($row12341=mysqli_fetch_array($res12341,MYSQLI_BOTH))
{
$balance1=$row12341['amount'];
$date=$row12341['date'];
$tot1=$balance1+$tot1;
}
//echo $tot1;
////for name
////for name
////for tree
$selu1="select * from tree where userid='$userid'";
$resu1=mysqli_query($con,$selu1);
$rowu1=mysqli_fetch_array($resu1,MYSQLI_BOTH);
$left=$rowu1['leftcount'];
$right=$rowu1['rightcount'];
//echo $left;
//echo $right;
$count=min($left,$right);
////for tree
///for income
$selu11="select * from income where userid='$userid'";
$resu11=mysqli_query($con,$selu11);
$rowu11=mysqli_fetch_array($resu11,MYSQLI_BOTH);
$total_bal=$rowu11['total_bal'];
$remain=$total_bal-$tot1;
///for income
?>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th style="text-align:center">DIST ID</th><th style="text-align:center">NAME</th><th style="text-align:center">PAIR COMPLETE</th><th style="text-align:center">PAIR AMOUNT</th><th style="text-align:center">RECEIVE AMOUNT </th><th style="text-align:center">REMAIN AMOUNT </th><th style="text-align:center">ACTION</th>
</tr>
</thead>
<tbody>
<?php
?>
<tr class="text-center">
<td><?PHP echo $userid;?></td><td><?php echo $row['name'];?></td><td><?php echo $count;?></td><td><?php echo $total_bal;?></td><td><?php echo $tot1;?></td><td><?php echo $remain;?></td>
<td><a href="javascript:;" onclick="pay12(<?php echo $row['id'];?>)"><span class="fa fa-inr">Request Send</span></a> <a href="javascript:;" onclick="payshow12(<?php echo $row['id'];?>)"><span class="fa fa-inr">Request Show</span></a></td>
</tr>
</tbody>
<tfoot>
<tr>
<th style="text-align:center">DIST ID</th><th style="text-align:center">NAME</th><th style="text-align:center">PAIR COMPLETE</th><th style="text-align:center">PAIR AMOUNT</th><th style="text-align:center">RECEIVE AMOUNT </th><th style="text-align:center">REMAIN AMOUNT </th><th style="text-align:center">ACTION</th>
</tr>
</tfoot>
</table>
</div>
<?php
break;
/// update data fees
break;
case 28:
$date4=$_POST['date1'];
$date1=date("d-m-Y",strtotime($date4));
$date3=$_POST['date2'];
$date2=date("d-m-Y",strtotime($date3));
$sel="select * from updatefees where date between '$date1' and '$date2' order by id desc";
$res=mysqli_query($conn,$sel);
$sel1="select * from updatefees where date between '$date1' and '$date2' order by id desc";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_num_rows($res1);
if($row1!="")
{
?>
<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>Slip No.</th><th>Name</th><th>Class</th><th>Old Month</th><th> Change Month</th><th>Old Total Fees</th><th>Change Total Fees</th><th>Old Date</th><th>Change Date</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Slip No.</th><th>Name</th><th>Class</th><th>Old Month</th><th> Change Month</th><th>Old Total Fees</th><th>Change Total Fees</th><th>Old Date</th><th>Change Date</th><th>Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['search'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td><td><?php echo $row['month'];?></td><td style="color:red"><?php echo $row['newmonth'];?></td><td><?php echo $row['total'];?></td><td style="color:red"><?php echo $row['newtotal'];?></td><td><?php echo $row['date'];?></td><td style="color:red"><?php echo $row['newdate'];?></td>
<td><a href="javascript:;" onclick="deleterow12(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt>Not Update Fees.</font>";
}
break;
/////////print student date//////
case 29:
?>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr >
<th style="text-align:center">Sr.</th><th style="text-align:center">App.No.</th><th style="text-align:center">Name</th><th style="text-align:center">Fname</th><th style="text-align:center">mname</th><th style="text-align:center">Session</th><th style="text-align:center">Class</th><th style="text-align:center">Address</th><th style="text-align:center">Mobile</th>
</tr>
</thead>
<tbody>
<?php
$session=$_POST['session'];
$class=$_POST['class'];
$sel="select * from registration where session='$session' and subject='$class'";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$d=$row['mobile'];
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['id'];?></td><td><?php echo $row['2'];?></td><td><?php echo $row['fname'];?></td><td><?php echo $row['mname'];?></td><td><?php echo $row['session']."<br/>".$row['date'];?></td><td><?php echo $row['subject'];?></td><td><?php echo $a."<br>"."<b>Post-</b>".$b."<br/>"."<b>Dist-</b>".$c;?></td><td><?php echo $row['mobile'];?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
break;
///////all fees print////
case 30:
$sel="select * from studentfees ";
$res=mysqli_query($conn,$sel);
?>
<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>Scho. No.</th><th>Session</th><th>Month</th><th>Name</th><th>Class</th><th>Paid Fees</th><th>Date</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Scho. No.</th><th>Session</th><th>Month</th><th>Name</th><th>Class</th><th>Paid Fees</th><th>Date</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['search'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['month'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td><td style="font-weight:bold"><?php echo $row['paid'];?></td><td><?php echo $row['date'];?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
break;
case 31:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from registration where id='$eid'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$d=$a." ".$b." ".$c;
?>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" id="myform" onsubmit="return changerow(this)">
<div class="form-group">
<label class="col-sm-3 control-label">Session</label>
<div class="col-sm-8">
<select class="form-control" name="session">
<option>---select---</option>
<option <?php if($row['session']=='2012-2013'){echo'selected';}?>>2012-2013</option>
<option <?php if($row['session']=='2013-2014'){echo'selected';}?>>2013-2014</option>
<option <?php if($row['session']=='2014-2015'){echo'selected';}?>>2014-2015</option>
<option <?php if($row['session']=='2015-2016'){echo'selected';}?>>2015-2016</option>
<option <?php if($row['session']=='2016-2017'){echo'selected';}?>>2016-2017</option>
<option <?php if($row['session']=='2017-2018'){echo'selected';}?>>2017-2018</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>
<br/>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Class</label>
<div class="col-sm-8">
<?php
$selc="select * from subclass";
$resc=mysqli_query($conn,$selc);
?>
<select class="form-control" style="font-weight:bold" id="select" name="class">
<option >--Select--</option>
<?php
while($rowc=mysqli_fetch_array($resc,MYSQLI_BOTH))
{
?>
<option value="<?php echo $rowc['subclass'];?>"><?php echo $rowc['subclass'];?></option>
<?php
}
?>
</select>
</div>
</div>
<br/>
<input type="hidden" value="<?php echo $row['application'];?>" name="app"/>
<center><button class="btn btn-primary">Trans</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</form>
</div>
</div>
<?php
break;
case 32:
$application=$_POST['app'];
$sel="select * from registration where application='$application'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$name=$row['name'];
//echo $name;
$fname=$row['fname'];
$mname=$row['mname'];
$dob=$row['dob'];
$mobile=$row['mobile'];
$picture=$row['picture'];
$session=$_POST['session'];
$class=$_POST['class'];
$gender=$row['gender'];
$date=date("d-m-Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$ins="insert into registration(application,name,fname, mname,dob,gender,class,mobile,picture,datetime,session,subject,village,postoffice,dist) values('$application','$name','$fname','$mname','$dob','$gender','$class','$mobile','$picture','$datetime','$session','$class','$a','$b','$c')";
if(mysqli_query($conn,$ins))
{
echo "Transfered";
}
else
{
echo"not";
}
break;
case 34:
$application=$_REQUEST['application'];
//echo $application;
?>
<form action="slip.php" method="post">
Date<input type="date" required name='date'><SPAN>
<input type="hidden" value="<?php echo $application;?>" name="app">
<input type="hidden" value="<?php echo '1';?>" name="no">
<button >Go</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</form>
<h3 style="color:green">OR</h3>
<br/>
<form action="slip.php" method="post">
<input type="hidden" value="<?php echo $application;?>" name="app">
<?php $date=date("d-m-Y");?>
<input type="hidden" value="<?php echo $date;?>" name="date">
<input type="hidden" value="<?php echo '2';?>" name="no">
<button >Today</button>
</form>
<?php
break;
case 36:
$sel1="select * from registration where session ='2018-2019' order by application asc";
$res1=mysqli_query($conn,$sel1);
$count=mysqli_num_rows($res1);
if($count!="")
{
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: []
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr align="center">
<th style="text-align:center">Sr.</th><th style="text-align:center">Sch No .</th><th style="text-align:center">Photo</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Session</th><th style="text-align:center">Action</th>
</tr>
</thead>
<tfoot>
<tr tr align="center">
<th style="text-align:center">Sr.</th><th style="text-align:center">Sch No .</th><th style="text-align:center">Photo</th><th style="text-align:center">Name</th><th style="text-align:center">Class</th><th style="text-align:center">Session</th><th style="text-align:center">Action</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from registration where session ='2018-2019' order by id asc";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$a=$row['village'];
$b=$row['postoffice'];
$c=$row['dist'];
$e=$row['mobile'];
$d=$a." ".$c;
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['application'];?></td><td><img src="../code/img/<?php echo $row['picture'];?>" height="90px" width="90px;"></td><td><?php echo $row['2']."<br/>"." <b>Father-</b>".$row['fname']."<br/>"." <b>Mother-</b>".$row['mname']."<br/>". "<b>D.O.B-</b>".$row['dob']."<br/>"."<b>Adh-</b>".$row['adhar'];?></td><td><?php echo $row['subject'];?></td><td><?php echo $row['session']."<br/>".$row['date']."<br/>".$row['time'];?></td>
<td>
<a href="javascript:;" onclick="feesrow(<?php echo $row['id'];?>)"> <span class=""><button type="button" class="btn btn-primary">Fees</button></span></a>
<a href="javascript:;" onclick="app12(<?php echo $row['application'];?>)"><span><button type="button" class="btn btn-success">Slip</button></span></a>
<a href="../admin/slip2.php?flag=<?php echo $row['application'];?>"><span> <button type="button" class="btn btn-info">Fees Details</button></span></a><BR/><br/>
<a href="javascript:;" onclick="app123(<?php echo $row['application'];?>)"><span><button type="button" class="btn btn-danger">Fees Update</button></span></a>
<a href="javascript:;" onclick="dues123(<?php echo $row['application'];?>)"><span><button type="button" class="btn btn-warning">Dues Paid</button></span></a>
</td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt> NO DATA Available</font>";
}
break;
case 37:
$id=$_POST['rowid'];
$del="delete from updatefees where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
case 38:
$year=$_POST['year'];
$class=$_POST['class'];
$sel="select * from studentfees where year='$year' and class='$class' order by date desc ";
$res=mysqli_query($conn,$sel);
$sel1="select * from studentfees where year='$year' and class='$class' ";
$res1=mysqli_query($conn,$sel1);
$row2=mysqli_num_rows($res1);
if($row2!=" ")
{
?>
<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>Sch No.</th><th>Session</th><th>Name</th><th>Class</th><th> Month</th><th>Month Fee</th><th>Annual Fee</th><th>Exam Fee</th><th>Conveyance </th><th>Admission.</th><th>Dues Charge</th><th>Other Charge</th><th> Total</th><th>DateTime</th><th>Delete</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Sch No.</th><th>Session</th><th>Name</th><th>Class</th><th> Month</th><th>Month Fee</th><th>Annual Fee</th><th>Exam Fee</th><th>Conveyance </th><th>Admission.</th><th>Dues Charge</th><th>Other Charge</th><th> Total</th><th>DateTime</th><th>Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['search'];?></td><td><?php echo $row['year'];?></td><td><?php echo $row['name'];?></td><td><?php echo $row['class'];?></td><td><?php echo $row['month'];?></td><td><?php echo $row['fee'];?></td><td><?php echo $row['ann'];?></td><td><?php echo $row['exam'];?></td><td><?php echo $row['van'];?></td><td><?php echo $row['addm'];?></td><td><?php echo $row['remain'];?></td><td><?php echo $row['other'];?></td><td><?php echo $row['total'];?></td><td><?php echo $row['date'];?></td>
<td><a href="javascript:;" onclick="deleterow13(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt>Not Record Available.</font>";
}
break;
case 39:
$id=$_POST['rowid'];
$del="delete from studentfees where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
case 41:
$month=$_POST['month'];
$sel1="select * from studentfees where month ='$month'";
$res1=mysqli_query($conn,$sel1);
$paid1="";
$dues1="";
$con1="";
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$paid=$row1['paid'];
$cons=$row1['con'];
$remain=$row1['remain'];
$paid1=$paid+$paid1;
$con1=$cons+$con1;
$dues1=$remain+$dues1;
}
?>
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<tr align="center">
<th style="text-align:center">Paid</th><th style="text-align:center">Dues</th><th style="text-align:center">Consession</th>
</tr>
<tr>
<td style="text-align:center"><?php echo $paid1;?></td><td style="text-align:center"><?php echo $dues1;?></td><td style="text-align:center"><?php echo $con1;?></td>
</tr>
</table>
<?php
break;
case 42:
?>
<script>
$("document").ready(function(){
$("#paid").keyup(function(){
var dew1=$("#dew").val();
var paid1=$("#paid").val();
var ndew1=$("#ndew").val();
var total1= parseInt(dew1) - parseInt(paid1) ;
$("#ndew").val(total1);
});
});
</script>
<?php
$sch=$_REQUEST['application'];
//echo"$eid";
$sel="select * from studentfees where search='$sch' order by id desc";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$paid12=$row['paid'];
?>
<div class="table-responsive">
<tbody>
<form onsubmit="return feesupdate(this)">
<div class="form-group">
<label class="col-sm-3 control-label">Sch.</label>
<div class="col-sm-3"><input type="text" value="<?php echo $row['search'];?>" name="search" readonly style="background-color:yellow;color:green"/></div>
<input type="hidden" value="<?php echo $row['id'];?>" name="id"/>
<input type="hidden" value="<?php echo $row['paid'];?>" name="paid13"/>
<input type="hidden" value="<?php echo $row['class'];?>" name="class"/>
<input type="hidden" value="<?php echo $row['year'];?>" name="year"/>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Name</label>
<div class="col-sm-3"><input type="text" value="<?php echo $row['name'];?>" name="name" readonly style="background-color:gray;color:pink" /></div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Dues</label>
<div class="col-sm-3"><input type="number" value="<?php echo $row['remain'];?>" name="dew" id="dew" readonly style="background-color:green;color:red"/></div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label">Paid</label>
<div class="col-sm-3"><input type="number" name="paid" id="paid" required /></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">New Dues</label>
<div class="col-sm-3"><input type="number" id="ndew" name="ndew" required /></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Date</label>
<div class="col-sm-3"><input type="date" name="date" required /></div>
</div>
<center><button class="btn btn-danger">Paid</button></center>
</form>
</div>
<?php
break;
case 43:
$id=$_POST['id'];
$name=$_POST['name'];
echo $name;
$class=$_POST['class'];
echo $class;
$date1=$_POST['date'];
$year=$_POST['year'];
echo $year;
$dew=$_POST['dew'];
echo $dew;
$date=date("d-m-Y",strtotime($date1));
echo $date;
//echo $id;
$search=$_POST['search'];
echo $search;
$paid13=$_POST['paid13'];
//echo $search;
$paid=$_POST['paid'];
echo $paid;
//echo $paid;
$ndew=$_POST['ndew'];
echo $ndew;
$paid8=$paid+$paid13;
//echo $ndew;
//echo"$eid";
$ins="insert into studentfees(name,class,search,month,paid,remain,pre,date,year) values('$name','$class','$search','Dues','$paid','$ndew','$dew','$date','$year')";
if($res=mysqli_query($conn,$ins))
{
echo " Dues Paid";
}
else
{
echo "not update";
}
break;
case 50:
$sel1="select * from message1 order by id desc";
$res1=mysqli_query($conn,$sel1);
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: []
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr tr align="center">
<th style="text-align:center">Sr.</th><th style="text-align:center">Message</th><th style="text-align:center">Date</th><th style="text-align:center">Delete</th>
</tr>
</thead>
<tfoot>
<tr tr align="center">
<th style="text-align:center">Sr.</th><th style="text-align:center">Message</th><th style="text-align:center">Date</th><th style="text-align:center">Delete</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from message1 order by id desc";
$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['message'];?></td><td><?php echo $row['date'];?></td>
<td>
<a href="del12.php?flag=<?php echo $row['id'];?>"><span><button type="button" class="btn btn-danger">Delete</button></span></a>
</td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
break;
case 51:
$id=$_POST['rowid'];
$del="delete from message1 where id='$id'";
if(mysqli_query($conn,$del))
{
echo"deleted Successfully";
}
else
{
echo"Not Deleted";
}
break;
///////for payment
case 52:
$sel1="select * from recieve order by id desc";
$res1=mysqli_query($con,$sel1);
$count=mysqli_num_rows($res1);
if($count!="")
{
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print'],
orientation:'landscape'
});
});
$(document).ready(function() {
var currentDate = new Date()
var day = currentDate.getDate()
var month = currentDate.getMonth() + 1
var year = currentDate.getFullYear()
var d = day + "-" + month + "-" + year;
$('#detailTable').DataTable({
dom: 'Bfrtip',
buttons: [{
extend: 'excelHtml5',
title: d + ' Purchase Orders'
}, {
extend: 'csvHtml5',
title: d + ' Purchase Orders'
}, {
extend: 'pdfHtml5',
title: d + ' Purchase Orders',
orientation: 'landscape',
pageSize: 'A4',
exportOptions: {
columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
}
}]
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<h1>Subject- Commission to be Credited from A/C No. - 201002473353 to be below A/Cs </h1>
<br/>  Kindly Credit Commission as per Excel Sheet Enclosed Below
<thead>
<tr>
<th style="text-align:center">Sr.</th><th style="text-align:center">Debit A/c </th><th style="text-align:center">Amount</th><th style="text-align:center">Bank</th><th style="text-align:center">Beneficiary Name</th><th style="text-align:center">A/C No.</th><th style="text-align:center">Addresss </th><th style="text-align:center">Ifsc Code</th><th style="text-align:center">Purpose</th><th style="text-align:center">Date</th>
</tr>
</thead>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$dist1=$row['dis'];
$sel2="select * from user where email='$dist1' order by id desc";
$res2=mysqli_query($con,$sel2);
$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
$ifc=$row2['ifc'];
$acn=$row2['account'];
?>
<tr class="text-center">
<td><?php echo $s;?></td><td>201002473353</td><td><?php echo $row['amount'];?></td><td><?php echo $row2['bank'];?></td><td><?php echo $row['name'];?></td><td><?php echo $acn;?></td><td><?php echo $row2['location'];?></td><td><?php echo $ifc;?></td><td>Commission</d><td><?php echo $row['date'];?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt> NO DATA Available</font>";
}
break;
case 55:
$sel1="select * from income ";
$res1=mysqli_query($conn,$sel1);
$count=mysqli_num_rows($res1);
if($count!="")
{
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['pdf','print']
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th style="text-align:center">Sr.</th><th style="text-align:center">Dist</th><th style="text-align:center">Name</th><th style="text-align:center">Pair Amount</th><th style="text-align:center">Pair Complete</th><th style="text-align:center">Paid Amount</th><th style="text-align:center">Remain Amount</th><th style="text-align:center">Action</th>
</tr>
</thead>
<tfoot>
<tr>
<th style="text-align:center">Sr.</th><th style="text-align:center">Dist</th><th style="text-align:center">Name</th><th style="text-align:center">Pair Amount</th><th style="text-align:center">Pair Complete</th><th style="text-align:center">Paid Amount</th><th style="text-align:center">Remain Amount</th><th style="text-align:center">Action</th>
</tr>
</tfoot>
<tbody>
<?php
$sel="select * from income ";
$res=mysqli_query($conn,$sel);
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$use=$row['userid'];
$selu="select * from user where email='$use'";
$resu=mysqli_query($conn,$selu);
$rowu=mysqli_fetch_array($resu,MYSQLI_BOTH);
$tot=$row['total_bal'];
$selu1="select * from tree where userid='$use'";
$resu1=mysqli_query($conn,$selu1);
$rowu1=mysqli_fetch_array($resu1,MYSQLI_BOTH);
$left=$rowu1['leftcount'];
$right=$rowu1['rightcount'];
//echo $left;
//echo $right;
$count=min($left,$right);
//echo $count;
///remain
$selmr="select * from recieve where dis='$use' and plan='Pair'";
$resmr=mysqli_query($conn,$selmr);
$amr=0;
while($rowmr=mysqli_fetch_array($resmr,MYSQLI_BOTH))
{
$amountr=$rowmr['amount'];
$amr=$amr+$amountr;
}
$remain=$tot-$amr;
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $row['userid'];?></td><td><?php echo $rowu['name'];?></td><td><?php echo $row['total_bal'];?></td><td><?php echo $count;?></td><td><?php echo $amr ;?></td><td><?php echo $remain ;?></td>
<td><a href="javascript:;" onclick="pay12(<?php echo $row['id'];?>)"><span class="fa fa-inr">Paid</span></a>
 <a href="javascript:;" onclick="pay123(<?php echo $row['id'];?>)"><span class="fa fa-inr">Show</span></a>
</td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
<?php
}
else
{
echo"<font color=red size=6pt> NO DATA Available</font>";
}
break;
case 56:
$e=$_REQUEST['id'];
$selr="select * from income where id='$e'";
$resr=mysqli_query($conn,$selr);
$rowr=mysqli_fetch_array($resr,MYSQLI_BOTH);
$eid=$rowr['userid'];
echo"$eid";
break;
case 57:
$userid=$_POST['userid'];
$remain=$_POST['remain'];
$receive=$_POST['paid'];
$plan=$_POST['plan'];
$date=date('Y-m-d');
//$edate=date("d-m-Y",strtotime($date1));
//echo $edate;
date_default_timezone_set("asia/kolkata");
$sel="select * from recieve where dis='$userid' order by id desc ";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$status=$row['status'];
if($remain<$receive)
{
echo "Your Receive Amount Greater Than Of Available Amount , ";
}
if($status!='' or $status!=NULL )
{
$ins1="insert into recieve(dis,amount,plan,date) values('$userid','$receive','$plan','$date')";
if(mysqli_query($conn,$ins1))
{
echo"Request Send ";
}
else
{
echo"not ok";
}
}
else
{
echo'Your Reuest Already Send Please Wait For Success ';
}
break;
////for direct
case 58:
$e=$_REQUEST['id'];
echo $e;
$selr="select * from income where id='$e'";
$resr=mysqli_query($conn,$selr);
$rowr=mysqli_fetch_array($resr,MYSQLI_BOTH);
$eid=$rowr['userid'];
//echo"$eid";
$sel111="select * from user where main='$eid' order by id desc";
$res111=mysqli_query($con,$sel111);
$a=0;
while($row111=mysqli_fetch_array($res111,MYSQLI_BOTH))
{
$amount=$row111['amount'];
// echo $amount;
if($amount==3500)
{
$c=250;
//echo $c;
}
if($amount==7000)
{
$c=500;
//echo $c;
}
$a=$a+$c;
}
///remain
$selmr="select * from recieve where dis='$eid' and plan='Direct' and status='Yes' ";
$resmr=mysqli_query($conn,$selmr);
$amr=0;
while($rowmr=mysqli_fetch_array($resmr,MYSQLI_BOTH))
{
$amountr=$rowmr['amount'];
$amr=$amr+$amountr;
}
$remain=$a-$amr;
//echo $a;
//echo $amr;
//$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
//$total2=$row1['total_bal'];
//$remain=$total-$tot;
?>
<script>
$("document").ready(function(){
$("#paid1").focus(function(){
alert(ok);
var paid=$("#paid").val();
var remain=$("#remain").val();
//var success=$("#success").val();
//var total12=$("#total").val();
var total121= parseInt(remain) - parseInt(paid) ;
$("#dues").val(total121);
});
});
</script>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" onsubmit="return payment(this)" >
<input type="hidden" value="<?php echo $eid;?>" name="userid" readonly />
<input type="hidden" value="<?php echo 'Direct';?>" name="plan" readonly />
<div class="form-group">
<label class="col-sm-3 control-label">Dist Id.</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $eid;?>" readonly /></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Available Amount</label>
<div class="col-sm-8"><input type="number" id="remain" name="remain" class="form-control" value="<?php echo $remain;?>" readonly /></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Withdraw Request</label>
<div class="col-sm-8"><input type="number" class="form-control" id='paid1' name="paid" required /></div>
<br/>
</div>
<center><button class="btn btn-primary">Submit</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</form>
</div>
</div>
<?php
break;
case 59:
$userid=$_POST['userid'];
$remain=$_POST['remain'];
$receive=$_POST['paid'];
$plan=$_POST['plan'];
$date=date('Y-m-d');
//$edate=date("d-m-Y",strtotime($date1));
//echo $edate;
date_default_timezone_set("asia/kolkata");
$sel="select * from recieve where dis='$userid' order by id desc ";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$status=$row['status'];
if($remain<$receive)
{
echo "Your Receive Amount Greater Than Of Available Amount , ";
}
if($status!='' or $status!=NULL )
{
$ins1="insert into recieve(dis,amount,plan,date) values('$userid','$receive','$plan','$date')";
if(mysqli_query($conn,$ins1))
{
echo"Request Send ";
}
else
{
echo"not ok";
}
}
else
{
echo'Your Reuest Already Send Please Wait For Success ';
}
break;
////for direct
case 61:
$e=$_REQUEST['id'];
$selr="select * from income where id='$e'";
$resr=mysqli_query($conn,$selr);
$rowr=mysqli_fetch_array($resr,MYSQLI_BOTH);
$eid=$rowr['userid'];
$sel="select * from recieve where dis='$eid' and plan='Direct'";
$res=mysqli_query($conn,$sel);
//$application=$row['application'];
?>
<div class="col-sm-12">
<script>
$(document).ready(function(){
$('#example1').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example1" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th colspan='9'>
</th>
</tr>
<tr>
<th>Sr.</th><th>Dist Id</th><th> Direct Amount</th><th>Date</th><th>Status</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Dist Id</th><th> Direct Amount</th><th>Date</th><th>Status</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $eid;?></td><td><?php echo $row['amount'];?></td><td><?php echo $row['date'];?></td><td><?php if($row['status']==''){echo '<font color=red>Pending</font>';}else{echo '<font color=green>Success</font>';}?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
</div>
<?php
break;
case 62:
$e=$_REQUEST['id'];
$selr="select * from income where id='$e'";
$resr=mysqli_query($conn,$selr);
$rowr=mysqli_fetch_array($resr,MYSQLI_BOTH);
$eid=$rowr['userid'];
$sel="select * from recieve where dis='$eid' and plan='Pair'";
$res=mysqli_query($conn,$sel);
//$application=$row['application'];
?>
<div class="col-sm-12">
<script>
$(document).ready(function(){
$('#example1').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example1" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th colspan='9'>
</th>
</tr>
<tr>
<th>Sr.</th><th>Dist Id</th><th> Direct Amount</th><th>Date</th><th>Status</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr.</th><th>Dist Id</th><th> Direct Amount</th><th>Date</th><th>Status</th>
</tr>
</tfoot>
<tbody>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr class="text-center">
<td><?php echo $s;?></td><td><?php echo $eid;?></td><td><?php echo $row['amount'];?></td><td><?php echo $row['date'];?></td><td><?php if($row['status']==''){echo '<font color=red>Pending</font>';}else{echo '<font color=green>Success</font>';}?></td>
</tr>
<?php
$s++;
}
?>
</tbody>
</table>
</div>
</div>
<?php
break;
case 69:
$check=$_POST['check'];
$side=$_POST['side'];
$sel="select * from tree where userid='$check' and `$side`!='' order by id desc ";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
if($row)
{
echo 'Your Side ' .$side. ' is Already Fill ' ;
}
else
{
echo 'Your Side '. $side . ' is Available ' ;
}
break;
////for direct
}
?>