<?php 
$_SESSION['active'] = 'projectReport';
include 'header.php';
include 'sidelinks.php';
include 'functions.php';
$project_selectAll = project_selectAll();
?> 

<div class="content-wrapper">
<div class="container-xxl flex-grow-1 container-p-y">
	 <h4 class="fw-bold py-3 mb-4">Projects 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 id="update">
                 	<?php
                   if(!empty($_GET['upd'])){
                 ?>
			     <div align="center">
			      <h4 style="color:green;">Project Data Updated Successfully </h4>
			    </div>
              <?php
                }
                ?>
            </div>
            <div align="center" style="display: none;" id="delete">
            	 <h4 style="color:red;">Project Data Deleted Successfully </h4>
            </div>
                 	<div>
                 		<table class="table">
                 			<thead>
	                 			<tr>
	                 				<td>#</td>
	                 				<th>Image</th>
	                 				<td>Name</td>
	                 				
	                 				<th>Action</th>
	                 			</tr>
                 			</thead>
                 			<tbody>
                 				<?php
                 				  $i=1;
                                  while($row = mysqli_fetch_array($project_selectAll)){
                 				?>
                 				<tr>
                 					<td><?= $i?></td>
                 					<td><img src="<?= $row['image']?>" style="width:50px; height: 5vh;"></td>
                 					<td><?= strtoupper($row['name'])?></td>
                 				
                 					<td>
                 						<a href="project_edit.php?edit=<?= $row['id']?>" class="btn btn-primary">Edit</a>
                 						<a href="javascript:void();" onclick="confirmDelete(<?= $row['id']?>)" class="btn btn-danger">Delete</a>
                 					</td>
                 				</tr>
                 				<?php
                 				  $i++;
                                   }
                 				?>
                 			</tbody>
                 			
                 		</table>
                 	</div>
                 </div>
	 		 </div>
	 	</div>
	 </div>
</div>

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

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