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/sunny-indonesia/admin

Free Space:

9.89 TB

🔧 Quick Actions

✏️ Editing: pelanggan.php

<?php
session_start();

// Redirect ke login jika tidak ada session
if (!isset($_SESSION['admin_logged_in'])) {
    header('Location: login.php');
    exit;
}
include 'includes/db.php';
$page_title = "Pelanggan";
$active_page = "pelanggan";
include 'includes/header.php';

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    if (isset($_POST['add'])) {
        $nama_pelanggan = $_POST['nama_pelanggan'];
        $alamat = $_POST['alamat'];
        $no_telp = $_POST['no_telp'];
        $email = $_POST['email'];
        
        $stmt = $conn->prepare("INSERT INTO pelanggan (nama_pelanggan, alamat, no_telp, email) VALUES (?, ?, ?, ?)");
        $stmt->bind_param("ssss", $nama_pelanggan, $alamat, $no_telp, $email);
        
        if ($stmt->execute()) {
            header("Location: pelanggan.php?success=Pelanggan berhasil ditambahkan");
            exit();
        } else {
            header("Location: pelanggan.php?error=Gagal menambahkan pelanggan");
            exit();
        }
    }
    
    if (isset($_POST['update'])) {
        $id_pelanggan = $_POST['id_pelanggan'];
        $nama_pelanggan = $_POST['nama_pelanggan'];
        $alamat = $_POST['alamat'];
        $no_telp = $_POST['no_telp'];
        $email = $_POST['email'];
        
        $stmt = $conn->prepare("UPDATE pelanggan SET nama_pelanggan=?, alamat=?, no_telp=?, email=? WHERE id_pelanggan=?");
        $stmt->bind_param("ssssi", $nama_pelanggan, $alamat, $no_telp, $email, $id_pelanggan);
        
        if ($stmt->execute()) {
            header("Location: pelanggan.php?success=Pelanggan berhasil diperbarui");
            exit();
        } else {
            header("Location: pelanggan.php?error=Gagal memperbarui pelanggan");
            exit();
        }
    }
}

// Handle delete
if (isset($_GET['delete'])) {
    $id_pelanggan = $_GET['delete'];
    
    // Check if customer has sales
    $check = $conn->query("SELECT COUNT(*) as total FROM penjualan WHERE id_pelanggan=$id_pelanggan");
    $result = $check->fetch_assoc();
    
    if ($result['total'] > 0) {
        header("Location: pelanggan.php?error=Pelanggan tidak dapat dihapus karena memiliki riwayat penjualan");
        exit();
    }
    
    $query = "DELETE FROM pelanggan WHERE id_pelanggan=$id_pelanggan";
    if ($conn->query($query)) {
        header("Location: pelanggan.php?success=Pelanggan berhasil dihapus");
        exit();
    } else {
        header("Location: pelanggan.php?error=Gagal menghapus pelanggan");
        exit();
    }
}

// Get customer data for edit
$edit_data = null;
if (isset($_GET['edit'])) {
    $id_pelanggan = $_GET['edit'];
    $query = "SELECT * FROM pelanggan WHERE id_pelanggan=$id_pelanggan";
    $result = $conn->query($query);
    $edit_data = $result->fetch_assoc();
}
?>

<div class="header">
    <h1>Pelanggan</h1>
    <div class="user-info">
        <span>Kelola data pelanggan</span>
    </div>
</div>

<div class="form-container animated">
    <h2><?php echo $edit_data ? 'Edit Pelanggan' : 'Tambah Pelanggan'; ?></h2>
    <form method="POST">
        <?php if ($edit_data): ?>
            <input type="hidden" name="id_pelanggan" value="<?php echo $edit_data['id_pelanggan']; ?>">
        <?php endif; ?>
        
        <div class="form-group">
            <label for="nama_pelanggan">Nama Pelanggan</label>
            <input type="text" id="nama_pelanggan" name="nama_pelanggan" required 
                   value="<?php echo $edit_data ? $edit_data['nama_pelanggan'] : ''; ?>">
        </div>
        
        <div class="form-group">
            <label for="alamat">Alamat</label>
            <textarea id="alamat" name="alamat" required><?php echo $edit_data ? $edit_data['alamat'] : ''; ?></textarea>
        </div>
        
        <div class="form-group">
            <label for="no_telp">No. Telepon</label>
            <input type="text" id="no_telp" name="no_telp" required 
                   value="<?php echo $edit_data ? $edit_data['no_telp'] : ''; ?>">
        </div>
        
        <div class="form-group">
            <label for="email">Email</label>
            <input type="email" id="email" name="email" 
                   value="<?php echo $edit_data ? $edit_data['email'] : ''; ?>">
        </div>
        
        <button type="submit" name="<?php echo $edit_data ? 'update' : 'add'; ?>" class="btn">
            <?php echo $edit_data ? 'Update Pelanggan' : 'Tambah Pelanggan'; ?>
        </button>
        
        <?php if ($edit_data): ?>
            <a href="pelanggan.php" class="btn btn-danger">Batal</a>
        <?php endif; ?>
    </form>
</div>

<div class="table-container animated delay-1">
    <h2>Daftar Pelanggan</h2>
    <table>
        <thead>
            <tr>
                <th>No</th>
                <th>Nama Pelanggan</th>
                <th>Alamat</th>
                <th>No. Telepon</th>
                <th>Email</th>
                <th>Aksi</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $query = "SELECT * FROM pelanggan ORDER BY nama_pelanggan ASC";
            $result = $conn->query($query);
            $no = 1;
            
            while ($row = $result->fetch_assoc()) {
                echo "<tr>
                        <td>{$no}</td>
                        <td>{$row['nama_pelanggan']}</td>
                        <td>" . substr($row['alamat'], 0, 30) . "...</td>
                        <td>{$row['no_telp']}</td>
                        <td>{$row['email']}</td>
                        <td>
                            <div class='action-buttons'>
                                <a href='pelanggan.php?edit={$row['id_pelanggan']}' class='action-btn edit'>Edit</a>
                                <a href='pelanggan.php?delete={$row['id_pelanggan']}' class='action-btn delete'>Hapus</a>
                            </div>
                        </td>
                      </tr>";
                $no++;
            }
            ?>
        </tbody>
    </table>
</div>

<?php include 'includes/footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pelanggan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation