24 lines
740 B
JavaScript
24 lines
740 B
JavaScript
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;
|