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

<?php 
include "header.php";

if(isset($_GET['approve']))
{
    $answer = $_GET['password'];

if($answer == $_SESSION['APASS'])
    {
        $id = $_GET['id'];
        $approver_id = $_SESSION['AID'];
        $approver_member_id = $_SESSION["member_id"];
        $approved_date = date('Y-m-d');

$query = mysqli_query($con,"UPDATE registration SET order_status = 'Success', approve_status = 1, approved_by = '$approver_member_id', approved_date = '$approved_date' WHERE registration_id = '$id'");

if($query)
        {
            echo "<script>alert('Approved Successfully');</script>";
            echo "<script>window.location.href='ConferenceRegistration.php';</script>";
        }
    }else{
        echo "<script>alert('Please enter correct password');</script>";
    }
   
}
?>
<body>

<div id="layout-wrapper">

</div>

<div class="main-content">

<div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                <h4 class="mb-sm-0">Conference Registration</h4>

<div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                        <li class="breadcrumb-item"><a href="javascript: void(0);">Home</a></li>
                                        <li class="breadcrumb-item active">Conference Registration</li>
                                    </ol>
                                </div>

</div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="card-title mb-0">Conference Registration - CASH List - FOR APPROVAL</h5>
                                </div>
                                <div class="card-body">
                                 <?php
$filter_registration_type = isset($_GET['registration_type_filter']) ? $_GET['registration_type_filter'] : '';

?>
                                
                                       <form method="GET" action="export.php">
    <div class="row mb-3">
        <div class="col-lg-4">
            <select name="registration_type_filter" class="form-select">
                <option value="">Select Registration Type</option>
                <?php
                // Fetch all registration types for the filter dropdown
                $sql_filter = "SELECT registration_type_id, registration_type_details FROM registration_type";
                $result_filter = mysqli_query($con, $sql_filter);
                while ($row_filter = mysqli_fetch_assoc($result_filter)) {
                    $selected = (isset($_GET['registration_type_filter']) && $_GET['registration_type_filter'] == $row_filter['registration_type_id']) ? 'selected' : '';
                    echo "<option value='" . $row_filter['registration_type_id'] . "' $selected>" . $row_filter['registration_type_details'] . "</option>";
                }
                ?>
            </select>
        </div>

<div class="col-lg-4">
            <button type="button" class="btn btn-primary" id="searchBtn">Search</button>
        </div>

</div>
</form>

<table id="scroll-horizontal" class="table nowrap align-middle" style="width:100%">
                                    <thead>
                                            <tr>
                                                <th>Sl. No</th>
                                                <th>Reg No / Reg Date</th>
                                                <th>Status</th>
                                                <th>View</th>
                                                <th>Pay Particulars</th>
                                                <th>Name / Ph</th>
                                                <th>Reg Type</th>
                                                <th>Mode / Recd by</th>
                                                <th>Reg Amt</th>
                                                
                                            </tr>
                                        </thead>
                                        <tbody>

<?php
// Get the selected registration type filter if any
$filter_registration_type = isset($_GET['registration_type_filter']) ? $_GET['registration_type_filter'] : '';

// Base query with the potential filter applied
$sql = "SELECT r.*, 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 member AS m ON m.member_id = r.member_id 
        WHERE r.approve_status = '0' AND payment_mode = 1 and r.delete_status = '0'";

// If a filter is applied, add it to the query
if ($filter_registration_type) {
    $sql .= " WHERE r.registration_type_id = '$filter_registration_type'";
}

$sql .= " ORDER BY r.added_date DESC"; // Keep your ordering intact

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

if ($query->num_rows > 0) {
    $i = 0;
    while ($row = mysqli_fetch_assoc($query)) {
        $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'];
        }
        $i++;
?>
                                           <tr>
        <?php 
        $rdate = date_create($row['added_date']);
        $reg_date = date_format($rdate, "d/m/Y H:i");
        ?>
        <td><?php echo $i; ?></td>
        <td><?php echo $row['reg_no'];?><br><?php echo $reg_date;?></td>
         <td><?php   $query1 = mysqli_query($con, "select rotarian_name from admin where member_id='".$row['approved_by']."'");

$row2= mysqli_fetch_assoc($query1);

if($row['approve_status'] == 0 ) { ?>
                <a href="#" class="btn btn-warning" onclick="submitWithPassword(<?= $registration_id; ?>)">Pending</a>
            <?php }else { ?>
                <span class="btn btn-success">Approved</span><br>
                <span>By
                <?
                if($row['payment_mode']==3){
                    echo 'CC Avenue';
                } else {
                    echo ucfirst($row2['rotarian_name']); 
                }
                
                ?></span>
            <?php } ?>
        </td>
        <td><a href="conf-reg-details.php?regid=<?php echo $row['registration_id'];?>"><i class="btn btn-primary ri-eye-fill" style="font-size:14px;"></i></a></td>
        <td><?php echo $row['order_status'];?><br>
        <?php if($row['payment_mode'] != 1) {?>
        Trand Id : <?php echo $row['tracking_id'];?><br>
        Bank Ref: <?php echo $row['bank_ref'];?>
        <?php } ?>
        </td>

<?php $categoryList = array('Rotarian','Rotarian','Rotaract','Guest','Others'); ?>
        <td><?php echo $name;?><br><?php echo $categoryList[$row['category_id']];?><br><?php echo $row['phone_number'];?></td>
        <td align="left"><?php echo substr(($row['registration_type_details'].' '.$row['registration_amount']),0,18);?></td>
        <td><?php 
            switch ($row['payment_mode']) {
              case 1:
                echo 'Cash';
                break;
              case 2:
                echo 'Online Direct';
                break;
              case 3:
                echo 'Payment Gateway';
                break;
              default:
                //code block
            }
        ?>
        <br>
        <?php 
            if($row['paid_to_member_id']==0){
                if($row['payment_mode']==2){
                    echo 'Direct Bank';
                }
                if($row['payment_mode']==3){
                    echo 'CC Avenue';
                }
            } else {
                $query11 = mysqli_query($con, "select rotarian_name from admin where member_id='".$row['paid_to_member_id']."'");
                $row11= mysqli_fetch_assoc($query11);
                echo $row11['rotarian_name'];
            }
        ?></td>
        
        <td><?php 
            if($row['order_status']==='Success'){
                echo $row['registration_amount'];
            }
        
        // echo $row['registration_amount'];
        
        
        ?></td>
       
    </tr>
                                            <?php
                                        
                                    }
                                }else{
                                    echo "<b> Records Not Found.....</b>";
                                }
                            ?>
                            </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

</div>
                
            </div>
            
            <?php  include "footer.php"?>;

</body>

// Check if the user provided a password
        if (password !== null) {
            var url = "ConferenceRegistration.php?approve&&id=" + registrationId + "&password=" + encodeURIComponent(password);
            window.location.href = url;
        }else{
            alert('Please enter password');
        }
    }
</script>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ConferenceRegistrationCashToApprove.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation