OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
3-31-025chanakya
/
Xpress
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/31/2025 06:36:42 AM
rwxr-xr-x
📄
.browserslistrc
208 bytes
03/26/2025 04:06:47 AM
rw-r--r--
📄
.gitignore
42 bytes
03/26/2025 04:06:47 AM
rw-r--r--
📄
.htaccess
803 bytes
03/26/2025 04:06:47 AM
rw-r--r--
📄
.htaccess.swp
12 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
.travis.yml
199 bytes
03/26/2025 04:06:47 AM
rw-r--r--
📄
09-01-25navbar.php
30.59 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
15-02-25viewList.php
14.86 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
17-02-25newCompaign.php
12.43 KB
03/26/2025 04:06:47 AM
rw-r--r--
📁
NLEditor
-
03/26/2025 04:21:24 AM
rwxr-xr-x
📄
addList.php
6.06 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
adi_deliveryViewList.php
11.13 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
aditya_choose.php
6 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
aditya_choose_template.php
7.52 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
aditya_viewCampaign.php
24.73 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
arvind_choose_templates.php
10.83 KB
03/26/2025 04:06:47 AM
rw-r--r--
📁
assets
-
03/26/2025 04:20:38 AM
rwxr-xr-x
📄
back_choose_template.php
7.52 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
blacklist.php
13.06 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
bounceViewList.php
14.63 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
bounce_handler.php
5.05 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
checkNotificationTopics.php
5.11 KB
03/26/2025 04:06:47 AM
rw-r--r--
📁
check_identity
-
03/26/2025 04:16:12 AM
rwxr-xr-x
📄
checknotif.php
1020 bytes
03/26/2025 04:06:47 AM
rw-r--r--
📄
choose_template.php
6.74 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
clickViewList.php
13.01 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
click_handler.php
1.75 KB
03/26/2025 04:06:47 AM
rw-r--r--
📄
complaintsViewList.php
8.41 KB
03/26/2025 04:06:48 AM
rw-r--r--
📄
complaints_handler.php
2.89 KB
03/26/2025 04:06:48 AM
rw-r--r--
📄
composer.json
200 bytes
03/26/2025 04:06:48 AM
rw-r--r--
📄
composer.lock
39.12 KB
03/26/2025 04:06:48 AM
rw-r--r--
📄
createList.php
19.13 KB
03/26/2025 04:06:48 AM
rw-r--r--
📁
credentials
-
03/26/2025 04:16:13 AM
rwxr-xr-x
📄
csv.php
12.33 KB
03/26/2025 04:06:48 AM
rw-r--r--
📁
data
-
03/26/2025 04:21:24 AM
rwxr-xr-x
📄
db.php
991 bytes
03/26/2025 04:06:48 AM
rw-r--r--
📄
deleteCampaign.php
966 bytes
03/26/2025 04:06:48 AM
rw-r--r--
📄
deleteTemplate.php
1.55 KB
03/26/2025 04:06:48 AM
rw-r--r--
📄
delete_list.php
959 bytes
03/26/2025 04:06:48 AM
rw-r--r--
📄
delete_users.php
435 bytes
03/26/2025 04:06:48 AM
rw-r--r--
📄
deliveryViewList.php
12.9 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
delivery_handler.php
3.25 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_Complaints.php
1.16 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_bounces.php
1.18 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_clicked.php
1.23 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_delivered.php
1.12 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_open.php
1.22 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_report.php
3.33 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
download_unique_open.php
1.6 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
duplicate_campaign.php
1.67 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
edit_campaign.php
1.45 KB
03/26/2025 04:06:49 AM
rw-r--r--
📄
edit_list.php
11.69 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
feedback.php
1.71 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
fetch_template.php
493 bytes
03/26/2025 04:06:50 AM
rw-r--r--
📄
footer.php
1.35 KB
03/26/2025 04:06:50 AM
rw-r--r--
📁
grfx
-
03/26/2025 04:16:13 AM
rwxr-xr-x
📄
himanshu_index.php
6.58 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
himanshu_newCompaign.php
11.25 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
housekeeping.php
24.85 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
index.php
9.9 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
insert_list.php
2.64 KB
03/26/2025 04:06:50 AM
rw-r--r--
📁
js
-
03/26/2025 04:16:13 AM
rwxr-xr-x
📄
load.php
159 bytes
03/26/2025 04:06:50 AM
rw-r--r--
📁
log
-
03/26/2025 04:16:25 AM
rwxr-xr-x
📄
main.css
1.3 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
navbar.php
22.54 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
navbar_menu.php
1.94 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
newCompaign.php
16.25 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
obc_cards.php
7.58 KB
03/26/2025 04:06:50 AM
rw-r--r--
📄
openViewList.php
14.4 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
open_handler.php
1.75 KB
03/26/2025 04:06:51 AM
rw-r--r--
📁
process
-
03/26/2025 04:16:33 AM
rwxr-xr-x
📄
process_emails.php
12.53 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
real-recipients.csv
39.48 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
resubscribe.php
6.41 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
sample.csv
55 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
save.php
252 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
save_campaign.php
612 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
saved_content.html
6.48 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
send_email.php
987 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
send_email_campaignGraph.php
2.24 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
sendgrid.php
3.62 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
showListMembers.php
11.44 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
showcase.php
7.79 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
sidebar.php
0 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
sns_subscribe.php
5.25 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
submit_form.php
2.48 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
template_index.php
10.08 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
test-mail.csv
337 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
test.php
969 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
test_choose_template.php
6.51 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
test_process_emails.php
1.91 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
unsubscribe.php
6.87 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
upload_image.php
606 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📁
uploads
-
03/26/2025 04:16:39 AM
rwxr-xr-x
📁
vendor
-
03/26/2025 04:21:35 AM
rwxr-xr-x
📄
verify.html
486 bytes
03/26/2025 04:06:51 AM
rw-r--r--
📄
verify.php
2.54 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
verify_email.php
5.03 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
viewCampaign.php
26.94 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
viewList.php
17.65 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
xpress_handler.php
10.51 KB
03/26/2025 04:06:51 AM
rw-r--r--
📄
znewCompaign.php
10.52 KB
03/26/2025 04:06:52 AM
rw-r--r--
📄
zunsubscribe.php
5.82 KB
03/26/2025 04:06:52 AM
rw-r--r--
📄
zzindex.php
6.8 KB
03/26/2025 04:06:52 AM
rw-r--r--
📄
zzzzindex.php
6.68 KB
03/26/2025 04:06:52 AM
rw-r--r--
📄
zzzzzindex.php
55.73 KB
03/26/2025 04:06:52 AM
rw-r--r--
Editing: download_report.php
Close
<?php include 'db.php'; if (isset($_GET['type'], $_GET['campaignId'])) { $type = $_GET['type']; $campaignId = $_GET['campaignId']; // Define the query based on report type $queries = [ "deliveries" => " SELECT d.email, COUNT(*) AS count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id WHERE m.campaign_id = ? GROUP BY d.email", "bounces" => " SELECT b.email, COUNT(*) AS count FROM bounces b INNER JOIN messages m ON m.message_id = b.message_id WHERE m.campaign_id = ? GROUP BY b.email", "opens" => " SELECT o.to_email AS email, COUNT(*) AS count FROM email_opens o INNER JOIN messages m ON m.message_id = o.message_id WHERE m.campaign_id = ? GROUP BY o.to_email", "clicks" => " SELECT c.to_email AS email, COUNT(*) AS count FROM email_clicks c INNER JOIN messages m ON m.message_id = c.message_id WHERE m.campaign_id = ? GROUP BY c.to_email", "not opened" => " SELECT d.email, COUNT(*) AS not_opened_count FROM deliveries d INNER JOIN messages m ON m.message_id = d.message_id LEFT JOIN email_opens o ON o.to_email = d.email AND o.message_id = m.message_id WHERE m.campaign_id = ? AND o.to_email IS NULL GROUP BY d.email" ]; if (array_key_exists($type, $queries)) { // Prepare the query and execute $query = $queries[$type]; $stmt = $conn->prepare($query); $stmt->bind_param("i", $campaignId); $stmt->execute(); $result = $stmt->get_result(); // Set headers to download the file as an Excel file header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $type . '_report.xls"'); header('Cache-Control: max-age=0'); // Open PHP output stream $fp = fopen('php://output', 'w'); // Write the column headings in the first row fputcsv($fp, ['Email', 'Count']); // Ensure this header matches the columns // Check if there are any rows in the result and write them to Excel if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { // Use 'not_opened_count' for the 'not opened' report; otherwise, use 'count' $countColumn = ($type === 'not opened') ? 'not_opened_count' : 'count'; fputcsv($fp, [$row['email'], $row[$countColumn]]); } } else { // If no rows are returned, output an empty row fputcsv($fp, ['No data available', '']); } fclose($fp); // Close the output stream exit; } else { // Handle invalid 'type' values echo "Invalid report type."; } } ?>