File Manager

Editing File: /home/quiczmwg/lightspringdigitals.com/admin/manage-products.php

<?php
include 'head.php';
include 'header.php';
include_once("../_db.php"); // Database connection

$status = $message = '';

// ==========================
// Handle Add Product
// ==========================
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $product_name = $_POST['product_name'];
    $amount = $_POST['amount'];
    $description = $_POST['description'];
    $product_id = md5(uniqid());

// Check required fields
    if (empty($product_name) || empty($amount) || empty($description) || empty($_FILES['image']['name'][0])) {
        $status = 'error';
        $message = 'Please fill all fields';
    } else {
        // File upload handling
        $uploadDirectory = '../uploads/products/';
        if (!is_dir($uploadDirectory)) {
            mkdir($uploadDirectory, 0755, true);
        }

foreach ($_FILES['image']['tmp_name'] as $key => $tmp_name) {
            $fileName = basename($_FILES['image']['name'][$key]);
            $targetPath = $uploadDirectory . time() . '-' . $fileName;

if (file_exists($targetPath)) {
                $status = 'error';
                $message = 'File already exists: ' . htmlspecialchars($fileName);
                break;
            } elseif (!move_uploaded_file($_FILES['image']['tmp_name'][$key], $targetPath)) {
                $status = 'error';
                $message = 'Failed to upload file: ' . htmlspecialchars($fileName);
                break;
            } else {
                // Insert product into database
                $insertQuery = "INSERT INTO products (product_id, product_name, amount, description, image) VALUES (?, ?, ?, ?, ?)";
                $insertStmt = $conn->prepare($insertQuery);

if ($insertStmt) {
                    $insertStmt->bind_param("sssss", $product_id, $product_name, $amount, $description, basename($targetPath));
                    if ($insertStmt->execute()) {
                        $status = 'success';
                        $message = 'Product added successfully';
                    } else {
                        $status = 'error';
                        $message = 'Failed to insert product: ' . $insertStmt->error;
                        break;
                    }
                } else {
                    $status = 'error';
                    $message = 'Failed to prepare SQL statement: ' . $conn->error;
                    break;
                }
            }
        }
    }

if ($status) {
        echo '<div style="color: ' . ($status === 'success' ? 'green' : 'red') . ';">' . htmlspecialchars($message) . '</div>';
    }
}

include 'sidebar.php';
?>

<div class="container">
                    <div class="text-right my-3">
                        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#addProductModal">
                            <i class="bi bi-plus"></i> Add Product
                        </button>
                    </div>
                </div>

<div class="modal fade" id="addProductModal">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            
                            <div class="modal-header">
                                <h4 class="modal-title">Add Product</h4>
                                <button type="button" class="close" data-dismiss="modal">&times;</button>
                            </div>
                            
                            <div class="modal-body">
                                <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="POST" enctype="multipart/form-data">
                                    <div class="form-group">
                                        <input type="text" name="product_name" placeholder="Enter product name" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="amount" placeholder="Enter product amount" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <textarea name="description" cols="30" rows="5" class="form-control my-2" placeholder="Enter product description" required></textarea>
                                    </div>
                                    <label for="image">Select Images:</label>
                                    <input type="file" name="image[]" id="image" accept="image/png, image/jpeg, image/webp" multiple required><br><br>

<div class="modal-footer">
                                        <button type="submit" class="btn btn-success">Submit</button>
                                        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<section>
                    <div class="d-flex justify-content-end align-items-center">
                        <div class="container-fluid">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="fw-bold mb-3">📊 All Sales Completion Requests</h4>
                                    <div class="table-responsive">
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Product Image</th>
                                                    <th>Product Name</th>
                                                    <th>Description</th>
                                                    <th>Amount</th>
                                                    <th>Status</th>
                                                    <th>Requested By</th>
                                                    <th>Requested At</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php 
                                                // ✅ Only fetch items with actual requests
                                                $query = "
                                                    SELECT DISTINCT p.product_id, p.product_name, p.description, p.image,
                                                           r.id, r.sale_amount, r.status, r.requested_by, r.request_date
                                                    FROM product_sales_requests r
                                                    INNER JOIN products p ON r.product_id = p.product_id
                                                    ORDER BY r.request_date DESC
                                                ";

$result = $conn->query($query);

if ($result && $result->num_rows > 0) {
                                                    $num = 1;
                                                    while ($row = $result->fetch_assoc()) {
                                                ?>
                                                <tr>
                                                    <td><?php echo $num++; ?></td>
                                                    <td><img src="../uploads/products/<?php echo htmlspecialchars($row['image']); ?>" height="100" alt=""></td>
                                                    <td><?php echo htmlspecialchars($row['product_name']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['description']); ?></td>
                                                    <td>$<?php echo number_format($row['sale_amount'], 2); ?></td>
                                                    <td>
                                                        <span class="badge bg-<?php 
                                                            echo ($row['status'] == 'pending' ? 'warning' : ($row['status'] == 'approved' ? 'success' : 'danger')); 
                                                        ?>">
                                                            <?php echo ucfirst($row['status']); ?>
                                                        </span>
                                                    </td>
                                                    <td><?php echo htmlspecialchars($row['requested_by']); ?></td>
                                                    <td><?php echo date("M d, Y h:i A", strtotime($row['request_date'])); ?></td>
                                                    <td>
                                                        <a href="product-details.php?product_id=<?php echo htmlspecialchars($row['product_id']); ?>" 
                                                           class="btn btn-info btn-sm">
                                                           <i class="bi bi-eye-fill" style="font-size: 20px;"></i>
                                                        </a>
                                                    </td>
                                                </tr>
                                                <?php
                                                    }
                                                } else {
                                                    echo "<tr><td colspan='9' class='text-center text-muted'>😕 No sales completion requests found.</td></tr>";
                                                }
                                                ?> 
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </section>

</div>
        </div>
    </div>
    <?php include 'footer.php'; ?>
</body>

Back to Directory File Manager