File "table044.php"

Full Path: /home/analogde/www/Dev tableau/table044.php
File size: 9.65 KB
MIME-type: text/html
Charset: utf-8

<!DOCTYPE html>
<html lang="fr">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Tableau HTML</title>
    <!-- Ajoutez le lien vers Bootstrap -->
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
    <style>
        .table-container {
            width: 100%;
            overflow-x: auto;
            margin-bottom: 10px;
        }

        .fixed-column {
            position: sticky;
            left: 0;
            background: white;
            z-index: 2;
            border-left: 2px solid black;
            border-right: 1px solid black;
            padding-left: 10px;
            padding-right: 10px;
            width: 222px;
            min-width: 222px;
        }

        .second-fixed-column {
            position: sticky;
            left: 222px;
            background: white;
            z-index: 2;
            border-right: 1px solid black;
            padding-left: 5px;
            padding-right: 5px;
            width: 1px; 
            min-width: 1px; 
            white-space: nowrap;
        }

        th.fixed-column, th.second-fixed-column {
            top: 0;
            z-index: 3;
        }

        td:first-child {
            border-left: 2px solid black;
        }

        .active-cell {
            background-color: green;
            color: white;
        }

        .total-column {
            background-color: #f0f0f0;
            pointer-events: none;
            width: 25px;
        }

        .week-even {
            background-color: #e0f7fa;
        }

        .week-odd {
            background-color: #ffecb3;
        }

        .button-container {
            text-align: center;
            margin-top: 10px;
        }

        .grayed-out {
            background-color: #d3d3d3;
            pointer-events: none;
        }
    </style>
</head>
<body>
    <div class="table-container">
        <table id="data-table" class="table table-bordered table-striped table-hover">
            <thead>
                <tr>
                    <th class="fixed-column">Nom</th>
                    <th class="second-fixed-column total-column">Total</th>
                    <?php 
                        $start_date = new DateTime("2025-01-01");
                        $end_date = new DateTime("2025-12-31");
                        $holidays = [
                            "01/01", "01/05", "08/05", "14/07", "15/08", "01/11", "11/11", "25/12", 
                            date("d/m", strtotime("2025-05-29")), 
                            date("d/m", strtotime("2025-06-08"))
                        ];
                        $dates = [];
                        while ($start_date <= $end_date) {
                            $dayOfWeek = $start_date->format("N");
                            $formattedDate = $start_date->format("d");
                            if ($dayOfWeek < 6 && !in_array($formattedDate, $holidays)) {
                                $weekNumber = $start_date->format("W");
                                $month = $start_date->format("m");
                                $dates[] = ["date" => $formattedDate, "week" => $weekNumber, "month" => $month];
                            }
                            $start_date->modify("+1 day");
                        }
                        $currentWeek = null;
                        $weekClass = "week-even";
                        $lastMonth = null;
                        $months = [
                            "01" => "Janvier", "02" => "Février", "03" => "Mars", "04" => "Avril",
                            "05" => "Mai", "06" => "Juin", "07" => "Juillet", "08" => "Août",
                            "09" => "Septembre", "10" => "Octobre", "11" => "Novembre", "12" => "Décembre"
                        ];

                        foreach ($dates as $data) {
                            $monthName = isset($months[$data['month']]) ? $months[$data['month']] : 'Mois inconnu';
                            if ($currentWeek !== $data['week']) {
                                $currentWeek = $data['week'];
                                $weekClass = ($weekClass === "week-even") ? "week-odd" : "week-even";
                            }
                            echo "<th class='$weekClass'>{$data['date']}</th>";
                        }
                    ?>
                </tr>
            </thead>
            <tbody>
                <tr>
                    <td class="fixed-column">Mois</td>
                    <td class="second-fixed-column"></td>
                    <?php 
                        $currentMonth = null;
                        $count = 1;
                        foreach ($dates as $index => $data) {
                            if ($currentMonth !== $data['month']) {
                                if ($currentMonth !== null) {
                                    echo "<td colspan='$count'>{$months[$currentMonth]}</td>";
                                }
                                $currentMonth = $data['month'];
                                $count = 1;
                            } else {
                                $count++;
                            }
                            if ($index == count($dates) - 1) {
                                echo "<td colspan='$count'>{$months[$currentMonth]}</td>";
                            }
                        }
                    ?>
                </tr>
                <tr>
                    <td class="fixed-column">Semaine</td>
                    <td class="second-fixed-column"></td>
                    <?php 
                        $currentWeek = null;
                        $weekCount = 1;
                        foreach ($dates as $index => $data) {
                            if ($currentWeek !== $data['week']) {
                                if ($currentWeek !== null) {
                                    echo "<td colspan='$weekCount'>{$currentWeek}</td>";
                                }
                                $currentWeek = $data['week'];
                                $weekCount = 1;
                            } else {
                                $weekCount++;
                            }
                            if ($index == count($dates) - 1) {
                                echo "<td colspan='$weekCount'>{$currentWeek}</td>";
                            }
                        }
                    ?>
                </tr>
            </tbody>
        </table>
    </div>

    <div class="button-container">
        <button class="btn btn-primary" onclick="addRow()">Ajouter une ligne</button>
    </div>

    <script>
        function addRow() {
            let table = document.getElementById("data-table");
            let row = table.insertRow(-1);
            
            // Première cellule - Combo Box
            let cell1 = row.insertCell(0);
            cell1.classList.add("fixed-column");
            let select = document.createElement("select");
            select.addEventListener("change", function(event) {
                // Ajouter ici des actions à effectuer lors de la sélection d'un item
                select.blur();
            });

            // Ajouter des options à la combo box
            let option1 = document.createElement("option");
            option1.value = "Option 1";
            option1.textContent = "Option 1";
            select.appendChild(option1);

            let option2 = document.createElement("option");
            option2.value = "Option 2";
            option2.textContent = "Option 2";
            select.appendChild(option2);

            let option3 = document.createElement("option");
            option3.value = "Option 3";
            option3.textContent = "Option 3";
            select.appendChild(option3);

            // Ajouter le select dans la cellule
            cell1.appendChild(select);
            
            // Deuxième cellule - Total
            let cell2 = row.insertCell(1);
            cell2.classList.add("second-fixed-column", "total-column");
            cell2.innerText = "0";
            
            // Ajouter les autres cellules de la ligne
            for (let i = 2; i < table.rows[0].cells.length; i++) {
                let cell = row.insertCell(i);
                cell.innerText = "0";
                cell.onclick = function() {
                    toggleCell(cell, row);
                };
            }
        }

        function toggleCell(cell, row) {
            if (cell.innerText === '0') {
                cell.innerText = '1';
                cell.classList.add('active-cell');
            } else {
                cell.innerText = '0';
                cell.classList.remove('active-cell');
            }
            updateTotal(row);
        }

        function updateTotal(row) {
            let total = 0;
            for (let i = 2; i < row.cells.length; i++) {
                let cellValue = parseInt(row.cells[i].innerText);
                if (!isNaN(cellValue)) {
                    total += cellValue;
                }
            }
            row.cells[1].innerText = total;
        }
    </script>

    <!-- Lien vers Bootstrap JS et dépendances -->
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.0.6/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>
</html>