Enhanced PHP File Manager

📁 Current Path: 🏠 Root /home/u998488001/domains/grindustries.in/public_html/Admin

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.70.1.lve.el8.x86_64

PHP Version:

8.1.33

User:

u998488001

Directory:

/home/u998488001/domains/grindustries.in/public_html/Admin

Free Space:

1.82 TB

🔧 Quick Actions

✏️ Editing: prod_rate.php

<?php
	include 'header.php';
	include 'menu.php';
?>
<link rel="stylesheet" href="plugins/toastr/toastr.min.css">
<script src="plugins/jquery/jquery.min.js"></script>
<script src="plugins/toastr/toastr.min.js"></script>

<script>
	$(document).ready(function()
	{
	    var gnm,bnm;
		$("#selectGroup").change(function()
		{
			
			catnm= $(this).find("option:selected").val();
			gnm = catnm;
			$.post(
				"select_cat.php",
				{
					cat:catnm
				},
				function(data,status){
					$("#selectCat").empty();
					$("#selectCat").append(data);
					
				});
		});
		
		$("#selectCat").change(function()
		{
			catnm= $(this).find("option:selected").val();
			bnm = catnm;
			$.post(
				"select_brand.php",
				{
					cat:catnm,gnm:gnm
				},
				function(data,status){
					$("#selectBrand").empty();
					$("#selectBrand").append(data);
					
				});
		});
		
		$("#selectBrand").change(function()
		{
			catnm= $(this).find("option:selected").val();
			$.post(
				"select_product.php",
				{
					cat:bnm,gnm:gnm,brand:catnm
				},
				function(data,status){
					$("#selectProduct").empty();
					$("#selectProduct").append(data);
					
				});
		});
	});
</script>
	<div class="content-wrapper">
		<div class="content-header">
		  <div class="container-fluid">
			<div class="card">
			  <div class="card-body">
				<h1 class="m-0 text-center text-primary">Manage Product Rate</h1>
			  </div>
			</div>
		  </div>
		</div>
		<section class="content">
			<div class="container-fluid">
				<form action="prod_rate.php" method="POST">
					<div class="card">
						<div class="card-body">
							<select class="form-select form-control w-100" name="selectGroup" id="selectGroup" required >
								  <option value="0" selected>Select Product Group</option>
								  <?php
									$cid = $_SESSION['cid'];
									$sql = "select * from product_group where cid='$cid'";
									$res = mysqli_query($conn,$sql);
									while($row = mysqli_fetch_assoc($res))
									{
										?>
											<option value="<?php echo $row['id']; ?>"><?php echo $row['group_name']; ?></option>
										<?php
									}
								  ?>
							</select>
							</br>
							<select class="form-select form-control w-100" name="selectCat" id="selectCat" required >
								  <option selected>Select Product Category</option>
							</select>
							</br>
							<select class="form-select form-control w-100" name="selectBrand" id="selectBrand" required >
								  <option selected>Select Product Brand</option> 
							</select>
							</br>
							<select class="form-select form-control w-100" name="selectProduct" id="selectProduct" required >
								  <option selected>Select Product</option> 
							</select>
							</br>
							<input type="text" name="txtprate" placeholder="Enter Product Purchase Rate" class="form-control" required /></br>
							<input type="text" name="txtsrate" placeholder="Enter Product Sales Rate" class="form-control" required /></br>
							<input type="submit" class="btn btn-block btn-primary" value="Save" />
						</div>
					</div>
					<div class="card">
						<div class="card-body">
							<table id="example1" style="width:100%;" class="table table-bordered table-sm table-striped">
								<thead>
									<tr>
										<th class="text-center" style="width:5%;">#</th>
										<th class="text-center" style="width:25%;">Product Name</th>
										<th class="text-center" style="width:25%;">Purchase Rate</th>
										<th class="text-center" style="width:25%;">Sales Rate</th>
										<th class="text-center" style="width:10%;">Product Image</th>
									</tr>
								</thead>
								<tbody>
									<?php
										$cid = $_SESSION['cid'];
										$i = 0;
										$sql = "select * from product where cid='$cid'";
										$res = mysqli_query($conn,$sql);
										while($row = mysqli_fetch_assoc($res))
										{
											$i++;
									?>
									<tr>
										<td class="text-center"><?php echo $i; ?></td>
										<td class="text-center"><?php echo $row['product_name']; ?></td>
										<td class="text-center"><?php echo $row['purchase_rate']; ?></td>
										<td class="text-center"><?php echo $row['sales_rate']; ?></td>
										<td class="text-center"><img src="<?php echo $row['product_image']; ?>" height="50"/></td>					
									</tr>
									<?php
										}
									?>
								</tbody>
							</table>
						</div>
					</div>
				</form>
			</div>
		</section>
  </div>
<?php
	if(isset($_POST['txtsrate']))
	{
		$cid = $_SESSION['cid'];
		$product = $_POST['selectProduct'];
		$prate = $_POST['txtprate'];
		$srate = $_POST['txtsrate'];
		$gname = $_POST['selectGroup'];
		$cname = $_POST['selectCat'];
		$bname = $_POST['selectBrand'];
		
		$sql = "UPDATE `product` SET purchase_rate='$prate',sales_rate='$srate' WHERE cid='$cid' and gid='$gname' and cat_id='$cname' and brand_id='$bname' and id='$product'";
		echo $sql;
		$res = mysqli_query($conn,$sql);
		if(mysqli_affected_rows($conn))
		{
		?>
			<script>
					toastr.success('Product Rate Updated!', 'My SHOP');
					setTimeout(function() 
					{
						window.location.replace("prod_rate.php");
					}, 2000);
				</script>
		<?php
		}
		else
		{
		?>
			<script>
					toastr.success('There Was Some Error!', 'My SHOP');
			</script>
		<?php
		}
	}
	include 'footer.php';
?>

❌ Cancel