โรงพยาบาลลำพูนใกล้หมอ

// ==========================================
// Google Apps Script - โรงพยาบาลลำพูนใกล้หมอ
// ==========================================

function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  if (data.length === 0 || data[0][0] === "") {
    setupHeaders(sheet);
    data = sheet.getDataRange().getValues();
  }
  
  var headers = data[0];
  var rows = data.slice(1);
  var result = rows.map(function(row) {
    var obj = {};
    headers.forEach(function(header, index) {
      obj[header] = row[index];
    });
    return obj;
  });
  
  return ContentService.createTextOutput(JSON.stringify({ status: "success", data: result }))
    .setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  try {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getActiveSheet();
    
    if (sheet.getLastRow() === 0) {
      setupHeaders(sheet);
    }
    
    var params = {};
    if (e.postData && e.postData.contents) {
      params = JSON.parse(e.postData.contents);
    } else if (e.parameter) {
      params = e.parameter;
    }
    
    sheet.appendRow([
      params.id || "LOG-" + new Date().getTime(),
      params.inboundTime || new Date(),
      params.channel || "",
      params.category || "",
      params.questionText || "",
      params.responseStatus || "",
      params.patientName || "",
      params.patientPhone || "",
      params.bookingTopic || "",
      params.bookingDate || "",
      params.bookingTime || "",
      params.hnNumber || "",
      params.staffName || "",
      params.completedTime || new Date(),
      params.turnaroundMinutes || 0,
      new Date()
    ]);
    
    return ContentService.createTextOutput(JSON.stringify({ status: "success", message: "บันทึกเรียบร้อย" }))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (error) {
    return ContentService.createTextOutput(JSON.stringify({ status: "error", message: error.toString() }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function setupHeaders(sheet) {
  var headers = [
    "ID", "เวลาทักมา", "ช่องทาง", "หมวดคำถาม", "คำถาม", 
    "สถานะการตอบ", "ชื่อผู้รับบริการ", "เบอร์โทร", "การจอง", 
    "วันที่จอง", "เวลาจอง", "เปิด HN", "เจ้าหน้าที่ตอบกลับ", 
    "เวลาตอบเสร็จ", "ระยะเวลาตอบ(นาที)", "เวลาบันทึกระบบ"
  ];
  sheet.getRange(1, 1, 1, headers.length).setValues([headers]);
  sheet.getRange(1, 1, 1, headers.length)
       .setFontWeight("bold")
       .setBackground("#0d9488")
       .setFontColor("#ffffff");
  sheet.setFrozenRows(1);
}