/* ========================================================= WORTEN | PDP - REVIEWS POR MARCA VARIANTE B + GA4 A/B TEST - Marca dinâmica via MutationObserver - Reviews da marca via XLSX / CSV / JSON - Link dinâmico para loja da marca - Fallback sem reviews - GA4 view / click marca / click A2C - SKU e reviews do produto dinâmicos - Sem dependências externas ========================================================= */ (function () { "use strict"; /* ========================================================= 1. CONFIGURATION ========================================================= */ const CONFIG = { dataUrl: "/i2/01M4T7GG6NFAQ7124486XD3KF0/01M4T7GGFCJHWH3Z4NFXRGVHDV", brandUrl: "/marcas/", eventCategory: "raw_brand_reviews|variant_b", observerDelay: 150, viewThreshold: 0.5, missingValue: "NA", debug: false, /* Confirmar estes seletores no DOM real da PDP */ skuSelectors: [ '[itemprop="sku"]', 'meta[property="product:retailer_item_id"]', 'meta[name="sku"]', '[data-product-sku]', '[data-sku]' ], productRatingSelectors: [ '[itemprop="aggregateRating"] [itemprop="ratingValue"]', '[itemprop="ratingValue"]', 'meta[itemprop="ratingValue"]', '.rating__value', '.reviews-rating__value' ], productCountSelectors: [ '[itemprop="aggregateRating"] [itemprop="reviewCount"]', '[itemprop="reviewCount"]', 'meta[itemprop="reviewCount"]', '.rating__count', '.reviews-rating__count' ], addToCartSelectors: [ 'button[data-testid="add-to-cart"]', 'button[data-test="add-to-cart"]', 'button[data-qa="add-to-cart"]', 'button.add-to-cart', '.add-to-cart button' ] }; const SELECTORS = { root: ".wrt-pdp-brand-reviews", link: ".wrt-pdp-brand-reviews__link", brand: ".wrt-pdp-brand-reviews__brand", reviews: ".wrt-pdp-brand-reviews__reviews", rating: ".wrt-pdp-brand-reviews__rating", reviewBrand: ".wrt-pdp-brand-reviews__review-brand", count: ".wrt-pdp-brand-reviews__count" }; const root = document.querySelector(SELECTORS.root); if (!root || root.dataset.initialized === "true") { return; } const elements = { link: root.querySelector(SELECTORS.link), brand: root.querySelector(SELECTORS.brand), reviews: root.querySelector(SELECTORS.reviews), rating: root.querySelector(SELECTORS.rating), reviewBrand: root.querySelector(SELECTORS.reviewBrand), count: root.querySelector(SELECTORS.count) }; if (Object.values(elements).some(el => !el)) { return; } root.dataset.initialized = "true"; let currentBrandKey = ""; let currentBrandName = ""; let currentSku = ""; let currentPath = location.pathname; let currentBrandData = null; let dataPromise = null; let observerTimer = null; let viewObserver = null; let renderVersion = 0; let pendingView = false; const sentViews = new Set(); const log = (...args) => { if (CONFIG.debug) { console.log("[PDP Brand Reviews B]", ...args); } }; /* ========================================================= 2. HELPERS ========================================================= */ function normalizeBrand(value) { return String(value || "") .normalize("NFD") .replace(/[\u0300-\u036f]/g, "") .trim() .toLowerCase() .replace(/&/g, " e ") .replace(/[^a-z0-9]+/g, ""); } function createBrandSlug(value) { return String(value || "") .normalize("NFD") .replace(/[\u0300-\u036f]/g, "") .trim() .toLowerCase() .replace(/[/\\'\s]+/g, "-") .replace(/[^a-z0-9-]/g, "-") .replace(/-+/g, "-") .replace(/^-|-$/g, ""); } function parseNumber(value) { if (typeof value === "number") { return Number.isFinite(value) ? value : NaN; } let text = String(value ?? "") .trim() .replace(/\s/g, ""); if (!text) return NaN; if (text.includes(",") && text.includes(".")) { if (text.lastIndexOf(",") > text.lastIndexOf(".")) { text = text.replace(/\./g, "").replace(",", "."); } else { text = text.replace(/,/g, ""); } } else if (text.includes(",")) { text = text.replace(",", "."); } const number = Number(text); return Number.isFinite(number) ? number : NaN; } function findElement(selectors) { for (const selector of selectors) { const element = document.querySelector(selector); if (element) return element; } return null; } function getElementValue(element) { if (!element) return ""; return String( element.getAttribute("content") || element.getAttribute("data-product-sku") || element.getAttribute("data-sku") || element.textContent || "" ).trim(); } /* ========================================================= 3. STRUCTURED PRODUCT DATA ========================================================= */ function getStructuredProduct() { const scripts = document.querySelectorAll( 'script[type="application/ld+json"]' ); function findProduct(value) { if (!value || typeof value !== "object") { return null; } if (Array.isArray(value)) { for (const item of value) { const result = findProduct(item); if (result) return result; } return null; } const types = Array.isArray(value["@type"]) ? value["@type"] : [value["@type"]]; if (types.some(type => typeof type === "string" && type.toLowerCase() === "product" )) { return value; } if (value["@graph"]) { return findProduct(value["@graph"]); } return null; } for (const script of scripts) { try { const data = JSON.parse(script.textContent); const product = findProduct(data); if (product) return product; } catch (error) { log("JSON-LD inválido:", error); } } return null; } /* ========================================================= 4. SKU AND PRODUCT REVIEWS ========================================================= */ function getSku() { const element = findElement( CONFIG.skuSelectors ); const directSku = getElementValue(element); if (directSku) return directSku; const product = getStructuredProduct(); if (product && product.sku) { return String(product.sku).trim(); } return CONFIG.missingValue; } function getProductReviews() { const ratingElement = findElement( CONFIG.productRatingSelectors ); const countElement = findElement( CONFIG.productCountSelectors ); let rating = getElementValue(ratingElement); let count = getElementValue(countElement); const product = getStructuredProduct(); if (product && product.aggregateRating) { const aggregate = Array.isArray( product.aggregateRating ) ? product.aggregateRating[0] : product.aggregateRating; if (!rating) { rating = aggregate.ratingValue ?? ""; } if (!count) { count = aggregate.reviewCount ?? aggregate.ratingCount ?? ""; } } const ratingNumber = parseNumber(rating); const countNumber = parseNumber(count); return { rating: Number.isFinite(ratingNumber) && ratingNumber >= 0 && ratingNumber <= 5 ? ratingNumber.toFixed(1) : CONFIG.missingValue, count: Number.isFinite(countNumber) && countNumber >= 0 ? String(Math.floor(countNumber)) : CONFIG.missingValue }; } /* ========================================================= 5. REVIEW FORMATTING ========================================================= */ function formatRating(value) { const number = parseNumber(value); if ( !Number.isFinite(number) || number < 0 || number > 5 ) { return ""; } return number.toLocaleString("pt-PT", { minimumFractionDigits: 1, maximumFractionDigits: 1 }); } function formatReviewCount(value) { const number = parseNumber(value); if (!Number.isFinite(number) || number <= 0) { return ""; } const count = Math.floor(number); if (count >= 1000000) { const millions = count / 1000000; const formatted = millions.toLocaleString( "pt-PT", { maximumFractionDigits: 1 } ); return ( "(+" + formatted + (millions >= 2 ? " milhões" : " milhão") + " de avaliações)" ); } if (count >= 1000) { const thousands = Math.floor(count / 1000); return "(+" + thousands + " mil avaliações)"; } return "(" + count.toLocaleString("pt-PT") + (count === 1 ? " avaliação)" : " avaliações)"); } /* ========================================================= 6. GET PRODUCT BRAND ========================================================= */ function getProductBrand() { const rows = document.querySelectorAll( ".table-specifications__row" ); for (const row of rows) { const label = row.querySelector( ".table__subtitle" ); if (!label) continue; const labelText = label.textContent .trim() .replace(/:$/, "") .toLowerCase(); if (labelText !== "marca") continue; const value = row.querySelector( ".table-specifications__right-container" ); if (!value) continue; const brand = value.textContent.trim(); if ( brand && !/^(n[aã]o|undefined|null|n\/a|-)$/ .test(brand.toLowerCase()) ) { return brand; } } return ""; } /* ========================================================= 7. PARSE CSV ========================================================= */ function parseCSV(text) { const source = String(text) .replace(/^\uFEFF/, ""); const firstLine = source.split(/\r?\n/, 1)[0] || ""; const delimiters = [";", ",", "\t"]; function countDelimiter(line, delimiter) { let count = 0; let quoted = false; for (const char of line) { if (char === '"') { quoted = !quoted; } else if (!quoted && char === delimiter) { count++; } } return count; } const delimiter = delimiters.sort( (a, b) => countDelimiter(firstLine, b) - countDelimiter(firstLine, a) )[0]; const rows = []; let row = []; let cell = ""; let quoted = false; for (let i = 0; i < source.length; i++) { const char = source[i]; if (char === '"') { if (quoted && source[i + 1] === '"') { cell += '"'; i++; } else { quoted = !quoted; } } else if (char === delimiter && !quoted) { row.push(cell); cell = ""; } else if ( (char === "\n" || char === "\r") && !quoted ) { if ( char === "\r" && source[i + 1] === "\n" ) { i++; } row.push(cell); if (row.some(value => value.trim())) { rows.push(row); } row = []; cell = ""; } else { cell += char; } } row.push(cell); if (row.some(value => value.trim())) { rows.push(row); } if (!rows.length) return []; const headers = rows.shift().map( header => header.trim() ); return rows.map(values => { const item = {}; headers.forEach((header, index) => { item[header] = values[index] ?? ""; }); return item; }); } /* ========================================================= 8. XLSX READER Native Browser APIs - No external libraries ========================================================= */ async function readXLSX(buffer) { if ( typeof DecompressionStream === "undefined" || typeof DOMParser === "undefined" ) { throw new Error( "Browser não suporta leitura nativa de XLSX." ); } const bytes = new Uint8Array(buffer); const view = new DataView(buffer); const decoder = new TextDecoder("utf-8"); function u16(offset) { return view.getUint16(offset, true); } function u32(offset) { return view.getUint32(offset, true); } let eocd = -1; const minimum = Math.max( 0, bytes.length - 65557 ); for ( let i = bytes.length - 22; i >= minimum; i-- ) { if (u32(i) === 0x06054b50) { eocd = i; break; } } if (eocd < 0) { throw new Error("Estrutura ZIP inválida."); } const entryCount = u16(eocd + 10); const centralOffset = u32(eocd + 16); const entries = new Map(); let pointer = centralOffset; for (let i = 0; i < entryCount; i++) { if (u32(pointer) !== 0x02014b50) { throw new Error("Diretório ZIP inválido."); } const method = u16(pointer + 10); const compressedSize = u32(pointer + 20); const nameLength = u16(pointer + 28); const extraLength = u16(pointer + 30); const commentLength = u16(pointer + 32); const localOffset = u32(pointer + 42); const name = decoder.decode( bytes.slice( pointer + 46, pointer + 46 + nameLength ) ); entries.set(name, { method, compressedSize, localOffset }); pointer += 46 + nameLength + extraLength + commentLength; } async function getXML(path) { const entry = entries.get(path); if (!entry) return null; const offset = entry.localOffset; if (u32(offset) !== 0x04034b50) { throw new Error("Entrada ZIP inválida."); } const nameLength = u16(offset + 26); const extraLength = u16(offset + 28); const start = offset + 30 + nameLength + extraLength; const end = start + entry.compressedSize; if (end > bytes.length) { throw new Error("XLSX incompleto."); } const compressed = bytes.slice(start, end); let output; if (entry.method === 0) { output = compressed; } else if (entry.method === 8) { const stream = new Blob([compressed]) .stream() .pipeThrough( new DecompressionStream("deflate-raw") ); output = new Uint8Array( await new Response(stream).arrayBuffer() ); } else { throw new Error( "Compressão XLSX não suportada." ); } const xml = new DOMParser().parseFromString( decoder.decode(output), "application/xml" ); if ( xml.getElementsByTagName("parsererror").length ) { throw new Error("XML inválido."); } return xml; } function extractText(node) { return Array.from( node.getElementsByTagName("t") ) .map(el => el.textContent || "") .join(""); } /* Shared strings */ const sharedStrings = []; const stringsXML = await getXML( "xl/sharedStrings.xml" ); if (stringsXML) { const nodes = stringsXML.getElementsByTagName("si"); for (const node of nodes) { sharedStrings.push(extractText(node)); } } /* First worksheet */ const worksheetPaths = Array.from( entries.keys() ) .filter(path => /^xl\/worksheets\/[^/]+\.xml$/i.test(path) ) .sort(); if (!worksheetPaths.length) { throw new Error( "Nenhuma folha encontrada no XLSX." ); } const worksheet = await getXML( worksheetPaths[0] ); if (!worksheet) { throw new Error( "Não foi possível ler a folha." ); } function columnIndex(reference) { const letters = String(reference).match(/^[A-Z]+/i)?.[0] || ""; let index = 0; for (const letter of letters.toUpperCase()) { index = index * 26 + letter.charCodeAt(0) - 64; } return index - 1; } const table = []; const xmlRows = worksheet.getElementsByTagName("row"); for (const xmlRow of xmlRows) { const values = []; const cells = xmlRow.getElementsByTagName("c"); for (const cell of cells) { const ref = cell.getAttribute("r") || ""; const type = cell.getAttribute("t") || ""; const index = columnIndex(ref); if (index < 0) continue; let value = ""; if (type === "inlineStr") { value = extractText(cell); } else { const valueNode = cell.getElementsByTagName("v")[0]; value = valueNode ? valueNode.textContent : ""; if (type === "s") { value = sharedStrings[Number(value)] ?? ""; } } values[index] = value; } table.push(values); } if (!table.length) return []; const headers = table.shift().map( header => String(header ?? "").trim() ); return table.map(values => { const item = {}; headers.forEach((header, index) => { item[header] = values[index] ?? ""; }); return item; }); } /* ========================================================= 9. LOAD BRAND DATA ========================================================= */ async function fetchReviewData() { const response = await fetch(CONFIG.dataUrl, { credentials: "same-origin", cache: "default" }); if (!response.ok) { throw new Error( "Erro HTTP: " + response.status ); } const buffer = await response.arrayBuffer(); const bytes = new Uint8Array(buffer); if (!bytes.length) { throw new Error("Ficheiro vazio."); } let records; if ( bytes[0] === 0x50 && bytes[1] === 0x4b ) { records = await readXLSX(buffer); } else { const text = new TextDecoder("utf-8") .decode(bytes) .replace(/^\uFEFF/, "") .trim(); if (text.startsWith("<")) { throw new Error( "URL devolveu HTML/XML." ); } if ( text.startsWith("[") || text.startsWith("{") ) { const json = JSON.parse(text); records = Array.isArray(json) ? json : json.data || json.records || json.items; } else { records = parseCSV(text); } } if (!Array.isArray(records)) { throw new Error( "Formato de dados não reconhecido." ); } const brands = new Map(); for (const record of records) { const normalizedRecord = {}; for (const [key, value] of Object.entries( record )) { normalizedRecord[ String(key).trim().toLowerCase() ] = value; } const brandName = String( normalizedRecord.marca || "" ).trim(); if (!brandName) continue; const key = normalizeBrand(brandName); if (!key) continue; brands.set(key, { brand: brandName, rating: normalizedRecord.avg_rating, count: normalizedRecord.nr_total_reviews }); } if (!brands.size) { throw new Error( "Nenhuma marca válida encontrada." ); } log("Marcas carregadas:", brands.size); return brands; } function getReviewData() { if (!dataPromise) { dataPromise = fetchReviewData() .catch(error => { log("Erro nos dados:", error); throw error; }); } return dataPromise; } /* ========================================================= 10. GA4 EVENT LABEL ========================================================= */ function getBrandAnalytics() { if (!currentBrandData) { return { rating: CONFIG.missingValue, count: CONFIG.missingValue }; } const rating = parseNumber( currentBrandData.rating ); const count = parseNumber( currentBrandData.count ); return { rating: Number.isFinite(rating) && rating >= 0 && rating <= 5 ? rating.toFixed(1) : CONFIG.missingValue, count: Number.isFinite(count) && count >= 0 ? String(Math.floor(count)) : CONFIG.missingValue }; } function getEventLabel() { const product = getProductReviews(); const brand = getBrandAnalytics(); return [ product.rating, product.count, brand.rating, brand.count ].join("|"); } /* ========================================================= 11. GA4 PUSH ========================================================= */ function pushGA4(action) { window.dataLayer = window.dataLayer || []; const eventData = { event: "event.generic_GA4", eventCategory: CONFIG.eventCategory, eventAction: action, eventPosition: getSku(), eventLabel: getEventLabel() }; window.dataLayer.push(eventData); log("GA4:", eventData); } /* ========================================================= 12. RENDERING ========================================================= */ function hideReviews() { elements.reviews.hidden = true; elements.rating.textContent = ""; elements.reviewBrand.textContent = ""; elements.count.textContent = ""; } function renderBrand(brandName) { const slug = createBrandSlug(brandName); if (!slug) { root.dataset.ready = "false"; return false; } elements.brand.textContent = brandName; elements.link.href = CONFIG.brandUrl + encodeURIComponent(slug); elements.link.setAttribute( "aria-label", "Ver loja " + brandName ); hideReviews(); root.dataset.ready = "true"; return true; } function renderReviews(brandName, data) { if (!data) { hideReviews(); return; } const rating = formatRating(data.rating); const count = formatReviewCount(data.count); if (!rating || !count) { hideReviews(); return; } elements.rating.textContent = rating; elements.reviewBrand.textContent = brandName; elements.count.textContent = count; elements.reviews.hidden = false; elements.link.setAttribute( "aria-label", "Ver loja " + brandName + ". Classificação média de " + rating + " estrelas. " + count.replace(/[()]/g, "") ); } /* ========================================================= 13. VIEW TRACKING ========================================================= */ function getViewKey() { return [ location.pathname, currentBrandKey, getSku() ].join("|"); } function sendView() { if (!pendingView) return; const key = getViewKey(); if (sentViews.has(key)) { pendingView = false; return; } sentViews.add(key); pendingView = false; pushGA4("view"); } function setupViewObserver() { if (viewObserver) { viewObserver.disconnect(); viewObserver = null; } if (root.dataset.ready !== "true") { return; } if (sentViews.has(getViewKey())) { return; } pendingView = true; if (!("IntersectionObserver" in window)) { if (root.getBoundingClientRect().width > 0) { sendView(); } return; } viewObserver = new IntersectionObserver( entries => { for (const entry of entries) { if ( entry.isIntersecting && entry.intersectionRatio >= CONFIG.viewThreshold ) { sendView(); viewObserver.disconnect(); viewObserver = null; break; } } }, { threshold: CONFIG.viewThreshold } ); viewObserver.observe(root); } /* ========================================================= 14. CLICK BRAND ========================================================= */ elements.link.addEventListener( "click", function () { if (root.dataset.ready !== "true") { return; } pushGA4("click - marca"); } ); /* ========================================================= 15. CLICK ADD TO CART PDP ========================================================= */ function isAddToCartButton(element) { const matchesSelector = CONFIG.addToCartSelectors.some(selector => { try { return element.matches(selector); } catch { return false; } }); if (matchesSelector) return true; const label = [ element.textContent, element.getAttribute("aria-label"), element.getAttribute("title") ] .filter(Boolean) .join(" ") .normalize("NFD") .replace(/[\u0300-\u036f]/g, "") .toLowerCase(); return ( label.includes("adicionar ao carrinho") || label.includes("adicionar a cesta") ); } function isMainPdpButton(button) { if (!button) return false; if ( button.closest( [ ".swiper-slide", ".slick-slide", ".recommendations", ".related-products", ".product-card", ".product-tile", "[data-highlight-template]" ].join(",") ) ) { return false; } return true; } document.addEventListener( "click", function (event) { const target = event.target; if (!(target instanceof Element)) return; const button = target.closest( 'button, [role="button"], input[type="submit"]' ); if (!button) return; if (!isAddToCartButton(button)) return; if (!isMainPdpButton(button)) return; if ( button.disabled || button.getAttribute("aria-disabled") === "true" ) { return; } if (root.dataset.ready !== "true") { return; } pushGA4( "click - adicionar ao carrinho pdp" ); }, true ); /* ========================================================= 16. UPDATE BRAND ========================================================= */ async function updateBrand() { const brandName = getProductBrand(); const brandKey = normalizeBrand(brandName); const sku = getSku(); const path = location.pathname; if (!brandName || !brandKey) { if (currentBrandKey) { currentBrandKey = ""; currentBrandName = ""; currentBrandData = null; currentSku = ""; renderVersion++; root.dataset.ready = "false"; hideReviews(); pendingView = false; if (viewObserver) { viewObserver.disconnect(); viewObserver = null; } } return; } const brandChanged = brandKey !== currentBrandKey; const productChanged = sku !== currentSku || path !== currentPath; if (!brandChanged && !productChanged) { return; } currentBrandKey = brandKey; currentBrandName = brandName; currentSku = sku; currentPath = path; const version = ++renderVersion; currentBrandData = null; pendingView = false; if (viewObserver) { viewObserver.disconnect(); viewObserver = null; } if (!renderBrand(brandName)) { return; } log("Produto detetado:", { brand: brandName, sku }); try { const brands = await getReviewData(); if (version !== renderVersion) { return; } const reviewData = brands.get(brandKey); if (reviewData) { const rating = parseNumber( reviewData.rating ); const count = parseNumber( reviewData.count ); if ( Number.isFinite(rating) && rating >= 0 && rating <= 5 && Number.isFinite(count) && count > 0 ) { currentBrandData = reviewData; renderReviews( brandName, reviewData ); } else { hideReviews(); } } else { log("Marca sem reviews:", brandName); hideReviews(); } } catch (error) { if (version !== renderVersion) { return; } hideReviews(); log("Fallback ativo:", error.message); } if (version !== renderVersion) { return; } /* View after brand data has been resolved */ setupViewObserver(); } /* ========================================================= 17. MUTATION OBSERVER ========================================================= */ function scheduleUpdate() { if (observerTimer !== null) { return; } observerTimer = setTimeout(() => { observerTimer = null; updateBrand(); }, CONFIG.observerDelay); } const observer = new MutationObserver(mutations => { const relevant = mutations.some(mutation => { return !root.contains(mutation.target); }); if (relevant) { scheduleUpdate(); } }); const target = document.body || document.documentElement; observer.observe(target, { childList: true, subtree: true, characterData: true }); /* ========================================================= 18. INITIALIZATION ========================================================= */ updateBrand(); log("Variante B inicializada."); })();

Livro Pro Oracle SQL Development de Jon Heller (Inglês)