/var/www/greso.tech/server/nsm/controllers/order/inventory
Edit: /var/www/greso.tech/server/nsm/controllers/order/inventory/list.js (1680B)
module.exports = function ({ db, logger }) {
const { NotFound, BadRequest } = require('../../../responseModels/errors')
const { isSet, isEmail, isPhone, isEmpty, minLength, isNumber } = require('../../../utils/validator.util')
const { OrderInventoryModel } = require('../../../responseModels')
return async (req, res, next) => {
logger.child({ path: req.path, request: req.query }).info()
let t1 = performance.now()
try {
const {
id,
inventoryId,
limit,
page
} = req.query
let where = {}
if (isSet(id)) {
where['orderId'] = id
}
if (isSet(inventoryId)) {
where['id'] = inventoryId
}
let offset = page ? (page - 1) * (limit || 10) : 0
const count = await db.orderInventory.count({
where,
});
const rows = await db.orderInventory.findAll({
include: [
{ model: db.inventoryItemsCategories, as: 'itemsCategory' },
{ model: db.inventoryExtras, as: 'extras' },
{ model: db.inventoryItems, as: 'items',
include: [
{ model: db.inventoryItemsConditions, as: 'conditions' },
{ model: db.inventoryItemsDestConditions, as: 'dest_conditions' },
{ model: db.inventoryItemsPackages, as: 'packages' },
{ model: db.inventoryItemsAttachments, as: 'attachments' }
],
}],
where,
offset,
order: [
['createdAt', 'DESC'],
],
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 OrderInventoryModel({ rows, page, limit, count, time }))
} catch (err) {
next(err)
}
}
}