var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName("Sheet2");
var timeZone = Session.getScriptTimeZone();
date = Utilities.formatDate(new Date(), timeZone, "MM-dd-yyyy | HH:mm:ss");

function doPost(e){

      var action  = e.parameter.action;
      
      if(action == "in")
        return inTime(e);
      
      if(action == "T")
        return Temp(e); 
      
      if(action == "out")
        return outTime(e);
      
    }

    function inTime(e){
      var id = e.parameter.id;
      var values = sheet.getRange(2,1,sheet.getLastRow(),1).getValues();
      
      for(var i = 0 ; i<values.length ; i++){
        if(values[i][0] == id){
          i=i+2;
          var in_time = Utilities.formatDate(new Date(), "GMT+8", "MM-dd-yy hh:mm");
          sheet.getRange(i,3).setValue(in_time);
          return ContentService.createTextOutput("Thank You ! Your TimeIN is "+in_time).setMimeType(ContentService.MimeType.TEXT);
        }
      }
      return ContentService.createTextOutput("Time IN - Id Not Found").setMimeType(ContentService.MimeType.TEXT);
    }


    function outTime(e){
      var id = e.parameter.id;
      var values = sheet.getRange(2,1,sheet.getLastRow(),1).getValues();
      
      for(var i = 0 ; i<values.length ; i++){
        if(values[i][0] == id){
          i=i+2;
          var out_time = Utilities.formatDate(new Date(), "GMT+8", "MM-dd-yy hh:mm:ss");
          sheet.getRange(i,4).setValue(out_time);
          return ContentService.createTextOutput("Thank You ! Your TimeOut  "+out_time).setMimeType(ContentService.MimeType.TEXT);
        }
      }
      return ContentService.createTextOutput("Time OUT - Id Not Found").setMimeType(ContentService.MimeType.TEXT);
    }

    function Temp(e){
      var Temp = e.parameter.Temp ;
      var values = sheet.getRange(2,1,sheet.getLastRow(),1).getValues();
      
      for(var i = 0 ; i<values.length ; i++){
        if(values[i][0] == Temp){
          i=i+2;
          var T_Temp = e.parameter.Temp; 
          sheet.getRange(i,5).setValue(T_Temp);
          return ContentService.createTextOutput("Thank You ! Your Temperature is "+Temp).setMimeType(ContentService.MimeType.TEXT);
        }
      }
      return ContentService.createTextOutput("Temp - Error").setMimeType(ContentService.MimeType.TEXT);
    }