<?php

session_start();
include("includes/config.php");

if(isset($_POST['add_team'])){
 
    $title = $_POST['title'];
    $position = $_POST['position'];
    $photo = $_FILES['photo']['name'];


    $allowed_image_extensions = array('gif','png','jpg','jpeg','webp','WEBP');


    $photo_filename = $_FILES['photo']['name'];
    $photo_file_extension = pathinfo($photo_filename, PATHINFO_EXTENSION);


    if(!in_array($photo_file_extension, $allowed_image_extensions)){
        $_SESSION['status'] = "The image file is not allowed. Please upload an image.";
        header('Location: team.php');
        exit;

    } else {
   
        $query = "INSERT INTO team (title, position, photo) VALUES ('$title','$position','$photo')";
        $query_run = mysqli_query($conn, $query);

        if($query_run){
            move_uploaded_file($_FILES["photo"]["tmp_name"], "team/".$_FILES["photo"]["name"]);
            $_SESSION['status'] = "Uploaded Successfully";
            header('Location: view-team.php');
            exit;
        } else {
            $_SESSION['status'] = "Not Uploaded ";
            header('Location: team.php');
            exit;
        }
    }
}


// update 
if(isset($_POST['update_team'])){
    $id = $_POST['id'];
    $title = $_POST['title'];
    $position = $_POST['position'];

   
    $old_photo = $_POST['image_old'];
    $update_photo_filename = $_FILES["photo"]["name"] ? $_FILES["photo"]["name"] : $old_photo;



    $allowed_image_extensions = array('gif','png','jpg','jpeg','webp','WEBP');
 

    $photo_file_extension = pathinfo($update_photo_filename, PATHINFO_EXTENSION);
   
    if(!in_array($photo_file_extension, $allowed_image_extensions)){
        $_SESSION['status'] = "The image file is not allowed. Please upload an image.";
        header("Location: edit-team.php?id=$id"); 
        exit;
   
    }

    // Update the department information in the database
    $query = "UPDATE team SET title='$title', position='$position', photo='$update_photo_filename' WHERE id ='$id' ";

    $query_run = mysqli_query($conn, $query);

    if($query_run){
      
        if($_FILES["photo"]["name"] !='' && $_FILES["photo"]["name"] != $old_photo){
            move_uploaded_file($_FILES["photo"]["tmp_name"], "team/".$_FILES["photo"]["name"]);
            unlink("team/". $old_photo);    
        }

     

        $_SESSION['status'] = "Updated Successfully";
        header('Location: view-team.php');
    } else {
        $_SESSION['status'] = "Not Updated";
        header('Location: view-team.php');
    }
}

// delete

if(isset($_POST['delete_team'])){
    $id = $_POST['delete_id'];
    $photo = $_POST['del_team'];
   

    $query = "DELETE FROM team WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if($query_run){
        if(unlink("team/".$photo)) {
            $_SESSION['status'] = "Deleted Successfully";
            header('Location: view-team.php');
        } else {
            $_SESSION['status'] = "Error deleting files";
            header('Location: view-team.php');
        }
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        header('Location: view-team.php');
    }
}
?>