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/aquajungletuban/owner/dashboard

Free Space:

9.88 TB

🔧 Quick Actions

✏️ Editing: laporan.php

<?php
// JANGAN ADA SPASI SEBELUM <?php INI!

// Matikan error display
error_reporting(E_ALL);
ini_set('display_errors', 0);
ini_set('log_errors', 1);

// Mulai output buffering
ob_start();

session_start();
require_once '../../config/db.php';

// Increase memory limit
ini_set('memory_limit', '256M');
ini_set('max_execution_time', '300');

// Get filter parameters
$date_from = $_GET['date_from'] ?? date('Y-m-01'); // Default: awal bulan ini
$date_to = $_GET['date_to'] ?? date('Y-m-d'); // Default: hari ini

// Build where clause for date filter
$where_clause = "WHERE DATE(dibuat_pada) BETWEEN '$date_from' AND '$date_to'";

// Bersihkan semua output sebelumnya
while (ob_get_level()) {
    ob_end_clean();
}

// Include TCPDF
require_once('../../vendor/tecnickcom/tcpdf/tcpdf.php');

// Create PDF
$pdf = new TCPDF('P', PDF_UNIT, 'A4', true, 'UTF-8', false);

// Set document information
$pdf->SetCreator('Aqua Jungle Tuban');
$pdf->SetAuthor('Aqua Jungle Tuban');
$pdf->SetTitle('Laporan Penjualan Lengkap');
$pdf->SetSubject('Laporan Komprehensif');

// Remove header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);

// Set margins
$pdf->SetMargins(15, 15, 15);
$pdf->SetAutoPageBreak(TRUE, 15);

// Add page
$pdf->AddPage();

// Set font
$pdf->SetFont('helvetica', '', 10);

// ====================
// COVER PAGE
// ====================
$html = '<div style="text-align: center; margin-top: 80px;">
    <h1 style="color: #2563eb; font-size: 32px; margin-bottom: 10px;">AQUA JUNGLE TUBAN</h1>
    <p style="color: #666; font-size: 14px; margin-bottom: 60px;">Laporan Penjualan & Analisis Bisnis</p>
    
    <div style="background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); padding: 40px; border-radius: 10px; color: white; margin: 40px 0;">
        <h2 style="font-size: 28px; margin: 0 0 20px 0;">LAPORAN LENGKAP</h2>
        <p style="font-size: 16px; margin: 10px 0;">Periode Laporan</p>
        <p style="font-size: 20px; font-weight: bold; margin: 10px 0;">' . date('d F Y', strtotime($date_from)) . '</p>
        <p style="font-size: 16px; margin: 5px 0;">sampai</p>
        <p style="font-size: 20px; font-weight: bold; margin: 10px 0;">' . date('d F Y', strtotime($date_to)) . '</p>
    </div>
    
    <div style="margin-top: 80px; padding: 20px; background-color: #f3f4f6; border-radius: 8px;">
        <p style="color: #374151; font-size: 12px; margin: 5px 0;"><strong>Tanggal Dibuat:</strong> ' . date('d F Y, H:i') . ' WIB</p>
        <p style="color: #374151; font-size: 12px; margin: 5px 0;"><strong>Dibuat Oleh:</strong> ' . ($_SESSION['nama_pengguna'] ?? 'System') . '</p>
        <p style="color: #374151; font-size: 12px; margin: 5px 0;"><strong>Status:</strong> Final Report</p>
    </div>
</div>';

$pdf->writeHTML($html, true, false, true, false, '');

// ====================
// PAGE 2: RINGKASAN EKSEKUTIF
// ====================
$pdf->AddPage();

// Header
$html = '<table style="width: 100%; border-bottom: 3px solid #2563eb; padding-bottom: 10px; margin-bottom: 20px;">
    <tr>
        <td style="width: 70%;">
            <h1 style="color: #2563eb; margin: 0; font-size: 20px;">AQUA JUNGLE TUBAN</h1>
            <p style="margin: 5px 0; color: #666; font-size: 9px;">Jl. Veteran No. 45, Tuban, Jawa Timur</p>
        </td>
        <td style="width: 30%; text-align: right;">
            <p style="margin: 0; font-size: 9px; color: #666;">Halaman {PAGENO}</p>
        </td>
    </tr>
</table>';

$html .= '<h2 style="color: #1f2937; margin: 20px 0 15px 0; font-size: 16px; border-left: 4px solid #2563eb; padding-left: 10px;">📊 RINGKASAN EKSEKUTIF</h2>';

// Get summary data
$sql_transaksi = "SELECT 
    COUNT(*) as total_transaksi,
    SUM(CASE WHEN status = 'berhasil' THEN 1 ELSE 0 END) as transaksi_berhasil,
    SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as transaksi_pending,
    SUM(CASE WHEN status = 'gagal' THEN 1 ELSE 0 END) as transaksi_gagal,
    SUM(CASE WHEN status = 'berhasil' THEN total_harga ELSE 0 END) as total_pendapatan,
    AVG(CASE WHEN status = 'berhasil' THEN total_harga ELSE NULL END) as rata_rata_transaksi,
    SUM(CASE WHEN status = 'berhasil' THEN quantity ELSE 0 END) as total_produk_terjual
FROM transaksi $where_clause";

$result = $conn->query($sql_transaksi);
$summary = $result->fetch_assoc();

$total_transaksi = $summary['total_transaksi'];
$transaksi_berhasil = $summary['transaksi_berhasil'];
$transaksi_pending = $summary['transaksi_pending'];
$transaksi_gagal = $summary['transaksi_gagal'];
$total_pendapatan = $summary['total_pendapatan'];
$rata_rata_transaksi = $summary['rata_rata_transaksi'];
$total_produk_terjual = $summary['total_produk_terjual'];

// Success rate
$success_rate = $total_transaksi > 0 ? round(($transaksi_berhasil / $total_transaksi) * 100, 1) : 0;

// Summary Cards
$html .= '<table style="width: 100%; margin: 20px 0;">
    <tr>
        <td style="width: 50%; padding: 15px; background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); border-radius: 8px; color: white;">
            <p style="margin: 0; font-size: 10px; opacity: 0.9;">Total Pendapatan</p>
            <p style="margin: 8px 0 0 0; font-size: 20px; font-weight: bold;">Rp ' . number_format($total_pendapatan, 0, ',', '.') . '</p>
            <p style="margin: 5px 0 0 0; font-size: 8px; opacity: 0.8;">Dari ' . $transaksi_berhasil . ' transaksi berhasil</p>
        </td>
        <td style="width: 50%; padding: 15px; background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%); border-radius: 8px; color: white;">
            <p style="margin: 0; font-size: 10px; opacity: 0.9;">Rata-rata Transaksi</p>
            <p style="margin: 8px 0 0 0; font-size: 20px; font-weight: bold;">Rp ' . number_format($rata_rata_transaksi, 0, ',', '.') . '</p>
            <p style="margin: 5px 0 0 0; font-size: 8px; opacity: 0.8;">Per transaksi berhasil</p>
        </td>
    </tr>
</table>';

$html .= '<table style="width: 100%; margin: 20px 0;">
    <tr>
        <td style="width: 33%; padding: 12px; background-color: #dbeafe; border-radius: 8px; text-align: center;">
            <p style="margin: 0; color: #1e40af; font-size: 9px;">Total Transaksi</p>
            <p style="margin: 5px 0; color: #1e3a8a; font-size: 24px; font-weight: bold;">' . $total_transaksi . '</p>
        </td>
        <td style="width: 33%; padding: 12px; background-color: #dcfce7; border-radius: 8px; text-align: center;">
            <p style="margin: 0; color: #166534; font-size: 9px;">Produk Terjual</p>
            <p style="margin: 5px 0; color: #14532d; font-size: 24px; font-weight: bold;">' . $total_produk_terjual . '</p>
        </td>
        <td style="width: 33%; padding: 12px; background-color: #fef3c7; border-radius: 8px; text-align: center;">
            <p style="margin: 0; color: #92400e; font-size: 9px;">Success Rate</p>
            <p style="margin: 5px 0; color: #78350f; font-size: 24px; font-weight: bold;">' . $success_rate . '%</p>
        </td>
    </tr>
</table>';

// Status Breakdown
$html .= '<h3 style="color: #374151; margin: 30px 0 15px 0; font-size: 12px; font-weight: bold;">Status Transaksi</h3>';

$html .= '<table border="1" cellpadding="8" style="border-collapse: collapse; width: 100%;">
    <thead>
        <tr style="background-color: #f3f4f6;">
            <th style="text-align: left; font-size: 10px; color: #374151; width: 40%;">Status</th>
            <th style="text-align: center; font-size: 10px; color: #374151; width: 30%;">Jumlah</th>
            <th style="text-align: center; font-size: 10px; color: #374151; width: 30%;">Persentase</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td style="font-size: 9px;"><span style="color: #10b981; font-weight: bold;">● </span>Berhasil</td>
            <td style="text-align: center; font-size: 9px; font-weight: bold;">' . $transaksi_berhasil . '</td>
            <td style="text-align: center; font-size: 9px;">' . ($total_transaksi > 0 ? round(($transaksi_berhasil/$total_transaksi)*100, 1) : 0) . '%</td>
        </tr>
        <tr style="background-color: #f9fafb;">
            <td style="font-size: 9px;"><span style="color: #f59e0b; font-weight: bold;">● </span>Pending</td>
            <td style="text-align: center; font-size: 9px; font-weight: bold;">' . $transaksi_pending . '</td>
            <td style="text-align: center; font-size: 9px;">' . ($total_transaksi > 0 ? round(($transaksi_pending/$total_transaksi)*100, 1) : 0) . '%</td>
        </tr>
        <tr>
            <td style="font-size: 9px;"><span style="color: #ef4444; font-weight: bold;">● </span>Gagal</td>
            <td style="text-align: center; font-size: 9px; font-weight: bold;">' . $transaksi_gagal . '</td>
            <td style="text-align: center; font-size: 9px;">' . ($total_transaksi > 0 ? round(($transaksi_gagal/$total_transaksi)*100, 1) : 0) . '%</td>
        </tr>
    </tbody>
</table>';

$pdf->writeHTML($html, true, false, true, false, '');

// ====================
// PAGE 3: ANALISIS PENDAPATAN
// ====================
$pdf->AddPage();

$html = '<table style="width: 100%; border-bottom: 3px solid #2563eb; padding-bottom: 10px; margin-bottom: 20px;">
    <tr>
        <td style="width: 70%;">
            <h1 style="color: #2563eb; margin: 0; font-size: 20px;">AQUA JUNGLE TUBAN</h1>
            <p style="margin: 5px 0; color: #666; font-size: 9px;">Jl. Veteran No. 45, Tuban, Jawa Timur</p>
        </td>
        <td style="width: 30%; text-align: right;">
            <p style="margin: 0; font-size: 9px; color: #666;">Halaman {PAGENO}</p>
        </td>
    </tr>
</table>';

$html .= '<h2 style="color: #1f2937; margin: 20px 0 15px 0; font-size: 16px; border-left: 4px solid #10b981; padding-left: 10px;">💰 ANALISIS PENDAPATAN</h2>';

// Pendapatan per Metode Pembayaran
$sql_metode = "SELECT 
    metode_bayar,
    COUNT(*) as jumlah,
    SUM(total_harga) as total
FROM transaksi 
$where_clause AND status = 'berhasil'
GROUP BY metode_bayar
ORDER BY total DESC";

$result_metode = $conn->query($sql_metode);

$html .= '<h3 style="color: #374151; margin: 20px 0 10px 0; font-size: 12px; font-weight: bold;">Pendapatan per Metode Pembayaran</h3>';

$html .= '<table border="1" cellpadding="8" style="border-collapse: collapse; width: 100%; margin-bottom: 30px;">
    <thead>
        <tr style="background-color: #f3f4f6;">
            <th style="text-align: left; font-size: 10px; color: #374151;">Metode Pembayaran</th>
            <th style="text-align: center; font-size: 10px; color: #374151;">Transaksi</th>
            <th style="text-align: right; font-size: 10px; color: #374151;">Total Pendapatan</th>
            <th style="text-align: center; font-size: 10px; color: #374151;">%</th>
        </tr>
    </thead>
    <tbody>';

while ($row = $result_metode->fetch_assoc()) {
    $persentase = $total_pendapatan > 0 ? round(($row['total'] / $total_pendapatan) * 100, 1) : 0;
    $html .= '<tr>
        <td style="font-size: 9px;">' . $row['metode_bayar'] . '</td>
        <td style="text-align: center; font-size: 9px;">' . $row['jumlah'] . '</td>
        <td style="text-align: right; font-size: 9px; font-weight: bold;">Rp ' . number_format($row['total'], 0, ',', '.') . '</td>
        <td style="text-align: center; font-size: 9px;">' . $persentase . '%</td>
    </tr>';
}

$html .= '</tbody></table>';

// Pendapatan Harian (chart sederhana)
$sql_daily = "SELECT 
    DATE(dibuat_pada) as tanggal,
    COUNT(*) as jumlah_transaksi,
    SUM(CASE WHEN status = 'berhasil' THEN total_harga ELSE 0 END) as pendapatan
FROM transaksi 
$where_clause
GROUP BY DATE(dibuat_pada)
ORDER BY tanggal DESC
LIMIT 10";

$result_daily = $conn->query($sql_daily);

$html .= '<h3 style="color: #374151; margin: 30px 0 10px 0; font-size: 12px; font-weight: bold;">Tren Pendapatan Harian (10 Hari Terakhir)</h3>';

$max_pendapatan = 0;
$daily_data = [];
while ($row = $result_daily->fetch_assoc()) {
    $daily_data[] = $row;
    if ($row['pendapatan'] > $max_pendapatan) {
        $max_pendapatan = $row['pendapatan'];
    }
}

foreach (array_reverse($daily_data) as $row) {
    $bar_width = $max_pendapatan > 0 ? round(($row['pendapatan'] / $max_pendapatan) * 100) : 0;
    $bar = '<div style="background-color: #3b82f6; height: 8px; width: ' . $bar_width . '%;"></div>';
    
    $html .= '<tr>
        <td style="font-size: 9px;">' . date('d M Y', strtotime($row['tanggal'])) . '</td>
        <td style="text-align: center; font-size: 9px;">' . $row['jumlah_transaksi'] . '</td>
        <td style="text-align: right; font-size: 9px; font-weight: bold;">Rp ' . number_format($row['pendapatan'], 0, ',', '.') . '</td>
        <td style="font-size: 9px;">' . $bar . '</td>
    </tr>';
}

$html .= '</tbody></table>';

$pdf->writeHTML($html, true, false, true, false, '');

// ====================
// PAGE 4: TOP PRODUK TERLARIS
// ====================
$pdf->AddPage();

$html .= '<h2 style="color: #1f2937; margin: 20px 0 15px 0; font-size: 16px; border-left: 4px solid #f59e0b; padding-left: 10px;">🏆 TOP PRODUK TERLARIS</h2>';

// Top 10 Produk
$sql_top_produk = "SELECT 
    produk_nama,
    COUNT(*) as jumlah_transaksi,
    SUM(quantity) as total_terjual,
    SUM(total_harga) as total_pendapatan,
    AVG(produk_harga) as harga_rata
FROM transaksi 
$where_clause AND status = 'berhasil'
GROUP BY produk_nama
ORDER BY total_terjual DESC
LIMIT 10";

$result_top = $conn->query($sql_top_produk);

$html .= '<p style="color: #6b7280; font-size: 9px; margin-bottom: 15px;">Berikut adalah 10 produk dengan penjualan tertinggi pada periode ini:</p>';

$html .= '<table border="1" cellpadding="8" style="border-collapse: collapse; width: 100%;">
    <thead>
        <tr style="background-color: #fef3c7;">
            <th style="text-align: center; font-size: 10px; color: #92400e; width: 8%;">Rank</th>
            <th style="text-align: left; font-size: 10px; color: #92400e;">Nama Produk</th>
            <th style="text-align: center; font-size: 10px; color: #92400e;">Terjual</th>
            <th style="text-align: right; font-size: 10px; color: #92400e;">Pendapatan</th>
        </tr>
    </thead>
    <tbody>';

$rank = 1;
$total_pendapatan_top = 0;

while ($row = $result_top->fetch_assoc()) {
    $bg_color = $rank <= 3 ? '#fffbeb' : ($rank % 2 == 0 ? '#f9fafb' : 'white');
    $medal = $rank == 1 ? '🥇' : ($rank == 2 ? '🥈' : ($rank == 3 ? '🥉' : ''));
    
    $total_pendapatan_top += $row['total_pendapatan'];
    
    $html .= '<tr style="background-color: ' . $bg_color . ';">
        <td style="text-align: center; font-size: 12px; font-weight: bold;">' . $medal . ' ' . $rank . '</td>
        <td style="font-size: 9px; font-weight: ' . ($rank <= 3 ? 'bold' : 'normal') . ';">' . $row['produk_nama'] . '</td>
        <td style="text-align: center; font-size: 9px; font-weight: bold; color: #2563eb;">' . $row['total_terjual'] . ' unit</td>
        <td style="text-align: right; font-size: 9px; font-weight: bold; color: #10b981;">Rp ' . number_format($row['total_pendapatan'], 0, ',', '.') . '</td>
    </tr>';
    $rank++;
}

$html .= '<tr style="background-color: #e0e7ff; font-weight: bold;">
    <td colspan="3" style="text-align: right; font-size: 10px; color: #3730a3; padding: 10px;">TOTAL TOP 10:</td>
    <td style="text-align: right; font-size: 10px; color: #3730a3; padding: 10px;">Rp ' . number_format($total_pendapatan_top, 0, ',', '.') . '</td>
</tr>';

$html .= '</tbody></table>';

// Kontribusi Top 10 terhadap total
$kontribusi_persen = $total_pendapatan > 0 ? round(($total_pendapatan_top / $total_pendapatan) * 100, 1) : 0;

$html .= '<div style="margin-top: 20px; padding: 15px; background-color: #e0e7ff; border-radius: 8px; border-left: 4px solid #4f46e5;">
    <p style="margin: 0; color: #3730a3; font-size: 10px; font-weight: bold;">💡 Insight</p>
    <p style="margin: 8px 0 0 0; color: #4338ca; font-size: 9px;">Top 10 produk berkontribusi <strong>' . $kontribusi_persen . '%</strong> dari total pendapatan periode ini (Rp ' . number_format($total_pendapatan_top, 0, ',', '.') . ' dari Rp ' . number_format($total_pendapatan, 0, ',', '.') . ')</p>
</div>';

$pdf->writeHTML($html, true, false, true, false, '');

// ====================
// PAGE 5: DETAIL TRANSAKSI TERBARU
// ====================
$pdf->AddPage();

$html .= '<h2 style="color: #1f2937; margin: 20px 0 15px 0; font-size: 16px; border-left: 4px solid #8b5cf6; padding-left: 10px;">📋 DETAIL TRANSAKSI TERBARU</h2>';

// Get latest 15 transactions
$sql_transaksi_detail = "SELECT * FROM transaksi $where_clause ORDER BY dibuat_pada DESC LIMIT 15";
$result_transaksi = $conn->query($sql_transaksi_detail);

$html .= '<table border="1" cellpadding="6" style="border-collapse: collapse; width: 100%; font-size: 8px;">
    <thead>
        <tr style="background-color: #f3f4f6;">
            <th style="text-align: left; color: #374151; width: 15%;">Order ID</th>
            <th style="text-align: left; color: #374151; width: 12%;">Tanggal</th>
            <th style="text-align: left; color: #374151; width: 18%;">Pembeli</th>
            <th style="text-align: left; color: #374151; width: 20%;">Produk</th>
            <th style="text-align: center; color: #374151; width: 8%;">Qty</th>
            <th style="text-align: right; color: #374151; width: 17%;">Total</th>
            <th style="text-align: center; color: #374151; width: 10%;">Status</th>
        </tr>
    </thead>
    <tbody>';

$no = 1;
while ($row = $result_transaksi->fetch_assoc()) {
    $bg_color = $no % 2 == 0 ? '#f9fafb' : 'white';
    $status_color = $row['status'] == 'berhasil' ? '#10b981' : ($row['status'] == 'pending' ? '#f59e0b' : '#ef4444');
    
    $html .= '<tr style="background-color: ' . $bg_color . ';">
        <td>' . $row['order_id'] . '</td>
        <td>' . date('d/m/Y H:i', strtotime($row['dibuat_pada'])) . '</td>
        <td>' . $row['nama_pembeli'] . '</td>
        <td>' . substr($row['produk_nama'], 0, 25) . '</td>
        <td style="text-align: center;">' . $row['quantity'] . '</td>
        <td style="text-align: right; font-weight: bold;">Rp ' . number_format($row['total_harga'], 0, ',', '.') . '</td>
        <td style="text-align: center; color: ' . $status_color . '; font-weight: bold;">' . strtoupper($row['status']) . '</td>
    </tr>';
    $no++;
}

$html .= '</tbody></table>';

$pdf->writeHTML($html, true, false, true, false, '');

// ====================
// LAST PAGE: KESIMPULAN & REKOMENDASI
// ====================
$pdf->AddPage();

$html .= '<h2 style="color: #1f2937; margin: 20px 0 15px 0; font-size: 16px; border-left: 4px solid #10b981; padding-left: 10px;">✅ KESIMPULAN & REKOMENDASI</h2>';

// Kesimpulan
$html .= '<div style="padding: 15px; background-color: #f0fdf4; border-radius: 8px; margin-bottom: 20px; border: 1px solid #bbf7d0;">
    <h3 style="color: #166534; font-size: 12px; margin: 0 0 10px 0;">📊 Kesimpulan Periode Ini:</h3>
    <ul style="color: #15803d; font-size: 9px; line-height: 1.6; margin: 0; padding-left: 20px;">
        <li>Berhasil mencatat <strong>' . $total_transaksi . ' transaksi</strong> dengan total pendapatan <strong>Rp ' . number_format($total_pendapatan, 0, ',', '.') . '</strong></li>
        <li>Success rate mencapai <strong>' . $success_rate . '%</strong> dari seluruh transaksi</li>
        <li>Rata-rata nilai per transaksi adalah <strong>Rp ' . number_format($rata_rata_transaksi, 0, ',', '.') . '</strong></li>
        <li>Total <strong>' . $total_produk_terjual . ' unit produk</strong> berhasil terjual</li>
    </ul>
</div>';

// Rekomendasi
$html .= '<div style="padding: 15px; background-color: #fef3c7; border-radius: 8px; margin-bottom: 20px; border: 1px solid #fde68a;">
    <h3 style="color: #92400e; font-size: 12px; margin: 0 0 10px 0;">💡 Rekomendasi Strategis:</h3>
    <ul style="color: #78350f; font-size: 9px; line-height: 1.6; margin: 0; padding-left: 20px;">
        <li>Fokus pada <strong>top 10 produk terlaris</strong> untuk memaksimalkan revenue</li>
        <li>Tingkatkan stok produk dengan penjualan tinggi untuk menghindari kehabisan stok</li>
        <li>Analisis produk dengan penjualan rendah untuk strategi promosi atau bundling</li>
        <li>Optimalkan metode pembayaran yang paling diminati pelanggan</li>
        <li>Follow up transaksi pending untuk meningkatkan conversion rate</li>
    </ul>
</div>';

// Performance Indicators
$html .= '<h3 style="color: #374151; margin: 30px 0 15px 0; font-size: 12px; font-weight: bold;">📈 Key Performance Indicators (KPI)</h3>';

$html .= '<table border="1" cellpadding="10" style="border-collapse: collapse; width: 100%;">
    <tr>
        <td style="width: 50%; background-color: #f3f4f6;">
            <p style="margin: 0; font-size: 9px; color: #6b7280;">Conversion Rate</p>
            <p style="margin: 5px 0 0 0; font-size: 16px; font-weight: bold; color: #2563eb;">' . $success_rate . '%</p>
        </td>
        <td style="width: 50%; background-color: #f3f4f6;">
            <p style="margin: 0; font-size: 9px; color: #6b7280;">Average Order Value</p>
            <p style="margin: 5px 0 0 0; font-size: 16px; font-weight: bold; color: #10b981;">Rp ' . number_format($rata_rata_transaksi, 0, ',', '.') . '</p>
        </td>
    </tr>
    <tr>
        <td style="background-color: #f9fafb;">
            <p style="margin: 0; font-size: 9px; color: #6b7280;">Total Customers</p>
            <p style="margin: 5px 0 0 0; font-size: 16px; font-weight: bold; color: #8b5cf6;">' . $total_transaksi . '</p>
        </td>
        <td style="background-color: #f9fafb;">
            <p style="margin: 0; font-size: 9px; color: #6b7280;">Units Sold</p>
            <p style="margin: 5px 0 0 0; font-size: 16px; font-weight: bold; color: #f59e0b;">' . $total_produk_terjual . '</p>
        </td>
    </tr>
</table>';

// Footer
$html .= '<div style="margin-top: 60px; padding-top: 20px; border-top: 2px solid #e5e7eb; text-align: center;">
    <p style="color: #6b7280; font-size: 9px; margin: 5px 0;">Laporan ini dibuat secara otomatis oleh sistem Aqua Jungle Tuban</p>
    <p style="color: #6b7280; font-size: 9px; margin: 5px 0;">Tanggal: ' . date('d F Y, H:i:s') . ' WIB</p>
    <p style="color: #6b7280; font-size: 9px; margin: 5px 0;">© 2025 Aqua Jungle Tuban. All Rights Reserved.</p>
    <p style="color: #2563eb; font-size: 9px; margin: 15px 0 0 0; font-weight: bold;">Jl. Veteran No. 45, Tuban, Jawa Timur | 0356-123456 | info@aquajungletuban.com</p>
</div>';

$pdf->writeHTML($html, true, false, true, false, '');

// Output PDF
$filename = 'Laporan_Lengkap_' . date('Y-m-d_His') . '.pdf';
$pdf->Output($filename, 'D');
exit();
// JANGAN ADA KODE APAPUN SETELAH INI!

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: laporan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation