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

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$heading="Summary";
$addpage="addpolishrt.php";
$listpage="viewpolishsm.php";
$table="stone_polish";
$pkey="id";
$status="status";
if(isset($_REQUEST['delete']) && $_REQUEST['delete']=="yes") {
	mysqli_query($con,"delete from `".$table."` where `".$pkey."`='".$_REQUEST['id']."'");
	$_SESSION['msg']="Entry is deleted successfully.";
	header("Location:".$listpage);
	exit();	
}
if(isset($_REQUEST['approve']) && $_REQUEST['approve']=="yes") {
	$d=date("Y-m-d");
	mysqli_query($con,"update `".$table."` set `".$status."`='1' where `".$pkey."`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']=$heading." is approved successfully.";
	header("Location:".$listpage."#".$got);
	exit();
}
if(isset($_REQUEST['reject']) && $_REQUEST['reject']=="yes") {
	mysqli_query($con,"update `".$table."` set `".$status."`='0' where `".$pkey."`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']=$heading." is rejected successfully.";
	header("Location:".$listpage."#".$got);
	exit();
}
if($_GET['pg']) {
	$pg=$_GET['pg'];
} else {
	$pg=1;
}
$upper=25;
$lower=$upper*($pg-1);
$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 `date`>='".$_REQUEST['fdtvl']."'";
}
if(isset($_REQUEST['tdtvl']) && $_REQUEST['tdtvl']!="") {
	$sql.=" and `date`<='".$_REQUEST['tdtvl']."'";
}
$res=mysqli_query($con,$sql);
$num=mysqli_num_rows($res);
$pgno=intval($num/$upper);
if($num%$upper!=0) {
	$pgno=$pgno+1;
}
include("includes/headermain.php"); 
?>
<script language="javascript" type="text/javascript">
function del(page,id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href=page+"?id="+id+"&delete=yes";
	}	
}
function approve(page,id,got) {
	location.href=page+"?id="+id+"&got="+got+"&approve=yes";
}
function reject(page,id,got) {
	location.href=page+"?id="+id+"&got="+got+"&reject=yes";
}
</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>
							<form action="#" method="post">
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">Karigar</label>
									<select class="form-control" name="cusvl" id="cusvl" required>
										<option value="">Select Karigar
										<?php
										$resc=mysqli_query($con,"select `id`,`name` from `karigar_master` where `status`='1'");
										while($rowc=mysqli_fetch_object($resc)) {
										?>
											<option value="<?php print $rowc->id; ?>" <?php if($rowc->id==$_REQUEST['cusvl']) { ?>selected<?php } ?>><?php print $rowc->name ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">From</label>
									<input class="form-control sphgt" type="date" name="fdtvl" id="fdtvl" value="<?php print $_REQUEST['fdtvl']; ?>">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">To</label>
									<input class="form-control sphgt" type="date" name="tdtvl" id="tdtvl" value="<?php print $_REQUEST['tdtvl']; ?>">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-6 floatleft">
									<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
									<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
									<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="location.href='viewpolishsmprt.php?cusvl=<?php print $_REQUEST['cusvl']; ?>&fdtvl=<?php print $_REQUEST['fdtvl']; ?>&tdtvl=<?php print $_REQUEST['tdtvl']; ?>'">Print</button>
								</div>	
							</form>	
							<div class="cleaner h20"></div>
							<?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><div class="cleaner h10"></div><?php } ?>
							<?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?>
							<table class="table text-center">
								<thead class="text-uppercase bg-primary">
									<tr class="text-white">
										<td align="left">Sl.</td>
										<td align="left">Date</td>
										<td align="left">karigar</td>
										<td align="left">Qty</td>
										<td align="left">Return</td>
										<td align="left">Rate</td>
										<td align="left">Total</td>
										<td align="left">Payment</td>
										<td align="left">Note</td>
										<td align="left">Options</td>
									</tr>
								</thead>
								<tbody>
									<?php
									$total=0;
									$payment=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 `date`>='".$_REQUEST['fdtvl']."'";
									}
									if(isset($_REQUEST['tdtvl']) && $_REQUEST['tdtvl']!="") {
										$sql.=" and `date`<='".$_REQUEST['tdtvl']."'";
									}
									if(isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']!="") {
										$sql.=" order by `".$pkey."`";
									} else {
										$sql.=" order by `".$pkey."` limit $lower,$upper";
									}
									$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(total) as `ardep`, sum(payment) 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"></td>
											<td align="left"></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) {
											$total+=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 `karigar_master` where `id`='".$row['karigar']."'"));
											$total+=$row['total'];
											$payment+=$row['payment'];
									?>
											<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"><?php print dtconvert($row['date']); ?></td>
												<td align="left"><?php print stripslashes($rowc['name']); ?></td>
												<td align="left"><?php if($row['qty']!="") { print $row['qty']; ?> <?php print $row['unit']; } ?></td>
												<td align="left"><?php if($row['rqty']!="") { print $row['rqty']; ?> <?php print $row['unit']; } ?></td>
												<td align="left"><?php if($row['rate']!="") { print $row['rate']; ?> / <?php print $row['unit']; } ?></td>
												<td align="left"><?php print number_format($row['total'],2); ?></td>
												<td align="left"><?php print number_format($row['payment'],2); ?></td>
												<td align="left"><?php print stripslashes($row['note']); ?></td>
												<td align="left">
													<?php if($row['qty']!="") { ?>
														<a href="addpolishjm.php?eid=<?php print $row[$pkey]; ?>&action=Update&cusvl=<?php print $_REQUEST['cusvl']; ?>&fdtvl=<?php print $_REQUEST['fdtvl']; ?>&tdtvl=<?php print $_REQUEST['tdtvl']; ?>&flag=<?php print $flag; ?>">Edit</a>
													<?php } if($row['rqty']!="") { ?>	
														<a href="addpolishrt.php?eid=<?php print $row[$pkey]; ?>&action=Update&cusvl=<?php print $_REQUEST['cusvl']; ?>&fdtvl=<?php print $_REQUEST['fdtvl']; ?>&tdtvl=<?php print $_REQUEST['tdtvl']; ?>&flag=<?php print $flag; ?>">Edit</a>
													<?php } if($row['payment']!="") { ?>	
														<a href="addpolishpys.php?eid=<?php print $row[$pkey]; ?>&action=Update&cusvl=<?php print $_REQUEST['cusvl']; ?>&fdtvl=<?php print $_REQUEST['fdtvl']; ?>&tdtvl=<?php print $_REQUEST['tdtvl']; ?>&flag=<?php print $flag; ?>">Edit</a>
													<?php } ?>				
													<?php if($row[$status]=="1") { ?>
														<br><a href="#" onClick="reject('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>');return false;">Deactivate</a>
													<?php } else { ?>	
														<br><a href="#" class="redtxt" onClick="approve('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>');return false;">Activate</a>
													<?php } ?>	
												</td>
											</tr>
									<?php } ?>
										<tr class="sbg4">
											<td colspan="6">&nbsp;</td>
											<td align="left"><strong>Total Deposit: <?php print number_format($total,2); ?></strong></td>
											<td align="left"><strong>Total Withdraw: <?php print number_format($payment,2); ?></strong></td>
											<td align="left" colspan="2"><strong>Balance: <?php print number_format(($total-$payment),2); ?></strong></td>
										</tr>
									<?php } else { ?>
										<tr>
											<td colspan="10">Sorry, nothing found.</td>
										</tr>
									<?php } ?>	
								</tbody>
							</table>
							<?php if($num>=1 && !isset($_REQUEST['cusvl']) && $_REQUEST['cusvl']=="") { ?>
								<div class="cleaner h20"></div>
								        
								<?php include("includes/pagination.php"); ?>
								    
							<?php } ?>
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewpolishsm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation