200 lines
7.8 KiB
PHP
200 lines
7.8 KiB
PHP
<?php
|
||
/*
|
||
Orario Scuola, Copyright (C) 2025 EmmeV.
|
||
|
||
This program is free software: you can redistribute it and/or modify
|
||
it under the terms of the GNU Affero General Public License as published by
|
||
the Free Software Foundation, either version 3 of the License, or
|
||
(at your option) any later version.
|
||
|
||
This program is distributed in the hope that it will be useful,
|
||
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
GNU Affero General Public License for more details.
|
||
|
||
You should have received a copy of the GNU Affero General Public License
|
||
along with this program. If not, see https://www.gnu.org/licenses/.
|
||
*/
|
||
session_start();
|
||
if (!isset($_SESSION['admin'])) { header("Location: login.php"); exit; }
|
||
include("../lib/db.php");
|
||
|
||
// --- Recupera tutte le materie ---
|
||
$subjects = [];
|
||
$res = $conn->query("SELECT * FROM subjects ORDER BY name ASC");
|
||
while ($r = $res->fetch_assoc()) {
|
||
$label = $r['name'];
|
||
if (!empty($r['teacher'])) $label .= " ({$r['teacher']})";
|
||
if (!empty($r['room'])) $label .= " ({$r['room']})";
|
||
$subjects[] = ['id' => $r['id'], 'label' => $label];
|
||
}
|
||
|
||
// --- Salvataggio orario ---
|
||
if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST['class_id']) && isset($_POST['subject'])) {
|
||
$class_id = intval($_POST['class_id']);
|
||
if ($class_id > 0) {
|
||
// Cancella solo l'orario di questa classe
|
||
$conn->query("DELETE FROM timetable WHERE class_id=$class_id");
|
||
|
||
foreach ($_POST['subject'] as $day => $hours) {
|
||
foreach ($hours as $hour => $sub_ids) {
|
||
foreach ($sub_ids as $subject_id) {
|
||
$subject_id = intval($subject_id);
|
||
if (!empty($subject_id)) {
|
||
$conn->query("INSERT INTO timetable (class_id, day, hour, subject_id)
|
||
VALUES ($class_id, '" . $conn->real_escape_string($day) . "', $hour, $subject_id)");
|
||
}
|
||
}
|
||
}
|
||
}
|
||
|
||
header("Location: timetable.php?class_id=$class_id&saved=1");
|
||
exit;
|
||
}
|
||
}
|
||
|
||
// --- Selezione classe corrente ---
|
||
$class_id = isset($_GET['class_id']) ? intval($_GET['class_id']) : 0;
|
||
|
||
// --- Precaricamento dati orario ---
|
||
$preselectedData = [];
|
||
if ($class_id > 0) {
|
||
$res = $conn->query("SELECT * FROM timetable WHERE class_id=$class_id");
|
||
while ($r = $res->fetch_assoc()) {
|
||
$preselectedData[$r['day']][$r['hour']][] = $r['subject_id'];
|
||
}
|
||
}
|
||
?>
|
||
<!DOCTYPE html>
|
||
<html>
|
||
<head>
|
||
<title>Gestisci Orario</title>
|
||
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
||
<link rel="stylesheet" href="style.css">
|
||
<style>
|
||
.subject-container select { min-width: 120px; }
|
||
.subject-container button { cursor: pointer; margin-left: 3px; }
|
||
.admin-container { max-width: 95%; margin: auto; background: #fff; padding: 15px; border-radius: 8px; }
|
||
table { border-collapse: collapse; width: 100%; overflow-x: auto; display: block; }
|
||
th, td { text-align: center; padding: 6px; border: 1px solid #ccc; }
|
||
@media (max-width: 768px) {
|
||
table { font-size: 14px; }
|
||
th, td { padding: 4px; }
|
||
}
|
||
.saved-message {
|
||
margin-top: 15px;
|
||
text-align: center;
|
||
font-weight: bold;
|
||
color: green;
|
||
}
|
||
</style>
|
||
</head>
|
||
<body>
|
||
<div class="navbar">
|
||
<div class="logo">Admin Dashboard</div>
|
||
<div class="links">
|
||
<a href="index.php">Dashboard</a>
|
||
<a href="logout.php">Logout</a>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="admin-container">
|
||
<h1>Gestisci Orario</h1>
|
||
<a href="index.php" class="back-link">⬅ Torna al Dashboard</a>
|
||
|
||
<form method="POST" autocomplete="off">
|
||
Classe:
|
||
<select name="class_id" required onchange="window.location='timetable.php?class_id='+this.value;">
|
||
<option value="" disabled <?= $class_id === 0 ? 'selected' : '' ?>>--Scegli un'opzione--</option>
|
||
<?php
|
||
$res = $conn->query("SELECT * FROM classes ORDER BY name ASC");
|
||
while ($r = $res->fetch_assoc()) {
|
||
$selected = ($class_id == $r['id']) ? 'selected' : '';
|
||
echo "<option value='{$r['id']}' $selected>{$r['name']}</option>";
|
||
}
|
||
?>
|
||
</select>
|
||
|
||
<br><br>
|
||
<?php if ($class_id > 0): ?>
|
||
<table>
|
||
<thead>
|
||
<tr>
|
||
<th>Ora</th>
|
||
<th>Lunedì</th>
|
||
<th>Martedì</th>
|
||
<th>Mercoledì</th>
|
||
<th>Giovedì</th>
|
||
<th>Venerdì</th>
|
||
<th>Sabato</th>
|
||
</tr>
|
||
</thead>
|
||
<tbody>
|
||
<?php
|
||
$days = ['Lunedì', 'Martedì', 'Mercoledì', 'Giovedì', 'Venerdì', 'Sabato'];
|
||
for ($hour = 1; $hour <= 6; $hour++) {
|
||
echo "<tr>";
|
||
echo "<td>{$hour}ª ora</td>";
|
||
foreach ($days as $day) {
|
||
$preselected = $preselectedData[$day][$hour] ?? [''];
|
||
echo "<td>";
|
||
echo "<div class='subject-container' data-day='$day' data-hour='$hour'>";
|
||
foreach ($preselected as $subject_id) {
|
||
echo "<div class='subject-row' style='display:flex;align-items:center;gap:5px;margin-bottom:3px;'>";
|
||
echo "<select name='subject[$day][$hour][]'>";
|
||
echo "<option value=''>--</option>";
|
||
foreach ($subjects as $s) {
|
||
$sel = ($subject_id == $s['id']) ? 'selected' : '';
|
||
echo "<option value='{$s['id']}' $sel>" . htmlspecialchars($s['label']) . "</option>";
|
||
}
|
||
echo "</select>";
|
||
echo "<button type='button' class='remove-subject' style='background:#e74c3c;color:white;border:none;border-radius:3px;padding:2px 6px;'>−</button>";
|
||
echo "</div>";
|
||
}
|
||
echo "<button type='button' class='add-subject' style='background:#28a745;color:white;border:none;border-radius:3px;padding:2px 6px;'>+</button>";
|
||
echo "</div>";
|
||
echo "</td>";
|
||
}
|
||
echo "</tr>";
|
||
}
|
||
?>
|
||
</tbody>
|
||
</table>
|
||
|
||
<br>
|
||
<button type="submit">Salva orario</button>
|
||
<?php endif; ?>
|
||
<?php if (isset($_GET['saved'])): ?>
|
||
<p class="saved-message">✅ Orario salvato con successo!</p>
|
||
<?php endif; ?>
|
||
</form>
|
||
<p style="text-align: center;">
|
||
Nota: Questa pagina si vede meglio da computer desktop. Se sei da computer, puoi ignorare questo messaggio.
|
||
</p>
|
||
<p style="text-align: center;">Copyright (C) 2025 EmmeV. - Released under <a href="https://git.vichingo455.freeddns.org/emmev-code/orario/src/branch/stable/LICENSE.txt" target="_blank">GNU AGPL 3.0 License</a>.</p>
|
||
</div>
|
||
|
||
<script>
|
||
document.addEventListener('click', function(e){
|
||
if(e.target.classList.contains('add-subject')){
|
||
const container = e.target.closest('.subject-container');
|
||
const firstRow = container.querySelector('.subject-row');
|
||
const clone = firstRow.cloneNode(true);
|
||
clone.querySelector('select').value = '';
|
||
container.insertBefore(clone, e.target);
|
||
}
|
||
|
||
if(e.target.classList.contains('remove-subject')){
|
||
const container = e.target.closest('.subject-container');
|
||
const rows = container.querySelectorAll('.subject-row');
|
||
if(rows.length > 1){
|
||
e.target.closest('.subject-row').remove();
|
||
} else {
|
||
rows[0].querySelector('select').value = '';
|
||
}
|
||
}
|
||
});
|
||
</script>
|
||
</body>
|
||
</html>
|