FM / extra

/var/www/greso.tech/server/nsm/controllers/company/extra/

/var/www/greso.tech/server/nsm/controllers/company/extra

Name	Size	Mode	Actions
create.js	1580	0644	edit dl rm
delete.js	836	0644	edit dl rm
details.js	473	0644	edit dl rm
edit.js	1736	0644	edit dl rm
list.js	1321	0644	edit dl rm

Edit: /var/www/greso.tech/server/nsm/controllers/company/extra/list.js (1321B)

module.exports = function ({ db, logger }) {
	const { NotFound, BadRequest } = require('../../../responseModels/errors')
	const { isSet, isEmail, isPhone, isEmpty, minLength, isNumber } = require('../../../utils/validator.util')
	const { ExtraListModel } = 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 { id, companyId, name, limit, page } =
				req.query

let offset = page ? (page - 1) * (limit || 10) : 0

let where = {}

if (isSet(id)) {
				where['id'] = id
			}

if (isSet(name) && minLength(name, 1)) {
				where['name'] = {
					[Op.like]: `%${name}%`
				}
			}
			
			if (isSet(companyId)) {
				where['companyId'] = companyId
			}

const count = await db.extras.count(where);

const rows = await db.extras.findAll({
				where,
				offset,
				order: [
					['direction', 'ASC'],
					['name', 'ASC'],
				],
				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 ExtraListModel({ rows, page, limit, count, time }))
        } catch (err) {
			next(err)
		}
	}
}

cmd: