Tiny File Manager

Back Back Up Advanced Editor

<?php

// Fonction pour récupérer les jours fériés

function getHolidays($year)

{

$holidays = [

"$year-01-01", // Jour de l'An

"$year-05-01", // Fête du Travail

"$year-05-08", // Victoire 1945

"$year-07-14", // Fête Nationale

"$year-08-15", // Assomption

"$year-11-01", // Toussaint

"$year-11-11", // Armistice

"$year-12-25", // Noël

];

$easterDate = easter_date($year);

$ascension = date('Y-m-d', strtotime('+39 days', $easterDate));

$pentecost = date('Y-m-d', strtotime('+49 days', $easterDate));

$holidays[] = $ascension;

$holidays[] = $pentecost;

return $holidays;

}

// Vérifier si c'est un jour ouvré

function isBusinessDay($date, $holidays)

{

$dayOfWeek = date('N', $date); // 1 (lundi) à 7 (dimanche)

return $dayOfWeek < 6 && !in_array(date('Y-m-d', $date), $holidays);

}

// Fonction pour générer le tableau dynamique

function generateTable($startDate, $endDate)

{

setlocale(LC_TIME, 'fr_FR.UTF-8');

$currentDate = strtotime($startDate);

$endDate = strtotime($endDate);

$holidays = getHolidays(date('Y', $currentDate));

$monthColors = [

"#FFCCCC", "#FFE5CC", "#FFFFCC", "#E5FFCC", "#CCFFCC", "#CCFFE5",

"#CCFFFF", "#CCE5FF", "#CCCCFF", "#E5CCFF", "#FFCCFF", "#FFCCE5",

];

$weekOddColor = "#D6EAF8";

$weekEvenColor = "#AED6F1";

echo '<div class="table-responsive">';

echo '<table class="table table-bordered text-center" id="dynamicTable">';

// Première ligne : en-têtes

echo '<thead><tr><th>Date</th>';

while ($currentDate <= $endDate) {

if (isBusinessDay($currentDate, $holidays)) {

$formattedDate = date('d/m/Y', $currentDate);

echo '<th style="background-color: ' . $monthColors[date('n', $currentDate) - 1] . ';">' . $formattedDate . '</th>';

}

$currentDate = strtotime('+1 day', $currentDate);

}

echo '</tr>';

// Réinitialiser la date pour la deuxième ligne (numéros de semaine)

$currentDate = strtotime($startDate);

echo '<tr><td>Semaine</td>';

$lastWeekNumber = null;

$weekCellCount = 0;

while ($currentDate <= $endDate) {

if (isBusinessDay($currentDate, $holidays)) {

$weekNumber = date('W', $currentDate);

if ($weekNumber === $lastWeekNumber) {

$weekCellCount++;

} else {

if ($lastWeekNumber !== null) {

$color = ($lastWeekNumber % 2 === 0) ? $weekEvenColor : $weekOddColor;

echo '<td colspan="' . $weekCellCount . '" style="background-color: ' . $color . ';">' . $lastWeekNumber . '</td>';

}

$lastWeekNumber = $weekNumber;

$weekCellCount = 1;

}

$currentDate = strtotime('+1 day', $currentDate);

}

if ($lastWeekNumber !== null) {

$color = ($lastWeekNumber % 2 === 0) ? $weekEvenColor : $weekOddColor;

echo '<td colspan="' . $weekCellCount . '" style="background-color: ' . $color . ';">' . $lastWeekNumber . '</td>';

}

echo '</tr>';

// Réinitialiser la date pour la troisième ligne (jours de la semaine)

$currentDate = strtotime($startDate);

echo '<tr><td>Jours</td>';

while ($currentDate <= $endDate) {

if (isBusinessDay($currentDate, $holidays)) {

$dayName = mb_substr(ucfirst(strftime('%A', $currentDate)), 0, 3) . '.';

echo '<td>' . $dayName . '</td>';

}

$currentDate = strtotime('+1 day', $currentDate);

}

echo '</tr></thead>';

// Ajout d'une ligne vide au corps du tableau

echo '<tbody id="dataBody"></tbody>';

echo '</table>';

echo '<button id="addRowBtn" class="btn btn-primary mt-3">Ajouter</button>';

echo '<button id="saveBtn" class="btn btn-success mt-3">Sauver</button>'; // Bouton Sauver

echo '</div>';

}

<!DOCTYPE html>

<head>

<title>Tableau Dynamique</title>

<style>

.table_date[data-status="1"] {

background-color: #007BFF;

color: #fff;

}

.titre_nom[contenteditable="true"] {

border: 1px dashed #000;

padding: 5px;

}

</style>

</head>

<body>

<h1 class="text-center mb-4">Tableau Dynamique</h1>

<?php generateTable('2025-01-01', '2025-12-31'); ?>

</div>

document.addEventListener('DOMContentLoaded', () => {

const tableBody = document.getElementById('dataBody');

const storageKey = 'dynamicTableData'; // Clé de stockage pour localStorage

// Fonction pour récupérer les données depuis le localStorage

function loadDataFromStorage() {

const savedData = JSON.parse(localStorage.getItem(storageKey)) || [];

savedData.forEach((rowData, rowIndex) => {

const row = tableBody.rows[rowIndex];

if (row) {

const cells = row.querySelectorAll('.table_date');

cells.forEach((cell, cellIndex) => {

const cellData = rowData[cellIndex];

if (cellData) {

cell.dataset.status = cellData.status;

cell.textContent = cellData.status;

}

});

}

});

}

// Sauvegarder les données dans le localStorage

function saveDataToStorage() {

const data = [];

tableBody.querySelectorAll('tr').forEach(row => {

const rowData = [];

row.querySelectorAll('.table_date').forEach(cell => {

rowData.push({ status: cell.dataset.status });

});

data.push(rowData);

});

localStorage.setItem(storageKey, JSON.stringify(data));

}

// Gestion du clic sur les cellules

document.addEventListener('click', (e) => {

if (e.target.classList.contains('table_date')) {

e.target.dataset.status = e.target.dataset.status === '0' ? '1' : '0';

e.target.textContent = e.target.dataset.status;

saveDataToStorage(); // Sauvegarder après modification

}

});

// Gestion de l'ajout d'une nouvelle ligne

document.getElementById('addRowBtn').addEventListener('click', () => {

const newRow = document.createElement('tr');

const firstCell = document.createElement('td');

firstCell.classList.add('titre_nom');

firstCell.setAttribute('contenteditable', 'true');

firstCell.textContent = 'Not define';

newRow.appendChild(firstCell);

// Ajouter des cellules vides avec un contenu initial de 0

document.querySelectorAll('th').forEach(() => {

const cell = document.createElement('td');

cell.classList.add('table_date');

cell.textContent = '0'; // Valeur initiale de la cellule

cell.dataset.status = '0'; // Statut initial

newRow.appendChild(cell);

});

// Ajouter la nouvelle ligne au tableau

tableBody.appendChild(newRow);

// Sauvegarder les données de toutes les lignes

saveDataToStorage();

});

// Sauvegarder les données dans un fichier PHP

document.getElementById('saveBtn').addEventListener('click', () => {

const rows = document.querySelectorAll('#dataBody tr');

const dataToSave = [];

rows.forEach(row => {

const rowData = { name: row.cells[0]?.innerText || '' };

row.querySelectorAll('.table_date').forEach((cell, index) => {

rowData[`col${index + 1}`] = cell.dataset.status || '0';

});

dataToSave.push(rowData);

});

fetch('sauvegarde.php', {

method: 'POST',

headers: { 'Content-Type': 'application/json' },

body: JSON.stringify(dataToSave),

})

.then(response => response.text())

.then(result => {

alert('Données sauvegardées avec succès !');

console.log(result);

})

.catch(error => console.error('Erreur :', error));

});

// Charger les données stockées au démarrage

loadDataFromStorage();

});

</script>

</body>

</html>