const express = require("express");
const router = express.Router();
const db = require("../../config/db");
const verifyToken = require("../../middlewares/authMiddleware");

router.get("/", verifyToken, (req, res) => {
  const caseidPattern = req.query.caseidPattern + "%";
  const batchno = parseInt(req.query.batchno, 10) || 1;
  const sql =
    "SELECT id, uuid, caseid, modified_time FROM popcen WHERE caseid LIKE ? LIMIT ? OFFSET ?";
  const limit = 1000;
  const offset = (batchno - 1) * limit;

  db.query(sql, [caseidPattern, limit, offset], (err, results) => {
    if (err) {
      console.error(err);
      return res.status(500).send("Server error");
    }
    res.json({ batchno, results });
  });
});

module.exports = router;