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: track_order.php

<?php
require_once '../config/database.php';
require_once '../config/constants.php';

header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    echo json_encode(['success' => false, 'message' => 'Invalid request']);
    exit;
}

$data = json_decode(file_get_contents('php://input'), true);
$action = $data['action'] ?? 'track';

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

if ($action === 'track') {
    $order_number = trim($data['order_number'] ?? '');
    $phone = trim($data['phone'] ?? '');
    
    // Bersihkan nomor HP input (hanya ambil angka) agar pencarian fleksibel
    $phone_clean = preg_replace('/[^0-9]/', '', $phone);

if (empty($order_number) || empty($phone)) {
        echo json_encode(['success' => false, 'message' => 'Mohon isi Nomor Pesanan dan Nomor HP']);
        exit;
    }

// Cari pesanan dengan pencarian HP yang lebih fleksibel
    $query = "SELECT o.*, c.name as customer_name, c.phone, c.email, c.address 
              FROM orders o 
              JOIN customers c ON o.customer_id = c.id 
              WHERE o.order_number = :order_number 
              AND (c.phone = :phone OR REPLACE(REPLACE(REPLACE(c.phone, '-', ''), ' ', ''), '+', '') = :phone_clean)
              LIMIT 1";
    
    $stmt = $db->prepare($query);
    $stmt->bindParam(':order_number', $order_number);
    $stmt->bindParam(':phone', $phone);
    $stmt->bindValue(':phone_clean', $phone_clean);
    $stmt->execute();

if ($stmt->rowCount() > 0) {
        $order = $stmt->fetch(PDO::FETCH_ASSOC);
        
        // Ambil detail item
        $queryItems = "SELECT * FROM order_items WHERE order_id = :id";
        $stmtItems = $db->prepare($queryItems);
        $stmtItems->bindParam(':id', $order['id']);
        $stmtItems->execute();
        $items = $stmtItems->fetchAll(PDO::FETCH_ASSOC);

echo json_encode([
            'success' => true,
            'data' => [
                'order' => $order,
                'items' => $items
            ]
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'Pesanan tidak ditemukan. Pastikan No. Pesanan dan No. HP sesuai.']);
    }

} elseif ($action === 'confirm') {
    $order_id = intval($data['order_id'] ?? 0);
    
    if ($order_id <= 0) {
        echo json_encode(['success' => false, 'message' => 'Invalid Order ID']);
        exit;
    }

// Update status ke 'delivered' HANYA jika status sebelumnya 'shipped'
    $query = "UPDATE orders SET order_status = 'delivered' WHERE id = :id AND order_status = 'shipped'";
    $stmt = $db->prepare($query);
    $stmt->bindParam(':id', $order_id);
    
    if ($stmt->execute() && $stmt->rowCount() > 0) {
        echo json_encode(['success' => true, 'message' => 'Terima kasih! Pesanan telah dikonfirmasi diterima.']);
    } else {
        echo json_encode(['success' => false, 'message' => 'Gagal konfirmasi. Status pesanan mungkin belum dikirim atau sudah selesai.']);
    }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: track_order.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation