citizens pagination

2 files changed, 16 insertions, 4 deletions

diff --git a/interface/routes/api/citizens.js b/interface/routes/api/citizens.js
index fc98928..c6c6425 100644
--- a/interface/routes/api/citizens.js
+++ b/interface/routes/api/citizens.js
@@ -3,6 +3,12 @@ const router = express.Router();
 
 const citizensController = require("../../controllers/citizens.controller");
 
+router.get('/count', (req, res) => {
+  citizensController.getCountOfCitizens().then(count => {
+    res.json({ count });
+  });
+});
+
 router.post("/edit", (req, res) => {
   const { citizen_id, address, mobile_num, dob, marital_status } = req.body;
   if (!citizen_id || !address || !mobile_num || !dob || !marital_status) {
diff --git a/interface/routes/index.js b/interface/routes/index.js
index b99abbf..c75c2c0 100644
--- a/interface/routes/index.js
+++ b/interface/routes/index.js
@@ -22,11 +22,17 @@ router.get('/', (req, res) => {
 });
 
 router.get("/citizens", (req, res) => {
+    // Get the limit and offset from the query string
+    const limit = parseInt(req.query.limit, 10) || 10;
+    const page = req.query.page ? (req.query.page - 1) * limit : 0;
+
     // Get the citizens from the database
-    citizensController.findXCitizens().then(citizens => {
-        res.render("citizens", {
-            citizens: citizens,
-            title: "Citizens Data"
+    Promise.all([citizensController.findXCitizens(limit, page), citizensController.getCountOfCitizens()]).then(results => {
+        const [citizens, count] = results;
+        res.render('citizens', {
+            title: 'Citizens',
+            citizens,
+            count: count[0].count,
         });
     });
 });