#include "WiFi.h"
#include <HTTPClient.h>
#include <time.h>
#include <sys/time.h>
// WiFi credentials
const char* ssid = "Wokwi-GUEST"; // change SSID
const char* password = ""; // change password
//sample web app link -
// results google sheet link - https://docs.google.com/spreadsheets/d/1bLoXfMlVEIFwtIqw9Ddh5lMiISU4WpZzajkjpbW_rZU/
// Google script ID and required credentials
//https://script.google.com/macros/s/AKfycbyR1hQposfn0mVRamEYJjSRv8qTnLfnv7SqjWGYlWZkslWVGaQqsVhzorIpeNFaBlw3/exec
// AKfycbzbrKl1m2PyERcrViv5-yhhKSgBdKtbMJP2kHl5ZqKLCvLjlMP-Gz2i5bq0T7a7EF15
const String GOOGLE_SCRIPT_ID = "AKfycbzC2WmvFgjVTSWwGjXOP9a6BRScEpSNwVc99EgfRgwt60zmNTrK8mPfbwOyfLRvDGTS"; // change Gscript ID
const int EVENT_OPEN = 1;
const int EVENT_CLOSE = 0;
const String EVENT_NAME = "door_sensor_1";
String event_string = "";
bool last_state = false;
bool current_state = false;
bool server_free=true;
int retry_counter = 0;
void setup() {
//pinMode(4, INPUT_PULLUP);
// delay(100);
Serial.begin(115200);
delay(100);
// connect to WiFi
Serial.println();
Serial.print("Connecting to wifi: ");
Serial.println(ssid);
Serial.flush();
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
Serial.println("Connected ");
}
void loop() {
// current_state = digitalRead(4);
current_state !=
if (current_state != last_state)
{
if (current_state) //abrir
{
event_string = String(EVENT_OPEN);
Serial.println("***open_event***");
}
else //recusar
{
event_string = String(EVENT_CLOSE);
Serial.println("***close_event***");
}
last_state = current_state;
if (server_free)
{
server_free=false;
xTaskCreate(post_data, "post_data" , 7168 , nullptr , 4 , nullptr);
}
else
{
Serial.println("*** HTTP SERVER BUSY! IGNORING EVENT ***");
}
delay(50); //debounce
}
}
void post_data(void* params)
{
retry_counter = 3;
while (retry_counter > 0)
{
String urlFinal = "https://script.google.com/macros/s/" + GOOGLE_SCRIPT_ID +
"/exec?" + EVENT_NAME + "=" + event_string +
"&retries_left=" + String(retry_counter) +
"&esp_time=" + String(millis());
Serial.println("POST data to spreadsheet:");
Serial.println(urlFinal);
HTTPClient http;
http.begin(urlFinal.c_str());
http.setFollowRedirects(HTTPC_STRICT_FOLLOW_REDIRECTS);
int httpCode = http.GET();
Serial.print("HTTP Status Code: ");
Serial.println(httpCode);
//---------------------------------------------------------------------
//getting response from google sheet
if (httpCode > 0) {
String payload;
payload = http.getString();
Serial.println("Payload: " + payload);
http.end();
retry_counter = 0;
}
else
{
retry_counter--;
Serial.println("HTTP GET failed - retries left: " + String(retry_counter));
delay(2000);
}
//---------------------------------------------------------------------
}
server_free=true;
vTaskDelete(nullptr);
}