// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x4c90=['type','map','query','keys','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','sort','filters','where','merge','filter','count','includeAll','include','findAll','rows','show','params','options','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Reports','find','userProfileId','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','preview','join','right_join','cross_join','MIN(%s)','AVG(%s)','GROUP_CONCAT(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','SEC_TO_TIME(%s)','ROUND(%s)','includes','IS\x20NOT\x20EMPTY','rules','operator','group','field','getFields','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','select','table','MetricId','replace','format','groupBy','orderBy','order','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','clone','Limited\x20Query:','toString','sequelize','SELECT','left_join','SUM(%s)','COUNT(%s)','COUNT(DISTINCT\x20%s)','MAX(%s)','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY','condition','keyBy','function','debug','QueryTypes','output','randomstring','generate','csv','custom','AnalyticExtractedReport','cdr','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','fork','../../components/export/','../../files/reports','savename','from','countTable','run','runReport','value','html-pdf','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','ejs','crypto','jsforce','desk.js','papaparse','ioredis','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','dbH','sendStatus','status','end','json','offset','limit','set','Content-Range','save','then','destroy','get','CustomReports','UserProfileResource','stack','name','index','AnalyticCustomReport','rawAttributes'];(function(_0xc3248d,_0x40996c){var _0x18e9f4=function(_0x86a96f){while(--_0x86a96f){_0xc3248d['push'](_0xc3248d['shift']());}};_0x18e9f4(++_0x40996c);}(_0x4c90,0x73));var _0x04c9=function(_0x29cb68,_0x500f0b){_0x29cb68=_0x29cb68-0x0;var _0x4fb66c=_0x4c90[_0x29cb68];return _0x4fb66c;};'use strict';var pdf=require(_0x04c9('0x0'));var emlformat=require(_0x04c9('0x1'));var rimraf=require(_0x04c9('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x04c9('0x3'));var rp=require('request-promise');var moment=require(_0x04c9('0x4'));var BPromise=require(_0x04c9('0x5'));var Mustache=require(_0x04c9('0x6'));var util=require(_0x04c9('0x7'));var path=require(_0x04c9('0x8'));var sox=require('sox');var csv=require(_0x04c9('0x9'));var ejs=require(_0x04c9('0xa'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x04c9('0xb'));var jsforce=require(_0x04c9('0xc'));var deskjs=require(_0x04c9('0xd'));var toCsv=require(_0x04c9('0x9'));var querystring=require('querystring');var Papa=require(_0x04c9('0xe'));var Redis=require(_0x04c9('0xf'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x04c9('0x10'));var logger=require(_0x04c9('0x11'))(_0x04c9('0x12'));var utils=require('../../config/utils');var config=require(_0x04c9('0x13'));var licenseUtil=require(_0x04c9('0x14'));var db=require(_0x04c9('0x15'))['db'];var dbH=require('../../mysqldb')[_0x04c9('0x16')];function respondWithStatusCode(_0xf34736,_0x1ecfbf){_0x1ecfbf=_0x1ecfbf||0xcc;return function(_0x660fbc){if(_0x660fbc){return _0xf34736[_0x04c9('0x17')](_0x1ecfbf);}return _0xf34736[_0x04c9('0x18')](_0x1ecfbf)[_0x04c9('0x19')]();};}function respondWithResult(_0x3d2589,_0x531146){_0x531146=_0x531146||0xc8;return function(_0x42aea9){if(_0x42aea9){return _0x3d2589[_0x04c9('0x18')](_0x531146)[_0x04c9('0x1a')](_0x42aea9);}};}function respondWithFilteredResult(_0x418208,_0x48d0c4){return function(_0x2be721){if(_0x2be721){var _0x4cad6d=_0x2be721['count'],_0x541c6d=_0x48d0c4[_0x04c9('0x1b')],_0x3a7a91=_0x48d0c4[_0x04c9('0x1b')]+_0x48d0c4[_0x04c9('0x1c')],_0x49dd88;if(_0x3a7a91>=_0x4cad6d){_0x3a7a91=_0x4cad6d;_0x49dd88=0xc8;}else{_0x49dd88=0xce;}_0x418208['status'](_0x49dd88);return _0x418208[_0x04c9('0x1d')](_0x04c9('0x1e'),_0x541c6d+'-'+_0x3a7a91+'/'+_0x4cad6d)[_0x04c9('0x1a')](_0x2be721);}return null;};}function patchUpdates(_0x16307f){return function(_0x357344){try{jsonpatch['apply'](_0x357344,_0x16307f,!![]);}catch(_0x1555dc){return BPromise['reject'](_0x1555dc);}return _0x357344[_0x04c9('0x1f')]();};}function saveUpdates(_0x2d5691,_0xb3e0){return function(_0x1817c3){if(_0x1817c3){return _0x1817c3['update'](_0x2d5691)[_0x04c9('0x20')](function(_0x48cae2){return _0x48cae2;});}return null;};}function removeEntity(_0x2cd2bb,_0x37b337){return function(_0x1dc155){if(_0x1dc155){return _0x1dc155[_0x04c9('0x21')]()[_0x04c9('0x20')](function(){var _0x5889fc=_0x1dc155[_0x04c9('0x22')]({'plain':!![]});var _0x57fb99=_0x04c9('0x23');return db[_0x04c9('0x24')][_0x04c9('0x21')]({'where':{'type':_0x57fb99,'resourceId':_0x5889fc['id']}})[_0x04c9('0x20')](function(){return _0x1dc155;});})[_0x04c9('0x20')](function(){_0x2cd2bb[_0x04c9('0x18')](0xcc)[_0x04c9('0x19')]();});}};}function handleEntityNotFound(_0x4117d1,_0x393e9b){return function(_0x518417){if(!_0x518417){_0x4117d1[_0x04c9('0x17')](0x194);}return _0x518417;};}function handleError(_0x323655,_0x5bab3d){_0x5bab3d=_0x5bab3d||0x1f4;return function(_0x38de1f){logger['error'](_0x38de1f[_0x04c9('0x25')]);if(_0x38de1f[_0x04c9('0x26')]){delete _0x38de1f[_0x04c9('0x26')];}_0x323655['status'](_0x5bab3d)['send'](_0x38de1f);};}exports[_0x04c9('0x27')]=function(_0x303446,_0x1e7fde){var _0x2a3d6c={},_0x585ed4={},_0x275e3b={'count':0x0,'rows':[]};var _0x786dc2=_['map'](db[_0x04c9('0x28')][_0x04c9('0x29')],function(_0x5ea67a){return{'name':_0x5ea67a['fieldName'],'type':_0x5ea67a[_0x04c9('0x2a')]['key']};});_0x585ed4['model']=_[_0x04c9('0x2b')](_0x786dc2,_0x04c9('0x26'));_0x585ed4[_0x04c9('0x2c')]=_[_0x04c9('0x2d')](_0x303446['query']);_0x585ed4['filters']=_[_0x04c9('0x2e')](_0x585ed4[_0x04c9('0x2f')],_0x585ed4['query']);_0x2a3d6c[_0x04c9('0x30')]=_['intersection'](_0x585ed4[_0x04c9('0x2f')],qs[_0x04c9('0x31')](_0x303446[_0x04c9('0x2c')][_0x04c9('0x31')]));_0x2a3d6c[_0x04c9('0x30')]=_0x2a3d6c[_0x04c9('0x30')][_0x04c9('0x32')]?_0x2a3d6c[_0x04c9('0x30')]:_0x585ed4[_0x04c9('0x2f')];if(!_0x303446[_0x04c9('0x2c')][_0x04c9('0x33')](_0x04c9('0x34'))){_0x2a3d6c[_0x04c9('0x1c')]=qs[_0x04c9('0x1c')](_0x303446[_0x04c9('0x2c')]['limit']);_0x2a3d6c[_0x04c9('0x1b')]=qs[_0x04c9('0x1b')](_0x303446[_0x04c9('0x2c')][_0x04c9('0x1b')]);}_0x2a3d6c['order']=qs[_0x04c9('0x35')](_0x303446[_0x04c9('0x2c')][_0x04c9('0x35')]);_0x2a3d6c['where']=qs[_0x04c9('0x36')](_['pick'](_0x303446[_0x04c9('0x2c')],_0x585ed4[_0x04c9('0x36')]),_0x786dc2);if(_0x303446['query']['filter']){_0x2a3d6c[_0x04c9('0x37')]=_[_0x04c9('0x38')](_0x2a3d6c[_0x04c9('0x37')],{'$or':_[_0x04c9('0x2b')](_0x786dc2,function(_0x1b0054){if(_0x1b0054[_0x04c9('0x2a')]!=='VIRTUAL'){var _0x35366e={};_0x35366e[_0x1b0054[_0x04c9('0x26')]]={'$like':'%'+_0x303446['query'][_0x04c9('0x39')]+'%'};return _0x35366e;}})});}_0x2a3d6c=_[_0x04c9('0x38')]({},_0x2a3d6c,_0x303446['options']);var _0x3e4461={'where':_0x2a3d6c[_0x04c9('0x37')]};return db[_0x04c9('0x28')][_0x04c9('0x3a')](_0x3e4461)[_0x04c9('0x20')](function(_0x1cf2f4){_0x275e3b[_0x04c9('0x3a')]=_0x1cf2f4;if(_0x303446[_0x04c9('0x2c')][_0x04c9('0x3b')]){_0x2a3d6c[_0x04c9('0x3c')]=[{'all':!![]}];}return db[_0x04c9('0x28')][_0x04c9('0x3d')](_0x2a3d6c);})[_0x04c9('0x20')](function(_0x194272){_0x275e3b[_0x04c9('0x3e')]=_0x194272;return _0x275e3b;})[_0x04c9('0x20')](respondWithFilteredResult(_0x1e7fde,_0x2a3d6c))['catch'](handleError(_0x1e7fde,null));};exports[_0x04c9('0x3f')]=function(_0x26173b,_0x5b58ca){var _0x101172={'raw':![],'where':{'id':_0x26173b[_0x04c9('0x40')]['id']}},_0x2cd298={};_0x2cd298[_0x04c9('0x2f')]=_['keys'](db[_0x04c9('0x28')][_0x04c9('0x29')]);_0x2cd298[_0x04c9('0x2c')]=_[_0x04c9('0x2d')](_0x26173b[_0x04c9('0x2c')]);_0x2cd298[_0x04c9('0x36')]=_['intersection'](_0x2cd298[_0x04c9('0x2f')],_0x2cd298[_0x04c9('0x2c')]);_0x101172[_0x04c9('0x30')]=_[_0x04c9('0x2e')](_0x2cd298[_0x04c9('0x2f')],qs[_0x04c9('0x31')](_0x26173b['query']['fields']));_0x101172[_0x04c9('0x30')]=_0x101172['attributes']['length']?_0x101172[_0x04c9('0x30')]:_0x2cd298[_0x04c9('0x2f')];if(_0x26173b[_0x04c9('0x2c')][_0x04c9('0x3b')]){_0x101172[_0x04c9('0x3c')]=[{'all':!![]}];}_0x101172=_[_0x04c9('0x38')]({},_0x101172,_0x26173b[_0x04c9('0x41')]);return db['AnalyticCustomReport']['find'](_0x101172)[_0x04c9('0x20')](handleEntityNotFound(_0x5b58ca,null))['then'](respondWithResult(_0x5b58ca,null))[_0x04c9('0x42')](handleError(_0x5b58ca,null));};exports[_0x04c9('0x43')]=function(_0x2caf66,_0x5a2c42){return db[_0x04c9('0x28')][_0x04c9('0x43')](_0x2caf66['body'],{})[_0x04c9('0x20')](function(_0x4db042){var _0x1d13a4=_0x2caf66[_0x04c9('0x44')][_0x04c9('0x22')]({'plain':!![]});if(!_0x1d13a4)throw new Error(_0x04c9('0x45'));if(_0x1d13a4[_0x04c9('0x46')]===_0x04c9('0x44')){var _0x12105a=_0x4db042[_0x04c9('0x22')]({'plain':!![]});var _0x14f6d1=_0x04c9('0x47');return db['UserProfileSection'][_0x04c9('0x48')]({'where':{'name':_0x14f6d1,'userProfileId':_0x1d13a4[_0x04c9('0x49')]},'raw':!![]})[_0x04c9('0x20')](function(_0x1c8804){if(_0x1c8804&&_0x1c8804['autoAssociation']===0x0){return db['UserProfileResource'][_0x04c9('0x43')]({'name':_0x12105a['name'],'resourceId':_0x12105a['id'],'type':_0x04c9('0x23'),'sectionId':_0x1c8804['id']},{})[_0x04c9('0x20')](function(){return _0x4db042;});}else{return _0x4db042;}})[_0x04c9('0x42')](function(_0x32385e){logger[_0x04c9('0x4a')](_0x04c9('0x4b'),_0x32385e);throw _0x32385e;});}return _0x4db042;})[_0x04c9('0x20')](respondWithResult(_0x5a2c42,0xc9))['catch'](handleError(_0x5a2c42,null));};exports[_0x04c9('0x4c')]=function(_0xbcf23,_0x282e35){if(_0xbcf23['body']['id']){delete _0xbcf23['body']['id'];}return db['AnalyticCustomReport'][_0x04c9('0x48')]({'where':{'id':_0xbcf23['params']['id']}})['then'](handleEntityNotFound(_0x282e35,null))[_0x04c9('0x20')](saveUpdates(_0xbcf23[_0x04c9('0x4d')],null))[_0x04c9('0x20')](respondWithResult(_0x282e35,null))['catch'](handleError(_0x282e35,null));};exports[_0x04c9('0x21')]=function(_0x1e6316,_0x39aebc){return db[_0x04c9('0x28')][_0x04c9('0x48')]({'where':{'id':_0x1e6316[_0x04c9('0x40')]['id']}})[_0x04c9('0x20')](handleEntityNotFound(_0x39aebc,null))['then'](removeEntity(_0x39aebc,null))[_0x04c9('0x42')](handleError(_0x39aebc,null));};exports[_0x04c9('0x4e')]=function(_0x1b17e3,_0x24479f){var _0x53e9db=0xa;var _0x2b911a=[_0x04c9('0x4f'),'left_join',_0x04c9('0x50'),_0x04c9('0x51')];var _0x40a217={'SUM':'SUM(%s)','COUNT':'COUNT(%s)','COUNT DISTINCT':'COUNT(DISTINCT\x20%s)','MAX':'MAX(%s)','MIN':_0x04c9('0x52'),'AVG':_0x04c9('0x53'),'GROUP_CONCAT':_0x04c9('0x54'),'GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x04c9('0x55')};var _0x2d6b60={'SEC_TO_TIME':_0x04c9('0x56'),'DATE':'DATE(%s)','HOUR':'HOUR(%s)','ROUND':_0x04c9('0x57'),'UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x4e8afe=function(_0x5be214){return!_[_0x04c9('0x58')](['IS\x20NULL','IS\x20NOT\x20NULL','IS\x20EMPTY',_0x04c9('0x59')],_0x5be214);};var _0x7ff07f=function(_0x5de580){if(!_0x5de580||!_0x5de580[_0x04c9('0x5a')][_0x04c9('0x32')]){return'';}for(var _0x454998='(',_0x2afc9c=0x0;_0x2afc9c<_0x5de580[_0x04c9('0x5a')][_0x04c9('0x32')];_0x2afc9c+=0x1){_0x2afc9c>0x0&&(_0x454998+='\x20'+_0x5de580[_0x04c9('0x5b')]+'\x20');_0x454998+=_0x5de580[_0x04c9('0x5a')][_0x2afc9c][_0x04c9('0x5c')]?_0x7ff07f(_0x5de580['rules'][_0x2afc9c][_0x04c9('0x5c')]):_0x5de580[_0x04c9('0x5a')][_0x2afc9c][_0x04c9('0x5d')]+'\x20'+_0x5de580[_0x04c9('0x5a')][_0x2afc9c]['condition']+(_0x4e8afe(_0x5de580[_0x04c9('0x5a')][_0x2afc9c]['condition'])?'\x20'+_0x5de580[_0x04c9('0x5a')][_0x2afc9c]['value']:'');}return _0x454998+')';};var _0x581dea={'where':{'id':_0x1b17e3[_0x04c9('0x40')]['id']}},_0x4c1505,_0x44d357,_0x24df7c,_0x1bb5a3,_0x44fd19;_0x581dea=_[_0x04c9('0x38')]({},_0x581dea,_0x1b17e3[_0x04c9('0x41')]);return db['AnalyticCustomReport'][_0x04c9('0x48')](_0x581dea)[_0x04c9('0x20')](function(_0x5e0a64){if(_0x5e0a64){_0x4c1505=_0x5e0a64;return _0x5e0a64[_0x04c9('0x5e')]();}return null;})['then'](function(_0xb7534c){if(_0xb7534c){if(!_0xb7534c['length']){throw new db[(_0x04c9('0x5f'))][(_0x04c9('0x60'))](_0x04c9('0x61'),0x193);}_0x44d357=_0xb7534c;return db[_0x04c9('0x62')]['findAll']({'raw':!![]});}return null;})[_0x04c9('0x20')](function(_0x3f012f){if(_0x3f012f){_0x24df7c=_['keyBy'](_0x3f012f,'id');var _0x790101;var _0x229e8f=squel[_0x04c9('0x63')]();_0x229e8f['from'](_0x4c1505[_0x04c9('0x64')]);for(var _0x27ff8d=0x0;_0x27ff8d<_0x44d357[_0x04c9('0x32')];_0x27ff8d+=0x1){_0x790101=_0x44d357[_0x27ff8d][_0x04c9('0x65')]?_0x24df7c[_0x44d357[_0x27ff8d][_0x04c9('0x65')]]['metric']:_0x44d357[_0x27ff8d]['field'];_0x790101=_0x44d357[_0x27ff8d]['function']?_[_0x04c9('0x66')](_0x40a217[_0x44d357[_0x27ff8d]['function']],'%s',_0x790101):_0x790101;_0x790101=_0x44d357[_0x27ff8d][_0x04c9('0x67')]?_[_0x04c9('0x66')](_0x2d6b60[_0x44d357[_0x27ff8d]['format']],'%s',_0x790101):_0x790101;if(_0x44d357[_0x27ff8d][_0x04c9('0x68')]){_0x229e8f[_0x04c9('0x5c')](_0x790101);}_0x44d357[_0x27ff8d][_0x04c9('0x69')]&&_0x229e8f[_0x04c9('0x6a')](_0x790101,_0x44d357[_0x27ff8d][_0x04c9('0x69')]===_0x04c9('0x6b')?![]:!![]);_0x229e8f['field'](_0x790101,_0x44d357[_0x27ff8d][_0x04c9('0x6c')]||_0x790101);}if(_0x4c1505[_0x04c9('0x6d')]){_0x4c1505[_0x04c9('0x6d')]=JSON[_0x04c9('0x6e')](_0x4c1505[_0x04c9('0x6d')]);for(var _0x3d980e=0x0;_0x3d980e<_0x4c1505['joins'][_0x04c9('0x32')];_0x3d980e+=0x1){if(_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x2a')]&&_[_0x04c9('0x58')](_0x2b911a,_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x2a')])&&_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x6f')]&&_0x4c1505[_0x04c9('0x6d')][_0x3d980e]['foreignTable']&&_0x4c1505[_0x04c9('0x6d')][_0x3d980e]['foreignKey']){_0x229e8f[_0x4c1505[_0x04c9('0x6d')][_0x3d980e]['type']](_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x70')],null,util[_0x04c9('0x67')](_0x04c9('0x71'),_0x4c1505[_0x04c9('0x64')],_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x6f')],_0x4c1505['joins'][_0x3d980e][_0x04c9('0x70')],_0x4c1505[_0x04c9('0x6d')][_0x3d980e][_0x04c9('0x72')]));}}}if(_0x4c1505['conditions']){_0x4c1505[_0x04c9('0x73')]=JSON['parse'](_0x4c1505[_0x04c9('0x73')]);_0x229e8f[_0x04c9('0x37')](_0x7ff07f(_0x4c1505['conditions'][_0x04c9('0x5c')]));}_0x44fd19=_0x229e8f[_0x04c9('0x74')]();_0x229e8f[_0x04c9('0x1c')](_0x53e9db);_0x229e8f[_0x04c9('0x1b')](0x0);logger['debug'](_0x04c9('0x75'),_0x229e8f[_0x04c9('0x76')]());return db[_0x04c9('0x77')][_0x04c9('0x2c')](_0x229e8f['toString'](),{'type':db['sequelize']['QueryTypes'][_0x04c9('0x78')]});}})[_0x04c9('0x20')](respondWithResult(_0x24479f,null))['catch'](handleError(_0x24479f,null));};function runReport(_0x3417f0,_0x3be4c7,_0x3707db){var _0x233a9a=_0x3be4c7[_0x04c9('0x26')];var _0x462720=0xa;var _0x3840b3=[_0x04c9('0x4f'),_0x04c9('0x79'),_0x04c9('0x50'),_0x04c9('0x51')];var _0x5c3062={'SUM':_0x04c9('0x7a'),'COUNT':_0x04c9('0x7b'),'COUNT DISTINCT':_0x04c9('0x7c'),'MAX':_0x04c9('0x7d'),'MIN':_0x04c9('0x52'),'AVG':_0x04c9('0x53'),'GROUP_CONCAT':_0x04c9('0x54'),'GROUP_CONCAT ASC':_0x04c9('0x7e'),'GROUP_CONCAT DESC':_0x04c9('0x55')};var _0x5907ba={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':_0x04c9('0x7f'),'HOUR':_0x04c9('0x80'),'ROUND':_0x04c9('0x57'),'UNIX_TIMESTAMP':_0x04c9('0x81')};var _0x5eae0a=function(_0x45c1df){return!_[_0x04c9('0x58')]([_0x04c9('0x82'),_0x04c9('0x83'),_0x04c9('0x84'),_0x04c9('0x59')],_0x45c1df);};var _0x40b929=function(_0x1248a3){if(!_0x1248a3||!_0x1248a3[_0x04c9('0x5a')][_0x04c9('0x32')]){return'';}for(var _0x5dbb33='(',_0x4ed340=0x0;_0x4ed340<_0x1248a3[_0x04c9('0x5a')]['length'];_0x4ed340+=0x1){_0x4ed340>0x0&&(_0x5dbb33+='\x20'+_0x1248a3[_0x04c9('0x5b')]+'\x20');_0x5dbb33+=_0x1248a3[_0x04c9('0x5a')][_0x4ed340][_0x04c9('0x5c')]?_0x40b929(_0x1248a3[_0x04c9('0x5a')][_0x4ed340][_0x04c9('0x5c')]):_0x1248a3['rules'][_0x4ed340][_0x04c9('0x5d')]+'\x20'+_0x1248a3[_0x04c9('0x5a')][_0x4ed340]['condition']+(_0x5eae0a(_0x1248a3[_0x04c9('0x5a')][_0x4ed340][_0x04c9('0x85')])?'\x20'+_0x1248a3['rules'][_0x4ed340]['value']:'');}return _0x5dbb33+')';};var _0x10c33e={'where':{'id':_0x3417f0['id']}},_0x379f4b,_0x3cc62b,_0x27f6a3,_0x3e1c87,_0x148d67;_0x10c33e=_['merge']({},_0x10c33e,_0x3707db);return db[_0x04c9('0x28')][_0x04c9('0x48')](_0x10c33e)[_0x04c9('0x20')](function(_0x31f4d3){if(_0x31f4d3){_0x379f4b=_0x31f4d3;return _0x31f4d3[_0x04c9('0x5e')]();}return null;})[_0x04c9('0x20')](function(_0x15f677){if(_0x15f677){if(!_0x15f677[_0x04c9('0x32')]){throw new db[(_0x04c9('0x5f'))][(_0x04c9('0x60'))]('Please\x20insert\x20at\x20least\x20one\x20field',0x193);}_0x3cc62b=_0x15f677;return db['AnalyticMetric'][_0x04c9('0x3d')]({'raw':!![]});}return null;})[_0x04c9('0x20')](function(_0x661022){if(_0x661022){_0x27f6a3=_[_0x04c9('0x86')](_0x661022,'id');var _0x449b80;var _0x157707=squel[_0x04c9('0x63')]();_0x157707['from'](_0x379f4b['table']);for(var _0xc27adf=0x0;_0xc27adf<_0x3cc62b[_0x04c9('0x32')];_0xc27adf+=0x1){_0x449b80=_0x3cc62b[_0xc27adf][_0x04c9('0x65')]?_0x27f6a3[_0x3cc62b[_0xc27adf][_0x04c9('0x65')]]['metric']:_0x3cc62b[_0xc27adf][_0x04c9('0x5d')];_0x449b80=_0x3cc62b[_0xc27adf][_0x04c9('0x87')]?_[_0x04c9('0x66')](_0x5c3062[_0x3cc62b[_0xc27adf][_0x04c9('0x87')]],'%s',_0x449b80):_0x449b80;_0x449b80=_0x3cc62b[_0xc27adf][_0x04c9('0x67')]?_[_0x04c9('0x66')](_0x5907ba[_0x3cc62b[_0xc27adf]['format']],'%s',_0x449b80):_0x449b80;if(_0x3cc62b[_0xc27adf][_0x04c9('0x68')]){_0x157707[_0x04c9('0x5c')](_0x449b80);}_0x3cc62b[_0xc27adf][_0x04c9('0x69')]&&_0x157707[_0x04c9('0x6a')](_0x449b80,_0x3cc62b[_0xc27adf][_0x04c9('0x69')]===_0x04c9('0x6b')?![]:!![]);_0x157707[_0x04c9('0x5d')](_0x449b80,_0x3cc62b[_0xc27adf][_0x04c9('0x6c')]||_0x449b80);}if(_0x379f4b[_0x04c9('0x6d')]){_0x379f4b[_0x04c9('0x6d')]=JSON[_0x04c9('0x6e')](_0x379f4b[_0x04c9('0x6d')]);for(var _0x166ca8=0x0;_0x166ca8<_0x379f4b['joins']['length'];_0x166ca8+=0x1){if(_0x379f4b[_0x04c9('0x6d')][_0x166ca8][_0x04c9('0x2a')]&&_['includes'](_0x3840b3,_0x379f4b['joins'][_0x166ca8]['type'])&&_0x379f4b['joins'][_0x166ca8][_0x04c9('0x6f')]&&_0x379f4b['joins'][_0x166ca8][_0x04c9('0x70')]&&_0x379f4b[_0x04c9('0x6d')][_0x166ca8][_0x04c9('0x72')]){_0x157707[_0x379f4b[_0x04c9('0x6d')][_0x166ca8][_0x04c9('0x2a')]](_0x379f4b[_0x04c9('0x6d')][_0x166ca8][_0x04c9('0x70')],null,util[_0x04c9('0x67')](_0x04c9('0x71'),_0x379f4b[_0x04c9('0x64')],_0x379f4b['joins'][_0x166ca8]['parentKey'],_0x379f4b[_0x04c9('0x6d')][_0x166ca8]['foreignTable'],_0x379f4b[_0x04c9('0x6d')][_0x166ca8]['foreignKey']));}}}if(_0x379f4b[_0x04c9('0x73')]){_0x379f4b[_0x04c9('0x73')]=JSON[_0x04c9('0x6e')](_0x379f4b[_0x04c9('0x73')]);_0x157707['where'](_0x40b929(_0x379f4b[_0x04c9('0x73')][_0x04c9('0x5c')]));}_0x148d67=_0x157707[_0x04c9('0x74')]();_0x157707[_0x04c9('0x1c')](_0x462720);_0x157707[_0x04c9('0x1b')](0x0);logger[_0x04c9('0x88')](_0x04c9('0x75'),_0x157707[_0x04c9('0x76')]());return db[_0x04c9('0x77')][_0x04c9('0x2c')](_0x157707[_0x04c9('0x76')](),{'type':db[_0x04c9('0x77')][_0x04c9('0x89')][_0x04c9('0x78')]});}})[_0x04c9('0x20')](function(_0x387a51){if(!_0x387a51[_0x04c9('0x32')]){throw new db[(_0x04c9('0x5f'))]['ValidationErrorItem']('No\x20available\x20data',0xcc);}if(_0x3be4c7[_0x04c9('0x8a')]==='web'){return null;}var _0x3218b8=_[_0x04c9('0x38')](_0x3be4c7,{'name':_0x3be4c7['fullPath']||_0x3be4c7[_0x04c9('0x26')]||_0x379f4b['name'],'basename':_0x233a9a,'savename':util[_0x04c9('0x67')]('%s-%s.%s',_0x3be4c7['name']||_0x379f4b[_0x04c9('0x26')],require(_0x04c9('0x8b'))[_0x04c9('0x8c')](0x4),_0x3be4c7['output']||_0x04c9('0x8d')),'reportId':_0x379f4b['id'],'reportType':_0x04c9('0x8e')});return db[_0x04c9('0x8f')][_0x04c9('0x43')](_0x3218b8,{'raw':!![]});})[_0x04c9('0x20')](function(_0x5cd73e){if(_0x379f4b[_0x04c9('0x64')]===_0x04c9('0x90')){_0x148d67[_0x04c9('0x37')](_0x379f4b[_0x04c9('0x64')]+'.calldate\x20BETWEEN\x20?\x20AND\x20?',_0x3be4c7['startDate'],_0x3be4c7[_0x04c9('0x91')]);}else{_0x148d67[_0x04c9('0x37')](_0x379f4b[_0x04c9('0x64')]+_0x04c9('0x92'),_0x3be4c7['startDate'],_0x3be4c7[_0x04c9('0x91')]);}if(_0x5cd73e){logger[_0x04c9('0x93')]('Run\x20Query:',_0x148d67[_0x04c9('0x76')]());require('child_process')[_0x04c9('0x94')](path['join'](__dirname,_0x04c9('0x95'),_0x5cd73e['output']),[_0x5cd73e['id'],_0x148d67[_0x04c9('0x76')](),path['join'](__dirname,_0x04c9('0x96'),_0x5cd73e[_0x04c9('0x97')]),_0x233a9a]);return _0x5cd73e;}else{var _0x3f2d8d=squel[_0x04c9('0x63')]();_0x3f2d8d[_0x04c9('0x98')]('('+_0x148d67[_0x04c9('0x76')]()+')',_0x04c9('0x99'));_0x3f2d8d[_0x04c9('0x5d')]('COUNT(*)',_0x04c9('0x3a'));_0x148d67[_0x04c9('0x1c')](_0x3be4c7[_0x04c9('0x1c')]||_0x462720);_0x148d67[_0x04c9('0x1b')](_0x3be4c7[_0x04c9('0x1b')]||0x0);return dbH[_0x04c9('0x77')][_0x04c9('0x2c')](_0x3f2d8d[_0x04c9('0x76')](),{'type':dbH[_0x04c9('0x77')][_0x04c9('0x89')]['SELECT']})[_0x04c9('0x20')](function(_0x43e40b){if(!_0x43e40b[_0x04c9('0x32')]){_0x3e1c87=0x0;}else{_0x3e1c87=_0x43e40b[0x0][_0x04c9('0x3a')]||0x0;}return dbH[_0x04c9('0x77')][_0x04c9('0x2c')](_0x148d67['toString'](),{'type':dbH[_0x04c9('0x77')]['QueryTypes'][_0x04c9('0x78')]});})[_0x04c9('0x20')](function(_0xbc5df5){return{'rows':_0xbc5df5||[],'count':_0x3e1c87};});}});}exports[_0x04c9('0x9a')]=function(_0x27e606,_0x53b98a){return runReport(_0x27e606[_0x04c9('0x40')],_0x27e606[_0x04c9('0x2c')],_0x27e606[_0x04c9('0x41')])[_0x04c9('0x20')](respondWithResult(_0x53b98a,null))[_0x04c9('0x42')](handleError(_0x53b98a,null));};exports[_0x04c9('0x9b')]=runReport;exports[_0x04c9('0x2c')]=function(_0xc191a1,_0x2df95f){var _0x5de507=0xa;var _0x4db27c=[_0x04c9('0x4f'),_0x04c9('0x79'),_0x04c9('0x50'),_0x04c9('0x51')];var _0x33cb57={'SUM':_0x04c9('0x7a'),'COUNT':'COUNT(%s)','COUNT DISTINCT':_0x04c9('0x7c'),'MAX':_0x04c9('0x7d'),'MIN':_0x04c9('0x52'),'AVG':_0x04c9('0x53'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20ASC)','GROUP_CONCAT DESC':_0x04c9('0x55')};var _0xdf422c={'SEC_TO_TIME':_0x04c9('0x56'),'DATE':_0x04c9('0x7f'),'HOUR':_0x04c9('0x80'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0x04c9('0x81')};var _0x4ae5b0=function(_0x2f5864){return!_[_0x04c9('0x58')]([_0x04c9('0x82'),_0x04c9('0x83'),_0x04c9('0x84'),_0x04c9('0x59')],_0x2f5864);};var _0x595822=function(_0x1d79fb){if(!_0x1d79fb||!_0x1d79fb[_0x04c9('0x5a')]['length']){return'';}for(var _0x5b7173='(',_0x2a592d=0x0;_0x2a592d<_0x1d79fb[_0x04c9('0x5a')][_0x04c9('0x32')];_0x2a592d+=0x1){_0x2a592d>0x0&&(_0x5b7173+='\x20'+_0x1d79fb[_0x04c9('0x5b')]+'\x20');_0x5b7173+=_0x1d79fb[_0x04c9('0x5a')][_0x2a592d]['group']?_0x595822(_0x1d79fb[_0x04c9('0x5a')][_0x2a592d][_0x04c9('0x5c')]):_0x1d79fb['rules'][_0x2a592d][_0x04c9('0x5d')]+'\x20'+_0x1d79fb[_0x04c9('0x5a')][_0x2a592d]['condition']+(_0x4ae5b0(_0x1d79fb[_0x04c9('0x5a')][_0x2a592d]['condition'])?'\x20'+_0x1d79fb[_0x04c9('0x5a')][_0x2a592d][_0x04c9('0x9c')]:'');}return _0x5b7173+')';};var _0x21a2f7={'where':{'id':_0xc191a1[_0x04c9('0x40')]['id']}},_0x199b0b,_0x4e88af,_0x356635,_0x467fa3,_0x37fed3;_0x21a2f7=_[_0x04c9('0x38')]({},_0x21a2f7,_0xc191a1[_0x04c9('0x41')]);return db[_0x04c9('0x28')][_0x04c9('0x48')](_0x21a2f7)[_0x04c9('0x20')](function(_0x19eddf){if(_0x19eddf){_0x199b0b=_0x19eddf;return _0x19eddf[_0x04c9('0x5e')]();}return null;})[_0x04c9('0x20')](function(_0x2f0c86){if(_0x2f0c86){if(!_0x2f0c86[_0x04c9('0x32')]){throw new db['Sequelize']['ValidationErrorItem'](_0x04c9('0x61'),0x193);}_0x4e88af=_0x2f0c86;return db[_0x04c9('0x62')][_0x04c9('0x3d')]({'raw':!![]});}return null;})[_0x04c9('0x20')](function(_0x4e1b6f){if(_0x4e1b6f){_0x356635=_['keyBy'](_0x4e1b6f,'id');var _0x303def;var _0x3d38e4=squel[_0x04c9('0x63')]();_0x3d38e4['from'](_0x199b0b[_0x04c9('0x64')]);for(var _0xbd5cd3=0x0;_0xbd5cd3<_0x4e88af[_0x04c9('0x32')];_0xbd5cd3+=0x1){_0x303def=_0x4e88af[_0xbd5cd3][_0x04c9('0x65')]?_0x356635[_0x4e88af[_0xbd5cd3][_0x04c9('0x65')]]['metric']:_0x4e88af[_0xbd5cd3][_0x04c9('0x5d')];_0x303def=_0x4e88af[_0xbd5cd3][_0x04c9('0x87')]?_[_0x04c9('0x66')](_0x33cb57[_0x4e88af[_0xbd5cd3][_0x04c9('0x87')]],'%s',_0x303def):_0x303def;_0x303def=_0x4e88af[_0xbd5cd3][_0x04c9('0x67')]?_[_0x04c9('0x66')](_0xdf422c[_0x4e88af[_0xbd5cd3][_0x04c9('0x67')]],'%s',_0x303def):_0x303def;if(_0x4e88af[_0xbd5cd3][_0x04c9('0x68')]){_0x3d38e4['group'](_0x303def);}_0x4e88af[_0xbd5cd3][_0x04c9('0x69')]&&_0x3d38e4[_0x04c9('0x6a')](_0x303def,_0x4e88af[_0xbd5cd3]['orderBy']==='DESC'?![]:!![]);_0x3d38e4['field'](_0x303def,_0x4e88af[_0xbd5cd3][_0x04c9('0x6c')]||_0x303def);}if(_0x199b0b[_0x04c9('0x6d')]){_0x199b0b['joins']=JSON[_0x04c9('0x6e')](_0x199b0b[_0x04c9('0x6d')]);for(var _0x3910c1=0x0;_0x3910c1<_0x199b0b[_0x04c9('0x6d')][_0x04c9('0x32')];_0x3910c1+=0x1){if(_0x199b0b[_0x04c9('0x6d')][_0x3910c1][_0x04c9('0x2a')]&&_[_0x04c9('0x58')](_0x4db27c,_0x199b0b['joins'][_0x3910c1][_0x04c9('0x2a')])&&_0x199b0b[_0x04c9('0x6d')][_0x3910c1][_0x04c9('0x6f')]&&_0x199b0b[_0x04c9('0x6d')][_0x3910c1][_0x04c9('0x70')]&&_0x199b0b['joins'][_0x3910c1][_0x04c9('0x72')]){_0x3d38e4[_0x199b0b['joins'][_0x3910c1][_0x04c9('0x2a')]](_0x199b0b[_0x04c9('0x6d')][_0x3910c1][_0x04c9('0x70')],null,util[_0x04c9('0x67')]('%s.%s\x20=\x20%s.%s',_0x199b0b[_0x04c9('0x64')],_0x199b0b[_0x04c9('0x6d')][_0x3910c1]['parentKey'],_0x199b0b[_0x04c9('0x6d')][_0x3910c1]['foreignTable'],_0x199b0b[_0x04c9('0x6d')][_0x3910c1]['foreignKey']));}}}if(_0x199b0b[_0x04c9('0x73')]){_0x199b0b[_0x04c9('0x73')]=JSON['parse'](_0x199b0b[_0x04c9('0x73')]);_0x3d38e4['where'](_0x595822(_0x199b0b[_0x04c9('0x73')][_0x04c9('0x5c')]));}_0x37fed3=_0x3d38e4['clone']();_0x3d38e4[_0x04c9('0x1c')](_0x5de507);_0x3d38e4['offset'](0x0);logger['debug'](_0x04c9('0x75'),_0x3d38e4[_0x04c9('0x76')]());return db[_0x04c9('0x77')][_0x04c9('0x2c')](_0x3d38e4[_0x04c9('0x76')](),{'type':db[_0x04c9('0x77')][_0x04c9('0x89')]['SELECT']});}})[_0x04c9('0x20')](function(){return{'sql':_0x37fed3[_0x04c9('0x76')]()};})['then'](respondWithResult(_0x2df95f,null))[_0x04c9('0x42')](handleError(_0x2df95f,null));};
\ No newline at end of file
+var _0x69bf=['table','MetricId','metric','function','replace','format','groupBy','orderBy','DESC','alias','joins','parse','parentKey','foreignTable','%s.%s\x20=\x20%s.%s','foreignKey','conditions','clone','debug','Limited\x20Query:','toString','sequelize','QueryTypes','SUM(%s)','IS\x20NOT\x20NULL','operator','output','web','fullPath','randomstring','generate','csv','custom','cdr','.calldate\x20BETWEEN\x20?\x20AND\x20?','startDate','endDate','.createdAt\x20BETWEEN\x20?\x20AND\x20?','info','Run\x20Query:','child_process','../../files/reports','savename','countTable','COUNT(*)','SELECT','run','runReport','GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)','getFields','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','dbH','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','CustomReports','UserProfileResource','error','stack','name','send','index','map','AnalyticCustomReport','fieldName','key','query','keys','filters','intersection','model','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','options','includeAll','include','findAll','rows','catch','rawAttributes','length','create','user','role','Reports','UserProfileSection','find','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','params','join','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)','SEC_TO_TIME(%s)','DATE(%s)','HOUR(%s)','UNIX_TIMESTAMP(%s)','includes','IS\x20NULL','IS\x20EMPTY','IS\x20NOT\x20EMPTY','rules','group','field','condition','value','Sequelize','ValidationErrorItem','Please\x20insert\x20at\x20least\x20one\x20field','AnalyticMetric','keyBy','select','from'];(function(_0x415637,_0x44cfa4){var _0x39a799=function(_0x535a43){while(--_0x535a43){_0x415637['push'](_0x415637['shift']());}};_0x39a799(++_0x44cfa4);}(_0x69bf,0x188));var _0xf69b=function(_0x122ef9,_0x451d2a){_0x122ef9=_0x122ef9-0x0;var _0x42fba0=_0x69bf[_0x122ef9];return _0x42fba0;};'use strict';var emlformat=require(_0xf69b('0x0'));var rimraf=require(_0xf69b('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xf69b('0x2'));var rp=require(_0xf69b('0x3'));var moment=require(_0xf69b('0x4'));var BPromise=require(_0xf69b('0x5'));var Mustache=require(_0xf69b('0x6'));var util=require(_0xf69b('0x7'));var path=require(_0xf69b('0x8'));var sox=require(_0xf69b('0x9'));var csv=require('to-csv');var ejs=require(_0xf69b('0xa'));var fs=require('fs');var fs_extra=require(_0xf69b('0xb'));var _=require(_0xf69b('0xc'));var squel=require(_0xf69b('0xd'));var crypto=require(_0xf69b('0xe'));var jsforce=require(_0xf69b('0xf'));var deskjs=require(_0xf69b('0x10'));var toCsv=require(_0xf69b('0x11'));var querystring=require(_0xf69b('0x12'));var Papa=require(_0xf69b('0x13'));var Redis=require(_0xf69b('0x14'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xf69b('0x15'));var hardwareService=require(_0xf69b('0x16'));var logger=require('../../config/logger')(_0xf69b('0x17'));var utils=require(_0xf69b('0x18'));var config=require(_0xf69b('0x19'));var licenseUtil=require(_0xf69b('0x1a'));var db=require(_0xf69b('0x1b'))['db'];var dbH=require(_0xf69b('0x1b'))[_0xf69b('0x1c')];function respondWithStatusCode(_0xa07e0d,_0x4f4f32){_0x4f4f32=_0x4f4f32||0xcc;return function(_0x4ecbef){if(_0x4ecbef){return _0xa07e0d['sendStatus'](_0x4f4f32);}return _0xa07e0d[_0xf69b('0x1d')](_0x4f4f32)[_0xf69b('0x1e')]();};}function respondWithResult(_0xef52ff,_0x46a305){_0x46a305=_0x46a305||0xc8;return function(_0x1909d3){if(_0x1909d3){return _0xef52ff[_0xf69b('0x1d')](_0x46a305)[_0xf69b('0x1f')](_0x1909d3);}};}function respondWithFilteredResult(_0x526b22,_0x185c32){return function(_0x73789e){if(_0x73789e){var _0xabab73=typeof _0x185c32[_0xf69b('0x20')]===_0xf69b('0x21')&&typeof _0x185c32[_0xf69b('0x22')]==='undefined';var _0x4e7b6e=_0x73789e[_0xf69b('0x23')];var _0x543533=_0xabab73?0x0:_0x185c32[_0xf69b('0x20')];var _0x64d197=_0xabab73?_0x73789e[_0xf69b('0x23')]:_0x185c32[_0xf69b('0x20')]+_0x185c32[_0xf69b('0x22')];var _0x575e9f;if(_0x64d197>=_0x4e7b6e){_0x64d197=_0x4e7b6e;_0x575e9f=0xc8;}else{_0x575e9f=0xce;}_0x526b22[_0xf69b('0x1d')](_0x575e9f);return _0x526b22[_0xf69b('0x24')](_0xf69b('0x25'),_0x543533+'-'+_0x64d197+'/'+_0x4e7b6e)['json'](_0x73789e);}return null;};}function patchUpdates(_0x313e48){return function(_0x11e973){try{jsonpatch[_0xf69b('0x26')](_0x11e973,_0x313e48,!![]);}catch(_0x23c229){return BPromise[_0xf69b('0x27')](_0x23c229);}return _0x11e973[_0xf69b('0x28')]();};}function saveUpdates(_0x32a871,_0x51480d){return function(_0x529d1b){if(_0x529d1b){return _0x529d1b[_0xf69b('0x29')](_0x32a871)['then'](function(_0x4bea80){return _0x4bea80;});}return null;};}function removeEntity(_0x48d1a2,_0x377f54){return function(_0x52a971){if(_0x52a971){return _0x52a971[_0xf69b('0x2a')]()[_0xf69b('0x2b')](function(){var _0x39ad27=_0x52a971[_0xf69b('0x2c')]({'plain':!![]});var _0x54b07e=_0xf69b('0x2d');return db[_0xf69b('0x2e')]['destroy']({'where':{'type':_0x54b07e,'resourceId':_0x39ad27['id']}})[_0xf69b('0x2b')](function(){return _0x52a971;});})[_0xf69b('0x2b')](function(){_0x48d1a2[_0xf69b('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2baa06,_0x572f65){return function(_0x36fbd8){if(!_0x36fbd8){_0x2baa06['sendStatus'](0x194);}return _0x36fbd8;};}function handleError(_0x3b024f,_0x411e23){_0x411e23=_0x411e23||0x1f4;return function(_0x2471a8){logger[_0xf69b('0x2f')](_0x2471a8[_0xf69b('0x30')]);if(_0x2471a8[_0xf69b('0x31')]){delete _0x2471a8[_0xf69b('0x31')];}_0x3b024f[_0xf69b('0x1d')](_0x411e23)[_0xf69b('0x32')](_0x2471a8);};}exports[_0xf69b('0x33')]=function(_0x3a7668,_0x46ccce){var _0x39f5f9={},_0x3aaf30={},_0x11b92c={'count':0x0,'rows':[]};var _0x47b56d=_[_0xf69b('0x34')](db[_0xf69b('0x35')]['rawAttributes'],function(_0x687335){return{'name':_0x687335[_0xf69b('0x36')],'type':_0x687335['type'][_0xf69b('0x37')]};});_0x3aaf30['model']=_['map'](_0x47b56d,'name');_0x3aaf30[_0xf69b('0x38')]=_[_0xf69b('0x39')](_0x3a7668[_0xf69b('0x38')]);_0x3aaf30[_0xf69b('0x3a')]=_[_0xf69b('0x3b')](_0x3aaf30[_0xf69b('0x3c')],_0x3aaf30[_0xf69b('0x38')]);_0x39f5f9[_0xf69b('0x3d')]=_[_0xf69b('0x3b')](_0x3aaf30['model'],qs[_0xf69b('0x3e')](_0x3a7668[_0xf69b('0x38')][_0xf69b('0x3e')]));_0x39f5f9['attributes']=_0x39f5f9[_0xf69b('0x3d')]['length']?_0x39f5f9['attributes']:_0x3aaf30[_0xf69b('0x3c')];if(!_0x3a7668[_0xf69b('0x38')][_0xf69b('0x3f')](_0xf69b('0x40'))){_0x39f5f9['limit']=qs[_0xf69b('0x22')](_0x3a7668[_0xf69b('0x38')][_0xf69b('0x22')]);_0x39f5f9['offset']=qs[_0xf69b('0x20')](_0x3a7668['query'][_0xf69b('0x20')]);}_0x39f5f9[_0xf69b('0x41')]=qs[_0xf69b('0x42')](_0x3a7668[_0xf69b('0x38')]['sort']);_0x39f5f9[_0xf69b('0x43')]=qs['filters'](_[_0xf69b('0x44')](_0x3a7668[_0xf69b('0x38')],_0x3aaf30['filters']),_0x47b56d);if(_0x3a7668[_0xf69b('0x38')][_0xf69b('0x45')]){_0x39f5f9[_0xf69b('0x43')]=_[_0xf69b('0x46')](_0x39f5f9['where'],{'$or':_[_0xf69b('0x34')](_0x47b56d,function(_0xb39df1){if(_0xb39df1[_0xf69b('0x47')]!=='VIRTUAL'){var _0x27b467={};_0x27b467[_0xb39df1[_0xf69b('0x31')]]={'$like':'%'+_0x3a7668[_0xf69b('0x38')][_0xf69b('0x45')]+'%'};return _0x27b467;}})});}_0x39f5f9=_[_0xf69b('0x46')]({},_0x39f5f9,_0x3a7668[_0xf69b('0x48')]);var _0x491469={'where':_0x39f5f9[_0xf69b('0x43')]};return db[_0xf69b('0x35')][_0xf69b('0x23')](_0x491469)['then'](function(_0x58df70){_0x11b92c['count']=_0x58df70;if(_0x3a7668[_0xf69b('0x38')][_0xf69b('0x49')]){_0x39f5f9[_0xf69b('0x4a')]=[{'all':!![]}];}return db[_0xf69b('0x35')][_0xf69b('0x4b')](_0x39f5f9);})[_0xf69b('0x2b')](function(_0x126a0f){_0x11b92c[_0xf69b('0x4c')]=_0x126a0f;return _0x11b92c;})[_0xf69b('0x2b')](respondWithFilteredResult(_0x46ccce,_0x39f5f9))[_0xf69b('0x4d')](handleError(_0x46ccce,null));};exports['show']=function(_0x2838dc,_0x29bb1d){var _0x53de43={'raw':![],'where':{'id':_0x2838dc['params']['id']}},_0x3fee2e={};_0x3fee2e[_0xf69b('0x3c')]=_['keys'](db['AnalyticCustomReport'][_0xf69b('0x4e')]);_0x3fee2e[_0xf69b('0x38')]=_[_0xf69b('0x39')](_0x2838dc[_0xf69b('0x38')]);_0x3fee2e[_0xf69b('0x3a')]=_[_0xf69b('0x3b')](_0x3fee2e['model'],_0x3fee2e[_0xf69b('0x38')]);_0x53de43[_0xf69b('0x3d')]=_[_0xf69b('0x3b')](_0x3fee2e[_0xf69b('0x3c')],qs[_0xf69b('0x3e')](_0x2838dc[_0xf69b('0x38')]['fields']));_0x53de43[_0xf69b('0x3d')]=_0x53de43['attributes'][_0xf69b('0x4f')]?_0x53de43[_0xf69b('0x3d')]:_0x3fee2e[_0xf69b('0x3c')];if(_0x2838dc[_0xf69b('0x38')]['includeAll']){_0x53de43[_0xf69b('0x4a')]=[{'all':!![]}];}_0x53de43=_[_0xf69b('0x46')]({},_0x53de43,_0x2838dc[_0xf69b('0x48')]);return db[_0xf69b('0x35')]['find'](_0x53de43)[_0xf69b('0x2b')](handleEntityNotFound(_0x29bb1d,null))['then'](respondWithResult(_0x29bb1d,null))[_0xf69b('0x4d')](handleError(_0x29bb1d,null));};exports[_0xf69b('0x50')]=function(_0x2e99cd,_0x3b07d4){return db[_0xf69b('0x35')][_0xf69b('0x50')](_0x2e99cd['body'],{})['then'](function(_0x5e0d8d){var _0xe763c6=_0x2e99cd[_0xf69b('0x51')]['get']({'plain':!![]});if(!_0xe763c6)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0xe763c6[_0xf69b('0x52')]===_0xf69b('0x51')){var _0x32bac3=_0x5e0d8d[_0xf69b('0x2c')]({'plain':!![]});var _0x10cb0a=_0xf69b('0x53');return db[_0xf69b('0x54')][_0xf69b('0x55')]({'where':{'name':_0x10cb0a,'userProfileId':_0xe763c6['userProfileId']},'raw':!![]})[_0xf69b('0x2b')](function(_0xcc77de){if(_0xcc77de&&_0xcc77de[_0xf69b('0x56')]===0x0){return db[_0xf69b('0x2e')][_0xf69b('0x50')]({'name':_0x32bac3[_0xf69b('0x31')],'resourceId':_0x32bac3['id'],'type':_0xf69b('0x2d'),'sectionId':_0xcc77de['id']},{})[_0xf69b('0x2b')](function(){return _0x5e0d8d;});}else{return _0x5e0d8d;}})[_0xf69b('0x4d')](function(_0x5dbdf0){logger[_0xf69b('0x2f')](_0xf69b('0x57'),_0x5dbdf0);throw _0x5dbdf0;});}return _0x5e0d8d;})[_0xf69b('0x2b')](respondWithResult(_0x3b07d4,0xc9))['catch'](handleError(_0x3b07d4,null));};exports[_0xf69b('0x29')]=function(_0x220151,_0x43fb7f){if(_0x220151[_0xf69b('0x58')]['id']){delete _0x220151[_0xf69b('0x58')]['id'];}return db[_0xf69b('0x35')][_0xf69b('0x55')]({'where':{'id':_0x220151[_0xf69b('0x59')]['id']}})[_0xf69b('0x2b')](handleEntityNotFound(_0x43fb7f,null))[_0xf69b('0x2b')](saveUpdates(_0x220151[_0xf69b('0x58')],null))[_0xf69b('0x2b')](respondWithResult(_0x43fb7f,null))[_0xf69b('0x4d')](handleError(_0x43fb7f,null));};exports[_0xf69b('0x2a')]=function(_0x53b7f3,_0x298736){return db[_0xf69b('0x35')][_0xf69b('0x55')]({'where':{'id':_0x53b7f3[_0xf69b('0x59')]['id']}})[_0xf69b('0x2b')](handleEntityNotFound(_0x298736,null))[_0xf69b('0x2b')](removeEntity(_0x298736,null))[_0xf69b('0x4d')](handleError(_0x298736,null));};exports['preview']=function(_0x3125f5,_0x2e0b43){var _0xcea84b=0xa;var _0x832b22=[_0xf69b('0x5a'),_0xf69b('0x5b'),_0xf69b('0x5c'),_0xf69b('0x5d')];var _0x289879={'SUM':'SUM(%s)','COUNT':_0xf69b('0x5e'),'COUNT DISTINCT':_0xf69b('0x5f'),'MAX':_0xf69b('0x60'),'MIN':_0xf69b('0x61'),'AVG':_0xf69b('0x62'),'GROUP_CONCAT':_0xf69b('0x63'),'GROUP_CONCAT ASC':_0xf69b('0x64'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x4d9e5c={'SEC_TO_TIME':_0xf69b('0x65'),'DATE':_0xf69b('0x66'),'HOUR':_0xf69b('0x67'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xf69b('0x68')};var _0x6975d9=function(_0x461413){return!_[_0xf69b('0x69')]([_0xf69b('0x6a'),'IS\x20NOT\x20NULL',_0xf69b('0x6b'),_0xf69b('0x6c')],_0x461413);};var _0x51d2ec=function(_0x411432){if(!_0x411432||!_0x411432[_0xf69b('0x6d')][_0xf69b('0x4f')]){return'';}for(var _0x1a3497='(',_0x103f65=0x0;_0x103f65<_0x411432[_0xf69b('0x6d')][_0xf69b('0x4f')];_0x103f65+=0x1){_0x103f65>0x0&&(_0x1a3497+='\x20'+_0x411432['operator']+'\x20');_0x1a3497+=_0x411432[_0xf69b('0x6d')][_0x103f65][_0xf69b('0x6e')]?_0x51d2ec(_0x411432[_0xf69b('0x6d')][_0x103f65]['group']):_0x411432['rules'][_0x103f65][_0xf69b('0x6f')]+'\x20'+_0x411432[_0xf69b('0x6d')][_0x103f65]['condition']+(_0x6975d9(_0x411432[_0xf69b('0x6d')][_0x103f65][_0xf69b('0x70')])?'\x20'+_0x411432[_0xf69b('0x6d')][_0x103f65][_0xf69b('0x71')]:'');}return _0x1a3497+')';};var _0x11ae47={'where':{'id':_0x3125f5[_0xf69b('0x59')]['id']}},_0x4769c8,_0x147667,_0x17d2ec,_0x5d5f3d,_0x4ff0e7;_0x11ae47=_['merge']({},_0x11ae47,_0x3125f5[_0xf69b('0x48')]);return db[_0xf69b('0x35')]['find'](_0x11ae47)[_0xf69b('0x2b')](function(_0x215118){if(_0x215118){_0x4769c8=_0x215118;return _0x215118['getFields']();}return null;})[_0xf69b('0x2b')](function(_0x506726){if(_0x506726){if(!_0x506726[_0xf69b('0x4f')]){throw new db[(_0xf69b('0x72'))][(_0xf69b('0x73'))](_0xf69b('0x74'),0x193);}_0x147667=_0x506726;return db[_0xf69b('0x75')][_0xf69b('0x4b')]({'raw':!![]});}return null;})[_0xf69b('0x2b')](function(_0x1dddaf){if(_0x1dddaf){_0x17d2ec=_[_0xf69b('0x76')](_0x1dddaf,'id');var _0x498ce9;var _0x16cc04=squel[_0xf69b('0x77')]();_0x16cc04[_0xf69b('0x78')](_0x4769c8[_0xf69b('0x79')]);for(var _0x3a52e7=0x0;_0x3a52e7<_0x147667[_0xf69b('0x4f')];_0x3a52e7+=0x1){_0x498ce9=_0x147667[_0x3a52e7][_0xf69b('0x7a')]?_0x17d2ec[_0x147667[_0x3a52e7][_0xf69b('0x7a')]][_0xf69b('0x7b')]:_0x147667[_0x3a52e7][_0xf69b('0x6f')];_0x498ce9=_0x147667[_0x3a52e7][_0xf69b('0x7c')]?_[_0xf69b('0x7d')](_0x289879[_0x147667[_0x3a52e7]['function']],'%s',_0x498ce9):_0x498ce9;_0x498ce9=_0x147667[_0x3a52e7][_0xf69b('0x7e')]?_[_0xf69b('0x7d')](_0x4d9e5c[_0x147667[_0x3a52e7][_0xf69b('0x7e')]],'%s',_0x498ce9):_0x498ce9;if(_0x147667[_0x3a52e7][_0xf69b('0x7f')]){_0x16cc04[_0xf69b('0x6e')](_0x498ce9);}_0x147667[_0x3a52e7][_0xf69b('0x80')]&&_0x16cc04[_0xf69b('0x41')](_0x498ce9,_0x147667[_0x3a52e7][_0xf69b('0x80')]===_0xf69b('0x81')?![]:!![]);_0x16cc04[_0xf69b('0x6f')](_0x498ce9,_0x147667[_0x3a52e7][_0xf69b('0x82')]||_0x498ce9);}if(_0x4769c8[_0xf69b('0x83')]){_0x4769c8['joins']=JSON[_0xf69b('0x84')](_0x4769c8['joins']);for(var _0x25c223=0x0;_0x25c223<_0x4769c8[_0xf69b('0x83')]['length'];_0x25c223+=0x1){if(_0x4769c8['joins'][_0x25c223]['type']&&_[_0xf69b('0x69')](_0x832b22,_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x47')])&&_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x85')]&&_0x4769c8['joins'][_0x25c223]['foreignTable']&&_0x4769c8['joins'][_0x25c223]['foreignKey']){_0x16cc04[_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x47')]](_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x86')],null,util[_0xf69b('0x7e')](_0xf69b('0x87'),_0x4769c8[_0xf69b('0x79')],_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x85')],_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x86')],_0x4769c8[_0xf69b('0x83')][_0x25c223][_0xf69b('0x88')]));}}}if(_0x4769c8[_0xf69b('0x89')]){_0x4769c8[_0xf69b('0x89')]=JSON[_0xf69b('0x84')](_0x4769c8[_0xf69b('0x89')]);_0x16cc04['where'](_0x51d2ec(_0x4769c8[_0xf69b('0x89')][_0xf69b('0x6e')]));}_0x4ff0e7=_0x16cc04[_0xf69b('0x8a')]();_0x16cc04[_0xf69b('0x22')](_0xcea84b);_0x16cc04[_0xf69b('0x20')](0x0);logger[_0xf69b('0x8b')](_0xf69b('0x8c'),_0x16cc04[_0xf69b('0x8d')]());return dbH[_0xf69b('0x8e')]['query'](_0x16cc04[_0xf69b('0x8d')](),{'type':dbH['sequelize'][_0xf69b('0x8f')]['SELECT']});}})[_0xf69b('0x2b')](respondWithResult(_0x2e0b43,null))[_0xf69b('0x4d')](handleError(_0x2e0b43,null));};function runReport(_0x415097,_0x2fb63e,_0x3aa49c){var _0x1f1127=_0x2fb63e[_0xf69b('0x31')];var _0x382f3d=0xa;var _0x1552cd=['join',_0xf69b('0x5b'),'right_join','cross_join'];var _0x5e2088={'SUM':_0xf69b('0x90'),'COUNT':_0xf69b('0x5e'),'COUNT DISTINCT':_0xf69b('0x5f'),'MAX':_0xf69b('0x60'),'MIN':_0xf69b('0x61'),'AVG':'AVG(%s)','GROUP_CONCAT':_0xf69b('0x63'),'GROUP_CONCAT ASC':_0xf69b('0x64'),'GROUP_CONCAT DESC':'GROUP_CONCAT(%s\x20ORDER\x20BY\x20%s\x20DESC)'};var _0x440586={'SEC_TO_TIME':_0xf69b('0x65'),'DATE':_0xf69b('0x66'),'HOUR':'HOUR(%s)','ROUND':'ROUND(%s)','UNIX_TIMESTAMP':_0xf69b('0x68')};var _0x21f85e=function(_0x1f8b32){return!_[_0xf69b('0x69')]([_0xf69b('0x6a'),_0xf69b('0x91'),_0xf69b('0x6b'),_0xf69b('0x6c')],_0x1f8b32);};var _0x486990=function(_0x475fb0){if(!_0x475fb0||!_0x475fb0[_0xf69b('0x6d')]['length']){return'';}for(var _0x100668='(',_0x1b297f=0x0;_0x1b297f<_0x475fb0[_0xf69b('0x6d')]['length'];_0x1b297f+=0x1){_0x1b297f>0x0&&(_0x100668+='\x20'+_0x475fb0[_0xf69b('0x92')]+'\x20');_0x100668+=_0x475fb0['rules'][_0x1b297f][_0xf69b('0x6e')]?_0x486990(_0x475fb0[_0xf69b('0x6d')][_0x1b297f]['group']):_0x475fb0['rules'][_0x1b297f][_0xf69b('0x6f')]+'\x20'+_0x475fb0[_0xf69b('0x6d')][_0x1b297f]['condition']+(_0x21f85e(_0x475fb0[_0xf69b('0x6d')][_0x1b297f]['condition'])?'\x20'+_0x475fb0[_0xf69b('0x6d')][_0x1b297f][_0xf69b('0x71')]:'');}return _0x100668+')';};var _0x4ae3a8={'where':{'id':_0x415097['id']}},_0x2e318e,_0x5a5f86,_0x59be68,_0x9ab2bf,_0x110832;_0x4ae3a8=_[_0xf69b('0x46')]({},_0x4ae3a8,_0x3aa49c);return db[_0xf69b('0x35')][_0xf69b('0x55')](_0x4ae3a8)[_0xf69b('0x2b')](function(_0x4328a8){if(_0x4328a8){_0x2e318e=_0x4328a8;return _0x4328a8['getFields']();}return null;})[_0xf69b('0x2b')](function(_0xa7e312){if(_0xa7e312){if(!_0xa7e312['length']){throw new db[(_0xf69b('0x72'))]['ValidationErrorItem'](_0xf69b('0x74'),0x193);}_0x5a5f86=_0xa7e312;return db[_0xf69b('0x75')][_0xf69b('0x4b')]({'raw':!![]});}return null;})[_0xf69b('0x2b')](function(_0x3710f1){if(_0x3710f1){_0x59be68=_[_0xf69b('0x76')](_0x3710f1,'id');var _0x50b836;var _0x147ba2=squel[_0xf69b('0x77')]();_0x147ba2[_0xf69b('0x78')](_0x2e318e[_0xf69b('0x79')]);for(var _0x3529a3=0x0;_0x3529a3<_0x5a5f86['length'];_0x3529a3+=0x1){_0x50b836=_0x5a5f86[_0x3529a3][_0xf69b('0x7a')]?_0x59be68[_0x5a5f86[_0x3529a3]['MetricId']]['metric']:_0x5a5f86[_0x3529a3][_0xf69b('0x6f')];_0x50b836=_0x5a5f86[_0x3529a3][_0xf69b('0x7c')]?_[_0xf69b('0x7d')](_0x5e2088[_0x5a5f86[_0x3529a3][_0xf69b('0x7c')]],'%s',_0x50b836):_0x50b836;_0x50b836=_0x5a5f86[_0x3529a3]['format']?_[_0xf69b('0x7d')](_0x440586[_0x5a5f86[_0x3529a3][_0xf69b('0x7e')]],'%s',_0x50b836):_0x50b836;if(_0x5a5f86[_0x3529a3][_0xf69b('0x7f')]){_0x147ba2[_0xf69b('0x6e')](_0x50b836);}_0x5a5f86[_0x3529a3]['orderBy']&&_0x147ba2[_0xf69b('0x41')](_0x50b836,_0x5a5f86[_0x3529a3][_0xf69b('0x80')]==='DESC'?![]:!![]);_0x147ba2[_0xf69b('0x6f')](_0x50b836,_0x5a5f86[_0x3529a3][_0xf69b('0x82')]||_0x50b836);}if(_0x2e318e[_0xf69b('0x83')]){_0x2e318e[_0xf69b('0x83')]=JSON['parse'](_0x2e318e[_0xf69b('0x83')]);for(var _0x3f4843=0x0;_0x3f4843<_0x2e318e[_0xf69b('0x83')][_0xf69b('0x4f')];_0x3f4843+=0x1){if(_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x47')]&&_[_0xf69b('0x69')](_0x1552cd,_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x47')])&&_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x85')]&&_0x2e318e['joins'][_0x3f4843][_0xf69b('0x86')]&&_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x88')]){_0x147ba2[_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x47')]](_0x2e318e[_0xf69b('0x83')][_0x3f4843]['foreignTable'],null,util[_0xf69b('0x7e')]('%s.%s\x20=\x20%s.%s',_0x2e318e[_0xf69b('0x79')],_0x2e318e[_0xf69b('0x83')][_0x3f4843]['parentKey'],_0x2e318e['joins'][_0x3f4843]['foreignTable'],_0x2e318e[_0xf69b('0x83')][_0x3f4843][_0xf69b('0x88')]));}}}if(_0x2e318e[_0xf69b('0x89')]){_0x2e318e[_0xf69b('0x89')]=JSON[_0xf69b('0x84')](_0x2e318e['conditions']);_0x147ba2['where'](_0x486990(_0x2e318e[_0xf69b('0x89')][_0xf69b('0x6e')]));}_0x110832=_0x147ba2[_0xf69b('0x8a')]();_0x147ba2['limit'](_0x382f3d);_0x147ba2[_0xf69b('0x20')](0x0);return;}})[_0xf69b('0x2b')](function(){if(_0x2fb63e[_0xf69b('0x93')]===_0xf69b('0x94')){return null;}var _0x4c2d9f=_[_0xf69b('0x46')](_0x2fb63e,{'name':_0x2fb63e[_0xf69b('0x95')]||_0x2fb63e[_0xf69b('0x31')]||_0x2e318e[_0xf69b('0x31')],'basename':_0x1f1127,'savename':util[_0xf69b('0x7e')]('%s-%s.%s',_0x2fb63e[_0xf69b('0x31')]||_0x2e318e[_0xf69b('0x31')],require(_0xf69b('0x96'))[_0xf69b('0x97')](0x4),_0x2fb63e['output']||_0xf69b('0x98')),'reportId':_0x2e318e['id'],'reportType':_0xf69b('0x99')});return db['AnalyticExtractedReport']['create'](_0x4c2d9f,{'raw':!![]});})['then'](function(_0x22c8ed){if(_0x2e318e[_0xf69b('0x79')]===_0xf69b('0x9a')){_0x110832[_0xf69b('0x43')](_0x2e318e['table']+_0xf69b('0x9b'),_0x2fb63e[_0xf69b('0x9c')],_0x2fb63e[_0xf69b('0x9d')]);}else{_0x110832['where'](_0x2e318e['table']+_0xf69b('0x9e'),_0x2fb63e[_0xf69b('0x9c')],_0x2fb63e[_0xf69b('0x9d')]);}if(_0x22c8ed){logger[_0xf69b('0x9f')](_0xf69b('0xa0'),_0x110832[_0xf69b('0x8d')]());require(_0xf69b('0xa1'))['fork'](path[_0xf69b('0x5a')](__dirname,'../../components/export/',_0x22c8ed[_0xf69b('0x93')]),[_0x22c8ed['id'],_0x110832[_0xf69b('0x8d')](),path[_0xf69b('0x5a')](__dirname,_0xf69b('0xa2'),_0x22c8ed[_0xf69b('0xa3')]),_0x1f1127]);return _0x22c8ed;}else{var _0x1921e4=squel[_0xf69b('0x77')]();_0x1921e4[_0xf69b('0x78')]('('+_0x110832[_0xf69b('0x8d')]()+')',_0xf69b('0xa4'));_0x1921e4[_0xf69b('0x6f')](_0xf69b('0xa5'),_0xf69b('0x23'));_0x110832[_0xf69b('0x22')](_0x2fb63e[_0xf69b('0x22')]||_0x382f3d);_0x110832[_0xf69b('0x20')](_0x2fb63e['offset']||0x0);return dbH[_0xf69b('0x8e')][_0xf69b('0x38')](_0x1921e4['toString'](),{'type':dbH[_0xf69b('0x8e')][_0xf69b('0x8f')][_0xf69b('0xa6')]})[_0xf69b('0x2b')](function(_0x126715){if(!_0x126715['length']){_0x9ab2bf=0x0;}else{_0x9ab2bf=_0x126715[0x0][_0xf69b('0x23')]||0x0;}return dbH[_0xf69b('0x8e')]['query'](_0x110832['toString'](),{'type':dbH[_0xf69b('0x8e')][_0xf69b('0x8f')]['SELECT']});})['then'](function(_0x5bf69b){return{'rows':_0x5bf69b||[],'count':_0x9ab2bf};});}});}exports[_0xf69b('0xa7')]=function(_0x409d88,_0xe7815d){return runReport(_0x409d88[_0xf69b('0x59')],_0x409d88[_0xf69b('0x38')],_0x409d88[_0xf69b('0x48')])[_0xf69b('0x2b')](respondWithResult(_0xe7815d,null))[_0xf69b('0x4d')](handleError(_0xe7815d,null));};exports[_0xf69b('0xa8')]=runReport;exports[_0xf69b('0x38')]=function(_0x37dde2,_0x51f52e){var _0x45b635=0xa;var _0x14caea=[_0xf69b('0x5a'),_0xf69b('0x5b'),_0xf69b('0x5c'),_0xf69b('0x5d')];var _0x274b30={'SUM':_0xf69b('0x90'),'COUNT':_0xf69b('0x5e'),'COUNT DISTINCT':_0xf69b('0x5f'),'MAX':'MAX(%s)','MIN':_0xf69b('0x61'),'AVG':_0xf69b('0x62'),'GROUP_CONCAT':'GROUP_CONCAT(%s)','GROUP_CONCAT ASC':_0xf69b('0x64'),'GROUP_CONCAT DESC':_0xf69b('0xa9')};var _0x470d85={'SEC_TO_TIME':'SEC_TO_TIME(%s)','DATE':'DATE(%s)','HOUR':_0xf69b('0x67'),'ROUND':'ROUND(%s)','UNIX_TIMESTAMP':'UNIX_TIMESTAMP(%s)'};var _0x309b60=function(_0x10444b){return!_['includes']([_0xf69b('0x6a'),_0xf69b('0x91'),_0xf69b('0x6b'),_0xf69b('0x6c')],_0x10444b);};var _0x118c61=function(_0x2f3383){if(!_0x2f3383||!_0x2f3383[_0xf69b('0x6d')]['length']){return'';}for(var _0x1b0c9d='(',_0x4df84c=0x0;_0x4df84c<_0x2f3383[_0xf69b('0x6d')][_0xf69b('0x4f')];_0x4df84c+=0x1){_0x4df84c>0x0&&(_0x1b0c9d+='\x20'+_0x2f3383[_0xf69b('0x92')]+'\x20');_0x1b0c9d+=_0x2f3383[_0xf69b('0x6d')][_0x4df84c][_0xf69b('0x6e')]?_0x118c61(_0x2f3383[_0xf69b('0x6d')][_0x4df84c][_0xf69b('0x6e')]):_0x2f3383[_0xf69b('0x6d')][_0x4df84c][_0xf69b('0x6f')]+'\x20'+_0x2f3383[_0xf69b('0x6d')][_0x4df84c][_0xf69b('0x70')]+(_0x309b60(_0x2f3383[_0xf69b('0x6d')][_0x4df84c]['condition'])?'\x20'+_0x2f3383[_0xf69b('0x6d')][_0x4df84c]['value']:'');}return _0x1b0c9d+')';};var _0x416f45={'where':{'id':_0x37dde2[_0xf69b('0x59')]['id']}},_0x98bd8b,_0x83ec48,_0x37228b,_0x4c06e2,_0x525024;_0x416f45=_[_0xf69b('0x46')]({},_0x416f45,_0x37dde2[_0xf69b('0x48')]);return db[_0xf69b('0x35')][_0xf69b('0x55')](_0x416f45)['then'](function(_0x50e9ef){if(_0x50e9ef){_0x98bd8b=_0x50e9ef;return _0x50e9ef[_0xf69b('0xaa')]();}return null;})[_0xf69b('0x2b')](function(_0x322acb){if(_0x322acb){if(!_0x322acb[_0xf69b('0x4f')]){throw new db[(_0xf69b('0x72'))][(_0xf69b('0x73'))](_0xf69b('0x74'),0x193);}_0x83ec48=_0x322acb;return db[_0xf69b('0x75')][_0xf69b('0x4b')]({'raw':!![]});}return null;})[_0xf69b('0x2b')](function(_0x53b501){if(_0x53b501){_0x37228b=_[_0xf69b('0x76')](_0x53b501,'id');var _0x2e7e82;var _0x47824c=squel[_0xf69b('0x77')]();_0x47824c[_0xf69b('0x78')](_0x98bd8b[_0xf69b('0x79')]);for(var _0x1343d4=0x0;_0x1343d4<_0x83ec48[_0xf69b('0x4f')];_0x1343d4+=0x1){_0x2e7e82=_0x83ec48[_0x1343d4][_0xf69b('0x7a')]?_0x37228b[_0x83ec48[_0x1343d4]['MetricId']]['metric']:_0x83ec48[_0x1343d4][_0xf69b('0x6f')];_0x2e7e82=_0x83ec48[_0x1343d4][_0xf69b('0x7c')]?_[_0xf69b('0x7d')](_0x274b30[_0x83ec48[_0x1343d4][_0xf69b('0x7c')]],'%s',_0x2e7e82):_0x2e7e82;_0x2e7e82=_0x83ec48[_0x1343d4][_0xf69b('0x7e')]?_['replace'](_0x470d85[_0x83ec48[_0x1343d4][_0xf69b('0x7e')]],'%s',_0x2e7e82):_0x2e7e82;if(_0x83ec48[_0x1343d4][_0xf69b('0x7f')]){_0x47824c['group'](_0x2e7e82);}_0x83ec48[_0x1343d4]['orderBy']&&_0x47824c[_0xf69b('0x41')](_0x2e7e82,_0x83ec48[_0x1343d4][_0xf69b('0x80')]==='DESC'?![]:!![]);_0x47824c[_0xf69b('0x6f')](_0x2e7e82,_0x83ec48[_0x1343d4][_0xf69b('0x82')]||_0x2e7e82);}if(_0x98bd8b[_0xf69b('0x83')]){_0x98bd8b[_0xf69b('0x83')]=JSON[_0xf69b('0x84')](_0x98bd8b[_0xf69b('0x83')]);for(var _0x1c9e0c=0x0;_0x1c9e0c<_0x98bd8b[_0xf69b('0x83')]['length'];_0x1c9e0c+=0x1){if(_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x47')]&&_[_0xf69b('0x69')](_0x14caea,_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x47')])&&_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x85')]&&_0x98bd8b['joins'][_0x1c9e0c][_0xf69b('0x86')]&&_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x88')]){_0x47824c[_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x47')]](_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x86')],null,util[_0xf69b('0x7e')](_0xf69b('0x87'),_0x98bd8b[_0xf69b('0x79')],_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x85')],_0x98bd8b['joins'][_0x1c9e0c][_0xf69b('0x86')],_0x98bd8b[_0xf69b('0x83')][_0x1c9e0c][_0xf69b('0x88')]));}}}if(_0x98bd8b[_0xf69b('0x89')]){_0x98bd8b[_0xf69b('0x89')]=JSON[_0xf69b('0x84')](_0x98bd8b[_0xf69b('0x89')]);_0x47824c[_0xf69b('0x43')](_0x118c61(_0x98bd8b[_0xf69b('0x89')][_0xf69b('0x6e')]));}_0x525024=_0x47824c[_0xf69b('0x8a')]();_0x47824c[_0xf69b('0x22')](_0x45b635);_0x47824c[_0xf69b('0x20')](0x0);logger[_0xf69b('0x8b')](_0xf69b('0x8c'),_0x47824c[_0xf69b('0x8d')]());return dbH[_0xf69b('0x8e')][_0xf69b('0x38')](_0x47824c['toString'](),{'type':dbH['sequelize']['QueryTypes']['SELECT']});}})[_0xf69b('0x2b')](function(){return{'sql':_0x525024[_0xf69b('0x8d')]()};})['then'](respondWithResult(_0x51f52e,null))[_0xf69b('0x4d')](handleError(_0x51f52e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff