server.js

const express = require("express");
const mongoose = require("mongoose");
const Members = require("./models/memberModel");
const Circulations = require("./models/circulationModel");
const Requests = require("./models/requestModel");
const Penalties = require("./models/penaltyModel");

const jwt = require("jsonwebtoken");
const cookieParser = require("cookie-parser");

const app = express();

app.use(cookieParser());
app.use(express.json());
app.use(express.urlencoded({ extended: false }));

//default route
app.get("/", (req, res) => {
  res.send("API WORKING SUCCESS");
});

// get borrowed
app.get("/circulations/:id/borrowed", async (req, res) => {
  try {
    const { id } = req.params;

    // Use the condition to filter by BorrowerMemberID and CirculationStatus
    const circulations = await Circulations.find({
      BorrowerMemberID: id,
      CirculationStatus: "Borrowed",
    });

    if (circulations.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(circulations);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// get borrowed
app.get("/circulations/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const circulations = await Circulations.find({ BorrowerMemberID: id , CirculationStatus: "Borrowed",});

    if (circulations.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(circulations);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// get penalty
app.get("/penalty/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const penalties = await Penalties.find({ MemberID: id });

    if (penalties.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(penalties);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// get request
/* app.get("/request/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const request = await Requests.find({ MemberID: id });

    if (request.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(request);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});
 */

//get member requests
app.get("/request/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const requests = await Requests.find({ MemberId: id });

    if (requests.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(requests);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// get count borrowed
app.get("/circulations/count/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const circulations = await Circulations.find({ BorrowerMemberID: id, CirculationStatus: "Borrowed" });
    const circulationsCount = circulations.length;

    if (circulations.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json({ message: circulationsCount });
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// get count overdue borrowed
app.get("/circulations/overdue/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const circulations = await Circulations.find({
      BorrowerMemberID: id,
      PenaltyStatus: "Overdue",
    });

    if (circulations.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    const circulationsCount = circulations.length;

    res.status(200).json({ message: circulationsCount });
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

//get memeber data
app.get("/member/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const member = await Members.find({ _id: id });

    if (member.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(member);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

//get member penalties
app.get("/penalties/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const penalties = await Penalties.find({ MemberID: id });

    if (penalties.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(penalties);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

//count request
app.get("/request/count/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const requests = await Requests.find({ MemberId: id });
    const requestCount = requests.length;

    if (requests.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json({ message: requestCount });
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

//count penalties
app.get("/penalties/count/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const penalty = await Penalties.find({ MemberID: id });
    const penaltiesCount = penalty.length;

    if (penalty.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json({ message: penaltiesCount });
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

//update member data
app.put("/member/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const member = await Members.findByIdAndUpdate(id, req.body);

    if (!member) {
      return res
        .status(404)
        .json({ message: `cannot find any schedule with ID ${id}` });
    }
    const updatedMember = await Members.findById(id);
    res.status(200).json(updatedMember);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

/* 
//get user
app.get("/user/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const patient = await Patient.findById(id);
    res.status(200).json(patient);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// fetch all schedules
app.get("/schedules", async (req, res) => {
  try {
    const schedules = await Schedules.find({});
    res.status(200).json(schedules);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// fetch all schedules
app.get("/rfids", async (req, res) => {
  try {
    const rfids = await Rfids.find({});
    res.status(200).json(rfids);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// add schedules
app.post("/insertschedule", async (req, res) => {
  try {
    const schedule = await Schedules.create(req.body);
    res.status(200).json(schedule);
  } catch (error) {
    console.log(error.message);
    res.status(500).json({ message: error.message });
  }
});

app.delete("/schedule/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const schedule = await Schedules.findByIdAndDelete(id);
    if (!schedule) {
      return res
        .status(404)
        .json({ message: `cannot find any schedule with ID ${id}` });
    }
    res.status(200).json(schedule);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// fetch all checkups
app.get("/checkups", async (req, res) => {
  try {
    const checkups = await Checkup.find({});
    res.status(200).json(checkups);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

// fetch all checkup history
app.get("/checkups-history", async (req, res) => {
  try {
    const checkupshistory = await CheckupsHistory.find({});
    res.status(200).json(checkupshistory);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

app.put("/schedule/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const schedule = await Schedules.findByIdAndUpdate(id, req.body);

    if (!schedule) {
      return res
        .status(404)
        .json({ message: `cannot find any schedule with ID ${id}` });
    }
    const updatedSchedule = await Schedules.findById(id);
    res.status(200).json(updatedSchedule);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});

app.get("/announcements/:id", async (req, res) => {
  try {
    const { id } = req.params;
    const announcements = await Announcements.find({ rfid: id });

    if (announcements.length === 0) {
      return res.status(404).json({ message: "No matching records found" });
    }

    res.status(200).json(announcements);
  } catch (error) {
    res.status(500).json({ message: error.message });
  }
});
 */

//login

app.post("/login", async (req, res) => {
  const { Username, Password } = req.body;

  try {
    // Find the user by email
    const user = await Members.findOne({ Username: Username });

    if (!user) {
      return res
        .status(401)
        .json({ message: "Authentication failed. User not found." });
    }

    // Compare the provided password with the stored password
    if (user.Password !== Password) {
      return res
        .status(401)
        .json({ message: "Authentication failed. Incorrect password." });
    }

    // Create a JWT token
    const token = jwt.sign({ userId: user._id }, "your-secret-key", {
      expiresIn: "1h",
    });

    // Set the token as a cookie (optional)
    res.cookie("jwt", token, { httpOnly: true, maxAge: 3600000 }); // 1 hour

    // Respond with the token as a Bearer token
    res.status(200).json({
      message: "Authentication successful",
      token: `${token}`,
      userId: user._id,
      userEmail: user.Email,
      userFullname: user.Fullname,
      userIDNumber: user.IDNumber,
      userRfid: user.Rfid,
      userAccountType: user.AccountType,
      userAge: user.Age,
      userAddress: user.Address,
      userContact: user.ContactNumber,
      userRegisterDate: user.DateRegistered,
      userUsername: user.Username,
      userPassword: user.Password,
      userBirthday: user.Birthday,
    });
  } catch (error) {
    console.log(error.message);
    res.status(500).json({ message: "Internal server error" });
  }
});

mongoose.set("strictQuery", false);
mongoose
  .connect(
    "mongodb+srv://virusdetected848:helloworld123@cluster0.mootble.mongodb.net/LMS"
  )
  .then(() => {
    console.log("connected to MongoDB");
    app.listen(3000, () => {
      console.log(`Node API app is running on port 3000`);
    });
  })
  .catch((error) => {
    console.log(error);
  });