var SHEET_NAME      = 'Leads';
var PROSPECTS_SHEET = 'Prospects';

var COLS = ['id','dateAdded','type','company','contactName','title','email',
            'phone','linkedin','website','source','signal','priority','notes','status',
            'lastContacted','followUpBy','tags','activities',
            'dealValue','incumbent','contactRole','photo'];

var PROSPECT_COLS = ['id','dateAdded','company','contactName','title',
                     'email','linkedin','website','source','signal','notes','status',
                     'jobTitle','jobUrl','photo'];

function doGet(e) {
  try {
    var ss = SpreadsheetApp.getActiveSpreadsheet();

    // ── Leads ──
    var leadsSheet = ss.getSheetByName(SHEET_NAME);
    var leads = [];
    if (leadsSheet && leadsSheet.getLastRow() > 1) {
      var rows = leadsSheet.getRange(2, 1, leadsSheet.getLastRow() - 1, COLS.length).getValues();
      leads = rows.map(function(row) {
        var lead = {};
        COLS.forEach(function(h, i) {
          if (h === 'tags' || h === 'activities') {
            try { lead[h] = JSON.parse(row[i] || '[]'); } catch(x) { lead[h] = []; }
          } else { lead[h] = row[i]; }
        });
        lead.id = Number(lead.id);
        return lead;
      });
    }

    // ── Prospects ──
    var pSheet = ss.getSheetByName(PROSPECTS_SHEET);
    var prospects = [];
    if (pSheet && pSheet.getLastRow() > 1) {
      var pRows = pSheet.getRange(2, 1, pSheet.getLastRow() - 1, PROSPECT_COLS.length).getValues();
      prospects = pRows.map(function(row) {
        var p = {};
        PROSPECT_COLS.forEach(function(h, i) { p[h] = row[i]; });
        p.id = Number(p.id);
        return p;
      });
    }

    return json({ leads: leads, prospects: prospects });
  } catch(e) { return json({ error: e.message }); }
}

function doPost(e) {
  try {
    var data = JSON.parse(e.postData.contents);
    var ss   = SpreadsheetApp.getActiveSpreadsheet();

    if (data.action === 'save_all') {
      var sheet = ss.getSheetByName(SHEET_NAME);
      if (!sheet) return json({ error: 'Sheet "Leads" not found' });
      if (sheet.getLastRow() > 1) sheet.deleteRows(2, sheet.getLastRow() - 1);
      var leads = data.leads || [];
      if (leads.length > 0) {
        var rows = leads.map(function(lead) {
          return COLS.map(function(h) {
            if (h === 'tags' || h === 'activities') return JSON.stringify(lead[h] || []);
            return lead[h] !== undefined ? lead[h] : '';
          });
        });
        sheet.getRange(2, 1, rows.length, COLS.length).setValues(rows);
      }
      return json({ ok: true, count: leads.length });
    }

    if (data.action === 'save_prospects') {
      var pSheet = ss.getSheetByName(PROSPECTS_SHEET);
      if (!pSheet) {
        pSheet = ss.insertSheet(PROSPECTS_SHEET);
        pSheet.getRange(1, 1, 1, PROSPECT_COLS.length).setValues([PROSPECT_COLS]);
      }
      if (pSheet.getLastRow() > 1) pSheet.deleteRows(2, pSheet.getLastRow() - 1);
      var precs = data.prospects || [];
      if (precs.length > 0) {
        var pRows = precs.map(function(p) {
          return PROSPECT_COLS.map(function(h) { return p[h] !== undefined ? p[h] : ''; });
        });
        pSheet.getRange(2, 1, pRows.length, PROSPECT_COLS.length).setValues(pRows);
      }
      return json({ ok: true, count: precs.length });
    }

    if (data.action === 'add_prospect') {
      var pSheet = ss.getSheetByName(PROSPECTS_SHEET);
      if (!pSheet) {
        pSheet = ss.insertSheet(PROSPECTS_SHEET);
        pSheet.getRange(1, 1, 1, PROSPECT_COLS.length).setValues([PROSPECT_COLS]);
      }
      var p = data.prospect || {};
      if (!p.id) p.id = new Date().getTime();
      if (!p.dateAdded) p.dateAdded = new Date().toISOString().split('T')[0];
      if (!p.status) p.status = 'new';
      var row = PROSPECT_COLS.map(function(h) { return p[h] !== undefined ? p[h] : ''; });
      pSheet.appendRow(row);
      return json({ ok: true, id: p.id });
    }

    return json({ error: 'Unknown action' });
  } catch(e) { return json({ error: e.message }); }
}

function json(data) {
  return ContentService.createTextOutput(JSON.stringify(data))
    .setMimeType(ContentService.MimeType.JSON);
}