Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 6.8.0-1039-aws

PHP Version:

8.0.30

User:

heali6836

Directory:

/home/healingkw.com/public_html/account

Free Space:

6.21 GB

🔧 Quick Actions

✏️ Editing: stock-list.php

<?php 
    require_once('../main/include.php');
    require_once('module/stock-list.php');
    require_once('verification.php');
    require_once('header.php');
?>

<div id="page-wrapper">
    <div class="page-head">
        <div class="container-fluid">
            <div class="row">
                <div class="col-lg-6 col-md-6 col-sm-6 col-12">
                    <h1 class="page-custom-header">Stock - List</h1>
                </div>
                <div class="col-sm-6 col-md-6 col-sm-6 col-12"></div>
            </div>
        </div>

<div class="row">
            <div class="col-lg-12">
                <div class="panel panel-default">
                    <div class="flex-panel panel-heading">
                        <div>Data Table</div>
                        <div><a title="Add New Product" href="stock-add.php" class="add-btn"><i class="fa fa-plus" aria-hidden="true"></i></a></div>
                    </div>
                    <div class="panel-body">
                        <div class="table-responsive">
                            <table class="table table-striped table-bordered table-hover" id="dataTables-example">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>Name</th>
                                        <th>Brand</th>
                                        <th>Category</th>
                                        
                                        
                                        
                                        <th>Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                <?php
                                    $product_ids = array();

$res_products_stocks = "SELECT * FROM products_stocks WHERE status='1' ";
                                    $run_products_stocks = mysqli_query($conn, $res_products_stocks);
                                    $num_products_stocks = mysqli_num_rows($run_products_stocks);
                                    while($row_products_stocks = mysqli_fetch_assoc($run_products_stocks))
                                    {
                                        //select-product-info
                                        $res_products = "SELECT * FROM products WHERE id='".$row_products_stocks['product_id']."' AND status='1' ";
                                        $run_products = mysqli_query($conn, $res_products);
                                        $num_products = mysqli_num_rows($run_products);
                                        if($num_products > '0')
                                        {
                                            $row_products = mysqli_fetch_assoc($run_products);

if(!in_array($row_products['id'], $product_ids))
                                            {
                                                $product_ids[] = $row_products['id'];

//select-brand-info
                                                $res_master_brands = "SELECT * FROM master_brands WHERE id='".$row_products['brand_id']."' AND status='1' ";
                                                $run_master_brands = mysqli_query($conn, $res_master_brands);
                                                $num_master_brands = mysqli_num_rows($run_master_brands);
                                                $row_master_brands = mysqli_fetch_assoc($run_master_brands);

//select-category_info
                                                $res_master_categories = "SELECT * FROM master_categories WHERE id='".$row_products['category_id']."' AND status='1' ";
                                                $run_master_categories = mysqli_query($conn, $res_master_categories);
                                                $num_master_categories = mysqli_num_rows($run_master_categories);
                                                $row_master_categories = mysqli_fetch_assoc($run_master_categories);

//select-size-info
                                                $res_master_sizes = "SELECT * FROM master_sizes WHERE id='".$row_products_stocks['size_id']."' AND status='1' ";
                                                $run_master_sizes = mysqli_query($conn, $res_master_sizes);
                                                $num_master_sizes = mysqli_num_rows($run_master_sizes);
                                                $row_master_sizes = mysqli_fetch_assoc($run_master_sizes);

?>
                                                <tr>
                                                    <td><?php echo $row_products['product_code']; ?></td>
                                                    <td><?php echo $row_products['en_name']; ?></td>
                                                    <td><?php echo $row_master_brands['en_name']; ?></td>
                                                    <td><?php echo $row_master_categories['en_name']; ?></td>
                                                    
                                                    
                                                    
                                                    <td>
                                                        <div class="actions">
                                                            <a href="<?php echo 'stock-add.php?eid='.$row_products_stocks['product_id'];?>" 
                                                            class="edit"><i class="fa fa-pencil"></i></a>
                                                        </div>
                                                    </td>
                                                </tr>
                                                <?php
                                            }
                                        }
                                    }
                                ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php require_once('footer.php'); ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock-list.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation