1 const a9_0x4e0a=['merge','csv','fork','from','AnalyticMetric','offset','run','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','metric','field','Run\x20Query:','generate','.calldate\x20BETWEEN\x20?\x20AND\x20?','then','findOne','value','create','COUNT(DISTINCT\x20%s)','options','condition','filters','status','group','IS\x20NOT\x20NULL','UserProfileResource','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','destroy','api','set','countTable','filter','MAX(%s)','end','DESC','body','orderBy','default','IS\x20EMPTY','joins','function','keyBy','IS\x20NOT\x20EMPTY','rawAttributes','length','fields','attributes','type','format','lodash','info','map','rules','alias','rows','../../components/export/','sequelize','left_join','stack','foreignKey','select','DATE(%s)','error','child_process','groupBy','pick','like','runReport','web','intersection','clone','IS\x20NULL','debug','COUNT(%s)','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','UserProfileSection','MetricId','getFields','HOUR(%s)','includeAll','../../mysqldb','limit','undefined','send','UNIX_TIMESTAMP(%s)','query','right_join','output','GROUP_CONCAT(%s)','model','Reports','endDate','VIRTUAL','parse','sort','nolimit','ROUND(%s)','AVG(%s)','parentKey','findAll','table','foreignTable','where','count','dbH','catch','../../files/reports','Limited\x20Query:','name','replace','user','join','include','startDate','includes','MIN(%s)','cross_join','params','squel','operator','%s.%s\x20=\x20%s.%s','SELECT','randomstring','%s-%s.%s','order','Please\x20insert\x20at\x20least\x20one\x20field','conditions','json','get','toString','sendStatus','QueryTypes','SUM(%s)','COUNT(*)','keys','AnalyticDefaultReport','DefaultReports','SEC_TO_TIME(%s)','update','key'];(function(_0x26ffb1,_0x4e0ae2){const _0x33274a=function(_0x294a8c){while(--_0x294a8c){_0x26ffb1['push'](_0x26ffb1['shift']());}};_0x33274a(++_0x4e0ae2);}(a9_0x4e0a,0x72));const a9_0x3327=function(_0x26ffb1,_0x4e0ae2){_0x26ffb1=_0x26ffb1-0x0;let _0x33274a=a9_0x4e0a[_0x26ffb1];return _0x33274a;};const _0x58bb68=a9_0x3327;'use strict';const util=require('util'),path=require('path'),_=require(_0x58bb68('0x49')),squel=require(_0x58bb68('0x3')),qs=require('../../components/parsers/qs'),logger=require('../../config/logger')(_0x58bb68('0x34')),db=require(_0x58bb68('0x68'))['db'],dbH=require(_0x58bb68('0x68'))[_0x58bb68('0x80')],{Op,ValidationErrorItem,QueryTypes}=require(_0x58bb68('0x50'));function respondWithResult(_0x294a8c,_0x64a2d7){return _0x64a2d7=_0x64a2d7||0xc8,function(_0x36bcea){if(_0x36bcea)return _0x294a8c['status'](_0x64a2d7)['json'](_0x36bcea);};}function respondWithFilteredResult(_0x5aed4c,_0xc78f77){return function(_0x5a9369){const _0x350784=a9_0x3327;if(_0x5a9369){const _0x8d03d=_0x5a9369[_0x350784('0x7f')],_0x3e9c1f=_0xc78f77[_0x350784('0x1e')];let _0x303a86=_0xc78f77['offset']+_0xc78f77[_0x350784('0x69')],_0x58eaa6;return _0x303a86>=_0x8d03d?(_0x303a86=_0x8d03d,_0x58eaa6=0xc8):_0x58eaa6=0xce,_0x5aed4c['status'](_0x58eaa6),_0x5aed4c[_0x350784('0x35')]('Content-Range',_0x3e9c1f+'-'+_0x303a86+'/'+_0x8d03d)[_0x350784('0xc')](_0x5a9369);}return null;};}function saveUpdates(_0x50b476){return function(_0x3bff1b){const _0x338e3d=a9_0x3327;if(_0x3bff1b)return _0x3bff1b[_0x338e3d('0x17')](_0x50b476)[_0x338e3d('0x26')](function(_0x449c1a){return _0x449c1a;});return null;};}function removeEntity(_0x495712){return function(_0x1444f7){const _0x246f29=a9_0x3327;if(_0x1444f7)return _0x1444f7[_0x246f29('0x33')]()['then'](function(){const _0x114226=_0x246f29,_0x203275=_0x1444f7[_0x114226('0xd')]({'plain':!![]}),_0x171f8a='DefaultReports';return db[_0x114226('0x31')]['destroy']({'where':{'type':_0x171f8a,'resourceId':_0x203275['id']}})[_0x114226('0x26')](function(){return _0x1444f7;});})[_0x246f29('0x26')](function(){const _0x1c8565=_0x246f29;_0x495712[_0x1c8565('0x2e')](0xcc)[_0x1c8565('0x39')]();});};}function handleEntityNotFound(_0x23e765){return function(_0x48d32c){const _0x874cee=a9_0x3327;return!_0x48d32c&&_0x23e765[_0x874cee('0xf')](0x194),_0x48d32c;};}function handleError(_0x23e14b,_0x5ec063){return _0x5ec063=_0x5ec063||0x1f4,function(_0x539b90){const _0x288ce4=a9_0x3327;logger[_0x288ce4('0x56')](_0x539b90[_0x288ce4('0x52')]),_0x539b90['name']&&delete _0x539b90[_0x288ce4('0x84')],_0x23e14b[_0x288ce4('0x2e')](_0x5ec063)[_0x288ce4('0x6b')](_0x539b90);};}exports['index']=function(_0x4ef437,_0x4267ad){const _0x15b293=_0x58bb68;let _0x55356d={};const _0x5b8421={},_0x12c2d8={'count':0x0,'rows':[]},_0x4ffd54=_[_0x15b293('0x4b')](db[_0x15b293('0x14')][_0x15b293('0x43')],function(_0x4e698c){const _0xc6bef3=_0x15b293;return{'name':_0x4e698c['fieldName'],'type':_0x4e698c[_0xc6bef3('0x47')][_0xc6bef3('0x18')]};});_0x5b8421['model']=_[_0x15b293('0x4b')](_0x4ffd54,_0x15b293('0x84')),_0x5b8421['query']=_['keys'](_0x4ef437['query']),_0x5b8421[_0x15b293('0x2d')]=_[_0x15b293('0x5d')](_0x5b8421[_0x15b293('0x71')],_0x5b8421[_0x15b293('0x6d')]),_0x55356d[_0x15b293('0x46')]=_[_0x15b293('0x5d')](_0x5b8421['model'],qs[_0x15b293('0x45')](_0x4ef437['query'][_0x15b293('0x45')])),_0x55356d[_0x15b293('0x46')]=_0x55356d[_0x15b293('0x46')][_0x15b293('0x44')]?_0x55356d[_0x15b293('0x46')]:_0x5b8421[_0x15b293('0x71')];typeof _0x4ef437[_0x15b293('0x6d')][_0x15b293('0x77')]===_0x15b293('0x6a')&&(_0x55356d[_0x15b293('0x69')]=qs[_0x15b293('0x69')](_0x4ef437[_0x15b293('0x6d')]['limit']),_0x55356d[_0x15b293('0x1e')]=qs[_0x15b293('0x1e')](_0x4ef437[_0x15b293('0x6d')][_0x15b293('0x1e')]));_0x55356d[_0x15b293('0x9')]=qs[_0x15b293('0x76')](_0x4ef437[_0x15b293('0x6d')][_0x15b293('0x76')]),_0x55356d['where']=qs[_0x15b293('0x2d')](_[_0x15b293('0x59')](_0x4ef437[_0x15b293('0x6d')],_0x5b8421[_0x15b293('0x2d')]),_0x4ffd54);_0x4ef437[_0x15b293('0x6d')][_0x15b293('0x37')]&&(_0x55356d[_0x15b293('0x7e')]=_['merge'](_0x55356d[_0x15b293('0x7e')],{[Op['or']]:_[_0x15b293('0x4b')](_0x4ffd54,function(_0x5982ab){const _0x5c8138=_0x15b293;if(_0x5982ab[_0x5c8138('0x47')]!==_0x5c8138('0x74')){const _0x14b7b8={};return _0x14b7b8[_0x5982ab['name']]={[Op[_0x5c8138('0x5a')]]:'%'+_0x4ef437[_0x5c8138('0x6d')][_0x5c8138('0x37')]+'%'},_0x14b7b8;}})}));_0x55356d=_[_0x15b293('0x19')]({},_0x55356d,_0x4ef437[_0x15b293('0x2b')]);const _0x3ba981={'where':_0x55356d[_0x15b293('0x7e')]};return db['AnalyticDefaultReport']['count'](_0x3ba981)[_0x15b293('0x26')](function(_0x4b1010){const _0x5c8cec=_0x15b293;return _0x12c2d8[_0x5c8cec('0x7f')]=_0x4b1010,_0x4ef437[_0x5c8cec('0x6d')][_0x5c8cec('0x67')]&&(_0x55356d['include']=[{'all':!![]}]),db[_0x5c8cec('0x14')][_0x5c8cec('0x7b')](_0x55356d);})[_0x15b293('0x26')](function(_0x12dc70){const _0x19890f=_0x15b293;return _0x12c2d8[_0x19890f('0x4e')]=_0x12dc70,_0x12c2d8;})[_0x15b293('0x26')](respondWithFilteredResult(_0x4267ad,_0x55356d))[_0x15b293('0x81')](handleError(_0x4267ad,null));},exports['show']=function(_0x5ca57d,_0x20cfe7){const _0x5546c2=_0x58bb68;let _0x23a8eb={'raw':!![],'where':{'id':_0x5ca57d[_0x5546c2('0x2')]['id']}};const _0x57d908={};return _0x57d908[_0x5546c2('0x71')]=_[_0x5546c2('0x13')](db['AnalyticDefaultReport'][_0x5546c2('0x43')]),_0x57d908[_0x5546c2('0x6d')]=_[_0x5546c2('0x13')](_0x5ca57d[_0x5546c2('0x6d')]),_0x57d908[_0x5546c2('0x2d')]=_[_0x5546c2('0x5d')](_0x57d908['model'],_0x57d908[_0x5546c2('0x6d')]),_0x23a8eb[_0x5546c2('0x46')]=_[_0x5546c2('0x5d')](_0x57d908['model'],qs[_0x5546c2('0x45')](_0x5ca57d[_0x5546c2('0x6d')][_0x5546c2('0x45')])),_0x23a8eb[_0x5546c2('0x46')]=_0x23a8eb['attributes']['length']?_0x23a8eb['attributes']:_0x57d908[_0x5546c2('0x71')],_0x5ca57d['query'][_0x5546c2('0x67')]&&(_0x23a8eb[_0x5546c2('0x88')]=[{'all':!![]}]),_0x23a8eb=_[_0x5546c2('0x19')]({},_0x23a8eb,_0x5ca57d[_0x5546c2('0x2b')]),db['AnalyticDefaultReport'][_0x5546c2('0x27')](_0x23a8eb)[_0x5546c2('0x26')](handleEntityNotFound(_0x20cfe7,null))['then'](respondWithResult(_0x20cfe7,null))[_0x5546c2('0x81')](handleError(_0x20cfe7,null));},exports[_0x58bb68('0x29')]=function(_0x42bf9c,_0x405cd0){const _0x455038=_0x58bb68;return db[_0x455038('0x14')][_0x455038('0x29')](_0x42bf9c['body'],{})[_0x455038('0x26')](function(_0x109210){const _0x401a70=_0x455038,_0x147cbe=_0x42bf9c['user'][_0x401a70('0xd')]({'plain':!![]});if(!_0x147cbe)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x147cbe['role']===_0x401a70('0x86')){const _0x55f3e8=_0x109210[_0x401a70('0xd')]({'plain':!![]}),_0x56da6c=_0x401a70('0x72');return db[_0x401a70('0x63')]['findOne']({'where':{'name':_0x56da6c,'userProfileId':_0x147cbe['userProfileId']},'raw':!![]})[_0x401a70('0x26')](function(_0x263c1f){const _0x19f15a=_0x401a70;return _0x263c1f&&_0x263c1f['autoAssociation']===0x0?db[_0x19f15a('0x31')][_0x19f15a('0x29')]({'name':_0x55f3e8['name'],'resourceId':_0x55f3e8['id'],'type':_0x19f15a('0x15'),'sectionId':_0x263c1f['id']},{})[_0x19f15a('0x26')](function(){return _0x109210;}):_0x109210;})[_0x401a70('0x81')](function(_0x38066e){const _0x5c8195=_0x401a70;logger[_0x5c8195('0x56')](_0x5c8195('0x62'),_0x38066e);throw _0x38066e;});}return _0x109210;})[_0x455038('0x26')](respondWithResult(_0x405cd0,0xc9))[_0x455038('0x81')](handleError(_0x405cd0,null));},exports[_0x58bb68('0x17')]=function(_0xf59b40,_0x525d36){const _0x2f54e6=_0x58bb68;return _0xf59b40[_0x2f54e6('0x3b')]['id']&&delete _0xf59b40[_0x2f54e6('0x3b')]['id'],db[_0x2f54e6('0x14')][_0x2f54e6('0x27')]({'where':{'id':_0xf59b40[_0x2f54e6('0x2')]['id']}})['then'](handleEntityNotFound(_0x525d36,null))['then'](saveUpdates(_0xf59b40[_0x2f54e6('0x3b')],null))[_0x2f54e6('0x26')](respondWithResult(_0x525d36,null))[_0x2f54e6('0x81')](handleError(_0x525d36,null));},exports['destroy']=function(_0x66f4b3,_0x118c68){const _0x2f1d0b=_0x58bb68;return db[_0x2f1d0b('0x14')][_0x2f1d0b('0x27')]({'where':{'id':_0x66f4b3[_0x2f1d0b('0x2')]['id']}})[_0x2f1d0b('0x26')](handleEntityNotFound(_0x118c68,null))[_0x2f1d0b('0x26')](removeEntity(_0x118c68,null))[_0x2f1d0b('0x81')](handleError(_0x118c68,null));},exports['preview']=function(_0x2cc496,_0x302aec){const _0x541792=_0x58bb68,_0x8c6847=0xa,_0x23cdb3=[_0x541792('0x87'),_0x541792('0x51'),_0x541792('0x6e'),_0x541792('0x1')],_0x52fc17={'SUM':'SUM(%s)','COUNT':_0x541792('0x61'),'COUNT\x20DISTINCT':_0x541792('0x2a'),'MAX':_0x541792('0x38'),'MIN':_0x541792('0x0'),'AVG':_0x541792('0x79'),'GROUP_CONCAT':_0x541792('0x70'),'GROUP_CONCAT\x20ASC':_0x541792('0x20'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0x3b1682={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x541792('0x6c')},_0x59fa94=function(_0x3c60ea){const _0x58e07e=_0x541792;return!_[_0x58e07e('0x8a')]([_0x58e07e('0x5f'),_0x58e07e('0x30'),'IS\x20EMPTY',_0x58e07e('0x42')],_0x3c60ea);},_0xfc344f=function(_0x48ed0d){const _0x112793=_0x541792;if(!_0x48ed0d||!_0x48ed0d[_0x112793('0x4c')]['length'])return'';let _0x409e34='(';for(let _0x72c495=0x0;_0x72c495<_0x48ed0d[_0x112793('0x4c')]['length'];_0x72c495+=0x1){_0x72c495>0x0&&(_0x409e34+='\x20'+_0x48ed0d[_0x112793('0x4')]+'\x20'),_0x409e34+=_0x48ed0d[_0x112793('0x4c')][_0x72c495][_0x112793('0x2f')]?_0xfc344f(_0x48ed0d[_0x112793('0x4c')][_0x72c495]['group']):_0x48ed0d[_0x112793('0x4c')][_0x72c495][_0x112793('0x22')]+'\x20'+_0x48ed0d[_0x112793('0x4c')][_0x72c495][_0x112793('0x2c')]+(_0x59fa94(_0x48ed0d[_0x112793('0x4c')][_0x72c495][_0x112793('0x2c')])?'\x20'+_0x48ed0d[_0x112793('0x4c')][_0x72c495][_0x112793('0x28')]:'');}return _0x409e34+')';};let _0x35fc04={'where':{'id':_0x2cc496[_0x541792('0x2')]['id']}},_0x52ec3a,_0x116483,_0x29dac7;return _0x35fc04=_['merge']({},_0x35fc04,_0x2cc496[_0x541792('0x2b')]),db['AnalyticDefaultReport']['findOne'](_0x35fc04)['then'](function(_0x434b64){const _0x370676=_0x541792;if(_0x434b64)return _0x52ec3a=_0x434b64,_0x434b64[_0x370676('0x65')]();return null;})[_0x541792('0x26')](function(_0x28e2a4){const _0x495e87=_0x541792;if(_0x28e2a4){if(!_0x28e2a4[_0x495e87('0x44')])throw new ValidationErrorItem(_0x495e87('0xa'),0x193);return _0x116483=_0x28e2a4,db[_0x495e87('0x1d')]['findAll']({'raw':!![]});}return null;})[_0x541792('0x26')](function(_0x1759ee){const _0x19c2e9=_0x541792;if(_0x1759ee){_0x29dac7=_[_0x19c2e9('0x41')](_0x1759ee,'id');let _0x37c2d5;const _0x57f9cd=squel[_0x19c2e9('0x54')]();_0x57f9cd['from'](_0x52ec3a[_0x19c2e9('0x7c')]);for(let _0x5276fb=0x0;_0x5276fb<_0x116483['length'];_0x5276fb+=0x1){_0x37c2d5=_0x116483[_0x5276fb]['MetricId']?_0x29dac7[_0x116483[_0x5276fb][_0x19c2e9('0x64')]][_0x19c2e9('0x21')]:_0x116483[_0x5276fb][_0x19c2e9('0x22')],_0x37c2d5=_0x116483[_0x5276fb][_0x19c2e9('0x40')]?_[_0x19c2e9('0x85')](_0x52fc17[_0x116483[_0x5276fb][_0x19c2e9('0x40')]],'%s',_0x37c2d5):_0x37c2d5,_0x37c2d5=_0x116483[_0x5276fb][_0x19c2e9('0x48')]?_['replace'](_0x3b1682[_0x116483[_0x5276fb][_0x19c2e9('0x48')]],'%s',_0x37c2d5):_0x37c2d5,_0x116483[_0x5276fb]['groupBy']&&_0x57f9cd[_0x19c2e9('0x2f')](_0x37c2d5),_0x116483[_0x5276fb][_0x19c2e9('0x3c')]&&_0x57f9cd[_0x19c2e9('0x9')](_0x37c2d5,_0x116483[_0x5276fb][_0x19c2e9('0x3c')]==='DESC'?![]:!![]),_0x57f9cd[_0x19c2e9('0x22')](_0x37c2d5,_0x116483[_0x5276fb]['alias']||_0x37c2d5);}if(_0x52ec3a[_0x19c2e9('0x3f')]){_0x52ec3a[_0x19c2e9('0x3f')]=JSON[_0x19c2e9('0x75')](_0x52ec3a['joins']);for(let _0x104e2a=0x0;_0x104e2a<_0x52ec3a[_0x19c2e9('0x3f')][_0x19c2e9('0x44')];_0x104e2a+=0x1){_0x52ec3a['joins'][_0x104e2a]['type']&&_[_0x19c2e9('0x8a')](_0x23cdb3,_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a][_0x19c2e9('0x47')])&&_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a][_0x19c2e9('0x7a')]&&_0x52ec3a['joins'][_0x104e2a][_0x19c2e9('0x7d')]&&_0x52ec3a['joins'][_0x104e2a][_0x19c2e9('0x53')]&&_0x57f9cd[_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a]['type']](_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a]['foreignTable'],null,util['format'](_0x19c2e9('0x5'),_0x52ec3a['table'],_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a]['parentKey'],_0x52ec3a['joins'][_0x104e2a][_0x19c2e9('0x7d')],_0x52ec3a[_0x19c2e9('0x3f')][_0x104e2a][_0x19c2e9('0x53')]));}}return _0x52ec3a[_0x19c2e9('0xb')]&&(_0x52ec3a[_0x19c2e9('0xb')]=JSON['parse'](_0x52ec3a[_0x19c2e9('0xb')]),_0x57f9cd['where'](_0xfc344f(_0x52ec3a[_0x19c2e9('0xb')][_0x19c2e9('0x2f')]))),_0x57f9cd[_0x19c2e9('0x69')](_0x8c6847),_0x57f9cd['offset'](0x0),logger[_0x19c2e9('0x60')](_0x19c2e9('0x83'),_0x57f9cd[_0x19c2e9('0xe')]()),db[_0x19c2e9('0x50')][_0x19c2e9('0x6d')](_0x57f9cd[_0x19c2e9('0xe')](),{'type':QueryTypes[_0x19c2e9('0x6')]});}})[_0x541792('0x26')](respondWithResult(_0x302aec,null))[_0x541792('0x81')](handleError(_0x302aec,null));};function runReport(_0x369483,_0x39bb29,_0x507aea){const _0xce80f7=_0x58bb68,_0x24e4d5=_0x39bb29['name'],_0x32a3de=0xa,_0x13c70c=[_0xce80f7('0x87'),_0xce80f7('0x51'),'right_join',_0xce80f7('0x1')],_0x4b060f={'SUM':_0xce80f7('0x11'),'COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0xce80f7('0x2a'),'MAX':_0xce80f7('0x38'),'MIN':_0xce80f7('0x0'),'AVG':_0xce80f7('0x79'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0xce80f7('0x32')},_0xb4f941={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0xce80f7('0x55'),'HOUR':_0xce80f7('0x66'),'ROUND':_0xce80f7('0x78'),'UNIX_TIMESTAMP':_0xce80f7('0x6c')},_0x295db1=function(_0x34f07b){const _0x21df9f=_0xce80f7;return!_[_0x21df9f('0x8a')]([_0x21df9f('0x5f'),_0x21df9f('0x30'),_0x21df9f('0x3e'),'IS\x20NOT\x20EMPTY'],_0x34f07b);},_0x30f87c=function(_0x3b96fc){const _0x3462d6=_0xce80f7;if(!_0x3b96fc||!_0x3b96fc[_0x3462d6('0x4c')][_0x3462d6('0x44')])return'';let _0x38cec5='(';for(let _0x19c50c=0x0;_0x19c50c<_0x3b96fc[_0x3462d6('0x4c')][_0x3462d6('0x44')];_0x19c50c+=0x1){_0x19c50c>0x0&&(_0x38cec5+='\x20'+_0x3b96fc[_0x3462d6('0x4')]+'\x20'),_0x38cec5+=_0x3b96fc[_0x3462d6('0x4c')][_0x19c50c][_0x3462d6('0x2f')]?_0x30f87c(_0x3b96fc[_0x3462d6('0x4c')][_0x19c50c][_0x3462d6('0x2f')]):_0x3b96fc['rules'][_0x19c50c][_0x3462d6('0x22')]+'\x20'+_0x3b96fc[_0x3462d6('0x4c')][_0x19c50c][_0x3462d6('0x2c')]+(_0x295db1(_0x3b96fc[_0x3462d6('0x4c')][_0x19c50c][_0x3462d6('0x2c')])?'\x20'+_0x3b96fc[_0x3462d6('0x4c')][_0x19c50c][_0x3462d6('0x28')]:'');}return _0x38cec5+')';};let _0x733f98={'where':{'id':_0x369483['id']}},_0x279abd,_0x78431,_0x13d2b1,_0x4bcf26,_0x5b60f6;return _0x733f98=_[_0xce80f7('0x19')]({},_0x733f98,_0x507aea),db['AnalyticDefaultReport'][_0xce80f7('0x27')](_0x733f98)[_0xce80f7('0x26')](function(_0x1157e0){const _0x5b158f=_0xce80f7;if(_0x1157e0)return _0x279abd=_0x1157e0,_0x1157e0[_0x5b158f('0x65')]();return null;})['then'](function(_0x39d533){const _0x2cab62=_0xce80f7;if(_0x39d533){if(!_0x39d533[_0x2cab62('0x44')])throw new ValidationErrorItem(_0x2cab62('0xa'),0x193);return _0x78431=_0x39d533,db[_0x2cab62('0x1d')][_0x2cab62('0x7b')]({'raw':!![]});}return null;})[_0xce80f7('0x26')](function(_0x139ab3){const _0x21f7d4=_0xce80f7;if(_0x139ab3){_0x13d2b1=_['keyBy'](_0x139ab3,'id');let _0x29206b;const _0x3346da=squel[_0x21f7d4('0x54')]();_0x3346da[_0x21f7d4('0x1c')](_0x279abd[_0x21f7d4('0x7c')]);for(let _0x4e8afd=0x0;_0x4e8afd<_0x78431[_0x21f7d4('0x44')];_0x4e8afd+=0x1){_0x29206b=_0x78431[_0x4e8afd]['MetricId']?_0x13d2b1[_0x78431[_0x4e8afd]['MetricId']]['metric']:_0x78431[_0x4e8afd]['field'],_0x29206b=_0x78431[_0x4e8afd][_0x21f7d4('0x40')]?_[_0x21f7d4('0x85')](_0x4b060f[_0x78431[_0x4e8afd][_0x21f7d4('0x40')]],'%s',_0x29206b):_0x29206b,_0x29206b=_0x78431[_0x4e8afd][_0x21f7d4('0x48')]?_[_0x21f7d4('0x85')](_0xb4f941[_0x78431[_0x4e8afd]['format']],'%s',_0x29206b):_0x29206b,_0x78431[_0x4e8afd][_0x21f7d4('0x58')]&&_0x3346da[_0x21f7d4('0x2f')](_0x29206b),_0x78431[_0x4e8afd][_0x21f7d4('0x3c')]&&_0x3346da[_0x21f7d4('0x9')](_0x29206b,_0x78431[_0x4e8afd][_0x21f7d4('0x3c')]===_0x21f7d4('0x3a')?![]:!![]),_0x3346da[_0x21f7d4('0x22')](_0x29206b,_0x78431[_0x4e8afd]['alias']||_0x29206b);}if(_0x279abd[_0x21f7d4('0x3f')]){_0x279abd[_0x21f7d4('0x3f')]=JSON[_0x21f7d4('0x75')](_0x279abd[_0x21f7d4('0x3f')]);for(let _0x20055e=0x0;_0x20055e<_0x279abd[_0x21f7d4('0x3f')][_0x21f7d4('0x44')];_0x20055e+=0x1){_0x279abd[_0x21f7d4('0x3f')][_0x20055e]['type']&&_[_0x21f7d4('0x8a')](_0x13c70c,_0x279abd[_0x21f7d4('0x3f')][_0x20055e]['type'])&&_0x279abd['joins'][_0x20055e][_0x21f7d4('0x7a')]&&_0x279abd[_0x21f7d4('0x3f')][_0x20055e]['foreignTable']&&_0x279abd[_0x21f7d4('0x3f')][_0x20055e]['foreignKey']&&_0x3346da[_0x279abd['joins'][_0x20055e][_0x21f7d4('0x47')]](_0x279abd[_0x21f7d4('0x3f')][_0x20055e][_0x21f7d4('0x7d')],null,util[_0x21f7d4('0x48')]('%s.%s\x20=\x20%s.%s',_0x279abd[_0x21f7d4('0x7c')],_0x279abd[_0x21f7d4('0x3f')][_0x20055e][_0x21f7d4('0x7a')],_0x279abd[_0x21f7d4('0x3f')][_0x20055e][_0x21f7d4('0x7d')],_0x279abd[_0x21f7d4('0x3f')][_0x20055e]['foreignKey']));}}return _0x279abd['conditions']&&(_0x279abd[_0x21f7d4('0xb')]=JSON['parse'](_0x279abd[_0x21f7d4('0xb')]),_0x3346da[_0x21f7d4('0x7e')](_0x30f87c(_0x279abd['conditions'][_0x21f7d4('0x2f')]))),_0x5b60f6=_0x3346da[_0x21f7d4('0x5e')](),_0x3346da['limit'](_0x32a3de),_0x3346da[_0x21f7d4('0x1e')](0x0),logger['debug']('Limited\x20Query:',_0x3346da[_0x21f7d4('0xe')]()),db[_0x21f7d4('0x50')]['query'](_0x3346da[_0x21f7d4('0xe')](),{'type':QueryTypes[_0x21f7d4('0x6')]});}})['then'](function(_0x3513a9){const _0x2be58a=_0xce80f7;if(!_0x3513a9[_0x2be58a('0x44')])throw new ValidationErrorItem('No\x20available\x20data',0xcc);if(_0x39bb29[_0x2be58a('0x6f')]===_0x2be58a('0x5c'))return null;const _0x51d3e6=_[_0x2be58a('0x19')](_0x39bb29,{'name':_0x39bb29['fullPath']||_0x39bb29[_0x2be58a('0x84')]||_0x279abd[_0x2be58a('0x84')],'basename':_0x24e4d5,'savename':util[_0x2be58a('0x48')](_0x2be58a('0x8'),_0x39bb29[_0x2be58a('0x84')]||_0x279abd['name'],require(_0x2be58a('0x7'))[_0x2be58a('0x24')](0x4),_0x39bb29['output']||_0x2be58a('0x1a')),'reportId':_0x279abd['id'],'reportType':_0x2be58a('0x3d')});return db['AnalyticExtractedReport']['create'](_0x51d3e6,{'raw':!![]});})['then'](function(_0x1a052b){const _0x123239=_0xce80f7;_0x279abd['table']==='cdr'?_0x5b60f6[_0x123239('0x7e')](_0x279abd[_0x123239('0x7c')]+_0x123239('0x25'),_0x39bb29[_0x123239('0x89')],_0x39bb29[_0x123239('0x73')]):_0x5b60f6[_0x123239('0x7e')](_0x279abd[_0x123239('0x7c')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x39bb29['startDate'],_0x39bb29['endDate']);if(_0x1a052b)return logger[_0x123239('0x4a')](_0x123239('0x23'),_0x5b60f6[_0x123239('0xe')]()),require(_0x123239('0x57'))[_0x123239('0x1b')](path[_0x123239('0x87')](__dirname,_0x123239('0x4f'),_0x1a052b[_0x123239('0x6f')]),[_0x1a052b['id'],_0x5b60f6[_0x123239('0xe')](),path['join'](__dirname,_0x123239('0x82'),_0x1a052b['savename']),_0x24e4d5]),_0x1a052b;else{const _0x2d091c=squel[_0x123239('0x54')]();return _0x2d091c['from']('('+_0x5b60f6['toString']()+')',_0x123239('0x36')),_0x2d091c[_0x123239('0x22')](_0x123239('0x12'),_0x123239('0x7f')),_0x5b60f6[_0x123239('0x69')](_0x39bb29['limit']||_0x32a3de),_0x5b60f6[_0x123239('0x1e')](_0x39bb29[_0x123239('0x1e')]||0x0),dbH['sequelize'][_0x123239('0x6d')](_0x2d091c['toString'](),{'type':dbH[_0x123239('0x50')]['QueryTypes']['SELECT']})['then'](function(_0x9d57dc){const _0x1d1368=_0x123239;return!_0x9d57dc['length']?_0x4bcf26=0x0:_0x4bcf26=_0x9d57dc[0x0][_0x1d1368('0x7f')]||0x0,dbH['sequelize'][_0x1d1368('0x6d')](_0x5b60f6['toString'](),{'type':dbH[_0x1d1368('0x50')][_0x1d1368('0x10')][_0x1d1368('0x6')]});})['then'](function(_0x2391ed){return{'rows':_0x2391ed||[],'count':_0x4bcf26};});}});}exports[_0x58bb68('0x1f')]=function(_0xf759a0,_0x538f25){const _0x8ebcd4=_0x58bb68;return runReport(_0xf759a0['params'],_0xf759a0[_0x8ebcd4('0x6d')],_0xf759a0['options'])[_0x8ebcd4('0x26')](respondWithResult(_0x538f25,null))[_0x8ebcd4('0x81')](handleError(_0x538f25,null));},exports[_0x58bb68('0x5b')]=runReport,exports['query']=function(_0x25944e,_0x51bbbb){const _0x5e2908=_0x58bb68,_0x5eabb6=0xa,_0x110132=[_0x5e2908('0x87'),_0x5e2908('0x51'),_0x5e2908('0x6e'),_0x5e2908('0x1')],_0x120434={'SUM':_0x5e2908('0x11'),'COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0x5e2908('0x2a'),'MAX':_0x5e2908('0x38'),'MIN':_0x5e2908('0x0'),'AVG':_0x5e2908('0x79'),'GROUP_CONCAT':_0x5e2908('0x70'),'GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0x5e2908('0x32')},_0x3fdcb9={'SEC_TO_TIME':_0x5e2908('0x16'),'DATE':_0x5e2908('0x55'),'HOUR':_0x5e2908('0x66'),'ROUND':_0x5e2908('0x78'),'UNIX_TIMESTAMP':_0x5e2908('0x6c')},_0x1b26f4=function(_0xf9b3a2){const _0x4458b9=_0x5e2908;return!_[_0x4458b9('0x8a')]([_0x4458b9('0x5f'),_0x4458b9('0x30'),_0x4458b9('0x3e'),_0x4458b9('0x42')],_0xf9b3a2);},_0x6750ce=function(_0x4ae1a4){const _0xe6acab=_0x5e2908;if(!_0x4ae1a4||!_0x4ae1a4[_0xe6acab('0x4c')][_0xe6acab('0x44')])return'';let _0x52c339='(';for(let _0x4e4a00=0x0;_0x4e4a00<_0x4ae1a4['rules'][_0xe6acab('0x44')];_0x4e4a00+=0x1){_0x4e4a00>0x0&&(_0x52c339+='\x20'+_0x4ae1a4['operator']+'\x20'),_0x52c339+=_0x4ae1a4[_0xe6acab('0x4c')][_0x4e4a00][_0xe6acab('0x2f')]?_0x6750ce(_0x4ae1a4[_0xe6acab('0x4c')][_0x4e4a00][_0xe6acab('0x2f')]):_0x4ae1a4[_0xe6acab('0x4c')][_0x4e4a00][_0xe6acab('0x22')]+'\x20'+_0x4ae1a4[_0xe6acab('0x4c')][_0x4e4a00][_0xe6acab('0x2c')]+(_0x1b26f4(_0x4ae1a4[_0xe6acab('0x4c')][_0x4e4a00][_0xe6acab('0x2c')])?'\x20'+_0x4ae1a4['rules'][_0x4e4a00]['value']:'');}return _0x52c339+')';};let _0x477836={'where':{'id':_0x25944e[_0x5e2908('0x2')]['id']}},_0xf2b391,_0x4724e2,_0x420daa,_0x3511e3;return _0x477836=_[_0x5e2908('0x19')]({},_0x477836,_0x25944e['options']),db[_0x5e2908('0x14')][_0x5e2908('0x27')](_0x477836)[_0x5e2908('0x26')](function(_0x419f55){const _0x298874=_0x5e2908;if(_0x419f55)return _0xf2b391=_0x419f55,_0x419f55[_0x298874('0x65')]();return null;})[_0x5e2908('0x26')](function(_0x1395b6){const _0x2e3dec=_0x5e2908;if(_0x1395b6){if(!_0x1395b6['length'])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x4724e2=_0x1395b6,db[_0x2e3dec('0x1d')][_0x2e3dec('0x7b')]({'raw':!![]});}return null;})[_0x5e2908('0x26')](function(_0x2eff87){const _0x221a3b=_0x5e2908;if(_0x2eff87){_0x420daa=_[_0x221a3b('0x41')](_0x2eff87,'id');let _0x39e024;const _0x2e82cd=squel[_0x221a3b('0x54')]();_0x2e82cd['from'](_0xf2b391[_0x221a3b('0x7c')]);for(let _0x530a33=0x0;_0x530a33<_0x4724e2[_0x221a3b('0x44')];_0x530a33+=0x1){_0x39e024=_0x4724e2[_0x530a33][_0x221a3b('0x64')]?_0x420daa[_0x4724e2[_0x530a33]['MetricId']][_0x221a3b('0x21')]:_0x4724e2[_0x530a33]['field'],_0x39e024=_0x4724e2[_0x530a33][_0x221a3b('0x40')]?_['replace'](_0x120434[_0x4724e2[_0x530a33][_0x221a3b('0x40')]],'%s',_0x39e024):_0x39e024,_0x39e024=_0x4724e2[_0x530a33][_0x221a3b('0x48')]?_['replace'](_0x3fdcb9[_0x4724e2[_0x530a33][_0x221a3b('0x48')]],'%s',_0x39e024):_0x39e024,_0x4724e2[_0x530a33]['groupBy']&&_0x2e82cd['group'](_0x39e024),_0x4724e2[_0x530a33][_0x221a3b('0x3c')]&&_0x2e82cd[_0x221a3b('0x9')](_0x39e024,_0x4724e2[_0x530a33][_0x221a3b('0x3c')]===_0x221a3b('0x3a')?![]:!![]),_0x2e82cd[_0x221a3b('0x22')](_0x39e024,_0x4724e2[_0x530a33][_0x221a3b('0x4d')]||_0x39e024);}if(_0xf2b391[_0x221a3b('0x3f')]){_0xf2b391['joins']=JSON[_0x221a3b('0x75')](_0xf2b391[_0x221a3b('0x3f')]);for(let _0xbe1847=0x0;_0xbe1847<_0xf2b391['joins']['length'];_0xbe1847+=0x1){_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x47')]&&_['includes'](_0x110132,_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x47')])&&_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x7a')]&&_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x7d')]&&_0xf2b391[_0x221a3b('0x3f')][_0xbe1847]['foreignKey']&&_0x2e82cd[_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x47')]](_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x7d')],null,util[_0x221a3b('0x48')](_0x221a3b('0x5'),_0xf2b391[_0x221a3b('0x7c')],_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x7a')],_0xf2b391['joins'][_0xbe1847][_0x221a3b('0x7d')],_0xf2b391[_0x221a3b('0x3f')][_0xbe1847][_0x221a3b('0x53')]));}}return _0xf2b391[_0x221a3b('0xb')]&&(_0xf2b391[_0x221a3b('0xb')]=JSON[_0x221a3b('0x75')](_0xf2b391[_0x221a3b('0xb')]),_0x2e82cd[_0x221a3b('0x7e')](_0x6750ce(_0xf2b391[_0x221a3b('0xb')][_0x221a3b('0x2f')]))),_0x3511e3=_0x2e82cd['clone'](),_0x2e82cd['limit'](_0x5eabb6),_0x2e82cd['offset'](0x0),logger[_0x221a3b('0x60')]('Limited\x20Query:',_0x2e82cd['toString']()),db['sequelize'][_0x221a3b('0x6d')](_0x2e82cd[_0x221a3b('0xe')](),{'type':QueryTypes[_0x221a3b('0x6')]});}})[_0x5e2908('0x26')](function(){const _0x4b60ba=_0x5e2908;return{'sql':_0x3511e3[_0x4b60ba('0xe')]()};})[_0x5e2908('0x26')](respondWithResult(_0x51bbbb,null))[_0x5e2908('0x81')](handleError(_0x51bbbb,null));};
git://repos.xcallymotion.com / motion-next.git / blob