// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe5ed=['../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','dbH','sendStatus','status','offset','limit','set','Content-Range','json','apply','reject','save','update','then','get','DefaultReports','end','error','stack','name','index','map','AnalyticDefaultReport','rawAttributes','key','model','query','keys','filters','intersection','fields','attributes','length','order','sort','filter','where','merge','type','VIRTUAL','options','includeAll','findAll','rows','show','include','catch','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','Reports','UserProfileSection','find','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','destroy','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','ROUND(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','table','MetricId','metric','function','format','replace','groupBy','orderBy','DESC','alias','joins','parse','foreignTable','foreignKey','%s.%s\x20=\x20%s.%s','parentKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SELECT','MIN(%s)','getFields','keyBy','web','fullPath','%s-%s.%s','generate','output','csv','default','AnalyticExtractedReport','startDate','endDate','Run\x20Query:','fork','../../components/export/','../../files/reports','from','countTable','COUNT(*)','count','run','runReport','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch'];(function(_0x1cc1f4,_0x1aecb8){var _0x16efd2=function(_0x50c4c4){while(--_0x50c4c4){_0x1cc1f4['push'](_0x1cc1f4['shift']());}};_0x16efd2(++_0x1aecb8);}(_0xe5ed,0x134));var _0xde5e=function(_0x38c3cd,_0x1e14dd){_0x38c3cd=_0x38c3cd-0x0;var _0x2afec4=_0xe5ed[_0x38c3cd];return _0x2afec4;};'use strict';var pdf=require(_0xde5e('0x0'));var emlformat=require(_0xde5e('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xde5e('0x2'));var jsonpatch=require(_0xde5e('0x3'));var rp=require(_0xde5e('0x4'));var moment=require(_0xde5e('0x5'));var BPromise=require(_0xde5e('0x6'));var Mustache=require('mustache');var util=require(_0xde5e('0x7'));var path=require(_0xde5e('0x8'));var sox=require(_0xde5e('0x9'));var csv=require(_0xde5e('0xa'));var ejs=require(_0xde5e('0xb'));var fs=require('fs');var _=require(_0xde5e('0xc'));var squel=require(_0xde5e('0xd'));var crypto=require(_0xde5e('0xe'));var jsforce=require(_0xde5e('0xf'));var deskjs=require('desk.js');var toCsv=require(_0xde5e('0xa'));var querystring=require('querystring');var Papa=require(_0xde5e('0x10'));var Redis=require(_0xde5e('0x11'));var authService=require(_0xde5e('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0xde5e('0x13'));var hardwareService=require(_0xde5e('0x14'));var logger=require(_0xde5e('0x15'))(_0xde5e('0x16'));var utils=require('../../config/utils');var config=require(_0xde5e('0x17'));var db=require(_0xde5e('0x18'))['db'];var dbH=require('../../mysqldb')[_0xde5e('0x19')];function respondWithStatusCode(_0x1ac059,_0x4c1983){_0x4c1983=_0x4c1983||0xcc;return function(_0x21172b){if(_0x21172b){return _0x1ac059[_0xde5e('0x1a')](_0x4c1983);}return _0x1ac059[_0xde5e('0x1b')](_0x4c1983)['end']();};}function respondWithResult(_0x189290,_0x2b61d6){_0x2b61d6=_0x2b61d6||0xc8;return function(_0x4da468){if(_0x4da468){return _0x189290[_0xde5e('0x1b')](_0x2b61d6)['json'](_0x4da468);}};}function respondWithFilteredResult(_0x5a9ba6,_0x461bea){return function(_0x57d32e){if(_0x57d32e){var _0x3e7af4=_0x57d32e['count'],_0x373a08=_0x461bea[_0xde5e('0x1c')],_0x539bc4=_0x461bea[_0xde5e('0x1c')]+_0x461bea[_0xde5e('0x1d')],_0x22c5bf;if(_0x539bc4>=_0x3e7af4){_0x539bc4=_0x3e7af4;_0x22c5bf=0xc8;}else{_0x22c5bf=0xce;}_0x5a9ba6[_0xde5e('0x1b')](_0x22c5bf);return _0x5a9ba6[_0xde5e('0x1e')](_0xde5e('0x1f'),_0x373a08+'-'+_0x539bc4+'/'+_0x3e7af4)[_0xde5e('0x20')](_0x57d32e);}return null;};}function patchUpdates(_0x539b03){return function(_0x3b6fbf){try{jsonpatch[_0xde5e('0x21')](_0x3b6fbf,_0x539b03,!![]);}catch(_0x533546){return BPromise[_0xde5e('0x22')](_0x533546);}return _0x3b6fbf[_0xde5e('0x23')]();};}function saveUpdates(_0xe46dbd,_0x195761){return function(_0x7495f8){if(_0x7495f8){return _0x7495f8[_0xde5e('0x24')](_0xe46dbd)[_0xde5e('0x25')](function(_0x59e51e){return _0x59e51e;});}return null;};}function removeEntity(_0x56a86c,_0x11c962){return function(_0x3fe3e7){if(_0x3fe3e7){return _0x3fe3e7['destroy']()['then'](function(){var _0x2b4024=_0x3fe3e7[_0xde5e('0x26')]({'plain':!![]});var _0x44e273=_0xde5e('0x27');return db['UserProfileResource']['destroy']({'where':{'type':_0x44e273,'resourceId':_0x2b4024['id']}})[_0xde5e('0x25')](function(){return _0x3fe3e7;});})[_0xde5e('0x25')](function(){_0x56a86c[_0xde5e('0x1b')](0xcc)[_0xde5e('0x28')]();});}};}function handleEntityNotFound(_0x3c9cc9,_0x5a5212){return function(_0x482afe){if(!_0x482afe){_0x3c9cc9[_0xde5e('0x1a')](0x194);}return _0x482afe;};}function handleError(_0x1358f5,_0x59d9dc){_0x59d9dc=_0x59d9dc||0x1f4;return function(_0x2d75a0){logger[_0xde5e('0x29')](_0x2d75a0[_0xde5e('0x2a')]);if(_0x2d75a0['name']){delete _0x2d75a0[_0xde5e('0x2b')];}_0x1358f5['status'](_0x59d9dc)['send'](_0x2d75a0);};}exports[_0xde5e('0x2c')]=function(_0x2543fe,_0x5c395f){var _0x1e0a6a={},_0x1bb24b={},_0x4137c0={'count':0x0,'rows':[]};var _0x15ac8b=_[_0xde5e('0x2d')](db[_0xde5e('0x2e')][_0xde5e('0x2f')],function(_0x5b3b01){return{'name':_0x5b3b01['fieldName'],'type':_0x5b3b01['type'][_0xde5e('0x30')]};});_0x1bb24b[_0xde5e('0x31')]=_[_0xde5e('0x2d')](_0x15ac8b,_0xde5e('0x2b'));_0x1bb24b[_0xde5e('0x32')]=_[_0xde5e('0x33')](_0x2543fe[_0xde5e('0x32')]);_0x1bb24b[_0xde5e('0x34')]=_['intersection'](_0x1bb24b['model'],_0x1bb24b[_0xde5e('0x32')]);_0x1e0a6a['attributes']=_[_0xde5e('0x35')](_0x1bb24b[_0xde5e('0x31')],qs['fields'](_0x2543fe[_0xde5e('0x32')][_0xde5e('0x36')]));_0x1e0a6a[_0xde5e('0x37')]=_0x1e0a6a[_0xde5e('0x37')][_0xde5e('0x38')]?_0x1e0a6a['attributes']:_0x1bb24b[_0xde5e('0x31')];if(!_0x2543fe[_0xde5e('0x32')]['hasOwnProperty']('nolimit')){_0x1e0a6a[_0xde5e('0x1d')]=qs[_0xde5e('0x1d')](_0x2543fe['query'][_0xde5e('0x1d')]);_0x1e0a6a[_0xde5e('0x1c')]=qs['offset'](_0x2543fe['query']['offset']);}_0x1e0a6a[_0xde5e('0x39')]=qs[_0xde5e('0x3a')](_0x2543fe['query'][_0xde5e('0x3a')]);_0x1e0a6a['where']=qs[_0xde5e('0x34')](_['pick'](_0x2543fe[_0xde5e('0x32')],_0x1bb24b[_0xde5e('0x34')]),_0x15ac8b);if(_0x2543fe[_0xde5e('0x32')][_0xde5e('0x3b')]){_0x1e0a6a[_0xde5e('0x3c')]=_[_0xde5e('0x3d')](_0x1e0a6a[_0xde5e('0x3c')],{'$or':_[_0xde5e('0x2d')](_0x15ac8b,function(_0x49fcbb){if(_0x49fcbb[_0xde5e('0x3e')]!==_0xde5e('0x3f')){var _0x212676={};_0x212676[_0x49fcbb[_0xde5e('0x2b')]]={'$like':'%'+_0x2543fe[_0xde5e('0x32')][_0xde5e('0x3b')]+'%'};return _0x212676;}})});}_0x1e0a6a=_['merge']({},_0x1e0a6a,_0x2543fe[_0xde5e('0x40')]);var _0x46e208={'where':_0x1e0a6a[_0xde5e('0x3c')]};return db['AnalyticDefaultReport']['count'](_0x46e208)[_0xde5e('0x25')](function(_0x7a3b84){_0x4137c0['count']=_0x7a3b84;if(_0x2543fe[_0xde5e('0x32')][_0xde5e('0x41')]){_0x1e0a6a['include']=[{'all':!![]}];}return db[_0xde5e('0x2e')][_0xde5e('0x42')](_0x1e0a6a);})[_0xde5e('0x25')](function(_0x2f9363){_0x4137c0[_0xde5e('0x43')]=_0x2f9363;return _0x4137c0;})['then'](respondWithFilteredResult(_0x5c395f,_0x1e0a6a))['catch'](handleError(_0x5c395f,null));};exports[_0xde5e('0x44')]=function(_0x16bc4f,_0x38f3e5){var _0x5bc0c2={'raw':!![],'where':{'id':_0x16bc4f['params']['id']}},_0x206fe0={};_0x206fe0[_0xde5e('0x31')]=_[_0xde5e('0x33')](db[_0xde5e('0x2e')][_0xde5e('0x2f')]);_0x206fe0['query']=_[_0xde5e('0x33')](_0x16bc4f[_0xde5e('0x32')]);_0x206fe0[_0xde5e('0x34')]=_[_0xde5e('0x35')](_0x206fe0[_0xde5e('0x31')],_0x206fe0[_0xde5e('0x32')]);_0x5bc0c2[_0xde5e('0x37')]=_[_0xde5e('0x35')](_0x206fe0[_0xde5e('0x31')],qs[_0xde5e('0x36')](_0x16bc4f[_0xde5e('0x32')][_0xde5e('0x36')]));_0x5bc0c2[_0xde5e('0x37')]=_0x5bc0c2[_0xde5e('0x37')][_0xde5e('0x38')]?_0x5bc0c2['attributes']:_0x206fe0[_0xde5e('0x31')];if(_0x16bc4f[_0xde5e('0x32')][_0xde5e('0x41')]){_0x5bc0c2[_0xde5e('0x45')]=[{'all':!![]}];}_0x5bc0c2=_[_0xde5e('0x3d')]({},_0x5bc0c2,_0x16bc4f[_0xde5e('0x40')]);return db[_0xde5e('0x2e')]['find'](_0x5bc0c2)[_0xde5e('0x25')](handleEntityNotFound(_0x38f3e5,null))[_0xde5e('0x25')](respondWithResult(_0x38f3e5,null))[_0xde5e('0x46')](handleError(_0x38f3e5,null));};exports[_0xde5e('0x47')]=function(_0x45de89,_0x111246){return db[_0xde5e('0x2e')][_0xde5e('0x47')](_0x45de89['body'],{})[_0xde5e('0x25')](function(_0x8de5ed){var _0x3b5943=_0x45de89['user']['get']({'plain':!![]});if(!_0x3b5943)throw new Error(_0xde5e('0x48'));if(_0x3b5943['role']===_0xde5e('0x49')){var _0x5f3a84=_0x8de5ed[_0xde5e('0x26')]({'plain':!![]});var _0x80d5b1=_0xde5e('0x4a');return db[_0xde5e('0x4b')][_0xde5e('0x4c')]({'where':{'name':_0x80d5b1,'userProfileId':_0x3b5943[_0xde5e('0x4d')]},'raw':!![]})[_0xde5e('0x25')](function(_0x31d310){if(_0x31d310&&_0x31d310[_0xde5e('0x4e')]===0x0){return db[_0xde5e('0x4f')][_0xde5e('0x47')]({'name':_0x5f3a84['name'],'resourceId':_0x5f3a84['id'],'type':_0xde5e('0x27'),'sectionId':_0x31d310['id']},{})[_0xde5e('0x25')](function(){return _0x8de5ed;});}else{return _0x8de5ed;}})[_0xde5e('0x46')](function(_0x1fc2df){logger['error'](_0xde5e('0x50'),_0x1fc2df);throw _0x1fc2df;});}return _0x8de5ed;})['then'](respondWithResult(_0x111246,0xc9))[_0xde5e('0x46')](handleError(_0x111246,null));};exports[_0xde5e('0x24')]=function(_0x5d64da,_0x56e60c){if(_0x5d64da[_0xde5e('0x51')]['id']){delete _0x5d64da['body']['id'];}return db[_0xde5e('0x2e')][_0xde5e('0x4c')]({'where':{'id':_0x5d64da[_0xde5e('0x52')]['id']}})[_0xde5e('0x25')](handleEntityNotFound(_0x56e60c,null))[_0xde5e('0x25')](saveUpdates(_0x5d64da['body'],null))[_0xde5e('0x25')](respondWithResult(_0x56e60c,null))[_0xde5e('0x46')](handleError(_0x56e60c,null));};exports[_0xde5e('0x53')]=function(_0xfef2b8,_0x155417){return db[_0xde5e('0x2e')][_0xde5e('0x4c')]({'where':{'id':_0xfef2b8['params']['id']}})[_0xde5e('0x25')](handleEntityNotFound(_0x155417,null))[_0xde5e('0x25')](removeEntity(_0x155417,null))[_0xde5e('0x46')](handleError(_0x155417,null));};exports[_0xde5e('0x54')]=function(_0x3241cb,_0x168820){var _0x11cd6f=0xa;var _0x50e0ad=[_0xde5e('0x55'),_0xde5e('0x56'),_0xde5e('0x57'),_0xde5e('0x58')];var _0x13a313={'SUM':_0xde5e('0x59'),'COUNT':_0xde5e('0x5a'),'COUNT DISTINCT':_0xde5e('0x5b'),'MAX':_0xde5e('0x5c'),'MIN':'MIN(%s)','AVG':_0xde5e('0x5d'),'GROUP_CONCAT':_0xde5e('0x5e'),'GROUP_CONCAT ASC':_0xde5e('0x5f'),'GROUP_CONCAT DESC':_0xde5e('0x60')};var _0x3464b8={'SEC_TO_TIME':_0xde5e('0x61'),'DATE':_0xde5e('0x62'),'HOUR':_0xde5e('0x63'),'ROUND':_0xde5e('0x64'),'UNIX_TIMESTAMP':_0xde5e('0x65')};var _0x2ca0e7=function(_0x1a691f){return!_['includes']([_0xde5e('0x66'),_0xde5e('0x67'),_0xde5e('0x68'),_0xde5e('0x69')],_0x1a691f);};var _0x59f888=function(_0x5cc11f){if(!_0x5cc11f||!_0x5cc11f[_0xde5e('0x6a')][_0xde5e('0x38')]){return'';}for(var _0xac5ed5='(',_0xc847ec=0x0;_0xc847ec<_0x5cc11f[_0xde5e('0x6a')][_0xde5e('0x38')];_0xc847ec+=0x1){_0xc847ec>0x0&&(_0xac5ed5+='\x20'+_0x5cc11f[_0xde5e('0x6b')]+'\x20');_0xac5ed5+=_0x5cc11f[_0xde5e('0x6a')][_0xc847ec][_0xde5e('0x6c')]?_0x59f888(_0x5cc11f[_0xde5e('0x6a')][_0xc847ec][_0xde5e('0x6c')]):_0x5cc11f[_0xde5e('0x6a')][_0xc847ec][_0xde5e('0x6d')]+'\x20'+_0x5cc11f[_0xde5e('0x6a')][_0xc847ec][_0xde5e('0x6e')]+(_0x2ca0e7(_0x5cc11f[_0xde5e('0x6a')][_0xc847ec][_0xde5e('0x6e')])?'\x20'+_0x5cc11f['rules'][_0xc847ec][_0xde5e('0x6f')]:'');}return _0xac5ed5+')';};var _0x5095b3={'where':{'id':_0x3241cb['params']['id']}},_0x525cde,_0x50c07e,_0x48c8c0,_0x5cead0,_0x4f6a3c;_0x5095b3=_['merge']({},_0x5095b3,_0x3241cb[_0xde5e('0x40')]);return db['AnalyticDefaultReport']['find'](_0x5095b3)['then'](function(_0x3761c5){if(_0x3761c5){_0x525cde=_0x3761c5;return _0x3761c5['getFields']();}return null;})[_0xde5e('0x25')](function(_0x3e7f2e){if(_0x3e7f2e){if(!_0x3e7f2e[_0xde5e('0x38')]){throw new db[(_0xde5e('0x70'))][(_0xde5e('0x71'))](_0xde5e('0x72'),0x193);}_0x50c07e=_0x3e7f2e;return db[_0xde5e('0x73')][_0xde5e('0x42')]({'raw':!![]});}return null;})[_0xde5e('0x25')](function(_0x541dfa){if(_0x541dfa){_0x48c8c0=_['keyBy'](_0x541dfa,'id');var _0x576329;var _0x4de16c=squel[_0xde5e('0x74')]();_0x4de16c['from'](_0x525cde[_0xde5e('0x75')]);for(var _0x23ebc8=0x0;_0x23ebc8<_0x50c07e[_0xde5e('0x38')];_0x23ebc8+=0x1){_0x576329=_0x50c07e[_0x23ebc8][_0xde5e('0x76')]?_0x48c8c0[_0x50c07e[_0x23ebc8]['MetricId']][_0xde5e('0x77')]:_0x50c07e[_0x23ebc8][_0xde5e('0x6d')];_0x576329=_0x50c07e[_0x23ebc8]['function']?_['replace'](_0x13a313[_0x50c07e[_0x23ebc8][_0xde5e('0x78')]],'%s',_0x576329):_0x576329;_0x576329=_0x50c07e[_0x23ebc8][_0xde5e('0x79')]?_[_0xde5e('0x7a')](_0x3464b8[_0x50c07e[_0x23ebc8][_0xde5e('0x79')]],'%s',_0x576329):_0x576329;if(_0x50c07e[_0x23ebc8][_0xde5e('0x7b')]){_0x4de16c['group'](_0x576329);}_0x50c07e[_0x23ebc8][_0xde5e('0x7c')]&&_0x4de16c[_0xde5e('0x39')](_0x576329,_0x50c07e[_0x23ebc8]['orderBy']===_0xde5e('0x7d')?![]:!![]);_0x4de16c[_0xde5e('0x6d')](_0x576329,_0x50c07e[_0x23ebc8][_0xde5e('0x7e')]||_0x576329);}if(_0x525cde[_0xde5e('0x7f')]){_0x525cde[_0xde5e('0x7f')]=JSON[_0xde5e('0x80')](_0x525cde[_0xde5e('0x7f')]);for(var _0x1fe7a7=0x0;_0x1fe7a7<_0x525cde[_0xde5e('0x7f')]['length'];_0x1fe7a7+=0x1){if(_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['type']&&_['includes'](_0x50e0ad,_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['type'])&&_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['parentKey']&&_0x525cde[_0xde5e('0x7f')][_0x1fe7a7][_0xde5e('0x81')]&&_0x525cde[_0xde5e('0x7f')][_0x1fe7a7][_0xde5e('0x82')]){_0x4de16c[_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['type']](_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['foreignTable'],null,util[_0xde5e('0x79')](_0xde5e('0x83'),_0x525cde[_0xde5e('0x75')],_0x525cde[_0xde5e('0x7f')][_0x1fe7a7][_0xde5e('0x84')],_0x525cde[_0xde5e('0x7f')][_0x1fe7a7]['foreignTable'],_0x525cde[_0xde5e('0x7f')][_0x1fe7a7][_0xde5e('0x82')]));}}}if(_0x525cde[_0xde5e('0x85')]){_0x525cde['conditions']=JSON[_0xde5e('0x80')](_0x525cde[_0xde5e('0x85')]);_0x4de16c[_0xde5e('0x3c')](_0x59f888(_0x525cde[_0xde5e('0x85')][_0xde5e('0x6c')]));}_0x4f6a3c=_0x4de16c[_0xde5e('0x86')]();_0x4de16c[_0xde5e('0x1d')](_0x11cd6f);_0x4de16c[_0xde5e('0x1c')](0x0);logger[_0xde5e('0x87')](_0xde5e('0x88'),_0x4de16c[_0xde5e('0x89')]());return db[_0xde5e('0x8a')][_0xde5e('0x32')](_0x4de16c[_0xde5e('0x89')](),{'type':db[_0xde5e('0x8a')][_0xde5e('0x8b')][_0xde5e('0x8c')]});}})[_0xde5e('0x25')](respondWithResult(_0x168820,null))[_0xde5e('0x46')](handleError(_0x168820,null));};function runReport(_0x5c7365,_0x25306e,_0x2e28c7){var _0x1a00d3=_0x25306e[_0xde5e('0x2b')];var _0x486586=0xa;var _0xe875bd=[_0xde5e('0x55'),_0xde5e('0x56'),_0xde5e('0x57'),_0xde5e('0x58')];var _0x8c3520={'SUM':_0xde5e('0x59'),'COUNT':_0xde5e('0x5a'),'COUNT DISTINCT':_0xde5e('0x5b'),'MAX':'MAX(%s)','MIN':_0xde5e('0x8d'),'AVG':_0xde5e('0x5d'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0xc288bc={'SEC_TO_TIME':_0xde5e('0x61'),'DATE':_0xde5e('0x62'),'HOUR':'HOUR(%s)','ROUND':_0xde5e('0x64'),'UNIX_TIMESTAMP':_0xde5e('0x65')};var _0x17c99e=function(_0x669dda){return!_['includes'](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0xde5e('0x69')],_0x669dda);};var _0x594a4f=function(_0x5bd2da){if(!_0x5bd2da||!_0x5bd2da[_0xde5e('0x6a')][_0xde5e('0x38')]){return'';}for(var _0x2552e8='(',_0x311d92=0x0;_0x311d92<_0x5bd2da[_0xde5e('0x6a')][_0xde5e('0x38')];_0x311d92+=0x1){_0x311d92>0x0&&(_0x2552e8+='\x20'+_0x5bd2da[_0xde5e('0x6b')]+'\x20');_0x2552e8+=_0x5bd2da[_0xde5e('0x6a')][_0x311d92]['group']?_0x594a4f(_0x5bd2da[_0xde5e('0x6a')][_0x311d92][_0xde5e('0x6c')]):_0x5bd2da[_0xde5e('0x6a')][_0x311d92][_0xde5e('0x6d')]+'\x20'+_0x5bd2da[_0xde5e('0x6a')][_0x311d92][_0xde5e('0x6e')]+(_0x17c99e(_0x5bd2da[_0xde5e('0x6a')][_0x311d92][_0xde5e('0x6e')])?'\x20'+_0x5bd2da[_0xde5e('0x6a')][_0x311d92][_0xde5e('0x6f')]:'');}return _0x2552e8+')';};var _0x8cc6dd={'where':{'id':_0x5c7365['id']}},_0x48e5c1,_0x22d871,_0x5e8bf4,_0xb2f246,_0x31d0b5;_0x8cc6dd=_[_0xde5e('0x3d')]({},_0x8cc6dd,_0x2e28c7);return db['AnalyticDefaultReport'][_0xde5e('0x4c')](_0x8cc6dd)[_0xde5e('0x25')](function(_0x996903){if(_0x996903){_0x48e5c1=_0x996903;return _0x996903[_0xde5e('0x8e')]();}return null;})['then'](function(_0x3a876f){if(_0x3a876f){if(!_0x3a876f[_0xde5e('0x38')]){throw new db[(_0xde5e('0x70'))]['ValidationErrorItem'](_0xde5e('0x72'),0x193);}_0x22d871=_0x3a876f;return db['AnalyticMetric'][_0xde5e('0x42')]({'raw':!![]});}return null;})[_0xde5e('0x25')](function(_0x4f6697){if(_0x4f6697){_0x5e8bf4=_[_0xde5e('0x8f')](_0x4f6697,'id');var _0x389e86;var _0x66b37a=squel[_0xde5e('0x74')]();_0x66b37a['from'](_0x48e5c1['table']);for(var _0x388045=0x0;_0x388045<_0x22d871[_0xde5e('0x38')];_0x388045+=0x1){_0x389e86=_0x22d871[_0x388045][_0xde5e('0x76')]?_0x5e8bf4[_0x22d871[_0x388045][_0xde5e('0x76')]]['metric']:_0x22d871[_0x388045][_0xde5e('0x6d')];_0x389e86=_0x22d871[_0x388045]['function']?_['replace'](_0x8c3520[_0x22d871[_0x388045][_0xde5e('0x78')]],'%s',_0x389e86):_0x389e86;_0x389e86=_0x22d871[_0x388045][_0xde5e('0x79')]?_[_0xde5e('0x7a')](_0xc288bc[_0x22d871[_0x388045][_0xde5e('0x79')]],'%s',_0x389e86):_0x389e86;if(_0x22d871[_0x388045][_0xde5e('0x7b')]){_0x66b37a['group'](_0x389e86);}_0x22d871[_0x388045][_0xde5e('0x7c')]&&_0x66b37a[_0xde5e('0x39')](_0x389e86,_0x22d871[_0x388045][_0xde5e('0x7c')]==='DESC'?![]:!![]);_0x66b37a['field'](_0x389e86,_0x22d871[_0x388045][_0xde5e('0x7e')]||_0x389e86);}if(_0x48e5c1[_0xde5e('0x7f')]){_0x48e5c1[_0xde5e('0x7f')]=JSON[_0xde5e('0x80')](_0x48e5c1['joins']);for(var _0x2028b6=0x0;_0x2028b6<_0x48e5c1[_0xde5e('0x7f')]['length'];_0x2028b6+=0x1){if(_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x3e')]&&_['includes'](_0xe875bd,_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x3e')])&&_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x84')]&&_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x81')]&&_0x48e5c1['joins'][_0x2028b6][_0xde5e('0x82')]){_0x66b37a[_0x48e5c1[_0xde5e('0x7f')][_0x2028b6]['type']](_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x81')],null,util[_0xde5e('0x79')](_0xde5e('0x83'),_0x48e5c1[_0xde5e('0x75')],_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x84')],_0x48e5c1[_0xde5e('0x7f')][_0x2028b6][_0xde5e('0x81')],_0x48e5c1['joins'][_0x2028b6][_0xde5e('0x82')]));}}}if(_0x48e5c1[_0xde5e('0x85')]){_0x48e5c1[_0xde5e('0x85')]=JSON[_0xde5e('0x80')](_0x48e5c1[_0xde5e('0x85')]);_0x66b37a[_0xde5e('0x3c')](_0x594a4f(_0x48e5c1['conditions']['group']));}_0x31d0b5=_0x66b37a[_0xde5e('0x86')]();_0x66b37a[_0xde5e('0x1d')](_0x486586);_0x66b37a['offset'](0x0);logger[_0xde5e('0x87')](_0xde5e('0x88'),_0x66b37a[_0xde5e('0x89')]());return db['sequelize']['query'](_0x66b37a[_0xde5e('0x89')](),{'type':db[_0xde5e('0x8a')][_0xde5e('0x8b')][_0xde5e('0x8c')]});}})[_0xde5e('0x25')](function(_0x464dbe){if(!_0x464dbe[_0xde5e('0x38')]){throw new db[(_0xde5e('0x70'))][(_0xde5e('0x71'))]('No\x20available\x20data',0xcc);}if(_0x25306e['output']===_0xde5e('0x90')){return null;}var _0x3745ac=_[_0xde5e('0x3d')](_0x25306e,{'name':_0x25306e[_0xde5e('0x91')]||_0x25306e['name']||_0x48e5c1[_0xde5e('0x2b')],'basename':_0x1a00d3,'savename':util[_0xde5e('0x79')](_0xde5e('0x92'),_0x25306e['name']||_0x48e5c1['name'],require('randomstring')[_0xde5e('0x93')](0x4),_0x25306e[_0xde5e('0x94')]||_0xde5e('0x95')),'reportId':_0x48e5c1['id'],'reportType':_0xde5e('0x96')});return db[_0xde5e('0x97')][_0xde5e('0x47')](_0x3745ac,{'raw':!![]});})['then'](function(_0x378916){if(_0x48e5c1[_0xde5e('0x75')]==='cdr'){_0x31d0b5['where'](_0x48e5c1['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x25306e[_0xde5e('0x98')],_0x25306e[_0xde5e('0x99')]);}else{_0x31d0b5[_0xde5e('0x3c')](_0x48e5c1[_0xde5e('0x75')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x25306e[_0xde5e('0x98')],_0x25306e[_0xde5e('0x99')]);}if(_0x378916){logger['info'](_0xde5e('0x9a'),_0x31d0b5[_0xde5e('0x89')]());require('child_process')[_0xde5e('0x9b')](path[_0xde5e('0x55')](__dirname,_0xde5e('0x9c'),_0x378916[_0xde5e('0x94')]),[_0x378916['id'],_0x31d0b5[_0xde5e('0x89')](),path[_0xde5e('0x55')](__dirname,_0xde5e('0x9d'),_0x378916['savename']),_0x1a00d3]);return _0x378916;}else{var _0x1aeef5=squel[_0xde5e('0x74')]();_0x1aeef5[_0xde5e('0x9e')]('('+_0x31d0b5['toString']()+')',_0xde5e('0x9f'));_0x1aeef5['field'](_0xde5e('0xa0'),'count');_0x31d0b5['limit'](_0x25306e[_0xde5e('0x1d')]||_0x486586);_0x31d0b5['offset'](_0x25306e[_0xde5e('0x1c')]||0x0);return dbH['sequelize'][_0xde5e('0x32')](_0x1aeef5[_0xde5e('0x89')](),{'type':dbH[_0xde5e('0x8a')][_0xde5e('0x8b')][_0xde5e('0x8c')]})['then'](function(_0x46de48){if(!_0x46de48[_0xde5e('0x38')]){_0xb2f246=0x0;}else{_0xb2f246=_0x46de48[0x0][_0xde5e('0xa1')]||0x0;}return dbH['sequelize'][_0xde5e('0x32')](_0x31d0b5[_0xde5e('0x89')](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});})[_0xde5e('0x25')](function(_0x204bb5){return{'rows':_0x204bb5||[],'count':_0xb2f246};});}});}exports[_0xde5e('0xa2')]=function(_0x5878fd,_0x5ecf63){return runReport(_0x5878fd[_0xde5e('0x52')],_0x5878fd[_0xde5e('0x32')],_0x5878fd['options'])['then'](respondWithResult(_0x5ecf63,null))[_0xde5e('0x46')](handleError(_0x5ecf63,null));};exports[_0xde5e('0xa3')]=runReport;exports[_0xde5e('0x32')]=function(_0x49fa06,_0x55a599){var _0x1664c5=0xa;var _0x11fa98=['join',_0xde5e('0x56'),_0xde5e('0x57'),_0xde5e('0x58')];var _0x35e8fa={'SUM':_0xde5e('0x59'),'COUNT':_0xde5e('0x5a'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0xde5e('0x5c'),'MIN':_0xde5e('0x8d'),'AVG':_0xde5e('0x5d'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0xde5e('0x60')};var _0x32f718={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0xde5e('0x63'),'ROUND':_0xde5e('0x64'),'UNIX_TIMESTAMP':_0xde5e('0x65')};var _0x536657=function(_0x2888ca){return!_['includes']([_0xde5e('0x66'),_0xde5e('0x67'),'IS\x20EMPTY',_0xde5e('0x69')],_0x2888ca);};var _0x599c26=function(_0x3d5d0a){if(!_0x3d5d0a||!_0x3d5d0a['rules'][_0xde5e('0x38')]){return'';}for(var _0x1044b3='(',_0x4b5865=0x0;_0x4b5865<_0x3d5d0a[_0xde5e('0x6a')]['length'];_0x4b5865+=0x1){_0x4b5865>0x0&&(_0x1044b3+='\x20'+_0x3d5d0a[_0xde5e('0x6b')]+'\x20');_0x1044b3+=_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865][_0xde5e('0x6c')]?_0x599c26(_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865][_0xde5e('0x6c')]):_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865][_0xde5e('0x6d')]+'\x20'+_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865][_0xde5e('0x6e')]+(_0x536657(_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865]['condition'])?'\x20'+_0x3d5d0a[_0xde5e('0x6a')][_0x4b5865]['value']:'');}return _0x1044b3+')';};var _0x45cc53={'where':{'id':_0x49fa06[_0xde5e('0x52')]['id']}},_0x557d0f,_0x2135e3,_0x402af7,_0x279cc3,_0x5cd87c;_0x45cc53=_[_0xde5e('0x3d')]({},_0x45cc53,_0x49fa06[_0xde5e('0x40')]);return db['AnalyticDefaultReport']['find'](_0x45cc53)[_0xde5e('0x25')](function(_0xf424db){if(_0xf424db){_0x557d0f=_0xf424db;return _0xf424db[_0xde5e('0x8e')]();}return null;})[_0xde5e('0x25')](function(_0x27d6ca){if(_0x27d6ca){if(!_0x27d6ca[_0xde5e('0x38')]){throw new db[(_0xde5e('0x70'))][(_0xde5e('0x71'))](_0xde5e('0x72'),0x193);}_0x2135e3=_0x27d6ca;return db[_0xde5e('0x73')][_0xde5e('0x42')]({'raw':!![]});}return null;})[_0xde5e('0x25')](function(_0x412e32){if(_0x412e32){_0x402af7=_['keyBy'](_0x412e32,'id');var _0x2f4ab0;var _0x1c7a80=squel['select']();_0x1c7a80[_0xde5e('0x9e')](_0x557d0f[_0xde5e('0x75')]);for(var _0x56b66b=0x0;_0x56b66b<_0x2135e3[_0xde5e('0x38')];_0x56b66b+=0x1){_0x2f4ab0=_0x2135e3[_0x56b66b][_0xde5e('0x76')]?_0x402af7[_0x2135e3[_0x56b66b]['MetricId']]['metric']:_0x2135e3[_0x56b66b][_0xde5e('0x6d')];_0x2f4ab0=_0x2135e3[_0x56b66b][_0xde5e('0x78')]?_[_0xde5e('0x7a')](_0x35e8fa[_0x2135e3[_0x56b66b]['function']],'%s',_0x2f4ab0):_0x2f4ab0;_0x2f4ab0=_0x2135e3[_0x56b66b][_0xde5e('0x79')]?_[_0xde5e('0x7a')](_0x32f718[_0x2135e3[_0x56b66b][_0xde5e('0x79')]],'%s',_0x2f4ab0):_0x2f4ab0;if(_0x2135e3[_0x56b66b][_0xde5e('0x7b')]){_0x1c7a80[_0xde5e('0x6c')](_0x2f4ab0);}_0x2135e3[_0x56b66b][_0xde5e('0x7c')]&&_0x1c7a80[_0xde5e('0x39')](_0x2f4ab0,_0x2135e3[_0x56b66b][_0xde5e('0x7c')]===_0xde5e('0x7d')?![]:!![]);_0x1c7a80[_0xde5e('0x6d')](_0x2f4ab0,_0x2135e3[_0x56b66b][_0xde5e('0x7e')]||_0x2f4ab0);}if(_0x557d0f[_0xde5e('0x7f')]){_0x557d0f[_0xde5e('0x7f')]=JSON[_0xde5e('0x80')](_0x557d0f[_0xde5e('0x7f')]);for(var _0x3399ec=0x0;_0x3399ec<_0x557d0f[_0xde5e('0x7f')][_0xde5e('0x38')];_0x3399ec+=0x1){if(_0x557d0f[_0xde5e('0x7f')][_0x3399ec]['type']&&_['includes'](_0x11fa98,_0x557d0f[_0xde5e('0x7f')][_0x3399ec][_0xde5e('0x3e')])&&_0x557d0f['joins'][_0x3399ec][_0xde5e('0x84')]&&_0x557d0f[_0xde5e('0x7f')][_0x3399ec]['foreignTable']&&_0x557d0f[_0xde5e('0x7f')][_0x3399ec][_0xde5e('0x82')]){_0x1c7a80[_0x557d0f[_0xde5e('0x7f')][_0x3399ec][_0xde5e('0x3e')]](_0x557d0f[_0xde5e('0x7f')][_0x3399ec]['foreignTable'],null,util[_0xde5e('0x79')]('%s.%s\x20=\x20%s.%s',_0x557d0f[_0xde5e('0x75')],_0x557d0f[_0xde5e('0x7f')][_0x3399ec][_0xde5e('0x84')],_0x557d0f[_0xde5e('0x7f')][_0x3399ec][_0xde5e('0x81')],_0x557d0f['joins'][_0x3399ec][_0xde5e('0x82')]));}}}if(_0x557d0f[_0xde5e('0x85')]){_0x557d0f['conditions']=JSON[_0xde5e('0x80')](_0x557d0f['conditions']);_0x1c7a80[_0xde5e('0x3c')](_0x599c26(_0x557d0f[_0xde5e('0x85')][_0xde5e('0x6c')]));}_0x5cd87c=_0x1c7a80[_0xde5e('0x86')]();_0x1c7a80[_0xde5e('0x1d')](_0x1664c5);_0x1c7a80[_0xde5e('0x1c')](0x0);logger[_0xde5e('0x87')](_0xde5e('0x88'),_0x1c7a80[_0xde5e('0x89')]());return db[_0xde5e('0x8a')][_0xde5e('0x32')](_0x1c7a80[_0xde5e('0x89')](),{'type':db[_0xde5e('0x8a')]['QueryTypes'][_0xde5e('0x8c')]});}})[_0xde5e('0x25')](function(){return{'sql':_0x5cd87c[_0xde5e('0x89')]()};})[_0xde5e('0x25')](respondWithResult(_0x55a599,null))['catch'](handleError(_0x55a599,null));};
\ No newline at end of file
+var _0x705a=['fullPath','randomstring','output','csv','.calldate\x20BETWEEN\x20?\x20AND\x20?','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','startDate','info','Run\x20Query:','fork','../../components/export/','../../files/reports','savename','countTable','QueryTypes','runReport','left_join','MAX(%s)','ROUND(%s)','html-pdf','eml-format','zip-dir','request-promise','bluebird','mustache','lodash','crypto','jsforce','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../mysqldb','dbH','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','get','DefaultReports','UserProfileResource','destroy','sendStatus','stack','name','send','index','AnalyticDefaultReport','rawAttributes','fieldName','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','type','VIRTUAL','includeAll','show','params','include','options','find','create','user','Reports','UserProfileSection','userProfileId','autoAssociation','catch','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','right_join','cross_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','field','condition','value','Sequelize','ValidationErrorItem','AnalyticMetric','findAll','keyBy','select','from','table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','join','HOUR(%s)','getFields','Please\x20insert\x20at\x20least\x20one\x20field','web'];(function(_0x39f211,_0x3b551b){var _0x1c1f5c=function(_0x14278c){while(--_0x14278c){_0x39f211['push'](_0x39f211['shift']());}};_0x1c1f5c(++_0x3b551b);}(_0x705a,0xb1));var _0xa705=function(_0x941099,_0x47fb57){_0x941099=_0x941099-0x0;var _0x1b6ad6=_0x705a[_0x941099];return _0x1b6ad6;};'use strict';var pdf=require(_0xa705('0x0'));var emlformat=require(_0xa705('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xa705('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xa705('0x3'));var moment=require('moment');var BPromise=require(_0xa705('0x4'));var Mustache=require(_0xa705('0x5'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0xa705('0x6'));var squel=require('squel');var crypto=require(_0xa705('0x7'));var jsforce=require(_0xa705('0x8'));var deskjs=require('desk.js');var toCsv=require(_0xa705('0x9'));var querystring=require(_0xa705('0xa'));var Papa=require('papaparse');var Redis=require(_0xa705('0xb'));var authService=require(_0xa705('0xc'));var qs=require('../../components/parsers/qs');var as=require(_0xa705('0xd'));var hardwareService=require(_0xa705('0xe'));var logger=require('../../config/logger')('api');var utils=require(_0xa705('0xf'));var config=require('../../config/environment');var db=require(_0xa705('0x10'))['db'];var dbH=require(_0xa705('0x10'))[_0xa705('0x11')];function respondWithStatusCode(_0x8fe288,_0xd58555){_0xd58555=_0xd58555||0xcc;return function(_0x4f95ec){if(_0x4f95ec){return _0x8fe288['sendStatus'](_0xd58555);}return _0x8fe288[_0xa705('0x12')](_0xd58555)[_0xa705('0x13')]();};}function respondWithResult(_0x3a283a,_0x4878bc){_0x4878bc=_0x4878bc||0xc8;return function(_0x3f74ed){if(_0x3f74ed){return _0x3a283a[_0xa705('0x12')](_0x4878bc)[_0xa705('0x14')](_0x3f74ed);}};}function respondWithFilteredResult(_0x48315b,_0x4bb679){return function(_0x374077){if(_0x374077){var _0x513f83=_0x374077[_0xa705('0x15')],_0x4ffc62=_0x4bb679[_0xa705('0x16')],_0x1c1b82=_0x4bb679[_0xa705('0x16')]+_0x4bb679[_0xa705('0x17')],_0x505086;if(_0x1c1b82>=_0x513f83){_0x1c1b82=_0x513f83;_0x505086=0xc8;}else{_0x505086=0xce;}_0x48315b['status'](_0x505086);return _0x48315b[_0xa705('0x18')](_0xa705('0x19'),_0x4ffc62+'-'+_0x1c1b82+'/'+_0x513f83)['json'](_0x374077);}return null;};}function patchUpdates(_0x5466dc){return function(_0x1c94c7){try{jsonpatch[_0xa705('0x1a')](_0x1c94c7,_0x5466dc,!![]);}catch(_0x126838){return BPromise[_0xa705('0x1b')](_0x126838);}return _0x1c94c7[_0xa705('0x1c')]();};}function saveUpdates(_0x7cbeb2,_0x5a4d18){return function(_0x33c720){if(_0x33c720){return _0x33c720[_0xa705('0x1d')](_0x7cbeb2)[_0xa705('0x1e')](function(_0x9d6202){return _0x9d6202;});}return null;};}function removeEntity(_0xaff627,_0x1c50c1){return function(_0xd1ff52){if(_0xd1ff52){return _0xd1ff52['destroy']()[_0xa705('0x1e')](function(){var _0x4e3149=_0xd1ff52[_0xa705('0x1f')]({'plain':!![]});var _0x57284a=_0xa705('0x20');return db[_0xa705('0x21')][_0xa705('0x22')]({'where':{'type':_0x57284a,'resourceId':_0x4e3149['id']}})[_0xa705('0x1e')](function(){return _0xd1ff52;});})[_0xa705('0x1e')](function(){_0xaff627[_0xa705('0x12')](0xcc)[_0xa705('0x13')]();});}};}function handleEntityNotFound(_0x35c91f,_0x2e5aac){return function(_0x5b6d51){if(!_0x5b6d51){_0x35c91f[_0xa705('0x23')](0x194);}return _0x5b6d51;};}function handleError(_0x34eb24,_0x34e5d0){_0x34e5d0=_0x34e5d0||0x1f4;return function(_0x4d7f59){logger['error'](_0x4d7f59[_0xa705('0x24')]);if(_0x4d7f59[_0xa705('0x25')]){delete _0x4d7f59[_0xa705('0x25')];}_0x34eb24[_0xa705('0x12')](_0x34e5d0)[_0xa705('0x26')](_0x4d7f59);};}exports[_0xa705('0x27')]=function(_0x21390e,_0x89793e){var _0x4b1588={},_0x3d9583={},_0x5e2cc7={'count':0x0,'rows':[]};var _0x31ae1d=_['map'](db[_0xa705('0x28')][_0xa705('0x29')],function(_0x3bdcc2){return{'name':_0x3bdcc2[_0xa705('0x2a')],'type':_0x3bdcc2['type']['key']};});_0x3d9583[_0xa705('0x2b')]=_[_0xa705('0x2c')](_0x31ae1d,'name');_0x3d9583[_0xa705('0x2d')]=_[_0xa705('0x2e')](_0x21390e[_0xa705('0x2d')]);_0x3d9583[_0xa705('0x2f')]=_[_0xa705('0x30')](_0x3d9583[_0xa705('0x2b')],_0x3d9583[_0xa705('0x2d')]);_0x4b1588[_0xa705('0x31')]=_[_0xa705('0x30')](_0x3d9583[_0xa705('0x2b')],qs[_0xa705('0x32')](_0x21390e[_0xa705('0x2d')][_0xa705('0x32')]));_0x4b1588[_0xa705('0x31')]=_0x4b1588['attributes'][_0xa705('0x33')]?_0x4b1588[_0xa705('0x31')]:_0x3d9583[_0xa705('0x2b')];if(!_0x21390e[_0xa705('0x2d')][_0xa705('0x34')](_0xa705('0x35'))){_0x4b1588[_0xa705('0x17')]=qs[_0xa705('0x17')](_0x21390e[_0xa705('0x2d')][_0xa705('0x17')]);_0x4b1588[_0xa705('0x16')]=qs[_0xa705('0x16')](_0x21390e['query'][_0xa705('0x16')]);}_0x4b1588[_0xa705('0x36')]=qs[_0xa705('0x37')](_0x21390e[_0xa705('0x2d')][_0xa705('0x37')]);_0x4b1588['where']=qs[_0xa705('0x2f')](_[_0xa705('0x38')](_0x21390e['query'],_0x3d9583[_0xa705('0x2f')]),_0x31ae1d);if(_0x21390e[_0xa705('0x2d')][_0xa705('0x39')]){_0x4b1588['where']=_[_0xa705('0x3a')](_0x4b1588[_0xa705('0x3b')],{'$or':_[_0xa705('0x2c')](_0x31ae1d,function(_0x14bce9){if(_0x14bce9[_0xa705('0x3c')]!==_0xa705('0x3d')){var _0x485c24={};_0x485c24[_0x14bce9['name']]={'$like':'%'+_0x21390e['query'][_0xa705('0x39')]+'%'};return _0x485c24;}})});}_0x4b1588=_[_0xa705('0x3a')]({},_0x4b1588,_0x21390e['options']);var _0x2ccdf4={'where':_0x4b1588['where']};return db[_0xa705('0x28')]['count'](_0x2ccdf4)['then'](function(_0x31b490){_0x5e2cc7[_0xa705('0x15')]=_0x31b490;if(_0x21390e[_0xa705('0x2d')][_0xa705('0x3e')]){_0x4b1588['include']=[{'all':!![]}];}return db[_0xa705('0x28')]['findAll'](_0x4b1588);})[_0xa705('0x1e')](function(_0xec57e2){_0x5e2cc7['rows']=_0xec57e2;return _0x5e2cc7;})[_0xa705('0x1e')](respondWithFilteredResult(_0x89793e,_0x4b1588))['catch'](handleError(_0x89793e,null));};exports[_0xa705('0x3f')]=function(_0x239ec3,_0x31f564){var _0x3f1f90={'raw':!![],'where':{'id':_0x239ec3[_0xa705('0x40')]['id']}},_0x4f64c1={};_0x4f64c1[_0xa705('0x2b')]=_[_0xa705('0x2e')](db['AnalyticDefaultReport']['rawAttributes']);_0x4f64c1[_0xa705('0x2d')]=_['keys'](_0x239ec3[_0xa705('0x2d')]);_0x4f64c1[_0xa705('0x2f')]=_['intersection'](_0x4f64c1[_0xa705('0x2b')],_0x4f64c1[_0xa705('0x2d')]);_0x3f1f90[_0xa705('0x31')]=_['intersection'](_0x4f64c1[_0xa705('0x2b')],qs[_0xa705('0x32')](_0x239ec3[_0xa705('0x2d')]['fields']));_0x3f1f90[_0xa705('0x31')]=_0x3f1f90['attributes'][_0xa705('0x33')]?_0x3f1f90[_0xa705('0x31')]:_0x4f64c1[_0xa705('0x2b')];if(_0x239ec3['query'][_0xa705('0x3e')]){_0x3f1f90[_0xa705('0x41')]=[{'all':!![]}];}_0x3f1f90=_[_0xa705('0x3a')]({},_0x3f1f90,_0x239ec3[_0xa705('0x42')]);return db[_0xa705('0x28')][_0xa705('0x43')](_0x3f1f90)[_0xa705('0x1e')](handleEntityNotFound(_0x31f564,null))[_0xa705('0x1e')](respondWithResult(_0x31f564,null))['catch'](handleError(_0x31f564,null));};exports[_0xa705('0x44')]=function(_0x26a10b,_0x5494f5){return db[_0xa705('0x28')][_0xa705('0x44')](_0x26a10b['body'],{})[_0xa705('0x1e')](function(_0x51db0c){var _0x4a387a=_0x26a10b[_0xa705('0x45')]['get']({'plain':!![]});if(!_0x4a387a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4a387a['role']==='user'){var _0x2faf1e=_0x51db0c[_0xa705('0x1f')]({'plain':!![]});var _0x5e355f=_0xa705('0x46');return db[_0xa705('0x47')]['find']({'where':{'name':_0x5e355f,'userProfileId':_0x4a387a[_0xa705('0x48')]},'raw':!![]})['then'](function(_0x5d6175){if(_0x5d6175&&_0x5d6175[_0xa705('0x49')]===0x0){return db[_0xa705('0x21')][_0xa705('0x44')]({'name':_0x2faf1e[_0xa705('0x25')],'resourceId':_0x2faf1e['id'],'type':_0xa705('0x20'),'sectionId':_0x5d6175['id']},{})['then'](function(){return _0x51db0c;});}else{return _0x51db0c;}})[_0xa705('0x4a')](function(_0x208586){logger[_0xa705('0x4b')](_0xa705('0x4c'),_0x208586);throw _0x208586;});}return _0x51db0c;})[_0xa705('0x1e')](respondWithResult(_0x5494f5,0xc9))[_0xa705('0x4a')](handleError(_0x5494f5,null));};exports[_0xa705('0x1d')]=function(_0x1ce876,_0x4366c3){if(_0x1ce876[_0xa705('0x4d')]['id']){delete _0x1ce876['body']['id'];}return db[_0xa705('0x28')][_0xa705('0x43')]({'where':{'id':_0x1ce876[_0xa705('0x40')]['id']}})['then'](handleEntityNotFound(_0x4366c3,null))[_0xa705('0x1e')](saveUpdates(_0x1ce876[_0xa705('0x4d')],null))['then'](respondWithResult(_0x4366c3,null))[_0xa705('0x4a')](handleError(_0x4366c3,null));};exports[_0xa705('0x22')]=function(_0x2f8caa,_0x49a6ea){return db[_0xa705('0x28')][_0xa705('0x43')]({'where':{'id':_0x2f8caa[_0xa705('0x40')]['id']}})['then'](handleEntityNotFound(_0x49a6ea,null))[_0xa705('0x1e')](removeEntity(_0x49a6ea,null))[_0xa705('0x4a')](handleError(_0x49a6ea,null));};exports['preview']=function(_0x16be85,_0x572192){var _0x105073=0xa;var _0x44a27d=['join','left_join',_0xa705('0x4e'),_0xa705('0x4f')];var _0x22bb92={'SUM':_0xa705('0x50'),'COUNT':_0xa705('0x51'),'COUNT DISTINCT':_0xa705('0x52'),'MAX':'MAX(%s)','MIN':_0xa705('0x53'),'AVG':_0xa705('0x54'),'GROUP_CONCAT':_0xa705('0x55'),'GROUP_CONCAT ASC':_0xa705('0x56'),'GROUP_CONCAT DESC':_0xa705('0x57')};var _0x4a1a5f={'SEC_TO_TIME':_0xa705('0x58'),'DATE':_0xa705('0x59'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xa705('0x5a')};var _0x246d05=function(_0x5898b8){return!_[_0xa705('0x5b')]([_0xa705('0x5c'),_0xa705('0x5d'),_0xa705('0x5e'),_0xa705('0x5f')],_0x5898b8);};var _0x49e9da=function(_0x470c7b){if(!_0x470c7b||!_0x470c7b['rules'][_0xa705('0x33')]){return'';}for(var _0x16c65e='(',_0x2facc5=0x0;_0x2facc5<_0x470c7b[_0xa705('0x60')][_0xa705('0x33')];_0x2facc5+=0x1){_0x2facc5>0x0&&(_0x16c65e+='\x20'+_0x470c7b[_0xa705('0x61')]+'\x20');_0x16c65e+=_0x470c7b[_0xa705('0x60')][_0x2facc5][_0xa705('0x62')]?_0x49e9da(_0x470c7b[_0xa705('0x60')][_0x2facc5][_0xa705('0x62')]):_0x470c7b['rules'][_0x2facc5][_0xa705('0x63')]+'\x20'+_0x470c7b['rules'][_0x2facc5]['condition']+(_0x246d05(_0x470c7b[_0xa705('0x60')][_0x2facc5][_0xa705('0x64')])?'\x20'+_0x470c7b['rules'][_0x2facc5][_0xa705('0x65')]:'');}return _0x16c65e+')';};var _0x39f4eb={'where':{'id':_0x16be85[_0xa705('0x40')]['id']}},_0x59dadf,_0x5a2446,_0x5c8b8a,_0x2dd742,_0x1fdd40;_0x39f4eb=_[_0xa705('0x3a')]({},_0x39f4eb,_0x16be85[_0xa705('0x42')]);return db[_0xa705('0x28')][_0xa705('0x43')](_0x39f4eb)[_0xa705('0x1e')](function(_0x2724dd){if(_0x2724dd){_0x59dadf=_0x2724dd;return _0x2724dd['getFields']();}return null;})[_0xa705('0x1e')](function(_0x3ba3ce){if(_0x3ba3ce){if(!_0x3ba3ce['length']){throw new db[(_0xa705('0x66'))][(_0xa705('0x67'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x5a2446=_0x3ba3ce;return db[_0xa705('0x68')][_0xa705('0x69')]({'raw':!![]});}return null;})[_0xa705('0x1e')](function(_0x2608bf){if(_0x2608bf){_0x5c8b8a=_[_0xa705('0x6a')](_0x2608bf,'id');var _0x330326;var _0x5f1ea4=squel[_0xa705('0x6b')]();_0x5f1ea4[_0xa705('0x6c')](_0x59dadf[_0xa705('0x6d')]);for(var _0x417015=0x0;_0x417015<_0x5a2446[_0xa705('0x33')];_0x417015+=0x1){_0x330326=_0x5a2446[_0x417015][_0xa705('0x6e')]?_0x5c8b8a[_0x5a2446[_0x417015]['MetricId']][_0xa705('0x6f')]:_0x5a2446[_0x417015][_0xa705('0x63')];_0x330326=_0x5a2446[_0x417015][_0xa705('0x70')]?_[_0xa705('0x71')](_0x22bb92[_0x5a2446[_0x417015][_0xa705('0x70')]],'%s',_0x330326):_0x330326;_0x330326=_0x5a2446[_0x417015][_0xa705('0x72')]?_[_0xa705('0x71')](_0x4a1a5f[_0x5a2446[_0x417015][_0xa705('0x72')]],'%s',_0x330326):_0x330326;if(_0x5a2446[_0x417015][_0xa705('0x73')]){_0x5f1ea4['group'](_0x330326);}_0x5a2446[_0x417015][_0xa705('0x74')]&&_0x5f1ea4[_0xa705('0x36')](_0x330326,_0x5a2446[_0x417015][_0xa705('0x74')]===_0xa705('0x75')?![]:!![]);_0x5f1ea4[_0xa705('0x63')](_0x330326,_0x5a2446[_0x417015][_0xa705('0x76')]||_0x330326);}if(_0x59dadf['joins']){_0x59dadf[_0xa705('0x77')]=JSON[_0xa705('0x78')](_0x59dadf[_0xa705('0x77')]);for(var _0x474a63=0x0;_0x474a63<_0x59dadf[_0xa705('0x77')][_0xa705('0x33')];_0x474a63+=0x1){if(_0x59dadf[_0xa705('0x77')][_0x474a63][_0xa705('0x3c')]&&_[_0xa705('0x5b')](_0x44a27d,_0x59dadf[_0xa705('0x77')][_0x474a63]['type'])&&_0x59dadf[_0xa705('0x77')][_0x474a63][_0xa705('0x79')]&&_0x59dadf[_0xa705('0x77')][_0x474a63][_0xa705('0x7a')]&&_0x59dadf[_0xa705('0x77')][_0x474a63]['foreignKey']){_0x5f1ea4[_0x59dadf[_0xa705('0x77')][_0x474a63]['type']](_0x59dadf['joins'][_0x474a63][_0xa705('0x7a')],null,util[_0xa705('0x72')](_0xa705('0x7b'),_0x59dadf[_0xa705('0x6d')],_0x59dadf[_0xa705('0x77')][_0x474a63][_0xa705('0x79')],_0x59dadf[_0xa705('0x77')][_0x474a63][_0xa705('0x7a')],_0x59dadf['joins'][_0x474a63][_0xa705('0x7c')]));}}}if(_0x59dadf[_0xa705('0x7d')]){_0x59dadf[_0xa705('0x7d')]=JSON['parse'](_0x59dadf[_0xa705('0x7d')]);_0x5f1ea4[_0xa705('0x3b')](_0x49e9da(_0x59dadf[_0xa705('0x7d')]['group']));}_0x1fdd40=_0x5f1ea4[_0xa705('0x7e')]();_0x5f1ea4[_0xa705('0x17')](_0x105073);_0x5f1ea4['offset'](0x0);logger[_0xa705('0x7f')](_0xa705('0x80'),_0x5f1ea4[_0xa705('0x81')]());return db[_0xa705('0x82')][_0xa705('0x2d')](_0x5f1ea4[_0xa705('0x81')](),{'type':db[_0xa705('0x82')]['QueryTypes'][_0xa705('0x83')]});}})[_0xa705('0x1e')](respondWithResult(_0x572192,null))['catch'](handleError(_0x572192,null));};function runReport(_0x38edf1,_0x306f6a,_0x5999c0){var _0x51ca6f=_0x306f6a[_0xa705('0x25')];var _0x89f284=0xa;var _0x5aa887=[_0xa705('0x84'),'left_join','right_join',_0xa705('0x4f')];var _0x4be1fa={'SUM':_0xa705('0x50'),'COUNT':_0xa705('0x51'),'COUNT DISTINCT':_0xa705('0x52'),'MAX':'MAX(%s)','MIN':_0xa705('0x53'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xa705('0x56'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4e74a0={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xa705('0x59'),'HOUR':_0xa705('0x85'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xa705('0x5a')};var _0x51b87b=function(_0x39909b){return!_[_0xa705('0x5b')]([_0xa705('0x5c'),_0xa705('0x5d'),_0xa705('0x5e'),_0xa705('0x5f')],_0x39909b);};var _0x183611=function(_0x3929a7){if(!_0x3929a7||!_0x3929a7[_0xa705('0x60')]['length']){return'';}for(var _0x298588='(',_0x20b753=0x0;_0x20b753<_0x3929a7[_0xa705('0x60')][_0xa705('0x33')];_0x20b753+=0x1){_0x20b753>0x0&&(_0x298588+='\x20'+_0x3929a7[_0xa705('0x61')]+'\x20');_0x298588+=_0x3929a7['rules'][_0x20b753][_0xa705('0x62')]?_0x183611(_0x3929a7['rules'][_0x20b753]['group']):_0x3929a7[_0xa705('0x60')][_0x20b753][_0xa705('0x63')]+'\x20'+_0x3929a7['rules'][_0x20b753][_0xa705('0x64')]+(_0x51b87b(_0x3929a7['rules'][_0x20b753]['condition'])?'\x20'+_0x3929a7['rules'][_0x20b753][_0xa705('0x65')]:'');}return _0x298588+')';};var _0x42736c={'where':{'id':_0x38edf1['id']}},_0x451739,_0x565a58,_0x764e91,_0x21c6ba,_0x4fe699;_0x42736c=_[_0xa705('0x3a')]({},_0x42736c,_0x5999c0);return db[_0xa705('0x28')][_0xa705('0x43')](_0x42736c)[_0xa705('0x1e')](function(_0x47dd49){if(_0x47dd49){_0x451739=_0x47dd49;return _0x47dd49[_0xa705('0x86')]();}return null;})[_0xa705('0x1e')](function(_0x46ae34){if(_0x46ae34){if(!_0x46ae34[_0xa705('0x33')]){throw new db['Sequelize'][(_0xa705('0x67'))](_0xa705('0x87'),0x193);}_0x565a58=_0x46ae34;return db[_0xa705('0x68')][_0xa705('0x69')]({'raw':!![]});}return null;})['then'](function(_0x2e8e98){if(_0x2e8e98){_0x764e91=_[_0xa705('0x6a')](_0x2e8e98,'id');var _0x1f2f2e;var _0xbc33a9=squel[_0xa705('0x6b')]();_0xbc33a9[_0xa705('0x6c')](_0x451739[_0xa705('0x6d')]);for(var _0x4d81b2=0x0;_0x4d81b2<_0x565a58[_0xa705('0x33')];_0x4d81b2+=0x1){_0x1f2f2e=_0x565a58[_0x4d81b2]['MetricId']?_0x764e91[_0x565a58[_0x4d81b2][_0xa705('0x6e')]]['metric']:_0x565a58[_0x4d81b2]['field'];_0x1f2f2e=_0x565a58[_0x4d81b2][_0xa705('0x70')]?_['replace'](_0x4be1fa[_0x565a58[_0x4d81b2][_0xa705('0x70')]],'%s',_0x1f2f2e):_0x1f2f2e;_0x1f2f2e=_0x565a58[_0x4d81b2][_0xa705('0x72')]?_[_0xa705('0x71')](_0x4e74a0[_0x565a58[_0x4d81b2][_0xa705('0x72')]],'%s',_0x1f2f2e):_0x1f2f2e;if(_0x565a58[_0x4d81b2][_0xa705('0x73')]){_0xbc33a9['group'](_0x1f2f2e);}_0x565a58[_0x4d81b2][_0xa705('0x74')]&&_0xbc33a9['order'](_0x1f2f2e,_0x565a58[_0x4d81b2][_0xa705('0x74')]===_0xa705('0x75')?![]:!![]);_0xbc33a9[_0xa705('0x63')](_0x1f2f2e,_0x565a58[_0x4d81b2][_0xa705('0x76')]||_0x1f2f2e);}if(_0x451739[_0xa705('0x77')]){_0x451739[_0xa705('0x77')]=JSON['parse'](_0x451739[_0xa705('0x77')]);for(var _0x183cd2=0x0;_0x183cd2<_0x451739[_0xa705('0x77')]['length'];_0x183cd2+=0x1){if(_0x451739[_0xa705('0x77')][_0x183cd2][_0xa705('0x3c')]&&_[_0xa705('0x5b')](_0x5aa887,_0x451739[_0xa705('0x77')][_0x183cd2][_0xa705('0x3c')])&&_0x451739['joins'][_0x183cd2][_0xa705('0x79')]&&_0x451739['joins'][_0x183cd2]['foreignTable']&&_0x451739[_0xa705('0x77')][_0x183cd2][_0xa705('0x7c')]){_0xbc33a9[_0x451739['joins'][_0x183cd2][_0xa705('0x3c')]](_0x451739['joins'][_0x183cd2][_0xa705('0x7a')],null,util[_0xa705('0x72')](_0xa705('0x7b'),_0x451739[_0xa705('0x6d')],_0x451739[_0xa705('0x77')][_0x183cd2][_0xa705('0x79')],_0x451739[_0xa705('0x77')][_0x183cd2][_0xa705('0x7a')],_0x451739['joins'][_0x183cd2][_0xa705('0x7c')]));}}}if(_0x451739[_0xa705('0x7d')]){_0x451739[_0xa705('0x7d')]=JSON[_0xa705('0x78')](_0x451739[_0xa705('0x7d')]);_0xbc33a9[_0xa705('0x3b')](_0x183611(_0x451739[_0xa705('0x7d')]['group']));}_0x4fe699=_0xbc33a9[_0xa705('0x7e')]();_0xbc33a9['limit'](_0x89f284);_0xbc33a9[_0xa705('0x16')](0x0);logger[_0xa705('0x7f')](_0xa705('0x80'),_0xbc33a9[_0xa705('0x81')]());return db[_0xa705('0x82')][_0xa705('0x2d')](_0xbc33a9[_0xa705('0x81')](),{'type':db[_0xa705('0x82')]['QueryTypes'][_0xa705('0x83')]});}})['then'](function(_0x1f8a21){if(!_0x1f8a21['length']){throw new db['Sequelize'][(_0xa705('0x67'))]('No\x20available\x20data',0xcc);}if(_0x306f6a['output']===_0xa705('0x88')){return null;}var _0x47e830=_[_0xa705('0x3a')](_0x306f6a,{'name':_0x306f6a[_0xa705('0x89')]||_0x306f6a[_0xa705('0x25')]||_0x451739[_0xa705('0x25')],'basename':_0x51ca6f,'savename':util[_0xa705('0x72')]('%s-%s.%s',_0x306f6a[_0xa705('0x25')]||_0x451739[_0xa705('0x25')],require(_0xa705('0x8a'))['generate'](0x4),_0x306f6a[_0xa705('0x8b')]||_0xa705('0x8c')),'reportId':_0x451739['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0xa705('0x44')](_0x47e830,{'raw':!![]});})[_0xa705('0x1e')](function(_0xa2a698){if(_0x451739[_0xa705('0x6d')]==='cdr'){_0x4fe699[_0xa705('0x3b')](_0x451739['table']+_0xa705('0x8d'),_0x306f6a['startDate'],_0x306f6a[_0xa705('0x8e')]);}else{_0x4fe699[_0xa705('0x3b')](_0x451739[_0xa705('0x6d')]+_0xa705('0x8f'),_0x306f6a[_0xa705('0x90')],_0x306f6a['endDate']);}if(_0xa2a698){logger[_0xa705('0x91')](_0xa705('0x92'),_0x4fe699[_0xa705('0x81')]());require('child_process')[_0xa705('0x93')](path[_0xa705('0x84')](__dirname,_0xa705('0x94'),_0xa2a698[_0xa705('0x8b')]),[_0xa2a698['id'],_0x4fe699[_0xa705('0x81')](),path[_0xa705('0x84')](__dirname,_0xa705('0x95'),_0xa2a698[_0xa705('0x96')]),_0x51ca6f]);return _0xa2a698;}else{var _0x9d5e1a=squel[_0xa705('0x6b')]();_0x9d5e1a[_0xa705('0x6c')]('('+_0x4fe699['toString']()+')',_0xa705('0x97'));_0x9d5e1a['field']('COUNT(*)',_0xa705('0x15'));_0x4fe699[_0xa705('0x17')](_0x306f6a['limit']||_0x89f284);_0x4fe699[_0xa705('0x16')](_0x306f6a[_0xa705('0x16')]||0x0);return dbH[_0xa705('0x82')][_0xa705('0x2d')](_0x9d5e1a[_0xa705('0x81')](),{'type':dbH[_0xa705('0x82')][_0xa705('0x98')][_0xa705('0x83')]})[_0xa705('0x1e')](function(_0x329d9f){if(!_0x329d9f['length']){_0x21c6ba=0x0;}else{_0x21c6ba=_0x329d9f[0x0][_0xa705('0x15')]||0x0;}return dbH[_0xa705('0x82')][_0xa705('0x2d')](_0x4fe699[_0xa705('0x81')](),{'type':dbH[_0xa705('0x82')][_0xa705('0x98')][_0xa705('0x83')]});})[_0xa705('0x1e')](function(_0x117a21){return{'rows':_0x117a21||[],'count':_0x21c6ba};});}});}exports['run']=function(_0x408748,_0x5650db){return runReport(_0x408748[_0xa705('0x40')],_0x408748[_0xa705('0x2d')],_0x408748[_0xa705('0x42')])[_0xa705('0x1e')](respondWithResult(_0x5650db,null))['catch'](handleError(_0x5650db,null));};exports[_0xa705('0x99')]=runReport;exports['query']=function(_0x14d1b7,_0x498e8c){var _0x384de4=0xa;var _0x294928=[_0xa705('0x84'),_0xa705('0x9a'),'right_join',_0xa705('0x4f')];var _0x3e896d={'SUM':_0xa705('0x50'),'COUNT':_0xa705('0x51'),'COUNT DISTINCT':_0xa705('0x52'),'MAX':_0xa705('0x9b'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0xa705('0x55'),'GROUP_CONCAT ASC':_0xa705('0x56'),'GROUP_CONCAT DESC':_0xa705('0x57')};var _0x264695={'SEC_TO_TIME':_0xa705('0x58'),'DATE':_0xa705('0x59'),'HOUR':'HOUR(%s)','ROUND':_0xa705('0x9c'),'UNIX_TIMESTAMP':_0xa705('0x5a')};var _0x13b342=function(_0x320296){return!_['includes']([_0xa705('0x5c'),_0xa705('0x5d'),_0xa705('0x5e'),_0xa705('0x5f')],_0x320296);};var _0x54cff0=function(_0xaf09e0){if(!_0xaf09e0||!_0xaf09e0[_0xa705('0x60')]['length']){return'';}for(var _0x3a4ed0='(',_0x589118=0x0;_0x589118<_0xaf09e0[_0xa705('0x60')]['length'];_0x589118+=0x1){_0x589118>0x0&&(_0x3a4ed0+='\x20'+_0xaf09e0[_0xa705('0x61')]+'\x20');_0x3a4ed0+=_0xaf09e0[_0xa705('0x60')][_0x589118][_0xa705('0x62')]?_0x54cff0(_0xaf09e0[_0xa705('0x60')][_0x589118][_0xa705('0x62')]):_0xaf09e0['rules'][_0x589118]['field']+'\x20'+_0xaf09e0[_0xa705('0x60')][_0x589118][_0xa705('0x64')]+(_0x13b342(_0xaf09e0['rules'][_0x589118][_0xa705('0x64')])?'\x20'+_0xaf09e0[_0xa705('0x60')][_0x589118][_0xa705('0x65')]:'');}return _0x3a4ed0+')';};var _0x250a92={'where':{'id':_0x14d1b7[_0xa705('0x40')]['id']}},_0xc0d68b,_0x237568,_0x5236b7,_0x1bd2f5,_0x4207ae;_0x250a92=_['merge']({},_0x250a92,_0x14d1b7[_0xa705('0x42')]);return db[_0xa705('0x28')][_0xa705('0x43')](_0x250a92)[_0xa705('0x1e')](function(_0x1cce3b){if(_0x1cce3b){_0xc0d68b=_0x1cce3b;return _0x1cce3b[_0xa705('0x86')]();}return null;})[_0xa705('0x1e')](function(_0x55b346){if(_0x55b346){if(!_0x55b346[_0xa705('0x33')]){throw new db['Sequelize'][(_0xa705('0x67'))](_0xa705('0x87'),0x193);}_0x237568=_0x55b346;return db[_0xa705('0x68')][_0xa705('0x69')]({'raw':!![]});}return null;})[_0xa705('0x1e')](function(_0x5a1bf8){if(_0x5a1bf8){_0x5236b7=_[_0xa705('0x6a')](_0x5a1bf8,'id');var _0x374763;var _0x5808fd=squel[_0xa705('0x6b')]();_0x5808fd[_0xa705('0x6c')](_0xc0d68b['table']);for(var _0x336f36=0x0;_0x336f36<_0x237568[_0xa705('0x33')];_0x336f36+=0x1){_0x374763=_0x237568[_0x336f36][_0xa705('0x6e')]?_0x5236b7[_0x237568[_0x336f36][_0xa705('0x6e')]][_0xa705('0x6f')]:_0x237568[_0x336f36][_0xa705('0x63')];_0x374763=_0x237568[_0x336f36][_0xa705('0x70')]?_[_0xa705('0x71')](_0x3e896d[_0x237568[_0x336f36][_0xa705('0x70')]],'%s',_0x374763):_0x374763;_0x374763=_0x237568[_0x336f36][_0xa705('0x72')]?_[_0xa705('0x71')](_0x264695[_0x237568[_0x336f36]['format']],'%s',_0x374763):_0x374763;if(_0x237568[_0x336f36][_0xa705('0x73')]){_0x5808fd[_0xa705('0x62')](_0x374763);}_0x237568[_0x336f36][_0xa705('0x74')]&&_0x5808fd[_0xa705('0x36')](_0x374763,_0x237568[_0x336f36][_0xa705('0x74')]===_0xa705('0x75')?![]:!![]);_0x5808fd['field'](_0x374763,_0x237568[_0x336f36][_0xa705('0x76')]||_0x374763);}if(_0xc0d68b[_0xa705('0x77')]){_0xc0d68b[_0xa705('0x77')]=JSON[_0xa705('0x78')](_0xc0d68b[_0xa705('0x77')]);for(var _0x53d510=0x0;_0x53d510<_0xc0d68b[_0xa705('0x77')]['length'];_0x53d510+=0x1){if(_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x3c')]&&_[_0xa705('0x5b')](_0x294928,_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x3c')])&&_0xc0d68b[_0xa705('0x77')][_0x53d510]['parentKey']&&_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x7a')]&&_0xc0d68b[_0xa705('0x77')][_0x53d510]['foreignKey']){_0x5808fd[_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x3c')]](_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x7a')],null,util['format'](_0xa705('0x7b'),_0xc0d68b[_0xa705('0x6d')],_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x79')],_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x7a')],_0xc0d68b[_0xa705('0x77')][_0x53d510][_0xa705('0x7c')]));}}}if(_0xc0d68b[_0xa705('0x7d')]){_0xc0d68b[_0xa705('0x7d')]=JSON[_0xa705('0x78')](_0xc0d68b[_0xa705('0x7d')]);_0x5808fd[_0xa705('0x3b')](_0x54cff0(_0xc0d68b[_0xa705('0x7d')][_0xa705('0x62')]));}_0x4207ae=_0x5808fd[_0xa705('0x7e')]();_0x5808fd['limit'](_0x384de4);_0x5808fd[_0xa705('0x16')](0x0);logger[_0xa705('0x7f')](_0xa705('0x80'),_0x5808fd[_0xa705('0x81')]());return db['sequelize']['query'](_0x5808fd[_0xa705('0x81')](),{'type':db[_0xa705('0x82')][_0xa705('0x98')][_0xa705('0x83')]});}})[_0xa705('0x1e')](function(){return{'sql':_0x4207ae[_0xa705('0x81')]()};})[_0xa705('0x1e')](respondWithResult(_0x498e8c,null))[_0xa705('0x4a')](handleError(_0x498e8c,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff