function doGet(e) { return handleRequest(e, 'GET'); }
function doPost(e) { return handleRequest(e, 'POST'); }
function handleRequest(e, method) {
const lock = LockService.getScriptLock();
lock.tryLock(15000);
try {
const ss = SpreadsheetApp.getActiveSpreadsheet();
ensureSheetsExist(ss);
if (method === 'GET') {
const stateSheet = ss.getSheetByName('SyncState');
const rawJson = stateSheet.getRange('A2').getValue();
const updatedAt = stateSheet.getRange('B2').getValue();
return jsonResponse({ status: 'success', data: rawJson ? JSON.parse(rawJson) : null, updatedAt: updatedAt || null });
}
if (method === 'POST') {
const payload = JSON.parse(e.postData.contents);
const appData = payload.data;
if (!appData) return jsonResponse({ status: 'error', message: 'No data' });
const stateSheet = ss.getSheetByName('SyncState');
const timestamp = new Date().toISOString();
stateSheet.getRange('A2').setValue(JSON.stringify(appData));
stateSheet.getRange('B2').setValue(timestamp);
syncSalesSheet(ss.getSheetByName('فرۆشتنەکان_Sales'), appData.sales || []);
syncLedgerSheet(ss.getSheetByName('قەرزی_دەفتەر_Ledger'), appData);
syncDailyDebtsSheet(ss.getSheetByName('قەرزی_ڕۆژانە_Daily'), appData);
syncCompaniesSheet(ss.getSheetByName('کۆمپانیاکان_Companies'), appData);
syncInventorySheet(ss.getSheetByName('کۆگای_دەرمان_Inventory'), appData.inventory || []);
syncMedicalSheet(ss.getSheetByName('تۆماری_پزیشکی_Clinic'), appData.patients || []);
return jsonResponse({ status: 'success', updatedAt: timestamp });
}
} catch (err) {
return jsonResponse({ status: 'error', message: err.toString() });
} finally {
lock.releaseLock();
}
}
function ensureSheetsExist(ss) {
const sheetsConfig = [
{ name: 'فرۆشتنەکان_Sales', color: '#0f766e', headers: ['پسوولە', 'ناوی کڕیار', 'مۆبایل', 'جۆری قەرز', 'ژ. دەفتەر', 'بەروار', 'وردەکاری دەرمان', 'کۆی گشتی', 'دراو', 'قەرزی ماوە'] },
{ name: 'قەرزی_دەفتەر_Ledger', color: '#d97706', headers: ['ڕیزبەندی دەفتەر', 'ناوی قەرزدار', 'مۆبایل', 'کاتی دانەوە', 'قەرزی سەرەتایی', 'کۆی قەرزی ماوە'] },
{ name: 'قەرزی_ڕۆژانە_Daily', color: '#0284c7', headers: ['ناوی قەرزدار', 'بڕی قەرزی ڕۆژانەی ماوە'] },
{ name: 'کۆمپانیاکان_Companies', color: '#be123c', headers: ['بەرواری کڕین', 'ناوی کۆمپانیا', 'ناوی دەرمان', 'جۆر', 'بڕ', 'نرخی کڕین', 'کۆی گشتی', 'دراو', 'قەرزی ماوە'] },
{ name: 'کۆگای_دەرمان_Inventory', color: '#4f46e5', headers: ['ناوی دەرمان', 'جۆر', 'بڕی ماوە لە کۆگا', 'نرخی کڕین', 'نرخی فرۆشتن', 'بەرواری بەسەرچوون'] },
{ name: 'تۆماری_پزیشکی_Clinic', color: '#e11d48', headers: ['خاوەن ئاژەڵ', 'مۆبایل', 'جۆری ئاژەڵ', 'جۆری سەردان', 'بەروار', 'دەستنیشانکردن و چارەسەر', 'مووعیدی داهاتوو'] },
{ name: 'SyncState', color: '#334155', headers: ['JSON_BACKUP', 'LAST_UPDATED'] }
];
sheetsConfig.forEach(cfg => {
let sheet = ss.getSheetByName(cfg.name);
if (!sheet) {
sheet = ss.insertSheet(cfg.name);
sheet.setRightToLeft(true);
const headerRange = sheet.getRange(1, 1, 1, cfg.headers.length);
headerRange.setValues([cfg.headers])
.setFontWeight('bold')
.setBackground(cfg.color)
.setFontColor('#ffffff')
.setHorizontalAlignment('center');
sheet.setFrozenRows(1);
}
});
}
function syncSalesSheet(sheet, sales) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 10).clearContent();
if (!sales.length) return;
const rows = sales.map(s => [
s.invoiceNum, s.customerName, s.customerPhone || '',
s.debtType === 'ledger' ? 'دەفتەر' : 'ڕۆژانە',
s.ledgerNumber || '-', s.date,
(s.items || []).map(i => i.name + ' (' + i.qty + ')').join('، '),
s.totalAmount, s.paidAmount, s.remainingAmount
]);
sheet.getRange(2, 1, rows.length, 10).setValues(rows);
}
function syncLedgerSheet(sheet, appData) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 6).clearContent();
const customers = (appData.ledgerCustomers || []).slice().sort((a, b) => Number(a.ledgerNumber) - Number(b.ledgerNumber));
if (!customers.length) return;
const rows = customers.map(c => {
let debt = Number(c.openingDebt || 0);
(appData.sales || []).forEach(s => {
if (s.debtType === 'ledger' && s.customerName === c.name) debt += Number(s.remainingAmount || 0);
});
(appData.debtPayments || []).forEach(d => {
if (d.type === 'ledger' && d.entityName === c.name) debt = Math.max(0, debt - Number(d.amount || 0));
});
return [c.ledgerNumber, c.name, c.phone || '', c.term || 'مانگانە', c.openingDebt || 0, debt];
});
sheet.getRange(2, 1, rows.length, 6).setValues(rows);
}
function syncDailyDebtsSheet(sheet, appData) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 2).clearContent();
const map = {};
(appData.sales || []).forEach(s => {
if ((s.debtType || 'daily') === 'daily' && s.remainingAmount > 0) {
map[s.customerName] = (map[s.customerName] || 0) + Number(s.remainingAmount || 0);
}
});
(appData.debtPayments || []).forEach(d => {
if (d.type === 'daily' && map[d.entityName] !== undefined) {
map[d.entityName] = Math.max(0, map[d.entityName] - Number(d.amount || 0));
}
});
const rows = Object.entries(map).filter(e => e[1] > 0);
if (!rows.length) return;
sheet.getRange(2, 1, rows.length, 2).setValues(rows);
}
function syncCompaniesSheet(sheet, appData) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 9).clearContent();
const purchases = appData.purchases || [];
if (!purchases.length) return;
const rows = purchases.map(p => [p.date, p.supplierName, p.itemName, p.category, p.qty, p.buyPrice, p.totalAmount, p.paidAmount, p.remainingAmount]);
sheet.getRange(2, 1, rows.length, 9).setValues(rows);
}
function syncInventorySheet(sheet, inv) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 6).clearContent();
if (!inv.length) return;
const rows = inv.map(i => [i.name, i.category, i.qty, i.buyPrice, i.sellPrice, i.expiryDate || '-']);
sheet.getRange(2, 1, rows.length, 6).setValues(rows);
}
function syncMedicalSheet(sheet, patients) {
if (sheet.getLastRow() > 1) sheet.getRange(2, 1, sheet.getLastRow() - 1, 7).clearContent();
if (!patients.length) return;
const rows = patients.map(p => [p.ownerName, p.ownerPhone || '', p.animalType, p.visitType || 'پشکنین', p.visitDate, p.diagnosis, p.nextDate || '-']);
sheet.getRange(2, 1, rows.length, 7).setValues(rows);
}
function jsonResponse(obj) {
return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(ContentService.MimeType.JSON);
}