-
Notifications
You must be signed in to change notification settings - Fork 0
/
Menu.js
84 lines (76 loc) · 2.23 KB
/
Menu.js
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
function onOpen() {
const ui = SpreadsheetApp.getUi();
ui.createMenu("Mark an Attendance")
.addItem("Mark Cancelled", "markCancelled")
.addItem("Mark Late Bail", "markLateBail")
.addItem("Mark No Show", "markNoShow")
.addSeparator()
.addItem("Mark Cancelled by the Crew", "markCrewCancelled")
.addSeparator()
.addItem("Mark Duplicate", "markDuplicate")
.addSeparator()
.addItem("Mark Attended", "markAttended")
.addSeparator()
.addItem("Mark ALL Attended", "markAttendedAndCloseEvent")
.addToUi();
ui.createMenu("Refresh Matrix")
.addItem("Refresh All", "readData")
.addSeparator()
.addItem("Refresh Diet", "refreshDiet")
.addItem("Refresh Gear", "refreshGear")
.addItem("Refresh Admin", "refreshAdmin")
.addItem("Refresh Transport", "refreshTransport")
.addItem("Refresh Buddy", "refreshBuddy")
.addItem("Refresh Event Listing", "refreshEventListing")
.addSeparator()
.addItem("Refresh Event Listings", "eventListing")
.addToUi();
ui.createMenu("Event Management")
.addItem("Open Event Spaces", "openEventSpaces")
.addItem("Open Signup", "openSignup")
.addItem("Close Signup", "closeSignup")
.addItem("Cancel Whole Event", "cancelWholeEvent")
.addToUi();
}
function refreshDiet() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readDiet(stmt);
stmt.close();
conn.close();
}
function refreshGear() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readGear(stmt);
stmt.close();
conn.close();
}
function refreshAdmin() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readAdmin(stmt);
stmt.close();
conn.close();
}
function refreshTransport() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readTransport(stmt);
stmt.close();
conn.close();
}
function refreshBuddy() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readBuddy(stmt);
stmt.close();
conn.close();
}
function refreshEventListing() {
const conn = Jdbc.getConnection(url, username, password);
const stmt = conn.createStatement();
readEventListing(stmt);
stmt.close();
conn.close();
}