0fcb08a16f1e50441cd654d831afd380b90c5b2f
[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 _0x7300=['fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','rows','catch','show','length','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','basename','savename','output','existsSync','join','root','server/files/reports','Sequelize','Report\x20not\x20found\x20or\x20empty','download','format','%s.%s','toLowerCase','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','reject','update','destroy','then','ExtractedReports','end','error','stack','name','send','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection'];(function(_0x92706d,_0x5e096c){var _0x15a7eb=function(_0x621d78){while(--_0x621d78){_0x92706d['push'](_0x92706d['shift']());}};_0x15a7eb(++_0x5e096c);}(_0x7300,0x14d));var _0x0730=function(_0x3abc16,_0x241b20){_0x3abc16=_0x3abc16-0x0;var _0x1c834f=_0x7300[_0x3abc16];return _0x1c834f;};'use strict';var emlformat=require(_0x0730('0x0'));var rimraf=require(_0x0730('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x0730('0x2'));var rp=require(_0x0730('0x3'));var moment=require(_0x0730('0x4'));var BPromise=require(_0x0730('0x5'));var Mustache=require(_0x0730('0x6'));var util=require(_0x0730('0x7'));var path=require(_0x0730('0x8'));var sox=require('sox');var csv=require(_0x0730('0x9'));var ejs=require(_0x0730('0xa'));var fs=require('fs');var fs_extra=require(_0x0730('0xb'));var _=require(_0x0730('0xc'));var squel=require(_0x0730('0xd'));var crypto=require(_0x0730('0xe'));var jsforce=require(_0x0730('0xf'));var deskjs=require('desk.js');var toCsv=require(_0x0730('0x9'));var querystring=require(_0x0730('0x10'));var Papa=require('papaparse');var Redis=require(_0x0730('0x11'));var authService=require(_0x0730('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x0730('0x13'));var hardwareService=require(_0x0730('0x14'));var logger=require(_0x0730('0x15'))(_0x0730('0x16'));var utils=require(_0x0730('0x17'));var config=require(_0x0730('0x18'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x21a553,_0x45c920){_0x45c920=_0x45c920||0xcc;return function(_0x4e4a87){if(_0x4e4a87){return _0x21a553[_0x0730('0x19')](_0x45c920);}return _0x21a553[_0x0730('0x1a')](_0x45c920)['end']();};}function respondWithResult(_0x106cb7,_0xd0a885){_0xd0a885=_0xd0a885||0xc8;return function(_0xc09d19){if(_0xc09d19){return _0x106cb7[_0x0730('0x1a')](_0xd0a885)[_0x0730('0x1b')](_0xc09d19);}};}function respondWithFilteredResult(_0x3ff557,_0x1c9154){return function(_0xca3eb6){if(_0xca3eb6){var _0x2ca670=typeof _0x1c9154[_0x0730('0x1c')]===_0x0730('0x1d')&&typeof _0x1c9154[_0x0730('0x1e')]==='undefined';var _0x2c4211=_0xca3eb6[_0x0730('0x1f')];var _0x2b2738=_0x2ca670?0x0:_0x1c9154[_0x0730('0x1c')];var _0x35ade7=_0x2ca670?_0xca3eb6[_0x0730('0x1f')]:_0x1c9154['offset']+_0x1c9154[_0x0730('0x1e')];var _0x127b86;if(_0x35ade7>=_0x2c4211){_0x35ade7=_0x2c4211;_0x127b86=0xc8;}else{_0x127b86=0xce;}_0x3ff557[_0x0730('0x1a')](_0x127b86);return _0x3ff557[_0x0730('0x20')](_0x0730('0x21'),_0x2b2738+'-'+_0x35ade7+'/'+_0x2c4211)[_0x0730('0x1b')](_0xca3eb6);}return null;};}function patchUpdates(_0x1c30a4){return function(_0x42d171){try{jsonpatch['apply'](_0x42d171,_0x1c30a4,!![]);}catch(_0x1c6b95){return BPromise[_0x0730('0x22')](_0x1c6b95);}return _0x42d171['save']();};}function saveUpdates(_0x2c2917,_0x51dc27){return function(_0x1df631){if(_0x1df631){return _0x1df631[_0x0730('0x23')](_0x2c2917)['then'](function(_0x184848){return _0x184848;});}return null;};}function removeEntity(_0x27b09b,_0x698344){return function(_0x1cd1b2){if(_0x1cd1b2){return _0x1cd1b2[_0x0730('0x24')]()[_0x0730('0x25')](function(){var _0x49db7b=_0x1cd1b2['get']({'plain':!![]});var _0x1d2ab7=_0x0730('0x26');return db['UserProfileResource'][_0x0730('0x24')]({'where':{'type':_0x1d2ab7,'resourceId':_0x49db7b['id']}})['then'](function(){return _0x1cd1b2;});})[_0x0730('0x25')](function(){_0x27b09b[_0x0730('0x1a')](0xcc)[_0x0730('0x27')]();});}};}function handleEntityNotFound(_0x5f4d8e,_0x3ad95f){return function(_0x518376){if(!_0x518376){_0x5f4d8e[_0x0730('0x19')](0x194);}return _0x518376;};}function handleError(_0x1d775a,_0x17d146){_0x17d146=_0x17d146||0x1f4;return function(_0xc767f){logger[_0x0730('0x28')](_0xc767f[_0x0730('0x29')]);if(_0xc767f[_0x0730('0x2a')]){delete _0xc767f[_0x0730('0x2a')];}_0x1d775a[_0x0730('0x1a')](_0x17d146)[_0x0730('0x2b')](_0xc767f);};}exports['index']=function(_0x45b24f,_0x35f615){var _0x3170ad={},_0x57eda1={},_0x3083f3={'count':0x0,'rows':[]};var _0x2c6b07=_[_0x0730('0x2c')](db[_0x0730('0x2d')][_0x0730('0x2e')],function(_0x9197af){return{'name':_0x9197af[_0x0730('0x2f')],'type':_0x9197af[_0x0730('0x30')][_0x0730('0x31')]};});_0x57eda1[_0x0730('0x32')]=_[_0x0730('0x2c')](_0x2c6b07,_0x0730('0x2a'));_0x57eda1[_0x0730('0x33')]=_[_0x0730('0x34')](_0x45b24f[_0x0730('0x33')]);_0x57eda1[_0x0730('0x35')]=_[_0x0730('0x36')](_0x57eda1[_0x0730('0x32')],_0x57eda1[_0x0730('0x33')]);_0x3170ad['attributes']=_[_0x0730('0x36')](_0x57eda1[_0x0730('0x32')],qs[_0x0730('0x37')](_0x45b24f[_0x0730('0x33')]['fields']));_0x3170ad[_0x0730('0x38')]=_0x3170ad[_0x0730('0x38')]['length']?_0x3170ad[_0x0730('0x38')]:_0x57eda1['model'];if(!_0x45b24f[_0x0730('0x33')][_0x0730('0x39')](_0x0730('0x3a'))){_0x3170ad['limit']=qs[_0x0730('0x1e')](_0x45b24f['query'][_0x0730('0x1e')]);_0x3170ad[_0x0730('0x1c')]=qs[_0x0730('0x1c')](_0x45b24f['query'][_0x0730('0x1c')]);}_0x3170ad[_0x0730('0x3b')]=qs[_0x0730('0x3c')](_0x45b24f[_0x0730('0x33')][_0x0730('0x3c')]);_0x3170ad[_0x0730('0x3d')]=qs['filters'](_[_0x0730('0x3e')](_0x45b24f[_0x0730('0x33')],_0x57eda1['filters']),_0x2c6b07);if(_0x45b24f[_0x0730('0x33')][_0x0730('0x3f')]){_0x3170ad[_0x0730('0x3d')]=_['merge'](_0x3170ad[_0x0730('0x3d')],{'$or':_['map'](_0x2c6b07,function(_0x4afd7d){if(_0x4afd7d['type']!==_0x0730('0x40')){var _0x35177d={};_0x35177d[_0x4afd7d[_0x0730('0x2a')]]={'$like':'%'+_0x45b24f['query'][_0x0730('0x3f')]+'%'};return _0x35177d;}})});}_0x3170ad=_[_0x0730('0x41')]({},_0x3170ad,_0x45b24f[_0x0730('0x42')]);var _0xacf5ca={'where':_0x3170ad['where']};return db[_0x0730('0x2d')][_0x0730('0x1f')](_0xacf5ca)['then'](function(_0x164a72){_0x3083f3[_0x0730('0x1f')]=_0x164a72;if(_0x45b24f['query'][_0x0730('0x43')]){_0x3170ad[_0x0730('0x44')]=[{'all':!![]}];}return db[_0x0730('0x2d')]['findAll'](_0x3170ad);})['then'](function(_0x6dc19d){_0x3083f3[_0x0730('0x45')]=_0x6dc19d;return _0x3083f3;})[_0x0730('0x25')](respondWithFilteredResult(_0x35f615,_0x3170ad))[_0x0730('0x46')](handleError(_0x35f615,null));};exports[_0x0730('0x47')]=function(_0x51098f,_0x47387b){var _0xdb7142={'raw':!![],'where':{'id':_0x51098f['params']['id']}},_0x403050={};_0x403050['model']=_[_0x0730('0x34')](db[_0x0730('0x2d')]['rawAttributes']);_0x403050[_0x0730('0x33')]=_['keys'](_0x51098f['query']);_0x403050[_0x0730('0x35')]=_[_0x0730('0x36')](_0x403050['model'],_0x403050[_0x0730('0x33')]);_0xdb7142[_0x0730('0x38')]=_['intersection'](_0x403050[_0x0730('0x32')],qs[_0x0730('0x37')](_0x51098f['query'][_0x0730('0x37')]));_0xdb7142[_0x0730('0x38')]=_0xdb7142[_0x0730('0x38')][_0x0730('0x48')]?_0xdb7142[_0x0730('0x38')]:_0x403050[_0x0730('0x32')];if(_0x51098f[_0x0730('0x33')][_0x0730('0x43')]){_0xdb7142[_0x0730('0x44')]=[{'all':!![]}];}_0xdb7142=_[_0x0730('0x41')]({},_0xdb7142,_0x51098f['options']);return db[_0x0730('0x2d')][_0x0730('0x49')](_0xdb7142)['then'](handleEntityNotFound(_0x47387b,null))[_0x0730('0x25')](respondWithResult(_0x47387b,null))[_0x0730('0x46')](handleError(_0x47387b,null));};exports[_0x0730('0x4a')]=function(_0x40abdc,_0x2ca559){return db[_0x0730('0x2d')][_0x0730('0x4a')](_0x40abdc[_0x0730('0x4b')],{})[_0x0730('0x25')](function(_0x2e7197){var _0x4c2520=_0x40abdc[_0x0730('0x4c')][_0x0730('0x4d')]({'plain':!![]});if(!_0x4c2520)throw new Error(_0x0730('0x4e'));if(_0x4c2520[_0x0730('0x4f')]===_0x0730('0x4c')){var _0xffc871=_0x2e7197[_0x0730('0x4d')]({'plain':!![]});var _0x288163=_0x0730('0x26');return db[_0x0730('0x50')][_0x0730('0x49')]({'where':{'name':_0x288163,'userProfileId':_0x4c2520[_0x0730('0x51')]},'raw':!![]})[_0x0730('0x25')](function(_0xa3aa9b){if(_0xa3aa9b&&_0xa3aa9b['autoAssociation']===0x0){return db['UserProfileResource'][_0x0730('0x4a')]({'name':_0xffc871[_0x0730('0x2a')],'resourceId':_0xffc871['id'],'type':_0xa3aa9b[_0x0730('0x2a')],'sectionId':_0xa3aa9b['id']},{})[_0x0730('0x25')](function(){return _0x2e7197;});}else{return _0x2e7197;}})[_0x0730('0x46')](function(_0x282d33){logger[_0x0730('0x28')](_0x0730('0x52'),_0x282d33);throw _0x282d33;});}return _0x2e7197;})[_0x0730('0x25')](respondWithResult(_0x2ca559,0xc9))[_0x0730('0x46')](handleError(_0x2ca559,null));};exports[_0x0730('0x23')]=function(_0x582681,_0x26d240){if(_0x582681[_0x0730('0x4b')]['id']){delete _0x582681[_0x0730('0x4b')]['id'];}return db[_0x0730('0x2d')]['find']({'where':{'id':_0x582681['params']['id']}})[_0x0730('0x25')](handleEntityNotFound(_0x26d240,null))['then'](saveUpdates(_0x582681[_0x0730('0x4b')],null))[_0x0730('0x25')](respondWithResult(_0x26d240,null))[_0x0730('0x46')](handleError(_0x26d240,null));};exports[_0x0730('0x24')]=function(_0x4d28e6,_0x1558e1){return db['AnalyticExtractedReport'][_0x0730('0x49')]({'where':{'id':_0x4d28e6[_0x0730('0x53')]['id']}})['then'](handleEntityNotFound(_0x1558e1,null))['then'](removeEntity(_0x1558e1,null))[_0x0730('0x46')](handleError(_0x1558e1,null));};exports['download']=function(_0x3d0357,_0x739519,_0x28d44d){return db['AnalyticExtractedReport']['find']({'where':{'id':_0x3d0357['params']['id']},'attributes':[_0x0730('0x2a'),_0x0730('0x54'),_0x0730('0x55'),_0x0730('0x56')],'raw':!![]})[_0x0730('0x25')](handleEntityNotFound(_0x739519,null))[_0x0730('0x25')](function(_0x38cb74){if(_0x38cb74){if(!fs[_0x0730('0x57')](path[_0x0730('0x58')](config[_0x0730('0x59')],_0x0730('0x5a'),_0x38cb74['savename']))){throw new db[(_0x0730('0x5b'))]['ValidationError'](_0x0730('0x5c'));}if(_0x3d0357[_0x0730('0x33')]['exists']){return _0x739519['sendStatus'](0xc8);}return _0x739519[_0x0730('0x5d')](path[_0x0730('0x58')](config['root'],_0x0730('0x5a'),_0x38cb74[_0x0730('0x55')]),util[_0x0730('0x5e')](_0x0730('0x5f'),_0x38cb74[_0x0730('0x54')]||_0x38cb74[_0x0730('0x2a')],_0x38cb74[_0x0730('0x56')][_0x0730('0x60')]()));}})[_0x0730('0x46')](handleError(_0x739519,null));};