產業專班 作業2 (使用 WOKWI 模擬 RFID UID )

產業專班 作業2 (使用  WOKWI 模擬 RFID UID ) 

(執行時 需先按 

建立LED資料庫   建立RFID資料庫)

WOKWI 程式

#include <ArduinoMqttClient.h>

#include <WiFi.h>

//MFRC522 程式庫  模擬mfrc522 定期送出卡號

//#include <SPI.h>

//#include <MFRC522.h>

//#define LED 13      //定義LED接腳

int LED = 13;

char ssid[]="Wokwi-GUEST";

char pass[]="";

WiFiClient wifiClient;

MqttClient mqttClient(wifiClient);

//const char broker[] = "test.mosquitto.org";

const char broker[] = "broker.mqtt-dashboard.com";

int        port     = 1883;

String json = "";

int id[10]={0,0,0,0,0,0,0,0,0,0};

const char *SubTopic1 = "alex9ufo/2024/RFID/LED_control";

const char *PubTopic2 = "alex9ufo/2024/RFID/LED_status";

const char *PubTopic3 = "alex9ufo/2024/RFID/RFID_UID";

//const char *PubTopic4 = "alex9ufo/2024/RFID/RFID_PICC";

const char willTopic[] = "alex9ufo/2024/RFID/Starting";

//======================================================

//#define SS_PIN       5        // 晶片選擇腳位

//MFRC522 mfrc522(SS_PIN, RST_PIN);    // 建立MFRC522物件

//MFRC522::MIFARE_Key key;  // 儲存金鑰

//MFRC522::StatusCode status;

//===========================================================

//布林代數 LED狀態 是否連上網路ESP32 ready ?

bool ledState = false;

bool atwork = false;

bool Send = false;  //true

String LEDjson = "";

int Count= 0;

bool Flash = false;  //true

bool Timer = false;  //true

unsigned long previousMillis = 0;

unsigned long interval = 30000;

//===========================================================

String decimalToHex(int decimal) {

  // Create an empty string to store the hexadecimal value.

  String hex = "";

 

  // Loop through each digit of the hexadecimal value.

  while (decimal > 0) {

    // Get the remainder when dividing the decimal value by 16.

    int remainder = decimal % 16;

 

    // Convert the remainder to its hexadecimal representation.

    char hexDigit;

    if (remainder < 10) {

      hexDigit = '0' + remainder;

    } else {

      hexDigit = 'A' + remainder - 10;

    }

 

    // Add the hexadecimal digit to the front of the string.

    hex = hexDigit + hex;

 

    // Divide the decimal value by 16 to move to the next digit.

    decimal /= 16;

  }

 

  // Return the hexadecimal value.

  return hex;

}

//===========================================================

void onMqttMessage(int messageSize) {

  // we received a message, print out the topic and contents

  Serial.print("Received a message with topic '");

  Serial.print(mqttClient.messageTopic());

  String Topic= mqttClient.messageTopic();

  Serial.print("', duplicate = ");

  Serial.print(mqttClient.messageDup() ? "true" : "false");

  Serial.print(", QoS = ");

  Serial.print(mqttClient.messageQoS());

  Serial.print(", retained = ");

  Serial.print(mqttClient.messageRetain() ? "true" : "false");

  Serial.print("', length ");

  Serial.print(messageSize);

  Serial.println(" bytes:");

  String message="";

  // use the Stream interface to print the contents

  while (mqttClient.available()) {

    //Serial.print((char)mqttClient.read());

    message += (char)mqttClient.read();

  }

  Serial.println(message);

  message.trim();

  Topic.trim();

  if (Topic=="alex9ufo/2024/RFID/LED_control") {

  if (message == "on") {

    digitalWrite(LED, LOW);  // Turn on the LED

    //ledState = true;  //ledState = ture HIGH

    //設定 各個 旗號

    LEDjson ="ON";

    Send = true ;

    Serial.print("LED =");

    Serial.println(LEDjson);

  }

  if (message == "off" ) {

    digitalWrite(LED, HIGH); // Turn off the LED

    //ledState = false; //ledState = false LOW

    LEDjson ="OFF";

    Send = true ;

    Serial.print("LED =");

    Serial.println(LEDjson);

  }

 

  if (message == "flash" ) {

    digitalWrite(LED, HIGH); // Turn off the LED

    Flash = true;

    Timer = false;

    LEDjson ="FLASH";

    Send = true ;  

    Serial.print("LED =");

    Serial.println(LEDjson);      

  }

  if (message == "timer" ) {

    digitalWrite(LED, LOW); // Turn off the LED

    Flash = false;

    Timer = true;

    LEDjson ="TIMER";

    Send = true ;

    Count= 11;

    Serial.print("LED =");

    Serial.println(LEDjson);  

  }

 

    Serial.println();

    Serial.println("-----------------------");

  }  

}

//===========================================================

String printHex(byte *buffer, byte bufferSize) {

      String id = "";

      for (byte i = 0; i < bufferSize; i++) {

        id += buffer[i] < 0x10 ? "0" : "";

        id += String(buffer[i], HEX);

        id +=" ";

      }

      return id;

}

//===========================================================

//副程式  setup wifi

void setup_wifi() {

  delay(10);

  // We start by connecting to a WiFi network

  Serial.println();

  Serial.print("Connecting to ");

  Serial.println(ssid);     //print ssid

  WiFi.begin(ssid, pass);  //初始化WiFi 函式庫並回傳目前的網路狀態

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

    delay(500);

    Serial.print(".");

  }   //假設 wifi 未連接 show ………

  Serial.println("");

  Serial.println("WiFi connected");

  Serial.println("IP address: ");

  Serial.println(WiFi.localIP());

}  

//===========================================================

//判斷 旗號Flash , Timer 是否為真

void LED_Message() {

  //判斷 旗號 Flash / timer  是否為真 ? 閃爍 定時

 

  if (Flash){

    digitalWrite(LED, !digitalRead(LED));

    delay(500);

    if (digitalRead(LED))

      ledState = true;

    else

      ledState = false;

  } //(Flash)

  if (Timer) {

    digitalWrite(LED, LOW);

    delay(500);

    if (digitalRead(LED))

      ledState = true;

    else

      ledState = false;

  Count=Count-1;

  if (Count == 0 ){

    Timer=false;

    digitalWrite(LED, HIGH);

    ledState = false;

    }

  } //(Timer)

 

 

  ////判斷 旗號 Send 是否為真 回傳MQTT訊息到MQTT Broker　

  if (Send) {

    // Convert JSON string to character array

    Serial.print("Publish message: ");

    Serial.println(LEDjson);

    LEDjson.trim();

    bool retained = false;

    int qos = 1;

    bool dup = false;

   

    // Publish JSON character array to MQTT topic

    mqttClient.beginMessage(PubTopic2,  LEDjson.length(), retained, qos, dup);  //LED Status

    mqttClient.print(LEDjson);

    mqttClient.endMessage();

    Send = false;    //處理過後 旗號 Send為假

  }

}

//===========================================================

void setup() {

  pinMode(LED, OUTPUT);

  digitalWrite(LED, HIGH);  // Turn off the LED initially

  //Initialize serial and wait for port to open:

  Serial.begin(115200);   // Initialize serial communications with the PC

  while (!Serial);    // Do nothing if no serial port is opened (added for Arduinos based on ATMEGA32U4)

 

  setup_wifi();

  Serial.println("You're connected to the network");

  Serial.println();

 

  String willPayload = "ESP32 Start working....!";

  bool willRetain = true;

  int willQos = 1;

  mqttClient.beginWill(willTopic, willPayload.length(), willRetain, willQos);

  mqttClient.print(willPayload);

  mqttClient.endWill();

  Serial.print("Attempting to connect to the MQTT broker: ");

  Serial.println(broker);

  if (!mqttClient.connect(broker, port)) {

    Serial.print("MQTT connection failed! Error code = ");

    Serial.println(mqttClient.connectError());

    while (1);

  }

  Serial.println("You're connected to the MQTT broker!");

  Serial.println();

  // set the message receive callback

  mqttClient.onMessage(onMqttMessage);

  Serial.print("Subscribing to topic: ");

  Serial.println(SubTopic1);

 

  // subscribe to a topic

  // the second parameter sets the QoS of the subscription,

  // the the library supports subscribing at QoS 0, 1, or 2

  int subscribeQos = 1;

  mqttClient.subscribe(SubTopic1, subscribeQos);

  Serial.println();

  //SPI.begin();      // Init SPI bus

  //mfrc522.PCD_Init();   // Init MFRC522

  delay(4);       // Optional delay. Some board do need more time after init to be ready, see Readme

  //mfrc522.PCD_DumpVersionToSerial();  // Show details of PCD - MFRC522 Card Reader details

  //Serial.println(F("Scan PICC to see UID, SAK, type, and data blocks..."));

}

//===========================================================

void loop() {

 

  // call poll() regularly to allow the library to receive MQTT messages and

  // send MQTT keep alives which avoids being disconnected by the broker

  mqttClient.poll();

 

  LED_Message();

  // to avoid having delays in loop, we'll use the strategy from BlinkWithoutDelay

  // see: File -> Examples -> 02.Digital -> BlinkWithoutDelay for more info

  unsigned long currentMillis = millis();

 // if (mfrc522.PICC_IsNewCardPresent() && mfrc522.PICC_ReadCardSerial()) {

   

  //   Serial.println(F("Please scan MIFARE Classic card..."));

  // 確認是否有新卡片

   

  //  byte *id = mfrc522.uid.uidByte;   // 取得卡片的UID

  //  byte idSize = mfrc522.uid.size;   // 取得UID的長度

  //  String Type;

  //  Serial.print("PICC type: ");      // 顯示卡片類型

  // 根據卡片回應的SAK值（mfrc522.uid.sak）判斷卡片類型

  //  MFRC522::PICC_Type piccType = mfrc522.PICC_GetType(mfrc522.uid.sak);

  //  Type= mfrc522.PICC_GetTypeName(piccType);

  //  Serial.println(mfrc522.PICC_GetTypeName(piccType));

  //  Serial.print("UID Size: ");       // 顯示卡片的UID長度值

  //  Serial.println(idSize);

  //  for (byte i = 0; i < idSize; i++) {  // 逐一顯示UID碼

  //    Serial.print("id[");

  //    Serial.print(i);

  //    Serial.print("]: ");

  //    Serial.println(id[i], HEX);       // 以16進位顯示UID值

  //  }

 

  if (currentMillis - previousMillis >=interval) {

  for(int i=0; i < 5; i++)

  {

    id[i] = random(255);

    Serial.println(id[i], HEX);       // 以16進位顯示UID值

    Serial.print(" ");  

  }

    Serial.println();

    json="";

    String json1="";

    //String json1=printHex(mfrc522.uid.uidByte, mfrc522.uid.size);

   

    for (byte i = 0; i < 6; i++) {

      json1 += id[i] < 0x10 ? "0" : "";

      json1 += String(id[i], HEX);

      json1 +=" ";

    }

    json1.toUpperCase();

    json = json + json1;

    json.trim();

    bool retained = false;

    int qos = 1;

    bool dup = false;

    mqttClient.beginMessage(PubTopic3,  json.length(), retained, qos, dup);

    mqttClient.print(json);

    mqttClient.endMessage();

   

    Serial.println();

    previousMillis = currentMillis;

    // Dump debug info about the card; PICC_HaltA() is automatically called

    // 令卡片進入停止狀態

    // Dump debug info about the card; PICC_HaltA() is automatically called

    // mfrc522.PICC_DumpToSerial(&(mfrc522.uid));

   

    //mfrc522.PICC_HaltA();

    //mfrc522.PCD_StopCrypto1(); // stop encryption on PCD

  }

}

////===========================================================

Node-Red 程式

[ { "id": "de94877be821c022", "type": "tab", "label": "2024產專班 作業2 ", "disabled": false, "info": "", "env": [] }, { "id": "d8886d19ed817b4d", "type": "sqlite", "z": "de94877be821c022", "mydb": "f5c97c74cc496505", "sqlquery": "msg.topic", "sql": "", "name": "LED_STATUS", "x": 540, "y": 380, "wires": [ [ "b693b296bc9dbb05" ] ] }, { "id": "3d78470fe40a253b", "type": "function", "z": "de94877be821c022", "name": "CREATE　DATABASE", "func": "//CREATE TABLE LEDSTATUS (\n//id INTEGER,\n//STATUS TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n//CREATE TABLE LEDSTATUS (id INTEGER,STATUS TEXT,Date DATE,Time TIME,PRIMARY KEY (id));\nmsg.topic = \"CREATE TABLE LEDSTATUS (id INTEGER,STATUS TEXT,Date DATE,Time TIME,PRIMARY KEY (id))\";\nreturn msg;\n", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 320, "y": 380, "wires": [ [ "d8886d19ed817b4d" ] ] }, { "id": "b5aa34b08dd0e6c5", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 10, "width": 3, "height": 1, "passthru": false, "label": "建立LED資料庫", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "建立資料庫", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 100, "y": 380, "wires": [ [ "3d78470fe40a253b", "6403be567fef0c83" ] ] }, { "id": "2ad08ae5e4938728", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 1, "width": 1, "height": 1, "passthru": false, "label": "ON", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "on", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 70, "y": 20, "wires": [ [ "9260190ef89016b8", "3f94a3388af27988", "9ea8d029f3defa26" ] ] }, { "id": "8c922987b04504e5", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 2, "width": 1, "height": 1, "passthru": false, "label": "OFF", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "off", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 70, "y": 60, "wires": [ [ "9260190ef89016b8", "3f94a3388af27988", "9ea8d029f3defa26" ] ] }, { "id": "028329a10f91c6ba", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 3, "width": 2, "height": 1, "passthru": false, "label": "TIMER", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "timer", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 80, "y": 100, "wires": [ [ "9260190ef89016b8", "3f94a3388af27988", "9ea8d029f3defa26" ] ] }, { "id": "39d1fb8a26430fbd", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 4, "width": 2, "height": 1, "passthru": false, "label": "FLASH", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "flash", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 80, "y": 140, "wires": [ [ "9260190ef89016b8", "3f94a3388af27988", "9ea8d029f3defa26" ] ] }, { "id": "2289c4addb72da83", "type": "function", "z": "de94877be821c022", "name": "INSERT", "func": "var Today = new Date();\nvar yyyy = Today.getFullYear(); //年\nvar MM = Today.getMonth()+1; //月\nvar dd = Today.getDate(); //日\nvar h = Today.getHours(); //時\nvar m = Today.getMinutes(); //分\nvar s = Today.getSeconds(); //秒\nif(MM<10)\n{\n MM = '0'+MM;\n}\n\nif(dd<10)\n{\n dd = '0'+dd;\n}\n\nif(h<10)\n{\n h = '0'+h;\n}\n\nif(m<10)\n{\n m = '0' + m;\n}\n\nif(s<10)\n{\n s = '0' + s;\n}\nvar var_date = yyyy+'/'+MM+'/'+dd;\nvar var_time = h+':'+m+':'+s;\n\nvar myLED = msg.payload;\n\n\nmsg.topic = \"INSERT INTO LEDSTATUS ( STATUS , Date , Time ) VALUES ($myLED, $var_date , $var_time ) \" ;\nmsg.payload = [myLED, var_date , var_time ]\nreturn msg;\n\n\n//INSERT INTO LEDSTATUS (\n//id INTEGER,\n//STATUS TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 400, "y": 240, "wires": [ [ "e88e4e11603904f6" ] ] }, { "id": "9260190ef89016b8", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 245, "y": 80, "wires": [], "l": false }, { "id": "e88e4e11603904f6", "type": "sqlite", "z": "de94877be821c022", "mydb": "f5c97c74cc496505", "sqlquery": "msg.topic", "sql": "", "name": "LED_STATUS", "x": 560, "y": 240, "wires": [ [ "589b1aff948b3263", "110bac143ce4ff27" ] ] }, { "id": "b693b296bc9dbb05", "type": "debug", "z": "de94877be821c022", "name": "debug ", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 690, "y": 380, "wires": [] }, { "id": "589b1aff948b3263", "type": "debug", "z": "de94877be821c022", "name": "debug ", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 750, "y": 240, "wires": [] }, { "id": "7db7512aa212e480", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 9, "width": 4, "height": 1, "passthru": false, "label": "檢視資料庫資料", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "檢視資料", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 100, "y": 320, "wires": [ [ "110bac143ce4ff27", "6403be567fef0c83" ] ] }, { "id": "110bac143ce4ff27", "type": "function", "z": "de94877be821c022", "name": "檢視資料", "func": "//INSERT INTO LEDSTATUS (\n//id INTEGER,\n//STATUS TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n\n//SELECT * FROM LEDSTATUS ORDER BY id DESC LIMIT 50;\n\nmsg.topic = \"SELECT * FROM LEDSTATUS ORDER BY id DESC LIMIT 50\";\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 400, "y": 320, "wires": [ [ "f1ef1d5f3e800de8" ] ] }, { "id": "29be5aad6abe5c63", "type": "ui_table", "z": "de94877be821c022", "group": "1ce7dd030081ad24", "name": "", "order": 7, "width": 10, "height": 10, "columns": [], "outputs": 0, "cts": false, "x": 730, "y": 320, "wires": [] }, { "id": "f1ef1d5f3e800de8", "type": "sqlite", "z": "de94877be821c022", "mydb": "f5c97c74cc496505", "sqlquery": "msg.topic", "sql": "", "name": "LED_STATUS", "x": 580, "y": 320, "wires": [ [ "29be5aad6abe5c63" ] ] }, { "id": "39c7f86f462c38f1", "type": "sqlite", "z": "de94877be821c022", "mydb": "f5c97c74cc496505", "sqlquery": "msg.topic", "sql": "", "name": "LED_STATUS", "x": 860, "y": 440, "wires": [ [ "d1bdc104e5232dd8" ] ] }, { "id": "93f502d303c88e81", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "order": 8, "width": 3, "height": 1, "passthru": false, "label": "刪除所有資料 ", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "刪除所有資料 ", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 100, "y": 440, "wires": [ [ "9559446ac1a4dd97", "d26bd8f6c50cf636" ] ] }, { "id": "b4c9b1e0bd818bb8", "type": "function", "z": "de94877be821c022", "name": "DELETE ALL DATA", "func": "//CREATE TABLE LEDSTATUS (\n//id INTEGER,\n//STATUS TEXT,\n//Date DATE,\n//Time TIME,\n//PRIMARY KEY (id)\n//);\n//CREATE TABLE LEDSTATUS (id INTEGER,STATUS TEXT,Date DATE,Time TIME,PRIMARY KEY (id));\nmsg.topic = \"DELETE from LEDSTATUS\";\nreturn msg;\n", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 670, "y": 440, "wires": [ [ "39c7f86f462c38f1" ] ] }, { "id": "9559446ac1a4dd97", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 225, "y": 500, "wires": [], "l": false }, { "id": "d26bd8f6c50cf636", "type": "ui_toast", "z": "de94877be821c022", "position": "prompt", "displayTime": "3", "highlight": "", "sendall": true, "outputs": 1, "ok": "OK", "cancel": "Cancel", "raw": true, "className": "", "topic": "", "name": "", "x": 290, "y": 440, "wires": [ [ "6041efbb6dfef689" ] ] }, { "id": "6041efbb6dfef689", "type": "function", "z": "de94877be821c022", "name": "OK or Cancel", "func": "var topic=msg.payload;\nif (topic==\"\"){\n return [msg,null];\n \n}\nif (topic==\"Cancel\"){\n return [null,msg];\n \n}\nreturn msg;", "outputs": 2, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 460, "y": 440, "wires": [ [ "b4c9b1e0bd818bb8" ], [] ] }, { "id": "6403be567fef0c83", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "1ce7dd030081ad24", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 245, "y": 340, "wires": [], "l": false }, { "id": "d1bdc104e5232dd8", "type": "link out", "z": "de94877be821c022", "name": "link out 57", "mode": "link", "links": [ "87b1fdf101776a2f" ], "x": 845, "y": 380, "wires": [] }, { "id": "87b1fdf101776a2f", "type": "link in", "z": "de94877be821c022", "name": "link in 55", "links": [ "d1bdc104e5232dd8" ], "x": 915, "y": 380, "wires": [ [ "110bac143ce4ff27" ] ] }, { "id": "3f94a3388af27988", "type": "mqtt out", "z": "de94877be821c022", "name": "Control LED out", "topic": "alex9ufo/2024/RFID/LED_control", "qos": "1", "retain": "true", "respTopic": "", "contentType": "", "userProps": "", "correl": "", "expiry": "", "broker": "603bb104.d6134", "x": 280, "y": 20, "wires": [] }, { "id": "da7e7c410844086a", "type": "mqtt in", "z": "de94877be821c022", "name": "Control LED in", "topic": "alex9ufo/2024/RFID/LED_status", "qos": "1", "datatype": "auto-detect", "broker": "603bb104.d6134", "nl": false, "rap": true, "rh": 0, "inputs": 0, "x": 100, "y": 240, "wires": [ [ "2289c4addb72da83", "55cea575c649529c" ] ] }, { "id": "49b9f4b55227af6b", "type": "comment", "z": "de94877be821c022", "name": "TABLE RFIDtable", "info": "\n//CREATE TABLE \"RFIDtable\" (\n//\t\"id\"\tINT NOT NULL,\n// \"uidname\" TEXT,\n// \"currentdate\" DATE, \n// \"currenttime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);\nmsg.topic = \"CREATE TABLE RFIDtable(id INTEGER PRIMARY KEY AUTOINCREMENT, uidname TEXT, currentdate DATE, currenttime TIME)\";\nreturn msg;\n", "x": 80, "y": 640, "wires": [] }, { "id": "12dc668a45158d33", "type": "comment", "z": "de94877be821c022", "name": "資料庫位置 C:\\Users\\User\\.node-red\\2024EX2_1.db", "info": "", "x": 190, "y": 680, "wires": [] }, { "id": "2fb1d9aa7e7a322d", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "order": 4, "width": 3, "height": 1, "passthru": false, "label": "建立RFID資料庫", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "建立資料庫", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 80, "y": 720, "wires": [ [ "20de3f201a4da6c8", "7605c0bb7b0637e4" ] ] }, { "id": "f69b58efbd541cfd", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "order": 5, "width": 4, "height": 1, "passthru": false, "label": "檢視資料庫資料", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "檢視資料", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 80, "y": 1360, "wires": [ [ "08880e70f61a5919", "a926822cc24e7e26", "1ee1c6e9e0b1ecc7" ] ] }, { "id": "e0428363e518f022", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "order": 6, "width": 3, "height": 1, "passthru": false, "label": "刪除RFID資料庫", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "刪除所有資料", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 80, "y": 1440, "wires": [ [ "9c472cfd1a059059", "08880e70f61a5919" ] ] }, { "id": "20de3f201a4da6c8", "type": "function", "z": "de94877be821c022", "name": "CREATE　DATABASE", "func": "\n\n//CREATE TABLE \"RFIDtable\" (\n//\t\"id\"\tINT NOT NULL,\n// \"uidname\" TEXT,\n// \"currentdate\" DATE, \n// \"currenttime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);\nmsg.topic = \"CREATE TABLE RFIDtable(id INTEGER PRIMARY KEY AUTOINCREMENT, uidname TEXT, currentdate DATE, currenttime TIME)\";\nreturn msg;\n", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 300, "y": 720, "wires": [ [ "af6f3e3aaa635b0b" ] ] }, { "id": "baab3664986e2095", "type": "debug", "z": "de94877be821c022", "name": "debug", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 630, "y": 1000, "wires": [] }, { "id": "72ba0c8d6992ed2e", "type": "function", "z": "de94877be821c022", "name": "INSERT", "func": "var Today = new Date();\nvar yyyy = Today.getFullYear(); //年\nvar MM = Today.getMonth()+1; //月\nvar dd = Today.getDate(); //日\nvar h = Today.getHours(); //時\nvar m = Today.getMinutes(); //分\nvar s = Today.getSeconds(); //秒\nif(MM<10)\n{\n MM = '0'+MM;\n}\n\nif(dd<10)\n{\n dd = '0'+dd;\n}\n\nif(h<10)\n{\n h = '0'+h;\n}\n\nif(m<10)\n{\n m = '0' + m;\n}\n\nif(s<10)\n{\n s = '0' + s;\n}\nvar var_date = yyyy+'/'+MM+'/'+dd;\nvar var_time = h+':'+m+':'+s;\n\nvar myRFID = flow.get('uid_temp');\n\n\nmsg.topic = \"INSERT INTO RFIDtable ( uidname , currentdate, currenttime ) VALUES ($myRFID, $var_date , $var_time ) \" ;\nmsg.payload = [myRFID, var_date , var_time ]\nreturn msg;\n\n//CREATE TABLE \"RFIDtable\" (\n//\t\"id\"\tINT NOT NULL,\n// \"uidname\" TEXT,\n// \"currentdate\" DATE, \n// \"currenttime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 320, "y": 1000, "wires": [ [ "821536d470c11949", "8f4ae6e4f835aadd" ] ] }, { "id": "ed134d22fa068cce", "type": "function", "z": "de94877be821c022", "name": "DROP　DATABASE", "func": "//DROP RFIDtable\n\nmsg.topic = \"DROP TABLE RFIDtable\" ;\nreturn msg;\n", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 640, "y": 1460, "wires": [ [ "572a42cab5fbfb24" ] ] }, { "id": "b27709c0f2739ab1", "type": "debug", "z": "de94877be821c022", "name": "", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 1050, "y": 1460, "wires": [] }, { "id": "1ee1c6e9e0b1ecc7", "type": "function", "z": "de94877be821c022", "name": "檢視資料", "func": "\n//CREATE TABLE \"RFIDtable\" (\n//\t\"id\"\tINT NOT NULL,\n// \"uidname\" TEXT,\n// \"currentdate\" DATE, \n// \"currenttime\" TIME\n//\tPRIMARY KEY(\"id\")\n//);\n\n//SELECT * FROM RFIDtable ORDER BY id DESC LIMIT 50;\n\nmsg.topic = \"SELECT * FROM RFIDtable ORDER BY id DESC LIMIT 50\";\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 720, "y": 1360, "wires": [ [ "eb7efa9b721cd725", "661c5bce45c2a306" ] ] }, { "id": "312bfc883680a182", "type": "mqtt in", "z": "de94877be821c022", "name": "RFID in", "topic": "alex9ufo/2024/RFID/RFID_UID", "qos": "2", "datatype": "auto-detect", "broker": "841df58d.ee5e98", "nl": false, "rap": true, "rh": 0, "inputs": 0, "x": 50, "y": 1080, "wires": [ [ "bd651a4cff859c90", "8e7400a11f6417cc" ] ] }, { "id": "6e2abccef79a108d", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 520, "y": 1200, "wires": [] }, { "id": "6e9fecbdbdf2efdf", "type": "function", "z": "de94877be821c022", "name": "function ", "func": "var temp= msg.payload;\nmsg.payload= \"新增一筆資料\" + temp;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 360, "y": 1160, "wires": [ [ "6e2abccef79a108d", "68c7efdc1b782bd4", "625709eb82e1bba4" ] ] }, { "id": "08880e70f61a5919", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 280, "y": 1400, "wires": [] }, { "id": "7605c0bb7b0637e4", "type": "ui_audio", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "voice": "Microsoft Hanhan - Chinese (Traditional, Taiwan)", "always": true, "x": 260, "y": 760, "wires": [] }, { "id": "dcb7ea26dfa13c02", "type": "ui_text", "z": "de94877be821c022", "group": "26999cd202d71546", "order": 2, "width": 8, "height": 1, "name": "", "label": "自動感應RFID查詢的uid", "format": "{{msg.payload}}", "layout": "row-left", "className": "", "x": 730, "y": 1160, "wires": [] }, { "id": "68c7efdc1b782bd4", "type": "function", "z": "de94877be821c022", "name": "取得UID號碼", "func": "var myRFID = flow.get('uid_temp');\nmsg.payload=myRFID;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 530, "y": 1160, "wires": [ [ "dcb7ea26dfa13c02" ] ] }, { "id": "821536d470c11949", "type": "function", "z": "de94877be821c022", "name": "增加 日期 時間", "func": "var ms1=msg.payload[0];\nvar ms2=msg.payload[1];\nvar ms3=msg.payload[2];\n\nmsg.payload=\"新增一筆:\"+ms1+\", 日期: \"+ms2+\", 時間:\"+ms3;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 520, "y": 1060, "wires": [ [ "2cd90c96fda0f25d" ] ] }, { "id": "2cd90c96fda0f25d", "type": "function", "z": "de94877be821c022", "name": "Set Line API ", "func": "msg.headers = {'content-type':'application/x-www-form-urlencoded','Authorization':'Bearer A4wwPNh2WqB7dlfeQyyIAwtggn1kfZSI5LkkCdia1gB'};\nmsg.payload = {\"message\":msg.payload};\nreturn msg;\n\n//oR7KdXvK1eobRr2sRRgsl4PMq23DjDlhfUs96SyUBZu", "outputs": 1, "noerr": 0, "x": 690, "y": 1060, "wires": [ [ "b948371d0bc949ce" ] ] }, { "id": "b948371d0bc949ce", "type": "http request", "z": "de94877be821c022", "name": "", "method": "POST", "ret": "txt", "paytoqs": false, "url": "https://notify-api.line.me/api/notify", "tls": "", "persist": false, "proxy": "", "authType": "", "x": 840, "y": 1060, "wires": [ [ "cb7871ed5d68fd11" ] ] }, { "id": "cb7871ed5d68fd11", "type": "debug", "z": "de94877be821c022", "name": "debug ", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 970, "y": 1060, "wires": [] }, { "id": "7688ecaf7ac9454e", "type": "comment", "z": "de94877be821c022", "name": "Line Notify Message ", "info": "", "x": 830, "y": 1020, "wires": [] }, { "id": "84f432e5e44c570e", "type": "ui_table", "z": "de94877be821c022", "group": "26999cd202d71546", "name": "", "order": 3, "width": 10, "height": 10, "columns": [], "outputs": 0, "cts": false, "x": 1030, "y": 1360, "wires": [] }, { "id": "9c472cfd1a059059", "type": "ui_toast", "z": "de94877be821c022", "position": "prompt", "displayTime": "3", "highlight": "", "sendall": true, "outputs": 1, "ok": "OK", "cancel": "Cancel", "raw": true, "className": "", "topic": "", "name": "", "x": 270, "y": 1460, "wires": [ [ "4c972d2605a20318" ] ] }, { "id": "4c972d2605a20318", "type": "function", "z": "de94877be821c022", "name": "OK or Cancel", "func": "var topic=msg.payload;\nif (topic==\"\"){\n return [msg,null];\n \n}\nif (topic==\"Cancel\"){\n return [null,msg];\n \n}\nreturn msg;", "outputs": 2, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 440, "y": 1460, "wires": [ [ "ed134d22fa068cce" ], [] ] }, { "id": "14396fb8a2b77316", "type": "link out", "z": "de94877be821c022", "name": "link out 58", "mode": "link", "links": [ "c19329df615520bf" ], "x": 605, "y": 960, "wires": [] }, { "id": "a926822cc24e7e26", "type": "ui_toast", "z": "de94877be821c022", "position": "top right", "displayTime": "3", "highlight": "", "sendall": true, "outputs": 0, "ok": "OK", "cancel": "Cancel", "raw": false, "className": "", "topic": "", "name": "", "x": 290, "y": 1320, "wires": [] }, { "id": "c4f1192fe4e205df", "type": "debug", "z": "de94877be821c022", "name": "debug", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 610, "y": 720, "wires": [] }, { "id": "bd651a4cff859c90", "type": "ui_toast", "z": "de94877be821c022", "position": "top right", "displayTime": "3", "highlight": "", "sendall": true, "outputs": 0, "ok": "OK", "cancel": "Cancel", "raw": false, "className": "", "topic": "", "name": "", "x": 170, "y": 1140, "wires": [] }, { "id": "af6f3e3aaa635b0b", "type": "sqlite", "z": "de94877be821c022", "mydb": "f87c808cc786ae80", "sqlquery": "msg.topic", "sql": "", "name": "RFID dB", "x": 480, "y": 720, "wires": [ [ "c4f1192fe4e205df" ] ] }, { "id": "8f4ae6e4f835aadd", "type": "sqlite", "z": "de94877be821c022", "mydb": "f87c808cc786ae80", "sqlquery": "msg.topic", "sql": "", "name": "RFID dB", "x": 500, "y": 1000, "wires": [ [ "14396fb8a2b77316", "baab3664986e2095" ] ] }, { "id": "eb7efa9b721cd725", "type": "sqlite", "z": "de94877be821c022", "mydb": "f87c808cc786ae80", "sqlquery": "msg.topic", "sql": "", "name": "RFID dB", "x": 860, "y": 1360, "wires": [ [ "84f432e5e44c570e" ] ] }, { "id": "572a42cab5fbfb24", "type": "sqlite", "z": "de94877be821c022", "mydb": "f87c808cc786ae80", "sqlquery": "msg.topic", "sql": "", "name": "RFID dB", "x": 820, "y": 1460, "wires": [ [ "b27709c0f2739ab1", "1ee1c6e9e0b1ecc7" ] ] }, { "id": "661c5bce45c2a306", "type": "debug", "z": "de94877be821c022", "name": "debug 299", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 870, "y": 1320, "wires": [] }, { "id": "100e89592bf1117b", "type": "ui_button", "z": "de94877be821c022", "name": "", "group": "26999cd202d71546", "order": 1, "width": 2, "height": 1, "passthru": false, "label": "模擬RFID UID(不從ESP32)", "tooltip": "", "color": "", "bgcolor": "", "className": "", "icon": "", "payload": "on", "payloadType": "str", "topic": "topic", "topicType": "msg", "x": 120, "y": 840, "wires": [ [ "dd7d54f37fadf881" ] ] }, { "id": "dd7d54f37fadf881", "type": "function", "z": "de94877be821c022", "name": "模擬RFID UID", "func": "const MIN = 0;\nconst MAX = 255;\nvar hex_v=0;\n//The maximum is exclusive and the minimum is inclusive\nfunction getRandomInt(min = MIN, max = MAX) {\n min = Math.ceil(min);\n max = Math.floor(max);\n return Math.floor(Math.random() * (max - min)) + min;\n}\n\nfunction decToHex(dec) {\n hex_v= dec.toString(16);\n if(hex_v<10)\n {\n hex_v= '0'+hex_v;\n }\n return hex_v;\n}\n\nvar no1=getRandomInt(min = MIN, max = MAX);\nvar no2=getRandomInt(min = MIN, max = MAX);\nvar no3=getRandomInt(min = MIN, max = MAX);\nvar no4=getRandomInt(min = MIN, max = MAX);\nvar no5=getRandomInt(min = MIN, max = MAX);\nvar no6=getRandomInt(min = MIN, max = MAX);\nvar no7=getRandomInt(min = MIN, max = MAX);\nvar no8=getRandomInt(min = MIN, max = MAX);\n\nvar var1=decToHex(no1);\nvar var2=decToHex(no2);\nvar var3=decToHex(no3);\nvar var4=decToHex(no4);\nvar var5=decToHex(no5);\nvar var6=decToHex(no6);\nvar var7=decToHex(no7);\nvar var8=decToHex(no8);\n\nmsg.payload=[var1,var2,var3,var4];\n\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 360, "y": 840, "wires": [ [ "b190f9066a21afac" ] ] }, { "id": "b190f9066a21afac", "type": "function", "z": "de94877be821c022", "name": "整理輸出", "func": "var temp=\"\";\nfor (var i = 0; i < msg.payload.length; i++) \n{\n temp=temp+ \" \" + msg.payload[i];\n temp=temp.toUpperCase();\n}\nmsg.payload=temp;\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 580, "y": 840, "wires": [ [ "e4d6d5f39fc4941f", "35307f3dbaeea2b0" ] ] }, { "id": "35307f3dbaeea2b0", "type": "mqtt out", "z": "de94877be821c022", "name": "RFID out", "topic": "alex9ufo/2024/RFID/RFID_UID", "qos": "1", "retain": "true", "respTopic": "", "contentType": "", "userProps": "", "correl": "", "expiry": "", "broker": "841df58d.ee5e98", "x": 800, "y": 880, "wires": [] }, { "id": "e4d6d5f39fc4941f", "type": "debug", "z": "de94877be821c022", "name": "debug 300", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "false", "statusVal": "", "statusType": "auto", "x": 730, "y": 840, "wires": [] }, { "id": "625709eb82e1bba4", "type": "ui_toast", "z": "de94877be821c022", "position": "top right", "displayTime": "3", "highlight": "", "sendall": true, "outputs": 0, "ok": "OK", "cancel": "Cancel", "raw": false, "className": "", "topic": "", "name": "", "x": 550, "y": 1120, "wires": [] }, { "id": "c19329df615520bf", "type": "link in", "z": "de94877be821c022", "name": "link in 56", "links": [ "609e318ca3262939", "14396fb8a2b77316", "70487decb239f3c4", "ce142a687d0b79f1" ], "x": 615, "y": 1320, "wires": [ [ "1ee1c6e9e0b1ecc7" ] ] }, { "id": "8e7400a11f6417cc", "type": "function", "z": "de94877be821c022", "name": "Store UID", "func": "flow.set(\"uid_temp\", msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 200, "y": 1080, "wires": [ [ "72ba0c8d6992ed2e", "6e9fecbdbdf2efdf" ] ] }, { "id": "9ea8d029f3defa26", "type": "debug", "z": "de94877be821c022", "name": "debug ", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 310, "y": 140, "wires": [] }, { "id": "55cea575c649529c", "type": "ui_text", "z": "de94877be821c022", "group": "1ce7dd030081ad24", "order": 6, "width": 2, "height": 1, "name": "", "label": "MQTT來的", "format": "<font color = RED>{{msg.payload}}", "layout": "row-left", "className": "", "x": 450, "y": 180, "wires": [] }, { "id": "1eb4c1f4f70dcfdf", "type": "function", "z": "de94877be821c022", "name": "function SET LED 直接從 led_control 到 led_status", "func": "flow.set('ledsimu',msg.payload);\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 730, "y": 20, "wires": [ [ "ffe2bc087d509275" ] ] }, { "id": "ffe2bc087d509275", "type": "debug", "z": "de94877be821c022", "name": "debug ", "active": true, "tosidebar": true, "console": false, "tostatus": false, "complete": "payload", "targetType": "msg", "statusVal": "", "statusType": "auto", "x": 990, "y": 20, "wires": [] }, { "id": "453c73dd9da1d70e", "type": "ui_switch", "z": "de94877be821c022", "name": "", "label": "switch", "tooltip": "", "group": "1ce7dd030081ad24", "order": 5, "width": 2, "height": 1, "passthru": true, "decouple": "false", "topic": "topic", "topicType": "msg", "style": "", "onvalue": "true", "onvalueType": "bool", "onicon": "", "oncolor": "", "offvalue": "false", "offvalueType": "bool", "officon": "", "offcolor": "", "animate": false, "className": "", "x": 450, "y": 20, "wires": [ [ "1eb4c1f4f70dcfdf" ] ] }, { "id": "afb84dbde6d820dd", "type": "mqtt in", "z": "de94877be821c022", "name": "Control LED in", "topic": "alex9ufo/2024/RFID/LED_control", "qos": "1", "datatype": "auto-detect", "broker": "603bb104.d6134", "nl": false, "rap": true, "rh": 0, "inputs": 0, "x": 100, "y": 180, "wires": [ [ "0ce7c4e74b3c570a" ] ] }, { "id": "0ce7c4e74b3c570a", "type": "function", "z": "de94877be821c022", "name": "判斷", "func": "var check= flow.get('ledsimu');\nvar mqttin=msg.payload;\n\nif (check == true)\n{\n msg.payload=mqttin;\n return [msg,null];\n}\nif (check == false)\n{\n msg.payload=mqttin;\n return [null ,msg];\n}\n", "outputs": 2, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 250, "y": 180, "wires": [ [ "55cea575c649529c", "2289c4addb72da83" ], [] ] }, { "id": "f5c97c74cc496505", "type": "sqlitedb", "db": "C:\\Users\\User\\.node-red\\2024EX_LED2.db", "mode": "RWC" }, { "id": "1ce7dd030081ad24", "type": "ui_group", "name": "LED", "tab": "53d4771468c19b49", "order": 1, "disp": true, "width": "10", "collapse": false, "className": "" }, { "id": "603bb104.d6134", "type": "mqtt-broker", "name": "", "broker": "broker.mqtt-dashboard.com", "port": "1883", "clientid": "", "autoConnect": true, "usetls": false, "compatmode": false, "protocolVersion": "4", "keepalive": "15", "cleansession": true, "birthTopic": "", "birthQos": "0", "birthPayload": "", "birthMsg": {}, "closeTopic": "", "closePayload": "", "closeMsg": {}, "willTopic": "", "willQos": "0", "willPayload": "", "willMsg": {}, "userProps": "", "sessionExpiry": "" }, { "id": "26999cd202d71546", "type": "ui_group", "name": "RFID", "tab": "53d4771468c19b49", "order": 2, "disp": true, "width": "10", "collapse": false, "className": "" }, { "id": "841df58d.ee5e98", "type": "mqtt-broker", "name": "", "broker": "broker.mqtt-dashboard.com", "port": "1883", "clientid": "", "autoConnect": true, "usetls": false, "compatmode": false, "protocolVersion": "4", "keepalive": "15", "cleansession": true, "birthTopic": "", "birthQos": "0", "birthPayload": "", "birthMsg": {}, "closeTopic": "", "closePayload": "", "closeMsg": {}, "willTopic": "", "willQos": "0", "willPayload": "", "willMsg": {}, "userProps": "", "sessionExpiry": "" }, { "id": "f87c808cc786ae80", "type": "sqlitedb", "db": "C:\\Users\\User\\.node-red\\2024EX2_1.db", "mode": "RWC" }, { "id": "53d4771468c19b49", "type": "ui_tab", "name": "2024產專班 作業2 ", "icon": "dashboard", "order": 123, "disabled": false, "hidden": false } ]