Oferta

document.getElementById('export-btn').addEventListener('click', function () { const allPosts = document.querySelectorAll('.brz-posts__item'); // Select all posts const selectedPosts = [];

// Collect data from selected posts allPosts.forEach((post) => { const checkbox = post.querySelector('input[name="select-post"]'); // Select the checkbox inside the post if (checkbox && checkbox.checked) { const spans = post.querySelectorAll("span.text-population"); const links = post.querySelectorAll(".link--external");

const furnizorElement = spans[0]; const orasElement = spans[1]; const adresaElement = spans[2]; const pictureEl = links[0]; // Assuming the picture link is the first in the list const formatElement = spans[4]; const numarFeteElement = spans[5]; const codElement = spans[6]; const locationElement = spans[7]; const sizeElement = spans[8]; const surfaceElement = spans[9]; const decorElement = spans[10]; const gpsElement = spans[11]; const linkGoogleMapsElement = links[1]; // Google Maps link const mapElement = links[2]; // Map link const schitaProductieElement = links[3]; // Schita Productie link

const furnizor = furnizorElement ? furnizorElement.innerText.trim() : 'No Furnizor Found'; const oras = orasElement ? orasElement.innerText.trim() : 'No Oras Found'; const adresa = adresaElement ? adresaElement.innerText.trim() : 'No Adresa Found'; const picture = pictureEl ? pictureEl.href : 'No Image Link Found'; const format = formatElement ? formatElement.innerText.trim() : 'No Format Found'; const numarFete = numarFeteElement ? numarFeteElement.innerText.trim() : 'No Numar Fete Found'; const cod = codElement ? codElement.innerText.trim() : 'No Cod Found'; const location = locationElement ? locationElement.innerText.trim() : 'No Location Found'; const size = sizeElement ? sizeElement.innerText.trim() : 'No Size Found'; const surface = surfaceElement ? surfaceElement.innerText.trim() : 'No Surface Found'; const decor = decorElement ? decorElement.innerText.trim() : 'No Decor Found'; const gps = gpsElement ? gpsElement.innerText.trim() : 'No GPS Found'; const linkGoogleMaps = linkGoogleMapsElement ? linkGoogleMapsElement.href : 'No Google Maps Link Found'; const map = mapElement ? mapElement.href : 'No Map Link Found'; const schitaProductie = schitaProductieElement ? schitaProductieElement.href : 'No Schita Productie Link Found';

selectedPosts.push({ Furnizor: furnizor, Oras: oras, Adresa: adresa, Picture: picture, Format: format, Numar_Fete: numarFete, Cod: cod, Location: location, Size: size, Surface: surface, Decor: decor, GPS: gps, Google_Maps_Link: linkGoogleMaps, Map: map, Schita_Productie: schitaProductie }); } });

if (selectedPosts.length === 0) { alert('Please select at least one post to export.'); return; }

const worksheet = XLSX.utils.json_to_sheet(selectedPosts); // Convert JSON data to worksheet

// Add hyperlinks to specific columns selectedPosts.forEach((post, index) => { const rowIndex = index + 2; // Row index starts at 2 (1-based indexing) if (post.Picture !== 'No Image Link Found') { worksheet[`D${rowIndex}`] = { t: 's', v: 'Click aici', l: { Target: post.Picture } }; // Picture link } if (post.Google_Maps_Link !== 'No Google Maps Link Found') { worksheet[`M${rowIndex}`] = { t: 's', v: 'Click aici', l: { Target: post.Google_Maps_Link } }; // Google Maps link } if (post.Map !== 'No Map Link Found') { worksheet[`N${rowIndex}`] = { t: 's', v: 'Click aici', l: { Target: post.Map } }; // Map link } if (post.Schita_Productie !== 'No Schita Productie Link Found') { worksheet[`O${rowIndex}`] = { t: 's', v: 'Click aici', l: { Target: post.Schita_Productie } }; // Schita Productie link } });

const workbook = XLSX.utils.book_new(); // Create a new workbook XLSX.utils.book_append_sheet(workbook, worksheet, 'Posts'); // Append the worksheet to the workbook

// Generate current date and time for filename const now = new Date(); const date = now.toISOString().split('T')[0]; // YYYY-MM-DD const time = now.toTimeString().split(' ')[0].replace(/:/g, '-'); // HH-MM-SS

const fileName = `Disponibil VanBerry ${date} - ${time}.xlsx`;

// Download the Excel file XLSX.writeFile(workbook, fileName); });