|
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/swrampyarejan.in/public_html/admin/../code/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../link/databaseconnection.php");
$flag=$_REQUEST['flag'];
error_reporting(0);
switch($flag)
{
case 1:
$class=$_POST['class'];
$class1=strtoupper($class);
$ins="insert into class(class1) values('$class1')";
if($class!='')
{
if(mysqli_query($conn,$ins))
{
echo "Successfully Add";
}
else
{
echo "not insert";
}
}
else
{
echo"Please Fill Box";
}
break;
case 2:
$sel="select * from class order by id desc";
$res=mysqli_query($conn,$sel);
?>
<div class="table-responsive">
<table class="table table-stript">
<tr>
<th>Sr No.</th><th>Class</th><th>Delete</th>
</tr>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr>
<td><?php echo $s++;?></td><td><?php echo $row['class1'];?></td><td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
<?php
}
?>
</tr>
</table>
</div>
<?php
break;
case 3:
$rowid=$_POST["rowid"];
$del="delete from class where id='$rowid'";
if(mysqli_query($conn,$del))
{
echo"Data deleted";
}
else
{
echo"not delete";
}
case 4:
$class=$_POST['class'];
$board=$_POST['board'];
$subclass1=$_POST['subclass'];
$subclass=strtoupper($subclass1);
if($class!='' and $subclass!='')
{
$ins="insert into subclass(classname,subclass,board) values('$class','$subclass','$board')";
if(mysqli_query($conn,$ins))
{
echo"successfully Add";
}
else
{
echo"not add";
}
}
else
{
echo"Fillup Box";
}
break;
case 5:
$sel="select * from subclass order by subclassid desc";
$res=mysqli_query($conn,$sel);
?>
<div class="table-responsive">
<table class="table table-stript">
<tr>
<th>Sr No.</th><th>Board</th><th>Class</th><th>SubClass</th><th>Delete</th>
</tr>
<?php
$s=1;
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?>
<tr>
<td><?php echo $s++;?></td><td><?php echo $row['board'];?></td><td><?php echo $row['classname'];?></td>
<td><?php echo $row['subclass'];?></td><td><a href="javascript:;" onclick="deleterow(<?php echo $row['0'];?>)"><span class="glyphicon glyphicon-trash"></span></a></td>
</tr>
<?php
}
?>
</table>
</div>
<?php
break;
case 6:
$id=$_POST['rowid'];
$del=" update bill set status='Delete' where id='$id'";
if(mysqli_query($conn,$del))
{
echo"Delete Success";
}
else
{
echo"not delete";
}
break;
case 41:
$description=$_POST['description'];
$name=$_POST['name'];
$amount=$_POST['amount'];
$mobile=$_POST['mobile'];
$address=$_POST['address'];
date_default_timezone_set('asia/kolkata');
$date=date('Y-m-d');
//$subclass=strtoupper($subclass1);
$time=date("h:i:sa");
if($description!='' and $name!='' )
{
$ins="insert into bill(description,name,amount,date,time,status,mobile,address) values('$description','$name','$amount','$date','$time','','$mobile','$address')";
if(mysqli_query($conn,$ins))
{
echo"successfully Add";
}
else
{
echo"not add";
}
}
else
{
echo"Fillup Box";
}
break;
case 411:
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['pdf','print','excel']
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Sr No.</th><th>Name</th><th>Address</th><th>Description</th><th>Amount</th><th>Date</th><th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sel="select * from bill where status='' order by id desc limit 50";
$res=mysqli_query($conn,$sel);
$s=1;
$am='';
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$date1=$row['date'];
$am=$row['amount']+$am;
$date=date("d-m-Y",strtotime($date1));
?>
<tr>
<td><?php echo $s++;?></td><td><?php echo $row['name'];?></td><td><textarea rows="3" cols="30"><?php echo $row['address'].',mob-'.$row['mobile'];?></textarea></td><td><textarea rows="3" cols="30"><?php echo $row['description'];?></textarea></td>
<td><?php echo $row['amount'];?></td><td><?php echo $date.','.$row['time'];;?></td><td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash">Delete</span></a> <a href="bill.php?flag=<?php echo $row['id']?>" target='_blank'><span class="glyphicon glyphicon-print">print</span></a></td>
</tr>
<?php
}
$am;
?>
</tbody>
</table>
</div>
<?php
break;
case 412:
$eid=$_REQUEST['id'];
//echo"$eid";
$sel="select * from hisab 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;
date_default_timezone_set('asia/kolkata');
$date=date('Y-m-d');
?>
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-body">
<form class="form-horizontal" id="myform" onsubmit="return updaterow(this)">
<div class="form-group">
<input type="hidden" value="<?php echo $row['id'];?>" name="id"/>
<input type="hidden" value="<?php echo $date;?>" name="date"/>
<label class="col-sm-3 control-label">Article</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['product'];?>" name="product"/></div>
</div>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Purpose</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['purpose'];?>" name="purpose"/></div>
</div>
<br/>
<br/>
<div class="form-group">
<label class="col-sm-3 control-label">Amount</label>
<div class="col-sm-8"><input type="text" class="form-control" value="<?php echo $row['amount'];?>" name="amount"/></div>
<br/>
</div>
<center><button class="btn btn-primary">Update</button>
   <button class="btn btn-danger" data-dismiss="modal"> Close</button>
</center>
</div>
</form>
</div>
</div>
<?php
break;
case 413:
$id=$_POST['id'];
$product=$_POST['product'];
$amount=$_POST['amount'];
//$mname=$_POST['mname'];
//$dob=$_POST['dob'];
//$class=$_POST['class'];
//$subject=$_POST['subject'];
//$add=$_POST['add'];
$purpose=$_POST['purpose'];
date_default_timezone_set('asia/kolkata');
$date=date('Y-m-d');
$time=date("h:i:sa");
$sel="select * from hisab where id='$id'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$up="update hisab set product='$product',purpose='$purpose',date='$date',amount='$amount' where id='$id' ";
if(mysqli_query($conn,$up))
{
echo"Update";
}
else
{
echo"not update";
}
break;
case 414:
?>
<script>
$(document).ready(function() {
$('#example').DataTable( {
fixedHeader: true,
dom: 'Bfrtip',
lengthMenu: [
[ 10, 25, 50, -1 ],
[ '10 rows', '25 rows', '50 rows', 'Show all' ]
],
buttons: [
'pageLength','print','excel',
{ extend: 'pdfHtml5', footer: true,
orientation: 'protland',
pageSize: 'LEGAL'
}
]
} );
} );
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Sr No.</th><th>Name</th><th>Address</th><th>Description</th><th>Amount</th><th>Date</th><th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sdate=$_POST['sdate'];
$edate=$_POST['edate'];
$description=$_POST['description'];
if($description=='All')
{
$sel="select * from bill where date between '$sdate' and '$edate' and status='' order by id asc ";
}
else
{
$sel="select * from bill where date between '$sdate' and '$edate' and status='' and description='$description' order by id asc ";
}
$res=mysqli_query($conn,$sel);
$s=1;
$am='0';
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$date1=$row['date'];
$am=$row['amount']+$am;
$date=date("d-m-Y",strtotime($date1));
?>
<tr>
<td><?php echo $s++;?></td><td><?php echo $row['name'];?></td><td><textarea rows="3" cols="30"><?php echo $row['address'].',mob-'.$row['mobile'];?></textarea></td><td><textarea rows="3" cols="30"><?php echo $row['description'];?></textarea></td>
<td><?php echo $row['amount'];?></td><td><?php echo $date.','.$row['time'];;?></td><td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-trash">Delete</span></a> <a href="bill.php?flag=<?php echo $row['id']?>" target='_blank'><span class="glyphicon glyphicon-print">print</span></a></td>
</tr>
<?php
}
?>
<tr align="center">
<td style="font-weight:bold;font-size:19px">Total</td><td></td><td></td><td style="font-weight:bold;font-size:19px;color:red"></td><td style="font-weight:bold;font-size:19px;color:red"><?php echo $am;?> (Rs)</td><td style="font-weight:bold;font-size:19px;color:green"></td><td style="font-weight:bold;font-size:19px;color:green">
</tr>
</tbody>
</table>
</div>
<?php
break;
case 4141:
?>
<script>
$(document).ready(function() {
$('#example').DataTable( {
fixedHeader: true,
dom: 'Bfrtip',
lengthMenu: [
[ 10, 25, 50, -1 ],
[ '10 rows', '25 rows', '50 rows', 'Show all' ]
],
buttons: [
'pageLength','print',
{ extend: 'pdfHtml5', footer: true,
orientation: 'protland',
pageSize: 'LEGAL'
}
]
} );
} );
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr>
<th>Sr No.</th><th>Name</th><th>Address</th><th>Description</th><th>Amount</th><th>Date</th><th>Action</th>
</tr>
</thead>
<tbody>
<?php
$sdate=$_POST['sdate'];
$edate=$_POST['edate'];
// $sesion=$row['session'];
$sel="select * from bill where date between '$sdate' and '$edate' and status='Delete' order by id asc ";
$res=mysqli_query($conn,$sel);
$s=1;
$am='0';
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$date1=$row['date'];
$am=$row['amount']+$am;
$date=date("d-m-Y",strtotime($date1));
?>
<tr>
<td><?php echo $row['id'];?></td><td><?php echo $row['name'];?></td><td><textarea rows="3" cols="30"><?php echo $row['address'].',mob-'.$row['mobile'];?></textarea></td><td><textarea rows="3" cols="30"><?php echo $row['description'];?></textarea></td>
<td><?php echo $row['amount'];?></td><td><?php echo $date.','.$row['time'];;?></td><td><a href="javascript:;" onclick="deleterow(<?php echo $row['id'];?>)"><span class="glyphicon glyphicon-refresh">Restore</span></a> <a href="bill.php?flag=<?php echo $row['id']?>" target='_blank'><span class="glyphicon glyphicon-print">print</span></a></td>
</tr>
<?php
}
?>
<tr align="center">
<td style="font-weight:bold;font-size:19px"></td><td></td><td></td><td style="font-weight:bold;font-size:19px;color:red"></td><td style="font-weight:bold;font-size:19px;color:red"><?php echo $am;?> (Rs)</td><td style="font-weight:bold;font-size:19px;color:green"></td><td style="font-weight:bold;font-size:19px;color:green">
</tr>
</tbody>
</table>
</div>
<?php
break;
case 60:
$id=$_POST['rowid'];
$del=" update bill set status='' where id='$id'";
if(mysqli_query($conn,$del))
{
echo"Restore Success";
}
else
{
echo"not delete";
}
break;
}
?>