Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2019
271
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2. *Oct 2019
  3. */
  4.  
  5. /*
  6. * Handles a HTTP GET request, redirects to landingPage.html
  7. */
  8. function doGet(e){
  9.   checkMultipleAccountIssue(initiator);
  10.   if(e!= undefined){
  11.     var page = HtmlService.createHtmlOutputFromFile('landingPage');
  12.     page.setTitle("NUHS Theater Sales Tracker");
  13.     return page;
  14.   }
  15. }
  16.  
  17. /*
  18. * Checks currently logged in user's email address for authorization against
  19. * a pre-existing range in the containing sheet.
  20. * @param user The user's email address.
  21. */
  22.  
  23. function isEditAuthorized_(user){
  24.   if(user == undefined){
  25.     var user = Session.getActiveUser().getEmail();
  26.   }
  27.   var sheet = getSheetById_(435412363);
  28.   var lastRow = sheet.getLastRow();
  29.   var data = sheet.getRange("A1:" + "A" + lastRow).getValues();
  30.   var isAuthorized = false;
  31.   for(var i = 0; i < lastRow; i++){
  32.     if(user == data[i]) {return true;};
  33.   }
  34.   return false;
  35. }
  36.  
  37. function getSheetById_(id) {
  38.   return SpreadsheetApp.openById("1Y9WMEnirPZtmosQOF4fRY7lpkPjPwij9QIk3Hv4mmw8").getSheets().filter(
  39.     function(s) {return s.getSheetId() === id;}
  40.   )[0];
  41. }
  42.  
  43. function newEntry(formData){
  44.   if(isEditAuthorized_(Session.getActiveUser().getEmail())){
  45.     Logger.log("New Entry Attempt by: " + Session.getActiveUser().getEmail());
  46.     var sheet = getSheetById_(0);
  47.     // Write data to sheet.
  48.     var entry = [
  49.       formData.firstName,
  50.       formData.lastName,
  51.       formData.showtime,
  52.       Session.getActiveUser().getEmail()
  53.     ];
  54.     sheet.appendRow(entry);
  55.     // Log access data
  56.     sheet = getSheetById_('1782382348');
  57.     //var d = new Date();
  58.     //Logger.log(d.getTime());
  59.     entry=[
  60.      
  61.     ];
  62.     sheet.appendRow(entry);
  63.   }
  64. }
  65.  
  66. function getSaleEntries(param, filter){
  67.  
  68.  
  69.  
  70.  
  71. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement