<?php

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


// <?php
if (isset($_POST['add_partner'])) {
  
    $image = $_FILES['photo']['name'];
    $target_dir = "partner/";
    $target_file = $target_dir . basename($image);
    move_uploaded_file($_FILES['photo']['tmp_name'], $target_file);

    // Get Selected Categories
    $category = isset($_POST['category']) ? implode(',', $_POST['category']) : '';

    // Insert Data into Database
    $sql = "INSERT INTO partners (photo, category) VALUES ('$image', '$category')";

    if (mysqli_query($conn, $sql)) {
        // echo "Partner added successfully!";
        $_SESSION['status'] = "Uploaded Successfully";
                header('Location: view-partner.php');
                  exit;
    } else {
        $_SESSION['status'] = "Not Uploaded ";
                    header('Location: partner.php');
                    exit;
    }

    mysqli_close($conn);
}



// if(isset($_POST['add_partner'])){

//     $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: partner.php');
//         exit;

//     } else {
   
//         $query = "INSERT INTO partners (photo) VALUES ('$photo')";
//         $query_run = mysqli_query($conn, $query);

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


// update 

if (isset($_POST['update_partner'])) {
    include 'db_connect.php';

    $id = $_POST['id'];

    // Handle Image Upload
    $image = $_FILES['photo']['name'];
    $image_old = $_POST['image_old'];
    $target_dir = "partner/";

    // Check if a new image is uploaded
    if (!empty($image)) {
        $target_file = $target_dir . basename($image);

        // Unlink (delete) old image if it exists
        if (!empty($image_old) && file_exists($target_dir . $image_old)) {
            unlink($target_dir . $image_old);
        }

        // Move the new image
        move_uploaded_file($_FILES['photo']['tmp_name'], $target_file);
    } else {
        $image = $image_old; // Keep the old image if no new file is uploaded
    }

    // Get Selected Categories
    $category = isset($_POST['category']) ? implode(',', $_POST['category']) : '';

    // Update Query
    $sql = "UPDATE partners SET photo='$image', category='$category' WHERE id='$id'";

    if (mysqli_query($conn, $sql)) {
              $_SESSION['status'] = "Updated Successfully";
        header('Location: view-partner.php');
    } else {
        $_SESSION['status'] = " Not Updated ";
        header('Location: view-partner.php');
    }

    mysqli_close($conn);
}


// if(isset($_POST['update_partner'])){
//     $id = $_POST['id'];
    
   
//     $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-partner.php?id=$id"); 
//         exit;
   
//     }

   
//     $query = "UPDATE partners SET 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"], "partner/".$_FILES["photo"]["name"]);
//             unlink("partner/". $old_photo);    
//         }

     

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

// delete

if(isset($_POST['delete_partner'])){
    $id = $_POST['delete_id'];
    $photo = $_POST['del_partner'];
   

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

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