388a3b9ab67de128a0de9144162a18e90bcdc920
[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 _0x1486=['then','destroy','get','ExtractedReports','UserProfileResource','end','error','name','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','keys','filters','intersection','attributes','fields','query','length','hasOwnProperty','nolimit','sort','where','merge','VIRTUAL','include','findAll','show','params','includeAll','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','output','existsSync','join','root','server/files/reports','ValidationError','Report\x20not\x20found\x20or\x20empty','savename','%s.%s','basename','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','ejs','fs-extra','squel','crypto','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','update'];(function(_0x5b5138,_0x356ad2){var _0x58b50e=function(_0x43fe4e){while(--_0x43fe4e){_0x5b5138['push'](_0x5b5138['shift']());}};_0x58b50e(++_0x356ad2);}(_0x1486,0x14f));var _0x6148=function(_0x2fac9a,_0x535120){_0x2fac9a=_0x2fac9a-0x0;var _0x4b260e=_0x1486[_0x2fac9a];return _0x4b260e;};'use strict';var emlformat=require(_0x6148('0x0'));var rimraf=require(_0x6148('0x1'));var zipdir=require(_0x6148('0x2'));var jsonpatch=require(_0x6148('0x3'));var rp=require(_0x6148('0x4'));var moment=require(_0x6148('0x5'));var BPromise=require(_0x6148('0x6'));var Mustache=require(_0x6148('0x7'));var util=require('util');var path=require(_0x6148('0x8'));var sox=require(_0x6148('0x9'));var csv=require('to-csv');var ejs=require(_0x6148('0xa'));var fs=require('fs');var fs_extra=require(_0x6148('0xb'));var _=require('lodash');var squel=require(_0x6148('0xc'));var crypto=require(_0x6148('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x6148('0xe'));var querystring=require(_0x6148('0xf'));var Papa=require('papaparse');var Redis=require(_0x6148('0x10'));var authService=require(_0x6148('0x11'));var qs=require(_0x6148('0x12'));var as=require(_0x6148('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x6148('0x14'))(_0x6148('0x15'));var utils=require('../../config/utils');var config=require(_0x6148('0x16'));var licenseUtil=require(_0x6148('0x17'));var db=require(_0x6148('0x18'))['db'];function respondWithStatusCode(_0x46a1bd,_0x1d9e2d){_0x1d9e2d=_0x1d9e2d||0xcc;return function(_0x5e5182){if(_0x5e5182){return _0x46a1bd[_0x6148('0x19')](_0x1d9e2d);}return _0x46a1bd[_0x6148('0x1a')](_0x1d9e2d)['end']();};}function respondWithResult(_0x2b7f6e,_0x7e32a7){_0x7e32a7=_0x7e32a7||0xc8;return function(_0x116392){if(_0x116392){return _0x2b7f6e[_0x6148('0x1a')](_0x7e32a7)[_0x6148('0x1b')](_0x116392);}};}function respondWithFilteredResult(_0x133241,_0x572aec){return function(_0x92a5){if(_0x92a5){var _0x393361=typeof _0x572aec[_0x6148('0x1c')]===_0x6148('0x1d')&&typeof _0x572aec[_0x6148('0x1e')]==='undefined';var _0x2fb40f=_0x92a5['count'];var _0x52ad7e=_0x393361?0x0:_0x572aec[_0x6148('0x1c')];var _0x37c494=_0x393361?_0x92a5[_0x6148('0x1f')]:_0x572aec[_0x6148('0x1c')]+_0x572aec['limit'];var _0x57f6b0;if(_0x37c494>=_0x2fb40f){_0x37c494=_0x2fb40f;_0x57f6b0=0xc8;}else{_0x57f6b0=0xce;}_0x133241[_0x6148('0x1a')](_0x57f6b0);return _0x133241[_0x6148('0x20')](_0x6148('0x21'),_0x52ad7e+'-'+_0x37c494+'/'+_0x2fb40f)['json'](_0x92a5);}return null;};}function patchUpdates(_0x48755f){return function(_0x2b7ba5){try{jsonpatch[_0x6148('0x22')](_0x2b7ba5,_0x48755f,!![]);}catch(_0x98eb7d){return BPromise['reject'](_0x98eb7d);}return _0x2b7ba5[_0x6148('0x23')]();};}function saveUpdates(_0x1356f7,_0x24b5f5){return function(_0x247c0f){if(_0x247c0f){return _0x247c0f[_0x6148('0x24')](_0x1356f7)[_0x6148('0x25')](function(_0x3f21dd){return _0x3f21dd;});}return null;};}function removeEntity(_0x504408,_0x3c3f51){return function(_0x321fa1){if(_0x321fa1){return _0x321fa1[_0x6148('0x26')]()['then'](function(){var _0x32ffe9=_0x321fa1[_0x6148('0x27')]({'plain':!![]});var _0x30a323=_0x6148('0x28');return db[_0x6148('0x29')][_0x6148('0x26')]({'where':{'type':_0x30a323,'resourceId':_0x32ffe9['id']}})[_0x6148('0x25')](function(){return _0x321fa1;});})[_0x6148('0x25')](function(){_0x504408['status'](0xcc)[_0x6148('0x2a')]();});}};}function handleEntityNotFound(_0x1421d6,_0x30e8b5){return function(_0x5d8d15){if(!_0x5d8d15){_0x1421d6['sendStatus'](0x194);}return _0x5d8d15;};}function handleError(_0x47faee,_0x335e22){_0x335e22=_0x335e22||0x1f4;return function(_0x2cd816){logger[_0x6148('0x2b')](_0x2cd816['stack']);if(_0x2cd816[_0x6148('0x2c')]){delete _0x2cd816[_0x6148('0x2c')];}_0x47faee[_0x6148('0x1a')](_0x335e22)['send'](_0x2cd816);};}exports[_0x6148('0x2d')]=function(_0x487a98,_0x5404c8){var _0x1a961c={},_0x56ba5f={},_0x425661={'count':0x0,'rows':[]};var _0x22331b=_[_0x6148('0x2e')](db[_0x6148('0x2f')][_0x6148('0x30')],function(_0x1ab377){return{'name':_0x1ab377[_0x6148('0x31')],'type':_0x1ab377[_0x6148('0x32')][_0x6148('0x33')]};});_0x56ba5f[_0x6148('0x34')]=_[_0x6148('0x2e')](_0x22331b,_0x6148('0x2c'));_0x56ba5f['query']=_[_0x6148('0x35')](_0x487a98['query']);_0x56ba5f[_0x6148('0x36')]=_[_0x6148('0x37')](_0x56ba5f[_0x6148('0x34')],_0x56ba5f['query']);_0x1a961c[_0x6148('0x38')]=_[_0x6148('0x37')](_0x56ba5f[_0x6148('0x34')],qs[_0x6148('0x39')](_0x487a98[_0x6148('0x3a')]['fields']));_0x1a961c[_0x6148('0x38')]=_0x1a961c[_0x6148('0x38')][_0x6148('0x3b')]?_0x1a961c[_0x6148('0x38')]:_0x56ba5f[_0x6148('0x34')];if(!_0x487a98[_0x6148('0x3a')][_0x6148('0x3c')](_0x6148('0x3d'))){_0x1a961c['limit']=qs[_0x6148('0x1e')](_0x487a98[_0x6148('0x3a')]['limit']);_0x1a961c['offset']=qs[_0x6148('0x1c')](_0x487a98[_0x6148('0x3a')][_0x6148('0x1c')]);}_0x1a961c['order']=qs['sort'](_0x487a98[_0x6148('0x3a')][_0x6148('0x3e')]);_0x1a961c['where']=qs[_0x6148('0x36')](_['pick'](_0x487a98[_0x6148('0x3a')],_0x56ba5f[_0x6148('0x36')]),_0x22331b);if(_0x487a98[_0x6148('0x3a')]['filter']){_0x1a961c[_0x6148('0x3f')]=_[_0x6148('0x40')](_0x1a961c[_0x6148('0x3f')],{'$or':_['map'](_0x22331b,function(_0x4ddcfa){if(_0x4ddcfa[_0x6148('0x32')]!==_0x6148('0x41')){var _0x192b72={};_0x192b72[_0x4ddcfa[_0x6148('0x2c')]]={'$like':'%'+_0x487a98[_0x6148('0x3a')]['filter']+'%'};return _0x192b72;}})});}_0x1a961c=_['merge']({},_0x1a961c,_0x487a98['options']);var _0x552311={'where':_0x1a961c[_0x6148('0x3f')]};return db[_0x6148('0x2f')][_0x6148('0x1f')](_0x552311)['then'](function(_0x52e0b9){_0x425661['count']=_0x52e0b9;if(_0x487a98[_0x6148('0x3a')]['includeAll']){_0x1a961c[_0x6148('0x42')]=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0x6148('0x43')](_0x1a961c);})['then'](function(_0x105220){_0x425661['rows']=_0x105220;return _0x425661;})[_0x6148('0x25')](respondWithFilteredResult(_0x5404c8,_0x1a961c))['catch'](handleError(_0x5404c8,null));};exports[_0x6148('0x44')]=function(_0x5005e4,_0x118b0a){var _0x307fd1={'raw':!![],'where':{'id':_0x5005e4[_0x6148('0x45')]['id']}},_0x1a96cb={};_0x1a96cb[_0x6148('0x34')]=_[_0x6148('0x35')](db[_0x6148('0x2f')][_0x6148('0x30')]);_0x1a96cb[_0x6148('0x3a')]=_['keys'](_0x5005e4[_0x6148('0x3a')]);_0x1a96cb[_0x6148('0x36')]=_['intersection'](_0x1a96cb[_0x6148('0x34')],_0x1a96cb[_0x6148('0x3a')]);_0x307fd1[_0x6148('0x38')]=_['intersection'](_0x1a96cb['model'],qs[_0x6148('0x39')](_0x5005e4[_0x6148('0x3a')][_0x6148('0x39')]));_0x307fd1[_0x6148('0x38')]=_0x307fd1[_0x6148('0x38')][_0x6148('0x3b')]?_0x307fd1[_0x6148('0x38')]:_0x1a96cb[_0x6148('0x34')];if(_0x5005e4['query'][_0x6148('0x46')]){_0x307fd1['include']=[{'all':!![]}];}_0x307fd1=_[_0x6148('0x40')]({},_0x307fd1,_0x5005e4['options']);return db[_0x6148('0x2f')][_0x6148('0x47')](_0x307fd1)[_0x6148('0x25')](handleEntityNotFound(_0x118b0a,null))['then'](respondWithResult(_0x118b0a,null))[_0x6148('0x48')](handleError(_0x118b0a,null));};exports[_0x6148('0x49')]=function(_0x2c8874,_0x422028){return db[_0x6148('0x2f')][_0x6148('0x49')](_0x2c8874[_0x6148('0x4a')],{})[_0x6148('0x25')](function(_0x19f36b){var _0x1e8c49=_0x2c8874[_0x6148('0x4b')][_0x6148('0x27')]({'plain':!![]});if(!_0x1e8c49)throw new Error(_0x6148('0x4c'));if(_0x1e8c49[_0x6148('0x4d')]==='user'){var _0x52b208=_0x19f36b[_0x6148('0x27')]({'plain':!![]});var _0x1fc659=_0x6148('0x28');return db[_0x6148('0x4e')][_0x6148('0x47')]({'where':{'name':_0x1fc659,'userProfileId':_0x1e8c49['userProfileId']},'raw':!![]})[_0x6148('0x25')](function(_0x372c19){if(_0x372c19&&_0x372c19[_0x6148('0x4f')]===0x0){return db[_0x6148('0x29')][_0x6148('0x49')]({'name':_0x52b208[_0x6148('0x2c')],'resourceId':_0x52b208['id'],'type':_0x372c19[_0x6148('0x2c')],'sectionId':_0x372c19['id']},{})[_0x6148('0x25')](function(){return _0x19f36b;});}else{return _0x19f36b;}})[_0x6148('0x48')](function(_0x56cc32){logger[_0x6148('0x2b')](_0x6148('0x50'),_0x56cc32);throw _0x56cc32;});}return _0x19f36b;})[_0x6148('0x25')](respondWithResult(_0x422028,0xc9))['catch'](handleError(_0x422028,null));};exports['update']=function(_0x4a6a68,_0x2d413c){if(_0x4a6a68[_0x6148('0x4a')]['id']){delete _0x4a6a68[_0x6148('0x4a')]['id'];}return db['AnalyticExtractedReport']['find']({'where':{'id':_0x4a6a68[_0x6148('0x45')]['id']}})[_0x6148('0x25')](handleEntityNotFound(_0x2d413c,null))[_0x6148('0x25')](saveUpdates(_0x4a6a68['body'],null))[_0x6148('0x25')](respondWithResult(_0x2d413c,null))[_0x6148('0x48')](handleError(_0x2d413c,null));};exports[_0x6148('0x26')]=function(_0x536d7e,_0x9010c5){return db['AnalyticExtractedReport'][_0x6148('0x47')]({'where':{'id':_0x536d7e[_0x6148('0x45')]['id']}})['then'](handleEntityNotFound(_0x9010c5,null))[_0x6148('0x25')](removeEntity(_0x9010c5,null))['catch'](handleError(_0x9010c5,null));};exports[_0x6148('0x51')]=function(_0x3e7b83,_0x4528fe,_0x24406a){return db[_0x6148('0x2f')][_0x6148('0x47')]({'where':{'id':_0x3e7b83[_0x6148('0x45')]['id']},'attributes':[_0x6148('0x2c'),'basename','savename',_0x6148('0x52')],'raw':!![]})['then'](handleEntityNotFound(_0x4528fe,null))['then'](function(_0x293395){if(_0x293395){if(!fs[_0x6148('0x53')](path[_0x6148('0x54')](config[_0x6148('0x55')],_0x6148('0x56'),_0x293395['savename']))){throw new db['Sequelize'][(_0x6148('0x57'))](_0x6148('0x58'));}if(_0x3e7b83['query']['exists']){return _0x4528fe[_0x6148('0x19')](0xc8);}return _0x4528fe[_0x6148('0x51')](path[_0x6148('0x54')](config[_0x6148('0x55')],_0x6148('0x56'),_0x293395[_0x6148('0x59')]),util['format'](_0x6148('0x5a'),_0x293395[_0x6148('0x5b')]||_0x293395['name'],_0x293395['output'][_0x6148('0x5c')]()));}})[_0x6148('0x48')](handleError(_0x4528fe,null));};