18 var _0x237d=['limit','set','Content-Range','apply','reject','then','destroy','UserProfileResource','error','name','AnalyticDefaultReport','model','keys','query','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','key','VIRTUAL','field','options','count','include','findAll','catch','show','rawAttributes','filters','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','Reports','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','preview','left_join','right_join','cross_join','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20NOT\x20EMPTY','rules','operator','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from','table','MetricId','metric','function','format','replace','groupBy','group','orderBy','DESC','alias','joins','parse','type','parentKey','foreignTable','foreignKey','conditions','debug','Limited\x20Query:','toString','sequelize','QueryTypes','join','IS\x20NULL','IS\x20EMPTY','clone','SELECT','No\x20available\x20data','output','fullPath','%s-%s.%s','randomstring','csv','default','AnalyticExtractedReport','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','info','child_process','fork','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','run','runReport','SUM(%s)','ROUND(%s)','%s.%s\x20=\x20%s.%s','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','util','path','sox','to-csv','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset'];(function(_0x4106da,_0x554190){var _0x1bf639=function(_0x4fa1a9){while(--_0x4fa1a9){_0x4106da['push'](_0x4106da['shift']());}};_0x1bf639(++_0x554190);}(_0x237d,0x85));var _0xd237=function(_0x5dd5b3,_0x222c43){_0x5dd5b3=_0x5dd5b3-0x0;var _0xa26fc6=_0x237d[_0x5dd5b3];return _0xa26fc6;};'use strict';var pdf=require(_0xd237('0x0'));var emlformat=require(_0xd237('0x1'));var rimraf=require(_0xd237('0x2'));var zipdir=require(_0xd237('0x3'));var jsonpatch=require(_0xd237('0x4'));var rp=require('request-promise');var moment=require(_0xd237('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xd237('0x6'));var util=require(_0xd237('0x7'));var path=require(_0xd237('0x8'));var sox=require(_0xd237('0x9'));var csv=require(_0xd237('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xd237('0xb'));var squel=require(_0xd237('0xc'));var crypto=require(_0xd237('0xd'));var jsforce=require(_0xd237('0xe'));var deskjs=require(_0xd237('0xf'));var toCsv=require(_0xd237('0xa'));var querystring=require(_0xd237('0x10'));var Papa=require(_0xd237('0x11'));var Redis=require(_0xd237('0x12'));var authService=require(_0xd237('0x13'));var qs=require(_0xd237('0x14'));var hardwareService=require(_0xd237('0x15'));var logger=require(_0xd237('0x16'))(_0xd237('0x17'));var utils=require(_0xd237('0x18'));var config=require(_0xd237('0x19'));var db=require(_0xd237('0x1a'))['db'];function respondWithStatusCode(_0x127584,_0xc651c){_0xc651c=_0xc651c||0xcc;return function(_0x44bd1a){if(_0x44bd1a){return _0x127584[_0xd237('0x1b')](_0xc651c);}return _0x127584[_0xd237('0x1c')](_0xc651c)[_0xd237('0x1d')]();};}function respondWithResult(_0x41dfbd,_0x127b07){_0x127b07=_0x127b07||0xc8;return function(_0x4093ce){if(_0x4093ce){return _0x41dfbd['status'](_0x127b07)[_0xd237('0x1e')](_0x4093ce);}};}function respondWithFilteredResult(_0x375ab0,_0x56c8a5){return function(_0x414d4a){if(_0x414d4a){var _0x49888c=_0x414d4a['count'],_0x27af40=_0x56c8a5[_0xd237('0x1f')],_0x241fdc=_0x56c8a5[_0xd237('0x1f')]+_0x56c8a5[_0xd237('0x20')],_0x168652;if(_0x241fdc>=_0x49888c){_0x241fdc=_0x49888c;_0x168652=0xc8;}else{_0x168652=0xce;}_0x375ab0[_0xd237('0x1c')](_0x168652);return _0x375ab0[_0xd237('0x21')](_0xd237('0x22'),_0x27af40+'-'+_0x241fdc+'/'+_0x49888c)[_0xd237('0x1e')](_0x414d4a);}return null;};}function patchUpdates(_0x5f5de4){return function(_0x5dd4a7){try{jsonpatch[_0xd237('0x23')](_0x5dd4a7,_0x5f5de4,!![]);}catch(_0x10def7){return BPromise[_0xd237('0x24')](_0x10def7);}return _0x5dd4a7['save']();};}function saveUpdates(_0x3c5409,_0x5830a4){return function(_0x330793){if(_0x330793){return _0x330793['update'](_0x3c5409)[_0xd237('0x25')](function(_0x362d83){return _0x362d83;});}return null;};}function removeEntity(_0xc2d23d,_0x9bb0f4){return function(_0x50f50c){if(_0x50f50c){return _0x50f50c[_0xd237('0x26')]()[_0xd237('0x25')](function(){var _0xd54675=_0x50f50c['get']({'plain':!![]});var _0x529891='DefaultReports';return db[_0xd237('0x27')][_0xd237('0x26')]({'where':{'type':_0x529891,'resourceId':_0xd54675['id']}})[_0xd237('0x25')](function(){return _0x50f50c;});})[_0xd237('0x25')](function(){_0xc2d23d[_0xd237('0x1c')](0xcc)[_0xd237('0x1d')]();});}};}function handleEntityNotFound(_0xff6830,_0xd7b213){return function(_0x5ec566){if(!_0x5ec566){_0xff6830[_0xd237('0x1b')](0x194);}return _0x5ec566;};}function handleError(_0x487bcd,_0x22938b){_0x22938b=_0x22938b||0x1f4;return function(_0x2bcc4d){logger[_0xd237('0x28')](_0x2bcc4d['stack']);if(_0x2bcc4d[_0xd237('0x29')]){delete _0x2bcc4d[_0xd237('0x29')];}_0x487bcd['status'](_0x22938b)['send'](_0x2bcc4d);};}exports['index']=function(_0x2eab7d,_0x5e7297){var _0x56749b={},_0x5a8545={},_0x40938f={'count':0x0,'rows':[]};var _0x294062=db[_0xd237('0x2a')]['rawAttributes'];_0x5a8545[_0xd237('0x2b')]=_[_0xd237('0x2c')](_0x294062);_0x5a8545['query']=_[_0xd237('0x2c')](_0x2eab7d[_0xd237('0x2d')]);_0x5a8545['filters']=_['intersection'](_0x5a8545['model'],_0x5a8545[_0xd237('0x2d')]);_0x56749b[_0xd237('0x2e')]=_[_0xd237('0x2f')](_0x5a8545['model'],qs['fields'](_0x2eab7d[_0xd237('0x2d')][_0xd237('0x30')]));_0x56749b[_0xd237('0x2e')]=_0x56749b[_0xd237('0x2e')][_0xd237('0x31')]?_0x56749b[_0xd237('0x2e')]:_0x5a8545['model'];if(!_0x2eab7d['query'][_0xd237('0x32')](_0xd237('0x33'))){_0x56749b[_0xd237('0x20')]=qs[_0xd237('0x20')](_0x2eab7d['query'][_0xd237('0x20')]);_0x56749b[_0xd237('0x1f')]=qs[_0xd237('0x1f')](_0x2eab7d[_0xd237('0x2d')][_0xd237('0x1f')]);}_0x56749b[_0xd237('0x34')]=qs[_0xd237('0x35')](_0x2eab7d[_0xd237('0x2d')]['sort']);_0x56749b[_0xd237('0x36')]=qs['filters'](_[_0xd237('0x37')](_0x2eab7d['query'],_0x5a8545['filters']));if(_0x2eab7d[_0xd237('0x2d')][_0xd237('0x38')]){_0x56749b[_0xd237('0x36')]=_[_0xd237('0x39')](_0x56749b[_0xd237('0x36')],{'$or':_['map'](_0x294062,function(_0x37089d){if(_0x37089d['type'][_0xd237('0x3a')]!==_0xd237('0x3b')){var _0x625346={};_0x625346[_0x37089d[_0xd237('0x3c')]]={'$like':'%'+_0x2eab7d[_0xd237('0x2d')][_0xd237('0x38')]+'%'};return _0x625346;}})});}_0x56749b=_[_0xd237('0x39')]({},_0x56749b,_0x2eab7d[_0xd237('0x3d')]);var _0x2e1c77={'where':_0x56749b['where']};return db[_0xd237('0x2a')]['count'](_0x2e1c77)[_0xd237('0x25')](function(_0xb4af3c){_0x40938f[_0xd237('0x3e')]=_0xb4af3c;if(_0x2eab7d[_0xd237('0x2d')]['includeAll']){_0x56749b[_0xd237('0x3f')]=[{'all':!![]}];}return db[_0xd237('0x2a')][_0xd237('0x40')](_0x56749b);})[_0xd237('0x25')](function(_0x5794c5){_0x40938f['rows']=_0x5794c5;return _0x40938f;})[_0xd237('0x25')](respondWithFilteredResult(_0x5e7297,_0x56749b))[_0xd237('0x41')](handleError(_0x5e7297,null));};exports[_0xd237('0x42')]=function(_0x4f6e01,_0x1cdfa1){var _0x23753f={'raw':!![],'where':{'id':_0x4f6e01['params']['id']}},_0x2ad5db={};_0x2ad5db['model']=_['keys'](db['AnalyticDefaultReport'][_0xd237('0x43')]);_0x2ad5db[_0xd237('0x2d')]=_['keys'](_0x4f6e01['query']);_0x2ad5db[_0xd237('0x44')]=_[_0xd237('0x2f')](_0x2ad5db[_0xd237('0x2b')],_0x2ad5db[_0xd237('0x2d')]);_0x23753f[_0xd237('0x2e')]=_[_0xd237('0x2f')](_0x2ad5db[_0xd237('0x2b')],qs[_0xd237('0x30')](_0x4f6e01[_0xd237('0x2d')][_0xd237('0x30')]));_0x23753f[_0xd237('0x2e')]=_0x23753f[_0xd237('0x2e')][_0xd237('0x31')]?_0x23753f[_0xd237('0x2e')]:_0x2ad5db[_0xd237('0x2b')];if(_0x4f6e01['query']['includeAll']){_0x23753f[_0xd237('0x3f')]=[{'all':!![]}];}_0x23753f=_[_0xd237('0x39')]({},_0x23753f,_0x4f6e01[_0xd237('0x3d')]);return db[_0xd237('0x2a')][_0xd237('0x45')](_0x23753f)[_0xd237('0x25')](handleEntityNotFound(_0x1cdfa1,null))[_0xd237('0x25')](respondWithResult(_0x1cdfa1,null))[_0xd237('0x41')](handleError(_0x1cdfa1,null));};exports['create']=function(_0x75e3c7,_0x46f6e7){return db[_0xd237('0x2a')][_0xd237('0x46')](_0x75e3c7[_0xd237('0x47')],{})['then'](function(_0x100e47){var _0xff3fdd=_0x75e3c7[_0xd237('0x48')]['get']({'plain':!![]});if(!_0xff3fdd)throw new Error(_0xd237('0x49'));if(_0xff3fdd[_0xd237('0x4a')]===_0xd237('0x48')){var _0x523854=_0x100e47[_0xd237('0x4b')]({'plain':!![]});var _0x3f5ffa=_0xd237('0x4c');return db[_0xd237('0x4d')]['find']({'where':{'name':_0x3f5ffa,'userProfileId':_0xff3fdd['userProfileId']},'raw':!![]})[_0xd237('0x25')](function(_0x5ac031){if(_0x5ac031&&_0x5ac031[_0xd237('0x4e')]===0x0){return db[_0xd237('0x27')][_0xd237('0x46')]({'name':_0x523854[_0xd237('0x29')],'resourceId':_0x523854['id'],'type':'DefaultReports','sectionId':_0x5ac031['id']},{})['then'](function(){return _0x100e47;});}else{return _0x100e47;}})['catch'](function(_0x497113){logger[_0xd237('0x28')](_0xd237('0x4f'),_0x497113);throw _0x497113;});}return _0x100e47;})[_0xd237('0x25')](respondWithResult(_0x46f6e7,0xc9))[_0xd237('0x41')](handleError(_0x46f6e7,null));};exports['update']=function(_0x342b12,_0x2c5264){if(_0x342b12[_0xd237('0x47')]['id']){delete _0x342b12['body']['id'];}return db[_0xd237('0x2a')][_0xd237('0x45')]({'where':{'id':_0x342b12['params']['id']}})[_0xd237('0x25')](handleEntityNotFound(_0x2c5264,null))[_0xd237('0x25')](saveUpdates(_0x342b12[_0xd237('0x47')],null))[_0xd237('0x25')](respondWithResult(_0x2c5264,null))[_0xd237('0x41')](handleError(_0x2c5264,null));};exports[_0xd237('0x26')]=function(_0x28fbe5,_0x5112b8){return db[_0xd237('0x2a')][_0xd237('0x45')]({'where':{'id':_0x28fbe5[_0xd237('0x50')]['id']}})[_0xd237('0x25')](handleEntityNotFound(_0x5112b8,null))[_0xd237('0x25')](removeEntity(_0x5112b8,null))[_0xd237('0x41')](handleError(_0x5112b8,null));};exports[_0xd237('0x51')]=function(_0x4c7615,_0x57caf6){var _0x3bfadd=0xa;var _0x1ff229=['join',_0xd237('0x52'),_0xd237('0x53'),_0xd237('0x54')];var _0x5e50a2={'SUM':'SUM(%s)','COUNT':_0xd237('0x55'),'COUNT DISTINCT':_0xd237('0x56'),'MAX':_0xd237('0x57'),'MIN':_0xd237('0x58'),'AVG':_0xd237('0x59'),'GROUP_CONCAT':_0xd237('0x5a'),'GROUP_CONCAT ASC':_0xd237('0x5b'),'GROUP_CONCAT DESC':_0xd237('0x5c')};var _0x2f2406={'SEC_TO_TIME':_0xd237('0x5d'),'DATE':_0xd237('0x5e'),'HOUR':_0xd237('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xd237('0x60')};var _0x1fae39=function(_0x35f358){return!_[_0xd237('0x61')](['IS\x20NULL',_0xd237('0x62'),'IS\x20EMPTY',_0xd237('0x63')],_0x35f358);};var _0x49646a=function(_0x5e3683){if(!_0x5e3683||!_0x5e3683[_0xd237('0x64')][_0xd237('0x31')]){return'';}for(var _0x42e906='(',_0x26a591=0x0;_0x26a591<_0x5e3683[_0xd237('0x64')]['length'];_0x26a591+=0x1){_0x26a591>0x0&&(_0x42e906+='\x20'+_0x5e3683[_0xd237('0x65')]+'\x20');_0x42e906+=_0x5e3683[_0xd237('0x64')][_0x26a591]['group']?_0x49646a(_0x5e3683[_0xd237('0x64')][_0x26a591]['group']):_0x5e3683[_0xd237('0x64')][_0x26a591][_0xd237('0x3c')]+'\x20'+_0x5e3683[_0xd237('0x64')][_0x26a591][_0xd237('0x66')]+(_0x1fae39(_0x5e3683[_0xd237('0x64')][_0x26a591][_0xd237('0x66')])?'\x20'+_0x5e3683[_0xd237('0x64')][_0x26a591][_0xd237('0x67')]:'');}return _0x42e906+')';};var _0x216502={'where':{'id':_0x4c7615['params']['id']}},_0x209bd4,_0xa9628a,_0x3afec6,_0x34c72c,_0xdb6e7f;_0x216502=_[_0xd237('0x39')]({},_0x216502,_0x4c7615[_0xd237('0x3d')]);return db[_0xd237('0x2a')]['find'](_0x216502)[_0xd237('0x25')](function(_0x33209a){if(_0x33209a){_0x209bd4=_0x33209a;return _0x33209a[_0xd237('0x68')]();}return null;})[_0xd237('0x25')](function(_0xbe0f70){if(_0xbe0f70){if(!_0xbe0f70[_0xd237('0x31')]){throw new db[(_0xd237('0x69'))][(_0xd237('0x6a'))](_0xd237('0x6b'),0x193);}_0xa9628a=_0xbe0f70;return db[_0xd237('0x6c')][_0xd237('0x40')]({'raw':!![]});}return null;})[_0xd237('0x25')](function(_0x54adc0){if(_0x54adc0){_0x3afec6=_[_0xd237('0x6d')](_0x54adc0,'id');var _0x4f935a;var _0x506926=squel[_0xd237('0x6e')]();_0x506926[_0xd237('0x6f')](_0x209bd4[_0xd237('0x70')]);for(var _0x505cf8=0x0;_0x505cf8<_0xa9628a[_0xd237('0x31')];_0x505cf8+=0x1){_0x4f935a=_0xa9628a[_0x505cf8][_0xd237('0x71')]?_0x3afec6[_0xa9628a[_0x505cf8]['MetricId']][_0xd237('0x72')]:_0xa9628a[_0x505cf8][_0xd237('0x3c')];_0x4f935a=_0xa9628a[_0x505cf8][_0xd237('0x73')]?_['replace'](_0x5e50a2[_0xa9628a[_0x505cf8][_0xd237('0x73')]],'%s',_0x4f935a):_0x4f935a;_0x4f935a=_0xa9628a[_0x505cf8][_0xd237('0x74')]?_[_0xd237('0x75')](_0x2f2406[_0xa9628a[_0x505cf8]['format']],'%s',_0x4f935a):_0x4f935a;if(_0xa9628a[_0x505cf8][_0xd237('0x76')]){_0x506926[_0xd237('0x77')](_0x4f935a);}_0xa9628a[_0x505cf8][_0xd237('0x78')]&&_0x506926['order'](_0x4f935a,_0xa9628a[_0x505cf8][_0xd237('0x78')]===_0xd237('0x79')?![]:!![]);_0x506926[_0xd237('0x3c')](_0x4f935a,_0xa9628a[_0x505cf8][_0xd237('0x7a')]||_0x4f935a);}if(_0x209bd4[_0xd237('0x7b')]){_0x209bd4[_0xd237('0x7b')]=JSON[_0xd237('0x7c')](_0x209bd4[_0xd237('0x7b')]);for(var _0x2d121b=0x0;_0x2d121b<_0x209bd4[_0xd237('0x7b')][_0xd237('0x31')];_0x2d121b+=0x1){if(_0x209bd4[_0xd237('0x7b')][_0x2d121b]['type']&&_['includes'](_0x1ff229,_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x7d')])&&_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x7e')]&&_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x7f')]&&_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x80')]){_0x506926[_0x209bd4[_0xd237('0x7b')][_0x2d121b]['type']](_0x209bd4[_0xd237('0x7b')][_0x2d121b]['foreignTable'],null,util['format']('%s.%s\x20=\x20%s.%s',_0x209bd4[_0xd237('0x70')],_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x7e')],_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x7f')],_0x209bd4[_0xd237('0x7b')][_0x2d121b][_0xd237('0x80')]));}}}if(_0x209bd4[_0xd237('0x81')]){_0x209bd4['conditions']=JSON[_0xd237('0x7c')](_0x209bd4[_0xd237('0x81')]);_0x506926[_0xd237('0x36')](_0x49646a(_0x209bd4[_0xd237('0x81')][_0xd237('0x77')]));}_0xdb6e7f=_0x506926['clone']();_0x506926[_0xd237('0x20')](_0x3bfadd);_0x506926[_0xd237('0x1f')](0x0);logger[_0xd237('0x82')](_0xd237('0x83'),_0x506926[_0xd237('0x84')]());return db[_0xd237('0x85')]['query'](_0x506926[_0xd237('0x84')](),{'type':db[_0xd237('0x85')][_0xd237('0x86')]['SELECT']});}})[_0xd237('0x25')](respondWithResult(_0x57caf6,null))['catch'](handleError(_0x57caf6,null));};function runReport(_0x4bb115,_0x5284b4,_0x1209fb){var _0x4277ae=_0x5284b4[_0xd237('0x29')];var _0x48648b=0xa;var _0x5b6973=[_0xd237('0x87'),_0xd237('0x52'),_0xd237('0x53'),_0xd237('0x54')];var _0x28d6c8={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0xd237('0x59'),'GROUP_CONCAT':_0xd237('0x5a'),'GROUP_CONCAT ASC':_0xd237('0x5b'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x5f36fe={'SEC_TO_TIME':_0xd237('0x5d'),'DATE':_0xd237('0x5e'),'HOUR':_0xd237('0x5f'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xd237('0x60')};var _0x2f99f3=function(_0x4366e7){return!_[_0xd237('0x61')]([_0xd237('0x88'),_0xd237('0x62'),_0xd237('0x89'),'IS\x20NOT\x20EMPTY'],_0x4366e7);};var _0x3d4164=function(_0x22bbdf){if(!_0x22bbdf||!_0x22bbdf[_0xd237('0x64')][_0xd237('0x31')]){return'';}for(var _0x180044='(',_0x129d14=0x0;_0x129d14<_0x22bbdf[_0xd237('0x64')][_0xd237('0x31')];_0x129d14+=0x1){_0x129d14>0x0&&(_0x180044+='\x20'+_0x22bbdf[_0xd237('0x65')]+'\x20');_0x180044+=_0x22bbdf[_0xd237('0x64')][_0x129d14][_0xd237('0x77')]?_0x3d4164(_0x22bbdf[_0xd237('0x64')][_0x129d14][_0xd237('0x77')]):_0x22bbdf[_0xd237('0x64')][_0x129d14][_0xd237('0x3c')]+'\x20'+_0x22bbdf['rules'][_0x129d14][_0xd237('0x66')]+(_0x2f99f3(_0x22bbdf[_0xd237('0x64')][_0x129d14][_0xd237('0x66')])?'\x20'+_0x22bbdf['rules'][_0x129d14][_0xd237('0x67')]:'');}return _0x180044+')';};var _0x53e969={'where':{'id':_0x4bb115['id']}},_0x94db2b,_0x30731c,_0x475796,_0x235dfd,_0x103d6d;_0x53e969=_['merge']({},_0x53e969,_0x1209fb);return db[_0xd237('0x2a')][_0xd237('0x45')](_0x53e969)[_0xd237('0x25')](function(_0x53592b){if(_0x53592b){_0x94db2b=_0x53592b;return _0x53592b[_0xd237('0x68')]();}return null;})[_0xd237('0x25')](function(_0x481d07){if(_0x481d07){if(!_0x481d07[_0xd237('0x31')]){throw new db[(_0xd237('0x69'))][(_0xd237('0x6a'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x30731c=_0x481d07;return db[_0xd237('0x6c')]['findAll']({'raw':!![]});}return null;})['then'](function(_0x3c506a){if(_0x3c506a){_0x475796=_['keyBy'](_0x3c506a,'id');var _0xd395c4;var _0x45fa99=squel[_0xd237('0x6e')]();_0x45fa99[_0xd237('0x6f')](_0x94db2b[_0xd237('0x70')]);for(var _0x535f06=0x0;_0x535f06<_0x30731c['length'];_0x535f06+=0x1){_0xd395c4=_0x30731c[_0x535f06][_0xd237('0x71')]?_0x475796[_0x30731c[_0x535f06][_0xd237('0x71')]][_0xd237('0x72')]:_0x30731c[_0x535f06][_0xd237('0x3c')];_0xd395c4=_0x30731c[_0x535f06][_0xd237('0x73')]?_['replace'](_0x28d6c8[_0x30731c[_0x535f06]['function']],'%s',_0xd395c4):_0xd395c4;_0xd395c4=_0x30731c[_0x535f06]['format']?_[_0xd237('0x75')](_0x5f36fe[_0x30731c[_0x535f06][_0xd237('0x74')]],'%s',_0xd395c4):_0xd395c4;if(_0x30731c[_0x535f06][_0xd237('0x76')]){_0x45fa99[_0xd237('0x77')](_0xd395c4);}_0x30731c[_0x535f06][_0xd237('0x78')]&&_0x45fa99[_0xd237('0x34')](_0xd395c4,_0x30731c[_0x535f06][_0xd237('0x78')]===_0xd237('0x79')?![]:!![]);_0x45fa99[_0xd237('0x3c')](_0xd395c4,_0x30731c[_0x535f06][_0xd237('0x7a')]||_0xd395c4);}if(_0x94db2b[_0xd237('0x7b')]){_0x94db2b[_0xd237('0x7b')]=JSON[_0xd237('0x7c')](_0x94db2b[_0xd237('0x7b')]);for(var _0x4eca0a=0x0;_0x4eca0a<_0x94db2b[_0xd237('0x7b')][_0xd237('0x31')];_0x4eca0a+=0x1){if(_0x94db2b[_0xd237('0x7b')][_0x4eca0a]['type']&&_[_0xd237('0x61')](_0x5b6973,_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x7d')])&&_0x94db2b['joins'][_0x4eca0a][_0xd237('0x7e')]&&_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x7f')]&&_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x80')]){_0x45fa99[_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x7d')]](_0x94db2b['joins'][_0x4eca0a]['foreignTable'],null,util[_0xd237('0x74')]('%s.%s\x20=\x20%s.%s',_0x94db2b[_0xd237('0x70')],_0x94db2b['joins'][_0x4eca0a][_0xd237('0x7e')],_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x7f')],_0x94db2b[_0xd237('0x7b')][_0x4eca0a][_0xd237('0x80')]));}}}if(_0x94db2b[_0xd237('0x81')]){_0x94db2b[_0xd237('0x81')]=JSON[_0xd237('0x7c')](_0x94db2b[_0xd237('0x81')]);_0x45fa99[_0xd237('0x36')](_0x3d4164(_0x94db2b[_0xd237('0x81')][_0xd237('0x77')]));}_0x103d6d=_0x45fa99[_0xd237('0x8a')]();_0x45fa99[_0xd237('0x20')](_0x48648b);_0x45fa99['offset'](0x0);logger[_0xd237('0x82')](_0xd237('0x83'),_0x45fa99['toString']());return db[_0xd237('0x85')][_0xd237('0x2d')](_0x45fa99['toString'](),{'type':db[_0xd237('0x85')][_0xd237('0x86')][_0xd237('0x8b')]});}})[_0xd237('0x25')](function(_0x4b38f0){if(!_0x4b38f0['length']){throw new db[(_0xd237('0x69'))][(_0xd237('0x6a'))](_0xd237('0x8c'),0xcc);}if(_0x5284b4[_0xd237('0x8d')]==='web'){return null;}var _0x3232ae=_['merge'](_0x5284b4,{'name':_0x5284b4[_0xd237('0x8e')]||_0x5284b4[_0xd237('0x29')]||_0x94db2b[_0xd237('0x29')],'basename':_0x4277ae,'savename':util[_0xd237('0x74')](_0xd237('0x8f'),_0x5284b4[_0xd237('0x29')]||_0x94db2b[_0xd237('0x29')],require(_0xd237('0x90'))['generate'](0x4),_0x5284b4[_0xd237('0x8d')]||_0xd237('0x91')),'reportId':_0x94db2b['id'],'reportType':_0xd237('0x92')});return db[_0xd237('0x93')][_0xd237('0x46')](_0x3232ae,{'raw':!![]});})[_0xd237('0x25')](function(_0x540d34){if(_0x94db2b['table']===_0xd237('0x94')){_0x103d6d['where'](_0x94db2b[_0xd237('0x70')]+_0xd237('0x95'),_0x5284b4[_0xd237('0x96')],_0x5284b4['endDate']);}else{_0x103d6d[_0xd237('0x36')](_0x94db2b[_0xd237('0x70')]+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x5284b4[_0xd237('0x96')],_0x5284b4[_0xd237('0x97')]);}if(_0x540d34){logger[_0xd237('0x98')]('Run\x20Query:',_0x103d6d[_0xd237('0x84')]());require(_0xd237('0x99'))[_0xd237('0x9a')](path['join'](__dirname,_0xd237('0x9b'),_0x540d34[_0xd237('0x8d')]),[_0x540d34['id'],_0x103d6d[_0xd237('0x84')](),path[_0xd237('0x87')](__dirname,_0xd237('0x9c'),_0x540d34[_0xd237('0x9d')]),_0x4277ae]);return _0x540d34;}else{var _0x1e0e62=squel[_0xd237('0x6e')]();_0x1e0e62[_0xd237('0x6f')]('('+_0x103d6d[_0xd237('0x84')]()+')',_0xd237('0x9e'));_0x1e0e62['field'](_0xd237('0x9f'),_0xd237('0x3e'));_0x103d6d['limit'](_0x5284b4[_0xd237('0x20')]||_0x48648b);_0x103d6d[_0xd237('0x1f')](_0x5284b4[_0xd237('0x1f')]||0x0);return db[_0xd237('0x85')]['query'](_0x1e0e62[_0xd237('0x84')](),{'type':db['sequelize'][_0xd237('0x86')][_0xd237('0x8b')]})[_0xd237('0x25')](function(_0x17339f){if(!_0x17339f[_0xd237('0x31')]){_0x235dfd=0x0;}else{_0x235dfd=_0x17339f[0x0][_0xd237('0x3e')]||0x0;}return db['sequelize']['query'](_0x103d6d[_0xd237('0x84')](),{'type':db[_0xd237('0x85')][_0xd237('0x86')][_0xd237('0x8b')]});})[_0xd237('0x25')](function(_0x27e0bd){return{'rows':_0x27e0bd||[],'count':_0x235dfd};});}});}exports[_0xd237('0xa0')]=function(_0x3fb728,_0x275518){return runReport(_0x3fb728[_0xd237('0x50')],_0x3fb728[_0xd237('0x2d')],_0x3fb728['options'])['then'](respondWithResult(_0x275518,null))[_0xd237('0x41')](handleError(_0x275518,null));};exports[_0xd237('0xa1')]=runReport;exports['query']=function(_0x33b409,_0x3fd54e){var _0x4c926c=0xa;var _0x3faebc=[_0xd237('0x87'),_0xd237('0x52'),_0xd237('0x53'),_0xd237('0x54')];var _0x46161b={'SUM':_0xd237('0xa2'),'COUNT':_0xd237('0x55'),'COUNT DISTINCT':_0xd237('0x56'),'MAX':_0xd237('0x57'),'MIN':_0xd237('0x58'),'AVG':_0xd237('0x59'),'GROUP_CONCAT':_0xd237('0x5a'),'GROUP_CONCAT ASC':_0xd237('0x5b'),'GROUP_CONCAT DESC':_0xd237('0x5c')};var _0x12e1d8={'SEC_TO_TIME':_0xd237('0x5d'),'DATE':_0xd237('0x5e'),'HOUR':'HOUR(%s)','ROUND':_0xd237('0xa3'),'UNIX_TIMESTAMP':_0xd237('0x60')};var _0xb509f8=function(_0x1a7dfe){return!_['includes']([_0xd237('0x88'),'IS\x20NOT\x20NULL',_0xd237('0x89'),_0xd237('0x63')],_0x1a7dfe);};var _0x25e76d=function(_0x2467a9){if(!_0x2467a9||!_0x2467a9[_0xd237('0x64')][_0xd237('0x31')]){return'';}for(var _0x191543='(',_0x1a4480=0x0;_0x1a4480<_0x2467a9[_0xd237('0x64')][_0xd237('0x31')];_0x1a4480+=0x1){_0x1a4480>0x0&&(_0x191543+='\x20'+_0x2467a9[_0xd237('0x65')]+'\x20');_0x191543+=_0x2467a9[_0xd237('0x64')][_0x1a4480][_0xd237('0x77')]?_0x25e76d(_0x2467a9['rules'][_0x1a4480][_0xd237('0x77')]):_0x2467a9[_0xd237('0x64')][_0x1a4480][_0xd237('0x3c')]+'\x20'+_0x2467a9[_0xd237('0x64')][_0x1a4480][_0xd237('0x66')]+(_0xb509f8(_0x2467a9[_0xd237('0x64')][_0x1a4480][_0xd237('0x66')])?'\x20'+_0x2467a9[_0xd237('0x64')][_0x1a4480][_0xd237('0x67')]:'');}return _0x191543+')';};var _0x50afc9={'where':{'id':_0x33b409[_0xd237('0x50')]['id']}},_0x5d36cf,_0x2eadf3,_0x48edcb,_0x3c54af,_0x871c60;_0x50afc9=_[_0xd237('0x39')]({},_0x50afc9,_0x33b409[_0xd237('0x3d')]);return db[_0xd237('0x2a')]['find'](_0x50afc9)[_0xd237('0x25')](function(_0x48ae23){if(_0x48ae23){_0x5d36cf=_0x48ae23;return _0x48ae23[_0xd237('0x68')]();}return null;})[_0xd237('0x25')](function(_0x1c1525){if(_0x1c1525){if(!_0x1c1525[_0xd237('0x31')]){throw new db[(_0xd237('0x69'))][(_0xd237('0x6a'))](_0xd237('0x6b'),0x193);}_0x2eadf3=_0x1c1525;return db['AnalyticMetric'][_0xd237('0x40')]({'raw':!![]});}return null;})[_0xd237('0x25')](function(_0x338100){if(_0x338100){_0x48edcb=_[_0xd237('0x6d')](_0x338100,'id');var _0x37e45d;var _0x11f460=squel[_0xd237('0x6e')]();_0x11f460[_0xd237('0x6f')](_0x5d36cf['table']);for(var _0x310f14=0x0;_0x310f14<_0x2eadf3['length'];_0x310f14+=0x1){_0x37e45d=_0x2eadf3[_0x310f14][_0xd237('0x71')]?_0x48edcb[_0x2eadf3[_0x310f14][_0xd237('0x71')]][_0xd237('0x72')]:_0x2eadf3[_0x310f14][_0xd237('0x3c')];_0x37e45d=_0x2eadf3[_0x310f14][_0xd237('0x73')]?_['replace'](_0x46161b[_0x2eadf3[_0x310f14][_0xd237('0x73')]],'%s',_0x37e45d):_0x37e45d;_0x37e45d=_0x2eadf3[_0x310f14][_0xd237('0x74')]?_[_0xd237('0x75')](_0x12e1d8[_0x2eadf3[_0x310f14][_0xd237('0x74')]],'%s',_0x37e45d):_0x37e45d;if(_0x2eadf3[_0x310f14][_0xd237('0x76')]){_0x11f460[_0xd237('0x77')](_0x37e45d);}_0x2eadf3[_0x310f14][_0xd237('0x78')]&&_0x11f460['order'](_0x37e45d,_0x2eadf3[_0x310f14][_0xd237('0x78')]==='DESC'?![]:!![]);_0x11f460['field'](_0x37e45d,_0x2eadf3[_0x310f14][_0xd237('0x7a')]||_0x37e45d);}if(_0x5d36cf['joins']){_0x5d36cf[_0xd237('0x7b')]=JSON[_0xd237('0x7c')](_0x5d36cf[_0xd237('0x7b')]);for(var _0x327930=0x0;_0x327930<_0x5d36cf[_0xd237('0x7b')][_0xd237('0x31')];_0x327930+=0x1){if(_0x5d36cf[_0xd237('0x7b')][_0x327930]['type']&&_['includes'](_0x3faebc,_0x5d36cf[_0xd237('0x7b')][_0x327930]['type'])&&_0x5d36cf[_0xd237('0x7b')][_0x327930][_0xd237('0x7e')]&&_0x5d36cf[_0xd237('0x7b')][_0x327930]['foreignTable']&&_0x5d36cf[_0xd237('0x7b')][_0x327930][_0xd237('0x80')]){_0x11f460[_0x5d36cf[_0xd237('0x7b')][_0x327930][_0xd237('0x7d')]](_0x5d36cf['joins'][_0x327930][_0xd237('0x7f')],null,util['format'](_0xd237('0xa4'),_0x5d36cf[_0xd237('0x70')],_0x5d36cf[_0xd237('0x7b')][_0x327930][_0xd237('0x7e')],_0x5d36cf['joins'][_0x327930][_0xd237('0x7f')],_0x5d36cf[_0xd237('0x7b')][_0x327930][_0xd237('0x80')]));}}}if(_0x5d36cf[_0xd237('0x81')]){_0x5d36cf[_0xd237('0x81')]=JSON[_0xd237('0x7c')](_0x5d36cf[_0xd237('0x81')]);_0x11f460[_0xd237('0x36')](_0x25e76d(_0x5d36cf[_0xd237('0x81')][_0xd237('0x77')]));}_0x871c60=_0x11f460['clone']();_0x11f460['limit'](_0x4c926c);_0x11f460[_0xd237('0x1f')](0x0);logger[_0xd237('0x82')](_0xd237('0x83'),_0x11f460['toString']());return db[_0xd237('0x85')]['query'](_0x11f460[_0xd237('0x84')](),{'type':db['sequelize'][_0xd237('0x86')][_0xd237('0x8b')]});}})[_0xd237('0x25')](function(){return{'sql':_0x871c60[_0xd237('0x84')]()};})[_0xd237('0x25')](respondWithResult(_0x3fd54e,null))[_0xd237('0x41')](handleError(_0x3fd54e,null));};
git://repos.xcallymotion.com / motion2.git / blob