ক্লাউড ডাটাবেসে নতুন টাস্ক বা আপডেট দ্বিমুখী লাইভ সেভ করার জন্য আপনার Apps Script Web App URL এখানে যুক্ত করুন। (শুধুমাত্র Admin পরিবর্তন করতে পারবেন)

// Google Apps Script (Code.gs) for WebTask Manager — Complete Cloud Sync API
function doGet(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var s1 = ss.getSheets()[0];
  var s2 = ss.getSheets()[1];
  var s3 = ss.getSheets()[2];
  var s4 = ss.getSheets()[3];
  
  return ContentService.createTextOutput(JSON.stringify({
    status: "success",
    tasks: formatRows(s1 ? s1.getDataRange().getValues() : []),
    updates: formatRows(s2 ? s2.getDataRange().getValues() : []),
    auditLogs: formatRows(s3 ? s3.getDataRange().getValues() : []),
    users: formatRows(s4 ? s4.getDataRange().getValues() : [])
  })).setMimeType(ContentService.MimeType.JSON);
}

function doPost(e) {
  try {
    var params = JSON.parse(e.postData.contents);
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheets = ss.getSheets();
    var nowStr = Utilities.formatDate(new Date(), "GMT+6", "yyyy-MM-dd HH:mm:ss");
    var shortNow = Utilities.formatDate(new Date(), "GMT+6", "yyyy-MM-dd HH:mm");
    
    if (params.type === "ADD_TASK" && sheets[0]) {
      sheets[0].appendRow([
        params.task.id, params.task.title, params.task.page, params.task.category,
        params.task.status, params.task.priority, params.task.assignedTo,
        params.task.version, params.task.dueDate, shortNow, params.task.notes
      ]);
    } else if (params.type === "UPDATE_TASK" && sheets[0]) {
      var t = params.task;
      updateRowById(sheets[0], 0, t.id, [
        t.id, t.title, t.page, t.category, t.status, t.priority,
        t.assignedTo, t.version, t.dueDate, shortNow, t.notes
      ]);
    } else if (params.type === "DELETE_TASK" && sheets[0]) {
      deleteRowById(sheets[0], 0, params.taskId);
    } else if (params.type === "ADD_UPDATE" && sheets[1]) {
      sheets[1].appendRow([
        params.update.id, params.update.version, params.update.title,
        params.update.page, params.update.date, params.update.status, params.update.summary
      ]);
    } else if (params.type === "DELETE_UPDATE" && sheets[1]) {
      deleteRowById(sheets[1], 0, params.updateId);
    } else if (params.type === "ADD_AUDIT_LOG" && sheets[2]) {
      var a = params.audit;
      sheets[2].appendRow([
        a.id, a.timestamp || nowStr, a.userName, a.userRole, a.actionType, a.targetItem, a.details, a.severity || "Low"
      ]);
    } else if (params.type === "ADD_USER" && sheets[3]) {
      var u = params.user;
      sheets[3].appendRow([
        u.id, u.name, u.email, u.password, u.role, u.department, u.status || "Active", u.lastLogin || "-"
      ]);
    } else if (params.type === "UPDATE_USER" && sheets[3]) {
      var u = params.user;
      updateRowById(sheets[3], 0, u.id, [
        u.id, u.name, u.email, u.password, u.role, u.department, u.status || "Active", u.lastLogin || shortNow
      ]);
    } else if (params.type === "DELETE_USER" && sheets[3]) {
      deleteRowById(sheets[3], 0, params.userId);
    }
    return ContentService.createTextOutput(JSON.stringify({status: "success"})).setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService.createTextOutput(JSON.stringify({status: "error", message: err.toString()})).setMimeType(ContentService.MimeType.JSON);
  }
}

function updateRowById(sheet, colIdx, id, rowVals) {
  if (!sheet) return;
  var data = sheet.getDataRange().getValues();
  for (var i = 1; i < data.length; i++) {
    if (String(data[i][colIdx]) === String(id)) {
      sheet.getRange(i + 1, 1, 1, rowVals.length).setValues([rowVals]);
      return;
    }
  }
}

function deleteRowById(sheet, colIdx, id) {
  if (!sheet) return;
  var data = sheet.getDataRange().getValues();
  for (var i = data.length - 1; i >= 1; i--) {
    if (String(data[i][colIdx]) === String(id)) {
      sheet.deleteRow(i + 1);
      return;
    }
  }
}

function formatRows(data) {
  if (!data || data.length <= 1) return [];
  var headers = data[0], rows = [];
  for (var i = 1; i < data.length; i++) {
    var item = {};
    for (var j = 0; j < headers.length; j++) item[headers[j]] = data[i][j];
    rows.push(item);
  }
  return rows;
}