Built motion from commit 5ba5b610.|2.5.33
[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 _0x951a=['ExtractedReports','destroy','then','sendStatus','stack','name','send','index','map','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','AnalyticExtractedReport','findAll','rows','catch','show','fields','create','body','user','role','UserProfileSection','find','userProfileId','autoAssociation','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','download','savename','root','server/files/reports','Report\x20not\x20found\x20or\x20empty','exists','%s.%s','basename','toLowerCase','eml-format','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','offset','undefined','limit','count','set','apply','reject','save','update','get'];(function(_0x5c7b96,_0x2a6400){var _0x77ad1d=function(_0x18b7fe){while(--_0x18b7fe){_0x5c7b96['push'](_0x5c7b96['shift']());}};_0x77ad1d(++_0x2a6400);}(_0x951a,0x96));var _0xa951=function(_0x1439aa,_0x3d697d){_0x1439aa=_0x1439aa-0x0;var _0x20ef11=_0x951a[_0x1439aa];return _0x20ef11;};'use strict';var emlformat=require(_0xa951('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xa951('0x1'));var rp=require(_0xa951('0x2'));var moment=require('moment');var BPromise=require(_0xa951('0x3'));var Mustache=require('mustache');var util=require(_0xa951('0x4'));var path=require(_0xa951('0x5'));var sox=require(_0xa951('0x6'));var csv=require(_0xa951('0x7'));var ejs=require(_0xa951('0x8'));var fs=require('fs');var fs_extra=require(_0xa951('0x9'));var _=require(_0xa951('0xa'));var squel=require(_0xa951('0xb'));var crypto=require(_0xa951('0xc'));var jsforce=require(_0xa951('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xa951('0x7'));var querystring=require(_0xa951('0xe'));var Papa=require(_0xa951('0xf'));var Redis=require('ioredis');var authService=require(_0xa951('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xa951('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xa951('0x12'))(_0xa951('0x13'));var utils=require(_0xa951('0x14'));var config=require(_0xa951('0x15'));var licenseUtil=require(_0xa951('0x16'));var db=require(_0xa951('0x17'))['db'];function respondWithStatusCode(_0x5a0448,_0x3eaca8){_0x3eaca8=_0x3eaca8||0xcc;return function(_0x250889){if(_0x250889){return _0x5a0448['sendStatus'](_0x3eaca8);}return _0x5a0448[_0xa951('0x18')](_0x3eaca8)[_0xa951('0x19')]();};}function respondWithResult(_0x3c52fb,_0x53f0e7){_0x53f0e7=_0x53f0e7||0xc8;return function(_0x50e14e){if(_0x50e14e){return _0x3c52fb[_0xa951('0x18')](_0x53f0e7)['json'](_0x50e14e);}};}function respondWithFilteredResult(_0x54a6b0,_0x77fdac){return function(_0x1c618a){if(_0x1c618a){var _0x1e2d23=typeof _0x77fdac[_0xa951('0x1a')]===_0xa951('0x1b')&&typeof _0x77fdac[_0xa951('0x1c')]===_0xa951('0x1b');var _0x8b17c7=_0x1c618a['count'];var _0x20accf=_0x1e2d23?0x0:_0x77fdac[_0xa951('0x1a')];var _0x11d1c2=_0x1e2d23?_0x1c618a[_0xa951('0x1d')]:_0x77fdac['offset']+_0x77fdac[_0xa951('0x1c')];var _0x3914db;if(_0x11d1c2>=_0x8b17c7){_0x11d1c2=_0x8b17c7;_0x3914db=0xc8;}else{_0x3914db=0xce;}_0x54a6b0[_0xa951('0x18')](_0x3914db);return _0x54a6b0[_0xa951('0x1e')]('Content-Range',_0x20accf+'-'+_0x11d1c2+'/'+_0x8b17c7)['json'](_0x1c618a);}return null;};}function patchUpdates(_0x1c3066){return function(_0x4497f2){try{jsonpatch[_0xa951('0x1f')](_0x4497f2,_0x1c3066,!![]);}catch(_0x398a46){return BPromise[_0xa951('0x20')](_0x398a46);}return _0x4497f2[_0xa951('0x21')]();};}function saveUpdates(_0x317c94,_0x5e26ff){return function(_0x1f0d7d){if(_0x1f0d7d){return _0x1f0d7d[_0xa951('0x22')](_0x317c94)['then'](function(_0x99db02){return _0x99db02;});}return null;};}function removeEntity(_0x77f389,_0x10b227){return function(_0x362835){if(_0x362835){return _0x362835['destroy']()['then'](function(){var _0xd07501=_0x362835[_0xa951('0x23')]({'plain':!![]});var _0x4ffd7a=_0xa951('0x24');return db['UserProfileResource'][_0xa951('0x25')]({'where':{'type':_0x4ffd7a,'resourceId':_0xd07501['id']}})['then'](function(){return _0x362835;});})[_0xa951('0x26')](function(){_0x77f389[_0xa951('0x18')](0xcc)[_0xa951('0x19')]();});}};}function handleEntityNotFound(_0x127476,_0x47ab6d){return function(_0x19bb08){if(!_0x19bb08){_0x127476[_0xa951('0x27')](0x194);}return _0x19bb08;};}function handleError(_0xf804e3,_0x2d823b){_0x2d823b=_0x2d823b||0x1f4;return function(_0x4737a6){logger['error'](_0x4737a6[_0xa951('0x28')]);if(_0x4737a6[_0xa951('0x29')]){delete _0x4737a6[_0xa951('0x29')];}_0xf804e3['status'](_0x2d823b)[_0xa951('0x2a')](_0x4737a6);};}exports[_0xa951('0x2b')]=function(_0x51da25,_0x542d97){var _0x2fe298={},_0x44508d={},_0x481d6c={'count':0x0,'rows':[]};var _0x4c4615=_[_0xa951('0x2c')](db['AnalyticExtractedReport'][_0xa951('0x2d')],function(_0x522a25){return{'name':_0x522a25[_0xa951('0x2e')],'type':_0x522a25[_0xa951('0x2f')]['key']};});_0x44508d[_0xa951('0x30')]=_[_0xa951('0x2c')](_0x4c4615,'name');_0x44508d[_0xa951('0x31')]=_[_0xa951('0x32')](_0x51da25[_0xa951('0x31')]);_0x44508d[_0xa951('0x33')]=_['intersection'](_0x44508d[_0xa951('0x30')],_0x44508d[_0xa951('0x31')]);_0x2fe298['attributes']=_[_0xa951('0x34')](_0x44508d[_0xa951('0x30')],qs['fields'](_0x51da25[_0xa951('0x31')]['fields']));_0x2fe298[_0xa951('0x35')]=_0x2fe298[_0xa951('0x35')][_0xa951('0x36')]?_0x2fe298[_0xa951('0x35')]:_0x44508d[_0xa951('0x30')];if(!_0x51da25[_0xa951('0x31')]['hasOwnProperty'](_0xa951('0x37'))){_0x2fe298[_0xa951('0x1c')]=qs[_0xa951('0x1c')](_0x51da25['query'][_0xa951('0x1c')]);_0x2fe298[_0xa951('0x1a')]=qs[_0xa951('0x1a')](_0x51da25[_0xa951('0x31')]['offset']);}_0x2fe298[_0xa951('0x38')]=qs[_0xa951('0x39')](_0x51da25['query'][_0xa951('0x39')]);_0x2fe298[_0xa951('0x3a')]=qs[_0xa951('0x33')](_[_0xa951('0x3b')](_0x51da25[_0xa951('0x31')],_0x44508d[_0xa951('0x33')]),_0x4c4615);if(_0x51da25[_0xa951('0x31')][_0xa951('0x3c')]){_0x2fe298['where']=_[_0xa951('0x3d')](_0x2fe298['where'],{'$or':_[_0xa951('0x2c')](_0x4c4615,function(_0x476656){if(_0x476656[_0xa951('0x2f')]!==_0xa951('0x3e')){var _0x24ff49={};_0x24ff49[_0x476656['name']]={'$like':'%'+_0x51da25[_0xa951('0x31')][_0xa951('0x3c')]+'%'};return _0x24ff49;}})});}_0x2fe298=_[_0xa951('0x3d')]({},_0x2fe298,_0x51da25[_0xa951('0x3f')]);var _0x37295a={'where':_0x2fe298['where']};return db['AnalyticExtractedReport'][_0xa951('0x1d')](_0x37295a)['then'](function(_0x317f40){_0x481d6c['count']=_0x317f40;if(_0x51da25['query'][_0xa951('0x40')]){_0x2fe298[_0xa951('0x41')]=[{'all':!![]}];}return db[_0xa951('0x42')][_0xa951('0x43')](_0x2fe298);})[_0xa951('0x26')](function(_0x2655cf){_0x481d6c[_0xa951('0x44')]=_0x2655cf;return _0x481d6c;})[_0xa951('0x26')](respondWithFilteredResult(_0x542d97,_0x2fe298))[_0xa951('0x45')](handleError(_0x542d97,null));};exports[_0xa951('0x46')]=function(_0x153d12,_0x15f2e7){var _0x491ba0={'raw':!![],'where':{'id':_0x153d12['params']['id']}},_0x4ce36c={};_0x4ce36c[_0xa951('0x30')]=_['keys'](db[_0xa951('0x42')][_0xa951('0x2d')]);_0x4ce36c[_0xa951('0x31')]=_[_0xa951('0x32')](_0x153d12[_0xa951('0x31')]);_0x4ce36c['filters']=_[_0xa951('0x34')](_0x4ce36c[_0xa951('0x30')],_0x4ce36c[_0xa951('0x31')]);_0x491ba0[_0xa951('0x35')]=_[_0xa951('0x34')](_0x4ce36c[_0xa951('0x30')],qs[_0xa951('0x47')](_0x153d12[_0xa951('0x31')]['fields']));_0x491ba0['attributes']=_0x491ba0[_0xa951('0x35')][_0xa951('0x36')]?_0x491ba0['attributes']:_0x4ce36c[_0xa951('0x30')];if(_0x153d12[_0xa951('0x31')]['includeAll']){_0x491ba0[_0xa951('0x41')]=[{'all':!![]}];}_0x491ba0=_[_0xa951('0x3d')]({},_0x491ba0,_0x153d12['options']);return db[_0xa951('0x42')]['find'](_0x491ba0)[_0xa951('0x26')](handleEntityNotFound(_0x15f2e7,null))['then'](respondWithResult(_0x15f2e7,null))['catch'](handleError(_0x15f2e7,null));};exports[_0xa951('0x48')]=function(_0xd8459e,_0x5c543c){return db[_0xa951('0x42')][_0xa951('0x48')](_0xd8459e[_0xa951('0x49')],{})[_0xa951('0x26')](function(_0x3e36f5){var _0xc95e73=_0xd8459e[_0xa951('0x4a')]['get']({'plain':!![]});if(!_0xc95e73)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0xc95e73[_0xa951('0x4b')]===_0xa951('0x4a')){var _0x4e6731=_0x3e36f5[_0xa951('0x23')]({'plain':!![]});var _0x2e813f=_0xa951('0x24');return db[_0xa951('0x4c')][_0xa951('0x4d')]({'where':{'name':_0x2e813f,'userProfileId':_0xc95e73[_0xa951('0x4e')]},'raw':!![]})[_0xa951('0x26')](function(_0x48e581){if(_0x48e581&&_0x48e581[_0xa951('0x4f')]===0x0){return db[_0xa951('0x50')][_0xa951('0x48')]({'name':_0x4e6731[_0xa951('0x29')],'resourceId':_0x4e6731['id'],'type':_0x48e581['name'],'sectionId':_0x48e581['id']},{})[_0xa951('0x26')](function(){return _0x3e36f5;});}else{return _0x3e36f5;}})[_0xa951('0x45')](function(_0x5d7a1c){logger[_0xa951('0x51')](_0xa951('0x52'),_0x5d7a1c);throw _0x5d7a1c;});}return _0x3e36f5;})[_0xa951('0x26')](respondWithResult(_0x5c543c,0xc9))['catch'](handleError(_0x5c543c,null));};exports[_0xa951('0x22')]=function(_0x4dcd8b,_0x355daa){if(_0x4dcd8b[_0xa951('0x49')]['id']){delete _0x4dcd8b['body']['id'];}return db[_0xa951('0x42')]['find']({'where':{'id':_0x4dcd8b['params']['id']}})[_0xa951('0x26')](handleEntityNotFound(_0x355daa,null))[_0xa951('0x26')](saveUpdates(_0x4dcd8b['body'],null))['then'](respondWithResult(_0x355daa,null))[_0xa951('0x45')](handleError(_0x355daa,null));};exports['destroy']=function(_0x4c81b1,_0x46acb3){return db[_0xa951('0x42')][_0xa951('0x4d')]({'where':{'id':_0x4c81b1[_0xa951('0x53')]['id']}})[_0xa951('0x26')](handleEntityNotFound(_0x46acb3,null))[_0xa951('0x26')](removeEntity(_0x46acb3,null))[_0xa951('0x45')](handleError(_0x46acb3,null));};exports[_0xa951('0x54')]=function(_0x27c77e,_0x106baa,_0x12c468){return db[_0xa951('0x42')][_0xa951('0x4d')]({'where':{'id':_0x27c77e['params']['id']},'attributes':[_0xa951('0x29'),'basename',_0xa951('0x55'),'output'],'raw':!![]})[_0xa951('0x26')](handleEntityNotFound(_0x106baa,null))[_0xa951('0x26')](function(_0x8b1c0c){if(_0x8b1c0c){if(!fs['existsSync'](path['join'](config[_0xa951('0x56')],_0xa951('0x57'),_0x8b1c0c['savename']))){throw new db['Sequelize']['ValidationError'](_0xa951('0x58'));}if(_0x27c77e[_0xa951('0x31')][_0xa951('0x59')]){return _0x106baa[_0xa951('0x27')](0xc8);}return _0x106baa[_0xa951('0x54')](path['join'](config[_0xa951('0x56')],_0xa951('0x57'),_0x8b1c0c['savename']),util['format'](_0xa951('0x5a'),_0x8b1c0c[_0xa951('0x5b')]||_0x8b1c0c['name'],_0x8b1c0c['output'][_0xa951('0x5c')]()));}})[_0xa951('0x45')](handleError(_0x106baa,null));};