#include <SPI.
h>
#include <Ethernet.h>
#include <MFRC522.h>
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
#include <Keypad.h>
#include <stdio.h>
//#include <LiquidCrystal_I2C.h>
#define RST_PIN 9
#define SDA_PIN 4 // slave for mfrc522
const int pinBuzzer = 5;
int hijau = 8;
int merah = 1;
MFRC522 mfrc522(SDA_PIN, RST_PIN);
//LiquidCrystal_I2C lcd(0x27,20,4);
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress staticIP(192, 168, 1, 240);
IPAddress server_addr(192, 168, 1, 253); // IP of the MySQL *server* here
char user[] = "irend"; // MySQL user login username
char password[] = "12345"; // MySQL user login password
char INSERT_DATA[] = "INSERT INTO [Link] (idkartu, mesin, stat, start_time,
stop_time) VALUES ('%s',%d,%s,%s,%s)";
char query[128];
char nama[10];
/* ini untuk inject ke mysql*/
char INSERT_SMS[] = "INSERT INTO [Link] (DestinationNumber,TextDecoded) VALUES
('%s',%d)";
/* ini script untuk query */
/*const char QUERY_POP[] = "SELECT idkartu, hp_ortu FROM sms.data_siswa WHERE
population > %lu ORDER BY population DESC;";*/
char INSERT_MASUK[] = "INSERT INTO [Link] (idkartu) VALUES ('%s')";
char INSERT_DOMPALA[] = "INSERT INTO [Link] (idkartu, stat) VALUES ('%s',
%d)";
char INSERT_KELUAR[] = "INSERT INTO [Link] (idkartu1) VALUES ('%s')";
EthernetClient client;
MySQL_Connection conn((Client *)&client); //koneksi Client
const byte ROWS = 1;
const byte COLS = 4;
char keys[ROWS][COLS] = {
{'1', '2', '3', '4'}
};
byte rowPins[ROWS] = {2};
byte colPins[COLS] = {7, 10, 6, 3};
Keypad keypad = Keypad( makeKeymap(keys), rowPins, colPins, ROWS, COLS );;
char str[32] = "";
byte readCard[4];
void setup(){
// [Link](); // initialize the lcd
// [Link]();
// [Link](16, 2);
// [Link](0,0);
// [Link]("ID anda:");
// delay(500);
[Link](115200);
pinMode(pinBuzzer, OUTPUT);
pinMode(merah, OUTPUT);
pinMode(hijau, OUTPUT);
[Link](); //jalur mulai
[Link]("====================================");
[Link](" TEKAN KYPAD ");
[Link]("====================================");
mfrc522.PCD_Init();
[Link](mac_addr,staticIP);
}
void loop() {
//Execute();
char keypressed = [Link]();
mfrc522.PCD_Init();
switch (keypressed)
{
[Link](keypressed);
case '1':
Masuk();
break;
case '2':
Keluar();
break;
}
delay(1);
//Masuk();
}
void Readcard() {
mfrc522.PCD_Init(); // Init MFRC522
while (mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()) {
[Link]("ID Kartu Anda : ");
for (int i = 0; i < 4; i++) {
readCard[i] = [Link][i];
[Link](readCard[i], HEX);
}
array_to_string(readCard, 4, str);
[Link]("");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
//while (!Serial);
[Link](mac_addr,staticIP);
if ([Link](server_addr, 3306, user, password)) {
delay(100);
MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
sprintf(query, INSERT_DATA, str, "", "'10'");
cur_mem->execute(query);
delete cur_mem;
[Link]("Data Anda Sudah Direkam");
}
else
[Link]("Connection failed.");
digitalWrite(pinBuzzer, HIGH);
delay(1000);
digitalWrite(pinBuzzer, LOW);
[Link]();
}
}
void Masuk() {
char keypressed = [Link]();
while (mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()) {
[Link]("ID Kartu Anda : ");
for (int i = 0; i < 4; i++) {
readCard[i] = [Link][i];
[Link](readCard[i], HEX);
// [Link](readCard[i], HEX);
}
array_to_string(readCard, 4, str);
[Link]("");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
// [Link](mac_addr);
[Link](mac_addr,staticIP);
if ([Link](server_addr, 3306, user, password)) {
delay(100);
MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
sprintf(query, INSERT_DATA, str, "", "'1'", "'[Link]'", "'[Link]'");
cur_mem->execute(query);
delete cur_mem;
[Link]("Data Anda Sudah Direkam");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
delay(200);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
delay(200);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
delay(200);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
}
// else
// digitalWrite(pinBuzzer, HIGH);
// delay(1000);
// digitalWrite(pinBuzzer, LOW);
// [Link]("Connection sucses.");
[Link]();
}
//
// digitalWrite(pinBuzzer, HIGH);
// delay(1000);
// digitalWrite(pinBuzzer, LOW);
//
}
void Keluar() {
char keypressed = [Link]();
while (mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()) {
[Link]("ID Kartu Anda : ");
for (int i = 0; i < 4; i++) {
readCard[i] = [Link][i];
[Link](readCard[i], HEX);
}
array_to_string(readCard, 4, str);
[Link]("");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
// [Link](mac_addr);
[Link](mac_addr,staticIP);
if ([Link](server_addr, 3306, user, password)) {
delay(100);
MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
sprintf(query, INSERT_DATA, str, "", "'2'", "'[Link]'", "'[Link]'");
cur_mem->execute(query);
delete cur_mem;
[Link]("Data Anda Sudah Direkam");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
delay(200);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
delay(200);
digitalWrite(hijau, HIGH);
delay(300);
digitalWrite(hijau, LOW);
}
// [Link]("Connection sucses.");
[Link]();
}
// }
// else
//
// digitalWrite(pinBuzzer, HIGH);
// delay(1000);
// digitalWrite(pinBuzzer, LOW);
void Sms() {
char keypressed = [Link]();
while (mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()) {
[Link]("ID Kartu Anda : ");
for (int i = 0; i < 4; i++) {
readCard[i] = [Link][i];
[Link](readCard[i], HEX);
}
array_to_string(readCard, 4, str);
[Link]("");
digitalWrite(pinBuzzer, HIGH);
delay(200);
digitalWrite(pinBuzzer, LOW);
[Link](mac_addr, staticIP);
if ([Link](server_addr, 3306, user, password)) {
delay(100);
MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
sprintf(query, INSERT_SMS, str, "", "'0811467646'");
cur_mem->execute(query);
delete cur_mem;
[Link]("Data Anda Sudah Terkirim");
}
else
[Link]("Connection failed.");
[Link]();
}
}
void array_to_string(byte array[], unsigned int len, char buffer[])
{
for (unsigned int i = 0; i < len; i++)
{
byte nib1 = (array[i] >> 4) & 0x0F;
byte nib2 = (array[i] >> 0) & 0x0F;
buffer[i * 2 + 0] = nib1 < 0xA ? '0' + nib1 : 'A' + nib1 - 0xA;
buffer[i * 2 + 1] = nib2 < 0xA ? '0' + nib2 : 'A' + nib2 - 0xA;
}
buffer[len * 2] = '\0';
}
void Execute() {
