Admin Panel

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    if (data.action === 'appendRow') {
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var sheet = ss.getSheetByName(data.sheet) || ss.insertSheet(data.sheet);
      
      // Add headers if sheet is empty
      if (sheet.getLastRow() === 0) {
        sheet.appendRow(['Timestamp','ຊ່ອງ','ລູກຄ້າ','ພະນັກງານ','ID','ສາຂາ','ປະເພດ','ຮູບແບບ','ເລີ່ມ','ສີ້ນສຸດ','ນາທີ','ໝາຍເຫດ','Firebase ID']);
        sheet.getRange(1,1,1,13).setFontWeight('bold').setBackground('#1155CC').setFontColor('#FFFFFF');
      }
      
      var d = data.data;
      sheet.appendRow([d.timestamp,d.counter,d.customerName,d.employeeName,d.ownerId,d.branchName,d.serviceType,d.serviceModel,d.startTime,d.endTime,d.durationMinutes,d.note,d.firebaseId]);
    }
    return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({status:'error',message:err.message})).setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  if (e.parameter.action === 'ping') {
    return ContentService.createTextOutput(JSON.stringify({status:'ok'})).setMimeType(ContentService.MimeType.JSON);
  }
  return ContentService.createTextOutput('SSMI Service Timer GSheet API').setMimeType(ContentService.MimeType.TEXT);
}