Built motion from commit (unavailable).|2.5.20
[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 _0x54a6=['create','body','user','role','userProfileId','autoAssociation','update','download','basename','output','join','root','server/files/reports','Sequelize','savename','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','count','offset','limit','apply','reject','save','then','destroy','get','ExtractedReports','UserProfileResource','error','name','index','map','fieldName','type','key','model','keys','query','filters','attributes','intersection','fields','length','nolimit','order','sort','where','pick','merge','VIRTUAL','AnalyticExtractedReport','includeAll','findAll','rows','catch','show','params','rawAttributes','options','find'];(function(_0x4e586a,_0x30ce47){var _0x201403=function(_0x3e1187){while(--_0x3e1187){_0x4e586a['push'](_0x4e586a['shift']());}};_0x201403(++_0x30ce47);}(_0x54a6,0x68));var _0x654a=function(_0xcba2a,_0x1cd689){_0xcba2a=_0xcba2a-0x0;var _0x39ed1d=_0x54a6[_0xcba2a];return _0x39ed1d;};'use strict';var pdf=require(_0x654a('0x0'));var emlformat=require(_0x654a('0x1'));var rimraf=require(_0x654a('0x2'));var zipdir=require(_0x654a('0x3'));var jsonpatch=require(_0x654a('0x4'));var rp=require(_0x654a('0x5'));var moment=require(_0x654a('0x6'));var BPromise=require(_0x654a('0x7'));var Mustache=require(_0x654a('0x8'));var util=require(_0x654a('0x9'));var path=require(_0x654a('0xa'));var sox=require(_0x654a('0xb'));var csv=require(_0x654a('0xc'));var ejs=require(_0x654a('0xd'));var fs=require('fs');var _=require(_0x654a('0xe'));var squel=require(_0x654a('0xf'));var crypto=require(_0x654a('0x10'));var jsforce=require('jsforce');var deskjs=require(_0x654a('0x11'));var toCsv=require(_0x654a('0xc'));var querystring=require(_0x654a('0x12'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x654a('0x13'));var qs=require(_0x654a('0x14'));var as=require(_0x654a('0x15'));var hardwareService=require(_0x654a('0x16'));var logger=require('../../config/logger')(_0x654a('0x17'));var utils=require(_0x654a('0x18'));var config=require(_0x654a('0x19'));var licenseUtil=require(_0x654a('0x1a'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5d6cbf,_0x5f4eb1){_0x5f4eb1=_0x5f4eb1||0xcc;return function(_0x1d501b){if(_0x1d501b){return _0x5d6cbf[_0x654a('0x1b')](_0x5f4eb1);}return _0x5d6cbf[_0x654a('0x1c')](_0x5f4eb1)[_0x654a('0x1d')]();};}function respondWithResult(_0x2fc1f9,_0x3eca5d){_0x3eca5d=_0x3eca5d||0xc8;return function(_0x1642d4){if(_0x1642d4){return _0x2fc1f9[_0x654a('0x1c')](_0x3eca5d)[_0x654a('0x1e')](_0x1642d4);}};}function respondWithFilteredResult(_0x47c0aa,_0x2ac14a){return function(_0x14fb04){if(_0x14fb04){var _0x574be5=_0x14fb04[_0x654a('0x1f')],_0x3c4d24=_0x2ac14a['offset'],_0xec7bc4=_0x2ac14a[_0x654a('0x20')]+_0x2ac14a[_0x654a('0x21')],_0x33fe70;if(_0xec7bc4>=_0x574be5){_0xec7bc4=_0x574be5;_0x33fe70=0xc8;}else{_0x33fe70=0xce;}_0x47c0aa[_0x654a('0x1c')](_0x33fe70);return _0x47c0aa['set']('Content-Range',_0x3c4d24+'-'+_0xec7bc4+'/'+_0x574be5)[_0x654a('0x1e')](_0x14fb04);}return null;};}function patchUpdates(_0x493ca2){return function(_0x30610e){try{jsonpatch[_0x654a('0x22')](_0x30610e,_0x493ca2,!![]);}catch(_0x255132){return BPromise[_0x654a('0x23')](_0x255132);}return _0x30610e[_0x654a('0x24')]();};}function saveUpdates(_0x34cc77,_0x29b346){return function(_0xb7e2be){if(_0xb7e2be){return _0xb7e2be['update'](_0x34cc77)[_0x654a('0x25')](function(_0x1f7dd3){return _0x1f7dd3;});}return null;};}function removeEntity(_0x3412a1,_0x1b7526){return function(_0x4dbca8){if(_0x4dbca8){return _0x4dbca8[_0x654a('0x26')]()['then'](function(){var _0x3205df=_0x4dbca8[_0x654a('0x27')]({'plain':!![]});var _0x256ebc=_0x654a('0x28');return db[_0x654a('0x29')][_0x654a('0x26')]({'where':{'type':_0x256ebc,'resourceId':_0x3205df['id']}})[_0x654a('0x25')](function(){return _0x4dbca8;});})[_0x654a('0x25')](function(){_0x3412a1[_0x654a('0x1c')](0xcc)[_0x654a('0x1d')]();});}};}function handleEntityNotFound(_0x596c86,_0x569f6e){return function(_0x362644){if(!_0x362644){_0x596c86[_0x654a('0x1b')](0x194);}return _0x362644;};}function handleError(_0x2ceb04,_0x3ff993){_0x3ff993=_0x3ff993||0x1f4;return function(_0xb9503c){logger[_0x654a('0x2a')](_0xb9503c['stack']);if(_0xb9503c['name']){delete _0xb9503c[_0x654a('0x2b')];}_0x2ceb04['status'](_0x3ff993)['send'](_0xb9503c);};}exports[_0x654a('0x2c')]=function(_0x418818,_0x5a8d52){var _0x4968e4={},_0x406e26={},_0x118672={'count':0x0,'rows':[]};var _0x2d0bf5=_[_0x654a('0x2d')](db['AnalyticExtractedReport']['rawAttributes'],function(_0x5a342d){return{'name':_0x5a342d[_0x654a('0x2e')],'type':_0x5a342d[_0x654a('0x2f')][_0x654a('0x30')]};});_0x406e26[_0x654a('0x31')]=_['map'](_0x2d0bf5,_0x654a('0x2b'));_0x406e26['query']=_[_0x654a('0x32')](_0x418818[_0x654a('0x33')]);_0x406e26[_0x654a('0x34')]=_['intersection'](_0x406e26['model'],_0x406e26[_0x654a('0x33')]);_0x4968e4[_0x654a('0x35')]=_[_0x654a('0x36')](_0x406e26[_0x654a('0x31')],qs[_0x654a('0x37')](_0x418818[_0x654a('0x33')][_0x654a('0x37')]));_0x4968e4[_0x654a('0x35')]=_0x4968e4[_0x654a('0x35')][_0x654a('0x38')]?_0x4968e4['attributes']:_0x406e26[_0x654a('0x31')];if(!_0x418818[_0x654a('0x33')]['hasOwnProperty'](_0x654a('0x39'))){_0x4968e4['limit']=qs[_0x654a('0x21')](_0x418818[_0x654a('0x33')][_0x654a('0x21')]);_0x4968e4[_0x654a('0x20')]=qs[_0x654a('0x20')](_0x418818['query'][_0x654a('0x20')]);}_0x4968e4[_0x654a('0x3a')]=qs[_0x654a('0x3b')](_0x418818[_0x654a('0x33')][_0x654a('0x3b')]);_0x4968e4[_0x654a('0x3c')]=qs[_0x654a('0x34')](_[_0x654a('0x3d')](_0x418818['query'],_0x406e26['filters']),_0x2d0bf5);if(_0x418818['query']['filter']){_0x4968e4[_0x654a('0x3c')]=_[_0x654a('0x3e')](_0x4968e4[_0x654a('0x3c')],{'$or':_[_0x654a('0x2d')](_0x2d0bf5,function(_0x453d2b){if(_0x453d2b[_0x654a('0x2f')]!==_0x654a('0x3f')){var _0x27b2e6={};_0x27b2e6[_0x453d2b[_0x654a('0x2b')]]={'$like':'%'+_0x418818['query']['filter']+'%'};return _0x27b2e6;}})});}_0x4968e4=_[_0x654a('0x3e')]({},_0x4968e4,_0x418818['options']);var _0x31a693={'where':_0x4968e4[_0x654a('0x3c')]};return db[_0x654a('0x40')][_0x654a('0x1f')](_0x31a693)[_0x654a('0x25')](function(_0x107ff7){_0x118672[_0x654a('0x1f')]=_0x107ff7;if(_0x418818[_0x654a('0x33')][_0x654a('0x41')]){_0x4968e4['include']=[{'all':!![]}];}return db[_0x654a('0x40')][_0x654a('0x42')](_0x4968e4);})[_0x654a('0x25')](function(_0x428302){_0x118672[_0x654a('0x43')]=_0x428302;return _0x118672;})[_0x654a('0x25')](respondWithFilteredResult(_0x5a8d52,_0x4968e4))[_0x654a('0x44')](handleError(_0x5a8d52,null));};exports[_0x654a('0x45')]=function(_0x3760ad,_0x140de7){var _0x335374={'raw':!![],'where':{'id':_0x3760ad[_0x654a('0x46')]['id']}},_0xd23d0d={};_0xd23d0d[_0x654a('0x31')]=_[_0x654a('0x32')](db['AnalyticExtractedReport'][_0x654a('0x47')]);_0xd23d0d['query']=_[_0x654a('0x32')](_0x3760ad[_0x654a('0x33')]);_0xd23d0d['filters']=_[_0x654a('0x36')](_0xd23d0d[_0x654a('0x31')],_0xd23d0d[_0x654a('0x33')]);_0x335374[_0x654a('0x35')]=_[_0x654a('0x36')](_0xd23d0d[_0x654a('0x31')],qs[_0x654a('0x37')](_0x3760ad['query'][_0x654a('0x37')]));_0x335374['attributes']=_0x335374[_0x654a('0x35')][_0x654a('0x38')]?_0x335374[_0x654a('0x35')]:_0xd23d0d[_0x654a('0x31')];if(_0x3760ad[_0x654a('0x33')][_0x654a('0x41')]){_0x335374['include']=[{'all':!![]}];}_0x335374=_['merge']({},_0x335374,_0x3760ad[_0x654a('0x48')]);return db['AnalyticExtractedReport'][_0x654a('0x49')](_0x335374)[_0x654a('0x25')](handleEntityNotFound(_0x140de7,null))['then'](respondWithResult(_0x140de7,null))[_0x654a('0x44')](handleError(_0x140de7,null));};exports[_0x654a('0x4a')]=function(_0x1994a7,_0x13d78){return db['AnalyticExtractedReport'][_0x654a('0x4a')](_0x1994a7[_0x654a('0x4b')],{})[_0x654a('0x25')](function(_0x5620a8){var _0x57a1df=_0x1994a7[_0x654a('0x4c')][_0x654a('0x27')]({'plain':!![]});if(!_0x57a1df)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x57a1df[_0x654a('0x4d')]===_0x654a('0x4c')){var _0x51be9d=_0x5620a8[_0x654a('0x27')]({'plain':!![]});var _0x1a29e7=_0x654a('0x28');return db['UserProfileSection']['find']({'where':{'name':_0x1a29e7,'userProfileId':_0x57a1df[_0x654a('0x4e')]},'raw':!![]})[_0x654a('0x25')](function(_0xaa973b){if(_0xaa973b&&_0xaa973b[_0x654a('0x4f')]===0x0){return db[_0x654a('0x29')][_0x654a('0x4a')]({'name':_0x51be9d[_0x654a('0x2b')],'resourceId':_0x51be9d['id'],'type':_0xaa973b[_0x654a('0x2b')],'sectionId':_0xaa973b['id']},{})[_0x654a('0x25')](function(){return _0x5620a8;});}else{return _0x5620a8;}})[_0x654a('0x44')](function(_0x251ba7){logger[_0x654a('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x251ba7);throw _0x251ba7;});}return _0x5620a8;})[_0x654a('0x25')](respondWithResult(_0x13d78,0xc9))[_0x654a('0x44')](handleError(_0x13d78,null));};exports[_0x654a('0x50')]=function(_0x1a89f4,_0x32577f){if(_0x1a89f4[_0x654a('0x4b')]['id']){delete _0x1a89f4[_0x654a('0x4b')]['id'];}return db['AnalyticExtractedReport'][_0x654a('0x49')]({'where':{'id':_0x1a89f4[_0x654a('0x46')]['id']}})[_0x654a('0x25')](handleEntityNotFound(_0x32577f,null))['then'](saveUpdates(_0x1a89f4[_0x654a('0x4b')],null))[_0x654a('0x25')](respondWithResult(_0x32577f,null))['catch'](handleError(_0x32577f,null));};exports['destroy']=function(_0x14dbb1,_0x15c18a){return db[_0x654a('0x40')][_0x654a('0x49')]({'where':{'id':_0x14dbb1[_0x654a('0x46')]['id']}})[_0x654a('0x25')](handleEntityNotFound(_0x15c18a,null))[_0x654a('0x25')](removeEntity(_0x15c18a,null))[_0x654a('0x44')](handleError(_0x15c18a,null));};exports[_0x654a('0x51')]=function(_0x57111,_0x56b341,_0x44e0a9){return db[_0x654a('0x40')][_0x654a('0x49')]({'where':{'id':_0x57111['params']['id']},'attributes':[_0x654a('0x2b'),_0x654a('0x52'),'savename',_0x654a('0x53')],'raw':!![]})[_0x654a('0x25')](handleEntityNotFound(_0x56b341,null))[_0x654a('0x25')](function(_0xd30bf9){if(_0xd30bf9){if(!fs['existsSync'](path[_0x654a('0x54')](config[_0x654a('0x55')],_0x654a('0x56'),_0xd30bf9['savename']))){throw new db[(_0x654a('0x57'))]['ValidationError']('Report\x20not\x20found\x20or\x20empty');}if(_0x57111[_0x654a('0x33')]['exists']){return _0x56b341[_0x654a('0x1b')](0xc8);}return _0x56b341[_0x654a('0x51')](path['join'](config['root'],_0x654a('0x56'),_0xd30bf9[_0x654a('0x58')]),util['format']('%s.%s',_0xd30bf9['basename']||_0xd30bf9[_0x654a('0x2b')],_0xd30bf9[_0x654a('0x53')]['toLowerCase']()));}})[_0x654a('0x44')](handleError(_0x56b341,null));};