server/api/analyticTreeReport/analyticTreeReport.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0xa818=['error','stack','name','send','index','map','AnalyticTreeReport','fieldName','type','key','model','query','filters','intersection','fields','attributes','length','nolimit','order','sort','pick','filter','merge','where','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','keys','rawAttributes','find','create','body','destroy','eml-format','zip-dir','fast-json-patch','request-promise','moment','util','to-csv','ejs','fs-extra','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','sendStatus','status','json','offset','limit','count','set','Content-Range','reject','save','update','then','end'];(function(_0x448f8,_0x2aa1d7){var _0xa73126=function(_0x1fcafa){while(--_0x1fcafa){_0x448f8['push'](_0x448f8['shift']());}};_0xa73126(++_0x2aa1d7);}(_0xa818,0x1d1));var _0x8a81=function(_0x3e2fcf,_0x579110){_0x3e2fcf=_0x3e2fcf-0x0;var _0x497db7=_0xa818[_0x3e2fcf];return _0x497db7;};'use strict';var emlformat=require(_0x8a81('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x8a81('0x1'));var jsonpatch=require(_0x8a81('0x2'));var rp=require(_0x8a81('0x3'));var moment=require(_0x8a81('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x8a81('0x5'));var path=require('path');var sox=require('sox');var csv=require(_0x8a81('0x6'));var ejs=require(_0x8a81('0x7'));var fs=require('fs');var fs_extra=require(_0x8a81('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x8a81('0x9'));var deskjs=require(_0x8a81('0xa'));var toCsv=require(_0x8a81('0x6'));var querystring=require(_0x8a81('0xb'));var Papa=require(_0x8a81('0xc'));var Redis=require('ioredis');var authService=require(_0x8a81('0xd'));var qs=require(_0x8a81('0xe'));var as=require(_0x8a81('0xf'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x8a81('0x10'))(_0x8a81('0x11'));var utils=require('../../config/utils');var config=require(_0x8a81('0x12'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x153d0c,_0x1598a8){_0x1598a8=_0x1598a8||0xcc;return function(_0x4fd8e7){if(_0x4fd8e7){return _0x153d0c[_0x8a81('0x13')](_0x1598a8);}return _0x153d0c[_0x8a81('0x14')](_0x1598a8)['end']();};}function respondWithResult(_0xfaa27e,_0x5087e8){_0x5087e8=_0x5087e8||0xc8;return function(_0x490a6e){if(_0x490a6e){return _0xfaa27e[_0x8a81('0x14')](_0x5087e8)[_0x8a81('0x15')](_0x490a6e);}};}function respondWithFilteredResult(_0x10591e,_0x56697d){return function(_0x1b3e11){if(_0x1b3e11){var _0x47eebe=typeof _0x56697d[_0x8a81('0x16')]==='undefined'&&typeof _0x56697d[_0x8a81('0x17')]==='undefined';var _0x35ad54=_0x1b3e11[_0x8a81('0x18')];var _0x3420e9=_0x47eebe?0x0:_0x56697d['offset'];var _0x417aa4=_0x47eebe?_0x1b3e11[_0x8a81('0x18')]:_0x56697d[_0x8a81('0x16')]+_0x56697d['limit'];var _0x5eda26;if(_0x417aa4>=_0x35ad54){_0x417aa4=_0x35ad54;_0x5eda26=0xc8;}else{_0x5eda26=0xce;}_0x10591e['status'](_0x5eda26);return _0x10591e[_0x8a81('0x19')](_0x8a81('0x1a'),_0x3420e9+'-'+_0x417aa4+'/'+_0x35ad54)[_0x8a81('0x15')](_0x1b3e11);}return null;};}function patchUpdates(_0x345148){return function(_0x3be610){try{jsonpatch['apply'](_0x3be610,_0x345148,!![]);}catch(_0x2aff7b){return BPromise[_0x8a81('0x1b')](_0x2aff7b);}return _0x3be610[_0x8a81('0x1c')]();};}function saveUpdates(_0x1def2a,_0x38e2b5){return function(_0x1569b2){if(_0x1569b2){return _0x1569b2[_0x8a81('0x1d')](_0x1def2a)[_0x8a81('0x1e')](function(_0x46cb3a){return _0x46cb3a;});}return null;};}function removeEntity(_0x5a1e61,_0x2515f4){return function(_0xf7bc7c){if(_0xf7bc7c){return _0xf7bc7c['destroy']()[_0x8a81('0x1e')](function(){_0x5a1e61[_0x8a81('0x14')](0xcc)[_0x8a81('0x1f')]();});}};}function handleEntityNotFound(_0x1568dc,_0x2cd7f7){return function(_0x38e801){if(!_0x38e801){_0x1568dc[_0x8a81('0x13')](0x194);}return _0x38e801;};}function handleError(_0xbc6979,_0x3255cc){_0x3255cc=_0x3255cc||0x1f4;return function(_0x17b2d0){logger[_0x8a81('0x20')](_0x17b2d0[_0x8a81('0x21')]);if(_0x17b2d0[_0x8a81('0x22')]){delete _0x17b2d0[_0x8a81('0x22')];}_0xbc6979[_0x8a81('0x14')](_0x3255cc)[_0x8a81('0x23')](_0x17b2d0);};}exports[_0x8a81('0x24')]=function(_0x18ee84,_0x1112a5){var _0x56c0bb={},_0x59aee5={},_0x134f45={'count':0x0,'rows':[]};var _0x2199da=_[_0x8a81('0x25')](db[_0x8a81('0x26')]['rawAttributes'],function(_0x4d72aa){return{'name':_0x4d72aa[_0x8a81('0x27')],'type':_0x4d72aa[_0x8a81('0x28')][_0x8a81('0x29')]};});_0x59aee5[_0x8a81('0x2a')]=_[_0x8a81('0x25')](_0x2199da,'name');_0x59aee5[_0x8a81('0x2b')]=_['keys'](_0x18ee84[_0x8a81('0x2b')]);_0x59aee5[_0x8a81('0x2c')]=_[_0x8a81('0x2d')](_0x59aee5['model'],_0x59aee5[_0x8a81('0x2b')]);_0x56c0bb['attributes']=_[_0x8a81('0x2d')](_0x59aee5[_0x8a81('0x2a')],qs['fields'](_0x18ee84[_0x8a81('0x2b')][_0x8a81('0x2e')]));_0x56c0bb[_0x8a81('0x2f')]=_0x56c0bb['attributes'][_0x8a81('0x30')]?_0x56c0bb['attributes']:_0x59aee5[_0x8a81('0x2a')];if(!_0x18ee84['query']['hasOwnProperty'](_0x8a81('0x31'))){_0x56c0bb['limit']=qs[_0x8a81('0x17')](_0x18ee84[_0x8a81('0x2b')][_0x8a81('0x17')]);_0x56c0bb['offset']=qs['offset'](_0x18ee84['query'][_0x8a81('0x16')]);}_0x56c0bb[_0x8a81('0x32')]=qs[_0x8a81('0x33')](_0x18ee84['query']['sort']);_0x56c0bb['where']=qs[_0x8a81('0x2c')](_[_0x8a81('0x34')](_0x18ee84[_0x8a81('0x2b')],_0x59aee5[_0x8a81('0x2c')]),_0x2199da);if(_0x18ee84['query'][_0x8a81('0x35')]){_0x56c0bb['where']=_[_0x8a81('0x36')](_0x56c0bb[_0x8a81('0x37')],{'$or':_['map'](_0x2199da,function(_0xbedea1){if(_0xbedea1[_0x8a81('0x28')]!==_0x8a81('0x38')){var _0x5644fa={};_0x5644fa[_0xbedea1[_0x8a81('0x22')]]={'$like':'%'+_0x18ee84['query']['filter']+'%'};return _0x5644fa;}})});}_0x56c0bb=_['merge']({},_0x56c0bb,_0x18ee84[_0x8a81('0x39')]);var _0x1b468e={'where':_0x56c0bb['where']};return db[_0x8a81('0x26')]['count'](_0x1b468e)[_0x8a81('0x1e')](function(_0x1bef5d){_0x134f45[_0x8a81('0x18')]=_0x1bef5d;if(_0x18ee84[_0x8a81('0x2b')][_0x8a81('0x3a')]){_0x56c0bb[_0x8a81('0x3b')]=[{'all':!![]}];}return db[_0x8a81('0x26')][_0x8a81('0x3c')](_0x56c0bb);})['then'](function(_0x2b0cb0){_0x134f45[_0x8a81('0x3d')]=_0x2b0cb0;return _0x134f45;})[_0x8a81('0x1e')](respondWithFilteredResult(_0x1112a5,_0x56c0bb))[_0x8a81('0x3e')](handleError(_0x1112a5,null));};exports[_0x8a81('0x3f')]=function(_0x3a7889,_0x5beb19){var _0x3648a8={'raw':!![],'where':{'id':_0x3a7889[_0x8a81('0x40')]['id']}},_0xda607={};_0xda607['model']=_[_0x8a81('0x41')](db[_0x8a81('0x26')][_0x8a81('0x42')]);_0xda607[_0x8a81('0x2b')]=_[_0x8a81('0x41')](_0x3a7889[_0x8a81('0x2b')]);_0xda607[_0x8a81('0x2c')]=_[_0x8a81('0x2d')](_0xda607[_0x8a81('0x2a')],_0xda607[_0x8a81('0x2b')]);_0x3648a8[_0x8a81('0x2f')]=_[_0x8a81('0x2d')](_0xda607['model'],qs[_0x8a81('0x2e')](_0x3a7889['query'][_0x8a81('0x2e')]));_0x3648a8[_0x8a81('0x2f')]=_0x3648a8[_0x8a81('0x2f')][_0x8a81('0x30')]?_0x3648a8[_0x8a81('0x2f')]:_0xda607[_0x8a81('0x2a')];if(_0x3a7889[_0x8a81('0x2b')]['includeAll']){_0x3648a8[_0x8a81('0x3b')]=[{'all':!![]}];}_0x3648a8=_['merge']({},_0x3648a8,_0x3a7889[_0x8a81('0x39')]);return db[_0x8a81('0x26')][_0x8a81('0x43')](_0x3648a8)[_0x8a81('0x1e')](handleEntityNotFound(_0x5beb19,null))['then'](respondWithResult(_0x5beb19,null))[_0x8a81('0x3e')](handleError(_0x5beb19,null));};exports[_0x8a81('0x44')]=function(_0x438e96,_0x20004e){return db[_0x8a81('0x26')][_0x8a81('0x44')](_0x438e96['body'],{})[_0x8a81('0x1e')](respondWithResult(_0x20004e,0xc9))[_0x8a81('0x3e')](handleError(_0x20004e,null));};exports[_0x8a81('0x1d')]=function(_0x2eefd0,_0x597256){if(_0x2eefd0['body']['id']){delete _0x2eefd0[_0x8a81('0x45')]['id'];}return db[_0x8a81('0x26')][_0x8a81('0x43')]({'where':{'id':_0x2eefd0['params']['id']}})[_0x8a81('0x1e')](handleEntityNotFound(_0x597256,null))[_0x8a81('0x1e')](saveUpdates(_0x2eefd0[_0x8a81('0x45')],null))[_0x8a81('0x1e')](respondWithResult(_0x597256,null))[_0x8a81('0x3e')](handleError(_0x597256,null));};exports[_0x8a81('0x46')]=function(_0x256f69,_0xdbd13c){return db['AnalyticTreeReport'][_0x8a81('0x43')]({'where':{'id':_0x256f69[_0x8a81('0x40')]['id']}})[_0x8a81('0x1e')](handleEntityNotFound(_0xdbd13c,null))['then'](removeEntity(_0xdbd13c,null))[_0x8a81('0x3e')](handleError(_0xdbd13c,null));};