b2a6465bd59ffe75e71076904838ba987bc0da2b
[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 _0xa06c=['../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','limit','set','apply','reject','save','then','destroy','get','ExtractedReports','UserProfileResource','error','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','nolimit','sort','where','filters','pick','filter','merge','options','count','include','findAll','rows','catch','show','includeAll','create','role','user','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','params','basename','output','existsSync','savename','Report\x20not\x20found\x20or\x20empty','download','join','root','format','%s.%s','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs'];(function(_0x4e707e,_0x208eb5){var _0x3d346e=function(_0xd1f767){while(--_0xd1f767){_0x4e707e['push'](_0x4e707e['shift']());}};_0x3d346e(++_0x208eb5);}(_0xa06c,0x102));var _0xca06=function(_0x2263ef,_0x1e26e6){_0x2263ef=_0x2263ef-0x0;var _0x1ff649=_0xa06c[_0x2263ef];return _0x1ff649;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0xca06('0x0'));var zipdir=require(_0xca06('0x1'));var jsonpatch=require(_0xca06('0x2'));var rp=require(_0xca06('0x3'));var moment=require(_0xca06('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xca06('0x5'));var util=require(_0xca06('0x6'));var path=require(_0xca06('0x7'));var sox=require('sox');var csv=require(_0xca06('0x8'));var ejs=require(_0xca06('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0xca06('0xa'));var crypto=require(_0xca06('0xb'));var jsforce=require(_0xca06('0xc'));var deskjs=require(_0xca06('0xd'));var toCsv=require(_0xca06('0x8'));var querystring=require(_0xca06('0xe'));var Papa=require('papaparse');var Redis=require(_0xca06('0xf'));var authService=require(_0xca06('0x10'));var qs=require(_0xca06('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xca06('0x12'));var logger=require(_0xca06('0x13'))(_0xca06('0x14'));var utils=require(_0xca06('0x15'));var config=require(_0xca06('0x16'));var db=require(_0xca06('0x17'))['db'];function respondWithStatusCode(_0x5b5602,_0x1689bc){_0x1689bc=_0x1689bc||0xcc;return function(_0x2496e4){if(_0x2496e4){return _0x5b5602[_0xca06('0x18')](_0x1689bc);}return _0x5b5602[_0xca06('0x19')](_0x1689bc)[_0xca06('0x1a')]();};}function respondWithResult(_0x194fd3,_0x22c673){_0x22c673=_0x22c673||0xc8;return function(_0x84da6e){if(_0x84da6e){return _0x194fd3[_0xca06('0x19')](_0x22c673)[_0xca06('0x1b')](_0x84da6e);}};}function respondWithFilteredResult(_0x355b17,_0x5b3d8e){return function(_0x33da6c){if(_0x33da6c){var _0x44c04f=_0x33da6c['count'],_0x35a03f=_0x5b3d8e[_0xca06('0x1c')],_0x26955c=_0x5b3d8e['offset']+_0x5b3d8e[_0xca06('0x1d')],_0x152013;if(_0x26955c>=_0x44c04f){_0x26955c=_0x44c04f;_0x152013=0xc8;}else{_0x152013=0xce;}_0x355b17[_0xca06('0x19')](_0x152013);return _0x355b17[_0xca06('0x1e')]('Content-Range',_0x35a03f+'-'+_0x26955c+'/'+_0x44c04f)[_0xca06('0x1b')](_0x33da6c);}return null;};}function patchUpdates(_0x310f9d){return function(_0x264d80){try{jsonpatch[_0xca06('0x1f')](_0x264d80,_0x310f9d,!![]);}catch(_0x2a6941){return BPromise[_0xca06('0x20')](_0x2a6941);}return _0x264d80[_0xca06('0x21')]();};}function saveUpdates(_0x51c8f7,_0x97cb8c){return function(_0x21afcf){if(_0x21afcf){return _0x21afcf['update'](_0x51c8f7)[_0xca06('0x22')](function(_0x46c0a7){return _0x46c0a7;});}return null;};}function removeEntity(_0x5ac1cf,_0x6b223f){return function(_0x2f8716){if(_0x2f8716){return _0x2f8716[_0xca06('0x23')]()['then'](function(){var _0x10ed33=_0x2f8716[_0xca06('0x24')]({'plain':!![]});var _0x289f15=_0xca06('0x25');return db[_0xca06('0x26')][_0xca06('0x23')]({'where':{'type':_0x289f15,'resourceId':_0x10ed33['id']}})[_0xca06('0x22')](function(){return _0x2f8716;});})[_0xca06('0x22')](function(){_0x5ac1cf[_0xca06('0x19')](0xcc)[_0xca06('0x1a')]();});}};}function handleEntityNotFound(_0x111265,_0x5beee4){return function(_0x2381c1){if(!_0x2381c1){_0x111265['sendStatus'](0x194);}return _0x2381c1;};}function handleError(_0x208f44,_0x192e74){_0x192e74=_0x192e74||0x1f4;return function(_0x454d1f){logger[_0xca06('0x27')](_0x454d1f['stack']);if(_0x454d1f[_0xca06('0x28')]){delete _0x454d1f[_0xca06('0x28')];}_0x208f44[_0xca06('0x19')](_0x192e74)[_0xca06('0x29')](_0x454d1f);};}exports[_0xca06('0x2a')]=function(_0x59aea5,_0x19db98){var _0x1922b6={},_0x1443dc={},_0x3cbce3={'count':0x0,'rows':[]};var _0x3b83fa=_[_0xca06('0x2b')](db[_0xca06('0x2c')][_0xca06('0x2d')],function(_0x18468e){return{'name':_0x18468e[_0xca06('0x2e')],'type':_0x18468e[_0xca06('0x2f')][_0xca06('0x30')]};});_0x1443dc[_0xca06('0x31')]=_['map'](_0x3b83fa,_0xca06('0x28'));_0x1443dc[_0xca06('0x32')]=_[_0xca06('0x33')](_0x59aea5[_0xca06('0x32')]);_0x1443dc['filters']=_[_0xca06('0x34')](_0x1443dc[_0xca06('0x31')],_0x1443dc['query']);_0x1922b6[_0xca06('0x35')]=_['intersection'](_0x1443dc[_0xca06('0x31')],qs[_0xca06('0x36')](_0x59aea5[_0xca06('0x32')][_0xca06('0x36')]));_0x1922b6[_0xca06('0x35')]=_0x1922b6[_0xca06('0x35')][_0xca06('0x37')]?_0x1922b6['attributes']:_0x1443dc[_0xca06('0x31')];if(!_0x59aea5['query']['hasOwnProperty'](_0xca06('0x38'))){_0x1922b6[_0xca06('0x1d')]=qs[_0xca06('0x1d')](_0x59aea5['query'][_0xca06('0x1d')]);_0x1922b6['offset']=qs[_0xca06('0x1c')](_0x59aea5[_0xca06('0x32')][_0xca06('0x1c')]);}_0x1922b6['order']=qs[_0xca06('0x39')](_0x59aea5[_0xca06('0x32')]['sort']);_0x1922b6[_0xca06('0x3a')]=qs[_0xca06('0x3b')](_[_0xca06('0x3c')](_0x59aea5['query'],_0x1443dc[_0xca06('0x3b')]));if(_0x59aea5[_0xca06('0x32')][_0xca06('0x3d')]){_0x1922b6[_0xca06('0x3a')]=_[_0xca06('0x3e')](_0x1922b6[_0xca06('0x3a')],{'$or':_[_0xca06('0x2b')](_0x3b83fa,function(_0x5869a5){if(_0x5869a5[_0xca06('0x2f')]!=='VIRTUAL'){var _0x524068={};_0x524068[_0x5869a5[_0xca06('0x28')]]={'$like':'%'+_0x59aea5['query'][_0xca06('0x3d')]+'%'};return _0x524068;}})});}_0x1922b6=_[_0xca06('0x3e')]({},_0x1922b6,_0x59aea5[_0xca06('0x3f')]);var _0x2d2820={'where':_0x1922b6[_0xca06('0x3a')]};return db['AnalyticExtractedReport'][_0xca06('0x40')](_0x2d2820)[_0xca06('0x22')](function(_0x33b1bf){_0x3cbce3[_0xca06('0x40')]=_0x33b1bf;if(_0x59aea5[_0xca06('0x32')]['includeAll']){_0x1922b6[_0xca06('0x41')]=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0xca06('0x42')](_0x1922b6);})['then'](function(_0x436e6a){_0x3cbce3[_0xca06('0x43')]=_0x436e6a;return _0x3cbce3;})[_0xca06('0x22')](respondWithFilteredResult(_0x19db98,_0x1922b6))[_0xca06('0x44')](handleError(_0x19db98,null));};exports[_0xca06('0x45')]=function(_0x23087c,_0x5cd93d){var _0x12f782={'raw':!![],'where':{'id':_0x23087c['params']['id']}},_0x5704a3={};_0x5704a3[_0xca06('0x31')]=_[_0xca06('0x33')](db[_0xca06('0x2c')][_0xca06('0x2d')]);_0x5704a3[_0xca06('0x32')]=_[_0xca06('0x33')](_0x23087c['query']);_0x5704a3['filters']=_[_0xca06('0x34')](_0x5704a3[_0xca06('0x31')],_0x5704a3[_0xca06('0x32')]);_0x12f782[_0xca06('0x35')]=_[_0xca06('0x34')](_0x5704a3[_0xca06('0x31')],qs[_0xca06('0x36')](_0x23087c[_0xca06('0x32')][_0xca06('0x36')]));_0x12f782[_0xca06('0x35')]=_0x12f782[_0xca06('0x35')][_0xca06('0x37')]?_0x12f782[_0xca06('0x35')]:_0x5704a3[_0xca06('0x31')];if(_0x23087c[_0xca06('0x32')][_0xca06('0x46')]){_0x12f782[_0xca06('0x41')]=[{'all':!![]}];}_0x12f782=_[_0xca06('0x3e')]({},_0x12f782,_0x23087c['options']);return db[_0xca06('0x2c')]['find'](_0x12f782)[_0xca06('0x22')](handleEntityNotFound(_0x5cd93d,null))[_0xca06('0x22')](respondWithResult(_0x5cd93d,null))['catch'](handleError(_0x5cd93d,null));};exports[_0xca06('0x47')]=function(_0x41451f,_0x252f61){return db[_0xca06('0x2c')][_0xca06('0x47')](_0x41451f['body'],{})['then'](function(_0x47c857){var _0x4f72ac=_0x41451f['user'][_0xca06('0x24')]({'plain':!![]});if(!_0x4f72ac)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4f72ac[_0xca06('0x48')]===_0xca06('0x49')){var _0xe2d123=_0x47c857[_0xca06('0x24')]({'plain':!![]});var _0x1763c1=_0xca06('0x25');return db[_0xca06('0x4a')][_0xca06('0x4b')]({'where':{'name':_0x1763c1,'userProfileId':_0x4f72ac[_0xca06('0x4c')]},'raw':!![]})['then'](function(_0x534330){if(_0x534330&&_0x534330[_0xca06('0x4d')]===0x0){return db[_0xca06('0x26')][_0xca06('0x47')]({'name':_0xe2d123[_0xca06('0x28')],'resourceId':_0xe2d123['id'],'type':_0x534330['name'],'sectionId':_0x534330['id']},{})[_0xca06('0x22')](function(){return _0x47c857;});}else{return _0x47c857;}})[_0xca06('0x44')](function(_0x1b47e8){logger[_0xca06('0x27')](_0xca06('0x4e'),_0x1b47e8);throw _0x1b47e8;});}return _0x47c857;})[_0xca06('0x22')](respondWithResult(_0x252f61,0xc9))[_0xca06('0x44')](handleError(_0x252f61,null));};exports[_0xca06('0x4f')]=function(_0x1743b1,_0x5b349a){if(_0x1743b1[_0xca06('0x50')]['id']){delete _0x1743b1[_0xca06('0x50')]['id'];}return db[_0xca06('0x2c')][_0xca06('0x4b')]({'where':{'id':_0x1743b1[_0xca06('0x51')]['id']}})[_0xca06('0x22')](handleEntityNotFound(_0x5b349a,null))[_0xca06('0x22')](saveUpdates(_0x1743b1['body'],null))[_0xca06('0x22')](respondWithResult(_0x5b349a,null))[_0xca06('0x44')](handleError(_0x5b349a,null));};exports[_0xca06('0x23')]=function(_0x24e2ce,_0x33944e){return db['AnalyticExtractedReport'][_0xca06('0x4b')]({'where':{'id':_0x24e2ce[_0xca06('0x51')]['id']}})['then'](handleEntityNotFound(_0x33944e,null))['then'](removeEntity(_0x33944e,null))['catch'](handleError(_0x33944e,null));};exports['download']=function(_0x195681,_0x5928e5,_0x38b1be){return db[_0xca06('0x2c')][_0xca06('0x4b')]({'where':{'id':_0x195681[_0xca06('0x51')]['id']},'attributes':[_0xca06('0x28'),_0xca06('0x52'),'savename',_0xca06('0x53')],'raw':!![]})['then'](handleEntityNotFound(_0x5928e5,null))[_0xca06('0x22')](function(_0x11624d){if(_0x11624d){if(!fs[_0xca06('0x54')](path['join'](config['root'],'server/files/reports',_0x11624d[_0xca06('0x55')]))){throw new db['Sequelize']['ValidationError'](_0xca06('0x56'));}if(_0x195681['query']['exists']){return _0x5928e5[_0xca06('0x18')](0xc8);}return _0x5928e5[_0xca06('0x57')](path[_0xca06('0x58')](config[_0xca06('0x59')],'server/files/reports',_0x11624d['savename']),util[_0xca06('0x5a')](_0xca06('0x5b'),_0x11624d[_0xca06('0x52')]||_0x11624d[_0xca06('0x28')],_0x11624d[_0xca06('0x53')]['toLowerCase']()));}})[_0xca06('0x44')](handleError(_0x5928e5,null));};