運営マニュアル

const DEALS_SHEET_NAME = 'Deals';
const CONFIG_SHEET_NAME = 'Config';
const DEAL_HEADERS = ['id', 'year', 'month', 'cat', 'st', 'tanto', 'name', 'uri', 'gen', 'note'];

function initSheets() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  if (!ss.getSheetByName(DEALS_SHEET_NAME)) {
    const s = ss.insertSheet(DEALS_SHEET_NAME);
    s.appendRow(DEAL_HEADERS);
  }
  if (!ss.getSheetByName(CONFIG_SHEET_NAME)) {
    const s = ss.insertSheet(CONFIG_SHEET_NAME);
    s.appendRow(['key', 'value']);
  }
}

function doGet(e) {
  initSheets();
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const dealSheet = ss.getSheetByName(DEALS_SHEET_NAME);
  const dealsData = dealSheet.getDataRange().getValues();
  const headers = dealsData[0];
  const deals = [];
  for (let i = 1; i < dealsData.length; i++) {
    let obj = {};
    for (let j = 0; j < headers.length; j++) obj[headers[j]] = dealsData[i][j];
    deals.push(obj);
  }

  const configSheet = ss.getSheetByName(CONFIG_SHEET_NAME);
  const configData = configSheet.getDataRange().getValues();
  let config = {};
  for (let i = 1; i < configData.length; i++) {
    try { config[configData[i][0]] = JSON.parse(configData[i][1]); } catch(err) {}
  }

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

function doPost(e) {
  initSheets();
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let data;
  try {
    data = JSON.parse(e.postData.contents);
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({ok: false, error: 'Invalid JSON'}))
      .setMimeType(ContentService.MimeType.JSON);
  }

  if (data.action === 'update_config') {
    const sheet = ss.getSheetByName(CONFIG_SHEET_NAME);
    const rows = sheet.getDataRange().getValues();
    let found = false;
    for (let i = 1; i < rows.length; i++) {
      if (rows[i][0] === data.key) {
        sheet.getRange(i + 1, 2).setValue(JSON.stringify(data.value));
        found = true;
        break;
      }
    }
    if (!found) sheet.appendRow([data.key, JSON.stringify(data.value)]);
    return ContentService.createTextOutput(JSON.stringify({ok: true}))
      .setMimeType(ContentService.MimeType.JSON);
  }

  const dealSheet = ss.getSheetByName(DEALS_SHEET_NAME);
  if (data.action === 'create') {
    let d = data.deal;
    dealSheet.appendRow([d.id, d.year, d.month, d.cat, d.st, d.tanto, d.name, d.uri, d.gen, d.note]);
  } else if (data.action === 'update') {
    let d = data.deal;
    let rows = dealSheet.getDataRange().getValues();
    for(let i = 1; i < rows.length; i++) {
      if(rows[i][0] == d.id) {
        dealSheet.getRange(i + 1, 1, 1, DEAL_HEADERS.length)
          .setValues([[d.id, d.year, d.month, d.cat, d.st, d.tanto, d.name, d.uri, d.gen, d.note]]);
        break;
      }
    }
  } else if (data.action === 'delete') {
    let id = data.id;
    let rows = dealSheet.getDataRange().getValues();
    for(let i = 1; i < rows.length; i++) {
      if(rows[i][0] == id) {
        dealSheet.deleteRow(i + 1);
        break;
      }
    }
  }

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