S\u00e9lection de filtre Excel<\/title>\n <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.17.0\/xlsx.full.min.js\"><\/script>\n \n<\/head>\n<body>\n <div class=\"filter-box\">\n <div class=\"filter-header\">Filtres avec menus d\u00e9roulants + mots-cl\u00e9s \u00e0 droite (saisir ou s\u00e9lectionner plusieurs)<\/div>\n <div class=\"filter-body\">\n <div class=\"filter-left\">\n <label>Statut<\/label>\n <select id=\"statusFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>Domaine th\u00e9matique<\/label>\n <select id=\"themenbereichFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>R\u00e9gion<\/label>\n <select id=\"regionFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>Langue<\/label>\n <select id=\"spracheFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <div class=\"filter-actions\">\n <span id=\"applyFiltersLeft\">Filtrer<\/span>\n <span id=\"resetFiltersLeft\">R\u00e9initialiser<\/span>\n <\/div>\n <\/div>\n\n <div class=\"filter-right\">\n <div class=\"search-wrapper\">\n <label for=\"keywordsInput\">Mots-cl\u00e9s<\/label>\n <input\n type=\"text\"\n id=\"keywordsInput\"\n placeholder=\"Saisir des mots-cl\u00e9s (s\u00e9par\u00e9s par des virgules), ex. \u00c9rosion, fortes pluies\"\n \/>\n <div class=\"helper-text\">\n Astuce : s\u00e9lection multiple avec <b>Ctrl<\/b> (Windows) \/ <b>Cmd<\/b> (Mac) ou <b>Shift<\/b>.\n <\/div>\n\n <select id=\"keywordsMulti\" multiple><\/select>\n\n <div class=\"filter-actions\">\n <span id=\"applyFiltersRight\">Filtrer<\/span>\n <span id=\"resetFiltersRight\">R\u00e9initialiser<\/span>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"result-header\" id=\"resultCount\">R\u00e9sultats : 0<\/div>\n <div id=\"dataDisplay\" class=\"hidden\"><\/div>\n\n <script>\n document.addEventListener(\"DOMContentLoaded\", function () {\n const statusFilter = document.getElementById(\"statusFilter\");\n const themenbereichFilter = document.getElementById(\"themenbereichFilter\");\n const regionFilter = document.getElementById(\"regionFilter\");\n const spracheFilter = document.getElementById(\"spracheFilter\");\n\n const keywordsInput = document.getElementById(\"keywordsInput\");\n const keywordsMulti = document.getElementById(\"keywordsMulti\");\n\n const dataDisplay = document.getElementById(\"dataDisplay\");\n const resultCount = document.getElementById(\"resultCount\");\n\n const applyButtons = [\n document.getElementById(\"applyFiltersLeft\"),\n document.getElementById(\"applyFiltersRight\"),\n ];\n const resetButtons = [\n document.getElementById(\"resetFiltersLeft\"),\n document.getElementById(\"resetFiltersRight\"),\n ];\n\n let data = [];\n let filteredData = [];\n\n const COL = {\n THEMENBEREICH: \"Themenbereich\",\n TITEL: \"Titel\",\n REGION: \"Region\",\n ORGANISATION: \"Organisation\",\n ZEITRAUM: \"Zeitraum\",\n STATUS: \"Status\",\n KEYWORDS: \"Keywords\",\n INFO_TEXT: \"Information \/ Quelle\",\n INFO_URL_CANDIDATES: [\"Information \/ Quelle_1\", \"Information \/ Quelle (2)\", \"Information \/ Quelle_2\"],\n SPRACHE: \"Sprache\",\n };\n\n function normalizeStr(v) {\n return (v ?? \"\").toString().trim();\n }\n\n function getInfoUrl(item) {\n for (const k of COL.INFO_URL_CANDIDATES) {\n if (item[k]) return normalizeStr(item[k]);\n }\n return \"\";\n }\n\n function safeUrl(url) {\n const u = normalizeStr(url);\n if (!u) return \"\";\n return u.startsWith(\"http:\/\/\") || u.startsWith(\"https:\/\/\") ? u : (\"https:\/\/\" + u);\n }\n\n function buildOptions(values, { includeEmpty = true, multiple = false } = {}) {\n const sorted = [...values].sort((a, b) => a.localeCompare(b, \"fr\"));\n const opts = sorted.map(v => {\n const esc = v.replace(\/\"\/g, \""\");\n return `<option value=\"${esc}\">${v}<\/option>`;\n }).join(\"\");\n if (!multiple && includeEmpty) {\n return `<option value=\"\">- S\u00e9lectionner -<\/option>` + opts;\n }\n return opts;\n }\n\n function uniqueValues(key) {\n return [...new Set(\n data.map(item => normalizeStr(item[key]))\n .filter(Boolean)\n )];\n }\n\n function uniqueKeywordTokens() {\n const tokens = new Set();\n data.forEach(item => {\n const kw = normalizeStr(item[COL.KEYWORDS]);\n if (!kw) return;\n kw.split(\",\").map(s => s.trim()).filter(Boolean).forEach(t => tokens.add(t));\n });\n return [...tokens];\n }\n\n function updateFilters() {\n statusFilter.innerHTML = buildOptions(uniqueValues(COL.STATUS));\n themenbereichFilter.innerHTML = buildOptions(uniqueValues(COL.THEMENBEREICH));\n regionFilter.innerHTML = buildOptions(uniqueValues(COL.REGION));\n spracheFilter.innerHTML = buildOptions(uniqueValues(COL.SPRACHE));\n keywordsMulti.innerHTML = buildOptions(uniqueKeywordTokens(), { includeEmpty: false, multiple: true });\n }\n\n function getSelectedMulti(selectEl) {\n return Array.from(selectEl.selectedOptions).map(o => normalizeStr(o.value)).filter(Boolean);\n }\n\n function parseTypedKeywords(inputValue) {\n const v = normalizeStr(inputValue);\n if (!v) return [];\n return v.split(\/[,;]+\/).map(s => s.trim()).filter(Boolean);\n }\n\n function applyFilters() {\n const selectedStatus = normalizeStr(statusFilter.value);\n const selectedThemenbereich = normalizeStr(themenbereichFilter.value);\n const selectedRegion = normalizeStr(regionFilter.value);\n const selectedSprache = normalizeStr(spracheFilter.value);\n\n const typedKeywords = parseTypedKeywords(keywordsInput.value);\n const selectedKeywords = getSelectedMulti(keywordsMulti);\n\n const keywordTokens = [...new Set([...typedKeywords, ...selectedKeywords])]\n .map(k => k.toLowerCase());\n\n const matchExact = (val, sel) => !sel || normalizeStr(val) === sel;\n\n const keywordMatch = (item) => {\n if (keywordTokens.length === 0) return true;\n const kwCell = normalizeStr(item[COL.KEYWORDS]).toLowerCase();\n if (!kwCell) return false;\n return keywordTokens.some(t => kwCell.includes(t));\n };\n\n filteredData = data.filter(item => {\n return (\n matchExact(item[COL.STATUS], selectedStatus) &&\n matchExact(item[COL.THEMENBEREICH], selectedThemenbereich) &&\n matchExact(item[COL.REGION], selectedRegion) &&\n matchExact(item[COL.SPRACHE], selectedSprache) &&\n keywordMatch(item)\n );\n });\n\n displayData();\n }\n\n function resetFilters() {\n statusFilter.value = \"\";\n themenbereichFilter.value = \"\";\n regionFilter.value = \"\";\n spracheFilter.value = \"\";\n\n keywordsInput.value = \"\";\n Array.from(keywordsMulti.options).forEach(o => o.selected = false);\n\n applyFilters();\n }\n\n function renderRow(label, valueHtml) {\n if (!valueHtml) return \"\";\n return `<div class=\"project-row\"><strong>${label}<\/strong><span>${valueHtml}<\/span><\/div>`;\n }\n\n function displayData() {\n dataDisplay.innerHTML = \"\";\n resultCount.textContent = `R\u00e9sultats : ${filteredData.length}`;\n dataDisplay.classList.toggle(\"hidden\", filteredData.length === 0);\n\n filteredData.forEach(item => {\n const title = normalizeStr(item[COL.TITEL]) || \"Sans titre\";\n const themenbereich = normalizeStr(item[COL.THEMENBEREICH]);\n const region = normalizeStr(item[COL.REGION]);\n const organisation = normalizeStr(item[COL.ORGANISATION]);\n const zeitraum = normalizeStr(item[COL.ZEITRAUM]);\n const status = normalizeStr(item[COL.STATUS]);\n const keywords = normalizeStr(item[COL.KEYWORDS]);\n const sprache = normalizeStr(item[COL.SPRACHE]);\n\n const infoText = normalizeStr(item[COL.INFO_TEXT]);\n const infoUrl = safeUrl(getInfoUrl(item));\n\n const infoHtml = infoUrl\n ? `<a href=\"${infoUrl}\" target=\"_blank\" rel=\"noopener noreferrer\">${infoText || infoUrl}<\/a>`\n : (infoText || \"\");\n\n const div = document.createElement(\"div\");\n div.className = \"project-card\";\n div.innerHTML = `\n <div class=\"project-header\">${title}<\/div>\n <div class=\"project-body\">\n ${renderRow(\"Domaine th\u00e9matique :\", themenbereich)}\n ${renderRow(\"R\u00e9gion :\", region)}\n ${renderRow(\"Organisation :\", organisation)}\n ${renderRow(\"P\u00e9riode :\", zeitraum)}\n ${renderRow(\"Statut :\", `<span class=\"${status.toLowerCase() === \"aktiv\" ? \"status-aktiv\" : \"\"}\">${status}<\/span>`)}\n ${renderRow(\"Mots-cl\u00e9s :\", keywords)}\n ${renderRow(\"Information \/ Source :\", infoHtml)}\n ${renderRow(\"Langue :\", sprache)}\n <\/div>\n `;\n dataDisplay.appendChild(div);\n });\n }\n\n applyButtons.forEach(btn => btn.addEventListener(\"click\", applyFilters));\n resetButtons.forEach(btn => btn.addEventListener(\"click\", resetFilters));\n\n [statusFilter, themenbereichFilter, regionFilter, spracheFilter].forEach(sel =>\n sel.addEventListener(\"change\", applyFilters)\n );\n\n keywordsMulti.addEventListener(\"change\", applyFilters);\n\n keywordsInput.addEventListener(\"keydown\", (e) => {\n if (e.key === \"Enter\") applyFilters();\n });\n\n fetch(\"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/wp-content\/uploads\/sites\/64\/2026\/03\/Excel-Filter-Projets_FR.xlsx\")\n .then(r => r.blob())\n .then(blob => {\n const reader = new FileReader();\n reader.onload = e => {\n const workbook = XLSX.read(new Uint8Array(e.target.result), { type: \"array\" });\n const sheet = workbook.Sheets[workbook.SheetNames[0]];\n\n data = XLSX.utils.sheet_to_json(sheet, { defval: \"\" });\n\n const headers = Object.keys(data[0] || {});\n const infoCols = headers.filter(h => h.startsWith(\"Information \/ Source\"));\n if (infoCols.length >= 2) {\n COL.INFO_URL_CANDIDATES = infoCols.slice(1);\n }\n\n updateFilters();\n filteredData = data;\n displayData();\n };\n reader.readAsArrayBuffer(blob);\n })\n .catch(err => {\n console.error(err);\n resultCount.textContent = \"Erreur lors du chargement du fichier Excel.\";\n });\n });\n <\/script>\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n<style class=\"advgb-styles-renderer\">\n body { font-family: Arial, sans-serif; background-color: #ffffff; padding: 20px; }\n\n .filter-box { background-color: #dff2fa; border-radius: 8px; margin-bottom: 20px; overflow: hidden; }\n .filter-header { background-color: #008bcc; color: white; padding: 10px 15px; font-weight: bold; font-size: 1.1em; border-radius: 8px 8px 0 0; }\n\n .filter-body { display: flex; flex-wrap: wrap; justify-content: space-between; padding: 20px; gap: 20px; }\n\n .filter-left { flex: 1 1 300px; }\n .filter-left label, .search-wrapper label { display: block; margin-bottom: 5px; font-weight: bold; }\n\n .filter-left select {\n width: 100%; padding: 8px; border: 1px solid #ccc; border-radius: 4px;\n margin-bottom: 15px; background: #fff;\n }\n\n .filter-right {\n flex: 1 1 300px; display: flex; align-items: center; justify-content: center;\n border-left: 2px solid #008bcc;\n }\n\n .search-wrapper { display: flex; flex-direction: column; align-items: center; justify-content: center; width: 100%; padding: 0 20px; gap: 10px; }\n\n .search-wrapper input {\n width: 100%; max-width: 360px; padding: 8px; border: 1px solid #008bcc;\n background: #e6f3fc; border-radius: 4px;\n }\n\n .search-wrapper select[multiple] {\n width: 100%;\n max-width: 360px;\n padding: 8px;\n border: 1px solid #008bcc;\n background: #ffffff;\n border-radius: 4px;\n min-height: 180px;\n }\n\n .helper-text {\n font-size: 0.9em;\n color: #0b5f86;\n max-width: 360px;\n line-height: 1.2em;\n }\n\n .filter-actions { display: flex; justify-content: center; margin-top: 10px; font-weight: bold; gap: 20px; }\n .filter-actions span { color: #008bcc; cursor: pointer; transition: color 0.3s; }\n .filter-actions span:hover { color: #005b85; }\n\n .result-header { margin: 20px 0; font-weight: bold; color: #333; }\n\n .project-card { border: 1px solid #008bcc; border-radius: 8px; margin-bottom: 20px; overflow: hidden; }\n .project-header { background-color: #008bcc; color: white; padding: 10px 15px; font-weight: bold; font-size: 1.1em; }\n .project-body { background-color: #e6f6fc; padding: 15px; }\n\n .project-row { display: flex; margin-bottom: 6px; gap: 10px; }\n .project-row strong { width: 160px; flex-shrink: 0; display: inline-block; }\n\n .status-aktiv { color: #00b050; font-weight: bold; }\n\n a { color: #008bcc; text-decoration: underline; word-break: break-word; }\n\n .hidden { display: none; }\n\n @media (max-width: 768px) {\n .filter-body { flex-direction: column; }\n .filter-right { border-left: none; border-top: 2px solid #008bcc; padding-top: 20px; }\n }\n <\/style>","protected":false},"excerpt":{"rendered":"<p>Vous pouvez vous informer ici sur les projets en cours ou termin\u00e9s concernant la gestion de l’eau dans l’agriculture. Utilisez pour cela le filtre ci-dessous. N’h\u00e9sitez pas \u00e0 nous faire part d’autres projets que vous pourrez soumettre ici. Sur la plateforme Climat d’AGRIDEA, les projets des cantons sont list\u00e9s, entre autres, sur le th\u00e8me de […]<\/p>\n","protected":false},"author":927,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_sb_is_suggestion_mode":false,"_sb_show_suggestion_boards":false,"_sb_show_comment_boards":false,"_sb_suggestion_history":"","_sb_update_block_changes":"","om_disable_all_campaigns":false,"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-63313","page","type-page","status-publish","hentry"],"coauthors":[{"link":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/author\/sar2\/","display_name":"sar2"}],"author_meta":{"author_link":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/author\/sar2\/","display_name":"sar2"},"relative_dates":{"created":"Publi\u00e9 2 mois il y a","modified":"Mis \u00e0 jour 2 jours il y a"},"absolute_dates":{"created":"Publi\u00e9 le 16 f\u00e9vrier 2026","modified":"Mise \u00e0 jour le 10 avril 2026"},"absolute_dates_time":{"created":"Publi\u00e9 le 16 f\u00e9vrier 2026 12h12","modified":"Mise \u00e0 jour le 10 avril 2026 14h55"},"featured_img_caption":"","featured_img":false,"series_order":"","_links":{"self":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/users\/927"}],"replies":[{"embeddable":true,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/comments?post=63313"}],"version-history":[{"count":12,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313\/revisions"}],"predecessor-version":[{"id":64388,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313\/revisions\/64388"}],"wp:attachment":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/media?parent=63313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

Vous pouvez vous informer ici sur les projets en cours ou termin\u00e9s concernant la gestion de l’eau dans l’agriculture. Utilisez pour cela le filtre ci-dessous. N’h\u00e9sitez pas \u00e0 nous faire part d’autres projets que vous pourrez soumettre ici<\/a>.<\/p>\n\n\n\n

<\/div>\n\n\n\n\n\n\n \n \n S\u00e9lection de filtre Excel<\/title>\n <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/xlsx\/0.17.0\/xlsx.full.min.js\"><\/script>\n \n<\/head>\n<body>\n <div class=\"filter-box\">\n <div class=\"filter-header\">Filtres avec menus d\u00e9roulants + mots-cl\u00e9s \u00e0 droite (saisir ou s\u00e9lectionner plusieurs)<\/div>\n <div class=\"filter-body\">\n <div class=\"filter-left\">\n <label>Statut<\/label>\n <select id=\"statusFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>Domaine th\u00e9matique<\/label>\n <select id=\"themenbereichFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>R\u00e9gion<\/label>\n <select id=\"regionFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <label>Langue<\/label>\n <select id=\"spracheFilter\"><option value=\"\">– S\u00e9lectionner –<\/option><\/select>\n\n <div class=\"filter-actions\">\n <span id=\"applyFiltersLeft\">Filtrer<\/span>\n <span id=\"resetFiltersLeft\">R\u00e9initialiser<\/span>\n <\/div>\n <\/div>\n\n <div class=\"filter-right\">\n <div class=\"search-wrapper\">\n <label for=\"keywordsInput\">Mots-cl\u00e9s<\/label>\n <input\n type=\"text\"\n id=\"keywordsInput\"\n placeholder=\"Saisir des mots-cl\u00e9s (s\u00e9par\u00e9s par des virgules), ex. \u00c9rosion, fortes pluies\"\n \/>\n <div class=\"helper-text\">\n Astuce : s\u00e9lection multiple avec <b>Ctrl<\/b> (Windows) \/ <b>Cmd<\/b> (Mac) ou <b>Shift<\/b>.\n <\/div>\n\n <select id=\"keywordsMulti\" multiple><\/select>\n\n <div class=\"filter-actions\">\n <span id=\"applyFiltersRight\">Filtrer<\/span>\n <span id=\"resetFiltersRight\">R\u00e9initialiser<\/span>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"result-header\" id=\"resultCount\">R\u00e9sultats : 0<\/div>\n <div id=\"dataDisplay\" class=\"hidden\"><\/div>\n\n <script>\n document.addEventListener(\"DOMContentLoaded\", function () {\n const statusFilter = document.getElementById(\"statusFilter\");\n const themenbereichFilter = document.getElementById(\"themenbereichFilter\");\n const regionFilter = document.getElementById(\"regionFilter\");\n const spracheFilter = document.getElementById(\"spracheFilter\");\n\n const keywordsInput = document.getElementById(\"keywordsInput\");\n const keywordsMulti = document.getElementById(\"keywordsMulti\");\n\n const dataDisplay = document.getElementById(\"dataDisplay\");\n const resultCount = document.getElementById(\"resultCount\");\n\n const applyButtons = [\n document.getElementById(\"applyFiltersLeft\"),\n document.getElementById(\"applyFiltersRight\"),\n ];\n const resetButtons = [\n document.getElementById(\"resetFiltersLeft\"),\n document.getElementById(\"resetFiltersRight\"),\n ];\n\n let data = [];\n let filteredData = [];\n\n const COL = {\n THEMENBEREICH: \"Themenbereich\",\n TITEL: \"Titel\",\n REGION: \"Region\",\n ORGANISATION: \"Organisation\",\n ZEITRAUM: \"Zeitraum\",\n STATUS: \"Status\",\n KEYWORDS: \"Keywords\",\n INFO_TEXT: \"Information \/ Quelle\",\n INFO_URL_CANDIDATES: [\"Information \/ Quelle_1\", \"Information \/ Quelle (2)\", \"Information \/ Quelle_2\"],\n SPRACHE: \"Sprache\",\n };\n\n function normalizeStr(v) {\n return (v ?? \"\").toString().trim();\n }\n\n function getInfoUrl(item) {\n for (const k of COL.INFO_URL_CANDIDATES) {\n if (item[k]) return normalizeStr(item[k]);\n }\n return \"\";\n }\n\n function safeUrl(url) {\n const u = normalizeStr(url);\n if (!u) return \"\";\n return u.startsWith(\"http:\/\/\") || u.startsWith(\"https:\/\/\") ? u : (\"https:\/\/\" + u);\n }\n\n function buildOptions(values, { includeEmpty = true, multiple = false } = {}) {\n const sorted = [...values].sort((a, b) => a.localeCompare(b, \"fr\"));\n const opts = sorted.map(v => {\n const esc = v.replace(\/\"\/g, \""\");\n return `<option value=\"${esc}\">${v}<\/option>`;\n }).join(\"\");\n if (!multiple && includeEmpty) {\n return `<option value=\"\">- S\u00e9lectionner -<\/option>` + opts;\n }\n return opts;\n }\n\n function uniqueValues(key) {\n return [...new Set(\n data.map(item => normalizeStr(item[key]))\n .filter(Boolean)\n )];\n }\n\n function uniqueKeywordTokens() {\n const tokens = new Set();\n data.forEach(item => {\n const kw = normalizeStr(item[COL.KEYWORDS]);\n if (!kw) return;\n kw.split(\",\").map(s => s.trim()).filter(Boolean).forEach(t => tokens.add(t));\n });\n return [...tokens];\n }\n\n function updateFilters() {\n statusFilter.innerHTML = buildOptions(uniqueValues(COL.STATUS));\n themenbereichFilter.innerHTML = buildOptions(uniqueValues(COL.THEMENBEREICH));\n regionFilter.innerHTML = buildOptions(uniqueValues(COL.REGION));\n spracheFilter.innerHTML = buildOptions(uniqueValues(COL.SPRACHE));\n keywordsMulti.innerHTML = buildOptions(uniqueKeywordTokens(), { includeEmpty: false, multiple: true });\n }\n\n function getSelectedMulti(selectEl) {\n return Array.from(selectEl.selectedOptions).map(o => normalizeStr(o.value)).filter(Boolean);\n }\n\n function parseTypedKeywords(inputValue) {\n const v = normalizeStr(inputValue);\n if (!v) return [];\n return v.split(\/[,;]+\/).map(s => s.trim()).filter(Boolean);\n }\n\n function applyFilters() {\n const selectedStatus = normalizeStr(statusFilter.value);\n const selectedThemenbereich = normalizeStr(themenbereichFilter.value);\n const selectedRegion = normalizeStr(regionFilter.value);\n const selectedSprache = normalizeStr(spracheFilter.value);\n\n const typedKeywords = parseTypedKeywords(keywordsInput.value);\n const selectedKeywords = getSelectedMulti(keywordsMulti);\n\n const keywordTokens = [...new Set([...typedKeywords, ...selectedKeywords])]\n .map(k => k.toLowerCase());\n\n const matchExact = (val, sel) => !sel || normalizeStr(val) === sel;\n\n const keywordMatch = (item) => {\n if (keywordTokens.length === 0) return true;\n const kwCell = normalizeStr(item[COL.KEYWORDS]).toLowerCase();\n if (!kwCell) return false;\n return keywordTokens.some(t => kwCell.includes(t));\n };\n\n filteredData = data.filter(item => {\n return (\n matchExact(item[COL.STATUS], selectedStatus) &&\n matchExact(item[COL.THEMENBEREICH], selectedThemenbereich) &&\n matchExact(item[COL.REGION], selectedRegion) &&\n matchExact(item[COL.SPRACHE], selectedSprache) &&\n keywordMatch(item)\n );\n });\n\n displayData();\n }\n\n function resetFilters() {\n statusFilter.value = \"\";\n themenbereichFilter.value = \"\";\n regionFilter.value = \"\";\n spracheFilter.value = \"\";\n\n keywordsInput.value = \"\";\n Array.from(keywordsMulti.options).forEach(o => o.selected = false);\n\n applyFilters();\n }\n\n function renderRow(label, valueHtml) {\n if (!valueHtml) return \"\";\n return `<div class=\"project-row\"><strong>${label}<\/strong><span>${valueHtml}<\/span><\/div>`;\n }\n\n function displayData() {\n dataDisplay.innerHTML = \"\";\n resultCount.textContent = `R\u00e9sultats : ${filteredData.length}`;\n dataDisplay.classList.toggle(\"hidden\", filteredData.length === 0);\n\n filteredData.forEach(item => {\n const title = normalizeStr(item[COL.TITEL]) || \"Sans titre\";\n const themenbereich = normalizeStr(item[COL.THEMENBEREICH]);\n const region = normalizeStr(item[COL.REGION]);\n const organisation = normalizeStr(item[COL.ORGANISATION]);\n const zeitraum = normalizeStr(item[COL.ZEITRAUM]);\n const status = normalizeStr(item[COL.STATUS]);\n const keywords = normalizeStr(item[COL.KEYWORDS]);\n const sprache = normalizeStr(item[COL.SPRACHE]);\n\n const infoText = normalizeStr(item[COL.INFO_TEXT]);\n const infoUrl = safeUrl(getInfoUrl(item));\n\n const infoHtml = infoUrl\n ? `<a href=\"${infoUrl}\" target=\"_blank\" rel=\"noopener noreferrer\">${infoText || infoUrl}<\/a>`\n : (infoText || \"\");\n\n const div = document.createElement(\"div\");\n div.className = \"project-card\";\n div.innerHTML = `\n <div class=\"project-header\">${title}<\/div>\n <div class=\"project-body\">\n ${renderRow(\"Domaine th\u00e9matique :\", themenbereich)}\n ${renderRow(\"R\u00e9gion :\", region)}\n ${renderRow(\"Organisation :\", organisation)}\n ${renderRow(\"P\u00e9riode :\", zeitraum)}\n ${renderRow(\"Statut :\", `<span class=\"${status.toLowerCase() === \"aktiv\" ? \"status-aktiv\" : \"\"}\">${status}<\/span>`)}\n ${renderRow(\"Mots-cl\u00e9s :\", keywords)}\n ${renderRow(\"Information \/ Source :\", infoHtml)}\n ${renderRow(\"Langue :\", sprache)}\n <\/div>\n `;\n dataDisplay.appendChild(div);\n });\n }\n\n applyButtons.forEach(btn => btn.addEventListener(\"click\", applyFilters));\n resetButtons.forEach(btn => btn.addEventListener(\"click\", resetFilters));\n\n [statusFilter, themenbereichFilter, regionFilter, spracheFilter].forEach(sel =>\n sel.addEventListener(\"change\", applyFilters)\n );\n\n keywordsMulti.addEventListener(\"change\", applyFilters);\n\n keywordsInput.addEventListener(\"keydown\", (e) => {\n if (e.key === \"Enter\") applyFilters();\n });\n\n fetch(\"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/wp-content\/uploads\/sites\/64\/2026\/03\/Excel-Filter-Projets_FR.xlsx\")\n .then(r => r.blob())\n .then(blob => {\n const reader = new FileReader();\n reader.onload = e => {\n const workbook = XLSX.read(new Uint8Array(e.target.result), { type: \"array\" });\n const sheet = workbook.Sheets[workbook.SheetNames[0]];\n\n data = XLSX.utils.sheet_to_json(sheet, { defval: \"\" });\n\n const headers = Object.keys(data[0] || {});\n const infoCols = headers.filter(h => h.startsWith(\"Information \/ Source\"));\n if (infoCols.length >= 2) {\n COL.INFO_URL_CANDIDATES = infoCols.slice(1);\n }\n\n updateFilters();\n filteredData = data;\n displayData();\n };\n reader.readAsArrayBuffer(blob);\n })\n .catch(err => {\n console.error(err);\n resultCount.textContent = \"Erreur lors du chargement du fichier Excel.\";\n });\n });\n <\/script>\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n<style class=\"advgb-styles-renderer\">\n body { font-family: Arial, sans-serif; background-color: #ffffff; padding: 20px; }\n\n .filter-box { background-color: #dff2fa; border-radius: 8px; margin-bottom: 20px; overflow: hidden; }\n .filter-header { background-color: #008bcc; color: white; padding: 10px 15px; font-weight: bold; font-size: 1.1em; border-radius: 8px 8px 0 0; }\n\n .filter-body { display: flex; flex-wrap: wrap; justify-content: space-between; padding: 20px; gap: 20px; }\n\n .filter-left { flex: 1 1 300px; }\n .filter-left label, .search-wrapper label { display: block; margin-bottom: 5px; font-weight: bold; }\n\n .filter-left select {\n width: 100%; padding: 8px; border: 1px solid #ccc; border-radius: 4px;\n margin-bottom: 15px; background: #fff;\n }\n\n .filter-right {\n flex: 1 1 300px; display: flex; align-items: center; justify-content: center;\n border-left: 2px solid #008bcc;\n }\n\n .search-wrapper { display: flex; flex-direction: column; align-items: center; justify-content: center; width: 100%; padding: 0 20px; gap: 10px; }\n\n .search-wrapper input {\n width: 100%; max-width: 360px; padding: 8px; border: 1px solid #008bcc;\n background: #e6f3fc; border-radius: 4px;\n }\n\n .search-wrapper select[multiple] {\n width: 100%;\n max-width: 360px;\n padding: 8px;\n border: 1px solid #008bcc;\n background: #ffffff;\n border-radius: 4px;\n min-height: 180px;\n }\n\n .helper-text {\n font-size: 0.9em;\n color: #0b5f86;\n max-width: 360px;\n line-height: 1.2em;\n }\n\n .filter-actions { display: flex; justify-content: center; margin-top: 10px; font-weight: bold; gap: 20px; }\n .filter-actions span { color: #008bcc; cursor: pointer; transition: color 0.3s; }\n .filter-actions span:hover { color: #005b85; }\n\n .result-header { margin: 20px 0; font-weight: bold; color: #333; }\n\n .project-card { border: 1px solid #008bcc; border-radius: 8px; margin-bottom: 20px; overflow: hidden; }\n .project-header { background-color: #008bcc; color: white; padding: 10px 15px; font-weight: bold; font-size: 1.1em; }\n .project-body { background-color: #e6f6fc; padding: 15px; }\n\n .project-row { display: flex; margin-bottom: 6px; gap: 10px; }\n .project-row strong { width: 160px; flex-shrink: 0; display: inline-block; }\n\n .status-aktiv { color: #00b050; font-weight: bold; }\n\n a { color: #008bcc; text-decoration: underline; word-break: break-word; }\n\n .hidden { display: none; }\n\n @media (max-width: 768px) {\n .filter-body { flex-direction: column; }\n .filter-right { border-left: none; border-top: 2px solid #008bcc; padding-top: 20px; }\n }\n <\/style>","protected":false},"excerpt":{"rendered":"<p>Vous pouvez vous informer ici sur les projets en cours ou termin\u00e9s concernant la gestion de l’eau dans l’agriculture. Utilisez pour cela le filtre ci-dessous. N’h\u00e9sitez pas \u00e0 nous faire part d’autres projets que vous pourrez soumettre ici. Sur la plateforme Climat d’AGRIDEA, les projets des cantons sont list\u00e9s, entre autres, sur le th\u00e8me de […]<\/p>\n","protected":false},"author":927,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_sb_is_suggestion_mode":false,"_sb_show_suggestion_boards":false,"_sb_show_comment_boards":false,"_sb_suggestion_history":"","_sb_update_block_changes":"","om_disable_all_campaigns":false,"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-63313","page","type-page","status-publish","hentry"],"coauthors":[{"link":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/author\/sar2\/","display_name":"sar2"}],"author_meta":{"author_link":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/author\/sar2\/","display_name":"sar2"},"relative_dates":{"created":"Publi\u00e9 2 mois il y a","modified":"Mis \u00e0 jour 2 jours il y a"},"absolute_dates":{"created":"Publi\u00e9 le 16 f\u00e9vrier 2026","modified":"Mise \u00e0 jour le 10 avril 2026"},"absolute_dates_time":{"created":"Publi\u00e9 le 16 f\u00e9vrier 2026 12h12","modified":"Mise \u00e0 jour le 10 avril 2026 14h55"},"featured_img_caption":"","featured_img":false,"series_order":"","_links":{"self":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/users\/927"}],"replies":[{"embeddable":true,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/comments?post=63313"}],"version-history":[{"count":12,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313\/revisions"}],"predecessor-version":[{"id":64388,"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/pages\/63313\/revisions\/64388"}],"wp:attachment":[{"href":"https:\/\/agripedia.ch\/forum-wasser-landwirtschaft\/fr\/wp-json\/wp\/v2\/media?parent=63313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}