1 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));};
git://repos.xcallymotion.com / motion-next.git / blob