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

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
include("includes/headermain.php"); 
?>
<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</h4>
							<form action="#" method="post">
								<div class="form-group col-md-6 floatleft">
									
									<input class="form-control" type="text" name="proname" id="proname" value="<?php print $_REQUEST['proname']; ?>" placeholder="By Product Name">
								</div>
								<div class="form-group col-md-6 floatleft">
									
									<input class="form-control" type="text" name="procode" id="procode" value="<?php print $_REQUEST['procode']; ?>" placeholder="By Product Code">
								</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>
							<div class="cleaner h20"></div>
							<table class="table text-center">
								<thead class="text-uppercase bg-primary">
									<tr class="text-white">
										<td align="left">Sl.</td>
										
										<td align="left">Code</td>
										<td align="left" width="30%">Name</td>
										<td align="left">Size</td>
										<td align="left">Color</td>
										<td align="left">Stock</td>
									</tr>
								</thead>
								<tbody>
									<?php
									$sql="select distinct st.pro_code from `stock_master` st, `product_master` p where p.pro_code=st.pro_code";
									if($_REQUEST['proname']) {
										$sql.=" and p.pro_name like '%".$_REQUEST['proname']."%'";
									}
									if($_REQUEST['procode']) {
										$sql.=" and p.pro_code='".$_REQUEST['procode']."'";
									}
									$sql.=" order by p.pro_code desc";
									//print $sql;
									$res=mysqli_query($con,$sql);
									if(mysqli_num_rows($res)>=1) {
										while($row=mysqli_fetch_assoc($res)) {
											$rowpro=mysqli_fetch_array(mysqli_query($con,"select * from `product_master` where `pro_code`='".$row['pro_code']."'"));
											$rowqty=mysqli_fetch_array(mysqli_query($con,"select sum(in_qty) as `qty` from `stock_master` where `pro_code`='".$row['pro_code']."'"));
									?>
											<tr <?php if($row[$status]=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
												<td align="left"><?php print $flag; ?></td>
												<?php /*?><td align='left'><?php print dtconvert($row['stock_date']); ?></td><?php */?>
												<td align='left'><?php print $rowpro['pro_code']; ?></td>
												<td align='left'>
													<?php print stripslashes($rowpro['pro_name']); ?>
												</td>
												<td align='left'><?php print $rowpro['pro_size']; ?></td>
												<td align='left'><?php print $rowpro['pro_color']; ?></td>
												<td align='left'><?php print $rowqty['qty']; ?></td>
											</tr>
									<?php }  } else { ?>
										<tr>
											<td colspan="7">Sorry, nothing found.</td>
										</tr>
									<?php } ?>	
								</tbody>
							</table>
							<?php if($num>=1) { ?>
								<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: viewstnstock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation