var SETTINGS = new Object();

function main() {
  
  var spreadsheetUrl = "https://docs.google.com/spreadsheets/d/11IcRzJDdsdGJVzLNw0IlczhXYl_l0HTk5lXkfGLq1ig/edit#gid=0";
  SETTINGS.useCampaignLevelSettings = 0;
  
  
  var sheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
  var tabs = sheet.getSheets();
  
  getTimeInThisAccount();
  var currentHour = SETTINGS.thisAccountTime.HH;
  var weekday = SETTINGS.thisAccountTime.weekday.toUpperCase();
  
  if(SETTINGS.useCampaignLevelSettings) {
    for(var i=0;i<tabs.length;i++) {
      var tabName = tabs[i].getName();
      if(tabName != "All Campaigns") {
        var dayPartSheet = sheet.getSheetByName(tabName);
        readDayPartsFromSheet(dayPartSheet);
        
        if(tabName.indexOf("'") != -1) {
          var campaignIterator = AdWordsApp.campaigns()
          .withCondition('Name = "' + tabName + '"')
          .get();
          var shoppingCampaignIterator = AdWordsApp.shoppingCampaigns()
          .withCondition('Name = "' + tabName + '"')
          .get();
        //} else if(tabName.indexOf('"') != -1) {
        } else {
          var campaignIterator = AdWordsApp.campaigns()
          .withCondition("Name = '" + tabName + "'")
          .get();
          var shoppingCampaignIterator = AdWordsApp.shoppingCampaigns()
          .withCondition("Name = '" + tabName + "'")
          .get();
        } 
        if (campaignIterator.hasNext()) {
          currentSetting.campaignCounter++;
          var campaign = campaignIterator.next();
          Logger.log('Campaign Name: ' + campaign.getName());
          removeAllAdSchedules(campaign);
          addFutureAdSchedules(campaign, weekday, currentHour);
          
        } else if (shoppingCampaignIterator.hasNext()) {
          currentSetting.campaignCounter++;
          var campaign = shoppingCampaignIterator.next();
          Logger.log('Shopping Campaign Name: ' + campaign.getName());
          removeAllAdSchedules(campaign);
          addFutureAdSchedules(campaign, weekday, currentHour);
        } else {
          Logger.log("Your spreadsheet contains a tab with a name that does not match any of your campaign names: '" + tabName + "'"); 
        }
      } 
  } else {
    var dayPartSheet = sheet.getSheetByName("All Campaigns");
    readDayPartsFromSheet(dayPartSheet);
    var campaignIterator = AdWordsApp.campaigns()
    .withCondition("Status IN [PAUSED, ENABLED]")
    .get();
    while(campaignIterator.hasNext()) {
      var campaign = campaignIterator.next();
      Logger.log('Campaign Name: ' + campaign.getName());
      removeAllAdSchedules(campaign);
      addFutureAdSchedules(campaign, weekday, currentHour);
    }  
  }
  
}

function getTimeInThisAccount() {
  var weekday = new Array(7);
  weekday[0]=  "Sunday";
  weekday[1] = "Monday";
  weekday[2] = "Tuesday";
  weekday[3] = "Wednesday";
  weekday[4] = "Thursday";
  weekday[5] = "Friday";
  weekday[6] = "Saturday";
  
  var timeZone = AdWordsApp.currentAccount().getTimeZone();
  Logger.log("time zone: " + timeZone);
  var date = new Date();
  var dayOfWeek = parseInt(Utilities.formatDate(date, timeZone, "uu")) - 1;
  var hour = 
  
  SETTINGS.thisAccountTime = new Object();
  SETTINGS.thisAccountTime.ddd =parseInt(Utilities.formatDate(date, timeZone, "ddd"));
  SETTINGS.thisAccountTime.weekday = weekday[SETTINGS.thisAccountTime.ddd];
  SETTINGS.thisAccountTime.HH = parseInt(Utilities.formatDate(date, timeZone, "HH"));
  SETTINGS.thisAccountTime.timeZone = timeZone;
}

function readDayPartsFromSheet(dayPartSheet) {
  SETTINGS.dayParts = new Array();
  
  var rows = dayPartSheet.getDataRange();
  var numRows = rows.getNumRows();
  var numCols = rows.getNumColumns();
  var values = rows.getValues();
  
  // Read Data Rows With Settings
  for(var i = 1; i<numRows; i++) {
    var rowIndex = i+1;
    var row = values[i];
    var dow = row[0];
    //Logger.log("dow: " + dow);
    SETTINGS.dayParts[dow] = new Array();
    for(var j = 1; j<=24; j++) {
      var value = row[j];
      var h = j-1;
      //Logger.log(j + ": " + value);
      SETTINGS.dayParts[dow][h] = value;
    }
  }
}


function addFutureAdSchedules(campaign, today, currentHour){
  
  // SET SCHEDULE FOR ALL DAYS
  for(var weekday in SETTINGS.dayParts) {
    if(weekday != today) {
      Logger.log("weekday: " + weekday);
      for(var i = 0; i<5; i++) {
        var startHour = i;
        var nextHour = startHour + 1;
        var bidAdjustment = SETTINGS.dayParts[weekday][startHour];
        Logger.log(startHour + ": " +  bidAdjustment);
        campaign.addAdSchedule(weekday, startHour, 0, nextHour, 0, bidAdjustment);
      }
      // turn on rest of day with no bid modification
      campaign.addAdSchedule(weekday, nextHour, 0, 24, 0, 1);
    }
  }
  
  // SET THE SCHEDULE FOR NEXT 6 HOURS
  var dayDone = 0;
  for(var i = 0; i<5; i++) {
    var hour = currentHour + i;
    var nextHour = hour + 1;
    var bidAdjustment = SETTINGS.dayParts[today][hour];
    Logger.log("add schedule for " + today + " at " + hour + ": " + bidAdjustment);
    campaign.addAdSchedule(today, hour, 0, nextHour, 0, bidAdjustment);
    if(hour == 23) {
      dayDone = 1;
      break;
    }
  }
  if(!dayDone) {
    campaign.addAdSchedule(today, nextHour, 0, 24, 0, bidAdjustment);
  }
}

function removeAllAdSchedules(campaign) {
  var adScheduleIterator = campaign.targeting().adSchedules().get();
  while(adScheduleIterator.hasNext()) {
    var adSchedule = adScheduleIterator.next();
    adSchedule.remove();
  }
}