ねっぱんの当日チェックイン・チェックアウトを毎朝自動通知する方法

function sendTodayRoomStatus() {
  // ▼▼▼ 設定 ▼▼▼
  const calendarId = 'カレンダーID';
  const notificationEmail = 'あなたのメールアドレス';

  // OTAごとの部屋タイプ名を、共通の部屋名にまとめる
  // 
  const roomRules = [
    {
      name: 'シングル',
      keywords: [
        'Single Room with Shared Shower and Toilet',
        'シングルルーム',
        ``,
        ``,
        ``
      ]
    },
    {
      name: 'ツイン',
      keywords: [
        'Twin Room',
        'ツインルーム',
        'ツイン',
        ``,
        ``,
        ``

      ]
    },
    {
      name: 'メールに表示する名前',
      keywords: [
        'カレンダーに入ってる部屋タイプ名①',
        'カレンダーに入ってる部屋タイプ名②',
        ``,
        ``,
        ``
        
      ]
    }
  ];
  // ▲▲▲ 設定ここまで ▲▲▲

  const calendar = CalendarApp.getCalendarById(calendarId);

  if (!calendar) {
    throw new Error(`カレンダーが見つかりません: ${calendarId}`);
  }

  const timeZone = Session.getScriptTimeZone();
  const today = new Date();

  today.setHours(0, 0, 0, 0);

  // 今日チェックアウトする予定を拾うため、前日から翌日まで取得
  const searchStart = new Date(today);
  searchStart.setDate(searchStart.getDate() - 1);

  const searchEnd = new Date(today);
  searchEnd.setDate(searchEnd.getDate() + 2);
  

  const events = calendar.getEvents(searchStart, searchEnd);

  const checkins = [];
  const checkouts = [];

  for (const event of events) {
    //if (!event.isAllDayEvent()) {
    //  continue;
    //}

    const startDate = event.getStartTime();
    const endDate = event.getEndTime();

    const title = event.getTitle();
    const description = event.getDescription();

    const roomType = getDescriptionValue(description, '部屋タイプ');
    const ota = getDescriptionValue(description, '予約サイト');
    const paymentMethod = getDescriptionValue(description, '決済方法');
    const guestName =
      getDescriptionValue(description, '宿泊者氏名') ||
      getGuestNameFromTitle(title);

    const normalizedRoomName = normalizeRoomName(roomType, roomRules);

    const reservation = {
      roomName: normalizedRoomName,
      rawRoomType: roomType,
      guestName,
      ota,
      paymentMethod
    };

    if (isSameDate(startDate, today, timeZone)) {
      checkins.push(reservation);
    }

    if (isSameDate(endDate, today, timeZone)) {
      checkouts.push(reservation);
    }
  }

  const result = classifyRooms(checkins, checkouts);

  const subject = `【客室状況】${formatDate(today, timeZone)}`;

  const body = createNotificationBody(
    today,
    result,
    checkins,
    checkouts,
    timeZone
  );

  //GmailApp.sendEmail(notificationEmail, subject, body);

  Logger.log(body);
}


/**
 * 説明欄から「部屋タイプ：○○」などの値を取得
 */
function getDescriptionValue(description, label) {
  if (!description) {
    return '';
  }

  const pattern = new RegExp(`${escapeRegExp(label)}\\s*：\\s*(.*)`);
  const match = description.match(pattern);

  return match ? match[1].trim() : '';
}


/**
 * OTAごとの部屋名を共通名へ変換
 */
function normalizeRoomName(rawRoomType, roomRules) {
  if (!rawRoomType) {
    return '部屋タイプ不明';
  }

  const lowerRoomType = rawRoomType.toLowerCase();

  for (const rule of roomRules) {
    const matched = rule.keywords.some(keyword =>
      lowerRoomType.includes(keyword.toLowerCase())
    );

    if (matched) {
      return rule.name;
    }
  }

  // 対応表にない部屋名は、そのまま表示
  return rawRoomType;
}


/**
 * OUTとINを部屋名で照合
 */
function classifyRooms(checkins, checkouts) {
  const checkinsByRoom = groupByRoom(checkins);
  const checkoutsByRoom = groupByRoom(checkouts);

  const roomNames = new Set([
    ...Object.keys(checkinsByRoom),
    ...Object.keys(checkoutsByRoom)
  ]);

  const turnovers = [];
  const checkoutOnly = [];
  const checkinOnly = [];

  for (const roomName of roomNames) {
    const incoming = checkinsByRoom[roomName] || [];
    const outgoing = checkoutsByRoom[roomName] || [];

    if (incoming.length > 0 && outgoing.length > 0) {
      turnovers.push({
        roomName,
        incoming,
        outgoing
      });
    } else if (outgoing.length > 0) {
      checkoutOnly.push({
        roomName,
        reservations: outgoing
      });
    } else if (incoming.length > 0) {
      checkinOnly.push({
        roomName,
        reservations: incoming
      });
    }
  }

  return {
    turnovers,
    checkoutOnly,
    checkinOnly
  };
}


function groupByRoom(reservations) {
  return reservations.reduce((groups, reservation) => {
    const roomName = reservation.roomName;

    if (!groups[roomName]) {
      groups[roomName] = [];
    }

    groups[roomName].push(reservation);

    return groups;
  }, {});
}


/**
 * 通知本文を作成
 */
function createNotificationBody(
  today,
  result,
  checkins,
  checkouts,
  timeZone
) {
  const lines = [];

  lines.push(`${formatDate(today, timeZone)}の客室状況`);
  lines.push('');

  lines.push('【優先清掃・当日入れ替え】');

  if (result.turnovers.length === 0) {
    lines.push('なし');
  } else {
    for (const room of result.turnovers) {
      lines.push(`■ ${room.roomName}`);

      for (const reservation of room.outgoing) {
        lines.push(`  OUT：${reservation.guestName || '氏名不明'}様`);
      }

      for (const reservation of room.incoming) {
        lines.push(
          `  IN ：${reservation.guestName || '氏名不明'}様` +
          formatSupplement(reservation)
        );
      }
    }
  }

  lines.push('');
  lines.push('【チェックアウトのみ】');

  if (result.checkoutOnly.length === 0) {
    lines.push('なし');
  } else {
    for (const room of result.checkoutOnly) {
      for (const reservation of room.reservations) {
        lines.push(
          `・${room.roomName}：${reservation.guestName || '氏名不明'}様`
        );
      }
    }
  }

  lines.push('');
  lines.push('【チェックインのみ】');

  if (result.checkinOnly.length === 0) {
    lines.push('なし');
  } else {
    for (const room of result.checkinOnly) {
      for (const reservation of room.reservations) {
        lines.push(
          `・${room.roomName}：${reservation.guestName || '氏名不明'}様` +
          formatSupplement(reservation)
        );
      }
    }
  }

  lines.push('');
  lines.push('-----');
  lines.push(`チェックアウト：${checkouts.length}件`);
  lines.push(`チェックイン：${checkins.length}件`);
  lines.push('');
  lines.push(`その他直接予約や別カレンダーの予約も確認してください。`)

  return lines.join('\n');
}


function formatSupplement(reservation) {
  const details = [];

  if (reservation.ota) {
    details.push(reservation.ota);
  }

  if (reservation.paymentMethod) {
    details.push(reservation.paymentMethod);
  }

  return details.length > 0 ? `（${details.join('／')}）` : '';
}


function getGuestNameFromTitle(title) {
  if (!title) {
    return '';
  }

  return title
    .replace(/^【.*?】/, '')
    .replace(/様$/, '')
    .trim();
}


function isSameDate(date1, date2, timeZone) {
  return (
    Utilities.formatDate(date1, timeZone, 'yyyy-MM-dd') ===
    Utilities.formatDate(date2, timeZone, 'yyyy-MM-dd')
  );
}


function formatDate(date, timeZone) {
  return Utilities.formatDate(date, timeZone, 'yyyy年M月d日');
}


function escapeRegExp(text) {
  return text.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
}