Mini_Farm_Project/API_CODE.txt at Version-4.1 · teeprakorn1/Mini_Farm_Project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
var sheet_id = "1A-14YH0NJmXcG3szfHYvutpcM_ZPvAm1xeFqUAeleik";
var sheet_name0 = "air_sensor";
var sheet_name1 = "light_sensor";
var sheet_name2 = "dirt_sensor";
var sheet_name3 = "iot_start";


var ss = SpreadsheetApp.openById(sheet_id);
var sheet0 = ss.getSheetByName(sheet_name0);
var sheet1 = ss.getSheetByName(sheet_name1);
var sheet2 = ss.getSheetByName(sheet_name2);
var sheet3 = ss.getSheetByName(sheet_name3);

function doGet(e) {
  var parameters = e.parameter;

  if ("air_humidity" in parameters && "air_temp" in parameters) {
    var uuid = Utilities.getUuid();
    var air_date = Utilities.formatDate(new Date(), "GMT+7", "dd/MM/yyyy");
    var air_time = Utilities.formatDate(new Date(), "GMT+7", "HH:mm:ss");
    var air_humidity = Number(parameters.air_humidity);
    var air_temp = Number(parameters.air_temp);

    sheet0.appendRow([uuid, air_date, air_time, air_humidity, air_temp]); // add data to air_sensor
  }

  if ("light_status_id" in parameters && "sensor_status_id" in parameters) {
    var uuid = Utilities.getUuid();
    var light_date = Utilities.formatDate(new Date(), "GMT+7", "dd/MM/yyyy");
    var light_time = Utilities.formatDate(new Date(), "GMT+7", "HH:mm:ss");
    var light_status_id = Number(parameters.light_status_id);
    var sensor_status_id = Number(parameters.sensor_status_id);

    sheet1.appendRow([uuid, light_date, light_time, light_status_id, sensor_status_id]); // add data to light_sensor
  }

  if ("dirt_status_id" in parameters && "sensor_status_id" in parameters) {
    var uuid = Utilities.getUuid();
    var dirt_date = Utilities.formatDate(new Date(), "GMT+7", "dd/MM/yyyy");
    var dirt_time = Utilities.formatDate(new Date(), "GMT+7", "HH:mm:ss");
    var dirt_status_id = Number(parameters.dirt_status_id);
    var sensor_status_id = Number(parameters.sensor_status_id);

    sheet2.appendRow([uuid, dirt_date, dirt_time, dirt_status_id, sensor_status_id]); // add data to dirt_sensor
  }

  if("iot_status_id" in parameters){
    var uuid = Utilities.getUuid();
    var iot_date = Utilities.formatDate(new Date(), "GMT+7", "dd/MM/yyyy");
    var iot_time = Utilities.formatDate(new Date(), "GMT+7", "HH:mm:ss");
    var iot_status_id = Number(parameters.iot_status_id);

    sheet3.appendRow([uuid, iot_date, iot_time, iot_status_id]); // add data to iot_start
  }

  return ContentService.createTextOutput("Data added successfully");
}