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: export_club.php

<?php
include "../config.php";
require_once 'PHPExcel.php';
if (isset($_GET['club_id'])) {
    $club_id = $_GET['club_id'];
    $objPHPExcel = new PHPExcel();
    $objPHPExcel->getActiveSheet()->getStyle("A1:AB1")->applyFromArray(array(
        "font" => array(
            "bold" => true,
            "color" => array("rgb" => "405189"),
            "size" => 10,
            "name" => "Arial"
        )
    ));

$objPHPExcel->setActiveSheetIndex(0);
    $rowCount = 1;
    $customTitle = array('Sl No', 'Reg No','Reg Date','Category','Registeration Type','Name','Phone Number','Food','Tshirt Size','Fellowship',
    'Payment Mode','Amount'); // Adjust according to your columns
    $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, $customTitle[0]);
    $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $customTitle[1]);
    $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, $customTitle[2]);
    $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $customTitle[3]);
    $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $customTitle[4]);
    $objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $customTitle[5]);
    $objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, $customTitle[6]);
    $objPHPExcel->getActiveSheet()->SetCellValue('H'.$rowCount, $customTitle[7]);
    $objPHPExcel->getActiveSheet()->SetCellValue('I'.$rowCount, $customTitle[8]);
    $objPHPExcel->getActiveSheet()->SetCellValue('J'.$rowCount, $customTitle[9]);
    $objPHPExcel->getActiveSheet()->SetCellValue('K'.$rowCount, $customTitle[10]);
    $objPHPExcel->getActiveSheet()->SetCellValue('L'.$rowCount, $customTitle[11]);

$rowCount++;
    // $sql = "SELECT r.*, rt.registration_type_details, m.rotarian_name ,c.club_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 c.club_id = r.club_id
    // LEFT JOIN member AS m ON m.member_id = r.member_id 
    // WHERE r.delete_status = 0 AND r.upgrade_id = 0 AND r.approve_status = 1";

// $sql="SELECT r.phone_number as phone, r.reg_no, r.category_id, rt.registration_type_details, 
    // c.club_name as club, r.payment_mode, r.registration_amount, r.registration_date, rd.name, rd.email_id, 
    // rd.food, rd.age, rd.gender, rd.t_shirt_and_shirt_size, rd.fellow_ship FROM registration_details rd 
    // JOIN registration r ON rd.ref_registration_id = r.registration_id
    // LEFT JOIN club AS c ON c.club_id = r.club_id
    // LEFT JOIN member AS m ON m.member_id = r.member_id 
    // LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id
    //  WHERE rd.member_type != 1 AND r.delete_status = 0 AND 
    // rd.delete_status = 0 AND r.approve_status = 1 AND r.upgrade_id = 0";

$sql="SELECT 
    r.phone_number AS phone,
    r.category_id,
    rt.registration_type_details,
    c.club_name AS club,
    r.payment_mode,
    r.registration_amount,
    r.registration_date,
    r.paid_to_member_id,
    r.tracking_id,
    r.bank_ref,
    r.registration_id,
    rd.reg_no,
    rd.name,
    rd.email_id,
    rd.food,
    rd.age,
    rd.gender,
    rd.t_shirt_and_shirt_size,
    rd.fellow_ship,
    rd.member_type,
    rd.group_count,
    m.rotarian_name
FROM registration_details rd
JOIN registration r ON rd.ref_registration_id = r.registration_id
LEFT JOIN club c ON c.club_id = r.club_id
LEFT JOIN member m ON m.member_id = r.member_id
LEFT JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id
WHERE r.delete_status = 0
  AND rd.delete_status = 0
  AND r.approve_status = 1
  AND r.upgrade_id = 0
  AND r.club_id = $club_id
GROUP BY
    CASE WHEN rd.member_type = 1 THEN r.phone_number ELSE rd.registration_details_id END ORDER BY r.registration_date ASC;
";

// echo $sql; die;
    $res = mysqli_query($con, $sql);
    $i = 0;
    while ($row = mysqli_fetch_array($res)) {
        $i++;
        $club_name = $row['club'];
        $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'];
        }
$food = ($row['food'] == 1) ? 'Veg' : (($row['food'] == 2) ? 'Non-Veg' : '');
$fellowship = ($row['fellow_ship'] == 1) ? 'Yes' : (($row['fellow_ship'] == 2) ? 'No' : '');

if($row['group_count']== 1 || $row['category_id']== 5){
$reg_amt = number_format($row['registration_amount']);
}else{
    $reg_amt = '';
}

$flag = false; 
    if ($row['group_count'] == 1 || $row['category_id'] == 5) {
        if ($row['category_id'] == 5) {
            if (!$flag) {
                $reg_amt = number_format($row['registration_amount']);
                $flag = true; 
            } else {
                $reg_amt = ''; 
            }
        } else {
            $reg_amt = number_format($row['registration_amount']);
        }
    } else {
        $reg_amt = '';
    }

switch ($row['payment_mode']) {
              case 1:
                $payment_mode = 'Cash';
                break;
              case 2:
                $payment_mode = 'UPI';
                break;
              case 3:
                $payment_mode = 'CC Avenue';
                break;
              case 4:
                $payment_mode = 'POS';
                break;
              default:
                //code block
            }

$categoryList = array('Rotarian','Rotarian','Rotaract','Spouse / Partner','Annet','Others','Guest'); 
        $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, "$i");
        $objPHPExcel->getActiveSheet()->SetCellValue('B'.$rowCount, $row['reg_no']);
        $objPHPExcel->getActiveSheet()->SetCellValue('C'.$rowCount, date("d-m-Y", strtotime($row['registration_date'])));
        $objPHPExcel->getActiveSheet()->SetCellValue('D'.$rowCount, $categoryList[$row['member_type']]);
        $objPHPExcel->getActiveSheet()->SetCellValue('E'.$rowCount, $row['registration_type_details']);
        $objPHPExcel->getActiveSheet()->SetCellValue('F'.$rowCount, $row['name']);
        $objPHPExcel->getActiveSheet()->SetCellValue('G'.$rowCount, $row['phone']);       
        $objPHPExcel->getActiveSheet()->SetCellValue('H' . $rowCount, $food);
        $objPHPExcel->getActiveSheet()->SetCellValue('I'.$rowCount, $row['t_shirt_and_shirt_size']);      
        $objPHPExcel->getActiveSheet()->SetCellValue('J' . $rowCount, $fellowship);
        $objPHPExcel->getActiveSheet()->SetCellValue('K'.$rowCount, $payment_mode);
        $objPHPExcel->getActiveSheet()->setCellValue('L'.$rowCount, $reg_amt);
        $rowCount++;
    }
    $club = str_replace([' ','(',')','-'],['_','','',''], $club_name);
    // Set the headers for the Excel file
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    // header('Content-Disposition: attachment;filename="ConferenceRegistration.xlsx"');
header('Content-Disposition: attachment; filename="'. $club . date('d-m-Y_H-i-s') . '.xlsx"');

header('Cache-Control: max-age=0');

// Write the PHPExcel object to a file
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('php://output');
    exit;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_club.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation