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/systema

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: summarydrv.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];
	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']:"";
unset($_SESSION['dttot']);
$rowcs=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `adv_id`='".$_REQUEST['cusname']."'"));	
$sql="select * from `delivery` a where a.dref='".$_REQUEST['cusname']."'";
//print $sql;
if($_REQUEST['fromdate'])
{
	$da=dtconvert($_REQUEST['fromdate']);
	$sql=$sql." and a.date>='".$da."'";
}
if($_REQUEST['todate'])
{
	$da=dtconvert($_REQUEST['todate']);
	$sql=$sql." and a.date<='".$da."'";
}
$sql=$sql." order by a.date desc";
$record=mysqli_query($con,$sql);
//$row=mysqli_fetch_array(mysqli_query($con,$sql));
//$sql="select sum(totamount) totb from `stock` a where a.cusname='".$_REQUEST['cusname']."'";
//print $sql;
/*if($_REQUEST[fromdate])
{
 $ed=explode("-",$_REQUEST[fromdate]);
 $da=$ed[2]."-".$ed[1]."-".$ed[0];
 $sql=$sql." and a.cdate >= '$da'";
}
if($_REQUEST[todate])
{
  $ed2=explode("-",$_REQUEST[todate]);
  $da2=$ed2[2]."-".$ed2[1]."-".$ed2[0];
  $sql=$sql." and a.cdate <= '$da2'";
}
$sql=$sql." order by a.cdate desc";*/
//print $sql;
//$rowb=mysqli_fetch_array(mysqli_query($con,$sql));
//$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_orders.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_orders.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_orders.php?cid="+ aa +"&action=active&page="+bb+"&countd="+cc+"&adv_name="+dd
	  }
   }
</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/header.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 Summary</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="summarydrv.php" method="post" name="ff">
				  <table cellpadding="10" border="0" cellspacing="0" style="font-size:.8em;font-family:arial;color:#484848;background:#DFEFFF;font-weight:bold;">
				  <tr>
					<td valign="middle" align="center">
					<A HREF="summarydrv.php" class="light_text_bold">Show All</A>
					&nbsp;&nbsp;&nbsp;&nbsp;
				    <SELECT NAME="cusname" id="cusname" style="border:1px solid #D7D7D7;height:25px;" required>
					<OPTION VALUE="" SELECTED>Select Driver
					<?php
					$sql5="select * from `driver` where `adv_st`='1' order by `adv_name` asc";
					$res5=mysqli_query($con,$sql5);
					while($row5=mysqli_fetch_array($res5))
					{
					?>
					<OPTION VALUE="<?php print $row5[adv_id] ?>" <?php if($_REQUEST['cusname']==$row5['adv_id']) print "selected"; ?>><?php print $row5[adv_name] ?><?php if($row5[adv_pl]) { ?> (<?php print $row5[adv_pl] ?>)<?php } ?>
					<?php
					}
					?>
					</SELECT>
					<?php /*?>&nbsp;&nbsp;&nbsp;&nbsp;
					Bill No. : 
				   <input type="text" name="billno" id="billno"  style="border:1px solid #D7D7D7;height:25px;" required size="10" value="<?php print $_REQUEST['billno']; ?>"><?php */?>
				   <BR><BR>
				   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">
				   </td></tr></table>
				   </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>Summary for <?php print $rowcs['adv_name']; ?></b> </td>
									<td align="right" width="20%">&nbsp;
									
									</td>
									<?php /*?><td align="right" width="20%">&nbsp;<?php echo $total_count;?> Record(s) found &nbsp;</td><?php */?>
								  </tr>
						</table>
				</td>
				</tr>

<tr>
				<td>
				       <form action="#" method="post">
						<table width="100%" border="0" align="center" cellpadding="5" cellspacing="2" style="font-size:.9em;font-family:arial;color:#3A3A3A;">
						
						  <tr style="background:#F7F5E0;">
						     <th width="10%" align="center" valign="middle">Sl.</th>
							 <th width="16%" align="center" valign="middle">Date</th>
							 <th width="24%" align="left" valign="middle">Details</th>
							 <th width="20%" align="left" valign="middle">Credit</th>
							 <th width="20%" align="left" valign="middle">Debit</th>
							 <th width="10%" align="left" valign="middle">Option</th>
						  </tr>
								<?php
								if(mysqli_num_rows($record)==0)
								{
								?>
								  <tr>
									<td height="50" colspan="6" align="center">Sorry, 
									  No Record Found.</td>
								  </tr>
								<?php 
								}
								else
								{
								$flag=0;
								if($page==1)
								 {
								 $a=1;
								 }
								 else{
								 $a=(($page-1)*25)+1;
								 }	
								 $countd=1;
								 $tota=0;
								 $totb=0;
								while($row=mysqli_fetch_array($record))
								{
									$rowc=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `adv_id`='".$row['cref']."'"));
									$tota+=$row['amount'];
									$totb+=$row['damount'];
								?>
											<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 $countd;?></p></td>
											<td align="center"><p style="padding-left:5px;"><?php echo $row['date'];?></p></td>
											<td align="left"><p style="padding:0 0 0 5px;">For <?php echo $rowc['adv_name'];?><?php if($row['remarks']!="") { ?></p><p style="margin-top:0;padding:0 0 0 5px;">(<?php echo $row['remarks'];?>)<?php } ?></p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $row['amount'];?></p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $row['damount'];?></p></td>
											<td align="left">
												<input name="edit" type="button" onClick="window.location.href='add_delc.php?s_id=<?php echo $row['d_id']; ?>&action=edit&countd=<?php echo $countd; ?>&page=<?php echo $page; ?>&cusname=<?php echo $_REQUEST['cusname']; ?>&fromdate=<?php echo $_REQUEST['fromdate']; ?>&todate=<?php echo $_REQUEST['todate']; ?>&edits=summary'" value="Edit">
											</td>
											</tr>
									<?php 
											$a++;
											$countd++;
										}	
									}	
								$blc=$tota-$totb;
								?>
							<tr>
							<td align="right">&nbsp;</td>
							<td align="right">&nbsp;</td>
							<td align="right">&nbsp;</td>
							<td align="left"><strong>Total Cash Out : Rs. <?php print number_format($tota); ?></strong></td>
							<td align="left"><strong>Total Cash In : Rs. <?php print number_format($totb); ?></strong></td>
							<td align="right">&nbsp;</td>
							</tr>
							<tr>
							<td align="left" colspan="3">&nbsp;</td>
							<td align="right"><?php if($tota>$totb) { ?><strong>Balance : Rs. <?php print number_format(abs($blc)); ?></strong><?php } ?></td>
							<td align="right"><?php if($tota<=$totb) { ?><strong>Balance : Rs. <?php print number_format(abs($blc)); ?></strong><?php } ?></td>
							<td align="right">&nbsp;</td>
							</tr>
                 </table>
				 </form>
               </td>
           </table>
</div>
</div>

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

</div>

</BODY>
</HTML>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: summarydrv.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation