分散式網路查詢成績新作法

本縣藝才班招生成績查詢用分散式資料系統，資訊中心無法度改成績資料，只有各校試務單位才會使輸入資料。按呢對個人的保護較齊到，以後就採用這種方式了。
各校的考生成績囥佇各校承辦人的雲頂硬碟內面，資訊中心做查詢介面配合爾爾。
下跤是程式節錄：


function doGet() {
   var email = Session.getActiveUser().getEmail();
   return HtmlService.createTemplateFromFile('index').evaluate();
}

function queryScore(schnum, myid ,birthdate) {
   var schools = [
              ['新港國中音樂班','1LUVlz3S-MGeGQnBrXkXdi0V7ngvoJCrO2-12JnXR'],
              ['民雄國中美術班','1bjX_OUaXtkDbdgg3Qo1VEVqRpGybSXhTqrD0wzU4'],
              ['民雄國中舞蹈班','1BrES7QwRDzx_FbhiYK6SHmxIYxP67yZacORY-5Nw'],
              ['竹崎高中美術班','1VLe6CnNoispk4U7xx3MzB0a6-MnmqzaQAfkBMi6E'],
              ['東石國中音樂班','1fKHRudf_5x1OI2tfL7kh1EJEycuva_UUj_VIlBDo'],
              ['水上國中音樂班','1CiPFFpduTbENIRKQW0qK3pQg4YnB6BwW4gKyJTRk'],
              ['大林國中音樂班','1qOMvm2JJLeDaSa0NlPpQQi7pREBsOgPWnbE1UxQs'],
              ['中埔國中舞蹈班','1cA_b7wKAcrKrzt8mZ1abzHVv0bLHDDi2sWpIwJUE'],
              ['南新國小音樂班','1iEYn7RsomH6WCBXDELFBCUme-7imwt9aWJh2MKhM'],
              ['興中國小美術班','1Gk49TaiR2UkEHelmJc0lyTEVxz-as3dcc-7-73Cs'],
              ['民雄國小美術班','1Kj_V6Rd-hr9pmmA92eTG01KwZ07YlN_ewZtzGWyc'],    
              ['水上國小舞蹈班','16z5E2hgLx3ZSEH3JYpw8OEQBUV6YaBX5S4ciXbmw'],
        ];
       
if (schnum == 99) return {"name": "Error:   ", "score": "恁無選報名班別"};
       
   var spreadsheet = SpreadsheetApp.openById(schools[schnum][1]); //開另外一个檔案，佇104藝才招生內面。
   var sheet = spreadsheet.getSheets()[0];
   var lastrow = sheet.getLastRow(); var lastcol = sheet.getLastColumn();
   var scores = sheet.getSheetValues(1, 1, lastrow, lastcol);
   for (var i = 0; i < lastrow; i++) {
      if ( myid == scores[i][3] && birthdate == scores[i][5]) {
         //Browser.msgBox(sheet.getRange(2,4).getValue());  //莫用getSheetByName("sheetname")
         var str = '';
         for (var j = 6; j<lastcol; j++) {
            str = str + scores[0][j] + "  " + scores[i][j] + "  ";
         }
         return {"name": scores[i][2], "score": str};
      }
   }
   //Browser.msgBox(scores[1][6]);
   return {"name": "error:   ", "score": "資料比對無合"} ;
}