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.11 TB

🔧 Quick Actions

✏️ Editing: generate_club_consolidate_pdf.php

<?php
require('fpdf/fpdf.php');
include('../config.php');

class PDF extends FPDF {
    function Header() {
        $this->Image('assets/images/rotary-logo.png', 20, 15, 40);
        $this->Image('assets/images/senthuram.png', 120, 8, 50);
        $this->Image('assets/images/unique.png', 230, 15, 40);
        $this->Ln(25);
        $this->SetFont('Arial','B',14);
        $this->Cell(0,10,'Club Consolidated Registration Report',0,1,'C');
        $this->Ln(2);

$this->SetFont('Arial','B',10);
        $this->SetFillColor(200,200,200);
        $this->Cell(6,8,'#',1,0,'C',true);
        $this->Cell(50,8,'Club Name',1,0,'C',true);
        $this->Cell(17,8,'Tot.Mem',1,0,'C',true);
        $this->Cell(17,8,'Reg.Mem',1,0,'C',true);

$categories = ['Combo','Conf','Sem','FP1','FP2','FP3','3FemRotr'];
        foreach ($categories as $cat) $this->Cell(18,8,$cat,1,0,'C',true);

$this->Cell(15,8,'Spouse',1,0,'C',true);
        $this->Cell(15,8,'Annet',1,0,'C',true);
        $this->Cell(15,8,'Guest',1,0,'C',true);
        $this->Cell(19,8,'Rotaractor',1,0,'C',true);
        $this->Ln();
    }

function Footer() {
        $this->SetY(-12);
        $this->SetFont('Arial','I',8);
        $this->Cell(0,10,'Page '.$this->PageNo(),0,0,'C');
    }
}

$pdf = new PDF('L','mm','A4'); 
$pdf->AddPage();
$pdf->SetFont('Arial','',9);

$categories = [
    1 => 'Combo',
    2 => 'Conf',
    3 => 'Sem',
    7 => 'FP1',
    8 => 'FP2',
    9 => 'FP3',
    10 => '3FemRotr'
];

// 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 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_reg_counts = array_fill_keys(array_keys($categories), 0);
$total_spouse = 0;
$total_annet = 0;
$total_guest = 0;
$total_rotaractor = 0;

$sl = 1;
while ($club = mysqli_fetch_assoc($clubs)) {
    $club_id = $club['club_id'];
    $club_name = $club['club_name'];
    $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);
    if (!$stats_query) die("SQL Error: " . mysqli_error($con) . "<br>Query: " . $stats_sql);
    $stats = mysqli_fetch_assoc($stats_query);

// Registration counts
    $reg_counts = array_fill_keys(array_keys($categories), 0);
    $reg_sql = "
        SELECT r.registration_type_id, 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 IN (" . implode(',', array_keys($categories)) . ")
        GROUP BY r.registration_type_id
    ";
    $reg_query = mysqli_query($con, $reg_sql);
    if (!$reg_query) die("SQL Error: " . mysqli_error($con) . "<br>Query: " . $reg_sql);

while ($row = mysqli_fetch_assoc($reg_query)) {
        $reg_counts[intval($row['registration_type_id'])] = intval($row['cnt']);
    }

$reg_counts[3] += $reg_counts[1]; // Seminar includes Combo

// Totals
    $total_total_members_static += $total_members_static;
    $total_total_members += $stats['total_members'];
    foreach ($categories as $cat_id => $cat_name) {
        $total_reg_counts[$cat_id] += $reg_counts[$cat_id];
    }
    $total_spouse += $stats['spouse'];
    $total_annet += $stats['annet'];
    $total_guest += $stats['guest'];
    $total_rotaractor += $stats['rotaractor'];

// PDF row
    $pdf->Cell(6,8,$sl++,1,0,'C');
    $pdf->Cell(50,8,$club_name,1);
    $pdf->Cell(17,8,$total_members_static,1,0,'C');
    $pdf->Cell(17,8,$stats['total_members'],1,0,'C');
    foreach ($categories as $cat_id => $cat_name) {
        $pdf->Cell(18,8,$reg_counts[$cat_id],1,0,'C');
    }
    $pdf->Cell(15,8,$stats['spouse'],1,0,'C');
    $pdf->Cell(15,8,$stats['annet'],1,0,'C');
    $pdf->Cell(15,8,$stats['guest'],1,0,'C');
    $pdf->Cell(19,8,$stats['rotaractor'],1,0,'C');
    $pdf->Ln();
}

// Totals row
$pdf->SetFont('Arial','B',9);
$pdf->Cell(56,8,'Total',1,0,'C');
$pdf->Cell(17,8,$total_total_members_static,1,0,'C');
$pdf->Cell(17,8,$total_total_members,1,0,'C');
foreach ($categories as $cat_id => $cat_name) {
    $pdf->Cell(18,8,$total_reg_counts[$cat_id],1,0,'C');
}
$pdf->Cell(15,8,$total_spouse,1,0,'C');
$pdf->Cell(15,8,$total_annet,1,0,'C');
$pdf->Cell(15,8,$total_guest,1,0,'C');
$pdf->Cell(19,8,$total_rotaractor,1,0,'C');

$pdf->Output('I','Club_Consolidate_Reg_Report.pdf');
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_club_consolidate_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation