Built motion from commit (unavailable).|2.5.22
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.controller.js
index a47f600..216838d 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x9587=['order','sort','where','filter','merge','map','type','options','AnalyticExtractedReport','includeAll','findAll','rows','catch','params','include','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','download','basename','savename','join','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','root','server/files/reports','format','%s.%s','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','sendStatus','status','end','count','offset','limit','set','apply','save','update','then','get','ExtractedReports','UserProfileResource','destroy','error','stack','name','send','index','rawAttributes','key','query','keys','filters','intersection','attributes','model','fields','length','hasOwnProperty'];(function(_0x321bb2,_0x202794){var _0x9c12ed=function(_0x263dd3){while(--_0x263dd3){_0x321bb2['push'](_0x321bb2['shift']());}};_0x9c12ed(++_0x202794);}(_0x9587,0x7e));var _0x7958=function(_0x248afa,_0xc057df){_0x248afa=_0x248afa-0x0;var _0x26d2d2=_0x9587[_0x248afa];return _0x26d2d2;};'use strict';var pdf=require(_0x7958('0x0'));var emlformat=require(_0x7958('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x7958('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7958('0x3'));var moment=require(_0x7958('0x4'));var BPromise=require(_0x7958('0x5'));var Mustache=require(_0x7958('0x6'));var util=require(_0x7958('0x7'));var path=require('path');var sox=require(_0x7958('0x8'));var csv=require(_0x7958('0x9'));var ejs=require(_0x7958('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7958('0xb'));var crypto=require(_0x7958('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x7958('0xd'));var toCsv=require(_0x7958('0x9'));var querystring=require(_0x7958('0xe'));var Papa=require(_0x7958('0xf'));var Redis=require(_0x7958('0x10'));var authService=require(_0x7958('0x11'));var qs=require(_0x7958('0x12'));var as=require(_0x7958('0x13'));var hardwareService=require(_0x7958('0x14'));var logger=require(_0x7958('0x15'))(_0x7958('0x16'));var utils=require('../../config/utils');var config=require(_0x7958('0x17'));var licenseUtil=require(_0x7958('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4f6748,_0x3d2660){_0x3d2660=_0x3d2660||0xcc;return function(_0x25feea){if(_0x25feea){return _0x4f6748[_0x7958('0x19')](_0x3d2660);}return _0x4f6748[_0x7958('0x1a')](_0x3d2660)[_0x7958('0x1b')]();};}function respondWithResult(_0x40846c,_0xa4fe3b){_0xa4fe3b=_0xa4fe3b||0xc8;return function(_0x4bc7a3){if(_0x4bc7a3){return _0x40846c[_0x7958('0x1a')](_0xa4fe3b)['json'](_0x4bc7a3);}};}function respondWithFilteredResult(_0x53982f,_0x2260c1){return function(_0x5f33be){if(_0x5f33be){var _0x22eaa4=_0x5f33be[_0x7958('0x1c')],_0x4c621f=_0x2260c1[_0x7958('0x1d')],_0x39ffcc=_0x2260c1['offset']+_0x2260c1[_0x7958('0x1e')],_0x25f0de;if(_0x39ffcc>=_0x22eaa4){_0x39ffcc=_0x22eaa4;_0x25f0de=0xc8;}else{_0x25f0de=0xce;}_0x53982f[_0x7958('0x1a')](_0x25f0de);return _0x53982f[_0x7958('0x1f')]('Content-Range',_0x4c621f+'-'+_0x39ffcc+'/'+_0x22eaa4)['json'](_0x5f33be);}return null;};}function patchUpdates(_0x91fe9e){return function(_0x397e9e){try{jsonpatch[_0x7958('0x20')](_0x397e9e,_0x91fe9e,!![]);}catch(_0xee373f){return BPromise['reject'](_0xee373f);}return _0x397e9e[_0x7958('0x21')]();};}function saveUpdates(_0x80c1a8,_0x417b12){return function(_0x42e3d6){if(_0x42e3d6){return _0x42e3d6[_0x7958('0x22')](_0x80c1a8)[_0x7958('0x23')](function(_0x5d95e6){return _0x5d95e6;});}return null;};}function removeEntity(_0x2d3ac9,_0x3de786){return function(_0x323dc4){if(_0x323dc4){return _0x323dc4['destroy']()[_0x7958('0x23')](function(){var _0x346909=_0x323dc4[_0x7958('0x24')]({'plain':!![]});var _0xae2b71=_0x7958('0x25');return db[_0x7958('0x26')][_0x7958('0x27')]({'where':{'type':_0xae2b71,'resourceId':_0x346909['id']}})[_0x7958('0x23')](function(){return _0x323dc4;});})[_0x7958('0x23')](function(){_0x2d3ac9['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3383fd,_0x23d89e){return function(_0xa904fa){if(!_0xa904fa){_0x3383fd[_0x7958('0x19')](0x194);}return _0xa904fa;};}function handleError(_0x1780c0,_0x37c977){_0x37c977=_0x37c977||0x1f4;return function(_0x542244){logger[_0x7958('0x28')](_0x542244[_0x7958('0x29')]);if(_0x542244[_0x7958('0x2a')]){delete _0x542244[_0x7958('0x2a')];}_0x1780c0['status'](_0x37c977)[_0x7958('0x2b')](_0x542244);};}exports[_0x7958('0x2c')]=function(_0x411579,_0xd1fd1f){var _0x28706a={},_0x36cd3e={},_0x3d79da={'count':0x0,'rows':[]};var _0x19606e=_['map'](db['AnalyticExtractedReport'][_0x7958('0x2d')],function(_0x1c985a){return{'name':_0x1c985a['fieldName'],'type':_0x1c985a['type'][_0x7958('0x2e')]};});_0x36cd3e['model']=_['map'](_0x19606e,'name');_0x36cd3e[_0x7958('0x2f')]=_[_0x7958('0x30')](_0x411579['query']);_0x36cd3e[_0x7958('0x31')]=_[_0x7958('0x32')](_0x36cd3e['model'],_0x36cd3e[_0x7958('0x2f')]);_0x28706a[_0x7958('0x33')]=_[_0x7958('0x32')](_0x36cd3e[_0x7958('0x34')],qs[_0x7958('0x35')](_0x411579[_0x7958('0x2f')][_0x7958('0x35')]));_0x28706a[_0x7958('0x33')]=_0x28706a['attributes'][_0x7958('0x36')]?_0x28706a[_0x7958('0x33')]:_0x36cd3e['model'];if(!_0x411579[_0x7958('0x2f')][_0x7958('0x37')]('nolimit')){_0x28706a[_0x7958('0x1e')]=qs[_0x7958('0x1e')](_0x411579[_0x7958('0x2f')][_0x7958('0x1e')]);_0x28706a[_0x7958('0x1d')]=qs['offset'](_0x411579[_0x7958('0x2f')][_0x7958('0x1d')]);}_0x28706a[_0x7958('0x38')]=qs[_0x7958('0x39')](_0x411579[_0x7958('0x2f')][_0x7958('0x39')]);_0x28706a[_0x7958('0x3a')]=qs[_0x7958('0x31')](_['pick'](_0x411579['query'],_0x36cd3e['filters']),_0x19606e);if(_0x411579['query'][_0x7958('0x3b')]){_0x28706a[_0x7958('0x3a')]=_[_0x7958('0x3c')](_0x28706a[_0x7958('0x3a')],{'$or':_[_0x7958('0x3d')](_0x19606e,function(_0x1f8e5d){if(_0x1f8e5d[_0x7958('0x3e')]!=='VIRTUAL'){var _0x27c3d4={};_0x27c3d4[_0x1f8e5d[_0x7958('0x2a')]]={'$like':'%'+_0x411579[_0x7958('0x2f')][_0x7958('0x3b')]+'%'};return _0x27c3d4;}})});}_0x28706a=_[_0x7958('0x3c')]({},_0x28706a,_0x411579[_0x7958('0x3f')]);var _0x3f4c3d={'where':_0x28706a[_0x7958('0x3a')]};return db[_0x7958('0x40')][_0x7958('0x1c')](_0x3f4c3d)['then'](function(_0x2c6a17){_0x3d79da[_0x7958('0x1c')]=_0x2c6a17;if(_0x411579[_0x7958('0x2f')][_0x7958('0x41')]){_0x28706a['include']=[{'all':!![]}];}return db['AnalyticExtractedReport'][_0x7958('0x42')](_0x28706a);})[_0x7958('0x23')](function(_0x186907){_0x3d79da[_0x7958('0x43')]=_0x186907;return _0x3d79da;})[_0x7958('0x23')](respondWithFilteredResult(_0xd1fd1f,_0x28706a))[_0x7958('0x44')](handleError(_0xd1fd1f,null));};exports['show']=function(_0xe3dca4,_0x49b500){var _0x1207f9={'raw':!![],'where':{'id':_0xe3dca4[_0x7958('0x45')]['id']}},_0x3c3f14={};_0x3c3f14[_0x7958('0x34')]=_['keys'](db[_0x7958('0x40')][_0x7958('0x2d')]);_0x3c3f14[_0x7958('0x2f')]=_[_0x7958('0x30')](_0xe3dca4['query']);_0x3c3f14[_0x7958('0x31')]=_[_0x7958('0x32')](_0x3c3f14[_0x7958('0x34')],_0x3c3f14[_0x7958('0x2f')]);_0x1207f9[_0x7958('0x33')]=_[_0x7958('0x32')](_0x3c3f14[_0x7958('0x34')],qs[_0x7958('0x35')](_0xe3dca4[_0x7958('0x2f')]['fields']));_0x1207f9[_0x7958('0x33')]=_0x1207f9['attributes']['length']?_0x1207f9[_0x7958('0x33')]:_0x3c3f14[_0x7958('0x34')];if(_0xe3dca4[_0x7958('0x2f')][_0x7958('0x41')]){_0x1207f9[_0x7958('0x46')]=[{'all':!![]}];}_0x1207f9=_[_0x7958('0x3c')]({},_0x1207f9,_0xe3dca4[_0x7958('0x3f')]);return db[_0x7958('0x40')][_0x7958('0x47')](_0x1207f9)[_0x7958('0x23')](handleEntityNotFound(_0x49b500,null))[_0x7958('0x23')](respondWithResult(_0x49b500,null))['catch'](handleError(_0x49b500,null));};exports['create']=function(_0x331f3c,_0x1184a0){return db[_0x7958('0x40')][_0x7958('0x48')](_0x331f3c[_0x7958('0x49')],{})[_0x7958('0x23')](function(_0x14caba){var _0x5f3402=_0x331f3c[_0x7958('0x4a')][_0x7958('0x24')]({'plain':!![]});if(!_0x5f3402)throw new Error(_0x7958('0x4b'));if(_0x5f3402['role']===_0x7958('0x4a')){var _0x4697cc=_0x14caba[_0x7958('0x24')]({'plain':!![]});var _0x6594ce=_0x7958('0x25');return db[_0x7958('0x4c')][_0x7958('0x47')]({'where':{'name':_0x6594ce,'userProfileId':_0x5f3402[_0x7958('0x4d')]},'raw':!![]})[_0x7958('0x23')](function(_0x1a12b0){if(_0x1a12b0&&_0x1a12b0[_0x7958('0x4e')]===0x0){return db[_0x7958('0x26')][_0x7958('0x48')]({'name':_0x4697cc[_0x7958('0x2a')],'resourceId':_0x4697cc['id'],'type':_0x1a12b0[_0x7958('0x2a')],'sectionId':_0x1a12b0['id']},{})[_0x7958('0x23')](function(){return _0x14caba;});}else{return _0x14caba;}})[_0x7958('0x44')](function(_0x293bdd){logger[_0x7958('0x28')](_0x7958('0x4f'),_0x293bdd);throw _0x293bdd;});}return _0x14caba;})[_0x7958('0x23')](respondWithResult(_0x1184a0,0xc9))['catch'](handleError(_0x1184a0,null));};exports[_0x7958('0x22')]=function(_0x2c6fc5,_0x394270){if(_0x2c6fc5['body']['id']){delete _0x2c6fc5[_0x7958('0x49')]['id'];}return db['AnalyticExtractedReport'][_0x7958('0x47')]({'where':{'id':_0x2c6fc5[_0x7958('0x45')]['id']}})[_0x7958('0x23')](handleEntityNotFound(_0x394270,null))[_0x7958('0x23')](saveUpdates(_0x2c6fc5[_0x7958('0x49')],null))['then'](respondWithResult(_0x394270,null))[_0x7958('0x44')](handleError(_0x394270,null));};exports[_0x7958('0x27')]=function(_0x2af08f,_0x477a3e){return db['AnalyticExtractedReport']['find']({'where':{'id':_0x2af08f['params']['id']}})[_0x7958('0x23')](handleEntityNotFound(_0x477a3e,null))[_0x7958('0x23')](removeEntity(_0x477a3e,null))[_0x7958('0x44')](handleError(_0x477a3e,null));};exports[_0x7958('0x50')]=function(_0x270dca,_0x539a28,_0x2659e9){return db[_0x7958('0x40')]['find']({'where':{'id':_0x270dca['params']['id']},'attributes':[_0x7958('0x2a'),_0x7958('0x51'),_0x7958('0x52'),'output'],'raw':!![]})['then'](handleEntityNotFound(_0x539a28,null))[_0x7958('0x23')](function(_0x3baa7b){if(_0x3baa7b){if(!fs['existsSync'](path[_0x7958('0x53')](config['root'],'server/files/reports',_0x3baa7b[_0x7958('0x52')]))){throw new db[(_0x7958('0x54'))][(_0x7958('0x55'))](_0x7958('0x56'));}if(_0x270dca[_0x7958('0x2f')]['exists']){return _0x539a28[_0x7958('0x19')](0xc8);}return _0x539a28[_0x7958('0x50')](path['join'](config[_0x7958('0x57')],_0x7958('0x58'),_0x3baa7b[_0x7958('0x52')]),util[_0x7958('0x59')](_0x7958('0x5a'),_0x3baa7b[_0x7958('0x51')]||_0x3baa7b['name'],_0x3baa7b['output']['toLowerCase']()));}})[_0x7958('0x44')](handleError(_0x539a28,null));};
\ No newline at end of file
+var _0xd8d3=['fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filter','VIRTUAL','merge','options','AnalyticExtractedReport','count','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','basename','savename','existsSync','server/files/reports','Sequelize','ValidationError','Report\x20not\x20found\x20or\x20empty','join','root','format','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','end','offset','set','Content-Range','json','apply','reject','save','update','then','destroy','get','UserProfileResource','error','stack','name','index','map','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes'];(function(_0x1fc9f6,_0x487b57){var _0x4afd0b=function(_0x3dc2cf){while(--_0x3dc2cf){_0x1fc9f6['push'](_0x1fc9f6['shift']());}};_0x4afd0b(++_0x487b57);}(_0xd8d3,0x1a0));var _0x3d8d=function(_0x5373b3,_0x4d6d32){_0x5373b3=_0x5373b3-0x0;var _0x574895=_0xd8d3[_0x5373b3];return _0x574895;};'use strict';var pdf=require(_0x3d8d('0x0'));var emlformat=require(_0x3d8d('0x1'));var rimraf=require(_0x3d8d('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x3d8d('0x3'));var rp=require(_0x3d8d('0x4'));var moment=require('moment');var BPromise=require(_0x3d8d('0x5'));var Mustache=require(_0x3d8d('0x6'));var util=require(_0x3d8d('0x7'));var path=require(_0x3d8d('0x8'));var sox=require(_0x3d8d('0x9'));var csv=require(_0x3d8d('0xa'));var ejs=require(_0x3d8d('0xb'));var fs=require('fs');var _=require(_0x3d8d('0xc'));var squel=require('squel');var crypto=require(_0x3d8d('0xd'));var jsforce=require(_0x3d8d('0xe'));var deskjs=require(_0x3d8d('0xf'));var toCsv=require(_0x3d8d('0xa'));var querystring=require(_0x3d8d('0x10'));var Papa=require('papaparse');var Redis=require(_0x3d8d('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x3d8d('0x12'));var as=require(_0x3d8d('0x13'));var hardwareService=require(_0x3d8d('0x14'));var logger=require(_0x3d8d('0x15'))(_0x3d8d('0x16'));var utils=require(_0x3d8d('0x17'));var config=require(_0x3d8d('0x18'));var licenseUtil=require(_0x3d8d('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x279ad3,_0x42bee6){_0x42bee6=_0x42bee6||0xcc;return function(_0x3162af){if(_0x3162af){return _0x279ad3['sendStatus'](_0x42bee6);}return _0x279ad3[_0x3d8d('0x1a')](_0x42bee6)[_0x3d8d('0x1b')]();};}function respondWithResult(_0x59f6ae,_0x30de70){_0x30de70=_0x30de70||0xc8;return function(_0x408aad){if(_0x408aad){return _0x59f6ae[_0x3d8d('0x1a')](_0x30de70)['json'](_0x408aad);}};}function respondWithFilteredResult(_0x3cb59b,_0xb83623){return function(_0x46808a){if(_0x46808a){var _0x4ddcbc=_0x46808a['count'],_0x3590fa=_0xb83623[_0x3d8d('0x1c')],_0x19d3c0=_0xb83623['offset']+_0xb83623['limit'],_0x5b616a;if(_0x19d3c0>=_0x4ddcbc){_0x19d3c0=_0x4ddcbc;_0x5b616a=0xc8;}else{_0x5b616a=0xce;}_0x3cb59b[_0x3d8d('0x1a')](_0x5b616a);return _0x3cb59b[_0x3d8d('0x1d')](_0x3d8d('0x1e'),_0x3590fa+'-'+_0x19d3c0+'/'+_0x4ddcbc)[_0x3d8d('0x1f')](_0x46808a);}return null;};}function patchUpdates(_0x5b786e){return function(_0xda8bc){try{jsonpatch[_0x3d8d('0x20')](_0xda8bc,_0x5b786e,!![]);}catch(_0x4586a5){return BPromise[_0x3d8d('0x21')](_0x4586a5);}return _0xda8bc[_0x3d8d('0x22')]();};}function saveUpdates(_0x55ca48,_0x458cbb){return function(_0x2580c6){if(_0x2580c6){return _0x2580c6[_0x3d8d('0x23')](_0x55ca48)[_0x3d8d('0x24')](function(_0x570702){return _0x570702;});}return null;};}function removeEntity(_0x1d2d56,_0x321b6e){return function(_0x132dfe){if(_0x132dfe){return _0x132dfe[_0x3d8d('0x25')]()['then'](function(){var _0x889cd1=_0x132dfe[_0x3d8d('0x26')]({'plain':!![]});var _0x4b3eac='ExtractedReports';return db[_0x3d8d('0x27')][_0x3d8d('0x25')]({'where':{'type':_0x4b3eac,'resourceId':_0x889cd1['id']}})[_0x3d8d('0x24')](function(){return _0x132dfe;});})[_0x3d8d('0x24')](function(){_0x1d2d56['status'](0xcc)[_0x3d8d('0x1b')]();});}};}function handleEntityNotFound(_0x43a25c,_0x191aa5){return function(_0x453b81){if(!_0x453b81){_0x43a25c['sendStatus'](0x194);}return _0x453b81;};}function handleError(_0x3020ec,_0x53841a){_0x53841a=_0x53841a||0x1f4;return function(_0x421077){logger[_0x3d8d('0x28')](_0x421077[_0x3d8d('0x29')]);if(_0x421077[_0x3d8d('0x2a')]){delete _0x421077[_0x3d8d('0x2a')];}_0x3020ec['status'](_0x53841a)['send'](_0x421077);};}exports[_0x3d8d('0x2b')]=function(_0x1cf8c3,_0x6b303c){var _0x39fd84={},_0x9e394b={},_0xc2bd08={'count':0x0,'rows':[]};var _0x52fd77=_[_0x3d8d('0x2c')](db['AnalyticExtractedReport'][_0x3d8d('0x2d')],function(_0x542e95){return{'name':_0x542e95[_0x3d8d('0x2e')],'type':_0x542e95[_0x3d8d('0x2f')][_0x3d8d('0x30')]};});_0x9e394b[_0x3d8d('0x31')]=_[_0x3d8d('0x2c')](_0x52fd77,_0x3d8d('0x2a'));_0x9e394b[_0x3d8d('0x32')]=_['keys'](_0x1cf8c3[_0x3d8d('0x32')]);_0x9e394b[_0x3d8d('0x33')]=_[_0x3d8d('0x34')](_0x9e394b[_0x3d8d('0x31')],_0x9e394b[_0x3d8d('0x32')]);_0x39fd84[_0x3d8d('0x35')]=_[_0x3d8d('0x34')](_0x9e394b['model'],qs[_0x3d8d('0x36')](_0x1cf8c3[_0x3d8d('0x32')]['fields']));_0x39fd84[_0x3d8d('0x35')]=_0x39fd84[_0x3d8d('0x35')][_0x3d8d('0x37')]?_0x39fd84[_0x3d8d('0x35')]:_0x9e394b[_0x3d8d('0x31')];if(!_0x1cf8c3[_0x3d8d('0x32')][_0x3d8d('0x38')](_0x3d8d('0x39'))){_0x39fd84[_0x3d8d('0x3a')]=qs['limit'](_0x1cf8c3['query'][_0x3d8d('0x3a')]);_0x39fd84[_0x3d8d('0x1c')]=qs['offset'](_0x1cf8c3[_0x3d8d('0x32')][_0x3d8d('0x1c')]);}_0x39fd84[_0x3d8d('0x3b')]=qs[_0x3d8d('0x3c')](_0x1cf8c3[_0x3d8d('0x32')]['sort']);_0x39fd84[_0x3d8d('0x3d')]=qs[_0x3d8d('0x33')](_['pick'](_0x1cf8c3['query'],_0x9e394b[_0x3d8d('0x33')]),_0x52fd77);if(_0x1cf8c3['query'][_0x3d8d('0x3e')]){_0x39fd84['where']=_['merge'](_0x39fd84[_0x3d8d('0x3d')],{'$or':_['map'](_0x52fd77,function(_0x1b473c){if(_0x1b473c[_0x3d8d('0x2f')]!==_0x3d8d('0x3f')){var _0x3ddb95={};_0x3ddb95[_0x1b473c[_0x3d8d('0x2a')]]={'$like':'%'+_0x1cf8c3[_0x3d8d('0x32')]['filter']+'%'};return _0x3ddb95;}})});}_0x39fd84=_[_0x3d8d('0x40')]({},_0x39fd84,_0x1cf8c3[_0x3d8d('0x41')]);var _0x5e68d0={'where':_0x39fd84['where']};return db[_0x3d8d('0x42')]['count'](_0x5e68d0)[_0x3d8d('0x24')](function(_0x269c9c){_0xc2bd08[_0x3d8d('0x43')]=_0x269c9c;if(_0x1cf8c3[_0x3d8d('0x32')][_0x3d8d('0x44')]){_0x39fd84[_0x3d8d('0x45')]=[{'all':!![]}];}return db[_0x3d8d('0x42')][_0x3d8d('0x46')](_0x39fd84);})[_0x3d8d('0x24')](function(_0x2955bb){_0xc2bd08[_0x3d8d('0x47')]=_0x2955bb;return _0xc2bd08;})[_0x3d8d('0x24')](respondWithFilteredResult(_0x6b303c,_0x39fd84))[_0x3d8d('0x48')](handleError(_0x6b303c,null));};exports[_0x3d8d('0x49')]=function(_0x4b210e,_0x10128e){var _0x88655a={'raw':!![],'where':{'id':_0x4b210e[_0x3d8d('0x4a')]['id']}},_0x477f31={};_0x477f31[_0x3d8d('0x31')]=_[_0x3d8d('0x4b')](db[_0x3d8d('0x42')][_0x3d8d('0x2d')]);_0x477f31[_0x3d8d('0x32')]=_[_0x3d8d('0x4b')](_0x4b210e[_0x3d8d('0x32')]);_0x477f31[_0x3d8d('0x33')]=_[_0x3d8d('0x34')](_0x477f31[_0x3d8d('0x31')],_0x477f31[_0x3d8d('0x32')]);_0x88655a[_0x3d8d('0x35')]=_[_0x3d8d('0x34')](_0x477f31['model'],qs['fields'](_0x4b210e[_0x3d8d('0x32')][_0x3d8d('0x36')]));_0x88655a['attributes']=_0x88655a[_0x3d8d('0x35')]['length']?_0x88655a[_0x3d8d('0x35')]:_0x477f31[_0x3d8d('0x31')];if(_0x4b210e[_0x3d8d('0x32')][_0x3d8d('0x44')]){_0x88655a[_0x3d8d('0x45')]=[{'all':!![]}];}_0x88655a=_[_0x3d8d('0x40')]({},_0x88655a,_0x4b210e[_0x3d8d('0x41')]);return db['AnalyticExtractedReport'][_0x3d8d('0x4c')](_0x88655a)[_0x3d8d('0x24')](handleEntityNotFound(_0x10128e,null))[_0x3d8d('0x24')](respondWithResult(_0x10128e,null))['catch'](handleError(_0x10128e,null));};exports[_0x3d8d('0x4d')]=function(_0x1887b5,_0x939f4f){return db['AnalyticExtractedReport'][_0x3d8d('0x4d')](_0x1887b5[_0x3d8d('0x4e')],{})[_0x3d8d('0x24')](function(_0x37678a){var _0x14a57c=_0x1887b5[_0x3d8d('0x4f')][_0x3d8d('0x26')]({'plain':!![]});if(!_0x14a57c)throw new Error(_0x3d8d('0x50'));if(_0x14a57c['role']===_0x3d8d('0x4f')){var _0x10f3ed=_0x37678a[_0x3d8d('0x26')]({'plain':!![]});var _0x51a799='ExtractedReports';return db[_0x3d8d('0x51')]['find']({'where':{'name':_0x51a799,'userProfileId':_0x14a57c['userProfileId']},'raw':!![]})[_0x3d8d('0x24')](function(_0x590ded){if(_0x590ded&&_0x590ded[_0x3d8d('0x52')]===0x0){return db[_0x3d8d('0x27')]['create']({'name':_0x10f3ed['name'],'resourceId':_0x10f3ed['id'],'type':_0x590ded[_0x3d8d('0x2a')],'sectionId':_0x590ded['id']},{})[_0x3d8d('0x24')](function(){return _0x37678a;});}else{return _0x37678a;}})['catch'](function(_0x15f301){logger['error'](_0x3d8d('0x53'),_0x15f301);throw _0x15f301;});}return _0x37678a;})[_0x3d8d('0x24')](respondWithResult(_0x939f4f,0xc9))[_0x3d8d('0x48')](handleError(_0x939f4f,null));};exports[_0x3d8d('0x23')]=function(_0x1dbb61,_0x1b3f37){if(_0x1dbb61[_0x3d8d('0x4e')]['id']){delete _0x1dbb61[_0x3d8d('0x4e')]['id'];}return db[_0x3d8d('0x42')]['find']({'where':{'id':_0x1dbb61[_0x3d8d('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1b3f37,null))['then'](saveUpdates(_0x1dbb61[_0x3d8d('0x4e')],null))[_0x3d8d('0x24')](respondWithResult(_0x1b3f37,null))[_0x3d8d('0x48')](handleError(_0x1b3f37,null));};exports[_0x3d8d('0x25')]=function(_0x3b2666,_0xcb0147){return db[_0x3d8d('0x42')][_0x3d8d('0x4c')]({'where':{'id':_0x3b2666['params']['id']}})[_0x3d8d('0x24')](handleEntityNotFound(_0xcb0147,null))[_0x3d8d('0x24')](removeEntity(_0xcb0147,null))[_0x3d8d('0x48')](handleError(_0xcb0147,null));};exports['download']=function(_0x501252,_0x2a3d09,_0x59b295){return db[_0x3d8d('0x42')][_0x3d8d('0x4c')]({'where':{'id':_0x501252[_0x3d8d('0x4a')]['id']},'attributes':[_0x3d8d('0x2a'),_0x3d8d('0x54'),_0x3d8d('0x55'),'output'],'raw':!![]})[_0x3d8d('0x24')](handleEntityNotFound(_0x2a3d09,null))[_0x3d8d('0x24')](function(_0x549c3c){if(_0x549c3c){if(!fs[_0x3d8d('0x56')](path['join'](config['root'],_0x3d8d('0x57'),_0x549c3c[_0x3d8d('0x55')]))){throw new db[(_0x3d8d('0x58'))][(_0x3d8d('0x59'))](_0x3d8d('0x5a'));}if(_0x501252[_0x3d8d('0x32')]['exists']){return _0x2a3d09['sendStatus'](0xc8);}return _0x2a3d09['download'](path[_0x3d8d('0x5b')](config[_0x3d8d('0x5c')],_0x3d8d('0x57'),_0x549c3c[_0x3d8d('0x55')]),util[_0x3d8d('0x5d')]('%s.%s',_0x549c3c[_0x3d8d('0x54')]||_0x549c3c[_0x3d8d('0x2a')],_0x549c3c['output']['toLowerCase']()));}})[_0x3d8d('0x48')](handleError(_0x2a3d09,null));};
\ No newline at end of file