// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6cf8=['GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','UNIX_TIMESTAMP(%s)','includes','IS\x20NOT\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','operator','group','condition','value','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','table','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','outer_join','COUNT(DISTINCT\x20%s)','MIN(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','HOUR(%s)','ROUND(%s)','IS\x20NULL','QueryTypes','SELECT','No\x20available\x20data','output','web','fullPath','%s-%s.%s','randomstring','generate','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../components/export/','../../files/reports','savename','countTable','COUNT(*)','runReport','SEC_TO_TIME(%s)','AnalyticMetric','alias','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','lodash','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../config/logger','api','../../config/utils','../../mysqldb','status','end','json','count','offset','limit','reject','update','then','get','DefaultReports','UserProfileResource','destroy','stack','send','index','AnalyticDefaultReport','rawAttributes','model','query','dateStart','dateEnd','keys','attributes','intersection','fields','length','nolimit','order','sort','where','pick','filters','day','add','merge','filter','map','type','key','VIRTUAL','field','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','role','Reports','UserProfileSection','userProfileId','autoAssociation','name','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','join','left_join','right_join','cross_join','SUM(%s)','COUNT(%s)','MAX(%s)','AVG(%s)'];(function(_0x1a3cc7,_0x2900e3){var _0x338438=function(_0x5a4872){while(--_0x5a4872){_0x1a3cc7['push'](_0x1a3cc7['shift']());}};_0x338438(++_0x2900e3);}(_0x6cf8,0xf0));var _0x86cf=function(_0x5297a3,_0x49b863){_0x5297a3=_0x5297a3-0x0;var _0x21b181=_0x6cf8[_0x5297a3];return _0x21b181;};'use strict';var pdf=require(_0x86cf('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x86cf('0x1'));var zipdir=require(_0x86cf('0x2'));var jsonpatch=require(_0x86cf('0x3'));var rp=require(_0x86cf('0x4'));var moment=require(_0x86cf('0x5'));var BPromise=require(_0x86cf('0x6'));var Mustache=require(_0x86cf('0x7'));var util=require(_0x86cf('0x8'));var path=require(_0x86cf('0x9'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x86cf('0xa'));var fs=require('fs');var _=require(_0x86cf('0xb'));var squel=require('squel');var crypto=require(_0x86cf('0xc'));var jsforce=require(_0x86cf('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x86cf('0xe'));var querystring=require(_0x86cf('0xf'));var Papa=require(_0x86cf('0x10'));var Redis=require(_0x86cf('0x11'));var qs=require('../../components/parsers/qs');var logger=require(_0x86cf('0x12'))(_0x86cf('0x13'));var utils=require(_0x86cf('0x14'));var config=require('../../config/environment');var db=require(_0x86cf('0x15'))['db'];function respondWithStatusCode(_0x59caa9,_0x2a74ea){_0x2a74ea=_0x2a74ea||0xcc;return function(_0x1eee29){if(_0x1eee29){return _0x59caa9['sendStatus'](_0x2a74ea);}return _0x59caa9[_0x86cf('0x16')](_0x2a74ea)[_0x86cf('0x17')]();};}function respondWithResult(_0x376a4b,_0x20c594){_0x20c594=_0x20c594||0xc8;return function(_0x489192){if(_0x489192){return _0x376a4b['status'](_0x20c594)[_0x86cf('0x18')](_0x489192);}};}function respondWithFilteredResult(_0x3a1ce6,_0x413d78){return function(_0x1e4716){if(_0x1e4716){var _0x52d01d=_0x1e4716[_0x86cf('0x19')],_0x2258a0=_0x413d78[_0x86cf('0x1a')],_0x4e5451=_0x413d78[_0x86cf('0x1a')]+_0x413d78[_0x86cf('0x1b')],_0x16e3e8;if(_0x4e5451>=_0x52d01d){_0x4e5451=_0x52d01d;_0x16e3e8=0xc8;}else{_0x16e3e8=0xce;}_0x3a1ce6['status'](_0x16e3e8);return _0x3a1ce6['set']('Content-Range',_0x2258a0+'-'+_0x4e5451+'/'+_0x52d01d)[_0x86cf('0x18')](_0x1e4716);}return null;};}function patchUpdates(_0x3bf0d4){return function(_0x35ba7b){try{jsonpatch['apply'](_0x35ba7b,_0x3bf0d4,!![]);}catch(_0x95db4e){return BPromise[_0x86cf('0x1c')](_0x95db4e);}return _0x35ba7b['save']();};}function saveUpdates(_0x451b04,_0x128f09){return function(_0x4f5700){if(_0x4f5700){return _0x4f5700[_0x86cf('0x1d')](_0x451b04)['then'](function(_0x3cee7d){return _0x3cee7d;});}return null;};}function removeEntity(_0x41e99c,_0x44a8b8){return function(_0xcc4a54){if(_0xcc4a54){return _0xcc4a54['destroy']()[_0x86cf('0x1e')](function(){var _0x98fe28=_0xcc4a54[_0x86cf('0x1f')]({'plain':!![]});var _0xf66ce6=_0x86cf('0x20');return db[_0x86cf('0x21')][_0x86cf('0x22')]({'where':{'type':_0xf66ce6,'resourceId':_0x98fe28['id']}})['then'](function(){return _0xcc4a54;});})[_0x86cf('0x1e')](function(){_0x41e99c['status'](0xcc)[_0x86cf('0x17')]();});}};}function handleEntityNotFound(_0x4f11d0,_0x4a6314){return function(_0x489c1b){if(!_0x489c1b){_0x4f11d0['sendStatus'](0x194);}return _0x489c1b;};}function handleError(_0x261077,_0x41c294){_0x41c294=_0x41c294||0x1f4;return function(_0x480430){logger['error'](_0x480430[_0x86cf('0x23')]);if(_0x480430['name']){delete _0x480430['name'];}_0x261077[_0x86cf('0x16')](_0x41c294)[_0x86cf('0x24')](_0x480430);};}exports[_0x86cf('0x25')]=function(_0x575476,_0x15088c){var _0x38831c={},_0x535dd4={},_0x513eb9={'count':0x0,'rows':[]};var _0x2635ae=db[_0x86cf('0x26')][_0x86cf('0x27')];_0x535dd4[_0x86cf('0x28')]=_['keys'](_0x2635ae);var _0x3c96a6={'dateStart':_0x575476[_0x86cf('0x29')][_0x86cf('0x2a')],'dateEnd':_0x575476['query'][_0x86cf('0x2b')]};delete _0x575476['query']['dateStart'];delete _0x575476[_0x86cf('0x29')][_0x86cf('0x2b')];_0x535dd4['query']=_[_0x86cf('0x2c')](_0x575476['query']);_0x535dd4['filters']=_['intersection'](_0x535dd4[_0x86cf('0x28')],_0x535dd4[_0x86cf('0x29')]);_0x38831c[_0x86cf('0x2d')]=_[_0x86cf('0x2e')](_0x535dd4[_0x86cf('0x28')],qs[_0x86cf('0x2f')](_0x575476[_0x86cf('0x29')]['fields']));_0x38831c[_0x86cf('0x2d')]=_0x38831c[_0x86cf('0x2d')][_0x86cf('0x30')]?_0x38831c[_0x86cf('0x2d')]:_0x535dd4[_0x86cf('0x28')];if(!_0x575476[_0x86cf('0x29')]['hasOwnProperty'](_0x86cf('0x31'))){_0x38831c[_0x86cf('0x1b')]=qs[_0x86cf('0x1b')](_0x575476[_0x86cf('0x29')][_0x86cf('0x1b')]);_0x38831c[_0x86cf('0x1a')]=qs[_0x86cf('0x1a')](_0x575476[_0x86cf('0x29')][_0x86cf('0x1a')]);}_0x38831c[_0x86cf('0x32')]=qs[_0x86cf('0x33')](_0x575476[_0x86cf('0x29')][_0x86cf('0x33')]);_0x38831c[_0x86cf('0x34')]=qs['filters'](_[_0x86cf('0x35')](_0x575476[_0x86cf('0x29')],_0x535dd4[_0x86cf('0x36')]));if(_0x3c96a6[_0x86cf('0x2a')]){if(_0x3c96a6['dateEnd']){_0x3c96a6[_0x86cf('0x2b')]=moment(_0x3c96a6[_0x86cf('0x2b')])['add'](0x1,_0x86cf('0x37'));}else{_0x3c96a6['dateEnd']=moment(_0x3c96a6[_0x86cf('0x2a')])[_0x86cf('0x38')](0x1,_0x86cf('0x37'));}_[_0x86cf('0x39')](_0x38831c[_0x86cf('0x34')],{'createdAt':{'$gte':_0x3c96a6[_0x86cf('0x2a')],'$lte':_0x3c96a6['dateEnd']}});}if(_0x575476[_0x86cf('0x29')][_0x86cf('0x3a')]){_0x38831c[_0x86cf('0x34')]=_[_0x86cf('0x39')](_0x38831c[_0x86cf('0x34')],{'$or':_[_0x86cf('0x3b')](_0x2635ae,function(_0x1844ee){if(_0x1844ee[_0x86cf('0x3c')][_0x86cf('0x3d')]!==_0x86cf('0x3e')){var _0x4a6807={};_0x4a6807[_0x1844ee[_0x86cf('0x3f')]]={'$like':'%'+_0x575476[_0x86cf('0x29')]['filter']+'%'};return _0x4a6807;}})});}_0x38831c=_[_0x86cf('0x39')]({},_0x38831c,_0x575476[_0x86cf('0x40')]);var _0x4e94bb={'where':_0x38831c[_0x86cf('0x34')]};return db[_0x86cf('0x26')][_0x86cf('0x19')](_0x4e94bb)['then'](function(_0x4a14ef){_0x513eb9[_0x86cf('0x19')]=_0x4a14ef;if(_0x575476[_0x86cf('0x29')][_0x86cf('0x41')]){_0x38831c[_0x86cf('0x42')]=[{'all':!![]}];}return db[_0x86cf('0x26')][_0x86cf('0x43')](_0x38831c);})['then'](function(_0x2319a2){_0x513eb9[_0x86cf('0x44')]=_0x2319a2;return _0x513eb9;})[_0x86cf('0x1e')](respondWithFilteredResult(_0x15088c,_0x38831c))[_0x86cf('0x45')](handleError(_0x15088c,null));};exports[_0x86cf('0x46')]=function(_0x17ceb6,_0x105c90){var _0x2ec028={'raw':!![],'where':{'id':_0x17ceb6[_0x86cf('0x47')]['id']}},_0x465996={};_0x465996['model']=_[_0x86cf('0x2c')](db[_0x86cf('0x26')][_0x86cf('0x27')]);_0x465996[_0x86cf('0x29')]=_[_0x86cf('0x2c')](_0x17ceb6[_0x86cf('0x29')]);_0x465996['filters']=_['intersection'](_0x465996[_0x86cf('0x28')],_0x465996['query']);_0x2ec028[_0x86cf('0x2d')]=_[_0x86cf('0x2e')](_0x465996['model'],qs[_0x86cf('0x2f')](_0x17ceb6[_0x86cf('0x29')][_0x86cf('0x2f')]));_0x2ec028['attributes']=_0x2ec028['attributes'][_0x86cf('0x30')]?_0x2ec028[_0x86cf('0x2d')]:_0x465996['model'];if(_0x17ceb6[_0x86cf('0x29')]['includeAll']){_0x2ec028[_0x86cf('0x42')]=[{'all':!![]}];}_0x2ec028=_[_0x86cf('0x39')]({},_0x2ec028,_0x17ceb6[_0x86cf('0x40')]);return db[_0x86cf('0x26')][_0x86cf('0x48')](_0x2ec028)[_0x86cf('0x1e')](handleEntityNotFound(_0x105c90,null))[_0x86cf('0x1e')](respondWithResult(_0x105c90,null))[_0x86cf('0x45')](handleError(_0x105c90,null));};exports[_0x86cf('0x49')]=function(_0x2756bd,_0xadffbc){return db[_0x86cf('0x26')][_0x86cf('0x49')](_0x2756bd[_0x86cf('0x4a')],{})['then'](function(_0x3dc6d8){var _0x1ae81a=_0x2756bd[_0x86cf('0x4b')][_0x86cf('0x1f')]({'plain':!![]});if(!_0x1ae81a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1ae81a[_0x86cf('0x4c')]==='user'){var _0x1beb52=_0x3dc6d8[_0x86cf('0x1f')]({'plain':!![]});var _0x40f36f=_0x86cf('0x4d');return db[_0x86cf('0x4e')]['find']({'where':{'name':_0x40f36f,'userProfileId':_0x1ae81a[_0x86cf('0x4f')]},'raw':!![]})[_0x86cf('0x1e')](function(_0xf02a81){if(_0xf02a81&&_0xf02a81[_0x86cf('0x50')]===0x0){return db[_0x86cf('0x21')][_0x86cf('0x49')]({'name':_0x1beb52[_0x86cf('0x51')],'resourceId':_0x1beb52['id'],'type':_0x86cf('0x20'),'sectionId':_0xf02a81['id']},{})[_0x86cf('0x1e')](function(){return _0x3dc6d8;});}else{return _0x3dc6d8;}})[_0x86cf('0x45')](function(_0x40ec7a){logger[_0x86cf('0x52')](_0x86cf('0x53'),_0x40ec7a);throw _0x40ec7a;});}return _0x3dc6d8;})[_0x86cf('0x1e')](respondWithResult(_0xadffbc,0xc9))['catch'](handleError(_0xadffbc,null));};exports[_0x86cf('0x1d')]=function(_0x27b1af,_0x5a7951){if(_0x27b1af['body']['id']){delete _0x27b1af[_0x86cf('0x4a')]['id'];}return db['AnalyticDefaultReport']['find']({'where':{'id':_0x27b1af[_0x86cf('0x47')]['id']}})[_0x86cf('0x1e')](handleEntityNotFound(_0x5a7951,null))[_0x86cf('0x1e')](saveUpdates(_0x27b1af[_0x86cf('0x4a')],null))[_0x86cf('0x1e')](respondWithResult(_0x5a7951,null))[_0x86cf('0x45')](handleError(_0x5a7951,null));};exports[_0x86cf('0x22')]=function(_0x1345e4,_0x162f44){return db[_0x86cf('0x26')]['find']({'where':{'id':_0x1345e4[_0x86cf('0x47')]['id']}})[_0x86cf('0x1e')](handleEntityNotFound(_0x162f44,null))[_0x86cf('0x1e')](removeEntity(_0x162f44,null))['catch'](handleError(_0x162f44,null));};exports['preview']=function(_0x5bdb75,_0x556749){var _0x46be01=0xa;var _0x35c603=[_0x86cf('0x54'),_0x86cf('0x55'),_0x86cf('0x56'),'outer_join',_0x86cf('0x57')];var _0x615e11={'SUM':_0x86cf('0x58'),'COUNT':_0x86cf('0x59'),'COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x86cf('0x5a'),'MIN':'MIN(%s)','AVG':_0x86cf('0x5b'),'GROUP_CONCAT':_0x86cf('0x5c'),'GROUP_CONCAT ASC':_0x86cf('0x5d'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x39b11a={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x86cf('0x5e')};var _0x13a8c8=function(_0x5d8e2b){return!_[_0x86cf('0x5f')](['IS\x20NULL',_0x86cf('0x60'),_0x86cf('0x61'),_0x86cf('0x62')],_0x5d8e2b);};var _0x391ced=function(_0x2f5d5b){if(!_0x2f5d5b||!_0x2f5d5b[_0x86cf('0x63')][_0x86cf('0x30')]){return'';}for(var _0x32172e='(',_0x2d78e2=0x0;_0x2d78e2<_0x2f5d5b[_0x86cf('0x63')][_0x86cf('0x30')];_0x2d78e2+=0x1){_0x2d78e2>0x0&&(_0x32172e+='\x20'+_0x2f5d5b[_0x86cf('0x64')]+'\x20');_0x32172e+=_0x2f5d5b['rules'][_0x2d78e2][_0x86cf('0x65')]?_0x391ced(_0x2f5d5b['rules'][_0x2d78e2][_0x86cf('0x65')]):_0x2f5d5b[_0x86cf('0x63')][_0x2d78e2][_0x86cf('0x3f')]+'\x20'+_0x2f5d5b[_0x86cf('0x63')][_0x2d78e2][_0x86cf('0x66')]+(_0x13a8c8(_0x2f5d5b[_0x86cf('0x63')][_0x2d78e2][_0x86cf('0x66')])?'\x20'+_0x2f5d5b[_0x86cf('0x63')][_0x2d78e2][_0x86cf('0x67')]:'');}return _0x32172e+')';};var _0x49a3d5={'where':{'id':_0x5bdb75[_0x86cf('0x47')]['id']}},_0x334161,_0x1306ec,_0x344906,_0x59b6f2,_0x259e7f;_0x49a3d5=_['merge']({},_0x49a3d5,_0x5bdb75[_0x86cf('0x40')]);return db['AnalyticDefaultReport'][_0x86cf('0x48')](_0x49a3d5)[_0x86cf('0x1e')](function(_0x384a13){if(_0x384a13){_0x334161=_0x384a13;return _0x384a13[_0x86cf('0x68')]();}return null;})[_0x86cf('0x1e')](function(_0x11675e){if(_0x11675e){if(!_0x11675e[_0x86cf('0x30')]){throw new db[(_0x86cf('0x69'))][(_0x86cf('0x6a'))](_0x86cf('0x6b'),0x193);}_0x1306ec=_0x11675e;return db['AnalyticMetric'][_0x86cf('0x43')]({'raw':!![]});}return null;})[_0x86cf('0x1e')](function(_0x3e2be5){if(_0x3e2be5){_0x344906=_[_0x86cf('0x6c')](_0x3e2be5,'id');var _0x7b1ea9;var _0x27ba64=squel[_0x86cf('0x6d')]();_0x27ba64[_0x86cf('0x6e')](_0x334161['table']);for(var _0x2459ab=0x0;_0x2459ab<_0x1306ec[_0x86cf('0x30')];_0x2459ab+=0x1){_0x7b1ea9=_0x1306ec[_0x2459ab][_0x86cf('0x6f')]?_0x344906[_0x1306ec[_0x2459ab][_0x86cf('0x6f')]][_0x86cf('0x70')]:_0x1306ec[_0x2459ab]['field'];_0x7b1ea9=_0x1306ec[_0x2459ab][_0x86cf('0x71')]?_[_0x86cf('0x72')](_0x615e11[_0x1306ec[_0x2459ab][_0x86cf('0x71')]],'%s',_0x7b1ea9):_0x7b1ea9;_0x7b1ea9=_0x1306ec[_0x2459ab]['format']?_[_0x86cf('0x72')](_0x39b11a[_0x1306ec[_0x2459ab][_0x86cf('0x73')]],'%s',_0x7b1ea9):_0x7b1ea9;if(_0x1306ec[_0x2459ab][_0x86cf('0x74')]){_0x27ba64[_0x86cf('0x65')](_0x7b1ea9);}_0x1306ec[_0x2459ab][_0x86cf('0x75')]&&_0x27ba64[_0x86cf('0x32')](_0x7b1ea9,_0x1306ec[_0x2459ab][_0x86cf('0x75')]===_0x86cf('0x76')?![]:!![]);_0x27ba64[_0x86cf('0x3f')](_0x7b1ea9,_0x1306ec[_0x2459ab]['alias']||_0x7b1ea9);}if(_0x334161['joins']){_0x334161[_0x86cf('0x77')]=JSON[_0x86cf('0x78')](_0x334161[_0x86cf('0x77')]);for(var _0x19c7ca=0x0;_0x19c7ca<_0x334161[_0x86cf('0x77')]['length'];_0x19c7ca+=0x1){if(_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x3c')]&&_[_0x86cf('0x5f')](_0x35c603,_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x3c')])&&_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x79')]&&_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x7a')]&&_0x334161[_0x86cf('0x77')][_0x19c7ca]['foreignKey']){_0x27ba64[_0x334161[_0x86cf('0x77')][_0x19c7ca]['type']](_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x7a')],null,util[_0x86cf('0x73')](_0x86cf('0x7b'),_0x334161[_0x86cf('0x7c')],_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x79')],_0x334161[_0x86cf('0x77')][_0x19c7ca]['foreignTable'],_0x334161[_0x86cf('0x77')][_0x19c7ca][_0x86cf('0x7d')]));}}}if(_0x334161[_0x86cf('0x7e')]){_0x334161[_0x86cf('0x7e')]=JSON[_0x86cf('0x78')](_0x334161['conditions']);_0x27ba64[_0x86cf('0x34')](_0x391ced(_0x334161[_0x86cf('0x7e')][_0x86cf('0x65')]));}_0x259e7f=_0x27ba64[_0x86cf('0x7f')]();_0x27ba64[_0x86cf('0x1b')](_0x46be01);_0x27ba64[_0x86cf('0x1a')](0x0);logger[_0x86cf('0x80')](_0x86cf('0x81'),_0x27ba64[_0x86cf('0x82')]());return db[_0x86cf('0x83')][_0x86cf('0x29')](_0x27ba64['toString'](),{'type':db['sequelize']['QueryTypes']['SELECT']});}})[_0x86cf('0x1e')](respondWithResult(_0x556749,null))[_0x86cf('0x45')](handleError(_0x556749,null));};function runReport(_0x24d9f3,_0x13f32,_0x2fac7e){var _0x2d7f8d=_0x13f32[_0x86cf('0x51')];var _0x248ac5=0xa;var _0x46749f=['join',_0x86cf('0x55'),_0x86cf('0x56'),_0x86cf('0x84'),_0x86cf('0x57')];var _0x1543bc={'SUM':'SUM(%s)','COUNT':_0x86cf('0x59'),'COUNT DISTINCT':_0x86cf('0x85'),'MAX':_0x86cf('0x5a'),'MIN':_0x86cf('0x86'),'AVG':_0x86cf('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x86cf('0x5d'),'GROUP_CONCAT DESC':_0x86cf('0x87')};var _0x36f622={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x86cf('0x88'),'HOUR':_0x86cf('0x89'),'ROUND':_0x86cf('0x8a'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x216da0=function(_0x57ce44){return!_[_0x86cf('0x5f')]([_0x86cf('0x8b'),_0x86cf('0x60'),_0x86cf('0x61'),'IS\x20NOT\x20EMPTY'],_0x57ce44);};var _0x38e86a=function(_0x42a7f4){if(!_0x42a7f4||!_0x42a7f4['rules']['length']){return'';}for(var _0x34dd45='(',_0xf37646=0x0;_0xf37646<_0x42a7f4[_0x86cf('0x63')][_0x86cf('0x30')];_0xf37646+=0x1){_0xf37646>0x0&&(_0x34dd45+='\x20'+_0x42a7f4[_0x86cf('0x64')]+'\x20');_0x34dd45+=_0x42a7f4[_0x86cf('0x63')][_0xf37646][_0x86cf('0x65')]?_0x38e86a(_0x42a7f4[_0x86cf('0x63')][_0xf37646][_0x86cf('0x65')]):_0x42a7f4[_0x86cf('0x63')][_0xf37646]['field']+'\x20'+_0x42a7f4['rules'][_0xf37646][_0x86cf('0x66')]+(_0x216da0(_0x42a7f4[_0x86cf('0x63')][_0xf37646][_0x86cf('0x66')])?'\x20'+_0x42a7f4['rules'][_0xf37646][_0x86cf('0x67')]:'');}return _0x34dd45+')';};var _0x56997a={'where':{'id':_0x24d9f3['id']}},_0x3365a1,_0x2a26e8,_0x48f4a8,_0x3c95e2,_0x5e0d27;_0x56997a=_['merge']({},_0x56997a,_0x2fac7e);return db[_0x86cf('0x26')]['find'](_0x56997a)[_0x86cf('0x1e')](function(_0x5871bc){if(_0x5871bc){_0x3365a1=_0x5871bc;return _0x5871bc[_0x86cf('0x68')]();}return null;})[_0x86cf('0x1e')](function(_0x28d331){if(_0x28d331){if(!_0x28d331[_0x86cf('0x30')]){throw new db[(_0x86cf('0x69'))][(_0x86cf('0x6a'))](_0x86cf('0x6b'),0x193);}_0x2a26e8=_0x28d331;return db['AnalyticMetric']['findAll']({'raw':!![]});}return null;})['then'](function(_0x4ce976){if(_0x4ce976){_0x48f4a8=_['keyBy'](_0x4ce976,'id');var _0x3e40e8;var _0x578b1d=squel['select']();_0x578b1d[_0x86cf('0x6e')](_0x3365a1['table']);for(var _0x265746=0x0;_0x265746<_0x2a26e8['length'];_0x265746+=0x1){_0x3e40e8=_0x2a26e8[_0x265746][_0x86cf('0x6f')]?_0x48f4a8[_0x2a26e8[_0x265746][_0x86cf('0x6f')]]['metric']:_0x2a26e8[_0x265746][_0x86cf('0x3f')];_0x3e40e8=_0x2a26e8[_0x265746]['function']?_['replace'](_0x1543bc[_0x2a26e8[_0x265746][_0x86cf('0x71')]],'%s',_0x3e40e8):_0x3e40e8;_0x3e40e8=_0x2a26e8[_0x265746]['format']?_[_0x86cf('0x72')](_0x36f622[_0x2a26e8[_0x265746]['format']],'%s',_0x3e40e8):_0x3e40e8;if(_0x2a26e8[_0x265746]['groupBy']){_0x578b1d[_0x86cf('0x65')](_0x3e40e8);}_0x2a26e8[_0x265746][_0x86cf('0x75')]&&_0x578b1d[_0x86cf('0x32')](_0x3e40e8,_0x2a26e8[_0x265746][_0x86cf('0x75')]===_0x86cf('0x76')?![]:!![]);_0x578b1d[_0x86cf('0x3f')](_0x3e40e8,_0x2a26e8[_0x265746]['alias']||_0x3e40e8);}if(_0x3365a1['joins']){_0x3365a1[_0x86cf('0x77')]=JSON['parse'](_0x3365a1['joins']);for(var _0x4d882f=0x0;_0x4d882f<_0x3365a1[_0x86cf('0x77')][_0x86cf('0x30')];_0x4d882f+=0x1){if(_0x3365a1[_0x86cf('0x77')][_0x4d882f][_0x86cf('0x3c')]&&_[_0x86cf('0x5f')](_0x46749f,_0x3365a1[_0x86cf('0x77')][_0x4d882f]['type'])&&_0x3365a1['joins'][_0x4d882f]['parentKey']&&_0x3365a1[_0x86cf('0x77')][_0x4d882f][_0x86cf('0x7a')]&&_0x3365a1['joins'][_0x4d882f][_0x86cf('0x7d')]){_0x578b1d[_0x3365a1[_0x86cf('0x77')][_0x4d882f][_0x86cf('0x3c')]](_0x3365a1[_0x86cf('0x77')][_0x4d882f][_0x86cf('0x7a')],null,util[_0x86cf('0x73')](_0x86cf('0x7b'),_0x3365a1[_0x86cf('0x7c')],_0x3365a1[_0x86cf('0x77')][_0x4d882f]['parentKey'],_0x3365a1['joins'][_0x4d882f][_0x86cf('0x7a')],_0x3365a1[_0x86cf('0x77')][_0x4d882f][_0x86cf('0x7d')]));}}}if(_0x3365a1[_0x86cf('0x7e')]){_0x3365a1[_0x86cf('0x7e')]=JSON[_0x86cf('0x78')](_0x3365a1[_0x86cf('0x7e')]);_0x578b1d['where'](_0x38e86a(_0x3365a1[_0x86cf('0x7e')][_0x86cf('0x65')]));}_0x5e0d27=_0x578b1d[_0x86cf('0x7f')]();_0x578b1d[_0x86cf('0x1b')](_0x248ac5);_0x578b1d[_0x86cf('0x1a')](0x0);logger[_0x86cf('0x80')](_0x86cf('0x81'),_0x578b1d[_0x86cf('0x82')]());return db[_0x86cf('0x83')][_0x86cf('0x29')](_0x578b1d[_0x86cf('0x82')](),{'type':db[_0x86cf('0x83')][_0x86cf('0x8c')][_0x86cf('0x8d')]});}})[_0x86cf('0x1e')](function(_0x2c3fbe){if(!_0x2c3fbe['length']){throw new db[(_0x86cf('0x69'))]['ValidationErrorItem'](_0x86cf('0x8e'),0xcc);}if(_0x13f32[_0x86cf('0x8f')]===_0x86cf('0x90')){return null;}var _0x32f09a=_[_0x86cf('0x39')](_0x13f32,{'name':_0x13f32[_0x86cf('0x91')]||_0x13f32[_0x86cf('0x51')]||_0x3365a1['name'],'basename':_0x2d7f8d,'savename':util[_0x86cf('0x73')](_0x86cf('0x92'),_0x13f32[_0x86cf('0x51')]||_0x3365a1[_0x86cf('0x51')],require(_0x86cf('0x93'))[_0x86cf('0x94')](0x4),_0x13f32[_0x86cf('0x8f')]||'csv'),'reportId':_0x3365a1['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0x86cf('0x49')](_0x32f09a,{'raw':!![]});})[_0x86cf('0x1e')](function(_0x54c167){if(_0x3365a1[_0x86cf('0x7c')]===_0x86cf('0x95')){_0x5e0d27[_0x86cf('0x34')](_0x3365a1[_0x86cf('0x7c')]+_0x86cf('0x96'),_0x13f32[_0x86cf('0x97')],_0x13f32[_0x86cf('0x98')]);}else{_0x5e0d27[_0x86cf('0x34')](_0x3365a1['table']+_0x86cf('0x99'),_0x13f32[_0x86cf('0x97')],_0x13f32['endDate']);}if(_0x54c167){logger[_0x86cf('0x9a')](_0x86cf('0x9b'),_0x5e0d27['toString']());require(_0x86cf('0x9c'))['fork'](path[_0x86cf('0x54')](__dirname,_0x86cf('0x9d'),_0x54c167['output']),[_0x54c167['id'],_0x5e0d27[_0x86cf('0x82')](),path[_0x86cf('0x54')](__dirname,_0x86cf('0x9e'),_0x54c167[_0x86cf('0x9f')]),_0x2d7f8d]);return _0x54c167;}else{var _0x27729c=squel[_0x86cf('0x6d')]();_0x27729c[_0x86cf('0x6e')]('('+_0x5e0d27[_0x86cf('0x82')]()+')',_0x86cf('0xa0'));_0x27729c[_0x86cf('0x3f')](_0x86cf('0xa1'),_0x86cf('0x19'));_0x5e0d27[_0x86cf('0x1b')](_0x13f32[_0x86cf('0x1b')]||_0x248ac5);_0x5e0d27[_0x86cf('0x1a')](_0x13f32['offset']||0x0);return db[_0x86cf('0x83')]['query'](_0x27729c[_0x86cf('0x82')](),{'type':db[_0x86cf('0x83')][_0x86cf('0x8c')]['SELECT']})['then'](function(_0x179215){if(!_0x179215[_0x86cf('0x30')]){_0x3c95e2=0x0;}else{_0x3c95e2=_0x179215[0x0][_0x86cf('0x19')]||0x0;}return db[_0x86cf('0x83')][_0x86cf('0x29')](_0x5e0d27[_0x86cf('0x82')](),{'type':db[_0x86cf('0x83')][_0x86cf('0x8c')][_0x86cf('0x8d')]});})[_0x86cf('0x1e')](function(_0x380dc0){return{'rows':_0x380dc0||[],'count':_0x3c95e2};});}});}exports['run']=function(_0x5ce205,_0x415c24){return runReport(_0x5ce205[_0x86cf('0x47')],_0x5ce205[_0x86cf('0x29')],_0x5ce205['options'])[_0x86cf('0x1e')](respondWithResult(_0x415c24,null))[_0x86cf('0x45')](handleError(_0x415c24,null));};exports[_0x86cf('0xa2')]=runReport;exports[_0x86cf('0x29')]=function(_0x415572,_0x15318f){var _0x472fad=0xa;var _0x113851=[_0x86cf('0x54'),_0x86cf('0x55'),_0x86cf('0x56'),_0x86cf('0x84'),_0x86cf('0x57')];var _0xbd26aa={'SUM':_0x86cf('0x58'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':'MIN(%s)','AVG':_0x86cf('0x5b'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0x86cf('0x5d'),'GROUP_CONCAT DESC':_0x86cf('0x87')};var _0x3dd7b8={'SEC_TO_TIME':_0x86cf('0xa3'),'DATE':_0x86cf('0x88'),'HOUR':_0x86cf('0x89'),'ROUND':_0x86cf('0x8a'),'UNIX_TIMESTAMP':_0x86cf('0x5e')};var _0x39b3a5=function(_0x306c2c){return!_[_0x86cf('0x5f')]([_0x86cf('0x8b'),'IS\x20NOT\x20NULL',_0x86cf('0x61'),_0x86cf('0x62')],_0x306c2c);};var _0x453c19=function(_0x135833){if(!_0x135833||!_0x135833[_0x86cf('0x63')][_0x86cf('0x30')]){return'';}for(var _0x10c6d6='(',_0x2cb7fb=0x0;_0x2cb7fb<_0x135833['rules']['length'];_0x2cb7fb+=0x1){_0x2cb7fb>0x0&&(_0x10c6d6+='\x20'+_0x135833['operator']+'\x20');_0x10c6d6+=_0x135833[_0x86cf('0x63')][_0x2cb7fb][_0x86cf('0x65')]?_0x453c19(_0x135833['rules'][_0x2cb7fb][_0x86cf('0x65')]):_0x135833[_0x86cf('0x63')][_0x2cb7fb][_0x86cf('0x3f')]+'\x20'+_0x135833[_0x86cf('0x63')][_0x2cb7fb][_0x86cf('0x66')]+(_0x39b3a5(_0x135833[_0x86cf('0x63')][_0x2cb7fb][_0x86cf('0x66')])?'\x20'+_0x135833[_0x86cf('0x63')][_0x2cb7fb]['value']:'');}return _0x10c6d6+')';};var _0x25a404={'where':{'id':_0x415572['params']['id']}},_0x11c207,_0x178e2a,_0x3341ca,_0x56fa92,_0x187f9e;_0x25a404=_['merge']({},_0x25a404,_0x415572[_0x86cf('0x40')]);return db[_0x86cf('0x26')][_0x86cf('0x48')](_0x25a404)[_0x86cf('0x1e')](function(_0x1825aa){if(_0x1825aa){_0x11c207=_0x1825aa;return _0x1825aa['getFields']();}return null;})[_0x86cf('0x1e')](function(_0xee205f){if(_0xee205f){if(!_0xee205f[_0x86cf('0x30')]){throw new db['Sequelize']['ValidationErrorItem'](_0x86cf('0x6b'),0x193);}_0x178e2a=_0xee205f;return db[_0x86cf('0xa4')]['findAll']({'raw':!![]});}return null;})[_0x86cf('0x1e')](function(_0x144337){if(_0x144337){_0x3341ca=_[_0x86cf('0x6c')](_0x144337,'id');var _0x206fb7;var _0x3d8ffa=squel['select']();_0x3d8ffa[_0x86cf('0x6e')](_0x11c207[_0x86cf('0x7c')]);for(var _0x4d804e=0x0;_0x4d804e<_0x178e2a[_0x86cf('0x30')];_0x4d804e+=0x1){_0x206fb7=_0x178e2a[_0x4d804e]['MetricId']?_0x3341ca[_0x178e2a[_0x4d804e]['MetricId']][_0x86cf('0x70')]:_0x178e2a[_0x4d804e][_0x86cf('0x3f')];_0x206fb7=_0x178e2a[_0x4d804e][_0x86cf('0x71')]?_[_0x86cf('0x72')](_0xbd26aa[_0x178e2a[_0x4d804e][_0x86cf('0x71')]],'%s',_0x206fb7):_0x206fb7;_0x206fb7=_0x178e2a[_0x4d804e][_0x86cf('0x73')]?_[_0x86cf('0x72')](_0x3dd7b8[_0x178e2a[_0x4d804e][_0x86cf('0x73')]],'%s',_0x206fb7):_0x206fb7;if(_0x178e2a[_0x4d804e][_0x86cf('0x74')]){_0x3d8ffa['group'](_0x206fb7);}_0x178e2a[_0x4d804e]['orderBy']&&_0x3d8ffa[_0x86cf('0x32')](_0x206fb7,_0x178e2a[_0x4d804e][_0x86cf('0x75')]==='DESC'?![]:!![]);_0x3d8ffa['field'](_0x206fb7,_0x178e2a[_0x4d804e][_0x86cf('0xa5')]||_0x206fb7);}if(_0x11c207[_0x86cf('0x77')]){_0x11c207[_0x86cf('0x77')]=JSON['parse'](_0x11c207['joins']);for(var _0x20dd82=0x0;_0x20dd82<_0x11c207[_0x86cf('0x77')][_0x86cf('0x30')];_0x20dd82+=0x1){if(_0x11c207[_0x86cf('0x77')][_0x20dd82][_0x86cf('0x3c')]&&_[_0x86cf('0x5f')](_0x113851,_0x11c207['joins'][_0x20dd82][_0x86cf('0x3c')])&&_0x11c207['joins'][_0x20dd82]['parentKey']&&_0x11c207[_0x86cf('0x77')][_0x20dd82][_0x86cf('0x7a')]&&_0x11c207[_0x86cf('0x77')][_0x20dd82]['foreignKey']){_0x3d8ffa[_0x11c207['joins'][_0x20dd82][_0x86cf('0x3c')]](_0x11c207[_0x86cf('0x77')][_0x20dd82][_0x86cf('0x7a')],null,util[_0x86cf('0x73')](_0x86cf('0x7b'),_0x11c207['table'],_0x11c207['joins'][_0x20dd82][_0x86cf('0x79')],_0x11c207['joins'][_0x20dd82][_0x86cf('0x7a')],_0x11c207[_0x86cf('0x77')][_0x20dd82]['foreignKey']));}}}if(_0x11c207['conditions']){_0x11c207[_0x86cf('0x7e')]=JSON[_0x86cf('0x78')](_0x11c207[_0x86cf('0x7e')]);_0x3d8ffa[_0x86cf('0x34')](_0x453c19(_0x11c207['conditions']['group']));}_0x187f9e=_0x3d8ffa['clone']();_0x3d8ffa['limit'](_0x472fad);_0x3d8ffa[_0x86cf('0x1a')](0x0);logger[_0x86cf('0x80')]('Limited\x20Query:',_0x3d8ffa[_0x86cf('0x82')]());return db['sequelize'][_0x86cf('0x29')](_0x3d8ffa[_0x86cf('0x82')](),{'type':db['sequelize'][_0x86cf('0x8c')][_0x86cf('0x8d')]});}})[_0x86cf('0x1e')](function(){return{'sql':_0x187f9e[_0x86cf('0x82')]()};})[_0x86cf('0x1e')](respondWithResult(_0x15318f,null))[_0x86cf('0x45')](handleError(_0x15318f,null));};
\ No newline at end of file
+var _0x1db8=['end','json','count','offset','status','Content-Range','apply','reject','update','then','destroy','get','DefaultReports','UserProfileResource','stack','name','send','index','model','keys','query','dateStart','dateEnd','filters','intersection','attributes','fields','length','nolimit','limit','order','sort','add','day','merge','where','filter','field','options','include','AnalyticDefaultReport','findAll','rows','catch','show','params','rawAttributes','find','create','body','user','role','Reports','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','preview','join','left_join','right_join','cross_join','SUM(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','ROUND(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20NOT\x20NULL','rules','group','condition','getFields','Sequelize','AnalyticMetric','select','from','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','type','parentKey','foreignTable','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','SELECT','outer_join','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','DATE(%s)','IS\x20EMPTY','operator','value','Please\x20insert\x20at\x20least\x20one\x20field','keyBy','table','QueryTypes','No\x20available\x20data','web','fullPath','generate','csv','cdr','startDate','endDate','info','Run\x20Query:','child_process','../../components/export/','output','../../files/reports','savename','COUNT(*)','run','COUNT(%s)','SEC_TO_TIME(%s)','HOUR(%s)','IS\x20NOT\x20EMPTY','%s.%s\x20=\x20%s.%s','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','ejs','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment'];(function(_0x5189b5,_0x129c83){var _0x29203f=function(_0xd8b9f9){while(--_0xd8b9f9){_0x5189b5['push'](_0x5189b5['shift']());}};_0x29203f(++_0x129c83);}(_0x1db8,0x1c9));var _0x81db=function(_0x122ef9,_0x451d2a){_0x122ef9=_0x122ef9-0x0;var _0x42fba0=_0x1db8[_0x122ef9];return _0x42fba0;};'use strict';var pdf=require(_0x81db('0x0'));var emlformat=require(_0x81db('0x1'));var rimraf=require(_0x81db('0x2'));var zipdir=require(_0x81db('0x3'));var jsonpatch=require(_0x81db('0x4'));var rp=require('request-promise');var moment=require(_0x81db('0x5'));var BPromise=require(_0x81db('0x6'));var Mustache=require(_0x81db('0x7'));var util=require(_0x81db('0x8'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x81db('0x9'));var fs=require('fs');var _=require(_0x81db('0xa'));var squel=require(_0x81db('0xb'));var crypto=require(_0x81db('0xc'));var jsforce=require(_0x81db('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x81db('0xe'));var querystring=require(_0x81db('0xf'));var Papa=require(_0x81db('0x10'));var Redis=require(_0x81db('0x11'));var qs=require(_0x81db('0x12'));var logger=require(_0x81db('0x13'))(_0x81db('0x14'));var utils=require(_0x81db('0x15'));var config=require(_0x81db('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x30d6df,_0x1e903c){_0x1e903c=_0x1e903c||0xcc;return function(_0x495f79){if(_0x495f79){return _0x30d6df['sendStatus'](_0x1e903c);}return _0x30d6df['status'](_0x1e903c)[_0x81db('0x17')]();};}function respondWithResult(_0x11b0cb,_0x46be43){_0x46be43=_0x46be43||0xc8;return function(_0x1cfe65){if(_0x1cfe65){return _0x11b0cb['status'](_0x46be43)[_0x81db('0x18')](_0x1cfe65);}};}function respondWithFilteredResult(_0x3cfb3b,_0x16b388){return function(_0x56e2e5){if(_0x56e2e5){var _0x97ffa7=_0x56e2e5[_0x81db('0x19')],_0x444164=_0x16b388[_0x81db('0x1a')],_0x583efe=_0x16b388[_0x81db('0x1a')]+_0x16b388['limit'],_0x50f7ce;if(_0x583efe>=_0x97ffa7){_0x583efe=_0x97ffa7;_0x50f7ce=0xc8;}else{_0x50f7ce=0xce;}_0x3cfb3b[_0x81db('0x1b')](_0x50f7ce);return _0x3cfb3b['set'](_0x81db('0x1c'),_0x444164+'-'+_0x583efe+'/'+_0x97ffa7)[_0x81db('0x18')](_0x56e2e5);}return null;};}function patchUpdates(_0x4a1447){return function(_0x151ffa){try{jsonpatch[_0x81db('0x1d')](_0x151ffa,_0x4a1447,!![]);}catch(_0x28676b){return BPromise[_0x81db('0x1e')](_0x28676b);}return _0x151ffa['save']();};}function saveUpdates(_0x36908a,_0x1b25f2){return function(_0x14b2e6){if(_0x14b2e6){return _0x14b2e6[_0x81db('0x1f')](_0x36908a)[_0x81db('0x20')](function(_0x209747){return _0x209747;});}return null;};}function removeEntity(_0x2b0e46,_0x1df348){return function(_0x4f9bd0){if(_0x4f9bd0){return _0x4f9bd0[_0x81db('0x21')]()[_0x81db('0x20')](function(){var _0xa2294b=_0x4f9bd0[_0x81db('0x22')]({'plain':!![]});var _0x460a4c=_0x81db('0x23');return db[_0x81db('0x24')][_0x81db('0x21')]({'where':{'type':_0x460a4c,'resourceId':_0xa2294b['id']}})[_0x81db('0x20')](function(){return _0x4f9bd0;});})[_0x81db('0x20')](function(){_0x2b0e46[_0x81db('0x1b')](0xcc)[_0x81db('0x17')]();});}};}function handleEntityNotFound(_0x2e2d39,_0x266b4f){return function(_0x3a38ae){if(!_0x3a38ae){_0x2e2d39['sendStatus'](0x194);}return _0x3a38ae;};}function handleError(_0x51a0a1,_0x3d6d96){_0x3d6d96=_0x3d6d96||0x1f4;return function(_0x57f287){logger['error'](_0x57f287[_0x81db('0x25')]);if(_0x57f287[_0x81db('0x26')]){delete _0x57f287[_0x81db('0x26')];}_0x51a0a1['status'](_0x3d6d96)[_0x81db('0x27')](_0x57f287);};}exports[_0x81db('0x28')]=function(_0x4f4229,_0x32a494){var _0x1501f1={},_0xcc44c6={},_0xaa9a0f={'count':0x0,'rows':[]};var _0x41fae1=db['AnalyticDefaultReport']['rawAttributes'];_0xcc44c6[_0x81db('0x29')]=_[_0x81db('0x2a')](_0x41fae1);var _0x497c62={'dateStart':_0x4f4229[_0x81db('0x2b')][_0x81db('0x2c')],'dateEnd':_0x4f4229[_0x81db('0x2b')][_0x81db('0x2d')]};delete _0x4f4229[_0x81db('0x2b')][_0x81db('0x2c')];delete _0x4f4229['query'][_0x81db('0x2d')];_0xcc44c6[_0x81db('0x2b')]=_[_0x81db('0x2a')](_0x4f4229[_0x81db('0x2b')]);_0xcc44c6[_0x81db('0x2e')]=_[_0x81db('0x2f')](_0xcc44c6['model'],_0xcc44c6[_0x81db('0x2b')]);_0x1501f1[_0x81db('0x30')]=_[_0x81db('0x2f')](_0xcc44c6['model'],qs[_0x81db('0x31')](_0x4f4229[_0x81db('0x2b')][_0x81db('0x31')]));_0x1501f1[_0x81db('0x30')]=_0x1501f1[_0x81db('0x30')][_0x81db('0x32')]?_0x1501f1['attributes']:_0xcc44c6[_0x81db('0x29')];if(!_0x4f4229[_0x81db('0x2b')]['hasOwnProperty'](_0x81db('0x33'))){_0x1501f1[_0x81db('0x34')]=qs[_0x81db('0x34')](_0x4f4229[_0x81db('0x2b')][_0x81db('0x34')]);_0x1501f1[_0x81db('0x1a')]=qs[_0x81db('0x1a')](_0x4f4229[_0x81db('0x2b')][_0x81db('0x1a')]);}_0x1501f1[_0x81db('0x35')]=qs[_0x81db('0x36')](_0x4f4229[_0x81db('0x2b')][_0x81db('0x36')]);_0x1501f1['where']=qs['filters'](_['pick'](_0x4f4229[_0x81db('0x2b')],_0xcc44c6[_0x81db('0x2e')]));if(_0x497c62[_0x81db('0x2c')]){if(_0x497c62[_0x81db('0x2d')]){_0x497c62[_0x81db('0x2d')]=moment(_0x497c62[_0x81db('0x2d')])[_0x81db('0x37')](0x1,_0x81db('0x38'));}else{_0x497c62['dateEnd']=moment(_0x497c62[_0x81db('0x2c')])[_0x81db('0x37')](0x1,_0x81db('0x38'));}_[_0x81db('0x39')](_0x1501f1[_0x81db('0x3a')],{'createdAt':{'$gte':_0x497c62[_0x81db('0x2c')],'$lte':_0x497c62[_0x81db('0x2d')]}});}if(_0x4f4229[_0x81db('0x2b')][_0x81db('0x3b')]){_0x1501f1['where']=_[_0x81db('0x39')](_0x1501f1[_0x81db('0x3a')],{'$or':_['map'](_0x41fae1,function(_0xea53a4){if(_0xea53a4['type']['key']!=='VIRTUAL'){var _0x5d42a2={};_0x5d42a2[_0xea53a4[_0x81db('0x3c')]]={'$like':'%'+_0x4f4229[_0x81db('0x2b')]['filter']+'%'};return _0x5d42a2;}})});}_0x1501f1=_[_0x81db('0x39')]({},_0x1501f1,_0x4f4229[_0x81db('0x3d')]);var _0x26b013={'where':_0x1501f1[_0x81db('0x3a')]};return db['AnalyticDefaultReport'][_0x81db('0x19')](_0x26b013)[_0x81db('0x20')](function(_0x3026c4){_0xaa9a0f[_0x81db('0x19')]=_0x3026c4;if(_0x4f4229[_0x81db('0x2b')]['includeAll']){_0x1501f1[_0x81db('0x3e')]=[{'all':!![]}];}return db[_0x81db('0x3f')][_0x81db('0x40')](_0x1501f1);})[_0x81db('0x20')](function(_0x26a356){_0xaa9a0f[_0x81db('0x41')]=_0x26a356;return _0xaa9a0f;})[_0x81db('0x20')](respondWithFilteredResult(_0x32a494,_0x1501f1))[_0x81db('0x42')](handleError(_0x32a494,null));};exports[_0x81db('0x43')]=function(_0x4d2dc8,_0x1fffd9){var _0x4e3bbb={'raw':!![],'where':{'id':_0x4d2dc8[_0x81db('0x44')]['id']}},_0x2a450c={};_0x2a450c[_0x81db('0x29')]=_[_0x81db('0x2a')](db[_0x81db('0x3f')][_0x81db('0x45')]);_0x2a450c[_0x81db('0x2b')]=_[_0x81db('0x2a')](_0x4d2dc8[_0x81db('0x2b')]);_0x2a450c['filters']=_['intersection'](_0x2a450c['model'],_0x2a450c[_0x81db('0x2b')]);_0x4e3bbb[_0x81db('0x30')]=_[_0x81db('0x2f')](_0x2a450c[_0x81db('0x29')],qs['fields'](_0x4d2dc8[_0x81db('0x2b')][_0x81db('0x31')]));_0x4e3bbb['attributes']=_0x4e3bbb[_0x81db('0x30')][_0x81db('0x32')]?_0x4e3bbb[_0x81db('0x30')]:_0x2a450c[_0x81db('0x29')];if(_0x4d2dc8[_0x81db('0x2b')]['includeAll']){_0x4e3bbb['include']=[{'all':!![]}];}_0x4e3bbb=_[_0x81db('0x39')]({},_0x4e3bbb,_0x4d2dc8['options']);return db[_0x81db('0x3f')][_0x81db('0x46')](_0x4e3bbb)[_0x81db('0x20')](handleEntityNotFound(_0x1fffd9,null))[_0x81db('0x20')](respondWithResult(_0x1fffd9,null))[_0x81db('0x42')](handleError(_0x1fffd9,null));};exports[_0x81db('0x47')]=function(_0x5d581d,_0xef6ff6){return db[_0x81db('0x3f')]['create'](_0x5d581d[_0x81db('0x48')],{})[_0x81db('0x20')](function(_0x15f97c){var _0x1f9bb2=_0x5d581d[_0x81db('0x49')]['get']({'plain':!![]});if(!_0x1f9bb2)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1f9bb2[_0x81db('0x4a')]===_0x81db('0x49')){var _0x1b1329=_0x15f97c[_0x81db('0x22')]({'plain':!![]});var _0x2447a5=_0x81db('0x4b');return db[_0x81db('0x4c')][_0x81db('0x46')]({'where':{'name':_0x2447a5,'userProfileId':_0x1f9bb2[_0x81db('0x4d')]},'raw':!![]})[_0x81db('0x20')](function(_0x427dc6){if(_0x427dc6&&_0x427dc6[_0x81db('0x4e')]===0x0){return db[_0x81db('0x24')][_0x81db('0x47')]({'name':_0x1b1329['name'],'resourceId':_0x1b1329['id'],'type':_0x81db('0x23'),'sectionId':_0x427dc6['id']},{})['then'](function(){return _0x15f97c;});}else{return _0x15f97c;}})[_0x81db('0x42')](function(_0x120bf2){logger[_0x81db('0x4f')](_0x81db('0x50'),_0x120bf2);throw _0x120bf2;});}return _0x15f97c;})[_0x81db('0x20')](respondWithResult(_0xef6ff6,0xc9))[_0x81db('0x42')](handleError(_0xef6ff6,null));};exports[_0x81db('0x1f')]=function(_0x5dae92,_0x4b4842){if(_0x5dae92[_0x81db('0x48')]['id']){delete _0x5dae92[_0x81db('0x48')]['id'];}return db['AnalyticDefaultReport'][_0x81db('0x46')]({'where':{'id':_0x5dae92[_0x81db('0x44')]['id']}})[_0x81db('0x20')](handleEntityNotFound(_0x4b4842,null))[_0x81db('0x20')](saveUpdates(_0x5dae92[_0x81db('0x48')],null))[_0x81db('0x20')](respondWithResult(_0x4b4842,null))[_0x81db('0x42')](handleError(_0x4b4842,null));};exports[_0x81db('0x21')]=function(_0x22ed4c,_0x335194){return db[_0x81db('0x3f')][_0x81db('0x46')]({'where':{'id':_0x22ed4c[_0x81db('0x44')]['id']}})[_0x81db('0x20')](handleEntityNotFound(_0x335194,null))['then'](removeEntity(_0x335194,null))['catch'](handleError(_0x335194,null));};exports[_0x81db('0x51')]=function(_0x51b1bd,_0x44aeca){var _0x1c0dba=0xa;var _0x10599b=[_0x81db('0x52'),_0x81db('0x53'),_0x81db('0x54'),'outer_join',_0x81db('0x55')];var _0x3682a7={'SUM':_0x81db('0x56'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x81db('0x57'),'MAX':_0x81db('0x58'),'MIN':_0x81db('0x59'),'AVG':_0x81db('0x5a'),'GROUP_CONCAT':_0x81db('0x5b'),'GROUP_CONCAT ASC':_0x81db('0x5c'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x467b0b={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x81db('0x5d'),'UNIX_TIMESTAMP':_0x81db('0x5e')};var _0x2b3f9e=function(_0x2b4c48){return!_[_0x81db('0x5f')]([_0x81db('0x60'),_0x81db('0x61'),'IS\x20EMPTY','IS\x20NOT\x20EMPTY'],_0x2b4c48);};var _0x5aa110=function(_0x30375e){if(!_0x30375e||!_0x30375e[_0x81db('0x62')][_0x81db('0x32')]){return'';}for(var _0x3578a4='(',_0x49de55=0x0;_0x49de55<_0x30375e['rules'][_0x81db('0x32')];_0x49de55+=0x1){_0x49de55>0x0&&(_0x3578a4+='\x20'+_0x30375e['operator']+'\x20');_0x3578a4+=_0x30375e[_0x81db('0x62')][_0x49de55][_0x81db('0x63')]?_0x5aa110(_0x30375e[_0x81db('0x62')][_0x49de55][_0x81db('0x63')]):_0x30375e[_0x81db('0x62')][_0x49de55][_0x81db('0x3c')]+'\x20'+_0x30375e[_0x81db('0x62')][_0x49de55][_0x81db('0x64')]+(_0x2b3f9e(_0x30375e[_0x81db('0x62')][_0x49de55][_0x81db('0x64')])?'\x20'+_0x30375e[_0x81db('0x62')][_0x49de55]['value']:'');}return _0x3578a4+')';};var _0x32a7eb={'where':{'id':_0x51b1bd['params']['id']}},_0x3df23a,_0x2422c0,_0x54f98c,_0x920a55,_0x5cea20;_0x32a7eb=_[_0x81db('0x39')]({},_0x32a7eb,_0x51b1bd[_0x81db('0x3d')]);return db['AnalyticDefaultReport'][_0x81db('0x46')](_0x32a7eb)[_0x81db('0x20')](function(_0x29340e){if(_0x29340e){_0x3df23a=_0x29340e;return _0x29340e[_0x81db('0x65')]();}return null;})[_0x81db('0x20')](function(_0x26f687){if(_0x26f687){if(!_0x26f687['length']){throw new db[(_0x81db('0x66'))]['ValidationErrorItem']('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x2422c0=_0x26f687;return db[_0x81db('0x67')][_0x81db('0x40')]({'raw':!![]});}return null;})['then'](function(_0x631396){if(_0x631396){_0x54f98c=_['keyBy'](_0x631396,'id');var _0x24d8fd;var _0x3c4717=squel[_0x81db('0x68')]();_0x3c4717[_0x81db('0x69')](_0x3df23a['table']);for(var _0x44b392=0x0;_0x44b392<_0x2422c0[_0x81db('0x32')];_0x44b392+=0x1){_0x24d8fd=_0x2422c0[_0x44b392][_0x81db('0x6a')]?_0x54f98c[_0x2422c0[_0x44b392][_0x81db('0x6a')]][_0x81db('0x6b')]:_0x2422c0[_0x44b392]['field'];_0x24d8fd=_0x2422c0[_0x44b392][_0x81db('0x6c')]?_[_0x81db('0x6d')](_0x3682a7[_0x2422c0[_0x44b392][_0x81db('0x6c')]],'%s',_0x24d8fd):_0x24d8fd;_0x24d8fd=_0x2422c0[_0x44b392][_0x81db('0x6e')]?_[_0x81db('0x6d')](_0x467b0b[_0x2422c0[_0x44b392][_0x81db('0x6e')]],'%s',_0x24d8fd):_0x24d8fd;if(_0x2422c0[_0x44b392][_0x81db('0x6f')]){_0x3c4717[_0x81db('0x63')](_0x24d8fd);}_0x2422c0[_0x44b392][_0x81db('0x70')]&&_0x3c4717['order'](_0x24d8fd,_0x2422c0[_0x44b392]['orderBy']===_0x81db('0x71')?![]:!![]);_0x3c4717[_0x81db('0x3c')](_0x24d8fd,_0x2422c0[_0x44b392][_0x81db('0x72')]||_0x24d8fd);}if(_0x3df23a[_0x81db('0x73')]){_0x3df23a[_0x81db('0x73')]=JSON[_0x81db('0x74')](_0x3df23a['joins']);for(var _0xfa00d1=0x0;_0xfa00d1<_0x3df23a['joins'][_0x81db('0x32')];_0xfa00d1+=0x1){if(_0x3df23a['joins'][_0xfa00d1][_0x81db('0x75')]&&_[_0x81db('0x5f')](_0x10599b,_0x3df23a[_0x81db('0x73')][_0xfa00d1][_0x81db('0x75')])&&_0x3df23a[_0x81db('0x73')][_0xfa00d1][_0x81db('0x76')]&&_0x3df23a[_0x81db('0x73')][_0xfa00d1][_0x81db('0x77')]&&_0x3df23a['joins'][_0xfa00d1][_0x81db('0x78')]){_0x3c4717[_0x3df23a[_0x81db('0x73')][_0xfa00d1]['type']](_0x3df23a['joins'][_0xfa00d1]['foreignTable'],null,util[_0x81db('0x6e')]('%s.%s\x20=\x20%s.%s',_0x3df23a['table'],_0x3df23a['joins'][_0xfa00d1][_0x81db('0x76')],_0x3df23a[_0x81db('0x73')][_0xfa00d1]['foreignTable'],_0x3df23a[_0x81db('0x73')][_0xfa00d1]['foreignKey']));}}}if(_0x3df23a['conditions']){_0x3df23a[_0x81db('0x79')]=JSON[_0x81db('0x74')](_0x3df23a[_0x81db('0x79')]);_0x3c4717[_0x81db('0x3a')](_0x5aa110(_0x3df23a[_0x81db('0x79')]['group']));}_0x5cea20=_0x3c4717[_0x81db('0x7a')]();_0x3c4717[_0x81db('0x34')](_0x1c0dba);_0x3c4717[_0x81db('0x1a')](0x0);logger[_0x81db('0x7b')](_0x81db('0x7c'),_0x3c4717[_0x81db('0x7d')]());return db[_0x81db('0x7e')][_0x81db('0x2b')](_0x3c4717[_0x81db('0x7d')](),{'type':db[_0x81db('0x7e')]['QueryTypes'][_0x81db('0x7f')]});}})['then'](respondWithResult(_0x44aeca,null))[_0x81db('0x42')](handleError(_0x44aeca,null));};function runReport(_0x4d0f49,_0x4ce9b6,_0x5c67ea){var _0x4a50cb=_0x4ce9b6[_0x81db('0x26')];var _0x33fb99=0xa;var _0x37fc0c=['join',_0x81db('0x53'),'right_join',_0x81db('0x80'),'cross_join'];var _0x5247c4={'SUM':_0x81db('0x56'),'COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':_0x81db('0x58'),'MIN':_0x81db('0x59'),'AVG':_0x81db('0x5a'),'GROUP_CONCAT':_0x81db('0x5b'),'GROUP_CONCAT ASC':_0x81db('0x5c'),'GROUP_CONCAT DESC':_0x81db('0x81')};var _0x112d79={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x81db('0x82'),'HOUR':'HOUR(%s)','ROUND':_0x81db('0x5d'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x1c7580=function(_0x440382){return!_['includes']([_0x81db('0x60'),_0x81db('0x61'),_0x81db('0x83'),'IS\x20NOT\x20EMPTY'],_0x440382);};var _0xd9d52e=function(_0x511405){if(!_0x511405||!_0x511405[_0x81db('0x62')][_0x81db('0x32')]){return'';}for(var _0x12efdc='(',_0x572b2e=0x0;_0x572b2e<_0x511405[_0x81db('0x62')][_0x81db('0x32')];_0x572b2e+=0x1){_0x572b2e>0x0&&(_0x12efdc+='\x20'+_0x511405[_0x81db('0x84')]+'\x20');_0x12efdc+=_0x511405[_0x81db('0x62')][_0x572b2e][_0x81db('0x63')]?_0xd9d52e(_0x511405['rules'][_0x572b2e][_0x81db('0x63')]):_0x511405['rules'][_0x572b2e]['field']+'\x20'+_0x511405['rules'][_0x572b2e][_0x81db('0x64')]+(_0x1c7580(_0x511405[_0x81db('0x62')][_0x572b2e][_0x81db('0x64')])?'\x20'+_0x511405[_0x81db('0x62')][_0x572b2e][_0x81db('0x85')]:'');}return _0x12efdc+')';};var _0x21d3c9={'where':{'id':_0x4d0f49['id']}},_0x6c3c84,_0x4933ef,_0x3bae34,_0x514bbb,_0x495069;_0x21d3c9=_[_0x81db('0x39')]({},_0x21d3c9,_0x5c67ea);return db[_0x81db('0x3f')]['find'](_0x21d3c9)[_0x81db('0x20')](function(_0x3e07a5){if(_0x3e07a5){_0x6c3c84=_0x3e07a5;return _0x3e07a5[_0x81db('0x65')]();}return null;})[_0x81db('0x20')](function(_0x5dcdb8){if(_0x5dcdb8){if(!_0x5dcdb8[_0x81db('0x32')]){throw new db[(_0x81db('0x66'))]['ValidationErrorItem'](_0x81db('0x86'),0x193);}_0x4933ef=_0x5dcdb8;return db['AnalyticMetric'][_0x81db('0x40')]({'raw':!![]});}return null;})[_0x81db('0x20')](function(_0x34ace8){if(_0x34ace8){_0x3bae34=_[_0x81db('0x87')](_0x34ace8,'id');var _0x2d98ec;var _0x12903d=squel[_0x81db('0x68')]();_0x12903d[_0x81db('0x69')](_0x6c3c84[_0x81db('0x88')]);for(var _0x239d88=0x0;_0x239d88<_0x4933ef['length'];_0x239d88+=0x1){_0x2d98ec=_0x4933ef[_0x239d88]['MetricId']?_0x3bae34[_0x4933ef[_0x239d88][_0x81db('0x6a')]][_0x81db('0x6b')]:_0x4933ef[_0x239d88][_0x81db('0x3c')];_0x2d98ec=_0x4933ef[_0x239d88][_0x81db('0x6c')]?_[_0x81db('0x6d')](_0x5247c4[_0x4933ef[_0x239d88][_0x81db('0x6c')]],'%s',_0x2d98ec):_0x2d98ec;_0x2d98ec=_0x4933ef[_0x239d88][_0x81db('0x6e')]?_[_0x81db('0x6d')](_0x112d79[_0x4933ef[_0x239d88][_0x81db('0x6e')]],'%s',_0x2d98ec):_0x2d98ec;if(_0x4933ef[_0x239d88]['groupBy']){_0x12903d['group'](_0x2d98ec);}_0x4933ef[_0x239d88]['orderBy']&&_0x12903d['order'](_0x2d98ec,_0x4933ef[_0x239d88][_0x81db('0x70')]===_0x81db('0x71')?![]:!![]);_0x12903d[_0x81db('0x3c')](_0x2d98ec,_0x4933ef[_0x239d88]['alias']||_0x2d98ec);}if(_0x6c3c84[_0x81db('0x73')]){_0x6c3c84[_0x81db('0x73')]=JSON['parse'](_0x6c3c84[_0x81db('0x73')]);for(var _0x3687e1=0x0;_0x3687e1<_0x6c3c84[_0x81db('0x73')][_0x81db('0x32')];_0x3687e1+=0x1){if(_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x75')]&&_[_0x81db('0x5f')](_0x37fc0c,_0x6c3c84['joins'][_0x3687e1][_0x81db('0x75')])&&_0x6c3c84['joins'][_0x3687e1]['parentKey']&&_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x77')]&&_0x6c3c84['joins'][_0x3687e1]['foreignKey']){_0x12903d[_0x6c3c84[_0x81db('0x73')][_0x3687e1]['type']](_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x77')],null,util[_0x81db('0x6e')]('%s.%s\x20=\x20%s.%s',_0x6c3c84[_0x81db('0x88')],_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x76')],_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x77')],_0x6c3c84[_0x81db('0x73')][_0x3687e1][_0x81db('0x78')]));}}}if(_0x6c3c84['conditions']){_0x6c3c84['conditions']=JSON['parse'](_0x6c3c84[_0x81db('0x79')]);_0x12903d[_0x81db('0x3a')](_0xd9d52e(_0x6c3c84[_0x81db('0x79')][_0x81db('0x63')]));}_0x495069=_0x12903d[_0x81db('0x7a')]();_0x12903d[_0x81db('0x34')](_0x33fb99);_0x12903d['offset'](0x0);logger[_0x81db('0x7b')](_0x81db('0x7c'),_0x12903d[_0x81db('0x7d')]());return db[_0x81db('0x7e')]['query'](_0x12903d['toString'](),{'type':db[_0x81db('0x7e')][_0x81db('0x89')][_0x81db('0x7f')]});}})['then'](function(_0x2fbf33){if(!_0x2fbf33[_0x81db('0x32')]){throw new db[(_0x81db('0x66'))]['ValidationErrorItem'](_0x81db('0x8a'),0xcc);}if(_0x4ce9b6['output']===_0x81db('0x8b')){return null;}var _0x1b01cc=_[_0x81db('0x39')](_0x4ce9b6,{'name':_0x4ce9b6[_0x81db('0x8c')]||_0x4ce9b6[_0x81db('0x26')]||_0x6c3c84[_0x81db('0x26')],'basename':_0x4a50cb,'savename':util[_0x81db('0x6e')]('%s-%s.%s',_0x4ce9b6[_0x81db('0x26')]||_0x6c3c84[_0x81db('0x26')],require('randomstring')[_0x81db('0x8d')](0x4),_0x4ce9b6['output']||_0x81db('0x8e')),'reportId':_0x6c3c84['id'],'reportType':'default'});return db['AnalyticExtractedReport'][_0x81db('0x47')](_0x1b01cc,{'raw':!![]});})[_0x81db('0x20')](function(_0x8cfff9){if(_0x6c3c84[_0x81db('0x88')]===_0x81db('0x8f')){_0x495069[_0x81db('0x3a')](_0x6c3c84['table']+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x4ce9b6[_0x81db('0x90')],_0x4ce9b6[_0x81db('0x91')]);}else{_0x495069[_0x81db('0x3a')](_0x6c3c84['table']+'.createdAt\x20BETWEEN\x20?\x20AND\x20?',_0x4ce9b6['startDate'],_0x4ce9b6[_0x81db('0x91')]);}if(_0x8cfff9){logger[_0x81db('0x92')](_0x81db('0x93'),_0x495069[_0x81db('0x7d')]());require(_0x81db('0x94'))['fork'](path[_0x81db('0x52')](__dirname,_0x81db('0x95'),_0x8cfff9[_0x81db('0x96')]),[_0x8cfff9['id'],_0x495069['toString'](),path[_0x81db('0x52')](__dirname,_0x81db('0x97'),_0x8cfff9[_0x81db('0x98')]),_0x4a50cb]);return _0x8cfff9;}else{var _0x17aaa1=squel[_0x81db('0x68')]();_0x17aaa1[_0x81db('0x69')]('('+_0x495069[_0x81db('0x7d')]()+')','countTable');_0x17aaa1[_0x81db('0x3c')](_0x81db('0x99'),'count');_0x495069['limit'](_0x4ce9b6[_0x81db('0x34')]||_0x33fb99);_0x495069['offset'](_0x4ce9b6[_0x81db('0x1a')]||0x0);return db[_0x81db('0x7e')][_0x81db('0x2b')](_0x17aaa1[_0x81db('0x7d')](),{'type':db['sequelize']['QueryTypes'][_0x81db('0x7f')]})['then'](function(_0x44e96a){if(!_0x44e96a[_0x81db('0x32')]){_0x514bbb=0x0;}else{_0x514bbb=_0x44e96a[0x0][_0x81db('0x19')]||0x0;}return db[_0x81db('0x7e')][_0x81db('0x2b')](_0x495069[_0x81db('0x7d')](),{'type':db[_0x81db('0x7e')][_0x81db('0x89')][_0x81db('0x7f')]});})[_0x81db('0x20')](function(_0x437af2){return{'rows':_0x437af2||[],'count':_0x514bbb};});}});}exports[_0x81db('0x9a')]=function(_0x4eb2c1,_0x14fa98){return runReport(_0x4eb2c1[_0x81db('0x44')],_0x4eb2c1[_0x81db('0x2b')],_0x4eb2c1[_0x81db('0x3d')])[_0x81db('0x20')](respondWithResult(_0x14fa98,null))[_0x81db('0x42')](handleError(_0x14fa98,null));};exports['runReport']=runReport;exports[_0x81db('0x2b')]=function(_0x431d2e,_0x5eac11){var _0x3d5f3d=0xa;var _0x72adf5=['join',_0x81db('0x53'),'right_join',_0x81db('0x80'),_0x81db('0x55')];var _0x295e54={'SUM':_0x81db('0x56'),'COUNT':_0x81db('0x9b'),'COUNT DISTINCT':_0x81db('0x57'),'MAX':'MAX(%s)','MIN':_0x81db('0x59'),'AVG':_0x81db('0x5a'),'GROUP_CONCAT':_0x81db('0x5b'),'GROUP_CONCAT ASC':_0x81db('0x5c'),'GROUP_CONCAT DESC':_0x81db('0x81')};var _0x3e2b76={'SEC_TO_TIME':_0x81db('0x9c'),'DATE':_0x81db('0x82'),'HOUR':_0x81db('0x9d'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x5eda4a=function(_0x4f34f8){return!_[_0x81db('0x5f')](['IS\x20NULL',_0x81db('0x61'),_0x81db('0x83'),_0x81db('0x9e')],_0x4f34f8);};var _0x49ce80=function(_0x1f7a89){if(!_0x1f7a89||!_0x1f7a89[_0x81db('0x62')]['length']){return'';}for(var _0x4f16b4='(',_0x5ad8a6=0x0;_0x5ad8a6<_0x1f7a89[_0x81db('0x62')][_0x81db('0x32')];_0x5ad8a6+=0x1){_0x5ad8a6>0x0&&(_0x4f16b4+='\x20'+_0x1f7a89[_0x81db('0x84')]+'\x20');_0x4f16b4+=_0x1f7a89[_0x81db('0x62')][_0x5ad8a6][_0x81db('0x63')]?_0x49ce80(_0x1f7a89[_0x81db('0x62')][_0x5ad8a6]['group']):_0x1f7a89[_0x81db('0x62')][_0x5ad8a6][_0x81db('0x3c')]+'\x20'+_0x1f7a89[_0x81db('0x62')][_0x5ad8a6]['condition']+(_0x5eda4a(_0x1f7a89['rules'][_0x5ad8a6][_0x81db('0x64')])?'\x20'+_0x1f7a89['rules'][_0x5ad8a6][_0x81db('0x85')]:'');}return _0x4f16b4+')';};var _0x528a4c={'where':{'id':_0x431d2e['params']['id']}},_0x441c18,_0x2193cd,_0x55c22c,_0x1f78ad,_0x4a9428;_0x528a4c=_[_0x81db('0x39')]({},_0x528a4c,_0x431d2e[_0x81db('0x3d')]);return db[_0x81db('0x3f')][_0x81db('0x46')](_0x528a4c)[_0x81db('0x20')](function(_0x1edfa1){if(_0x1edfa1){_0x441c18=_0x1edfa1;return _0x1edfa1['getFields']();}return null;})[_0x81db('0x20')](function(_0x440f60){if(_0x440f60){if(!_0x440f60[_0x81db('0x32')]){throw new db[(_0x81db('0x66'))]['ValidationErrorItem'](_0x81db('0x86'),0x193);}_0x2193cd=_0x440f60;return db[_0x81db('0x67')][_0x81db('0x40')]({'raw':!![]});}return null;})[_0x81db('0x20')](function(_0x110841){if(_0x110841){_0x55c22c=_[_0x81db('0x87')](_0x110841,'id');var _0x4b678d;var _0x39cc66=squel[_0x81db('0x68')]();_0x39cc66['from'](_0x441c18['table']);for(var _0x194688=0x0;_0x194688<_0x2193cd[_0x81db('0x32')];_0x194688+=0x1){_0x4b678d=_0x2193cd[_0x194688]['MetricId']?_0x55c22c[_0x2193cd[_0x194688][_0x81db('0x6a')]][_0x81db('0x6b')]:_0x2193cd[_0x194688][_0x81db('0x3c')];_0x4b678d=_0x2193cd[_0x194688][_0x81db('0x6c')]?_['replace'](_0x295e54[_0x2193cd[_0x194688]['function']],'%s',_0x4b678d):_0x4b678d;_0x4b678d=_0x2193cd[_0x194688][_0x81db('0x6e')]?_[_0x81db('0x6d')](_0x3e2b76[_0x2193cd[_0x194688][_0x81db('0x6e')]],'%s',_0x4b678d):_0x4b678d;if(_0x2193cd[_0x194688][_0x81db('0x6f')]){_0x39cc66[_0x81db('0x63')](_0x4b678d);}_0x2193cd[_0x194688][_0x81db('0x70')]&&_0x39cc66[_0x81db('0x35')](_0x4b678d,_0x2193cd[_0x194688][_0x81db('0x70')]===_0x81db('0x71')?![]:!![]);_0x39cc66[_0x81db('0x3c')](_0x4b678d,_0x2193cd[_0x194688]['alias']||_0x4b678d);}if(_0x441c18['joins']){_0x441c18[_0x81db('0x73')]=JSON[_0x81db('0x74')](_0x441c18[_0x81db('0x73')]);for(var _0x2a8198=0x0;_0x2a8198<_0x441c18['joins'][_0x81db('0x32')];_0x2a8198+=0x1){if(_0x441c18[_0x81db('0x73')][_0x2a8198]['type']&&_['includes'](_0x72adf5,_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x75')])&&_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x76')]&&_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x77')]&&_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x78')]){_0x39cc66[_0x441c18[_0x81db('0x73')][_0x2a8198]['type']](_0x441c18[_0x81db('0x73')][_0x2a8198]['foreignTable'],null,util[_0x81db('0x6e')](_0x81db('0x9f'),_0x441c18[_0x81db('0x88')],_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x76')],_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x77')],_0x441c18[_0x81db('0x73')][_0x2a8198][_0x81db('0x78')]));}}}if(_0x441c18['conditions']){_0x441c18[_0x81db('0x79')]=JSON['parse'](_0x441c18['conditions']);_0x39cc66['where'](_0x49ce80(_0x441c18[_0x81db('0x79')]['group']));}_0x4a9428=_0x39cc66[_0x81db('0x7a')]();_0x39cc66[_0x81db('0x34')](_0x3d5f3d);_0x39cc66[_0x81db('0x1a')](0x0);logger['debug'](_0x81db('0x7c'),_0x39cc66[_0x81db('0x7d')]());return db[_0x81db('0x7e')][_0x81db('0x2b')](_0x39cc66[_0x81db('0x7d')](),{'type':db[_0x81db('0x7e')]['QueryTypes'][_0x81db('0x7f')]});}})[_0x81db('0x20')](function(){return{'sql':_0x4a9428['toString']()};})[_0x81db('0x20')](respondWithResult(_0x5eac11,null))[_0x81db('0x42')](handleError(_0x5eac11,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff