Built motion from commit 7158bc59.|2.5.42
[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 _0xa28c=['basename','savename','output','root','server/files/reports','Sequelize','exists','format','%s.%s','toLowerCase','eml-format','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','undefined','limit','count','set','apply','update','then','destroy','get','ExtractedReports','UserProfileResource','error','name','send','index','map','AnalyticExtractedReport','fieldName','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','offset','order','sort','where','pick','filter','type','VIRTUAL','options','findAll','rows','show','params','includeAll','merge','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download'];(function(_0x3fe8f7,_0x63b432){var _0x424799=function(_0x41ef2e){while(--_0x41ef2e){_0x3fe8f7['push'](_0x3fe8f7['shift']());}};_0x424799(++_0x63b432);}(_0xa28c,0x127));var _0xca28=function(_0x13e741,_0x5d3c24){_0x13e741=_0x13e741-0x0;var _0x3f8bb3=_0xa28c[_0x13e741];return _0x3f8bb3;};'use strict';var emlformat=require(_0xca28('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xca28('0x1'));var jsonpatch=require(_0xca28('0x2'));var rp=require(_0xca28('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xca28('0x4'));var util=require(_0xca28('0x5'));var path=require(_0xca28('0x6'));var sox=require(_0xca28('0x7'));var csv=require(_0xca28('0x8'));var ejs=require(_0xca28('0x9'));var fs=require('fs');var fs_extra=require(_0xca28('0xa'));var _=require(_0xca28('0xb'));var squel=require('squel');var crypto=require(_0xca28('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xca28('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xca28('0xe'));var Redis=require(_0xca28('0xf'));var authService=require(_0xca28('0x10'));var qs=require(_0xca28('0x11'));var as=require(_0xca28('0x12'));var hardwareService=require(_0xca28('0x13'));var logger=require(_0xca28('0x14'))(_0xca28('0x15'));var utils=require(_0xca28('0x16'));var config=require(_0xca28('0x17'));var licenseUtil=require(_0xca28('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x52c663,_0x3c28ab){_0x3c28ab=_0x3c28ab||0xcc;return function(_0x4f732f){if(_0x4f732f){return _0x52c663[_0xca28('0x19')](_0x3c28ab);}return _0x52c663[_0xca28('0x1a')](_0x3c28ab)[_0xca28('0x1b')]();};}function respondWithResult(_0x27c675,_0x1d2379){_0x1d2379=_0x1d2379||0xc8;return function(_0xde79c5){if(_0xde79c5){return _0x27c675['status'](_0x1d2379)[_0xca28('0x1c')](_0xde79c5);}};}function respondWithFilteredResult(_0x50c17c,_0xa146cc){return function(_0x504b3e){if(_0x504b3e){var _0x31a4dd=typeof _0xa146cc['offset']===_0xca28('0x1d')&&typeof _0xa146cc[_0xca28('0x1e')]===_0xca28('0x1d');var _0x5efc7f=_0x504b3e[_0xca28('0x1f')];var _0x56182a=_0x31a4dd?0x0:_0xa146cc['offset'];var _0x2ab5b5=_0x31a4dd?_0x504b3e[_0xca28('0x1f')]:_0xa146cc['offset']+_0xa146cc[_0xca28('0x1e')];var _0x2371b9;if(_0x2ab5b5>=_0x5efc7f){_0x2ab5b5=_0x5efc7f;_0x2371b9=0xc8;}else{_0x2371b9=0xce;}_0x50c17c[_0xca28('0x1a')](_0x2371b9);return _0x50c17c[_0xca28('0x20')]('Content-Range',_0x56182a+'-'+_0x2ab5b5+'/'+_0x5efc7f)[_0xca28('0x1c')](_0x504b3e);}return null;};}function patchUpdates(_0x50b9db){return function(_0x1e1dc5){try{jsonpatch[_0xca28('0x21')](_0x1e1dc5,_0x50b9db,!![]);}catch(_0x1cbdbb){return BPromise['reject'](_0x1cbdbb);}return _0x1e1dc5['save']();};}function saveUpdates(_0x148c87,_0x3e5f96){return function(_0x1398d9){if(_0x1398d9){return _0x1398d9[_0xca28('0x22')](_0x148c87)[_0xca28('0x23')](function(_0xcda208){return _0xcda208;});}return null;};}function removeEntity(_0x1fd377,_0x226fea){return function(_0x41979a){if(_0x41979a){return _0x41979a[_0xca28('0x24')]()[_0xca28('0x23')](function(){var _0x558f94=_0x41979a[_0xca28('0x25')]({'plain':!![]});var _0x37e12a=_0xca28('0x26');return db[_0xca28('0x27')][_0xca28('0x24')]({'where':{'type':_0x37e12a,'resourceId':_0x558f94['id']}})[_0xca28('0x23')](function(){return _0x41979a;});})['then'](function(){_0x1fd377['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0xe9a3cb,_0x5dffae){return function(_0x447cbf){if(!_0x447cbf){_0xe9a3cb[_0xca28('0x19')](0x194);}return _0x447cbf;};}function handleError(_0x1a6e88,_0x4a959b){_0x4a959b=_0x4a959b||0x1f4;return function(_0x364f93){logger[_0xca28('0x28')](_0x364f93['stack']);if(_0x364f93['name']){delete _0x364f93[_0xca28('0x29')];}_0x1a6e88[_0xca28('0x1a')](_0x4a959b)[_0xca28('0x2a')](_0x364f93);};}exports[_0xca28('0x2b')]=function(_0x309457,_0x1f3d68){var _0xfab1d8={},_0x5c9b3f={},_0x3f1ebd={'count':0x0,'rows':[]};var _0x444e6d=_[_0xca28('0x2c')](db[_0xca28('0x2d')]['rawAttributes'],function(_0x4b9dc6){return{'name':_0x4b9dc6[_0xca28('0x2e')],'type':_0x4b9dc6['type'][_0xca28('0x2f')]};});_0x5c9b3f[_0xca28('0x30')]=_[_0xca28('0x2c')](_0x444e6d,_0xca28('0x29'));_0x5c9b3f[_0xca28('0x31')]=_[_0xca28('0x32')](_0x309457[_0xca28('0x31')]);_0x5c9b3f[_0xca28('0x33')]=_['intersection'](_0x5c9b3f[_0xca28('0x30')],_0x5c9b3f[_0xca28('0x31')]);_0xfab1d8['attributes']=_[_0xca28('0x34')](_0x5c9b3f[_0xca28('0x30')],qs[_0xca28('0x35')](_0x309457['query'][_0xca28('0x35')]));_0xfab1d8[_0xca28('0x36')]=_0xfab1d8[_0xca28('0x36')][_0xca28('0x37')]?_0xfab1d8[_0xca28('0x36')]:_0x5c9b3f[_0xca28('0x30')];if(!_0x309457[_0xca28('0x31')][_0xca28('0x38')](_0xca28('0x39'))){_0xfab1d8[_0xca28('0x1e')]=qs[_0xca28('0x1e')](_0x309457[_0xca28('0x31')][_0xca28('0x1e')]);_0xfab1d8[_0xca28('0x3a')]=qs[_0xca28('0x3a')](_0x309457[_0xca28('0x31')][_0xca28('0x3a')]);}_0xfab1d8[_0xca28('0x3b')]=qs[_0xca28('0x3c')](_0x309457['query'][_0xca28('0x3c')]);_0xfab1d8[_0xca28('0x3d')]=qs[_0xca28('0x33')](_[_0xca28('0x3e')](_0x309457['query'],_0x5c9b3f[_0xca28('0x33')]),_0x444e6d);if(_0x309457[_0xca28('0x31')][_0xca28('0x3f')]){_0xfab1d8[_0xca28('0x3d')]=_['merge'](_0xfab1d8[_0xca28('0x3d')],{'$or':_['map'](_0x444e6d,function(_0x43cce1){if(_0x43cce1[_0xca28('0x40')]!==_0xca28('0x41')){var _0x4801dd={};_0x4801dd[_0x43cce1[_0xca28('0x29')]]={'$like':'%'+_0x309457['query'][_0xca28('0x3f')]+'%'};return _0x4801dd;}})});}_0xfab1d8=_['merge']({},_0xfab1d8,_0x309457[_0xca28('0x42')]);var _0x5bb14e={'where':_0xfab1d8[_0xca28('0x3d')]};return db[_0xca28('0x2d')]['count'](_0x5bb14e)[_0xca28('0x23')](function(_0x2321cc){_0x3f1ebd[_0xca28('0x1f')]=_0x2321cc;if(_0x309457['query']['includeAll']){_0xfab1d8['include']=[{'all':!![]}];}return db[_0xca28('0x2d')][_0xca28('0x43')](_0xfab1d8);})[_0xca28('0x23')](function(_0x69502){_0x3f1ebd[_0xca28('0x44')]=_0x69502;return _0x3f1ebd;})['then'](respondWithFilteredResult(_0x1f3d68,_0xfab1d8))['catch'](handleError(_0x1f3d68,null));};exports[_0xca28('0x45')]=function(_0x1bb9ea,_0x2760b1){var _0x5949e4={'raw':!![],'where':{'id':_0x1bb9ea[_0xca28('0x46')]['id']}},_0x565198={};_0x565198[_0xca28('0x30')]=_[_0xca28('0x32')](db[_0xca28('0x2d')]['rawAttributes']);_0x565198['query']=_[_0xca28('0x32')](_0x1bb9ea['query']);_0x565198['filters']=_[_0xca28('0x34')](_0x565198[_0xca28('0x30')],_0x565198['query']);_0x5949e4['attributes']=_[_0xca28('0x34')](_0x565198[_0xca28('0x30')],qs['fields'](_0x1bb9ea[_0xca28('0x31')][_0xca28('0x35')]));_0x5949e4['attributes']=_0x5949e4['attributes']['length']?_0x5949e4['attributes']:_0x565198[_0xca28('0x30')];if(_0x1bb9ea[_0xca28('0x31')][_0xca28('0x47')]){_0x5949e4['include']=[{'all':!![]}];}_0x5949e4=_[_0xca28('0x48')]({},_0x5949e4,_0x1bb9ea[_0xca28('0x42')]);return db[_0xca28('0x2d')][_0xca28('0x49')](_0x5949e4)[_0xca28('0x23')](handleEntityNotFound(_0x2760b1,null))['then'](respondWithResult(_0x2760b1,null))[_0xca28('0x4a')](handleError(_0x2760b1,null));};exports[_0xca28('0x4b')]=function(_0x4dc426,_0x5f882){return db['AnalyticExtractedReport'][_0xca28('0x4b')](_0x4dc426[_0xca28('0x4c')],{})[_0xca28('0x23')](function(_0x54e87a){var _0x586a9d=_0x4dc426[_0xca28('0x4d')][_0xca28('0x25')]({'plain':!![]});if(!_0x586a9d)throw new Error(_0xca28('0x4e'));if(_0x586a9d[_0xca28('0x4f')]===_0xca28('0x4d')){var _0x5b74f3=_0x54e87a[_0xca28('0x25')]({'plain':!![]});var _0x949dab=_0xca28('0x26');return db[_0xca28('0x50')][_0xca28('0x49')]({'where':{'name':_0x949dab,'userProfileId':_0x586a9d[_0xca28('0x51')]},'raw':!![]})[_0xca28('0x23')](function(_0x1040ef){if(_0x1040ef&&_0x1040ef[_0xca28('0x52')]===0x0){return db[_0xca28('0x27')][_0xca28('0x4b')]({'name':_0x5b74f3[_0xca28('0x29')],'resourceId':_0x5b74f3['id'],'type':_0x1040ef[_0xca28('0x29')],'sectionId':_0x1040ef['id']},{})[_0xca28('0x23')](function(){return _0x54e87a;});}else{return _0x54e87a;}})[_0xca28('0x4a')](function(_0x4b0093){logger[_0xca28('0x28')](_0xca28('0x53'),_0x4b0093);throw _0x4b0093;});}return _0x54e87a;})[_0xca28('0x23')](respondWithResult(_0x5f882,0xc9))['catch'](handleError(_0x5f882,null));};exports[_0xca28('0x22')]=function(_0x24cb92,_0x196e31){if(_0x24cb92[_0xca28('0x4c')]['id']){delete _0x24cb92['body']['id'];}return db[_0xca28('0x2d')][_0xca28('0x49')]({'where':{'id':_0x24cb92[_0xca28('0x46')]['id']}})[_0xca28('0x23')](handleEntityNotFound(_0x196e31,null))['then'](saveUpdates(_0x24cb92[_0xca28('0x4c')],null))['then'](respondWithResult(_0x196e31,null))[_0xca28('0x4a')](handleError(_0x196e31,null));};exports[_0xca28('0x24')]=function(_0x3631d8,_0x3833cf){return db['AnalyticExtractedReport']['find']({'where':{'id':_0x3631d8[_0xca28('0x46')]['id']}})['then'](handleEntityNotFound(_0x3833cf,null))[_0xca28('0x23')](removeEntity(_0x3833cf,null))[_0xca28('0x4a')](handleError(_0x3833cf,null));};exports[_0xca28('0x54')]=function(_0x3a370b,_0x599aae,_0x2cb5c3){return db[_0xca28('0x2d')][_0xca28('0x49')]({'where':{'id':_0x3a370b[_0xca28('0x46')]['id']},'attributes':[_0xca28('0x29'),_0xca28('0x55'),_0xca28('0x56'),_0xca28('0x57')],'raw':!![]})['then'](handleEntityNotFound(_0x599aae,null))[_0xca28('0x23')](function(_0x367f9a){if(_0x367f9a){if(!fs['existsSync'](path['join'](config[_0xca28('0x58')],_0xca28('0x59'),_0x367f9a[_0xca28('0x56')]))){throw new db[(_0xca28('0x5a'))]['ValidationError']('Report\x20not\x20found\x20or\x20empty');}if(_0x3a370b['query'][_0xca28('0x5b')]){return _0x599aae[_0xca28('0x19')](0xc8);}return _0x599aae['download'](path['join'](config['root'],_0xca28('0x59'),_0x367f9a[_0xca28('0x56')]),util[_0xca28('0x5c')](_0xca28('0x5d'),_0x367f9a['basename']||_0x367f9a[_0xca28('0x29')],_0x367f9a[_0xca28('0x57')][_0xca28('0x5e')]()));}})[_0xca28('0x4a')](handleError(_0x599aae,null));};