<?php

include("inc/config.php");

if (isset($_POST['add_project'])) {
    $project_name = mysqli_real_escape_string($conn, $_POST['project_name']);
    $emp_id = mysqli_real_escape_string($conn, $_POST['emp_id']);
 
    $destination = mysqli_real_escape_string($conn, $_POST['destination']);

    // Check if at least one checkbox is selected
    if (!isset($_POST['category_id']) || empty($_POST['category_id'])) {
        echo "<script>alert('Please select at least one category.'); window.history.back();</script>";
        exit();
    }

    $category_ids = $_POST['category_id']; // Array of selected categories
    $category_json = json_encode($category_ids); // Convert array to JSON format

    $query = "INSERT INTO projects (project_name, destination, emp_id, category_ids) VALUES ('$project_name', '$destination', '$emp_id', '$category_json')";
    
    if (mysqli_query($conn, $query)) {
        echo "<script>
                alert('Project Added Successfully!');
                window.location.href = 'view-project.php';
              </script>";
        exit();
    } else {
        echo "<script>
                alert('Error: " . mysqli_error($conn) . "');
                window.history.back();
              </script>";
    }
}


// if(isset($_POST['add_project'])){
//     $project_name = $_POST['project_name'];
 
//     $project_start = $_POST['project_start'];
//     $emp_id = $_POST['emp_id'];
//     $category_id = $_POST['category_id'];
    

//     $project_name = mysqli_real_escape_string($conn, $project_name);
//     $project_start = mysqli_real_escape_string($conn, $project_start);
//     $emp_id = mysqli_real_escape_string($conn, $emp_id);
//     $category_id = mysqli_real_escape_string($conn, $category_id);


//     $query = "INSERT INTO `projects` (`project_name` , `project_start` , `emp_id` , `category_id`) VALUES ('$project_name', '$project_start' , '$emp_id' , '$category_id')";

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

//     if($query_run){
     
//         $_SESSION['status'] = "Data Uploaded Successfully";
//         header('Location: view-project.php');
//         exit;
//     } else {
//         $_SESSION['status'] = "Data Not Uploaded Successfully";
//         header('Location: project.php');
//         exit;
//     }
// }



if (isset($_POST['update_project'])) {
    $id = $_POST['id'];
    $project_name = $_POST['project_name'];
    $emp_id = $_POST['emp_id'];
    $project_status = $_POST['project_status'];
    $destination = $_POST['destination'];
    // $project_end = $_POST['project_end'];

    // Convert category_id array to JSON
    $category_ids = json_encode($_POST['category_id']);

    // Update the project information in the database
    $query = "UPDATE projects 
              SET project_name='$project_name',
                  emp_id='$emp_id',
                  category_ids='$category_ids', 
                  project_status='$project_status',
                  destination='$destination'
              WHERE id='$id'";

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

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


// if (isset($_POST['update_project'])) {
//     $id = $_POST['id'];
//     $project_name = $_POST['project_name'];

//     $emp_id = $_POST['emp_id'];
//     $category_id = $_POST['category_id'];

//     $project_status = $_POST['project_status'];
//     $project_start = $_POST['project_start'];
//     $project_end = $_POST['project_end'];

//         $query = "UPDATE projects 
//               SET project_name='$project_name',
//                emp_id='$emp_id',
//                 category_id='$category_id',
//                 project_status='$project_status',
//                 project_start='$project_start',
//                 project_end='$project_end'

//               WHERE id='$id'";

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

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



// if (isset($_POST['complete_project'])) {
//     $project_id = $_POST['project_id'];

 
//     $query = "UPDATE projects SET project_status = 'Complete' WHERE id = '$project_id'";
//     $query_run = mysqli_query($conn, $query);

//     if ($query_run) {
      
//         header("Location: view-project.php?status=success");
//         exit();
//     } else {
       
//         header("Location: view-project.php?status=error");
//         exit();
//     }
// } else {
//     header("Location: view-project.php");
//     exit();
// }




// delete

if (isset($_POST['delete_project'])) {

    $id = $_POST['delete_id'];
    $query = "DELETE FROM `projects` WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Deleted Successfully";
        header('Location: view-project.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        header('Location: view-project.php');
    }
}

?>