/var/www/greso.tech/server/nsm/controllers/zip_code
Edit: /var/www/greso.tech/server/nsm/controllers/zip_code/list.js (1114B)
module.exports = function ({ db, logger }) {
const { NotFound, BadRequest } = require('../../responseModels/errors')
const { isSet, isEmail, isPhone, isEmpty, minLength, isNumber } = require('../../utils/validator.util')
const { ZipCodesListModel } = require('../../responseModels')
const { Op } = require('sequelize')
return async (req, res, next) => {
logger.child({ path: req.path, request: req.query }).info()
let t1 = performance.now()
try {
const { zip, limit, page } =
req.query
let offset = page ? (page - 1) * (limit || 10) : 0
let where = {}
if (isSet(zip) && minLength(zip, 1)) {
where['zip'] = {
[Op.like]: `%${zip}%`
}
}
const count = await db.zipCode.count(where);
const rows = await db.zipCode.findAll({
where,
offset,
limit: parseInt(limit) || 10
})
if (!rows || rows.length == 0) {
throw new NotFound({ lang: req.user?.languageCode })
}
const time = performance.now() - t1
return res.status(200).json(new ZipCodesListModel({ rows, page, limit, count, time }))
} catch (err) {
next(err)
}
}
}