Built motion from commit a679711e.|2.6.15
[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 _0x97da=['Unable\x20to\x20retrieve\x20the\x20current\x20user','role','ExtractedReports','UserProfileSection','find','autoAssociation','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','basename','savename','existsSync','join','root','Sequelize','exists','server/files/reports','format','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','sendStatus','end','status','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','update','then','destroy','get','stack','name','send','index','map','fieldName','type','key','query','keys','filters','intersection','model','fields','attributes','length','nolimit','order','sort','pick','filter','where','VIRTUAL','merge','includeAll','AnalyticExtractedReport','findAll','rows','show','params','rawAttributes','options','catch','create','body','user'];(function(_0x1eb3f6,_0x3f8dc7){var _0x511f68=function(_0x33d351){while(--_0x33d351){_0x1eb3f6['push'](_0x1eb3f6['shift']());}};_0x511f68(++_0x3f8dc7);}(_0x97da,0xd6));var _0xa97d=function(_0x732ef5,_0x535434){_0x732ef5=_0x732ef5-0x0;var _0x57791f=_0x97da[_0x732ef5];return _0x57791f;};'use strict';var emlformat=require(_0xa97d('0x0'));var rimraf=require(_0xa97d('0x1'));var zipdir=require(_0xa97d('0x2'));var jsonpatch=require(_0xa97d('0x3'));var rp=require(_0xa97d('0x4'));var moment=require(_0xa97d('0x5'));var BPromise=require(_0xa97d('0x6'));var Mustache=require(_0xa97d('0x7'));var util=require('util');var path=require(_0xa97d('0x8'));var sox=require(_0xa97d('0x9'));var csv=require(_0xa97d('0xa'));var ejs=require(_0xa97d('0xb'));var fs=require('fs');var fs_extra=require(_0xa97d('0xc'));var _=require(_0xa97d('0xd'));var squel=require(_0xa97d('0xe'));var crypto=require('crypto');var jsforce=require(_0xa97d('0xf'));var deskjs=require(_0xa97d('0x10'));var toCsv=require(_0xa97d('0xa'));var querystring=require('querystring');var Papa=require(_0xa97d('0x11'));var Redis=require(_0xa97d('0x12'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xa97d('0x13'));var hardwareService=require(_0xa97d('0x14'));var logger=require(_0xa97d('0x15'))(_0xa97d('0x16'));var utils=require('../../config/utils');var config=require(_0xa97d('0x17'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3a7ab7,_0x571fc1){_0x571fc1=_0x571fc1||0xcc;return function(_0x421eba){if(_0x421eba){return _0x3a7ab7[_0xa97d('0x18')](_0x571fc1);}return _0x3a7ab7['status'](_0x571fc1)[_0xa97d('0x19')]();};}function respondWithResult(_0x300f13,_0x4a7171){_0x4a7171=_0x4a7171||0xc8;return function(_0x285b46){if(_0x285b46){return _0x300f13[_0xa97d('0x1a')](_0x4a7171)['json'](_0x285b46);}};}function respondWithFilteredResult(_0x23f37e,_0x52384a){return function(_0x5862e5){if(_0x5862e5){var _0x3fd603=typeof _0x52384a[_0xa97d('0x1b')]===_0xa97d('0x1c')&&typeof _0x52384a[_0xa97d('0x1d')]===_0xa97d('0x1c');var _0x4d5efe=_0x5862e5[_0xa97d('0x1e')];var _0x49eced=_0x3fd603?0x0:_0x52384a[_0xa97d('0x1b')];var _0x57a7e0=_0x3fd603?_0x5862e5[_0xa97d('0x1e')]:_0x52384a[_0xa97d('0x1b')]+_0x52384a[_0xa97d('0x1d')];var _0x3f61cf;if(_0x57a7e0>=_0x4d5efe){_0x57a7e0=_0x4d5efe;_0x3f61cf=0xc8;}else{_0x3f61cf=0xce;}_0x23f37e[_0xa97d('0x1a')](_0x3f61cf);return _0x23f37e[_0xa97d('0x1f')](_0xa97d('0x20'),_0x49eced+'-'+_0x57a7e0+'/'+_0x4d5efe)[_0xa97d('0x21')](_0x5862e5);}return null;};}function patchUpdates(_0x427c39){return function(_0x4834e0){try{jsonpatch[_0xa97d('0x22')](_0x4834e0,_0x427c39,!![]);}catch(_0x322c59){return BPromise[_0xa97d('0x23')](_0x322c59);}return _0x4834e0[_0xa97d('0x24')]();};}function saveUpdates(_0x1c12c1,_0x4e2fb8){return function(_0x5df229){if(_0x5df229){return _0x5df229[_0xa97d('0x25')](_0x1c12c1)[_0xa97d('0x26')](function(_0x46620e){return _0x46620e;});}return null;};}function removeEntity(_0x3b6079,_0x1b2e5f){return function(_0x74dbee){if(_0x74dbee){return _0x74dbee[_0xa97d('0x27')]()[_0xa97d('0x26')](function(){var _0x575ef1=_0x74dbee[_0xa97d('0x28')]({'plain':!![]});var _0x3158d6='ExtractedReports';return db['UserProfileResource'][_0xa97d('0x27')]({'where':{'type':_0x3158d6,'resourceId':_0x575ef1['id']}})[_0xa97d('0x26')](function(){return _0x74dbee;});})[_0xa97d('0x26')](function(){_0x3b6079[_0xa97d('0x1a')](0xcc)[_0xa97d('0x19')]();});}};}function handleEntityNotFound(_0x206fa6,_0x55c894){return function(_0x3db232){if(!_0x3db232){_0x206fa6[_0xa97d('0x18')](0x194);}return _0x3db232;};}function handleError(_0x11cfaf,_0x1d732b){_0x1d732b=_0x1d732b||0x1f4;return function(_0x5f0c98){logger['error'](_0x5f0c98[_0xa97d('0x29')]);if(_0x5f0c98[_0xa97d('0x2a')]){delete _0x5f0c98[_0xa97d('0x2a')];}_0x11cfaf['status'](_0x1d732b)[_0xa97d('0x2b')](_0x5f0c98);};}exports[_0xa97d('0x2c')]=function(_0x16db6d,_0x5cba26){var _0x275c15={},_0x14766a={},_0x3c1269={'count':0x0,'rows':[]};var _0x54a609=_[_0xa97d('0x2d')](db['AnalyticExtractedReport']['rawAttributes'],function(_0x20144a){return{'name':_0x20144a[_0xa97d('0x2e')],'type':_0x20144a[_0xa97d('0x2f')][_0xa97d('0x30')]};});_0x14766a['model']=_[_0xa97d('0x2d')](_0x54a609,_0xa97d('0x2a'));_0x14766a[_0xa97d('0x31')]=_[_0xa97d('0x32')](_0x16db6d[_0xa97d('0x31')]);_0x14766a[_0xa97d('0x33')]=_[_0xa97d('0x34')](_0x14766a['model'],_0x14766a['query']);_0x275c15['attributes']=_['intersection'](_0x14766a[_0xa97d('0x35')],qs['fields'](_0x16db6d[_0xa97d('0x31')][_0xa97d('0x36')]));_0x275c15[_0xa97d('0x37')]=_0x275c15[_0xa97d('0x37')][_0xa97d('0x38')]?_0x275c15[_0xa97d('0x37')]:_0x14766a['model'];if(!_0x16db6d[_0xa97d('0x31')]['hasOwnProperty'](_0xa97d('0x39'))){_0x275c15[_0xa97d('0x1d')]=qs[_0xa97d('0x1d')](_0x16db6d['query'][_0xa97d('0x1d')]);_0x275c15[_0xa97d('0x1b')]=qs[_0xa97d('0x1b')](_0x16db6d[_0xa97d('0x31')][_0xa97d('0x1b')]);}_0x275c15[_0xa97d('0x3a')]=qs['sort'](_0x16db6d[_0xa97d('0x31')][_0xa97d('0x3b')]);_0x275c15['where']=qs[_0xa97d('0x33')](_[_0xa97d('0x3c')](_0x16db6d[_0xa97d('0x31')],_0x14766a[_0xa97d('0x33')]),_0x54a609);if(_0x16db6d['query'][_0xa97d('0x3d')]){_0x275c15[_0xa97d('0x3e')]=_['merge'](_0x275c15['where'],{'$or':_[_0xa97d('0x2d')](_0x54a609,function(_0x2016e1){if(_0x2016e1['type']!==_0xa97d('0x3f')){var _0x3d3cde={};_0x3d3cde[_0x2016e1[_0xa97d('0x2a')]]={'$like':'%'+_0x16db6d[_0xa97d('0x31')][_0xa97d('0x3d')]+'%'};return _0x3d3cde;}})});}_0x275c15=_[_0xa97d('0x40')]({},_0x275c15,_0x16db6d['options']);var _0x3a1e85={'where':_0x275c15[_0xa97d('0x3e')]};return db['AnalyticExtractedReport'][_0xa97d('0x1e')](_0x3a1e85)[_0xa97d('0x26')](function(_0x54c467){_0x3c1269['count']=_0x54c467;if(_0x16db6d['query'][_0xa97d('0x41')]){_0x275c15['include']=[{'all':!![]}];}return db[_0xa97d('0x42')][_0xa97d('0x43')](_0x275c15);})[_0xa97d('0x26')](function(_0x243c90){_0x3c1269[_0xa97d('0x44')]=_0x243c90;return _0x3c1269;})[_0xa97d('0x26')](respondWithFilteredResult(_0x5cba26,_0x275c15))['catch'](handleError(_0x5cba26,null));};exports[_0xa97d('0x45')]=function(_0x9ecb7c,_0x38280f){var _0x1b57f4={'raw':!![],'where':{'id':_0x9ecb7c[_0xa97d('0x46')]['id']}},_0xacda11={};_0xacda11[_0xa97d('0x35')]=_[_0xa97d('0x32')](db[_0xa97d('0x42')][_0xa97d('0x47')]);_0xacda11[_0xa97d('0x31')]=_[_0xa97d('0x32')](_0x9ecb7c[_0xa97d('0x31')]);_0xacda11[_0xa97d('0x33')]=_[_0xa97d('0x34')](_0xacda11[_0xa97d('0x35')],_0xacda11[_0xa97d('0x31')]);_0x1b57f4['attributes']=_[_0xa97d('0x34')](_0xacda11['model'],qs[_0xa97d('0x36')](_0x9ecb7c[_0xa97d('0x31')]['fields']));_0x1b57f4[_0xa97d('0x37')]=_0x1b57f4[_0xa97d('0x37')][_0xa97d('0x38')]?_0x1b57f4['attributes']:_0xacda11['model'];if(_0x9ecb7c[_0xa97d('0x31')][_0xa97d('0x41')]){_0x1b57f4['include']=[{'all':!![]}];}_0x1b57f4=_[_0xa97d('0x40')]({},_0x1b57f4,_0x9ecb7c[_0xa97d('0x48')]);return db[_0xa97d('0x42')]['find'](_0x1b57f4)[_0xa97d('0x26')](handleEntityNotFound(_0x38280f,null))[_0xa97d('0x26')](respondWithResult(_0x38280f,null))[_0xa97d('0x49')](handleError(_0x38280f,null));};exports[_0xa97d('0x4a')]=function(_0x4d8d19,_0x26b83f){return db[_0xa97d('0x42')][_0xa97d('0x4a')](_0x4d8d19[_0xa97d('0x4b')],{})[_0xa97d('0x26')](function(_0x5068ea){var _0xfded9d=_0x4d8d19[_0xa97d('0x4c')]['get']({'plain':!![]});if(!_0xfded9d)throw new Error(_0xa97d('0x4d'));if(_0xfded9d[_0xa97d('0x4e')]===_0xa97d('0x4c')){var _0x36e512=_0x5068ea[_0xa97d('0x28')]({'plain':!![]});var _0x29b9b1=_0xa97d('0x4f');return db[_0xa97d('0x50')][_0xa97d('0x51')]({'where':{'name':_0x29b9b1,'userProfileId':_0xfded9d['userProfileId']},'raw':!![]})[_0xa97d('0x26')](function(_0xb0cceb){if(_0xb0cceb&&_0xb0cceb[_0xa97d('0x52')]===0x0){return db[_0xa97d('0x53')]['create']({'name':_0x36e512[_0xa97d('0x2a')],'resourceId':_0x36e512['id'],'type':_0xb0cceb['name'],'sectionId':_0xb0cceb['id']},{})[_0xa97d('0x26')](function(){return _0x5068ea;});}else{return _0x5068ea;}})[_0xa97d('0x49')](function(_0x4ee3bf){logger[_0xa97d('0x54')](_0xa97d('0x55'),_0x4ee3bf);throw _0x4ee3bf;});}return _0x5068ea;})['then'](respondWithResult(_0x26b83f,0xc9))[_0xa97d('0x49')](handleError(_0x26b83f,null));};exports[_0xa97d('0x25')]=function(_0x51c226,_0x30eaec){if(_0x51c226[_0xa97d('0x4b')]['id']){delete _0x51c226[_0xa97d('0x4b')]['id'];}return db[_0xa97d('0x42')]['find']({'where':{'id':_0x51c226['params']['id']}})[_0xa97d('0x26')](handleEntityNotFound(_0x30eaec,null))[_0xa97d('0x26')](saveUpdates(_0x51c226[_0xa97d('0x4b')],null))[_0xa97d('0x26')](respondWithResult(_0x30eaec,null))[_0xa97d('0x49')](handleError(_0x30eaec,null));};exports[_0xa97d('0x27')]=function(_0x271d6a,_0x37acfa){return db[_0xa97d('0x42')]['find']({'where':{'id':_0x271d6a[_0xa97d('0x46')]['id']}})[_0xa97d('0x26')](handleEntityNotFound(_0x37acfa,null))[_0xa97d('0x26')](removeEntity(_0x37acfa,null))[_0xa97d('0x49')](handleError(_0x37acfa,null));};exports[_0xa97d('0x56')]=function(_0x3301dd,_0x2172a8,_0x41d983){return db[_0xa97d('0x42')][_0xa97d('0x51')]({'where':{'id':_0x3301dd[_0xa97d('0x46')]['id']},'attributes':[_0xa97d('0x2a'),_0xa97d('0x57'),_0xa97d('0x58'),'output'],'raw':!![]})['then'](handleEntityNotFound(_0x2172a8,null))['then'](function(_0x15e112){if(_0x15e112){if(!fs[_0xa97d('0x59')](path[_0xa97d('0x5a')](config[_0xa97d('0x5b')],'server/files/reports',_0x15e112[_0xa97d('0x58')]))){throw new db[(_0xa97d('0x5c'))]['ValidationError']('Report\x20not\x20found\x20or\x20empty');}if(_0x3301dd[_0xa97d('0x31')][_0xa97d('0x5d')]){return _0x2172a8[_0xa97d('0x18')](0xc8);}return _0x2172a8[_0xa97d('0x56')](path['join'](config['root'],_0xa97d('0x5e'),_0x15e112['savename']),util[_0xa97d('0x5f')]('%s.%s',_0x15e112[_0xa97d('0x57')]||_0x15e112[_0xa97d('0x2a')],_0x15e112['output'][_0xa97d('0x60')]()));}})[_0xa97d('0x49')](handleError(_0x2172a8,null));};