const scheduleTypeSchedule = "予定";
const scheduleTypeResult = "実績";
const shareStatusFinish = "済";
const shareStatusUnfinish = "未";

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [];
  menuEntries.push({name: "共有する", functionName: "shareCalendar"});
  ss.addMenu("カレンダー共有", menuEntries);

  menuEntries = [];
  menuEntries.push({name: scheduleTypeSchedule, functionName: "genMsgSchedule"});
  menuEntries.push(null);
  menuEntries.push({name: scheduleTypeResult, functionName: "genMsgResult"});
  ss.addMenu("メッセージ作成", menuEntries);
}

function getSSPosition( arg ) {
  var row = 4;
  var column = 9;
  var cellItem = 0;
  var cellSubItem = 1;
  var cellDate = 2;
  var cellScheduleType = 7;

  if (arg == "message") {
    var cellTotalTime = 6;
    var cellOutputMsg = "M1";
    return {row, column, cellDate, cellItem, cellSubItem, cellScheduleType, cellTotalTime, cellOutputMsg};
  } else {
    var cellStartTime = 3;
    var cellEndTime = 4;
    var cellShareStatus = 8;
    var cellGmailAddr = "B1";
    return {row, column, cellDate, cellItem, cellSubItem, cellScheduleType, cellShareStatus, cellStartTime, cellEndTime, cellGmailAddr};
  }
}

function getSSData( row, column ) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  var values = sheet.getRange(row, 2, lastRow, column).getValues();
  return {sheet, lastRow, values};
}

function genMsg( arg, values, lastRow, row, cellScheduleType, cellDate, cellItem, cellSubItem, cellTotalTime ) {
  var msg = "";

  for (i = 0; i <= lastRow - row; i++) {
    var scheduleType = values[i][cellScheduleType];
    var date = genDateObj(values[i][cellDate]);
    var now = genDateObj();
    var workContent = values[i][cellItem] + " " + values[i][cellSubItem];
    var workTime = values[i][cellTotalTime];
    if (date.toDateString() == now.toDateString() && scheduleType == arg) {
      if (msg == "") {
        if (arg == scheduleTypeResult) {
          msg = "お疲れさまです。本日の業務です。n";
        } else {
          msg = "おはようございます。本日の予定です。n";
        }
      }
      msg = msg + "・" + workContent + "（" + workTime + ")n";
    }
  }

  return msg;
}

function genDateObj( date = "" ) {
  if (date == "") {
    ret = new Date();
  } else {
    ret = new Date(date);
  }
  return ret;
}

function sendMsg( arg ) {
  var {row, column, cellDate, cellItem, cellSubItem, cellScheduleType, cellTotalTime, cellOutputMsg} = getSSPosition("message");
  var {sheet, lastRow, values} = getSSData(row, column);
  var msg = genMsg(arg, values, lastRow, row, cellScheduleType, cellDate, cellItem, cellSubItem, cellTotalTime);
  sheet.getRange(cellOutputMsg).setValue(msg);
}

function genMsgResult() {
  sendMsg(scheduleTypeResult);
}

function genMsgSchedule() {
  sendMsg(scheduleTypeSchedule);
}

function shareCalendar() {
  var {row, column, cellDate, cellItem, cellSubItem, cellScheduleType, cellShareStatus, cellStartTime, cellEndTime, cellGmailAddr} = getSSPosition("calendar");
  var {sheet, lastRow, values} = getSSData(row, column);
  var gmailAddr = sheet.getRange(cellGmailAddr).getValue();
  var calender = CalendarApp.getCalendarById(gmailAddr);

  for (i = 0; i <= lastRow - row; i++) {
    var shareStatus = values[i][cellShareStatus];
    if (shareStatus == shareStatusFinish) {
      continue;
    }

    var date = genDateObj(values[i][cellDate]);
    var startTime = values[i][cellStartTime];
    var endTime = values[i][cellEndTime];
    var workContent = values[i][cellItem] + " " + values[i][cellSubItem];
    var scheduleType = values[i][cellScheduleType];
    var options = {description: scheduleType};

    if (shareStatus == shareStatusUnfinish && scheduleType == scheduleTypeResult) {
      var events = calender.getEventsForDay(date)
      for(let i = 0 ; i < events.length ; i++ ){
        if (events[i].getDescription() == scheduleTypeSchedule) {
          events[i].deleteEvent();
        }
      }
    }

    var startWorkTime = genDateObj(date);
    var endWorkTime = genDateObj(date);
    startWorkTime.setHours(startTime.getHours());
    startWorkTime.setMinutes(startTime.getMinutes());
    endWorkTime.setHours(endTime.getHours());
    endWorkTime.setMinutes(endTime.getMinutes());
    calender.createEvent(workContent, startWorkTime, endWorkTime, options);

    sheet.getRange(row + i, column + 1).setValue(shareStatusFinish);
  }
}