<?php 
$_SESSION['active'] = 'contactReport';
include 'header.php';
include 'sidelinks.php';
include 'functions.php';

   
$contact_selectAll = contact_selectAll();
 
?> 

<div class="content-wrapper">
<div class="container-xxl flex-grow-1 container-p-y">
	 <h4 class="fw-bold py-3 mb-4">Contact Report</h4>
	 <div class="row">
	 	<div class="col-xxl">
	 		 <div class="card mb-6">
	 		 	 <div class="card-header d-flex align-items-center justify-content-between">
		            <h5 class="mb-0">Reports</h5>
		            <small class="text-muted float-end">Default label</small>
                 </div>
                 <div class="card-body">
                 	  <div align="center" style="display: none;" id="delete">
            	 <h4 style="color:red;">Contact Data Deleted Successfully </h4>
            </div>
                 	<div>
                 		<table class="table" style="width:100%;">
                 			<thead class="card-body">
	                 			<tr>
	                 				<td>#</td>
	                 				<th width="15%;">Name</th>
	                 				<th width="15%;">MailID</th>
	                 				<th width="15%;">Subject</th>
	                 				<th width="15%;">Message</th>
	                 				<th width="15%;">Action</th>
	                 			</tr>
                 			</thead>
                 			<tbody>
                 					<?php
                 				  $i=1;
                                  while($row = mysqli_fetch_array($contact_selectAll)){
                 				?>
                 				<tr>
                 					<td><?= $i?></td>
                 						<td><?= strtoupper($row['name'])?></td>
                 				<td><?= strtoupper($row['mailID'])?></td>
                 				<td><?= strtoupper($row['subject'])?></td>
                 				<td><?= strtoupper($row['message'])?></td>
                 					<td>
                 						
                 						<a href="javascript:void();" onclick="confirmDelete(<?= $row['id']?>)" class="btn btn-danger">Delete</a>
                 					</td>
                 				</tr>
                 				<?php
                 				  $i++;
                                   }
                 				?>
                 				</tr>
                 			</tbody>
                 			
                 		</table>
                      <div class="table-responsive">
            </div>
                 	</div>
                 </div>
	 		 </div>
	 	</div>
	 </div>
</div>

 <?php
include 'footer.php';
?>

<script>
       function confirmDelete(contactid)
       {
        
          if (contactid != '') {
            var x = confirm('Are you sure to Delete?');
          if(x){
          $.ajax({
            url : "delete.php",
            data :  {contactid : contactid},
            type : 'POST',
            success : function(response) {
              if(response ==1){
               $('#delete').show();
               $('#update').hide();
                window.location.href = "contact_report.php";
              }
                
               
            }
        });
        }
       }
     }
    </script>