-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathFloat.gs
More file actions
186 lines (168 loc) · 5 KB
/
Copy pathFloat.gs
File metadata and controls
186 lines (168 loc) · 5 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
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
function run() {
advanceTasks();
removeUnsolicitedEvents();
}
function advanceTasks() {
const taskLists = getTaskLists();
for (let i = 0; i < taskLists.length; i++) {
const taskList = taskLists[i];
console.log(`Found task list called ${taskList.name}`);
const overdueTasks = getOverdueTasks(taskList.id);
console.log(`Found ${overdueTasks.length} overdue tasks`);
for (let j = 0; j < overdueTasks.length; j++) {
advanceTask(taskList.id, overdueTasks[j].id);
}
const completedTasks = getCompletedTasks(taskList.id);
console.log(`Found ${completedTasks.length} completed tasks`);
for (let j = 0; j < completedTasks.length; j++) {
console.log(`Found completed task called ${completedTasks[j].title}`);
if (!convertTask( completedTasks[j] ) ) {
deleteTask(taskList.id, completedTasks[j].id);
} else if (addCalendarEvent(completedTasks[j].title, completedTasks[j].notes, completedTasks[j].completed, completedTasks[j].links)) {
deleteTask(taskList.id, completedTasks[j].id);
}
}
}
}
function convertTask( task ) {
if (task.notes && task.notes.includes( "#delete" )) {
return false;
} else if (task.title && task.title.includes( "temporarily" )) {
return false;
} else {
return true;
}
}
function getTaskLists() {
const taskLists = Tasks.Tasklists.list();
if (!taskLists || !taskLists.items) {
return [];
}
return taskLists.items.map(taskList => ({
id: taskList.id,
name: taskList.title,
}));
}
function getOverdueTasks(listId) {
const params = {
dueMax: formatDate(getToday()),
showCompleted: false,
showDeleted: false,
};
const tasks = Tasks.Tasks.list(listId, params);
if (!tasks || !tasks.items) {
return [];
}
return tasks.items.map(task => ({
id: task.id,
title: task.title,
due: task.due,
})).filter(task => task.title);
}
function advanceTask(taskListId, taskId) {
const task = Tasks.Tasks.get(taskListId, taskId);
let dueDate = new Date(task.due);
console.log(`Advancing task ${task.title} due at ${dueDate}`);
while (dueDate < getToday()) {
dueDate.setDate(dueDate.getDate() + 1);
}
console.log(`Task will now be due at ${dueDate}`);
task.due = formatDate(dueDate); // Update the due date
Tasks.Tasks.update(task, taskListId, taskId);
}
function getToday() {
const today = new Date();
today.setDate(today.getDate() - 1);
return today;
}
function getCompletedTasks(listId) {
const params = {
showCompleted: true,
showHidden: true,
completedMax: getEndOfDays(),
showDeleted: false,
};
const tasks = Tasks.Tasks.list(listId, params);
if (!tasks || !tasks.items) {
return [];
}
return tasks.items.map(task => ({
id: task.id,
title: task.title,
notes: task.notes,
completed: task.completed,
links: task.links,
})).filter(task => task.title);
}
function getEndOfDays() {
const date = new Date();
date.setDate(date.getDate() + 365000);
return formatDate(date);
}
function addCalendarEvent(title, notes, date, links) {
if (links) {
if (!notes) {
notes = "Links:\n";
} else {
notes = notes + "\n\nLinks:\n";
}
for (let i = 0; i < links.length; i++) {
notes = notes + links[i].type + ": " + links[i].link + "\n";
}
}
const event = {
start: {
dateTime: date,
},
end: {
dateTime: date,
},
summary: title,
transparency: "transparent", // Don't block time
description: notes,
};
Calendar.Events.insert(event, Session.getActiveUser().getEmail());
return true;
}
function deleteTask(taskListId, taskId) {
Tasks.Tasks.remove(taskListId, taskId);
}
function removeUnsolicitedEvents() {
const events = getUnsolicitedEvents();
console.log(`Found ${events.length} events that should be declined`);
for (let i = 0; i < events.length; i++) {
const event = events[i];
console.log(`Will decline "${event.title}" created at ${event.createdTime} and updated at ${event.updated}`);
event.myStatus = CalendarApp.GuestStatus.NO; // Correct way to set status
}
}
function getUnsolicitedEvents() {
const DAYS_MAX_LOOK_AHEAD = new Date(Date.now() + (14 * 24 * 60 * 60 * 1000));
const events = CalendarApp.getEvents(new Date(), DAYS_MAX_LOOK_AHEAD, { max: 200 });
if (events.length === 0) {
console.log("Found no events");
return [];
}
return events.filter(event =>
isLargeEvent(event) && hasNotResponded(event) && isNotNewInvite(event)
);
}
function isLargeEvent(event) {
return !event.guestsCanSeeGuests;
}
function hasNotResponded(event) {
return event.myStatus === CalendarApp.GuestStatus.INVITED;
}
function isNotNewInvite(event) {
const DAYS_GRACE_PERIOD = new Date(Date.now() - (8 * 60 * 60 * 1000));
return event.createdTime < DAYS_GRACE_PERIOD;
}
/**
* Return an RFC3339 formated date String corresponding to the given
* Date object.
* @param {Date} date a Date.
* @return {string} a formatted date string.
*/
function formatDate(date) {
return Utilities.formatDate(date, 'UTC', 'yyyy-MM-dd\'T\'HH:mm:ssZ');
}