Built motion from commit bab6f49e.|2.6.17
[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 _0xc040=['../../mysqldb','sendStatus','status','json','offset','undefined','count','Content-Range','apply','reject','save','destroy','then','UserProfileResource','error','stack','name','send','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','limit','sort','filters','pick','merge','where','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','show','params','find','create','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','ExtractedReports','UserProfileSection','userProfileId','update','body','download','basename','savename','output','existsSync','join','root','server/files/reports','Sequelize','Report\x20not\x20found\x20or\x20empty','exists','format','%s.%s','toLowerCase','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util'];(function(_0x487563,_0x5aaf5f){var _0x139db0=function(_0x5107f9){while(--_0x5107f9){_0x487563['push'](_0x487563['shift']());}};_0x139db0(++_0x5aaf5f);}(_0xc040,0xa7));var _0x0c04=function(_0x205cb8,_0x2a971a){_0x205cb8=_0x205cb8-0x0;var _0x4bb45a=_0xc040[_0x205cb8];return _0x4bb45a;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x0c04('0x0'));var zipdir=require(_0x0c04('0x1'));var jsonpatch=require(_0x0c04('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x0c04('0x3'));var Mustache=require(_0x0c04('0x4'));var util=require(_0x0c04('0x5'));var path=require(_0x0c04('0x6'));var sox=require(_0x0c04('0x7'));var csv=require('to-csv');var ejs=require(_0x0c04('0x8'));var fs=require('fs');var fs_extra=require(_0x0c04('0x9'));var _=require(_0x0c04('0xa'));var squel=require(_0x0c04('0xb'));var crypto=require('crypto');var jsforce=require(_0x0c04('0xc'));var deskjs=require(_0x0c04('0xd'));var toCsv=require(_0x0c04('0xe'));var querystring=require(_0x0c04('0xf'));var Papa=require(_0x0c04('0x10'));var Redis=require(_0x0c04('0x11'));var authService=require(_0x0c04('0x12'));var qs=require(_0x0c04('0x13'));var as=require(_0x0c04('0x14'));var hardwareService=require(_0x0c04('0x15'));var logger=require(_0x0c04('0x16'))(_0x0c04('0x17'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x0c04('0x18'));var db=require(_0x0c04('0x19'))['db'];function respondWithStatusCode(_0xf249b,_0x2f828f){_0x2f828f=_0x2f828f||0xcc;return function(_0x58211e){if(_0x58211e){return _0xf249b[_0x0c04('0x1a')](_0x2f828f);}return _0xf249b['status'](_0x2f828f)['end']();};}function respondWithResult(_0x62367b,_0x1e67b5){_0x1e67b5=_0x1e67b5||0xc8;return function(_0x35691d){if(_0x35691d){return _0x62367b[_0x0c04('0x1b')](_0x1e67b5)[_0x0c04('0x1c')](_0x35691d);}};}function respondWithFilteredResult(_0x5b991a,_0x3adbfb){return function(_0x37c067){if(_0x37c067){var _0x3f7e81=typeof _0x3adbfb[_0x0c04('0x1d')]===_0x0c04('0x1e')&&typeof _0x3adbfb['limit']==='undefined';var _0x4ac6d6=_0x37c067[_0x0c04('0x1f')];var _0x358575=_0x3f7e81?0x0:_0x3adbfb[_0x0c04('0x1d')];var _0x1b69d9=_0x3f7e81?_0x37c067['count']:_0x3adbfb[_0x0c04('0x1d')]+_0x3adbfb['limit'];var _0x2fc5a2;if(_0x1b69d9>=_0x4ac6d6){_0x1b69d9=_0x4ac6d6;_0x2fc5a2=0xc8;}else{_0x2fc5a2=0xce;}_0x5b991a['status'](_0x2fc5a2);return _0x5b991a['set'](_0x0c04('0x20'),_0x358575+'-'+_0x1b69d9+'/'+_0x4ac6d6)['json'](_0x37c067);}return null;};}function patchUpdates(_0x4d452e){return function(_0x2181c8){try{jsonpatch[_0x0c04('0x21')](_0x2181c8,_0x4d452e,!![]);}catch(_0x37de6b){return BPromise[_0x0c04('0x22')](_0x37de6b);}return _0x2181c8[_0x0c04('0x23')]();};}function saveUpdates(_0x129b57,_0x27acf3){return function(_0xa31d76){if(_0xa31d76){return _0xa31d76['update'](_0x129b57)['then'](function(_0x5972bb){return _0x5972bb;});}return null;};}function removeEntity(_0x56baaf,_0x90ddc2){return function(_0x29a7ca){if(_0x29a7ca){return _0x29a7ca[_0x0c04('0x24')]()[_0x0c04('0x25')](function(){var _0x54a003=_0x29a7ca['get']({'plain':!![]});var _0x1e866f='ExtractedReports';return db[_0x0c04('0x26')][_0x0c04('0x24')]({'where':{'type':_0x1e866f,'resourceId':_0x54a003['id']}})[_0x0c04('0x25')](function(){return _0x29a7ca;});})[_0x0c04('0x25')](function(){_0x56baaf['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x52fe74,_0x8302a9){return function(_0x55831e){if(!_0x55831e){_0x52fe74[_0x0c04('0x1a')](0x194);}return _0x55831e;};}function handleError(_0x256070,_0x19f25a){_0x19f25a=_0x19f25a||0x1f4;return function(_0x2fd992){logger[_0x0c04('0x27')](_0x2fd992[_0x0c04('0x28')]);if(_0x2fd992[_0x0c04('0x29')]){delete _0x2fd992[_0x0c04('0x29')];}_0x256070[_0x0c04('0x1b')](_0x19f25a)[_0x0c04('0x2a')](_0x2fd992);};}exports['index']=function(_0x1f3bfa,_0x733698){var _0x24de0b={},_0x13f4fd={},_0x48b9b3={'count':0x0,'rows':[]};var _0xc0727=_[_0x0c04('0x2b')](db[_0x0c04('0x2c')][_0x0c04('0x2d')],function(_0x258569){return{'name':_0x258569[_0x0c04('0x2e')],'type':_0x258569[_0x0c04('0x2f')][_0x0c04('0x30')]};});_0x13f4fd[_0x0c04('0x31')]=_[_0x0c04('0x2b')](_0xc0727,'name');_0x13f4fd['query']=_[_0x0c04('0x32')](_0x1f3bfa[_0x0c04('0x33')]);_0x13f4fd['filters']=_[_0x0c04('0x34')](_0x13f4fd[_0x0c04('0x31')],_0x13f4fd[_0x0c04('0x33')]);_0x24de0b['attributes']=_[_0x0c04('0x34')](_0x13f4fd[_0x0c04('0x31')],qs[_0x0c04('0x35')](_0x1f3bfa[_0x0c04('0x33')][_0x0c04('0x35')]));_0x24de0b[_0x0c04('0x36')]=_0x24de0b[_0x0c04('0x36')][_0x0c04('0x37')]?_0x24de0b[_0x0c04('0x36')]:_0x13f4fd[_0x0c04('0x31')];if(!_0x1f3bfa[_0x0c04('0x33')][_0x0c04('0x38')]('nolimit')){_0x24de0b[_0x0c04('0x39')]=qs[_0x0c04('0x39')](_0x1f3bfa['query'][_0x0c04('0x39')]);_0x24de0b[_0x0c04('0x1d')]=qs[_0x0c04('0x1d')](_0x1f3bfa[_0x0c04('0x33')][_0x0c04('0x1d')]);}_0x24de0b['order']=qs[_0x0c04('0x3a')](_0x1f3bfa[_0x0c04('0x33')][_0x0c04('0x3a')]);_0x24de0b['where']=qs[_0x0c04('0x3b')](_[_0x0c04('0x3c')](_0x1f3bfa[_0x0c04('0x33')],_0x13f4fd[_0x0c04('0x3b')]),_0xc0727);if(_0x1f3bfa[_0x0c04('0x33')]['filter']){_0x24de0b['where']=_[_0x0c04('0x3d')](_0x24de0b[_0x0c04('0x3e')],{'$or':_[_0x0c04('0x2b')](_0xc0727,function(_0x25e4ca){if(_0x25e4ca[_0x0c04('0x2f')]!==_0x0c04('0x3f')){var _0x567911={};_0x567911[_0x25e4ca[_0x0c04('0x29')]]={'$like':'%'+_0x1f3bfa[_0x0c04('0x33')][_0x0c04('0x40')]+'%'};return _0x567911;}})});}_0x24de0b=_[_0x0c04('0x3d')]({},_0x24de0b,_0x1f3bfa[_0x0c04('0x41')]);var _0xb35496={'where':_0x24de0b[_0x0c04('0x3e')]};return db[_0x0c04('0x2c')][_0x0c04('0x1f')](_0xb35496)[_0x0c04('0x25')](function(_0x4ea559){_0x48b9b3[_0x0c04('0x1f')]=_0x4ea559;if(_0x1f3bfa['query'][_0x0c04('0x42')]){_0x24de0b[_0x0c04('0x43')]=[{'all':!![]}];}return db[_0x0c04('0x2c')][_0x0c04('0x44')](_0x24de0b);})[_0x0c04('0x25')](function(_0x45d7c4){_0x48b9b3[_0x0c04('0x45')]=_0x45d7c4;return _0x48b9b3;})[_0x0c04('0x25')](respondWithFilteredResult(_0x733698,_0x24de0b))[_0x0c04('0x46')](handleError(_0x733698,null));};exports[_0x0c04('0x47')]=function(_0x5dab83,_0x4054ab){var _0x3bb370={'raw':!![],'where':{'id':_0x5dab83[_0x0c04('0x48')]['id']}},_0x38e621={};_0x38e621[_0x0c04('0x31')]=_[_0x0c04('0x32')](db[_0x0c04('0x2c')][_0x0c04('0x2d')]);_0x38e621[_0x0c04('0x33')]=_[_0x0c04('0x32')](_0x5dab83['query']);_0x38e621[_0x0c04('0x3b')]=_['intersection'](_0x38e621[_0x0c04('0x31')],_0x38e621['query']);_0x3bb370[_0x0c04('0x36')]=_[_0x0c04('0x34')](_0x38e621[_0x0c04('0x31')],qs['fields'](_0x5dab83['query'][_0x0c04('0x35')]));_0x3bb370['attributes']=_0x3bb370[_0x0c04('0x36')][_0x0c04('0x37')]?_0x3bb370[_0x0c04('0x36')]:_0x38e621[_0x0c04('0x31')];if(_0x5dab83[_0x0c04('0x33')][_0x0c04('0x42')]){_0x3bb370[_0x0c04('0x43')]=[{'all':!![]}];}_0x3bb370=_[_0x0c04('0x3d')]({},_0x3bb370,_0x5dab83[_0x0c04('0x41')]);return db[_0x0c04('0x2c')][_0x0c04('0x49')](_0x3bb370)[_0x0c04('0x25')](handleEntityNotFound(_0x4054ab,null))[_0x0c04('0x25')](respondWithResult(_0x4054ab,null))[_0x0c04('0x46')](handleError(_0x4054ab,null));};exports[_0x0c04('0x4a')]=function(_0x4a9f6d,_0x194193){return db[_0x0c04('0x2c')]['create'](_0x4a9f6d['body'],{})['then'](function(_0x4d66e0){var _0x312dca=_0x4a9f6d['user'][_0x0c04('0x4b')]({'plain':!![]});if(!_0x312dca)throw new Error(_0x0c04('0x4c'));if(_0x312dca['role']==='user'){var _0xbd18f7=_0x4d66e0[_0x0c04('0x4b')]({'plain':!![]});var _0x21e05a=_0x0c04('0x4d');return db[_0x0c04('0x4e')][_0x0c04('0x49')]({'where':{'name':_0x21e05a,'userProfileId':_0x312dca[_0x0c04('0x4f')]},'raw':!![]})[_0x0c04('0x25')](function(_0x5cbc62){if(_0x5cbc62&&_0x5cbc62['autoAssociation']===0x0){return db[_0x0c04('0x26')][_0x0c04('0x4a')]({'name':_0xbd18f7[_0x0c04('0x29')],'resourceId':_0xbd18f7['id'],'type':_0x5cbc62[_0x0c04('0x29')],'sectionId':_0x5cbc62['id']},{})[_0x0c04('0x25')](function(){return _0x4d66e0;});}else{return _0x4d66e0;}})['catch'](function(_0xa79555){logger[_0x0c04('0x27')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0xa79555);throw _0xa79555;});}return _0x4d66e0;})[_0x0c04('0x25')](respondWithResult(_0x194193,0xc9))[_0x0c04('0x46')](handleError(_0x194193,null));};exports[_0x0c04('0x50')]=function(_0x557ea5,_0x4b9df6){if(_0x557ea5[_0x0c04('0x51')]['id']){delete _0x557ea5['body']['id'];}return db[_0x0c04('0x2c')][_0x0c04('0x49')]({'where':{'id':_0x557ea5['params']['id']}})[_0x0c04('0x25')](handleEntityNotFound(_0x4b9df6,null))['then'](saveUpdates(_0x557ea5['body'],null))[_0x0c04('0x25')](respondWithResult(_0x4b9df6,null))[_0x0c04('0x46')](handleError(_0x4b9df6,null));};exports[_0x0c04('0x24')]=function(_0x253790,_0x5bf0d4){return db[_0x0c04('0x2c')][_0x0c04('0x49')]({'where':{'id':_0x253790['params']['id']}})['then'](handleEntityNotFound(_0x5bf0d4,null))[_0x0c04('0x25')](removeEntity(_0x5bf0d4,null))[_0x0c04('0x46')](handleError(_0x5bf0d4,null));};exports[_0x0c04('0x52')]=function(_0x23a040,_0x57a7f0,_0x17ac4b){return db[_0x0c04('0x2c')]['find']({'where':{'id':_0x23a040['params']['id']},'attributes':[_0x0c04('0x29'),_0x0c04('0x53'),_0x0c04('0x54'),_0x0c04('0x55')],'raw':!![]})[_0x0c04('0x25')](handleEntityNotFound(_0x57a7f0,null))[_0x0c04('0x25')](function(_0x4ee857){if(_0x4ee857){if(!fs[_0x0c04('0x56')](path[_0x0c04('0x57')](config[_0x0c04('0x58')],_0x0c04('0x59'),_0x4ee857[_0x0c04('0x54')]))){throw new db[(_0x0c04('0x5a'))]['ValidationError'](_0x0c04('0x5b'));}if(_0x23a040[_0x0c04('0x33')][_0x0c04('0x5c')]){return _0x57a7f0['sendStatus'](0xc8);}return _0x57a7f0[_0x0c04('0x52')](path[_0x0c04('0x57')](config[_0x0c04('0x58')],'server/files/reports',_0x4ee857[_0x0c04('0x54')]),util[_0x0c04('0x5d')](_0x0c04('0x5e'),_0x4ee857[_0x0c04('0x53')]||_0x4ee857[_0x0c04('0x29')],_0x4ee857[_0x0c04('0x55')][_0x0c04('0x5f')]()));}})[_0x0c04('0x46')](handleError(_0x57a7f0,null));};