access code
/** @OnlyCurrentDoc */
function testRun() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
Logger.log(ss.getName());
}
function doGet(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
// Helper 1: Sirf raw data nikalne ke liye (Sikka aur Escrow ke liye)
function getRawData(sheetName) {
var sheet = ss.getSheetByName(sheetName);
if (!sheet) return [];
var data = sheet.getDataRange().getDisplayValues();
if (data.length > 0) data.shift();
return data;
}
// Helper 2: Channel Deals Operations ko object banane ke liye
function getOperationsData() {
var sheet = ss.getSheetByName("Operations");
if (!sheet) return [];
var data = sheet.getDataRange().getDisplayValues();
var result = [];
for (var i = 1; i < data.length; i++) {
result.push({
date: data[i][0] || "",
sellerWa: data[i][1] || "",
status: data[i][3] || "PENDING",
channelId: data[i][4] || "",
purchasePrice: data[i][10] || 0
});
}
return result;
}
// Helper 3: Finance ko object banane ke liye
function getFinanceData() {
var sheet = ss.getSheetByName("Finance");
if (!sheet) return [];
var data = sheet.getDataRange().getDisplayValues();
var result = [];
for (var i = 1; i < data.length; i++) {
result.push({
date: data[i][0] || "",
channelId: data[i][1] || "General",
category: data[i][2] || "",
type: data[i][3] || "",
amountIn: data[i][4] || 0,
amountOut: data[i][5] || 0,
remarks: data[i][6] || ""
});
}
return result;
}
// Final JSON Payload
var payload = {
channelDeals: {
operations: getOperationsData(),
finance: getFinanceData(),
chartData: {}
},
escrow: {
channels: getRawData("PTSDeals"),
items: getRawData("PTSitems")
},
sikka: {
transactions: getRawData("Sikka Transactions"),
profit: getRawData("Admin_Profit")
}
};
return ContentService.createTextOutput(JSON.stringify(payload))
.setMimeType(ContentService.MimeType.JSON);
}
