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

<?php
include "../config.php";
require_once 'PHPExcel.php';
$approved = $_GET['approved'];
if (isset($approved)) {
    $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;
    if($approved == ''){
        $all_records = true;
    }else{
        $all_records = false;
    }
    $customTitle = array('Sl No','Category','Post','Position','Name','Club Name','Zone No','Region No','Mobile No','Email Id','Reason','Updated Date & Time');
    if ($approved === '') {
     $all_records = true;
     $customTitle[] = 'Accessed';
     $customTitle[] = 'Accepted';
    } else {
     $all_records = false;
    }
 
    $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]);
    if($all_records){
    $objPHPExcel->getActiveSheet()->SetCellValue('M'.$rowCount, $customTitle[12]);
    $objPHPExcel->getActiveSheet()->SetCellValue('N'.$rowCount, $customTitle[13]);
    }

$rowCount++;
    $approved = isset($_GET['approved']) ? $_GET['approved'] : '';
    
    if ($approved === '' || !is_numeric($approved)) {
        $sql = "SELECT * FROM district_posting WHERE delete_status = 0 ORDER BY added_date DESC";
    } else {
        $approved = intval($approved); 
        $sql = "SELECT * FROM district_posting WHERE delete_status = 0 AND approved = $approved ORDER BY added_date DESC";
    }

$res = mysqli_query($con, $sql);

$i = 0;
    while ($row = mysqli_fetch_array($res)) {

switch ($row['approved']) {
            case 1:
                $approved_value = "Accepted";
                break;
            case 2:
                $approved_value = "Declined";
                break;
            case 0:
                $approved_value = "Pending";
                break;
        }
        switch ($row['accessed']) {
            case 1:
                $accessed_value = "Accessed";
                break;
            case 0:
                $accessed_value = "Not Accessed";
                break;
        }

$i++;
        $objPHPExcel->getActiveSheet()->SetCellValue('A'.$rowCount, "$i");
        $objPHPExcel->getActiveSheet()->setCellValue('B' . $rowCount, $row['category']);
        $objPHPExcel->getActiveSheet()->setCellValue('C' . $rowCount, $row['post']);
        $objPHPExcel->getActiveSheet()->setCellValue('D' . $rowCount, $row['position']);
        $objPHPExcel->getActiveSheet()->setCellValue('E' . $rowCount, $row['name']);
        $objPHPExcel->getActiveSheet()->setCellValue('F' . $rowCount, $row['club_name']);
        $objPHPExcel->getActiveSheet()->setCellValue('G' . $rowCount, "Zone ".$row['zone_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('H' . $rowCount, "Region ".$row['region_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('I' . $rowCount, $row['mobile_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('J' . $rowCount, $row['email_id']);
        $objPHPExcel->getActiveSheet()->setCellValue('K' . $rowCount, $row['reason']);
        $objPHPExcel->getActiveSheet()->setCellValue('L' . $rowCount, date('d-m-y H:i:s', strtotime($row['update_date'])));
        if($all_records){
        $objPHPExcel->getActiveSheet()->setCellValue('M' . $rowCount, "$accessed_value");
        $objPHPExcel->getActiveSheet()->setCellValue('N' . $rowCount, "$approved_value");
        }

$rowCount++;
    }
    if($approved == 1){
        $excel_name = "AcceptedList";
    }elseif($approved == 2){
        $excel_name = "DeclinedList";
    }elseif($approved == 0){
        $excel_name = "PendingList";
    }else{
        $excel_name = "DistrictPostingList";
    }

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment; filename="' . $excel_name . '.xlsx"');
    header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('php://output');
    exit;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ExportDistrictPosting.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation