/* ------------------------------------------------------------------------
* Created by: Tauseef Ahmad
* Created on: 10 March, 2023
*
* Tutorial: https://youtu.be/aNjkNmHRx4o
* ------------------------------------------------------------------------
* Download Resources
* ------------------------------------------------------------------------
* Preferences--> Aditional boards Manager URLs :
* For ESP8266 and NodeMCU - Board Version 2.6.3
* http://arduino.esp8266.com/stable/package_esp8266com_index.json
* ------------------------------------------------------------------------
* HTTPS Redirect Library:
* https://github.com/jbuszkie/HTTPSRedirect
* Example Arduino/ESP8266 code to upload data to Google Sheets
* Follow setup instructions found here:
* https://github.com/StorageB/Google-Sheets-Logging
* ------------------------------------------------------------------------*/
#include <Arduino.h>
#include <ESP8266WiFi.h>
#include <SPI.h>
#include <MFRC522.h>
#include <HTTPSRedirect.h>
#include<Wire.h>
#include<LiquidCrystal_I2C.h>
LiquidCrystal_I2C lcd(0x27, 16, 2);
//---------------------------------------------------------------------------------------------------------
// Enter Google Script Deployment ID:
const char *GScriptId = "AKfycbylTfyBAh3WcraafNciNYZ0mKUkx7M8pG43sdlKIlW6muYRWtdV_AhF5XwOsWz_SXg9";
String gate_number = "Gate1";
//---------------------------------------------------------------------------------------------------------
// Enter network credentials:
const char* ssid = "CreativePhone"; //"MIM 06 ESMART";
const char* password = "creat123"; //"esmartschool123";
//---------------------------------------------------------------------------------------------------------
// Enter command (insert_row or append_row) and your Google Sheets sheet name (default is Sheet1):
String payload_base = "{\"command\": \"insert_row\", \"sheet_name\": \"Sheet1\", \"values\": ";
String payload = "";
//---------------------------------------------------------------------------------------------------------
// Google Sheets setup (do not edit)
const char* host = "script.google.com";
const int httpsPort = 443;
const char* fingerprint = "";
String url = String("/macros/s/") + GScriptId + "/exec";
HTTPSRedirect* client = nullptr;
//------------------------------------------------------------
// Declare variables that will be published to Google Sheets
String student_id;
//------------------------------------------------------------
int blocks[] = {4,5,6,8,9};
#define total_blocks (sizeof(blocks) / sizeof(blocks[0]))
//------------------------------------------------------------
#define RST_PIN 0 //D3
#define SS_PIN 2 //D4
#define BUZZER 4 //D2
//------------------------------------------------------------
MFRC522 mfrc522(SS_PIN, RST_PIN);
MFRC522::MIFARE_Key key;
MFRC522::StatusCode status;
//------------------------------------------------------------
/* Be aware of Sector Trailer Blocks */
int blockNum = 2;
/* Create another array to read data from Block */
/* Legthn of buffer should be 2 Bytes more than the size of Block (16 Bytes) */
byte bufferLen = 18;
byte readBlockData[18];
//------------------------------------------------------------
/****************************************************************************************************
* setup Function
****************************************************************************************************/
void setup() {
//----------------------------------------------------------
Serial.begin(9600);
delay(10);
Serial.println('\n');
//----------------------------------------------------------
SPI.begin();
//----------------------------------------------------------
//initialize lcd screen
lcd.init();
// turn on the backlight
lcd.backlight();
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Koneksi ke ");
lcd.setCursor(0,1); //col=0 row=0
lcd.print("WiFi...");
//----------------------------------------------------------
// Connect to WiFi
WiFi.begin(ssid, password);
Serial.print("Koneksi ke ");
Serial.print(ssid); Serial.println(" ...");
while (WiFi.status() != WL_CONNECTED) {
delay(1000);
Serial.print(".");
}
Serial.println('\n');
Serial.println("WiFi Terkoneksi!");
//Serial.print("IP address:\t");
Serial.println(WiFi.localIP());
//----------------------------------------------------------
// Use HTTPSRedirect class to create a new TLS connection
client = new HTTPSRedirect(httpsPort);
client->setInsecure();
client->setPrintResponseBody(true);
client->setContentTypeHeader("application/json");
//----------------------------------------------------------
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Koneksi ke");
lcd.setCursor(0,1); //col=0 row=0
lcd.print("Google ");
delay(5000);
//----------------------------------------------------------
Serial.print("Mengkoneksikan ke ");
Serial.println(host);
//----------------------------------------------------------
// Try to connect for a maximum of 5 times
bool flag = false;
for(int i=0; i<5; i++){
int retval = client->connect(host, httpsPort);
//*************************************************
if (retval == 1){
flag = true;
String msg = "Terkoneksi. OK";
Serial.println(msg);
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print(msg);
delay(2000);
break;
}
//*************************************************
else
Serial.println("Koneksi gagal. Mencoba ulang...");
//*************************************************
}
//----------------------------------------------------------
if (!flag){
//____________________________________________
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Koneksi gagal");
//____________________________________________
Serial.print("Tidak dapat terhubung ke server: ");
Serial.println(host);
delay(5000);
return;
//____________________________________________
}
//----------------------------------------------------------
delete client; // delete HTTPSRedirect object
client = nullptr; // delete HTTPSRedirect object
//----------------------------------------------------------
pinMode(15, OUTPUT);
pinMode(16, OUTPUT);
}
/****************************************************************************************************
* loop Function
****************************************************************************************************/
void loop() {
//Serial.println("[TEST] loop() starts");
//----------------------------------------------------------------
static bool flag = false;
if (!flag){
client = new HTTPSRedirect(httpsPort);
client->setInsecure();
flag = true;
client->setPrintResponseBody(true);
client->setContentTypeHeader("application/json");
}
if (client != nullptr){
//when below if condition is TRUE then it takes more time then usual, It means the device
//is disconnected from the google sheet server and it takes time to connect again
//NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
if (!client->connected()){
int retval = client->connect(host, httpsPort);
if (retval != 1){
Serial.println("Disconnected. Retrying...");
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Terputus.");
lcd.setCursor(0,1); //col=0 row=0
lcd.print("Mencoba Ulang...");
return; //Reset the loop
}
}
//NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
}
else{Serial.println("Error creating client object!"); Serial.println("else");}
//----------------------------------------------------------------
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("KARTU SHOLIH");
lcd.setCursor(0,1); //col=0 row=0
lcd.print("SHOLIHAH");
//Serial.println("[TEST] Scan Your Tag");
/* Initialize MFRC522 Module */
mfrc522.PCD_Init();
/* Look for new cards */
/* Reset the loop if no new card is present on RC522 Reader */
if ( ! mfrc522.PICC_IsNewCardPresent()) {return;}
/* Select one of the cards */
if ( ! mfrc522.PICC_ReadCardSerial()) {return;}
/* Read data from the same block */
Serial.println();
Serial.println(F("Membaca data RFID Terakhir"));
//----------------------------------------------------------------
String values = "", data;
/*
//creating payload - method 1
//----------------------------------------------------------------
ReadDataFromBlock(blocks[0], readBlockData); //student id
data = String((char*)readBlockData); data.trim();
student_id = data;
//----------------------------------------------------------------
ReadDataFromBlock(blocks[1], readBlockData); //first name
data = String((char*)readBlockData); data.trim();
first_name = data;
//----------------------------------------------------------------
ReadDataFromBlock(blocks[2], readBlockData); //last name
data = String((char*)readBlockData); data.trim();
last_name = data;
//----------------------------------------------------------------
ReadDataFromBlock(blocks[3], readBlockData); //phone number
data = String((char*)readBlockData); data.trim();
phone_number = data;
//----------------------------------------------------------------
ReadDataFromBlock(blocks[4], readBlockData); //address
data = String((char*)readBlockData); data.trim();
address = data; data = "";
//----------------------------------------------------------------
values = "\"" + student_id + ",";
values += first_name + ",";
values += last_name + ",";
values += phone_number + ",";
values += address + "\"}";
//----------------------------------------------------------------*/
//creating payload - method 2 - More efficient
for (byte i = 0; i < total_blocks; i++) {
ReadDataFromBlock(blocks[i], readBlockData);
//*************************************************
if(i == 0){
data = String((char*)readBlockData);
data.trim();
student_id = data;
values = "\"" + data + ",";
}
//*************************************************
/*else if(i == total_blocks-1){
data = String((char*)readBlockData);
data.trim();
values += data + "\"}";
}*/
//*************************************************
else{
data = String((char*)readBlockData);
data.trim();
values += data + ",";
}
}
values += gate_number + "\"}";
//----------------------------------------------------------------
// Create json object string to send to Google Sheets
// values = "\"" + value0 + "," + value1 + "," + value2 + "\"}"
payload = payload_base + values;
//----------------------------------------------------------------
digitalWrite(15, HIGH);
digitalWrite(16, HIGH);
delay(100);
digitalWrite(15, LOW);
digitalWrite(16, LOW);
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Tunggu Ya......");
lcd.setCursor(0,1);
lcd.print(":)");
//----------------------------------------------------------------
lcd.setCursor(0,1); //col=0 row=0
// Publish data to Google Sheets
Serial.println("Mengirim Data...");
Serial.println(payload);
if(client->POST(url, host, payload)){
// do stuff here if publish was successful
Serial.println("[OK] Data published.");
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print(student_id);
lcd.setCursor(0,1); //col=0 row=0
lcd.print("Sukses - ;)");
digitalWrite(15, HIGH);
digitalWrite(16, HIGH);
delay(100);
digitalWrite(15, LOW);
digitalWrite(16, LOW);
delay(100);
digitalWrite(15, HIGH);
digitalWrite(16, HIGH);
delay(100);
digitalWrite(15, LOW);
digitalWrite(16, LOW);
}
//----------------------------------------------------------------
else{
// do stuff here if publish was not successful
Serial.println("Error while connecting");
lcd.clear();
lcd.setCursor(0,0); //col=0 row=0
lcd.print("Gagal.");
lcd.setCursor(0,1); //col=0 row=0
lcd.print("Coba Lagi");
}
//----------------------------------------------------------------
// a delay of several seconds is required before publishing again
Serial.println("[TEST] delay(5000)");
delay(5000);
}
/****************************************************************************************************
*
****************************************************************************************************/
/****************************************************************************************************
* ReadDataFromBlock() function
****************************************************************************************************/
void ReadDataFromBlock(int blockNum, byte readBlockData[])
{
//----------------------------------------------------------------------------
/* Prepare the ksy for authentication */
/* All keys are set to FFFFFFFFFFFFh at chip delivery from the factory */
for (byte i = 0; i < 6; i++) {
key.keyByte[i] = 0xFF;
}
//----------------------------------------------------------------------------
/* Authenticating the desired data block for Read access using Key A */
status = mfrc522.PCD_Authenticate(MFRC522::PICC_CMD_MF_AUTH_KEY_A, blockNum, &key, &(mfrc522.uid));
//----------------------------------------------------------------------------s
if (status != MFRC522::STATUS_OK){
Serial.print("Pembacaan autentikasi gagal: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
//----------------------------------------------------------------------------
else {
Serial.println("Pembacaan Berhasil");
}
//----------------------------------------------------------------------------
/* Reading data from the Block */
status = mfrc522.MIFARE_Read(blockNum, readBlockData, &bufferLen);
if (status != MFRC522::STATUS_OK) {
Serial.print("Pembacaan gagal: ");
Serial.println(mfrc522.GetStatusCodeName(status));
return;
}
//----------------------------------------------------------------------------
else {
readBlockData[16] = ' ';
readBlockData[17] = ' ';
Serial.println("Block was read successfully");
}
//----------------------------------------------------------------------------
}