Embed

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Avis des Clients</title>
    <style>
        body {
            font-family: Arial, sans-serif;
        }
        .reviews {
            max-width: 600px;
            margin: 20px auto;
            padding: 20px;
            border: 1px solid #ddd;
            border-radius: 8px;
            box-shadow: 0 4px 8px rgba(0,0,0,0.1);
        }
        .review {
            border-bottom: 1px solid #ddd;
            padding: 10px 0;
        }
        .review-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 5px;
        }
        .star {
            color: #f5b301;
            font-size: 1.2em;
            margin-left: 5px;
        }
        .empty-star {
            color: #ddd;
            font-size: 1.2em;
            margin-left: 5px;
        }
    </style>
</head>
<body>

<div class="reviews" id="reviews">
    <h2>veuillez rafraichir la page</h2>
    
</div>

<script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/5.3.0/papaparse.min.js"></script>
<script>
    const SHEET_URL = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vToMdhkblb9N9WvTmMyWoQN8JzJ1Bl83_Zl_SbFptDEsRP_KWf-huIMDc_f8gSUfd04zp_UXXuC_Hne/pub?output=csv&gid=1279635760';

    async function fetchReviews() {
        const response = await fetch(SHEET_URL, {
            headers: {
                'Cache-Control': 'no-cache'
            }
        });
        const csvData = await response.text();
        Papa.parse(csvData, {
            header: true,
            complete: function(results) {
                const reviews = results.data.map(row => ({
                    firstName: row[Object.keys(row)[2]],
                    lastName: row[Object.keys(row)[1]],
                    rating: row[Object.keys(row)[5]],
                    comment: row[Object.keys(row)[4]]
                }));
                displayReviews(reviews);
            }
        });
    }

    function displayReviews(reviews) {
        const reviewsContainer = document.getElementById('reviews');
        reviewsContainer.innerHTML = ''; // Clear existing reviews
        reviews.forEach(review => {
            const reviewElement = document.createElement('div');
            reviewElement.classList.add('review');
            reviewElement.innerHTML = `
                <div class="review-header">
                    <p><strong>${review.firstName} ${review.lastName.charAt(0)}.</strong></p>
                    <div class="star-rating">
                        ${review.rating}
                    </div>
                </div>
                <p>${review.comment}</p>
            `;
            reviewsContainer.appendChild(reviewElement);
        });
    }

    document.addEventListener('DOMContentLoaded', () => {
        fetchReviews();
        setInterval(fetchReviews, 30000); // Refresh every 30 seconds
    });
</script>

</body>
</html>