Phoenix Asia — PC Builder

🔗 Koneksi Google Sheets

Belum terhubung (mode demo lokal)

URL Web App (Google Apps Script)

Lihat panduan & kode setup (sekali saja)

Buat Google Sheet baru (boleh kosong, judul apa saja).
Menu Extensions → Apps Script.
Hapus semua isi editor kode, tempel kode di bawah ini.
Deploy → New deployment → pilih tipe Web app.
Execute as: Me. Who has access: Anyone.
Klik Deploy, izinkan akses saat diminta Google, lalu salin URL Web App yang muncul.
Tempel URL itu di kolom di atas, klik "Simpan & Hubungkan".

/**
 * Phoenix Asia - PC Builder backend (Google Apps Script)
 * Tempel semua kode ini di Extensions > Apps Script pada Google Sheet-mu,
 * lalu Deploy sebagai Web app (Execute as: Me, Who has access: Anyone).
 */

const SHEET_NAME = 'Products';
const IMAGE_FOLDER_NAME = 'PhoenixAsia_ProductImages';

function doGet(e) {
  try {
    const action = (e.parameter.action || 'list');
    if (action === 'list') return jsonOut({ success: true, products: getAllProducts() });
    return jsonOut({ success: false, error: 'Unknown action' });
  } catch (err) {
    return jsonOut({ success: false, error: String(err) });
  }
}

function doPost(e) {
  try {
    const body = JSON.parse(e.postData.contents);
    const action = body.action;
    let result;
    if (action === 'add') result = addProduct(body.product);
    else if (action === 'update') result = updateProduct(body.product);
    else if (action === 'delete') result = deleteProduct(body.id);
    else if (action === 'bulkAdd') result = bulkAddProducts(body.products);
    else if (action === 'uploadImage') result = uploadImage(body.image, body.fileName);
    else result = { success: false, error: 'Unknown action' };
    return jsonOut(result);
  } catch (err) {
    return jsonOut({ success: false, error: String(err) });
  }
}

function getSheet() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(SHEET_NAME);
  if (!sheet) {
    sheet = ss.insertSheet(SHEET_NAME);
    sheet.appendRow(['id', 'category', 'name', 'price', 'stock', 'specs', 'image']);
  }
  return sheet;
}

function getAllProducts() {
  const sheet = getSheet();
  const data = sheet.getDataRange().getValues();
  const rows = data.slice(1);
  return rows.filter(function (r) { return r[0]; }).map(function (r) {
    return {
      id: String(r[0]),
      category: r[1],
      name: r[2],
      price: Number(r[3]) || 0,
      stock: Number(r[4]) || 0,
      specs: safeParse(r[5]),
      image: r[6] || null
    };
  });
}

function addProduct(p) {
  const sheet = getSheet();
  sheet.appendRow([p.id, p.category, p.name, p.price, p.stock, JSON.stringify(p.specs || {}), p.image || '']);
  return { success: true };
}

function updateProduct(p) {
  const sheet = getSheet();
  const data = sheet.getDataRange().getValues();
  for (let i = 1; i < data.length; i++) {
    if (String(data[i][0]) === String(p.id)) {
      sheet.getRange(i + 1, 1, 1, 7).setValues([[p.id, p.category, p.name, p.price, p.stock, JSON.stringify(p.specs || {}), p.image || '']]);
      return { success: true };
    }
  }
  return { success: false, error: 'Produk tidak ditemukan' };
}

function deleteProduct(id) {
  const sheet = getSheet();
  const data = sheet.getDataRange().getValues();
  for (let i = 1; i < data.length; i++) {
    if (String(data[i][0]) === String(id)) {
      sheet.deleteRow(i + 1);
      return { success: true };
    }
  }
  return { success: false, error: 'Produk tidak ditemukan' };
}

function bulkAddProducts(products) {
  const sheet = getSheet();
  const rows = (products || []).map(function (p) {
    return [p.id, p.category, p.name, p.price, p.stock, JSON.stringify(p.specs || {}), p.image || ''];
  });
  if (rows.length) {
    sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, 7).setValues(rows);
  }
  return { success: true, count: rows.length };
}

function uploadImage(base64DataUrl, fileName) {
  const folder = getOrCreateFolder();
  const contentType = base64DataUrl.substring(base64DataUrl.indexOf(':') + 1, base64DataUrl.indexOf(';'));
  const base64 = base64DataUrl.substring(base64DataUrl.indexOf(',') + 1);
  const bytes = Utilities.base64Decode(base64);
  const blob = Utilities.newBlob(bytes, contentType, fileName || ('product_' + Date.now() + '.jpg'));
  const file = folder.createFile(blob);
  file.setSharing(DriveApp.Access.ANYONE_WITH_LINK, DriveApp.Permission.VIEW);
  return { success: true, url: 'https://drive.google.com/uc?export=view&id=' + file.getId() };
}

function getOrCreateFolder() {
  const folders = DriveApp.getFoldersByName(IMAGE_FOLDER_NAME);
  if (folders.hasNext()) return folders.next();
  return DriveApp.createFolder(IMAGE_FOLDER_NAME);
}

function safeParse(s) {
  try { return JSON.parse(s); } catch (e) { return {}; }
}

function jsonOut(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(ContentService.MimeType.JSON);
}

Catatan keamanan: karena akses "Anyone", siapa pun yang memegang URL ini bisa membaca & menulis data produkmu. Jangan sebar URL ini secara publik.

+ Tambah Komponen

Kategori

Nama Produk

Harga (Rp)

Stok

Gambar Produk

Klik untuk unggah gambar (opsional)

⇅ Bulk Input Produk

Satu produk per baris, format: kategori, nama, harga, stok. Kategori: cpu, motherboard, ram, gpu, storage, psu, case, cooler.