project_manage.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 = '';
$success = '';
$domain_tables = getDomainTables($conn);

// Check if project was deleted
if (isset($_GET['deleted']) && $_GET['deleted'] === '1' && isset($_GET['project'])) {
    $success = "Project '" . htmlspecialchars($_GET['project']) . "' has been deleted successfully.";
}

// Handle delete request
if (isset($_GET['action']) && $_GET['action'] === 'delete' && isset($_GET['domain']) && isset($_GET['id'])) {
    $domainNumber = intval($_GET['domain']);
    $projectId = intval($_GET['id']);
    
    // Redirect to the delete confirmation page
    header("Location: project_delete.php?domain=" . urlencode($domainNumber) . "&id=" . urlencode($projectId));
    exit;
}

// Search and filtering
$search = isset($_GET['search']) ? trim($_GET['search']) : '';
$domain_filter = isset($_GET['domain']) ? intval($_GET['domain']) : 0;
$type_filter = isset($_GET['type']) ? trim($_GET['type']) : '';

// Pagination
$page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$per_page = 10;
$offset = ($page - 1) * $per_page;

// Get all projects across domains
$projects = [];
$total_count = 0;

foreach ($domain_tables as $domain_id => $domain_table) {
    // Skip if domain filter is set and doesn't match
    if ($domain_filter > 0 && $domain_id != $domain_filter) {
        continue;
    }
    
    // Get project name field for this domain
    $projectNameField = getProjectNameField($conn, $domain_table);
    
    // Build the query
    $query = "SELECT *, '$domain_id' as domain_number FROM $domain_table";
    $where_clauses = [];
    $params = [];
    $types = '';
    
    // Add search condition if search term is provided
    if (!empty($search)) {
        $where_clauses[] = "(`$projectNameField` LIKE ? OR `Description` LIKE ?)";
        $search_param = "%$search%";
        $params[] = $search_param;
        $params[] = $search_param;
        $types .= 'ss';
    }
    
    // Add type filter if provided
    if (!empty($type_filter)) {
        $where_clauses[] = "`H/S` = ?";
        $params[] = $type_filter;
        $types .= 's';
    }
    
    // Finalize the query
    if (!empty($where_clauses)) {
        $query .= " WHERE " . implode(' AND ', $where_clauses);
    }
    
    // First, get the total count for this domain
    $count_query = str_replace("SELECT *, '$domain_id' as domain_number", "SELECT COUNT(*)", $query);
    $count_stmt = $conn->prepare($count_query);
    
    if ($count_stmt) {
        if (!empty($params)) {
            $count_stmt->bind_param($types, ...$params);
        }
        $count_stmt->execute();
        $count_result = $count_stmt->get_result();
        $count_row = $count_result->fetch_row();
        $total_count += $count_row[0];
        $count_stmt->close();
    }
    
    // Now get the actual projects
    $query .= " ORDER BY Project_ID DESC";
    $stmt = $conn->prepare($query);
    
    if ($stmt) {
        if (!empty($params)) {
            $stmt->bind_param($types, ...$params);
        }
        $stmt->execute();
        $result = $stmt->get_result();
        
        while ($row = $result->fetch_assoc()) {
            $row['domain_table'] = $domain_table;
            $row['projectNameField'] = $projectNameField;
            $projects[] = $row;
        }
        
        $stmt->close();
    }
}

// If domain filter is active, we need to adjust pagination
$total_pages = ceil($total_count / $per_page);

// Sort projects by most recent (assuming Project_ID increases with newer projects)
usort($projects, function($a, $b) {
    return $b['Project_ID'] - $a['Project_ID'];
});

// Apply pagination
$paginated_projects = array_slice($projects, $offset, $per_page);

// Get domain descriptions
$domainDescriptions = getDomainDescriptions($conn);

// 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 active">Manage Projects</li>
            </ol>
        </nav>
        <div class="d-flex justify-content-between align-items-center">
            <h2><i class="fas fa-tasks me-2"></i> Manage Projects</h2>
            <a href="project_add.php" class="btn btn-primary">
                <i class="fas fa-plus-circle me-1"></i> Add New Project
            </a>
        </div>
    </div>
</div>

<?php if (!empty($success)): ?>
<div class="alert alert-success">
    <i class="fas fa-check-circle me-2"></i> <?php echo $success; ?>
</div>
<?php endif; ?>

<?php if (!empty($error)): ?>
<div class="alert alert-danger">
    <i class="fas fa-exclamation-circle me-2"></i> <?php echo $error; ?>
</div>
<?php endif; ?>

<div class="card shadow-sm mb-4">
    <div class="card-header bg-light">
        <h5 class="mb-0"><i class="fas fa-filter me-2"></i> Search and Filter</h5>
    </div>
    <div class="card-body">
        <form method="get" action="project_manage.php" class="row g-3">
            <div class="col-md-4">
                <label for="search" class="form-label">Search</label>
                <div class="input-group">
                    <input type="text" class="form-control" id="search" name="search" 
                           placeholder="Search by name or description" value="<?php echo htmlspecialchars($search); ?>">
                    <button class="btn btn-outline-secondary" type="submit">
                        <i class="fas fa-search"></i>
                    </button>
                </div>
            </div>
            
            <div class="col-md-4">
                <label for="domain" class="form-label">Domain</label>
                <select class="form-select" id="domain" name="domain">
                    <option value="0">All Domains</option>
                    <?php foreach ($domain_tables as $id => $table): ?>
                        <?php $desc = isset($domainDescriptions[$id]) ? $domainDescriptions[$id] : "Domain $id"; ?>
                        <option value="<?php echo $id; ?>" <?php echo ($domain_filter == $id) ? 'selected' : ''; ?>>
                            Domain <?php echo $id; ?>: <?php echo htmlspecialchars($desc); ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>
            
            <div class="col-md-3">
                <label for="type" class="form-label">Project Type</label>
                <select class="form-select" id="type" name="type">
                    <option value="">All Types</option>
                    <option value="Hardware" <?php echo ($type_filter === 'Hardware') ? 'selected' : ''; ?>>Hardware</option>
                    <option value="Software" <?php echo ($type_filter === 'Software') ? 'selected' : ''; ?>>Software</option>
                </select>
            </div>
            
            <div class="col-md-1 d-flex align-items-end">
                <?php if (!empty($search) || $domain_filter > 0 || !empty($type_filter)): ?>
                    <a href="project_manage.php" class="btn btn-outline-secondary">
                        <i class="fas fa-times"></i> Clear
                    </a>
                <?php endif; ?>
            </div>
        </form>
    </div>
</div>

<div class="card shadow-sm">
    <div class="card-header bg-light d-flex justify-content-between align-items-center">
        <h5 class="mb-0"><i class="fas fa-clipboard-list me-2"></i> Projects</h5>
        <span class="badge bg-primary rounded-pill"><?php echo $total_count; ?> Projects</span>
    </div>
    <div class="card-body">
        <?php if (empty($paginated_projects)): ?>
            <div class="alert alert-info">
                <i class="fas fa-info-circle me-2"></i> No projects found matching your criteria. Try different search parameters or <a href="project_add.php" class="alert-link">add a new project</a>.
            </div>
        <?php else: ?>
            <div class="table-responsive">
                <table class="table table-hover">
                    <thead class="table-light">
                        <tr>
                            <th>ID</th>
                            <th>Domain</th>
                            <th>Project Name</th>
                            <th>Type</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($paginated_projects as $project): ?>
                            <?php 
                                $domain_id = $project['domain_number'];
                                $projectName = $project[$project['projectNameField']];
                                $domainDesc = isset($domainDescriptions[$domain_id]) ? $domainDescriptions[$domain_id] : "Domain $domain_id";
                            ?>
                            <tr>
                                <td><?php echo $project['Project_ID']; ?></td>
                                <td>
                                    <span class="badge bg-secondary">Domain <?php echo $domain_id; ?></span>
                                    <small class="d-block text-muted"><?php echo htmlspecialchars($domainDesc); ?></small>
                                </td>
                                <td><?php echo htmlspecialchars($projectName); ?></td>
                                <td>
                                    <?php if (isset($project['H/S'])): ?>
                                        <?php if ($project['H/S'] === 'Hardware'): ?>
                                            <span class="badge bg-danger">Hardware</span>
                                        <?php elseif ($project['H/S'] === 'Software'): ?>
                                            <span class="badge bg-success">Software</span>
                                        <?php else: ?>
                                            <span class="badge bg-secondary"><?php echo htmlspecialchars($project['H/S']); ?></span>
                                        <?php endif; ?>
                                    <?php else: ?>
                                        <span class="badge bg-secondary">N/A</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <div class="btn-group btn-group-sm" role="group">
                                        <a href="project_details.php?domain=<?php echo urlencode($domain_id); ?>&id=<?php echo urlencode($project['Project_ID']); ?>" class="btn btn-outline-primary" title="View Project">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                        <a href="project_edit.php?domain=<?php echo urlencode($domain_id); ?>&id=<?php echo urlencode($project['Project_ID']); ?>" class="btn btn-outline-success" title="Edit Project">
                                            <i class="fas fa-edit"></i>
                                        </a>
                                        <a href="project_delete.php?domain=<?php echo urlencode($domain_id); ?>&id=<?php echo urlencode($project['Project_ID']); ?>" class="btn btn-outline-danger" title="Delete Project">
                                            <i class="fas fa-trash-alt"></i>
                                        </a>
                                    </div>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
            
            <?php if ($total_pages > 1): ?>
                <nav aria-label="Page navigation" class="mt-4">
                    <ul class="pagination justify-content-center">
                        <li class="page-item <?php echo ($page <= 1) ? 'disabled' : ''; ?>">
                            <a class="page-link" href="<?php echo ($page <= 1) ? '#' : "project_manage.php?page=" . ($page - 1) . "&search=" . urlencode($search) . "&domain=" . urlencode($domain_filter) . "&type=" . urlencode($type_filter); ?>">
                                <i class="fas fa-chevron-left"></i> Previous
                            </a>
                        </li>
                        
                        <?php for ($i = max(1, $page - 2); $i <= min($total_pages, $page + 2); $i++): ?>
                            <li class="page-item <?php echo ($i == $page) ? 'active' : ''; ?>">
                                <a class="page-link" href="project_manage.php?page=<?php echo $i; ?>&search=<?php echo urlencode($search); ?>&domain=<?php echo urlencode($domain_filter); ?>&type=<?php echo urlencode($type_filter); ?>">
                                    <?php echo $i; ?>
                                </a>
                            </li>
                        <?php endfor; ?>
                        
                        <li class="page-item <?php echo ($page >= $total_pages) ? 'disabled' : ''; ?>">
                            <a class="page-link" href="<?php echo ($page >= $total_pages) ? '#' : "project_manage.php?page=" . ($page + 1) . "&search=" . urlencode($search) . "&domain=" . urlencode($domain_filter) . "&type=" . urlencode($type_filter); ?>">
                                Next <i class="fas fa-chevron-right"></i>
                            </a>
                        </li>
                    </ul>
                </nav>
            <?php endif; ?>
        <?php endif; ?>
    </div>
</div>

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

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