Destiny 2 Clan Website

// get list of members and populate roster table
$.ajax({
  url: "https://www.bungie.net/platform/GroupV2/" + groupID + "/Members/",
  headers: {
    "X-API-Key": apiKey
  }
}).done(function(json) {
  var members = json.Response.results;
  console.log('Member list:', members);
  listMembers(members);
});

function listMembers(rsp) {
  var
  list = $('.memberList-list'),
  sortMembers = function(method) {
    // sort by date joined
    if (method = joined) {
      list.find('.member').sort(function(a, b) {
        return ($(b).data('joined')) < ($(a).data('joined')) ? 1 : -1;
      }).appendTo(list);
    } else if (method = username) {
      list.find('.member').sort(function(a, b) {
        return ($(b).data('username')) < ($(a).data('username')) ? 1 : -1;
      }).appendTo(list);
    }
    list.find('.member.online').prependTo(list);
  };

  for (var i = 0; i < rsp.length; i++) {
    var
    profile = rsp[i].bungieNetUserInfo,
    member = $('<a></a>');
    // check for valid profile
    // some users don't have Bungie profiles somehow and it breaks function
    if (typeof profile != 'undefined') {
      // store response data in semantic variables
      var
      name = rsp[i].destinyUserInfo.displayName,
      joinDate = rsp[i].joinDate,
      joined = joinDate.substring(0, joinDate.indexOf('T')),
      online = rsp[i].isOnline,
      icon = profile.iconPath,
      memberId = profile.membershipId,
      memberType = rsp[i].destinyUserInfo.membershipType,
      destinyId = rsp[i].destinyUserInfo.membershipId,
      rank = rsp[i].memberType;
      // configure DOM node and add to page
      member
      .attr({
        'class': 'j-row vertical-center-row member',
        'href': '/player/?bungieId=' + memberId + '&destinyId=' + destinyId + '&joined=' + joined + '&rank=' + rank,
        'title': 'See player profile for ' + name,
        'data-joined' : joined.replace(/-/g, ''),
        'data-username': name,
        'data-online' : 'false',
        'data-searchable' : name,
      })
      .html(
        '<div class="j-col j-col-1 member-icon"><img src="https://bungie.net/' + icon + '"></div>' +
        '<div class="j-col j-col-3 member-name"><h3>' + name + '</h3></div>' +
        '<div class="j-col j-col-3 member-joined" data-label="Joined">' + joined.replace(/-/g, '/') + '</div>' +
        '<div class="j-col j-col-3 member-status" data-label="Status"><span class="member-online" id="status-' + memberId + '">' + online + '</span></div>' +
        '<div class="j-col j-col-3 member-button"><a class="button outline gold full-width">' + 'View Stats' + '</a></div>'
      )
      .appendTo(list);
      // indicate online/offline status
      if (String(online) === 'true') {
        $('#status-' + memberId)
        .text('Online')
        .addClass('online')
        .closest('.member')
        .attr('data-online', true)
        .addClass('online');
      } else {
        $('#status-' + memberId).text('Offline').removeClass('online');
      }
      sortMembers(joined); // sort members by join date
    }
  }
}

function checkParams(param) {
  var
  pageURL = window.location.search.substring(1),
  urlParams = pageURL.split('&');

  if (urlParams.length > 0) {
    for (var i = 0; i < urlParams.length; i++) {
      var pair = urlParams[i].split('=');
      if (pair[0] == param) {
        return pair[1];
      }
    }
  }
}

var
// ...
bungieId = checkParams('bungieId'),
destinyId = checkParams('destinyId'),
joined = checkParams('joined'),
rank = checkParams('rank');

if (bungieId && destinyId && joined && rank) {
    $.ajax({
      url: "https://www.bungie.net/Platform/Destiny2/4/Account/" + destinyId + "/Character/0/Stats/",
      headers: {
        "X-API-Key": apiKey
      },
      success: function(data) {
        var
        stats = data.Response.allPvP.allTime,
        efficiency = stats.efficiency.basic.displayValue,
        kd = stats.killsDeathsRatio.basic.displayValue,
        kda = stats.killsDeathsAssists.basic.displayValue,
        kills = stats.kills.basic.displayValue,
        deaths = stats.deaths.basic.displayValue,
        assists = stats.assists.basic.displayValue,
        precisionKills = stats.precisionKills.basic.displayValue,
        combatRating = stats.combatRating.basic.displayValue,
        mostKills = stats.bestSingleGameKills.basic.displayValue,
        killSpree = stats.longestKillSpree.basic.displayValue,
        mostPrecision = stats.mostPrecisionKills.basic.displayValue,
        weapon = stats.weaponBestType.basic.displayValue,
        clock = stats.allParticipantsTimePlayed.basic.displayValue,
        hours = clock.match(/\d+/g);

        totalHours = (Number(hours[0]) * 24) + Number(hours[1]);

        console.log('Player stats:', data);

        // Populate stats
        $('#player-clock').text(totalHours + 'h');
        $('#player-efficiency').text(efficiency);
        $('#player-kd').text(kd);
        $('#player-kda').text(kda);
        $('#player-kills').text(kills);
        $('#player-assists').text(assists);
        $('#player-precision-kills').text(precisionKills);
        $('#player-weapon').text(weapon);
        $('#player-kill-spree').text(killSpree);
        $('#player-most-kills').text(mostKills);
        $('#player-most-precision').text(mostPrecision);
      },
      error: function(data) {
        console.log('Error loading player stats:', data);
      }
    });

    $.ajax({ // get Bungie Profile
      url: "https://www.bungie.net/Platform/User/GetBungieNetUserById/" + bungieId + "/",
      headers: {
        "X-API-Key": apiKey
      },
      success: function(data) {
        console.log('Player profile:', data);
        var
        response = data.Response,
        about = response.about,
        banner = response.profileThemeName,
        blizzard = response.blizzardDisplayName,
        icon = response.profilePicturePath,
        name = blizzard.substring(0, blizzard.indexOf('#'));

        // Populate profile
        $('.hero#player-hero').css({
          'background-image': 'url("https://bungie.net/img/UserThemes/' + banner + '/header.jpg")'
        })
        $('#player-title').text(name);
        $('.player-icon').attr({
          'src': 'https://www.bungie.net' + icon
        });
        $('#player-join-date').text(joined.replace(/-/g, '/'));
        switch(rank) {

          case '3': $('#player-rank').text('Iron Officer')
          break;

          case '5': $('#player-rank').text('Iron General');
          break;

          default: $('#player-rank').text('Iron Brigaider');
        }
      },
      error: function(data) {
        console.log('Error loading player profile:', data);
      }
    });
  }

$('input.search').on('input', function() {
  var
  filter = $(this).val().toLowerCase(),
  container = $(this).data('container'),
  scope = $(this).data('scope');

  $('.' + scope).each(function() { // loop through current scope
    var
    $this = $(this),
    name = $this.data('searchable').toLowerCase();
    // loop through query words
    for (var i = 0; i < scope.length; i++) {
      // hide as soon as name != filter
      if (name.indexOf(filter) > -1) {
        $this.show()
      } else {
        $this.hide();
      }
    }
  }); // end scope loop

});

$('.signupSheet').each(function() {
  var
  day = $(this).attr('id'),
  sheet = $(this).data('sheet'),
  $this = $(this),
  url = 'https://spreadsheets.google.com/feeds/list/' + sheet + '/od6/public/basic?alt=json';

  $.ajax({
    url: url,
    success: function(response) {
      var
      data = response.feed.entry,
      parsedData = [];
      // parse Google sheets data into more manageable format
      $.each(data, function(i) {
        parsedData.push({
          name: data[i].title.$t,
          available: data[i].content.$t.replace('timeframe: ', ''),
        });
      });
      // if anyone is signed up
      if (parsedData.length > 0) {
        // hide the "no one signed up" thing
        $this.find('.signupSheet-empty').hide();
        // populate data for signup
        $.each(parsedData, function(i) {
          console.log('Player signed up for ' + day + ':', parsedData[i]);
          $this.find('.signupSheet-content').append(
            '<div class="j-row signupSheet-entry">' +
            '<div class="j-col j-col-6" data-th="Player"><span class="signupSheet-player">' + parsedData[i].name + '</span></div>' +
            '<div class="j-col j-col-6" data-th="Available"><span class="signupSheet-availability">' + parsedData[i].available + '</span></div>' +
            '</div>'
          );
        });
      }
    }
  });
});

var
// ...
days = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'],
today = new Date().getDay(),
sortedDays = days.slice(today).concat(days.slice(0, today)),
// ...

$('.signupSheet').sort(function(a, b) {
  return sortedDays.indexOf($(a).attr('id')) > sortedDays.indexOf($(b).attr('id'));
}).appendTo('#raid-signup');

var checkName = function(name) {

  var m = false; // flag
  console.log('Checking to see if ' + name + ' is a Reign of Iron Member...');
  // loop through clan usernames and check for a match
  $.each(userNames, function(i) {
    // make case insensitve
    if (name.toLowerCase() === userNames[i].toLowerCase()) {
      console.log('Confirmed, ' + userNames[i] + ' is in Reign of Iron');
      m = true;
    }
  });

  if (m) {
    return true;
  } else {
    return false;
  }

};

// Store member list immediately so we only make one AJAX request to Bungie API
$.ajax({
  url: "https://www.bungie.net/platform/GroupV2/" + groupID + "/Members/",
  headers: {
    "X-API-Key": apiKey
  }
}).done(function(json) {
  var members = json.Response.results;
  $.each(members, function(i) {
    userNames.push(members[i].destinyUserInfo.displayName);
  });
});

$('form.signupForm').submit(function(e) {
  // stop form from reloading the page
  e.preventDefault();
  // Show loading screen
  $('#loading').fadeIn();

  var
  available = [],
  name = $(this).find('input[name="player_name"]').val(),
  postTo = $(this).data('postto'),
  timeFrame = $(this).find('input[name="time_frame"]'),
  $form = $(this);

  if (checkName(name)) { // if entered name exists in current roster
    // find the raid time(s) the user has selected and push their values to an array
    $form.find('input[type="checkbox"]').each(function() {
      if ($(this).is(':checked')) {
        available.push($(this).val());
      }
    });
    // turn the array into a string to and put it in the input that goes to Google
    available = available.join(', ');
    timeFrame.val(available);
    // Turn form into object and send to Google
    $.ajax({
      url: 'https://script.google.com/macros/s/' + postTo + '/exec',
      method: "GET",
      dataType: "json",
      // .serializeObject() requires some prerequisite code, FYI
      data: $form.serializeObject(),
      success: function(response) {
        console.log(response);
        // get rid of loading animation
        $('#loading').fadeOut();
        // alert user of successful registration
        alert(
          'Nice, you\'ve been added to the list for '
          + $form.closest('.signupSheet').attr('id') +
          ', ' + name + '!'
        );
        // add to signup sheet immediately
        $form.closest('.signupSheet')
          // first get rid of "no one signed up" message if user is first to register
          .find('.signupSheet-empty')
          .hide()
          .end()
          // create new row in table and append entered data
          .find('.signupSheet-content')
          .append(
            '<div class="j-row signupSheet-entry">' +
            '<div class="j-col j-col-6" data-th="Player"><span class="signupSheet-player">' + name + '</span></div>' +
            '<div class="j-col j-col-6" data-th="Available"><span class="signupSheet-availability">' + timeFrame.val() + '</span></div>'
          );
      },
      error: function(response) {
        console.log(response);
        alert('Sorry, looks like there was an error signing you up. Please try again, and if the issue persists, get a hold of kuro.');
        // get rid of loading animation
        $('#loading').fadeOut();
      }
    });

	} else { // if user entered an invalid name

    console.log('Error: no record of ' + name + ' in Reign of Iron roster.');
    alert('Sorry, no record of ' + name + ' in the Reign of Iron roster. Please make sure you\'re using your Battletag and that you\'ve spelled it correctly.');
    // get rid of loading animation
    $('#loading').fadeOut();
  }

});

function doGet(e){
  return handleResponse(e);
}
var SHEET_ID = ""; // whatever the sheet ID was for this signup sheet
var SHEET_NAME = "Sheet1";

var SCRIPT_PROP = PropertiesService.getScriptProperties();

function handleResponse(e) {
  var lock = LockService.getPublicLock();
  lock.waitLock(30000);

  try {
    var doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty("key"));
    var sheet = doc.getSheetByName(SHEET_NAME);
    var headRow = e.parameter.header_row || 1;
    var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
    var nextRow = sheet.getLastRow()+1; // get next row
    var row = [];
    // loop through the header columns
    for (i in headers){
      if (headers[i] == "Timestamp"){ // special case if you include a 'Timestamp' column
        row.push(new Date());
      } else { // else use header name to get data
        row.push(e.parameter[headers[i]]);
      }
    }
    sheet.getRange(nextRow, 1, 1, row.length).setValues([row]);
    // return json success results
    return ContentService
          .createTextOutput(JSON.stringify({"result":"success", "row": nextRow}))
          .setMimeType(ContentService.MimeType.JSON);
  } catch(e) {
    return ContentService
          .createTextOutput(JSON.stringify({"result":"error", "error": e}))
          .setMimeType(ContentService.MimeType.JSON);
  } finally {
    lock.releaseLock();
  }
}

function setUp() {
    var doc = SpreadsheetApp.getActiveSpreadsheet();
    SCRIPT_PROP.setProperty("key", doc.getId());
}

function clearRaid() {  
  var sheetActive = SpreadsheetApp.openById(SHEET_ID).getSheetByName(SHEET_NAME);
  sheetActive.getRange('A2:B').clearContent();
}