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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: bsummaryoldprt.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$table="cust_acc";
$pkey="id";
$status="status";
include("includes/headermain.php"); 
?>
<script language="javascript" type="text/javascript">
function PrintDivData(crtlid) {
	var ctrlcontent=document.getElementById(crtlid);
	var printscreen=window.open('','','left=0,top=0,width=1350,toolbar=0,scrollbars=0,status=0');
	printscreen.document.write(ctrlcontent.innerHTML);
	printscreen.document.close();
	printscreen.focus();
	printscreen.print();
	printscreen.close();
}
</script>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">
	
	<?php include("includes/leftmenu.php"); ?>
	
	
	<div class="main-content">
		
		<?php include("includes/header.php"); ?>
		
	 	<div class="main-content-inner">
			
			<div> 
				<div class="col-lg-12 mt-4">
					<div class="card">
						<div class="card-body">
							<button type="button" class="btn btn-primary pr-4 pl-4 floatleft" onClick="PrintDivData('dprint');">Print</button>
							<div class="cleaner h20"></div>
							<div id="dprint">
								<table width="100%" border="1">
									<thead>
										<tr>
											<td colspan="7" align="left" style="padding: 5px;font-size: 20px;"><strong>Old Paka Summary - <?php print date("Y"); ?></strong></td>
										</tr>
										<tr>
											<td align="left" style="padding: 5px;">Sl.</td>
											<td align="left" style="padding: 5px;">Date</td>
											<td align="left" style="padding: 5px;">Name</td>
											<td align="left" style="padding: 5px;">Bill No.</td>
											<td align="left" style="padding: 5px;">Bill Amount</td>
											<td align="left" style="padding: 5px;">Payment</td>
											<td align="left" style="padding: 5px;">Note</td>
										</tr>
									</thead>
									<tbody>
										<?php
										$expense=0;
										$payment=0;
										$sql="select * from `".$table."` where `".$status."`!='1'";
										if(isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']!="") {
											$sql.=" and `customer`='".$_REQUEST['cusvl']."'";
										}
										if(isset($_REQUEST['fdtvl']) && $_REQUEST['fdtvl']!="") {
											$sql.=" and `date`>='".$_REQUEST['fdtvl']."'";
										}
										if(isset($_REQUEST['tdtvl']) && $_REQUEST['tdtvl']!="") {
											$sql.=" and `date`<='".$_REQUEST['tdtvl']."'";
										}
										$sql.=" order by `date`";
										$res=mysqli_query($con,$sql);
										if(isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']!="") {
											$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `customer_master` where `id`='".$_REQUEST['cusvl']."'"));
											$rowop=mysqli_fetch_assoc(mysqli_query($con,"select sum(bamount) as `ardep`, sum(payment) as `arwth` from `".$table."` where `customer`='".$_REQUEST['cusvl']."' and (`".$status."`!='0' && `".$status."`!='1')"));
											$opbalance=$rowop['ardep']-$rowop['arwth'];
										?>
											<tr <?php if($row[$status]=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
												<td align="left"><?php print $flag; ?></td>
												<td align="left"></td>
												<td align="left"><?php print stripslashes($rowc['name']); ?></td>
												<td align="left"></td>
												<td align="left"><?php if($opbalance>=0) { print number_format(abs($opbalance),2); } ?></td>
												<td align="left"><?php if($opbalance<0) { print number_format(abs($opbalance),2); } ?></td>
												<td align="left">Opening Balance</td>
												<td align="left">&nbsp;</td>
											</tr>
										<?php	
											if($opbalance>0) {
												$bamount+=abs($opbalance);
											} else {
												$payment+=abs($opbalance);
											}		
										}
										if(mysqli_num_rows($res)>=1) {
											while($row=mysqli_fetch_assoc($res)) {
												$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `customer_master` where `id`='".$row['customer']."'"));
												$bamount+=$row['bamount'];
												$payment+=$row['payment'];
										?>
												<tr <?php if($row[$status]=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
													<td align="left" style="padding: 5px;"><?php print $flag; ?></td>
													<td align="left" style="padding: 5px;"><?php print dtconvert($row['date']); ?></td>
													<td align="left" style="padding: 5px;"><?php print stripslashes($rowc['name']); ?></td>
													<td align="left" style="padding: 5px;"><?php print $row['blno']; ?></td>
													<td align="left" style="padding: 5px;"><?php print number_format($row['bamount'],2); ?></td>
													<td align="left" style="padding: 5px;"><?php print number_format($row['payment'],2); ?></td>
													<td align="left" style="padding: 5px;"><?php print stripslashes($row['note']); ?></td>
												</tr>
										<?php } ?>
											<tr class="sbg4">
												<td align="right" colspan="4" style="padding: 5px;"><strong>Total</td>
												<td align="left" style="padding: 5px;"><strong><?php print number_format($bamount,2); ?></strong></td>
												<td align="left" style="padding: 5px;"><strong><?php print number_format($payment,2); ?></strong></td>
												<td align="left" style="padding: 5px;"><strong><?php print number_format(($bamount-$payment),2); ?></strong></td>
												<td align="right">&nbsp;</td>
											</tr>
										<?php } else { ?>
											<tr>
												<td colspan="9">Sorry, nothing found.</td>
											</tr>
										<?php } ?>	
									</tbody>
								</table>
							</div>
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bsummaryoldprt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation