OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/28/2024 11:03:35 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .gitignore	42 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .htaccess	803 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 .htaccess.swp	12 KB	08/16/2024 08:23:43 AM	rw-r--r--
📄 .travis.yml	199 bytes	08/16/2024 08:23:43 AM	rw-r--r--
📄 addList.php	4.7 KB	08/16/2024 08:23:43 AM	rw-r--r--
📄 allTemplates.php	5 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bbsns_subscribe.php	5.14 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bcreateList.php	9.61 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 blacklist.php	14.09 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bounceViewList.php	5.86 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bounce_handler.php	9.87 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 bprocess_emails.php	6.73 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	08/16/2024 08:23:44 AM	rw-r--r--
📁 check_identity	-	08/16/2024 08:23:47 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 ckeditor.php	2.14 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 click_handler.php	1.75 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 combined.php	11.28 KB	08/16/2024 08:23:44 AM	rw-r--r--
📄 complaintsViewList.php	5.72 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 composer.json	200 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 composer.lock	39.12 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 createList.php	10.05 KB	08/16/2024 08:23:45 AM	rw-r--r--
📁 credentials	-	08/16/2024 08:23:47 AM	rwxr-xr-x
📄 csv.php	10.1 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 db.php	1000 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 delete_list.php	565 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 deliveryViewList.php	5.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_Complaints.php	974 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_bounces.php	1007 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_delivered.php	971 bytes	08/16/2024 08:23:45 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 edit_list.php	8.45 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 feedback.php	1.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 footer.php	4.71 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 housekeeping.php	10.03 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 index.php	8.12 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 insert_list.php	2.64 KB	08/16/2024 08:23:45 AM	rw-r--r--
📁 log	-	08/16/2024 08:23:52 AM	rwxr-xr-x
📄 navbar.php	1.64 KB	08/16/2024 08:23:45 AM	rw-r--r--
📄 newCompaign.php	5.94 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 open_handler.php	1.75 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 process_emails.php	10.21 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sample.csv	55 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 send_email.php	987 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 send_email_campaignGraph.php	2.24 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sendgrid.php	3.62 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 showListMembers.php	4.59 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 showcase.php	7.93 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sidebar.php	3.11 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 submit_form.php	2.48 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 test-mail.csv	337 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 test.php	969 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 upload_image.php	606 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📁 uploads	-	08/16/2024 08:24:03 AM	rwxr-xr-x
📁 vendor	-	08/16/2024 08:24:30 AM	rwxr-xr-x
📄 verify.html	486 bytes	08/16/2024 08:23:46 AM	rw-r--r--
📄 verify.php	3.12 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 verify_email.php	5.12 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 viewCampaign.php	13.05 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 viewList.php	8.53 KB	08/16/2024 08:23:46 AM	rw-r--r--
📄 zsidebar.php	3.27 KB	08/16/2024 08:23:47 AM	rw-r--r--
📄 zviewCampaign.php	8.94 KB	08/16/2024 08:23:47 AM	rw-r--r--
📄 zzprocess_emails.php	10.07 KB	08/16/2024 08:23:47 AM	rw-r--r--

Editing: zviewCampaign.php

<?php
// Include necessary files
include '../inc/validate.logged.php';
include '../inc/config.php';
include 'db.php';

// Get the campaign ID from the query parameter
$campaignId = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch unique clicks, unique opens, bounces, and deliveries
function fetch_campaign_data($conn, $campaignId)
{
    $data = [];

$queries = [
        'unique_clicks' => "SELECT COUNT(*) AS count FROM messages m INNER JOIN email_clicks ec ON ec.message_id = m.message_id WHERE m.campaign_id = ?",
        'unique_opens' => "SELECT COUNT(*) AS count FROM messages m INNER JOIN email_opens eo ON eo.message_id = m.message_id WHERE m.campaign_id = ?",
        'bounces' => "SELECT COUNT(*) AS count FROM bounces b INNER JOIN messages m ON m.message_id = b.message_id WHERE m.campaign_id = ?",
        'deliveries' => "SELECT COUNT(*) AS count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id WHERE m.campaign_id = ?"
    ];

foreach ($queries as $key => $query) {
        $stmt = $conn->prepare($query);
        $stmt->bind_param("i", $campaignId);
        $stmt->execute();
        $result = $stmt->get_result();
        $data[$key] = $result->fetch_assoc()['count'];
        $stmt->close();
    }

return $data;
}

// Fetch campaign details
$campaignData = fetch_campaign_data($conn, $campaignId);
$campaign = $conn->query("SELECT campaign_name, action, list_id, sent_date FROM campaigns WHERE id = $campaignId")->fetch_assoc();
$list = $conn->query("SELECT list_name FROM list WHERE id = {$campaign['list_id']}")->fetch_assoc();
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Knobly Cream: Create &bull; Reach &bull; Measure</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <link rel="stylesheet" href="../inc/style.css" />
    <link rel="stylesheet" href="../inc/genai_style.css" />
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" crossorigin="anonymous"></script>
    <style>
        .chart-container {
            display: flex;
            justify-content: space-between;
            height: 300px; /* Same height for both charts */
        }

.chart {
            width: 48%;
        }

.bar-chart-container {
            height: 300px;
        }

h2 {
            margin-bottom: 20px;
            font-size: 24px;
            font-weight: bold;
            color: #333;
        }

p {
            margin-bottom: 5px;
            color: #555;
        }

.btn-secondary {
            margin-right: 10px;
        }

.legend {
            display: flex;
            justify-content: center;
            margin-top: 10px;
        }

.legend-item {
            display: flex;
            align-items: center;
            margin-right: 15px;
        }

.legend-dot {
            width: 10px;
            height: 10px;
            border-radius: 50%;
            margin-right: 5px;
        }
    </style>
</head>

<body class="sb-nav-fixed">
    <?php include "navbar.php"; ?>
    <div id="layoutSidenav">
        <?php include 'sidebar.php'; ?>
        <div id="layoutSidenav_content">
            <main>
                <div id="panelContent" class="container-fluid">
                    <div class="container mt-5">
                        <h2>Campaign Details: <?= htmlspecialchars($campaign['campaign_name']) ?></h2>
                        <p><strong>Action:</strong> <?= htmlspecialchars($campaign['action']) ?></p>
                        <p><strong>List Name:</strong> <?= htmlspecialchars($list['list_name']) ?></p>
                        <p><strong>Sent Date:</strong> <?= htmlspecialchars($campaign['sent_date']) ?></p>

<div class="chart-container">
                            
                            <div class="chart">
                                <canvas id="deliveriesBouncesChart"></canvas>
                                <div class="chart-buttons">
                                    <button onclick="downloadChart('deliveriesBouncesChart', 'Deliveries_Bounces_Chart.png')" class="btn btn-secondary">Download Chart Image</button>
                                </div>
                            </div>

<div class="chart">
                                <canvas id="horizontalBarChart"></canvas>
                                <div class="legend">
                                    <div class="legend-item">
                                        <div class="legend-dot" style="background-color: #4caf50;"></div> Delivered
                                    </div>
                                    <div class="legend-item">
                                        <div class="legend-dot" style="background-color: #f44336;"></div> Bounces
                                    </div>
                                    <div class="legend-item">
                                        <div class="legend-dot" style="background-color: #3f51b5;"></div> Unique Opens
                                    </div>
                                    <div class="legend-item">
                                        <div class="legend-dot" style="background-color: #ff9800;"></div> Unique Clicks
                                    </div>
                                </div>
                                <div class="chart-buttons">
                                    <button onclick="downloadChart('horizontalBarChart', 'Campaign_Stats_Chart.png')" class="btn btn-secondary">Download Chart Image</button>
                                </div>
                            </div>
                        </div>

</div>
                </div>
            </main>
        </div>
    </div>

// Pie Chart
        const deliveriesBouncesChart = new Chart(document.getElementById('deliveriesBouncesChart'), {
            type: 'pie',
            data: {
                labels: ['Delivered', 'Bounced', 'Unique Opens', 'Unique Clicks'],
                datasets: [{
                    data: [deliveries, bounces, unique_opens, unique_clicks],
                    backgroundColor: ['#4caf50', '#f44336', '#3f51b5', '#ff9800']
                }]
            },
            options: {
                title: {
                    display: true,
                    text: 'Deliveries vs Bounces vs Unique Opens vs Unique Clicks'
                },
                responsive: true,
                maintainAspectRatio: false, // Ensures responsiveness
            }
        });

// Horizontal Bar Chart
        const horizontalBarChart = new Chart(document.getElementById('horizontalBarChart'), {
            type: 'horizontalBar',
            data: {
                labels: ['Delivered', 'Bounces', 'Unique Opens', 'Unique Clicks'],
                datasets: [{
                    label: 'Count',
                    data: [deliveries, bounces, unique_opens, unique_clicks],
                    backgroundColor: ['#4caf50', '#f44336', '#3f51b5', '#ff9800'],
                    borderWidth: 1,
                    barThickness: 20 // Makes the bars thinner
                }]
            },
            options: {
                title: {
                    display: true,
                    text: 'Campaign Statistics'
                },
                scales: {
                    xAxes: [{
                        ticks: {
                            beginAtZero: true
                        }
                    }]
                },
                responsive: true,
                maintainAspectRatio: false, // Ensures responsiveness
                tooltips: {
                    enabled: true,
                    callbacks: {
                        label: function(tooltipItem) {
                            return tooltipItem.xLabel;
                        }
                    }
                }
            }
        });

function downloadChart(chartId, filename) {
            const link = document.createElement('a');
            link.href = document.getElementById(chartId).toDataURL('image/png');
            link.download = filename;
            link.click();
        }
    </script>
</body>

</html>