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_history.php

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

// Set timezone ke Asia/Jakarta (WIB) agar jam cetak sesuai
date_default_timezone_set('Asia/Jakarta');

checkAdminLogin();

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

// Ambil Parameter Filter
$search = $_GET['search'] ?? '';
$filter_type = $_GET['filter_type'] ?? 'all';
$filter_date = $_GET['filter_date'] ?? date('Y-m-d');
$filter_month = $_GET['filter_month'] ?? date('m');
$filter_year = $_GET['filter_year'] ?? date('Y');

// Jika ada pencarian, otomatis set filter ke 'Semua' agar data ditemukan
if(!empty($search)) {
    $filter_type = 'all';
}

// Query Dasar: Hanya pesanan yang sudah selesai (delivered)
$query = "SELECT o.*, c.name as customer_name, c.phone 
          FROM orders o 
          LEFT JOIN customers c ON o.customer_id = c.id 
          WHERE o.order_status = 'delivered'";

$params = [];

// Filter Pencarian (No Pesanan / Nama)
if(!empty($search)) {
    $query .= " AND (o.order_number LIKE :search OR c.name LIKE :search OR c.phone LIKE :search)";
    $params[':search'] = "%$search%";
}

// Judul Laporan Default
$report_title = "Semua Riwayat Pesanan Selesai";

// Logika Filter Waktu
if($filter_type == 'date') {
    $query .= " AND DATE(o.created_at) = :date";
    $params[':date'] = $filter_date;
    $report_title = "Laporan Penjualan Tanggal " . date('d/m/Y', strtotime($filter_date));
} elseif($filter_type == 'month') {
    $query .= " AND MONTH(o.created_at) = :month AND YEAR(o.created_at) = :year";
    $params[':month'] = $filter_month;
    $params[':year'] = $filter_year;
    $month_name = date('F', mktime(0, 0, 0, $filter_month, 10));
    $report_title = "Laporan Penjualan Bulan $month_name $filter_year";
} elseif($filter_type == 'year') {
    $query .= " AND YEAR(o.created_at) = :year";
    $params[':year'] = $filter_year;
    $report_title = "Laporan Penjualan Tahun $filter_year";
}

$query .= " ORDER BY o.created_at DESC";

$stmt = $db->prepare($query);
foreach($params as $key => $val) {
    $stmt->bindValue($key, $val);
}
$stmt->execute();
$orders = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Hitung Total Pendapatan
$total_revenue = 0;
foreach($orders as $o) $total_revenue += $o['total_amount'];
?>
<!DOCTYPE html>
<html lang="id">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Riwayat & Laporan - <?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>
        .filter-box { background: white; padding: 20px; border-radius: 15px; margin-bottom: 20px; box-shadow: 0 5px 20px rgba(0,0,0,0.05); }
        .filter-form { display: flex; gap: 15px; align-items: flex-end; flex-wrap: wrap; }
        .filter-group { display: flex; flex-direction: column; gap: 5px; }
        .filter-group label { font-size: 0.9rem; font-weight: 600; color: #666; }
        .filter-group select, .filter-group input { padding: 10px 15px; border: 1px solid #ddd; border-radius: 8px; font-family: inherit; }
        .print-header { display: none; }
        .print-footer { display: none; }
        
        @media print {
            @page { size: A4; margin: 1.5cm; }
            .sidebar, .topbar, .page-header, .filter-box, .btn-action, .no-print { display: none !important; }
            .main-content { margin: 0 !important; padding: 0 !important; width: 100% !important; }
            .content-area { padding: 0 !important; box-shadow: none !important; }
            .content-box { box-shadow: none !important; padding: 0 !important; background: none !important; }
            
            body { 
                background: white; 
                font-family: 'Poppins', sans-serif;
                -webkit-print-color-adjust: exact !important;
                print-color-adjust: exact !important;
            }

.print-header { 
                display: block !important; 
                text-align: center; 
                margin-bottom: 30px; 
                border-bottom: 3px double #333; 
                padding-bottom: 20px; 
            }
            .print-header h2 { font-size: 24pt; margin: 0 0 5px 0; color: #ff4757 !important; text-transform: uppercase; font-weight: 800; }
            .print-header h3 { font-size: 14pt; margin: 0 0 5px 0; color: #333; font-weight: 600; }
            .print-header p { font-size: 10pt; color: #666; margin: 0; font-style: italic; }

.table-responsive { overflow: visible !important; }
            .data-table { width: 100% !important; border-collapse: collapse !important; border: 1px solid #000 !important; font-size: 10pt; }
            .data-table th { 
                background-color: #f2f2f2 !important; 
                color: #000 !important; 
                border: 1px solid #000 !important; 
                padding: 10px !important;
                text-transform: uppercase;
                font-weight: 700;
            }
            .data-table td { 
                border: 1px solid #000 !important; 
                padding: 8px 10px !important;
                color: #000 !important;
                vertical-align: middle;
            }
            
            /* Total Row Styling */
            .data-table tr:last-child { background-color: #fff !important; }
            .data-table tr:last-child td { 
                border-top: 2px solid #000 !important; 
                font-weight: bold !important; 
                font-size: 12pt !important; 
                background-color: #f8f9fa !important;
            }

/* Footer for signature */
            .print-footer {
                display: flex !important;
                justify-content: space-between;
                margin-top: 50px;
                page-break-inside: avoid;
            }
            .signature-box {
                text-align: center;
                width: 200px;
            }
            .signature-line {
                border-bottom: 1px solid #000;
                margin-top: 70px;
                margin-bottom: 5px;
            }
            .signature-box p { font-size: 10pt; margin: 0; }
        }
    </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-history"></i> Riwayat Pesanan</h1>
                <div style="display: flex; gap: 10px;">
                    <a href="manage_orders.php" class="btn-primary" style="background: #6c757d; border-color: #6c757d;">
                        <i class="fas fa-arrow-left"></i> Kembali
                    </a>
                    <button onclick="window.print()" class="btn-primary">
                        <i class="fas fa-print"></i> Cetak Laporan
                    </button>
                </div>
            </div>

<div class="filter-box">
                <form method="GET" class="filter-form">
                    <div class="filter-group">
                        <label>Cari</label>
                        <input type="text" name="search" placeholder="No. Pesanan / Nama / HP" value="<?php echo htmlspecialchars($search); ?>">
                    </div>
                    
                    <div class="filter-group">
                        <label>Filter Berdasarkan</label>
                        <select name="filter_type" onchange="this.form.submit()">
                            <option value="all" <?php echo $filter_type == 'all' ? 'selected' : ''; ?>>Semua</option>
                            <option value="date" <?php echo $filter_type == 'date' ? 'selected' : ''; ?>>Per Tanggal</option>
                            <option value="month" <?php echo $filter_type == 'month' ? 'selected' : ''; ?>>Per Bulan</option>
                            <option value="year" <?php echo $filter_type == 'year' ? 'selected' : ''; ?>>Per Tahun</option>
                        </select>
                    </div>

<?php if($filter_type == 'date'): ?>
                    <div class="filter-group">
                        <label>Tanggal</label>
                        <input type="date" name="filter_date" value="<?php echo $filter_date; ?>">
                    </div>
                    <?php endif; ?>

<?php if($filter_type == 'month'): ?>
                    <div class="filter-group">
                        <label>Bulan</label>
                        <select name="filter_month">
                            <?php for($m=1; $m<=12; $m++): ?>
                                <option value="<?php echo $m; ?>" <?php echo $filter_month == $m ? 'selected' : ''; ?>>
                                    <?php echo date('F', mktime(0,0,0,$m, 10)); ?>
                                </option>
                            <?php endfor; ?>
                        </select>
                    </div>
                    <div class="filter-group">
                        <label>Tahun</label>
                        <select name="filter_year">
                            <?php for($y=date('Y'); $y>=2020; $y--): ?>
                                <option value="<?php echo $y; ?>" <?php echo $filter_year == $y ? 'selected' : ''; ?>><?php echo $y; ?></option>
                            <?php endfor; ?>
                        </select>
                    </div>
                    <?php endif; ?>

<?php if($filter_type == 'year'): ?>
                    <div class="filter-group">
                        <label>Tahun</label>
                        <select name="filter_year">
                            <?php for($y=date('Y'); $y>=2020; $y--): ?>
                                <option value="<?php echo $y; ?>" <?php echo $filter_year == $y ? 'selected' : ''; ?>><?php echo $y; ?></option>
                            <?php endfor; ?>
                        </select>
                    </div>
                    <?php endif; ?>

<div class="filter-group" style="justify-content: flex-end;">
                        <button type="submit" class="btn-primary" style="padding: 10px 20px;">
                            <i class="fas fa-filter"></i> Terapkan
                        </button>
                    </div>
                </form>
            </div>

<div class="content-box">
                <div class="print-header">
                    <h2><?php echo SITE_NAME; ?></h2>
                    <h3><?php echo $report_title; ?></h3>
                    <p>Dicetak pada: <?php echo date('d F Y, H:i'); ?> WIB</p>
                </div>

<div class="table-responsive">
                    <table class="data-table">
                        <thead>
                            <tr>
                                <th>No. Pesanan</th>
                                <th>Tanggal</th>
                                <th>Pelanggan</th>
                                <th>Total</th>
                                <th class="no-print">Aksi</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if(count($orders) > 0): ?>
                                <?php foreach($orders as $order): ?>
                                <tr>
                                    <td><strong><?php echo htmlspecialchars($order['order_number']); ?></strong></td>
                                    <td><?php echo date('d/m/Y', strtotime($order['created_at'])); ?></td>
                                    <td>
                                        <?php echo htmlspecialchars($order['customer_name']); ?><br>
                                        <small><?php echo htmlspecialchars($order['phone']); ?></small>
                                    </td>
                                    <td>Rp <?php echo number_format($order['total_amount'], 0, ',', '.'); ?></td>
                                    <td class="no-print">
                                        <a href="order_detail.php?id=<?php echo $order['id']; ?>" class="btn-action btn-info">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                    </td>
                                </tr>
                                <?php endforeach; ?>
                                <tr style="background: #f8f9fa; font-weight: bold;">
                                    <td colspan="3" style="text-align: right;">TOTAL PENDAPATAN</td>
                                    <td colspan="2" style="color: #2ecc71; font-size: 1.1rem;">
                                        Rp <?php echo number_format($total_revenue, 0, ',', '.'); ?>
                                    </td>
                                </tr>
                            <?php else: ?>
                                <tr>
                                    <td colspan="5" style="text-align: center;">Tidak ada data pesanan selesai untuk filter ini.</td>
                                </tr>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>

<div class="print-footer">
                    <div class="signature-box">
                        <p>Mengetahui,</p>
                        <p>Manager</p>
                        <div class="signature-line"></div>
                        <p>( ........................... )</p>
                    </div>
                    <div class="signature-box">
                        <p>Dibuat Oleh,</p>
                        <p>Admin</p>
                        <div class="signature-line"></div>
                        <p><?php echo htmlspecialchars($_SESSION['admin_username']); ?></p>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: order_history.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation