let jsonData=[],filteredData=[];const SHEET_ID="1aQiwbtrQu1QOIOkFrOYl9WkzT0mqnZqIwI9KJCXGb4E",API_KEY="AIzaSyDsqxZhhN2llBnbX13DldQ0ChLD1VZLs5s",SHEET_NAMES=["學校總表_中文"],COLLEGES=["醫學院","工學院","管理學院","智慧運算學院"],PROGRAMS=["學士班","碩士班","博士班"];async function fetchSheetData(t){document.getElementById("loading-message").style.display="block";let e=`https://sheets.googleapis.com/v4/spreadsheets/1aQiwbtrQu1QOIOkFrOYl9WkzT0mqnZqIwI9KJCXGb4E/values/${t}?key=AIzaSyDsqxZhhN2llBnbX13DldQ0ChLD1VZLs5s`;try{let l=await fetch(e),a=await l.json();if(!a.values||a.values.length<=1)return console.warn(`工作表 ${t} 沒有數據，跳過。`),[];return a.values.slice(1).map((e,l)=>{let a=extractPlainText(e[6]),n=extractPlainText(e[7]);return{id:l,rowIndex:l,國家:extractPlainText(e[1]),校名:formatCell(e[2],e[3]),網址:e[3]||"",學院:a,colleges:parseColleges(a),學制:n,programs:parsePrograms(n),學系:formatCell(e[8]),類型:formatCell(e[11]),更多資訊:"",sheetName:t}})}catch(n){return console.error("讀取 Google Sheets 失敗:",n),[]}finally{document.getElementById("loading-message").style.display="none"}}async function fetchAllSheets(){for(let t of(jsonData=[],filteredData=[],SHEET_NAMES)){let e=await fetchSheetData(t);e.length>0&&(filteredData=[...jsonData=jsonData.concat(e)])}displayResults(),populateFilters(jsonData)}function extractPlainText(t){return t?t.toString().replace(/<\/?[^>]+(>|$)/g,""):""}function parseColleges(t){let e=extractPlainText(t||"").trim();if(!e)return[];if(e.includes("全校"))return[...COLLEGES];let l=e.split(/[,\s、\/;；]+/g).map(t=>t.trim()).filter(Boolean);return[...new Set(l.filter(t=>COLLEGES.includes(t)))]}function parsePrograms(t){let e=extractPlainText(t||"").trim();if(!e)return[];if(e.includes("不限"))return[...PROGRAMS];let l=e.split(/[,\s、\/;；]+/g).map(t=>t.trim()).filter(Boolean);return[...new Set(l.filter(t=>PROGRAMS.includes(t)))]}function formatCell(t,e=null){if(!t)return"";let l=t.toString().replace(/\n/g,"<br>"),a=e&&e.startsWith("http")?e:"";return a?`<a href="/oia-ch/ServerFile/GetByKindEditor/469c8dd1-e254-46ae-9322-4b2c1382784e/${a}" target="_blank">${l}</a>`:`<span>${l}</span>`}function populateFilters(t){let e=document.getElementById("country-filter"),l=document.getElementById("college-filter"),a=document.getElementById("type-filter");populateFilterOptions(e,[...new Set(t.map(t=>extractPlainText(t.國家)))]),populateFilterOptions(l,COLLEGES),populateFilterOptions(a,PROGRAMS)}function populateFilterOptions(t,e){t.innerHTML='<option value="">请选择</option>',e.forEach(e=>{let l=document.createElement("option");l.value=e,l.textContent=e,t.appendChild(l)})}function search(){let t=document.getElementById("search-input").value.trim().toLowerCase(),e=document.getElementById("country-filter").value,l=document.getElementById("college-filter").value,a=document.getElementById("type-filter").value;filteredData=jsonData.filter(n=>(""===t||Object.values(n).some(e=>"string"==typeof e&&e.toLowerCase().includes(t)))&&(""===e||n.國家===e)&&(""===l||(n.colleges||[]).includes(l))&&(""===a||(n.programs||[]).includes(a))),displayResults()}function displayResults(){let t=document.getElementById("table-body"),e=document.getElementById("total-count");t.innerHTML="",filteredData.forEach(e=>{let l=e.sheetName,a=document.createElement("tr");a.innerHTML=`
      <td class="text md-center" data-title="國家">$调别.国家皑</td>
      <td class="text" data-title="校名">$调别.校名皑</td>
      <td class="text text-center lg-none" style="font-weight: bold;">【本校申请资格】</td>
      <td class="text md-center" data-title="學院">$调别.学院皑</td>
      <td class="text md-center" data-title="學制">$调别.学制皑</td>
      <td class="text md-center" data-title="學系">$调别.学系皑</td>
      <td class="text md-center" data-title="研修類型">$调别.类型皑</td>
      <td class="text md-center" data-title="更多資訊">
        <button onclick="openDetailsPage('${e.id}', '${l}', '${e.rowIndex}')" class="btn search_btn">查看更多</button>
      </td>
    `,t.appendChild(a)}),e&&(e.textContent=`共 ${filteredData.length} 筆`)}function openDetailsPage(t,e,l){if(!e||"undefined"===e){console.warn("? 錯誤：sheetName 為 undefined，無法導向詳情頁面。");return}let a=parseInt(l,10)+1,n=`/oia-ch/ServerFile/GetByKindEditor/7a94a4d2-e93c-43c7-a882-855c2a636ccf?subjectId=64711&id=${t}&sheet=${encodeURIComponent(e)}&row=${a}`;window.open(n,"_blank")}fetchAllSheets(),document.getElementById("search-btn").addEventListener("click",search);