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/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: generate_pdf.php

<?php
// Include the FPDF library
require('fpdf/fpdf.php');
include('../config.php');
$club_ids_raw = isset($_GET['club_id']) ? $_GET['club_id'] : '';
$club_parts = explode('_', $club_ids_raw);
$club_id = isset($club_parts[0]) ? intval($club_parts[0]) : null;
$club_id1 = isset($club_parts[1]) ? intval($club_parts[1]) : null;

// echo $club_id ."<br>". $club_id1;

// SQL query to get the grouped data
// $sql = "SELECT r.*, rt.registration_type_details,c.club_name, 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 r.delete_status = 0 AND (r.club_id = $club_id OR r.club_id = $club_id1) AND r.approve_status = 1 AND r.upgrade_id = 0
//         GROUP BY r.registration_type_id 
//         ORDER BY r.registration_type_id";

$sql = "SELECT r.*, rt.registration_type_details, c.club_name, 
               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 r.delete_status = 0 
          AND r.approve_status = 1 
          AND r.upgrade_id = 0";

if (!is_null($club_id1)) {
    $sql .= " AND r.club_id IN ($club_id, $club_id1)";
} else {
    $sql .= " AND r.club_id = $club_id";
}
// echo $sql; die();
$sql .= " GROUP BY r.registration_type_id 
          ORDER BY r.registration_type_id";

// echo $sql; die();
// 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/alagoviyam.png', 90, 8, 40);
$pdf->Image('assets/images/unique.png', 170, 8, 33);
$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) {
    $clubPrinted = false;
    // Loop through each registration type
    while ($typeRow = mysqli_fetch_assoc($res)) {
        $registration_type_details = $typeRow['registration_type_details'];

$i = 1;
        
        // $sql_detail = "SELECT r.*, m.rotarian_name, r.payment_mode 
        //                FROM registration AS r
        //                LEFT JOIN member AS m ON m.member_id = r.member_id
        //                WHERE r.delete_status = 0 AND (r.club_id = $club_id OR r.club_id = $club_id1) AND r.approve_status = 1 AND r.delete_status = 0 AND r.upgrade_id = 0
        //                AND r.registration_type_id = " . $typeRow['registration_type_id'] . " 
        //                ORDER BY r.payment_mode";

$sql_detail = "SELECT r.*, m.rotarian_name, r.payment_mode 
               FROM registration AS r
               LEFT JOIN member AS m ON m.member_id = r.member_id
               WHERE r.delete_status = 0 
                 AND r.approve_status = 1 
                 AND r.upgrade_id = 0";

if (!is_null($club_id1)) {
    $sql_detail .= " AND r.club_id IN ($club_id, $club_id1)";
} else {
    $sql_detail .= " AND r.club_id = $club_id";
}

$sql_detail .= " AND r.registration_type_id = " . intval($typeRow['registration_type_id']) . " 
                 ORDER BY r.payment_mode";

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

if (!$clubPrinted) {
		$pdf->Ln();
        $pdf->SetFont('Arial', 'B', 12);
        $pdf->Cell(0, 5, "Club: " . $typeRow['club_name'], 0, 1, 'L');
        $clubPrinted = true; 
    }
     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(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['reg_no'], 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, $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, "Club Total Registrations : " . $overall_total_count . " | Club Total Amount : " . $formatted_amount, 0, 1, 'L');

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

$sql_detail = "SELECT r.*,rd.*,r.registration_amount,r.category_id FROM registration_details as rd 
               LEFT JOIN registration as r ON r.registration_id = rd.ref_registration_id 
               WHERE r.upgrade_id = 0 AND r.delete_status = 0 AND r.approve_status = 1";

if (!is_null($club_id1)) {
    $sql_detail .= " AND r.club_id IN ($club_id, $club_id1)";
} else {
    $sql_detail .= " AND r.club_id = $club_id";
}
// echo $sql_detail; die;  
$res_details1 = mysqli_query($con, $sql_detail);

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

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

$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;  // To keep track of total amount
    $total_count = 0;   // To keep track of the total count of members
    
    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);
        
        if (($member['member_type'] == 3 && $member['category_id'] == 4) || ($member['member_type'] == 4 && $member['category_id'] == 5) || $member['member_type'] == 6 || $member['member_type'] == 2) {
            $pdf->Cell(30, 7, $mode, 1);
            $registration_amount = number_format($member['registration_amount'], 2, '.', ',');
            $pdf->Cell(20, 7, $registration_amount, 1, 0, 'R');
            $total_amount += $member['registration_amount'];  // Add to total amount
            $total_count++;  // Increment total count
        }else{
            $pdf->Cell(30, 7, $mode, 1);
            $pdf->Cell(20, 7, '-', 1 , 0 , 'C');
            $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 . " | Total Amount: " . $formatted_total_amount, 0, 1, 'L');
        $pdf->Ln();
    }

$con->close();

$pdf->Output();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation