<?php

include("inc/config.php");

if(isset($_POST['add_project'])){
    $project_name = $_POST['project_name'];
    $project_cost = $_POST['project_cost'];
  
   

    // Sanitize input data (for example, you can use mysqli_real_escape_string)
    $project_name = mysqli_real_escape_string($conn, $project_name);
    $project_cost = mysqli_real_escape_string($conn, $project_cost);
   
   

  

    // Construct the SQL query with sanitized input data

    $query = "INSERT INTO `projects` (`project_name`, `project_cost`) VALUES ('$project_name', '$project_cost')";

   
    $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'];
    $project_cost = $_POST['project_cost'];
    $project_status = $_POST['project_status'];



    // Update the project information in the database
    $query = "UPDATE projects 
              SET project_name='$project_name',
              project_cost='$project_cost',
               project_status='$project_status'
              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'];

    // Update the status of the project to "Complete"
    $query = "UPDATE projects SET project_status = 'Complete' WHERE id = '$project_id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        // Redirect back to the projects page with a success message
        header("Location: view-project.php?status=success");
        exit();
    } else {
        // Redirect back to the projects page with an error message
        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');
    }
}

?>