Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rotary2982.org/public_html/conf2026/admin

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: excelreport.php

<?php
require_once 'PHPExcel.php'; // Make sure PHPExcel is installed
include('../config.php');

$categories = [
    1 => 'Combo',
];

// Create new PHPExcel object
$excel = new PHPExcel();
$excel->setActiveSheetIndex(0);
$sheet = $excel->getActiveSheet();
$sheet->setTitle('Club Combo Report');

// Header row
$header = [
    '#', 'Zone ID', 'Club Name', 'Tot.Mem', 'Reg.Mem', 'Combo', 'Spouse', 'Annet', 'Guest', 'Rotaractor'
];
$col = 0;
foreach ($header as $h) {
    $sheet->setCellValueByColumnAndRow($col++, 1, $h);
}

// Get selected clubs
if (isset($_GET['clubs']) && !empty($_GET['clubs'])) {
    $club_ids = array_map('intval', explode(',', $_GET['clubs']));
    $clubs_query = count($club_ids) > 0
        ? "SELECT * FROM club WHERE delete_status=0 AND club_id IN (".implode(',', $club_ids).") ORDER BY club_id ASC"
        : "SELECT * FROM club WHERE delete_status=0 ORDER BY club_id ASC";
} else {
    $clubs_query = "SELECT * FROM club WHERE delete_status=0 ORDER BY zone_id, club_id ASC";
}

$clubs = mysqli_query($con, $clubs_query);
if (!$clubs) die("SQL Error: " . mysqli_error($con) . "<br>Query: " . $clubs_query);

// Totals
$total_total_members_static = 0;
$total_total_members = 0;
$total_combo = 0;
$total_spouse = 0;
$total_annet = 0;
$total_guest = 0;
$total_rotaractor = 0;

$row_num = 2;
$sl = 1;
while ($club = mysqli_fetch_assoc($clubs)) {
    $club_id = $club['club_id'];
    $club_name = $club['club_name'];
    $zone_id = $club['zone_id'];
    $total_members_static = $club['total_members'];

$club_condition = ($club_id == 93) ? "r.club_id IN (0,93)" : "r.club_id = $club_id";

// Stats
    $stats_sql = "
        SELECT 
            COUNT(DISTINCT r.registration_id) AS total_members,
            COUNT(CASE WHEN rd.member_type = 3 THEN 1 END) AS spouse,
            COUNT(CASE WHEN rd.member_type = 4 THEN 1 END) AS annet,
            COUNT(CASE WHEN rd.member_type = 6 THEN 1 END) AS guest,
            COUNT(CASE WHEN rd.member_type = 2 THEN 1 END) AS rotaractor
        FROM registration AS r
        LEFT JOIN registration_details AS rd ON r.registration_id = rd.ref_registration_id
        WHERE $club_condition
            AND r.approve_status = 1 
            AND r.delete_status = 0 
            AND r.upgrade_id = 0
    ";
    $stats_query = mysqli_query($con, $stats_sql);
    $stats = mysqli_fetch_assoc($stats_query);

// Combo count only
    $combo_sql = "
        SELECT COUNT(*) AS cnt
        FROM registration AS r
        WHERE $club_condition
            AND r.approve_status = 1
            AND r.delete_status = 0
            AND r.upgrade_id = 0
            AND r.registration_type_id = 1
    ";
    $combo_query = mysqli_query($con, $combo_sql);
    $combo_row = mysqli_fetch_assoc($combo_query);
    $combo_count = intval($combo_row['cnt']);

// Totals
    $total_total_members_static += $total_members_static;
    $total_total_members += $stats['total_members'];
    $total_combo += $combo_count;
    $total_spouse += $stats['spouse'];
    $total_annet += $stats['annet'];
    $total_guest += $stats['guest'];
    $total_rotaractor += $stats['rotaractor'];

// Write row to Excel
    $sheet->setCellValueByColumnAndRow(0, $row_num, $sl++);
    $sheet->setCellValueByColumnAndRow(1, $row_num, "Zone" . $zone_id);
    $sheet->setCellValueByColumnAndRow(2, $row_num, $club_name);
    $sheet->setCellValueByColumnAndRow(3, $row_num, $total_members_static);
    $sheet->setCellValueByColumnAndRow(4, $row_num, $stats['total_members']);
    $sheet->setCellValueByColumnAndRow(5, $row_num, $combo_count);
    $sheet->setCellValueByColumnAndRow(6, $row_num, $stats['spouse']);
    $sheet->setCellValueByColumnAndRow(7, $row_num, $stats['annet']);
    $sheet->setCellValueByColumnAndRow(8, $row_num, $stats['guest']);
    $sheet->setCellValueByColumnAndRow(9, $row_num, $stats['rotaractor']);

$row_num++;
}

// Totals row
$sheet->setCellValueByColumnAndRow(0, $row_num, 'Total');
$sheet->mergeCellsByColumnAndRow(0, $row_num, 2, $row_num);
$sheet->setCellValueByColumnAndRow(3, $row_num, $total_total_members_static);
$sheet->setCellValueByColumnAndRow(4, $row_num, $total_total_members);
$sheet->setCellValueByColumnAndRow(5, $row_num, $total_combo);
$sheet->setCellValueByColumnAndRow(6, $row_num, $total_spouse);
$sheet->setCellValueByColumnAndRow(7, $row_num, $total_annet);
$sheet->setCellValueByColumnAndRow(8, $row_num, $total_guest);
$sheet->setCellValueByColumnAndRow(9, $row_num, $total_rotaractor);

// Auto size columns
foreach(range('A','J') as $col) {
    $sheet->getColumnDimension($col)->setAutoSize(true);
}

// Output to browser
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Club_Combo_Report.xls"');
header('Cache-Control: max-age=0');

$writer = PHPExcel_IOFactory::createWriter($excel, 'Excel5');
$writer->save('php://output');
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: excelreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation