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/demo.sigmacomputers.in/public_html/avatar_coupon/admin

Free Space:

4.08 TB

🔧 Quick Actions

✏️ Editing: Dashboard_admin.php

<?php 
include "header.php";
$member_id = $_SESSION["member_id"];
$user_group = $_SESSION["user_group"];
?>
<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">Dashboard</h4>

<div class="page-title-right">
                                    <ol class="breadcrumb m-0">
                                      
                                        <li class="breadcrumb-item active">Dashboard</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">Dashboard</h5>
                                </div>
							</div>
						</div>
					</div>
					
					<div class="row">

<div class="col-md-6">
                            <div class="d-flex flex-column h-100">
                                <div class="row">
                                     <?php
                                                        if($user_group != 2){
                                                        $sql="SELECT COUNT(CASE WHEN payment_mode = 1 THEN 1 END) AS payment_mode_1_count, COUNT(CASE WHEN payment_mode = 2 or payment_mode = 3 THEN 1 END) AS payment_mode_0_count FROM registration where approve_status =1 and delete_status = 0";}
                                                        else{
                                                            $sql="SELECT COUNT(CASE WHEN payment_mode = 1 THEN 1 END) AS payment_mode_1_count, COUNT(CASE WHEN payment_mode = 2 THEN 1 END) AS payment_mode_0_count FROM registration where approve_status =1  and delete_status = 0 and paid_to_member_id = $member_id ";
                                                        }
                                                        $query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                         $cash_count2 = $row['payment_mode_1_count'];
                                         $online_count2 = $row['payment_mode_0_count'];
                                         $approve_total = $cash_count2 + $online_count2;
                                                        ?>
                                <div class="container">
									 <div class="card">
										<div class="card-header">
											<h5 class="card-title mb-0">Registration Approved
                                             <span style="margin-left: 50%;">Total - <?php echo $approve_total;?></span> </h5>
										</div>
									</div>
                                    <div class="row">
                                    <div class="col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between">
                                                    <div>
                                                       
                                                        <p class="fw-medium text-green mb-0">Online</p>
                                                        <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $online_count2?></h2>
                                                    </div>
                                                    <div>
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                <img src="svg/online.png"/>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div> 
                                    </div>

<div class="col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between">
                                                    <div>
                                                        <p class="fw-medium text-cash mb-0">Cash</p>
                                                        <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $cash_count2?></h2>
                                                    </div>
                                                    <div>
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                <img src="svg/cash.png"/>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div> 
                                    </div>
                                </div>
                                </div>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-md-12">
                            <div class="d-flex flex-column h-100">
                                <div class="row">
                                <div class="">
									 <div class="card">
										<div class="card-header">
											<h5 class="card-title mb-0">Categorywise Registration</h5>
										</div>
									</div>
                                    <div class="row">
										<div class="col-md-2">
											<div class="card card-animate">
												<div class="card-body">
													<div class="d-flex justify-content-between">
														<div>
                                                            <?php 
                                                        
                                                        $sql=" SELECT rt.registration_type_id, 
           rt.registration_type_details, 
           COUNT(r.registration_type_id) AS registration_count
    FROM registration r
    JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id
    WHERE rt.registration_type_details = 'Combo [Conference + 5 Seminar]'
    AND r.approve_status = 1 AND r.delete_status = 0
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
    GROUP BY rt.registration_type_id, rt.registration_type_details";
                                                            $query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $combo = $row['registration_count']??'0';

?>
															<p class="fw-medium text-green mb-0">Combo</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $combo?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/combo.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div> 
									<br>
										<div class="col-md-2">
											<div class="card card-animate">
												<div class="card-body">
													<div class="d-flex justify-content-between">
														<div>
                                                            <?php 
//                                                             
                                                            $sql = "
    SELECT SUM(registration_count) AS total_registration_count
    FROM (
        SELECT rt.registration_type_id, 
               rt.registration_type_details, 
               COUNT(r.registration_type_id) AS registration_count
        FROM registration r
        JOIN registration_type rt 
            ON r.registration_type_id = rt.registration_type_id
        WHERE rt.registration_type_details IN ('Rotarian', 
                                                'Rotarian + Ann', 
                                                'Rotarian + Ann + Annet', 
                                                'Rotarian + Ann + 2 Annet')
          AND r.approve_status = 1 AND r.delete_status = 0
          " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
        GROUP BY rt.registration_type_id, rt.registration_type_details
    ) AS subquery
";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $rotarian = $row['total_registration_count']??'0';

?>
															<p class="fw-medium text-green mb-0">Rotarian</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $rotarian;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/rotarian.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div> 
										
										<div class="col-md-2">
											<div class="card card-animate">
												<div class="card-body">
													<div class="d-flex justify-content-between">
														<div>
                                                             <?php 
                                                            // $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Rotractor' GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";

$sql=" SELECT rt.registration_type_id, 
           rt.registration_type_details, 
           COUNT(r.registration_type_id) AS registration_count
    FROM registration r
    JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id
    WHERE rt.registration_type_details = 'Rotractor'
    AND r.approve_status = 1
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
    GROUP BY rt.registration_type_id, rt.registration_type_details";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $rotractor = $row['registration_count']??'0';

?>
															<p class="fw-medium text-green mb-0">Rotract</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php 
                                                            echo $rotractor;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/rotarian.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div> 
										
										
										<div class="col-md-2">
											<div class="card card-animate">
												<div class="card-body">
													<div class="d-flex justify-content-between">
														<div>
                                                            <?php 
                                                            // $sql = "SELECT COUNT(*) FROM `registration_details` WHERE member_type = 6";
                                                            $sql=" SELECT count(*) 
    FROM registration_details rd
    JOIN registration r ON rd.ref_registration_id = r.registration_id
    WHERE rd.member_type = 6
    AND r.approve_status = 1
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $guest = $row['count(*)']??'0';

?>
															<p class="fw-medium text-green mb-0">Guest</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $guest;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/guest.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div>

if($user_group != 2){
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 1' && r.approve_status = 1 GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }else {
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, count(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 1'  && r.paid_to_member_id = $member_id GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }
//                                                             $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count 
//         FROM registration r 
//         JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id 
//         WHERE rt.registration_type_details = 'Family Patron 1' 
//         AND r.approve_status = 1";

// if ($user_group == 2) {
//     $sql .= " AND r.paid_to_member_id = $member_id";
// }

// $sql .= " GROUP BY rt.registration_type_id, rt.registration_type_details 
//           ORDER BY registration_count ASC;";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $family_pat1 = $row['registration_count']??'0';

?>
															<p class="fw-medium text-cash mb-0">Fly Patron-1</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $family_pat1;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/family.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div>

if($user_group != 2){
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 2' && r.approve_status = 1 GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }else {
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, count(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 2' && r.approve_status = 1  && r.paid_to_member_id = $member_id GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }
                                                            $query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $family_pat2 = $row['registration_count']??'0';

?>
															<p class="fw-medium text-cash mb-0">Fly Patron-2</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $family_pat2;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/family.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div>

<div class="col-md-2">
											<div class="card card-animate">
												<div class="card-body">
													<div class="d-flex justify-content-between">
														<div>
                                                              <?php 
                                                            // $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 3' GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                                if($user_group != 2){
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, COUNT(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 3' && r.approve_status = 1 GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }else {
                                                                $sql = "SELECT rt.registration_type_id, rt.registration_type_details, count(r.registration_type_id) AS registration_count FROM registration r JOIN registration_type rt ON r.registration_type_id = rt.registration_type_id where rt.registration_type_details = 'Family Patron 3' && r.approve_status = 1  && r.paid_to_member_id = $member_id GROUP BY rt.registration_type_id, rt.registration_type_details ORDER BY `registration_count` ASC;";
                                                            }
                                                            $query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $family_pat3 = $row['registration_count']??'0';

?>
															<p class="fw-medium text-cash mb-0">Fly Patron-3</p>
															<h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $family_pat3;?></h2>
														</div>
														<div>
															<div class="avatar-sm flex-shrink-0">
																<span class="avatar-title bg-info-subtle rounded-circle fs-2">
																	<img src="svg/family.png"/>
																</span>
															</div>
														</div>
													</div>
												</div>
											</div> 
										</div>
										<div> <br></div>
                                        <div class="col-md-2">
                                            <div class="card card-animate">
                                                <div class="card-body">
                                                <div class="d-flex justify-content-between">
                                                        <div>
                                                            <?php 
                                                           
                                                            $sql = "
    SELECT count(*) 
    FROM registration_details rd
    JOIN registration r ON rd.ref_registration_id = r.registration_id
    WHERE rd.member_type = 12
    AND r.approve_status = 1
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $ann = $row['count(*)']??'0';

?>
                                                            <p class="fw-medium text-green mb-0">Spouse</p>
                                                            <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $ann;?></h2>
                                                        </div>
                                                        <div>
                                                            <div class="avatar-sm flex-shrink-0">
                                                                <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                    <img src="svg/ann.png"/>
                                                                </span>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div> 
                                        </div> 
                                        
                                        <div class="col-md-2">
                                            <div class="card card-animate">
                                                <div class="card-body">
                                                    <div class="d-flex justify-content-between">
                                                        <div>
                                                            <?php 
                                                            // $sql = "SELECT COUNT(*) FROM `registration_details` WHERE member_type = 4 or member_type = 5";
                                                            $sql=" SELECT count(*) 
    FROM registration_details rd
    JOIN registration r ON rd.ref_registration_id = r.registration_id
    WHERE rd.member_type = 14 AND r.approve_status = 1
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $annet = $row['count(*)']??'0';

?>
                                                            <p class="fw-medium text-green mb-0">Annet</p>
                                                            <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $annet;?></h2>
                                                        </div>
                                                        <div>
                                                            <div class="avatar-sm flex-shrink-0">
                                                                <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                    <img src="svg/annet.png"/>
                                                                </span>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div> 
                                        </div> 
                                        <div class="col-md-2">
                                            <div class="card card-animate">
                                                <div class="card-body">
                                                    <div class="d-flex justify-content-between">
                                                        <div>
                                                            <?php 
                                                            // $sql = "SELECT COUNT(*) FROM `registration_details` WHERE member_type = 7";
                                                            $sql=" SELECT count(*) 
    FROM registration_details rd
    JOIN registration r ON rd.ref_registration_id = r.registration_id
    WHERE rd.member_type = 7
    AND r.approve_status = 1
    " . ($user_group == 2 ? "AND r.paid_to_member_id = $member_id" : "") . "
";

$query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                                        $others = $row['count(*)']??'0';

?>
                                                            <p class="fw-medium text-cash mb-0">Others</p>
                                                            <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $others;?></h2>
                                                        </div>
                                                        <div>
                                                            <div class="avatar-sm flex-shrink-0">
                                                                <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                    <img src="svg/guest.png"/>
                                                                </span>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div> 
                                        </div>
                                        
									</div>
                                </div>
                                </div>
                            </div>
                        </div>
                        
                           <div class="row col-md-12">
                        <div class="col-md-6">
                            <div class="d-flex flex-column h-100">
                                <div class="row">
                                    <?php 
                                                        if($user_group == 1){
                                                       $sql = "SELECT
    COUNT(CASE WHEN payment_mode = 1 THEN 1 END) AS payment_mode_1_count,
    COUNT(CASE WHEN payment_mode = 2  THEN 1 END) AS payment_mode_2_count,    
    COUNT(CASE WHEN payment_mode = 3 THEN 1 END) AS payment_mode_3_count    
FROM registration;";
}else{
     $sql = "SELECT
    COUNT(CASE WHEN payment_mode = 1 THEN 1 END) AS payment_mode_1_count,
    COUNT(CASE WHEN payment_mode = 2  THEN 1 END) AS payment_mode_2_count,    
    COUNT(CASE WHEN payment_mode = 3 THEN 1 END) AS payment_mode_3_count  
FROM registration WHERE paid_to_member_id = $member_id ";
}
                                                        $query = mysqli_query($con, $sql);
                                                        $row= mysqli_fetch_assoc($query);
                                         $cash_count1 = $row['payment_mode_1_count'];
                                         $payment_mode_2_count = $row['payment_mode_2_count'];
                                         $payment_mode_3_count = $row['payment_mode_3_count'];
                                         $online_count1 = $payment_mode_2_count + $payment_mode_3_count;
                                         $total = $cash_count1 + $online_count1;

?>
                                <div class="container">
									 <div class="card">
										<div class="card-header">
											<h5 class="card-title mb-0">Registration Initiated
                                            <span style="margin-left: 50%;">Total - <?php echo $total;?></span>  
                                            </h5>
                                            
										</div>
									</div>
                                    <div class="row">
                                    <div class="col-md-6">
                                        <div class="card card-animate">
                                            <div class="card-body">
                                                <div class="d-flex justify-content-between">
                                                    <div>
                                                        
                                                        <p class="fw-medium text-green mb-0">Online</p>
                                                        <h2 class="mt-4 ff-secondary cfs-22 fw-semibold"><?php echo $online_count1?></h2>
                                                    </div>
                                                    <div>
                                                        <div class="avatar-sm flex-shrink-0">
                                                            <span class="avatar-title bg-info-subtle rounded-circle fs-2">
                                                                <img src="svg/online.png"/>
                                                            </span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div> 
                                    </div>

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

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Dashboard_admin.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation