BacklogIssues/TriggerUtil.gs at master · nilesflow/BacklogIssues · GitHub

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
/**
 * Triggerユーティリティー
 */
function TriggerUtil(param) {
};

/**
 * 時間指定
 * @see https://developers.google.com/apps-script/reference/script/clock-trigger-builder#nearminuteminute
 */
TriggerUtil.prototype.setEveryTime = function(name, hour, minute) {
  // 入力チェック
  if (hour != Number(hour) || minute != Number(minute)) {
    return false;
  }
  hour = Number(hour);
  minute = Number(minute);

  // トリガーを設定
  ScriptApp.newTrigger(name)
  .timeBased()
  .atHour(hour)
  .nearMinute(minute)
  .everyDays(1)
  .create();

  Logger.log(hour);
  Logger.log(minute);

  return true;
};

/**
 * 曜日指定
 * @see https://developers.google.com/apps-script/reference/script/clock-trigger-builder#onweekdayday
 */
TriggerUtil.prototype.setEveryWeek = function(name, weekday, hour, minute) {
  // 入力チェック
  if (hour != Number(hour) || minute != Number(minute) || weekday in ScriptApp.WeekDay) {
    return false;
  }
  hour = Number(hour);
  minute = Number(minute);

  // トリガーを設定
  ScriptApp.newTrigger(name)
  .timeBased()
  .atHour(hour)
  .nearMinute(minute)
  .onWeekDay(weekday)
  .create();

  Logger.log(name);
  Logger.log(weekday);
  Logger.log(hour);
  Logger.log(minute);

  return true;
};

/**
 * 指定ms後
 * @see https://developers.google.com/apps-script/reference/script/clock-trigger-builder#afterdurationmilliseconds
 */
TriggerUtil.prototype.setAfter = function(name, ms) {
  ScriptApp.newTrigger(name)
  .timeBased()
  .after(ms)
  .create();

  Logger.log(name);
  Logger.log(ms);
};

/**
 * イベントトリガー：onEdit
 * @see https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder#onedit
 */
TriggerUtil.prototype.setOnEdit = function(name) {
  var sheet = SpreadsheetApp.getActive();
  ScriptApp.newTrigger(name)
  .forSpreadsheet(sheet)
  .onEdit()
  .create();
};

/**
 * トリガーの検索
 */
TriggerUtil.prototype.isSet = function(name) {
  var triggers = ScriptApp.getProjectTriggers();
  for (var i in triggers) {
    if (triggers[i].getHandlerFunction() == name) {
      return true;
    }
  }

  return false;
};

/**
 * トリガーの削除
 * @see https://developers.google.com/apps-script/reference/script/script-app#deletetriggertrigger
 */
TriggerUtil.prototype.deleteAll = function(name) {
  var triggers = ScriptApp.getProjectTriggers();
  for (var i in triggers) {
    if (triggers[i].getHandlerFunction() == name) {
      ScriptApp.deleteTrigger(triggers[i]);
    }
  }
};