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: viewdewtoldprint.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$heading="Old Khata Summary";
//$addpage="deposit.php";
$listpage="viewdewt.php";
$table="khata_dpwt";
$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">
							<h4 class="header-title"><?php print $heading; ?></h4>
							<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="javascript:PrintDivData('dprint');">Print</button>
							<div class="cleaner h20"></div>
							<div id="dprint">
								<table width="100%" border="1">
									<thead>
										<tr>
											<td align="left" style="padding: 5px;">Sl.</td>
											<td align="left" style="padding: 5px;">Date</td>
											<td align="left" style="padding: 5px;">karigar</td>
											<td align="left" style="padding: 5px;">Deposit</td>
											<td align="left" style="padding: 5px;">Withdraw</td>
											<td align="left" style="padding: 5px;">Note</td>
										</tr>
									</thead>
									<tbody>
										<?php
										$incometot=0;
										$expensetot=0;
										if($lower==0) {
											$flag=0;
										} else {
											$flag=$lower;
										}
										$sql="select * from `".$table."` where `".$status."`!='1'";
										if(isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']!="") {
											$sql.=" and `karigar`='".$_REQUEST['cusvl']."'";
										}
										if(isset($_REQUEST['fdtvl']) && $_REQUEST['fdtvl']!="") {
											$sql.=" and `pdate`>='".$_REQUEST['fdtvl']."'";
										}
										if(isset($_REQUEST['tdtvl']) && $_REQUEST['tdtvl']!="") {
											$sql.=" and `pdate`<='".$_REQUEST['tdtvl']."'";
										}
										$sql.=" order by `".$pkey."`";
										$res=mysqli_query($con,$sql);
										if(isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']!="") {
											$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `karigar_master` where `id`='".$_REQUEST['cusvl']."'"));
											$rowop=mysqli_fetch_assoc(mysqli_query($con,"select sum(deposit) as `ardep`, sum(withdraw) as `arwth` from `".$table."` where `karigar`='".$_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"><?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>
											</tr>
										<?php	
											if($opbalance>0) {
												$incometot+=abs($opbalance);
											} else {
												$expensetot+=abs($opbalance);
											}		
										}
										if(mysqli_num_rows($res)>=1) {
											while($row=mysqli_fetch_assoc($res)) {
												$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `karigar_master` where `id`='".$row['karigar']."'"));
												$incometot+=$row['deposit'];
												$expensetot+=$row['withdraw'];
										?>
												<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['pdate']); ?></td>
													<td align="left" style="padding: 5px;"><?php print $rowc['name']; ?></td>
													<td align="left" style="padding: 5px;"><?php print number_format($row['deposit'],2); ?></td>
													<td align="left" style="padding: 5px;"><?php print number_format($row['withdraw'],2); ?></td>
													<td align="left" style="padding: 5px;"><?php print stripslashes($row['note']); ?></td>
												</tr>
										<?php } ?>
											<tr class="sbg4">
												<td colspan="3">&nbsp;</td>
												<td align="left" style="padding: 5px;"><strong>Total Service: <?php print number_format($incometot,2); ?></strong></td>
												<td align="left" style="padding: 5px;"><strong>Total Payment: <?php print number_format($expensetot,2); ?></strong></td>
												<td align="left" style="padding: 5px;"><strong>Balance: <?php print number_format(($incometot-$expensetot),2); ?></strong></td>
											</tr>
										<?php } else { ?>
											<tr>
												<td colspan="6">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: viewdewtoldprint.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation