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

🔧 Quick Actions

✏️ Editing: generate_cash_reg_pdf.php

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

$member_id = $_SESSION['member_id'];
$sql_member = "select rotarian_name from admin where member_id = $member_id ";
$query_member = mysqli_query($con, $sql_member);
                                                        $row_member= mysqli_fetch_assoc($query_member);
                                                        $member_name= $row_member['rotarian_name']??'0';

// SQL query to get the grouped data
$sql_grouped = "SELECT r.*, rt.registration_type_details, 
                       COUNT(r.registration_id) AS total_members, 
                       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
                WHERE r.paid_to_member_id = $member_id
                GROUP BY r.registration_type_id
                ORDER BY rt.registration_type_details";

$res_grouped = mysqli_query($con, $sql_grouped);

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

// Header
$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');

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

// Initialize overall totals
$overall_total_count = 0;
$overall_total_amount = 0;

// Fetch and output data for each registration type
if(mysqli_num_rows($res_grouped) > 0) {
    while ($row_grouped = mysqli_fetch_assoc($res_grouped)) {
        $i = 1;
       $sql = "select r.*,c.club_name as c_name ,rt.registration_type_details,m.rotarian_name from registration as r 
       left join registration_type as rt on r.registration_type_id = rt.registration_type_id 
  LEFT JOIN club AS c ON r.club_id =  c.club_id
       left join member as m on m.member_id = r.member_id  where r.paid_to_member_id = $member_id && r.registration_type_id = " . $row_grouped['registration_type_id'] . "  order by r.added_date DESC";
       // echo $sql;

// Execute the query
$res = mysqli_query($con, $sql);
        $pdf->Cell(0, 10, "Registration Type: " . $row_grouped['registration_type_details'], 0, 1, 'L');
        $pdf->Cell(0, 10, "AG Name: " . $member_name, 0, 1, 'L');

$pdf->Cell(5, 10, 'SL', 1);
        $pdf->Cell(15, 10, 'Reg No', 1);
        $pdf->Cell(20, 10, 'Reg Date', 1);
        $pdf->Cell(40, 10, 'Name', 1);
        $pdf->Cell(22, 10, 'Phone', 1);
        // $pdf->Cell(50, 10, 'Reg Type', 1);
        $pdf->Cell(35, 10, 'Club Name', 1);
        $pdf->Cell(20, 10, 'Aprv Date', 1);
        $pdf->Cell(25, 10, 'Aprv By', 1);
        $pdf->Cell(13, 10, 'Amt', 1);
        $pdf->Ln();

// Loop through individual registrations for this type
        while ($row = mysqli_fetch_assoc($res)) {

if ($row['payment_mode'] == 1) {
                $mode = "Cash";
            } elseif ($row['payment_mode'] == 2) {
                $mode = "Online Direct";
            } elseif ($row['payment_mode'] == 3) {
                $mode = "Payment Gateway";
            }
                                    $name = $row['rotarian_name']; 
                                    $registration_id=$row['registration_id'];

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'];
                                    }

// Output the individual registration data
            $pdf->SetFont('Arial', '', 8);
            $pdf->Cell(5, 10, $i++, 1); 
            $pdf->Cell(15, 10, $row['reg_no'], 1); 
            $pdf->Cell(20, 10, $row['registration_date'], 1); 
            $pdf->Cell(40, 10, $name, 1);  
            $pdf->Cell(22, 10, $row['phone_number'], 1);  
            // $apr_by = $row_grouped['approved_by'];

// $pdf->Cell(50, 10, $row_grouped['registration_type_details'], 1);
            
            $pdf->Cell(35, 10, $row['c_name'], 1);
            $pdf->Cell(20, 10, $row_grouped['approved_date'], 1);
            $apr_by = $row_grouped['approved_by'];

$sql_admin = "SELECT * FROM admin as a left join member as m on a.member_id = m.member_id WHERE a.member_id = '$apr_by'";
                                                        $query_admin = mysqli_query($con, $sql_admin);
                                                        $row_admin= mysqli_fetch_assoc($query_admin);
                                                        $approve_by= $row_admin['rotarian_name']??'0';
                                                        // echo $approve_by;
            $pdf->Cell(25, 10,  $approve_by, 1);
            // $pdf->Cell(30, 10, $row_grouped['rotarian_name'], 1);
            // $pdf->Cell(30, 10, $mode, 1);
            $pdf->Cell(13, 10, $row['registration_amount'], 1);  
            $pdf->Ln(); // Line break after each row

// Accumulate the overall totals
            $overall_total_count++;
            $overall_total_amount += $row['registration_amount'];
        }

$pdf->SetFont('Arial', 'B', 10);
        $pdf->Cell(0, 10, "Total Registrations: " . $row_grouped['total_members'] . " | Total Amount: " . $row_grouped['total_amount'], 0, 1, 'L');
        $pdf->Ln();
    }
} else {
    // If no rows are found, display a message in the PDF
    $pdf->Cell(0, 10, 'No records found', 0, 1);
}

// Add overall totals at the end of the report
$pdf->SetFont('Arial', 'B', 12);
$pdf->Cell(0, 10, "Total Registrations : " .' '. $overall_total_count." |  Total Amount :  ".$overall_total_amount, 0, 1, 'L');
// $pdf->Cell(0, 10, "Overall Total Amount: " . $overall_total_amount, 0, 1, 'R');

$con->close();

// Output the PDF to the browser
$pdf->Output();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: generate_cash_reg_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation