All files / source/reports printer.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
47
 
 
 
 
 
61x
 
 
 
 
1x
5x
1x
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
5x
5x
 
1x
1x
1x
 
1x
1x
5x
 
9x
5x
2x
 
 
1x
 
 
import Sequelize from 'sequelize';
import moment from 'moment-timezone';
import PrinterDao from '../../database/dao/printer';
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 PrinterDao.findPrinters(where, {
    attributes: headersValue,
    include: [{
      required: false,
      model: models.User,
      as: 'userCreated',
      attributes: ['login'],
    }, {
      required: false,
      model: models.User,
      as: 'userUpdated',
      attributes: ['login'],
    },],
    ...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')
      }
    }
    rows.push(row);
  });
};