routes.js

const express = require("express");
const bodyParser = require("body-parser");
const mysql = require("mysql");
const cors = require("cors");

const app = express();
const port = 3000;

// MySQL database connection pool
const pool = mysql.createPool({
  host: "localhost",
  user: "root",
  password: "SmeIsTheBest26",
  database: "ngo",
});

// Middleware
app.use(cors()); // Enable CORS
app.use(bodyParser.json()); // Parse JSON request body

// Route to handle POST request to save QR code to database
app.post("/save-qr", (req, res) => {
  const qrText = req.body.qrText;
  if (!qrText) {
    return res
      .status(400)
      .json({ error: true, message: "QR Text is required" });
  }

  pool.getConnection((err, connection) => {
    if (err) {
      console.error("Database connection failed:", err.stack);
      return res
        .status(500)
        .json({ error: true, message: "Database connection failed" });
    }

    const insertQuery =
      "INSERT INTO qr_code (Gen_ID, date_time) VALUES (?, NOW())";
    connection.query(insertQuery, [qrText], (error, results, fields) => {
      connection.release(); // Release connection

      if (error) {
        console.error("Failed to insert data:", error);
        return res
          .status(500)
          .json({ error: true, message: "Failed to insert data" });
      }

      res.json({
        error: false,
        message: "QR code has been saved successfully.",
        data: results,
      });
    });
  });
});

// Route to get the last 5 generated QR codes with their scan info if available
app.get("/get-last-qr-codes", (req, res) => {
  pool.getConnection((err, connection) => {
    if (err) {
      console.error("Database connection failed:", err.stack);
      return res
        .status(500)
        .json({ error: true, message: "Database connection failed" });
    }

    const selectQuery = `
        SELECT * FROM qr_code ORDER BY date_time DESC LIMIT 5`;
    connection.query(selectQuery, (error, results, fields) => {
      connection.release(); // Release connection

      if (error) {
        console.error("Failed to fetch data:", error);
        return res
          .status(500)
          .json({ error: true, message: "Failed to fetch data" });
      }

      res.json({
        error: false,
        data: results.reverse(),
      });
    });
  });
});

// Route to handle POST request to save scanned QR code to database
app.post("/save-scan", (req, res) => {
  const qrText = req.body.qrText;
  if (!qrText) {
    return res
      .status(400)
      .json({ error: true, message: "QR Text is required" });
  }

  pool.getConnection((err, connection) => {
    if (err) {
      console.error("Database connection failed:", err.stack);
      return res
        .status(500)
        .json({ error: true, message: "Database connection failed" });
    }

    const insertQuery =
      "INSERT INTO scan (Gen_ID,scan_date_time) VALUES (?, NOW())";
    connection.query(insertQuery, [qrText], (error, results, fields) => {
      connection.release(); // Release connection

      if (error) {
        console.error("Failed to insert data:", error);
        return res
          .status(500)
          .json({ error: true, message: "Failed to insert data" });
      }

      res.json({
        error: false,
        message: "Scanned QR code has been saved successfully.",
        data: results,
      });
    });
  });
});

// Start server
app.listen(port, () => {
  console.log(`Server is running on http://localhost:${port}`);
});