Built motion from commit b5996064.|2.6.21
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.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 _0xcc0b=['moment','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','status','end','offset','undefined','limit','count','Content-Range','json','apply','reject','update','then','destroy','ExtractedReports','sendStatus','error','stack','name','send','index','map','AnalyticExtractedReport','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','rawAttributes','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','get','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','basename','savename','output','existsSync','join','root','Sequelize','ValidationError','exists','format','eml-format','fast-json-patch','request-promise'];(function(_0x598bdb,_0x4065df){var _0x5b818b=function(_0xfaf9ef){while(--_0xfaf9ef){_0x598bdb['push'](_0x598bdb['shift']());}};_0x5b818b(++_0x4065df);}(_0xcc0b,0x10e));var _0xbcc0=function(_0x4d06fb,_0x55390d){_0x4d06fb=_0x4d06fb-0x0;var _0x2e42fc=_0xcc0b[_0x4d06fb];return _0x2e42fc;};'use strict';var emlformat=require(_0xbcc0('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xbcc0('0x1'));var rp=require(_0xbcc0('0x2'));var moment=require(_0xbcc0('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xbcc0('0x4'));var sox=require(_0xbcc0('0x5'));var csv=require(_0xbcc0('0x6'));var ejs=require(_0xbcc0('0x7'));var fs=require('fs');var fs_extra=require(_0xbcc0('0x8'));var _=require(_0xbcc0('0x9'));var squel=require(_0xbcc0('0xa'));var crypto=require(_0xbcc0('0xb'));var jsforce=require(_0xbcc0('0xc'));var deskjs=require(_0xbcc0('0xd'));var toCsv=require(_0xbcc0('0x6'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xbcc0('0xe'));var qs=require('../../components/parsers/qs');var as=require(_0xbcc0('0xf'));var hardwareService=require(_0xbcc0('0x10'));var logger=require(_0xbcc0('0x11'))(_0xbcc0('0x12'));var utils=require(_0xbcc0('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0xbcc0('0x14'));var db=require(_0xbcc0('0x15'))['db'];function respondWithStatusCode(_0x217c29,_0x4bc585){_0x4bc585=_0x4bc585||0xcc;return function(_0x1072ce){if(_0x1072ce){return _0x217c29['sendStatus'](_0x4bc585);}return _0x217c29[_0xbcc0('0x16')](_0x4bc585)[_0xbcc0('0x17')]();};}function respondWithResult(_0x1b9816,_0x25d43c){_0x25d43c=_0x25d43c||0xc8;return function(_0x47e162){if(_0x47e162){return _0x1b9816['status'](_0x25d43c)['json'](_0x47e162);}};}function respondWithFilteredResult(_0x54973b,_0x45486a){return function(_0x3a5093){if(_0x3a5093){var _0x137200=typeof _0x45486a[_0xbcc0('0x18')]===_0xbcc0('0x19')&&typeof _0x45486a[_0xbcc0('0x1a')]===_0xbcc0('0x19');var _0x5174eb=_0x3a5093[_0xbcc0('0x1b')];var _0x90c4d6=_0x137200?0x0:_0x45486a[_0xbcc0('0x18')];var _0x37c5cd=_0x137200?_0x3a5093[_0xbcc0('0x1b')]:_0x45486a[_0xbcc0('0x18')]+_0x45486a[_0xbcc0('0x1a')];var _0x133e1d;if(_0x37c5cd>=_0x5174eb){_0x37c5cd=_0x5174eb;_0x133e1d=0xc8;}else{_0x133e1d=0xce;}_0x54973b['status'](_0x133e1d);return _0x54973b['set'](_0xbcc0('0x1c'),_0x90c4d6+'-'+_0x37c5cd+'/'+_0x5174eb)[_0xbcc0('0x1d')](_0x3a5093);}return null;};}function patchUpdates(_0x33a1d6){return function(_0x795bfc){try{jsonpatch[_0xbcc0('0x1e')](_0x795bfc,_0x33a1d6,!![]);}catch(_0x27635a){return BPromise[_0xbcc0('0x1f')](_0x27635a);}return _0x795bfc['save']();};}function saveUpdates(_0x2a127c,_0x19285c){return function(_0xcac76e){if(_0xcac76e){return _0xcac76e[_0xbcc0('0x20')](_0x2a127c)[_0xbcc0('0x21')](function(_0x1db301){return _0x1db301;});}return null;};}function removeEntity(_0x415729,_0xdf3190){return function(_0x1bdc66){if(_0x1bdc66){return _0x1bdc66[_0xbcc0('0x22')]()[_0xbcc0('0x21')](function(){var _0x1b5223=_0x1bdc66['get']({'plain':!![]});var _0x46faec=_0xbcc0('0x23');return db['UserProfileResource'][_0xbcc0('0x22')]({'where':{'type':_0x46faec,'resourceId':_0x1b5223['id']}})[_0xbcc0('0x21')](function(){return _0x1bdc66;});})['then'](function(){_0x415729[_0xbcc0('0x16')](0xcc)[_0xbcc0('0x17')]();});}};}function handleEntityNotFound(_0x31b61f,_0x3fee36){return function(_0x407ade){if(!_0x407ade){_0x31b61f[_0xbcc0('0x24')](0x194);}return _0x407ade;};}function handleError(_0x52217d,_0x1fe350){_0x1fe350=_0x1fe350||0x1f4;return function(_0x194a9c){logger[_0xbcc0('0x25')](_0x194a9c[_0xbcc0('0x26')]);if(_0x194a9c['name']){delete _0x194a9c[_0xbcc0('0x27')];}_0x52217d[_0xbcc0('0x16')](_0x1fe350)[_0xbcc0('0x28')](_0x194a9c);};}exports[_0xbcc0('0x29')]=function(_0x3590f9,_0x1596a5){var _0x56dc9c={},_0x4ec02e={},_0x163c17={'count':0x0,'rows':[]};var _0xfdde1f=_[_0xbcc0('0x2a')](db[_0xbcc0('0x2b')]['rawAttributes'],function(_0x47095f){return{'name':_0x47095f[_0xbcc0('0x2c')],'type':_0x47095f[_0xbcc0('0x2d')]['key']};});_0x4ec02e[_0xbcc0('0x2e')]=_[_0xbcc0('0x2a')](_0xfdde1f,_0xbcc0('0x27'));_0x4ec02e[_0xbcc0('0x2f')]=_[_0xbcc0('0x30')](_0x3590f9[_0xbcc0('0x2f')]);_0x4ec02e[_0xbcc0('0x31')]=_[_0xbcc0('0x32')](_0x4ec02e[_0xbcc0('0x2e')],_0x4ec02e[_0xbcc0('0x2f')]);_0x56dc9c[_0xbcc0('0x33')]=_['intersection'](_0x4ec02e[_0xbcc0('0x2e')],qs[_0xbcc0('0x34')](_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x34')]));_0x56dc9c[_0xbcc0('0x33')]=_0x56dc9c['attributes'][_0xbcc0('0x35')]?_0x56dc9c[_0xbcc0('0x33')]:_0x4ec02e['model'];if(!_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x36')](_0xbcc0('0x37'))){_0x56dc9c[_0xbcc0('0x1a')]=qs['limit'](_0x3590f9['query'][_0xbcc0('0x1a')]);_0x56dc9c[_0xbcc0('0x18')]=qs['offset'](_0x3590f9['query'][_0xbcc0('0x18')]);}_0x56dc9c['order']=qs[_0xbcc0('0x38')](_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x38')]);_0x56dc9c[_0xbcc0('0x39')]=qs[_0xbcc0('0x31')](_['pick'](_0x3590f9[_0xbcc0('0x2f')],_0x4ec02e[_0xbcc0('0x31')]),_0xfdde1f);if(_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x3a')]){_0x56dc9c['where']=_[_0xbcc0('0x3b')](_0x56dc9c['where'],{'$or':_[_0xbcc0('0x2a')](_0xfdde1f,function(_0xaa37e2){if(_0xaa37e2['type']!==_0xbcc0('0x3c')){var _0x375b1d={};_0x375b1d[_0xaa37e2[_0xbcc0('0x27')]]={'$like':'%'+_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x3a')]+'%'};return _0x375b1d;}})});}_0x56dc9c=_[_0xbcc0('0x3b')]({},_0x56dc9c,_0x3590f9[_0xbcc0('0x3d')]);var _0x351d51={'where':_0x56dc9c['where']};return db[_0xbcc0('0x2b')]['count'](_0x351d51)[_0xbcc0('0x21')](function(_0x4796aa){_0x163c17[_0xbcc0('0x1b')]=_0x4796aa;if(_0x3590f9[_0xbcc0('0x2f')][_0xbcc0('0x3e')]){_0x56dc9c[_0xbcc0('0x3f')]=[{'all':!![]}];}return db[_0xbcc0('0x2b')][_0xbcc0('0x40')](_0x56dc9c);})[_0xbcc0('0x21')](function(_0x7ff841){_0x163c17[_0xbcc0('0x41')]=_0x7ff841;return _0x163c17;})[_0xbcc0('0x21')](respondWithFilteredResult(_0x1596a5,_0x56dc9c))[_0xbcc0('0x42')](handleError(_0x1596a5,null));};exports[_0xbcc0('0x43')]=function(_0xe82cd7,_0x47c5b7){var _0x52544e={'raw':!![],'where':{'id':_0xe82cd7['params']['id']}},_0x274ffb={};_0x274ffb[_0xbcc0('0x2e')]=_['keys'](db['AnalyticExtractedReport'][_0xbcc0('0x44')]);_0x274ffb[_0xbcc0('0x2f')]=_['keys'](_0xe82cd7[_0xbcc0('0x2f')]);_0x274ffb[_0xbcc0('0x31')]=_['intersection'](_0x274ffb[_0xbcc0('0x2e')],_0x274ffb[_0xbcc0('0x2f')]);_0x52544e[_0xbcc0('0x33')]=_[_0xbcc0('0x32')](_0x274ffb[_0xbcc0('0x2e')],qs[_0xbcc0('0x34')](_0xe82cd7['query'][_0xbcc0('0x34')]));_0x52544e['attributes']=_0x52544e[_0xbcc0('0x33')][_0xbcc0('0x35')]?_0x52544e[_0xbcc0('0x33')]:_0x274ffb[_0xbcc0('0x2e')];if(_0xe82cd7[_0xbcc0('0x2f')][_0xbcc0('0x3e')]){_0x52544e[_0xbcc0('0x3f')]=[{'all':!![]}];}_0x52544e=_['merge']({},_0x52544e,_0xe82cd7[_0xbcc0('0x3d')]);return db[_0xbcc0('0x2b')][_0xbcc0('0x45')](_0x52544e)[_0xbcc0('0x21')](handleEntityNotFound(_0x47c5b7,null))[_0xbcc0('0x21')](respondWithResult(_0x47c5b7,null))[_0xbcc0('0x42')](handleError(_0x47c5b7,null));};exports[_0xbcc0('0x46')]=function(_0xd6c377,_0x1cca57){return db['AnalyticExtractedReport'][_0xbcc0('0x46')](_0xd6c377[_0xbcc0('0x47')],{})[_0xbcc0('0x21')](function(_0x5aef4b){var _0x1ceee9=_0xd6c377[_0xbcc0('0x48')]['get']({'plain':!![]});if(!_0x1ceee9)throw new Error(_0xbcc0('0x49'));if(_0x1ceee9['role']===_0xbcc0('0x48')){var _0x31bb61=_0x5aef4b[_0xbcc0('0x4a')]({'plain':!![]});var _0x4245b9=_0xbcc0('0x23');return db[_0xbcc0('0x4b')]['find']({'where':{'name':_0x4245b9,'userProfileId':_0x1ceee9[_0xbcc0('0x4c')]},'raw':!![]})[_0xbcc0('0x21')](function(_0x5331aa){if(_0x5331aa&&_0x5331aa[_0xbcc0('0x4d')]===0x0){return db[_0xbcc0('0x4e')][_0xbcc0('0x46')]({'name':_0x31bb61[_0xbcc0('0x27')],'resourceId':_0x31bb61['id'],'type':_0x5331aa[_0xbcc0('0x27')],'sectionId':_0x5331aa['id']},{})[_0xbcc0('0x21')](function(){return _0x5aef4b;});}else{return _0x5aef4b;}})[_0xbcc0('0x42')](function(_0xf6e33f){logger['error'](_0xbcc0('0x4f'),_0xf6e33f);throw _0xf6e33f;});}return _0x5aef4b;})[_0xbcc0('0x21')](respondWithResult(_0x1cca57,0xc9))[_0xbcc0('0x42')](handleError(_0x1cca57,null));};exports[_0xbcc0('0x20')]=function(_0x15dbb8,_0x16ac53){if(_0x15dbb8[_0xbcc0('0x47')]['id']){delete _0x15dbb8['body']['id'];}return db['AnalyticExtractedReport'][_0xbcc0('0x45')]({'where':{'id':_0x15dbb8[_0xbcc0('0x50')]['id']}})[_0xbcc0('0x21')](handleEntityNotFound(_0x16ac53,null))['then'](saveUpdates(_0x15dbb8['body'],null))[_0xbcc0('0x21')](respondWithResult(_0x16ac53,null))['catch'](handleError(_0x16ac53,null));};exports[_0xbcc0('0x22')]=function(_0x3b7ccf,_0x54d93b){return db[_0xbcc0('0x2b')][_0xbcc0('0x45')]({'where':{'id':_0x3b7ccf[_0xbcc0('0x50')]['id']}})[_0xbcc0('0x21')](handleEntityNotFound(_0x54d93b,null))[_0xbcc0('0x21')](removeEntity(_0x54d93b,null))[_0xbcc0('0x42')](handleError(_0x54d93b,null));};exports['download']=function(_0x249ff4,_0x23f47c,_0x105311){return db[_0xbcc0('0x2b')][_0xbcc0('0x45')]({'where':{'id':_0x249ff4[_0xbcc0('0x50')]['id']},'attributes':[_0xbcc0('0x27'),_0xbcc0('0x51'),_0xbcc0('0x52'),_0xbcc0('0x53')],'raw':!![]})[_0xbcc0('0x21')](handleEntityNotFound(_0x23f47c,null))['then'](function(_0x26c73e){if(_0x26c73e){if(!fs[_0xbcc0('0x54')](path[_0xbcc0('0x55')](config[_0xbcc0('0x56')],'server/files/reports',_0x26c73e['savename']))){throw new db[(_0xbcc0('0x57'))][(_0xbcc0('0x58'))]('Report\x20not\x20found\x20or\x20empty');}if(_0x249ff4[_0xbcc0('0x2f')][_0xbcc0('0x59')]){return _0x23f47c[_0xbcc0('0x24')](0xc8);}return _0x23f47c['download'](path[_0xbcc0('0x55')](config['root'],'server/files/reports',_0x26c73e[_0xbcc0('0x52')]),util[_0xbcc0('0x5a')]('%s.%s',_0x26c73e[_0xbcc0('0x51')]||_0x26c73e[_0xbcc0('0x27')],_0x26c73e['output']['toLowerCase']()));}})[_0xbcc0('0x42')](handleError(_0x23f47c,null));};