<?php 
error_reporting(0);
include("common.php"); 
include("config.php"); 

// Query to count total vacancies
$sql = "SELECT COUNT(*) as total_vacancies FROM vacancy"; 
$result = $conn->query($sql);
// Get the count value
$totalVacancies = 0;
if ($result && $row = $result->fetch_assoc()) {
    $totalVacancies = $row['total_vacancies'];
}

$sql1 = "SELECT COUNT(*) as total_contact FROM contact_book"; 
$result1 = $conn->query($sql1);
$totalContact = 0;
if ($result1 && $row1 = $result1->fetch_assoc()) {
    $totalContact = $row1['total_contact'];
}

$sql2 = "SELECT COUNT(*) as total_reg FROM emp_reg"; 
$result2 = $conn->query($sql2);
$totalEmpReg = 0;
if ($result2 && $row2 = $result2->fetch_assoc()) {
    $totalEmpReg = $row2['total_reg'];
}

$sql3 = "SELECT COUNT(*) as total_appointment FROM emp_reg where status='Yes'"; 
$result3 = $conn->query($sql3);
$totalAppointment = 0;
if ($result3 && $row3 = $result3->fetch_assoc()) {
    $totalAppointment = $row3['total_appointment'];
}


$sql4 = "SELECT COUNT(*) as total_post FROM post"; 
$result4 = $conn->query($sql4);
$totalPOST = 0;
if ($result4 && $row4 = $result4->fetch_assoc()) {
    $totalPOST = $row4['total_post'];
}

$sql5= "SELECT COUNT(*) as total_Emp FROM applications"; 
$result5 = $conn->query($sql5);
$totalEmp = 0;
if ($result5 && $row5 = $result5->fetch_assoc()) {
    $totalEmp = $row5['total_Emp'];
}

$sql7= "SELECT COUNT(*) as total_Emp FROM applications where status='Selected'"; 
$result7 = $conn->query($sql7);
$totalSELEmp = 0;
if ($result7&& $row7 = $result7->fetch_assoc()) {
    $totalSELEmp = $row7['total_Emp'];
}


$sql6= "SELECT COUNT(*) as total_Emp FROM applications where status='Reject'"; 
$result6 = $conn->query($sql6);
$totalEmp6 = 0;
if ($result6 && $row6 = $result6->fetch_assoc()) {
    $totalEmp6 = $row6['total_Emp'];
}
?>
<style>
		
		.btn6{
			padding:2px;
			background-color:#4a3937;
			color:#fff;
			border-radius:2px;
			padding-left:10px;padding-right:10px;
			border:2px solid #4a3937;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:120px;	
			
		}
		</style>
<style>
 
.vacancy-count {
    background: linear-gradient(90deg, #ff7f50, #ff4500);
    color: white;
    padding: 5px 10px;
    border-radius: 5px;
    font-size: 24px;
    font-weight: bold;
    margin-left: 10px;
    display: inline-block;
    animation: pulse 1.5s infinite;
}

        .row {
            display: flex;
            flex-wrap: wrap;
            gap: 20px; /* Space between boxes */
        }

        .job-box {
            flex: 1 1 calc(25% - 20px); /* 4 boxes per row */
            background-color: #ffffff;
            border: 1px solid #ddd;
            border-radius: 8px;
            padding: 20px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
            transition: transform 0.3s ease;
        }

        .job-box:hover {
            transform: translateY(-5px);
        }

        .job-box h4 {
            color: #333;
            font-size: 18px;
            margin-bottom: 10px;
        }

        .job-box p {
            color: #555;
            margin: 5px 0;
        }

   
        .apply-btn {
            display: inline-block;
            padding: 10px 20px;
            font-size: 16px;
            color: #ffffff;
            background-color: #007bff;
            border-radius: 5px;
            text-decoration: none;
            text-align: center;
            margin-top: 10px;
            transition: background-color 0.3s ease, transform 0.3s ease;
        }

        .apply-btn:hover {
            background-color: #0056b3;
            transform: translateY(-2px);
			color:#fff;
        }

        @media (max-width: 992px) {
            .job-box {
                flex: 1 1 calc(33.33% - 20px); /* 3 boxes per row for medium screens */
            }
        }

        @media (max-width: 768px) {
            .job-box {
                flex: 1 1 calc(50% - 20px); /* 2 boxes per row for small screens */
            }
        }

        @media (max-width: 480px) {
            .job-box {
                flex: 1 1 100%; /* 1 box per row for very small screens */
            }
        }
    </style>
        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: Breadcrumbs-->
                <div class="row">
                    <div class="col-12  align-self-center">
                        <div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
                            <div class="w-sm-100 mr-auto"><h4 class="mb-0">Reports</h4> 
							           <span style="float:left">
  <a href="welcome.php"><button class="btn6">Back to page</button> </a></span>
							</div>

                          
                        </div>
                    </div>
                </div>
				
	
                <div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                           
                            
							 <div class="card-body">
                                <div class="table-responsive">
                                   <div class="container">
        <div class="row">
           
               <div class="job-box" style="background: rgb(221,251,251);
background: radial-gradient(circle, rgba(221,251,251,1) 7%, rgba(241,210,215,0.34775908654477417) 76%);">
    <h4> Applied List <span class="vacancy-count"><?php echo $totalEmp; ?></span></h4>
                <a href="member.php" class="apply-btn">View Now</a>
            </div>
			
			<div class="job-box" style="background: rgb(221,251,251);
background: radial-gradient(circle, rgba(221,251,251,1) 7%, rgba(183,245,218,0.8883753330433736) 76%);">
    <h4> Selected Employee<span class="vacancy-count"><?php echo $totalSELEmp; ?></span></h4>
                <a href="member_select.php" class="apply-btn">View Now</a>
            </div>
           <div class="job-box" style="background: rgb(221,251,251);
background: radial-gradient(circle, rgba(221,251,251,1) 7%, rgba(241,210,215,0.34775908654477417) 76%);">
                <h4>Reject Members <span class="vacancy-count"><?php echo $totalEmp6; ?></span></h4>
                <a href="member_reject.php" class="apply-btn">View Now</a>
            </div>
            <div class="job-box" style="background: rgb(221,251,251);
background: radial-gradient(circle, rgba(221,251,251,1) 7%, rgba(241,210,215,0.34775908654477417) 76%);">
                <h4>Appointment Doc List </h4>
                <a href="appointment_members.php" class="apply-btn">View Now</a>
            </div>
			
			
			 
        </div>
		
    </div>
                                </div>
                            </div>
							
                        </div> 

                    </div>                  
                </div>
              
                
                </div>
                <!-- END: Card DATA-->
            </div>
        </main>
        <!-- END: Content-->

      
        <!-- START: Back to top-->
        <a href="#" class="scrollup text-center"> 
            <i class="icon-arrow-up"></i>
        </a>
        <!-- END: Back to top-->

      


        <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
       
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->        
        <script src="dist/js/datatable.script.js"></script>
		
    </body>
 
</html>