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: summary.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']=='deletea')
{
	$itec_id=$_GET['cid'];
	//$gdiv="gotodiv".$_REQUEST[countd];
	mysqli_query($con,"delete from `stock` where `st_id`='$itec_id'");
	$_SESSION['msg']=message('The Entry is deleted successfully',1);
	header("Location: ".basename(__FILE__)."?in_page=$_REQUEST[page]&cusname=$_REQUEST[cusname]&cusname=$_REQUEST[fromdate]&cusname=$_REQUEST[todate]#$gdiv");
	exit();
}
if(isset($_GET['action']) && $_GET['action']=='deleteb')
{
	$itec_id=$_GET['cid'];
	//$gdiv="gotodiv".$_REQUEST[countd];
	mysqli_query($con,"delete from `order` where `or_id`='$itec_id'");
	$_SESSION['msg']=message('The Entry is deleted successfully',1);
	header("Location: ".basename(__FILE__)."?in_page=$_REQUEST[page]&cusname=$_REQUEST[cusname]&cusname=$_REQUEST[fromdate]&cusname=$_REQUEST[todate]#$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']:"";
if($_REQUEST['blyr']!="") {
	$year=$_REQUEST['blyr'];
} else {
	$year=date("Y");
}
$lyear=$year-1;
$lastdate=$lyear."-12-31";
unset($_SESSION['dttot']);
$tota=0;
$totb=0;
$totatot=0;
$totbtot=0;
$resortot=mysqli_query($con,"select * from `order` a where a.cusname='".$_REQUEST['cusname']."' and a.cdate<='".$lastdate."'");
while($rowortot=mysqli_fetch_array($resortot)) {
	$totatot+=$rowortot['totamount'];
}
$ressttot=mysqli_query($con,"select * from `stock` a where a.cusname='".$_REQUEST['cusname']."' and a.cdate<='".$lastdate."'");
while($rowsttot=mysqli_fetch_array($ressttot)) {
	$totbtot+=$rowsttot['totamount'];
}
if($_REQUEST['fromdate']=="" && $_REQUEST['todate']=="") {
	$lastbalance=$totatot-$totbtot;
	if($lastbalance>0) {
		$totb=abs($lastbalance);
	} else {
		$tota=abs($lastbalance);
	}
}
$rowcs=mysqli_fetch_array(mysqli_query($con,"select * from `customer` where `adv_id`='".$_REQUEST['cusname']."'"));	
$sql="select distinct a.cdate from `order` a where a.cusname='".$_REQUEST['cusname']."' and a.cdate>'".$lastdate."'";
//$sql="select distinct a.cdate from `order` 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";
$record=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($record)) {
	if(!@in_array($row['cdate'],$_SESSION['dttot']) && $row['cdate']!="") {
		$_SESSION['dttot'][]=$row['cdate'];
	}		
}
$sql="select distinct a.cdate from `stock` a where a.cusname='".$_REQUEST['cusname']."' and a.cdate>'".$lastdate."'";
//$sql="select distinct a.cdate 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";
$record=mysqli_query($con,$sql);
while($row=mysqli_fetch_array($record)) {
	if(!@in_array($row['cdate'],$_SESSION['dttot']) && $row['cdate']!="") {
		$_SESSION['dttot'][]=$row['cdate'];
	}	
}
rsort($_SESSION['dttot']);
//$rowa=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 dela(aa,bb,cc,dd,ee) {
	var a=confirm("Are you sure, you want to delete?")
	if (a) {
		location.href="summary.php?cid="+aa+"&action=deletea&page="+bb+"&cusname="+cc+"&fromdate="+dd+"&todate="+ee;
	}  
} 
function delb(aa,bb,cc,dd,ee) {
	var a=confirm("Are you sure, you want to delete?")
	if (a) {
		location.href="summary.php?cid="+aa+"&action=deleteb&page="+bb+"&cusname="+cc+"&fromdate="+dd+"&todate="+ee;
	}  
}
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="summary.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="summary.php?cusname=<?php print $_REQUEST['cusname']; ?>" class="light_text_bold">Show All/Current</A>
					&nbsp;&nbsp;&nbsp;&nbsp;
				    <SELECT NAME="cusname" id="cusname" style="border:1px solid #D7D7D7;height:25px;" required onChange="document.ff.submit();">
					<OPTION VALUE="" SELECTED>Select Customer
					<?php
					$sql5="select * from `customer` 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>
					&nbsp;&nbsp;&nbsp;&nbsp;
					<SELECT NAME="blyr" id="blyr" style="border:1px solid #D7D7D7;height:25px;">
					<OPTION VALUE="" SELECTED>Select Year
					<?php
					$dyr=date("Y")-1;
					for($i=2018;$i<=$dyr;$i++)
					{
					?>
						<OPTION VALUE="<?php print $i; ?>" <?php if($_REQUEST['blyr']==$i) print "selected"; ?>>From <?php print $i; ?>
					<?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="17%" align="left" valign="middle">Cash Out</th>
							 <th width="17%" align="left" valign="middle">Cash In</th>
							 <th width="16%" align="left" valign="middle">Option</th>
						  </tr>
						  
								<?php
								$record=count($_SESSION['dttot']);
								if($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;	
								 foreach($_SESSION['dttot'] as $val)
								 {  
								    if($val!="") {
										$resa=mysqli_query($con,"select * from `stock` where `cdate`='".$val."' and `cusname`='".$_REQUEST['cusname']."'");
										while($rowa=mysqli_fetch_array($resa)) {
											$tota+=$rowa['totamount'];
									?>
											<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 $rowa['sdate'];?></p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $rowa['pdetails'];?></p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $rowa['totamount'];?></p></td>
											<td align="left"><p style="padding-left:5px;">&nbsp;</p></td>
											<td align="left">
												<input name="edit" type="button" onClick="window.location.href='add_stock.php?s_id=<?php echo $rowa['st_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">
												<input name="del" type="button" onClick="dela('<?php echo $rowa['st_id']; ?>','<?php echo $page; ?>','<?php echo $_REQUEST['cusname']; ?>','<?php echo $_REQUEST['fromdate']; ?>','<?php echo $_REQUEST['todate']; ?>');" value="Delete">
											</td>
											</tr>
									<?php 
											$a++;
											$countd++;
										}	
									}	
									 if($val!="") {
										$resb=mysqli_query($con,"select * from `order` where `cdate`='".$val."' and `cusname`='".$_REQUEST['cusname']."'");
										while($rowb=mysqli_fetch_array($resb)) {
											$totb+=$rowb['totamount'];
									?>
											<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 $rowb['sdate'];?></p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $rowb['sdetails'];?></p></td>
											<td align="left"><p style="padding-left:5px;">&nbsp;</p></td>
											<td align="left"><p style="padding-left:5px;"><?php echo $rowb['totamount'];?></p></td>
											<td align="left">
												<input name="edit" type="button" onClick="window.location.href='add_order.php?s_id=<?php echo $rowb['or_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">
												<input name="del" type="button" onClick="delb('<?php echo $rowb['or_id']; ?>','<?php echo $page; ?>','<?php echo $_REQUEST['cusname']; ?>','<?php echo $_REQUEST['fromdate']; ?>','<?php echo $_REQUEST['todate']; ?>');" value="Delete">
											</td>
											</tr>
								<?php 
											$a++;
											$countd++;
										}	
									}	
								  }
								}
								$blc=$tota-$totb;
								?>
							<?php if($_REQUEST['fromdate']=='' && $_REQUEST['todate']=='') { ?>	
								<tr>
								 <td colspan="3" align="center">&nbsp;</td>
								 <td align="left"><strong><?php if($lastbalance<0) { ?>Opening Balance<br>Rs. <?php print number_format(abs($lastbalance)); } ?></strong></td>
								 <td align="left"><strong><?php if($lastbalance>=0) { ?>Opening Balance<br>Rs. <?php print number_format($lastbalance); } ?></strong></td>
								 <td align="center">&nbsp;</td>
							    </tr>
							<?php } ?>		
							<tr>
							<td align="right">&nbsp;</td>
							<td align="right">&nbsp;</td>
							<td align="right">&nbsp;</td>
							<td align="left"><strong>Total Cash Out<br>Rs. <?php print number_format($tota); ?></strong></td>
							<td align="left"><strong>Total Cash In<br>Rs. <?php print number_format($totb); ?></strong></td>
							<td align="right">&nbsp;</td>
							</tr>
							<tr>
							<td align="left" colspan="3"><?php if($record>0) { ?><a href="converttoexcelsm.php?cusname=<?php print $_REQUEST['cusname']; ?>&fromdate=<?php print $_REQUEST['fromdate']; ?>&todate=<?php print $_REQUEST['todate']; ?>" class="alink2">Export to Excel</a><?php } ?></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: summary.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation