All files / source/reports collector.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
 
 
 
 
 
 
61x
 
 
 
 
1x
6x
 
1x
 
 
 
 
6x
6x
1x
 
 
2x
2x
12x
 
12x
12x
4x
8x
2x
 
 
2x
 
 
import Sequelize from 'sequelize';
import moment from 'moment-timezone';
 
import CollectorDao from '../../database/dao/collector';
import { mountWhereBasedFilter } from '../../helpers/reports/sequelize';
import { models } from '../../../config/database';
const Op = Sequelize.Op;
 
// 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);  
  var headersValue = columns.map(it => it.value);
 
  const dados = await CollectorDao.findCollectors(where, {
    attributes: headersValue,
    ...opts
  });
 
  const headersValueRes = columns.map(it => it.value);
  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 < headersValueRes.length; index++) {
      const column = headersValueRes[index];
 
      row.push(column.split('.').reduce((o,i)=>o[i] || '', it));
      if (column === 'createdAt' || column==='updatedAt') {
        row[index] = moment(row[index]).format('L LTS')
      }else if (column === 'active') {
        row[index] = row[index] ? 'Sim' : 'Não';
      }
    }
    rows.push(row);
  });
}