-const a9_0x29c2=['joins','catch','ROUND(%s)','userProfileId','foreignTable','keyBy','includeAll','fork','HOUR(%s)','stack','../../components/export/','select','filters','util','replace','undefined','include','SELECT','operator','preview','body','end','startDate','update','info','function','AnalyticDefaultReport','DATE(%s)','COUNT(*)','sequelize','endDate','create','Please\x20insert\x20at\x20least\x20one\x20field','condition','show','model','limit','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','Limited\x20Query:','metric','attributes','SEC_TO_TIME(%s)','.createdAt\x20BETWEEN\x20?\x20AND\x20?','then','MIN(%s)','keys','right_join','includes','COUNT(%s)','randomstring','../../config/logger','orderBy','toString','lodash','fullPath','csv','count','IS\x20EMPTY','get','format','parentKey','group','options','COUNT(DISTINCT\x20%s)','findAll','groupBy','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','../../components/parsers/qs','merge','alias','status','map','dbH','conditions','destroy','clone','../../mysqldb','countTable','IS\x20NOT\x20EMPTY','UNIX_TIMESTAMP(%s)','findOne','IS\x20NOT\x20NULL','fields','GROUP_CONCAT(%s)','UserProfileSection','role','MetricId','filter','generate','Content-Range','params','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','IS\x20NULL','name','pick','order','AnalyticMetric','DESC','runReport','foreignKey','key','fieldName','type','from','sort','AVG(%s)','DefaultReports','AnalyticExtractedReport','../../files/reports','rules','value','table','debug','child_process','sendStatus','like','output','nolimit','SUM(%s)','rawAttributes','field','squel','set','default','%s.%s\x20=\x20%s.%s','cross_join','join','intersection','error','getFields','QueryTypes','index','MAX(%s)','parse','left_join','where','json','user','UserProfileResource','query','length','Unable\x20to\x20retrieve\x20the\x20current\x20user','offset'];(function(_0x2b9487,_0x29c25e){const _0x194a2c=function(_0x2b8d94){while(--_0x2b8d94){_0x2b9487['push'](_0x2b9487['shift']());}};_0x194a2c(++_0x29c25e);}(a9_0x29c2,0xf8));const a9_0x194a=function(_0x2b9487,_0x29c25e){_0x2b9487=_0x2b9487-0x0;let _0x194a2c=a9_0x29c2[_0x2b9487];return _0x194a2c;};const _0x5ebedc=a9_0x194a;'use strict';const util=require(_0x5ebedc('0x33')),path=require('path'),_=require(_0x5ebedc('0x5b')),squel=require(_0x5ebedc('0x10')),qs=require(_0x5ebedc('0x69')),logger=require(_0x5ebedc('0x58'))('api'),db=require(_0x5ebedc('0x72'))['db'],dbH=require(_0x5ebedc('0x72'))[_0x5ebedc('0x6e')],{Op,ValidationErrorItem,QueryTypes}=require(_0x5ebedc('0x43'));function respondWithResult(_0x2b8d94,_0xaed44e){return _0xaed44e=_0xaed44e||0xc8,function(_0x280126){const _0x3dc7af=a9_0x194a;if(_0x280126)return _0x2b8d94[_0x3dc7af('0x6c')](_0xaed44e)[_0x3dc7af('0x1f')](_0x280126);};}function respondWithFilteredResult(_0x16b713,_0x1ed7e0){return function(_0x5dac99){const _0x44ea92=a9_0x194a;if(_0x5dac99){const _0x28fb46=_0x5dac99[_0x44ea92('0x5e')],_0x46173f=_0x1ed7e0['offset'];let _0xd51537=_0x1ed7e0[_0x44ea92('0x25')]+_0x1ed7e0[_0x44ea92('0x4a')],_0x21d79e;return _0xd51537>=_0x28fb46?(_0xd51537=_0x28fb46,_0x21d79e=0xc8):_0x21d79e=0xce,_0x16b713[_0x44ea92('0x6c')](_0x21d79e),_0x16b713[_0x44ea92('0x11')](_0x44ea92('0x7f'),_0x46173f+'-'+_0xd51537+'/'+_0x28fb46)[_0x44ea92('0x1f')](_0x5dac99);}return null;};}function saveUpdates(_0x4bfffd){return function(_0x42c874){const _0x3c0fd8=a9_0x194a;if(_0x42c874)return _0x42c874[_0x3c0fd8('0x3d')](_0x4bfffd)[_0x3c0fd8('0x51')](function(_0x3bd331){return _0x3bd331;});return null;};}function removeEntity(_0x8dcee6){return function(_0x264fed){const _0x41beae=a9_0x194a;if(_0x264fed)return _0x264fed['destroy']()[_0x41beae('0x51')](function(){const _0x3b60a7=_0x41beae,_0x2b10c2=_0x264fed[_0x3b60a7('0x60')]({'plain':!![]}),_0x41d6be='DefaultReports';return db[_0x3b60a7('0x21')][_0x3b60a7('0x70')]({'where':{'type':_0x41d6be,'resourceId':_0x2b10c2['id']}})[_0x3b60a7('0x51')](function(){return _0x264fed;});})[_0x41beae('0x51')](function(){const _0x5a6f1a=_0x41beae;_0x8dcee6['status'](0xcc)[_0x5a6f1a('0x3b')]();});};}function handleEntityNotFound(_0x4912c3){return function(_0x2809cf){const _0x2566a3=a9_0x194a;return!_0x2809cf&&_0x4912c3[_0x2566a3('0x9')](0x194),_0x2809cf;};}function handleError(_0x152f7e,_0x56591f){return _0x56591f=_0x56591f||0x1f4,function(_0x423468){const _0x2779ae=a9_0x194a;logger['error'](_0x423468[_0x2779ae('0x2f')]),_0x423468[_0x2779ae('0x83')]&&delete _0x423468['name'],_0x152f7e['status'](_0x56591f)['send'](_0x423468);};}exports[_0x5ebedc('0x1a')]=function(_0x1df63a,_0x1935b5){const _0x136372=_0x5ebedc;let _0x53f1ee={};const _0x5dacef={},_0x272f78={'count':0x0,'rows':[]},_0x53d1bc=_['map'](db[_0x136372('0x40')]['rawAttributes'],function(_0x26d512){const _0xd64ac8=_0x136372;return{'name':_0x26d512[_0xd64ac8('0x8b')],'type':_0x26d512[_0xd64ac8('0x8c')][_0xd64ac8('0x8a')]};});_0x5dacef['model']=_[_0x136372('0x6d')](_0x53d1bc,_0x136372('0x83')),_0x5dacef[_0x136372('0x22')]=_[_0x136372('0x53')](_0x1df63a['query']),_0x5dacef['filters']=_[_0x136372('0x16')](_0x5dacef[_0x136372('0x49')],_0x5dacef[_0x136372('0x22')]),_0x53f1ee['attributes']=_[_0x136372('0x16')](_0x5dacef[_0x136372('0x49')],qs[_0x136372('0x78')](_0x1df63a['query']['fields'])),_0x53f1ee[_0x136372('0x4e')]=_0x53f1ee[_0x136372('0x4e')][_0x136372('0x23')]?_0x53f1ee[_0x136372('0x4e')]:_0x5dacef[_0x136372('0x49')];typeof _0x1df63a[_0x136372('0x22')][_0x136372('0xc')]===_0x136372('0x35')&&(_0x53f1ee[_0x136372('0x4a')]=qs[_0x136372('0x4a')](_0x1df63a[_0x136372('0x22')]['limit']),_0x53f1ee[_0x136372('0x25')]=qs[_0x136372('0x25')](_0x1df63a['query']['offset']));_0x53f1ee[_0x136372('0x85')]=qs[_0x136372('0x8e')](_0x1df63a[_0x136372('0x22')][_0x136372('0x8e')]),_0x53f1ee[_0x136372('0x1e')]=qs[_0x136372('0x32')](_[_0x136372('0x84')](_0x1df63a['query'],_0x5dacef['filters']),_0x53d1bc);_0x1df63a[_0x136372('0x22')][_0x136372('0x7d')]&&(_0x53f1ee[_0x136372('0x1e')]=_[_0x136372('0x6a')](_0x53f1ee[_0x136372('0x1e')],{[Op['or']]:_[_0x136372('0x6d')](_0x53d1bc,function(_0x199fa4){const _0xf659=_0x136372;if(_0x199fa4[_0xf659('0x8c')]!=='VIRTUAL'){const _0x4c85d7={};return _0x4c85d7[_0x199fa4['name']]={[Op[_0xf659('0xa')]]:'%'+_0x1df63a['query'][_0xf659('0x7d')]+'%'},_0x4c85d7;}})}));_0x53f1ee=_[_0x136372('0x6a')]({},_0x53f1ee,_0x1df63a['options']);const _0x168f72={'where':_0x53f1ee['where']};return db[_0x136372('0x40')][_0x136372('0x5e')](_0x168f72)[_0x136372('0x51')](function(_0x5943e8){const _0x3d0fc0=_0x136372;return _0x272f78[_0x3d0fc0('0x5e')]=_0x5943e8,_0x1df63a[_0x3d0fc0('0x22')][_0x3d0fc0('0x2c')]&&(_0x53f1ee[_0x3d0fc0('0x36')]=[{'all':!![]}]),db['AnalyticDefaultReport'][_0x3d0fc0('0x66')](_0x53f1ee);})['then'](function(_0x3741a1){return _0x272f78['rows']=_0x3741a1,_0x272f78;})[_0x136372('0x51')](respondWithFilteredResult(_0x1935b5,_0x53f1ee))['catch'](handleError(_0x1935b5,null));},exports[_0x5ebedc('0x48')]=function(_0x1c1d48,_0x5ae98e){const _0x15c81a=_0x5ebedc;let _0x3d767e={'raw':!![],'where':{'id':_0x1c1d48['params']['id']}};const _0x5d9484={};return _0x5d9484[_0x15c81a('0x49')]=_[_0x15c81a('0x53')](db[_0x15c81a('0x40')][_0x15c81a('0xe')]),_0x5d9484[_0x15c81a('0x22')]=_['keys'](_0x1c1d48[_0x15c81a('0x22')]),_0x5d9484[_0x15c81a('0x32')]=_[_0x15c81a('0x16')](_0x5d9484[_0x15c81a('0x49')],_0x5d9484[_0x15c81a('0x22')]),_0x3d767e[_0x15c81a('0x4e')]=_[_0x15c81a('0x16')](_0x5d9484[_0x15c81a('0x49')],qs[_0x15c81a('0x78')](_0x1c1d48[_0x15c81a('0x22')]['fields'])),_0x3d767e[_0x15c81a('0x4e')]=_0x3d767e[_0x15c81a('0x4e')][_0x15c81a('0x23')]?_0x3d767e[_0x15c81a('0x4e')]:_0x5d9484[_0x15c81a('0x49')],_0x1c1d48['query']['includeAll']&&(_0x3d767e[_0x15c81a('0x36')]=[{'all':!![]}]),_0x3d767e=_[_0x15c81a('0x6a')]({},_0x3d767e,_0x1c1d48[_0x15c81a('0x64')]),db[_0x15c81a('0x40')][_0x15c81a('0x76')](_0x3d767e)['then'](handleEntityNotFound(_0x5ae98e,null))[_0x15c81a('0x51')](respondWithResult(_0x5ae98e,null))['catch'](handleError(_0x5ae98e,null));},exports[_0x5ebedc('0x45')]=function(_0x273e34,_0xab9d29){const _0x3deb83=_0x5ebedc;return db['AnalyticDefaultReport'][_0x3deb83('0x45')](_0x273e34['body'],{})['then'](function(_0x4eb4de){const _0x3c59a0=_0x3deb83,_0x5b93d1=_0x273e34[_0x3c59a0('0x20')][_0x3c59a0('0x60')]({'plain':!![]});if(!_0x5b93d1)throw new Error(_0x3c59a0('0x24'));if(_0x5b93d1[_0x3c59a0('0x7b')]===_0x3c59a0('0x20')){const _0x350569=_0x4eb4de[_0x3c59a0('0x60')]({'plain':!![]}),_0x543fbd='Reports';return db[_0x3c59a0('0x7a')][_0x3c59a0('0x76')]({'where':{'name':_0x543fbd,'userProfileId':_0x5b93d1[_0x3c59a0('0x29')]},'raw':!![]})[_0x3c59a0('0x51')](function(_0x5d84da){const _0x5181d6=_0x3c59a0;return _0x5d84da&&_0x5d84da['autoAssociation']===0x0?db[_0x5181d6('0x21')]['create']({'name':_0x350569[_0x5181d6('0x83')],'resourceId':_0x350569['id'],'type':_0x5181d6('0x1'),'sectionId':_0x5d84da['id']},{})[_0x5181d6('0x51')](function(){return _0x4eb4de;}):_0x4eb4de;})[_0x3c59a0('0x27')](function(_0x775d32){const _0x34493e=_0x3c59a0;logger[_0x34493e('0x17')](_0x34493e('0x4b'),_0x775d32);throw _0x775d32;});}return _0x4eb4de;})['then'](respondWithResult(_0xab9d29,0xc9))['catch'](handleError(_0xab9d29,null));},exports[_0x5ebedc('0x3d')]=function(_0x3bd106,_0x356c1e){const _0x5c12cd=_0x5ebedc;return _0x3bd106[_0x5c12cd('0x3a')]['id']&&delete _0x3bd106[_0x5c12cd('0x3a')]['id'],db['AnalyticDefaultReport'][_0x5c12cd('0x76')]({'where':{'id':_0x3bd106[_0x5c12cd('0x80')]['id']}})['then'](handleEntityNotFound(_0x356c1e,null))[_0x5c12cd('0x51')](saveUpdates(_0x3bd106['body'],null))[_0x5c12cd('0x51')](respondWithResult(_0x356c1e,null))[_0x5c12cd('0x27')](handleError(_0x356c1e,null));},exports[_0x5ebedc('0x70')]=function(_0x84557c,_0x5a24b1){const _0x434ee0=_0x5ebedc;return db['AnalyticDefaultReport']['findOne']({'where':{'id':_0x84557c[_0x434ee0('0x80')]['id']}})['then'](handleEntityNotFound(_0x5a24b1,null))['then'](removeEntity(_0x5a24b1,null))[_0x434ee0('0x27')](handleError(_0x5a24b1,null));},exports[_0x5ebedc('0x39')]=function(_0x4e089a,_0x5eee15){const _0x1729b0=_0x5ebedc,_0x1879b4=0xa,_0x5622b7=[_0x1729b0('0x15'),'left_join',_0x1729b0('0x54'),_0x1729b0('0x14')],_0x594638={'SUM':'SUM(%s)','COUNT':_0x1729b0('0x56'),'COUNT\x20DISTINCT':_0x1729b0('0x65'),'MAX':_0x1729b0('0x1b'),'MIN':_0x1729b0('0x52'),'AVG':_0x1729b0('0x0'),'GROUP_CONCAT':_0x1729b0('0x79'),'GROUP_CONCAT\x20ASC':_0x1729b0('0x68'),'GROUP_CONCAT\x20DESC':_0x1729b0('0x81')},_0x2fb1f3={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x1729b0('0x28'),'UNIX_TIMESTAMP':_0x1729b0('0x75')},_0x440d66=function(_0x326dd4){const _0x438d10=_0x1729b0;return!_[_0x438d10('0x55')](['IS\x20NULL',_0x438d10('0x77'),_0x438d10('0x5f'),_0x438d10('0x74')],_0x326dd4);},_0x381db8=function(_0x3ad975){const _0x3f1ea2=_0x1729b0;if(!_0x3ad975||!_0x3ad975['rules']['length'])return'';let _0x3f8336='(';for(let _0x390437=0x0;_0x390437<_0x3ad975[_0x3f1ea2('0x4')]['length'];_0x390437+=0x1){_0x390437>0x0&&(_0x3f8336+='\x20'+_0x3ad975[_0x3f1ea2('0x38')]+'\x20'),_0x3f8336+=_0x3ad975[_0x3f1ea2('0x4')][_0x390437][_0x3f1ea2('0x63')]?_0x381db8(_0x3ad975[_0x3f1ea2('0x4')][_0x390437]['group']):_0x3ad975[_0x3f1ea2('0x4')][_0x390437][_0x3f1ea2('0xf')]+'\x20'+_0x3ad975[_0x3f1ea2('0x4')][_0x390437][_0x3f1ea2('0x47')]+(_0x440d66(_0x3ad975[_0x3f1ea2('0x4')][_0x390437]['condition'])?'\x20'+_0x3ad975[_0x3f1ea2('0x4')][_0x390437][_0x3f1ea2('0x5')]:'');}return _0x3f8336+')';};let _0x4ab19b={'where':{'id':_0x4e089a['params']['id']}},_0x4fb13b,_0x115b99,_0xf5e49e;return _0x4ab19b=_[_0x1729b0('0x6a')]({},_0x4ab19b,_0x4e089a[_0x1729b0('0x64')]),db[_0x1729b0('0x40')]['findOne'](_0x4ab19b)[_0x1729b0('0x51')](function(_0x58ee9d){const _0x280377=_0x1729b0;if(_0x58ee9d)return _0x4fb13b=_0x58ee9d,_0x58ee9d[_0x280377('0x18')]();return null;})[_0x1729b0('0x51')](function(_0x51c1c8){const _0x3876f3=_0x1729b0;if(_0x51c1c8){if(!_0x51c1c8[_0x3876f3('0x23')])throw new ValidationErrorItem(_0x3876f3('0x46'),0x193);return _0x115b99=_0x51c1c8,db[_0x3876f3('0x86')][_0x3876f3('0x66')]({'raw':!![]});}return null;})[_0x1729b0('0x51')](function(_0x46109a){const _0xce0c5e=_0x1729b0;if(_0x46109a){_0xf5e49e=_[_0xce0c5e('0x2b')](_0x46109a,'id');let _0x1897b2;const _0x2a26b3=squel[_0xce0c5e('0x31')]();_0x2a26b3[_0xce0c5e('0x8d')](_0x4fb13b[_0xce0c5e('0x6')]);for(let _0x24eb83=0x0;_0x24eb83<_0x115b99[_0xce0c5e('0x23')];_0x24eb83+=0x1){_0x1897b2=_0x115b99[_0x24eb83][_0xce0c5e('0x7c')]?_0xf5e49e[_0x115b99[_0x24eb83][_0xce0c5e('0x7c')]][_0xce0c5e('0x4d')]:_0x115b99[_0x24eb83][_0xce0c5e('0xf')],_0x1897b2=_0x115b99[_0x24eb83][_0xce0c5e('0x3f')]?_[_0xce0c5e('0x34')](_0x594638[_0x115b99[_0x24eb83]['function']],'%s',_0x1897b2):_0x1897b2,_0x1897b2=_0x115b99[_0x24eb83][_0xce0c5e('0x61')]?_[_0xce0c5e('0x34')](_0x2fb1f3[_0x115b99[_0x24eb83]['format']],'%s',_0x1897b2):_0x1897b2,_0x115b99[_0x24eb83][_0xce0c5e('0x67')]&&_0x2a26b3[_0xce0c5e('0x63')](_0x1897b2),_0x115b99[_0x24eb83][_0xce0c5e('0x59')]&&_0x2a26b3[_0xce0c5e('0x85')](_0x1897b2,_0x115b99[_0x24eb83][_0xce0c5e('0x59')]==='DESC'?![]:!![]),_0x2a26b3[_0xce0c5e('0xf')](_0x1897b2,_0x115b99[_0x24eb83][_0xce0c5e('0x6b')]||_0x1897b2);}if(_0x4fb13b['joins']){_0x4fb13b['joins']=JSON[_0xce0c5e('0x1c')](_0x4fb13b[_0xce0c5e('0x26')]);for(let _0x292554=0x0;_0x292554<_0x4fb13b[_0xce0c5e('0x26')][_0xce0c5e('0x23')];_0x292554+=0x1){_0x4fb13b['joins'][_0x292554][_0xce0c5e('0x8c')]&&_['includes'](_0x5622b7,_0x4fb13b[_0xce0c5e('0x26')][_0x292554][_0xce0c5e('0x8c')])&&_0x4fb13b['joins'][_0x292554][_0xce0c5e('0x62')]&&_0x4fb13b[_0xce0c5e('0x26')][_0x292554]['foreignTable']&&_0x4fb13b[_0xce0c5e('0x26')][_0x292554][_0xce0c5e('0x89')]&&_0x2a26b3[_0x4fb13b[_0xce0c5e('0x26')][_0x292554][_0xce0c5e('0x8c')]](_0x4fb13b[_0xce0c5e('0x26')][_0x292554][_0xce0c5e('0x2a')],null,util[_0xce0c5e('0x61')](_0xce0c5e('0x13'),_0x4fb13b['table'],_0x4fb13b[_0xce0c5e('0x26')][_0x292554]['parentKey'],_0x4fb13b[_0xce0c5e('0x26')][_0x292554]['foreignTable'],_0x4fb13b[_0xce0c5e('0x26')][_0x292554][_0xce0c5e('0x89')]));}}return _0x4fb13b[_0xce0c5e('0x6f')]&&(_0x4fb13b[_0xce0c5e('0x6f')]=JSON[_0xce0c5e('0x1c')](_0x4fb13b[_0xce0c5e('0x6f')]),_0x2a26b3[_0xce0c5e('0x1e')](_0x381db8(_0x4fb13b[_0xce0c5e('0x6f')][_0xce0c5e('0x63')]))),_0x2a26b3[_0xce0c5e('0x4a')](_0x1879b4),_0x2a26b3[_0xce0c5e('0x25')](0x0),logger[_0xce0c5e('0x7')](_0xce0c5e('0x4c'),_0x2a26b3['toString']()),db['sequelize'][_0xce0c5e('0x22')](_0x2a26b3[_0xce0c5e('0x5a')](),{'type':QueryTypes[_0xce0c5e('0x37')]});}})['then'](respondWithResult(_0x5eee15,null))['catch'](handleError(_0x5eee15,null));};function runReport(_0x370c9b,_0x31105f,_0x4f5f3c){const _0x5e87c1=_0x5ebedc,_0x4fd36d=_0x31105f[_0x5e87c1('0x83')],_0x427afa=0xa,_0x115172=[_0x5e87c1('0x15'),_0x5e87c1('0x1d'),'right_join','cross_join'],_0x23ad1c={'SUM':'SUM(%s)','COUNT':_0x5e87c1('0x56'),'COUNT\x20DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x5e87c1('0x1b'),'MIN':_0x5e87c1('0x52'),'AVG':_0x5e87c1('0x0'),'GROUP_CONCAT':_0x5e87c1('0x79'),'GROUP_CONCAT\x20ASC':_0x5e87c1('0x68'),'GROUP_CONCAT\x20DESC':_0x5e87c1('0x81')},_0x101691={'SEC_TO_TIME':_0x5e87c1('0x4f'),'DATE':_0x5e87c1('0x41'),'HOUR':_0x5e87c1('0x2e'),'ROUND':_0x5e87c1('0x28'),'UNIX_TIMESTAMP':_0x5e87c1('0x75')},_0x5d0238=function(_0x3fd95c){const _0x1fe8b1=_0x5e87c1;return!_[_0x1fe8b1('0x55')](['IS\x20NULL',_0x1fe8b1('0x77'),_0x1fe8b1('0x5f'),_0x1fe8b1('0x74')],_0x3fd95c);},_0x3c99af=function(_0x36927d){const _0x17e508=_0x5e87c1;if(!_0x36927d||!_0x36927d['rules'][_0x17e508('0x23')])return'';let _0x484b3a='(';for(let _0x26f137=0x0;_0x26f137<_0x36927d[_0x17e508('0x4')][_0x17e508('0x23')];_0x26f137+=0x1){_0x26f137>0x0&&(_0x484b3a+='\x20'+_0x36927d[_0x17e508('0x38')]+'\x20'),_0x484b3a+=_0x36927d[_0x17e508('0x4')][_0x26f137][_0x17e508('0x63')]?_0x3c99af(_0x36927d['rules'][_0x26f137][_0x17e508('0x63')]):_0x36927d[_0x17e508('0x4')][_0x26f137][_0x17e508('0xf')]+'\x20'+_0x36927d[_0x17e508('0x4')][_0x26f137]['condition']+(_0x5d0238(_0x36927d['rules'][_0x26f137][_0x17e508('0x47')])?'\x20'+_0x36927d[_0x17e508('0x4')][_0x26f137][_0x17e508('0x5')]:'');}return _0x484b3a+')';};let _0x5c4285={'where':{'id':_0x370c9b['id']}},_0x24ec37,_0x37c8e5,_0xcf876a,_0x2bc4cd,_0x398205;return _0x5c4285=_[_0x5e87c1('0x6a')]({},_0x5c4285,_0x4f5f3c),db[_0x5e87c1('0x40')][_0x5e87c1('0x76')](_0x5c4285)[_0x5e87c1('0x51')](function(_0x282fe0){if(_0x282fe0)return _0x24ec37=_0x282fe0,_0x282fe0['getFields']();return null;})[_0x5e87c1('0x51')](function(_0x281f9e){const _0x50e085=_0x5e87c1;if(_0x281f9e){if(!_0x281f9e['length'])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x37c8e5=_0x281f9e,db[_0x50e085('0x86')][_0x50e085('0x66')]({'raw':!![]});}return null;})[_0x5e87c1('0x51')](function(_0x383520){const _0x20c0c6=_0x5e87c1;if(_0x383520){_0xcf876a=_[_0x20c0c6('0x2b')](_0x383520,'id');let _0x23a490;const _0x52eac5=squel[_0x20c0c6('0x31')]();_0x52eac5[_0x20c0c6('0x8d')](_0x24ec37['table']);for(let _0x27f7d3=0x0;_0x27f7d3<_0x37c8e5[_0x20c0c6('0x23')];_0x27f7d3+=0x1){_0x23a490=_0x37c8e5[_0x27f7d3][_0x20c0c6('0x7c')]?_0xcf876a[_0x37c8e5[_0x27f7d3][_0x20c0c6('0x7c')]][_0x20c0c6('0x4d')]:_0x37c8e5[_0x27f7d3][_0x20c0c6('0xf')],_0x23a490=_0x37c8e5[_0x27f7d3]['function']?_[_0x20c0c6('0x34')](_0x23ad1c[_0x37c8e5[_0x27f7d3][_0x20c0c6('0x3f')]],'%s',_0x23a490):_0x23a490,_0x23a490=_0x37c8e5[_0x27f7d3]['format']?_[_0x20c0c6('0x34')](_0x101691[_0x37c8e5[_0x27f7d3]['format']],'%s',_0x23a490):_0x23a490,_0x37c8e5[_0x27f7d3][_0x20c0c6('0x67')]&&_0x52eac5[_0x20c0c6('0x63')](_0x23a490),_0x37c8e5[_0x27f7d3][_0x20c0c6('0x59')]&&_0x52eac5['order'](_0x23a490,_0x37c8e5[_0x27f7d3][_0x20c0c6('0x59')]===_0x20c0c6('0x87')?![]:!![]),_0x52eac5[_0x20c0c6('0xf')](_0x23a490,_0x37c8e5[_0x27f7d3][_0x20c0c6('0x6b')]||_0x23a490);}if(_0x24ec37[_0x20c0c6('0x26')]){_0x24ec37[_0x20c0c6('0x26')]=JSON['parse'](_0x24ec37[_0x20c0c6('0x26')]);for(let _0x529255=0x0;_0x529255<_0x24ec37[_0x20c0c6('0x26')][_0x20c0c6('0x23')];_0x529255+=0x1){_0x24ec37[_0x20c0c6('0x26')][_0x529255][_0x20c0c6('0x8c')]&&_[_0x20c0c6('0x55')](_0x115172,_0x24ec37['joins'][_0x529255]['type'])&&_0x24ec37[_0x20c0c6('0x26')][_0x529255][_0x20c0c6('0x62')]&&_0x24ec37[_0x20c0c6('0x26')][_0x529255]['foreignTable']&&_0x24ec37[_0x20c0c6('0x26')][_0x529255]['foreignKey']&&_0x52eac5[_0x24ec37[_0x20c0c6('0x26')][_0x529255]['type']](_0x24ec37[_0x20c0c6('0x26')][_0x529255][_0x20c0c6('0x2a')],null,util[_0x20c0c6('0x61')](_0x20c0c6('0x13'),_0x24ec37[_0x20c0c6('0x6')],_0x24ec37[_0x20c0c6('0x26')][_0x529255][_0x20c0c6('0x62')],_0x24ec37['joins'][_0x529255]['foreignTable'],_0x24ec37[_0x20c0c6('0x26')][_0x529255]['foreignKey']));}}return _0x24ec37[_0x20c0c6('0x6f')]&&(_0x24ec37[_0x20c0c6('0x6f')]=JSON[_0x20c0c6('0x1c')](_0x24ec37[_0x20c0c6('0x6f')]),_0x52eac5[_0x20c0c6('0x1e')](_0x3c99af(_0x24ec37[_0x20c0c6('0x6f')][_0x20c0c6('0x63')]))),_0x398205=_0x52eac5[_0x20c0c6('0x71')](),_0x52eac5[_0x20c0c6('0x4a')](_0x427afa),_0x52eac5[_0x20c0c6('0x25')](0x0),logger['debug']('Limited\x20Query:',_0x52eac5['toString']()),db[_0x20c0c6('0x43')][_0x20c0c6('0x22')](_0x52eac5[_0x20c0c6('0x5a')](),{'type':QueryTypes[_0x20c0c6('0x37')]});}})[_0x5e87c1('0x51')](function(_0x326684){const _0x287b4d=_0x5e87c1;if(!_0x326684[_0x287b4d('0x23')])throw new ValidationErrorItem('No\x20available\x20data',0xcc);if(_0x31105f[_0x287b4d('0xb')]==='web')return null;const _0x4d4461=_['merge'](_0x31105f,{'name':_0x31105f[_0x287b4d('0x5c')]||_0x31105f[_0x287b4d('0x83')]||_0x24ec37[_0x287b4d('0x83')],'basename':_0x4fd36d,'savename':util[_0x287b4d('0x61')]('%s-%s.%s',_0x31105f[_0x287b4d('0x83')]||_0x24ec37[_0x287b4d('0x83')],require(_0x287b4d('0x57'))[_0x287b4d('0x7e')](0x4),_0x31105f[_0x287b4d('0xb')]||_0x287b4d('0x5d')),'reportId':_0x24ec37['id'],'reportType':_0x287b4d('0x12')});return db[_0x287b4d('0x2')]['create'](_0x4d4461,{'raw':!![]});})[_0x5e87c1('0x51')](function(_0x29f005){const _0x1b12e5=_0x5e87c1;_0x24ec37[_0x1b12e5('0x6')]==='cdr'?_0x398205[_0x1b12e5('0x1e')](_0x24ec37[_0x1b12e5('0x6')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x31105f[_0x1b12e5('0x3c')],_0x31105f[_0x1b12e5('0x44')]):_0x398205['where'](_0x24ec37[_0x1b12e5('0x6')]+_0x1b12e5('0x50'),_0x31105f[_0x1b12e5('0x3c')],_0x31105f[_0x1b12e5('0x44')]);if(_0x29f005)return logger[_0x1b12e5('0x3e')]('Run\x20Query:',_0x398205[_0x1b12e5('0x5a')]()),require(_0x1b12e5('0x8'))[_0x1b12e5('0x2d')](path[_0x1b12e5('0x15')](__dirname,_0x1b12e5('0x30'),_0x29f005[_0x1b12e5('0xb')]),[_0x29f005['id'],_0x398205['toString'](),path['join'](__dirname,_0x1b12e5('0x3'),_0x29f005['savename']),_0x4fd36d]),_0x29f005;else{const _0x1a191b=squel[_0x1b12e5('0x31')]();return _0x1a191b['from']('('+_0x398205[_0x1b12e5('0x5a')]()+')',_0x1b12e5('0x73')),_0x1a191b['field'](_0x1b12e5('0x42'),'count'),_0x398205['limit'](_0x31105f[_0x1b12e5('0x4a')]||_0x427afa),_0x398205['offset'](_0x31105f[_0x1b12e5('0x25')]||0x0),dbH[_0x1b12e5('0x43')]['query'](_0x1a191b[_0x1b12e5('0x5a')](),{'type':dbH[_0x1b12e5('0x43')]['QueryTypes'][_0x1b12e5('0x37')]})[_0x1b12e5('0x51')](function(_0x1e157c){const _0x3cdd9e=_0x1b12e5;return!_0x1e157c[_0x3cdd9e('0x23')]?_0x2bc4cd=0x0:_0x2bc4cd=_0x1e157c[0x0][_0x3cdd9e('0x5e')]||0x0,dbH[_0x3cdd9e('0x43')]['query'](_0x398205[_0x3cdd9e('0x5a')](),{'type':dbH['sequelize'][_0x3cdd9e('0x19')][_0x3cdd9e('0x37')]});})[_0x1b12e5('0x51')](function(_0x1d49ab){return{'rows':_0x1d49ab||[],'count':_0x2bc4cd};});}});}exports['run']=function(_0x28f98d,_0x333b54){const _0xfacfb8=_0x5ebedc;return runReport(_0x28f98d['params'],_0x28f98d['query'],_0x28f98d[_0xfacfb8('0x64')])[_0xfacfb8('0x51')](respondWithResult(_0x333b54,null))[_0xfacfb8('0x27')](handleError(_0x333b54,null));},exports[_0x5ebedc('0x88')]=runReport,exports['query']=function(_0x39ed23,_0x230577){const _0x3aad04=_0x5ebedc,_0x594118=0xa,_0x656cc5=['join','left_join',_0x3aad04('0x54'),'cross_join'],_0x1e8151={'SUM':_0x3aad04('0xd'),'COUNT':_0x3aad04('0x56'),'COUNT\x20DISTINCT':_0x3aad04('0x65'),'MAX':'MAX(%s)','MIN':_0x3aad04('0x52'),'AVG':_0x3aad04('0x0'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0x3aad04('0x81')},_0x1c4b84={'SEC_TO_TIME':_0x3aad04('0x4f'),'DATE':_0x3aad04('0x41'),'HOUR':_0x3aad04('0x2e'),'ROUND':_0x3aad04('0x28'),'UNIX_TIMESTAMP':_0x3aad04('0x75')},_0x2aed5c=function(_0x3a269c){const _0x1786a2=_0x3aad04;return!_['includes']([_0x1786a2('0x82'),'IS\x20NOT\x20NULL',_0x1786a2('0x5f'),'IS\x20NOT\x20EMPTY'],_0x3a269c);},_0x7a3b76=function(_0xb0acb2){const _0x285dcd=_0x3aad04;if(!_0xb0acb2||!_0xb0acb2['rules'][_0x285dcd('0x23')])return'';let _0x440206='(';for(let _0x3a7e98=0x0;_0x3a7e98<_0xb0acb2[_0x285dcd('0x4')][_0x285dcd('0x23')];_0x3a7e98+=0x1){_0x3a7e98>0x0&&(_0x440206+='\x20'+_0xb0acb2[_0x285dcd('0x38')]+'\x20'),_0x440206+=_0xb0acb2[_0x285dcd('0x4')][_0x3a7e98][_0x285dcd('0x63')]?_0x7a3b76(_0xb0acb2['rules'][_0x3a7e98][_0x285dcd('0x63')]):_0xb0acb2['rules'][_0x3a7e98][_0x285dcd('0xf')]+'\x20'+_0xb0acb2[_0x285dcd('0x4')][_0x3a7e98][_0x285dcd('0x47')]+(_0x2aed5c(_0xb0acb2[_0x285dcd('0x4')][_0x3a7e98][_0x285dcd('0x47')])?'\x20'+_0xb0acb2[_0x285dcd('0x4')][_0x3a7e98][_0x285dcd('0x5')]:'');}return _0x440206+')';};let _0x5c0490={'where':{'id':_0x39ed23['params']['id']}},_0x3c3eb3,_0x3867b4,_0x298217,_0x2d4f02;return _0x5c0490=_[_0x3aad04('0x6a')]({},_0x5c0490,_0x39ed23[_0x3aad04('0x64')]),db[_0x3aad04('0x40')][_0x3aad04('0x76')](_0x5c0490)[_0x3aad04('0x51')](function(_0x476e9b){if(_0x476e9b)return _0x3c3eb3=_0x476e9b,_0x476e9b['getFields']();return null;})[_0x3aad04('0x51')](function(_0x451b13){const _0xd16f2d=_0x3aad04;if(_0x451b13){if(!_0x451b13[_0xd16f2d('0x23')])throw new ValidationErrorItem(_0xd16f2d('0x46'),0x193);return _0x3867b4=_0x451b13,db[_0xd16f2d('0x86')][_0xd16f2d('0x66')]({'raw':!![]});}return null;})[_0x3aad04('0x51')](function(_0x16a3fd){const _0x2008d9=_0x3aad04;if(_0x16a3fd){_0x298217=_[_0x2008d9('0x2b')](_0x16a3fd,'id');let _0x4ab9a2;const _0x4ef5d7=squel[_0x2008d9('0x31')]();_0x4ef5d7['from'](_0x3c3eb3[_0x2008d9('0x6')]);for(let _0x38b2b2=0x0;_0x38b2b2<_0x3867b4['length'];_0x38b2b2+=0x1){_0x4ab9a2=_0x3867b4[_0x38b2b2][_0x2008d9('0x7c')]?_0x298217[_0x3867b4[_0x38b2b2][_0x2008d9('0x7c')]][_0x2008d9('0x4d')]:_0x3867b4[_0x38b2b2][_0x2008d9('0xf')],_0x4ab9a2=_0x3867b4[_0x38b2b2][_0x2008d9('0x3f')]?_[_0x2008d9('0x34')](_0x1e8151[_0x3867b4[_0x38b2b2][_0x2008d9('0x3f')]],'%s',_0x4ab9a2):_0x4ab9a2,_0x4ab9a2=_0x3867b4[_0x38b2b2][_0x2008d9('0x61')]?_[_0x2008d9('0x34')](_0x1c4b84[_0x3867b4[_0x38b2b2][_0x2008d9('0x61')]],'%s',_0x4ab9a2):_0x4ab9a2,_0x3867b4[_0x38b2b2][_0x2008d9('0x67')]&&_0x4ef5d7[_0x2008d9('0x63')](_0x4ab9a2),_0x3867b4[_0x38b2b2][_0x2008d9('0x59')]&&_0x4ef5d7[_0x2008d9('0x85')](_0x4ab9a2,_0x3867b4[_0x38b2b2][_0x2008d9('0x59')]===_0x2008d9('0x87')?![]:!![]),_0x4ef5d7[_0x2008d9('0xf')](_0x4ab9a2,_0x3867b4[_0x38b2b2][_0x2008d9('0x6b')]||_0x4ab9a2);}if(_0x3c3eb3['joins']){_0x3c3eb3[_0x2008d9('0x26')]=JSON[_0x2008d9('0x1c')](_0x3c3eb3[_0x2008d9('0x26')]);for(let _0x44c96c=0x0;_0x44c96c<_0x3c3eb3[_0x2008d9('0x26')]['length'];_0x44c96c+=0x1){_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x8c')]&&_[_0x2008d9('0x55')](_0x656cc5,_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c]['type'])&&_0x3c3eb3['joins'][_0x44c96c][_0x2008d9('0x62')]&&_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c]['foreignTable']&&_0x3c3eb3['joins'][_0x44c96c][_0x2008d9('0x89')]&&_0x4ef5d7[_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x8c')]](_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x2a')],null,util[_0x2008d9('0x61')](_0x2008d9('0x13'),_0x3c3eb3['table'],_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x62')],_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x2a')],_0x3c3eb3[_0x2008d9('0x26')][_0x44c96c][_0x2008d9('0x89')]));}}return _0x3c3eb3[_0x2008d9('0x6f')]&&(_0x3c3eb3['conditions']=JSON[_0x2008d9('0x1c')](_0x3c3eb3[_0x2008d9('0x6f')]),_0x4ef5d7['where'](_0x7a3b76(_0x3c3eb3[_0x2008d9('0x6f')]['group']))),_0x2d4f02=_0x4ef5d7[_0x2008d9('0x71')](),_0x4ef5d7[_0x2008d9('0x4a')](_0x594118),_0x4ef5d7[_0x2008d9('0x25')](0x0),logger[_0x2008d9('0x7')]('Limited\x20Query:',_0x4ef5d7[_0x2008d9('0x5a')]()),db['sequelize']['query'](_0x4ef5d7[_0x2008d9('0x5a')](),{'type':QueryTypes[_0x2008d9('0x37')]});}})[_0x3aad04('0x51')](function(){const _0x409242=_0x3aad04;return{'sql':_0x2d4f02[_0x409242('0x5a')]()};})['then'](respondWithResult(_0x230577,null))['catch'](handleError(_0x230577,null));};
\ No newline at end of file
+const a9_0x7bd8=['preview','../../mysqldb','IS\x20NOT\x20NULL','savename','field','Limited\x20Query:','filter','fields','merge','set','right_join','MAX(%s)','select','GROUP_CONCAT(%s)','IS\x20NOT\x20EMPTY','order','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','catch','runReport','includeAll','endDate','where','error','output','cross_join','AnalyticMetric','format','COUNT(*)','csv','../../files/reports','IS\x20NULL','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','MIN(%s)','keyBy','startDate','parse','../../components/parsers/qs','destroy','replace','attributes','generate','query','from','condition','../../config/logger','groupBy','params','UserProfileResource','Run\x20Query:','getFields','orderBy','key','offset','randomstring','conditions','name','like','Content-Range','COUNT(%s)','type','send','then','rules','findOne','filters','keys','role','update','end','sort','AnalyticExtractedReport','findAll','Unable\x20to\x20retrieve\x20the\x20current\x20user','count','HOUR(%s)','get','%s.%s\x20=\x20%s.%s','sequelize','map','info','includes','fork','SEC_TO_TIME(%s)','SELECT','Please\x20insert\x20at\x20least\x20one\x20field','countTable','DESC','MetricId','web','left_join','%s-%s.%s','COUNT(DISTINCT\x20%s)','clone','value','sendStatus','group','operator','path','foreignTable','rawAttributes','DefaultReports','cdr','status','show','body','run','DATE(%s)','join','SUM(%s)','VIRTUAL','table','autoAssociation','limit','IS\x20EMPTY','metric','function','toString','user','debug','model','UNIX_TIMESTAMP(%s)','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','foreignKey','joins','length','fullPath','default','undefined','json','nolimit','ROUND(%s)','parentKey','options','intersection','create','pick','dbH','AnalyticDefaultReport'];(function(_0x58035b,_0x7bd8ac){const _0x2b590e=function(_0x3ed02a){while(--_0x3ed02a){_0x58035b['push'](_0x58035b['shift']());}};_0x2b590e(++_0x7bd8ac);}(a9_0x7bd8,0x12a));const a9_0x2b59=function(_0x58035b,_0x7bd8ac){_0x58035b=_0x58035b-0x0;let _0x2b590e=a9_0x7bd8[_0x58035b];return _0x2b590e;};const _0x42bdd2=a9_0x2b59;'use strict';const util=require('util'),path=require(_0x42bdd2('0x4b')),_=require('lodash'),squel=require('squel'),qs=require(_0x42bdd2('0xe')),logger=require(_0x42bdd2('0x16'))('api'),db=require(_0x42bdd2('0x75'))['db'],dbH=require(_0x42bdd2('0x75'))[_0x42bdd2('0x72')],{Op,ValidationErrorItem,QueryTypes}=require(_0x42bdd2('0x37'));function respondWithResult(_0x3ed02a,_0x30504f){return _0x30504f=_0x30504f||0xc8,function(_0x267eb1){const _0x9cbf32=a9_0x2b59;if(_0x267eb1)return _0x3ed02a['status'](_0x30504f)[_0x9cbf32('0x6a')](_0x267eb1);};}function respondWithFilteredResult(_0x23b9de,_0x4a941b){return function(_0x12a1ec){const _0x21d47d=a9_0x2b59;if(_0x12a1ec){const _0x47ca3b=_0x12a1ec[_0x21d47d('0x33')],_0x267e60=_0x4a941b[_0x21d47d('0x1e')];let _0x36cabc=_0x4a941b['offset']+_0x4a941b[_0x21d47d('0x5a')],_0x93e25a;return _0x36cabc>=_0x47ca3b?(_0x36cabc=_0x47ca3b,_0x93e25a=0xc8):_0x93e25a=0xce,_0x23b9de[_0x21d47d('0x50')](_0x93e25a),_0x23b9de[_0x21d47d('0x7d')](_0x21d47d('0x23'),_0x267e60+'-'+_0x36cabc+'/'+_0x47ca3b)['json'](_0x12a1ec);}return null;};}function saveUpdates(_0xa43d9e){return function(_0x3169d7){const _0x378f07=a9_0x2b59;if(_0x3169d7)return _0x3169d7[_0x378f07('0x2d')](_0xa43d9e)[_0x378f07('0x27')](function(_0x196e2d){return _0x196e2d;});return null;};}function removeEntity(_0x33177e){return function(_0x16703){const _0x11f789=a9_0x2b59;if(_0x16703)return _0x16703[_0x11f789('0xf')]()[_0x11f789('0x27')](function(){const _0x288057=_0x11f789,_0x1749b0=_0x16703[_0x288057('0x35')]({'plain':!![]}),_0x16615c=_0x288057('0x4e');return db[_0x288057('0x19')][_0x288057('0xf')]({'where':{'type':_0x16615c,'resourceId':_0x1749b0['id']}})[_0x288057('0x27')](function(){return _0x16703;});})[_0x11f789('0x27')](function(){const _0x104e94=_0x11f789;_0x33177e[_0x104e94('0x50')](0xcc)[_0x104e94('0x2e')]();});};}function handleEntityNotFound(_0x3702f4){return function(_0x583242){const _0x1fe314=a9_0x2b59;return!_0x583242&&_0x3702f4[_0x1fe314('0x48')](0x194),_0x583242;};}function handleError(_0x57e7d6,_0x46df00){return _0x46df00=_0x46df00||0x1f4,function(_0x45f588){const _0x1a2e12=a9_0x2b59;logger[_0x1a2e12('0x0')](_0x45f588['stack']),_0x45f588['name']&&delete _0x45f588['name'],_0x57e7d6[_0x1a2e12('0x50')](_0x46df00)[_0x1a2e12('0x26')](_0x45f588);};}exports['index']=function(_0x290829,_0x14cabd){const _0x8fbee=_0x42bdd2;let _0x48c71e={};const _0x5cab37={},_0x331977={'count':0x0,'rows':[]},_0x600fbf=_[_0x8fbee('0x38')](db[_0x8fbee('0x73')]['rawAttributes'],function(_0xb5c266){const _0x2466ab=_0x8fbee;return{'name':_0xb5c266['fieldName'],'type':_0xb5c266[_0x2466ab('0x25')][_0x2466ab('0x1d')]};});_0x5cab37[_0x8fbee('0x61')]=_[_0x8fbee('0x38')](_0x600fbf,_0x8fbee('0x21')),_0x5cab37[_0x8fbee('0x13')]=_[_0x8fbee('0x2b')](_0x290829['query']),_0x5cab37[_0x8fbee('0x2a')]=_[_0x8fbee('0x6f')](_0x5cab37[_0x8fbee('0x61')],_0x5cab37[_0x8fbee('0x13')]),_0x48c71e[_0x8fbee('0x11')]=_[_0x8fbee('0x6f')](_0x5cab37['model'],qs['fields'](_0x290829[_0x8fbee('0x13')][_0x8fbee('0x7b')])),_0x48c71e[_0x8fbee('0x11')]=_0x48c71e[_0x8fbee('0x11')][_0x8fbee('0x66')]?_0x48c71e[_0x8fbee('0x11')]:_0x5cab37[_0x8fbee('0x61')];typeof _0x290829[_0x8fbee('0x13')][_0x8fbee('0x6b')]===_0x8fbee('0x69')&&(_0x48c71e[_0x8fbee('0x5a')]=qs[_0x8fbee('0x5a')](_0x290829[_0x8fbee('0x13')][_0x8fbee('0x5a')]),_0x48c71e[_0x8fbee('0x1e')]=qs[_0x8fbee('0x1e')](_0x290829['query'][_0x8fbee('0x1e')]));_0x48c71e[_0x8fbee('0x83')]=qs[_0x8fbee('0x2f')](_0x290829[_0x8fbee('0x13')][_0x8fbee('0x2f')]),_0x48c71e[_0x8fbee('0x89')]=qs[_0x8fbee('0x2a')](_[_0x8fbee('0x71')](_0x290829['query'],_0x5cab37[_0x8fbee('0x2a')]),_0x600fbf);_0x290829[_0x8fbee('0x13')][_0x8fbee('0x7a')]&&(_0x48c71e[_0x8fbee('0x89')]=_[_0x8fbee('0x7c')](_0x48c71e[_0x8fbee('0x89')],{[Op['or']]:_[_0x8fbee('0x38')](_0x600fbf,function(_0x5c8978){const _0x19e7ed=_0x8fbee;if(_0x5c8978[_0x19e7ed('0x25')]!==_0x19e7ed('0x57')){const _0x2fd143={};return _0x2fd143[_0x5c8978[_0x19e7ed('0x21')]]={[Op[_0x19e7ed('0x22')]]:'%'+_0x290829[_0x19e7ed('0x13')][_0x19e7ed('0x7a')]+'%'},_0x2fd143;}})}));_0x48c71e=_[_0x8fbee('0x7c')]({},_0x48c71e,_0x290829[_0x8fbee('0x6e')]);const _0x2ed7e0={'where':_0x48c71e[_0x8fbee('0x89')]};return db[_0x8fbee('0x73')][_0x8fbee('0x33')](_0x2ed7e0)[_0x8fbee('0x27')](function(_0xd56be4){const _0x5d404c=_0x8fbee;return _0x331977[_0x5d404c('0x33')]=_0xd56be4,_0x290829[_0x5d404c('0x13')][_0x5d404c('0x87')]&&(_0x48c71e['include']=[{'all':!![]}]),db['AnalyticDefaultReport']['findAll'](_0x48c71e);})[_0x8fbee('0x27')](function(_0x1a1f36){return _0x331977['rows']=_0x1a1f36,_0x331977;})['then'](respondWithFilteredResult(_0x14cabd,_0x48c71e))['catch'](handleError(_0x14cabd,null));},exports[_0x42bdd2('0x51')]=function(_0x5901ae,_0x486226){const _0x4b6d6c=_0x42bdd2;let _0x2f5393={'raw':!![],'where':{'id':_0x5901ae[_0x4b6d6c('0x18')]['id']}};const _0x24c183={};return _0x24c183[_0x4b6d6c('0x61')]=_[_0x4b6d6c('0x2b')](db[_0x4b6d6c('0x73')][_0x4b6d6c('0x4d')]),_0x24c183[_0x4b6d6c('0x13')]=_['keys'](_0x5901ae[_0x4b6d6c('0x13')]),_0x24c183[_0x4b6d6c('0x2a')]=_[_0x4b6d6c('0x6f')](_0x24c183[_0x4b6d6c('0x61')],_0x24c183['query']),_0x2f5393[_0x4b6d6c('0x11')]=_[_0x4b6d6c('0x6f')](_0x24c183[_0x4b6d6c('0x61')],qs[_0x4b6d6c('0x7b')](_0x5901ae['query'][_0x4b6d6c('0x7b')])),_0x2f5393[_0x4b6d6c('0x11')]=_0x2f5393['attributes'][_0x4b6d6c('0x66')]?_0x2f5393[_0x4b6d6c('0x11')]:_0x24c183[_0x4b6d6c('0x61')],_0x5901ae[_0x4b6d6c('0x13')][_0x4b6d6c('0x87')]&&(_0x2f5393['include']=[{'all':!![]}]),_0x2f5393=_[_0x4b6d6c('0x7c')]({},_0x2f5393,_0x5901ae[_0x4b6d6c('0x6e')]),db['AnalyticDefaultReport'][_0x4b6d6c('0x29')](_0x2f5393)[_0x4b6d6c('0x27')](handleEntityNotFound(_0x486226,null))[_0x4b6d6c('0x27')](respondWithResult(_0x486226,null))[_0x4b6d6c('0x85')](handleError(_0x486226,null));},exports[_0x42bdd2('0x70')]=function(_0x2a6d29,_0x450353){const _0x5f19ab=_0x42bdd2;return db[_0x5f19ab('0x73')][_0x5f19ab('0x70')](_0x2a6d29['body'],{})[_0x5f19ab('0x27')](function(_0x2df325){const _0x34dac2=_0x5f19ab,_0x4ba17c=_0x2a6d29['user'][_0x34dac2('0x35')]({'plain':!![]});if(!_0x4ba17c)throw new Error(_0x34dac2('0x32'));if(_0x4ba17c[_0x34dac2('0x2c')]===_0x34dac2('0x5f')){const _0x45c09a=_0x2df325[_0x34dac2('0x35')]({'plain':!![]}),_0x565ba5='Reports';return db['UserProfileSection'][_0x34dac2('0x29')]({'where':{'name':_0x565ba5,'userProfileId':_0x4ba17c['userProfileId']},'raw':!![]})['then'](function(_0x165f9d){const _0x27ee6f=_0x34dac2;return _0x165f9d&&_0x165f9d[_0x27ee6f('0x59')]===0x0?db[_0x27ee6f('0x19')][_0x27ee6f('0x70')]({'name':_0x45c09a[_0x27ee6f('0x21')],'resourceId':_0x45c09a['id'],'type':_0x27ee6f('0x4e'),'sectionId':_0x165f9d['id']},{})[_0x27ee6f('0x27')](function(){return _0x2df325;}):_0x2df325;})[_0x34dac2('0x85')](function(_0x3ba056){const _0x170190=_0x34dac2;logger['error'](_0x170190('0x63'),_0x3ba056);throw _0x3ba056;});}return _0x2df325;})[_0x5f19ab('0x27')](respondWithResult(_0x450353,0xc9))[_0x5f19ab('0x85')](handleError(_0x450353,null));},exports[_0x42bdd2('0x2d')]=function(_0x28ad87,_0x1ae47b){const _0x488486=_0x42bdd2;return _0x28ad87[_0x488486('0x52')]['id']&&delete _0x28ad87[_0x488486('0x52')]['id'],db['AnalyticDefaultReport']['findOne']({'where':{'id':_0x28ad87[_0x488486('0x18')]['id']}})[_0x488486('0x27')](handleEntityNotFound(_0x1ae47b,null))['then'](saveUpdates(_0x28ad87[_0x488486('0x52')],null))['then'](respondWithResult(_0x1ae47b,null))[_0x488486('0x85')](handleError(_0x1ae47b,null));},exports[_0x42bdd2('0xf')]=function(_0x2aa5a0,_0x2db617){const _0x5c9694=_0x42bdd2;return db[_0x5c9694('0x73')][_0x5c9694('0x29')]({'where':{'id':_0x2aa5a0[_0x5c9694('0x18')]['id']}})[_0x5c9694('0x27')](handleEntityNotFound(_0x2db617,null))[_0x5c9694('0x27')](removeEntity(_0x2db617,null))[_0x5c9694('0x85')](handleError(_0x2db617,null));},exports[_0x42bdd2('0x74')]=function(_0x4b62db,_0x2c2d3f){const _0x237021=_0x42bdd2,_0x5f47e3=0xa,_0x45e98c=[_0x237021('0x55'),'left_join','right_join',_0x237021('0x2')],_0x1c5102={'SUM':_0x237021('0x56'),'COUNT':_0x237021('0x24'),'COUNT\x20DISTINCT':_0x237021('0x45'),'MAX':'MAX(%s)','MIN':_0x237021('0xa'),'AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':_0x237021('0x9'),'GROUP_CONCAT\x20DESC':_0x237021('0x84')},_0x5c8fe9={'SEC_TO_TIME':_0x237021('0x3c'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x237021('0x6c'),'UNIX_TIMESTAMP':_0x237021('0x62')},_0x47918d=function(_0x3cac03){const _0x374693=_0x237021;return!_[_0x374693('0x3a')]([_0x374693('0x8'),_0x374693('0x76'),'IS\x20EMPTY',_0x374693('0x82')],_0x3cac03);},_0x58ba64=function(_0x2ab6d8){const _0x393862=_0x237021;if(!_0x2ab6d8||!_0x2ab6d8[_0x393862('0x28')][_0x393862('0x66')])return'';let _0x4fce52='(';for(let _0x231ce1=0x0;_0x231ce1<_0x2ab6d8[_0x393862('0x28')][_0x393862('0x66')];_0x231ce1+=0x1){_0x231ce1>0x0&&(_0x4fce52+='\x20'+_0x2ab6d8['operator']+'\x20'),_0x4fce52+=_0x2ab6d8[_0x393862('0x28')][_0x231ce1]['group']?_0x58ba64(_0x2ab6d8[_0x393862('0x28')][_0x231ce1][_0x393862('0x49')]):_0x2ab6d8[_0x393862('0x28')][_0x231ce1][_0x393862('0x78')]+'\x20'+_0x2ab6d8[_0x393862('0x28')][_0x231ce1][_0x393862('0x15')]+(_0x47918d(_0x2ab6d8[_0x393862('0x28')][_0x231ce1]['condition'])?'\x20'+_0x2ab6d8[_0x393862('0x28')][_0x231ce1][_0x393862('0x47')]:'');}return _0x4fce52+')';};let _0x556aaf={'where':{'id':_0x4b62db[_0x237021('0x18')]['id']}},_0xc5f306,_0x56121a,_0x3119ec;return _0x556aaf=_[_0x237021('0x7c')]({},_0x556aaf,_0x4b62db[_0x237021('0x6e')]),db[_0x237021('0x73')][_0x237021('0x29')](_0x556aaf)[_0x237021('0x27')](function(_0x43b9cc){if(_0x43b9cc)return _0xc5f306=_0x43b9cc,_0x43b9cc['getFields']();return null;})[_0x237021('0x27')](function(_0x50458c){const _0x428c27=_0x237021;if(_0x50458c){if(!_0x50458c[_0x428c27('0x66')])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x56121a=_0x50458c,db[_0x428c27('0x3')][_0x428c27('0x31')]({'raw':!![]});}return null;})[_0x237021('0x27')](function(_0x15aa5a){const _0x4f867a=_0x237021;if(_0x15aa5a){_0x3119ec=_['keyBy'](_0x15aa5a,'id');let _0x29ebcd;const _0x313f4a=squel['select']();_0x313f4a[_0x4f867a('0x14')](_0xc5f306['table']);for(let _0x47a9fa=0x0;_0x47a9fa<_0x56121a[_0x4f867a('0x66')];_0x47a9fa+=0x1){_0x29ebcd=_0x56121a[_0x47a9fa][_0x4f867a('0x41')]?_0x3119ec[_0x56121a[_0x47a9fa][_0x4f867a('0x41')]]['metric']:_0x56121a[_0x47a9fa][_0x4f867a('0x78')],_0x29ebcd=_0x56121a[_0x47a9fa][_0x4f867a('0x5d')]?_[_0x4f867a('0x10')](_0x1c5102[_0x56121a[_0x47a9fa][_0x4f867a('0x5d')]],'%s',_0x29ebcd):_0x29ebcd,_0x29ebcd=_0x56121a[_0x47a9fa][_0x4f867a('0x4')]?_[_0x4f867a('0x10')](_0x5c8fe9[_0x56121a[_0x47a9fa][_0x4f867a('0x4')]],'%s',_0x29ebcd):_0x29ebcd,_0x56121a[_0x47a9fa][_0x4f867a('0x17')]&&_0x313f4a[_0x4f867a('0x49')](_0x29ebcd),_0x56121a[_0x47a9fa][_0x4f867a('0x1c')]&&_0x313f4a[_0x4f867a('0x83')](_0x29ebcd,_0x56121a[_0x47a9fa][_0x4f867a('0x1c')]===_0x4f867a('0x40')?![]:!![]),_0x313f4a[_0x4f867a('0x78')](_0x29ebcd,_0x56121a[_0x47a9fa]['alias']||_0x29ebcd);}if(_0xc5f306[_0x4f867a('0x65')]){_0xc5f306[_0x4f867a('0x65')]=JSON[_0x4f867a('0xd')](_0xc5f306[_0x4f867a('0x65')]);for(let _0x4ffe04=0x0;_0x4ffe04<_0xc5f306[_0x4f867a('0x65')][_0x4f867a('0x66')];_0x4ffe04+=0x1){_0xc5f306['joins'][_0x4ffe04][_0x4f867a('0x25')]&&_['includes'](_0x45e98c,_0xc5f306['joins'][_0x4ffe04][_0x4f867a('0x25')])&&_0xc5f306['joins'][_0x4ffe04][_0x4f867a('0x6d')]&&_0xc5f306['joins'][_0x4ffe04][_0x4f867a('0x4c')]&&_0xc5f306['joins'][_0x4ffe04]['foreignKey']&&_0x313f4a[_0xc5f306[_0x4f867a('0x65')][_0x4ffe04][_0x4f867a('0x25')]](_0xc5f306[_0x4f867a('0x65')][_0x4ffe04]['foreignTable'],null,util['format'](_0x4f867a('0x36'),_0xc5f306[_0x4f867a('0x58')],_0xc5f306[_0x4f867a('0x65')][_0x4ffe04][_0x4f867a('0x6d')],_0xc5f306[_0x4f867a('0x65')][_0x4ffe04][_0x4f867a('0x4c')],_0xc5f306[_0x4f867a('0x65')][_0x4ffe04][_0x4f867a('0x64')]));}}return _0xc5f306[_0x4f867a('0x20')]&&(_0xc5f306[_0x4f867a('0x20')]=JSON[_0x4f867a('0xd')](_0xc5f306[_0x4f867a('0x20')]),_0x313f4a[_0x4f867a('0x89')](_0x58ba64(_0xc5f306[_0x4f867a('0x20')][_0x4f867a('0x49')]))),_0x313f4a[_0x4f867a('0x5a')](_0x5f47e3),_0x313f4a['offset'](0x0),logger['debug']('Limited\x20Query:',_0x313f4a[_0x4f867a('0x5e')]()),db[_0x4f867a('0x37')][_0x4f867a('0x13')](_0x313f4a[_0x4f867a('0x5e')](),{'type':QueryTypes['SELECT']});}})[_0x237021('0x27')](respondWithResult(_0x2c2d3f,null))[_0x237021('0x85')](handleError(_0x2c2d3f,null));};function runReport(_0xc72aa6,_0x47cb21,_0x57e71a){const _0x24d593=_0x42bdd2,_0x58ccf8=_0x47cb21[_0x24d593('0x21')],_0x1f4f68=0xa,_0x3f1af4=[_0x24d593('0x55'),_0x24d593('0x43'),_0x24d593('0x7e'),'cross_join'],_0x3d87cf={'SUM':_0x24d593('0x56'),'COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0x24d593('0x45'),'MAX':_0x24d593('0x7f'),'MIN':_0x24d593('0xa'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x24d593('0x81'),'GROUP_CONCAT\x20ASC':_0x24d593('0x9'),'GROUP_CONCAT\x20DESC':_0x24d593('0x84')},_0x1b88b8={'SEC_TO_TIME':_0x24d593('0x3c'),'DATE':_0x24d593('0x54'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x24d593('0x62')},_0xde34cd=function(_0x1fb6de){const _0x3ac0ba=_0x24d593;return!_[_0x3ac0ba('0x3a')](['IS\x20NULL',_0x3ac0ba('0x76'),_0x3ac0ba('0x5b'),_0x3ac0ba('0x82')],_0x1fb6de);},_0x184a80=function(_0x3a137c){const _0x6cff66=_0x24d593;if(!_0x3a137c||!_0x3a137c[_0x6cff66('0x28')][_0x6cff66('0x66')])return'';let _0x7c4231='(';for(let _0x3d130c=0x0;_0x3d130c<_0x3a137c['rules'][_0x6cff66('0x66')];_0x3d130c+=0x1){_0x3d130c>0x0&&(_0x7c4231+='\x20'+_0x3a137c[_0x6cff66('0x4a')]+'\x20'),_0x7c4231+=_0x3a137c[_0x6cff66('0x28')][_0x3d130c][_0x6cff66('0x49')]?_0x184a80(_0x3a137c[_0x6cff66('0x28')][_0x3d130c]['group']):_0x3a137c['rules'][_0x3d130c][_0x6cff66('0x78')]+'\x20'+_0x3a137c[_0x6cff66('0x28')][_0x3d130c][_0x6cff66('0x15')]+(_0xde34cd(_0x3a137c['rules'][_0x3d130c][_0x6cff66('0x15')])?'\x20'+_0x3a137c[_0x6cff66('0x28')][_0x3d130c]['value']:'');}return _0x7c4231+')';};let _0x3ba488={'where':{'id':_0xc72aa6['id']}},_0x31d8a6,_0x1eb114,_0x10b3a8,_0x3d23e1,_0x30a36a;return _0x3ba488=_[_0x24d593('0x7c')]({},_0x3ba488,_0x57e71a),db['AnalyticDefaultReport'][_0x24d593('0x29')](_0x3ba488)[_0x24d593('0x27')](function(_0x4f36ed){const _0x21e7d1=_0x24d593;if(_0x4f36ed)return _0x31d8a6=_0x4f36ed,_0x4f36ed[_0x21e7d1('0x1b')]();return null;})['then'](function(_0x2e9355){if(_0x2e9355){if(!_0x2e9355['length'])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x1eb114=_0x2e9355,db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})['then'](function(_0x836ed5){const _0x5e6afc=_0x24d593;if(_0x836ed5){_0x10b3a8=_[_0x5e6afc('0xb')](_0x836ed5,'id');let _0x1c250b;const _0x575fa2=squel[_0x5e6afc('0x80')]();_0x575fa2['from'](_0x31d8a6[_0x5e6afc('0x58')]);for(let _0x28fe9e=0x0;_0x28fe9e<_0x1eb114[_0x5e6afc('0x66')];_0x28fe9e+=0x1){_0x1c250b=_0x1eb114[_0x28fe9e][_0x5e6afc('0x41')]?_0x10b3a8[_0x1eb114[_0x28fe9e][_0x5e6afc('0x41')]]['metric']:_0x1eb114[_0x28fe9e]['field'],_0x1c250b=_0x1eb114[_0x28fe9e][_0x5e6afc('0x5d')]?_[_0x5e6afc('0x10')](_0x3d87cf[_0x1eb114[_0x28fe9e][_0x5e6afc('0x5d')]],'%s',_0x1c250b):_0x1c250b,_0x1c250b=_0x1eb114[_0x28fe9e][_0x5e6afc('0x4')]?_[_0x5e6afc('0x10')](_0x1b88b8[_0x1eb114[_0x28fe9e][_0x5e6afc('0x4')]],'%s',_0x1c250b):_0x1c250b,_0x1eb114[_0x28fe9e][_0x5e6afc('0x17')]&&_0x575fa2[_0x5e6afc('0x49')](_0x1c250b),_0x1eb114[_0x28fe9e][_0x5e6afc('0x1c')]&&_0x575fa2['order'](_0x1c250b,_0x1eb114[_0x28fe9e][_0x5e6afc('0x1c')]===_0x5e6afc('0x40')?![]:!![]),_0x575fa2[_0x5e6afc('0x78')](_0x1c250b,_0x1eb114[_0x28fe9e]['alias']||_0x1c250b);}if(_0x31d8a6[_0x5e6afc('0x65')]){_0x31d8a6['joins']=JSON['parse'](_0x31d8a6[_0x5e6afc('0x65')]);for(let _0xf87efa=0x0;_0xf87efa<_0x31d8a6[_0x5e6afc('0x65')]['length'];_0xf87efa+=0x1){_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x25')]&&_[_0x5e6afc('0x3a')](_0x3f1af4,_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x25')])&&_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa]['parentKey']&&_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x4c')]&&_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x64')]&&_0x575fa2[_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x25')]](_0x31d8a6['joins'][_0xf87efa][_0x5e6afc('0x4c')],null,util[_0x5e6afc('0x4')](_0x5e6afc('0x36'),_0x31d8a6[_0x5e6afc('0x58')],_0x31d8a6['joins'][_0xf87efa][_0x5e6afc('0x6d')],_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x4c')],_0x31d8a6[_0x5e6afc('0x65')][_0xf87efa][_0x5e6afc('0x64')]));}}return _0x31d8a6[_0x5e6afc('0x20')]&&(_0x31d8a6['conditions']=JSON['parse'](_0x31d8a6[_0x5e6afc('0x20')]),_0x575fa2[_0x5e6afc('0x89')](_0x184a80(_0x31d8a6['conditions']['group']))),_0x30a36a=_0x575fa2[_0x5e6afc('0x46')](),_0x575fa2['limit'](_0x1f4f68),_0x575fa2[_0x5e6afc('0x1e')](0x0),logger['debug'](_0x5e6afc('0x79'),_0x575fa2[_0x5e6afc('0x5e')]()),db[_0x5e6afc('0x37')][_0x5e6afc('0x13')](_0x575fa2[_0x5e6afc('0x5e')](),{'type':QueryTypes[_0x5e6afc('0x3d')]});}})[_0x24d593('0x27')](function(_0x284572){const _0x3e49f9=_0x24d593;if(!_0x284572[_0x3e49f9('0x66')])throw new ValidationErrorItem('No\x20available\x20data',0xcc);if(_0x47cb21[_0x3e49f9('0x1')]===_0x3e49f9('0x42'))return null;const _0x23c129=_[_0x3e49f9('0x7c')](_0x47cb21,{'name':_0x47cb21[_0x3e49f9('0x67')]||_0x47cb21[_0x3e49f9('0x21')]||_0x31d8a6['name'],'basename':_0x58ccf8,'savename':util['format'](_0x3e49f9('0x44'),_0x47cb21[_0x3e49f9('0x21')]||_0x31d8a6[_0x3e49f9('0x21')],require(_0x3e49f9('0x1f'))[_0x3e49f9('0x12')](0x4),_0x47cb21[_0x3e49f9('0x1')]||_0x3e49f9('0x6')),'reportId':_0x31d8a6['id'],'reportType':_0x3e49f9('0x68')});return db[_0x3e49f9('0x30')][_0x3e49f9('0x70')](_0x23c129,{'raw':!![]});})[_0x24d593('0x27')](function(_0xf817f9){const _0x15271a=_0x24d593;_0x31d8a6[_0x15271a('0x58')]===_0x15271a('0x4f')?_0x30a36a[_0x15271a('0x89')](_0x31d8a6[_0x15271a('0x58')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x47cb21[_0x15271a('0xc')],_0x47cb21[_0x15271a('0x88')]):_0x30a36a['where'](_0x31d8a6[_0x15271a('0x58')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x47cb21[_0x15271a('0xc')],_0x47cb21['endDate']);if(_0xf817f9)return logger[_0x15271a('0x39')](_0x15271a('0x1a'),_0x30a36a[_0x15271a('0x5e')]()),require('child_process')[_0x15271a('0x3b')](path[_0x15271a('0x55')](__dirname,'../../components/export/',_0xf817f9['output']),[_0xf817f9['id'],_0x30a36a[_0x15271a('0x5e')](),path['join'](__dirname,_0x15271a('0x7'),_0xf817f9[_0x15271a('0x77')]),_0x58ccf8]),_0xf817f9;else{const _0x413d2a=squel['select']();return _0x413d2a['from']('('+_0x30a36a[_0x15271a('0x5e')]()+')',_0x15271a('0x3f')),_0x413d2a[_0x15271a('0x78')](_0x15271a('0x5'),_0x15271a('0x33')),_0x30a36a[_0x15271a('0x5a')](_0x47cb21[_0x15271a('0x5a')]||_0x1f4f68),_0x30a36a[_0x15271a('0x1e')](_0x47cb21['offset']||0x0),dbH[_0x15271a('0x37')][_0x15271a('0x13')](_0x413d2a[_0x15271a('0x5e')](),{'type':dbH[_0x15271a('0x37')]['QueryTypes'][_0x15271a('0x3d')]})[_0x15271a('0x27')](function(_0x2bd2de){const _0x393547=_0x15271a;return!_0x2bd2de['length']?_0x3d23e1=0x0:_0x3d23e1=_0x2bd2de[0x0][_0x393547('0x33')]||0x0,dbH[_0x393547('0x37')][_0x393547('0x13')](_0x30a36a[_0x393547('0x5e')](),{'type':dbH[_0x393547('0x37')]['QueryTypes']['SELECT']});})[_0x15271a('0x27')](function(_0x4faf02){return{'rows':_0x4faf02||[],'count':_0x3d23e1};});}});}exports[_0x42bdd2('0x53')]=function(_0x1fc75e,_0xe378ca){const _0x47da8a=_0x42bdd2;return runReport(_0x1fc75e['params'],_0x1fc75e[_0x47da8a('0x13')],_0x1fc75e[_0x47da8a('0x6e')])[_0x47da8a('0x27')](respondWithResult(_0xe378ca,null))[_0x47da8a('0x85')](handleError(_0xe378ca,null));},exports[_0x42bdd2('0x86')]=runReport,exports[_0x42bdd2('0x13')]=function(_0x28bf91,_0x5e72b8){const _0x130631=_0x42bdd2,_0x1f6020=0xa,_0x37b450=[_0x130631('0x55'),'left_join',_0x130631('0x7e'),_0x130631('0x2')],_0x16e12c={'SUM':_0x130631('0x56'),'COUNT':_0x130631('0x24'),'COUNT\x20DISTINCT':_0x130631('0x45'),'MAX':_0x130631('0x7f'),'MIN':_0x130631('0xa'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x130631('0x81'),'GROUP_CONCAT\x20ASC':_0x130631('0x9'),'GROUP_CONCAT\x20DESC':_0x130631('0x84')},_0x3827cf={'SEC_TO_TIME':_0x130631('0x3c'),'DATE':_0x130631('0x54'),'HOUR':_0x130631('0x34'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x130631('0x62')},_0x500065=function(_0x2ad5e9){const _0x2558db=_0x130631;return!_[_0x2558db('0x3a')](['IS\x20NULL','IS\x20NOT\x20NULL',_0x2558db('0x5b'),_0x2558db('0x82')],_0x2ad5e9);},_0x1ed1f1=function(_0x1fc083){const _0x1069c7=_0x130631;if(!_0x1fc083||!_0x1fc083[_0x1069c7('0x28')][_0x1069c7('0x66')])return'';let _0x4ddf07='(';for(let _0x3f0a26=0x0;_0x3f0a26<_0x1fc083['rules'][_0x1069c7('0x66')];_0x3f0a26+=0x1){_0x3f0a26>0x0&&(_0x4ddf07+='\x20'+_0x1fc083[_0x1069c7('0x4a')]+'\x20'),_0x4ddf07+=_0x1fc083['rules'][_0x3f0a26]['group']?_0x1ed1f1(_0x1fc083['rules'][_0x3f0a26][_0x1069c7('0x49')]):_0x1fc083['rules'][_0x3f0a26][_0x1069c7('0x78')]+'\x20'+_0x1fc083[_0x1069c7('0x28')][_0x3f0a26][_0x1069c7('0x15')]+(_0x500065(_0x1fc083[_0x1069c7('0x28')][_0x3f0a26]['condition'])?'\x20'+_0x1fc083[_0x1069c7('0x28')][_0x3f0a26][_0x1069c7('0x47')]:'');}return _0x4ddf07+')';};let _0x3eb1ea={'where':{'id':_0x28bf91['params']['id']}},_0x2c5df0,_0x262b1b,_0x3812fa,_0x29ca34;return _0x3eb1ea=_[_0x130631('0x7c')]({},_0x3eb1ea,_0x28bf91['options']),db[_0x130631('0x73')][_0x130631('0x29')](_0x3eb1ea)[_0x130631('0x27')](function(_0x2777f9){const _0x23a902=_0x130631;if(_0x2777f9)return _0x2c5df0=_0x2777f9,_0x2777f9[_0x23a902('0x1b')]();return null;})[_0x130631('0x27')](function(_0x3072ec){const _0x11b011=_0x130631;if(_0x3072ec){if(!_0x3072ec['length'])throw new ValidationErrorItem(_0x11b011('0x3e'),0x193);return _0x262b1b=_0x3072ec,db[_0x11b011('0x3')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x222446){const _0xca3ef2=_0x130631;if(_0x222446){_0x3812fa=_['keyBy'](_0x222446,'id');let _0x74ee70;const _0x296f3a=squel[_0xca3ef2('0x80')]();_0x296f3a[_0xca3ef2('0x14')](_0x2c5df0['table']);for(let _0x17e650=0x0;_0x17e650<_0x262b1b['length'];_0x17e650+=0x1){_0x74ee70=_0x262b1b[_0x17e650][_0xca3ef2('0x41')]?_0x3812fa[_0x262b1b[_0x17e650]['MetricId']][_0xca3ef2('0x5c')]:_0x262b1b[_0x17e650][_0xca3ef2('0x78')],_0x74ee70=_0x262b1b[_0x17e650][_0xca3ef2('0x5d')]?_[_0xca3ef2('0x10')](_0x16e12c[_0x262b1b[_0x17e650][_0xca3ef2('0x5d')]],'%s',_0x74ee70):_0x74ee70,_0x74ee70=_0x262b1b[_0x17e650]['format']?_[_0xca3ef2('0x10')](_0x3827cf[_0x262b1b[_0x17e650][_0xca3ef2('0x4')]],'%s',_0x74ee70):_0x74ee70,_0x262b1b[_0x17e650][_0xca3ef2('0x17')]&&_0x296f3a['group'](_0x74ee70),_0x262b1b[_0x17e650][_0xca3ef2('0x1c')]&&_0x296f3a[_0xca3ef2('0x83')](_0x74ee70,_0x262b1b[_0x17e650][_0xca3ef2('0x1c')]===_0xca3ef2('0x40')?![]:!![]),_0x296f3a['field'](_0x74ee70,_0x262b1b[_0x17e650]['alias']||_0x74ee70);}if(_0x2c5df0['joins']){_0x2c5df0['joins']=JSON[_0xca3ef2('0xd')](_0x2c5df0[_0xca3ef2('0x65')]);for(let _0xd83110=0x0;_0xd83110<_0x2c5df0[_0xca3ef2('0x65')][_0xca3ef2('0x66')];_0xd83110+=0x1){_0x2c5df0[_0xca3ef2('0x65')][_0xd83110][_0xca3ef2('0x25')]&&_[_0xca3ef2('0x3a')](_0x37b450,_0x2c5df0[_0xca3ef2('0x65')][_0xd83110][_0xca3ef2('0x25')])&&_0x2c5df0['joins'][_0xd83110][_0xca3ef2('0x6d')]&&_0x2c5df0[_0xca3ef2('0x65')][_0xd83110][_0xca3ef2('0x4c')]&&_0x2c5df0[_0xca3ef2('0x65')][_0xd83110][_0xca3ef2('0x64')]&&_0x296f3a[_0x2c5df0[_0xca3ef2('0x65')][_0xd83110]['type']](_0x2c5df0['joins'][_0xd83110][_0xca3ef2('0x4c')],null,util['format'](_0xca3ef2('0x36'),_0x2c5df0['table'],_0x2c5df0['joins'][_0xd83110][_0xca3ef2('0x6d')],_0x2c5df0['joins'][_0xd83110][_0xca3ef2('0x4c')],_0x2c5df0[_0xca3ef2('0x65')][_0xd83110][_0xca3ef2('0x64')]));}}return _0x2c5df0[_0xca3ef2('0x20')]&&(_0x2c5df0[_0xca3ef2('0x20')]=JSON[_0xca3ef2('0xd')](_0x2c5df0[_0xca3ef2('0x20')]),_0x296f3a[_0xca3ef2('0x89')](_0x1ed1f1(_0x2c5df0['conditions']['group']))),_0x29ca34=_0x296f3a[_0xca3ef2('0x46')](),_0x296f3a[_0xca3ef2('0x5a')](_0x1f6020),_0x296f3a['offset'](0x0),logger[_0xca3ef2('0x60')](_0xca3ef2('0x79'),_0x296f3a[_0xca3ef2('0x5e')]()),db[_0xca3ef2('0x37')]['query'](_0x296f3a['toString'](),{'type':QueryTypes[_0xca3ef2('0x3d')]});}})['then'](function(){return{'sql':_0x29ca34['toString']()};})[_0x130631('0x27')](respondWithResult(_0x5e72b8,null))[_0x130631('0x85')](handleError(_0x5e72b8,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff