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

  <script>
setTimeout(function(){ 
    $('#myData').hide();
}, 3000);
</script>
        <!-- START: Template CSS-->
        <link rel="stylesheet" href="dist/vendors/bootstrap/css/bootstrap.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.min.css">
        <link rel="stylesheet" href="dist/vendors/jquery-ui/jquery-ui.theme.min.css">
        <link rel="stylesheet" href="dist/vendors/simple-line-icons/css/simple-line-icons.css">        
        <link rel="stylesheet" href="dist/vendors/flags-icon/css/flag-icon.min.css"> 
        <link rel="stylesheet" href="dist/vendors/flag-select/css/flags.css">
        <!-- END Template CSS-->   

        <!-- START: Page CSS-->
        <link rel="stylesheet" href="dist/vendors/quill/quill.snow.css" />
        <!-- END: Page CSS-->

        <!-- START: Custom CSS-->
        <link rel="stylesheet" href="dist/css/main.css">
        <!-- END: Custom CSS-->
  


        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
    

							
                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-12 mt-3">
                       <div class="card">
    <div class="card-header justify-content-between align-items-center">
        <h4 class="card-title">Applied Members</h4>
		 <span style="float:right"> <a href="job_fair.php">Back to page </a></span>
        <span>
            <input type="text" name="search" class="form-control" id="search" style="font-size:23px;" placeholder="Search by Name, Post, or Status" oninput="fetchResults()">
        </span>
		
    </div>
    <div class="card-body">
        <div class="table-responsive">
            <table id="example" class="display table dataTable table-striped table-bordered">
                <thead>
                    <tr>
                        <th>Sr.</th>
                        <th>Apply Date</th>
                        <th>Apply Post</th>
                        <th>Applicant Name</th>
                      
                        <th>Contact</th>
                        <th>View</th>
                        <th>Action</th>
                      
                    </tr>
                </thead>
                <tbody id="result-body">
    <?php
    error_reporting(0);
    include("config.php");
    $query = "SELECT * FROM applications ORDER BY id DESC";
    $result = $conn->query($query);
    $count = 0;

    while ($meta = mysqli_fetch_assoc($result)) {
        $count++;
        $jid = $meta['appjob_id'];
        $q = "SELECT * FROM vacancy WHERE id='$jid'";
        $r = $conn->query($q);
        $m = mysqli_fetch_assoc($r);
    ?>
        <tr>
            <td><?php echo $count; ?></td>
            <td><?php echo date('d  M  Y', strtotime($meta['appliaction_date'])); ?></td>
           <!-- <td>
                <b><?php echo ucfirst($m['job_post']); ?></b><br>
                <small><?php echo ucfirst($m['salary']); ?> <?php echo ucfirst($m['salary_typ']); ?></small>
            </td>-->
			 <td>
			 <?php echo ucfirst($meta['appjob_id']); ?>
			 <?php if($meta['postname2']!=""){?>
			 <br><?php echo ucfirst($meta['postname2']); ?>
			 <?php } ?>
			 <?php if($meta['postname3']!=""){?>
			 <br> <?php echo ucfirst($meta['postname3']); ?>
			  <?php } ?>
			 </td>
            <td><?php echo ucfirst($meta['applicant_name']); ?></td>
          
            <td><?php echo $meta['mobile']; ?> <br><?php echo $meta['alt_mobile']; ?></td>
            <td>
              
                    <a href="view_info.php?id=<?php echo $meta[id];?>">Manage Profile</a>
               
            </td>
            <td>
                <a class="btn3" title="delete" href="del_form.php?flag=del&id=<?php echo $meta['id']; ?>" onclick="return confirm('Do You Want To Delete This?');">
                    <center><i class="fa fa-trash icon-white"></i></center>
                </a>
            </td>
           
        </tr>
    <?php } ?>
</tbody>

         
<script>
    function fetchResults() {
        const searchValue = document.getElementById("search").value;

        // Create an AJAX request
        const xhr = new XMLHttpRequest();
        xhr.open("POST", "search.php", true);
        xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");

        xhr.onload = function () {
            if (xhr.status === 200) {
                // Update the table body with the returned data
                document.getElementById("result-body").innerHTML = xhr.responseText;
            } else {
                console.error("Error fetching data");
            }
        };

        // Send the search value to the server
        xhr.send("query=" + encodeURIComponent(searchValue));
    }
</script>                   
                                    </table>
                                </div>
                            </div>
                        </div> 

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

      
      
        <!-- 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/quill/quill.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->
        <script src="dist/js/mail.script.js"></script>
        <!-- END: Page Script JS-->
		<style>
		.btn5{
			padding:2px;
			background-color:#fc2210;
			color:#fff;
			border-radius:2px;
			padding-left:10px;padding-right:10px;
			border:2px solid #fc2210;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:220px;	
			
		}
		
		</style>
		
    </body>
   
</html>