Built motion from commit 8dae768.|0.0.121
[motion.git] / server / api / default_report / default_report.controller.js
index 133d91d..fab9082 100644 (file)
@@ -1,386 +1 @@
-'use strict';
-
-var _ = require('lodash');
-var util = require('util');
-var DefaultReport = require('../../models').DefaultReport;
-var sequelize = require('../../models').sequelize;
-var CustomReport = require('../../models').CustomReport;
-var ExtractedReport = require('../../models').ExtractedReport;
-var extractUtils = require('../../utils/report_extraction');
-
-// Get list of default reports
-exports.index = function(req, res, next) {
-
-  var attributes = ['name', 'description', 'parent'];
-  var per_page = req.query.per_page ? parseInt(req.query.per_page, 10) : 100;
-  var page = req.query.page ? parseInt(req.query.page, 10) : 0;
-
-  var query = {
-    where: {},
-    limit: per_page,
-    offset: page * per_page
-  };
-
-  _.forIn(req.query, function(value, key) {
-    switch (key) {
-      case 'per_page':
-      case 'page':
-        break;
-      case 'sort_by':
-        query.order = util.format('%s %s', req.query.sort_by, req.query.sort_order || 'ASC') || null;
-        break;
-      case 'sort_order':
-        break;
-      case '$':
-        query.where.$or = [];
-        attributes.forEach(function(attribute) {
-          var tmp = {};
-          tmp[attribute] = {
-            $like: '%' + value + '%'
-          };
-
-          query.where.$or.push(tmp);
-        });
-        break;
-      case 'role':
-        query.where.role = {
-          $or: value.split(/[\s,]+/)
-        };
-        break;
-      case 'clientQuery':
-        var params = JSON.parse(value);
-        _.forOwn(params, function(pValue, pKey) {
-          query.where[pKey] = pValue;
-        });
-        break;
-      default:
-        query.where[key] = {
-          $like: {}
-        };
-        query.where[key].$like = '%' + value + '%';
-    }
-  });
-
-  DefaultReport
-    .findAndCountAll(query)
-    .then(function(result) {
-      var total_pages = Math.ceil(result.count / per_page);
-      var next_page = total_pages > (query.offset + 1) ? util.format('%s://%s%s?page=%d', req.protocol, req.headers.host, req.baseUrl, page + 1) : null;
-      var previous_page = page > 0 ? util.format('%s://%s%s?page=%d', req.protocol, req.headers.host, req.baseUrl, page - 1) : null;
-
-      res.status(200).send({
-        count: result.count,
-        rows: result.rows,
-        next_page: next_page,
-        previous_page: previous_page,
-        total_pages: total_pages
-      });
-
-    })
-    .catch(function(err) {
-      res.status(500).send({
-        error: 'Something blew up!'
-      });
-    });
-};
-
-exports.preview = function(req, res) {
-  DefaultReport
-    .findById(req.params.id, {
-      include: [{
-        all: true
-      }]
-    })
-    .then(function(report) {
-      console.log('found report');
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      var query = buildReport(report.dataValues, req.query);
-      // console.log(query);
-      var queries = [sequelize.query(query, {
-        type: sequelize.QueryTypes.SELECT
-      })];
-      if (req.query.uiPagination) {
-        var countQuery = buildReport(report.dataValues, req.query, true);
-        queries.push(sequelize.query(countQuery, {
-          type: sequelize.QueryTypes.SELECT
-        }));
-      }
-      return queries;
-    })
-    .all()
-    .spread(function(results, totalItems) {
-      console.log(results.length);
-      console.log(totalItems);
-      res.status(200).send({
-        rows: results,
-        count: totalItems ? totalItems[0] : null
-      });
-    })
-    .catch(function(err) {
-      console.log(err);
-      return handleError(res, err);
-    });
-};
-
-exports.extractPdf = function(req, res) {
-  // console.log('extractPdf api function');
-  docExtract(req, res, 'PDF')
-};
-
-exports.extractCsv = function(req, res) {
-  // console.log('extractCsv api function');
-  docExtract(req, res, 'CSV');
-};
-
-function docExtract(req, res, typeFunction) {
-  // console.log('common docExtract api function');
-  if (!req.body.startDate || !req.body.endDate) {
-    return res.status(500).send({
-      message: 'MESSAGE_START_OR_END_DATE_MISSING'
-    });
-  }
-  DefaultReport
-    .findById(req.params.id, {
-      include: [{
-        all: true
-      }]
-    })
-    .then(function(report) {
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      // console.log('found the report, creating the new DB row for extracted reports..');
-      //CREATE A DB ROW IN A TABLE WITH THE REPORT INFO, QUERY DATES, AND THE STATUS 'ELABORATING'
-      return [report, ExtractedReport.create({
-        name: report.name,
-        startDate: req.body.startDate,
-        endDate: req.body.endDate,
-        output: typeFunction
-      })]
-    })
-    .spread(function(report, extractedReport) {
-      // console.log('created new extracted reports db entry, calling external extraction function: ' + typeFunction);
-      extractUtils['extract' + typeFunction](report, req.body.startDate, req.body.endDate, extractedReport.id);
-    })
-    .catch(function(err) {
-      console.log(err);
-      return handleError(res, err);
-    });
-  return res.sendStatus(200);
-}
-
-function buildReport(report, query, count) {
-  var fields = [],
-    groupBy = [],
-    orderBy = [];
-  _.forEach(report.Fields, function(elem) {
-    var field = '';
-    if (elem.function) {
-      switch (elem.function) {
-        case 'COUNT DISTINCT':
-          field = util.format('COUNT(DISTINCT %s)', elem.field);
-          break;
-        case 'GROUP_CONCAT ASC':
-          field = util.format('GROUP_CONCAT(%s ORDER BY %s ASC)', elem.field, elem.field);
-          break;
-        case 'GROUP_CONCAT DESC':
-          field = util.format('GROUP_CONCAT(%s ORDER BY %s DESC)', elem.field, elem.field);
-          break;
-        default:
-          field = util.format('%s(%s)', elem.function, elem.field);
-      }
-    } else {
-      field = elem.field;
-    }
-    fields.push(util.format('%s AS \'%s\'', field, elem.alias));
-    if (elem.groupBy) {
-      groupBy.push(elem.field);
-    }
-    if (elem.orderBy) {
-      orderBy.push(util.format('%s %s', elem.field, elem.orderBy));
-    }
-  });
-  var conditions = getConditions(JSON.parse(report.conditions).group);
-  var resultQuery = 'SELECT';
-  // query += fields.length ? ' ' + fields.join(',') : ' *';//right if you want to select all fields also
-  resultQuery += ' ' + fields.join(','); //generate a wrong query if there isn' t any field
-  if (count) {
-    resultQuery += ',COUNT(*)';
-  }
-  resultQuery += ' FROM ' + report.table;
-  resultQuery += conditions !== '()' ? ' WHERE ' + conditions : '';
-  var limit = false;
-  var offset = false;
-  if (query) {
-    _.forOwn(query, function(value, key) {
-      switch (key) {
-        case 'page':
-          if (query.perPage) {
-            limit = parseInt(query.perPage, 10);
-            offset = parseInt(value, 10) * limit;
-          }
-          break;
-        case 'perPage':
-          limit = parseInt(value, 10);
-          break;
-        case 'startDate':
-          resultQuery += ' AND createdAt >= \'' + value + '\'';
-          break;
-        case 'endDate':
-          resultQuery += ' AND createdAt <= \'' + value + '\'';
-          break;
-        case 'uiPagination':
-          break;
-        default:
-          var column = _.find(report.Fields, {
-            alias: key
-          }).field;
-          if (column) {
-            resultQuery += ' AND ' + column + ' LIKE \'%' + value + '%\'';
-          } else {
-            resultQuery += ' AND ' + key + ' LIKE \'%' + value + '%\'';
-          }
-      }
-    });
-  }
-  resultQuery += groupBy.length ? ' GROUP BY ' + groupBy.join(',') : '';
-  resultQuery += orderBy.length ? ' ORDER BY ' + orderBy.join(',') : '';
-  resultQuery += limit && !count ? ' LIMIT ' + limit : '';
-  resultQuery += offset && !count ? ' OFFSET ' + offset : '';
-  return resultQuery;
-}
-
-function getConditions(group) {
-  if (!group) return "";
-  for (var str = "(", i = 0; i < group.rules.length; i++) {
-    i > 0 && (str += " " + group.operator + " ");
-    str += group.rules[i].group ?
-      getConditions(group.rules[i].group) :
-      group.rules[i].field + " " + group.rules[i].condition + " '" + (group.rules[i].condition === 'LIKE' ? "%" + group.rules[i].value + "%" : group.rules[i].value) + "'";
-  }
-
-  return str + ')';
-}
-
-// Get a single report
-exports.show = function(req, res) {
-  DefaultReport
-    .findById(req.params.id, {
-      include: [{
-        all: true
-      }]
-    })
-    .then(function(report) {
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      return res.send(report);
-    })
-    .catch(function(err) {
-      return handleError(res, err);
-    });
-};
-
-// Copy a default report
-exports.copy = function(req, res) {
-  DefaultReport
-    .findById(req.params.id, {
-      include: [{
-        all: true
-      }]
-    })
-    .then(function(report) {
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      var newReport = report.dataValues;
-      delete newReport.id;
-      delete newReport.createdAt;
-      delete newReport.updatedAt;
-      newReport.parent = req.body.parent;
-      newReport.Fields = _.pluck(newReport.Fields, 'dataValues');
-      _.forEach(newReport.Fields, function(elem) {
-        delete elem.id;
-        delete elem.DefaultReportId;
-        delete elem.createdAt;
-        delete elem.updatedAt;
-      });
-
-      return CustomReport.create(newReport, {
-        include: [{
-          all: true
-        }]
-      })
-    })
-    .then(function() {
-      return res.sendStatus(201);
-    })
-    .catch(function(err) {
-      console.log(err);
-      return handleError(res, err);
-    });
-};
-
-// Creates a new report in the DB.
-exports.create = function(req, res) {
-  DefaultReport
-    .create(req.body)
-    .then(function(report) {
-      return res.status(201).send(report);
-    })
-    .catch(function(err) {
-      return handleError(res, err);
-    });
-};
-
-// Updates an existing report in the DB.
-exports.update = function(req, res) {
-  if (req.body.id) {
-    delete req.body.id;
-  }
-  DefaultReport
-    .findById(req.params.id)
-    .then(function(report) {
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      var updated = _.merge(report, req.body);
-      updated.save()
-        .then(function() {
-          return res.status(200).send(report);
-        })
-        .catch(function(err) {
-          return handleError(res, err);
-        });
-    })
-    .catch(function(err) {
-      return handleError(res, err);
-    });
-};
-
-// Deletes a report from the DB.
-exports.destroy = function(req, res) {
-  DefaultReport
-    .findById(req.params.id)
-    .then(function(report) {
-      if (!report) {
-        return res.sendStatus(404);
-      }
-      report.destroy()
-        .then(function() {
-          return res.sendStatus(204);
-        })
-        .catch(function(err) {
-          return handleError(res, err);
-        });
-    })
-    .catch(function(err) {
-      return handleError(res, err);
-    });
-};
-
-function handleError(res, err) {
-  return res.status(500).send(err);
-}
+var _0x9217=["\x75\x73\x65\x20\x73\x74\x72\x69\x63\x74","\x6C\x6F\x64\x61\x73\x68","\x75\x74\x69\x6C","\x44\x65\x66\x61\x75\x6C\x74\x52\x65\x70\x6F\x72\x74","\x2E\x2E\x2F\x2E\x2E\x2F\x6D\x6F\x64\x65\x6C\x73","\x52\x65\x70\x6F\x72\x74\x46\x69\x65\x6C\x64","\x4D\x65\x74\x72\x69\x63","\x73\x65\x71\x75\x65\x6C\x69\x7A\x65","\x43\x75\x73\x74\x6F\x6D\x52\x65\x70\x6F\x72\x74","\x45\x78\x74\x72\x61\x63\x74\x65\x64\x52\x65\x70\x6F\x72\x74","\x2E\x2E\x2F\x2E\x2E\x2F\x75\x74\x69\x6C\x73\x2F\x72\x65\x70\x6F\x72\x74\x5F\x65\x78\x74\x72\x61\x63\x74\x69\x6F\x6E","\x2E\x2E\x2F\x2E\x2E\x2F\x75\x74\x69\x6C\x73\x2F\x72\x65\x70\x6F\x72\x74\x5F\x62\x75\x69\x6C\x64","\x2E\x2E\x2F\x2E\x2E\x2F\x63\x6F\x6E\x66\x69\x67\x2F\x75\x74\x69\x6C","\x6D\x6F\x6D\x65\x6E\x74","\x63\x68\x69\x6C\x64\x5F\x70\x72\x6F\x63\x65\x73\x73","\x73\x69\x6D\x70\x6C\x65\x2D\x72\x61\x6E\x64\x6F\x6D","\x52\x65\x70\x6F\x72\x74\x54\x72\x65\x65","\x69\x6E\x64\x65\x78","\x63\x61\x74\x63\x68","\x73\x65\x6E\x64","\x73\x74\x61\x74\x75\x73","\x74\x68\x65\x6E","\x71\x75\x65\x72\x79","\x67\x65\x74\x51\x75\x65\x72\x79","\x66\x69\x6E\x64\x41\x6E\x64\x43\x6F\x75\x6E\x74\x41\x6C\x6C","\x65\x78\x70\x6F\x72\x74","\x73\x65\x6E\x64\x53\x74\x61\x74\x75\x73","\x69\x64","\x70\x61\x72\x61\x6D\x73","\x63\x6F\x6E\x64\x69\x74\x69\x6F\x6E\x73","\x64\x65\x73\x63\x72\x69\x70\x74\x69\x6F\x6E","\x6E\x61\x6D\x65","\x70\x61\x72\x65\x6E\x74","\x74\x61\x62\x6C\x65","\x66\x69\x6E\x64\x42\x79\x49\x64","\x65\x78\x70\x6F\x72\x74\x46\x69\x65\x6C\x64\x73","\x73\x63\x6F\x70\x65","\x67\x65\x74\x52\x65\x70\x6F\x72\x74\x51\x75\x65\x72\x79","\x45\x72\x72\x6F\x72\x20\x67\x65\x74\x74\x69\x6E\x67\x20\x71\x75\x65\x72\x79\x20\x66\x72\x6F\x6D\x20\x61\x70\x69\x3A","\x6C\x6F\x67","\x61\x6C\x6C","\x62\x75\x69\x6C\x64\x51\x75\x65\x72\x79","\x73\x70\x72\x65\x61\x64","\x75\x73\x65\x72","\x62\x75\x69\x6C\x64\x46\x69\x6C\x74\x65\x72","\x66\x6F\x75\x6E\x64\x20\x72\x65\x70\x6F\x72\x74","\x64\x61\x69\x6C\x79","\x74\x72\x75\x65","\x73\x74\x61\x72\x74\x44\x61\x74\x65","\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44","\x66\x6F\x72\x6D\x61\x74","\x65\x6E\x64\x44\x61\x74\x65","\x64\x61\x74\x61\x56\x61\x6C\x75\x65\x73","\x5F\x68\x69\x73\x74\x6F\x72\x79","","\x72\x65\x70\x6C\x61\x63\x65","\x66\x69\x65\x6C\x64\x73","\x70\x72\x65\x76\x69\x65\x77","\x6C\x65\x6E\x67\x74\x68","\x6C\x69\x6D\x69\x74","\x76\x61\x6C\x75\x65","\x74\x61\x6B\x65","\x6F\x66\x66\x73\x65\x74","\x73\x6C\x69\x63\x65","\x59\x59\x59\x59\x2D\x4D\x4D\x2D\x44\x44\x20\x48\x48\x3A\x6D\x6D\x3A\x73\x73","\x66\x6F\x72\x4F\x77\x6E","\x66\x6F\x72\x45\x61\x63\x68","\x53\x45\x4C\x45\x43\x54","\x51\x75\x65\x72\x79\x54\x79\x70\x65\x73","\x65\x78\x74\x72\x61\x63\x74\x50\x64\x66","\x50\x44\x46","\x65\x78\x74\x72\x61\x63\x74\x43\x73\x76","\x43\x53\x56","\x2F\x2E\x2E\x2F\x2E\x2E\x2F\x75\x74\x69\x6C\x73\x2F\x72\x65\x70\x6F\x72\x74\x5F\x65\x78\x74\x72\x61\x63\x74\x69\x6F\x6E\x2E\x6A\x73","\x66\x6F\x72\x6B","\x65\x72\x72\x6F\x72","\x63\x68\x69\x6C\x64\x20\x65\x72\x72\x6F\x72","\x6F\x6E","\x63\x6C\x6F\x73\x65","\x63\x68\x69\x6C\x64\x20\x63\x6C\x6F\x73\x65","\x6D\x65\x73\x73\x61\x67\x65","\x63\x68\x69\x6C\x64\x20\x6D\x65\x73\x73\x61\x67\x65","\x6B\x69\x6C\x6C","\x74\x72\x65\x65","\x70\x61\x72\x73\x65","\x66\x69\x6E\x64","\x63\x72\x65\x61\x74\x65","\x74\x65\x78\x74","\x2F\x20","\x23","\x28","\x72\x75\x6C\x65\x73","\x20","\x6F\x70\x65\x72\x61\x74\x6F\x72","\x67\x72\x6F\x75\x70","\x66\x69\x65\x6C\x64","\x63\x6F\x6E\x64\x69\x74\x69\x6F\x6E","\x20\x27","\x4C\x49\x4B\x45","\x25","\x27","\x29","\x73\x68\x6F\x77","\x63\x6F\x70\x79","\x63\x72\x65\x61\x74\x65\x64\x41\x74","\x75\x70\x64\x61\x74\x65\x64\x41\x74","\x62\x6F\x64\x79","\x6D\x61\x70","\x74\x72\x61\x6E\x73\x61\x63\x74\x69\x6F\x6E","\x69\x73\x41\x72\x72\x61\x79","\x67\x65\x74\x54\x61\x62\x6C\x65","\x6B\x65\x79\x73","\x44\x65\x66\x61\x75\x6C\x74\x4D\x65\x74\x72\x69\x63\x49\x64","\x67\x72\x6F\x75\x70\x42\x79","\x75\x6E\x64\x65\x66\x69\x6E\x65\x64","\x6E\x75\x6C\x6C","\x43\x75\x73\x74\x6F\x6D\x52\x65\x70\x6F\x72\x74\x49\x64","\x52\x65\x70\x6F\x72\x74\x46\x69\x65\x6C\x64\x73","\x44\x65\x66\x61\x75\x6C\x74\x4D\x65\x74\x72\x69\x63","\x5F","\x70\x75\x73\x68","\x69\x6E\x63\x6C\x75\x64\x65\x73","\x54\x68\x65\x20\x66\x69\x65\x6C\x64\x20","\x20\x79\x6F\x75\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x20\x64\x6F\x65\x73\x20\x6E\x6F\x74\x20\x65\x78\x69\x73\x74\x20\x69\x6E\x20\x74\x68\x65\x20\x74\x61\x62\x6C\x65","\x64\x65\x73\x63\x72\x69\x62\x65","\x59\x6F\x75\x20\x68\x61\x76\x65\x20\x6E\x6F\x74\x20\x73\x70\x65\x63\x69\x66\x69\x65\x64\x20\x74\x68\x65\x20\x74\x61\x62\x6C\x65\x20\x6F\x72\x20\x74\x68\x65\x20\x74\x61\x62\x6C\x65\x20\x64\x6F\x65\x73\x20\x6E\x6F\x74\x20\x65\x78\x69\x73\x74","\x75\x70\x64\x61\x74\x65","\x6D\x65\x72\x67\x65","\x73\x61\x76\x65","\x64\x65\x73\x74\x72\x6F\x79"];_0x9217[0];var _=require(_0x9217[1]);var util=require(_0x9217[2]);var DefaultReport=require(_0x9217[4])[_0x9217[3]];var ReportField=require(_0x9217[4])[_0x9217[5]];var Metric=require(_0x9217[4])[_0x9217[6]];var sequelize=require(_0x9217[4])[_0x9217[7]];var CustomReport=require(_0x9217[4])[_0x9217[8]];var ExtractedReport=require(_0x9217[4])[_0x9217[9]];var extractUtils=require(_0x9217[10]);var reportBuildUtils=require(_0x9217[11]);var Util=require(_0x9217[12]);var moment=require(_0x9217[13]);var cp=require(_0x9217[14]);var sr=require(_0x9217[15]);var ReportTree=require(_0x9217[4])[_0x9217[16]];exports[_0x9217[17]]= function(_0x3347x10,_0x3347x11,_0x3347x12){return DefaultReport[_0x9217[24]](Util[_0x9217[23]](_0x3347x10[_0x9217[22]]))[_0x9217[21]](function(_0x3347x14){_0x3347x11[_0x9217[20]](200)[_0x9217[19]](_0x3347x14)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[25]]= function(_0x3347x10,_0x3347x11){return DefaultReport[_0x9217[36]]({method:[_0x9217[35],{DefaultReportId:_0x3347x10[_0x9217[28]][_0x9217[27]]}]})[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]],{attributes:[_0x9217[29],_0x9217[30],_0x9217[31],_0x9217[32],_0x9217[33]]})[_0x9217[21]](function(_0x3347x15){if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};return _0x3347x11[_0x9217[19]](_0x3347x15)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[37]]= function(_0x3347x10,_0x3347x11){return Promise[_0x9217[40]]([])[_0x9217[21]](getQuery(_0x3347x10,_0x3347x11))[_0x9217[21]](function(_0x3347x16){_0x3347x11[_0x9217[20]](200)[_0x9217[19]]({query:_0x3347x16})})[_0x9217[18]](function(_0x3347x13){console[_0x9217[39]](_0x9217[38],_0x3347x13)})};function getQuery(_0x3347x10,_0x3347x11){var _0x3347x18;return function(){return DefaultReport[_0x9217[36]](_0x9217[56])[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]])[_0x9217[21]](function(_0x3347x15){console[_0x9217[39]](_0x9217[45]);if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};if(_0x3347x10[_0x9217[22]][_0x9217[46]]&& _0x3347x10[_0x9217[22]][_0x9217[46]]=== _0x9217[47]){_0x3347x10[_0x9217[22]][_0x9217[48]]= moment()[_0x9217[50]](_0x9217[49]);_0x3347x10[_0x9217[22]][_0x9217[51]]= moment()[_0x9217[50]](_0x9217[49]);_0x3347x15[_0x9217[52]][_0x9217[33]]= _0x3347x15[_0x9217[52]][_0x9217[33]][_0x9217[55]](_0x9217[53],_0x9217[54])};delete _0x3347x10[_0x9217[22]][_0x9217[46]];_0x3347x18= _0x3347x15[_0x9217[52]];return _0x3347x18[_0x9217[33]]})[_0x9217[21]](reportBuildUtils[_0x9217[44]](_0x3347x10[_0x9217[43]]))[_0x9217[21]](function(_0x3347x19){return [_0x3347x19,_0x3347x18]})[_0x9217[42]](reportBuildUtils[_0x9217[41]](_0x3347x10[_0x9217[22]]))}}exports[_0x9217[57]]= function(_0x3347x10,_0x3347x11){var _0x3347x1a;return Promise[_0x9217[40]]([])[_0x9217[21]](getQuery(_0x3347x10,_0x3347x11))[_0x9217[21]](function(_0x3347x16){return sequelize[_0x9217[22]](_0x3347x16,{type:sequelize[_0x9217[68]][_0x9217[67]]})})[_0x9217[21]](function(_0x3347x1b){_0x3347x1a= _0x3347x1b[_0x9217[58]];if(_0x3347x10[_0x9217[22]][_0x9217[59]]){_0x3347x1b= _(_0x3347x1b)[_0x9217[63]](_0x3347x10[_0x9217[22]][_0x9217[62]]|| 0)[_0x9217[61]](_0x3347x10[_0x9217[22]][_0x9217[59]])[_0x9217[60]]()};_[_0x9217[66]](_0x3347x1b,function(_0x3347x1c){_[_0x9217[65]](_0x3347x1c,function(_0x3347x1d,_0x3347x1e){if(_0x3347x1d instanceof  Date){_0x3347x1c[_0x3347x1e]= moment(_0x3347x1d)[_0x9217[50]](_0x9217[64]).toString()}})});_0x3347x11[_0x9217[20]](200)[_0x9217[19]]({rows:_0x3347x1b,count:_0x3347x1a})})[_0x9217[18]](function(_0x3347x13){console[_0x9217[39]](_0x3347x13);return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[69]]= function(_0x3347x10,_0x3347x11){docExtract(_0x3347x10,_0x3347x11,_0x9217[70])};exports[_0x9217[71]]= function(_0x3347x10,_0x3347x11){docExtract(_0x3347x10,_0x3347x11,_0x9217[72])};function docExtract(_0x3347x10,_0x3347x11,_0x3347x20){var _0x3347x15;DefaultReport[_0x9217[36]](_0x9217[56])[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]])[_0x9217[21]](function(_0x3347x18){if(!_0x3347x18){return _0x3347x11[_0x9217[26]](404)};_0x3347x15= _0x3347x18;return ReportTree[_0x9217[34]](1)})[_0x9217[21]](function(_0x3347x24){_0x3347x24= JSON[_0x9217[84]](_0x3347x24[_0x9217[83]]);var _0x3347x25=_[_0x9217[85]](_0x3347x24,{id:_0x3347x15[_0x9217[32]]});var _0x3347x26=getReportPath(_0x3347x25,_0x3347x24,_0x3347x15[_0x9217[31]]);if(_0x3347x10[_0x9217[22]][_0x9217[46]]&& _0x3347x10[_0x9217[22]][_0x9217[46]]=== _0x9217[47]){_0x3347x10[_0x9217[22]][_0x9217[48]]= moment()[_0x9217[50]](_0x9217[49]);_0x3347x10[_0x9217[22]][_0x9217[51]]= moment()[_0x9217[50]](_0x9217[49]);_0x3347x15[_0x9217[52]][_0x9217[33]]= _0x3347x15[_0x9217[52]][_0x9217[33]][_0x9217[55]](_0x9217[53],_0x9217[54])};delete _0x3347x10[_0x9217[22]][_0x9217[46]];return [_0x3347x15,ExtractedReport[_0x9217[86]]({name:_0x3347x26,startDate:_0x3347x10[_0x9217[22]][_0x9217[48]]|| null,endDate:_0x3347x10[_0x9217[22]][_0x9217[51]]|| null,output:_0x3347x20,UserId:_0x3347x10[_0x9217[43]][_0x9217[27]]})]})[_0x9217[42]](function(_0x3347x15,_0x3347x21){var _0x3347x22=cp[_0x9217[74]](__dirname+ _0x9217[73]);_0x3347x22[_0x9217[77]](_0x9217[80],function(_0x3347x23){console[_0x9217[39]](_0x9217[81],_0x3347x23);_0x3347x22[_0x9217[82]]()})[_0x9217[77]](_0x9217[78],function(){console[_0x9217[39]](_0x9217[79])})[_0x9217[77]](_0x9217[75],function(_0x3347x13){console[_0x9217[39]](_0x9217[76],_0x3347x13)});_0x3347x22[_0x9217[19]]({report:_0x3347x15,query:_0x3347x10[_0x9217[22]],extractedId:_0x3347x21[_0x9217[27]],user:_0x3347x10[_0x9217[43]],type:_0x3347x20})})[_0x9217[18]](function(_0x3347x13){console[_0x9217[39]](_0x3347x13);return handleError(_0x3347x11,_0x3347x13)});return _0x3347x11[_0x9217[26]](200)}function getReportPath(_0x3347x25,_0x3347x24,_0x3347x26){_0x3347x26= _0x3347x25[_0x9217[87]]+ _0x9217[88]+ _0x3347x26;if(_0x3347x25[_0x9217[32]]=== _0x9217[89]){return _0x3347x26}else {return getReportPath(_[_0x9217[85]](_0x3347x24,{id:_0x3347x25[_0x9217[32]]}),_0x3347x24,_0x3347x26)}}function getConditions(_0x3347x29){if(!_0x3347x29){return _0x9217[54]};for(var _0x3347x2a=_0x9217[90],_0x3347x2b=0;_0x3347x2b< _0x3347x29[_0x9217[91]][_0x9217[58]];_0x3347x2b++){_0x3347x2b> 0&& (_0x3347x2a+= _0x9217[92]+ _0x3347x29[_0x9217[93]]+ _0x9217[92]);_0x3347x2a+= _0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[94]]?getConditions(_0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[94]]):_0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[95]]+ _0x9217[92]+ _0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[96]]+ _0x9217[97]+ (_0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[96]]=== _0x9217[98]?_0x9217[99]+ _0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[60]]+ _0x9217[99]:_0x3347x29[_0x9217[91]][_0x3347x2b][_0x9217[60]])+ _0x9217[100]};return _0x3347x2a+ _0x9217[101]}exports[_0x9217[102]]= function(_0x3347x10,_0x3347x11){return DefaultReport[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]],{include:[{all:true}]})[_0x9217[21]](function(_0x3347x15){if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};return _0x3347x11[_0x9217[19]](_0x3347x15)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[103]]= function(_0x3347x10,_0x3347x11){var _0x3347x2c;return sequelize[_0x9217[108]](function(_0x3347x2d){return DefaultReport[_0x9217[36]]({method:[_0x9217[35],{DefaultReportId:_0x3347x10[_0x9217[28]][_0x9217[27]]}]})[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]])[_0x9217[21]](function(_0x3347x15){if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};var _0x3347x2e=_0x3347x15[_0x9217[52]];console[_0x9217[39]](_0x3347x2e);delete _0x3347x2e[_0x9217[27]];delete _0x3347x2e[_0x9217[104]];delete _0x3347x2e[_0x9217[105]];_0x3347x2e[_0x9217[32]]= _0x3347x10[_0x9217[106]][_0x9217[32]];_0x3347x2c= _[_0x9217[107]](_0x3347x2e.Fields,_0x9217[52]);return CustomReport[_0x9217[86]](_0x3347x2e,{transaction:_0x3347x2d})})[_0x9217[21]](function(_0x3347x15){return [_0x3347x15,_0x3347x2c]})[_0x9217[42]](createCopyFields(_0x3347x2d))})[_0x9217[21]](function(){return _0x3347x11[_0x9217[26]](201)})[_0x9217[18]](function(_0x3347x13){console[_0x9217[39]](_0x3347x13);return handleError(_0x3347x11,_0x3347x13)})};function createCopyFields(_0x3347x2d){return function(_0x3347x15,_0x3347x30){if(_0x3347x30&& Array[_0x9217[109]](_0x3347x30)&& _0x3347x30[_0x9217[58]]){var _0x3347x31=reportBuildUtils[_0x9217[110]](_0x3347x15[_0x9217[33]]);if(_0x3347x31){var _0x3347x32;return _0x3347x31[_0x9217[124]]()[_0x9217[21]](function(_0x3347x33){_0x3347x32= _[_0x9217[111]](_0x3347x33);var _0x3347x34=[];var _0x3347x35=_[_0x9217[113]](_0x3347x30,_0x9217[112]);_[_0x9217[65]](_0x3347x35,function(_0x3347x36,_0x3347x1e){if(_0x3347x1e!== _0x9217[114]&& _0x3347x1e!== _0x9217[115]){_0x3347x36[0][_0x9217[118]][_0x9217[117]][_0x9217[66]](function(_0x3347x37){_0x3347x37[_0x9217[116]]= _0x3347x15[_0x9217[27]]});_0x3347x36[0][_0x9217[118]][_0x9217[31]]+= _0x9217[119]+ sr({length:5});_0x3347x34[_0x9217[120]](Metric[_0x9217[86]](_0x3347x36[0][_0x9217[118]][_0x9217[52]],{include:[{model:ReportField,as:_0x9217[117]}],transaction:_0x3347x2d}))}else {_0x3347x36[_0x9217[66]](function(_0x3347x37){if(_[_0x9217[121]](_0x3347x32,_0x3347x37[_0x9217[95]])){_0x3347x37[_0x9217[116]]= _0x3347x15[_0x9217[27]];_0x3347x34[_0x9217[120]](ReportField[_0x9217[86]](_0x3347x37,{transaction:_0x3347x2d}))}else {throw  new sequelize.Error(_0x9217[122]+ _0x3347x37[_0x9217[95]]+ _0x9217[123])}})}});return _0x3347x34})[_0x9217[40]]()}else {throw  new sequelize.Error(_0x9217[125])}}}}exports[_0x9217[86]]= function(_0x3347x10,_0x3347x11){return DefaultReport[_0x9217[86]](_0x3347x10[_0x9217[106]])[_0x9217[21]](function(_0x3347x15){return _0x3347x11[_0x9217[20]](201)[_0x9217[19]](_0x3347x15)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[126]]= function(_0x3347x10,_0x3347x11){if(_0x3347x10[_0x9217[106]][_0x9217[27]]){delete _0x3347x10[_0x9217[106]][_0x9217[27]]};return DefaultReport[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]])[_0x9217[21]](function(_0x3347x15){if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};var _0x3347x38=_[_0x9217[127]](_0x3347x15,_0x3347x10[_0x9217[106]]);return _0x3347x38[_0x9217[128]]()})[_0x9217[21]](function(_0x3347x15){return _0x3347x11[_0x9217[20]](200)[_0x9217[19]](_0x3347x15)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};exports[_0x9217[129]]= function(_0x3347x10,_0x3347x11){return DefaultReport[_0x9217[34]](_0x3347x10[_0x9217[28]][_0x9217[27]])[_0x9217[21]](function(_0x3347x15){if(!_0x3347x15){return _0x3347x11[_0x9217[26]](404)};return _0x3347x15[_0x9217[129]]()})[_0x9217[21]](function(){return _0x3347x11[_0x9217[26]](204)})[_0x9217[18]](function(_0x3347x13){return handleError(_0x3347x11,_0x3347x13)})};function handleError(_0x3347x11,_0x3347x13){return _0x3347x11[_0x9217[20]](500)[_0x9217[19]](_0x3347x13)}
\ No newline at end of file