Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.26.1.el9_7.x86_64

PHP Version:

8.4.15

User:

u892747680

Directory:

/home/u892747680/domains/sisteminformasic.com/public_html/freshfruty

Free Space:

9.68 TB

🔧 Quick Actions

✏️ Editing: manage_promos.php

<?php
// admin/manage_promos.php
require_once 'auth.php';
require_once '../config/database.php';
require_once '../config/constants.php';

checkAdminLogin();

$database = new Database();
$db = $database->getConnection();

// 1. Buat tabel promos jika belum ada
try {
    $checkTable = $db->query("SHOW TABLES LIKE 'promos'");
    if($checkTable->rowCount() == 0) {
        $query = "CREATE TABLE promos (
            id INT AUTO_INCREMENT PRIMARY KEY,
            product_id INT NOT NULL,
            title VARCHAR(100),
            description TEXT,
            badge_text VARCHAR(50),
            min_qty INT DEFAULT 2,
            discount_percent INT DEFAULT 10,
            bg_style VARCHAR(50) DEFAULT 'gradient-1',
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        )";
        $db->exec($query);
    }
} catch(Exception $e) { }

// 2. Handle Hapus
if(isset($_GET['delete'])) {
    $id = intval($_GET['delete']);
    $query = "DELETE FROM promos WHERE id = :id";
    $stmt = $db->prepare($query);
    $stmt->bindParam(':id', $id);
    if($stmt->execute()) {
        header("Location: manage_promos.php?msg=deleted");
        exit();
    }
}

// 3. Handle Tambah Promo
if($_SERVER['REQUEST_METHOD'] === 'POST') {
    $product_id = intval($_POST['product_id']);
    $title = trim($_POST['title']);
    $description = trim($_POST['description']);
    $badge_text = trim($_POST['badge_text']);
    $min_qty = intval($_POST['min_qty']);
    $discount_percent = intval($_POST['discount_percent']);
    $bg_style = $_POST['bg_style'];
    
    // Cek apakah produk sudah ada di promo
    $check = $db->prepare("SELECT id FROM promos WHERE product_id = ?");
    $check->execute([$product_id]);
    if($check->rowCount() > 0) {
        $error = "Produk ini sudah ada di daftar promo!";
    } else {
        $query = "INSERT INTO promos (product_id, title, description, badge_text, min_qty, discount_percent, bg_style) 
                  VALUES (:pid, :title, :desc, :badge, :qty, :disc, :bg)";
        $stmt = $db->prepare($query);
        $stmt->bindParam(':pid', $product_id);
        $stmt->bindParam(':title', $title);
        $stmt->bindParam(':desc', $description);
        $stmt->bindParam(':badge', $badge_text);
        $stmt->bindParam(':qty', $min_qty);
        $stmt->bindParam(':disc', $discount_percent);
        $stmt->bindParam(':bg', $bg_style);
        
        if($stmt->execute()) {
            header("Location: manage_promos.php?msg=saved");
            exit();
        }
    }
}

// Ambil Data Promo
$query = "SELECT p.*, pr.name as product_name, pr.price, pr.image, pr.unit 
          FROM promos p 
          JOIN products pr ON p.product_id = pr.id 
          ORDER BY p.id DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$promos = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Ambil Semua Produk untuk Dropdown
$queryPr = "SELECT id, name, price, unit FROM products ORDER BY name ASC";
$stmtPr = $db->prepare($queryPr);
$stmtPr->execute();
$all_products = $stmtPr->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Kelola Promo - <?php echo SITE_NAME; ?></title>
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700;800&display=swap" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="../assets/css/admin.css">
    <style>
        .gradient-option {
            width: 100%; height: 40px; border-radius: 8px; cursor: pointer; border: 2px solid transparent;
            margin-bottom: 5px;
        }
        .gradient-option.selected { border-color: #333; transform: scale(0.95); }
        .g-1 { background: linear-gradient(135deg, #fff0f1 0%, #ffe4e6 100%); }
        .g-2 { background: linear-gradient(135deg, #e3f2fd 0%, #bbdefb 100%); }
        .g-3 { background: linear-gradient(135deg, #fff8e1 0%, #ffecb3 100%); }
        .g-4 { background: linear-gradient(135deg, #e8f5e9 0%, #c8e6c9 100%); }
    </style>
</head>
<body>
    <?php require_once __DIR__ . '/includes/sidebar.php'; ?>
    
    <div class="main-content">
        <?php require_once __DIR__ . '/includes/topbar.php'; ?>
        
        <div class="content-area">
            <div class="page-header">
                <h1><i class="fas fa-tags"></i> Kelola Promo Spesial</h1>
                <button onclick="openModal()" class="btn-primary">
                    <i class="fas fa-plus"></i> Tambah Promo
                </button>
            </div>

<?php if(isset($_GET['msg'])): ?>
            <div class="alert alert-success">
                <i class="fas fa-check-circle"></i>
                <?php echo $_GET['msg'] === 'saved' ? 'Promo berhasil disimpan!' : 'Promo berhasil dihapus!'; ?>
            </div>
            <?php endif; ?>
            
            <?php if(isset($error)): ?>
            <div class="alert alert-danger">
                <i class="fas fa-exclamation-circle"></i> <?php echo $error; ?>
            </div>
            <?php endif; ?>

<div class="content-box">
                <div class="table-responsive">
                    <table class="data-table">
                        <thead>
                            <tr>
                                <th>Produk</th>
                                <th>Judul Promo</th>
                                <th>Diskon</th>
                                <th>Min. Beli</th>
                                <th>Badge</th>
                                <th>Aksi</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach($promos as $p): ?>
                            <tr>
                                <td>
                                    <div style="display:flex;align-items:center;gap:10px;">
                                        <img src="<?php echo htmlspecialchars($p['image']); ?>" style="width:40px;height:40px;border-radius:8px;object-fit:cover;">
                                        <div>
                                            <strong><?php echo htmlspecialchars($p['product_name']); ?></strong><br>
                                            <small>Rp <?php echo number_format($p['price'],0,',','.'); ?>/<?php echo $p['unit']; ?></small>
                                        </div>
                                    </div>
                                </td>
                                <td><?php echo htmlspecialchars($p['title']); ?></td>
                                <td><span class="badge badge-paid"><?php echo $p['discount_percent']; ?>%</span></td>
                                <td><?php echo $p['min_qty']; ?> <?php echo $p['unit']; ?></td>
                                <td><span class="badge badge-info"><?php echo htmlspecialchars($p['badge_text']); ?></span></td>
                                <td>
                                    <a href="?delete=<?php echo $p['id']; ?>" onclick="return confirm('Hapus promo ini?')" class="btn-action btn-delete">
                                        <i class="fas fa-trash"></i>
                                    </a>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                            <?php if(empty($promos)): ?>
                            <tr><td colspan="6" style="text-align:center;">Belum ada promo aktif.</td></tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

<div id="promoModal" class="modal">
        <div class="modal-content">
            <div class="modal-header">
                <h2>Tambah Promo Baru</h2>
                <span class="close" onclick="closeModal()">&times;</span>
            </div>
            <form method="POST">
                <div class="form-group">
                    <label>Pilih Produk</label>
                    <select name="product_id" required style="width:100%;padding:10px;border:1px solid #ddd;border-radius:8px;">
                        <option value="">-- Pilih Produk --</option>
                        <?php foreach($all_products as $pr): ?>
                        <option value="<?php echo $pr['id']; ?>">
                            <?php echo htmlspecialchars($pr['name']); ?> (Rp <?php echo number_format($pr['price'],0,',','.'); ?>/<?php echo $pr['unit']; ?>)
                        </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="form-group">
                    <label>Judul Promo (Headline)</label>
                    <input type="text" name="title" placeholder="Contoh: Paket Imun Booster" required>
                </div>
                
                <div class="form-group">
                    <label>Deskripsi Singkat</label>
                    <textarea name="description" rows="2" placeholder="Contoh: Sumber Vitamin C terbaik..." required></textarea>
                </div>

<div class="form-group" style="display:grid;grid-template-columns:1fr 1fr;gap:15px;">
                    <div>
                        <label>Diskon (%)</label>
                        <input type="number" name="discount_percent" value="10" min="1" max="99" required>
                    </div>
                    <div>
                        <label>Min. Pembelian (Qty)</label>
                        <input type="number" name="min_qty" value="2" min="1" required>
                    </div>
                </div>
                
                <div class="form-group">
                    <label>Teks Badge</label>
                    <input type="text" name="badge_text" placeholder="Contoh: Hemat 10%, Best Deal" required>
                </div>

<div class="form-group">
                    <label>Warna Background</label>
                    <div style="display:grid;grid-template-columns:repeat(4,1fr);gap:10px;">
                        <div class="gradient-option g-1" onclick="selectBg('gradient-1', this)"></div>
                        <div class="gradient-option g-2" onclick="selectBg('gradient-2', this)"></div>
                        <div class="gradient-option g-3" onclick="selectBg('gradient-3', this)"></div>
                        <div class="gradient-option g-4" onclick="selectBg('gradient-4', this)"></div>
                    </div>
                    <input type="hidden" name="bg_style" id="bgStyle" value="gradient-1">
                </div>
                
                <button type="submit" class="btn-primary">
                    <i class="fas fa-save"></i> Simpan Promo
                </button>
            </form>
        </div>
    </div>

window.onclick = function(e) {
            if(e.target == document.getElementById('promoModal')) closeModal();
        }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_promos.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation