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

/*
 * Sample program for Form Bridge - generateUrl.js
 * Copyright (c) 2019 Cybozu
 *
 * Licensed under the MIT License
 * https://opensource.org/license/mit/
 */
const generateUrl = (baseUrl, params = {}) => {
  const queryParams = [];
  if (params !== [] && params !== {}) {
    const add = (key, value) => {
      // if value is a function then call it and assign it's return value as value
      value = (typeof value === 'function') ? value() : value;

      // change null to empty string
      value = (value === null) ? '' : value;

      queryParams.push(encodeURIComponent(key) + '=' + encodeURIComponent(value));
    };
    const buildQueryParams = (prefix, params, add) => {
      const rbracket = new RegExp(/\[\]$/);
      if (params instanceof Array) {
        params.forEach((val, i) => {
          if (rbracket.test(prefix)) {
            add(prefix, val);
          } else {
            buildQueryParams(prefix + '[' + (typeof val === 'object' ? i : '') + ']', val, add);
          }
        });
      } else if (typeof params === 'object') {
        for (const name in params) {
          buildQueryParams(prefix + '[' + name + ']', params[name], add);
        }
      } else {
        add(prefix, params);
      }
    };

    for (const prefix in params) {
      buildQueryParams(prefix, params[prefix], add);
    }
    return baseUrl + '?' + queryParams.join('&').replace(/%20/g, '+');
  }
  return baseUrl;

};

 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

/*
 * Sample program for Form Bridge - sample.js
 * Copyright (c) 2019 Cybozu
 *
 * Licensed under the MIT License
 * https://opensource.org/license/mit/
 */

/* globals generateUrl */
(() => {
  'use strict';
  fb.events.fields.イベント名.changed = [state => {
    if (!state.record.イベントID.value) return;
    const masterApp = 'https://viewer.kintoneapp.com/public/api/records/*****/1'; // イベントマスタアプリAPIのURL
    const applicantListApp = 'https://viewer.kintoneapp.com/public/api/records/*****/1'; // イベント参加者リストアプリAPIのURL
    Promise.all([
      fetch(
        generateUrl(
          masterApp,
          {
            additionalFilters: [
              {with: 'and', field: 'レコード番号', sign: '=', value: state.record.イベントID.value}
            ]
          }
        )
      ).then(response => response.json()),
      fetch(
        generateUrl(
          applicantListApp,
          {
            additionalFilters: [
              {with: 'and', field: 'イベントID', sign: '=', value: state.record.イベントID.value}
            ]
          }
        )
      ).then(response => response.json())
    ]).then(responses => {
      if (responses[0].records[0].定員.value > responses[1].totalCount) {
        alert('予約可能です。');
      } else {
        state.record.イベントID.value = '';
        state.record.イベント名.value = '';
        alert('定員オーバーです。');
      }
      return state;
    });
  }];
})();