9c43ce3bc41ff04fc720091013df984712b18fe1
[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 _0x2e5b=['catch','show','params','length','include','find','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','destroy','download','basename','savename','output','existsSync','root','server/files/reports','Sequelize','Report\x20not\x20found\x20or\x20empty','exists','join','%s.%s','toLowerCase','rimraf','zip-dir','moment','bluebird','mustache','path','to-csv','ejs','fs-extra','lodash','squel','crypto','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','limit','undefined','count','apply','reject','save','then','ExtractedReports','UserProfileResource','error','stack','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','key','query','keys','intersection','model','attributes','fields','hasOwnProperty','nolimit','sort','where','filters','pick','filter','merge','VIRTUAL','includeAll','findAll','rows'];(function(_0x5166f8,_0x54812c){var _0x4a2a5b=function(_0xf820d0){while(--_0xf820d0){_0x5166f8['push'](_0x5166f8['shift']());}};_0x4a2a5b(++_0x54812c);}(_0x2e5b,0x7e));var _0xb2e5=function(_0x226fd5,_0x599267){_0x226fd5=_0x226fd5-0x0;var _0x5122b5=_0x2e5b[_0x226fd5];return _0x5122b5;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xb2e5('0x0'));var zipdir=require(_0xb2e5('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0xb2e5('0x2'));var BPromise=require(_0xb2e5('0x3'));var Mustache=require(_0xb2e5('0x4'));var util=require('util');var path=require(_0xb2e5('0x5'));var sox=require('sox');var csv=require(_0xb2e5('0x6'));var ejs=require(_0xb2e5('0x7'));var fs=require('fs');var fs_extra=require(_0xb2e5('0x8'));var _=require(_0xb2e5('0x9'));var squel=require(_0xb2e5('0xa'));var crypto=require(_0xb2e5('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xb2e5('0x6'));var querystring=require(_0xb2e5('0xc'));var Papa=require(_0xb2e5('0xd'));var Redis=require(_0xb2e5('0xe'));var authService=require('../../components/auth/service');var qs=require(_0xb2e5('0xf'));var as=require(_0xb2e5('0x10'));var hardwareService=require(_0xb2e5('0x11'));var logger=require(_0xb2e5('0x12'))('api');var utils=require(_0xb2e5('0x13'));var config=require(_0xb2e5('0x14'));var licenseUtil=require(_0xb2e5('0x15'));var db=require(_0xb2e5('0x16'))['db'];function respondWithStatusCode(_0x2a5dc6,_0x34d9c9){_0x34d9c9=_0x34d9c9||0xcc;return function(_0x3575ed){if(_0x3575ed){return _0x2a5dc6[_0xb2e5('0x17')](_0x34d9c9);}return _0x2a5dc6[_0xb2e5('0x18')](_0x34d9c9)[_0xb2e5('0x19')]();};}function respondWithResult(_0x12a3ce,_0x1a2088){_0x1a2088=_0x1a2088||0xc8;return function(_0x314e){if(_0x314e){return _0x12a3ce[_0xb2e5('0x18')](_0x1a2088)['json'](_0x314e);}};}function respondWithFilteredResult(_0x273a27,_0x30589e){return function(_0x1242f0){if(_0x1242f0){var _0x1ce97b=typeof _0x30589e[_0xb2e5('0x1a')]==='undefined'&&typeof _0x30589e[_0xb2e5('0x1b')]===_0xb2e5('0x1c');var _0x461160=_0x1242f0[_0xb2e5('0x1d')];var _0x5ee708=_0x1ce97b?0x0:_0x30589e[_0xb2e5('0x1a')];var _0x38894c=_0x1ce97b?_0x1242f0[_0xb2e5('0x1d')]:_0x30589e[_0xb2e5('0x1a')]+_0x30589e[_0xb2e5('0x1b')];var _0x19f8e4;if(_0x38894c>=_0x461160){_0x38894c=_0x461160;_0x19f8e4=0xc8;}else{_0x19f8e4=0xce;}_0x273a27[_0xb2e5('0x18')](_0x19f8e4);return _0x273a27['set']('Content-Range',_0x5ee708+'-'+_0x38894c+'/'+_0x461160)['json'](_0x1242f0);}return null;};}function patchUpdates(_0x4b4c89){return function(_0x4a2cde){try{jsonpatch[_0xb2e5('0x1e')](_0x4a2cde,_0x4b4c89,!![]);}catch(_0x1a4259){return BPromise[_0xb2e5('0x1f')](_0x1a4259);}return _0x4a2cde[_0xb2e5('0x20')]();};}function saveUpdates(_0x22eaea,_0x59fc7c){return function(_0x5f1b30){if(_0x5f1b30){return _0x5f1b30['update'](_0x22eaea)[_0xb2e5('0x21')](function(_0x31668b){return _0x31668b;});}return null;};}function removeEntity(_0x59d121,_0x445281){return function(_0x460392){if(_0x460392){return _0x460392['destroy']()[_0xb2e5('0x21')](function(){var _0x1271fc=_0x460392['get']({'plain':!![]});var _0x294360=_0xb2e5('0x22');return db[_0xb2e5('0x23')]['destroy']({'where':{'type':_0x294360,'resourceId':_0x1271fc['id']}})[_0xb2e5('0x21')](function(){return _0x460392;});})[_0xb2e5('0x21')](function(){_0x59d121[_0xb2e5('0x18')](0xcc)[_0xb2e5('0x19')]();});}};}function handleEntityNotFound(_0x119f4b,_0xc30cb8){return function(_0x2be8f0){if(!_0x2be8f0){_0x119f4b[_0xb2e5('0x17')](0x194);}return _0x2be8f0;};}function handleError(_0x80ef7e,_0x362598){_0x362598=_0x362598||0x1f4;return function(_0x2f244b){logger[_0xb2e5('0x24')](_0x2f244b[_0xb2e5('0x25')]);if(_0x2f244b['name']){delete _0x2f244b[_0xb2e5('0x26')];}_0x80ef7e['status'](_0x362598)[_0xb2e5('0x27')](_0x2f244b);};}exports[_0xb2e5('0x28')]=function(_0x74e678,_0x3331ac){var _0x5a614f={},_0x176c3b={},_0x1fb0a8={'count':0x0,'rows':[]};var _0x1fb1d7=_[_0xb2e5('0x29')](db[_0xb2e5('0x2a')][_0xb2e5('0x2b')],function(_0x32f2fd){return{'name':_0x32f2fd[_0xb2e5('0x2c')],'type':_0x32f2fd['type'][_0xb2e5('0x2d')]};});_0x176c3b['model']=_[_0xb2e5('0x29')](_0x1fb1d7,'name');_0x176c3b[_0xb2e5('0x2e')]=_[_0xb2e5('0x2f')](_0x74e678[_0xb2e5('0x2e')]);_0x176c3b['filters']=_[_0xb2e5('0x30')](_0x176c3b[_0xb2e5('0x31')],_0x176c3b[_0xb2e5('0x2e')]);_0x5a614f[_0xb2e5('0x32')]=_['intersection'](_0x176c3b[_0xb2e5('0x31')],qs[_0xb2e5('0x33')](_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x33')]));_0x5a614f[_0xb2e5('0x32')]=_0x5a614f['attributes']['length']?_0x5a614f[_0xb2e5('0x32')]:_0x176c3b[_0xb2e5('0x31')];if(!_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x34')](_0xb2e5('0x35'))){_0x5a614f['limit']=qs[_0xb2e5('0x1b')](_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x1b')]);_0x5a614f['offset']=qs['offset'](_0x74e678['query'][_0xb2e5('0x1a')]);}_0x5a614f['order']=qs[_0xb2e5('0x36')](_0x74e678['query'][_0xb2e5('0x36')]);_0x5a614f[_0xb2e5('0x37')]=qs[_0xb2e5('0x38')](_[_0xb2e5('0x39')](_0x74e678[_0xb2e5('0x2e')],_0x176c3b['filters']),_0x1fb1d7);if(_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x3a')]){_0x5a614f['where']=_[_0xb2e5('0x3b')](_0x5a614f['where'],{'$or':_[_0xb2e5('0x29')](_0x1fb1d7,function(_0x5d9478){if(_0x5d9478['type']!==_0xb2e5('0x3c')){var _0x34d197={};_0x34d197[_0x5d9478['name']]={'$like':'%'+_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x3a')]+'%'};return _0x34d197;}})});}_0x5a614f=_['merge']({},_0x5a614f,_0x74e678['options']);var _0x4a616a={'where':_0x5a614f[_0xb2e5('0x37')]};return db['AnalyticExtractedReport'][_0xb2e5('0x1d')](_0x4a616a)['then'](function(_0x2eddf2){_0x1fb0a8[_0xb2e5('0x1d')]=_0x2eddf2;if(_0x74e678[_0xb2e5('0x2e')][_0xb2e5('0x3d')]){_0x5a614f['include']=[{'all':!![]}];}return db[_0xb2e5('0x2a')][_0xb2e5('0x3e')](_0x5a614f);})[_0xb2e5('0x21')](function(_0x3895c4){_0x1fb0a8[_0xb2e5('0x3f')]=_0x3895c4;return _0x1fb0a8;})[_0xb2e5('0x21')](respondWithFilteredResult(_0x3331ac,_0x5a614f))[_0xb2e5('0x40')](handleError(_0x3331ac,null));};exports[_0xb2e5('0x41')]=function(_0x583103,_0x4996da){var _0x2d03d4={'raw':!![],'where':{'id':_0x583103[_0xb2e5('0x42')]['id']}},_0x3d0b9d={};_0x3d0b9d[_0xb2e5('0x31')]=_['keys'](db[_0xb2e5('0x2a')][_0xb2e5('0x2b')]);_0x3d0b9d[_0xb2e5('0x2e')]=_[_0xb2e5('0x2f')](_0x583103[_0xb2e5('0x2e')]);_0x3d0b9d[_0xb2e5('0x38')]=_[_0xb2e5('0x30')](_0x3d0b9d[_0xb2e5('0x31')],_0x3d0b9d[_0xb2e5('0x2e')]);_0x2d03d4[_0xb2e5('0x32')]=_[_0xb2e5('0x30')](_0x3d0b9d['model'],qs[_0xb2e5('0x33')](_0x583103[_0xb2e5('0x2e')][_0xb2e5('0x33')]));_0x2d03d4[_0xb2e5('0x32')]=_0x2d03d4[_0xb2e5('0x32')][_0xb2e5('0x43')]?_0x2d03d4[_0xb2e5('0x32')]:_0x3d0b9d['model'];if(_0x583103['query'][_0xb2e5('0x3d')]){_0x2d03d4[_0xb2e5('0x44')]=[{'all':!![]}];}_0x2d03d4=_[_0xb2e5('0x3b')]({},_0x2d03d4,_0x583103['options']);return db[_0xb2e5('0x2a')][_0xb2e5('0x45')](_0x2d03d4)[_0xb2e5('0x21')](handleEntityNotFound(_0x4996da,null))[_0xb2e5('0x21')](respondWithResult(_0x4996da,null))[_0xb2e5('0x40')](handleError(_0x4996da,null));};exports[_0xb2e5('0x46')]=function(_0xb09436,_0x5323f9){return db['AnalyticExtractedReport'][_0xb2e5('0x46')](_0xb09436['body'],{})[_0xb2e5('0x21')](function(_0x557093){var _0x4defaa=_0xb09436[_0xb2e5('0x47')][_0xb2e5('0x48')]({'plain':!![]});if(!_0x4defaa)throw new Error(_0xb2e5('0x49'));if(_0x4defaa[_0xb2e5('0x4a')]===_0xb2e5('0x47')){var _0x1ff140=_0x557093[_0xb2e5('0x48')]({'plain':!![]});var _0xc6de14=_0xb2e5('0x22');return db[_0xb2e5('0x4b')][_0xb2e5('0x45')]({'where':{'name':_0xc6de14,'userProfileId':_0x4defaa[_0xb2e5('0x4c')]},'raw':!![]})[_0xb2e5('0x21')](function(_0x5d045c){if(_0x5d045c&&_0x5d045c[_0xb2e5('0x4d')]===0x0){return db[_0xb2e5('0x23')][_0xb2e5('0x46')]({'name':_0x1ff140[_0xb2e5('0x26')],'resourceId':_0x1ff140['id'],'type':_0x5d045c[_0xb2e5('0x26')],'sectionId':_0x5d045c['id']},{})[_0xb2e5('0x21')](function(){return _0x557093;});}else{return _0x557093;}})[_0xb2e5('0x40')](function(_0x372122){logger[_0xb2e5('0x24')](_0xb2e5('0x4e'),_0x372122);throw _0x372122;});}return _0x557093;})[_0xb2e5('0x21')](respondWithResult(_0x5323f9,0xc9))[_0xb2e5('0x40')](handleError(_0x5323f9,null));};exports[_0xb2e5('0x4f')]=function(_0x1bf1bc,_0x1b4327){if(_0x1bf1bc[_0xb2e5('0x50')]['id']){delete _0x1bf1bc[_0xb2e5('0x50')]['id'];}return db[_0xb2e5('0x2a')][_0xb2e5('0x45')]({'where':{'id':_0x1bf1bc[_0xb2e5('0x42')]['id']}})[_0xb2e5('0x21')](handleEntityNotFound(_0x1b4327,null))['then'](saveUpdates(_0x1bf1bc[_0xb2e5('0x50')],null))['then'](respondWithResult(_0x1b4327,null))[_0xb2e5('0x40')](handleError(_0x1b4327,null));};exports[_0xb2e5('0x51')]=function(_0x35c72a,_0x2969d0){return db[_0xb2e5('0x2a')][_0xb2e5('0x45')]({'where':{'id':_0x35c72a[_0xb2e5('0x42')]['id']}})[_0xb2e5('0x21')](handleEntityNotFound(_0x2969d0,null))[_0xb2e5('0x21')](removeEntity(_0x2969d0,null))[_0xb2e5('0x40')](handleError(_0x2969d0,null));};exports[_0xb2e5('0x52')]=function(_0x115136,_0x45b7ba,_0x506a57){return db[_0xb2e5('0x2a')][_0xb2e5('0x45')]({'where':{'id':_0x115136[_0xb2e5('0x42')]['id']},'attributes':['name',_0xb2e5('0x53'),_0xb2e5('0x54'),_0xb2e5('0x55')],'raw':!![]})[_0xb2e5('0x21')](handleEntityNotFound(_0x45b7ba,null))[_0xb2e5('0x21')](function(_0x1ca038){if(_0x1ca038){if(!fs[_0xb2e5('0x56')](path['join'](config[_0xb2e5('0x57')],_0xb2e5('0x58'),_0x1ca038[_0xb2e5('0x54')]))){throw new db[(_0xb2e5('0x59'))]['ValidationError'](_0xb2e5('0x5a'));}if(_0x115136[_0xb2e5('0x2e')][_0xb2e5('0x5b')]){return _0x45b7ba[_0xb2e5('0x17')](0xc8);}return _0x45b7ba[_0xb2e5('0x52')](path[_0xb2e5('0x5c')](config['root'],_0xb2e5('0x58'),_0x1ca038[_0xb2e5('0x54')]),util['format'](_0xb2e5('0x5d'),_0x1ca038[_0xb2e5('0x53')]||_0x1ca038[_0xb2e5('0x26')],_0x1ca038[_0xb2e5('0x55')][_0xb2e5('0x5e')]()));}})[_0xb2e5('0x40')](handleError(_0x45b7ba,null));};