Built motion from commit 43538d75.|2.5.35
[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 _0x4d07=['destroy','then','UserProfileResource','end','error','stack','name','send','index','map','AnalyticExtractedReport','fieldName','key','model','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','include','findAll','rows','catch','show','params','keys','rawAttributes','length','includeAll','find','create','body','user','get','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','basename','output','existsSync','join','root','server/files/reports','savename','Sequelize','ValidationError','exists','format','%s.%s','toLowerCase','rimraf','mustache','util','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','offset','limit','undefined','count','set','Content-Range','json','apply','reject','save','update'];(function(_0x4011be,_0x5530f7){var _0x3f4c55=function(_0x51d25c){while(--_0x51d25c){_0x4011be['push'](_0x4011be['shift']());}};_0x3f4c55(++_0x5530f7);}(_0x4d07,0x9e));var _0x74d0=function(_0xe1503d,_0x3b9fe0){_0xe1503d=_0xe1503d-0x0;var _0x519013=_0x4d07[_0xe1503d];return _0x519013;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x74d0('0x0'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x74d0('0x1'));var util=require(_0x74d0('0x2'));var path=require('path');var sox=require(_0x74d0('0x3'));var csv=require('to-csv');var ejs=require(_0x74d0('0x4'));var fs=require('fs');var fs_extra=require(_0x74d0('0x5'));var _=require(_0x74d0('0x6'));var squel=require(_0x74d0('0x7'));var crypto=require(_0x74d0('0x8'));var jsforce=require(_0x74d0('0x9'));var deskjs=require(_0x74d0('0xa'));var toCsv=require(_0x74d0('0xb'));var querystring=require('querystring');var Papa=require(_0x74d0('0xc'));var Redis=require(_0x74d0('0xd'));var authService=require(_0x74d0('0xe'));var qs=require('../../components/parsers/qs');var as=require(_0x74d0('0xf'));var hardwareService=require(_0x74d0('0x10'));var logger=require(_0x74d0('0x11'))(_0x74d0('0x12'));var utils=require(_0x74d0('0x13'));var config=require(_0x74d0('0x14'));var licenseUtil=require(_0x74d0('0x15'));var db=require(_0x74d0('0x16'))['db'];function respondWithStatusCode(_0x3ad801,_0x11d6c8){_0x11d6c8=_0x11d6c8||0xcc;return function(_0x2ff3a9){if(_0x2ff3a9){return _0x3ad801[_0x74d0('0x17')](_0x11d6c8);}return _0x3ad801[_0x74d0('0x18')](_0x11d6c8)['end']();};}function respondWithResult(_0x56a4ea,_0xcb5b71){_0xcb5b71=_0xcb5b71||0xc8;return function(_0x109b72){if(_0x109b72){return _0x56a4ea[_0x74d0('0x18')](_0xcb5b71)['json'](_0x109b72);}};}function respondWithFilteredResult(_0x58ca2a,_0x294b03){return function(_0x3ebb89){if(_0x3ebb89){var _0x304d4d=typeof _0x294b03[_0x74d0('0x19')]==='undefined'&&typeof _0x294b03[_0x74d0('0x1a')]===_0x74d0('0x1b');var _0x283e34=_0x3ebb89[_0x74d0('0x1c')];var _0x5cb80f=_0x304d4d?0x0:_0x294b03['offset'];var _0xaa23e1=_0x304d4d?_0x3ebb89[_0x74d0('0x1c')]:_0x294b03[_0x74d0('0x19')]+_0x294b03[_0x74d0('0x1a')];var _0x1aca25;if(_0xaa23e1>=_0x283e34){_0xaa23e1=_0x283e34;_0x1aca25=0xc8;}else{_0x1aca25=0xce;}_0x58ca2a[_0x74d0('0x18')](_0x1aca25);return _0x58ca2a[_0x74d0('0x1d')](_0x74d0('0x1e'),_0x5cb80f+'-'+_0xaa23e1+'/'+_0x283e34)[_0x74d0('0x1f')](_0x3ebb89);}return null;};}function patchUpdates(_0x2f6015){return function(_0x178f49){try{jsonpatch[_0x74d0('0x20')](_0x178f49,_0x2f6015,!![]);}catch(_0x3eba1f){return BPromise[_0x74d0('0x21')](_0x3eba1f);}return _0x178f49[_0x74d0('0x22')]();};}function saveUpdates(_0x2f5bab,_0x4a7468){return function(_0x26f13b){if(_0x26f13b){return _0x26f13b[_0x74d0('0x23')](_0x2f5bab)['then'](function(_0x38989e){return _0x38989e;});}return null;};}function removeEntity(_0x2f181e,_0x12dca4){return function(_0x271e3c){if(_0x271e3c){return _0x271e3c[_0x74d0('0x24')]()[_0x74d0('0x25')](function(){var _0x3417c6=_0x271e3c['get']({'plain':!![]});var _0x3ffdac='ExtractedReports';return db[_0x74d0('0x26')][_0x74d0('0x24')]({'where':{'type':_0x3ffdac,'resourceId':_0x3417c6['id']}})[_0x74d0('0x25')](function(){return _0x271e3c;});})[_0x74d0('0x25')](function(){_0x2f181e[_0x74d0('0x18')](0xcc)[_0x74d0('0x27')]();});}};}function handleEntityNotFound(_0x197d3a,_0xffa2ab){return function(_0x3f9ad1){if(!_0x3f9ad1){_0x197d3a[_0x74d0('0x17')](0x194);}return _0x3f9ad1;};}function handleError(_0x25646a,_0x5be009){_0x5be009=_0x5be009||0x1f4;return function(_0x530b64){logger[_0x74d0('0x28')](_0x530b64[_0x74d0('0x29')]);if(_0x530b64['name']){delete _0x530b64[_0x74d0('0x2a')];}_0x25646a[_0x74d0('0x18')](_0x5be009)[_0x74d0('0x2b')](_0x530b64);};}exports[_0x74d0('0x2c')]=function(_0x3d906d,_0x20b837){var _0x5ee6fe={},_0x83a21a={},_0x19cb4a={'count':0x0,'rows':[]};var _0x3b2845=_[_0x74d0('0x2d')](db[_0x74d0('0x2e')]['rawAttributes'],function(_0x4f0728){return{'name':_0x4f0728[_0x74d0('0x2f')],'type':_0x4f0728['type'][_0x74d0('0x30')]};});_0x83a21a[_0x74d0('0x31')]=_[_0x74d0('0x2d')](_0x3b2845,'name');_0x83a21a[_0x74d0('0x32')]=_['keys'](_0x3d906d['query']);_0x83a21a[_0x74d0('0x33')]=_[_0x74d0('0x34')](_0x83a21a['model'],_0x83a21a[_0x74d0('0x32')]);_0x5ee6fe['attributes']=_[_0x74d0('0x34')](_0x83a21a['model'],qs['fields'](_0x3d906d[_0x74d0('0x32')][_0x74d0('0x35')]));_0x5ee6fe[_0x74d0('0x36')]=_0x5ee6fe[_0x74d0('0x36')]['length']?_0x5ee6fe[_0x74d0('0x36')]:_0x83a21a[_0x74d0('0x31')];if(!_0x3d906d[_0x74d0('0x32')][_0x74d0('0x37')](_0x74d0('0x38'))){_0x5ee6fe['limit']=qs['limit'](_0x3d906d['query'][_0x74d0('0x1a')]);_0x5ee6fe['offset']=qs[_0x74d0('0x19')](_0x3d906d[_0x74d0('0x32')][_0x74d0('0x19')]);}_0x5ee6fe[_0x74d0('0x39')]=qs[_0x74d0('0x3a')](_0x3d906d[_0x74d0('0x32')][_0x74d0('0x3a')]);_0x5ee6fe[_0x74d0('0x3b')]=qs[_0x74d0('0x33')](_[_0x74d0('0x3c')](_0x3d906d['query'],_0x83a21a[_0x74d0('0x33')]),_0x3b2845);if(_0x3d906d[_0x74d0('0x32')][_0x74d0('0x3d')]){_0x5ee6fe[_0x74d0('0x3b')]=_[_0x74d0('0x3e')](_0x5ee6fe[_0x74d0('0x3b')],{'$or':_[_0x74d0('0x2d')](_0x3b2845,function(_0x1a7c33){if(_0x1a7c33['type']!=='VIRTUAL'){var _0xa68696={};_0xa68696[_0x1a7c33[_0x74d0('0x2a')]]={'$like':'%'+_0x3d906d[_0x74d0('0x32')][_0x74d0('0x3d')]+'%'};return _0xa68696;}})});}_0x5ee6fe=_[_0x74d0('0x3e')]({},_0x5ee6fe,_0x3d906d[_0x74d0('0x3f')]);var _0x7a76c4={'where':_0x5ee6fe['where']};return db['AnalyticExtractedReport'][_0x74d0('0x1c')](_0x7a76c4)[_0x74d0('0x25')](function(_0x2811d5){_0x19cb4a['count']=_0x2811d5;if(_0x3d906d[_0x74d0('0x32')]['includeAll']){_0x5ee6fe[_0x74d0('0x40')]=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0x74d0('0x41')](_0x5ee6fe);})['then'](function(_0x1f4966){_0x19cb4a[_0x74d0('0x42')]=_0x1f4966;return _0x19cb4a;})[_0x74d0('0x25')](respondWithFilteredResult(_0x20b837,_0x5ee6fe))[_0x74d0('0x43')](handleError(_0x20b837,null));};exports[_0x74d0('0x44')]=function(_0x54ecaa,_0x17ed0b){var _0x3dff48={'raw':!![],'where':{'id':_0x54ecaa[_0x74d0('0x45')]['id']}},_0x70ccf9={};_0x70ccf9['model']=_[_0x74d0('0x46')](db[_0x74d0('0x2e')][_0x74d0('0x47')]);_0x70ccf9['query']=_[_0x74d0('0x46')](_0x54ecaa[_0x74d0('0x32')]);_0x70ccf9[_0x74d0('0x33')]=_[_0x74d0('0x34')](_0x70ccf9[_0x74d0('0x31')],_0x70ccf9[_0x74d0('0x32')]);_0x3dff48[_0x74d0('0x36')]=_[_0x74d0('0x34')](_0x70ccf9[_0x74d0('0x31')],qs['fields'](_0x54ecaa[_0x74d0('0x32')][_0x74d0('0x35')]));_0x3dff48[_0x74d0('0x36')]=_0x3dff48[_0x74d0('0x36')][_0x74d0('0x48')]?_0x3dff48['attributes']:_0x70ccf9['model'];if(_0x54ecaa[_0x74d0('0x32')][_0x74d0('0x49')]){_0x3dff48[_0x74d0('0x40')]=[{'all':!![]}];}_0x3dff48=_[_0x74d0('0x3e')]({},_0x3dff48,_0x54ecaa[_0x74d0('0x3f')]);return db[_0x74d0('0x2e')][_0x74d0('0x4a')](_0x3dff48)[_0x74d0('0x25')](handleEntityNotFound(_0x17ed0b,null))[_0x74d0('0x25')](respondWithResult(_0x17ed0b,null))['catch'](handleError(_0x17ed0b,null));};exports[_0x74d0('0x4b')]=function(_0x52cd2a,_0x573ab9){return db[_0x74d0('0x2e')][_0x74d0('0x4b')](_0x52cd2a[_0x74d0('0x4c')],{})[_0x74d0('0x25')](function(_0x115d91){var _0x536d73=_0x52cd2a[_0x74d0('0x4d')][_0x74d0('0x4e')]({'plain':!![]});if(!_0x536d73)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x536d73[_0x74d0('0x4f')]===_0x74d0('0x4d')){var _0x44ee68=_0x115d91[_0x74d0('0x4e')]({'plain':!![]});var _0x32f65f='ExtractedReports';return db[_0x74d0('0x50')][_0x74d0('0x4a')]({'where':{'name':_0x32f65f,'userProfileId':_0x536d73[_0x74d0('0x51')]},'raw':!![]})[_0x74d0('0x25')](function(_0x239ad3){if(_0x239ad3&&_0x239ad3['autoAssociation']===0x0){return db[_0x74d0('0x26')][_0x74d0('0x4b')]({'name':_0x44ee68[_0x74d0('0x2a')],'resourceId':_0x44ee68['id'],'type':_0x239ad3[_0x74d0('0x2a')],'sectionId':_0x239ad3['id']},{})[_0x74d0('0x25')](function(){return _0x115d91;});}else{return _0x115d91;}})[_0x74d0('0x43')](function(_0x306223){logger[_0x74d0('0x28')](_0x74d0('0x52'),_0x306223);throw _0x306223;});}return _0x115d91;})[_0x74d0('0x25')](respondWithResult(_0x573ab9,0xc9))['catch'](handleError(_0x573ab9,null));};exports[_0x74d0('0x23')]=function(_0x468e87,_0x44d0ed){if(_0x468e87[_0x74d0('0x4c')]['id']){delete _0x468e87[_0x74d0('0x4c')]['id'];}return db[_0x74d0('0x2e')][_0x74d0('0x4a')]({'where':{'id':_0x468e87['params']['id']}})['then'](handleEntityNotFound(_0x44d0ed,null))[_0x74d0('0x25')](saveUpdates(_0x468e87[_0x74d0('0x4c')],null))[_0x74d0('0x25')](respondWithResult(_0x44d0ed,null))[_0x74d0('0x43')](handleError(_0x44d0ed,null));};exports[_0x74d0('0x24')]=function(_0x5bba6e,_0x4fe986){return db[_0x74d0('0x2e')]['find']({'where':{'id':_0x5bba6e['params']['id']}})[_0x74d0('0x25')](handleEntityNotFound(_0x4fe986,null))[_0x74d0('0x25')](removeEntity(_0x4fe986,null))['catch'](handleError(_0x4fe986,null));};exports[_0x74d0('0x53')]=function(_0x4daf9c,_0x3eabf3,_0x4bf990){return db['AnalyticExtractedReport'][_0x74d0('0x4a')]({'where':{'id':_0x4daf9c['params']['id']},'attributes':[_0x74d0('0x2a'),_0x74d0('0x54'),'savename',_0x74d0('0x55')],'raw':!![]})['then'](handleEntityNotFound(_0x3eabf3,null))['then'](function(_0x5a30a8){if(_0x5a30a8){if(!fs[_0x74d0('0x56')](path[_0x74d0('0x57')](config[_0x74d0('0x58')],_0x74d0('0x59'),_0x5a30a8[_0x74d0('0x5a')]))){throw new db[(_0x74d0('0x5b'))][(_0x74d0('0x5c'))]('Report\x20not\x20found\x20or\x20empty');}if(_0x4daf9c[_0x74d0('0x32')][_0x74d0('0x5d')]){return _0x3eabf3[_0x74d0('0x17')](0xc8);}return _0x3eabf3['download'](path[_0x74d0('0x57')](config[_0x74d0('0x58')],_0x74d0('0x59'),_0x5a30a8[_0x74d0('0x5a')]),util[_0x74d0('0x5e')](_0x74d0('0x5f'),_0x5a30a8[_0x74d0('0x54')]||_0x5a30a8[_0x74d0('0x2a')],_0x5a30a8[_0x74d0('0x55')][_0x74d0('0x60')]()));}})[_0x74d0('0x43')](handleError(_0x3eabf3,null));};