real_escape_string($keyword_raw);
$sort = isset($_GET['sort']) ? $_GET['sort'] : 'new';
$valid_sorts = ['new', 'old', 'top'];
if (!in_array($sort, $valid_sorts, true)) {
$sort = 'new';
}
$section = isset($_GET['section']) ? $_GET['section'] : 'all';
$valid_sections = ['all', 'good', 'bad', 'medium', 'people', 'humanity'];
if (!in_array($section, $valid_sections, true)) {
$section = 'all';
}
$searched_user = null;
$searched_user_items = [];
if (!empty($keyword)) {
$kw_esc = $conn->real_escape_string($keyword);
$user_query = $conn->query(
"SELECT id, username, email, is_admin, created_at FROM users WHERE " .
"id = '" . (int)$kw_esc . "' OR email LIKE '%$kw_esc%' OR username LIKE '%$kw_esc%' LIMIT 1"
);
if ($user_query && $user_query->num_rows > 0) {
$searched_user = $user_query->fetch_assoc();
}
}
$page = max(1, (int)($_GET['page'] ?? 1));
$limit = 60;
$offset = ($page - 1) * $limit;
$where = "WHERE s.status = 1";
if (!empty($keyword)) {
$kw_esc2 = $conn->real_escape_string($keyword);
if ($searched_user) {
$where .= " AND (s.license_plate LIKE '%$kw_esc2%' OR s.brand LIKE '%$kw_esc2%' OR s.region LIKE '%$kw_esc2%' OR s.user_id = " . (int)$searched_user['id'] . ")";
} else {
$where .= " AND (s.license_plate LIKE '%$kw_esc2%' OR s.brand LIKE '%$kw_esc2%' OR s.region LIKE '%$kw_esc2%' OR u.email LIKE '%$kw_esc2%')";
}
}
if ($section !== 'all') {
$secEsc = $conn->real_escape_string($section);
$where .= " AND s.section = '$secEsc'";
}
$total = 0;
$count_sql = "SELECT COUNT(DISTINCT s.id) as c
FROM submissions s
LEFT JOIN users u ON s.user_id = u.id
$where";
$count_res = $conn->query($count_sql);
if ($count_res) {
$total = (int)($count_res->fetch_assoc()['c'] ?? 0);
}
if ($searched_user) {
$user_items_sql = "SELECT s.id, s.photo_path, s.license_plate, s.region, s.brand, s.created_at,
u.email as author_email, AVG(r.rating) as avg_rating
FROM submissions s
LEFT JOIN users u ON s.user_id = u.id
LEFT JOIN ratings r ON s.id = r.submission_id
WHERE s.status = 1 AND s.user_id = " . (int)$searched_user['id'] . "
GROUP BY s.id ORDER BY s.id DESC";
$user_items_res = $conn->query($user_items_sql);
if ($user_items_res) {
while ($row = $user_items_res->fetch_assoc()) {
$searched_user_items[] = $row;
}
}
}
if ($sort === 'top') {
$order_by = 'ORDER BY avg_rating DESC, s.id DESC';
} elseif ($sort === 'old') {
$order_by = 'ORDER BY s.id ASC';
} else {
$order_by = 'ORDER BY s.id DESC';
}
$sql = "SELECT s.id, s.photo_path, s.license_plate, s.region, s.brand, s.created_at,
u.email as author_email, AVG(r.rating) as avg_rating
FROM submissions s
LEFT JOIN users u ON s.user_id = u.id
LEFT JOIN ratings r ON s.id = r.submission_id
$where
GROUP BY s.id $order_by LIMIT $limit OFFSET $offset";
$res = $conn->query($sql);
$all_items = [];
if ($res) {
while($row = $res->fetch_assoc()) {
$all_items[] = $row;
}
}
$cloud_cache_file = __DIR__ . '/cache/cloud_tags.json';
$cloud_tags = null;
if (file_exists($cloud_cache_file) && (time() - filemtime($cloud_cache_file)) < 600) {
$cloud_tags = json_decode(file_get_contents($cloud_cache_file), true);
}
if ($cloud_tags === null) {
$corpus = '';
$cloud_res = $conn->query("SELECT brand, region, license_plate FROM submissions WHERE status = 1 ORDER BY id DESC LIMIT 200");
if ($cloud_res) {
while ($row = $cloud_res->fetch_assoc()) {
$corpus .= " " . ($row['brand'] ?? '') . " " . ($row['region'] ?? '') . " " . ($row['license_plate'] ?? '');
}
}
$cloud_tags = getCloudTags($corpus);
if (!is_dir(__DIR__ . '/cache')) {
@mkdir(__DIR__ . '/cache', 0755, true);
}
@file_put_contents($cloud_cache_file, json_encode($cloud_tags));
}
$is_logged_in = isset($_SESSION['user_id']);
$user_data = null;
if ($is_logged_in) {
$uid = $_SESSION['user_id'];
$u_res = $conn->query("SELECT username, is_admin FROM users WHERE id = $uid");
$user_data = $u_res->fetch_assoc();
}
?>
<?= !empty($keyword_raw) ? '搜索：' . htmlspecialchars($keyword_raw) . ' - 800BUS | 捌佰档案站' : '画廊 - 800BUS | 捌佰档案站' ?>
