1 const a5_0x48e4=['.calldate\x20BETWEEN\x20?\x20AND\x20?','VIRTUAL','SEC_TO_TIME(%s)','alias','limit','then','output','No\x20available\x20data','rules','../../files/reports','autoAssociation','debug','error','joins','UserProfileResource','keys','includes','api','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','destroy','groupBy','DATE(%s)','fieldName','GROUP_CONCAT(%s)','join','where','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','clone','fullPath','cross_join','stack','Limited\x20Query:','IS\x20NULL','count','type','IS\x20NOT\x20NULL','MIN(%s)','countTable','endDate','catch','startDate','COUNT(%s)','runReport','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','offset','function','undefined','format','sendStatus','Unable\x20to\x20retrieve\x20the\x20current\x20user','MAX(%s)','left_join','filter','findOne','condition','toString','Content-Range','create','path','options','foreignKey','getFields','sort','rawAttributes','query','key','cdr','map','name','params','update','AVG(%s)','replace','AnalyticMetric','Reports','order','info','right_join','preview','index','from','get','SUM(%s)','keyBy','QueryTypes','%s-%s.%s','parentKey','intersection','util','like','AnalyticCustomReport','operator','run','fork','attributes','IS\x20NOT\x20EMPTY','value','userProfileId','../../mysqldb','length','conditions','sequelize','model','filters','ROUND(%s)','generate','IS\x20EMPTY','role','end','SELECT','metric','savename','orderBy','lodash','custom','field','table','body','merge','../../components/parsers/qs','parse','status','foreignTable','pick','select','dbH','web','user','COUNT(DISTINCT\x20%s)','include','fields','HOUR(%s)','UNIX_TIMESTAMP(%s)','findAll','%s.%s\x20=\x20%s.%s','CustomReports','nolimit','DESC','group','MetricId','Please\x20insert\x20at\x20least\x20one\x20field'];(function(_0x2be0ad,_0x48e462){const _0x46236c=function(_0x27b3bd){while(--_0x27b3bd){_0x2be0ad['push'](_0x2be0ad['shift']());}};_0x46236c(++_0x48e462);}(a5_0x48e4,0x7f));const a5_0x4623=function(_0x2be0ad,_0x48e462){_0x2be0ad=_0x2be0ad-0x0;let _0x46236c=a5_0x48e4[_0x2be0ad];return _0x46236c;};const _0x3994b9=a5_0x4623;'use strict';const util=require(_0x3994b9('0x66')),path=require(_0x3994b9('0x48')),_=require(_0x3994b9('0x7f')),squel=require('squel'),qs=require(_0x3994b9('0x85')),logger=require('../../config/logger')(_0x3994b9('0x1f')),db=require(_0x3994b9('0x70'))['db'],dbH=require('../../mysqldb')[_0x3994b9('0x8b')],{Op,ValidationErrorItem,QueryTypes}=require('sequelize');function respondWithResult(_0x27b3bd,_0x9107b2){return _0x9107b2=_0x9107b2||0xc8,function(_0x813dfd){const _0xf3932d=a5_0x4623;if(_0x813dfd)return _0x27b3bd[_0xf3932d('0x87')](_0x9107b2)['json'](_0x813dfd);};}function respondWithFilteredResult(_0x55078a,_0x16de1a){return function(_0x519626){const _0x13c846=a5_0x4623;if(_0x519626){const _0xe60c73=_0x519626[_0x13c846('0x2f')],_0x457631=_0x16de1a[_0x13c846('0x3a')];let _0x1944f0=_0x16de1a[_0x13c846('0x3a')]+_0x16de1a[_0x13c846('0x12')],_0x41b8c8;return _0x1944f0>=_0xe60c73?(_0x1944f0=_0xe60c73,_0x41b8c8=0xc8):_0x41b8c8=0xce,_0x55078a['status'](_0x41b8c8),_0x55078a['set'](_0x13c846('0x46'),_0x457631+'-'+_0x1944f0+'/'+_0xe60c73)['json'](_0x519626);}return null;};}function saveUpdates(_0x13a7a7){return function(_0x4c8cb2){const _0x39a43f=a5_0x4623;if(_0x4c8cb2)return _0x4c8cb2[_0x39a43f('0x54')](_0x13a7a7)[_0x39a43f('0x13')](function(_0x45f88c){return _0x45f88c;});return null;};}function removeEntity(_0x537321){return function(_0x3c7a29){const _0x2ed0d9=a5_0x4623;if(_0x3c7a29)return _0x3c7a29[_0x2ed0d9('0x21')]()['then'](function(){const _0x57ee19=_0x2ed0d9,_0x1c2f9d=_0x3c7a29['get']({'plain':!![]}),_0x4937e0=_0x57ee19('0x8');return db[_0x57ee19('0x1c')][_0x57ee19('0x21')]({'where':{'type':_0x4937e0,'resourceId':_0x1c2f9d['id']}})[_0x57ee19('0x13')](function(){return _0x3c7a29;});})[_0x2ed0d9('0x13')](function(){const _0x2cf199=_0x2ed0d9;_0x537321[_0x2cf199('0x87')](0xcc)[_0x2cf199('0x7a')]();});};}function handleEntityNotFound(_0x4dcff7){return function(_0x3b00b8){const _0x2762e1=a5_0x4623;return!_0x3b00b8&&_0x4dcff7[_0x2762e1('0x3e')](0x194),_0x3b00b8;};}function handleError(_0x1686b4,_0x2bfb76){return _0x2bfb76=_0x2bfb76||0x1f4,function(_0x5851cb){const _0x33ea22=a5_0x4623;logger[_0x33ea22('0x1a')](_0x5851cb[_0x33ea22('0x2c')]),_0x5851cb[_0x33ea22('0x52')]&&delete _0x5851cb[_0x33ea22('0x52')],_0x1686b4[_0x33ea22('0x87')](_0x2bfb76)['send'](_0x5851cb);};}exports[_0x3994b9('0x5d')]=function(_0x599d32,_0x478970){const _0x396471=_0x3994b9;let _0x2831be={};const _0x57209e={},_0x3aa2b2={'count':0x0,'rows':[]},_0x4caf6e=_[_0x396471('0x51')](db['AnalyticCustomReport'][_0x396471('0x4d')],function(_0x368f22){const _0x312348=_0x396471;return{'name':_0x368f22[_0x312348('0x24')],'type':_0x368f22[_0x312348('0x30')][_0x312348('0x4f')]};});_0x57209e[_0x396471('0x74')]=_[_0x396471('0x51')](_0x4caf6e,_0x396471('0x52')),_0x57209e[_0x396471('0x4e')]=_[_0x396471('0x1d')](_0x599d32['query']),_0x57209e[_0x396471('0x75')]=_[_0x396471('0x65')](_0x57209e[_0x396471('0x74')],_0x57209e[_0x396471('0x4e')]),_0x2831be[_0x396471('0x6c')]=_[_0x396471('0x65')](_0x57209e['model'],qs[_0x396471('0x3')](_0x599d32['query']['fields'])),_0x2831be[_0x396471('0x6c')]=_0x2831be[_0x396471('0x6c')][_0x396471('0x71')]?_0x2831be[_0x396471('0x6c')]:_0x57209e[_0x396471('0x74')];typeof _0x599d32[_0x396471('0x4e')][_0x396471('0x9')]===_0x396471('0x3c')&&(_0x2831be['limit']=qs[_0x396471('0x12')](_0x599d32['query'][_0x396471('0x12')]),_0x2831be[_0x396471('0x3a')]=qs['offset'](_0x599d32[_0x396471('0x4e')][_0x396471('0x3a')]));_0x2831be[_0x396471('0x59')]=qs[_0x396471('0x4c')](_0x599d32[_0x396471('0x4e')]['sort']),_0x2831be[_0x396471('0x27')]=qs['filters'](_[_0x396471('0x89')](_0x599d32[_0x396471('0x4e')],_0x57209e[_0x396471('0x75')]),_0x4caf6e);_0x599d32[_0x396471('0x4e')][_0x396471('0x42')]&&(_0x2831be[_0x396471('0x27')]=_[_0x396471('0x84')](_0x2831be[_0x396471('0x27')],{[Op['or']]:_[_0x396471('0x51')](_0x4caf6e,function(_0x58565d){const _0x6e904c=_0x396471;if(_0x58565d[_0x6e904c('0x30')]!==_0x6e904c('0xf')){const _0x20861d={};return _0x20861d[_0x58565d['name']]={[Op[_0x6e904c('0x67')]]:'%'+_0x599d32[_0x6e904c('0x4e')]['filter']+'%'},_0x20861d;}})}));_0x2831be=_[_0x396471('0x84')]({},_0x2831be,_0x599d32['options']);const _0x2cc485={'where':_0x2831be[_0x396471('0x27')]};return db[_0x396471('0x68')][_0x396471('0x2f')](_0x2cc485)['then'](function(_0x4c7bc3){const _0x53f11c=_0x396471;return _0x3aa2b2[_0x53f11c('0x2f')]=_0x4c7bc3,_0x599d32['query']['includeAll']&&(_0x2831be[_0x53f11c('0x2')]=[{'all':!![]}]),db['AnalyticCustomReport'][_0x53f11c('0x6')](_0x2831be);})['then'](function(_0x1f6dd9){return _0x3aa2b2['rows']=_0x1f6dd9,_0x3aa2b2;})[_0x396471('0x13')](respondWithFilteredResult(_0x478970,_0x2831be))[_0x396471('0x35')](handleError(_0x478970,null));},exports['show']=function(_0x1dc6ef,_0x5759a9){const _0x4a9097=_0x3994b9;let _0x213862={'raw':![],'where':{'id':_0x1dc6ef[_0x4a9097('0x53')]['id']}};const _0x4f3c5c={};return _0x4f3c5c[_0x4a9097('0x74')]=_[_0x4a9097('0x1d')](db['AnalyticCustomReport'][_0x4a9097('0x4d')]),_0x4f3c5c[_0x4a9097('0x4e')]=_[_0x4a9097('0x1d')](_0x1dc6ef[_0x4a9097('0x4e')]),_0x4f3c5c[_0x4a9097('0x75')]=_['intersection'](_0x4f3c5c[_0x4a9097('0x74')],_0x4f3c5c[_0x4a9097('0x4e')]),_0x213862[_0x4a9097('0x6c')]=_['intersection'](_0x4f3c5c[_0x4a9097('0x74')],qs[_0x4a9097('0x3')](_0x1dc6ef[_0x4a9097('0x4e')][_0x4a9097('0x3')])),_0x213862['attributes']=_0x213862['attributes'][_0x4a9097('0x71')]?_0x213862['attributes']:_0x4f3c5c[_0x4a9097('0x74')],_0x1dc6ef[_0x4a9097('0x4e')]['includeAll']&&(_0x213862['include']=[{'all':!![]}]),_0x213862=_['merge']({},_0x213862,_0x1dc6ef['options']),db[_0x4a9097('0x68')][_0x4a9097('0x43')](_0x213862)['then'](handleEntityNotFound(_0x5759a9,null))[_0x4a9097('0x13')](respondWithResult(_0x5759a9,null))[_0x4a9097('0x35')](handleError(_0x5759a9,null));},exports[_0x3994b9('0x47')]=function(_0xc5399,_0x227fb1){const _0x4f8e89=_0x3994b9;return db[_0x4f8e89('0x68')][_0x4f8e89('0x47')](_0xc5399[_0x4f8e89('0x83')],{})[_0x4f8e89('0x13')](function(_0x4aab60){const _0x57e686=_0x4f8e89,_0xdfdbca=_0xc5399[_0x57e686('0x0')][_0x57e686('0x5f')]({'plain':!![]});if(!_0xdfdbca)throw new Error(_0x57e686('0x3f'));if(_0xdfdbca[_0x57e686('0x79')]===_0x57e686('0x0')){const _0xa6d9dd=_0x4aab60[_0x57e686('0x5f')]({'plain':!![]}),_0x4c7e26=_0x57e686('0x58');return db['UserProfileSection']['findOne']({'where':{'name':_0x4c7e26,'userProfileId':_0xdfdbca[_0x57e686('0x6f')]},'raw':!![]})[_0x57e686('0x13')](function(_0x55072d){const _0x39407b=_0x57e686;return _0x55072d&&_0x55072d[_0x39407b('0x18')]===0x0?db[_0x39407b('0x1c')][_0x39407b('0x47')]({'name':_0xa6d9dd[_0x39407b('0x52')],'resourceId':_0xa6d9dd['id'],'type':_0x39407b('0x8'),'sectionId':_0x55072d['id']},{})[_0x39407b('0x13')](function(){return _0x4aab60;}):_0x4aab60;})[_0x57e686('0x35')](function(_0x5d94fb){const _0x342508=_0x57e686;logger[_0x342508('0x1a')](_0x342508('0x20'),_0x5d94fb);throw _0x5d94fb;});}return _0x4aab60;})[_0x4f8e89('0x13')](respondWithResult(_0x227fb1,0xc9))['catch'](handleError(_0x227fb1,null));},exports['update']=function(_0x1932b8,_0x4dd732){const _0x4ec623=_0x3994b9;return _0x1932b8[_0x4ec623('0x83')]['id']&&delete _0x1932b8[_0x4ec623('0x83')]['id'],db['AnalyticCustomReport']['findOne']({'where':{'id':_0x1932b8['params']['id']}})[_0x4ec623('0x13')](handleEntityNotFound(_0x4dd732,null))[_0x4ec623('0x13')](saveUpdates(_0x1932b8[_0x4ec623('0x83')],null))[_0x4ec623('0x13')](respondWithResult(_0x4dd732,null))['catch'](handleError(_0x4dd732,null));},exports['destroy']=function(_0x41eeae,_0x389f13){const _0x353ccb=_0x3994b9;return db[_0x353ccb('0x68')][_0x353ccb('0x43')]({'where':{'id':_0x41eeae[_0x353ccb('0x53')]['id']}})[_0x353ccb('0x13')](handleEntityNotFound(_0x389f13,null))[_0x353ccb('0x13')](removeEntity(_0x389f13,null))['catch'](handleError(_0x389f13,null));},exports[_0x3994b9('0x5c')]=function(_0x3abcce,_0x4c14ce){const _0x1a284a=_0x3994b9,_0x4eea70=0xa,_0x5d67c8=['join',_0x1a284a('0x41'),_0x1a284a('0x5b'),_0x1a284a('0x2b')],_0x4cc176={'SUM':_0x1a284a('0x60'),'COUNT':_0x1a284a('0x37'),'COUNT\x20DISTINCT':_0x1a284a('0x1'),'MAX':_0x1a284a('0x40'),'MIN':'MIN(%s)','AVG':_0x1a284a('0x55'),'GROUP_CONCAT':_0x1a284a('0x25'),'GROUP_CONCAT\x20ASC':_0x1a284a('0x28'),'GROUP_CONCAT\x20DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'},_0x1d7403={'SEC_TO_TIME':_0x1a284a('0x10'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x1a284a('0x76'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'},_0x2ee54b=function(_0x2cbdd5){const _0xd485f7=_0x1a284a;return!_[_0xd485f7('0x1e')]([_0xd485f7('0x2e'),_0xd485f7('0x31'),_0xd485f7('0x78'),_0xd485f7('0x6d')],_0x2cbdd5);},_0x5ce5eb=function(_0x46f54a){const _0x2222b4=_0x1a284a;if(!_0x46f54a||!_0x46f54a[_0x2222b4('0x16')][_0x2222b4('0x71')])return'';let _0x282cd5='(';for(let _0x500bf3=0x0;_0x500bf3<_0x46f54a[_0x2222b4('0x16')]['length'];_0x500bf3+=0x1){_0x500bf3>0x0&&(_0x282cd5+='\x20'+_0x46f54a['operator']+'\x20'),_0x282cd5+=_0x46f54a[_0x2222b4('0x16')][_0x500bf3][_0x2222b4('0xb')]?_0x5ce5eb(_0x46f54a[_0x2222b4('0x16')][_0x500bf3][_0x2222b4('0xb')]):_0x46f54a[_0x2222b4('0x16')][_0x500bf3][_0x2222b4('0x81')]+'\x20'+_0x46f54a[_0x2222b4('0x16')][_0x500bf3][_0x2222b4('0x44')]+(_0x2ee54b(_0x46f54a[_0x2222b4('0x16')][_0x500bf3][_0x2222b4('0x44')])?'\x20'+_0x46f54a['rules'][_0x500bf3][_0x2222b4('0x6e')]:'');}return _0x282cd5+')';};let _0x26ca55={'where':{'id':_0x3abcce['params']['id']}},_0x1697ec,_0x8273d4,_0x54a523;return _0x26ca55=_['merge']({},_0x26ca55,_0x3abcce['options']),db['AnalyticCustomReport']['findOne'](_0x26ca55)['then'](function(_0x4635a9){const _0x1bb718=_0x1a284a;if(_0x4635a9)return _0x1697ec=_0x4635a9,_0x4635a9[_0x1bb718('0x4b')]();return null;})[_0x1a284a('0x13')](function(_0x101c73){const _0x416fb0=_0x1a284a;if(_0x101c73){if(!_0x101c73[_0x416fb0('0x71')])throw new ValidationErrorItem(_0x416fb0('0xd'),0x193);return _0x8273d4=_0x101c73,db[_0x416fb0('0x57')][_0x416fb0('0x6')]({'raw':!![]});}return null;})['then'](function(_0xf8b90){const _0x15f02e=_0x1a284a;if(_0xf8b90){_0x54a523=_[_0x15f02e('0x61')](_0xf8b90,'id');let _0x589df1;const _0x1ea675=squel[_0x15f02e('0x8a')]();_0x1ea675[_0x15f02e('0x5e')](_0x1697ec['table']);for(let _0x1db185=0x0;_0x1db185<_0x8273d4[_0x15f02e('0x71')];_0x1db185+=0x1){_0x589df1=_0x8273d4[_0x1db185]['MetricId']?_0x54a523[_0x8273d4[_0x1db185][_0x15f02e('0xc')]][_0x15f02e('0x7c')]:_0x8273d4[_0x1db185][_0x15f02e('0x81')],_0x589df1=_0x8273d4[_0x1db185][_0x15f02e('0x3b')]?_[_0x15f02e('0x56')](_0x4cc176[_0x8273d4[_0x1db185]['function']],'%s',_0x589df1):_0x589df1,_0x589df1=_0x8273d4[_0x1db185][_0x15f02e('0x3d')]?_[_0x15f02e('0x56')](_0x1d7403[_0x8273d4[_0x1db185]['format']],'%s',_0x589df1):_0x589df1,_0x8273d4[_0x1db185][_0x15f02e('0x22')]&&_0x1ea675[_0x15f02e('0xb')](_0x589df1),_0x8273d4[_0x1db185][_0x15f02e('0x7e')]&&_0x1ea675[_0x15f02e('0x59')](_0x589df1,_0x8273d4[_0x1db185]['orderBy']===_0x15f02e('0xa')?![]:!![]),_0x1ea675[_0x15f02e('0x81')](_0x589df1,_0x8273d4[_0x1db185][_0x15f02e('0x11')]||_0x589df1);}if(_0x1697ec[_0x15f02e('0x1b')]){_0x1697ec['joins']=JSON[_0x15f02e('0x86')](_0x1697ec[_0x15f02e('0x1b')]);for(let _0x1b3c83=0x0;_0x1b3c83<_0x1697ec[_0x15f02e('0x1b')][_0x15f02e('0x71')];_0x1b3c83+=0x1){_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83][_0x15f02e('0x30')]&&_[_0x15f02e('0x1e')](_0x5d67c8,_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83][_0x15f02e('0x30')])&&_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83][_0x15f02e('0x64')]&&_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83]['foreignTable']&&_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83][_0x15f02e('0x4a')]&&_0x1ea675[_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83][_0x15f02e('0x30')]](_0x1697ec['joins'][_0x1b3c83][_0x15f02e('0x88')],null,util[_0x15f02e('0x3d')](_0x15f02e('0x7'),_0x1697ec['table'],_0x1697ec[_0x15f02e('0x1b')][_0x1b3c83]['parentKey'],_0x1697ec['joins'][_0x1b3c83]['foreignTable'],_0x1697ec['joins'][_0x1b3c83]['foreignKey']));}}return _0x1697ec['conditions']&&(_0x1697ec[_0x15f02e('0x72')]=JSON[_0x15f02e('0x86')](_0x1697ec[_0x15f02e('0x72')]),_0x1ea675[_0x15f02e('0x27')](_0x5ce5eb(_0x1697ec[_0x15f02e('0x72')][_0x15f02e('0xb')]))),_0x1ea675[_0x15f02e('0x12')](_0x4eea70),_0x1ea675[_0x15f02e('0x3a')](0x0),logger[_0x15f02e('0x19')]('Limited\x20Query:',_0x1ea675['toString']()),db[_0x15f02e('0x73')][_0x15f02e('0x4e')](_0x1ea675[_0x15f02e('0x45')](),{'type':QueryTypes[_0x15f02e('0x7b')]});}})['then'](respondWithResult(_0x4c14ce,null))['catch'](handleError(_0x4c14ce,null));};function runReport(_0x1b3321,_0x44387a,_0x33b874){const _0x25fc98=_0x3994b9,_0x21502c=_0x44387a[_0x25fc98('0x52')],_0x59cd19=0xa,_0x47b15b=[_0x25fc98('0x26'),'left_join','right_join',_0x25fc98('0x2b')],_0x3cc793={'SUM':_0x25fc98('0x60'),'COUNT':_0x25fc98('0x37'),'COUNT\x20DISTINCT':_0x25fc98('0x1'),'MAX':_0x25fc98('0x40'),'MIN':_0x25fc98('0x32'),'AVG':_0x25fc98('0x55'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0x25fc98('0x39')},_0x4b1f06={'SEC_TO_TIME':_0x25fc98('0x10'),'DATE':_0x25fc98('0x23'),'HOUR':_0x25fc98('0x4'),'ROUND':_0x25fc98('0x76'),'UNIX_TIMESTAMP':_0x25fc98('0x5')},_0x346913=function(_0x4bb35b){const _0xd5a10=_0x25fc98;return!_[_0xd5a10('0x1e')]([_0xd5a10('0x2e'),_0xd5a10('0x31'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x4bb35b);},_0x438759=function(_0x2dc6d3){const _0xa4257d=_0x25fc98;if(!_0x2dc6d3||!_0x2dc6d3[_0xa4257d('0x16')][_0xa4257d('0x71')])return'';let _0x335db8='(';for(let _0x44114f=0x0;_0x44114f<_0x2dc6d3[_0xa4257d('0x16')]['length'];_0x44114f+=0x1){_0x44114f>0x0&&(_0x335db8+='\x20'+_0x2dc6d3[_0xa4257d('0x69')]+'\x20'),_0x335db8+=_0x2dc6d3[_0xa4257d('0x16')][_0x44114f]['group']?_0x438759(_0x2dc6d3['rules'][_0x44114f][_0xa4257d('0xb')]):_0x2dc6d3[_0xa4257d('0x16')][_0x44114f][_0xa4257d('0x81')]+'\x20'+_0x2dc6d3[_0xa4257d('0x16')][_0x44114f][_0xa4257d('0x44')]+(_0x346913(_0x2dc6d3[_0xa4257d('0x16')][_0x44114f]['condition'])?'\x20'+_0x2dc6d3[_0xa4257d('0x16')][_0x44114f]['value']:'');}return _0x335db8+')';};let _0xc4e83a={'where':{'id':_0x1b3321['id']}},_0x20a3cf,_0x4b8d74,_0x225576,_0x586a2c,_0x2d82c7;return _0xc4e83a=_[_0x25fc98('0x84')]({},_0xc4e83a,_0x33b874),db[_0x25fc98('0x68')][_0x25fc98('0x43')](_0xc4e83a)[_0x25fc98('0x13')](function(_0x3eb9d4){if(_0x3eb9d4)return _0x20a3cf=_0x3eb9d4,_0x3eb9d4['getFields']();return null;})[_0x25fc98('0x13')](function(_0x2d5e36){const _0x20bfb8=_0x25fc98;if(_0x2d5e36){if(!_0x2d5e36[_0x20bfb8('0x71')])throw new ValidationErrorItem(_0x20bfb8('0xd'),0x193);return _0x4b8d74=_0x2d5e36,db[_0x20bfb8('0x57')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x286533){const _0x27ca90=_0x25fc98;if(_0x286533){_0x225576=_['keyBy'](_0x286533,'id');let _0x581428;const _0x46ab3c=squel[_0x27ca90('0x8a')]();_0x46ab3c['from'](_0x20a3cf['table']);for(let _0x2826b3=0x0;_0x2826b3<_0x4b8d74[_0x27ca90('0x71')];_0x2826b3+=0x1){_0x581428=_0x4b8d74[_0x2826b3][_0x27ca90('0xc')]?_0x225576[_0x4b8d74[_0x2826b3]['MetricId']]['metric']:_0x4b8d74[_0x2826b3][_0x27ca90('0x81')],_0x581428=_0x4b8d74[_0x2826b3][_0x27ca90('0x3b')]?_['replace'](_0x3cc793[_0x4b8d74[_0x2826b3][_0x27ca90('0x3b')]],'%s',_0x581428):_0x581428,_0x581428=_0x4b8d74[_0x2826b3][_0x27ca90('0x3d')]?_[_0x27ca90('0x56')](_0x4b1f06[_0x4b8d74[_0x2826b3]['format']],'%s',_0x581428):_0x581428,_0x4b8d74[_0x2826b3][_0x27ca90('0x22')]&&_0x46ab3c[_0x27ca90('0xb')](_0x581428),_0x4b8d74[_0x2826b3][_0x27ca90('0x7e')]&&_0x46ab3c['order'](_0x581428,_0x4b8d74[_0x2826b3]['orderBy']===_0x27ca90('0xa')?![]:!![]),_0x46ab3c[_0x27ca90('0x81')](_0x581428,_0x4b8d74[_0x2826b3][_0x27ca90('0x11')]||_0x581428);}if(_0x20a3cf['joins']){_0x20a3cf[_0x27ca90('0x1b')]=JSON[_0x27ca90('0x86')](_0x20a3cf['joins']);for(let _0x467b34=0x0;_0x467b34<_0x20a3cf[_0x27ca90('0x1b')]['length'];_0x467b34+=0x1){_0x20a3cf['joins'][_0x467b34][_0x27ca90('0x30')]&&_[_0x27ca90('0x1e')](_0x47b15b,_0x20a3cf[_0x27ca90('0x1b')][_0x467b34][_0x27ca90('0x30')])&&_0x20a3cf[_0x27ca90('0x1b')][_0x467b34]['parentKey']&&_0x20a3cf['joins'][_0x467b34][_0x27ca90('0x88')]&&_0x20a3cf[_0x27ca90('0x1b')][_0x467b34]['foreignKey']&&_0x46ab3c[_0x20a3cf[_0x27ca90('0x1b')][_0x467b34][_0x27ca90('0x30')]](_0x20a3cf[_0x27ca90('0x1b')][_0x467b34][_0x27ca90('0x88')],null,util[_0x27ca90('0x3d')](_0x27ca90('0x7'),_0x20a3cf[_0x27ca90('0x82')],_0x20a3cf[_0x27ca90('0x1b')][_0x467b34][_0x27ca90('0x64')],_0x20a3cf[_0x27ca90('0x1b')][_0x467b34][_0x27ca90('0x88')],_0x20a3cf['joins'][_0x467b34]['foreignKey']));}}return _0x20a3cf[_0x27ca90('0x72')]&&(_0x20a3cf[_0x27ca90('0x72')]=JSON[_0x27ca90('0x86')](_0x20a3cf[_0x27ca90('0x72')]),_0x46ab3c[_0x27ca90('0x27')](_0x438759(_0x20a3cf['conditions'][_0x27ca90('0xb')]))),_0x2d82c7=_0x46ab3c[_0x27ca90('0x29')](),_0x46ab3c[_0x27ca90('0x12')](_0x59cd19),_0x46ab3c[_0x27ca90('0x3a')](0x0),logger['debug'](_0x27ca90('0x2d'),_0x46ab3c['toString']()),db['sequelize']['query'](_0x46ab3c[_0x27ca90('0x45')](),{'type':QueryTypes[_0x27ca90('0x7b')]});}})[_0x25fc98('0x13')](function(_0x180751){const _0x2db471=_0x25fc98;if(!_0x180751[_0x2db471('0x71')])throw new ValidationErrorItem(_0x2db471('0x15'),0xcc);if(_0x44387a['output']===_0x2db471('0x8c'))return null;const _0x1e1ed6=_[_0x2db471('0x84')](_0x44387a,{'name':_0x44387a[_0x2db471('0x2a')]||_0x44387a[_0x2db471('0x52')]||_0x20a3cf[_0x2db471('0x52')],'basename':_0x21502c,'savename':util['format'](_0x2db471('0x63'),_0x44387a[_0x2db471('0x52')]||_0x20a3cf[_0x2db471('0x52')],require('randomstring')[_0x2db471('0x77')](0x4),_0x44387a[_0x2db471('0x14')]||'csv'),'reportId':_0x20a3cf['id'],'reportType':_0x2db471('0x80')});return db['AnalyticExtractedReport'][_0x2db471('0x47')](_0x1e1ed6,{'raw':!![]});})['then'](function(_0x5a7bd5){const _0x2814da=_0x25fc98;_0x20a3cf[_0x2814da('0x82')]===_0x2814da('0x50')?_0x2d82c7[_0x2814da('0x27')](_0x20a3cf[_0x2814da('0x82')]+_0x2814da('0xe'),_0x44387a[_0x2814da('0x36')],_0x44387a[_0x2814da('0x34')]):_0x2d82c7[_0x2814da('0x27')](_0x20a3cf[_0x2814da('0x82')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x44387a[_0x2814da('0x36')],_0x44387a[_0x2814da('0x34')]);if(_0x5a7bd5)return logger[_0x2814da('0x5a')]('Run\x20Query:',_0x2d82c7[_0x2814da('0x45')]()),require('child_process')[_0x2814da('0x6b')](path[_0x2814da('0x26')](__dirname,'../../components/export/',_0x5a7bd5[_0x2814da('0x14')]),[_0x5a7bd5['id'],_0x2d82c7['toString'](),path[_0x2814da('0x26')](__dirname,_0x2814da('0x17'),_0x5a7bd5[_0x2814da('0x7d')]),_0x21502c]),_0x5a7bd5;else{const _0x493313=squel[_0x2814da('0x8a')]();return _0x493313['from']('('+_0x2d82c7[_0x2814da('0x45')]()+')',_0x2814da('0x33')),_0x493313[_0x2814da('0x81')]('COUNT(*)',_0x2814da('0x2f')),_0x2d82c7[_0x2814da('0x12')](_0x44387a[_0x2814da('0x12')]||_0x59cd19),_0x2d82c7[_0x2814da('0x3a')](_0x44387a[_0x2814da('0x3a')]||0x0),dbH[_0x2814da('0x73')][_0x2814da('0x4e')](_0x493313[_0x2814da('0x45')](),{'type':dbH[_0x2814da('0x73')][_0x2814da('0x62')][_0x2814da('0x7b')]})[_0x2814da('0x13')](function(_0x3ab619){const _0x3d52d4=_0x2814da;return!_0x3ab619[_0x3d52d4('0x71')]?_0x586a2c=0x0:_0x586a2c=_0x3ab619[0x0][_0x3d52d4('0x2f')]||0x0,dbH[_0x3d52d4('0x73')][_0x3d52d4('0x4e')](_0x2d82c7[_0x3d52d4('0x45')](),{'type':dbH[_0x3d52d4('0x73')][_0x3d52d4('0x62')][_0x3d52d4('0x7b')]});})[_0x2814da('0x13')](function(_0xd3d0d7){return{'rows':_0xd3d0d7||[],'count':_0x586a2c};});}});}exports[_0x3994b9('0x6a')]=function(_0x182ba1,_0x24ab78){const _0x2a1983=_0x3994b9;return runReport(_0x182ba1[_0x2a1983('0x53')],_0x182ba1[_0x2a1983('0x4e')],_0x182ba1[_0x2a1983('0x49')])[_0x2a1983('0x13')](respondWithResult(_0x24ab78,null))['catch'](handleError(_0x24ab78,null));},exports[_0x3994b9('0x38')]=runReport,exports[_0x3994b9('0x4e')]=function(_0xd56979,_0xa0d00){const _0xab1485=_0x3994b9,_0x2cfc28=0xa,_0x139a58=[_0xab1485('0x26'),_0xab1485('0x41'),_0xab1485('0x5b'),_0xab1485('0x2b')],_0x548f8e={'SUM':_0xab1485('0x60'),'COUNT':_0xab1485('0x37'),'COUNT\x20DISTINCT':_0xab1485('0x1'),'MAX':_0xab1485('0x40'),'MIN':'MIN(%s)','AVG':'AVG(%s)','GROUP_CONCAT':_0xab1485('0x25'),'GROUP_CONCAT\x20ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT\x20DESC':_0xab1485('0x39')},_0x5c0561={'SEC_TO_TIME':_0xab1485('0x10'),'DATE':_0xab1485('0x23'),'HOUR':_0xab1485('0x4'),'ROUND':_0xab1485('0x76'),'UNIX_TIMESTAMP':_0xab1485('0x5')},_0x146086=function(_0xc5481e){const _0x2230c=_0xab1485;return!_['includes']([_0x2230c('0x2e'),_0x2230c('0x31'),_0x2230c('0x78'),'IS\x20NOT\x20EMPTY'],_0xc5481e);},_0x37e544=function(_0x2ad6df){const _0xe37c1=_0xab1485;if(!_0x2ad6df||!_0x2ad6df[_0xe37c1('0x16')][_0xe37c1('0x71')])return'';let _0x1d6c73='(';for(let _0x240b29=0x0;_0x240b29<_0x2ad6df['rules'][_0xe37c1('0x71')];_0x240b29+=0x1){_0x240b29>0x0&&(_0x1d6c73+='\x20'+_0x2ad6df[_0xe37c1('0x69')]+'\x20'),_0x1d6c73+=_0x2ad6df[_0xe37c1('0x16')][_0x240b29]['group']?_0x37e544(_0x2ad6df[_0xe37c1('0x16')][_0x240b29][_0xe37c1('0xb')]):_0x2ad6df[_0xe37c1('0x16')][_0x240b29][_0xe37c1('0x81')]+'\x20'+_0x2ad6df[_0xe37c1('0x16')][_0x240b29][_0xe37c1('0x44')]+(_0x146086(_0x2ad6df[_0xe37c1('0x16')][_0x240b29][_0xe37c1('0x44')])?'\x20'+_0x2ad6df[_0xe37c1('0x16')][_0x240b29][_0xe37c1('0x6e')]:'');}return _0x1d6c73+')';};let _0x478b5b={'where':{'id':_0xd56979[_0xab1485('0x53')]['id']}},_0x1b66f3,_0x25147d,_0xb0d026,_0x3af72b;return _0x478b5b=_[_0xab1485('0x84')]({},_0x478b5b,_0xd56979[_0xab1485('0x49')]),db['AnalyticCustomReport'][_0xab1485('0x43')](_0x478b5b)[_0xab1485('0x13')](function(_0x5ec43f){const _0x1f70a7=_0xab1485;if(_0x5ec43f)return _0x1b66f3=_0x5ec43f,_0x5ec43f[_0x1f70a7('0x4b')]();return null;})['then'](function(_0x5bcd73){const _0x3e9a46=_0xab1485;if(_0x5bcd73){if(!_0x5bcd73[_0x3e9a46('0x71')])throw new ValidationErrorItem(_0x3e9a46('0xd'),0x193);return _0x25147d=_0x5bcd73,db[_0x3e9a46('0x57')]['findAll']({'raw':!![]});}return null;})[_0xab1485('0x13')](function(_0x5bf883){const _0x2086e9=_0xab1485;if(_0x5bf883){_0xb0d026=_['keyBy'](_0x5bf883,'id');let _0x58e3f7;const _0x16860d=squel[_0x2086e9('0x8a')]();_0x16860d[_0x2086e9('0x5e')](_0x1b66f3[_0x2086e9('0x82')]);for(let _0x1f5428=0x0;_0x1f5428<_0x25147d[_0x2086e9('0x71')];_0x1f5428+=0x1){_0x58e3f7=_0x25147d[_0x1f5428][_0x2086e9('0xc')]?_0xb0d026[_0x25147d[_0x1f5428][_0x2086e9('0xc')]]['metric']:_0x25147d[_0x1f5428]['field'],_0x58e3f7=_0x25147d[_0x1f5428][_0x2086e9('0x3b')]?_[_0x2086e9('0x56')](_0x548f8e[_0x25147d[_0x1f5428]['function']],'%s',_0x58e3f7):_0x58e3f7,_0x58e3f7=_0x25147d[_0x1f5428][_0x2086e9('0x3d')]?_[_0x2086e9('0x56')](_0x5c0561[_0x25147d[_0x1f5428][_0x2086e9('0x3d')]],'%s',_0x58e3f7):_0x58e3f7,_0x25147d[_0x1f5428][_0x2086e9('0x22')]&&_0x16860d['group'](_0x58e3f7),_0x25147d[_0x1f5428][_0x2086e9('0x7e')]&&_0x16860d[_0x2086e9('0x59')](_0x58e3f7,_0x25147d[_0x1f5428][_0x2086e9('0x7e')]==='DESC'?![]:!![]),_0x16860d['field'](_0x58e3f7,_0x25147d[_0x1f5428][_0x2086e9('0x11')]||_0x58e3f7);}if(_0x1b66f3[_0x2086e9('0x1b')]){_0x1b66f3[_0x2086e9('0x1b')]=JSON[_0x2086e9('0x86')](_0x1b66f3[_0x2086e9('0x1b')]);for(let _0x36a133=0x0;_0x36a133<_0x1b66f3[_0x2086e9('0x1b')][_0x2086e9('0x71')];_0x36a133+=0x1){_0x1b66f3['joins'][_0x36a133][_0x2086e9('0x30')]&&_[_0x2086e9('0x1e')](_0x139a58,_0x1b66f3[_0x2086e9('0x1b')][_0x36a133]['type'])&&_0x1b66f3[_0x2086e9('0x1b')][_0x36a133][_0x2086e9('0x64')]&&_0x1b66f3['joins'][_0x36a133][_0x2086e9('0x88')]&&_0x1b66f3[_0x2086e9('0x1b')][_0x36a133]['foreignKey']&&_0x16860d[_0x1b66f3[_0x2086e9('0x1b')][_0x36a133][_0x2086e9('0x30')]](_0x1b66f3[_0x2086e9('0x1b')][_0x36a133][_0x2086e9('0x88')],null,util[_0x2086e9('0x3d')](_0x2086e9('0x7'),_0x1b66f3[_0x2086e9('0x82')],_0x1b66f3[_0x2086e9('0x1b')][_0x36a133][_0x2086e9('0x64')],_0x1b66f3['joins'][_0x36a133][_0x2086e9('0x88')],_0x1b66f3[_0x2086e9('0x1b')][_0x36a133][_0x2086e9('0x4a')]));}}return _0x1b66f3[_0x2086e9('0x72')]&&(_0x1b66f3[_0x2086e9('0x72')]=JSON[_0x2086e9('0x86')](_0x1b66f3[_0x2086e9('0x72')]),_0x16860d[_0x2086e9('0x27')](_0x37e544(_0x1b66f3[_0x2086e9('0x72')]['group']))),_0x3af72b=_0x16860d[_0x2086e9('0x29')](),_0x16860d['limit'](_0x2cfc28),_0x16860d['offset'](0x0),logger[_0x2086e9('0x19')](_0x2086e9('0x2d'),_0x16860d[_0x2086e9('0x45')]()),db[_0x2086e9('0x73')][_0x2086e9('0x4e')](_0x16860d[_0x2086e9('0x45')](),{'type':QueryTypes[_0x2086e9('0x7b')]});}})[_0xab1485('0x13')](function(){const _0x262fba=_0xab1485;return{'sql':_0x3af72b[_0x262fba('0x45')]()};})[_0xab1485('0x13')](respondWithResult(_0xa0d00,null))[_0xab1485('0x35')](handleError(_0xa0d00,null));};
git://repos.xcallymotion.com / motion-next.git / blob