server/api/analyticFieldReport/analyticFieldReport.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 _0xfd37=['save','update','destroy','stack','name','send','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','query','keys','filters','attributes','fields','hasOwnProperty','sort','where','filter','merge','VIRTUAL','options','then','include','findAll','params','intersection','includeAll','find','catch','create','body','bulkCreate','addFields','AnalyticCustomReport','sequelize','transaction','CustomReportId','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','sox','to-csv','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject'];(function(_0x2e46b3,_0x49ae11){var _0x319d05=function(_0x30ce69){while(--_0x30ce69){_0x2e46b3['push'](_0x2e46b3['shift']());}};_0x319d05(++_0x49ae11);}(_0xfd37,0x110));var _0x7fd3=function(_0x5cb21b,_0x57e0a6){_0x5cb21b=_0x5cb21b-0x0;var _0x33d87d=_0xfd37[_0x5cb21b];return _0x33d87d;};'use strict';var pdf=require(_0x7fd3('0x0'));var emlformat=require(_0x7fd3('0x1'));var rimraf=require(_0x7fd3('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x7fd3('0x3'));var rp=require(_0x7fd3('0x4'));var moment=require('moment');var BPromise=require(_0x7fd3('0x5'));var Mustache=require(_0x7fd3('0x6'));var util=require(_0x7fd3('0x7'));var path=require('path');var sox=require(_0x7fd3('0x8'));var csv=require(_0x7fd3('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x7fd3('0xa'));var squel=require('squel');var crypto=require(_0x7fd3('0xb'));var jsforce=require(_0x7fd3('0xc'));var deskjs=require(_0x7fd3('0xd'));var toCsv=require(_0x7fd3('0x9'));var querystring=require(_0x7fd3('0xe'));var Papa=require(_0x7fd3('0xf'));var Redis=require(_0x7fd3('0x10'));var authService=require(_0x7fd3('0x11'));var qs=require(_0x7fd3('0x12'));var as=require(_0x7fd3('0x13'));var hardwareService=require(_0x7fd3('0x14'));var logger=require(_0x7fd3('0x15'))(_0x7fd3('0x16'));var utils=require(_0x7fd3('0x17'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x7fd3('0x18'))['db'];function respondWithStatusCode(_0x1346cd,_0x379637){_0x379637=_0x379637||0xcc;return function(_0x5a0a45){if(_0x5a0a45){return _0x1346cd[_0x7fd3('0x19')](_0x379637);}return _0x1346cd[_0x7fd3('0x1a')](_0x379637)[_0x7fd3('0x1b')]();};}function respondWithResult(_0x5871d8,_0x19627e){_0x19627e=_0x19627e||0xc8;return function(_0x44f75c){if(_0x44f75c){return _0x5871d8[_0x7fd3('0x1a')](_0x19627e)[_0x7fd3('0x1c')](_0x44f75c);}};}function respondWithFilteredResult(_0x1721a3,_0x331b16){return function(_0x5db791){if(_0x5db791){var _0x2dbbd6=_0x5db791[_0x7fd3('0x1d')],_0x2481a8=_0x331b16[_0x7fd3('0x1e')],_0x42defa=_0x331b16[_0x7fd3('0x1e')]+_0x331b16[_0x7fd3('0x1f')],_0x5c977f;if(_0x42defa>=_0x2dbbd6){_0x42defa=_0x2dbbd6;_0x5c977f=0xc8;}else{_0x5c977f=0xce;}_0x1721a3[_0x7fd3('0x1a')](_0x5c977f);return _0x1721a3[_0x7fd3('0x20')](_0x7fd3('0x21'),_0x2481a8+'-'+_0x42defa+'/'+_0x2dbbd6)[_0x7fd3('0x1c')](_0x5db791);}return null;};}function patchUpdates(_0x4eed54){return function(_0x4c1266){try{jsonpatch[_0x7fd3('0x22')](_0x4c1266,_0x4eed54,!![]);}catch(_0x412f2d){return BPromise[_0x7fd3('0x23')](_0x412f2d);}return _0x4c1266[_0x7fd3('0x24')]();};}function saveUpdates(_0x2ef380,_0x63f618){return function(_0xa9c337){if(_0xa9c337){return _0xa9c337[_0x7fd3('0x25')](_0x2ef380)['then'](function(_0x373d7e){return _0x373d7e;});}return null;};}function removeEntity(_0x4bb46f,_0x39dae6){return function(_0x32cf3a){if(_0x32cf3a){return _0x32cf3a[_0x7fd3('0x26')]()['then'](function(){_0x4bb46f['status'](0xcc)[_0x7fd3('0x1b')]();});}};}function handleEntityNotFound(_0x5d2f5d,_0x336eec){return function(_0x1d0e05){if(!_0x1d0e05){_0x5d2f5d[_0x7fd3('0x19')](0x194);}return _0x1d0e05;};}function handleError(_0x4b3c3a,_0x2f2fe8){_0x2f2fe8=_0x2f2fe8||0x1f4;return function(_0xfe8d82){logger['error'](_0xfe8d82[_0x7fd3('0x27')]);if(_0xfe8d82[_0x7fd3('0x28')]){delete _0xfe8d82[_0x7fd3('0x28')];}_0x4b3c3a['status'](_0x2f2fe8)[_0x7fd3('0x29')](_0xfe8d82);};}exports['index']=function(_0x2a81c5,_0x50e89a){var _0x43f945={},_0x8e3465={},_0xb3008d={'count':0x0,'rows':[]};var _0x563c8e=_[_0x7fd3('0x2a')](db[_0x7fd3('0x2b')][_0x7fd3('0x2c')],function(_0x15c8d0){return{'name':_0x15c8d0[_0x7fd3('0x2d')],'type':_0x15c8d0[_0x7fd3('0x2e')][_0x7fd3('0x2f')]};});_0x8e3465[_0x7fd3('0x30')]=_[_0x7fd3('0x2a')](_0x563c8e,_0x7fd3('0x28'));_0x8e3465[_0x7fd3('0x31')]=_[_0x7fd3('0x32')](_0x2a81c5[_0x7fd3('0x31')]);_0x8e3465[_0x7fd3('0x33')]=_['intersection'](_0x8e3465[_0x7fd3('0x30')],_0x8e3465[_0x7fd3('0x31')]);_0x43f945[_0x7fd3('0x34')]=_['intersection'](_0x8e3465[_0x7fd3('0x30')],qs[_0x7fd3('0x35')](_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x35')]));_0x43f945[_0x7fd3('0x34')]=_0x43f945[_0x7fd3('0x34')]['length']?_0x43f945['attributes']:_0x8e3465[_0x7fd3('0x30')];if(!_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x36')]('nolimit')){_0x43f945[_0x7fd3('0x1f')]=qs['limit'](_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x1f')]);_0x43f945[_0x7fd3('0x1e')]=qs['offset'](_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x1e')]);}_0x43f945['order']=qs[_0x7fd3('0x37')](_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x37')]);_0x43f945[_0x7fd3('0x38')]=qs[_0x7fd3('0x33')](_['pick'](_0x2a81c5['query'],_0x8e3465[_0x7fd3('0x33')]),_0x563c8e);if(_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x39')]){_0x43f945[_0x7fd3('0x38')]=_[_0x7fd3('0x3a')](_0x43f945[_0x7fd3('0x38')],{'$or':_[_0x7fd3('0x2a')](_0x563c8e,function(_0x4110fe){if(_0x4110fe['type']!==_0x7fd3('0x3b')){var _0x598ab4={};_0x598ab4[_0x4110fe[_0x7fd3('0x28')]]={'$like':'%'+_0x2a81c5[_0x7fd3('0x31')][_0x7fd3('0x39')]+'%'};return _0x598ab4;}})});}_0x43f945=_[_0x7fd3('0x3a')]({},_0x43f945,_0x2a81c5[_0x7fd3('0x3c')]);var _0x2e971b={'where':_0x43f945[_0x7fd3('0x38')]};return db[_0x7fd3('0x2b')][_0x7fd3('0x1d')](_0x2e971b)[_0x7fd3('0x3d')](function(_0x3d4127){_0xb3008d[_0x7fd3('0x1d')]=_0x3d4127;if(_0x2a81c5[_0x7fd3('0x31')]['includeAll']){_0x43f945[_0x7fd3('0x3e')]=[{'all':!![]}];}return db[_0x7fd3('0x2b')][_0x7fd3('0x3f')](_0x43f945);})[_0x7fd3('0x3d')](function(_0x5f3afc){_0xb3008d['rows']=_0x5f3afc;return _0xb3008d;})[_0x7fd3('0x3d')](respondWithFilteredResult(_0x50e89a,_0x43f945))['catch'](handleError(_0x50e89a,null));};exports['show']=function(_0x560a8f,_0x34fbf2){var _0x2a2397={'raw':![],'where':{'id':_0x560a8f[_0x7fd3('0x40')]['id']}},_0x559567={};_0x559567[_0x7fd3('0x30')]=_[_0x7fd3('0x32')](db[_0x7fd3('0x2b')][_0x7fd3('0x2c')]);_0x559567[_0x7fd3('0x31')]=_[_0x7fd3('0x32')](_0x560a8f[_0x7fd3('0x31')]);_0x559567['filters']=_[_0x7fd3('0x41')](_0x559567[_0x7fd3('0x30')],_0x559567['query']);_0x2a2397[_0x7fd3('0x34')]=_[_0x7fd3('0x41')](_0x559567[_0x7fd3('0x30')],qs[_0x7fd3('0x35')](_0x560a8f[_0x7fd3('0x31')]['fields']));_0x2a2397['attributes']=_0x2a2397['attributes']['length']?_0x2a2397[_0x7fd3('0x34')]:_0x559567['model'];if(_0x560a8f['query'][_0x7fd3('0x42')]){_0x2a2397[_0x7fd3('0x3e')]=[{'all':!![]}];}_0x2a2397=_[_0x7fd3('0x3a')]({},_0x2a2397,_0x560a8f[_0x7fd3('0x3c')]);return db[_0x7fd3('0x2b')][_0x7fd3('0x43')](_0x2a2397)[_0x7fd3('0x3d')](handleEntityNotFound(_0x34fbf2,null))[_0x7fd3('0x3d')](respondWithResult(_0x34fbf2,null))[_0x7fd3('0x44')](handleError(_0x34fbf2,null));};exports[_0x7fd3('0x45')]=function(_0x5784bf,_0x33a723){return db[_0x7fd3('0x2b')][_0x7fd3('0x45')](_0x5784bf[_0x7fd3('0x46')],{})[_0x7fd3('0x3d')](respondWithResult(_0x33a723,0xc9))[_0x7fd3('0x44')](handleError(_0x33a723,null));};exports[_0x7fd3('0x47')]=function(_0xf270c3,_0x1cc6ea){return db[_0x7fd3('0x2b')][_0x7fd3('0x47')](_0xf270c3[_0x7fd3('0x46')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x1cc6ea,0xc9))[_0x7fd3('0x44')](handleError(_0x1cc6ea,null));};exports[_0x7fd3('0x25')]=function(_0x2bbf0d,_0x89d8ef){if(_0x2bbf0d['body']['id']){delete _0x2bbf0d[_0x7fd3('0x46')]['id'];}return db[_0x7fd3('0x2b')]['find']({'where':{'id':_0x2bbf0d[_0x7fd3('0x40')]['id']}})[_0x7fd3('0x3d')](handleEntityNotFound(_0x89d8ef,null))[_0x7fd3('0x3d')](saveUpdates(_0x2bbf0d[_0x7fd3('0x46')],null))[_0x7fd3('0x3d')](respondWithResult(_0x89d8ef,null))['catch'](handleError(_0x89d8ef,null));};exports[_0x7fd3('0x26')]=function(_0x326bfb,_0x54cba0){return db[_0x7fd3('0x2b')][_0x7fd3('0x43')]({'where':{'id':_0x326bfb['params']['id']}})[_0x7fd3('0x3d')](handleEntityNotFound(_0x54cba0,null))['then'](removeEntity(_0x54cba0,null))[_0x7fd3('0x44')](handleError(_0x54cba0,null));};exports['bulkDestroy']=function(_0x567261,_0x1c7a18){return db['AnalyticFieldReport'][_0x7fd3('0x26')]({'where':{'id':_0x567261[_0x7fd3('0x31')]['ids']||[]},'raw':![],'individualHooks':!![]})[_0x7fd3('0x3d')](respondWithResult(_0x1c7a18,0xcc))[_0x7fd3('0x44')](handleError(_0x1c7a18,null));};exports[_0x7fd3('0x48')]=function(_0x3d8a69,_0x472e1a,_0x5932a6){return db[_0x7fd3('0x49')]['findOne']({'where':{'id':_0x3d8a69[_0x7fd3('0x40')]['id']}})[_0x7fd3('0x3d')](handleEntityNotFound(_0x472e1a,null))['then'](function(_0x2162a6){if(_0x2162a6){return db[_0x7fd3('0x4a')][_0x7fd3('0x4b')](function(_0xcdff21){return db['AnalyticFieldReport'][_0x7fd3('0x26')]({'where':{'CustomReportId':_0x3d8a69[_0x7fd3('0x40')]['id']},'transaction':_0xcdff21})[_0x7fd3('0x3d')](function(_0x39e8c3){var _0x4d7b93=_[_0x7fd3('0x2a')](_0x3d8a69[_0x7fd3('0x46')],function(_0x45f579){delete _0x45f579['id'];_0x45f579[_0x7fd3('0x4c')]=_0x3d8a69['params']['id'];return _0x45f579;});return db['AnalyticFieldReport'][_0x7fd3('0x47')](_0x4d7b93,{'transaction':_0xcdff21});});})[_0x7fd3('0x3d')](function(){return db[_0x7fd3('0x2b')][_0x7fd3('0x3f')]({'where':{'CustomReportId':_0x3d8a69['params']['id']}});});}})[_0x7fd3('0x3d')](respondWithResult(_0x472e1a,null))[_0x7fd3('0x44')](handleError(_0x472e1a,null));};