Dull & Yellow
Headlights?
Restore Them to
Crystal-Clear Condition.

function doPost(e) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = {};
  try {
    if (!e || !e.postData || !e.postData.contents) {
      return ContentService.createTextOutput(JSON.stringify({ ok: false, error: 'No data received - send a POST request with a JSON body.' }))
        .setMimeType(ContentService.MimeType.JSON);
    }
    data = JSON.parse(e.postData.contents);
  } catch (err) {
    data = { raw: e.postData.contents };
  }

  var headers = ['Booking ID','Created At','Date','Time','Name','Phone','Vehicle Make','Vehicle Model','Vehicle','Service','Mode','Address / Location','GPS','Amount Paid','Balance','Payment Status','Booking Status'];
  var row = [
    data.id || '', data.createdAt || '', data.date || '', data.time || '',
    data.name || '', data.phone || '', data.vehicleMake || '', data.vehicleModel || '',
    data.vehicle || '', data.serviceLabel || data.service || '',
    data.mode || '', (data.address || '') + (data.location ? ' | Area: ' + data.location : ''), (data.gpsLat ? data.gpsLat + ', ' + data.gpsLng : ''),
    data.amountPaid || '', data.balance || '', data.paymentStatus || '', data.status || ''
  ];

  if (sheet.getLastRow() === 0) sheet.appendRow(headers);

  var values = sheet.getDataRange().getValues();
  var updated = false;
  for (var i = values.length - 1; i >= 1; i--) {
    if (String(values[i][0]) === String(data.id)) {
      sheet.getRange(i + 1, 1, 1, row.length).setValues([row]);
      updated = true;
      break;
    }
  }
  if (!updated) sheet.appendRow(row);

  // WhatsApp alert to the owner on every NEW booking
  if (!updated) sendWhatsAppAlert(data);

  return ContentService.createTextOutput(JSON.stringify({ ok: true }))
    .setMimeType(ContentService.MimeType.JSON);
}

// LIVE AVAILABILITY — the website calls this to learn which slots are
// already booked on a date, so the calendar greys them out for everyone.
// Example:  https://script.google.com/macros/s/.../exec?date=2026-09-05
function doGet(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var date = (e && e.parameter && e.parameter.date) ? String(e.parameter.date) : '';
    var values = sheet.getDataRange().getValues();
    var bookedSlots = [];
    var bookedDates = {};
    for (var i = 1; i < values.length; i++) {
      var row = values[i];
      var d = String(row[2] || '');   // Date column
      var t = String(row[3] || '');   // Time column
      var st = String(row[16] || ''); // Booking Status column
      if (!d || !t) continue;
      if (st === 'Cancelled') continue;
      if (!bookedDates[d]) bookedDates[d] = [];
      bookedDates[d].push(t);
      if (d === date) bookedSlots.push(t);
    }
    return ContentService.createTextOutput(JSON.stringify({ ok: true, date: date, bookedSlots: bookedSlots, bookedDates: bookedDates }))
      .setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({ ok: false, error: String(err) }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

// WHATSAPP ALERTS — free CallMeBot service. One-time activation from your
// own WhatsApp: send "I allow callmebot to send me messages" to +34 644 44
// 93 43, and CallMeBot replies with your personal API key.
var OWNER_PHONE = '918317681327'; // <- your WhatsApp number for booking alerts
var CALLMEBOT_API_KEY = 'REPLACE_WITH_YOUR_CALLMEBOT_API_KEY';

function sendWhatsAppAlert(data) {
  if (!CALLMEBOT_API_KEY || CALLMEBOT_API_KEY.indexOf('REPLACE') === 0) return;
  var text = '🔔 NEW BOOKING — Prinshine Enterprises\n' +
    'ID: ' + (data.id || '') + '\n' +
    'Name: ' + (data.name || '') + '\n' +
    'Phone: ' + (data.phone || '') + '\n' +
    'Vehicle: ' + (data.vehicle || '') + '\n' +
    'Service: ' + (data.serviceLabel || data.service || '') + '\n' +
    'Date: ' + (data.date || '') + '\n' +
    'Time: ' + (data.time || '') + '\n' +
    'Mode: ' + (data.mode || '') + '\n' +
    'Payment: ' + (data.paymentStatus || '') + ' (₹' + (data.amountPaid || 0) + ')\n' +
    'Balance: ₹' + (data.balance || 0) + '\n' +
    'Address: ' + (data.address || '') + (data.location ? ' | Area: ' + data.location : '');
  var url = 'https://api.callmebot.com/whatsapp.php?phone=' + encodeURIComponent(OWNER_PHONE) +
            '&apikey=' + encodeURIComponent(CALLMEBOT_API_KEY) +
            '&text=' + encodeURIComponent(text);
  try {
    UrlFetchApp.fetch(url, { muteHttpExceptions: true });
  } catch (err) {}
}