Clinic Notification System

nurse.gs

function onFormSubmit1(){
  var form = FormApp.getActiveForm();
  var currentResponse = form.getResponses()[form.getResponses().length-1];
  var barCode = currentResponse.getItemResponses()[0].getResponse();
  var reason = currentResponse.getItemResponses()[1].getResponse();
  var parentContact = currentResponse.getItemResponses()[2].getResponse();
  var info = findInfoFromBarCode(barCode);
  if (info[1] == 'Unknown'){
    try{
    info[1] = currentResponse.getItemResponses()[3].getResponse();
    }
    catch(err){
      Logger.log(err);
    }
  }
  
  var name = info[0];
  var postion = info[1];
  var date = new Date();
  var month = date.getMonth()+1;
  var day = date.getDate();
  var year = date.getFullYear();
  var hour = date.getHours();
  var myDay = month+'/'+day+'/'+year;
  var minute = date.getMinutes()+1;
  if (minute < 10){
    minute = '0'+minute;
  }
  var timestamp = hour+':'+minute;
  var sheetName = month+'-'+year;
  //Open spreadsheet and get this month's sheet or create a new one
  var spreadsheet = SpreadsheetApp.openById('10rPqn33WzgCWQo9CWc9FfifUMbKRiAP7i52jCbQBSiM');
  try{
    var sheet = spreadsheet.getSheetByName(sheetName);
    var lastRow = sheet.getLastRow();
    Logger.log('Hit');
  }
  catch(err){
    var sheet = spreadsheet.insertSheet(sheetName, 1)
    sheet.appendRow(['Name','Time-In','Time-Out','Grade / Role','Date','Reason','Result','Minutes in Station','In Now()','Out Now()','Guardian contact/consent'])
    Logger.log('caught');
  } 
  
  //find data from sheet
  var lastRow = sheet.getLastRow();
  Logger.log(lastRow);
  var range = sheet.getRange(1, 1, lastRow, 4).getValues();
  for (var i = range.length-1; i >-1; i = i-1){
    Logger.log(range[i][0]);
    if (name == range[i][0]){
      Logger.log('Found Name');
      Logger.log(range[i][2]);
      var checkEntry = range[i][2].toString();
      if (checkEntry.length > 2){

        Logger.log('Duplicate');
        //add info to sheet
        sendTeacherEmail(name, postion, reason)
        sheet.appendRow([name,timestamp,'',postion,myDay,reason,'','',Date.now(),'',parentContact]);
        return
      }
      else{
        //Sign out
        sheet.getRange(i+1, 3).setValue(timestamp);
        var msTime = sheet.getRange(i+1, 9).getValue();
        var newNow = Date.now();
        var msInLibrary = newNow - msTime
        var minInLibrary = Math.floor(msInLibrary / 60000);
        Logger.log(minInLibrary);
        sheet.getRange(i+1, 7).setValue(reason);
        sheet.getRange(i+1, 8).setValue(minInLibrary);
        sheet.getRange(i+1,10).setValue(newNow);
        sheet.getRange(i+1, 11).setValue(parentContact);
        return
      }
    }
    
  }

  //add info to sheet
  sendTeacherEmail(name, postion, reason)
  sheet.appendRow([name,timestamp,'',postion,myDay,reason,'','',Date.now()]);
  
}

function findInfoFromBarCode(barCode){
  //return [barCode, 'Unknown'];
  var modCode = "*"+barCode+"*";
  var database = SpreadsheetApp.openById('1N5YoTJCcIWDS5Sg7AVoGfVJAlobZcgCV4N5rNkQeg8A');
  
  var subString = modCode.substring(1, 3);
  Logger.log('Substring is: '+subString);
  if (subString == '99'){
    var sheet = database.getSheetByName('parents');
  }
  else if (subString == '10'){
    var sheet = database.getSheetByName('students');
  }
  else{
  //Staff
  var sheet = database.getSheetByName('staff');
  }
  
  var lastRow = sheet.getLastRow();
  var dataRange = sheet.getRange(1, 1, lastRow, 6).getValues();
  for (var i = 1; i < lastRow; i++){
    if (dataRange[i][3] == modCode){
      var firstName = dataRange[i][1];
      var lastName = dataRange[i][2];
      var position = dataRange[i][4];
      Logger.log(firstName+' '+lastName+': '+position);
      return [firstName+' '+lastName, position];
    }
  }
  return [barCode, 'Unknown'];
}

function sendTeacherEmail(name, position, reason){
  var ss = SpreadsheetApp.openById('10rPqn33WzgCWQo9CWc9FfifUMbKRiAP7i52jCbQBSiM');
  var sheet = ss.getSheetByName('Teacher Contact Info');
  var data = sheet.getDataRange().getValues();
  Logger.log(data)
  for (var i = 0; i < data.length; i++){
    if (data[i][0] == position){
      MailApp.sendEmail(data[i][1], name+' at clinic', name+' is at the clinic for '+reason);
      return data[i][2];
    }
  }
  Logger.log('No Teacher');
  return 'No Teacher';
}