-const a9_0x5ecf=['dbH','output','default','foreignKey','fieldName','csv','clone','findOne','set','intersection','group','COUNT(DISTINCT\x20%s)','show','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','include','filters','squel','cdr','child_process','length','rawAttributes','create','Reports','../../mysqldb','catch','join','countTable','rules','IS\x20NULL','IS\x20NOT\x20NULL','AnalyticMetric','debug','../../components/parsers/qs','count','DATE(%s)','endDate','ROUND(%s)','api','table','condition','limit','params','options','%s-%s.%s','GROUP_CONCAT(%s)','Limited\x20Query:','UNIX_TIMESTAMP(%s)','savename','getFields','joins','randomstring','sequelize','keyBy','MIN(%s)','right_join','query','UserProfileResource','findAll','get','conditions','pick','SEC_TO_TIME(%s)','parentKey','replace','MetricId','foreignTable','destroy','offset','includeAll','keys','undefined','field','where','QueryTypes','key','order','MAX(%s)','update','value','filter','DefaultReports','sendStatus','map','autoAssociation','index','end','model','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','groupBy','../../files/reports','type','cross_join','%s.%s\x20=\x20%s.%s','AnalyticExtractedReport','AnalyticDefaultReport','status','parse','lodash','operator','function','SELECT','Unable\x20to\x20retrieve\x20the\x20current\x20user','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','user','Please\x20insert\x20at\x20least\x20one\x20field','COUNT(%s)','startDate','path','IS\x20NOT\x20EMPTY','fields','format','SUM(%s)','stack','name','orderBy','fork','UserProfileSection','send','includes','IS\x20EMPTY','DESC','then','AVG(%s)','json','merge','from','Run\x20Query:','metric','left_join','alias','attributes','toString','body','runReport','select','userProfileId'];(function(_0x41f84e,_0x5ecfaf){const _0x2b6b54=function(_0x17e038){while(--_0x17e038){_0x41f84e['push'](_0x41f84e['shift']());}};_0x2b6b54(++_0x5ecfaf);}(a9_0x5ecf,0x1cf));const a9_0x2b6b=function(_0x41f84e,_0x5ecfaf){_0x41f84e=_0x41f84e-0x0;let _0x2b6b54=a9_0x5ecf[_0x41f84e];return _0x2b6b54;};const _0x26ad38=a9_0x2b6b;'use strict';const util=require('util'),path=require(_0x26ad38('0x34')),_=require(_0x26ad38('0x2a')),squel=require(_0x26ad38('0x61')),qs=require(_0x26ad38('0x71')),logger=require('../../config/logger')(_0x26ad38('0x76')),db=require(_0x26ad38('0x68'))['db'],dbH=require('../../mysqldb')[_0x26ad38('0x51')],{Op,ValidationErrorItem,QueryTypes}=require(_0x26ad38('0x84'));function respondWithResult(_0x17e038,_0x4c143b){return _0x4c143b=_0x4c143b||0xc8,function(_0x14fc5d){const _0x17207d=a9_0x2b6b;if(_0x14fc5d)return _0x17e038['status'](_0x4c143b)[_0x17207d('0x44')](_0x14fc5d);};}function respondWithFilteredResult(_0x3512f3,_0x527982){return function(_0x593b62){const _0x2f91e9=a9_0x2b6b;if(_0x593b62){const _0x310731=_0x593b62[_0x2f91e9('0x72')],_0x42d15f=_0x527982[_0x2f91e9('0xc')];let _0x1f01af=_0x527982[_0x2f91e9('0xc')]+_0x527982[_0x2f91e9('0x79')],_0x43a306;return _0x1f01af>=_0x310731?(_0x1f01af=_0x310731,_0x43a306=0xc8):_0x43a306=0xce,_0x3512f3[_0x2f91e9('0x28')](_0x43a306),_0x3512f3[_0x2f91e9('0x59')]('Content-Range',_0x42d15f+'-'+_0x1f01af+'/'+_0x310731)[_0x2f91e9('0x44')](_0x593b62);}return null;};}function saveUpdates(_0x50b096){return function(_0x4180e0){const _0x203cd0=a9_0x2b6b;if(_0x4180e0)return _0x4180e0[_0x203cd0('0x16')](_0x50b096)[_0x203cd0('0x42')](function(_0x440fd5){return _0x440fd5;});return null;};}function removeEntity(_0x5b9ec6){return function(_0x1fe531){const _0x68828a=a9_0x2b6b;if(_0x1fe531)return _0x1fe531[_0x68828a('0xb')]()[_0x68828a('0x42')](function(){const _0x58a6cd=_0x68828a,_0x528c50=_0x1fe531[_0x58a6cd('0x3')]({'plain':!![]}),_0x4d2c1c=_0x58a6cd('0x19');return db[_0x58a6cd('0x1')][_0x58a6cd('0xb')]({'where':{'type':_0x4d2c1c,'resourceId':_0x528c50['id']}})[_0x58a6cd('0x42')](function(){return _0x1fe531;});})[_0x68828a('0x42')](function(){const _0xaac084=_0x68828a;_0x5b9ec6[_0xaac084('0x28')](0xcc)[_0xaac084('0x1e')]();});};}function handleEntityNotFound(_0x1541f9){return function(_0xc2ccb9){const _0xb6af76=a9_0x2b6b;return!_0xc2ccb9&&_0x1541f9[_0xb6af76('0x1a')](0x194),_0xc2ccb9;};}function handleError(_0x56e993,_0x5e385f){return _0x5e385f=_0x5e385f||0x1f4,function(_0x330ae8){const _0x48b64a=a9_0x2b6b;logger['error'](_0x330ae8[_0x48b64a('0x39')]),_0x330ae8[_0x48b64a('0x3a')]&&delete _0x330ae8[_0x48b64a('0x3a')],_0x56e993['status'](_0x5e385f)[_0x48b64a('0x3e')](_0x330ae8);};}exports[_0x26ad38('0x1d')]=function(_0x578af3,_0x145bc1){const _0x3c30a3=_0x26ad38;let _0x55d03c={};const _0x2d60fc={},_0x39620c={'count':0x0,'rows':[]},_0xcb7862=_[_0x3c30a3('0x1b')](db[_0x3c30a3('0x27')][_0x3c30a3('0x65')],function(_0x5bb2c0){const _0x9c9dff=_0x3c30a3;return{'name':_0x5bb2c0[_0x9c9dff('0x55')],'type':_0x5bb2c0[_0x9c9dff('0x23')][_0x9c9dff('0x13')]};});_0x2d60fc[_0x3c30a3('0x1f')]=_[_0x3c30a3('0x1b')](_0xcb7862,_0x3c30a3('0x3a')),_0x2d60fc['query']=_[_0x3c30a3('0xe')](_0x578af3[_0x3c30a3('0x0')]),_0x2d60fc[_0x3c30a3('0x60')]=_[_0x3c30a3('0x5a')](_0x2d60fc[_0x3c30a3('0x1f')],_0x2d60fc[_0x3c30a3('0x0')]),_0x55d03c['attributes']=_[_0x3c30a3('0x5a')](_0x2d60fc['model'],qs['fields'](_0x578af3[_0x3c30a3('0x0')]['fields'])),_0x55d03c[_0x3c30a3('0x4b')]=_0x55d03c[_0x3c30a3('0x4b')][_0x3c30a3('0x64')]?_0x55d03c[_0x3c30a3('0x4b')]:_0x2d60fc[_0x3c30a3('0x1f')];typeof _0x578af3[_0x3c30a3('0x0')]['nolimit']===_0x3c30a3('0xf')&&(_0x55d03c['limit']=qs[_0x3c30a3('0x79')](_0x578af3[_0x3c30a3('0x0')][_0x3c30a3('0x79')]),_0x55d03c['offset']=qs[_0x3c30a3('0xc')](_0x578af3['query'][_0x3c30a3('0xc')]));_0x55d03c[_0x3c30a3('0x14')]=qs['sort'](_0x578af3[_0x3c30a3('0x0')]['sort']),_0x55d03c[_0x3c30a3('0x11')]=qs['filters'](_[_0x3c30a3('0x5')](_0x578af3[_0x3c30a3('0x0')],_0x2d60fc[_0x3c30a3('0x60')]),_0xcb7862);_0x578af3[_0x3c30a3('0x0')][_0x3c30a3('0x18')]&&(_0x55d03c[_0x3c30a3('0x11')]=_[_0x3c30a3('0x45')](_0x55d03c['where'],{[Op['or']]:_[_0x3c30a3('0x1b')](_0xcb7862,function(_0x5ae4c9){const _0x169e39=_0x3c30a3;if(_0x5ae4c9[_0x169e39('0x23')]!=='VIRTUAL'){const _0x37952b={};return _0x37952b[_0x5ae4c9['name']]={[Op['like']]:'%'+_0x578af3[_0x169e39('0x0')][_0x169e39('0x18')]+'%'},_0x37952b;}})}));_0x55d03c=_[_0x3c30a3('0x45')]({},_0x55d03c,_0x578af3[_0x3c30a3('0x7b')]);const _0x1deeb4={'where':_0x55d03c['where']};return db[_0x3c30a3('0x27')][_0x3c30a3('0x72')](_0x1deeb4)[_0x3c30a3('0x42')](function(_0x41420c){const _0x588fe7=_0x3c30a3;return _0x39620c[_0x588fe7('0x72')]=_0x41420c,_0x578af3[_0x588fe7('0x0')]['includeAll']&&(_0x55d03c['include']=[{'all':!![]}]),db[_0x588fe7('0x27')][_0x588fe7('0x2')](_0x55d03c);})[_0x3c30a3('0x42')](function(_0x4fa1a9){return _0x39620c['rows']=_0x4fa1a9,_0x39620c;})[_0x3c30a3('0x42')](respondWithFilteredResult(_0x145bc1,_0x55d03c))['catch'](handleError(_0x145bc1,null));},exports[_0x26ad38('0x5d')]=function(_0x3cc877,_0x1a3273){const _0x4ebf1b=_0x26ad38;let _0x1d58aa={'raw':!![],'where':{'id':_0x3cc877['params']['id']}};const _0x6b7e33={};return _0x6b7e33[_0x4ebf1b('0x1f')]=_[_0x4ebf1b('0xe')](db[_0x4ebf1b('0x27')]['rawAttributes']),_0x6b7e33[_0x4ebf1b('0x0')]=_[_0x4ebf1b('0xe')](_0x3cc877[_0x4ebf1b('0x0')]),_0x6b7e33[_0x4ebf1b('0x60')]=_[_0x4ebf1b('0x5a')](_0x6b7e33[_0x4ebf1b('0x1f')],_0x6b7e33['query']),_0x1d58aa['attributes']=_['intersection'](_0x6b7e33['model'],qs[_0x4ebf1b('0x36')](_0x3cc877[_0x4ebf1b('0x0')]['fields'])),_0x1d58aa['attributes']=_0x1d58aa[_0x4ebf1b('0x4b')][_0x4ebf1b('0x64')]?_0x1d58aa[_0x4ebf1b('0x4b')]:_0x6b7e33[_0x4ebf1b('0x1f')],_0x3cc877['query'][_0x4ebf1b('0xd')]&&(_0x1d58aa[_0x4ebf1b('0x5f')]=[{'all':!![]}]),_0x1d58aa=_[_0x4ebf1b('0x45')]({},_0x1d58aa,_0x3cc877[_0x4ebf1b('0x7b')]),db[_0x4ebf1b('0x27')]['findOne'](_0x1d58aa)['then'](handleEntityNotFound(_0x1a3273,null))[_0x4ebf1b('0x42')](respondWithResult(_0x1a3273,null))[_0x4ebf1b('0x69')](handleError(_0x1a3273,null));},exports[_0x26ad38('0x66')]=function(_0x3854c5,_0x4df077){const _0x3a7bce=_0x26ad38;return db[_0x3a7bce('0x27')]['create'](_0x3854c5[_0x3a7bce('0x4d')],{})['then'](function(_0x2de47c){const _0xbba025=_0x3a7bce,_0x2c7d7e=_0x3854c5[_0xbba025('0x30')][_0xbba025('0x3')]({'plain':!![]});if(!_0x2c7d7e)throw new Error(_0xbba025('0x2e'));if(_0x2c7d7e['role']===_0xbba025('0x30')){const _0x4b20c1=_0x2de47c['get']({'plain':!![]}),_0x2c1371=_0xbba025('0x67');return db[_0xbba025('0x3d')]['findOne']({'where':{'name':_0x2c1371,'userProfileId':_0x2c7d7e[_0xbba025('0x50')]},'raw':!![]})[_0xbba025('0x42')](function(_0x26b11e){const _0x393951=_0xbba025;return _0x26b11e&&_0x26b11e[_0x393951('0x1c')]===0x0?db[_0x393951('0x1')][_0x393951('0x66')]({'name':_0x4b20c1[_0x393951('0x3a')],'resourceId':_0x4b20c1['id'],'type':_0x393951('0x19'),'sectionId':_0x26b11e['id']},{})['then'](function(){return _0x2de47c;}):_0x2de47c;})['catch'](function(_0x8ec622){const _0x398a8b=_0xbba025;logger['error'](_0x398a8b('0x20'),_0x8ec622);throw _0x8ec622;});}return _0x2de47c;})['then'](respondWithResult(_0x4df077,0xc9))['catch'](handleError(_0x4df077,null));},exports[_0x26ad38('0x16')]=function(_0x14cf82,_0x14fee6){const _0x5672be=_0x26ad38;return _0x14cf82[_0x5672be('0x4d')]['id']&&delete _0x14cf82[_0x5672be('0x4d')]['id'],db[_0x5672be('0x27')]['findOne']({'where':{'id':_0x14cf82['params']['id']}})[_0x5672be('0x42')](handleEntityNotFound(_0x14fee6,null))[_0x5672be('0x42')](saveUpdates(_0x14cf82['body'],null))[_0x5672be('0x42')](respondWithResult(_0x14fee6,null))[_0x5672be('0x69')](handleError(_0x14fee6,null));},exports[_0x26ad38('0xb')]=function(_0x5733df,_0x2342c9){const _0x2d77cc=_0x26ad38;return db[_0x2d77cc('0x27')][_0x2d77cc('0x58')]({'where':{'id':_0x5733df[_0x2d77cc('0x7a')]['id']}})[_0x2d77cc('0x42')](handleEntityNotFound(_0x2342c9,null))[_0x2d77cc('0x42')](removeEntity(_0x2342c9,null))['catch'](handleError(_0x2342c9,null));},exports['preview']=function(_0x335023,_0xfaf739){const _0x51d7e6=_0x26ad38,_0x18e868=0xa,_0x181232=['join',_0x51d7e6('0x49'),'right_join',_0x51d7e6('0x24')],_0x3ab074={'SUM':'SUM(%s)','COUNT':_0x51d7e6('0x32'),'COUNT\x20DISTINCT':_0x51d7e6('0x5c'),'MAX':_0x51d7e6('0x15'),'MIN':_0x51d7e6('0x86'),'AVG':_0x51d7e6('0x43'),'GROUP_CONCAT':_0x51d7e6('0x7d'),'GROUP_CONCAT\x20ASC':_0x51d7e6('0x5e'),'GROUP_CONCAT\x20DESC':_0x51d7e6('0x2f')},_0x1e30e2={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x51d7e6('0x73'),'HOUR':'HOUR(%s)','ROUND':_0x51d7e6('0x75'),'UNIX_TIMESTAMP':_0x51d7e6('0x7f')},_0x4298ea=function(_0x12f92c){const _0x1c7346=_0x51d7e6;return!_['includes']([_0x1c7346('0x6d'),_0x1c7346('0x6e'),_0x1c7346('0x40'),_0x1c7346('0x35')],_0x12f92c);},_0x167e56=function(_0x2bdf7e){const _0x44131c=_0x51d7e6;if(!_0x2bdf7e||!_0x2bdf7e['rules'][_0x44131c('0x64')])return'';let _0x4c07f7='(';for(let _0x50e7c4=0x0;_0x50e7c4<_0x2bdf7e[_0x44131c('0x6c')][_0x44131c('0x64')];_0x50e7c4+=0x1){_0x50e7c4>0x0&&(_0x4c07f7+='\x20'+_0x2bdf7e[_0x44131c('0x2b')]+'\x20'),_0x4c07f7+=_0x2bdf7e['rules'][_0x50e7c4][_0x44131c('0x5b')]?_0x167e56(_0x2bdf7e[_0x44131c('0x6c')][_0x50e7c4]['group']):_0x2bdf7e[_0x44131c('0x6c')][_0x50e7c4][_0x44131c('0x10')]+'\x20'+_0x2bdf7e[_0x44131c('0x6c')][_0x50e7c4]['condition']+(_0x4298ea(_0x2bdf7e[_0x44131c('0x6c')][_0x50e7c4][_0x44131c('0x78')])?'\x20'+_0x2bdf7e[_0x44131c('0x6c')][_0x50e7c4]['value']:'');}return _0x4c07f7+')';};let _0x4bf4ea={'where':{'id':_0x335023[_0x51d7e6('0x7a')]['id']}},_0x55aaa2,_0x2d6d18,_0x105aa6;return _0x4bf4ea=_[_0x51d7e6('0x45')]({},_0x4bf4ea,_0x335023['options']),db[_0x51d7e6('0x27')][_0x51d7e6('0x58')](_0x4bf4ea)[_0x51d7e6('0x42')](function(_0x95e67d){const _0x2b254a=_0x51d7e6;if(_0x95e67d)return _0x55aaa2=_0x95e67d,_0x95e67d[_0x2b254a('0x81')]();return null;})[_0x51d7e6('0x42')](function(_0x315a01){const _0x56ac70=_0x51d7e6;if(_0x315a01){if(!_0x315a01[_0x56ac70('0x64')])throw new ValidationErrorItem(_0x56ac70('0x31'),0x193);return _0x2d6d18=_0x315a01,db['AnalyticMetric'][_0x56ac70('0x2')]({'raw':!![]});}return null;})[_0x51d7e6('0x42')](function(_0x39e5dd){const _0x1637a5=_0x51d7e6;if(_0x39e5dd){_0x105aa6=_['keyBy'](_0x39e5dd,'id');let _0x2bd8df;const _0x5cd649=squel['select']();_0x5cd649[_0x1637a5('0x46')](_0x55aaa2['table']);for(let _0x28f56a=0x0;_0x28f56a<_0x2d6d18[_0x1637a5('0x64')];_0x28f56a+=0x1){_0x2bd8df=_0x2d6d18[_0x28f56a][_0x1637a5('0x9')]?_0x105aa6[_0x2d6d18[_0x28f56a][_0x1637a5('0x9')]][_0x1637a5('0x48')]:_0x2d6d18[_0x28f56a]['field'],_0x2bd8df=_0x2d6d18[_0x28f56a][_0x1637a5('0x2c')]?_[_0x1637a5('0x8')](_0x3ab074[_0x2d6d18[_0x28f56a][_0x1637a5('0x2c')]],'%s',_0x2bd8df):_0x2bd8df,_0x2bd8df=_0x2d6d18[_0x28f56a][_0x1637a5('0x37')]?_[_0x1637a5('0x8')](_0x1e30e2[_0x2d6d18[_0x28f56a][_0x1637a5('0x37')]],'%s',_0x2bd8df):_0x2bd8df,_0x2d6d18[_0x28f56a]['groupBy']&&_0x5cd649['group'](_0x2bd8df),_0x2d6d18[_0x28f56a][_0x1637a5('0x3b')]&&_0x5cd649[_0x1637a5('0x14')](_0x2bd8df,_0x2d6d18[_0x28f56a]['orderBy']===_0x1637a5('0x41')?![]:!![]),_0x5cd649['field'](_0x2bd8df,_0x2d6d18[_0x28f56a][_0x1637a5('0x4a')]||_0x2bd8df);}if(_0x55aaa2[_0x1637a5('0x82')]){_0x55aaa2[_0x1637a5('0x82')]=JSON[_0x1637a5('0x29')](_0x55aaa2['joins']);for(let _0xbb7b05=0x0;_0xbb7b05<_0x55aaa2['joins'][_0x1637a5('0x64')];_0xbb7b05+=0x1){_0x55aaa2['joins'][_0xbb7b05][_0x1637a5('0x23')]&&_[_0x1637a5('0x3f')](_0x181232,_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0x23')])&&_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05]['parentKey']&&_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0xa')]&&_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0x54')]&&_0x5cd649[_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05]['type']](_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0xa')],null,util[_0x1637a5('0x37')]('%s.%s\x20=\x20%s.%s',_0x55aaa2['table'],_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0x7')],_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0xa')],_0x55aaa2[_0x1637a5('0x82')][_0xbb7b05][_0x1637a5('0x54')]));}}return _0x55aaa2[_0x1637a5('0x4')]&&(_0x55aaa2[_0x1637a5('0x4')]=JSON[_0x1637a5('0x29')](_0x55aaa2[_0x1637a5('0x4')]),_0x5cd649['where'](_0x167e56(_0x55aaa2[_0x1637a5('0x4')][_0x1637a5('0x5b')]))),_0x5cd649[_0x1637a5('0x79')](_0x18e868),_0x5cd649[_0x1637a5('0xc')](0x0),logger[_0x1637a5('0x70')]('Limited\x20Query:',_0x5cd649[_0x1637a5('0x4c')]()),db[_0x1637a5('0x84')][_0x1637a5('0x0')](_0x5cd649[_0x1637a5('0x4c')](),{'type':QueryTypes[_0x1637a5('0x2d')]});}})[_0x51d7e6('0x42')](respondWithResult(_0xfaf739,null))[_0x51d7e6('0x69')](handleError(_0xfaf739,null));};function runReport(_0x217aa6,_0x240d1d,_0x55ce69){const _0x3cfe43=_0x26ad38,_0x246b6b=_0x240d1d['name'],_0x55f041=0xa,_0x4ec5b6=[_0x3cfe43('0x6a'),_0x3cfe43('0x49'),'right_join',_0x3cfe43('0x24')],_0x241068={'SUM':_0x3cfe43('0x38'),'COUNT':_0x3cfe43('0x32'),'COUNT\x20DISTINCT':_0x3cfe43('0x5c'),'MAX':_0x3cfe43('0x15'),'MIN':_0x3cfe43('0x86'),'AVG':_0x3cfe43('0x43'),'GROUP_CONCAT':_0x3cfe43('0x7d'),'GROUP_CONCAT\x20ASC':_0x3cfe43('0x5e'),'GROUP_CONCAT\x20DESC':_0x3cfe43('0x2f')},_0x73017d={'SEC_TO_TIME':_0x3cfe43('0x6'),'DATE':_0x3cfe43('0x73'),'HOUR':'HOUR(%s)','ROUND':_0x3cfe43('0x75'),'UNIX_TIMESTAMP':_0x3cfe43('0x7f')},_0x47e035=function(_0x39fd9a){const _0xed9c34=_0x3cfe43;return!_[_0xed9c34('0x3f')]([_0xed9c34('0x6d'),_0xed9c34('0x6e'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x39fd9a);},_0x1690a9=function(_0x78b791){const _0x3d9523=_0x3cfe43;if(!_0x78b791||!_0x78b791['rules'][_0x3d9523('0x64')])return'';let _0x2ddd64='(';for(let _0x232539=0x0;_0x232539<_0x78b791[_0x3d9523('0x6c')]['length'];_0x232539+=0x1){_0x232539>0x0&&(_0x2ddd64+='\x20'+_0x78b791[_0x3d9523('0x2b')]+'\x20'),_0x2ddd64+=_0x78b791[_0x3d9523('0x6c')][_0x232539][_0x3d9523('0x5b')]?_0x1690a9(_0x78b791[_0x3d9523('0x6c')][_0x232539][_0x3d9523('0x5b')]):_0x78b791['rules'][_0x232539]['field']+'\x20'+_0x78b791[_0x3d9523('0x6c')][_0x232539][_0x3d9523('0x78')]+(_0x47e035(_0x78b791['rules'][_0x232539][_0x3d9523('0x78')])?'\x20'+_0x78b791[_0x3d9523('0x6c')][_0x232539][_0x3d9523('0x17')]:'');}return _0x2ddd64+')';};let _0x44b3ce={'where':{'id':_0x217aa6['id']}},_0x4f01b4,_0x25d18d,_0x4fd10b,_0x4501e5,_0x83b8dd;return _0x44b3ce=_[_0x3cfe43('0x45')]({},_0x44b3ce,_0x55ce69),db[_0x3cfe43('0x27')][_0x3cfe43('0x58')](_0x44b3ce)['then'](function(_0x5ba360){const _0x2fdc61=_0x3cfe43;if(_0x5ba360)return _0x4f01b4=_0x5ba360,_0x5ba360[_0x2fdc61('0x81')]();return null;})[_0x3cfe43('0x42')](function(_0x16c1c5){const _0x5bdfd1=_0x3cfe43;if(_0x16c1c5){if(!_0x16c1c5[_0x5bdfd1('0x64')])throw new ValidationErrorItem(_0x5bdfd1('0x31'),0x193);return _0x25d18d=_0x16c1c5,db[_0x5bdfd1('0x6f')][_0x5bdfd1('0x2')]({'raw':!![]});}return null;})['then'](function(_0x1ef305){const _0x50e5aa=_0x3cfe43;if(_0x1ef305){_0x4fd10b=_['keyBy'](_0x1ef305,'id');let _0x16b691;const _0x274b1a=squel['select']();_0x274b1a['from'](_0x4f01b4[_0x50e5aa('0x77')]);for(let _0x107acb=0x0;_0x107acb<_0x25d18d[_0x50e5aa('0x64')];_0x107acb+=0x1){_0x16b691=_0x25d18d[_0x107acb][_0x50e5aa('0x9')]?_0x4fd10b[_0x25d18d[_0x107acb]['MetricId']][_0x50e5aa('0x48')]:_0x25d18d[_0x107acb][_0x50e5aa('0x10')],_0x16b691=_0x25d18d[_0x107acb]['function']?_[_0x50e5aa('0x8')](_0x241068[_0x25d18d[_0x107acb][_0x50e5aa('0x2c')]],'%s',_0x16b691):_0x16b691,_0x16b691=_0x25d18d[_0x107acb][_0x50e5aa('0x37')]?_['replace'](_0x73017d[_0x25d18d[_0x107acb][_0x50e5aa('0x37')]],'%s',_0x16b691):_0x16b691,_0x25d18d[_0x107acb]['groupBy']&&_0x274b1a[_0x50e5aa('0x5b')](_0x16b691),_0x25d18d[_0x107acb][_0x50e5aa('0x3b')]&&_0x274b1a[_0x50e5aa('0x14')](_0x16b691,_0x25d18d[_0x107acb][_0x50e5aa('0x3b')]===_0x50e5aa('0x41')?![]:!![]),_0x274b1a[_0x50e5aa('0x10')](_0x16b691,_0x25d18d[_0x107acb][_0x50e5aa('0x4a')]||_0x16b691);}if(_0x4f01b4['joins']){_0x4f01b4['joins']=JSON['parse'](_0x4f01b4[_0x50e5aa('0x82')]);for(let _0x2ba194=0x0;_0x2ba194<_0x4f01b4[_0x50e5aa('0x82')][_0x50e5aa('0x64')];_0x2ba194+=0x1){_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194]['type']&&_[_0x50e5aa('0x3f')](_0x4ec5b6,_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0x23')])&&_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0x7')]&&_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0xa')]&&_0x4f01b4['joins'][_0x2ba194][_0x50e5aa('0x54')]&&_0x274b1a[_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0x23')]](_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0xa')],null,util['format'](_0x50e5aa('0x25'),_0x4f01b4[_0x50e5aa('0x77')],_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0x7')],_0x4f01b4[_0x50e5aa('0x82')][_0x2ba194][_0x50e5aa('0xa')],_0x4f01b4['joins'][_0x2ba194][_0x50e5aa('0x54')]));}}return _0x4f01b4[_0x50e5aa('0x4')]&&(_0x4f01b4[_0x50e5aa('0x4')]=JSON['parse'](_0x4f01b4[_0x50e5aa('0x4')]),_0x274b1a[_0x50e5aa('0x11')](_0x1690a9(_0x4f01b4['conditions'][_0x50e5aa('0x5b')]))),_0x83b8dd=_0x274b1a[_0x50e5aa('0x57')](),_0x274b1a[_0x50e5aa('0x79')](_0x55f041),_0x274b1a[_0x50e5aa('0xc')](0x0),logger['debug'](_0x50e5aa('0x7e'),_0x274b1a[_0x50e5aa('0x4c')]()),db[_0x50e5aa('0x84')][_0x50e5aa('0x0')](_0x274b1a[_0x50e5aa('0x4c')](),{'type':QueryTypes[_0x50e5aa('0x2d')]});}})[_0x3cfe43('0x42')](function(_0x1f0308){const _0x19b6b7=_0x3cfe43;if(!_0x1f0308[_0x19b6b7('0x64')])throw new ValidationErrorItem('No\x20available\x20data',0xcc);if(_0x240d1d[_0x19b6b7('0x52')]==='web')return null;const _0xeb19f8=_[_0x19b6b7('0x45')](_0x240d1d,{'name':_0x240d1d['fullPath']||_0x240d1d['name']||_0x4f01b4[_0x19b6b7('0x3a')],'basename':_0x246b6b,'savename':util['format'](_0x19b6b7('0x7c'),_0x240d1d[_0x19b6b7('0x3a')]||_0x4f01b4['name'],require(_0x19b6b7('0x83'))['generate'](0x4),_0x240d1d[_0x19b6b7('0x52')]||_0x19b6b7('0x56')),'reportId':_0x4f01b4['id'],'reportType':_0x19b6b7('0x53')});return db[_0x19b6b7('0x26')]['create'](_0xeb19f8,{'raw':!![]});})[_0x3cfe43('0x42')](function(_0x2c4990){const _0x7e3312=_0x3cfe43;_0x4f01b4[_0x7e3312('0x77')]===_0x7e3312('0x62')?_0x83b8dd['where'](_0x4f01b4[_0x7e3312('0x77')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x240d1d['startDate'],_0x240d1d['endDate']):_0x83b8dd['where'](_0x4f01b4[_0x7e3312('0x77')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x240d1d[_0x7e3312('0x33')],_0x240d1d[_0x7e3312('0x74')]);if(_0x2c4990)return logger['info'](_0x7e3312('0x47'),_0x83b8dd[_0x7e3312('0x4c')]()),require(_0x7e3312('0x63'))[_0x7e3312('0x3c')](path['join'](__dirname,'../../components/export/',_0x2c4990['output']),[_0x2c4990['id'],_0x83b8dd[_0x7e3312('0x4c')](),path['join'](__dirname,_0x7e3312('0x22'),_0x2c4990[_0x7e3312('0x80')]),_0x246b6b]),_0x2c4990;else{const _0x1e2326=squel[_0x7e3312('0x4f')]();return _0x1e2326[_0x7e3312('0x46')]('('+_0x83b8dd[_0x7e3312('0x4c')]()+')',_0x7e3312('0x6b')),_0x1e2326[_0x7e3312('0x10')]('COUNT(*)',_0x7e3312('0x72')),_0x83b8dd[_0x7e3312('0x79')](_0x240d1d[_0x7e3312('0x79')]||_0x55f041),_0x83b8dd[_0x7e3312('0xc')](_0x240d1d[_0x7e3312('0xc')]||0x0),dbH[_0x7e3312('0x84')][_0x7e3312('0x0')](_0x1e2326[_0x7e3312('0x4c')](),{'type':dbH[_0x7e3312('0x84')]['QueryTypes']['SELECT']})[_0x7e3312('0x42')](function(_0x27f031){const _0x50bf1b=_0x7e3312;return!_0x27f031[_0x50bf1b('0x64')]?_0x4501e5=0x0:_0x4501e5=_0x27f031[0x0][_0x50bf1b('0x72')]||0x0,dbH['sequelize']['query'](_0x83b8dd[_0x50bf1b('0x4c')](),{'type':dbH[_0x50bf1b('0x84')][_0x50bf1b('0x12')][_0x50bf1b('0x2d')]});})['then'](function(_0xdc80df){return{'rows':_0xdc80df||[],'count':_0x4501e5};});}});}exports['run']=function(_0x7657b1,_0x1c3f1f){const _0x4f7bde=_0x26ad38;return runReport(_0x7657b1[_0x4f7bde('0x7a')],_0x7657b1[_0x4f7bde('0x0')],_0x7657b1[_0x4f7bde('0x7b')])[_0x4f7bde('0x42')](respondWithResult(_0x1c3f1f,null))[_0x4f7bde('0x69')](handleError(_0x1c3f1f,null));},exports[_0x26ad38('0x4e')]=runReport,exports[_0x26ad38('0x0')]=function(_0x17ee67,_0x1199bf){const _0x20d670=_0x26ad38,_0x470db9=0xa,_0x3551b7=[_0x20d670('0x6a'),_0x20d670('0x49'),_0x20d670('0x87'),_0x20d670('0x24')],_0xecfc95={'SUM':_0x20d670('0x38'),'COUNT':_0x20d670('0x32'),'COUNT\x20DISTINCT':_0x20d670('0x5c'),'MAX':_0x20d670('0x15'),'MIN':_0x20d670('0x86'),'AVG':'AVG(%s)','GROUP_CONCAT':_0x20d670('0x7d'),'GROUP_CONCAT\x20ASC':_0x20d670('0x5e'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0x3ff356={'SEC_TO_TIME':_0x20d670('0x6'),'DATE':_0x20d670('0x73'),'HOUR':'HOUR(%s)','ROUND':_0x20d670('0x75'),'UNIX_TIMESTAMP':_0x20d670('0x7f')},_0x67f3cd=function(_0x375484){const _0x551b18=_0x20d670;return!_[_0x551b18('0x3f')]([_0x551b18('0x6d'),_0x551b18('0x6e'),_0x551b18('0x40'),_0x551b18('0x35')],_0x375484);},_0x4b921b=function(_0x509661){const _0x1dbc29=_0x20d670;if(!_0x509661||!_0x509661[_0x1dbc29('0x6c')][_0x1dbc29('0x64')])return'';let _0x16ad0d='(';for(let _0x1b9d5a=0x0;_0x1b9d5a<_0x509661['rules'][_0x1dbc29('0x64')];_0x1b9d5a+=0x1){_0x1b9d5a>0x0&&(_0x16ad0d+='\x20'+_0x509661[_0x1dbc29('0x2b')]+'\x20'),_0x16ad0d+=_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a]['group']?_0x4b921b(_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a][_0x1dbc29('0x5b')]):_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a][_0x1dbc29('0x10')]+'\x20'+_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a][_0x1dbc29('0x78')]+(_0x67f3cd(_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a][_0x1dbc29('0x78')])?'\x20'+_0x509661[_0x1dbc29('0x6c')][_0x1b9d5a]['value']:'');}return _0x16ad0d+')';};let _0xc7251b={'where':{'id':_0x17ee67[_0x20d670('0x7a')]['id']}},_0x2b4527,_0x4f8f4e,_0x4f7ddf,_0x543cbb;return _0xc7251b=_['merge']({},_0xc7251b,_0x17ee67[_0x20d670('0x7b')]),db['AnalyticDefaultReport'][_0x20d670('0x58')](_0xc7251b)['then'](function(_0x89e7ef){const _0x3681da=_0x20d670;if(_0x89e7ef)return _0x2b4527=_0x89e7ef,_0x89e7ef[_0x3681da('0x81')]();return null;})[_0x20d670('0x42')](function(_0x1c1304){const _0x1eb332=_0x20d670;if(_0x1c1304){if(!_0x1c1304[_0x1eb332('0x64')])throw new ValidationErrorItem(_0x1eb332('0x31'),0x193);return _0x4f8f4e=_0x1c1304,db[_0x1eb332('0x6f')][_0x1eb332('0x2')]({'raw':!![]});}return null;})['then'](function(_0x24bfc7){const _0x47e171=_0x20d670;if(_0x24bfc7){_0x4f7ddf=_[_0x47e171('0x85')](_0x24bfc7,'id');let _0x522ea8;const _0x4dae8a=squel['select']();_0x4dae8a[_0x47e171('0x46')](_0x2b4527[_0x47e171('0x77')]);for(let _0x480e90=0x0;_0x480e90<_0x4f8f4e[_0x47e171('0x64')];_0x480e90+=0x1){_0x522ea8=_0x4f8f4e[_0x480e90][_0x47e171('0x9')]?_0x4f7ddf[_0x4f8f4e[_0x480e90][_0x47e171('0x9')]][_0x47e171('0x48')]:_0x4f8f4e[_0x480e90][_0x47e171('0x10')],_0x522ea8=_0x4f8f4e[_0x480e90][_0x47e171('0x2c')]?_[_0x47e171('0x8')](_0xecfc95[_0x4f8f4e[_0x480e90][_0x47e171('0x2c')]],'%s',_0x522ea8):_0x522ea8,_0x522ea8=_0x4f8f4e[_0x480e90][_0x47e171('0x37')]?_[_0x47e171('0x8')](_0x3ff356[_0x4f8f4e[_0x480e90][_0x47e171('0x37')]],'%s',_0x522ea8):_0x522ea8,_0x4f8f4e[_0x480e90][_0x47e171('0x21')]&&_0x4dae8a['group'](_0x522ea8),_0x4f8f4e[_0x480e90][_0x47e171('0x3b')]&&_0x4dae8a[_0x47e171('0x14')](_0x522ea8,_0x4f8f4e[_0x480e90]['orderBy']==='DESC'?![]:!![]),_0x4dae8a[_0x47e171('0x10')](_0x522ea8,_0x4f8f4e[_0x480e90]['alias']||_0x522ea8);}if(_0x2b4527[_0x47e171('0x82')]){_0x2b4527[_0x47e171('0x82')]=JSON['parse'](_0x2b4527[_0x47e171('0x82')]);for(let _0x45debb=0x0;_0x45debb<_0x2b4527[_0x47e171('0x82')]['length'];_0x45debb+=0x1){_0x2b4527[_0x47e171('0x82')][_0x45debb][_0x47e171('0x23')]&&_[_0x47e171('0x3f')](_0x3551b7,_0x2b4527[_0x47e171('0x82')][_0x45debb]['type'])&&_0x2b4527[_0x47e171('0x82')][_0x45debb][_0x47e171('0x7')]&&_0x2b4527[_0x47e171('0x82')][_0x45debb][_0x47e171('0xa')]&&_0x2b4527[_0x47e171('0x82')][_0x45debb][_0x47e171('0x54')]&&_0x4dae8a[_0x2b4527[_0x47e171('0x82')][_0x45debb]['type']](_0x2b4527[_0x47e171('0x82')][_0x45debb]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x2b4527['table'],_0x2b4527[_0x47e171('0x82')][_0x45debb][_0x47e171('0x7')],_0x2b4527[_0x47e171('0x82')][_0x45debb]['foreignTable'],_0x2b4527[_0x47e171('0x82')][_0x45debb]['foreignKey']));}}return _0x2b4527['conditions']&&(_0x2b4527[_0x47e171('0x4')]=JSON['parse'](_0x2b4527[_0x47e171('0x4')]),_0x4dae8a['where'](_0x4b921b(_0x2b4527[_0x47e171('0x4')][_0x47e171('0x5b')]))),_0x543cbb=_0x4dae8a[_0x47e171('0x57')](),_0x4dae8a['limit'](_0x470db9),_0x4dae8a[_0x47e171('0xc')](0x0),logger[_0x47e171('0x70')]('Limited\x20Query:',_0x4dae8a[_0x47e171('0x4c')]()),db['sequelize'][_0x47e171('0x0')](_0x4dae8a[_0x47e171('0x4c')](),{'type':QueryTypes[_0x47e171('0x2d')]});}})[_0x20d670('0x42')](function(){return{'sql':_0x543cbb['toString']()};})[_0x20d670('0x42')](respondWithResult(_0x1199bf,null))[_0x20d670('0x69')](handleError(_0x1199bf,null));};
\ No newline at end of file
+const a9_0x579a=['csv','MAX(%s)','../../components/parsers/qs','query','select','create','DESC','VIRTUAL','status','Run\x20Query:','sequelize','map','conditions','findAll','getFields','includeAll','run','keyBy','right_join','parentKey','sort','savename','lodash','IS\x20EMPTY','condition','options','value','SUM(%s)','IS\x20NULL','json','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','COUNT(DISTINCT\x20%s)','Unable\x20to\x20retrieve\x20the\x20current\x20user','like','stack','body','rawAttributes','undefined','where','QueryTypes','SEC_TO_TIME(%s)','orderBy','clone','group','end','update','parse','order','rows','IS\x20NOT\x20NULL','%s.%s\x20=\x20%s.%s','table','foreignTable','type','endDate','UNIX_TIMESTAMP(%s)','catch','merge','info','generate','destroy','error','metric','cross_join','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','AVG(%s)','findOne','.createdAt\x20BETWEEN\x20?\x20AND\x20?','output','countTable','set','count','limit','Content-Range','MetricId','offset','joins','debug','../../config/logger','from','path','foreignKey','fields','user','filters','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','COUNT(%s)','web','AnalyticExtractedReport','replace','get','.calldate\x20BETWEEN\x20?\x20AND\x20?','../../mysqldb','startDate','Please\x20insert\x20at\x20least\x20one\x20field','filter','No\x20available\x20data','default','sendStatus','field','fieldName','join','name','length','key','keys','autoAssociation','HOUR(%s)','COUNT(*)','rules','UserProfileResource','../../files/reports','SELECT','util','AnalyticMetric','intersection','toString','includes','DATE(%s)','alias','function','ROUND(%s)','GROUP_CONCAT(%s)','format','left_join','params','then','attributes','model','AnalyticDefaultReport','operator','IS\x20NOT\x20EMPTY','groupBy','DefaultReports','fullPath','Limited\x20Query:'];(function(_0x5d28f6,_0x579a0a){const _0x2b28f3=function(_0x4d594f){while(--_0x4d594f){_0x5d28f6['push'](_0x5d28f6['shift']());}};_0x2b28f3(++_0x579a0a);}(a9_0x579a,0x12c));const a9_0x2b28=function(_0x5d28f6,_0x579a0a){_0x5d28f6=_0x5d28f6-0x0;let _0x2b28f3=a9_0x579a[_0x5d28f6];return _0x2b28f3;};const _0x355343=a9_0x2b28;'use strict';const util=require(_0x355343('0x55')),path=require(_0x355343('0x34')),_=require(_0x355343('0x82')),squel=require('squel'),qs=require(_0x355343('0x6e')),logger=require(_0x355343('0x32'))('api'),db=require('../../mysqldb')['db'],dbH=require(_0x355343('0x40'))['dbH'],{Op,ValidationErrorItem,QueryTypes}=require(_0x355343('0x76'));function respondWithResult(_0x4d594f,_0x1c6fab){return _0x1c6fab=_0x1c6fab||0xc8,function(_0x5212e8){const _0x598707=a9_0x2b28;if(_0x5212e8)return _0x4d594f[_0x598707('0x74')](_0x1c6fab)[_0x598707('0x1')](_0x5212e8);};}function respondWithFilteredResult(_0x25b720,_0x39753f){return function(_0x96509b){const _0x5b7fbe=a9_0x2b28;if(_0x96509b){const _0x290687=_0x96509b[_0x5b7fbe('0x2b')],_0x520b0f=_0x39753f['offset'];let _0x1710ac=_0x39753f['offset']+_0x39753f[_0x5b7fbe('0x2c')],_0x2f27da;return _0x1710ac>=_0x290687?(_0x1710ac=_0x290687,_0x2f27da=0xc8):_0x2f27da=0xce,_0x25b720[_0x5b7fbe('0x74')](_0x2f27da),_0x25b720[_0x5b7fbe('0x2a')](_0x5b7fbe('0x2d'),_0x520b0f+'-'+_0x1710ac+'/'+_0x290687)['json'](_0x96509b);}return null;};}function saveUpdates(_0x375d07){return function(_0x93272c){const _0x532e4b=a9_0x2b28;if(_0x93272c)return _0x93272c[_0x532e4b('0x11')](_0x375d07)[_0x532e4b('0x62')](function(_0x2bab5e){return _0x2bab5e;});return null;};}function removeEntity(_0x18a834){return function(_0x23c92b){const _0x94e267=a9_0x2b28;if(_0x23c92b)return _0x23c92b[_0x94e267('0x20')]()[_0x94e267('0x62')](function(){const _0x297a00=_0x94e267,_0xb156c4=_0x23c92b[_0x297a00('0x3e')]({'plain':!![]}),_0x2eba9f=_0x297a00('0x69');return db[_0x297a00('0x52')][_0x297a00('0x20')]({'where':{'type':_0x2eba9f,'resourceId':_0xb156c4['id']}})[_0x297a00('0x62')](function(){return _0x23c92b;});})['then'](function(){const _0x2e3874=_0x94e267;_0x18a834['status'](0xcc)[_0x2e3874('0x10')]();});};}function handleEntityNotFound(_0x58d9d1){return function(_0x270edc){const _0x5e5514=a9_0x2b28;return!_0x270edc&&_0x58d9d1[_0x5e5514('0x46')](0x194),_0x270edc;};}function handleError(_0x45140f,_0x5603c8){return _0x5603c8=_0x5603c8||0x1f4,function(_0x276797){const _0x286c1c=a9_0x2b28;logger[_0x286c1c('0x21')](_0x276797[_0x286c1c('0x6')]),_0x276797['name']&&delete _0x276797[_0x286c1c('0x4a')],_0x45140f[_0x286c1c('0x74')](_0x5603c8)['send'](_0x276797);};}exports['index']=function(_0x53bf9a,_0x187e7e){const _0x7f44b9=_0x355343;let _0xc32ad5={};const _0x1f50aa={},_0x127718={'count':0x0,'rows':[]},_0x3b79cf=_['map'](db[_0x7f44b9('0x65')][_0x7f44b9('0x8')],function(_0x3b305e){const _0x5376a8=_0x7f44b9;return{'name':_0x3b305e[_0x5376a8('0x48')],'type':_0x3b305e[_0x5376a8('0x19')][_0x5376a8('0x4c')]};});_0x1f50aa[_0x7f44b9('0x64')]=_[_0x7f44b9('0x77')](_0x3b79cf,'name'),_0x1f50aa[_0x7f44b9('0x6f')]=_[_0x7f44b9('0x4d')](_0x53bf9a[_0x7f44b9('0x6f')]),_0x1f50aa[_0x7f44b9('0x38')]=_[_0x7f44b9('0x57')](_0x1f50aa['model'],_0x1f50aa[_0x7f44b9('0x6f')]),_0xc32ad5['attributes']=_[_0x7f44b9('0x57')](_0x1f50aa[_0x7f44b9('0x64')],qs[_0x7f44b9('0x36')](_0x53bf9a[_0x7f44b9('0x6f')][_0x7f44b9('0x36')])),_0xc32ad5['attributes']=_0xc32ad5[_0x7f44b9('0x63')][_0x7f44b9('0x4b')]?_0xc32ad5[_0x7f44b9('0x63')]:_0x1f50aa[_0x7f44b9('0x64')];typeof _0x53bf9a[_0x7f44b9('0x6f')]['nolimit']===_0x7f44b9('0x9')&&(_0xc32ad5[_0x7f44b9('0x2c')]=qs[_0x7f44b9('0x2c')](_0x53bf9a[_0x7f44b9('0x6f')][_0x7f44b9('0x2c')]),_0xc32ad5['offset']=qs[_0x7f44b9('0x2f')](_0x53bf9a[_0x7f44b9('0x6f')][_0x7f44b9('0x2f')]));_0xc32ad5[_0x7f44b9('0x13')]=qs[_0x7f44b9('0x80')](_0x53bf9a[_0x7f44b9('0x6f')][_0x7f44b9('0x80')]),_0xc32ad5[_0x7f44b9('0xa')]=qs[_0x7f44b9('0x38')](_['pick'](_0x53bf9a[_0x7f44b9('0x6f')],_0x1f50aa['filters']),_0x3b79cf);_0x53bf9a[_0x7f44b9('0x6f')][_0x7f44b9('0x43')]&&(_0xc32ad5[_0x7f44b9('0xa')]=_['merge'](_0xc32ad5[_0x7f44b9('0xa')],{[Op['or']]:_[_0x7f44b9('0x77')](_0x3b79cf,function(_0x257106){const _0x1c3a63=_0x7f44b9;if(_0x257106[_0x1c3a63('0x19')]!==_0x1c3a63('0x73')){const _0x53bad8={};return _0x53bad8[_0x257106[_0x1c3a63('0x4a')]]={[Op[_0x1c3a63('0x5')]]:'%'+_0x53bf9a['query'][_0x1c3a63('0x43')]+'%'},_0x53bad8;}})}));_0xc32ad5=_[_0x7f44b9('0x1d')]({},_0xc32ad5,_0x53bf9a[_0x7f44b9('0x85')]);const _0x436315={'where':_0xc32ad5[_0x7f44b9('0xa')]};return db['AnalyticDefaultReport'][_0x7f44b9('0x2b')](_0x436315)[_0x7f44b9('0x62')](function(_0x507a40){const _0x1b2123=_0x7f44b9;return _0x127718['count']=_0x507a40,_0x53bf9a[_0x1b2123('0x6f')][_0x1b2123('0x7b')]&&(_0xc32ad5['include']=[{'all':!![]}]),db[_0x1b2123('0x65')][_0x1b2123('0x79')](_0xc32ad5);})[_0x7f44b9('0x62')](function(_0xff7e82){const _0x4b38ac=_0x7f44b9;return _0x127718[_0x4b38ac('0x14')]=_0xff7e82,_0x127718;})[_0x7f44b9('0x62')](respondWithFilteredResult(_0x187e7e,_0xc32ad5))['catch'](handleError(_0x187e7e,null));},exports['show']=function(_0x1e1fe8,_0x448f9b){const _0x123204=_0x355343;let _0x342663={'raw':!![],'where':{'id':_0x1e1fe8[_0x123204('0x61')]['id']}};const _0x37f8b6={};return _0x37f8b6[_0x123204('0x64')]=_[_0x123204('0x4d')](db['AnalyticDefaultReport'][_0x123204('0x8')]),_0x37f8b6[_0x123204('0x6f')]=_[_0x123204('0x4d')](_0x1e1fe8[_0x123204('0x6f')]),_0x37f8b6[_0x123204('0x38')]=_[_0x123204('0x57')](_0x37f8b6[_0x123204('0x64')],_0x37f8b6[_0x123204('0x6f')]),_0x342663[_0x123204('0x63')]=_['intersection'](_0x37f8b6[_0x123204('0x64')],qs[_0x123204('0x36')](_0x1e1fe8['query'][_0x123204('0x36')])),_0x342663[_0x123204('0x63')]=_0x342663[_0x123204('0x63')][_0x123204('0x4b')]?_0x342663[_0x123204('0x63')]:_0x37f8b6[_0x123204('0x64')],_0x1e1fe8[_0x123204('0x6f')][_0x123204('0x7b')]&&(_0x342663['include']=[{'all':!![]}]),_0x342663=_[_0x123204('0x1d')]({},_0x342663,_0x1e1fe8[_0x123204('0x85')]),db['AnalyticDefaultReport'][_0x123204('0x26')](_0x342663)['then'](handleEntityNotFound(_0x448f9b,null))[_0x123204('0x62')](respondWithResult(_0x448f9b,null))[_0x123204('0x1c')](handleError(_0x448f9b,null));},exports[_0x355343('0x71')]=function(_0x3b2db7,_0x1acd51){const _0x3616be=_0x355343;return db[_0x3616be('0x65')]['create'](_0x3b2db7[_0x3616be('0x7')],{})[_0x3616be('0x62')](function(_0x30e5e7){const _0x279628=_0x3616be,_0x18e3b4=_0x3b2db7[_0x279628('0x37')][_0x279628('0x3e')]({'plain':!![]});if(!_0x18e3b4)throw new Error(_0x279628('0x4'));if(_0x18e3b4['role']===_0x279628('0x37')){const _0x22a61e=_0x30e5e7[_0x279628('0x3e')]({'plain':!![]}),_0x32a481='Reports';return db['UserProfileSection'][_0x279628('0x26')]({'where':{'name':_0x32a481,'userProfileId':_0x18e3b4['userProfileId']},'raw':!![]})[_0x279628('0x62')](function(_0x47d659){const _0x2cabf6=_0x279628;return _0x47d659&&_0x47d659[_0x2cabf6('0x4e')]===0x0?db['UserProfileResource'][_0x2cabf6('0x71')]({'name':_0x22a61e[_0x2cabf6('0x4a')],'resourceId':_0x22a61e['id'],'type':_0x2cabf6('0x69'),'sectionId':_0x47d659['id']},{})[_0x2cabf6('0x62')](function(){return _0x30e5e7;}):_0x30e5e7;})[_0x279628('0x1c')](function(_0x2d77fc){const _0xbeb64c=_0x279628;logger[_0xbeb64c('0x21')](_0xbeb64c('0x24'),_0x2d77fc);throw _0x2d77fc;});}return _0x30e5e7;})[_0x3616be('0x62')](respondWithResult(_0x1acd51,0xc9))[_0x3616be('0x1c')](handleError(_0x1acd51,null));},exports[_0x355343('0x11')]=function(_0x2b9d9e,_0x290acf){const _0x4f8cdc=_0x355343;return _0x2b9d9e['body']['id']&&delete _0x2b9d9e['body']['id'],db[_0x4f8cdc('0x65')][_0x4f8cdc('0x26')]({'where':{'id':_0x2b9d9e[_0x4f8cdc('0x61')]['id']}})[_0x4f8cdc('0x62')](handleEntityNotFound(_0x290acf,null))[_0x4f8cdc('0x62')](saveUpdates(_0x2b9d9e[_0x4f8cdc('0x7')],null))[_0x4f8cdc('0x62')](respondWithResult(_0x290acf,null))[_0x4f8cdc('0x1c')](handleError(_0x290acf,null));},exports[_0x355343('0x20')]=function(_0x2241f7,_0x1aa268){const _0x3126da=_0x355343;return db['AnalyticDefaultReport'][_0x3126da('0x26')]({'where':{'id':_0x2241f7['params']['id']}})[_0x3126da('0x62')](handleEntityNotFound(_0x1aa268,null))['then'](removeEntity(_0x1aa268,null))[_0x3126da('0x1c')](handleError(_0x1aa268,null));},exports['preview']=function(_0x1790c2,_0x1ecd32){const _0x2f9388=_0x355343,_0x49fc62=0xa,_0x4cc830=['join',_0x2f9388('0x60'),_0x2f9388('0x7e'),_0x2f9388('0x23')],_0x7a135a={'SUM':_0x2f9388('0x87'),'COUNT':_0x2f9388('0x3a'),'COUNT\x20DISTINCT':_0x2f9388('0x3'),'MAX':_0x2f9388('0x6d'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':_0x2f9388('0x2'),'GROUP_CONCAT\x20DESC':_0x2f9388('0x39')},_0x251899={'SEC_TO_TIME':_0x2f9388('0xc'),'DATE':_0x2f9388('0x5a'),'HOUR':_0x2f9388('0x4f'),'ROUND':_0x2f9388('0x5d'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'},_0x456aba=function(_0x54392b){const _0x2d3150=_0x2f9388;return!_['includes'](['IS\x20NULL','IS\x20NOT\x20NULL',_0x2d3150('0x83'),_0x2d3150('0x67')],_0x54392b);},_0x3d49f1=function(_0x224cca){const _0xc8802c=_0x2f9388;if(!_0x224cca||!_0x224cca[_0xc8802c('0x51')][_0xc8802c('0x4b')])return'';let _0x4ec6a7='(';for(let _0x3bce02=0x0;_0x3bce02<_0x224cca[_0xc8802c('0x51')][_0xc8802c('0x4b')];_0x3bce02+=0x1){_0x3bce02>0x0&&(_0x4ec6a7+='\x20'+_0x224cca['operator']+'\x20'),_0x4ec6a7+=_0x224cca[_0xc8802c('0x51')][_0x3bce02][_0xc8802c('0xf')]?_0x3d49f1(_0x224cca[_0xc8802c('0x51')][_0x3bce02][_0xc8802c('0xf')]):_0x224cca[_0xc8802c('0x51')][_0x3bce02][_0xc8802c('0x47')]+'\x20'+_0x224cca[_0xc8802c('0x51')][_0x3bce02][_0xc8802c('0x84')]+(_0x456aba(_0x224cca[_0xc8802c('0x51')][_0x3bce02][_0xc8802c('0x84')])?'\x20'+_0x224cca['rules'][_0x3bce02][_0xc8802c('0x86')]:'');}return _0x4ec6a7+')';};let _0x55f8d3={'where':{'id':_0x1790c2['params']['id']}},_0xc8d08b,_0x35f737,_0x24bbdf;return _0x55f8d3=_[_0x2f9388('0x1d')]({},_0x55f8d3,_0x1790c2[_0x2f9388('0x85')]),db[_0x2f9388('0x65')][_0x2f9388('0x26')](_0x55f8d3)[_0x2f9388('0x62')](function(_0x3b37fb){const _0x5e44f0=_0x2f9388;if(_0x3b37fb)return _0xc8d08b=_0x3b37fb,_0x3b37fb[_0x5e44f0('0x7a')]();return null;})[_0x2f9388('0x62')](function(_0x5125a3){const _0x199563=_0x2f9388;if(_0x5125a3){if(!_0x5125a3[_0x199563('0x4b')])throw new ValidationErrorItem('Please\x20insert\x20at\x20least\x20one\x20field',0x193);return _0x35f737=_0x5125a3,db[_0x199563('0x56')][_0x199563('0x79')]({'raw':!![]});}return null;})['then'](function(_0x67621e){const _0x38fc22=_0x2f9388;if(_0x67621e){_0x24bbdf=_['keyBy'](_0x67621e,'id');let _0x108070;const _0x12a2cb=squel[_0x38fc22('0x70')]();_0x12a2cb[_0x38fc22('0x33')](_0xc8d08b[_0x38fc22('0x17')]);for(let _0x353eff=0x0;_0x353eff<_0x35f737[_0x38fc22('0x4b')];_0x353eff+=0x1){_0x108070=_0x35f737[_0x353eff][_0x38fc22('0x2e')]?_0x24bbdf[_0x35f737[_0x353eff]['MetricId']][_0x38fc22('0x22')]:_0x35f737[_0x353eff][_0x38fc22('0x47')],_0x108070=_0x35f737[_0x353eff][_0x38fc22('0x5c')]?_[_0x38fc22('0x3d')](_0x7a135a[_0x35f737[_0x353eff][_0x38fc22('0x5c')]],'%s',_0x108070):_0x108070,_0x108070=_0x35f737[_0x353eff][_0x38fc22('0x5f')]?_[_0x38fc22('0x3d')](_0x251899[_0x35f737[_0x353eff][_0x38fc22('0x5f')]],'%s',_0x108070):_0x108070,_0x35f737[_0x353eff][_0x38fc22('0x68')]&&_0x12a2cb['group'](_0x108070),_0x35f737[_0x353eff][_0x38fc22('0xd')]&&_0x12a2cb['order'](_0x108070,_0x35f737[_0x353eff][_0x38fc22('0xd')]===_0x38fc22('0x72')?![]:!![]),_0x12a2cb[_0x38fc22('0x47')](_0x108070,_0x35f737[_0x353eff][_0x38fc22('0x5b')]||_0x108070);}if(_0xc8d08b[_0x38fc22('0x30')]){_0xc8d08b[_0x38fc22('0x30')]=JSON[_0x38fc22('0x12')](_0xc8d08b[_0x38fc22('0x30')]);for(let _0x3a4e7e=0x0;_0x3a4e7e<_0xc8d08b[_0x38fc22('0x30')]['length'];_0x3a4e7e+=0x1){_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x19')]&&_[_0x38fc22('0x59')](_0x4cc830,_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e]['type'])&&_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e]['parentKey']&&_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x18')]&&_0xc8d08b['joins'][_0x3a4e7e][_0x38fc22('0x35')]&&_0x12a2cb[_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x19')]](_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x18')],null,util[_0x38fc22('0x5f')](_0x38fc22('0x16'),_0xc8d08b[_0x38fc22('0x17')],_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x7f')],_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x18')],_0xc8d08b[_0x38fc22('0x30')][_0x3a4e7e][_0x38fc22('0x35')]));}}return _0xc8d08b[_0x38fc22('0x78')]&&(_0xc8d08b[_0x38fc22('0x78')]=JSON[_0x38fc22('0x12')](_0xc8d08b[_0x38fc22('0x78')]),_0x12a2cb['where'](_0x3d49f1(_0xc8d08b['conditions'][_0x38fc22('0xf')]))),_0x12a2cb[_0x38fc22('0x2c')](_0x49fc62),_0x12a2cb['offset'](0x0),logger[_0x38fc22('0x31')]('Limited\x20Query:',_0x12a2cb[_0x38fc22('0x58')]()),db[_0x38fc22('0x76')][_0x38fc22('0x6f')](_0x12a2cb['toString'](),{'type':QueryTypes[_0x38fc22('0x54')]});}})[_0x2f9388('0x62')](respondWithResult(_0x1ecd32,null))[_0x2f9388('0x1c')](handleError(_0x1ecd32,null));};function runReport(_0xcab21f,_0x18fa21,_0x3a11d4){const _0xa19b8a=_0x355343,_0x494560=_0x18fa21['name'],_0x886074=0xa,_0x4f26ba=[_0xa19b8a('0x49'),_0xa19b8a('0x60'),'right_join','cross_join'],_0x2dedcf={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0xa19b8a('0x3'),'MAX':_0xa19b8a('0x6d'),'MIN':'MIN(%s)','AVG':_0xa19b8a('0x25'),'GROUP_CONCAT':_0xa19b8a('0x5e'),'GROUP_CONCAT\x20ASC':_0xa19b8a('0x2'),'GROUP_CONCAT\x20DESC':_0xa19b8a('0x39')},_0x3afc0f={'SEC_TO_TIME':_0xa19b8a('0xc'),'DATE':'DATE(%s)','HOUR':_0xa19b8a('0x4f'),'ROUND':_0xa19b8a('0x5d'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'},_0x1ffd59=function(_0x422eb4){const _0x5891d8=_0xa19b8a;return!_['includes'](['IS\x20NULL',_0x5891d8('0x15'),_0x5891d8('0x83'),_0x5891d8('0x67')],_0x422eb4);},_0x7ef72d=function(_0x1c797d){const _0x57de59=_0xa19b8a;if(!_0x1c797d||!_0x1c797d[_0x57de59('0x51')][_0x57de59('0x4b')])return'';let _0x206fc9='(';for(let _0x4ea0e6=0x0;_0x4ea0e6<_0x1c797d[_0x57de59('0x51')]['length'];_0x4ea0e6+=0x1){_0x4ea0e6>0x0&&(_0x206fc9+='\x20'+_0x1c797d[_0x57de59('0x66')]+'\x20'),_0x206fc9+=_0x1c797d[_0x57de59('0x51')][_0x4ea0e6][_0x57de59('0xf')]?_0x7ef72d(_0x1c797d[_0x57de59('0x51')][_0x4ea0e6][_0x57de59('0xf')]):_0x1c797d[_0x57de59('0x51')][_0x4ea0e6]['field']+'\x20'+_0x1c797d[_0x57de59('0x51')][_0x4ea0e6][_0x57de59('0x84')]+(_0x1ffd59(_0x1c797d[_0x57de59('0x51')][_0x4ea0e6][_0x57de59('0x84')])?'\x20'+_0x1c797d[_0x57de59('0x51')][_0x4ea0e6][_0x57de59('0x86')]:'');}return _0x206fc9+')';};let _0x2f559c={'where':{'id':_0xcab21f['id']}},_0x1ae5e5,_0x4e6972,_0x3d4024,_0x5b9bf8,_0x6efb87;return _0x2f559c=_[_0xa19b8a('0x1d')]({},_0x2f559c,_0x3a11d4),db[_0xa19b8a('0x65')][_0xa19b8a('0x26')](_0x2f559c)[_0xa19b8a('0x62')](function(_0x33939c){if(_0x33939c)return _0x1ae5e5=_0x33939c,_0x33939c['getFields']();return null;})[_0xa19b8a('0x62')](function(_0x22c964){const _0xe282be=_0xa19b8a;if(_0x22c964){if(!_0x22c964[_0xe282be('0x4b')])throw new ValidationErrorItem(_0xe282be('0x42'),0x193);return _0x4e6972=_0x22c964,db['AnalyticMetric'][_0xe282be('0x79')]({'raw':!![]});}return null;})[_0xa19b8a('0x62')](function(_0x2d26eb){const _0x50141b=_0xa19b8a;if(_0x2d26eb){_0x3d4024=_[_0x50141b('0x7d')](_0x2d26eb,'id');let _0x3daf5b;const _0x369cbd=squel['select']();_0x369cbd[_0x50141b('0x33')](_0x1ae5e5[_0x50141b('0x17')]);for(let _0x1c6d82=0x0;_0x1c6d82<_0x4e6972[_0x50141b('0x4b')];_0x1c6d82+=0x1){_0x3daf5b=_0x4e6972[_0x1c6d82][_0x50141b('0x2e')]?_0x3d4024[_0x4e6972[_0x1c6d82][_0x50141b('0x2e')]][_0x50141b('0x22')]:_0x4e6972[_0x1c6d82][_0x50141b('0x47')],_0x3daf5b=_0x4e6972[_0x1c6d82][_0x50141b('0x5c')]?_['replace'](_0x2dedcf[_0x4e6972[_0x1c6d82][_0x50141b('0x5c')]],'%s',_0x3daf5b):_0x3daf5b,_0x3daf5b=_0x4e6972[_0x1c6d82][_0x50141b('0x5f')]?_[_0x50141b('0x3d')](_0x3afc0f[_0x4e6972[_0x1c6d82][_0x50141b('0x5f')]],'%s',_0x3daf5b):_0x3daf5b,_0x4e6972[_0x1c6d82][_0x50141b('0x68')]&&_0x369cbd[_0x50141b('0xf')](_0x3daf5b),_0x4e6972[_0x1c6d82]['orderBy']&&_0x369cbd['order'](_0x3daf5b,_0x4e6972[_0x1c6d82]['orderBy']===_0x50141b('0x72')?![]:!![]),_0x369cbd[_0x50141b('0x47')](_0x3daf5b,_0x4e6972[_0x1c6d82][_0x50141b('0x5b')]||_0x3daf5b);}if(_0x1ae5e5[_0x50141b('0x30')]){_0x1ae5e5[_0x50141b('0x30')]=JSON[_0x50141b('0x12')](_0x1ae5e5[_0x50141b('0x30')]);for(let _0x31911f=0x0;_0x31911f<_0x1ae5e5[_0x50141b('0x30')][_0x50141b('0x4b')];_0x31911f+=0x1){_0x1ae5e5['joins'][_0x31911f][_0x50141b('0x19')]&&_['includes'](_0x4f26ba,_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x19')])&&_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x7f')]&&_0x1ae5e5['joins'][_0x31911f][_0x50141b('0x18')]&&_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x35')]&&_0x369cbd[_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x19')]](_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x18')],null,util[_0x50141b('0x5f')]('%s.%s\x20=\x20%s.%s',_0x1ae5e5[_0x50141b('0x17')],_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x7f')],_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x18')],_0x1ae5e5[_0x50141b('0x30')][_0x31911f][_0x50141b('0x35')]));}}return _0x1ae5e5[_0x50141b('0x78')]&&(_0x1ae5e5[_0x50141b('0x78')]=JSON[_0x50141b('0x12')](_0x1ae5e5[_0x50141b('0x78')]),_0x369cbd[_0x50141b('0xa')](_0x7ef72d(_0x1ae5e5[_0x50141b('0x78')][_0x50141b('0xf')]))),_0x6efb87=_0x369cbd[_0x50141b('0xe')](),_0x369cbd[_0x50141b('0x2c')](_0x886074),_0x369cbd[_0x50141b('0x2f')](0x0),logger[_0x50141b('0x31')]('Limited\x20Query:',_0x369cbd[_0x50141b('0x58')]()),db[_0x50141b('0x76')]['query'](_0x369cbd[_0x50141b('0x58')](),{'type':QueryTypes[_0x50141b('0x54')]});}})[_0xa19b8a('0x62')](function(_0xb3af16){const _0x4e3156=_0xa19b8a;if(!_0xb3af16[_0x4e3156('0x4b')])throw new ValidationErrorItem(_0x4e3156('0x44'),0xcc);if(_0x18fa21['output']===_0x4e3156('0x3b'))return null;const _0x319996=_['merge'](_0x18fa21,{'name':_0x18fa21[_0x4e3156('0x6a')]||_0x18fa21[_0x4e3156('0x4a')]||_0x1ae5e5[_0x4e3156('0x4a')],'basename':_0x494560,'savename':util[_0x4e3156('0x5f')]('%s-%s.%s',_0x18fa21[_0x4e3156('0x4a')]||_0x1ae5e5[_0x4e3156('0x4a')],require('randomstring')[_0x4e3156('0x1f')](0x4),_0x18fa21[_0x4e3156('0x28')]||_0x4e3156('0x6c')),'reportId':_0x1ae5e5['id'],'reportType':_0x4e3156('0x45')});return db[_0x4e3156('0x3c')][_0x4e3156('0x71')](_0x319996,{'raw':!![]});})[_0xa19b8a('0x62')](function(_0x4e6cdc){const _0x34cee6=_0xa19b8a;_0x1ae5e5[_0x34cee6('0x17')]==='cdr'?_0x6efb87[_0x34cee6('0xa')](_0x1ae5e5[_0x34cee6('0x17')]+_0x34cee6('0x3f'),_0x18fa21[_0x34cee6('0x41')],_0x18fa21[_0x34cee6('0x1a')]):_0x6efb87['where'](_0x1ae5e5['table']+_0x34cee6('0x27'),_0x18fa21[_0x34cee6('0x41')],_0x18fa21[_0x34cee6('0x1a')]);if(_0x4e6cdc)return logger[_0x34cee6('0x1e')](_0x34cee6('0x75'),_0x6efb87['toString']()),require('child_process')['fork'](path[_0x34cee6('0x49')](__dirname,'../../components/export/',_0x4e6cdc['output']),[_0x4e6cdc['id'],_0x6efb87[_0x34cee6('0x58')](),path[_0x34cee6('0x49')](__dirname,_0x34cee6('0x53'),_0x4e6cdc[_0x34cee6('0x81')]),_0x494560]),_0x4e6cdc;else{const _0x2ed215=squel['select']();return _0x2ed215['from']('('+_0x6efb87[_0x34cee6('0x58')]()+')',_0x34cee6('0x29')),_0x2ed215[_0x34cee6('0x47')](_0x34cee6('0x50'),_0x34cee6('0x2b')),_0x6efb87[_0x34cee6('0x2c')](_0x18fa21[_0x34cee6('0x2c')]||_0x886074),_0x6efb87[_0x34cee6('0x2f')](_0x18fa21[_0x34cee6('0x2f')]||0x0),dbH['sequelize']['query'](_0x2ed215[_0x34cee6('0x58')](),{'type':dbH[_0x34cee6('0x76')][_0x34cee6('0xb')]['SELECT']})[_0x34cee6('0x62')](function(_0x5cf1d6){const _0x1bc21d=_0x34cee6;return!_0x5cf1d6[_0x1bc21d('0x4b')]?_0x5b9bf8=0x0:_0x5b9bf8=_0x5cf1d6[0x0][_0x1bc21d('0x2b')]||0x0,dbH['sequelize'][_0x1bc21d('0x6f')](_0x6efb87['toString'](),{'type':dbH[_0x1bc21d('0x76')][_0x1bc21d('0xb')]['SELECT']});})[_0x34cee6('0x62')](function(_0x523f1c){return{'rows':_0x523f1c||[],'count':_0x5b9bf8};});}});}exports[_0x355343('0x7c')]=function(_0x262aac,_0x571f27){const _0x223471=_0x355343;return runReport(_0x262aac[_0x223471('0x61')],_0x262aac[_0x223471('0x6f')],_0x262aac[_0x223471('0x85')])[_0x223471('0x62')](respondWithResult(_0x571f27,null))[_0x223471('0x1c')](handleError(_0x571f27,null));},exports['runReport']=runReport,exports['query']=function(_0x30f761,_0x3bc7ff){const _0x35cdd3=_0x355343,_0x548e49=0xa,_0x439d65=['join',_0x35cdd3('0x60'),_0x35cdd3('0x7e'),_0x35cdd3('0x23')],_0x53494e={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT\x20DISTINCT':_0x35cdd3('0x3'),'MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0x35cdd3('0x5e'),'GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0x35cdd3('0x39')},_0xacfbdc={'SEC_TO_TIME':_0x35cdd3('0xc'),'DATE':_0x35cdd3('0x5a'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x35cdd3('0x1b')},_0x8f24f0=function(_0x4fb304){const _0x24b5c9=_0x35cdd3;return!_[_0x24b5c9('0x59')]([_0x24b5c9('0x0'),_0x24b5c9('0x15'),_0x24b5c9('0x83'),_0x24b5c9('0x67')],_0x4fb304);},_0x1e3635=function(_0x28fcd4){const _0x1248b5=_0x35cdd3;if(!_0x28fcd4||!_0x28fcd4['rules'][_0x1248b5('0x4b')])return'';let _0xa2d06f='(';for(let _0x393036=0x0;_0x393036<_0x28fcd4['rules'][_0x1248b5('0x4b')];_0x393036+=0x1){_0x393036>0x0&&(_0xa2d06f+='\x20'+_0x28fcd4[_0x1248b5('0x66')]+'\x20'),_0xa2d06f+=_0x28fcd4[_0x1248b5('0x51')][_0x393036]['group']?_0x1e3635(_0x28fcd4['rules'][_0x393036][_0x1248b5('0xf')]):_0x28fcd4[_0x1248b5('0x51')][_0x393036][_0x1248b5('0x47')]+'\x20'+_0x28fcd4[_0x1248b5('0x51')][_0x393036][_0x1248b5('0x84')]+(_0x8f24f0(_0x28fcd4[_0x1248b5('0x51')][_0x393036]['condition'])?'\x20'+_0x28fcd4[_0x1248b5('0x51')][_0x393036][_0x1248b5('0x86')]:'');}return _0xa2d06f+')';};let _0x450e5c={'where':{'id':_0x30f761['params']['id']}},_0x1e2a22,_0x5245c4,_0x271418,_0x45a834;return _0x450e5c=_[_0x35cdd3('0x1d')]({},_0x450e5c,_0x30f761['options']),db['AnalyticDefaultReport'][_0x35cdd3('0x26')](_0x450e5c)['then'](function(_0x491ebf){const _0x548edd=_0x35cdd3;if(_0x491ebf)return _0x1e2a22=_0x491ebf,_0x491ebf[_0x548edd('0x7a')]();return null;})[_0x35cdd3('0x62')](function(_0x117439){const _0x599a94=_0x35cdd3;if(_0x117439){if(!_0x117439[_0x599a94('0x4b')])throw new ValidationErrorItem(_0x599a94('0x42'),0x193);return _0x5245c4=_0x117439,db['AnalyticMetric'][_0x599a94('0x79')]({'raw':!![]});}return null;})[_0x35cdd3('0x62')](function(_0x5dc9d2){const _0x487a0c=_0x35cdd3;if(_0x5dc9d2){_0x271418=_['keyBy'](_0x5dc9d2,'id');let _0xdc37ab;const _0x2fe958=squel[_0x487a0c('0x70')]();_0x2fe958[_0x487a0c('0x33')](_0x1e2a22[_0x487a0c('0x17')]);for(let _0x3931c3=0x0;_0x3931c3<_0x5245c4['length'];_0x3931c3+=0x1){_0xdc37ab=_0x5245c4[_0x3931c3][_0x487a0c('0x2e')]?_0x271418[_0x5245c4[_0x3931c3][_0x487a0c('0x2e')]][_0x487a0c('0x22')]:_0x5245c4[_0x3931c3][_0x487a0c('0x47')],_0xdc37ab=_0x5245c4[_0x3931c3][_0x487a0c('0x5c')]?_['replace'](_0x53494e[_0x5245c4[_0x3931c3][_0x487a0c('0x5c')]],'%s',_0xdc37ab):_0xdc37ab,_0xdc37ab=_0x5245c4[_0x3931c3][_0x487a0c('0x5f')]?_[_0x487a0c('0x3d')](_0xacfbdc[_0x5245c4[_0x3931c3][_0x487a0c('0x5f')]],'%s',_0xdc37ab):_0xdc37ab,_0x5245c4[_0x3931c3][_0x487a0c('0x68')]&&_0x2fe958['group'](_0xdc37ab),_0x5245c4[_0x3931c3]['orderBy']&&_0x2fe958[_0x487a0c('0x13')](_0xdc37ab,_0x5245c4[_0x3931c3][_0x487a0c('0xd')]===_0x487a0c('0x72')?![]:!![]),_0x2fe958[_0x487a0c('0x47')](_0xdc37ab,_0x5245c4[_0x3931c3][_0x487a0c('0x5b')]||_0xdc37ab);}if(_0x1e2a22['joins']){_0x1e2a22[_0x487a0c('0x30')]=JSON[_0x487a0c('0x12')](_0x1e2a22[_0x487a0c('0x30')]);for(let _0x209f33=0x0;_0x209f33<_0x1e2a22['joins'][_0x487a0c('0x4b')];_0x209f33+=0x1){_0x1e2a22[_0x487a0c('0x30')][_0x209f33]['type']&&_[_0x487a0c('0x59')](_0x439d65,_0x1e2a22[_0x487a0c('0x30')][_0x209f33][_0x487a0c('0x19')])&&_0x1e2a22[_0x487a0c('0x30')][_0x209f33]['parentKey']&&_0x1e2a22['joins'][_0x209f33][_0x487a0c('0x18')]&&_0x1e2a22[_0x487a0c('0x30')][_0x209f33][_0x487a0c('0x35')]&&_0x2fe958[_0x1e2a22['joins'][_0x209f33][_0x487a0c('0x19')]](_0x1e2a22[_0x487a0c('0x30')][_0x209f33][_0x487a0c('0x18')],null,util[_0x487a0c('0x5f')](_0x487a0c('0x16'),_0x1e2a22[_0x487a0c('0x17')],_0x1e2a22[_0x487a0c('0x30')][_0x209f33][_0x487a0c('0x7f')],_0x1e2a22['joins'][_0x209f33][_0x487a0c('0x18')],_0x1e2a22['joins'][_0x209f33][_0x487a0c('0x35')]));}}return _0x1e2a22[_0x487a0c('0x78')]&&(_0x1e2a22[_0x487a0c('0x78')]=JSON[_0x487a0c('0x12')](_0x1e2a22[_0x487a0c('0x78')]),_0x2fe958[_0x487a0c('0xa')](_0x1e3635(_0x1e2a22['conditions']['group']))),_0x45a834=_0x2fe958[_0x487a0c('0xe')](),_0x2fe958[_0x487a0c('0x2c')](_0x548e49),_0x2fe958[_0x487a0c('0x2f')](0x0),logger[_0x487a0c('0x31')](_0x487a0c('0x6b'),_0x2fe958[_0x487a0c('0x58')]()),db[_0x487a0c('0x76')]['query'](_0x2fe958[_0x487a0c('0x58')](),{'type':QueryTypes['SELECT']});}})['then'](function(){return{'sql':_0x45a834['toString']()};})[_0x35cdd3('0x62')](respondWithResult(_0x3bc7ff,null))[_0x35cdd3('0x1c')](handleError(_0x3bc7ff,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff