const GITHUB_REPO = 'seniga1/altis-dashboard';
const GITHUB_FILE_PATH = 'index.html';

function doGet(e) {
  const ssCompras = SpreadsheetApp.openById('1CNrs0KtKxsPlhhj6KyijcGJwlX9s3O9ae6L9gKTJ3qc');
  const ssPanel = SpreadsheetApp.openById('1NkBChFAq7pAkvzS7KfJtfSVUSMFvuK0Pqly6hDyMNPY');
  const ssStock = SpreadsheetApp.openById('1_zPyUO_ZgPEsYztwvtn4DHRo_XbdgYtpLDNtW9gr-4c');

  const sheetTN = ssStock.getSheetByName('Inventario_TN');
  const sheetEgresos = ssStock.getSheetByName('Egresos_No_Comerciales');

  const threads = GmailApp.search('from:ventas@tiendanegocio.com "Nueva venta"', 0, 20);
  const ventas = threads.map(t => ({
    subject: t.getFirstMessageSubject(),
    date: t.getLastMessageDate(),
    snippet: t.getMessages()[0].getPlainBody().slice(0, 350)
  }));

  const payload = {
    updatedAt: new Date().toISOString(),
    ventasRecientes: ventas,
    inventarioTN: sheetTN ? sheetTN.getDataRange().getValues() : [],
    egresosNoComerciales: sheetEgresos ? sheetEgresos.getDataRange().getValues() : [],
    comprasRows: ssCompras.getSheets()[0].getDataRange().getValues(),
    panelRows: ssPanel.getSheets()[0].getDataRange().getValues()
  };

  return ContentService.createTextOutput(JSON.stringify(payload))
    .setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  try {
    const body = JSON.parse(e.postData.contents);
    const ssStock = SpreadsheetApp.openById('1_zPyUO_ZgPEsYztwvtn4DHRo_XbdgYtpLDNtW9gr-4c');

    if (body.action === 'ADD_NON_COMMERCIAL') {
      const sheetEgresos = ssStock.getSheetByName('Egresos_No_Comerciales');
      sheetEgresos.appendRow([
        new Date(),
        body.sku,
        body.productName,
        body.qty,
        body.reason,
        body.unitCost,
        body.qty * body.unitCost,
        body.notes || ''
      ]);
      return ContentService.createTextOutput(JSON.stringify({ status: 'ok' }))
        .setMimeType(ContentService.MimeType.JSON);
    }
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({ status: 'error', message: err.toString() }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}