All files / source/reports productsUnitsMeasure.js

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
 
 
 
 
 
 
 
 
2x
12x
2x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
12x
 
2x
2x
2x
 
2x
2x
12x
 
12x
12x
4x
 
 
2x
 
 
import moment from 'moment-timezone';
import UnitMeasureDao from '../../database/dao/unitMeasure';
import { models } from '../../../config/database';
import { mountWhereBasedFilter } from '../../helpers/reports/sequelize';
 
 
// Funcao 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 headersValue = columns.map(it => it.value);
  const dados = await UnitMeasureDao.findUnitsMeasure(where, {
    attributes: headersValue,
    include: [{
      required: false,
      model: models.User,
      as: 'userCreated',
      attributes: ['login'],
    }, {
      required: false,
      model: models.User,
      as: 'userUpdated',
      attributes: ['login'],
    },],
    ...opts
  });
 
  columns.forEach(it => { headers.push(it.label); });
 
  dados.forEach(it => {
    it.createdUser = it.userCreated.dataValues.login
    it.updatedUser = it.userUpdated.dataValues.login
 
    const row = [];
    for (let index = 0; index < headersValue.length; index++) {
      const column = headersValue[index];
 
      row.push(it[column]);
      if (column === 'createdAt' || column === 'updatedAt') {
        row[index] = moment(row[index]).format('l LTS')
      }
    }
    rows.push(row);
  });
};