project_delete.php

<?php
// Include database connection and authentication
require_once 'includes/db_connect.php';
require_once 'includes/domain_utils.php';
require_once 'includes/auth_check.php';

// Ensure only faculty can access this page
requireFaculty();

// Initialize variables
$error = '';
$domainNumber = isset($_GET['domain']) ? intval($_GET['domain']) : 0;
$projectId = isset($_GET['id']) ? intval($_GET['id']) : 0;
$confirm = isset($_GET['confirm']) && $_GET['confirm'] === 'yes';
$projectName = '';
$domainTable = "domain_" . $domainNumber;

// Get domain descriptions
$domainDescriptions = getDomainDescriptions($conn);
$domainDescription = isset($domainDescriptions[$domainNumber]) ? $domainDescriptions[$domainNumber] : "Domain $domainNumber";

// Check if the domain and project ID are provided
if ($domainNumber <= 0 || $projectId <= 0) {
    $error = "Invalid domain or project ID.";
} else {
    // Check if the domain table exists
    $tableCheckQuery = "SHOW TABLES LIKE '$domainTable'";
    $tableExists = $conn->query($tableCheckQuery)->num_rows > 0;
    
    if (!$tableExists) {
        $error = "Domain table does not exist.";
    } else {
        // Get project name field for this domain
        $projectNameField = getProjectNameField($conn, $domainTable);
        
        // Get the project details
        $projectQuery = "SELECT `$projectNameField` FROM $domainTable WHERE Project_ID = ? LIMIT 1";
        $stmt = $conn->prepare($projectQuery);
        
        if ($stmt) {
            $stmt->bind_param('i', $projectId);
            $stmt->execute();
            $result = $stmt->get_result();
            
            if ($result && $result->num_rows > 0) {
                $project = $result->fetch_assoc();
                $projectName = $project[$projectNameField];
                
                // If confirmed, delete the project
                if ($confirm) {
                    $deleteQuery = "DELETE FROM $domainTable WHERE Project_ID = ?";
                    $deleteStmt = $conn->prepare($deleteQuery);
                    
                    if ($deleteStmt) {
                        $deleteStmt->bind_param('i', $projectId);
                        
                        if ($deleteStmt->execute()) {
                            // Redirect to project management page with success message
                            header("Location: project_manage.php?deleted=1&project=" . urlencode($projectName));
                            exit;
                        } else {
                            $error = "Error deleting project: " . $deleteStmt->error;
                        }
                        
                        $deleteStmt->close();
                    } else {
                        $error = "Error preparing delete query: " . $conn->error;
                    }
                }
            } else {
                $error = "Project not found.";
            }
            
            $stmt->close();
        } else {
            $error = "Error preparing query: " . $conn->error;
        }
    }
}

// Include header
include 'includes/header.php';
?>

<div class="row mb-4">
    <div class="col-md-12">
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                <li class="breadcrumb-item"><a href="project_manage.php">Manage Projects</a></li>
                <li class="breadcrumb-item active">Delete Project</li>
            </ol>
        </nav>
        <h2><i class="fas fa-trash-alt me-2"></i> Delete Project</h2>
    </div>
</div>

<?php if (!empty($error)): ?>
<div class="alert alert-danger">
    <i class="fas fa-exclamation-circle me-2"></i> <?php echo $error; ?>
    <div class="mt-3">
        <a href="project_manage.php" class="btn btn-primary">
            <i class="fas fa-arrow-left me-1"></i> Back to Project Management
        </a>
    </div>
</div>
<?php elseif (!$confirm): ?>
<div class="row">
    <div class="col-md-8 mx-auto">
        <div class="card shadow-sm border-danger">
            <div class="card-header bg-danger text-white">
                <h5 class="mb-0"><i class="fas fa-exclamation-triangle me-2"></i> Confirm Deletion</h5>
            </div>
            <div class="card-body">
                <p class="alert alert-warning">
                    <i class="fas fa-exclamation-circle me-2"></i> <strong>Warning:</strong> You are about to delete the following project:
                </p>
                
                <div class="card mb-4">
                    <div class="card-body">
                        <h5 class="card-title"><?php echo htmlspecialchars($projectName); ?></h5>
                        <p class="card-text">
                            <strong>Domain:</strong> <?php echo htmlspecialchars("Domain $domainNumber: $domainDescription"); ?>
                        </p>
                        <p class="card-text">
                            <strong>Project ID:</strong> <?php echo $projectId; ?>
                        </p>
                    </div>
                </div>
                
                <p class="text-danger"><strong>This action cannot be undone.</strong> Are you sure you want to delete this project?</p>
                
                <div class="d-flex justify-content-between mt-4">
                    <a href="project_manage.php" class="btn btn-secondary">
                        <i class="fas fa-times me-1"></i> Cancel
                    </a>
                    <a href="project_delete.php?domain=<?php echo urlencode($domainNumber); ?>&id=<?php echo urlencode($projectId); ?>&confirm=yes" class="btn btn-danger">
                        <i class="fas fa-trash-alt me-1"></i> Yes, Delete Project
                    </a>
                </div>
            </div>
        </div>
    </div>
</div>
<?php endif; ?>

<?php
// Include footer
include 'includes/footer.php';

// Close connection
$conn->close();
?>