-const a5_0x6854=['keys','includeAll','field','metric','orderBy','sequelize','error','MIN(%s)','foreignTable','model','merge','foreignKey','child_process','left_join','.createdAt\x20BETWEEN\x20?\x20AND\x20?','IS\x20NOT\x20EMPTY','index','HOUR(%s)','toString','Run\x20Query:','%s.%s\x20=\x20%s.%s','DESC','order','update','../../components/parsers/qs','../../files/reports','output','MetricId','AnalyticMetric','intersection','%s-%s.%s','AVG(%s)','create','debug','util','key','UserProfileResource','info','joins','api','operator','user','IS\x20NULL','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','table','parentKey','DATE(%s)','endDate','cross_join','SUM(%s)','Reports','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','from','clone','type','then','select','AnalyticExtractedReport','cdr','where','end','filters','UNIX_TIMESTAMP(%s)','csv','fullPath','autoAssociation','attributes','include','randomstring','offset','preview','squel','map','web','Limited\x20Query:','role','filter','right_join','keyBy','fields','undefined','params','options','custom','run','show','sendStatus','fieldName','function','findAll','rules','countTable','limit','findOne','runReport','groupBy','Content-Range','sort','count','body','rows','COUNT(%s)','format','join','stack','AnalyticCustomReport','destroy','.calldate\x20BETWEEN\x20?\x20AND\x20?','get','status','like','catch','value','group','fork','SEC_TO_TIME(%s)','../../mysqldb','GROUP_CONCAT(%s)','ROUND(%s)','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','QueryTypes','lodash','startDate','Unable\x20to\x20retrieve\x20the\x20current\x20user','getFields','includes','userProfileId','MAX(%s)','parse','name','UserProfileSection','SELECT','replace','COUNT(DISTINCT\x20%s)','dbH','VIRTUAL','IS\x20NOT\x20NULL','length','CustomReports','alias','IS\x20EMPTY','savename','query','Please\x20insert\x20at\x20least\x20one\x20field','condition','conditions'];(function(_0x1be7db,_0x6854ad){const _0x4eb9d0=function(_0x1db553){while(--_0x1db553){_0x1be7db['push'](_0x1be7db['shift']());}};_0x4eb9d0(++_0x6854ad);}(a5_0x6854,0xf8));const a5_0x4eb9=function(_0x1be7db,_0x6854ad){_0x1be7db=_0x1be7db-0x0;let _0x4eb9d0=a5_0x6854[_0x1be7db];return _0x4eb9d0;};const _0x290121=a5_0x4eb9;'use strict';const util=require(_0x290121('0x4e')),path=require('path'),_=require(_0x290121('0x13')),squel=require(_0x290121('0x73')),qs=require(_0x290121('0x44')),logger=require('../../config/logger')(_0x290121('0x53')),db=require('../../mysqldb')['db'],dbH=require(_0x290121('0xe'))[_0x290121('0x20')],{Op,ValidationErrorItem,QueryTypes}=require(_0x290121('0x31'));function respondWithResult(_0x1db553,_0x1e79c7){return _0x1e79c7=_0x1e79c7||0xc8,function(_0x653ff){const _0x3e262f=a5_0x4eb9;if(_0x653ff)return _0x1db553[_0x3e262f('0x7')](_0x1e79c7)['json'](_0x653ff);};}function respondWithFilteredResult(_0x28a08a,_0x4769ae){return function(_0xd468dc){const _0x375d56=a5_0x4eb9;if(_0xd468dc){const _0x2b4230=_0xd468dc[_0x375d56('0x8e')],_0x315115=_0x4769ae[_0x375d56('0x71')];let _0x299686=_0x4769ae[_0x375d56('0x71')]+_0x4769ae['limit'],_0x103f13;return _0x299686>=_0x2b4230?(_0x299686=_0x2b4230,_0x103f13=0xc8):_0x103f13=0xce,_0x28a08a[_0x375d56('0x7')](_0x103f13),_0x28a08a['set'](_0x375d56('0x8c'),_0x315115+'-'+_0x299686+'/'+_0x2b4230)['json'](_0xd468dc);}return null;};}function saveUpdates(_0x5c9cf0){return function(_0x575e52){if(_0x575e52)return _0x575e52['update'](_0x5c9cf0)['then'](function(_0x25a151){return _0x25a151;});return null;};}function removeEntity(_0x58841b){return function(_0x2319ce){const _0x397759=a5_0x4eb9;if(_0x2319ce)return _0x2319ce[_0x397759('0x4')]()[_0x397759('0x63')](function(){const _0x10f929=_0x397759,_0x5cefa9=_0x2319ce[_0x10f929('0x6')]({'plain':!![]}),_0x239b26=_0x10f929('0x24');return db['UserProfileResource'][_0x10f929('0x4')]({'where':{'type':_0x239b26,'resourceId':_0x5cefa9['id']}})[_0x10f929('0x63')](function(){return _0x2319ce;});})['then'](function(){const _0xb7a68c=_0x397759;_0x58841b[_0xb7a68c('0x7')](0xcc)[_0xb7a68c('0x68')]();});};}function handleEntityNotFound(_0x2e385f){return function(_0x18f041){const _0x37902c=a5_0x4eb9;return!_0x18f041&&_0x2e385f[_0x37902c('0x82')](0x194),_0x18f041;};}function handleError(_0x2f96f5,_0x27e490){return _0x27e490=_0x27e490||0x1f4,function(_0x57c68f){const _0x226992=a5_0x4eb9;logger['error'](_0x57c68f[_0x226992('0x2')]),_0x57c68f[_0x226992('0x1b')]&&delete _0x57c68f[_0x226992('0x1b')],_0x2f96f5[_0x226992('0x7')](_0x27e490)['send'](_0x57c68f);};}exports[_0x290121('0x3c')]=function(_0x11107e,_0x317ed6){const _0xc1a5e5=_0x290121;let _0x35417e={};const _0x44dc9b={},_0x20f805={'count':0x0,'rows':[]},_0x42a384=_[_0xc1a5e5('0x74')](db[_0xc1a5e5('0x3')]['rawAttributes'],function(_0x117c92){const _0xbc837a=_0xc1a5e5;return{'name':_0x117c92[_0xbc837a('0x83')],'type':_0x117c92[_0xbc837a('0x62')][_0xbc837a('0x4f')]};});_0x44dc9b[_0xc1a5e5('0x35')]=_[_0xc1a5e5('0x74')](_0x42a384,_0xc1a5e5('0x1b')),_0x44dc9b[_0xc1a5e5('0x28')]=_[_0xc1a5e5('0x2c')](_0x11107e['query']),_0x44dc9b[_0xc1a5e5('0x69')]=_[_0xc1a5e5('0x49')](_0x44dc9b['model'],_0x44dc9b[_0xc1a5e5('0x28')]),_0x35417e[_0xc1a5e5('0x6e')]=_[_0xc1a5e5('0x49')](_0x44dc9b[_0xc1a5e5('0x35')],qs[_0xc1a5e5('0x7b')](_0x11107e[_0xc1a5e5('0x28')]['fields'])),_0x35417e[_0xc1a5e5('0x6e')]=_0x35417e[_0xc1a5e5('0x6e')][_0xc1a5e5('0x23')]?_0x35417e[_0xc1a5e5('0x6e')]:_0x44dc9b[_0xc1a5e5('0x35')];typeof _0x11107e[_0xc1a5e5('0x28')]['nolimit']===_0xc1a5e5('0x7c')&&(_0x35417e['limit']=qs[_0xc1a5e5('0x88')](_0x11107e['query']['limit']),_0x35417e[_0xc1a5e5('0x71')]=qs[_0xc1a5e5('0x71')](_0x11107e['query'][_0xc1a5e5('0x71')]));_0x35417e[_0xc1a5e5('0x42')]=qs[_0xc1a5e5('0x8d')](_0x11107e[_0xc1a5e5('0x28')][_0xc1a5e5('0x8d')]),_0x35417e[_0xc1a5e5('0x67')]=qs['filters'](_['pick'](_0x11107e['query'],_0x44dc9b[_0xc1a5e5('0x69')]),_0x42a384);_0x11107e[_0xc1a5e5('0x28')][_0xc1a5e5('0x78')]&&(_0x35417e[_0xc1a5e5('0x67')]=_['merge'](_0x35417e[_0xc1a5e5('0x67')],{[Op['or']]:_[_0xc1a5e5('0x74')](_0x42a384,function(_0x2a9d75){const _0x1d3429=_0xc1a5e5;if(_0x2a9d75['type']!==_0x1d3429('0x21')){const _0x48c33b={};return _0x48c33b[_0x2a9d75[_0x1d3429('0x1b')]]={[Op[_0x1d3429('0x8')]]:'%'+_0x11107e['query'][_0x1d3429('0x78')]+'%'},_0x48c33b;}})}));_0x35417e=_[_0xc1a5e5('0x36')]({},_0x35417e,_0x11107e[_0xc1a5e5('0x7e')]);const _0x1dbc9e={'where':_0x35417e['where']};return db[_0xc1a5e5('0x3')][_0xc1a5e5('0x8e')](_0x1dbc9e)['then'](function(_0x4dcc2c){const _0x400735=_0xc1a5e5;return _0x20f805[_0x400735('0x8e')]=_0x4dcc2c,_0x11107e['query'][_0x400735('0x2d')]&&(_0x35417e['include']=[{'all':!![]}]),db[_0x400735('0x3')][_0x400735('0x85')](_0x35417e);})[_0xc1a5e5('0x63')](function(_0x287809){const _0x5d6111=_0xc1a5e5;return _0x20f805[_0x5d6111('0x90')]=_0x287809,_0x20f805;})['then'](respondWithFilteredResult(_0x317ed6,_0x35417e))['catch'](handleError(_0x317ed6,null));},exports[_0x290121('0x81')]=function(_0x284a36,_0x308351){const _0x3debbf=_0x290121;let _0x4004fe={'raw':![],'where':{'id':_0x284a36[_0x3debbf('0x7d')]['id']}};const _0x35c006={};return _0x35c006[_0x3debbf('0x35')]=_[_0x3debbf('0x2c')](db[_0x3debbf('0x3')]['rawAttributes']),_0x35c006[_0x3debbf('0x28')]=_['keys'](_0x284a36[_0x3debbf('0x28')]),_0x35c006[_0x3debbf('0x69')]=_['intersection'](_0x35c006[_0x3debbf('0x35')],_0x35c006[_0x3debbf('0x28')]),_0x4004fe[_0x3debbf('0x6e')]=_[_0x3debbf('0x49')](_0x35c006[_0x3debbf('0x35')],qs['fields'](_0x284a36[_0x3debbf('0x28')][_0x3debbf('0x7b')])),_0x4004fe[_0x3debbf('0x6e')]=_0x4004fe[_0x3debbf('0x6e')][_0x3debbf('0x23')]?_0x4004fe[_0x3debbf('0x6e')]:_0x35c006[_0x3debbf('0x35')],_0x284a36[_0x3debbf('0x28')][_0x3debbf('0x2d')]&&(_0x4004fe[_0x3debbf('0x6f')]=[{'all':!![]}]),_0x4004fe=_[_0x3debbf('0x36')]({},_0x4004fe,_0x284a36[_0x3debbf('0x7e')]),db['AnalyticCustomReport'][_0x3debbf('0x89')](_0x4004fe)[_0x3debbf('0x63')](handleEntityNotFound(_0x308351,null))[_0x3debbf('0x63')](respondWithResult(_0x308351,null))[_0x3debbf('0x9')](handleError(_0x308351,null));},exports[_0x290121('0x4c')]=function(_0x1aea68,_0x5aee3b){const _0x31a8ca=_0x290121;return db[_0x31a8ca('0x3')][_0x31a8ca('0x4c')](_0x1aea68[_0x31a8ca('0x8f')],{})['then'](function(_0x490d5){const _0x5be0d9=_0x31a8ca,_0x492fda=_0x1aea68[_0x5be0d9('0x55')][_0x5be0d9('0x6')]({'plain':!![]});if(!_0x492fda)throw new Error(_0x5be0d9('0x15'));if(_0x492fda[_0x5be0d9('0x77')]===_0x5be0d9('0x55')){const _0x5c7ce4=_0x490d5['get']({'plain':!![]}),_0xfaccf7=_0x5be0d9('0x5e');return db[_0x5be0d9('0x1c')][_0x5be0d9('0x89')]({'where':{'name':_0xfaccf7,'userProfileId':_0x492fda[_0x5be0d9('0x18')]},'raw':!![]})[_0x5be0d9('0x63')](function(_0x44e0f4){const _0x291258=_0x5be0d9;return _0x44e0f4&&_0x44e0f4[_0x291258('0x6d')]===0x0?db[_0x291258('0x50')][_0x291258('0x4c')]({'name':_0x5c7ce4[_0x291258('0x1b')],'resourceId':_0x5c7ce4['id'],'type':_0x291258('0x24'),'sectionId':_0x44e0f4['id']},{})[_0x291258('0x63')](function(){return _0x490d5;}):_0x490d5;})[_0x5be0d9('0x9')](function(_0x83b7cd){const _0x158c46=_0x5be0d9;logger[_0x158c46('0x32')](_0x158c46('0x11'),_0x83b7cd);throw _0x83b7cd;});}return _0x490d5;})['then'](respondWithResult(_0x5aee3b,0xc9))[_0x31a8ca('0x9')](handleError(_0x5aee3b,null));},exports[_0x290121('0x43')]=function(_0x492720,_0x280d71){const _0xe2372a=_0x290121;return _0x492720[_0xe2372a('0x8f')]['id']&&delete _0x492720['body']['id'],db[_0xe2372a('0x3')][_0xe2372a('0x89')]({'where':{'id':_0x492720[_0xe2372a('0x7d')]['id']}})[_0xe2372a('0x63')](handleEntityNotFound(_0x280d71,null))['then'](saveUpdates(_0x492720[_0xe2372a('0x8f')],null))[_0xe2372a('0x63')](respondWithResult(_0x280d71,null))[_0xe2372a('0x9')](handleError(_0x280d71,null));},exports[_0x290121('0x4')]=function(_0xc994fa,_0xadadf){const _0x3b9276=_0x290121;return db[_0x3b9276('0x3')]['findOne']({'where':{'id':_0xc994fa['params']['id']}})['then'](handleEntityNotFound(_0xadadf,null))[_0x3b9276('0x63')](removeEntity(_0xadadf,null))['catch'](handleError(_0xadadf,null));},exports[_0x290121('0x72')]=function(_0x4b1e02,_0x4c16d4){const _0x40b66=_0x290121,_0x21ec3e=0xa,_0x2d991f=[_0x40b66('0x1'),_0x40b66('0x39'),_0x40b66('0x79'),_0x40b66('0x5c')],_0x15dda7={'SUM':_0x40b66('0x5d'),'COUNT':_0x40b66('0x91'),'COUNT\x20DISTINCT':_0x40b66('0x1f'),'MAX':_0x40b66('0x19'),'MIN':_0x40b66('0x33'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x40b66('0xf'),'GROUP_CONCAT\x20ASC':_0x40b66('0x57'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0xb9d59d={'SEC_TO_TIME':_0x40b66('0xd'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x40b66('0x10'),'UNIX_TIMESTAMP':_0x40b66('0x6a')},_0x5e1091=function(_0x1450d0){const _0x313c89=_0x40b66;return!_[_0x313c89('0x17')](['IS\x20NULL',_0x313c89('0x22'),'IS\x20EMPTY',_0x313c89('0x3b')],_0x1450d0);},_0x41eb0e=function(_0x101db7){const _0x5ae323=_0x40b66;if(!_0x101db7||!_0x101db7[_0x5ae323('0x86')][_0x5ae323('0x23')])return'';let _0x21965c='(';for(let _0x474420=0x0;_0x474420<_0x101db7[_0x5ae323('0x86')][_0x5ae323('0x23')];_0x474420+=0x1){_0x474420>0x0&&(_0x21965c+='\x20'+_0x101db7[_0x5ae323('0x54')]+'\x20'),_0x21965c+=_0x101db7['rules'][_0x474420][_0x5ae323('0xb')]?_0x41eb0e(_0x101db7[_0x5ae323('0x86')][_0x474420]['group']):_0x101db7[_0x5ae323('0x86')][_0x474420][_0x5ae323('0x2e')]+'\x20'+_0x101db7[_0x5ae323('0x86')][_0x474420]['condition']+(_0x5e1091(_0x101db7['rules'][_0x474420][_0x5ae323('0x2a')])?'\x20'+_0x101db7[_0x5ae323('0x86')][_0x474420][_0x5ae323('0xa')]:'');}return _0x21965c+')';};let _0x21dac8={'where':{'id':_0x4b1e02[_0x40b66('0x7d')]['id']}},_0x309f7c,_0x52cd5f,_0x5cf06a;return _0x21dac8=_[_0x40b66('0x36')]({},_0x21dac8,_0x4b1e02[_0x40b66('0x7e')]),db[_0x40b66('0x3')][_0x40b66('0x89')](_0x21dac8)['then'](function(_0x4ca605){const _0x2e8512=_0x40b66;if(_0x4ca605)return _0x309f7c=_0x4ca605,_0x4ca605[_0x2e8512('0x16')]();return null;})['then'](function(_0x137b22){const _0x4a918d=_0x40b66;if(_0x137b22){if(!_0x137b22['length'])throw new ValidationErrorItem(_0x4a918d('0x29'),0x193);return _0x52cd5f=_0x137b22,db[_0x4a918d('0x48')]['findAll']({'raw':!![]});}return null;})[_0x40b66('0x63')](function(_0x3d2faa){const _0x278d63=_0x40b66;if(_0x3d2faa){_0x5cf06a=_[_0x278d63('0x7a')](_0x3d2faa,'id');let _0x1c1be5;const _0x43d8ac=squel['select']();_0x43d8ac[_0x278d63('0x60')](_0x309f7c[_0x278d63('0x58')]);for(let _0x48b486=0x0;_0x48b486<_0x52cd5f[_0x278d63('0x23')];_0x48b486+=0x1){_0x1c1be5=_0x52cd5f[_0x48b486][_0x278d63('0x47')]?_0x5cf06a[_0x52cd5f[_0x48b486][_0x278d63('0x47')]]['metric']:_0x52cd5f[_0x48b486][_0x278d63('0x2e')],_0x1c1be5=_0x52cd5f[_0x48b486][_0x278d63('0x84')]?_['replace'](_0x15dda7[_0x52cd5f[_0x48b486][_0x278d63('0x84')]],'%s',_0x1c1be5):_0x1c1be5,_0x1c1be5=_0x52cd5f[_0x48b486][_0x278d63('0x0')]?_['replace'](_0xb9d59d[_0x52cd5f[_0x48b486][_0x278d63('0x0')]],'%s',_0x1c1be5):_0x1c1be5,_0x52cd5f[_0x48b486][_0x278d63('0x8b')]&&_0x43d8ac['group'](_0x1c1be5),_0x52cd5f[_0x48b486]['orderBy']&&_0x43d8ac[_0x278d63('0x42')](_0x1c1be5,_0x52cd5f[_0x48b486][_0x278d63('0x30')]==='DESC'?![]:!![]),_0x43d8ac['field'](_0x1c1be5,_0x52cd5f[_0x48b486][_0x278d63('0x25')]||_0x1c1be5);}if(_0x309f7c[_0x278d63('0x52')]){_0x309f7c[_0x278d63('0x52')]=JSON[_0x278d63('0x1a')](_0x309f7c['joins']);for(let _0x505bf8=0x0;_0x505bf8<_0x309f7c[_0x278d63('0x52')]['length'];_0x505bf8+=0x1){_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x62')]&&_[_0x278d63('0x17')](_0x2d991f,_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x62')])&&_0x309f7c['joins'][_0x505bf8][_0x278d63('0x59')]&&_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x34')]&&_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x37')]&&_0x43d8ac[_0x309f7c[_0x278d63('0x52')][_0x505bf8]['type']](_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x34')],null,util[_0x278d63('0x0')](_0x278d63('0x40'),_0x309f7c[_0x278d63('0x58')],_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x59')],_0x309f7c[_0x278d63('0x52')][_0x505bf8]['foreignTable'],_0x309f7c[_0x278d63('0x52')][_0x505bf8][_0x278d63('0x37')]));}}return _0x309f7c[_0x278d63('0x2b')]&&(_0x309f7c[_0x278d63('0x2b')]=JSON[_0x278d63('0x1a')](_0x309f7c[_0x278d63('0x2b')]),_0x43d8ac[_0x278d63('0x67')](_0x41eb0e(_0x309f7c[_0x278d63('0x2b')][_0x278d63('0xb')]))),_0x43d8ac[_0x278d63('0x88')](_0x21ec3e),_0x43d8ac[_0x278d63('0x71')](0x0),logger[_0x278d63('0x4d')](_0x278d63('0x76'),_0x43d8ac[_0x278d63('0x3e')]()),db[_0x278d63('0x31')][_0x278d63('0x28')](_0x43d8ac[_0x278d63('0x3e')](),{'type':QueryTypes[_0x278d63('0x1d')]});}})[_0x40b66('0x63')](respondWithResult(_0x4c16d4,null))[_0x40b66('0x9')](handleError(_0x4c16d4,null));};function runReport(_0x238c50,_0xae24f7,_0x82df99){const _0x544ea8=_0x290121,_0x50d0b4=_0xae24f7[_0x544ea8('0x1b')],_0x1fb0e9=0xa,_0x2d10b1=['join',_0x544ea8('0x39'),_0x544ea8('0x79'),_0x544ea8('0x5c')],_0x22116b={'SUM':_0x544ea8('0x5d'),'COUNT':_0x544ea8('0x91'),'COUNT\x20DISTINCT':_0x544ea8('0x1f'),'MAX':_0x544ea8('0x19'),'MIN':_0x544ea8('0x33'),'AVG':_0x544ea8('0x4b'),'GROUP_CONCAT':_0x544ea8('0xf'),'GROUP_CONCAT\x20ASC':_0x544ea8('0x57'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0x4cf9e2={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0x544ea8('0x3d'),'ROUND':_0x544ea8('0x10'),'UNIX_TIMESTAMP':_0x544ea8('0x6a')},_0x13e445=function(_0x163451){const _0x374358=_0x544ea8;return!_[_0x374358('0x17')]([_0x374358('0x56'),'IS\x20NOT\x20NULL',_0x374358('0x26'),_0x374358('0x3b')],_0x163451);},_0x42fd0b=function(_0x446a51){const _0x27a6e7=_0x544ea8;if(!_0x446a51||!_0x446a51['rules']['length'])return'';let _0x50c06e='(';for(let _0x3ca351=0x0;_0x3ca351<_0x446a51[_0x27a6e7('0x86')][_0x27a6e7('0x23')];_0x3ca351+=0x1){_0x3ca351>0x0&&(_0x50c06e+='\x20'+_0x446a51['operator']+'\x20'),_0x50c06e+=_0x446a51['rules'][_0x3ca351][_0x27a6e7('0xb')]?_0x42fd0b(_0x446a51[_0x27a6e7('0x86')][_0x3ca351][_0x27a6e7('0xb')]):_0x446a51['rules'][_0x3ca351][_0x27a6e7('0x2e')]+'\x20'+_0x446a51[_0x27a6e7('0x86')][_0x3ca351][_0x27a6e7('0x2a')]+(_0x13e445(_0x446a51[_0x27a6e7('0x86')][_0x3ca351][_0x27a6e7('0x2a')])?'\x20'+_0x446a51[_0x27a6e7('0x86')][_0x3ca351][_0x27a6e7('0xa')]:'');}return _0x50c06e+')';};let _0x417177={'where':{'id':_0x238c50['id']}},_0xaab4f3,_0x55702c,_0x38b6a1,_0x4b58e0,_0x3f08d3;return _0x417177=_[_0x544ea8('0x36')]({},_0x417177,_0x82df99),db[_0x544ea8('0x3')][_0x544ea8('0x89')](_0x417177)[_0x544ea8('0x63')](function(_0x57c4e2){if(_0x57c4e2)return _0xaab4f3=_0x57c4e2,_0x57c4e2['getFields']();return null;})[_0x544ea8('0x63')](function(_0x2d60c1){const _0xed187=_0x544ea8;if(_0x2d60c1){if(!_0x2d60c1[_0xed187('0x23')])throw new ValidationErrorItem(_0xed187('0x29'),0x193);return _0x55702c=_0x2d60c1,db['AnalyticMetric'][_0xed187('0x85')]({'raw':!![]});}return null;})[_0x544ea8('0x63')](function(_0x10f669){const _0x33ce25=_0x544ea8;if(_0x10f669){_0x38b6a1=_['keyBy'](_0x10f669,'id');let _0x5e4612;const _0x3d23d3=squel[_0x33ce25('0x64')]();_0x3d23d3[_0x33ce25('0x60')](_0xaab4f3['table']);for(let _0x2826f8=0x0;_0x2826f8<_0x55702c['length'];_0x2826f8+=0x1){_0x5e4612=_0x55702c[_0x2826f8]['MetricId']?_0x38b6a1[_0x55702c[_0x2826f8][_0x33ce25('0x47')]][_0x33ce25('0x2f')]:_0x55702c[_0x2826f8][_0x33ce25('0x2e')],_0x5e4612=_0x55702c[_0x2826f8][_0x33ce25('0x84')]?_['replace'](_0x22116b[_0x55702c[_0x2826f8]['function']],'%s',_0x5e4612):_0x5e4612,_0x5e4612=_0x55702c[_0x2826f8][_0x33ce25('0x0')]?_[_0x33ce25('0x1e')](_0x4cf9e2[_0x55702c[_0x2826f8][_0x33ce25('0x0')]],'%s',_0x5e4612):_0x5e4612,_0x55702c[_0x2826f8][_0x33ce25('0x8b')]&&_0x3d23d3[_0x33ce25('0xb')](_0x5e4612),_0x55702c[_0x2826f8][_0x33ce25('0x30')]&&_0x3d23d3['order'](_0x5e4612,_0x55702c[_0x2826f8][_0x33ce25('0x30')]===_0x33ce25('0x41')?![]:!![]),_0x3d23d3[_0x33ce25('0x2e')](_0x5e4612,_0x55702c[_0x2826f8][_0x33ce25('0x25')]||_0x5e4612);}if(_0xaab4f3[_0x33ce25('0x52')]){_0xaab4f3[_0x33ce25('0x52')]=JSON['parse'](_0xaab4f3['joins']);for(let _0xb287dd=0x0;_0xb287dd<_0xaab4f3['joins'][_0x33ce25('0x23')];_0xb287dd+=0x1){_0xaab4f3['joins'][_0xb287dd]['type']&&_['includes'](_0x2d10b1,_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x62')])&&_0xaab4f3['joins'][_0xb287dd]['parentKey']&&_0xaab4f3['joins'][_0xb287dd][_0x33ce25('0x34')]&&_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x37')]&&_0x3d23d3[_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x62')]](_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x34')],null,util[_0x33ce25('0x0')](_0x33ce25('0x40'),_0xaab4f3[_0x33ce25('0x58')],_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x59')],_0xaab4f3[_0x33ce25('0x52')][_0xb287dd][_0x33ce25('0x34')],_0xaab4f3[_0x33ce25('0x52')][_0xb287dd]['foreignKey']));}}return _0xaab4f3[_0x33ce25('0x2b')]&&(_0xaab4f3[_0x33ce25('0x2b')]=JSON[_0x33ce25('0x1a')](_0xaab4f3[_0x33ce25('0x2b')]),_0x3d23d3[_0x33ce25('0x67')](_0x42fd0b(_0xaab4f3[_0x33ce25('0x2b')][_0x33ce25('0xb')]))),_0x3f08d3=_0x3d23d3['clone'](),_0x3d23d3['limit'](_0x1fb0e9),_0x3d23d3[_0x33ce25('0x71')](0x0),logger['debug']('Limited\x20Query:',_0x3d23d3['toString']()),db['sequelize'][_0x33ce25('0x28')](_0x3d23d3['toString'](),{'type':QueryTypes[_0x33ce25('0x1d')]});}})[_0x544ea8('0x63')](function(_0x3cf0b9){const _0x15ba6d=_0x544ea8;if(!_0x3cf0b9[_0x15ba6d('0x23')])throw new ValidationErrorItem('No\x20available\x20data',0xcc);if(_0xae24f7[_0x15ba6d('0x46')]===_0x15ba6d('0x75'))return null;const _0x2c60a9=_['merge'](_0xae24f7,{'name':_0xae24f7[_0x15ba6d('0x6c')]||_0xae24f7['name']||_0xaab4f3[_0x15ba6d('0x1b')],'basename':_0x50d0b4,'savename':util[_0x15ba6d('0x0')](_0x15ba6d('0x4a'),_0xae24f7[_0x15ba6d('0x1b')]||_0xaab4f3[_0x15ba6d('0x1b')],require(_0x15ba6d('0x70'))['generate'](0x4),_0xae24f7[_0x15ba6d('0x46')]||_0x15ba6d('0x6b')),'reportId':_0xaab4f3['id'],'reportType':_0x15ba6d('0x7f')});return db[_0x15ba6d('0x65')][_0x15ba6d('0x4c')](_0x2c60a9,{'raw':!![]});})['then'](function(_0x3dde48){const _0x29a854=_0x544ea8;_0xaab4f3['table']===_0x29a854('0x66')?_0x3f08d3[_0x29a854('0x67')](_0xaab4f3[_0x29a854('0x58')]+_0x29a854('0x5'),_0xae24f7[_0x29a854('0x14')],_0xae24f7['endDate']):_0x3f08d3[_0x29a854('0x67')](_0xaab4f3[_0x29a854('0x58')]+_0x29a854('0x3a'),_0xae24f7['startDate'],_0xae24f7[_0x29a854('0x5b')]);if(_0x3dde48)return logger[_0x29a854('0x51')](_0x29a854('0x3f'),_0x3f08d3[_0x29a854('0x3e')]()),require(_0x29a854('0x38'))[_0x29a854('0xc')](path[_0x29a854('0x1')](__dirname,'../../components/export/',_0x3dde48[_0x29a854('0x46')]),[_0x3dde48['id'],_0x3f08d3['toString'](),path[_0x29a854('0x1')](__dirname,_0x29a854('0x45'),_0x3dde48[_0x29a854('0x27')]),_0x50d0b4]),_0x3dde48;else{const _0x2fb3c0=squel[_0x29a854('0x64')]();return _0x2fb3c0[_0x29a854('0x60')]('('+_0x3f08d3[_0x29a854('0x3e')]()+')',_0x29a854('0x87')),_0x2fb3c0[_0x29a854('0x2e')]('COUNT(*)','count'),_0x3f08d3['limit'](_0xae24f7[_0x29a854('0x88')]||_0x1fb0e9),_0x3f08d3[_0x29a854('0x71')](_0xae24f7['offset']||0x0),dbH[_0x29a854('0x31')]['query'](_0x2fb3c0[_0x29a854('0x3e')](),{'type':dbH[_0x29a854('0x31')][_0x29a854('0x12')]['SELECT']})[_0x29a854('0x63')](function(_0x2353b7){const _0x5b2f21=_0x29a854;return!_0x2353b7[_0x5b2f21('0x23')]?_0x4b58e0=0x0:_0x4b58e0=_0x2353b7[0x0][_0x5b2f21('0x8e')]||0x0,dbH[_0x5b2f21('0x31')][_0x5b2f21('0x28')](_0x3f08d3[_0x5b2f21('0x3e')](),{'type':dbH[_0x5b2f21('0x31')][_0x5b2f21('0x12')][_0x5b2f21('0x1d')]});})[_0x29a854('0x63')](function(_0x10673a){return{'rows':_0x10673a||[],'count':_0x4b58e0};});}});}exports[_0x290121('0x80')]=function(_0x4d91e6,_0x4efc48){const _0x58324d=_0x290121;return runReport(_0x4d91e6[_0x58324d('0x7d')],_0x4d91e6[_0x58324d('0x28')],_0x4d91e6[_0x58324d('0x7e')])[_0x58324d('0x63')](respondWithResult(_0x4efc48,null))[_0x58324d('0x9')](handleError(_0x4efc48,null));},exports[_0x290121('0x8a')]=runReport,exports[_0x290121('0x28')]=function(_0x252b6e,_0x4ec2d4){const _0x1f44a3=_0x290121,_0x3288bd=0xa,_0x9697b3=['join',_0x1f44a3('0x39'),_0x1f44a3('0x79'),_0x1f44a3('0x5c')],_0x6c88db={'SUM':_0x1f44a3('0x5d'),'COUNT':_0x1f44a3('0x91'),'COUNT\x20DISTINCT':_0x1f44a3('0x1f'),'MAX':_0x1f44a3('0x19'),'MIN':_0x1f44a3('0x33'),'AVG':_0x1f44a3('0x4b'),'GROUP_CONCAT':_0x1f44a3('0xf'),'GROUP_CONCAT\x20ASC':_0x1f44a3('0x57'),'GROUP_CONCAT\x20DESC':_0x1f44a3('0x5f')},_0x1a6f96={'SEC_TO_TIME':_0x1f44a3('0xd'),'DATE':_0x1f44a3('0x5a'),'HOUR':'HOUR(%s)','ROUND':_0x1f44a3('0x10'),'UNIX_TIMESTAMP':_0x1f44a3('0x6a')},_0x24b485=function(_0x5de11f){const _0xde8046=_0x1f44a3;return!_[_0xde8046('0x17')]([_0xde8046('0x56'),_0xde8046('0x22'),_0xde8046('0x26'),_0xde8046('0x3b')],_0x5de11f);},_0xbaf686=function(_0x134e41){const _0x462f38=_0x1f44a3;if(!_0x134e41||!_0x134e41[_0x462f38('0x86')][_0x462f38('0x23')])return'';let _0x28a32a='(';for(let _0x2b8e1f=0x0;_0x2b8e1f<_0x134e41['rules'][_0x462f38('0x23')];_0x2b8e1f+=0x1){_0x2b8e1f>0x0&&(_0x28a32a+='\x20'+_0x134e41['operator']+'\x20'),_0x28a32a+=_0x134e41['rules'][_0x2b8e1f][_0x462f38('0xb')]?_0xbaf686(_0x134e41[_0x462f38('0x86')][_0x2b8e1f]['group']):_0x134e41[_0x462f38('0x86')][_0x2b8e1f]['field']+'\x20'+_0x134e41[_0x462f38('0x86')][_0x2b8e1f][_0x462f38('0x2a')]+(_0x24b485(_0x134e41['rules'][_0x2b8e1f][_0x462f38('0x2a')])?'\x20'+_0x134e41[_0x462f38('0x86')][_0x2b8e1f][_0x462f38('0xa')]:'');}return _0x28a32a+')';};let _0x11ca48={'where':{'id':_0x252b6e[_0x1f44a3('0x7d')]['id']}},_0x58abb2,_0x3b7786,_0x2b4109,_0x1e8bef;return _0x11ca48=_['merge']({},_0x11ca48,_0x252b6e['options']),db[_0x1f44a3('0x3')]['findOne'](_0x11ca48)[_0x1f44a3('0x63')](function(_0x1b6027){const _0x52df02=_0x1f44a3;if(_0x1b6027)return _0x58abb2=_0x1b6027,_0x1b6027[_0x52df02('0x16')]();return null;})[_0x1f44a3('0x63')](function(_0x3c6649){const _0x970f35=_0x1f44a3;if(_0x3c6649){if(!_0x3c6649[_0x970f35('0x23')])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x3b7786=_0x3c6649,db['AnalyticMetric'][_0x970f35('0x85')]({'raw':!![]});}return null;})[_0x1f44a3('0x63')](function(_0x1eda18){const _0x5eb7e1=_0x1f44a3;if(_0x1eda18){_0x2b4109=_['keyBy'](_0x1eda18,'id');let _0x5f2057;const _0x9ccc46=squel[_0x5eb7e1('0x64')]();_0x9ccc46['from'](_0x58abb2['table']);for(let _0x3010e5=0x0;_0x3010e5<_0x3b7786[_0x5eb7e1('0x23')];_0x3010e5+=0x1){_0x5f2057=_0x3b7786[_0x3010e5][_0x5eb7e1('0x47')]?_0x2b4109[_0x3b7786[_0x3010e5][_0x5eb7e1('0x47')]][_0x5eb7e1('0x2f')]:_0x3b7786[_0x3010e5][_0x5eb7e1('0x2e')],_0x5f2057=_0x3b7786[_0x3010e5]['function']?_[_0x5eb7e1('0x1e')](_0x6c88db[_0x3b7786[_0x3010e5]['function']],'%s',_0x5f2057):_0x5f2057,_0x5f2057=_0x3b7786[_0x3010e5][_0x5eb7e1('0x0')]?_['replace'](_0x1a6f96[_0x3b7786[_0x3010e5][_0x5eb7e1('0x0')]],'%s',_0x5f2057):_0x5f2057,_0x3b7786[_0x3010e5][_0x5eb7e1('0x8b')]&&_0x9ccc46[_0x5eb7e1('0xb')](_0x5f2057),_0x3b7786[_0x3010e5][_0x5eb7e1('0x30')]&&_0x9ccc46[_0x5eb7e1('0x42')](_0x5f2057,_0x3b7786[_0x3010e5][_0x5eb7e1('0x30')]===_0x5eb7e1('0x41')?![]:!![]),_0x9ccc46[_0x5eb7e1('0x2e')](_0x5f2057,_0x3b7786[_0x3010e5][_0x5eb7e1('0x25')]||_0x5f2057);}if(_0x58abb2[_0x5eb7e1('0x52')]){_0x58abb2['joins']=JSON[_0x5eb7e1('0x1a')](_0x58abb2[_0x5eb7e1('0x52')]);for(let _0x3cc752=0x0;_0x3cc752<_0x58abb2['joins'][_0x5eb7e1('0x23')];_0x3cc752+=0x1){_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752]['type']&&_['includes'](_0x9697b3,_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752]['type'])&&_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752][_0x5eb7e1('0x59')]&&_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752]['foreignTable']&&_0x58abb2['joins'][_0x3cc752][_0x5eb7e1('0x37')]&&_0x9ccc46[_0x58abb2['joins'][_0x3cc752][_0x5eb7e1('0x62')]](_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752]['foreignTable'],null,util[_0x5eb7e1('0x0')]('%s.%s\x20=\x20%s.%s',_0x58abb2['table'],_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752][_0x5eb7e1('0x59')],_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752]['foreignTable'],_0x58abb2[_0x5eb7e1('0x52')][_0x3cc752][_0x5eb7e1('0x37')]));}}return _0x58abb2[_0x5eb7e1('0x2b')]&&(_0x58abb2[_0x5eb7e1('0x2b')]=JSON[_0x5eb7e1('0x1a')](_0x58abb2[_0x5eb7e1('0x2b')]),_0x9ccc46[_0x5eb7e1('0x67')](_0xbaf686(_0x58abb2['conditions'][_0x5eb7e1('0xb')]))),_0x1e8bef=_0x9ccc46[_0x5eb7e1('0x61')](),_0x9ccc46['limit'](_0x3288bd),_0x9ccc46[_0x5eb7e1('0x71')](0x0),logger['debug']('Limited\x20Query:',_0x9ccc46[_0x5eb7e1('0x3e')]()),db['sequelize']['query'](_0x9ccc46[_0x5eb7e1('0x3e')](),{'type':QueryTypes[_0x5eb7e1('0x1d')]});}})[_0x1f44a3('0x63')](function(){return{'sql':_0x1e8bef['toString']()};})['then'](respondWithResult(_0x4ec2d4,null))[_0x1f44a3('0x9')](handleError(_0x4ec2d4,null));};
\ No newline at end of file
+const a5_0x3a7f=['merge','create','offset','savename','findOne','CustomReports','end','Limited\x20Query:','foreignTable','options','COUNT(*)','fields','query','order','keys','getFields','../../config/logger','path','IS\x20NOT\x20EMPTY','function','clone','stack','join','fullPath','map','web','filters','joins','Unable\x20to\x20retrieve\x20the\x20current\x20user','findAll','includeAll','custom','UNIX_TIMESTAMP(%s)','length','countTable','where','rows','startDate','toString','AnalyticMetric','params','AnalyticExtractedReport','field','groupBy','Please\x20insert\x20at\x20least\x20one\x20field','api','body','../../files/reports','MetricId','include','sequelize','send','endDate','AVG(%s)','ROUND(%s)','COUNT(%s)','catch','HOUR(%s)','.calldate\x20BETWEEN\x20?\x20AND\x20?','intersection','Reports','status','autoAssociation','AnalyticCustomReport','SELECT','then','../../mysqldb','squel','foreignKey','filter','group','../../components/export/','runReport','IS\x20NOT\x20NULL','IS\x20EMPTY','fieldName','alias','keyBy','attributes','MAX(%s)','lodash','from','model','DATE(%s)','fork','replace','error','userProfileId','count','child_process','COUNT(DISTINCT\x20%s)','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','SUM(%s)','left_join','sendStatus','DESC','debug','MIN(%s)','parentKey','info','generate','IS\x20NULL','get','Run\x20Query:','select','right_join','Content-Range','destroy','UserProfileResource','pick','%s-%s.%s','metric','.createdAt\x20BETWEEN\x20?\x20AND\x20?','format','condition','table','run','like','set','No\x20available\x20data','sort','GROUP_CONCAT(%s)','includes','nolimit','randomstring','dbH','cdr','SEC_TO_TIME(%s)','show','user','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','type','operator','output','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','conditions','cross_join','%s.%s\x20=\x20%s.%s','parse','UserProfileSection','index','name','limit','rules','orderBy','QueryTypes','value'];(function(_0x3b3c25,_0x3a7fc6){const _0x2de8ff=function(_0x4b124d){while(--_0x4b124d){_0x3b3c25['push'](_0x3b3c25['shift']());}};_0x2de8ff(++_0x3a7fc6);}(a5_0x3a7f,0x165));const a5_0x2de8=function(_0x3b3c25,_0x3a7fc6){_0x3b3c25=_0x3b3c25-0x0;let _0x2de8ff=a5_0x3a7f[_0x3b3c25];return _0x2de8ff;};const _0x398131=a5_0x2de8;'use strict';const util=require('util'),path=require(_0x398131('0x65')),_=require(_0x398131('0x11')),squel=require(_0x398131('0x4')),qs=require('../../components/parsers/qs'),logger=require(_0x398131('0x64'))(_0x398131('0x81')),db=require(_0x398131('0x3'))['db'],dbH=require(_0x398131('0x3'))[_0x398131('0x3e')],{Op,ValidationErrorItem,QueryTypes}=require(_0x398131('0x86'));function respondWithResult(_0x4b124d,_0x118e32){return _0x118e32=_0x118e32||0xc8,function(_0x57855b){const _0x32d38a=a5_0x2de8;if(_0x57855b)return _0x4b124d[_0x32d38a('0x91')](_0x118e32)['json'](_0x57855b);};}function respondWithFilteredResult(_0x1701c9,_0x4500fd){return function(_0x1b436f){const _0x30ecb2=a5_0x2de8;if(_0x1b436f){const _0x1c0202=_0x1b436f['count'],_0x3730b1=_0x4500fd['offset'];let _0x48952e=_0x4500fd[_0x30ecb2('0x56')]+_0x4500fd['limit'],_0x128499;return _0x48952e>=_0x1c0202?(_0x48952e=_0x1c0202,_0x128499=0xc8):_0x128499=0xce,_0x1701c9[_0x30ecb2('0x91')](_0x128499),_0x1701c9[_0x30ecb2('0x37')](_0x30ecb2('0x2b'),_0x3730b1+'-'+_0x48952e+'/'+_0x1c0202)['json'](_0x1b436f);}return null;};}function saveUpdates(_0x420d6c){return function(_0x346521){const _0x10c2cb=a5_0x2de8;if(_0x346521)return _0x346521['update'](_0x420d6c)[_0x10c2cb('0x2')](function(_0x1c5ccb){return _0x1c5ccb;});return null;};}function removeEntity(_0x5999b0){return function(_0x3a03e6){const _0x4c0854=a5_0x2de8;if(_0x3a03e6)return _0x3a03e6[_0x4c0854('0x2c')]()[_0x4c0854('0x2')](function(){const _0x11c45a=_0x4c0854,_0x47e136=_0x3a03e6[_0x11c45a('0x27')]({'plain':!![]}),_0x3ef04c=_0x11c45a('0x59');return db[_0x11c45a('0x2d')][_0x11c45a('0x2c')]({'where':{'type':_0x3ef04c,'resourceId':_0x47e136['id']}})['then'](function(){return _0x3a03e6;});})[_0x4c0854('0x2')](function(){const _0x5d4653=_0x4c0854;_0x5999b0['status'](0xcc)[_0x5d4653('0x5a')]();});};}function handleEntityNotFound(_0x2bee79){return function(_0x51499e){const _0xec19f7=a5_0x2de8;return!_0x51499e&&_0x2bee79[_0xec19f7('0x1f')](0x194),_0x51499e;};}function handleError(_0x302986,_0x1ee2a2){return _0x1ee2a2=_0x1ee2a2||0x1f4,function(_0x1d6723){const _0x4de988=a5_0x2de8;logger[_0x4de988('0x17')](_0x1d6723[_0x4de988('0x69')]),_0x1d6723[_0x4de988('0x4e')]&&delete _0x1d6723['name'],_0x302986[_0x4de988('0x91')](_0x1ee2a2)[_0x4de988('0x87')](_0x1d6723);};}exports[_0x398131('0x4d')]=function(_0x43ca11,_0x42b2e4){const _0x3bc14c=_0x398131;let _0x434a39={};const _0x424542={},_0x4a7c69={'count':0x0,'rows':[]},_0x1d93f4=_['map'](db[_0x3bc14c('0x0')]['rawAttributes'],function(_0x4c2164){const _0xa1866d=_0x3bc14c;return{'name':_0x4c2164[_0xa1866d('0xc')],'type':_0x4c2164[_0xa1866d('0x44')]['key']};});_0x424542[_0x3bc14c('0x13')]=_[_0x3bc14c('0x6c')](_0x1d93f4,_0x3bc14c('0x4e')),_0x424542[_0x3bc14c('0x60')]=_[_0x3bc14c('0x62')](_0x43ca11[_0x3bc14c('0x60')]),_0x424542['filters']=_[_0x3bc14c('0x8f')](_0x424542['model'],_0x424542[_0x3bc14c('0x60')]),_0x434a39[_0x3bc14c('0xf')]=_[_0x3bc14c('0x8f')](_0x424542['model'],qs[_0x3bc14c('0x5f')](_0x43ca11[_0x3bc14c('0x60')][_0x3bc14c('0x5f')])),_0x434a39[_0x3bc14c('0xf')]=_0x434a39['attributes']['length']?_0x434a39[_0x3bc14c('0xf')]:_0x424542[_0x3bc14c('0x13')];typeof _0x43ca11[_0x3bc14c('0x60')][_0x3bc14c('0x3c')]==='undefined'&&(_0x434a39[_0x3bc14c('0x4f')]=qs['limit'](_0x43ca11[_0x3bc14c('0x60')]['limit']),_0x434a39[_0x3bc14c('0x56')]=qs[_0x3bc14c('0x56')](_0x43ca11[_0x3bc14c('0x60')]['offset']));_0x434a39['order']=qs[_0x3bc14c('0x39')](_0x43ca11[_0x3bc14c('0x60')]['sort']),_0x434a39[_0x3bc14c('0x77')]=qs['filters'](_[_0x3bc14c('0x2e')](_0x43ca11[_0x3bc14c('0x60')],_0x424542[_0x3bc14c('0x6e')]),_0x1d93f4);_0x43ca11['query'][_0x3bc14c('0x6')]&&(_0x434a39['where']=_[_0x3bc14c('0x54')](_0x434a39[_0x3bc14c('0x77')],{[Op['or']]:_[_0x3bc14c('0x6c')](_0x1d93f4,function(_0x40e8a2){const _0x16b3b6=_0x3bc14c;if(_0x40e8a2[_0x16b3b6('0x44')]!=='VIRTUAL'){const _0x3d0877={};return _0x3d0877[_0x40e8a2['name']]={[Op[_0x16b3b6('0x36')]]:'%'+_0x43ca11[_0x16b3b6('0x60')][_0x16b3b6('0x6')]+'%'},_0x3d0877;}})}));_0x434a39=_['merge']({},_0x434a39,_0x43ca11['options']);const _0x572882={'where':_0x434a39['where']};return db[_0x3bc14c('0x0')]['count'](_0x572882)[_0x3bc14c('0x2')](function(_0x224635){const _0x324c34=_0x3bc14c;return _0x4a7c69[_0x324c34('0x19')]=_0x224635,_0x43ca11[_0x324c34('0x60')]['includeAll']&&(_0x434a39[_0x324c34('0x85')]=[{'all':!![]}]),db[_0x324c34('0x0')][_0x324c34('0x71')](_0x434a39);})[_0x3bc14c('0x2')](function(_0x43ad92){const _0x3d665c=_0x3bc14c;return _0x4a7c69[_0x3d665c('0x78')]=_0x43ad92,_0x4a7c69;})[_0x3bc14c('0x2')](respondWithFilteredResult(_0x42b2e4,_0x434a39))[_0x3bc14c('0x8c')](handleError(_0x42b2e4,null));},exports[_0x398131('0x41')]=function(_0x201d94,_0x442410){const _0x31c092=_0x398131;let _0x1ef71e={'raw':![],'where':{'id':_0x201d94[_0x31c092('0x7c')]['id']}};const _0x4cb57b={};return _0x4cb57b['model']=_['keys'](db[_0x31c092('0x0')]['rawAttributes']),_0x4cb57b[_0x31c092('0x60')]=_[_0x31c092('0x62')](_0x201d94['query']),_0x4cb57b[_0x31c092('0x6e')]=_['intersection'](_0x4cb57b['model'],_0x4cb57b[_0x31c092('0x60')]),_0x1ef71e['attributes']=_[_0x31c092('0x8f')](_0x4cb57b[_0x31c092('0x13')],qs['fields'](_0x201d94[_0x31c092('0x60')][_0x31c092('0x5f')])),_0x1ef71e[_0x31c092('0xf')]=_0x1ef71e[_0x31c092('0xf')][_0x31c092('0x75')]?_0x1ef71e['attributes']:_0x4cb57b[_0x31c092('0x13')],_0x201d94[_0x31c092('0x60')][_0x31c092('0x72')]&&(_0x1ef71e[_0x31c092('0x85')]=[{'all':!![]}]),_0x1ef71e=_['merge']({},_0x1ef71e,_0x201d94[_0x31c092('0x5d')]),db['AnalyticCustomReport']['findOne'](_0x1ef71e)['then'](handleEntityNotFound(_0x442410,null))['then'](respondWithResult(_0x442410,null))['catch'](handleError(_0x442410,null));},exports[_0x398131('0x55')]=function(_0x39998a,_0x1713c2){const _0x1c488e=_0x398131;return db['AnalyticCustomReport'][_0x1c488e('0x55')](_0x39998a['body'],{})[_0x1c488e('0x2')](function(_0x257516){const _0x1c2aee=_0x1c488e,_0x319f12=_0x39998a[_0x1c2aee('0x42')]['get']({'plain':!![]});if(!_0x319f12)throw new Error(_0x1c2aee('0x70'));if(_0x319f12['role']===_0x1c2aee('0x42')){const _0x3f9577=_0x257516['get']({'plain':!![]}),_0x2756a8=_0x1c2aee('0x90');return db[_0x1c2aee('0x4c')][_0x1c2aee('0x58')]({'where':{'name':_0x2756a8,'userProfileId':_0x319f12[_0x1c2aee('0x18')]},'raw':!![]})[_0x1c2aee('0x2')](function(_0x33bf7b){const _0x327391=_0x1c2aee;return _0x33bf7b&&_0x33bf7b[_0x327391('0x92')]===0x0?db[_0x327391('0x2d')][_0x327391('0x55')]({'name':_0x3f9577[_0x327391('0x4e')],'resourceId':_0x3f9577['id'],'type':_0x327391('0x59'),'sectionId':_0x33bf7b['id']},{})[_0x327391('0x2')](function(){return _0x257516;}):_0x257516;})[_0x1c2aee('0x8c')](function(_0x42e446){const _0x288ff8=_0x1c2aee;logger['error'](_0x288ff8('0x1c'),_0x42e446);throw _0x42e446;});}return _0x257516;})[_0x1c488e('0x2')](respondWithResult(_0x1713c2,0xc9))[_0x1c488e('0x8c')](handleError(_0x1713c2,null));},exports['update']=function(_0x1c5e60,_0x4ed32d){const _0x1f8904=_0x398131;return _0x1c5e60['body']['id']&&delete _0x1c5e60[_0x1f8904('0x82')]['id'],db[_0x1f8904('0x0')][_0x1f8904('0x58')]({'where':{'id':_0x1c5e60[_0x1f8904('0x7c')]['id']}})[_0x1f8904('0x2')](handleEntityNotFound(_0x4ed32d,null))[_0x1f8904('0x2')](saveUpdates(_0x1c5e60[_0x1f8904('0x82')],null))[_0x1f8904('0x2')](respondWithResult(_0x4ed32d,null))[_0x1f8904('0x8c')](handleError(_0x4ed32d,null));},exports[_0x398131('0x2c')]=function(_0x48e368,_0x4dc664){const _0x251dea=_0x398131;return db[_0x251dea('0x0')][_0x251dea('0x58')]({'where':{'id':_0x48e368[_0x251dea('0x7c')]['id']}})['then'](handleEntityNotFound(_0x4dc664,null))[_0x251dea('0x2')](removeEntity(_0x4dc664,null))[_0x251dea('0x8c')](handleError(_0x4dc664,null));},exports['preview']=function(_0x551086,_0x2d2ae6){const _0x1206cf=_0x398131,_0x261866=0xa,_0x65891d=['join',_0x1206cf('0x1e'),_0x1206cf('0x2a'),_0x1206cf('0x49')],_0x27c8af={'SUM':_0x1206cf('0x1d'),'COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0x1206cf('0x1b'),'MAX':_0x1206cf('0x10'),'MIN':'MIN(%s)','AVG':_0x1206cf('0x89'),'GROUP_CONCAT':_0x1206cf('0x3a'),'GROUP_CONCAT\x20ASC':_0x1206cf('0x43'),'GROUP_CONCAT\x20DESC':_0x1206cf('0x47')},_0x38a99d={'SEC_TO_TIME':_0x1206cf('0x40'),'DATE':_0x1206cf('0x14'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x1206cf('0x74')},_0x21bc4c=function(_0x5e0960){const _0x48b850=_0x1206cf;return!_['includes'](['IS\x20NULL',_0x48b850('0xa'),_0x48b850('0xb'),_0x48b850('0x66')],_0x5e0960);},_0x3f1751=function(_0x328fbc){const _0x1bfdc7=_0x1206cf;if(!_0x328fbc||!_0x328fbc[_0x1bfdc7('0x50')][_0x1bfdc7('0x75')])return'';let _0x4bf9c6='(';for(let _0x4c5da1=0x0;_0x4c5da1<_0x328fbc[_0x1bfdc7('0x50')][_0x1bfdc7('0x75')];_0x4c5da1+=0x1){_0x4c5da1>0x0&&(_0x4bf9c6+='\x20'+_0x328fbc[_0x1bfdc7('0x45')]+'\x20'),_0x4bf9c6+=_0x328fbc[_0x1bfdc7('0x50')][_0x4c5da1][_0x1bfdc7('0x7')]?_0x3f1751(_0x328fbc['rules'][_0x4c5da1][_0x1bfdc7('0x7')]):_0x328fbc[_0x1bfdc7('0x50')][_0x4c5da1][_0x1bfdc7('0x7e')]+'\x20'+_0x328fbc[_0x1bfdc7('0x50')][_0x4c5da1][_0x1bfdc7('0x33')]+(_0x21bc4c(_0x328fbc[_0x1bfdc7('0x50')][_0x4c5da1][_0x1bfdc7('0x33')])?'\x20'+_0x328fbc['rules'][_0x4c5da1][_0x1bfdc7('0x53')]:'');}return _0x4bf9c6+')';};let _0x5b005e={'where':{'id':_0x551086[_0x1206cf('0x7c')]['id']}},_0x266391,_0x2d8eb7,_0x1dfee2;return _0x5b005e=_['merge']({},_0x5b005e,_0x551086[_0x1206cf('0x5d')]),db['AnalyticCustomReport'][_0x1206cf('0x58')](_0x5b005e)['then'](function(_0x256183){const _0x1cdb1a=_0x1206cf;if(_0x256183)return _0x266391=_0x256183,_0x256183[_0x1cdb1a('0x63')]();return null;})[_0x1206cf('0x2')](function(_0x71aebd){const _0x2dded3=_0x1206cf;if(_0x71aebd){if(!_0x71aebd['length'])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x2d8eb7=_0x71aebd,db[_0x2dded3('0x7b')][_0x2dded3('0x71')]({'raw':!![]});}return null;})[_0x1206cf('0x2')](function(_0x27f9a4){const _0xe36e65=_0x1206cf;if(_0x27f9a4){_0x1dfee2=_[_0xe36e65('0xe')](_0x27f9a4,'id');let _0x43051c;const _0x23c10b=squel[_0xe36e65('0x29')]();_0x23c10b[_0xe36e65('0x12')](_0x266391[_0xe36e65('0x34')]);for(let _0x10f9e9=0x0;_0x10f9e9<_0x2d8eb7[_0xe36e65('0x75')];_0x10f9e9+=0x1){_0x43051c=_0x2d8eb7[_0x10f9e9][_0xe36e65('0x84')]?_0x1dfee2[_0x2d8eb7[_0x10f9e9][_0xe36e65('0x84')]][_0xe36e65('0x30')]:_0x2d8eb7[_0x10f9e9]['field'],_0x43051c=_0x2d8eb7[_0x10f9e9][_0xe36e65('0x67')]?_[_0xe36e65('0x16')](_0x27c8af[_0x2d8eb7[_0x10f9e9]['function']],'%s',_0x43051c):_0x43051c,_0x43051c=_0x2d8eb7[_0x10f9e9][_0xe36e65('0x32')]?_[_0xe36e65('0x16')](_0x38a99d[_0x2d8eb7[_0x10f9e9][_0xe36e65('0x32')]],'%s',_0x43051c):_0x43051c,_0x2d8eb7[_0x10f9e9][_0xe36e65('0x7f')]&&_0x23c10b[_0xe36e65('0x7')](_0x43051c),_0x2d8eb7[_0x10f9e9][_0xe36e65('0x51')]&&_0x23c10b[_0xe36e65('0x61')](_0x43051c,_0x2d8eb7[_0x10f9e9][_0xe36e65('0x51')]===_0xe36e65('0x20')?![]:!![]),_0x23c10b[_0xe36e65('0x7e')](_0x43051c,_0x2d8eb7[_0x10f9e9][_0xe36e65('0xd')]||_0x43051c);}if(_0x266391['joins']){_0x266391[_0xe36e65('0x6f')]=JSON['parse'](_0x266391[_0xe36e65('0x6f')]);for(let _0x4f6ad1=0x0;_0x4f6ad1<_0x266391['joins'][_0xe36e65('0x75')];_0x4f6ad1+=0x1){_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x44')]&&_[_0xe36e65('0x3b')](_0x65891d,_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x44')])&&_0x266391['joins'][_0x4f6ad1][_0xe36e65('0x23')]&&_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x5c')]&&_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x5')]&&_0x23c10b[_0x266391['joins'][_0x4f6ad1][_0xe36e65('0x44')]](_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x5c')],null,util[_0xe36e65('0x32')]('%s.%s\x20=\x20%s.%s',_0x266391[_0xe36e65('0x34')],_0x266391[_0xe36e65('0x6f')][_0x4f6ad1]['parentKey'],_0x266391['joins'][_0x4f6ad1][_0xe36e65('0x5c')],_0x266391[_0xe36e65('0x6f')][_0x4f6ad1][_0xe36e65('0x5')]));}}return _0x266391['conditions']&&(_0x266391[_0xe36e65('0x48')]=JSON[_0xe36e65('0x4b')](_0x266391['conditions']),_0x23c10b[_0xe36e65('0x77')](_0x3f1751(_0x266391[_0xe36e65('0x48')][_0xe36e65('0x7')]))),_0x23c10b[_0xe36e65('0x4f')](_0x261866),_0x23c10b['offset'](0x0),logger[_0xe36e65('0x21')](_0xe36e65('0x5b'),_0x23c10b[_0xe36e65('0x7a')]()),db[_0xe36e65('0x86')][_0xe36e65('0x60')](_0x23c10b[_0xe36e65('0x7a')](),{'type':QueryTypes['SELECT']});}})[_0x1206cf('0x2')](respondWithResult(_0x2d2ae6,null))[_0x1206cf('0x8c')](handleError(_0x2d2ae6,null));};function runReport(_0x40cc30,_0x29bcae,_0x42f7bc){const _0x4899fb=_0x398131,_0x56c4ac=_0x29bcae['name'],_0x25c479=0xa,_0x40bb7f=[_0x4899fb('0x6a'),_0x4899fb('0x1e'),_0x4899fb('0x2a'),_0x4899fb('0x49')],_0x42960d={'SUM':_0x4899fb('0x1d'),'COUNT':_0x4899fb('0x8b'),'COUNT\x20DISTINCT':_0x4899fb('0x1b'),'MAX':_0x4899fb('0x10'),'MIN':_0x4899fb('0x22'),'AVG':_0x4899fb('0x89'),'GROUP_CONCAT':_0x4899fb('0x3a'),'GROUP_CONCAT\x20ASC':_0x4899fb('0x43'),'GROUP_CONCAT\x20DESC':_0x4899fb('0x47')},_0x860d44={'SEC_TO_TIME':_0x4899fb('0x40'),'DATE':_0x4899fb('0x14'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x4899fb('0x74')},_0x4e08d3=function(_0x165b01){const _0x47bf0b=_0x4899fb;return!_[_0x47bf0b('0x3b')]([_0x47bf0b('0x26'),_0x47bf0b('0xa'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x165b01);},_0x10aaa7=function(_0xb7ef8){const _0x6d15f=_0x4899fb;if(!_0xb7ef8||!_0xb7ef8[_0x6d15f('0x50')][_0x6d15f('0x75')])return'';let _0x46db47='(';for(let _0x562e43=0x0;_0x562e43<_0xb7ef8[_0x6d15f('0x50')][_0x6d15f('0x75')];_0x562e43+=0x1){_0x562e43>0x0&&(_0x46db47+='\x20'+_0xb7ef8[_0x6d15f('0x45')]+'\x20'),_0x46db47+=_0xb7ef8[_0x6d15f('0x50')][_0x562e43]['group']?_0x10aaa7(_0xb7ef8[_0x6d15f('0x50')][_0x562e43][_0x6d15f('0x7')]):_0xb7ef8[_0x6d15f('0x50')][_0x562e43][_0x6d15f('0x7e')]+'\x20'+_0xb7ef8[_0x6d15f('0x50')][_0x562e43][_0x6d15f('0x33')]+(_0x4e08d3(_0xb7ef8[_0x6d15f('0x50')][_0x562e43][_0x6d15f('0x33')])?'\x20'+_0xb7ef8[_0x6d15f('0x50')][_0x562e43]['value']:'');}return _0x46db47+')';};let _0x1fc5e3={'where':{'id':_0x40cc30['id']}},_0x1084d5,_0x6f808c,_0x481d4e,_0x2e822b,_0x437f19;return _0x1fc5e3=_[_0x4899fb('0x54')]({},_0x1fc5e3,_0x42f7bc),db['AnalyticCustomReport'][_0x4899fb('0x58')](_0x1fc5e3)[_0x4899fb('0x2')](function(_0x11f2f4){const _0x2e1e08=_0x4899fb;if(_0x11f2f4)return _0x1084d5=_0x11f2f4,_0x11f2f4[_0x2e1e08('0x63')]();return null;})[_0x4899fb('0x2')](function(_0xb43480){const _0x2ad8a8=_0x4899fb;if(_0xb43480){if(!_0xb43480[_0x2ad8a8('0x75')])throw new ValidationErrorItem(_0x2ad8a8('0x80'),0x193);return _0x6f808c=_0xb43480,db[_0x2ad8a8('0x7b')][_0x2ad8a8('0x71')]({'raw':!![]});}return null;})['then'](function(_0x21eaff){const _0x3a8fdb=_0x4899fb;if(_0x21eaff){_0x481d4e=_['keyBy'](_0x21eaff,'id');let _0x3b2ca3;const _0x2dc6c7=squel[_0x3a8fdb('0x29')]();_0x2dc6c7[_0x3a8fdb('0x12')](_0x1084d5['table']);for(let _0x2e584b=0x0;_0x2e584b<_0x6f808c[_0x3a8fdb('0x75')];_0x2e584b+=0x1){_0x3b2ca3=_0x6f808c[_0x2e584b][_0x3a8fdb('0x84')]?_0x481d4e[_0x6f808c[_0x2e584b]['MetricId']][_0x3a8fdb('0x30')]:_0x6f808c[_0x2e584b][_0x3a8fdb('0x7e')],_0x3b2ca3=_0x6f808c[_0x2e584b][_0x3a8fdb('0x67')]?_[_0x3a8fdb('0x16')](_0x42960d[_0x6f808c[_0x2e584b][_0x3a8fdb('0x67')]],'%s',_0x3b2ca3):_0x3b2ca3,_0x3b2ca3=_0x6f808c[_0x2e584b]['format']?_[_0x3a8fdb('0x16')](_0x860d44[_0x6f808c[_0x2e584b][_0x3a8fdb('0x32')]],'%s',_0x3b2ca3):_0x3b2ca3,_0x6f808c[_0x2e584b][_0x3a8fdb('0x7f')]&&_0x2dc6c7['group'](_0x3b2ca3),_0x6f808c[_0x2e584b][_0x3a8fdb('0x51')]&&_0x2dc6c7[_0x3a8fdb('0x61')](_0x3b2ca3,_0x6f808c[_0x2e584b]['orderBy']===_0x3a8fdb('0x20')?![]:!![]),_0x2dc6c7[_0x3a8fdb('0x7e')](_0x3b2ca3,_0x6f808c[_0x2e584b][_0x3a8fdb('0xd')]||_0x3b2ca3);}if(_0x1084d5[_0x3a8fdb('0x6f')]){_0x1084d5[_0x3a8fdb('0x6f')]=JSON[_0x3a8fdb('0x4b')](_0x1084d5[_0x3a8fdb('0x6f')]);for(let _0x35cd3b=0x0;_0x35cd3b<_0x1084d5['joins'][_0x3a8fdb('0x75')];_0x35cd3b+=0x1){_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b][_0x3a8fdb('0x44')]&&_[_0x3a8fdb('0x3b')](_0x40bb7f,_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b][_0x3a8fdb('0x44')])&&_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b]['parentKey']&&_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b][_0x3a8fdb('0x5c')]&&_0x1084d5['joins'][_0x35cd3b][_0x3a8fdb('0x5')]&&_0x2dc6c7[_0x1084d5['joins'][_0x35cd3b][_0x3a8fdb('0x44')]](_0x1084d5['joins'][_0x35cd3b]['foreignTable'],null,util[_0x3a8fdb('0x32')](_0x3a8fdb('0x4a'),_0x1084d5[_0x3a8fdb('0x34')],_0x1084d5['joins'][_0x35cd3b][_0x3a8fdb('0x23')],_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b][_0x3a8fdb('0x5c')],_0x1084d5[_0x3a8fdb('0x6f')][_0x35cd3b][_0x3a8fdb('0x5')]));}}return _0x1084d5[_0x3a8fdb('0x48')]&&(_0x1084d5[_0x3a8fdb('0x48')]=JSON[_0x3a8fdb('0x4b')](_0x1084d5[_0x3a8fdb('0x48')]),_0x2dc6c7[_0x3a8fdb('0x77')](_0x10aaa7(_0x1084d5[_0x3a8fdb('0x48')][_0x3a8fdb('0x7')]))),_0x437f19=_0x2dc6c7[_0x3a8fdb('0x68')](),_0x2dc6c7[_0x3a8fdb('0x4f')](_0x25c479),_0x2dc6c7[_0x3a8fdb('0x56')](0x0),logger[_0x3a8fdb('0x21')](_0x3a8fdb('0x5b'),_0x2dc6c7['toString']()),db['sequelize'][_0x3a8fdb('0x60')](_0x2dc6c7[_0x3a8fdb('0x7a')](),{'type':QueryTypes['SELECT']});}})[_0x4899fb('0x2')](function(_0x138ba8){const _0x153e5a=_0x4899fb;if(!_0x138ba8[_0x153e5a('0x75')])throw new ValidationErrorItem(_0x153e5a('0x38'),0xcc);if(_0x29bcae[_0x153e5a('0x46')]===_0x153e5a('0x6d'))return null;const _0x4873f1=_[_0x153e5a('0x54')](_0x29bcae,{'name':_0x29bcae[_0x153e5a('0x6b')]||_0x29bcae[_0x153e5a('0x4e')]||_0x1084d5[_0x153e5a('0x4e')],'basename':_0x56c4ac,'savename':util['format'](_0x153e5a('0x2f'),_0x29bcae[_0x153e5a('0x4e')]||_0x1084d5[_0x153e5a('0x4e')],require(_0x153e5a('0x3d'))[_0x153e5a('0x25')](0x4),_0x29bcae['output']||'csv'),'reportId':_0x1084d5['id'],'reportType':_0x153e5a('0x73')});return db[_0x153e5a('0x7d')][_0x153e5a('0x55')](_0x4873f1,{'raw':!![]});})['then'](function(_0x4f4be1){const _0x4b0888=_0x4899fb;_0x1084d5[_0x4b0888('0x34')]===_0x4b0888('0x3f')?_0x437f19[_0x4b0888('0x77')](_0x1084d5['table']+_0x4b0888('0x8e'),_0x29bcae[_0x4b0888('0x79')],_0x29bcae[_0x4b0888('0x88')]):_0x437f19[_0x4b0888('0x77')](_0x1084d5[_0x4b0888('0x34')]+_0x4b0888('0x31'),_0x29bcae[_0x4b0888('0x79')],_0x29bcae[_0x4b0888('0x88')]);if(_0x4f4be1)return logger[_0x4b0888('0x24')](_0x4b0888('0x28'),_0x437f19[_0x4b0888('0x7a')]()),require(_0x4b0888('0x1a'))[_0x4b0888('0x15')](path['join'](__dirname,_0x4b0888('0x8'),_0x4f4be1[_0x4b0888('0x46')]),[_0x4f4be1['id'],_0x437f19[_0x4b0888('0x7a')](),path[_0x4b0888('0x6a')](__dirname,_0x4b0888('0x83'),_0x4f4be1[_0x4b0888('0x57')]),_0x56c4ac]),_0x4f4be1;else{const _0x37aaec=squel[_0x4b0888('0x29')]();return _0x37aaec[_0x4b0888('0x12')]('('+_0x437f19['toString']()+')',_0x4b0888('0x76')),_0x37aaec[_0x4b0888('0x7e')](_0x4b0888('0x5e'),_0x4b0888('0x19')),_0x437f19[_0x4b0888('0x4f')](_0x29bcae['limit']||_0x25c479),_0x437f19[_0x4b0888('0x56')](_0x29bcae[_0x4b0888('0x56')]||0x0),dbH[_0x4b0888('0x86')][_0x4b0888('0x60')](_0x37aaec['toString'](),{'type':dbH[_0x4b0888('0x86')][_0x4b0888('0x52')][_0x4b0888('0x1')]})[_0x4b0888('0x2')](function(_0x57c474){const _0x79a83b=_0x4b0888;return!_0x57c474['length']?_0x2e822b=0x0:_0x2e822b=_0x57c474[0x0][_0x79a83b('0x19')]||0x0,dbH[_0x79a83b('0x86')][_0x79a83b('0x60')](_0x437f19[_0x79a83b('0x7a')](),{'type':dbH[_0x79a83b('0x86')][_0x79a83b('0x52')][_0x79a83b('0x1')]});})[_0x4b0888('0x2')](function(_0x3627c7){return{'rows':_0x3627c7||[],'count':_0x2e822b};});}});}exports[_0x398131('0x35')]=function(_0x403438,_0x37f545){const _0x5c5bd2=_0x398131;return runReport(_0x403438[_0x5c5bd2('0x7c')],_0x403438[_0x5c5bd2('0x60')],_0x403438[_0x5c5bd2('0x5d')])[_0x5c5bd2('0x2')](respondWithResult(_0x37f545,null))[_0x5c5bd2('0x8c')](handleError(_0x37f545,null));},exports[_0x398131('0x9')]=runReport,exports['query']=function(_0x2564d1,_0x4ae095){const _0x502168=_0x398131,_0xb43b7a=0xa,_0x194ffb=[_0x502168('0x6a'),_0x502168('0x1e'),_0x502168('0x2a'),'cross_join'],_0x4ccbed={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0x502168('0x1b'),'MAX':'MAX(%s)','MIN':_0x502168('0x22'),'AVG':_0x502168('0x89'),'GROUP_CONCAT':_0x502168('0x3a'),'GROUP_CONCAT\x20ASC':_0x502168('0x43'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0x530803={'SEC_TO_TIME':_0x502168('0x40'),'DATE':'DATE(%s)','HOUR':_0x502168('0x8d'),'ROUND':_0x502168('0x8a'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'},_0xe95398=function(_0x1901f5){const _0x5ee77b=_0x502168;return!_[_0x5ee77b('0x3b')]([_0x5ee77b('0x26'),_0x5ee77b('0xa'),_0x5ee77b('0xb'),'IS\x20NOT\x20EMPTY'],_0x1901f5);},_0x555ac5=function(_0x2b2c53){const _0x36d3a5=_0x502168;if(!_0x2b2c53||!_0x2b2c53[_0x36d3a5('0x50')][_0x36d3a5('0x75')])return'';let _0x33df2b='(';for(let _0x608de1=0x0;_0x608de1<_0x2b2c53[_0x36d3a5('0x50')][_0x36d3a5('0x75')];_0x608de1+=0x1){_0x608de1>0x0&&(_0x33df2b+='\x20'+_0x2b2c53[_0x36d3a5('0x45')]+'\x20'),_0x33df2b+=_0x2b2c53[_0x36d3a5('0x50')][_0x608de1][_0x36d3a5('0x7')]?_0x555ac5(_0x2b2c53[_0x36d3a5('0x50')][_0x608de1][_0x36d3a5('0x7')]):_0x2b2c53[_0x36d3a5('0x50')][_0x608de1][_0x36d3a5('0x7e')]+'\x20'+_0x2b2c53[_0x36d3a5('0x50')][_0x608de1][_0x36d3a5('0x33')]+(_0xe95398(_0x2b2c53['rules'][_0x608de1][_0x36d3a5('0x33')])?'\x20'+_0x2b2c53[_0x36d3a5('0x50')][_0x608de1][_0x36d3a5('0x53')]:'');}return _0x33df2b+')';};let _0xa7f69b={'where':{'id':_0x2564d1[_0x502168('0x7c')]['id']}},_0x4afa24,_0x40df34,_0x37ab3c,_0x474f4e;return _0xa7f69b=_[_0x502168('0x54')]({},_0xa7f69b,_0x2564d1['options']),db['AnalyticCustomReport'][_0x502168('0x58')](_0xa7f69b)[_0x502168('0x2')](function(_0x660f3b){if(_0x660f3b)return _0x4afa24=_0x660f3b,_0x660f3b['getFields']();return null;})['then'](function(_0x1a848c){const _0x39a7a0=_0x502168;if(_0x1a848c){if(!_0x1a848c[_0x39a7a0('0x75')])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x40df34=_0x1a848c,db[_0x39a7a0('0x7b')][_0x39a7a0('0x71')]({'raw':!![]});}return null;})['then'](function(_0x36fefd){const _0x3bee23=_0x502168;if(_0x36fefd){_0x37ab3c=_['keyBy'](_0x36fefd,'id');let _0x43e5de;const _0x20a9b1=squel[_0x3bee23('0x29')]();_0x20a9b1['from'](_0x4afa24[_0x3bee23('0x34')]);for(let _0x483bbf=0x0;_0x483bbf<_0x40df34['length'];_0x483bbf+=0x1){_0x43e5de=_0x40df34[_0x483bbf][_0x3bee23('0x84')]?_0x37ab3c[_0x40df34[_0x483bbf]['MetricId']][_0x3bee23('0x30')]:_0x40df34[_0x483bbf][_0x3bee23('0x7e')],_0x43e5de=_0x40df34[_0x483bbf][_0x3bee23('0x67')]?_[_0x3bee23('0x16')](_0x4ccbed[_0x40df34[_0x483bbf][_0x3bee23('0x67')]],'%s',_0x43e5de):_0x43e5de,_0x43e5de=_0x40df34[_0x483bbf][_0x3bee23('0x32')]?_[_0x3bee23('0x16')](_0x530803[_0x40df34[_0x483bbf][_0x3bee23('0x32')]],'%s',_0x43e5de):_0x43e5de,_0x40df34[_0x483bbf][_0x3bee23('0x7f')]&&_0x20a9b1[_0x3bee23('0x7')](_0x43e5de),_0x40df34[_0x483bbf][_0x3bee23('0x51')]&&_0x20a9b1[_0x3bee23('0x61')](_0x43e5de,_0x40df34[_0x483bbf]['orderBy']==='DESC'?![]:!![]),_0x20a9b1[_0x3bee23('0x7e')](_0x43e5de,_0x40df34[_0x483bbf]['alias']||_0x43e5de);}if(_0x4afa24[_0x3bee23('0x6f')]){_0x4afa24[_0x3bee23('0x6f')]=JSON['parse'](_0x4afa24[_0x3bee23('0x6f')]);for(let _0x197837=0x0;_0x197837<_0x4afa24[_0x3bee23('0x6f')][_0x3bee23('0x75')];_0x197837+=0x1){_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x44')]&&_[_0x3bee23('0x3b')](_0x194ffb,_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x44')])&&_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x23')]&&_0x4afa24[_0x3bee23('0x6f')][_0x197837]['foreignTable']&&_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x5')]&&_0x20a9b1[_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x44')]](_0x4afa24['joins'][_0x197837][_0x3bee23('0x5c')],null,util[_0x3bee23('0x32')](_0x3bee23('0x4a'),_0x4afa24['table'],_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x23')],_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x5c')],_0x4afa24[_0x3bee23('0x6f')][_0x197837][_0x3bee23('0x5')]));}}return _0x4afa24[_0x3bee23('0x48')]&&(_0x4afa24[_0x3bee23('0x48')]=JSON[_0x3bee23('0x4b')](_0x4afa24[_0x3bee23('0x48')]),_0x20a9b1['where'](_0x555ac5(_0x4afa24[_0x3bee23('0x48')][_0x3bee23('0x7')]))),_0x474f4e=_0x20a9b1['clone'](),_0x20a9b1[_0x3bee23('0x4f')](_0xb43b7a),_0x20a9b1['offset'](0x0),logger[_0x3bee23('0x21')](_0x3bee23('0x5b'),_0x20a9b1[_0x3bee23('0x7a')]()),db[_0x3bee23('0x86')][_0x3bee23('0x60')](_0x20a9b1['toString'](),{'type':QueryTypes[_0x3bee23('0x1')]});}})['then'](function(){const _0x42fd3b=_0x502168;return{'sql':_0x474f4e[_0x42fd3b('0x7a')]()};})[_0x502168('0x2')](respondWithResult(_0x4ae095,null))[_0x502168('0x8c')](handleError(_0x4ae095,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff