= ?";
$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();
// Build filter description
$filter_desc = [];
if ($filter_status) $filter_desc[] = "Status: $filter_status";
if ($filter_industry) $filter_desc[] = "Industry: $filter_industry";
if ($filter_from_date) $filter_desc[] = "From: $filter_from_date";
if ($filter_to_date) $filter_desc[] = "To: $filter_to_date";
if ($filter_min_loi) $filter_desc[] = "Min LOI: {$filter_min_loi}min";
if ($filter_max_loi) $filter_desc[] = "Max LOI: {$filter_max_loi}min";
$filter_text = empty($filter_desc) ? 'All Projects' : implode(' | ', $filter_desc);
?>
Projects Export
Filters Applied:
No projects match the selected filters.
| Project ID |
Name |
Ref |
Industry |
Status |
eLOI |
Sample |
Deadline |
Created |
'#0066cc',
'Targeted' => '#ffc107',
'Live' => '#28a745',
'On hold' => '#dc2626',
'Closed' => '#666'
];
$color = $status_colors[$project['status']] ?? '#666';
?>
|
|
|
|
|
|
min |
|
|
|