prepare("INSERT INTO competitions (title, details, rank_result, year_th) VALUES (?, ?, ?, ?)"); $stmt->execute([$title, $details, $rank_result, $year_th]); $competition_id = $pdo->lastInsertId(); // Handle authors $authors = array_filter(array_map('trim', explode(',', $authors_str))); foreach ($authors as $author) { $stmt = $pdo->prepare("INSERT INTO competition_authors (competition_id, author_name) VALUES (?, ?)"); $stmt->execute([$competition_id, $author]); } // Handle file uploads if (!empty($_FILES['attachments']['name'][0])) { foreach ($_FILES['attachments']['name'] as $key => $name) { if ($_FILES['attachments']['error'][$key] == 0) { $tmp_name = $_FILES['attachments']['tmp_name'][$key]; $gdrive_file_id = uploadFileToDrive($tmp_name, $name, $folder_id); if ($gdrive_file_id) { $stmt = $pdo->prepare("INSERT INTO competition_attachments (competition_id, file_name, gdrive_file_id) VALUES (?, ?, ?)"); $stmt->execute([$competition_id, $name, $gdrive_file_id]); } } } } logActivity($pdo, 'CREATE_COMPETITION', "เพิ่มผลงาน: $title"); header("Location: competitions.php"); exit; } if (isset($_POST['edit_competition'])) { $id = $_POST['id']; $title = $_POST['title']; $year_th = $_POST['year_th']; $rank_result = $_POST['rank_result']; $details = $_POST['details']; $authors_str = $_POST['authors']; $stmt = $pdo->prepare("UPDATE competitions SET title = ?, details = ?, rank_result = ?, year_th = ? WHERE id = ?"); $stmt->execute([$title, $details, $rank_result, $year_th, $id]); // Update authors (delete all and re-insert) $stmt = $pdo->prepare("DELETE FROM competition_authors WHERE competition_id = ?"); $stmt->execute([$id]); $authors = array_filter(array_map('trim', explode(',', $authors_str))); foreach ($authors as $author) { $stmt = $pdo->prepare("INSERT INTO competition_authors (competition_id, author_name) VALUES (?, ?)"); $stmt->execute([$id, $author]); } // Handle new file uploads if (!empty($_FILES['attachments']['name'][0])) { foreach ($_FILES['attachments']['name'] as $key => $name) { if ($_FILES['attachments']['error'][$key] == 0) { $tmp_name = $_FILES['attachments']['tmp_name'][$key]; $gdrive_file_id = uploadFileToDrive($tmp_name, $name, $folder_id); if ($gdrive_file_id) { $stmt = $pdo->prepare("INSERT INTO competition_attachments (competition_id, file_name, gdrive_file_id) VALUES (?, ?, ?)"); $stmt->execute([$id, $name, $gdrive_file_id]); } } } } logActivity($pdo, 'UPDATE_COMPETITION', "แก้ไขผลงาน: $title"); header("Location: competitions.php"); exit; } } if ($action === 'delete_attachment' && isset($_GET['id'])) { $id = $_GET['id']; $stmt = $pdo->prepare("SELECT * FROM competition_attachments WHERE id = ?"); $stmt->execute([$id]); $attachment = $stmt->fetch(); if ($attachment) { deleteFileFromDrive($attachment['gdrive_file_id']); $stmt = $pdo->prepare("DELETE FROM competition_attachments WHERE id = ?"); $stmt->execute([$id]); logActivity($pdo, 'DELETE_COMPETITION_FILE', "ลบไฟล์แนบผลงาน: " . $attachment['file_name']); } header("Location: competitions.php?action=edit&id=" . $attachment['competition_id']); exit; } if ($action === 'delete' && isset($_GET['id'])) { $id = $_GET['id']; $stmt = $pdo->prepare("SELECT title FROM competitions WHERE id = ?"); $stmt->execute([$id]); $comp = $stmt->fetch(); if ($comp) { // Delete all attachments from GDrive $stmt = $pdo->prepare("SELECT * FROM competition_attachments WHERE competition_id = ?"); $stmt->execute([$id]); $attachments = $stmt->fetchAll(); foreach ($attachments as $attachment) { deleteFileFromDrive($attachment['gdrive_file_id']); } $stmt = $pdo->prepare("DELETE FROM competitions WHERE id = ?"); $stmt->execute([$id]); logActivity($pdo, 'DELETE_COMPETITION', "ลบผลงาน: " . $comp['title']); } header("Location: competitions.php"); exit; } ?>

จัดการผลงานประกวด

+ เพิ่มผลงานใหม่ กลับหน้ารายการ
query(" SELECT c.*, (SELECT GROUP_CONCAT(author_name SEPARATOR ', ') FROM competition_authors WHERE competition_id = c.id) as authors, (SELECT COUNT(*) FROM competition_attachments WHERE competition_id = c.id) as file_count FROM competitions c ORDER BY c.year_th DESC, c.id DESC "); while ($row = $stmt->fetch()): ?>
ปี (พ.ศ.) ชื่อผลงาน รางวัล ผู้จัดทำ ไฟล์แนบ จัดการ
แก้ไข ลบ
prepare("SELECT * FROM competitions WHERE id = ?"); $stmt->execute([$_GET['id']]); $comp = $stmt->fetch(); $stmt = $pdo->prepare("SELECT * FROM competition_attachments WHERE competition_id = ?"); $stmt->execute([$_GET['id']]); $attachments = $stmt->fetchAll(); $stmt = $pdo->prepare("SELECT GROUP_CONCAT(author_name SEPARATOR ', ') FROM competition_authors WHERE competition_id = ?"); $stmt->execute([$_GET['id']]); $authors_str = $stmt->fetchColumn(); } ?>

ไฟล์แนบปัจจุบัน