931e8a977bea91c7ab8594ad2a13f76fc0e4df20
[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 _0x1e43=['UserProfileSection','userProfileId','autoAssociation','params','download','basename','savename','output','existsSync','join','server/files/reports','Sequelize','ValidationError','root','format','%s.%s','toLowerCase','rimraf','zip-dir','request-promise','moment','bluebird','util','path','to-csv','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/license/util','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','update','destroy','then','get','ExtractedReports','UserProfileResource','error','stack','name','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','model','filters','intersection','query','attributes','fields','length','order','sort','where','filter','merge','VIRTUAL','includeAll','include','findAll','catch','keys','find','create','body','role'];(function(_0x50d00f,_0xd2a8bb){var _0x358c70=function(_0x33ab83){while(--_0x33ab83){_0x50d00f['push'](_0x50d00f['shift']());}};_0x358c70(++_0xd2a8bb);}(_0x1e43,0x69));var _0x31e4=function(_0x1ad07b,_0x551d55){_0x1ad07b=_0x1ad07b-0x0;var _0x2c447f=_0x1e43[_0x1ad07b];return _0x2c447f;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x31e4('0x0'));var zipdir=require(_0x31e4('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x31e4('0x2'));var moment=require(_0x31e4('0x3'));var BPromise=require(_0x31e4('0x4'));var Mustache=require('mustache');var util=require(_0x31e4('0x5'));var path=require(_0x31e4('0x6'));var sox=require('sox');var csv=require(_0x31e4('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x31e4('0x8'));var _=require(_0x31e4('0x9'));var squel=require(_0x31e4('0xa'));var crypto=require('crypto');var jsforce=require(_0x31e4('0xb'));var deskjs=require(_0x31e4('0xc'));var toCsv=require(_0x31e4('0x7'));var querystring=require(_0x31e4('0xd'));var Papa=require(_0x31e4('0xe'));var Redis=require(_0x31e4('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x31e4('0x10'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x31e4('0x11'))(_0x31e4('0x12'));var utils=require(_0x31e4('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0x31e4('0x14'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2e1098,_0x301358){_0x301358=_0x301358||0xcc;return function(_0x14ed73){if(_0x14ed73){return _0x2e1098[_0x31e4('0x15')](_0x301358);}return _0x2e1098[_0x31e4('0x16')](_0x301358)[_0x31e4('0x17')]();};}function respondWithResult(_0x130b7d,_0x2b7228){_0x2b7228=_0x2b7228||0xc8;return function(_0x378bfd){if(_0x378bfd){return _0x130b7d['status'](_0x2b7228)[_0x31e4('0x18')](_0x378bfd);}};}function respondWithFilteredResult(_0x4e5093,_0x10d7c9){return function(_0x1de25d){if(_0x1de25d){var _0x3d4f6a=typeof _0x10d7c9[_0x31e4('0x19')]==='undefined'&&typeof _0x10d7c9[_0x31e4('0x1a')]===_0x31e4('0x1b');var _0x1125f4=_0x1de25d[_0x31e4('0x1c')];var _0xcdd8a1=_0x3d4f6a?0x0:_0x10d7c9[_0x31e4('0x19')];var _0x542485=_0x3d4f6a?_0x1de25d[_0x31e4('0x1c')]:_0x10d7c9['offset']+_0x10d7c9[_0x31e4('0x1a')];var _0x1ab25f;if(_0x542485>=_0x1125f4){_0x542485=_0x1125f4;_0x1ab25f=0xc8;}else{_0x1ab25f=0xce;}_0x4e5093[_0x31e4('0x16')](_0x1ab25f);return _0x4e5093[_0x31e4('0x1d')](_0x31e4('0x1e'),_0xcdd8a1+'-'+_0x542485+'/'+_0x1125f4)[_0x31e4('0x18')](_0x1de25d);}return null;};}function patchUpdates(_0x4712f7){return function(_0x25a06d){try{jsonpatch[_0x31e4('0x1f')](_0x25a06d,_0x4712f7,!![]);}catch(_0x162ec1){return BPromise[_0x31e4('0x20')](_0x162ec1);}return _0x25a06d[_0x31e4('0x21')]();};}function saveUpdates(_0x3902a6,_0x53f3ac){return function(_0x5ce198){if(_0x5ce198){return _0x5ce198[_0x31e4('0x22')](_0x3902a6)['then'](function(_0x1f34c7){return _0x1f34c7;});}return null;};}function removeEntity(_0x5b59a4,_0x3f4126){return function(_0x2f549e){if(_0x2f549e){return _0x2f549e[_0x31e4('0x23')]()[_0x31e4('0x24')](function(){var _0x4ef5ec=_0x2f549e[_0x31e4('0x25')]({'plain':!![]});var _0x5afc3b=_0x31e4('0x26');return db[_0x31e4('0x27')]['destroy']({'where':{'type':_0x5afc3b,'resourceId':_0x4ef5ec['id']}})['then'](function(){return _0x2f549e;});})[_0x31e4('0x24')](function(){_0x5b59a4[_0x31e4('0x16')](0xcc)[_0x31e4('0x17')]();});}};}function handleEntityNotFound(_0x3c7ee0,_0xaec60c){return function(_0x2fbbfb){if(!_0x2fbbfb){_0x3c7ee0['sendStatus'](0x194);}return _0x2fbbfb;};}function handleError(_0x4b78d1,_0xb36087){_0xb36087=_0xb36087||0x1f4;return function(_0xc7a7d7){logger[_0x31e4('0x28')](_0xc7a7d7[_0x31e4('0x29')]);if(_0xc7a7d7[_0x31e4('0x2a')]){delete _0xc7a7d7[_0x31e4('0x2a')];}_0x4b78d1[_0x31e4('0x16')](_0xb36087)['send'](_0xc7a7d7);};}exports[_0x31e4('0x2b')]=function(_0x1ff38f,_0x13dec9){var _0x26c848={},_0xffa1ad={},_0x29b94d={'count':0x0,'rows':[]};var _0x3edaca=_[_0x31e4('0x2c')](db[_0x31e4('0x2d')][_0x31e4('0x2e')],function(_0x221698){return{'name':_0x221698[_0x31e4('0x2f')],'type':_0x221698[_0x31e4('0x30')]['key']};});_0xffa1ad[_0x31e4('0x31')]=_[_0x31e4('0x2c')](_0x3edaca,_0x31e4('0x2a'));_0xffa1ad['query']=_['keys'](_0x1ff38f['query']);_0xffa1ad[_0x31e4('0x32')]=_[_0x31e4('0x33')](_0xffa1ad[_0x31e4('0x31')],_0xffa1ad[_0x31e4('0x34')]);_0x26c848[_0x31e4('0x35')]=_['intersection'](_0xffa1ad['model'],qs[_0x31e4('0x36')](_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x36')]));_0x26c848[_0x31e4('0x35')]=_0x26c848[_0x31e4('0x35')][_0x31e4('0x37')]?_0x26c848[_0x31e4('0x35')]:_0xffa1ad[_0x31e4('0x31')];if(!_0x1ff38f[_0x31e4('0x34')]['hasOwnProperty']('nolimit')){_0x26c848['limit']=qs[_0x31e4('0x1a')](_0x1ff38f[_0x31e4('0x34')]['limit']);_0x26c848[_0x31e4('0x19')]=qs['offset'](_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x19')]);}_0x26c848[_0x31e4('0x38')]=qs[_0x31e4('0x39')](_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x39')]);_0x26c848[_0x31e4('0x3a')]=qs[_0x31e4('0x32')](_['pick'](_0x1ff38f[_0x31e4('0x34')],_0xffa1ad[_0x31e4('0x32')]),_0x3edaca);if(_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x3b')]){_0x26c848[_0x31e4('0x3a')]=_[_0x31e4('0x3c')](_0x26c848[_0x31e4('0x3a')],{'$or':_[_0x31e4('0x2c')](_0x3edaca,function(_0x5d2ff0){if(_0x5d2ff0['type']!==_0x31e4('0x3d')){var _0x378158={};_0x378158[_0x5d2ff0[_0x31e4('0x2a')]]={'$like':'%'+_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x3b')]+'%'};return _0x378158;}})});}_0x26c848=_[_0x31e4('0x3c')]({},_0x26c848,_0x1ff38f['options']);var _0x529038={'where':_0x26c848['where']};return db[_0x31e4('0x2d')]['count'](_0x529038)[_0x31e4('0x24')](function(_0x237b47){_0x29b94d[_0x31e4('0x1c')]=_0x237b47;if(_0x1ff38f[_0x31e4('0x34')][_0x31e4('0x3e')]){_0x26c848[_0x31e4('0x3f')]=[{'all':!![]}];}return db[_0x31e4('0x2d')][_0x31e4('0x40')](_0x26c848);})[_0x31e4('0x24')](function(_0x3fd26a){_0x29b94d['rows']=_0x3fd26a;return _0x29b94d;})[_0x31e4('0x24')](respondWithFilteredResult(_0x13dec9,_0x26c848))[_0x31e4('0x41')](handleError(_0x13dec9,null));};exports['show']=function(_0x4f17ea,_0x1efdb2){var _0x3082c5={'raw':!![],'where':{'id':_0x4f17ea['params']['id']}},_0x1f49ac={};_0x1f49ac[_0x31e4('0x31')]=_[_0x31e4('0x42')](db[_0x31e4('0x2d')]['rawAttributes']);_0x1f49ac[_0x31e4('0x34')]=_['keys'](_0x4f17ea[_0x31e4('0x34')]);_0x1f49ac[_0x31e4('0x32')]=_['intersection'](_0x1f49ac['model'],_0x1f49ac[_0x31e4('0x34')]);_0x3082c5['attributes']=_[_0x31e4('0x33')](_0x1f49ac[_0x31e4('0x31')],qs[_0x31e4('0x36')](_0x4f17ea['query'][_0x31e4('0x36')]));_0x3082c5[_0x31e4('0x35')]=_0x3082c5[_0x31e4('0x35')]['length']?_0x3082c5['attributes']:_0x1f49ac['model'];if(_0x4f17ea[_0x31e4('0x34')]['includeAll']){_0x3082c5[_0x31e4('0x3f')]=[{'all':!![]}];}_0x3082c5=_[_0x31e4('0x3c')]({},_0x3082c5,_0x4f17ea['options']);return db[_0x31e4('0x2d')][_0x31e4('0x43')](_0x3082c5)['then'](handleEntityNotFound(_0x1efdb2,null))[_0x31e4('0x24')](respondWithResult(_0x1efdb2,null))[_0x31e4('0x41')](handleError(_0x1efdb2,null));};exports[_0x31e4('0x44')]=function(_0x55ae7e,_0x2da0a4){return db[_0x31e4('0x2d')][_0x31e4('0x44')](_0x55ae7e[_0x31e4('0x45')],{})[_0x31e4('0x24')](function(_0x42c171){var _0x1e2a2a=_0x55ae7e['user'][_0x31e4('0x25')]({'plain':!![]});if(!_0x1e2a2a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1e2a2a[_0x31e4('0x46')]==='user'){var _0x54aa3b=_0x42c171[_0x31e4('0x25')]({'plain':!![]});var _0x4af3d9=_0x31e4('0x26');return db[_0x31e4('0x47')]['find']({'where':{'name':_0x4af3d9,'userProfileId':_0x1e2a2a[_0x31e4('0x48')]},'raw':!![]})[_0x31e4('0x24')](function(_0x40acae){if(_0x40acae&&_0x40acae[_0x31e4('0x49')]===0x0){return db[_0x31e4('0x27')]['create']({'name':_0x54aa3b[_0x31e4('0x2a')],'resourceId':_0x54aa3b['id'],'type':_0x40acae[_0x31e4('0x2a')],'sectionId':_0x40acae['id']},{})[_0x31e4('0x24')](function(){return _0x42c171;});}else{return _0x42c171;}})[_0x31e4('0x41')](function(_0x15a178){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x15a178);throw _0x15a178;});}return _0x42c171;})[_0x31e4('0x24')](respondWithResult(_0x2da0a4,0xc9))[_0x31e4('0x41')](handleError(_0x2da0a4,null));};exports['update']=function(_0x1fd0ef,_0x1c92ab){if(_0x1fd0ef['body']['id']){delete _0x1fd0ef[_0x31e4('0x45')]['id'];}return db[_0x31e4('0x2d')]['find']({'where':{'id':_0x1fd0ef[_0x31e4('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1c92ab,null))[_0x31e4('0x24')](saveUpdates(_0x1fd0ef['body'],null))['then'](respondWithResult(_0x1c92ab,null))[_0x31e4('0x41')](handleError(_0x1c92ab,null));};exports[_0x31e4('0x23')]=function(_0x1b0b36,_0x5ddb37){return db[_0x31e4('0x2d')]['find']({'where':{'id':_0x1b0b36[_0x31e4('0x4a')]['id']}})[_0x31e4('0x24')](handleEntityNotFound(_0x5ddb37,null))['then'](removeEntity(_0x5ddb37,null))['catch'](handleError(_0x5ddb37,null));};exports[_0x31e4('0x4b')]=function(_0x45b800,_0x5829a7,_0x4ec81d){return db[_0x31e4('0x2d')][_0x31e4('0x43')]({'where':{'id':_0x45b800['params']['id']},'attributes':[_0x31e4('0x2a'),_0x31e4('0x4c'),_0x31e4('0x4d'),_0x31e4('0x4e')],'raw':!![]})['then'](handleEntityNotFound(_0x5829a7,null))[_0x31e4('0x24')](function(_0x580501){if(_0x580501){if(!fs[_0x31e4('0x4f')](path[_0x31e4('0x50')](config['root'],_0x31e4('0x51'),_0x580501[_0x31e4('0x4d')]))){throw new db[(_0x31e4('0x52'))][(_0x31e4('0x53'))]('Report\x20not\x20found\x20or\x20empty');}if(_0x45b800[_0x31e4('0x34')]['exists']){return _0x5829a7[_0x31e4('0x15')](0xc8);}return _0x5829a7[_0x31e4('0x4b')](path['join'](config[_0x31e4('0x54')],'server/files/reports',_0x580501['savename']),util[_0x31e4('0x55')](_0x31e4('0x56'),_0x580501[_0x31e4('0x4c')]||_0x580501['name'],_0x580501[_0x31e4('0x4e')][_0x31e4('0x57')]()));}})[_0x31e4('0x41')](handleError(_0x5829a7,null));};