// Draws one ticket to pick one winner
function drawOneWinner() {
  drawTicket('F8', 'F9');
}

// Draws tickets until three winners have been chosen
function drawThreeWinners() {
  let winnerNames = [];
  winnerNames.push(drawUntilNewWinner(winnerNames, 'F8', 'F9'));
  winnerNames.push(drawUntilNewWinner(winnerNames, 'G8', 'G9'));
  drawUntilNewWinner(winnerNames, 'H8', 'H9');
}

// Draws tickets until 2 winners have been chosen. Then draw a 3rd winner name ignoring ticket count.
function drawWinners() {
  let winnerNames = [];
  winnerNames.push(drawUntilNewWinner(winnerNames, 'F8', 'F9'));
  winnerNames.push(drawUntilNewWinner(winnerNames, 'G8', 'G9'));
  drawRandomName(winnerNames, 'H9');
}

function drawUntilNewWinner(winnerNames, winnerTicketCell, winnerNameCell) {
  let winnerName = '';
  while (!winnerName || isInArray(winnerNames, winnerName)) {
    winnerName = drawTicket(winnerTicketCell, winnerNameCell);
  }
  return winnerName;
}

function drawTicket(winnerTicketCell, winnerNameCell) {
  let sheet = SpreadsheetApp.getActiveSheet();
  let data = sheet.getDataRange().getValues();
  let tickets = 0;
  
  for (let i = 1; i < data.length; i++) {
    tickets += data[i][2];
  }
  
  let drawnTicket = Math.floor(Math.random() * tickets);
  
  tickets = 0;
  for (let i = 1; i < data.length; i++) {
    tickets += data[i][2];
    if (tickets > drawnTicket) {
      let winnerName = data[i][0];
      sheet.getRange(winnerNameCell).setValue(winnerName);
      sheet.getRange(winnerTicketCell).setValue(drawnTicket + 1);
      return winnerName;
    }
  }
}

function drawRandomName(ignoredNames, winnerNameCell) {
  let sheet = SpreadsheetApp.getActiveSheet();
  let data = sheet.getDataRange().getValues();
  let names = [];
  
  for (let i = 1; i < data.length; i++) {
    let name = data[i][0];
    if (name && !isInArray(names, name) && !isInArray(ignoredNames, name)) {
      names.push(name);
    }
  }
  if (!names.length) {
    return '';
  }
  let winnerName = names[Math.floor(Math.random() * names.length)]
  sheet.getRange(winnerNameCell).setValue(winnerName);
  return winnerName;
}

function isInArray(array, object) {
  return array.indexOf(object) + 1
}