1

GET https://{subdomain}.cybozu.com/g/api/v1/schedule/events?rangeStart=YYYY-MM-DDThh:mm:ss+09:00&rangeEnd=YYYY-MM-DDThh:mm:ss+09:00&orderBy=start asc

 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

/*
 * A sample program of Garoon REST API using from kintone app
 * Copyright (c) 2018 Cybozu
 *
 * Licensed under the MIT License
*/
(function() {
  'use strict';
  const myJQuery = jQuery.noConflict(true);
  (function($) {
    const eventsArray = [
      'app.record.create.show',
      'app.record.edit.show'
    ];
    const myEnv = 'https://{subdomain}.cybozu.com'; // 環境に合わせて書き換えてください
    // 日時整形用関数
    function timeCalc(start, end) {
      const myStartTime = start.slice(11, 13);
      const myEndTime = end.slice(11, 13);
      return parseInt(myEndTime, 10) - parseInt(myStartTime, 10);
    }
    // 時刻用整形関数
    function trimTime(start, end) {
      const myStart = start.slice(11, 16);
      const myEnd = end.slice(11, 16);
      return myStart + ' - ' + myEnd;
    }
    // GaroonへのGETリクエスト
    function getGaroonEvents(recData) {
      const searchDate = recData.record.kin_date.value;
      const myStart = searchDate + encodeURIComponent('T00:00:00+09:00');
      const myEnd = searchDate + encodeURIComponent('T23:59:00+09:00');
      const requestParams = {
        type: 'GET',
        url: '/g/api/v1/schedule/events?rangeStart=' + myStart + '&rangeEnd=' + myEnd + '&orderBy=start asc'
      };
      // Garoonにリクエストを送る
      $.ajax(requestParams).done((resp) => {
        const myEvents = resp.events;
        recData.record.my_table.value = [];
        if (resp.events.length === 0) {
          alert('指定した日付の予定がありません');
        }
        // set kintone table
        for (let i = 0; i < resp.events.length; i++) {
          const newRow = {
            value: {
              event_time: {
                type: 'NUMBER',
                value: timeCalc(myEvents[i].start.dateTime, myEvents[i].end.dateTime)
              },
              event_type: {
                type: 'DROP_DOWN',
                value: myEvents[i].eventMenu
              },
              event_time_range: {
                type: 'SINGLE_LINE_TEXT',
                value: trimTime(myEvents[i].start.dateTime, myEvents[i].end.dateTime)
              },
              event_title: {
                type: 'SINGLE_LINE_TEXT',
                value: myEvents[i].subject
              }
            }
          };
          recData.record.my_table.value.push(newRow);
        }
        recData.record.day_link.value = myEnv + '/g/schedule/personal_day.csp?event=' + searchDate;
        kintone.app.record.set(recData);
      });
    }
    kintone.events.on(eventsArray, (event) => {
      const record = event.record;
      const mySpace = kintone.app.record.getSpaceElement('my_btn');
      const $myButton = $('<input>', {
        type: 'button',
        value: 'Garoonの予定を取得',
        class: 'square_btn'
      }).click(() => {
        const recordData = kintone.app.record.get();
        getGaroonEvents(recordData);
      });
      $myButton.appendTo(mySpace);
      record.day_link.disabled = true;
      record.overtime_sum.disabled = true;
      record.mtg_sum.disabled = true;
      return event;
    });
  })(myJQuery);
})();