prepare(" SELECT status FROM projects WHERE id = ? AND client_id = ? "); $checkStmt->execute([$project_id, $_SESSION['client_id']]); $project = $checkStmt->fetch(); if ($project && $project['status'] !== 'Live') { $deleteStmt = $pdo->prepare("DELETE FROM projects WHERE id = ?"); $deleteStmt->execute([$project_id]); $success = 'Project deleted successfully.'; } else { $error = 'Cannot delete this project. Live projects cannot be deleted.'; } } // Get filter values $filter_status = $_GET['status'] ?? ''; $filter_industry = $_GET['industry'] ?? ''; $filter_from_date = $_GET['from_date'] ?? ''; $filter_to_date = $_GET['to_date'] ?? ''; $filter_min_loi = $_GET['min_loi'] ?? ''; $filter_max_loi = $_GET['max_loi'] ?? ''; // Build query with filters $query = "SELECT * FROM projects WHERE client_id = ?"; $params = [$_SESSION['client_id']]; if ($filter_status) { $query .= " AND status = ?"; $params[] = $filter_status; } if ($filter_industry) { $query .= " AND industry = ?"; $params[] = $filter_industry; } if ($filter_from_date) { $query .= " AND DATE(created_at) >= ?"; $params[] = $filter_from_date; } if ($filter_to_date) { $query .= " AND DATE(created_at) <= ?"; $params[] = $filter_to_date; } if ($filter_min_loi) { $query .= " AND eloi >= ?"; $params[] = intval($filter_min_loi); } if ($filter_max_loi) { $query .= " AND eloi <= ?"; $params[] = intval($filter_max_loi); } $query .= " ORDER BY created_at DESC"; $stmt = $pdo->prepare($query); $stmt->execute($params); $projects = $stmt->fetchAll(); // Get industries for filter $industriesStmt = $pdo->query("SELECT DISTINCT industry FROM projects WHERE client_id = " . $_SESSION['client_id'] . " ORDER BY industry"); $industries = $industriesStmt->fetchAll(); include 'client-portal-header.php'; ?>

Projects

Manage your survey projects

+ Create New Project
✅
⚠️

🔍 Filters

Clear
📄 Export Filtered Projects (PDF)

Projects ()

📁

No projects found

Create your first project to get started!

+ Create Project
'#0066cc', 'Targeted' => '#ffc107', 'Live' => '#28a745', 'On hold' => '#dc2626', 'Closed' => '#666' ]; $status_color = $status_colors[$project['status']] ?? '#666'; $is_live = $project['status'] === 'Live'; ?>
Project ID Name Industry Status eLOI Sample Deadline Actions

Ref: 		min
👁️ ✏️ 🗑️ ✏️ 🗑️ 📄