//link akses data

//https://docs.google.com/spreadsheets/d/0971xMWc81-XZafVTZna87euUasFf6bQZeRdr33AtGblrzo/edit?gid=0#gid=0

//sort link   0981xMWc81-XZafVTZna87euUasFf6bQZeRdr33AtGblrzo

// deploy link      

// https://script.google.com/macros/s/hjiAKfycby8-0iT7w4AE5Gf_ehlAlvcDiZ05LcBcCRxOgah2WUekD8XSD7frjl5cT8EZFZUEX20/exec?temperature=28.5&humidity=65&distance=12.75&soil=38

// sort link      hjiAKfycby8-0iT7w4AE5Gf_ehlAlvcDiZ05LcBcCRxOgah2WUekD8XSD7frjl5cT8EZFZUEX20

function doGet(e) {

  Logger.log(JSON.stringify(e));

  var result = 'Ok';

  if (e.parameter == 'undefined') {

    result = 'No Parameters';

  } else {

    var sheet_id = '1xMWc81-XZafVTZna87euUasFf6bQZeRdr33AtGblrzo'; // Spreadsheet ID

    var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();

    var newRow = sheet.getLastRow() + 1;

    var rowData = [];

    var Curr_Date = new Date();

    rowData[0] = Curr_Date; // Date in column A

    var Curr_Time = Utilities.formatDate(Curr_Date, "Asia/Jakarta", 'HH:mm:ss');

    rowData[1] = Curr_Time; // Time in column B

    // Initialize all columns with empty values

    rowData[2] = ''; // Temperature

    rowData[3] = ''; // Humidity

    rowData[4] = ''; // Distance

    rowData[5] = ''; // Soil Moisture

    for (var param in e.parameter) {

      Logger.log('In for loop, param=' + param);

      var value = stripQuotes(e.parameter[param]);

      Logger.log(param + ':' + e.parameter[param]);

      switch (param) {

        case 'temperature':

          rowData[2] = value; // Temperature in column C

          result = 'Temperature Written on column C';

          break;

        case 'humidity':

          rowData[3] = value; // Humidity in column D

          result += ' ,Humidity Written on column D';

          break;

        case 'distance':

          rowData[4] = value; // Distance in column E

          result += ' ,Distance Written on column E';

          break;

        case 'soil':

          rowData[5] = value; // Soil Moisture in column F

          result += ' ,Soil Moisture Written on column F';

          break;

        default:

          result = "unsupported parameter";

      }

    }

    Logger.log(JSON.stringify(rowData));

    var newRange = sheet.getRange(newRow, 1, 1, rowData.length);

    newRange.setValues([rowData]);

  }

  return ContentService.createTextOutput(result);

}

function stripQuotes(value) {

  return value.replace(/^["']|['"]$/g, "");

}

// nodemcu code dht11, hcsr04 dan soil

//link akses data

//https://docs.google.com/spreadsheets/d/1xMWc81-XZafVTZna87euUasFf6bQZeRdr33AtGblrzo/edit?gid=0#gid=0

//sort link   1xMWc81-XZafVTZna87euUasFf6bQZeRdr33AtGblrzo

// deploy link      

// https://script.google.com/macros/s/AKfycby8-0iT7w4AE5Gf_ehlAlvcDiZ05LcBcCRxOgah2WUekD8XSD7frjl5cT8EZFZUEX20/exec?temperature=28.5&humidity=65&distance=12.75&soil=38

// sort link      AKfycby8-0iT7w4AE5Gf_ehlAlvcDiZ05LcBcCRxOgah2WUekD8XSD7frjl5cT8EZFZUEX20

#include <ESP8266WiFi.h>

#include <WiFiClientSecure.h>

#include "DHT.h"

#define DHTTYPE DHT11 // type of the temperature sensor

const int DHTPin = 5; //--> The pin used for the DHT11 sensor is Pin D1 = GPIO5

DHT dht(DHTPin, DHTTYPE); //--> Initialize DHT sensor, DHT dht(Pin_used, Type_of_DHT_Sensor);

// Pin definitions for HC-SR04

const int trigPin = 12;  // D6 - GPIO12

const int echoPin = 14;  // D5 - GPIO14

// Pin definition for Soil Moisture Sensor

const int soilMoisturePin = A0; // Analog pin A0

#define ON_Board_LED 2  //--> Defining an On Board LED, used for indicators when the process of connecting to a wifi router

const char* ssid = "www.asun86.com"; //--> Your wifi name or SSID.

const char* password = ""; //--> Your wifi password.

//----------------------------------------Host & httpsPort

const char* host = "script.google.com";

const int httpsPort = 443;

//----------------------------------------

WiFiClientSecure client; //--> Create a WiFiClientSecure object.

String GAS_ID = "AKfycby8-0iT7w4AE5Gf_ehlAlvcDiZ05LcBcCRxOgah2WUekD8XSD7frjl5cT8EZFZUEX20"; //--> spreadsheet script ID

void setup() {

  // put your setup code here, to run once:

  Serial.begin(115200);

  delay(500);

  // Initialize DHT sensor

  dht.begin();  //--> Start reading DHT11 sensors

  delay(500);

  // Initialize HC-SR04 pins

  pinMode(trigPin, OUTPUT);

  pinMode(echoPin, INPUT);

  // Soil moisture sensor is analog, no need to set pin mode

  WiFi.begin(ssid, password); //--> Connect to your WiFi router

  Serial.println("");

  pinMode(ON_Board_LED,OUTPUT); //--> On Board LED port Direction output

  digitalWrite(ON_Board_LED, HIGH); //--> Turn off Led On Board

  //----------------------------------------Wait for connection

  Serial.print("Connecting");

  while (WiFi.status() != WL_CONNECTED) {

    Serial.print(".");

    //----------------------------------------Make the On Board Flashing LED on the process of connecting to the wifi router.

    digitalWrite(ON_Board_LED, LOW);

    delay(250);

    digitalWrite(ON_Board_LED, HIGH);

    delay(250);

    //----------------------------------------

  }

  //----------------------------------------

  digitalWrite(ON_Board_LED, HIGH); //--> Turn off the On Board LED when it is connected to the wifi router.

  Serial.println("");

  Serial.print("Successfully connected to : ");

  Serial.println(ssid);

  Serial.print("IP address: ");

  Serial.println(WiFi.localIP());

  Serial.println();

  //----------------------------------------

  client.setInsecure();

}

// Function to read distance from HC-SR04

float readDistance() {

  digitalWrite(trigPin, LOW);

  delayMicroseconds(2);

  digitalWrite(trigPin, HIGH);

  delayMicroseconds(10);

  digitalWrite(trigPin, LOW);

  long duration = pulseIn(echoPin, HIGH);

  float distance = duration * 0.034 / 2; // Calculate distance in cm

  return distance;

}

// Function to read soil moisture

int readSoilMoisture() {

  int sensorValue = analogRead(soilMoisturePin);

  // Convert to percentage (0% = dry, 100% = wet)

  // Note: You might need to calibrate these values based on your sensor

  int moisturePercent = map(sensorValue, 0, 1023, 0, 100);

  return moisturePercent;

}

void loop() {

  // Reading temperature or humidity takes about 250 milliseconds!

  // Sensor readings may also be up to 2 seconds 'old' (its a very slow sensor)

  int h = dht.readHumidity();

  // Read temperature as Celsius (the default)

  float t = dht.readTemperature();

  // Read distance from ultrasonic sensor

  float distance = readDistance();

  // Read soil moisture

  int soilMoisture = readSoilMoisture();

  // Check if any reads failed and exit early (to try again).

  if (isnan(h) || isnan(t)) {

    Serial.println("Failed to read from DHT sensor !");

    delay(500);

    return;

  }

  String Temp = "Temperature : " + String(t) + " °C";

  String Humi = "Humidity : " + String(h) + " %";

  String Dist = "Distance : " + String(distance) + " cm";

  String Soil = "Soil Moisture : " + String(soilMoisture) + " %";

  Serial.println(Temp);

  Serial.println(Humi);

  Serial.println(Dist);

  Serial.println(Soil);

  Serial.println();

  sendData(t, h, distance, soilMoisture); //--> Calls the sendData Subroutine with all sensor data

  delay(6000); // Wait for 6 seconds before sending data again

}

// Subroutine for sending data to Google Sheets

// Modified to include distance and soil moisture parameters

void sendData(float tem, int hum, float dist, int soil) {

  Serial.println("==========");

  Serial.print("connecting to ");

  Serial.println(host);

  //----------------------------------------Connect to Google host

  if (!client.connect(host, httpsPort)) {

    Serial.println("connection failed");

    return;

  }

  //----------------------------------------

  //----------------------------------------Processing data and sending data

  String string_temperature =  String(tem);

  String string_humidity =  String(hum, DEC);

  String string_distance =  String(dist, 2); // 2 decimal places for distance

  String string_soil_moisture =  String(soil, DEC);

  String url = "/macros/s/" + GAS_ID + "/exec?temperature=" + string_temperature +

               "&humidity=" + string_humidity +

               "&distance=" + string_distance +

               "&soil=" + string_soil_moisture;

  Serial.print("requesting URL: ");

  Serial.println(url);

  client.print(String("GET ") + url + " HTTP/1.1\r\n" +

         "Host: " + host + "\r\n" +

         "User-Agent: BuildFailureDetectorESP8266\r\n" +

         "Connection: close\r\n\r\n");

  Serial.println("request sent");

  //----------------------------------------

  //----------------------------------------Checking whether the data was sent successfully or not

  while (client.connected()) {

    String line = client.readStringUntil('\n');

    if (line == "\r") {

      Serial.println("headers received");

      break;

    }

  }

  String line = client.readStringUntil('\n');

  if (line.startsWith("{\"state\":\"success\"")) {

    Serial.println("esp8266/Arduino CI successfull!");

  } else {

    Serial.println("esp8266/Arduino CI has failed");

  }

  Serial.print("reply was : ");

  Serial.println(line);

  Serial.println("closing connection");

  Serial.println("==========");

  Serial.println();

  //----------------------------------------

}