Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/gkindus

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: ledgerbkp.php

<?php
ob_start();
session_start();
include("includes/logincheck.php");
include("includes/connection.php");
include("includes/functions.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'cc=cc');

if(isset($_GET['action']) && $_GET['action']=='delete')
{
	$itec_id=$_GET['cid'];
	$gdiv="gotodiv".$_REQUEST[countd];
	mysqli_query($con,"delete from `order` where `or_id`='$itec_id'");
	mysqli_query($con,"delete from `orderpro` where `op_ref`='$itec_id'");
	$_SESSION['msg']=message('The Entry is deleted successfully',1);
	header("Location: ".basename(__FILE__)."?in_page=$_REQUEST[page]&adv_name=$_REQUEST[adv_name]#$gdiv");
	exit();
}
if(isset($_GET['action']) && $_GET['action']=='inactive')
{
	 $item_id=$_GET['cid'];
	 $gdiv="gotodiv".$_REQUEST[countd];
	$sql32="select * from `orderpro` where `op_ref`='$item_id'";
	$res32=mysqli_query($con,$sql32);
	while($row32=mysqli_fetch_array($res32))
	    {
	     $sql31="select * from `product` where `pro_id`='$row32[op_pro]'";
		 $res31=mysqli_query($con,$sql31);
		 $row31=mysqli_fetch_array($res31);
		 $stock=$row31[pro_stock]+$row32[op_qty];
		 mysqli_query($con,"update `product` set `pro_stock`='$stock' where `pro_id`='$row32[op_pro]'");
		}
	mysqli_query($con,"update `order`  set `or_st`='0' where `or_id`='".$item_id."'");
	$_SESSION['msg']=message('Updated successfully',1);
	header("Location: ".basename(__FILE__)."?in_page=$_REQUEST[page]&adv_name=$_REQUEST[adv_name]#$gdiv");
	exit();
}

if(isset($_GET['action']) && $_GET['action']=='active')
{
	 $item_id=$_GET['cid'];
	 $gdiv="gotodiv".$_REQUEST[countd];
	 $sql="update `order` set `or_st`='1' where `or_id`='".$item_id."'";
	mysqli_query($con,$sql);
	$_SESSION['msg']=message('Updated successfully',1);
	header("Location: ".basename(__FILE__)."?in_page=$_REQUEST[page]&adv_name=$_REQUEST[adv_name]#$gdiv");
	exit();
}

if(isset($_GET['search']))
{
	$keyword=$_GET['in_keyword'];	
	$recperpage=$_GET['in_recperpage'];
}
else
{
	$keyword="";	
	$recperpage=10;
}
$start_key=isset($_GET['in_start_key'])?$_GET['in_start_key']:"";

$sql="select * from `order` a, `customer` c where  a.cusname=c.adv_id ";

if($keyword!="")
{
	$key=filter($keyword);
	$sql=$sql." and p.pro_name like '%$key%'";				
	
}

if($start_key!="")
	$sql=$sql." and p.pro_name like '$start_key%'";

if($_REQUEST[adv_name])
{
  $sql=$sql." and a.sdate = '$_REQUEST[adv_name]'";
}

$sql=$sql." order by a.or_id desc";

$total_count=mysqli_num_rows(mysqli_query($con,$sql));

//-----------------------------------/Pagination------------------------------
/*
if(isset($_GET['in_page'])&& $_GET['in_page']!="")
	$page=$_GET['in_page'];
else
	$page=1;

$total_count=mysqli_num_rows(mysqli_query($con,$sql));
$sql=$sql." limit ".(($page-1)*$recperpage).", $recperpage";

if($page>1)
	{
		$url_next=stristr($url,"&in_page=".$page)==FALSE?$url."&in_page=".($page+1):str_replace("&in_page=".$page,"&in_page=".($page+1),$url);
		$next="<a href='$url_next' class='small_link'>Next</a>";
	}
	else
		$prev="Prev";
		
	if((($page)*$recperpage)<$total_count)
	{
		$url_next=stristr($url,"&in_page=".$page)==FALSE?$url."&in_page=".($page+1):str_replace("&in_page=".$page,"&in_page=".($page+1),$url);
		$next="<a href='$url_next' class='small_link'>Next</a>";
	}
	else
		$next="Next";
		
	$page_temp=(($page)*$recperpage);
	$page_temp=$page_temp<$total_count?$page_temp:$total_count;
	$showing=" Showing ".(($page-1)*$recperpage+1)." - ".$page_temp." of ".$total_count." | ";*/

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <TITLE>BILLING MANAGEMENT SYSTEM</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<meta name="Description" content="">
 <meta name="Keywords" content="">
 <meta name="robots" content="index,follow">

 <script type="text/javascript" src="./js/validate.js"></script>
 <link href="./css/style.css" rel="stylesheet" type="text/css" title="default">
 <script language="javascript">
function del(aa,bb,cc,dd)
{
  var a=confirm("Are you sure, you want to delete?")
  if (a)
  {
	location.href="list_order.php?cid="+aa+"&action=delete&page="+bb+"&countd="+cc+"&adv_name="+dd
  }  
} 
function inactive(aa,bb,cc,dd) 
   {
	  var a=confirm("Are you sure, you want to cancel?")
	  if (a)
	  {
        location.href="list_order.php?cid="+ aa +"&action=inactive&page="+bb+"&countd="+cc+"&adv_name="+dd
	  }
    } 
   function active(aa,bb,cc,dd)
   {
	   var a=confirm("Are you sure, you want to approve?")
	  if (a)
	  {
      location.href="list_order.php?cid="+ aa +"&action=active&page="+bb+"&countd="+cc+"&adv_name="+dd
	  }
   }
</script>
<script language="javascript">
    function report()
	{
		var fromd=document.getElementById("eventstartdate2").value;
		var tod=document.getElementById("eventstartdate3").value;
		location.href="converttoexcel2.php?fromd="+fromd+"&tod="+tod
	}
 </script>
 <script type='text/javascript' src="./zpcal/utils/zapatec.js"></script>
<script type="text/javascript" src="./zpcal/src/calendar.js"></script>
<script type="text/javascript" src="./zpcal/lang/calendar-en.js"></script>
<link href="./zpcal/website/css/zpcal.css" rel="stylesheet" type="text/css">
<link href="./zpcal/themes/aqua.css" rel="stylesheet" type="text/css">
 </HEAD>
<BODY>

<?php include("includes/header7.php"); ?>

<div class="innercontent">
<div style="float:right;font-family:arial;font-size:.8em;">Logged in as <B>Admin</B>&nbsp;&nbsp;&nbsp;</div>
<div class="cleaner h5"></div>
&nbsp;&nbsp;&nbsp;<FONT style="font-size:1em;font-family:calibri;text-transform:uppercase;"><B>View Order List</B></FONT>
<hr color="#D8E1F5" style="height:10px;">
<div class="cleaner h10"></div>
<div class="deeparea" style="padding-top:20px;text-align:center;background:#fff;">

               <table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
                     <tr><td>
                         <table width="100%" border="0" align="center" cellpadding="2" cellspacing="2" >
			
				  <tr>
					<td align="center" colspan="2">
					  <form action="ledger.php" method="post" name="ff">
					   From Date : 
					   <input type="text" name="fromdate" id="eventstartdate2"  style="border:1px solid #D7D7D7;height:25px;" required  readonly="readonly" size="10" value="<?php print $_REQUEST[fromdate]; ?>">
					   <span id="cal12">
					   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
					   <script type="text/javascript">
					   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate2",
						ifFormat:"%d-%m-%Y",
						button:"cal12",
						showsTime:false

});
						</script>(Format 02-03-2014)
						&nbsp;&nbsp;&nbsp;&nbsp;
					   To Date : 
					   <input type="text" name="todate" id="eventstartdate3"  style="border:1px solid #D7D7D7;height:25px;" required  readonly="readonly" size="10" value="<?php print $_REQUEST[todate]; ?>">
					   <span id="cal15">
					   <img src="./images/calendar.jpg" style="cursor:pointer;" /></span>
					   <script type="text/javascript">
					   var cal = new Zapatec.Calendar.setup({

inputField:"eventstartdate3",
						ifFormat:"%d-%m-%Y",
						button:"cal15",
						showsTime:false

});
						</script>(Format 02-03-2014)
					   &nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" value="Search" name="sear" class="subbut">
					   </form>
					</td>
					</tr>

<!--  <form action="<?php echo basename(__FILE__);?>" method="get" name="ff" id="ff">
                         <input type="hidden" name="in_start_key" value="<?php echo $start_key;?>" />

<tr> 
							  <td colspan="3" valign="top" align="center" style="cursor:default;padding:10px;font-size:.8em;font-family:arial;color:#484848;background:#DFEFFF;font-weight:bold;">
									Search By order Initials : <a class="light_text_bold" href="<?php echo basename(__FILE__);?>?in_recperpage=<?php echo $recperpage;?>&amp;in_keyword=<?php echo $keyword;?>&amp;in_start_key=&amp;search=+Search+" title="ALL"><font color="<?php echo $start_key==""?"#0098E1":""?>">ALL</font></a>&nbsp;
									<?php for($i=65;$i<=90;$i++)
										{
											$chrval=chr($i);
										?>
											<a class="light_text_bold" href="<?php echo basename(__FILE__);?>?in_recperpage=<?php echo $recperpage;?>&amp;in_keyword=<?php echo $keyword;?>&amp;in_start_key=<?php echo $chrval;?>&amp;search=+Search+" title="<?php echo $chrval;?>"><font color="<?php echo $start_key==$chrval?"#0098E1":""?>"><?php echo $chrval;?></font></a>&nbsp;
										<?php }?>	  
							 </td>
						  </tr> -->

</form>
                       </table>

</td>
			    </tr>
                </table>

<tr>
				<td>
						<table width="100%" border="0" cellspacing="0" cellpadding="7" class="bodytitle">
								  <tr>
									<td align="left" width="60%">Show <b>Order(s)</b> </td>
									<td align="right" width="20%">&nbsp;
									
									</td>
									<td align="right" width="20%">&nbsp;<?php echo $total_count;?> Record(s) found &nbsp;</td>
								  </tr>
						</table>
				</td>
				</tr>

<tr>
				<td>
				       <form action="billprint.php" method="post">
						<table width="100%" border="0" align="center" cellpadding="5" cellspacing="2" style="font-size:.9em;font-family:arial;color:#3A3A3A;">
						<tr>
							<td colspan="9" align="center"><INPUT TYPE="submit" VALUE="Print" name="prsub"></td>
						</tr>
						  <tr style="background:#F7F5E0;">
						     <th width="12%" align="center" valign="middle">Date</th>
							 <th width="35%" align="center" valign="middle">Customer Name</th>
							 <th width="12%" align="center" valign="middle">Bill No.</th>
							 <th width="12%" align="center" valign="middle">Gross Total</th>
						     <th width="12%" align="center" valign="middle">Sales @<BR>14.5%</th>
							 <th width="12%" align="center" valign="middle">Output Vat @<BR>14.5%</th>
							 <th width="12%" align="center" valign="middle">Output Vat @<BR>5%</th>
							 <th width="12%" align="center" valign="middle">Output Vat @<BR>0%</th>
							 <th width="12%" align="center" valign="middle">Rounded Off</th>
						  </tr>
								<?php
								$record=mysqli_query($con,$sql);
								if(mysqli_num_rows($record)==0)
								{?>
								  <tr>
									<td height="50" colspan="9" align="center">Sorry, 
									  No Record Found.</td>
								  </tr>
								  <?php 
								}
								else
								{
								?>
							  
								<?php
								$flag=0;
								if($page==1)
								 {
								 $a=1;
								 }
								 else{
								 $a=(($page-1)*25)+1;
								 }
								 $countd=1;
								while($row=mysqli_fetch_array($record))
								{
									$netratewithouttax=0;
									$totam=0;
									$vattaxfive=0;
									$vattaxfteen=0;
									$vattaxzero=0;
									$tot=0;
									$totm=0;
									$vatfive=0;
									$vatzero=0;
									$vatfteen=0;
									$sql2="select * from `product` p, `orderpro` op where op.op_ref='$row[or_id]' and op.op_free='' and op.op_pro=p.pro_id";
									$res2=mysqli_query($con,$sql2);
									while($row2=mysqli_fetch_array($res2))
									{
                                    $netratewithouttax=($row2[pro_rate]*$row2[op_qty]);
									$sdis=$netratewithouttax*($row2[op_sdis]/100);
									$cdis=$netratewithouttax*($row2[op_cdis]/100);
									$netratewithouttax=$netratewithouttax-($sdis+$cdis);
									if($row2[pro_tax]=="5" || $row2[pro_tax]=="5.0" || $row2[pro_tax]=="5.00" || $row2[pro_tax]=="05")
										{
										 $vattaxfive+=$netratewithouttax;
										}
									 if($row2[pro_tax]=="14.5" || $row2[pro_tax]=="14.50")
										{
										 $vattaxfteen+=$netratewithouttax;
										}
									 if($row2[pro_tax]=="0" || $row2[pro_tax]=="0.00" || $row2[pro_tax]=="00.00")
										{
										 $vattaxzero+=$netratewithouttax;
										}
									  $vatzero=0;
									  $vatfive=round($vattaxfive*(5/100),2);
									  $vatfteen=round($vattaxfteen*(14.5/100),2);
									  $tot=$vattaxfive+$vattaxfteen+$vattaxzero;
									  $totm=round(($vatfive+$vatfteen+$tot),2);
									}
								?>

<tr class="<?php echo ++$flag%2==0?"alternate_color1":"alternate_color2";?>" onMouseOver="this.className='hover_color'" onMouseOut="this.className='<?php echo $flag%2==0?"alternate_color1":"alternate_color2";?>'" id="gotodiv<?php print $countd; ?>">
					<td align="center"><p style="padding-left:5px;">
					<?php echo $row[sdate];?></p></td>
					<td align="left"><p style="padding-left:5px;">
					<?php echo stripslashes($row[adv_name]);?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo $row[or_bill];?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo $row[totamount];?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo round($tot,2);?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo $vatfteen;?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo $vatfive;?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php echo 0;?></p></td>
					<td align="center"><p style="padding-left:5px;">
					<?php 
						$rou=round(($row[totamount]-$totm),2);
					    if($rou<0) { print $rou; }
						if($rou>0) { print "+".$rou; }
					?></p></td>
				    </tr>

<?php 
					  $a++;
					  $countd++;
					  }
					}
					?>

</table>
				 </form>
               </td>

</table>

</div>
</div>

<?php include("includes/footer.php"); ?>

</div>

</BODY>
</HTML>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ledgerbkp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation