基于RFID的学生出勤监控系统

2512858 2023-01-30 | zip | 0.05 MB | 次下载 | 免费

资料介绍

电路板如下图：

组件

499 Adafruit 工业有限责任公司	x 1
ESP-WROOM-32	x 1

描述

基于 RFID 的学生出勤监控系统

在教室里，时间被浪费在点名上，因为它是手动完成的。在这个提议的系统中，被授权的学生被赋予一个 RFID 标签。通过将 RFID 标签放在阅读器上，学生或工作人员可以立即验证他们的出勤情况。因此，存储在该卡中的数据被称为该人的身份/出勤。一旦学生将卡片放在 RFID 读卡器前面，它就会读取数据并与存储的数据进行验证。蜂鸣器会在扫描 RFID 标签时发出蜂鸣声。如果数据匹配，则它会在 LCD 上显示一条消息，确认该学生的输入，否则会显示一条消息，拒绝出席。通过按下连接到微控制器的状态按钮，可以从该系统中检索学生的出勤状态。最后，他/她的日期和时间数据存储在谷歌表格中。这个特定的谷歌表格显示了日期、时间和 RFID 标签中存储的数据。因此，由于所有学生的出勤情况都直接存储在数据库中，因此节省了大量时间。它将产生一个实时考勤监控系统，供讲师、校园管理人员和家长等各方访问。

代码

RFID入口代码

阿杜诺

?	#include
?	#include
?	//--------------------------------------------------
?	//GPIO 0 --> D3
?	//GPIO 2 --> D4
?	const uint8_t RST_PIN = D3;
?	const uint8_t SS_PIN = D4;
?	int BUZZER = 2;
?	//--------------------------------------------------
?	MFRC522 mfrc522(SS_PIN, RST_PIN);
?	MFRC522::MIFARE_Key key;
?	//--------------------------------------------------
?	/* Be aware of Sector Trailer Blocks */
?	int blockNum = 4;
?	byte block_data[16];
?	/* Create array to read data from Block */
?	/* Length of buffer should be 4 Bytes
?	more than the size of Block (16 Bytes) */
?	byte bufferLen = 18;
?	byte readBlockData[18];
?	//--------------------------------------------------
?	MFRC522::StatusCode status;
?	//--------------------------------------------------
?	?
?	?
?	?
?	void setup()
?	{
?	//------------------------------------------------------
?	//Initialize serial communications with PC
?	Serial.begin(9600);
?	//------------------------------------------------------
?	//Initialize SPI bus
?	SPI.begin();
?	//------------------------------------------------------
?	//Initialize MFRC522 Module
?	mfrc522.PCD_Init();
?	Serial.println("Scan a MIFARE 1K Tag to write data...");
?	//------------------------------------------------------
?	}
?	?
?	?
?	?
?	/****************************************************************************************************
?	* loop() function
?	****************************************************************************************************/
?	void loop()
?	{
?	//------------------------------------------------------------------------------
?	/* 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;
?	}
?	//------------------------------------------------------------------------------
?	/* 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;}
?	//------------------------------------------------------------------------------
?	Serial.print("\n");
?	Serial.println("Card Detected");
?	/* Print UID of the Card */
?	Serial.print(F("Card UID:"));
?	for (byte i = 0; i < mfrc522.uid.size; i++){
?	Serial.print(mfrc522.uid.uidByte[i] < 0x10 ? " 0" : " ");
?	Serial.print(mfrc522.uid.uidByte[i], HEX);
?	}
?	Serial.print("\n");
?	/* Print type of card (for example, MIFARE 1K) */
?	Serial.print(F("PICC type: "));
?	MFRC522::PICC_Type piccType = mfrc522.PICC_GetType(mfrc522.uid.sak);
?	Serial.println(mfrc522.PICC_GetTypeName(piccType));
?	?
?	------------------------------------------------------------------------------
?	blockNum =4;
?	toBlockDataArray("211EC206"); //ID
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =5;
?	toBlockDataArray("Madhumithra"); //First Name
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =6;
?	toBlockDataArray("S"); //Last Name
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =8;
?	toBlockDataArray("Shanmugavel.M"); //Father Name
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =9;
?	toBlockDataArray("24-09-2003"); //Date of Birth
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =10;
?	toBlockDataArray("8526267629"); //Phone Number
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	blockNum =12;
?	toBlockDataArray("Pollachi"); //Address
?	WriteDataToBlock(blockNum, block_data);
?	ReadDataFromBlock(blockNum, readBlockData);
?	dumpSerial(blockNum, readBlockData);
?	?
?	//tone(BUZZER, 1000, 1000);
?	}
?	?
?	?
?	?
?	/****************************************************************************************************
?	* Writ() function
?	****************************************************************************************************/
?	void WriteDataToBlock(int blockNum, byte blockData[])
?	{
?	Serial.print("Writing data on block ");
?	Serial.print(blockNum);
?	//------------------------------------------------------------------------------
?	/* Authenticating the desired data block for write access using Key A */
?	status = mfrc522.PCD_Authenticate(MFRC522::PICC_CMD_MF_AUTH_KEY_A, blockNum, &key, &(mfrc522.uid));
?	if (status != MFRC522::STATUS_OK){
?	Serial.print("Authentication failed for Write: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	//------------------------------------------------------------------------------
?	else {
?	Serial.println("Authentication success");
?	}
?	//------------------------------------------------------------------------------
?	/* Write data to the block */
?	status = mfrc522.MIFARE_Write(blockNum, blockData, 16);
?	if (status != MFRC522::STATUS_OK) {
?	Serial.print("Writing to Block failed: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	else
?	{Serial.println("Data was written into Block successfully");}
?	//------------------------------------------------------------------------------
?	}
?	?
?	?
?	?
?	?
?	?
?	/****************************************************************************************************
?	* ReadDataFromBlock() function
?	****************************************************************************************************/
?	void ReadDataFromBlock(int blockNum, byte readBlockData[])
?	{
?	Serial.print("Reading data from block ");
?	Serial.println(blockNum);
?	//------------------------------------------------------------------------------
?	/* 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));
?	//------------------------------------------------------------------------------
?	if (status != MFRC522::STATUS_OK){
?	Serial.print("Authentication failed for Read: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	else {
?	Serial.println("Authentication success");
?	}
?	//------------------------------------------------------------------------------
?	/* Reading data from the Block */
?	status = mfrc522.MIFARE_Read(blockNum, readBlockData, &bufferLen);
?	if (status != MFRC522::STATUS_OK){
?	Serial.print("Reading failed: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	else {
?	Serial.println("Block was read successfully");
?	}
?	//------------------------------------------------------------------------------
?	}
?	?
?	?
?	?
?	/****************************************************************************************************
?	* dumpSerial() function
?	****************************************************************************************************/
?	void dumpSerial(int blockNum, byte blockData[])
?	{
?	Serial.print("\n");
?	Serial.print("Data in Block:");
?	Serial.print(blockNum);
?	Serial.print(" --> ");
?	for (int j=0 ; j<16 ; j++){
?	Serial.write(readBlockData[j]);
?	}
?	Serial.print("\n");Serial.print("\n");
?	}
?	?
?	?
?	/****************************************************************************************************
?	* dumpSerial() function
?	****************************************************************************************************/
?	void toBlockDataArray(String str)
?	{
?	byte len = str.length();
?	if(len > 16) len = 16;
?	for (byte i = 0; i < len; i++) block_data[i] = str[i];
?	for (byte i = len; i < 16; i++) block_data[i] = ' ';
?	}

RFID发布代码

阿杜诺

?	#include
?	#include
?	#include
?	#include
?	#include
?	?
?	#include
?	#include
?	LiquidCrystal_I2C lcd(0x27, 16, 2);
?	//---------------------------------------------------------------------------------------------------------
?	// Enter Google Script Deployment ID:
?	const char *GScriptId = "AKfycbwTtq4rcL8zUaB8rjExY9KYo26q_n0hVqkiEdjS9YEBtfRg5C80OWvEVK2Hv5YUEj8ivw";
?	//---------------------------------------------------------------------------------------------------------
?	// Enter network credentials:
?	const char* ssid = "ECE";
?	const char* password = "62806280";
?	//---------------------------------------------------------------------------------------------------------
?	// 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, 10, 12};
?	#define total_blocks(sizeof(blocks) / sizeof(blocks[0]))
?	//------------------------------------------------------------
?	#define RST_PIN0//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("Connecting to");
?	lcd.setCursor(0,1); //col=0 row=0
?	lcd.print("WiFi...");
?	//----------------------------------------------------------
?	// Connect to WiFi
?	WiFi.begin(ssid, password);
?	Serial.print("Connecting to ");
?	Serial.print(ssid); Serial.println(" ...");
?	?
?	while (WiFi.status() != WL_CONNECTED) {
?	delay(1000);
?	Serial.print(".");
?	}
?	Serial.println('\n');
?	Serial.println("Connection established!");
?	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("Connecting to");
?	lcd.setCursor(0,1); //col=0 row=0
?	lcd.print("Google ");
?	delay(5000);
?	//----------------------------------------------------------
?	Serial.print("Connecting to ");
?	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 = "Connected. OK";
?	Serial.println(msg);
?	lcd.clear();
?	lcd.setCursor(0,0); //col=0 row=0
?	lcd.print(msg);
?	delay(2000);
?	break;
?	}
?	//*************************************************
?	else
?	Serial.println("Connection failed. Retrying...");
?	//*************************************************
?	}
?	//----------------------------------------------------------
?	if (!flag){
?	//____________________________________________
?	lcd.clear();
?	lcd.setCursor(0,0); //col=0 row=0
?	lcd.print("Connection fail");
?	//____________________________________________
?	Serial.print("Could not connect to server: ");
?	Serial.println(host);
?	delay(5000);
?	return;
?	//____________________________________________
?	}
?	//----------------------------------------------------------
?	delete client;// delete HTTPSRedirect object
?	client = nullptr; // delete HTTPSRedirect object
?	//----------------------------------------------------------
?	}
?	?
?	/****************************************************************************************************
?	* loop Function
?	****************************************************************************************************/
?	void loop() {
?	//----------------------------------------------------------------
?	static bool flag = false;
?	if (!flag){
?	client = new HTTPSRedirect(httpsPort);
?	client->setInsecure();
?	flag = true;
?	client->setPrintResponseBody(true);
?	client->setContentTypeHeader("application/json");
?	}
?	if (client != nullptr){
?	if (!client->connected())
?	{client->connect(host, httpsPort);}
?	}
?	else{Serial.println("Error creating client object!");}
?	//----------------------------------------------------------------
?	lcd.clear();
?	lcd.setCursor(0,0); //col=0 row=0
?	lcd.print("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("Reading last data from RFID..."));
?	//----------------------------------------------------------------
?	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 + ",";
?	}
?	}
?	//----------------------------------------------------------------
?	// Create json object string to send to Google Sheets
?	// values = """ + value0 + "," + value1 + "," + value2 + ""}"
?	payload = payload_base + values;
?	//----------------------------------------------------------------
?	lcd.clear();
?	lcd.setCursor(0,0); //col=0 row=0
?	lcd.print("Publishing Data");
?	lcd.setCursor(0,1); //col=0 row=0
?	lcd.print("Please Wait...");
?	//----------------------------------------------------------------
?	// Publish data to Google Sheets
?	Serial.println("Publishing data...");
?	Serial.println(payload);
?	if(client->POST(url, host, payload)){
?	// do stuff here if publish was successful
?	lcd.clear();
?	lcd.setCursor(0,0); //col=0 row=0
?	lcd.print("Student ID: "+student_id);
?	lcd.setCursor(0,1); //col=0 row=0
?	lcd.print("Present");
?	}
?	//----------------------------------------------------------------
?	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("Failed.");
?	lcd.setCursor(0,1); //col=0 row=0
?	lcd.print("Try Again");
?	}
?	//----------------------------------------------------------------
?	// a delay of several seconds is required before publishing again
?	delay(5000);
?	tone(BUZZER, 1000, 1000);
?	}
?	?
?	?
?	/****************************************************************************************************
?	*
?	****************************************************************************************************/
?	/****************************************************************************************************
?	* 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("Authentication failed for Read: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	//----------------------------------------------------------------------------
?	else {
?	Serial.println("Authentication success");
?	}
?	//----------------------------------------------------------------------------
?	/* Reading data from the Block */
?	status = mfrc522.MIFARE_Read(blockNum, readBlockData, &bufferLen);
?	if (status != MFRC522::STATUS_OK) {
?	Serial.print("Reading failed: ");
?	Serial.println(mfrc522.GetStatusCodeName(status));
?	return;
?	}
?	//----------------------------------------------------------------------------
?	else {
?	readBlockData[16] = ' ';
?	readBlockData[17] = ' ';
?	Serial.println("Block was read successfully");
?	}
?	//----------------------------------------------------------------------------
?	}