|
|
<?php
|
|
|
require_once 'config.php';
|
|
|
session_start();
|
|
|
|
|
|
|
|
|
if (!isset($_SESSION['user_id'])) {
|
|
|
header('Location: login.php');
|
|
|
exit;
|
|
|
}
|
|
|
|
|
|
$search_query = $_GET['q'] ?? '';
|
|
|
$sort = $_GET['sort'] ?? 'default';
|
|
|
|
|
|
|
|
|
$conn = new mysqli($host, $username, $password, $dbname);
|
|
|
if ($conn->connect_error) {
|
|
|
die("Connection failed: " . $conn->connect_error);
|
|
|
}
|
|
|
if (!$conn->set_charset("utf8mb4")) {
|
|
|
throw new Exception("文字コード設定失敗: " . $conn->error);
|
|
|
}
|
|
|
|
|
|
$sql = "SELECT * FROM projects WHERE is_public = 1";
|
|
|
$params = [];
|
|
|
|
|
|
if (!empty($search_query)) {
|
|
|
$sql .= " AND (project_name LIKE ? OR description LIKE ?)";
|
|
|
$search_param = "%$search_query%";
|
|
|
$params = array_merge($params, [$search_param, $search_param]);
|
|
|
}
|
|
|
|
|
|
|
|
|
switch ($sort) {
|
|
|
case 'stars':
|
|
|
$sql .= " ORDER BY stars DESC";
|
|
|
break;
|
|
|
case 'views':
|
|
|
$sql .= " ORDER BY views DESC";
|
|
|
break;
|
|
|
case 'custom':
|
|
|
|
|
|
$sql .= " ORDER BY (stars * 2 + views) DESC";
|
|
|
break;
|
|
|
default:
|
|
|
|
|
|
if (!empty($search_query)) {
|
|
|
$sql .= " ORDER BY
|
|
|
(CASE WHEN project_name LIKE ? THEN 3
|
|
|
WHEN description LIKE ? THEN 2
|
|
|
ELSE 1 END) DESC";
|
|
|
$exact_param = "$search_query%";
|
|
|
$params = array_merge($params, [$exact_param, $exact_param]);
|
|
|
} else {
|
|
|
$sql .= " ORDER BY created_at DESC";
|
|
|
}
|
|
|
}
|
|
|
|
|
|
$stmt = $conn->prepare($sql);
|
|
|
|
|
|
|
|
|
if (!empty($params)) {
|
|
|
$types = str_repeat('s', count($params));
|
|
|
$stmt->bind_param($types, ...$params);
|
|
|
}
|
|
|
|
|
|
$stmt->execute();
|
|
|
$result = $stmt->get_result();
|
|
|
$projects = $result->fetch_all(MYSQLI_ASSOC);
|
|
|
|
|
|
$conn->close();
|
|
|
?>
|
|
|
|
|
|
<!DOCTYPE html>
|
|
|
<html lang="ja">
|
|
|
<head>
|
|
|
<meta charset="UTF-8">
|
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
|
<!-- Google Tag Manager -->
|
|
|
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
|
|
|
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
|
|
|
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
|
|
|
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
|
|
|
})(window,document,'script','dataLayer','GTM-PJXRKX3F');</script>
|
|
|
<!-- End Google Tag Manager -->
|
|
|
<title>プロジェクト検索 - Scratch School</title>
|
|
|
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+JP:wght@400;500;700&display=swap" rel="stylesheet">
|
|
|
<style>
|
|
|
:root {
|
|
|
--primary-color:
|
|
|
--secondary-color:
|
|
|
--background-color:
|
|
|
--card-bg:
|
|
|
--text-color:
|
|
|
--error-color:
|
|
|
--success-color:
|
|
|
}
|
|
|
|
|
|
* {
|
|
|
box-sizing: border-box;
|
|
|
margin: 0;
|
|
|
padding: 0;
|
|
|
}
|
|
|
|
|
|
body {
|
|
|
font-family: 'Noto Sans JP', sans-serif;
|
|
|
background-color: var(--background-color);
|
|
|
color: var(--text-color);
|
|
|
line-height: 1.6;
|
|
|
padding: 20px;
|
|
|
}
|
|
|
|
|
|
.container {
|
|
|
max-width: 98%;
|
|
|
margin: 0 auto;
|
|
|
background-color: var(--card-bg);
|
|
|
border-radius: 10px;
|
|
|
box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1);
|
|
|
padding: 30px;
|
|
|
}
|
|
|
|
|
|
h1 {
|
|
|
color: var(--primary-color);
|
|
|
margin-bottom: 20px;
|
|
|
text-align: center;
|
|
|
}
|
|
|
|
|
|
.form-group {
|
|
|
margin-bottom: 20px;
|
|
|
}
|
|
|
|
|
|
label {
|
|
|
display: block;
|
|
|
margin-bottom: 5px;
|
|
|
font-weight: 500;
|
|
|
}
|
|
|
|
|
|
input[type="text"],
|
|
|
textarea {
|
|
|
width: 100%;
|
|
|
padding: 10px;
|
|
|
border: 1px solid
|
|
|
border-radius: 4px;
|
|
|
font-family: inherit;
|
|
|
font-size: 16px;
|
|
|
}
|
|
|
|
|
|
textarea {
|
|
|
min-height: 120px;
|
|
|
resize: vertical;
|
|
|
}
|
|
|
|
|
|
.thumbnail-preview {
|
|
|
width: 200px;
|
|
|
height: 150px;
|
|
|
background-color:
|
|
|
border-radius: 4px;
|
|
|
margin-bottom: 10px;
|
|
|
overflow: hidden;
|
|
|
display: flex;
|
|
|
align-items: center;
|
|
|
justify-content: center;
|
|
|
}
|
|
|
|
|
|
.thumbnail-preview img {
|
|
|
max-width: 100%;
|
|
|
max-height: 100%;
|
|
|
object-fit: contain;
|
|
|
}
|
|
|
|
|
|
.btn {
|
|
|
background-color: var(--primary-color);
|
|
|
color: white;
|
|
|
border: none;
|
|
|
padding: 10px 20px;
|
|
|
border-radius: 4px;
|
|
|
cursor: pointer;
|
|
|
font-size: 16px;
|
|
|
font-weight: 500;
|
|
|
transition: background-color 0.3s;
|
|
|
}
|
|
|
|
|
|
.btn:hover {
|
|
|
background-color:
|
|
|
}
|
|
|
|
|
|
.btn-secondary {
|
|
|
background-color: var(--secondary-color);
|
|
|
}
|
|
|
|
|
|
.btn-secondary:hover {
|
|
|
background-color:
|
|
|
}
|
|
|
|
|
|
.error {
|
|
|
color: var(--error-color);
|
|
|
margin-bottom: 15px;
|
|
|
}
|
|
|
|
|
|
.success {
|
|
|
color: var(--success-color);
|
|
|
margin-bottom: 15px;
|
|
|
}
|
|
|
|
|
|
.checkbox-group {
|
|
|
display: flex;
|
|
|
align-items: center;
|
|
|
margin-bottom: 20px;
|
|
|
}
|
|
|
|
|
|
.checkbox-group input {
|
|
|
margin-right: 10px;
|
|
|
}
|
|
|
.search-container {
|
|
|
display: flex;
|
|
|
margin-bottom: 20px;
|
|
|
}
|
|
|
|
|
|
.search-input {
|
|
|
flex-grow: 1;
|
|
|
padding: 10px;
|
|
|
border: 1px solid
|
|
|
border-radius: 4px 0 0 4px;
|
|
|
font-size: 16px;
|
|
|
}
|
|
|
|
|
|
.search-button {
|
|
|
padding: 10px 20px;
|
|
|
background-color: var(--primary-color);
|
|
|
color: white;
|
|
|
border: none;
|
|
|
border-radius: 0 4px 4px 0;
|
|
|
cursor: pointer;
|
|
|
}
|
|
|
|
|
|
.sort-options {
|
|
|
display: flex;
|
|
|
gap: 10px;
|
|
|
margin-bottom: 20px;
|
|
|
}
|
|
|
|
|
|
.sort-option {
|
|
|
padding: 5px 10px;
|
|
|
background-color:
|
|
|
border-radius: 4px;
|
|
|
cursor: pointer;
|
|
|
}
|
|
|
|
|
|
.sort-option.active {
|
|
|
background-color: var(--primary-color);
|
|
|
color: white;
|
|
|
}
|
|
|
|
|
|
.projects-grid {
|
|
|
display: grid;
|
|
|
grid-template-columns: repeat(auto-fill, minmax(250px, 1fr));
|
|
|
gap: 20px;
|
|
|
}
|
|
|
|
|
|
.project-card {
|
|
|
background-color: var(--card-bg);
|
|
|
border-radius: 8px;
|
|
|
overflow: hidden;
|
|
|
box-shadow: 0 2px 5px rgba(0, 0, 0, 0.1);
|
|
|
transition: transform 0.3s, box-shadow 0.3s;
|
|
|
cursor: pointer;
|
|
|
}
|
|
|
|
|
|
.project-card:hover {
|
|
|
transform: translateY(-5px);
|
|
|
box-shadow: 0 5px 15px rgba(0, 0, 0, 0.1);
|
|
|
}
|
|
|
|
|
|
.project-thumbnail {
|
|
|
width: 100%;
|
|
|
height: 150px;
|
|
|
background-color:
|
|
|
overflow: hidden;
|
|
|
position: relative;
|
|
|
}
|
|
|
|
|
|
.project-thumbnail img {
|
|
|
width: 100%;
|
|
|
height: 100%;
|
|
|
object-fit: cover;
|
|
|
}
|
|
|
|
|
|
.project-info {
|
|
|
padding: 15px;
|
|
|
}
|
|
|
|
|
|
.project-title {
|
|
|
font-weight: 500;
|
|
|
margin-bottom: 5px;
|
|
|
white-space: nowrap;
|
|
|
overflow: hidden;
|
|
|
text-overflow: ellipsis;
|
|
|
}
|
|
|
|
|
|
.project-author {
|
|
|
color: var(--secondary-color);
|
|
|
font-size: 14px;
|
|
|
margin-bottom: 10px;
|
|
|
}
|
|
|
|
|
|
.project-stats {
|
|
|
display: flex;
|
|
|
justify-content: space-between;
|
|
|
font-size: 14px;
|
|
|
color: var(--secondary-color);
|
|
|
}
|
|
|
|
|
|
.loading-thumbnail {
|
|
|
position: absolute;
|
|
|
top: 50%;
|
|
|
left: 50%;
|
|
|
transform: translate(-50%, -50%);
|
|
|
color:
|
|
|
}
|
|
|
</style>
|
|
|
</head>
|
|
|
<body>
|
|
|
<!-- Google Tag Manager (noscript) -->
|
|
|
<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PJXRKX3F"
|
|
|
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
|
|
|
<!-- End Google Tag Manager (noscript) -->
|
|
|
<div class="container">
|
|
|
<h1>プロジェクトを探す</h1>
|
|
|
|
|
|
<form method="GET" class="search-container">
|
|
|
<input type="text" name="q" class="search-input" placeholder="プロジェクトを検索..." value="<?php echo htmlspecialchars($search_query); ?>">
|
|
|
<button type="submit" class="search-button">検索</button>
|
|
|
</form>
|
|
|
|
|
|
<div class="sort-options">
|
|
|
<a href="?q=<?php echo urlencode($search_query); ?>&sort=default" class="sort-option <?php echo $sort === 'default' ? 'active' : ''; ?>">関連順</a>
|
|
|
<a href="?q=<?php echo urlencode($search_query); ?>&sort=stars" class="sort-option <?php echo $sort === 'stars' ? 'active' : ''; ?>">星の数</a>
|
|
|
<a href="?q=<?php echo urlencode($search_query); ?>&sort=views" class="sort-option <?php echo $sort === 'views' ? 'active' : ''; ?>">閲覧数</a>
|
|
|
<a href="?q=<?php echo urlencode($search_query); ?>&sort=custom" class="sort-option <?php echo $sort === 'custom' ? 'active' : ''; ?>">おすすめ</a>
|
|
|
</div>
|
|
|
|
|
|
<?php if (empty($projects)): ?>
|
|
|
<p>プロジェクトが見つかりませんでした</p>
|
|
|
<?php else: ?>
|
|
|
<div class="projects-grid">
|
|
|
<?php foreach ($projects as $project): ?>
|
|
|
<a href="view.php?id=<?php echo $project['id']; ?>" class="project-card" target="_blank">
|
|
|
<div class="project-thumbnail" data-drive-id="<?php echo htmlspecialchars($project['drive_id']); ?>">
|
|
|
<div class="loading-thumbnail">...</div>
|
|
|
<!-- 画像はJavaScriptで動的に挿入されます -->
|
|
|
</div>
|
|
|
<div class="project-info">
|
|
|
<h3 class="project-title"><?php echo htmlspecialchars($project['project_name']); ?></h3>
|
|
|
<p class="project-author">by <?php echo htmlspecialchars($project['author_name']); ?></p>
|
|
|
<div class="project-stats">
|
|
|
<span>★ <?php echo $project['stars']; ?></span>
|
|
|
<span>👁️ <?php echo $project['views']; ?></span>
|
|
|
</div>
|
|
|
</div>
|
|
|
</a>
|
|
|
<?php endforeach; ?>
|
|
|
</div>
|
|
|
<?php endif; ?>
|
|
|
</div>
|
|
|
|
|
|
<script>
|
|
|
document.addEventListener('DOMContentLoaded', function() {
|
|
|
const accessToken = '<?php echo $_SESSION['access_token'] ?? ''; ?>';
|
|
|
const thumbnailContainers = document.querySelectorAll('.project-thumbnail');
|
|
|
|
|
|
thumbnailContainers.forEach(container => {
|
|
|
const driveId = container.dataset.driveId;
|
|
|
const loadingElement = container.querySelector('.loading-thumbnail');
|
|
|
|
|
|
if (!driveId) {
|
|
|
loadingElement.textContent = 'サムネイルなし';
|
|
|
return;
|
|
|
}
|
|
|
|
|
|
const thumbnailName = `Scratch-Thumbnail-${driveId}.png`;
|
|
|
|
|
|
|
|
|
fetch(`https://www.googleapis.com/drive/v3/files?q=name='${encodeURIComponent(thumbnailName)}'`, {
|
|
|
headers: {
|
|
|
'Authorization': `Bearer ${accessToken}`
|
|
|
}
|
|
|
})
|
|
|
.then(response => {
|
|
|
if (!response.ok) {
|
|
|
throw new Error('サムネイル検索に失敗しました');
|
|
|
}
|
|
|
return response.json();
|
|
|
})
|
|
|
.then(data => {
|
|
|
if (data.files && data.files.length > 0) {
|
|
|
const thumbnailId = data.files[0].id;
|
|
|
const img = document.createElement('img');
|
|
|
img.src = `https:
|
|
|
img.alt = 'プロジェクトサムネイル';
|
|
|
img.onload = () => {
|
|
|
loadingElement.remove();
|
|
|
container.appendChild(img);
|
|
|
};
|
|
|
img.onerror = () => {
|
|
|
loadingElement.textContent = 'サムネイル読み込みエラー';
|
|
|
};
|
|
|
} else {
|
|
|
loadingElement.textContent = 'サムネイルなし';
|
|
|
}
|
|
|
})
|
|
|
.catch(error => {
|
|
|
console.error('サムネイル取得エラー:', error);
|
|
|
loadingElement.textContent = '読み込みエラー';
|
|
|
|
|
|
if (error.message.includes('401')) {
|
|
|
|
|
|
window.location.href = 'login.php';
|
|
|
}
|
|
|
});
|
|
|
});
|
|
|
});
|
|
|
</script>
|
|
|
</body>
|
|
|
</html> |
