<? $pageID = 'people'; ?>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/db-connection.php'; ?>
<?
// Get filters from query parameters
$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$personality_filters = isset($_GET['personality']) && is_array($_GET['personality']) ? $_GET['personality'] : [];
$match_all = isset($_GET['match_type']) ? $_GET['match_type'] === 'all' : false; // Default to "match any"
// Initialize role filter variables
$reader_filter = isset($_GET['reader']) ? true : false;
$author_filter = isset($_GET['author']) ? true : false;
// Initialize name filter variable
$name_filter = isset($_GET['name']) ? trim(htmlspecialchars($_GET['name'])) : '';
// Sanitize personality filters
$personality_filters = array_map('htmlspecialchars', $personality_filters);
$items_per_page = 20;
$offset = ($current_page - 1) * $items_per_page;
// Get total people count and filtered people
$pdo = getDbConnection();
$reader_count = $pdo->query("SELECT COUNT(*) FROM people WHERE is_reader = 1")->fetchColumn();
$author_count = $pdo->query("SELECT COUNT(*) FROM people WHERE is_author = 1")->fetchColumn();
// Build the query with filters
$query = 'SELECT DISTINCT p.id, p.name, p.slug, p.image
FROM people p';
$params = []; // Initialize params array
// Handle personality filters based on match type
if (!empty($personality_filters)) {
if ($match_all) {
// Match ALL personalities (using JOINs)
foreach ($personality_filters as $index => $personality) {
$join_alias = "pp{$index}";
$pers_alias = "pers{$index}";
$query .= " JOIN person_personality {$join_alias} ON p.id = {$join_alias}.person_id
JOIN personalities {$pers_alias} ON {$join_alias}.personality_id = {$pers_alias}.id
AND {$pers_alias}.slug = ?";
$params[] = $personality;
}
} else {
// Match ANY personalities (using EXISTS)
$query .= " JOIN person_personality pp ON p.id = pp.person_id
JOIN personalities pers ON pp.personality_id = pers.id
AND pers.slug IN (" . implode(',', array_fill(0, count($personality_filters), '?')) . ")";
$params = array_merge($params, $personality_filters);
}
}
$query .= ' WHERE 1=1';
// Handle role filters based on match type
$role_conditions = [];
if ($match_all) {
// For "match all", add individual conditions
if ($reader_filter) {
$role_conditions[] = 'p.is_reader = 1';
}
if ($author_filter) {
$role_conditions[] = 'p.is_author = 1';
}
if (!empty($role_conditions)) {
$query .= ' AND ' . implode(' AND ', $role_conditions);
}
} else {
// For "match any", OR the conditions
$any_role_conditions = [];
if ($reader_filter) {
$any_role_conditions[] = 'p.is_reader = 1';
}
if ($author_filter) {
$any_role_conditions[] = 'p.is_author = 1';
}
if (!empty($any_role_conditions)) {
$query .= ' AND (' . implode(' OR ', $any_role_conditions) . ')';
}
}
// Handle name filter
if (!empty($name_filter)) {
$name_words = array_filter(array_map('trim', explode(' ', $name_filter)));
if (!empty($name_words)) {
$name_conditions = [];
foreach ($name_words as $word) {
$name_conditions[] = 'LOWER(TRIM(p.name)) LIKE LOWER(?)';
$params[] = '%' . $word . '%';
}
$query .= ' AND (' . implode(' OR ', $name_conditions) . ')';
}
}
// Get total count
$count_query = str_replace('SELECT DISTINCT p.id, p.name, p.slug, p.image', 'SELECT COUNT(DISTINCT p.id)', $query);
$stmt = $pdo->prepare($count_query);
$stmt->execute($params);
$total_people = $stmt->fetchColumn();
$total_pages = ceil($total_people / $items_per_page);
// Get people for current page
$query .= ' ORDER BY p.name ASC LIMIT ? OFFSET ?';
$params[] = $items_per_page;
$params[] = $offset;
$stmt = $pdo->prepare($query);
$stmt->execute($params);
$people = $stmt->fetchAll(PDO::FETCH_ASSOC);
$query = "SELECT p.personality, p.slug, COUNT(DISTINCT pp.person_id) as people_count
FROM personalities p
LEFT JOIN person_personality pp ON p.id = pp.personality_id
GROUP BY p.id, p.personality, p.slug
ORDER BY p.personality ASC";
$personalities = $pdo->query($query)->fetchAll(PDO::FETCH_ASSOC);
// Function to build pagination URL with current filters
function buildPaginationUrl($page) {
$params = $_GET;
$params['page'] = $page;
return '?' . http_build_query($params);
}
// Check if there are active filters
$has_active_filters = $match_all || $reader_filter || $author_filter || !empty($personality_filters) || !empty($name_filter);
// Function to get personality names from slugs
function getPersonalityNames($slugs, $personalities) {
$names = [];
foreach ($slugs as $slug) {
foreach ($personalities as $personality) {
if ($personality['slug'] === $slug) {
$names[] = $personality['personality'];
break;
}
}
}
return $names;
}
// Build filter summary text
$filter_summary = [];
if ($match_all || (!$reader_filter && !$author_filter && !empty($personality_filters))) {
$filter_summary[] = 'Match ' . ($match_all ? 'ALL' : 'ANY') . ' criteria';
}
if ($reader_filter) {
$filter_summary[] = 'Have read books';
}
if ($author_filter) {
$filter_summary[] = 'Have authored books';
}
if (!empty($personality_filters)) {
$personality_names = getPersonalityNames($personality_filters, $personalities);
$filter_summary = array_merge($filter_summary, $personality_names);
}
if (!empty($name_filter)) {
$filter_summary[] = 'Name contains "' . $name_filter . '"';
}
?>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/global.php'; ?>
<!doctype html>
<html lang=en>
<head>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/analytics.php'; ?>
<meta charset=utf-8>
<meta name=viewport content="width=device-width, initial-scale=1">
<? # START - Head code ?>
<title>People - AspireBookClub.com<? echo $current_page > 1 ? " - Page $current_page" : ""; ?></title>
<meta name=description content="List of people that inspire us.">
<meta property=og:title content="People - AspireBookClub.com<? echo $current_page > 1 ? " - Page $current_page" : ""; ?>">
<meta property=og:description content="AspireBookClub.com get inspired by people that inspire us.">
<meta property=og:url content="https://aspirebookclub.com">
<meta property=og:site_name content=AspireBookClub.com>
<meta property=og:type content=website>
<meta property=og:image content="https://aspirebookclub.com/images/people.png">
<? # END - Head code ?>
<meta name=robots content="index, follow">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/head-code.php'; ?>
</head>
<body class=bg-blue-50>
<div x-data="{ showNav: false }" class="max-w-[1250px] mx-auto">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/header.php'; ?>
<div id=wrap class="grid grid-cols-12">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/navigation.php'; ?>
<main class="bg-white p-6 w-full col-span-12 shadow-[10px_0_15px_-3px_rgba(0,0,0,0.1)] flex flex-col">
<? # include $_SERVER['DOCUMENT_ROOT'] . '/../includes/ad-abc-res-top.php'; ?>
<nav aria-label=Breadcrumbs class="order-2 md:order-1 mt-7 md:mt-0">
<ul class="text-gray-600 lg:mb-3">
<? # START - Breadcrumb code ?>
<li class="mb-3 inline-block pl-2 before:absolute before:top-[0em] mr-1 after:content-['\203A'] after:ml-1"><a class=hover:text-blue-600 href="https://aspirebookclub.com">Aspire Book Club</a></li>
<li class="mb-3 inline-block pl-2 text-gray-400">People</li>
<? # END - Breadcrumb code ?>
</ul>
</nav>
<div class="order-1 md:order-2 md:pl-3 md:pr-3">
<? # START - Main content ?>
<h1>👤 People</h1>
<!-- Filters -->
<form method=get class="mb-8 bg-gray-50 rounded-lg border-gray-300 border" x-data="{
    isOpen: false}">
<div class="p-4 ">
<div class="flex items-center justify-between cursor-pointer" @click="isOpen = !isOpen">
<div class="flex items-center gap-2">
<span class=font-medium>Filter</span>
<template x-if="!isOpen && false">
<div class="text-sm text-gray-600">
</div>
</template>
</div>
<svg class="w-5 h-5 transition-transform" :class="{ 'rotate-180': !isOpen }" xmlns="https://www.w3.org/2000/svg" fill=none viewBox="0 0 24 24" stroke=currentColor>
<path stroke-linecap=round stroke-linejoin=round stroke-width=2 d="M19 9l-7 7-7-7"/>
</svg>
</div>
</div>
<div class="space-y-4 p-4 pt-0" x-show=isOpen x-transition>
<!-- Match Type Selection -->
<div class=space-y-2>
<div class="flex gap-4">
<label class="inline-flex items-baseline">
<input type=radio name=match_type value=any checked class="form-radio text-blue-600">
<span class=ml-2>Match ANY criteria</span>
</label>
<label class="inline-flex items-baseline">
<input type=radio name=match_type value=all class="form-radio text-blue-600">
<span class=ml-2>Match ALL criteria</span>
</label>
</div>
</div>
<!-- Personality filter -->
<div>
<div class="grid grid-cols-2 md:grid-cols-3 lg:grid-cols-5 gap-2">
</div>
</div>
<!-- Role filter -->
<div>
<div class="flex gap-4 mt-6 mb-6">
<label class="inline-flex items-baseline">
<input type=checkbox name=reader value=1 class="form-checkbox text-blue-600">
<span class=ml-2>Have read books <span class="text-gray-500 text-sm">()</span></span>
</label>
<label class="inline-flex items-baseline">
<input type=checkbox name=author value=1 class="form-checkbox text-blue-600">
<span class=ml-2>Have authored books <span class="text-gray-500 text-sm">()</span></span>
</label>
</div>
</div>
<!-- Name filter -->
<div>
<label class="block sm:flex sm:items-center">
<span class="text-md font-medium sm:mr-4">Person name contains:</span>
<input type=text name=name value="" class="mt-1 min-w-[100%] sm:min-w-[400px] block px-3 py-2 border border-gray-300 bg-white rounded-md shadow-sm placeholder-gray-400 focus:outline-none focus:ring-blue-500 focus:border-blue-500">
</label>
</div>
<!-- Hidden field to preserve page=1 when filtering -->
<input type=hidden name=page value=1>
<div class=flex>
<button type=submit class="px-4 py-2 bg-blue-600 text-white rounded hover:bg-blue-700 cursor-pointer">Apply filter</button>
<div></div>
</div>
</div>
</form>
<!-- People List Container -->
<div id=peopleListContainer>
<!-- Results Count -->
<div class="mb-4 text-gray-600">
0 pepole </div>
<!-- People List -->
<div class=mb-4>
<p class="text-4xl !mb-3"> 😭 </p>
<p class="text-3xl text-gray-600 mb-10"><a href="/people" class="text-blue-600 underline">Reset try again</a></p>
</div>
<!-- Pagination -->
</div>
<script>function buildPaginationUrl(page){const params=new URLSearchParams(window.location.search);params.set('page',page);return'?'+params.toString();}</script>
<? # END - Main content ?>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/ad-abc-res-bottom.php'; ?>
</div>
</main>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/footer.php'; ?>
</div>
</body>
</html>