function doPost(e){
  var ss=SpreadsheetApp.openById(
    '1hc2BLG1fkPshWcqTEyjcFsog7N-DHC6nzMkO9UjqHs0');
  var sh=ss.getSheetByName('Tegula Quotes')
         ||ss.getSheets()[0];
  var d=JSON.parse(e.postData.contents);
  if(sh.getLastRow()===0){
    sh.appendRow(['Status','Time','ID','Name',
      'Email','Phone','ZIP','Service','Sqft',
      'Budget','Timeline','Contact',
      'Priorities','Score']);
    sh.getRange(1,1,1,14)
      .setBackground('#2C2C2C')
      .setFontColor('#FFFFFF')
      .setFontWeight('bold');
    sh.getRange(1,1).setBackground('#1A3358');
  }
  var status=d.status||'New';
  var nr=sh.appendRow([status,new Date(),
    d.id,d.name,d.email,d.phone,d.zip,
    d.svc,d.sqft,d.budget,d.timeline,
    d.contact,d.priorities,d.score])
    .getLastRow();
  var row=sh.getLastRow();
  sh.getRange(row,1)
    .setBackground(
      status==='hot'?'#FAE8E8':
      status==='warm'?'#FFF8E1':'#E6EFF8')
    .setFontColor(
      status==='hot'?'#7A1C1C':
      status==='warm'?'#7A5800':'#1A3358')
    .setFontWeight('bold');
  return ContentService.createTextOutput('OK');
}
// Friday 7PM auto-clean: remove blanks
function weeklyClean(){
  var ss=SpreadsheetApp.openById(
    '1hc2BLG1fkPshWcqTEyjcFsog7N-DHC6nzMkO9UjqHs0');
  var sh=ss.getSheetByName('Tegula Quotes')
         ||ss.getSheets()[0];
  var n=sh.getLastRow();
  if(n<2)return;
  var data=sh.getRange(2,1,n-1,14).getValues();
  var ok=data.filter(function(r){return r[0]&&r[2];});
  sh.getRange(2,1,n-1,14).clearContent();
  if(ok.length)sh.getRange(2,1,ok.length,14)
    .setValues(ok);
}

function doPost(e){
  var ss=SpreadsheetApp.openById(
    '1VQIiitNzopg-0Mmu3oeE_YWCUugOkKk56avsNZqrv2o');
  var sh=ss.getSheetByName('Tegula Contractors')
         ||ss.getSheets()[0];
  var d=JSON.parse(e.postData.contents);
  if(sh.getLastRow()===0){
    sh.appendRow(['Status','Time','ID','Name',
      'Company','Email','Phone','Username',
      'Password','Plan','Joined','ZIPs','Specialties']);
    sh.getRange(1,1,1,13)
      .setBackground('#2C2C2C')
      .setFontColor('#FFFFFF')
      .setFontWeight('bold');
    sh.getRange(1,1).setBackground('#1E5C2E');
  }
  var rows=sh.getDataRange().getValues();
  var idx=-1;
  for(var i=1;i<rows.length;i++)
    if(String(rows[i][2])===String(d.id)){idx=i+1;break;}
  var status=d.status||'Active';
  var row=[status,new Date(),d.id,d.name,
    d.company||'',d.email||'',d.phone||'',
    d.username||'',d.password||'',
    d.plan,d.joined,d.zips,d.specs];
  if(idx>0){
    sh.getRange(idx,1,1,13).setValues([row]);
    sh.getRange(idx,1).setBackground(
      status==='Active'?'#E6F4EA':'#FAE8E8')
      .setFontColor(
      status==='Active'?'#1E5C2E':'#7A1C1C')
      .setFontWeight('bold');
  } else {
    sh.appendRow(row);
    var nr=sh.getLastRow();
    sh.getRange(nr,1).setBackground(
      status==='Active'?'#E6F4EA':'#FAE8E8')
      .setFontColor(
      status==='Active'?'#1E5C2E':'#7A1C1C')
      .setFontWeight('bold');
  }
  return ContentService.createTextOutput('OK');
}
function weeklyRenew(){
  var ss=SpreadsheetApp.openById(
    '1VQIiitNzopg-0Mmu3oeE_YWCUugOkKk56avsNZqrv2o');
  var sh=ss.getSheetByName('Tegula Contractors')
         ||ss.getSheets()[0];
  var n=sh.getLastRow();
  for(var i=2;i<=n;i++){
    sh.getRange(i,1).setValue('Active')
      .setBackground('#E6F4EA')
      .setFontColor('#1E5C2E')
      .setFontWeight('bold');
  }
}
function markInactive(contractorId){
  var ss=SpreadsheetApp.openById(
    '1VQIiitNzopg-0Mmu3oeE_YWCUugOkKk56avsNZqrv2o');
  var sh=ss.getSheetByName('Tegula Contractors')
         ||ss.getSheets()[0];
  var rows=sh.getDataRange().getValues();
  for(var i=1;i<rows.length;i++){
    if(String(rows[i][2])===String(contractorId)){
      sh.getRange(i+1,1).setValue('Inactive')
        .setBackground('#FAE8E8')
        .setFontColor('#7A1C1C')
        .setFontWeight('bold');
      break;
    }
  }
}