油耗紀錄小幫手

function doGet() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var result = [];
  for (var i = 1; i < data.length; i++) {
    var row = data[i];
    if(!row[0]) continue;
    var rawDate = row[0];
    var formattedDate = "";
    
    // 使用 Apps Script 原生 API 進行超強固日期解析
    var d = new Date(rawDate);
    if (!isNaN(d.getTime())) {
      formattedDate = Utilities.formatDate(d, Session.getScriptTimeZone() || "GMT+8", "yyyy-MM-dd");
    } else {
      var strDate = String(rawDate);
      if (strDate.indexOf('T') !== -1 && strDate.indexOf('GMT') === -1) {
        formattedDate = strDate.split('T')[0];
      } else {
        formattedDate = strDate;
      }
    }
    
    result.push({
      date: formattedDate,
      mileage: Number(row[1]),
      price: Number(row[2]),
      liters: Number(row[3])
    });
  }
  return ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clearContents();
  sheet.appendRow(["加油日期", "行駛當下里程", "一公升油價", "加油公升數"]);
  var payload = JSON.parse(e.postData.contents);
  for (var i = 0; i < payload.length; i++) {
    var r = payload[i];
    sheet.appendRow([r.date, r.mileage, r.price, r.liters]);
  }
  return ContentService.createTextOutput(JSON.stringify({status: "success"}))
    .setMimeType(ContentService.MimeType.JSON)
    .setHeaders({"Access-Control-Allow-Origin": "*"});
}