OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 .browserslistrc	208 bytes	01/06/2025 07:58:55 AM	rw-r--r--
📄 .gitignore	42 bytes	01/06/2025 07:58:55 AM	rw-r--r--
📄 .htaccess	803 bytes	01/06/2025 07:58:55 AM	rw-r--r--
📄 .htaccess.swp	12 KB	01/06/2025 07:58:56 AM	rw-r--r--
📄 .travis.yml	199 bytes	01/06/2025 07:58:56 AM	rw-r--r--
📄 09-01-25navbar.php	23.78 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 15-02-25viewList.php	15.21 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 17-02-25newCompaign.php	13.09 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 NLEditor	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 addList.php	5.65 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 adi_deliveryViewList.php	11.25 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 aditya_choose.php	6.13 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 aditya_viewCampaign.php	25.53 KB	05/19/2025 10:07:19 AM	rwxrwxrwx
📁 assets	-	01/06/2025 08:00:13 AM	rwxr-xr-x
📄 back_choose_template.php	8.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 blacklist.php	13.47 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 bounceViewList.php	13.28 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 bounce_handler.php	5.05 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 checkNotificationTopics.php	5.11 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 check_identity	-	05/19/2025 10:07:17 AM	rwxr-xr-x
📄 checknotif.php	1.01 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 choose_template.php	9.73 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 clickViewList.php	11.72 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 click_handler.php	1.75 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 complaintsViewList.php	7.43 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 complaints_handler.php	2.89 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 composer.json	200 bytes	01/06/2025 07:59:01 AM	rw-r--r--
📄 composer.lock	39.12 KB	01/06/2025 07:59:01 AM	rw-r--r--
📄 createList.php	17.48 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 credentials	-	01/06/2025 08:01:45 AM	rwxr-xr-x
📄 csv.php	11.8 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 data	-	03/03/2025 11:56:59 AM	rwxrwxrwx
📄 db.php	1000 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 deleteCampaign.php	966 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📄 delete_list.php	903 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 delete_users.php	435 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 deliveryViewList.php	11.45 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 delivery_handler.php	3.25 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_Complaints.php	1.16 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_bounces.php	1.18 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_clicked.php	1.23 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_delivered.php	1.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_open.php	1.22 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 download_report.php	3.33 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 download_unique_open.php	1.6 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 duplicate_campaign.php	1.62 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 edit_campaign.php	1.45 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 edit_list.php	9.99 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 feedback.php	1.66 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 fetch_template.php	493 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 footer.php	1.7 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 grfx	-	01/06/2025 08:01:47 AM	rwxrwxrwx
📄 himanshu_index.php	6.66 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 himanshu_newCompaign.php	11.92 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 housekeeping.php	23.07 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 index.php	7.95 KB	05/19/2025 10:07:17 AM	rwxrwxrwx
📄 insert_list.php	2.64 KB	05/19/2025 10:07:17 AM	rw-r--r--
📁 js	-	01/06/2025 08:01:49 AM	rwxr-xr-x
📄 load.php	159 bytes	05/19/2025 10:07:19 AM	rw-r--r--
📁 log	-	01/07/2025 07:47:04 AM	rwxrwxrwx
📄 main.css	1.32 KB	01/09/2025 10:38:27 AM	rw-r--r--
📄 navbar.php	22.64 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 navbar_menu.php	1.65 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 newCompaign.php	14.61 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 obc_cards.php	8.25 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 openViewList.php	13.25 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 open_handler.php	1.75 KB	05/19/2025 10:07:19 AM	rw-r--r--
📁 process	-	05/19/2025 10:07:17 AM	rwxrwxrwx
📄 process_emails.php	11.96 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 real-recipients.csv	39.48 KB	01/06/2025 07:59:07 AM	rw-r--r--
📄 resubscribe.php	5.61 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 sample.csv	55 bytes	01/06/2025 07:59:08 AM	rw-r--r--
📄 save.php	252 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 save_campaign.php	612 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 saved_content.html	6.48 KB	01/07/2025 11:02:10 AM	rw-r--r--
📄 send_email.php	987 bytes	05/19/2025 10:07:17 AM	rwxrwxrwx
📄 send_email_campaignGraph.php	2.24 KB	05/19/2025 10:07:19 AM	rwxrwxrwx
📄 sendgrid.php	3.62 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 showListMembers.php	10.69 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 showcase.php	7.93 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 sidebar.php	0 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 sns_subscribe.php	5.25 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 submit_form.php	2.48 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 template_index.php	7.37 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 test-mail.csv	337 bytes	01/06/2025 07:59:10 AM	rw-r--r--
📄 test.php	969 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📄 test_process_emails.php	1.91 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 unsubscribe.php	7.63 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 upload_image.php	606 bytes	05/19/2025 10:07:17 AM	rw-r--r--
📁 uploads	-	03/03/2025 01:00:59 PM	rwxrwxrwx
📁 vendor	-	05/19/2025 10:07:19 AM	rwxr-xr-x
📄 verify.html	486 bytes	01/06/2025 07:59:11 AM	rw-r--r--
📄 verify.php	3.12 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 verify_email.php	5.12 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 viewCampaign.php	25.37 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 viewList.php	16.51 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 xpress_handler.php	10.38 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 znewCompaign.php	11.22 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zunsubscribe.php	6.02 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zzindex.php	6.89 KB	05/19/2025 10:07:19 AM	rw-r--r--
📄 zzzzindex.php	6.76 KB	05/19/2025 10:07:17 AM	rw-r--r--
📄 zzzzzindex.php	6.88 KB	05/19/2025 10:07:19 AM	rw-r--r--

Editing: openViewList.php

<?php
include '../assets/php/validate.logged.php';
include 'db.php';
include '../assets/php/config.php';
include '../assets/php/function.php';

// Modified SQL query to group emails by campaign and concatenate them
$sql = "SELECT c.campaign_name, GROUP_CONCAT(e.to_email SEPARATOR ', ') AS emails
        FROM email_opens e
        INNER JOIN messages m ON m.message_id = e.message_id
        INNER JOIN campaigns c ON c.id = m.campaign_id 
        WHERE e.from_email = '$gUserEmail'
        GROUP BY c.campaign_name";

$result = mysqli_query($conn, $sql);
?>

<!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.0/css/bootstrap.min.css" crossorigin="anonymous" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css">
    
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.0.0/animate.min.css" />
    <script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" crossorigin="anonymous"></script>
    <script src="https://cdn.tiny.cloud/1/u5oz235qw5jiqww4udm90ocp9zg2rncblqo2ch0ym3twjgyt/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-icons/1.10.5/font/bootstrap-icons.min.css" rel="stylesheet">
    <script src="../inc/common.js"></script>
    <link rel="stylesheet" href="../assets/css/styles.css">
    <link rel="stylesheet" href="main.css">

<style>
        .campaign-group {
            background-color: #f8f9fa;
            margin-top: 15px;
            padding: 10px;
            border-radius: 8px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }

.campaign-name {
            font-weight: bold;
            font-size: 1.1rem;
            color: #333;
        }

.email-list {
            margin-top: 10px;
            padding-left: 20px;
        }

.email-item {
            font-size: 0.9rem;
            color: #555;
            padding: 5px 0;
            border-bottom: 1px solid #ddd;
        }

.email-item:last-child {
            border-bottom: none;
        }

.email-item a {
            color: #007bff;
            text-decoration: none;
        }

.email-item a:hover {
            text-decoration: underline;
        }

.table-responsive {
            margin-top: 20px;
        }

/* Card layout for the table */
        .card {
            margin: 10px 0;
            border: 1px solid #ddd;
            border-radius: 5px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            transition: box-shadow 0.3s ease-in-out;
            height: 100%;
            /* Ensures all cards are the same height */
        }

.card:hover {
            box-shadow: 0 8px 16px rgba(0, 0, 0, 0.2);
        }

.card-header {
            background-color: #007bff;
            color: #fff;
            padding: 12px;
            font-size: 1.2rem;
        }

.card-body {
            padding: 12px;
            height: 100%;
            /* Ensures equal card height */
        }

.email-list {
            list-style-type: none;
            padding: 0;
        }

.email-list li {
            margin: 8px 0;
            font-size: 1rem;
            color: #333;
        }

/* Centering content */
        .container {
            max-width: 1200px;
        }

.table-responsive {
            padding: 0;
        }

/* Flexbox layout for equal card sizes */
        .row {
            display: flex;
            flex-wrap: wrap;
            justify-content: space-between;
        }

.col-md-4 {
            flex: 1 1 30%;
            /* Ensures three equal-width columns */
            margin: 10px;
        }

.btn-outline-success {
            background-color: #db5919;
            color: #fafafa;
            border-color: #db5919;
        }

.btn-outline-success:hover {
            color: #fff;
            background-color: #db5919;
            border-color: #db5919;
            box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5);
        }

.btn-outline-success:focus {
            box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5);
        }

.btn-outline-success:not(:disabled):not(.disabled):active:focus {
            box-shadow: 0 0 0 0.2rem rgba(219, 89, 25, 0.5);
        }

.btn-outline-success:not(:disabled):not(.disabled):active,
        .show>.btn-outline-success.dropdown-toggle {
            color: #fafafa;
            background-color: #db5919;
            border-color: #db5919;
        }

/* Responsive card sizes */
        @media (max-width: 768px) {
            .col-md-4 {
                max-width: 100%;
            }

.card {
                margin: 10px;
            }
        }

/* Outer table styling */
        .email-table {
            width: 100%;
            border-collapse: collapse;
            margin-bottom: 16px;
            background-color: #f9f9f9;
            border: 1px solid #ddd;
        }

.email-table-header {
            background-color: #343a40;
            color: #fff;
            text-align: center;
            padding: 12px;
            font-size: 18px;
            font-weight: bold;
        }

/* Inner table styling */
        .inner-email-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 8px;
        }

.inner-email-table thead th {
            background-color: #f1f1f1;
            text-align: left;
            padding: 8px;
            font-size: 16px;
            font-weight: bold;
            border-bottom: 1px solid #ddd;
        }

.inner-email-table tbody tr td {
            padding: 8px;
            border-bottom: 1px solid #ddd;
            font-size: 14px;
            color: #333;
        }

/* Alternate row colors for the inner table */
        .inner-email-table tbody tr:nth-child(even) {
            background-color: #f9f9f9;
        }

.inner-email-table tbody tr:nth-child(odd) {
            background-color: #fff;
        }

/* Add spacing to icons */
        .bi-envelope-fill {
            margin-right: 8px;
        }

/* General spacing for the outer structure */
        .col-lg-4,
        .col-md-6 {
            padding: 8px;
        }

.mb-4 {
            margin-bottom: 16px !important;
        }

.row {
            display: flex;
            /* Flexbox layout for responsiveness */
            flex-wrap: wrap;
            /* Allow wrapping for smaller screens */
            margin-right: -15px;
            margin-left: -15px;
        }

.col-lg-4 {
            margin-left: 10px;
            min-width: 1100px;
            /* Keep this for larger screens */
        }

/* Responsive adjustments for tablets and smaller devices */
        @media (max-width: 1024px) {

/* Adjust for 1024px laptops and smaller screens */
            .row {
                display: flex;
                /* Keep items in a flexible layout */
                flex-wrap: wrap;
                /* Allow wrapping on smaller widths */
                justify-content: space-around;
                /* Space items evenly */
            }

.col-lg-4 {
                margin-left: 0;
                /* Remove additional left margin */
                min-width: 100%;
                /* Allow columns to fit the full width */
                margin-bottom: 15px;
                /* Add spacing between rows */
            }
        }

/* Responsive adjustments for mobile screens (768px and below) */
        @media (max-width: 768px) {
            .row {
                display: block;
                /* Stack items vertically */
            }

.col-lg-4 {
                margin-left: 0;
                min-width: 100%;
                /* Full width for smaller screens */
            }
        }

.text-primary {
            color: #000000 !important;
        }
        .col-lg-4 {
            min-width: 95%;
        }
    </style>
</head>

<body class="sb-nav-fixed">
    <?php include "navbar.php"; ?>
    <?php include "../assets/php/go_backbar.php"; ?>
    <div id="layoutSidenav">
        <?php include 'sidebar.php'; ?>
        <div id="layoutSidenav_content">
            <main>
                <div id="panelContent" class="container-fluid">
                    <div class="container mt-5">
                        <ol class="breadcrumb my-3">
                            <li class="breadcrumb-item w-100 d-flex flex-column flex-sm-row justify-content-between align-items-center">
                                <h4 class="mt-1 text-center">Email Open Details</h4>
                                <div class="d-flex flex-column flex-sm-row mt-2 mt-sm-0">
                                    <a href="download_open.php" class="btn btn-outline-success mb-2 mb-sm-0">
                                        <i class="fas fa-paper-plane"></i> Download Email Opens
                                    </a>
                                </div>
                            </li>
                        </ol>

<div class="row">
                            <?php
                            // Fetch and display data from database
                            if ($result && mysqli_num_rows($result) > 0) {
                                while ($row = mysqli_fetch_assoc($result)) {
                                    $campaignName = htmlspecialchars($row['campaign_name']);
                                    $emails = explode(', ', $row['emails']);
                            ?>
                                    <div class="col-lg-4 col-md-6 mb-4">
                                        <table class="email-table">
                                            <thead>
                                                <tr>
                                                    <th class="email-table-header">Campaign Name - <?= $campaignName ?></th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <tr>
                                                    <td class="email-table-body">
                                                        <table class="inner-email-table">
                                                            <thead>
                                                                <tr>
                                                                    <th><i class="bi bi-envelope-fill"></i> Email Addresses</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody>
                                                                <? foreach ($emails as $email) { ?>
                                                                    <tr>
                                                                        <td><?= htmlspecialchars($email) ?></td>
                                                                    </tr>
                                                                <? } ?>
                                                            </tbody>
                                                        </table>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                    </div>

<?  }
                            } else { ?>
                                <div class="no-data">No delivered emails found.</div>
                            <? }
                            mysqli_close($conn);
                            ?>
                        </div>
                    </div>
                </div>
            </main>
        </div>
    </div>

<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@1.16.1/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>

</html>