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

Free Space:

9.89 TB

🔧 Quick Actions

✏️ Editing: order_detail.php

<?php
// admin/order_detail.php
require_once 'auth.php';
require_once '../config/database.php';
require_once '../config/constants.php';
require_once 'helpers/virtual_account_helper.php';

checkAdminLogin();

if(!isset($_GET['id'])) {
    header("Location: manage_orders.php");
    exit();
}

$id = intval($_GET['id']);
$database = new Database();
$db = $database->getConnection();

// Get order details
$query = "SELECT o.*, c.name as customer_name, c.phone, c.email, c.address as customer_address
          FROM orders o 
          LEFT JOIN customers c ON o.customer_id = c.id 
          WHERE o.id = :id LIMIT 1";
$stmt = $db->prepare($query);
$stmt->bindParam(':id', $id);
$stmt->execute();

if($stmt->rowCount() == 0) {
    header("Location: manage_orders.php");
    exit();
}

$order = $stmt->fetch(PDO::FETCH_ASSOC);

// Get order items
$queryItems = "SELECT * FROM order_items WHERE order_id = :order_id";
$stmtItems = $db->prepare($queryItems);
$stmtItems->bindParam(':order_id', $id);
$stmtItems->execute();
$items = $stmtItems->fetchAll(PDO::FETCH_ASSOC);

// Get Virtual Account info if exists
$vaManager = getVAManager();
$virtualAccount = $vaManager->getVAByOrderId($id);

// Translation maps
$payment_status_map = [
    'pending' => 'Menunggu',
    'paid' => 'Lunas',
    'cancelled' => 'Dibatalkan'
];
$order_status_map = [
    'pending' => 'Menunggu',
    'processing' => 'Diproses',
    'shipped' => 'Dikirim',
    'delivered' => 'Selesai',
    'cancelled' => 'Dibatalkan'
];

// Handle status update from detail page
if(isset($_POST['update_status'])) {
    $payment_status = $_POST['payment_status'];
    $order_status = $_POST['order_status'];
    
    // PENTING: Cegah pesanan menandai "Selesai" tanpa pembayaran dikonfirmasi
    // IMPORTANT: Prevent marking order as "Delivered" without confirmed payment
    if($order_status === 'delivered' && $payment_status !== 'paid') {
        header("Location: order_detail.php?id=$id&error=payment_required&notify=1");
        exit();
    }
    
    $queryUpdate = "UPDATE orders SET payment_status = :payment_status, order_status = :order_status WHERE id = :id";
    $stmtUpdate = $db->prepare($queryUpdate);
    $stmtUpdate->bindParam(':payment_status', $payment_status);
    $stmtUpdate->bindParam(':order_status', $order_status);
    $stmtUpdate->bindParam(':id', $id);
    
    if($stmtUpdate->execute()) {
        // Refresh data
        header("Location: order_detail.php?id=$id&msg=updated&notify=1");
        exit();
    }
}

// Prepare WhatsApp Notification URL
$phone = preg_replace('/[^0-9]/', '', $order['phone']);
if(substr($phone, 0, 1) == '0') {
    $phone = '62' . substr($phone, 1);
}

// Buat daftar item untuk WA
$items_list = "";
foreach($items as $item) {
    $items_list .= "\u{25AA} " . $item['product_name'] . " (x" . $item['quantity'] . ")\n";
}

$msg = "\u{1F31F} *UPDATE PESANAN FRESHFRUTY* \u{1F31F}\n\n";
$msg .= "Halo Kak *" . $order['customer_name'] . "* \u{1F44B},\n";
$msg .= "Terima kasih sudah berbelanja buah segar di FreshFruty! Berikut update status pesanan Kakak:\n\n";
$msg .= "\u{1F9FE} *No. Invoice:* #" . $order['order_number'] . "\n";
$msg .= "\u{1F4C5} *Tanggal:* " . date('d/m/Y', strtotime($order['created_at'])) . "\n";
$msg .= "----------------------------------\n";
$msg .= "\u{1F504} *STATUS:* " . strtoupper($order_status_map[$order['order_status']] ?? $order['order_status']) . "\n";
$msg .= "\u{1F4B0} *PEMBAYARAN:* " . strtoupper($payment_status_map[$order['payment_status']] ?? $order['payment_status']) . "\n";
$msg .= "----------------------------------\n\n";
$msg .= "\u{1F6D2} *Detail Pesanan:*\n" . $items_list;
$msg .= "\n\u{1F4B5} *Total: Rp " . number_format($order['total_amount'], 0, ',', '.') . "*\n\n";

if($order['order_status'] == 'shipped') {
    $msg .= "\u{1F69A} Pesanan Kakak sedang dalam perjalanan. Mohon ditunggu ya!\n\n";
} elseif($order['order_status'] == 'delivered') {
    $msg .= "\u{2705} Pesanan telah sampai! Semoga Kakak suka dengan buah segarnya.\n\n";
} else {
    $msg .= "Mohon ditunggu update selanjutnya ya Kak! \u{1F60A}\n\n";
}

$msg .= "Salam Sehat,\n*Tim FreshFruty* \u{1F343}\n#FreshFruty #BuahSegar";
$wa_url = "https://wa.me/" . $phone . "?text=" . rawurlencode($msg);
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Detail Pesanan #<?php echo $order['order_number']; ?> - <?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>
        .detail-grid {
            display: grid;
            grid-template-columns: 2fr 1fr;
            gap: 30px;
        }
        .info-card {
            background: white;
            border-radius: 15px;
            padding: 25px;
            box-shadow: 0 5px 20px rgba(0,0,0,0.05);
            margin-bottom: 30px;
        }
        .info-header {
            border-bottom: 1px solid #eee;
            padding-bottom: 15px;
            margin-bottom: 20px;
            font-size: 1.1rem;
            font-weight: 600;
            color: #333;
        }
        .info-row {
            display: flex;
            margin-bottom: 15px;
        }
        .info-label {
            width: 140px;
            color: #888;
            font-size: 0.9rem;
        }
        .info-value {
            flex: 1;
            font-weight: 500;
            color: #333;
        }
        .item-list {
            width: 100%;
            border-collapse: collapse;
        }
        .item-list th {
            text-align: left;
            padding: 10px;
            background: #f8f9fa;
            font-size: 0.85rem;
            color: #666;
        }
        .item-list td {
            padding: 15px 10px;
            border-bottom: 1px solid #eee;
        }
        .item-total {
            text-align: right;
            font-weight: 700;
            font-size: 1.1rem;
            padding-top: 20px;
        }
        @media (max-width: 768px) {
            .detail-grid { grid-template-columns: 1fr; }
        }
        
        /* Print Styles - Professional Invoice Look */
        @media print {
            @page { margin: 0; size: A4; }
            body { 
                background: white; 
                -webkit-print-color-adjust: exact !important; 
                print-color-adjust: exact !important; 
            }
            .sidebar, .topbar, .page-header, .no-print, .btn-action, .alert, .btn-primary { 
                display: none !important; 
            }
            .main-content { 
                margin: 0 !important; 
                padding: 0 !important; 
            }
            .content-area { 
                padding: 40px !important; 
            }
            .detail-grid { 
                display: block !important; 
            }
            .left-col, .right-col { 
                width: 100% !important; 
            }
            .info-card { 
                box-shadow: none !important; 
                padding: 0 !important; 
                margin-bottom: 20px !important; 
                border: none !important; 
            }
            
            /* Invoice Header */
            .invoice-header {
                display: flex !important;
                justify-content: space-between;
                margin-bottom: 40px;
                padding-bottom: 20px;
                border-bottom: 3px solid #ff4757;
            }
            .invoice-brand h1 { font-size: 28px; color: #ff4757; margin: 0; font-weight: 800; }
            .invoice-brand p { font-size: 12px; color: #666; margin: 5px 0 0; }
            .invoice-meta { text-align: right; }
            .invoice-meta h3 { font-size: 20px; margin: 0; color: #333; font-weight: 700; }
            .invoice-meta p { font-size: 12px; color: #666; margin: 5px 0 0; }
            
            /* Customer Info Print Layout */
            .customer-info-print {
                display: flex !important;
                justify-content: space-between;
                margin-bottom: 40px;
                padding: 25px;
                background: #f8f9fa !important;
                border-radius: 15px;
            }
            .cust-col h4 { font-size: 11px; color: #888; text-transform: uppercase; margin-bottom: 8px; letter-spacing: 1px; }
            .cust-col p { font-size: 14px; color: #333; margin-bottom: 5px; font-weight: 600; }
            
            /* Table Styling */
            .item-list th { background: #2f3542 !important; color: white !important; padding: 15px !important; text-transform: uppercase; font-size: 11px !important; }
            .item-list td { padding: 15px !important; border-bottom: 1px solid #eee !important; }
            .item-total { font-size: 24px !important; color: #ff4757 !important; margin-top: 30px !important; text-align: right !important; }
            
            /* Footer */
            .invoice-footer {
                display: block !important;
                text-align: center;
                margin-top: 80px;
                padding-top: 20px;
                border-top: 1px solid #eee;
                font-size: 12px;
                color: #aaa;
            }
        }
        .invoice-header, .invoice-footer, .customer-info-print { display: none; }
    </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="invoice-header">
                <div class="invoice-brand">
                    <h1><?php echo SITE_NAME; ?></h1>
                    <p>Jl. Buah Segar No. 88, Jakarta Selatan</p>
                    <p>Email: hello@freshfruty.com | WA: <?php echo WA_NUMBER; ?></p>
                </div>
                <div class="invoice-meta">
                    <h3>INVOICE</h3>
                    <p>No: #<?php echo htmlspecialchars($order['order_number']); ?></p>
                    <p>Tanggal: <?php echo date('d F Y', strtotime($order['created_at'])); ?></p>
                </div>
            </div>

<div class="page-header">
                <h1>
                    <i class="fas fa-receipt"></i> Detail Pesanan #<?php echo htmlspecialchars($order['order_number']); ?>
                </h1>
                <div>
                    <a href="manage_orders.php" class="btn-primary" style="text-decoration: none; margin-right: 10px;">
                        <i class="fas fa-arrow-left"></i> Kembali
                    </a>
                    <a href="<?php echo $wa_url; ?>" target="_blank" class="btn-primary" style="text-decoration: none; margin-right: 10px; background: #25D366; border-color: #25D366;">
                        <i class="fab fa-whatsapp"></i> Kirim Notifikasi
                    </a>
                    <button onclick="window.print()" class="btn-primary" style="background: #17a2b8; border-color: #17a2b8;">
                        <i class="fas fa-print"></i> Cetak
                    </button>
                </div>
            </div>

<?php if(isset($_GET['msg'])): ?>
            <div class="alert alert-success">
                <i class="fas fa-check-circle"></i> Status pesanan berhasil diperbarui!
            </div>
            <?php endif; ?>

<?php if(isset($_GET['error']) && $_GET['error'] === 'payment_required'): ?>
            <div class="alert alert-danger">
                <i class="fas fa-exclamation-circle"></i> <strong>Pembayaran Wajib!</strong> Pesanan tidak dapat ditandai sebagai selesai sebelum pembayaran dikonfirmasi. Silakan perbarui status pembayaran menjadi "Lunas" terlebih dahulu.
            </div>
            <?php endif; ?>

<div class="detail-grid">
                <div class="left-col">
                    
                    <div class="customer-info-print">
                        <div class="cust-col">
                            <h4>Ditagihkan Kepada:</h4>
                            <p><?php echo htmlspecialchars($order['customer_name']); ?></p>
                            <p style="font-weight: 400; font-size: 13px;"><?php echo nl2br(htmlspecialchars($order['shipping_address'])); ?></p>
                            <p style="font-weight: 400; font-size: 13px;"><?php echo htmlspecialchars($order['phone']); ?></p>
                        </div>
                        <div class="cust-col" style="text-align: right;">
                            <h4>Detail Pembayaran:</h4>
                            <p>Metode: <?php echo !empty($order['payment_method']) ? strtoupper($order['payment_method']) : '-'; ?></p>
                            <p>Status: <?php echo strtoupper($payment_status_map[$order['payment_status']] ?? $order['payment_status']); ?></p>
                        </div>
                    </div>

<div class="info-card">
                        <div class="info-header">Item Pesanan</div>
                        <table class="item-list">
                            <thead>
                                <tr>
                                    <th>Produk</th>
                                    <th>Harga</th>
                                    <th>Qty</th>
                                    <th style="text-align: right;">Subtotal</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach($items as $item): ?>
                                <tr>
                                    <td><strong><?php echo htmlspecialchars($item['product_name']); ?></strong></td>
                                    <td>Rp <?php echo number_format($item['price'], 0, ',', '.'); ?></td>
                                    <td>x<?php echo $item['quantity']; ?></td>
                                    <td style="text-align: right;">Rp <?php echo number_format($item['subtotal'], 0, ',', '.'); ?></td>
                                </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                        <div class="item-total">
                            Total: Rp <?php echo number_format($order['total_amount'], 0, ',', '.'); ?>
                        </div>
                    </div>

<div class="info-card no-print">
                        <div class="info-header">Informasi Pelanggan</div>
                        <div class="info-row">
                            <div class="info-label">Nama</div>
                            <div class="info-value"><?php echo htmlspecialchars($order['customer_name']); ?></div>
                        </div>
                        <div class="info-row">
                            <div class="info-label">Telepon</div>
                            <div class="info-value"><?php echo htmlspecialchars($order['phone']); ?></div>
                        </div>
                        <div class="info-row">
                            <div class="info-label">Email</div>
                            <div class="info-value"><?php echo htmlspecialchars($order['email'] ?? '-'); ?></div>
                        </div>
                        <div class="info-row">
                            <div class="info-label">Alamat Kirim</div>
                            <div class="info-value"><?php echo nl2br(htmlspecialchars($order['shipping_address'])); ?></div>
                        </div>
                    </div>
                </div>

<div class="right-col">
                    
                    <div class="info-card no-print">
                        <div class="info-header">Status Pesanan</div>
                        <form method="POST">
                            <?php if($virtualAccount): ?>
                            
                            <div class="form-group" style="background: #f0f8ff; padding: 15px; border-radius: 10px; border-left: 4px solid #0052cc; margin-bottom: 20px;">
                                <label style="font-weight: 700; color: #0052cc; margin-bottom: 10px; display: block;">💳 Virtual Account (Transfer Pembayaran)</label>
                                <div style="background: white; padding: 12px; border-radius: 8px; border: 2px dashed #0052cc; margin-bottom: 10px; font-family: 'Courier New', monospace;">
                                    <div style="font-weight: 900; font-size: 1.3rem; color: #0052cc; letter-spacing: 2px; text-align: center;">
                                        <?php echo $vaManager->formatVA($virtualAccount['virtual_account_number']); ?>
                                    </div>
                                </div>
                                <div style="font-size: 0.85rem; color: #333; margin-bottom: 5px;">
                                    <strong>Metode:</strong> <?php echo htmlspecialchars($virtualAccount['payment_method']); ?>
                                </div>
                                <div style="font-size: 0.85rem; color: #333; margin-bottom: 5px;">
                                    <strong>Status:</strong> <?php echo $vaManager->getStatusBadge($virtualAccount['status']); ?>
                                </div>
                                <div style="font-size: 0.85rem; color: #333;">
                                    <strong>Dibuat:</strong> <?php echo date('d/m/Y H:i', strtotime($virtualAccount['created_at'])); ?>
                                </div>
                                <?php if($virtualAccount['paid_at']): ?>
                                <div style="font-size: 0.85rem; color: #2ecc71; font-weight: 600;">
                                    <strong>✓ Terbayar:</strong> <?php echo date('d/m/Y H:i', strtotime($virtualAccount['paid_at'])); ?>
                                </div>
                                <?php endif; ?>
                            </div>
                            <?php endif; ?>
                            
                            <div class="form-group">
                                <label>Status Pembayaran</label>
                                <select name="payment_status" class="form-control">
                                    <option value="pending" <?php echo $order['payment_status'] == 'pending' ? 'selected' : ''; ?>>Menunggu</option>
                                    <option value="paid" <?php echo $order['payment_status'] == 'paid' ? 'selected' : ''; ?>>Lunas</option>
                                    <option value="cancelled" <?php echo $order['payment_status'] == 'cancelled' ? 'selected' : ''; ?>>Dibatalkan</option>
                                </select>
                            </div>
                            <div class="form-group">
                                <label>Status Pengiriman</label>
                                <select name="order_status" class="form-control">
                                    <option value="pending" <?php echo $order['order_status'] == 'pending' ? 'selected' : ''; ?>>Menunggu</option>
                                    <option value="processing" <?php echo $order['order_status'] == 'processing' ? 'selected' : ''; ?>>Diproses</option>
                                    <option value="shipped" <?php echo $order['order_status'] == 'shipped' ? 'selected' : ''; ?>>Dikirim</option>
                                    <option value="delivered" <?php echo $order['order_status'] == 'delivered' ? 'selected' : ''; ?>>Selesai</option>
                                    <option value="cancelled" <?php echo $order['order_status'] == 'cancelled' ? 'selected' : ''; ?>>Dibatalkan</option>
                                </select>
                            </div>
                            <div class="form-group">
                                <label>Metode Pembayaran</label>
                                <?php
                                    $pm = $order['payment_method'];
                                    $providerName = (preg_match('/$(.*?)$/', $pm, $matches)) ? $matches[1] : '';
                                    $logo_map = [
                                        'BCA' => 'bca.png', 'Mandiri' => 'mandiri.png', 'BNI' => 'bni.png', 'BRI' => 'bri.png',
                                        'CIMB Niaga' => 'cimb.png', 'Danamon' => 'danamon.png', 'Bank Danamon' => 'danamon.png', 'Permata' => 'permata.png',
                                        'BSI' => 'bsi.png', 'BTN' => 'btn.png', 'Jenius' => 'jenius.png', 'Jago' => 'jago.png', 'SeaBank' => 'seabank.png',
                                        'GoPay' => 'gopay.png', 'OVO' => 'ovo.png', 'DANA' => 'dana.png', 'ShopeePay' => 'shopeepay.png', 'LinkAja' => 'linkaja.png', 'i.saku' => 'isaku.png'
                                    ];
                                    $logo_url = isset($logo_map[$providerName]) ? '../assets/images/payments/' . $logo_map[$providerName] : '';
                                ?>
                                <?php if(!empty($logo_url)): ?>
                                    <div style="margin-bottom: 5px;"><img src="<?php echo $logo_url; ?>" style="height: 30px; object-fit: contain;"></div>
                                <?php endif; ?>
                                <input type="text" value="<?php echo !empty($order['payment_method']) ? strtoupper($order['payment_method']) : '-'; ?>" readonly style="background: #f9f9f9;">
                            </div>
                            <div class="form-group">
                                <label>Tanggal Pesanan</label>
                                <input type="text" value="<?php echo date('d F Y H:i', strtotime($order['created_at'])); ?>" readonly style="background: #f9f9f9;">
                            </div>
                            
                            <button type="submit" name="update_status" class="btn-primary" style="width: 100%; justify-content: center;">
                                <i class="fas fa-save"></i> Simpan Perubahan
                            </button>
                        </form>
                    </div>

<?php if(!empty($order['payment_proof'])): ?>
                    <div class="info-card no-print">
                        <div class="info-header">Bukti Pembayaran</div>
                        <img src="../uploads/payment_proofs/<?php echo htmlspecialchars($order['payment_proof']); ?>" alt="Bukti Transfer" style="width: 100%; border-radius: 10px; cursor: pointer;" onclick="window.open(this.src)">
                        <small style="display: block; text-align: center; margin-top: 10px; color: #888;">Klik gambar untuk memperbesar</small>
                    </div>
                    <?php endif; ?>
                </div>
            </div>
            
            
            <div class="invoice-footer">
                <p>Terima kasih telah berbelanja di <?php echo SITE_NAME; ?>.</p>
                <p>Dokumen ini adalah bukti pembayaran yang sah dan diterbitkan secara otomatis oleh komputer.</p>
            </div>
        </div>
    </div>

<?php if(isset($_GET['notify'])): ?>
    <script>
        window.open('<?php echo $wa_url; ?>', '_blank');
    </script>
    <?php endif; ?>

function updateDeliveredState() {
            const isPaid = paymentStatusSelect.value === 'paid';
            const isCurrentlyDelivered = orderStatusSelect.value === 'delivered';
            
            // Disable "Selesai" option jika pembayaran belum "Lunas"
            if(deliveredOption) {
                deliveredOption.disabled = !isPaid;
                deliveredOption.title = isPaid ? 'Tersedia' : 'Pembayaran harus "Lunas" terlebih dahulu';
            }

// Jika mengubah status pembayaran dan order sedang "Selesai", ubah kembali ke "Dikirim"
            if(!isPaid && isCurrentlyDelivered) {
                orderStatusSelect.value = 'shipped';
            }
        }

// Form submission validation
        function validateFormSubmission(e) {
            const isPaid = paymentStatusSelect.value === 'paid';
            const wantDelivered = orderStatusSelect.value === 'delivered';

if(wantDelivered && !isPaid) {
                e.preventDefault();
                alert('⚠️ Pembayaran Wajib!\n\nAnda tidak dapat menandai pesanan sebagai "Selesai" sebelum status pembayaran diubah menjadi "Lunas".\n\nSilakan:\n1. Perbarui status pembayaran menjadi "Lunas" terlebih dahulu\n2. Kemudian tandai pesanan sebagai "Selesai"');
                orderStatusSelect.focus();
                return false;
            }
        }

// Listen to payment status changes
        paymentStatusSelect.addEventListener('change', updateDeliveredState);
        
        // Form submission validation
        const form = updateButton.closest('form');
        if(form) {
            form.addEventListener('submit', validateFormSubmission);
        }

// Initialize on page load
        updateDeliveredState();
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: order_detail.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation