-const a9_0x3fe9=['AnalyticDefaultReport','VIRTUAL','HOUR(%s)','preview','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','replace','get','squel','AnalyticExtractedReport','stack','parentKey','cdr','IS\x20NOT\x20EMPTY','GROUP_CONCAT(%s)','offset','filter','set','Limited\x20Query:','run','AVG(%s)','SELECT','fieldName','randomstring','right_join','limit','length','foreignKey','DefaultReports','include','UNIX_TIMESTAMP(%s)','count','foreignTable','joins','fork','MetricId','condition','table','operator','cross_join','Run\x20Query:','role','includeAll','orderBy','.calldate\x20BETWEEN\x20?\x20AND\x20?','fields','info','UserProfileSection','options','COUNT(%s)','autoAssociation','parse','MAX(%s)','AnalyticMetric','from','select','../../components/parsers/qs','end','index','keys','IS\x20NOT\x20NULL','clone','conditions','like','.createdAt\x20BETWEEN\x20?\x20AND\x20?','COUNT(*)','../../components/export/','params','map','IS\x20NULL','output','path','json','intersection','api','Please\x20insert\x20at\x20least\x20one\x20field','csv','generate','attributes','query','merge','lodash','function','QueryTypes','DATE(%s)','model','sendStatus','ROUND(%s)','format','nolimit','body','order','rawAttributes','No\x20available\x20data','left_join','debug','groupBy','SUM(%s)','group','findAll','fullPath','runReport','rules','join','value','dbH','error','default','then','undefined','sort','child_process','status','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','IS\x20EMPTY','type','metric','send','SEC_TO_TIME(%s)','endDate','field','web','../../mysqldb','toString','COUNT(DISTINCT\x20%s)','%s-%s.%s','DESC','includes','where','../../config/logger','keyBy','getFields','destroy','filters','alias','update','%s.%s\x20=\x20%s.%s','startDate','userProfileId','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','sequelize','MIN(%s)','name','../../files/reports','Unable\x20to\x20retrieve\x20the\x20current\x20user','findOne','UserProfileResource','countTable','create','catch'];(function(_0x4cdc3f,_0x3fe92e){const _0x3a0956=function(_0x9ce5fd){while(--_0x9ce5fd){_0x4cdc3f['push'](_0x4cdc3f['shift']());}};_0x3a0956(++_0x3fe92e);}(a9_0x3fe9,0x16f));const a9_0x3a09=function(_0x4cdc3f,_0x3fe92e){_0x4cdc3f=_0x4cdc3f-0x0;let _0x3a0956=a9_0x3fe9[_0x4cdc3f];return _0x3a0956;};const _0xa48b17=a9_0x3a09;'use strict';const util=require('util'),path=require(_0xa48b17('0x1')),_=require(_0xa48b17('0xb')),squel=require(_0xa48b17('0x57')),qs=require(_0xa48b17('0x87')),logger=require(_0xa48b17('0x3b'))(_0xa48b17('0x4')),db=require(_0xa48b17('0x34'))['db'],dbH=require(_0xa48b17('0x34'))[_0xa48b17('0x23')],{Op,ValidationErrorItem,QueryTypes}=require(_0xa48b17('0x46'));function respondWithResult(_0x9ce5fd,_0x249d90){return _0x249d90=_0x249d90||0xc8,function(_0x2edd0c){const _0xadfe2d=a9_0x3a09;if(_0x2edd0c)return _0x9ce5fd[_0xadfe2d('0x2a')](_0x249d90)[_0xadfe2d('0x2')](_0x2edd0c);};}function respondWithFilteredResult(_0x5f1820,_0x32c061){return function(_0x328edb){const _0x54c425=a9_0x3a09;if(_0x328edb){const _0x5c7873=_0x328edb[_0x54c425('0x6e')],_0x4b41be=_0x32c061[_0x54c425('0x5e')];let _0x14a0a5=_0x32c061[_0x54c425('0x5e')]+_0x32c061['limit'],_0x3f3ff6;return _0x14a0a5>=_0x5c7873?(_0x14a0a5=_0x5c7873,_0x3f3ff6=0xc8):_0x3f3ff6=0xce,_0x5f1820[_0x54c425('0x2a')](_0x3f3ff6),_0x5f1820[_0x54c425('0x60')]('Content-Range',_0x4b41be+'-'+_0x14a0a5+'/'+_0x5c7873)['json'](_0x328edb);}return null;};}function saveUpdates(_0x1fb2c6){return function(_0x244452){const _0x13319b=a9_0x3a09;if(_0x244452)return _0x244452[_0x13319b('0x41')](_0x1fb2c6)[_0x13319b('0x26')](function(_0x5d5262){return _0x5d5262;});return null;};}function removeEntity(_0x117c6f){return function(_0xaf819b){const _0x4521be=a9_0x3a09;if(_0xaf819b)return _0xaf819b[_0x4521be('0x3e')]()[_0x4521be('0x26')](function(){const _0x44389e=_0x4521be,_0x44dbdc=_0xaf819b[_0x44389e('0x56')]({'plain':!![]}),_0x5d4847='DefaultReports';return db[_0x44389e('0x4c')][_0x44389e('0x3e')]({'where':{'type':_0x5d4847,'resourceId':_0x44dbdc['id']}})['then'](function(){return _0xaf819b;});})[_0x4521be('0x26')](function(){const _0x199bdd=_0x4521be;_0x117c6f[_0x199bdd('0x2a')](0xcc)[_0x199bdd('0x88')]();});};}function handleEntityNotFound(_0x45efa0){return function(_0x50f118){const _0x5b1637=a9_0x3a09;return!_0x50f118&&_0x45efa0[_0x5b1637('0x10')](0x194),_0x50f118;};}function handleError(_0x2af53f,_0x1c2ebf){return _0x1c2ebf=_0x1c2ebf||0x1f4,function(_0x5889a4){const _0x3361ce=a9_0x3a09;logger['error'](_0x5889a4[_0x3361ce('0x59')]),_0x5889a4['name']&&delete _0x5889a4['name'],_0x2af53f[_0x3361ce('0x2a')](_0x1c2ebf)[_0x3361ce('0x2f')](_0x5889a4);};}exports[_0xa48b17('0x89')]=function(_0x209179,_0x5334e3){const _0x2db6e4=_0xa48b17;let _0x57092b={};const _0x1ca537={},_0xc2a341={'count':0x0,'rows':[]},_0x46896a=_[_0x2db6e4('0x93')](db['AnalyticDefaultReport'][_0x2db6e4('0x16')],function(_0x5d677d){const _0x5d5f91=_0x2db6e4;return{'name':_0x5d677d[_0x5d5f91('0x65')],'type':_0x5d677d[_0x5d5f91('0x2d')]['key']};});_0x1ca537['model']=_[_0x2db6e4('0x93')](_0x46896a,_0x2db6e4('0x48')),_0x1ca537['query']=_[_0x2db6e4('0x8a')](_0x209179[_0x2db6e4('0x9')]),_0x1ca537[_0x2db6e4('0x3f')]=_[_0x2db6e4('0x3')](_0x1ca537['model'],_0x1ca537[_0x2db6e4('0x9')]),_0x57092b[_0x2db6e4('0x8')]=_[_0x2db6e4('0x3')](_0x1ca537[_0x2db6e4('0xf')],qs[_0x2db6e4('0x7c')](_0x209179[_0x2db6e4('0x9')]['fields'])),_0x57092b['attributes']=_0x57092b[_0x2db6e4('0x8')]['length']?_0x57092b[_0x2db6e4('0x8')]:_0x1ca537[_0x2db6e4('0xf')];typeof _0x209179[_0x2db6e4('0x9')][_0x2db6e4('0x13')]===_0x2db6e4('0x27')&&(_0x57092b[_0x2db6e4('0x68')]=qs[_0x2db6e4('0x68')](_0x209179[_0x2db6e4('0x9')][_0x2db6e4('0x68')]),_0x57092b['offset']=qs['offset'](_0x209179['query'][_0x2db6e4('0x5e')]));_0x57092b[_0x2db6e4('0x15')]=qs[_0x2db6e4('0x28')](_0x209179['query'][_0x2db6e4('0x28')]),_0x57092b['where']=qs[_0x2db6e4('0x3f')](_['pick'](_0x209179[_0x2db6e4('0x9')],_0x1ca537['filters']),_0x46896a);_0x209179[_0x2db6e4('0x9')]['filter']&&(_0x57092b[_0x2db6e4('0x3a')]=_[_0x2db6e4('0xa')](_0x57092b[_0x2db6e4('0x3a')],{[Op['or']]:_[_0x2db6e4('0x93')](_0x46896a,function(_0x92415){const _0x434733=_0x2db6e4;if(_0x92415['type']!==_0x434733('0x51')){const _0x398de3={};return _0x398de3[_0x92415[_0x434733('0x48')]]={[Op[_0x434733('0x8e')]]:'%'+_0x209179[_0x434733('0x9')][_0x434733('0x5f')]+'%'},_0x398de3;}})}));_0x57092b=_[_0x2db6e4('0xa')]({},_0x57092b,_0x209179['options']);const _0x496343={'where':_0x57092b[_0x2db6e4('0x3a')]};return db[_0x2db6e4('0x50')][_0x2db6e4('0x6e')](_0x496343)[_0x2db6e4('0x26')](function(_0x55e3ee){const _0xe5222b=_0x2db6e4;return _0xc2a341[_0xe5222b('0x6e')]=_0x55e3ee,_0x209179[_0xe5222b('0x9')]['includeAll']&&(_0x57092b[_0xe5222b('0x6c')]=[{'all':!![]}]),db['AnalyticDefaultReport']['findAll'](_0x57092b);})[_0x2db6e4('0x26')](function(_0x28677a){return _0xc2a341['rows']=_0x28677a,_0xc2a341;})[_0x2db6e4('0x26')](respondWithFilteredResult(_0x5334e3,_0x57092b))[_0x2db6e4('0x4f')](handleError(_0x5334e3,null));},exports['show']=function(_0x33c159,_0x1ad3dd){const _0x30ef27=_0xa48b17;let _0x91dc9e={'raw':!![],'where':{'id':_0x33c159['params']['id']}};const _0x2c7dd4={};return _0x2c7dd4[_0x30ef27('0xf')]=_['keys'](db['AnalyticDefaultReport'][_0x30ef27('0x16')]),_0x2c7dd4['query']=_[_0x30ef27('0x8a')](_0x33c159[_0x30ef27('0x9')]),_0x2c7dd4['filters']=_[_0x30ef27('0x3')](_0x2c7dd4[_0x30ef27('0xf')],_0x2c7dd4[_0x30ef27('0x9')]),_0x91dc9e[_0x30ef27('0x8')]=_[_0x30ef27('0x3')](_0x2c7dd4[_0x30ef27('0xf')],qs[_0x30ef27('0x7c')](_0x33c159['query'][_0x30ef27('0x7c')])),_0x91dc9e[_0x30ef27('0x8')]=_0x91dc9e[_0x30ef27('0x8')][_0x30ef27('0x69')]?_0x91dc9e[_0x30ef27('0x8')]:_0x2c7dd4[_0x30ef27('0xf')],_0x33c159[_0x30ef27('0x9')][_0x30ef27('0x79')]&&(_0x91dc9e['include']=[{'all':!![]}]),_0x91dc9e=_[_0x30ef27('0xa')]({},_0x91dc9e,_0x33c159['options']),db[_0x30ef27('0x50')][_0x30ef27('0x4b')](_0x91dc9e)[_0x30ef27('0x26')](handleEntityNotFound(_0x1ad3dd,null))['then'](respondWithResult(_0x1ad3dd,null))[_0x30ef27('0x4f')](handleError(_0x1ad3dd,null));},exports['create']=function(_0x3a733a,_0x450461){const _0x2ff111=_0xa48b17;return db['AnalyticDefaultReport'][_0x2ff111('0x4e')](_0x3a733a[_0x2ff111('0x14')],{})[_0x2ff111('0x26')](function(_0xa567cb){const _0x1be5f0=_0x2ff111,_0x44bfeb=_0x3a733a['user'][_0x1be5f0('0x56')]({'plain':!![]});if(!_0x44bfeb)throw new Error(_0x1be5f0('0x4a'));if(_0x44bfeb[_0x1be5f0('0x78')]==='user'){const _0x54edd6=_0xa567cb['get']({'plain':!![]}),_0x259be7='Reports';return db[_0x1be5f0('0x7e')][_0x1be5f0('0x4b')]({'where':{'name':_0x259be7,'userProfileId':_0x44bfeb[_0x1be5f0('0x44')]},'raw':!![]})[_0x1be5f0('0x26')](function(_0x56f6f8){const _0x2cf2f2=_0x1be5f0;return _0x56f6f8&&_0x56f6f8[_0x2cf2f2('0x81')]===0x0?db[_0x2cf2f2('0x4c')][_0x2cf2f2('0x4e')]({'name':_0x54edd6[_0x2cf2f2('0x48')],'resourceId':_0x54edd6['id'],'type':_0x2cf2f2('0x6b'),'sectionId':_0x56f6f8['id']},{})[_0x2cf2f2('0x26')](function(){return _0xa567cb;}):_0xa567cb;})[_0x1be5f0('0x4f')](function(_0x29a13a){const _0x1b5291=_0x1be5f0;logger[_0x1b5291('0x24')](_0x1b5291('0x54'),_0x29a13a);throw _0x29a13a;});}return _0xa567cb;})[_0x2ff111('0x26')](respondWithResult(_0x450461,0xc9))[_0x2ff111('0x4f')](handleError(_0x450461,null));},exports[_0xa48b17('0x41')]=function(_0x378b1c,_0x1f8e68){const _0x11a43b=_0xa48b17;return _0x378b1c[_0x11a43b('0x14')]['id']&&delete _0x378b1c[_0x11a43b('0x14')]['id'],db[_0x11a43b('0x50')][_0x11a43b('0x4b')]({'where':{'id':_0x378b1c[_0x11a43b('0x92')]['id']}})[_0x11a43b('0x26')](handleEntityNotFound(_0x1f8e68,null))['then'](saveUpdates(_0x378b1c[_0x11a43b('0x14')],null))['then'](respondWithResult(_0x1f8e68,null))[_0x11a43b('0x4f')](handleError(_0x1f8e68,null));},exports['destroy']=function(_0x2b97a7,_0xbfb6e9){const _0x557c49=_0xa48b17;return db[_0x557c49('0x50')][_0x557c49('0x4b')]({'where':{'id':_0x2b97a7[_0x557c49('0x92')]['id']}})[_0x557c49('0x26')](handleEntityNotFound(_0xbfb6e9,null))[_0x557c49('0x26')](removeEntity(_0xbfb6e9,null))[_0x557c49('0x4f')](handleError(_0xbfb6e9,null));},exports[_0xa48b17('0x53')]=function(_0x435f86,_0x18b72f){const _0x203ee7=_0xa48b17,_0x58f1f8=0xa,_0x45a556=[_0x203ee7('0x21'),_0x203ee7('0x18'),_0x203ee7('0x67'),'cross_join'],_0x267fa2={'SUM':_0x203ee7('0x1b'),'COUNT':_0x203ee7('0x80'),'COUNT\x20DISTINCT':_0x203ee7('0x36'),'MAX':_0x203ee7('0x83'),'MIN':_0x203ee7('0x47'),'AVG':_0x203ee7('0x63'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':_0x203ee7('0x2b'),'GROUP_CONCAT\x20DESC':_0x203ee7('0x45')},_0x2a2d82={'SEC_TO_TIME':_0x203ee7('0x30'),'DATE':'DATE(%s)','HOUR':_0x203ee7('0x52'),'ROUND':_0x203ee7('0x11'),'UNIX_TIMESTAMP':_0x203ee7('0x6d')},_0x1bbd34=function(_0x1ba79b){const _0x3a3cd9=_0x203ee7;return!_[_0x3a3cd9('0x39')]([_0x3a3cd9('0x94'),_0x3a3cd9('0x8b'),_0x3a3cd9('0x2c'),_0x3a3cd9('0x5c')],_0x1ba79b);},_0x41170e=function(_0xfc771c){const _0x26a9c4=_0x203ee7;if(!_0xfc771c||!_0xfc771c['rules'][_0x26a9c4('0x69')])return'';let _0x11266a='(';for(let _0x528732=0x0;_0x528732<_0xfc771c[_0x26a9c4('0x20')]['length'];_0x528732+=0x1){_0x528732>0x0&&(_0x11266a+='\x20'+_0xfc771c[_0x26a9c4('0x75')]+'\x20'),_0x11266a+=_0xfc771c[_0x26a9c4('0x20')][_0x528732][_0x26a9c4('0x1c')]?_0x41170e(_0xfc771c[_0x26a9c4('0x20')][_0x528732]['group']):_0xfc771c['rules'][_0x528732][_0x26a9c4('0x32')]+'\x20'+_0xfc771c['rules'][_0x528732][_0x26a9c4('0x73')]+(_0x1bbd34(_0xfc771c[_0x26a9c4('0x20')][_0x528732]['condition'])?'\x20'+_0xfc771c['rules'][_0x528732]['value']:'');}return _0x11266a+')';};let _0x1d597a={'where':{'id':_0x435f86[_0x203ee7('0x92')]['id']}},_0xee815e,_0x32908a,_0x356d46;return _0x1d597a=_['merge']({},_0x1d597a,_0x435f86[_0x203ee7('0x7f')]),db[_0x203ee7('0x50')][_0x203ee7('0x4b')](_0x1d597a)['then'](function(_0x54a02d){if(_0x54a02d)return _0xee815e=_0x54a02d,_0x54a02d['getFields']();return null;})[_0x203ee7('0x26')](function(_0x27b2c9){const _0x16f4bc=_0x203ee7;if(_0x27b2c9){if(!_0x27b2c9['length'])throw new ValidationErrorItem(_0x16f4bc('0x5'),0x193);return _0x32908a=_0x27b2c9,db[_0x16f4bc('0x84')][_0x16f4bc('0x1d')]({'raw':!![]});}return null;})[_0x203ee7('0x26')](function(_0x240d88){const _0x48461b=_0x203ee7;if(_0x240d88){_0x356d46=_[_0x48461b('0x3c')](_0x240d88,'id');let _0x22abc9;const _0x2f5a0e=squel[_0x48461b('0x86')]();_0x2f5a0e[_0x48461b('0x85')](_0xee815e[_0x48461b('0x74')]);for(let _0x16cb6a=0x0;_0x16cb6a<_0x32908a[_0x48461b('0x69')];_0x16cb6a+=0x1){_0x22abc9=_0x32908a[_0x16cb6a][_0x48461b('0x72')]?_0x356d46[_0x32908a[_0x16cb6a]['MetricId']][_0x48461b('0x2e')]:_0x32908a[_0x16cb6a]['field'],_0x22abc9=_0x32908a[_0x16cb6a][_0x48461b('0xc')]?_[_0x48461b('0x55')](_0x267fa2[_0x32908a[_0x16cb6a][_0x48461b('0xc')]],'%s',_0x22abc9):_0x22abc9,_0x22abc9=_0x32908a[_0x16cb6a]['format']?_[_0x48461b('0x55')](_0x2a2d82[_0x32908a[_0x16cb6a][_0x48461b('0x12')]],'%s',_0x22abc9):_0x22abc9,_0x32908a[_0x16cb6a][_0x48461b('0x1a')]&&_0x2f5a0e[_0x48461b('0x1c')](_0x22abc9),_0x32908a[_0x16cb6a][_0x48461b('0x7a')]&&_0x2f5a0e[_0x48461b('0x15')](_0x22abc9,_0x32908a[_0x16cb6a][_0x48461b('0x7a')]===_0x48461b('0x38')?![]:!![]),_0x2f5a0e['field'](_0x22abc9,_0x32908a[_0x16cb6a][_0x48461b('0x40')]||_0x22abc9);}if(_0xee815e['joins']){_0xee815e['joins']=JSON[_0x48461b('0x82')](_0xee815e['joins']);for(let _0x64b5c6=0x0;_0x64b5c6<_0xee815e[_0x48461b('0x70')]['length'];_0x64b5c6+=0x1){_0xee815e[_0x48461b('0x70')][_0x64b5c6]['type']&&_[_0x48461b('0x39')](_0x45a556,_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x2d')])&&_0xee815e['joins'][_0x64b5c6][_0x48461b('0x5a')]&&_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x6f')]&&_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x6a')]&&_0x2f5a0e[_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x2d')]](_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x6f')],null,util[_0x48461b('0x12')]('%s.%s\x20=\x20%s.%s',_0xee815e[_0x48461b('0x74')],_0xee815e['joins'][_0x64b5c6][_0x48461b('0x5a')],_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x6f')],_0xee815e[_0x48461b('0x70')][_0x64b5c6][_0x48461b('0x6a')]));}}return _0xee815e[_0x48461b('0x8d')]&&(_0xee815e[_0x48461b('0x8d')]=JSON[_0x48461b('0x82')](_0xee815e[_0x48461b('0x8d')]),_0x2f5a0e[_0x48461b('0x3a')](_0x41170e(_0xee815e[_0x48461b('0x8d')][_0x48461b('0x1c')]))),_0x2f5a0e['limit'](_0x58f1f8),_0x2f5a0e[_0x48461b('0x5e')](0x0),logger[_0x48461b('0x19')](_0x48461b('0x61'),_0x2f5a0e[_0x48461b('0x35')]()),db[_0x48461b('0x46')][_0x48461b('0x9')](_0x2f5a0e[_0x48461b('0x35')](),{'type':QueryTypes[_0x48461b('0x64')]});}})[_0x203ee7('0x26')](respondWithResult(_0x18b72f,null))['catch'](handleError(_0x18b72f,null));};function runReport(_0x446933,_0x478a95,_0x39aae9){const _0x287540=_0xa48b17,_0x5d68a7=_0x478a95[_0x287540('0x48')],_0x448108=0xa,_0x49ccab=[_0x287540('0x21'),_0x287540('0x18'),'right_join',_0x287540('0x76')],_0x21c72c={'SUM':_0x287540('0x1b'),'COUNT':_0x287540('0x80'),'COUNT\x20DISTINCT':_0x287540('0x36'),'MAX':_0x287540('0x83'),'MIN':_0x287540('0x47'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x287540('0x5d'),'GROUP_CONCAT\x20ASC':_0x287540('0x2b'),'GROUP_CONCAT\x20DESC':_0x287540('0x45')},_0xbaee03={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x287540('0xe'),'HOUR':_0x287540('0x52'),'ROUND':_0x287540('0x11'),'UNIX_TIMESTAMP':_0x287540('0x6d')},_0x1aef21=function(_0x37648b){const _0x529dc4=_0x287540;return!_['includes']([_0x529dc4('0x94'),'IS\x20NOT\x20NULL',_0x529dc4('0x2c'),_0x529dc4('0x5c')],_0x37648b);},_0x3ca50c=function(_0x318561){const _0x5791dd=_0x287540;if(!_0x318561||!_0x318561['rules'][_0x5791dd('0x69')])return'';let _0x141f8b='(';for(let _0x548034=0x0;_0x548034<_0x318561[_0x5791dd('0x20')][_0x5791dd('0x69')];_0x548034+=0x1){_0x548034>0x0&&(_0x141f8b+='\x20'+_0x318561[_0x5791dd('0x75')]+'\x20'),_0x141f8b+=_0x318561[_0x5791dd('0x20')][_0x548034][_0x5791dd('0x1c')]?_0x3ca50c(_0x318561[_0x5791dd('0x20')][_0x548034][_0x5791dd('0x1c')]):_0x318561['rules'][_0x548034][_0x5791dd('0x32')]+'\x20'+_0x318561[_0x5791dd('0x20')][_0x548034][_0x5791dd('0x73')]+(_0x1aef21(_0x318561[_0x5791dd('0x20')][_0x548034][_0x5791dd('0x73')])?'\x20'+_0x318561[_0x5791dd('0x20')][_0x548034]['value']:'');}return _0x141f8b+')';};let _0x16ebf5={'where':{'id':_0x446933['id']}},_0x35208e,_0x473e79,_0x4c91b1,_0x30477f,_0x572071;return _0x16ebf5=_[_0x287540('0xa')]({},_0x16ebf5,_0x39aae9),db[_0x287540('0x50')][_0x287540('0x4b')](_0x16ebf5)[_0x287540('0x26')](function(_0x19331c){const _0x3da432=_0x287540;if(_0x19331c)return _0x35208e=_0x19331c,_0x19331c[_0x3da432('0x3d')]();return null;})['then'](function(_0x505a1b){const _0x29614a=_0x287540;if(_0x505a1b){if(!_0x505a1b[_0x29614a('0x69')])throw new ValidationErrorItem(_0x29614a('0x5'),0x193);return _0x473e79=_0x505a1b,db[_0x29614a('0x84')][_0x29614a('0x1d')]({'raw':!![]});}return null;})[_0x287540('0x26')](function(_0xbd6a48){const _0x32905c=_0x287540;if(_0xbd6a48){_0x4c91b1=_[_0x32905c('0x3c')](_0xbd6a48,'id');let _0x501a81;const _0x31ba86=squel['select']();_0x31ba86[_0x32905c('0x85')](_0x35208e[_0x32905c('0x74')]);for(let _0x48285d=0x0;_0x48285d<_0x473e79[_0x32905c('0x69')];_0x48285d+=0x1){_0x501a81=_0x473e79[_0x48285d][_0x32905c('0x72')]?_0x4c91b1[_0x473e79[_0x48285d][_0x32905c('0x72')]][_0x32905c('0x2e')]:_0x473e79[_0x48285d][_0x32905c('0x32')],_0x501a81=_0x473e79[_0x48285d]['function']?_[_0x32905c('0x55')](_0x21c72c[_0x473e79[_0x48285d]['function']],'%s',_0x501a81):_0x501a81,_0x501a81=_0x473e79[_0x48285d]['format']?_[_0x32905c('0x55')](_0xbaee03[_0x473e79[_0x48285d][_0x32905c('0x12')]],'%s',_0x501a81):_0x501a81,_0x473e79[_0x48285d][_0x32905c('0x1a')]&&_0x31ba86['group'](_0x501a81),_0x473e79[_0x48285d]['orderBy']&&_0x31ba86[_0x32905c('0x15')](_0x501a81,_0x473e79[_0x48285d][_0x32905c('0x7a')]===_0x32905c('0x38')?![]:!![]),_0x31ba86[_0x32905c('0x32')](_0x501a81,_0x473e79[_0x48285d][_0x32905c('0x40')]||_0x501a81);}if(_0x35208e[_0x32905c('0x70')]){_0x35208e[_0x32905c('0x70')]=JSON[_0x32905c('0x82')](_0x35208e['joins']);for(let _0x5dd85d=0x0;_0x5dd85d<_0x35208e[_0x32905c('0x70')][_0x32905c('0x69')];_0x5dd85d+=0x1){_0x35208e[_0x32905c('0x70')][_0x5dd85d]['type']&&_['includes'](_0x49ccab,_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x2d')])&&_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x5a')]&&_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x6f')]&&_0x35208e['joins'][_0x5dd85d][_0x32905c('0x6a')]&&_0x31ba86[_0x35208e['joins'][_0x5dd85d][_0x32905c('0x2d')]](_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x6f')],null,util['format'](_0x32905c('0x42'),_0x35208e['table'],_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x5a')],_0x35208e[_0x32905c('0x70')][_0x5dd85d][_0x32905c('0x6f')],_0x35208e[_0x32905c('0x70')][_0x5dd85d]['foreignKey']));}}return _0x35208e['conditions']&&(_0x35208e['conditions']=JSON['parse'](_0x35208e[_0x32905c('0x8d')]),_0x31ba86[_0x32905c('0x3a')](_0x3ca50c(_0x35208e[_0x32905c('0x8d')]['group']))),_0x572071=_0x31ba86[_0x32905c('0x8c')](),_0x31ba86['limit'](_0x448108),_0x31ba86[_0x32905c('0x5e')](0x0),logger['debug'](_0x32905c('0x61'),_0x31ba86[_0x32905c('0x35')]()),db[_0x32905c('0x46')][_0x32905c('0x9')](_0x31ba86['toString'](),{'type':QueryTypes[_0x32905c('0x64')]});}})[_0x287540('0x26')](function(_0x3322dc){const _0x58cf4e=_0x287540;if(!_0x3322dc[_0x58cf4e('0x69')])throw new ValidationErrorItem(_0x58cf4e('0x17'),0xcc);if(_0x478a95[_0x58cf4e('0x0')]===_0x58cf4e('0x33'))return null;const _0x59f74c=_['merge'](_0x478a95,{'name':_0x478a95[_0x58cf4e('0x1e')]||_0x478a95[_0x58cf4e('0x48')]||_0x35208e[_0x58cf4e('0x48')],'basename':_0x5d68a7,'savename':util[_0x58cf4e('0x12')](_0x58cf4e('0x37'),_0x478a95[_0x58cf4e('0x48')]||_0x35208e[_0x58cf4e('0x48')],require(_0x58cf4e('0x66'))[_0x58cf4e('0x7')](0x4),_0x478a95[_0x58cf4e('0x0')]||_0x58cf4e('0x6')),'reportId':_0x35208e['id'],'reportType':_0x58cf4e('0x25')});return db[_0x58cf4e('0x58')]['create'](_0x59f74c,{'raw':!![]});})[_0x287540('0x26')](function(_0x3b8592){const _0x519fe3=_0x287540;_0x35208e['table']===_0x519fe3('0x5b')?_0x572071['where'](_0x35208e[_0x519fe3('0x74')]+_0x519fe3('0x7b'),_0x478a95['startDate'],_0x478a95[_0x519fe3('0x31')]):_0x572071[_0x519fe3('0x3a')](_0x35208e['table']+_0x519fe3('0x8f'),_0x478a95[_0x519fe3('0x43')],_0x478a95[_0x519fe3('0x31')]);if(_0x3b8592)return logger[_0x519fe3('0x7d')](_0x519fe3('0x77'),_0x572071[_0x519fe3('0x35')]()),require(_0x519fe3('0x29'))[_0x519fe3('0x71')](path['join'](__dirname,_0x519fe3('0x91'),_0x3b8592[_0x519fe3('0x0')]),[_0x3b8592['id'],_0x572071[_0x519fe3('0x35')](),path[_0x519fe3('0x21')](__dirname,_0x519fe3('0x49'),_0x3b8592['savename']),_0x5d68a7]),_0x3b8592;else{const _0x3c8a0b=squel[_0x519fe3('0x86')]();return _0x3c8a0b[_0x519fe3('0x85')]('('+_0x572071[_0x519fe3('0x35')]()+')',_0x519fe3('0x4d')),_0x3c8a0b[_0x519fe3('0x32')](_0x519fe3('0x90'),_0x519fe3('0x6e')),_0x572071[_0x519fe3('0x68')](_0x478a95[_0x519fe3('0x68')]||_0x448108),_0x572071['offset'](_0x478a95[_0x519fe3('0x5e')]||0x0),dbH[_0x519fe3('0x46')]['query'](_0x3c8a0b['toString'](),{'type':dbH[_0x519fe3('0x46')][_0x519fe3('0xd')][_0x519fe3('0x64')]})[_0x519fe3('0x26')](function(_0x284f5e){const _0x216fff=_0x519fe3;return!_0x284f5e[_0x216fff('0x69')]?_0x30477f=0x0:_0x30477f=_0x284f5e[0x0][_0x216fff('0x6e')]||0x0,dbH[_0x216fff('0x46')][_0x216fff('0x9')](_0x572071[_0x216fff('0x35')](),{'type':dbH[_0x216fff('0x46')][_0x216fff('0xd')][_0x216fff('0x64')]});})[_0x519fe3('0x26')](function(_0x44e773){return{'rows':_0x44e773||[],'count':_0x30477f};});}});}exports[_0xa48b17('0x62')]=function(_0x5728f1,_0x4a77a6){const _0x4b8ca0=_0xa48b17;return runReport(_0x5728f1[_0x4b8ca0('0x92')],_0x5728f1[_0x4b8ca0('0x9')],_0x5728f1[_0x4b8ca0('0x7f')])[_0x4b8ca0('0x26')](respondWithResult(_0x4a77a6,null))['catch'](handleError(_0x4a77a6,null));},exports[_0xa48b17('0x1f')]=runReport,exports['query']=function(_0x35be1d,_0x2f83d1){const _0x126e62=_0xa48b17,_0x124214=0xa,_0xb3798b=['join',_0x126e62('0x18'),_0x126e62('0x67'),'cross_join'],_0x31828e={'SUM':'SUM(%s)','COUNT':_0x126e62('0x80'),'COUNT\x20DISTINCT':_0x126e62('0x36'),'MAX':_0x126e62('0x83'),'MIN':_0x126e62('0x47'),'AVG':_0x126e62('0x63'),'GROUP_CONCAT':_0x126e62('0x5d'),'GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0x126e62('0x45')},_0x3b48e1={'SEC_TO_TIME':_0x126e62('0x30'),'DATE':_0x126e62('0xe'),'HOUR':_0x126e62('0x52'),'ROUND':_0x126e62('0x11'),'UNIX_TIMESTAMP':_0x126e62('0x6d')},_0x2361d9=function(_0xb944ec){const _0x31909a=_0x126e62;return!_[_0x31909a('0x39')]([_0x31909a('0x94'),_0x31909a('0x8b'),_0x31909a('0x2c'),_0x31909a('0x5c')],_0xb944ec);},_0x12ccee=function(_0x1a6a3c){const _0x1333a9=_0x126e62;if(!_0x1a6a3c||!_0x1a6a3c['rules'][_0x1333a9('0x69')])return'';let _0x2ab855='(';for(let _0x28d5d8=0x0;_0x28d5d8<_0x1a6a3c[_0x1333a9('0x20')][_0x1333a9('0x69')];_0x28d5d8+=0x1){_0x28d5d8>0x0&&(_0x2ab855+='\x20'+_0x1a6a3c['operator']+'\x20'),_0x2ab855+=_0x1a6a3c['rules'][_0x28d5d8]['group']?_0x12ccee(_0x1a6a3c['rules'][_0x28d5d8]['group']):_0x1a6a3c[_0x1333a9('0x20')][_0x28d5d8][_0x1333a9('0x32')]+'\x20'+_0x1a6a3c[_0x1333a9('0x20')][_0x28d5d8][_0x1333a9('0x73')]+(_0x2361d9(_0x1a6a3c[_0x1333a9('0x20')][_0x28d5d8][_0x1333a9('0x73')])?'\x20'+_0x1a6a3c[_0x1333a9('0x20')][_0x28d5d8][_0x1333a9('0x22')]:'');}return _0x2ab855+')';};let _0x18c786={'where':{'id':_0x35be1d[_0x126e62('0x92')]['id']}},_0x48fd49,_0x43ccca,_0x58b6f7,_0x52e0ac;return _0x18c786=_[_0x126e62('0xa')]({},_0x18c786,_0x35be1d[_0x126e62('0x7f')]),db['AnalyticDefaultReport']['findOne'](_0x18c786)[_0x126e62('0x26')](function(_0x1782f5){const _0x3761e2=_0x126e62;if(_0x1782f5)return _0x48fd49=_0x1782f5,_0x1782f5[_0x3761e2('0x3d')]();return null;})[_0x126e62('0x26')](function(_0x422b3b){const _0x2760bc=_0x126e62;if(_0x422b3b){if(!_0x422b3b[_0x2760bc('0x69')])throw new ValidationErrorItem(_0x2760bc('0x5'),0x193);return _0x43ccca=_0x422b3b,db[_0x2760bc('0x84')]['findAll']({'raw':!![]});}return null;})[_0x126e62('0x26')](function(_0x33b2a9){const _0x4594ca=_0x126e62;if(_0x33b2a9){_0x58b6f7=_[_0x4594ca('0x3c')](_0x33b2a9,'id');let _0xf1cb50;const _0x30aa43=squel[_0x4594ca('0x86')]();_0x30aa43[_0x4594ca('0x85')](_0x48fd49[_0x4594ca('0x74')]);for(let _0x4a07bb=0x0;_0x4a07bb<_0x43ccca[_0x4594ca('0x69')];_0x4a07bb+=0x1){_0xf1cb50=_0x43ccca[_0x4a07bb]['MetricId']?_0x58b6f7[_0x43ccca[_0x4a07bb][_0x4594ca('0x72')]][_0x4594ca('0x2e')]:_0x43ccca[_0x4a07bb][_0x4594ca('0x32')],_0xf1cb50=_0x43ccca[_0x4a07bb]['function']?_['replace'](_0x31828e[_0x43ccca[_0x4a07bb]['function']],'%s',_0xf1cb50):_0xf1cb50,_0xf1cb50=_0x43ccca[_0x4a07bb][_0x4594ca('0x12')]?_[_0x4594ca('0x55')](_0x3b48e1[_0x43ccca[_0x4a07bb]['format']],'%s',_0xf1cb50):_0xf1cb50,_0x43ccca[_0x4a07bb][_0x4594ca('0x1a')]&&_0x30aa43[_0x4594ca('0x1c')](_0xf1cb50),_0x43ccca[_0x4a07bb][_0x4594ca('0x7a')]&&_0x30aa43[_0x4594ca('0x15')](_0xf1cb50,_0x43ccca[_0x4a07bb]['orderBy']===_0x4594ca('0x38')?![]:!![]),_0x30aa43[_0x4594ca('0x32')](_0xf1cb50,_0x43ccca[_0x4a07bb][_0x4594ca('0x40')]||_0xf1cb50);}if(_0x48fd49['joins']){_0x48fd49[_0x4594ca('0x70')]=JSON[_0x4594ca('0x82')](_0x48fd49['joins']);for(let _0x15c215=0x0;_0x15c215<_0x48fd49[_0x4594ca('0x70')][_0x4594ca('0x69')];_0x15c215+=0x1){_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x2d')]&&_[_0x4594ca('0x39')](_0xb3798b,_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x2d')])&&_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x5a')]&&_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x6f')]&&_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x6a')]&&_0x30aa43[_0x48fd49[_0x4594ca('0x70')][_0x15c215]['type']](_0x48fd49['joins'][_0x15c215]['foreignTable'],null,util[_0x4594ca('0x12')]('%s.%s\x20=\x20%s.%s',_0x48fd49[_0x4594ca('0x74')],_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x5a')],_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x6f')],_0x48fd49[_0x4594ca('0x70')][_0x15c215][_0x4594ca('0x6a')]));}}return _0x48fd49[_0x4594ca('0x8d')]&&(_0x48fd49[_0x4594ca('0x8d')]=JSON['parse'](_0x48fd49[_0x4594ca('0x8d')]),_0x30aa43[_0x4594ca('0x3a')](_0x12ccee(_0x48fd49['conditions']['group']))),_0x52e0ac=_0x30aa43[_0x4594ca('0x8c')](),_0x30aa43[_0x4594ca('0x68')](_0x124214),_0x30aa43[_0x4594ca('0x5e')](0x0),logger['debug']('Limited\x20Query:',_0x30aa43['toString']()),db[_0x4594ca('0x46')]['query'](_0x30aa43[_0x4594ca('0x35')](),{'type':QueryTypes['SELECT']});}})[_0x126e62('0x26')](function(){const _0x22a717=_0x126e62;return{'sql':_0x52e0ac[_0x22a717('0x35')]()};})['then'](respondWithResult(_0x2f83d1,null))[_0x126e62('0x4f')](handleError(_0x2f83d1,null));};
\ No newline at end of file
+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));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff