//Global variables
var SID = '1M1ek4w_iQ-GefiwX2FwBc_O4Dh0T65ZzlKzc487calA';
var SS = SpreadsheetApp.openById(SID);
//Get latest sheet as input sheet
var totalSheets = SS.getNumSheets();
var lastSheet = SS.getSheets()[totalSheets - 1]; //if there are 3 sheets, the last sheet is [2]
var s = SS.getSheetByName(lastSheet.getName());

var time = new Date();
var mm = time.getMinutes();
if (String(mm).length <2)
{mm = '0' + mm;}
var hh = time.getHours();
var dd = time.getDate();
var MM = time.getMonth()+1;
var yyyy = time.getFullYear();
time = hh + ':' + mm + ' ' + dd+ '/' + MM + '/' + yyyy;

var data =
    [
      ['Planet', 'Mainland', 'Country', 'City'],
      ['Earth', 'Europe', 'Britain', 'London']
    ];

for(i=1; i<96; i++ )
{if(s.getRange(i,2).getValue() === "") {break;} }

var confirm;

function getStatus()
{
    var ui = SpreadsheetApp.getUi();
    var status = ui.alert('Input weather condition','Is it raining right now?',ui.ButtonSet.YES_NO);
    if(status == ui.Button.YES)
      {
        Logger.log('It is raining right now!');
        s.getRange(i,1).setValue(status);
      }
    else
     {
        Logger.log('It is not raining right now');
        s.getRange(i,1).setValue(status);
     }
}

function createMenu(e)
{
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Utility')
    .addItem('Clear all','Clear')
    .addSeparator()
    .addItem('Clear specific','ClearSpecific')
    .addToUi();
}

function Clear()
{
  SS.getActiveSheet().getRange(4,1,100,100).clearContent();
  Logger.log("All logged data has been cleared.");
}

function ClearSpecific(R1,R2)
{
  var r1 = R1.substring(1);
  var r2 = R2.substring(1);
  var rr = r2-r1;
  var c1 = R1.substring(0,1);
  s2.getRange(4,2).setValue(r1);
  c1 = s2.getRange(8,2).getValue();
  var c2 = R2.substring(0,1);
  s2.getRange(4,2).setValue(r2);
  c2 = s2.getRange(8,2).getValue();
  var rc = c2-c1;
  SS.getActiveSheet().getRange(r1,c1,rr,rc).clearContent();
  Logger.log("Specified data has been cleared.");
}

function getJsonArrayFromData()
{

  var obj = {};

    data = s.getRange(i-1,2).getValue()
    obj.Status = data;
    obj = JSON.stringify(obj);
    if(data == "YES")
    {
       obj = obj.substring(0, 1) + "\\" + obj.substr(1);
       obj = obj.substring(0, 9) + "\\" + obj.substr(9);
       obj = obj.substring(0, 12) + "\\" + obj.substr(12);
       obj = obj.substring(0, 17) + "\\" + obj.substr(17);
    }
    Logger.log(obj);

  return obj;

}

/*function doPost(e)
{

Logger.log("Request received. Begin processing data.")

//Input time of data readings
s.getRange(i,1).setValue(time);

//Input data readings
var parsedData;
try {parsedData = JSON.parse(e.postData.contents);}
catch(f) {return ContentService.createTextOutput("Error in parsing requested object: " + f.message)}
if(parsedData !== undefined)
{
  console.log("Successfully acquired data from client.");
if(parsedData.command == "appendRow")
{
  if(parsedData.values.temperature !== undefined)  {s.getRange(i,2).setValue(parsedData.values.temperature);}
  if(parsedData.values.humidity !== undefined)  {s.getRange(i,3).setValue(parsedData.values.humidity);}
  if(parsedData.values.pressure !== undefined)  {s.getRange(i,4).setValue(parsedData.values.pressure);}
  if(parsedData.values.luminosity !== undefined)  {s.getRange(i,5).setValue(parsedData.values.luminosity);}
}
}
else {Logger.log("Error! Logged data empty or doesn't exist.");}
}
*/

function doGet(e)
{
  var read = e.parameter.read;
  if (read !== undefined)
  {
    return ContentService.createTextOutput(getJsonArrayFromData());
  }

  if (e.parameter.value === undefined)
  {return ContentService.createTextOutput(getJsonArrayFromData());}
}

function test()
{
var data = {
  'entry': {
    'group': {
      'title': 'Dog Skateboarding',
      'description': 'My dog gets some serious air'
    },
    'keywords': 'dog, skateboard'
  }
}
var payload = JSON.stringify(data);
Logger.log(payload);
}