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/venomancillary.com/public_html/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: stockreportacp.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$heading="Stock Report (Accessories/Apparels)";
$table="newproduct";
$pkey="pro_id";
if($_GET['pg']) {
	$pg=$_GET['pg'];
} else {
	$pg=1;
}
$upper=25;
$lower=$upper*($pg-1);
$sql="select * from `".$table."` where 1";
if(isset($_REQUEST['name']) && $_REQUEST['name']!="") {
	$sql.=" and `name` like '%".$_REQUEST['name']."%'";
}
$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";
}
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">Stock Report (Accessories/Apparels)</h4>
							<form action="#" method="post">
								<div class="form-group">
									
									<input class="form-control" type="text" name="name" id="name" value="<?php print $_REQUEST['name']; ?>" placeholder="By Name">
								</div>
								<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
							</form>	
							<a href="<?php print basename(__FILE__); ?>" class="btn btn-primary ml-2 pr-4 pl-4 floatleft">Show All</a>
							<a href="productexcelacp.php" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" target="_blank">Export</a>
							<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 } ?>
							<div id="dprint">
								<table class="table text-center" width="100%" border="1">
									<thead class="text-uppercase bg-primary">
										<tr class="text-white">
											<td align="left">Sl.</td>
											<td align="left">Brand</td>
											<td align="left">Model</td>
											<td align="left">Product</td>
											<td align="left">MRP</td>
											<td align="left">Deal</td>
											<td align="left">Stock</td>
										</tr>
									</thead>
									<tbody>
										<?php
										if($lower==0) {
											$flag=0;
										} else {
											$flag=$lower;
										}
										$sql="select * from `".$table."` where `category` in ('66','67')";
										if(isset($_REQUEST['name']) && $_REQUEST['name']!="") {
											$sql.=" and `proname` like '%".$_REQUEST['name']."%'";
										}
										$sql.=" order by `".$pkey."` desc"; //limit $lower,$upper
										$res=mysqli_query($con,$sql);
										if(mysqli_num_rows($res)>=1) {
											while($row=mysqli_fetch_assoc($res)) {
												$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `category` where `id`='".$row['category']."'"));
												$rowsc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `subcategory` where `id`='".$row['subcategory']."'"));
												//$rowssc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `ssubcategory` where `id`='".$row['ssubcategory']."'"));
										?>
												<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 $rowc['name']; ?></td>
													<td align="left"><?php print $rowsc['name']; ?></td>
													<td align="left"><?php print $row['proname']; ?></td>
													<td align="left"><?php print $row['mrp']; ?></td>
													<td align="left"><?php print $row['dprice']; ?></td>
													<td align="left"><?php print $row['instock']; ?></td>
												</tr>
										<?php }  } else { ?>
											<tr>
												<td colspan="7">Sorry, nothing found.</</td>
											</tr>
										<?php } ?>	
									</tbody>
								</table>
							</div>	
							<div class="cleaner h20"></div>
							<div class="prtarea"><input class="cartbuttona" type="button" value="Print" onClick="PrintDivData('dprint');"></div>
							<?php /*?><?php if($num>=1) { ?>
								<div class="cleaner h20"></div>
								        
								<?php include("includes/pagination.php"); ?>
								    
							<?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: stockreportacp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation