Built motion from commit 97153652.|2.6.26
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.controller.js
index 8d092b0..37824b1 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-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));};
\ No newline at end of file
+var _0x0cd2=['get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','body','download','basename','savename','output','existsSync','server/files/reports','Sequelize','Report\x20not\x20found\x20or\x20empty','exists','root','format','%s.%s','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','ejs','squel','crypto','desk.js','to-csv','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','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','ExtractedReports','UserProfileResource','destroy','error','stack','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','show','params','keys','catch','create','user'];(function(_0xdbd0c8,_0x35da4c){var _0x2f23cf=function(_0x352ecb){while(--_0x352ecb){_0xdbd0c8['push'](_0xdbd0c8['shift']());}};_0x2f23cf(++_0x35da4c);}(_0x0cd2,0x78));var _0x20cd=function(_0x3959fc,_0x32b4f8){_0x3959fc=_0x3959fc-0x0;var _0x4e438e=_0x0cd2[_0x3959fc];return _0x4e438e;};'use strict';var emlformat=require(_0x20cd('0x0'));var rimraf=require(_0x20cd('0x1'));var zipdir=require(_0x20cd('0x2'));var jsonpatch=require(_0x20cd('0x3'));var rp=require(_0x20cd('0x4'));var moment=require(_0x20cd('0x5'));var BPromise=require(_0x20cd('0x6'));var Mustache=require(_0x20cd('0x7'));var util=require('util');var path=require(_0x20cd('0x8'));var sox=require(_0x20cd('0x9'));var csv=require('to-csv');var ejs=require(_0x20cd('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x20cd('0xb'));var crypto=require(_0x20cd('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x20cd('0xd'));var toCsv=require(_0x20cd('0xe'));var querystring=require(_0x20cd('0xf'));var Papa=require(_0x20cd('0x10'));var Redis=require(_0x20cd('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x20cd('0x12'));var as=require(_0x20cd('0x13'));var hardwareService=require(_0x20cd('0x14'));var logger=require(_0x20cd('0x15'))('api');var utils=require(_0x20cd('0x16'));var config=require(_0x20cd('0x17'));var licenseUtil=require(_0x20cd('0x18'));var db=require(_0x20cd('0x19'))['db'];function respondWithStatusCode(_0x236aaa,_0x4e05c1){_0x4e05c1=_0x4e05c1||0xcc;return function(_0x54793d){if(_0x54793d){return _0x236aaa[_0x20cd('0x1a')](_0x4e05c1);}return _0x236aaa[_0x20cd('0x1b')](_0x4e05c1)[_0x20cd('0x1c')]();};}function respondWithResult(_0x4a9c61,_0x648885){_0x648885=_0x648885||0xc8;return function(_0x4017c3){if(_0x4017c3){return _0x4a9c61[_0x20cd('0x1b')](_0x648885)[_0x20cd('0x1d')](_0x4017c3);}};}function respondWithFilteredResult(_0x5eecb8,_0x2eac98){return function(_0x35016d){if(_0x35016d){var _0x3269af=typeof _0x2eac98[_0x20cd('0x1e')]===_0x20cd('0x1f')&&typeof _0x2eac98[_0x20cd('0x20')]===_0x20cd('0x1f');var _0x2bdabf=_0x35016d[_0x20cd('0x21')];var _0x87aafa=_0x3269af?0x0:_0x2eac98[_0x20cd('0x1e')];var _0x50666e=_0x3269af?_0x35016d[_0x20cd('0x21')]:_0x2eac98[_0x20cd('0x1e')]+_0x2eac98[_0x20cd('0x20')];var _0x14d4f1;if(_0x50666e>=_0x2bdabf){_0x50666e=_0x2bdabf;_0x14d4f1=0xc8;}else{_0x14d4f1=0xce;}_0x5eecb8[_0x20cd('0x1b')](_0x14d4f1);return _0x5eecb8[_0x20cd('0x22')](_0x20cd('0x23'),_0x87aafa+'-'+_0x50666e+'/'+_0x2bdabf)[_0x20cd('0x1d')](_0x35016d);}return null;};}function patchUpdates(_0xafa0b7){return function(_0x4db5f4){try{jsonpatch[_0x20cd('0x24')](_0x4db5f4,_0xafa0b7,!![]);}catch(_0x521218){return BPromise['reject'](_0x521218);}return _0x4db5f4[_0x20cd('0x25')]();};}function saveUpdates(_0x27238d,_0x5511a4){return function(_0x3328f5){if(_0x3328f5){return _0x3328f5[_0x20cd('0x26')](_0x27238d)[_0x20cd('0x27')](function(_0x587e53){return _0x587e53;});}return null;};}function removeEntity(_0x2f5a89,_0x5e0a22){return function(_0x1d6e1){if(_0x1d6e1){return _0x1d6e1['destroy']()[_0x20cd('0x27')](function(){var _0x4cdeed=_0x1d6e1['get']({'plain':!![]});var _0x3672c6=_0x20cd('0x28');return db[_0x20cd('0x29')][_0x20cd('0x2a')]({'where':{'type':_0x3672c6,'resourceId':_0x4cdeed['id']}})['then'](function(){return _0x1d6e1;});})[_0x20cd('0x27')](function(){_0x2f5a89[_0x20cd('0x1b')](0xcc)[_0x20cd('0x1c')]();});}};}function handleEntityNotFound(_0x5397fa,_0x48b83f){return function(_0x4d097f){if(!_0x4d097f){_0x5397fa[_0x20cd('0x1a')](0x194);}return _0x4d097f;};}function handleError(_0x50a5d3,_0x17220d){_0x17220d=_0x17220d||0x1f4;return function(_0x40b41f){logger[_0x20cd('0x2b')](_0x40b41f[_0x20cd('0x2c')]);if(_0x40b41f[_0x20cd('0x2d')]){delete _0x40b41f['name'];}_0x50a5d3[_0x20cd('0x1b')](_0x17220d)[_0x20cd('0x2e')](_0x40b41f);};}exports[_0x20cd('0x2f')]=function(_0x559521,_0xf66613){var _0x2fa96d={},_0x112bec={},_0x20fa63={'count':0x0,'rows':[]};var _0x3f552c=_[_0x20cd('0x30')](db[_0x20cd('0x31')][_0x20cd('0x32')],function(_0x4498d9){return{'name':_0x4498d9[_0x20cd('0x33')],'type':_0x4498d9[_0x20cd('0x34')][_0x20cd('0x35')]};});_0x112bec[_0x20cd('0x36')]=_[_0x20cd('0x30')](_0x3f552c,_0x20cd('0x2d'));_0x112bec['query']=_['keys'](_0x559521[_0x20cd('0x37')]);_0x112bec[_0x20cd('0x38')]=_[_0x20cd('0x39')](_0x112bec[_0x20cd('0x36')],_0x112bec['query']);_0x2fa96d[_0x20cd('0x3a')]=_[_0x20cd('0x39')](_0x112bec[_0x20cd('0x36')],qs[_0x20cd('0x3b')](_0x559521[_0x20cd('0x37')][_0x20cd('0x3b')]));_0x2fa96d['attributes']=_0x2fa96d[_0x20cd('0x3a')][_0x20cd('0x3c')]?_0x2fa96d[_0x20cd('0x3a')]:_0x112bec[_0x20cd('0x36')];if(!_0x559521[_0x20cd('0x37')][_0x20cd('0x3d')](_0x20cd('0x3e'))){_0x2fa96d[_0x20cd('0x20')]=qs[_0x20cd('0x20')](_0x559521[_0x20cd('0x37')]['limit']);_0x2fa96d[_0x20cd('0x1e')]=qs[_0x20cd('0x1e')](_0x559521[_0x20cd('0x37')][_0x20cd('0x1e')]);}_0x2fa96d[_0x20cd('0x3f')]=qs[_0x20cd('0x40')](_0x559521['query'][_0x20cd('0x40')]);_0x2fa96d[_0x20cd('0x41')]=qs[_0x20cd('0x38')](_[_0x20cd('0x42')](_0x559521[_0x20cd('0x37')],_0x112bec[_0x20cd('0x38')]),_0x3f552c);if(_0x559521[_0x20cd('0x37')][_0x20cd('0x43')]){_0x2fa96d[_0x20cd('0x41')]=_[_0x20cd('0x44')](_0x2fa96d[_0x20cd('0x41')],{'$or':_[_0x20cd('0x30')](_0x3f552c,function(_0x1de35e){if(_0x1de35e[_0x20cd('0x34')]!==_0x20cd('0x45')){var _0x4019b2={};_0x4019b2[_0x1de35e[_0x20cd('0x2d')]]={'$like':'%'+_0x559521[_0x20cd('0x37')][_0x20cd('0x43')]+'%'};return _0x4019b2;}})});}_0x2fa96d=_[_0x20cd('0x44')]({},_0x2fa96d,_0x559521['options']);var _0x144260={'where':_0x2fa96d[_0x20cd('0x41')]};return db[_0x20cd('0x31')][_0x20cd('0x21')](_0x144260)[_0x20cd('0x27')](function(_0x13ac3b){_0x20fa63[_0x20cd('0x21')]=_0x13ac3b;if(_0x559521[_0x20cd('0x37')][_0x20cd('0x46')]){_0x2fa96d[_0x20cd('0x47')]=[{'all':!![]}];}return db['AnalyticExtractedReport']['findAll'](_0x2fa96d);})[_0x20cd('0x27')](function(_0x2a8a90){_0x20fa63['rows']=_0x2a8a90;return _0x20fa63;})[_0x20cd('0x27')](respondWithFilteredResult(_0xf66613,_0x2fa96d))['catch'](handleError(_0xf66613,null));};exports[_0x20cd('0x48')]=function(_0x14a9d5,_0x2b91d8){var _0x4371a9={'raw':!![],'where':{'id':_0x14a9d5[_0x20cd('0x49')]['id']}},_0x44bf52={};_0x44bf52[_0x20cd('0x36')]=_[_0x20cd('0x4a')](db[_0x20cd('0x31')]['rawAttributes']);_0x44bf52['query']=_[_0x20cd('0x4a')](_0x14a9d5['query']);_0x44bf52[_0x20cd('0x38')]=_[_0x20cd('0x39')](_0x44bf52[_0x20cd('0x36')],_0x44bf52[_0x20cd('0x37')]);_0x4371a9['attributes']=_[_0x20cd('0x39')](_0x44bf52[_0x20cd('0x36')],qs['fields'](_0x14a9d5[_0x20cd('0x37')][_0x20cd('0x3b')]));_0x4371a9[_0x20cd('0x3a')]=_0x4371a9['attributes'][_0x20cd('0x3c')]?_0x4371a9[_0x20cd('0x3a')]:_0x44bf52[_0x20cd('0x36')];if(_0x14a9d5[_0x20cd('0x37')][_0x20cd('0x46')]){_0x4371a9['include']=[{'all':!![]}];}_0x4371a9=_[_0x20cd('0x44')]({},_0x4371a9,_0x14a9d5['options']);return db[_0x20cd('0x31')]['find'](_0x4371a9)['then'](handleEntityNotFound(_0x2b91d8,null))[_0x20cd('0x27')](respondWithResult(_0x2b91d8,null))[_0x20cd('0x4b')](handleError(_0x2b91d8,null));};exports['create']=function(_0x28eaeb,_0x4ffb22){return db[_0x20cd('0x31')][_0x20cd('0x4c')](_0x28eaeb['body'],{})[_0x20cd('0x27')](function(_0x4e934c){var _0x63830a=_0x28eaeb[_0x20cd('0x4d')][_0x20cd('0x4e')]({'plain':!![]});if(!_0x63830a)throw new Error(_0x20cd('0x4f'));if(_0x63830a[_0x20cd('0x50')]===_0x20cd('0x4d')){var _0xe35381=_0x4e934c['get']({'plain':!![]});var _0x7ad8cb=_0x20cd('0x28');return db[_0x20cd('0x51')][_0x20cd('0x52')]({'where':{'name':_0x7ad8cb,'userProfileId':_0x63830a[_0x20cd('0x53')]},'raw':!![]})[_0x20cd('0x27')](function(_0x46e44c){if(_0x46e44c&&_0x46e44c[_0x20cd('0x54')]===0x0){return db[_0x20cd('0x29')][_0x20cd('0x4c')]({'name':_0xe35381['name'],'resourceId':_0xe35381['id'],'type':_0x46e44c[_0x20cd('0x2d')],'sectionId':_0x46e44c['id']},{})[_0x20cd('0x27')](function(){return _0x4e934c;});}else{return _0x4e934c;}})[_0x20cd('0x4b')](function(_0x34df8d){logger[_0x20cd('0x2b')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x34df8d);throw _0x34df8d;});}return _0x4e934c;})['then'](respondWithResult(_0x4ffb22,0xc9))[_0x20cd('0x4b')](handleError(_0x4ffb22,null));};exports['update']=function(_0x57fa01,_0x46964f){if(_0x57fa01[_0x20cd('0x55')]['id']){delete _0x57fa01['body']['id'];}return db[_0x20cd('0x31')][_0x20cd('0x52')]({'where':{'id':_0x57fa01[_0x20cd('0x49')]['id']}})[_0x20cd('0x27')](handleEntityNotFound(_0x46964f,null))[_0x20cd('0x27')](saveUpdates(_0x57fa01[_0x20cd('0x55')],null))[_0x20cd('0x27')](respondWithResult(_0x46964f,null))['catch'](handleError(_0x46964f,null));};exports[_0x20cd('0x2a')]=function(_0x1eacf9,_0x245073){return db[_0x20cd('0x31')]['find']({'where':{'id':_0x1eacf9['params']['id']}})['then'](handleEntityNotFound(_0x245073,null))['then'](removeEntity(_0x245073,null))[_0x20cd('0x4b')](handleError(_0x245073,null));};exports[_0x20cd('0x56')]=function(_0x424bd9,_0x2b1288,_0x1c3dbb){return db[_0x20cd('0x31')][_0x20cd('0x52')]({'where':{'id':_0x424bd9['params']['id']},'attributes':['name',_0x20cd('0x57'),_0x20cd('0x58'),_0x20cd('0x59')],'raw':!![]})[_0x20cd('0x27')](handleEntityNotFound(_0x2b1288,null))['then'](function(_0x3b8f62){if(_0x3b8f62){if(!fs[_0x20cd('0x5a')](path['join'](config['root'],_0x20cd('0x5b'),_0x3b8f62[_0x20cd('0x58')]))){throw new db[(_0x20cd('0x5c'))]['ValidationError'](_0x20cd('0x5d'));}if(_0x424bd9[_0x20cd('0x37')][_0x20cd('0x5e')]){return _0x2b1288['sendStatus'](0xc8);}return _0x2b1288['download'](path['join'](config[_0x20cd('0x5f')],_0x20cd('0x5b'),_0x3b8f62[_0x20cd('0x58')]),util[_0x20cd('0x60')](_0x20cd('0x61'),_0x3b8f62[_0x20cd('0x57')]||_0x3b8f62[_0x20cd('0x2d')],_0x3b8f62[_0x20cd('0x59')][_0x20cd('0x62')]()));}})[_0x20cd('0x4b')](handleError(_0x2b1288,null));};
\ No newline at end of file