Repository navigation
Expand file tree
/
Copy pathgoogle_apps_script.js
More file actions
156 lines (137 loc) · 4.03 KB
/
Copy pathgoogle_apps_script.js
File metadata and controls
156 lines (137 loc) · 4.03 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
/**
* Google Apps Script Backend for VITAL App
*
* Deploy as Web App:
* Execute as: Me
* Who has access: Anyone
*
* Payload contracts:
* Logs (Create):
* { "timestamp": "...", "type": "...", "uid": "...",
* "weight": ..., "bp_sys": ..., "bp_dia": ..., "hr": ..., "value": ..., "unit": ..., "notes": ... }
*
* Delete:
* { "type": "DELETE", "uid": "..." }
*
* Profile:
* { "timestamp": "...", "type": "PROFILE", "name": "Mom" }
*/
var LOG_HEADERS = [
"UID",
"Date",
"Time",
"Type",
"Value",
"Unit",
"Weight",
"BP Systolic",
"BP Diastolic",
"Heart Rate",
"Notes",
];
var LOG_SHEET = "Logs";
var PROFILE_HEADERS = ["Name", "CreatedAt", "UpdatedAt"];
var PROFILE_SHEET = "Profile";
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
if (!data.type) {
return _json({ status: "error", message: "Missing 'type'" });
}
if (data.type === "DELETE") {
return _handleDelete(data);
}
if (data.type === "PROFILE") {
var ts = data.timestamp ? new Date(data.timestamp) : new Date();
return _handleProfile(data, ts);
}
// Default: Handle as a Log Entry (Create/Update)
var ts = data.timestamp ? new Date(data.timestamp) : new Date();
return _handleLog(data, ts);
} catch (err) {
return _json({ status: "error", message: String(err) });
}
}
function _handleLog(data, ts) {
var sheet = _ensureSheet(LOG_SHEET, LOG_HEADERS);
var tz = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();
// Use provided UID or generate one
var uid = data.uid || Utilities.getUuid();
// If UID exists, update it. Otherwise append.
var existingRow = _findRowByUid(sheet, uid);
var rowData = [
uid,
Utilities.formatDate(ts, tz, "yyyy-MM-dd"),
Utilities.formatDate(ts, tz, "HH:mm:ss"),
data.type,
_nullable(data.value),
_nullable(data.unit),
_nullable(data.weight),
_nullable(data.bp_sys),
_nullable(data.bp_dia),
_nullable(data.hr),
_nullable(data.notes),
];
if (existingRow > 0) {
sheet.getRange(existingRow, 1, 1, rowData.length).setValues([rowData]);
} else {
sheet.appendRow(rowData);
}
return _json({ status: "success", uid: uid });
}
function _handleDelete(data) {
if (!data.uid)
return _json({ status: "error", message: "Missing 'uid' for delete" });
var sheet = _ensureSheet(LOG_SHEET, LOG_HEADERS);
var row = _findRowByUid(sheet, data.uid);
if (row > 0) {
sheet.deleteRow(row);
return _json({ status: "success", message: "Deleted row " + row });
}
return _json({ status: "error", message: "Record not found" });
}
function _handleProfile(data, ts) {
if (!data.name || String(data.name).trim() === "") {
return _json({ status: "error", message: "Missing 'name'" });
}
var sheet = _ensureSheet(PROFILE_SHEET, PROFILE_HEADERS);
var tz = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();
var nowStr = Utilities.formatDate(ts, tz, "yyyy-MM-dd HH:mm:ss");
var name = String(data.name).trim();
if (sheet.getLastRow() > 1) {
var row = 2;
sheet
.getRange(row, 1, 1, 3)
.setValues([[name, sheet.getRange(row, 2).getValue() || nowStr, nowStr]]);
} else {
sheet.appendRow([name, nowStr, nowStr]);
}
return _json({ status: "success", name: name });
}
function _findRowByUid(sheet, uid) {
if (sheet.getLastRow() < 2) return -1;
var data = sheet.getRange(2, 1, sheet.getLastRow() - 1, 1).getValues();
for (var i = 0; i < data.length; i++) {
if (data[i][0] == uid) return i + 2;
}
return -1;
}
function _ensureSheet(name, headers) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(name);
if (!sheet) {
sheet = ss.insertSheet(name);
sheet.appendRow(headers);
} else if (sheet.getLastRow() === 0) {
sheet.appendRow(headers);
}
return sheet;
}
function _nullable(v) {
return v === null || v === undefined ? "" : v;
}
function _json(obj) {
return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(
ContentService.MimeType.JSON,
);
}