All files / source/reports userFunctions.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
45
46
 
 
 
 
 
 
 
 
4x
14x
 
4x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
14x
4x
4x
4x
 
4x
4x
14x
 
14x
14x
6x
 
 
4x
 
 
 
 
import moment from 'moment-timezone';
import UserFunctionsDao from '../../database/dao/userFunction';
import I18n from '../../helpers/i18n';
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 UserFunctionsDao.findUserFunctions(where, {
    attributes: headersValue,
    include: [{
      required: true,
      model: models.User,
      as: 'userCreated',
      attributes: ['login'],
    }, {
      required: true,
      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);
  });
 
 
}