Loads of Luv — Staff Portal

Step 1. Open Google Sheets and create a new spreadsheet.
Step 2. Go to Extensions → Apps Script.
Step 3. Paste the following code and click Save:

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var type = data.type || 'revenue';
    if (type === 'order')  return writeOrderRow_(data);
    if (type === 'repair') return writeRepairRow_(data);
    if (type === 'clock')  return writeClockRow_(data);
    return writeRevenueRow_(data);
  } catch (err) {
    return ContentService
      .createTextOutput(JSON.stringify({status:'error', message:err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

// Unchanged from before - still writes to whichever sheet tab is active, so
// existing Revenue history keeps landing in the same place it always has.
function writeRevenueRow_(data) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var HEADERS = ['Date',
                 'Washers ($)','Washer Qtrs','Dryers ($)','Dryer Qtrs','Quarter Total',
                 'Vending','Wash & Fold','Machine Total',
                 'ATM Had','ATM Added','ATM Total',
                 '$20 Bills','$10 Bills','$5 Bills','$1 Bills','Bill Total',
                 'Last Updated'];
  var row = [
    data.date,
    data.washers       || 0,
    data.qtrWashers    || 0,
    data.dryers        || 0,
    data.qtrDryers     || 0,
    data.quarterTotal  || 0,
    data.vending       || 0,
    data.washfold      || 0,
    data.machineTotal  || 0,
    data.atmHad        || 0,
    data.atmAdded      || 0,
    data.atmTotal      || 0,
    data.bills20       || 0,
    data.bills10       || 0,
    data.bills5        || 0,
    data.bills1        || 0,
    data.billTotal     || 0,
    data.savedAt       || new Date().toISOString()
  ];
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(HEADERS);
    var hRange = sheet.getRange(1, 1, 1, HEADERS.length);
    hRange.setFontWeight('bold');
    hRange.setBackground('#7c3aed');
    hRange.setFontColor('#ffffff');
  }
  // Column A may contain either a Date object (Sheets auto-parsed it) or a
  // string, so normalize both sides to YYYY-MM-DD before comparing.
  function normalizeDate_(v) {
    if (v instanceof Date) {
      var tz = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone() || 'America/New_York';
      return Utilities.formatDate(v, tz, 'yyyy-MM-dd');
    }
    return String(v || '').slice(0, 10);
  }
  var targetDate = normalizeDate_(data.date);
  var lastRow = sheet.getLastRow();
  var existingRow = -1;
  if (lastRow > 1) {
    var dates = sheet.getRange(2, 1, lastRow - 1, 1).getValues();
    for (var i = 0; i < dates.length; i++) {
      if (normalizeDate_(dates[i][0]) === targetDate) { existingRow = i + 2; break; }
    }
  }
  if (existingRow > 0) {
    sheet.getRange(existingRow, 1, 1, row.length).setValues([row]);
  } else {
    sheet.appendRow(row);
    var newRow = sheet.getLastRow();
    sheet.getRange(newRow, 1).setNumberFormat('@');
  }
  sheet.autoResizeColumns(1, HEADERS.length);
  return ContentService
    .createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}

// New - one row per order, upserted by Order ID, in its own "Orders" tab
// (auto-created the first time it's needed so it never touches Revenue).
function writeOrderRow_(data) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Orders') || ss.insertSheet('Orders');
  var HEADERS = ['Order ID','Drop-off Date','Pickup Date','Customer','Phone',
                 'Service Type','Wash Style','Weight (lbs)','Bags',
                 'Comforters ($)','Total ($)','Amount Paid ($)','Status','Last Updated'];
  var row = [
    data.orderId || '', data.date || '', data.pickupDate || '',
    data.customer || '', data.phone || '', data.serviceType || '', data.washStyle || '',
    data.weight || 0, data.bags || '', data.comfortersTotal || 0,
    data.total || 0, data.amountPaid || 0, data.status || '',
    data.savedAt || new Date().toISOString()
  ];
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(HEADERS);
    var hRange = sheet.getRange(1, 1, 1, HEADERS.length);
    hRange.setFontWeight('bold');
    hRange.setBackground('#7c3aed');
    hRange.setFontColor('#ffffff');
  }
  var lastRow = sheet.getLastRow();
  var existingRow = -1;
  if (lastRow > 1) {
    var ids = sheet.getRange(2, 1, lastRow - 1, 1).getValues();
    for (var i = 0; i < ids.length; i++) {
      if (String(ids[i][0]) === String(data.orderId)) { existingRow = i + 2; break; }
    }
  }
  if (existingRow > 0) sheet.getRange(existingRow, 1, 1, row.length).setValues([row]);
  else sheet.appendRow(row);
  sheet.autoResizeColumns(1, HEADERS.length);
  return ContentService
    .createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}

// New - one row per logged issue, appended (not upserted - it's a log) to
// its own "Repairs" tab, auto-created the first time it's needed.
function writeRepairRow_(data) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Repairs') || ss.insertSheet('Repairs');
  var HEADERS = ['Machine','Type','Issue','Status','Reported By','Logged At'];
  var row = [
    data.machine || '', data.machineType || '', data.issue || '',
    data.status || '', data.reportedBy || '', data.savedAt || new Date().toISOString()
  ];
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(HEADERS);
    var hRange = sheet.getRange(1, 1, 1, HEADERS.length);
    hRange.setFontWeight('bold');
    hRange.setBackground('#7c3aed');
    hRange.setFontColor('#ffffff');
  }
  sheet.appendRow(row);
  sheet.autoResizeColumns(1, HEADERS.length);
  return ContentService
    .createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}

// New - one row per clock event (clock in/out, break/lunch start+end),
// appended (not upserted - it's a log) to its own "Clock" tab, auto-created
// the first time it's needed.
function writeClockRow_(data) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Clock') || ss.insertSheet('Clock');
  var HEADERS = ['Employee','Event','Time','Duration (min)','Break (min)','Logged At'];
  var row = [
    data.employee || '', data.event || '', data.time || '',
    data.durationMinutes || '', data.breakMinutes || '', data.savedAt || new Date().toISOString()
  ];
  if (sheet.getLastRow() === 0) {
    sheet.appendRow(HEADERS);
    var hRange = sheet.getRange(1, 1, 1, HEADERS.length);
    hRange.setFontWeight('bold');
    hRange.setBackground('#7c3aed');
    hRange.setFontColor('#ffffff');
  }
  sheet.appendRow(row);
  sheet.autoResizeColumns(1, HEADERS.length);
  return ContentService
    .createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}

Step 4. Click Deploy → New Deployment (or, if you're updating an existing script, Deploy → Manage deployments → ✏️ Edit → New version).
Step 5. Set type to Web app, execute as Me, who has access Anyone.
Step 6. Click Deploy, authorize, and copy the Web App URL.
Step 7. Paste the URL into the field above and click Save. If you're updating an existing deployment, the URL doesn't change — you only need to re-save it here if it's new.
Tip: Revenue still gets one row per day, upserted so re-syncing never duplicates. Orders get one row per order (also upserted, by Order ID). Repairs and Clock events are both appended as a running log. Each lives in its own sheet tab, created automatically the first time it's needed.