20 lines
569 B
JavaScript
20 lines
569 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 sql = "SELECT COUNT(id) AS count FROM popcen WHERE caseid LIKE ?";
|
|
|
|
db.query(sql, [caseidPattern], (err, results) => {
|
|
if (err) {
|
|
console.error(err);
|
|
return res.status(500).send("Server error");
|
|
}
|
|
res.json(results[0].count);
|
|
});
|
|
});
|
|
|
|
module.exports = router;
|