Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | 2x 2x 2x 1x | import WarehouseDao from '../../database/dao/warehouse';
import { models } from '../../../config/database';
async function getWarehouse(query, opts = {}) {
return WarehouseDao.findWarehouse(query, {
// raw: true,
attributes: ['id', 'code', 'name', 'branchCode', 'note'],
include: [
{
required: false,
model: models.Branch,
as: 'branch',
attributes: ['code', 'name'],
},
],
...opts,
});
}
async function getAllWarehouses(opts = {}) {
const warehousesQuery = {};
const warehouses = await WarehouseDao.findWarehouses(warehousesQuery, {
attributes: ['id', 'code', 'name', 'branchCode', 'note'],
include: [
{
required: false,
model: models.Branch,
as: 'branch',
attributes: ['code', 'name'],
},
],
...opts,
});
return warehouses;
}
async function getOptionsWarehouses(opts = {}) {
const warehouses = await WarehouseDao.findWarehouses(
{},
{
attributes: ['id', 'code', 'name', 'branchCode'],
raw: true,
...opts,
}
);
const result = warehouses.map((warehouse) => {
return {
value: warehouse.code,
label: `${warehouse.code} - ${warehouse.name}`,
branchCode: warehouse.branchCode,
};
});
return result;
}
export default {
getWarehouse,
getAllWarehouses,
getOptionsWarehouses,
};
|