Built motion from commit 953226e6.|2.6.32
[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 _0xcb4e=['../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','set','Content-Range','apply','reject','save','update','then','destroy','ExtractedReports','UserProfileResource','error','stack','name','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','include','catch','show','params','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','basename','root','server/files/reports','savename','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','exists','download','join','format','%s.%s','output','eml-format','fast-json-patch','moment','bluebird','to-csv','fs-extra','lodash','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils'];(function(_0x32255e,_0x385ff8){var _0x598fc1=function(_0x5d38de){while(--_0x5d38de){_0x32255e['push'](_0x32255e['shift']());}};_0x598fc1(++_0x385ff8);}(_0xcb4e,0xa2));var _0xecb4=function(_0x41fd4a,_0x168a17){_0x41fd4a=_0x41fd4a-0x0;var _0x269875=_0xcb4e[_0x41fd4a];return _0x269875;};'use strict';var emlformat=require(_0xecb4('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xecb4('0x1'));var rp=require('request-promise');var moment=require(_0xecb4('0x2'));var BPromise=require(_0xecb4('0x3'));var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require('sox');var csv=require(_0xecb4('0x4'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xecb4('0x5'));var _=require(_0xecb4('0x6'));var squel=require('squel');var crypto=require(_0xecb4('0x7'));var jsforce=require('jsforce');var deskjs=require(_0xecb4('0x8'));var toCsv=require('to-csv');var querystring=require(_0xecb4('0x9'));var Papa=require(_0xecb4('0xa'));var Redis=require(_0xecb4('0xb'));var authService=require(_0xecb4('0xc'));var qs=require(_0xecb4('0xd'));var as=require(_0xecb4('0xe'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xecb4('0xf'))(_0xecb4('0x10'));var utils=require(_0xecb4('0x11'));var config=require(_0xecb4('0x12'));var licenseUtil=require('../../config/license/util');var db=require(_0xecb4('0x13'))['db'];function respondWithStatusCode(_0x9f7ca6,_0x3f1007){_0x3f1007=_0x3f1007||0xcc;return function(_0x2450aa){if(_0x2450aa){return _0x9f7ca6[_0xecb4('0x14')](_0x3f1007);}return _0x9f7ca6[_0xecb4('0x15')](_0x3f1007)[_0xecb4('0x16')]();};}function respondWithResult(_0x1367fd,_0x2a7149){_0x2a7149=_0x2a7149||0xc8;return function(_0x10547c){if(_0x10547c){return _0x1367fd[_0xecb4('0x15')](_0x2a7149)[_0xecb4('0x17')](_0x10547c);}};}function respondWithFilteredResult(_0x346228,_0x4028fa){return function(_0xd7f045){if(_0xd7f045){var _0x45b2b6=typeof _0x4028fa[_0xecb4('0x18')]===_0xecb4('0x19')&&typeof _0x4028fa[_0xecb4('0x1a')]==='undefined';var _0x1195e4=_0xd7f045['count'];var _0x4bb5df=_0x45b2b6?0x0:_0x4028fa['offset'];var _0x2691b5=_0x45b2b6?_0xd7f045['count']:_0x4028fa['offset']+_0x4028fa[_0xecb4('0x1a')];var _0x348773;if(_0x2691b5>=_0x1195e4){_0x2691b5=_0x1195e4;_0x348773=0xc8;}else{_0x348773=0xce;}_0x346228['status'](_0x348773);return _0x346228[_0xecb4('0x1b')](_0xecb4('0x1c'),_0x4bb5df+'-'+_0x2691b5+'/'+_0x1195e4)['json'](_0xd7f045);}return null;};}function patchUpdates(_0x243283){return function(_0x395ed0){try{jsonpatch[_0xecb4('0x1d')](_0x395ed0,_0x243283,!![]);}catch(_0x142484){return BPromise[_0xecb4('0x1e')](_0x142484);}return _0x395ed0[_0xecb4('0x1f')]();};}function saveUpdates(_0x1402a6,_0x52ffb5){return function(_0x1325e0){if(_0x1325e0){return _0x1325e0[_0xecb4('0x20')](_0x1402a6)[_0xecb4('0x21')](function(_0x1ba9f7){return _0x1ba9f7;});}return null;};}function removeEntity(_0x428d67,_0x3001ef){return function(_0x28fe2e){if(_0x28fe2e){return _0x28fe2e[_0xecb4('0x22')]()[_0xecb4('0x21')](function(){var _0xcc6baf=_0x28fe2e['get']({'plain':!![]});var _0x539e62=_0xecb4('0x23');return db[_0xecb4('0x24')][_0xecb4('0x22')]({'where':{'type':_0x539e62,'resourceId':_0xcc6baf['id']}})['then'](function(){return _0x28fe2e;});})[_0xecb4('0x21')](function(){_0x428d67['status'](0xcc)[_0xecb4('0x16')]();});}};}function handleEntityNotFound(_0x39edda,_0x2faf96){return function(_0x5a14e9){if(!_0x5a14e9){_0x39edda[_0xecb4('0x14')](0x194);}return _0x5a14e9;};}function handleError(_0x3537da,_0x3dabfa){_0x3dabfa=_0x3dabfa||0x1f4;return function(_0x14f940){logger[_0xecb4('0x25')](_0x14f940[_0xecb4('0x26')]);if(_0x14f940[_0xecb4('0x27')]){delete _0x14f940[_0xecb4('0x27')];}_0x3537da[_0xecb4('0x15')](_0x3dabfa)['send'](_0x14f940);};}exports['index']=function(_0x4a9ee8,_0x3249a6){var _0x331f63={},_0x12bbc8={},_0x590791={'count':0x0,'rows':[]};var _0x2175e0=_[_0xecb4('0x28')](db[_0xecb4('0x29')][_0xecb4('0x2a')],function(_0x5a1226){return{'name':_0x5a1226[_0xecb4('0x2b')],'type':_0x5a1226[_0xecb4('0x2c')][_0xecb4('0x2d')]};});_0x12bbc8[_0xecb4('0x2e')]=_[_0xecb4('0x28')](_0x2175e0,_0xecb4('0x27'));_0x12bbc8['query']=_[_0xecb4('0x2f')](_0x4a9ee8[_0xecb4('0x30')]);_0x12bbc8[_0xecb4('0x31')]=_[_0xecb4('0x32')](_0x12bbc8[_0xecb4('0x2e')],_0x12bbc8[_0xecb4('0x30')]);_0x331f63[_0xecb4('0x33')]=_[_0xecb4('0x32')](_0x12bbc8['model'],qs[_0xecb4('0x34')](_0x4a9ee8[_0xecb4('0x30')]['fields']));_0x331f63[_0xecb4('0x33')]=_0x331f63[_0xecb4('0x33')][_0xecb4('0x35')]?_0x331f63['attributes']:_0x12bbc8[_0xecb4('0x2e')];if(!_0x4a9ee8[_0xecb4('0x30')][_0xecb4('0x36')](_0xecb4('0x37'))){_0x331f63[_0xecb4('0x1a')]=qs['limit'](_0x4a9ee8['query'][_0xecb4('0x1a')]);_0x331f63[_0xecb4('0x18')]=qs[_0xecb4('0x18')](_0x4a9ee8[_0xecb4('0x30')][_0xecb4('0x18')]);}_0x331f63[_0xecb4('0x38')]=qs[_0xecb4('0x39')](_0x4a9ee8[_0xecb4('0x30')][_0xecb4('0x39')]);_0x331f63[_0xecb4('0x3a')]=qs['filters'](_[_0xecb4('0x3b')](_0x4a9ee8[_0xecb4('0x30')],_0x12bbc8['filters']),_0x2175e0);if(_0x4a9ee8[_0xecb4('0x30')]['filter']){_0x331f63[_0xecb4('0x3a')]=_[_0xecb4('0x3c')](_0x331f63[_0xecb4('0x3a')],{'$or':_['map'](_0x2175e0,function(_0x5142f6){if(_0x5142f6[_0xecb4('0x2c')]!==_0xecb4('0x3d')){var _0x5ade9b={};_0x5ade9b[_0x5142f6['name']]={'$like':'%'+_0x4a9ee8[_0xecb4('0x30')][_0xecb4('0x3e')]+'%'};return _0x5ade9b;}})});}_0x331f63=_[_0xecb4('0x3c')]({},_0x331f63,_0x4a9ee8[_0xecb4('0x3f')]);var _0xb66534={'where':_0x331f63[_0xecb4('0x3a')]};return db[_0xecb4('0x29')]['count'](_0xb66534)[_0xecb4('0x21')](function(_0x565b5c){_0x590791['count']=_0x565b5c;if(_0x4a9ee8[_0xecb4('0x30')]['includeAll']){_0x331f63[_0xecb4('0x40')]=[{'all':!![]}];}return db[_0xecb4('0x29')]['findAll'](_0x331f63);})['then'](function(_0x21e0eb){_0x590791['rows']=_0x21e0eb;return _0x590791;})[_0xecb4('0x21')](respondWithFilteredResult(_0x3249a6,_0x331f63))[_0xecb4('0x41')](handleError(_0x3249a6,null));};exports[_0xecb4('0x42')]=function(_0x197412,_0x1b4882){var _0x18d9ec={'raw':!![],'where':{'id':_0x197412[_0xecb4('0x43')]['id']}},_0x584a89={};_0x584a89[_0xecb4('0x2e')]=_[_0xecb4('0x2f')](db['AnalyticExtractedReport'][_0xecb4('0x2a')]);_0x584a89[_0xecb4('0x30')]=_['keys'](_0x197412[_0xecb4('0x30')]);_0x584a89[_0xecb4('0x31')]=_[_0xecb4('0x32')](_0x584a89[_0xecb4('0x2e')],_0x584a89[_0xecb4('0x30')]);_0x18d9ec[_0xecb4('0x33')]=_['intersection'](_0x584a89[_0xecb4('0x2e')],qs[_0xecb4('0x34')](_0x197412['query'][_0xecb4('0x34')]));_0x18d9ec[_0xecb4('0x33')]=_0x18d9ec['attributes']['length']?_0x18d9ec[_0xecb4('0x33')]:_0x584a89['model'];if(_0x197412[_0xecb4('0x30')]['includeAll']){_0x18d9ec[_0xecb4('0x40')]=[{'all':!![]}];}_0x18d9ec=_['merge']({},_0x18d9ec,_0x197412[_0xecb4('0x3f')]);return db[_0xecb4('0x29')][_0xecb4('0x44')](_0x18d9ec)[_0xecb4('0x21')](handleEntityNotFound(_0x1b4882,null))[_0xecb4('0x21')](respondWithResult(_0x1b4882,null))[_0xecb4('0x41')](handleError(_0x1b4882,null));};exports[_0xecb4('0x45')]=function(_0x1517b8,_0x74969d){return db[_0xecb4('0x29')][_0xecb4('0x45')](_0x1517b8[_0xecb4('0x46')],{})['then'](function(_0x14ba7e){var _0x5cb29a=_0x1517b8[_0xecb4('0x47')][_0xecb4('0x48')]({'plain':!![]});if(!_0x5cb29a)throw new Error(_0xecb4('0x49'));if(_0x5cb29a[_0xecb4('0x4a')]===_0xecb4('0x47')){var _0xe5657c=_0x14ba7e[_0xecb4('0x48')]({'plain':!![]});var _0x713e38='ExtractedReports';return db[_0xecb4('0x4b')][_0xecb4('0x44')]({'where':{'name':_0x713e38,'userProfileId':_0x5cb29a['userProfileId']},'raw':!![]})['then'](function(_0x58f04c){if(_0x58f04c&&_0x58f04c[_0xecb4('0x4c')]===0x0){return db[_0xecb4('0x24')][_0xecb4('0x45')]({'name':_0xe5657c[_0xecb4('0x27')],'resourceId':_0xe5657c['id'],'type':_0x58f04c['name'],'sectionId':_0x58f04c['id']},{})[_0xecb4('0x21')](function(){return _0x14ba7e;});}else{return _0x14ba7e;}})['catch'](function(_0x48e0bc){logger[_0xecb4('0x25')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x48e0bc);throw _0x48e0bc;});}return _0x14ba7e;})[_0xecb4('0x21')](respondWithResult(_0x74969d,0xc9))['catch'](handleError(_0x74969d,null));};exports[_0xecb4('0x20')]=function(_0x2b0f58,_0x12b79e){if(_0x2b0f58[_0xecb4('0x46')]['id']){delete _0x2b0f58[_0xecb4('0x46')]['id'];}return db[_0xecb4('0x29')]['find']({'where':{'id':_0x2b0f58[_0xecb4('0x43')]['id']}})[_0xecb4('0x21')](handleEntityNotFound(_0x12b79e,null))['then'](saveUpdates(_0x2b0f58[_0xecb4('0x46')],null))[_0xecb4('0x21')](respondWithResult(_0x12b79e,null))[_0xecb4('0x41')](handleError(_0x12b79e,null));};exports[_0xecb4('0x22')]=function(_0x4f6e1b,_0x484eed){return db['AnalyticExtractedReport'][_0xecb4('0x44')]({'where':{'id':_0x4f6e1b[_0xecb4('0x43')]['id']}})[_0xecb4('0x21')](handleEntityNotFound(_0x484eed,null))[_0xecb4('0x21')](removeEntity(_0x484eed,null))['catch'](handleError(_0x484eed,null));};exports['download']=function(_0x125fd2,_0x14c1b6,_0xa3b91f){return db['AnalyticExtractedReport'][_0xecb4('0x44')]({'where':{'id':_0x125fd2[_0xecb4('0x43')]['id']},'attributes':['name',_0xecb4('0x4d'),'savename','output'],'raw':!![]})['then'](handleEntityNotFound(_0x14c1b6,null))['then'](function(_0xd833b8){if(_0xd833b8){if(!fs['existsSync'](path['join'](config[_0xecb4('0x4e')],_0xecb4('0x4f'),_0xd833b8[_0xecb4('0x50')]))){throw new db[(_0xecb4('0x51'))][(_0xecb4('0x52'))](_0xecb4('0x53'));}if(_0x125fd2['query'][_0xecb4('0x54')]){return _0x14c1b6[_0xecb4('0x14')](0xc8);}return _0x14c1b6[_0xecb4('0x55')](path[_0xecb4('0x56')](config[_0xecb4('0x4e')],_0xecb4('0x4f'),_0xd833b8['savename']),util[_0xecb4('0x57')](_0xecb4('0x58'),_0xd833b8['basename']||_0xd833b8[_0xecb4('0x27')],_0xd833b8[_0xecb4('0x59')]['toLowerCase']()));}})['catch'](handleError(_0x14c1b6,null));};