Backend-POS/Controller/Database.js

const asyncHandler = require("../Middleware/async");
const sequelize = require('sequelize')
const DBInfo = require("../Model/Database");

exports.getDBInfo = asyncHandler(async (req, res, next) => {
    console.log("GET DB INFO EXEC ")
    var hasNext = false;
    // const decode = decodeURIComponent
    const { limit, offset = 0, name = "", nodelivery = 0 } = req.query;
    const decode = decodeURIComponent(name);
    // console.log("DECODE ", decode)
    if (name) {
        // get count of all databases
        const count = await DBInfo.count({
            where: {
                DB_NAME: sequelize.where(
                    sequelize.fn("LOWER", sequelize.col("DB_NAME")),
                    "LIKE",
                    "%" + decode.toLowerCase() + "%"
                ),
            },
        });

        // check if count is greater than offset + limit
        if (count > offset + limit) {
            hasNext = true;
        }
        const allDBInfo = await DBInfo.findAll({
            where: {
                DB_NAME: sequelize.where(
                    sequelize.fn("LOWER", sequelize.col("DB_NAME")),
                    "LIKE",
                    "%" + decode.toLowerCase() + "%"
                ),

            },
            offset: offset,
            limit: limit,
        }).then((db) => {
            var list = { databases: db, hasNext: hasNext, count: db.length };
            return res.status(200).send(JSON.stringify(list));
        });


    } else {
        // if there is no name provide then get all databases
        const count = await DBInfo.count();
        if (count > offset + limit) {
            hasNext = true;
        }
        const allDBInfo = await DBInfo.findAll({
            where: {
                DB_STAT: "A"
            },
            offset: offset,
            limit: limit,
        }).then((db) => {
            var list = { databases: db, hasNext: hasNext, count: db.length };
            return res.status(200).send(JSON.stringify(list));
        });
    }

    // res.status(200).JSON({
    //     success: True,
    //     description: allDBInfo
    // })
})