// Google Apps Script for Kurdish Veterinary Clinic System (VetClinic Cloud)
// Automatically creates and syncs: Sales, Purchases, Debts, MedicalRecords, Inventory, SyncState
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 provided' });
}
// 1. Save Full JSON State for instant cross-device sync (Mobile <-> PC)
const stateSheet = ss.getSheetByName('SyncState');
const timestamp = new Date().toISOString();
stateSheet.getRange('A2').setValue(JSON.stringify(appData));
stateSheet.getRange('B2').setValue(timestamp);
// 2. Populate Human-Readable Kurdish Tables in Google Sheets
syncSalesSheet(ss.getSheetByName('Sales'), appData.sales || []);
syncPurchasesSheet(ss.getSheetByName('Purchases'), appData.purchases || []);
syncDebtsSheet(ss.getSheetByName('Debts'), appData);
syncMedicalSheet(ss.getSheetByName('MedicalRecords'), appData.patients || []);
return jsonResponse({ status: 'success', updatedAt: timestamp });
}
} catch (err) {
return jsonResponse({ status: 'error', message: err.toString() });
} finally {
lock.releaseLock();
}
}
function ensureSheetsExist(ss) {
const required = [
{ name: 'Sales', headers: ['ژمارەی پسوولە', 'ناوی کڕیار', 'مۆبایل', 'بەرواری فرۆشتن', 'کۆی گشتی', 'بڕی دراو', 'قەرزی ماوە', 'تێبینی'] },
{ name: 'Purchases', headers: ['بەرواری کڕین', 'ناوی فرۆشیار', 'ناوی دەرمان', 'جۆر', 'بڕ', 'نرخی کڕین', 'کۆی گشتی', 'دراو', 'قەرزی ماوە'] },
{ name: 'Debts', headers: ['جۆری قەرز', 'ناو', 'بڕی پارەی دراو/وەرگیراو', 'بەروار', 'تێبینی'] },
{ name: 'MedicalRecords', headers: ['خاوەن ئاژەڵ', 'مۆبایل', 'جۆری ئاژەڵ', 'ناو/ژمارە', 'بەرواری سەردان', 'نەخۆشی و چارەسەر', 'ڤاکسینی داهاتوو'] },
{ name: 'SyncState', headers: ['JSON_BACKUP', 'LAST_UPDATED'] }
];
required.forEach(s => {
let sheet = ss.getSheetByName(s.name);
if (!sheet) {
sheet = ss.insertSheet(s.name);
sheet.getRange(1, 1, 1, s.headers.length).setValues([s.headers]).setFontWeight('bold');
sheet.setFrozenRows(1);
}
});
}
function syncSalesSheet(sheet, sales) {
sheet.getRange(2, 1, Math.max(sheet.getLastRow(), 2), 8).clearContent();
if (!sales.length) return;
const rows = sales.map(s => [
s.invoiceNum, s.customerName, s.customerPhone || '', s.date,
s.totalAmount, s.paidAmount, s.remainingAmount, s.notes || ''
]);
sheet.getRange(2, 1, rows.length, 8).setValues(rows);
}
function syncPurchasesSheet(sheet, purchases) {
sheet.getRange(2, 1, Math.max(sheet.getLastRow(), 2), 9).clearContent();
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 syncDebtsSheet(sheet, appData) {
sheet.getRange(2, 1, Math.max(sheet.getLastRow(), 2), 5).clearContent();
const payments = appData.debtPayments || [];
if (!payments.length) return;
const rows = payments.map(d => [
d.type === 'customer' ? 'وەرگرتنەوە لە کڕیار' : 'دانەوە بە فرۆشیار',
d.entityName, d.amount, d.date, d.notes || ''
]);
sheet.getRange(2, 1, rows.length, 5).setValues(rows);
}
function syncMedicalSheet(sheet, patients) {
sheet.getRange(2, 1, Math.max(sheet.getLastRow(), 2), 7).clearContent();
if (!patients.length) return;
const rows = patients.map(p => [
p.ownerName, p.ownerPhone || '', p.animalType, p.animalName || '',
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);
}