function myFunction() {
  sendEmail()
}
 
function sendEmail() {
  var stockData = getData("table", "Stocks", true);
  var stockData2 = getData("2022", "send_day", false);
  // console.warn(stockData2)
  var stockColor = getColor();
  var body = getEmailText(stockData2,stockColor);
  // console.warn(body)
  var htmlBody = getEmailHtml(stockData,stockColor);
  // console.warn(htmlBody)
  let today = new Date();   

  var week = new Array("일", "월", "화", "수", "목", "금", "토")
  let year = today.getFullYear(); // 년도
  let month = today.getMonth() + 1;  // 월
  let date = today.getDate();  // 날짜
  let day = today.getDay();  // 요일

  let key = false
  var que = null
  stockData2.forEach(function(value) {
    let a = value["공휴일"]
    let y = value["날짜"].getFullYear(); // 년도
    let m = value["날짜"].getMonth() + 1;  // 월
    let da = value["날짜"].getDate();  // 날짜
    let d = value["날짜"].getDay();  // 요일

    que = y+"-"+m+"-"+da+"-"+week[d]
    var now = year+"-"+month+"-"+date+"-"+week[day]
    // console.log(que, now)
    if(que == now){
      if(a == 1){
        key = true
      }
      else{
        key = false
      }
    }
    else{
      key = false
    }
  })

  var subject_val = "자동 메일 전송 " + year + '년 ' + month + '월 ' + date + "일 (" + week[day] + ")"
  
  var address = "To@email.com"
  if(week[day] != "토" && week[day] != "일" && key == false){
    MailApp.sendEmail({
      to: address,
      subject: subject_val,
      htmlBody : htmlBody
    });
    console.log("Send mail : ", que, week[day], key)
  }
  else{
    console.log("Not send mail : ", que, week[day], key)
  }
}
 
function getEmailText(stockData) {
  var text = "";
  stockData.forEach(function(stock) {
    text = text + stock.날짜 + "\n" + stock.요일 + "\n" + stock.공휴일 + "\n" + "\n-----------------------\n\n";
  });
  return text;
}
 
/**
 * @OnlyCurrentDoc
 */
function getData(t, s, f) {
  var values = SpreadsheetApp.getActive().getSheetByName(t).getRange(s).getValues();
  values.shift(); //remove headers
  var stocks = [];
  if(f==true){
    values.forEach(function(value) {
      var stock = {};
      stock.TitleA = value[0];
      stock.TitleB = value[1];
      stock.TitleC = value[2];
      stock.TitleD = value[3];
      stocks.push(stock);
    })
  }
  else{
    values.forEach(function(value) {
      var stock = {};
      stock.날짜 = value[0];
      stock.요일 = value[1];
      stock.공휴일 = value[2];
      stocks.push(stock);
    })
  }
  return stocks;
}
 
function getColor() {
  var values = SpreadsheetApp.getActive().getSheetByName("table").getRange("Stocks").getBackgrounds();
  values.shift(); //remove headers
  var colors = [];
  values.forEach(function(value) {
    var color = {};
	color.TitleA = value[0];
	color.TitleB = value[1];
	color.TitleC = value[2];
	color.TitleD = value[3];
    colors.push(color);
  })
  return colors;
}
 
 
 
function getEmailHtml(stockData,stockColor) {
  var htmlTemplate = HtmlService.createTemplateFromFile("Template.html");
  htmlTemplate.stocks = stockData; 
  htmlTemplate.colors = stockColor; 
  var htmlBody = htmlTemplate.evaluate().getContent();
  return htmlBody;
}