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/conference_registration(2)

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: registration_details(1).php

<div class="col-lg-12">
                        <?php  $flag = true;
                        $approve_status ='';
                        $mem_type ='';
                        $type_id ='';
                        $cat_id ='';
                        // echo $phone_number."reg idd";exit();   
                           $sql = "
    SELECT r.*, rt.registration_type_details,rd.member_type FROM registration AS r LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id LEFT JOIN registration_details AS rd ON r.registration_id = rd.ref_registration_id WHERE r.phone_number = $phone_number AND r.order_status NOT IN ('Failure', 'Aborted', 'Unsuccessful', 'Timeout') AND r.delete_status = 0 AND r.upgrade_id = 0 AND ( (r.category_id = 4 AND r.already_registered = 0) OR r.category_id !=4) AND r.registration_type_id != 3 AND ( (r.order_status = 'Initiated' AND r.tracking_id != '') OR r.order_status != 'Initiated' )
";
        $query2 = mysqli_query($con, "SELECT *,r.category_id FROM registration AS r LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id LEFT JOIN registration_details AS rd ON r.group_number = rd.group_number WHERE r.phone_number = '$phnNum' AND r.delete_status = 0 AND r.upgrade = 1 AND r.upgrade_id = 0 AND r.approve_status = 0 AND r.order_status NOT IN ('Failure', 'Aborted', 'Unsuccessful', 'Timeout') AND ( (r.order_status = 'Initiated' AND r.tracking_id != '') OR r.order_status != 'Initiated' ) ORDER BY r.registration_id LIMIT 1");

$upgradeResult = mysqli_fetch_assoc($query2);         // echo $sql;
                              
                            $res=mysqli_query($con, $sql);
                            $row=mysqli_fetch_array($res);
                            if($row){
                                $flag = false;
                            $mode = $row['payment_mode'];
                            $approve_status = $row['approve_status'];
                            $registration_id = $row['registration_id'];
                            $reg_no = $row['reg_no'];
                            $type_id = $row['registration_type_id'];
                            $cat_id = $row['category_id'];
                            $order_status = $row['order_status'];
                            $registration_type = $row['registration_type_details'];

// if($reg_no_sts == ''){
                            //     $reg_no = 'Pending';
                            // }else{
                            //     $reg_no = $reg_no_sts;
                            // }
                            // echo $approve_status;

switch ($row['payment_mode']) {
                              case 1:
                                $type = "Cash";
                                break;
                              case 2:
                                $type = 'Online Direct';
                                break;
                              case 3:
                                $type = 'Payment Gateway';
                                break;
                              default:
                                //code block
                            }

//          if($row['paid_to_member_id'] == 0 ) { $receive = "User"; }else { $receive = "Admin"; }

if($row['paid_to_member_id']==0){
                                if($row['payment_mode']==2){
                                    $receive = 'Direct Bank';
                                }
                                if($row['payment_mode']==3){
                                    $receive = '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);
                                $receive = $row11['rotarian_name'];
                            }

?>
                            <div class="card"> 
    <div class="card-header">
        <div class="row">
            <div class="col-md-3">
                <h5 class="text-primary">Reg No :  <?php if($reg_no == ''){?>
                            <span style="color:red;"> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?></h5>
            </div>
            <div class="col-md-6">
                <?php if(!empty($upgradeResult) && $upgradeResult['approve_status'] == 0){ ?>
                <h5 class="text-danger text-center">Approval Pending For - <?= $upgradeResult['registration_type_details']; ?></h5>
                <?php }?>
                
            </div>
            <div class="col-md-3">
                <h5 class="text-primary text-end"> Received by - <?php echo $receive; ?></h5>
            </div>
        </div>
    </div>
    
    
    <?php if ($mode==3){ ?>
    <table class="table table-bordered">
        <tr>
            <th colspan=4 align="center">Payment Through Online</th>
        </tr>
        <tr>
            <th align="left">Order Status</th>
            <th align="left">Tracking ID</th>
            <th align="left">Bank Ref</th>
        </tr>
        <tr>
            <td align="left"><?php echo $row['order_status'];?></td>
            <td align="left"><?php echo $row['tracking_id'];?></td>
            <td align="left"><?php echo $row['bank_ref'];?></td>
        </tr>
    </table>
    <?php } ?>
    <?php if ($mode==2){ ?>
    <table class="table table-bordered" cellspacing="0" border="0">
        <tr>
            <th align="left">Payment Through UPI</th>
            <td align="left">Click on Image to Zoom <br><a href="uploads/upi_screenshots/<?= $row['UPI_transaction_screenshot'];?>" target="_blank"><img src="uploads/upi_screenshots/<?= $row['UPI_transaction_screenshot'];?>" height="400"/></a></td>
        </tr>
        <!-- <tr>
            <td colspan="3">

<?php

if($approve_status == 0) { 
// echo $approve_status;
                ?>
                <a href="#" class="btn btn-warning" onclick="submitWithPassword()">Pending</a>
           
                <?php }?>
        </td>
        </tr> -->
    </table>
    <?php } }else{
        $registration_id = '';
    }

?>
        
            
    <div class="card-body">
        <div class="table-responsive">
            <div class="row">               
                <?php
                if($registration_id != ''){

// $sql = "select rd.*,c.club_name from registration_details as rd left join club as c on c.club_id = rd.club_id where upgrade_id = 0 AND group_number = $phone_number group by rd.member_type,rd.name";

$sql ="select rd.*,c.club_name,r.order_status from registration_details as rd left join club as c on c.club_id = rd.club_id 
                    left join registration as r on r.registration_id = rd.ref_registration_id
                    where r.upgrade_id = 0 AND rd.upgrade_id = 0 AND r.registration_type_id != 3 AND rd.group_number = $phone_number group by rd.member_type,rd.group_count";
                        $res = mysqli_query($con, $sql);
                        $i = 0;
                        while($row = mysqli_fetch_array($res)){
                            $mem_type = $row['member_type'];
                            // echo "order".$order_status;
                    if($mem_type == 1){ 
                ?>
                <div class="col-md-3 ">
                    <table class="table bg-primary text-white table-bordered"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white ">Rotarian</th>
                        </tr> 
                        <tr>
                             <td align="left" ><b>Status :</b>
                             <?php if($order_status == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['order_status']; ?></span>
                            <?php }?>
                        </td>
                           
                        </tr>
                        <tr>
                           
                           <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                            
                        </tr>
                        <tr>
                            <td align="left"><b>Name :</b> <?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Club :</b> <?= $row['club_name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile :</b> <?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Email :</b> <?= $row['email_id']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Gender :</b> <?= ($row['gender'] == 1) ? 'Male' : 'Female'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food :</b> <?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Shirt/T-shirt Size :</b> <?= $row['t_shirt_and_shirt_size']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Fellowship :</b> <?= ($row['fellow_ship'] == 1) ? 'Yes' : 'No'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Reg Type :</b> <?= $registration_type; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 2) {?>
                <div class="col-md-3">
                    <table class="table table-bordered  bg-primary text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">Rotaractor</th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status'] ? : 'Pending'; ?></td>

</tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name : </b><?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Club :</b> <?= $row['club_name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile :</b> <?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Email :</b> <?= $row['email_id']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Gender :</b> <?= ($row['gender'] == 1) ? 'Male' : 'Female'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food :</b> <?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= $registration_type; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 6) {?>
                <div class="col-md-3">
                    <table class="table table-bordered bg-primary text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">Guest</th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>
                       </tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name :</b> <?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Club :</b> <?= $row['club_name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile :</b> <?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Email :</b> <?= $row['email_id']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Gender :</b> <?= ($row['gender'] == 1) ? 'Male' : 'Female'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food :</b> <?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= $registration_type; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 7) {?>
                <div class="col-md-3">
                    <table class="table table-bordered bg-primary text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">Others</th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>
                       </tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name :</b><?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Club :</b><?= $row['club_name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile :</b><?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Email :</b><?= $row['email_id']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Gender :</b><?= ($row['gender'] == 1) ? 'Male' : 'Female'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food :</b><?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Shirt/T-shirt Size :</b><?= $row['t_shirt_and_shirt_size']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Fellowship :</b> <?= ($row['fellow_ship'] == 1) ? 'Yes' : 'No'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= $registration_type; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 3) { $annInc = 1; ?>
                <div class="col-md-3">
                    <table class="table table-bordered bg-secondary text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">SPOUSE / PARTNER</th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>
                       </tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name: </b> <?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile : </b> <?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food : </b><?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= 'Conference'; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 4) { $i++;?>
                <div class="col-md-3">
                    <table class="table bg-warning text-white table-bordered"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">ANNET - <?= $i; ?> </th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>
                       </tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name :</b> <?= $row['name']; ?></td>
                        </tr>
                       
                        <tr>
                            <td align="left"><b>Age :</b> <?php if($row['age']== 1){echo "Below 5 Years";}elseif($row['age']== 2){echo "5 to 12 Years";}elseif($row['age']== 3){echo "Above 12 Years";}?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food : </b><?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= 'Conference'; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 5) {?>
                <div class="col-md-3">
                    <table class="table table-bordered bg-warning text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">ANNET -2 </th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>
                       </tr>
                        <tr>
                            <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                        </tr>
                        <tr>
                            <td align="left"><b>Name : </b><?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Age : </b><?= ($row['age'] == 1) ? 'Below 5 Years' : ($row['age'] == 2) ? '5 to 12 Years' : 'Above 12 Years'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food : </b><?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                         <tr>
                            <td align="left"><b>Reg Type :</b> <?= 'Conference'; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php } ?>
        <?php } 
}
         ?>
             </div><br>
<?php  
        if($flag == true){                // echo $phone_number."reg idd";exit();   
                           $sql = "
    SELECT r.*, rt.registration_type_details FROM registration AS r LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id WHERE r.phone_number = $phone_number AND r.order_status NOT IN ('Failure', 'Aborted', 'Unsuccessful', 'Timeout') AND r.delete_status = 0 AND r.upgrade_id = 0 AND r.registration_type_id = 3 AND ( (r.order_status = 'Initiated' AND r.tracking_id != '') OR r.order_status != 'Initiated' )
";
                            // echo $sql;
                              
                            $res=mysqli_query($con, $sql);
                            $row=mysqli_fetch_array($res);
                            if($row){

$mode = $row['payment_mode'];
                            $approve_status = $row['approve_status'];
                            $registration_id = $row['registration_id'];
                            $reg_no = $row['reg_no'];
                            $type_id = $row['registration_type_id'];

$order_status = $row['order_status'];
                            $registration_type = $row['registration_type_details'];
                            // echo $approve_status;

//          if($row['paid_to_member_id'] == 0 ) { $receive = "User"; }else { $receive = "Admin"; }

?>
                            <div class="card"> 
    <div class="card-header">
        <div class="row">
            <div class="col-md-3">
                <h5 class="text-primary">Reg No : <?php if($reg_no == ''){?>
                            <span style="color:red;"> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?></h5>
            </div>
            <div class="col-md-6">
                <h5 class="text-primary text-center"><?php echo $row['registration_type_details'].' - '.$row['registration_amount'].' / '.$type; ?></h5>
            </div>
            <div class="col-md-3">
                <h5 class="text-primary text-end"> Received by - <?php echo $receive; ?></h5>
            </div>
        </div>
    </div>
    
    
    <?php if ($mode==3){ ?>
    <table class="table table-bordered">
        <tr>
            <th colspan=4 align="center">Payment Through Online</th>
        </tr>
        <tr>
            <th align="left">Order Status</th>
            <th align="left">Tracking ID</th>
            <th align="left">Bank Ref</th>
        </tr>
        <tr>
            <td align="left"><?php echo $row['order_status'];?></td>
            <td align="left"><?php echo $row['tracking_id'];?></td>
            <td align="left"><?php echo $row['bank_ref'];?></td>
        </tr>
    </table>
    <?php } ?>
    <?php if ($mode==2){ ?>
    <table class="table table-bordered" cellspacing="0" border="0">
        <tr>
            <th align="left">Payment Through UPI</th>
            <td align="left">Click on Image to Zoom <br><a href="uploads/upi_screenshots/<?= $row['UPI_transaction_screenshot'];?>" target="_blank"><img src="uploads/upi_screenshots/<?= $row['UPI_transaction_screenshot'];?>" height="400"/></a></td>
        </tr>
        <tr>
            <td colspan="3">

<?php

if($approve_status == 0) { 
// echo $approve_status;
                ?>
                <a href="#" class="btn btn-warning" onclick="submitWithPassword()">Pending</a>
           
                <?php }?>
        </td>
        </tr>
    </table>
    <?php } }else{
        $registration_id = '';
    }

$sql = "select rd.*,c.club_name,r.order_status from registration_details as rd left join club as c on c.club_id = rd.club_id 
                    left join registration as r on r.registration_id = rd.ref_registration_id where r.upgrade_id = 0 AND rd.group_number = $phone_number group by rd.member_type,rd.group_count";
                // echo $sql;
                        $res = mysqli_query($con, $sql);
                        $i = 0;
                        while($row = mysqli_fetch_array($res)){
                            $mem_type = $row['member_type'];
                    if($mem_type == 1){ 
                ?>
                 <div class="col-md-3 ">
                    <table class="table bg-primary text-white table-bordered"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white ">Rotarian</th>
                        </tr> 
                        <tr>
                             <td align="left" ><b>Status :</b>
                             <?php if($order_status == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['order_status']; ?></span>
                            <?php }?>
                        </td>
                           
                        </tr>
                        <tr>
                           
                           <td align="left" ><b>Reg No :</b>
                             <?php if($row['reg_no'] == ''){?>
                            <span> Pending</span>
                            <?php }else{?>
                                <span > <?= $row['reg_no']; ?></span>
                            <?php }?>
                        </td>
                            
                        </tr>
                        <tr>
                            <td align="left"><b>Name :</b> <?= $row['name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Club :</b> <?= $row['club_name']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Mobile :</b> <?= $row['phone_number']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Email :</b> <?= $row['email_id']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Gender :</b> <?= ($row['gender'] == 1) ? 'Male' : 'Female'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Food :</b> <?= ($row['food'] == 1) ? 'Veg' : 'Non-Veg'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Shirt/T-shirt Size :</b> <?= $row['t_shirt_and_shirt_size']; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Fellowship :</b> <?= ($row['fellow_ship'] == 1) ? 'Yes' : 'No'; ?></td>
                        </tr>
                        <tr>
                            <td align="left"><b>Reg Type :</b> <?= $registration_type; ?></td>
                            
                        </tr>
                        <tr>
                            <td align="left"><img class="img-fluid" src="uploads/<?= $row['photo_upload']; ?>" width="20%"></td>
                        </tr>
                    </table>
                </div>
            <?php }else if ($mem_type == 2) {?>
                <div class="col-md-3">
                    <table class="table table-bordered  bg-primary text-white"  cellspacing="0" border="0">
                        <tr>
                            <th align="left" class="text-white">Rotaractor</th>
                        </tr>
                         <tr>
                           <td align="left"><b>Status :</b> <?= $row['order_status']? : 'Pending'; ?></td>

<?php } ?>
              <?php 
                        $seminars = ['', 'Seminar 1', 'Seminar 2', 'Seminar 3', 'Seminar 4', 'Seminar 5'];
                        $sql = "
    SELECT r.*, rt.registration_type_details FROM registration AS r LEFT JOIN registration_type AS rt ON r.registration_type_id = rt.registration_type_id WHERE r.phone_number = $phone_number AND r.order_status NOT IN ('Failure', 'Aborted', 'Unsuccessful', 'Timeout') AND r.delete_status = 0 AND r.upgrade_id = 0 AND r.registration_type_id = 3 AND ( (r.order_status = 'Initiated' AND r.tracking_id != '') OR r.order_status != 'Initiated' )";
                        $result = mysqli_query($con, $sql);
            $patron = [7,8,9,10];
if(mysqli_num_rows($result) > 0 && !in_array($type_id, $patron)){ ?>
             <div class="col-md-6">
                 <table class="table table-bordered bg-danger text-white"  cellspacing="0" border="0">
                    <tr>
                        <th colspan = "3" class="text-white">Seminar Details </th>
                    </tr>
                        <tr>
                            <th class="text-white" align="left">Date</th>
                            <th class="text-white" align="left">Seminar</th>
                            <th class="text-white" align="left">Status</th>
                        </tr>
                        <?php 
                       
                        while($row = mysqli_fetch_array($result)){
                            $seminar= json_decode($row['seminars']);
                        ?>
                        <tr>    
                            <td align="left"><b><?= $row['added_date'];?></b> </td>

<td align="left"><b><?php foreach ($seminar as $key => $value) {
                                echo $seminars[$value].'<br>';

$selectedSeminars[] = $value;
                            }
                            
                        ?></b> </td>
                           <?php if($row['approve_status']== 1){?>
                                <td align="left"><b>
                                
                            </b>Approved</td><?php
                            }elseif($row['approve_status']== 0){?>
                                <td align="left"><b>
                                
                            </b>Pending</td><?php
                            }

?>
                            
                        </tr> 
                        <?php } ?>
                    </table>
             </div>
             
            
            <?php }  
            if($approve_status == 1){?>
				<div class="row">
             <div class="col-md-9 text-start ">
                 <h5 class="btn btn-danger">If you want to Change or Edit Registered Data Contact Your Respective Assistant Governor</h5>
             </div>

<?php }

if($type_id != 7 && $type_id != 10 && $cat_id != 2 && $cat_id != 3 && $cat_id != 4) { ?>
            <div class="col-md-3 text-end">
                 <a href="upgrade.php?phn_num=<?= $phone_number; ?>&type_id=<?= $type_id; ?>" class="btn btn-success mb-4 me-5">Upgrade To Pattron</a>
            </div>
            </div>
            <?php } ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: registration_details(1).php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation