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_zone_pdf.php

<?php
// Include the FPDF library
require('fpdf/fpdf.php');
include('../config.php');
$zone = $_GET['zone'];

// SQL query to get the grouped data
$sql = "SELECT r.*,c.club_name,c.zone_id, rt.registration_type_details, SUM(r.registration_amount) AS total_amount, COUNT(r.registration_type_id) AS total_count
        FROM registration AS r
        LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id
        LEFT JOIN member AS m ON m.member_id = r.member_id
        LEFT JOIN club AS c ON r.club_id =  c.club_id
        WHERE  c.zone_id = $zone AND r.approve_status = 1 && r.delete_status = 0 AND r.upgrade_id = 0
        GROUP BY r.registration_type_id 
        ORDER BY r.registration_type_id";

// Execute the query
$res = mysqli_query($con, $sql);

// Create PDF document
$pdf = new FPDF();
$pdf->AddPage();
$pdf->SetMargins(8, 8);
$pdf->SetDrawColor(231, 231, 231);

$pdf->Image('assets/images/rotary-logo.png', 10, 8, 33);
$pdf->Image('assets/images/senthuram.png', 90, 10, 40);
$pdf->Image('assets/images/unique.png', 170, 8, 23);
$pdf->SetFont('Arial', 'B', 15);
$pdf->Cell(0, 15, '', 0, 1, 'C');

$pdf->SetFont('Arial', 'B', 10);

$overall_total_count = 0;
$overall_total_amount = 0;

if (mysqli_num_rows($res) > 0) {
    $typeRow1 = mysqli_fetch_assoc($res);
    $zone_no = $typeRow1['zone_id'];
    $pdf->Cell(0, 5, "ZONE: " . $zone_no, 0, 1, 'L');
mysqli_data_seek($res, 0);

$clubPrinted = false;

while ($typeRow = mysqli_fetch_assoc($res)) {
      
        $registration_type_details = $typeRow['registration_type_details'];

$i = 1;
        // echo $typeRow['registration_type_id'];
        $sql_detail = "SELECT r.*, m.rotarian_name, r.payment_mode,c.zone_id,c.club_name,rd.name, rd.reg_no AS registered_id 
                       FROM registration AS r
                       LEFT JOIN member AS m ON m.member_id = r.member_id
                       LEFT JOIN registration_details AS rd ON rd.ref_registration_id = r.registration_id
                       LEFT JOIN club AS c ON r.club_id =  c.club_id
                       WHERE   c.zone_id = $zone AND r.approve_status = 1 && r.delete_status = 0
                       AND r.registration_type_id = " . $typeRow['registration_type_id'] . " 
                       GROUP BY rd.ref_registration_id
                       ORDER BY c.club_name , r.payment_mode";

$res_details = mysqli_query($con, $sql_detail);

if($registration_type_details != ''){

$pdf->Cell(0, 10, "Registration Type: " . $typeRow['registration_type_details'], 0, 1, 'L');

$pdf->SetFont('Arial', 'B', 10);
        $pdf->Cell(15, 7, 'S.No', 1);
        $pdf->Cell(20, 7, 'Reg No', 1);
        $pdf->Cell(25, 7, 'Reg Date', 1);
        $pdf->Cell(48, 7, 'Name', 1);
        $pdf->Cell(35, 7, 'Phone', 1);
        // $pdf->Cell(50, 10, 'Reg Type', 1);
        $pdf->Cell(30, 7, 'Mode', 1);
        $pdf->Cell(20,7,'Amt',1,0,'R');
        $pdf->Ln();

while ($row = mysqli_fetch_assoc($res_details)) {
            $reg_id = $row['registration_id'];
            if ($row['payment_mode'] == 1) {
                $mode = "Cash";
            } elseif ($row['payment_mode'] == 2) {
                $mode = "Online Direct";
            } elseif ($row['payment_mode'] == 3) {
                $mode = "Payment Gateway";
            }
            $date = strtotime($row['registration_date']); 
            $formattedDate = date('d-m-Y', $date);
            $pdf->SetFont('Arial', '', 8);
            $pdf->Cell(15, 7, $i++, 1); 
            $pdf->Cell(20, 7, $row['registered_id'], 1); 
            $pdf->Cell(25, 7, $formattedDate, 1);
            $registration_id = $row['registration_id'];
            $name = $row['rotarian_name'];

if (empty($name)) {
            $res1 = mysqli_query($con, "SELECT name FROM registration_details WHERE ref_registration_id='$registration_id' LIMIT 1");
            $row1 = mysqli_fetch_assoc($res1);
            $name = $row1['name'];
        }
            $pdf->Cell(48, 7, $row['name'], 1);  
            $pdf->Cell(35, 7, $row['phone_number'], 1);  
            $pdf->Cell(30, 7, $mode, 1);
$registration_amount = number_format($row['registration_amount'], 2, '.', ',');

$pdf->Cell(20, 7, $registration_amount , 1,0,'R');  
            $pdf->Ln(); 
            $overall_total_count++;
            $overall_total_amount += $row['registration_amount'];
        }

$pdf->SetFont('Arial', 'B', 10);
        $pdf->Cell(0, 10, "Total Registrations: " . $typeRow['total_count'] . " | Total Amount: " . $typeRow['total_amount'], 0, 1, 'L');
        $pdf->Ln();
    }}
} else {
    $pdf->Cell(0, 10, 'No records found', 0, 1);
}
$y_position = $pdf->GetY();

$pdf->Line(10, $y_position, 200, $y_position); 
$formatted_amount = number_format($overall_total_amount, 2, '.', ','); 
$pdf->Cell(0, 10, "Zone Total Registrations : " . $overall_total_count . " | Zone Total Amount : " . $formatted_amount, 0, 1, 'L');

$pdf->Line(10, $pdf->GetY(), 200, $pdf->GetY());

$sql_detail = "SELECT r.*,rd.* FROM registration_details as rd 
               LEFT JOIN registration as r ON r.registration_id = rd.ref_registration_id 
               LEFT JOIN club AS c ON r.club_id =  c.club_id
               WHERE c.zone_id = $zone AND r.upgrade_id = 0 AND r.delete_status = 0 AND r.approve_status = 1";

$res_details1 = mysqli_query($con, $sql_detail);

$pdf->SetFont('Arial', 'B', 10);

// Define member types
$member_types = [
    3 => 'Spouse',
    4 => 'Annet',
    6 => 'Guest',
    2 => 'Rotractor'
];

$members_by_type = [];

while ($row1 = mysqli_fetch_assoc($res_details1)) {
    $member_type = $row1['member_type'];
    if (isset($member_types[$member_type])) {
        $members_by_type[$member_type][] = $row1;
    }
}

foreach ($members_by_type as $member_type => $members) {
    $member_type_name = $member_types[$member_type];

$pdf->Ln();
    $pdf->SetFont('Arial', 'B', 10);
    $pdf->Cell(0, 10, 'Member Type: ' . $member_type_name, 0, 1, 'L');
    $pdf->SetFont('Arial', 'B', 8);
    $pdf->Cell(15, 7, 'S.No', 1);
    $pdf->Cell(20, 7, 'Reg No', 1);
    $pdf->Cell(25, 7, 'Reg Date', 1);
    $pdf->Cell(48, 7, 'Name', 1);
    $pdf->Cell(35, 7, 'Phone', 1);
    $pdf->Cell(30, 7, 'Mode', 1);
    $pdf->Cell(20, 7, 'Amt', 1, 0, 'R');
    $pdf->Ln();

$pdf->SetFont('Arial', '', 8);
    $serial_no = 1;
    $total_amount = 0;  
    $total_count = 0;   
    
    foreach ($members as $member) {
        if ($member['payment_mode'] == 1) {
            $mode = "Cash";
        } elseif ($member['payment_mode'] == 2) {
            $mode = "Online Direct";
        } elseif ($member['payment_mode'] == 3) {
            $mode = "Payment Gateway";
        }

$pdf->Cell(15, 7, $serial_no++, 1);
        $pdf->Cell(20, 7, $member['reg_no'], 1);
        $date = strtotime($member['registration_date']);
        $formattedDate = date('d-m-Y', $date);
        $pdf->Cell(25, 7, $formattedDate, 1);
        $pdf->Cell(48, 7, $member['name'], 1);
        $pdf->Cell(35, 7, $member['phone_number'], 1);
        $pdf->Cell(30, 7, '-', 1 ,0, 'C');
        $pdf->Cell(20, 7, '-', 1 ,0, 'C');
        
        // if ($member['member_type'] == 3 || $member['member_type'] == 6) {
        //     $pdf->Cell(30, 7, $mode, 1);
        //     $registration_amount = number_format($member['registration_amount'], 2, '.', ',');
        //     // $pdf->Cell(20, 7, $registration_amount, 1, 0, 'R');
        //     $pdf->Cell(20, 7, '-', 1, 0, 'R');
        //     $total_amount += $member['registration_amount'];  // Add to total amount
        //     $total_count++;  // Increment total count
        // } elseif ($member['member_type'] == 4 && $member['age'] != 1) {
        //     $pdf->Cell(30, 7, $mode, 1);
        //     $registration_amount = number_format($member['registration_amount'], 2, '.', ',');
        //     // $pdf->Cell(20, 7, $registration_amount, 1, 0, 'R');
        //     $pdf->Cell(20, 7, '-', 1, 0, 'R');
        //     $total_amount += $member['registration_amount'];  // Add to total amount
        //     $total_count++;  // Increment total count
        // } elseif ($member['age'] == 1) {
        //     $pdf->Cell(30, 7, '-', 1 ,0, 'C');
        //     $pdf->Cell(20, 7, '-', 1 ,0, 'R');
        //     $total_count++; 
        // }

$total_count++; 
        $pdf->Ln();
    }

$formatted_total_amount = number_format($total_amount, 2, '.', ',');
 $pdf->SetFont('Arial', 'B', 10);
        $pdf->Cell(0, 10, "Total Registrations: " . $total_count, 0, 1, 'L');
        // $pdf->Cell(0, 10, "Total Registrations: " . $total_count . " | Total Amount: " . $formatted_total_amount, 0, 1, 'L');
        $pdf->Ln();
    }

$con->close();

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_zone_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation