Memimpin Logistik,
Menghubungkan
Nusantara

const SHEET_NAME = 'FleetTracker';

function doPost(e) {
  try {
    const data = JSON.parse(e.postData.contents);
    const ss = SpreadsheetApp.getActiveSpreadsheet();
    let sheet = ss.getSheetByName(SHEET_NAME);
    if (!sheet) {
      sheet = ss.insertSheet(SHEET_NAME);
      sheet.appendRow(['id','orderNo','name','veh','ph','addr','cat','status','lat','lng','createdAt','log']);
      sheet.getRange(1,1,1,12).setFontWeight('bold').setBackground('#1e3a5f').setFontColor('#ffffff');
      sheet.setFrozenRows(1);
    }

    const action = data.action;

    if (action === 'ping') {
      return ok({ status: 'ok', sheet: SHEET_NAME });
    }

    if (action === 'getAll') {
      const rows = sheet.getDataRange().getValues();
      if (rows.length <= 1) return ok({ data: [] });
      const headers = rows[0];
      const result = rows.slice(1).map(row => {
        const obj = {};
        headers.forEach((h, i) => {
          obj[h] = row[i];
        });
        // Parse log JSON string
        try { obj.log = JSON.parse(obj.log || '[]'); } catch(e) { obj.log = []; }
        // Parse coords
        obj.lat = parseFloat(obj.lat) || 0;
        obj.lng = parseFloat(obj.lng) || 0;
        return obj;
      }).filter(r => r.id);
      return ok({ data: result });
    }

    if (action === 'save') {
      const loc = data.loc;
      if (!loc || !loc.id) return err('Missing id');
      const rows = sheet.getDataRange().getValues();
      const headers = rows[0];
      const idCol = headers.indexOf('id');
      let rowIdx = -1;
      for (let i = 1; i < rows.length; i++) {
        if (rows[i][idCol] === loc.id) { rowIdx = i + 1; break; }
      }
      const rowData = headers.map(h => {
        if (h === 'log') return JSON.stringify(loc[h] || []);
        return loc[h] !== undefined ? loc[h] : '';
      });
      if (rowIdx > 0) {
        sheet.getRange(rowIdx, 1, 1, headers.length).setValues([rowData]);
      } else {
        sheet.appendRow(rowData);
        // Auto-resize columns on first data entry
        if (sheet.getLastRow() === 2) sheet.autoResizeColumns(1, headers.length);
      }
      // Color row by status
      colorByStatus(sheet, rowIdx > 0 ? rowIdx : sheet.getLastRow(), loc.status);
      return ok({ saved: loc.id });
    }

    if (action === 'delete') {
      const id = data.id;
      const rows = sheet.getDataRange().getValues();
      const idCol = rows[0].indexOf('id');
      for (let i = 1; i < rows.length; i++) {
        if (rows[i][idCol] === id) { sheet.deleteRow(i + 1); break; }
      }
      return ok({ deleted: id });
    }

    return err('Unknown action: ' + action);
  } catch(e) {
    return err(e.toString());
  }
}

function colorByStatus(sheet, rowNum, status) {
  const colors = {
    'Pick up':    '#1e3a5f',
    'On the Way': '#1e3a1e',
    'On Site':    '#3a2a00',
    'POD':        '#1a1a2e',
  };
  const bg = colors[status] || '#1a1a1a';
  sheet.getRange(rowNum, 1, 1, 12).setBackground(bg);
}

function ok(data)  { return ContentService.createTextOutput(JSON.stringify({ ...data, ok: true })).setMimeType(ContentService.MimeType.JSON); }
function err(msg)  { return ContentService.createTextOutput(JSON.stringify({ error: msg, ok: false })).setMimeType(ContentService.MimeType.JSON); }

// Trigger GET for testing in browser
function doGet(e) { return ok({ status: 'ok', message: 'FleetTracker API aktif' }); }