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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | 3x 3x 3x 1x 6x 6x 1x 1x 1x 1x 1x 6x 1x 2x 2x 2x 2x 2x 2x 2x 12x 12x 12x 2x 12x 2x 2x | import moment from 'moment-timezone';
import { models } from '../../../config/database';
import inboundOrderProductStorageDao from '../../database/dao/inboundOrderProductStorage';
import { mountWhereBasedFilter } from '../../helpers/reports/sequelize';
import NumberFormatter from '../../helpers/number/format';
function remove(headersValue, value) {
const index = headersValue.indexOf(value);
Eif (index !== -1) {
headersValue.splice(index, 1);
}
}
// Função criada para popular o array headers e rows enviados por parametro
export default async function generateData(
columns,
filters,
headers = [],
rows = [],
opts = {}
) {
const where = mountWhereBasedFilter(filters);
const columnsValuesDefault = columns.map((column) => column.value);
const columnsValuesToFind = columns.map((column) => column.value);
remove(columnsValuesToFind, 'branchName');
remove(columnsValuesToFind, '_storageProductUser');
remove(columnsValuesToFind, '_range');
const dados =
await inboundOrderProductStorageDao.findInboundOrderProductStorages(where, {
attributes: columnsValuesToFind,
raw: true,
include: [
{
required: false,
model: models.StorageAddress,
as: 'storageAddressInbound',
attributes: ['rangeCode'],
},
{
required: false,
model: models.User,
as: 'userProductStorage',
attributes: ['login', 'name'],
},
{
required: false,
model: models.InboundOrderProduct,
as: 'inboundOrderProduct',
attributes: ['inboundOrderId'],
include: [
{
required: false,
model: models.InboundOrder,
as: 'inboundOrder',
attributes: ['branchCode'],
include: [
{
required: false,
model: models.Branch,
as: 'branch',
attributes: ['name'],
},
],
},
],
},
],
...opts,
});
columns.forEach((it) => {
headers.push(it.label);
});
dados.forEach((it) => {
it.inboundOrderProductId =
it['inboundOrderProduct.inboundOrder.branchCode'];
it.branchName = it['inboundOrderProduct.inboundOrder.branch.name'];
it._storageProductUser = it['userProductStorage.name'];
it._range = it['storage.rangeCode'];
it.quantityStorage = it.quantityStorage || 0;
const row = [];
for (let index = 0; index < columnsValuesDefault.length; index += 1) {
const column = columnsValuesDefault[index];
row.push(it[column]);
if (column === 'storageProductAt')
row[index] = row[index] ? moment(row[index]).format('l') : '';
if (column === 'quantityStorage' && row[index] !== null) {
row[index] = NumberFormatter.format(row[index], 4);
}
}
rows.push(row);
});
}
|