<?php include('config.php');
include('checksession.php');

include('include/header.php');
?>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper">
      <!-- Main content -->
      <section class="content">
         <div class="container-fluid">
         <div class="row">
            <div class="col-12">
               <div class="card card-primary">
                  <div class="card-header">
                     <h4 class="card-title">All Project <a href="add_project.php"  class="btn btn-tool btn-danger"  style="background:rgb(203, 114, 13); margin:0 0 0 30px; border:none;">
                        Add Project</a></h4>
                     <div class="card-tools">
                        <button type="button" class="btn btn-tool" data-card-widget="collapse" title="Collapse">
                        <i class="fas fa-minus"></i>
                        </button>
                        <button type="button" class="btn btn-tool" data-card-widget="remove" title="Remove">
                        <i class="fas fa-times"></i>
                        </button>
                     </div>
                  </div>
                  <div class="card-body p-0">
                     <table class="table table-striped projects"  id="example4">
                        <thead>
                           <tr>
                              <th style="width: 10%">
                                  Sl No
                              </th>
                              <th style="width: 25%">
                                 Project Name
                              </th>
                               
                              <th style="width: 20%">
                                 Status
                              </th>
                              
                              <th style="width: 20%">
                                  Action
                              </th>
                           </tr>
                        </thead>
                        <tbody>
                            <?php 
                            $i=1;
                            $query=mysqli_query($conn,"select * from  tbl_projects order by id desc");
                            while($row=mysqli_fetch_array($query)){ 
                          
                            ?>
                           <tr id="tr_<?=$row['id'];?>">
                              <td>
                               <?=$i;?>
                              </td>
                              <td>
                                
                                <?=$row['name'];?>
                                
                              </td>
                              
                            
                             
                              <td class="project_progress">
                                  <select class="form-control" id="stat<?=$row['id'];?>" onchange="change_status(<?=$row['id'];?>)">
                                      <option value="1" <?php if($row['status']==1){ echo 'selected';} ?>>Ongoing</option>
                                      <option value="2" <?php if($row['status']==2){ echo 'selected';} ?>>Upcoming</option>
                                      <option value="3" <?php if($row['status']==3){ echo 'selected';} ?>>Delivered</option>
                                  </select>
                              </td>
                              
                              <td class="project-actions text-right">
                                 <a class="btn btn-info btn-sm" href="edit_project.php?id=<?=$row['id'];?>">
                                 <i class="fas fa-pencil-alt">
                                 </i>
                                 Edit
                                 </a>
                                 <a class="btn btn-danger btn-sm" href="javascript:void(0);" onclick="delete_news(<?=$row['id'];?>)">
                                 <i class="fas fa-trash">
                                 </i>
                                 Delete
                                 </a>
                              </td>
                           </tr>
                           
                           <?php 
                           $i++;
                           } ?>
                           
                        </tbody>
                     </table>
                  </div>
                  <!-- /.card-body -->
               </div>
               <!-- /.card -->
      </section>
      <!-- Main content -->
      </div>
      <!-- /.content-wrapper -->
<?php include('include/footer.php'); ?>
      <script>
         $(function () {
           $("#example1").DataTable({
             "responsive": true, "lengthChange": false, "autoWidth": false,
             "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
           }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
           $('#example4').DataTable({
             "paging": true,
             "lengthChange": false,
             "searching": false,
             "ordering": true,
             "info": true,
             "autoWidth": false,
             "responsive": true,
           });
         });
         
         
         function delete_news(id){
          var result = confirm("Want to delete this project?");
            if (result) {
                $.ajax({

                            url: 'allajax.php',
                            type:'POST',
                            data: ({ 
                            action: 'delete_project',
                            'id' :id
                            }),
                          success:function(result){
                            
                            console.log(result);
                            $("#tr_"+id).hide();
                           if(result==1){
                               alert('Project deleted successfully.');
                               
                           }
                            
                            
                               }
                             });  
            }else{
                return false;
            }   
                     }
                     
                     
    function change_position(id,pos) {
     var position=$("#position_change_"+id).val();
     //alert(position);
     if(position==''){
         alert('Please chose a position first.');
         $("#position_change_"+id).val(pos);
     }else{
        $.ajax({

                            url: 'allajax.php',
                            type:'POST',
                            data: ({ 
                            action: 'change_position',
                            'pro_id' :id,
                            'position':position
                            }),
                          success:function(result){
                            
                            console.log(result);
                           
                           if(result==1){
                               alert('Position changed successfully.');
                               //window.location.href='allproject.php';
                               
                           }
                            
                            
                               }
                             });   
     }
    }
    
    function change_status(id){
     var stat=$("#stat"+id).val();
      var result = confirm("Want to change the project status?");
            if (result) {
                $.ajax({

                            url: 'allajax.php',
                            type:'POST',
                            data: ({ 
                            action: 'change_project_status',
                            'id' :id,
                            'stat':stat
                            }),
                          success:function(result){
                            
                            console.log(result);
                          
                           if(result==1){
                               alert('Project status changed successfully.');
                               window.location.reload();
                               
                           }
                            
                            
                               }
                             });  
            }else{
                return false;
            }
    }
      </script>
   </body>
</html>