FM / items

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

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

Name	Size	Mode	Actions
create.js	1853	0644	edit dl rm
delete.js	834	0644	edit dl rm
details.js	466	0644	edit dl rm
edit.js	2041	0644	edit dl rm
list.js	1364	0644	edit dl rm

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

module.exports = function ({ db, logger }) {
	const { NotFound, BadRequest } = require('../../../responseModels/errors')
	const { isSet, isEmail, isPhone, isEmpty, minLength, isNumber } = require('../../../utils/validator.util')
	const { ItemsListModel } = require('../../../responseModels')

return async (req, res, next) => {
		logger.child({ path: req.path, request: req.query }).info()
		let t1 = performance.now()
		try {
			const { name, itemsCategoryId, companyId, limit, page } =
				req.query

let include = []
			let where = {}

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

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

const count = await db.items.count({
				where,
			});

const rows =  await db.items.findAll({
				include: include,
				where,
				offset,
				order: [
					['itemsCategoryId','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 ItemsListModel({ items: rows, page, limit, count, time }))
        } catch (err) {
			next(err)
		}
	}
}

cmd: