FM / warehouse

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

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

Name	Size	Mode	Actions
create.js	1034	0644	edit dl rm
delete.js	844	0644	edit dl rm
details.js	473	0644	edit dl rm
edit.js	1529	0644	edit dl rm
list.js	1489	0644	edit dl rm

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

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

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

let where = {}

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

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

var rows = await db.warehouses.findAll({
				where,
				offset,
				limit: parseInt(limit) || 10
			})
			if (!rows || rows.length == 0) {
				throw new NotFound({ lang: req.user?.languageCode })
			}

for(let x = 0; x < rows.length;x++){
				if(rows[x].addressId != null && !isEmpty(rows[x].addressId)){
					const address = await db.address.findOne({
						where: { id: rows[x].addressId }
					})
					if (address) {
						rows[x].address = address
					}
		
				}
			}
			const time = performance.now() - t1

return res.status(200).json(new WarehouseListModel({ rows, page, limit, count, time }))
        } catch (err) {
			next(err)
		}
	}
}

cmd: