(function ($) { $(function () { const $widget = $('.dealer-table').last().closest('.elementor-widget-html'); if (!$widget.length) return; const $dropdown = $widget.find('select.dealer-filter'); const $container = $widget.find('.dealer-container'); const $table = $widget.find('.dealer-table'); const $tbody = $table.find('tbody'); const fullRows = []; let currentRSM = '', currentSales = ''; $tbody.find('tr').each(function () { const cells = $(this).find('td'); let rsm, sales, region, dealer, phone, address; if (cells.length === 7) { rsm = currentRSM = cells.eq(1).text().trim(); sales = currentSales = cells.eq(2).text().trim(); region = cells.eq(3).text().trim(); dealer = cells.eq(4).text().trim(); phone = cells.eq(5).text().trim(); address = cells.eq(6).text().trim(); } else { // Fill in missing RSM/Sales values using previous rsm = currentRSM; sales = currentSales; region = cells.eq(1).text().trim(); dealer = cells.eq(2).text().trim(); phone = cells.eq(3).text().trim(); address = cells.eq(4).text().trim(); } fullRows.push({ rsm, sales, region, dealer, phone, address }); }); // Populate region filter dropdown const regions = [...new Set(fullRows.map(row => row.region))].sort(); regions.forEach(region => { $dropdown.append(`${region}`); }); // Handle filtering $dropdown.on('change', function () { const selected = $(this).val(); const filtered = fullRows.filter(r => r.region === selected); if (!selected || filtered.length === 0) { $container.hide(); return; } $tbody.empty(); filtered.forEach((r, i) => { const tr = $(''); tr.append(`${i + 1}`); tr.append(`${r.rsm}`); tr.append(`${r.sales}`); tr.append(`${r.region}`); tr.append(`${r.dealer}`); tr.append(`${r.phone}`); tr.append(`${r.address}`); $tbody.append(tr); }); $container.show(); }); }); })(jQuery);